2014年6月5日 星期四
iDempiere 2014 May 5 Daily 開發測試版 , 這個錯誤無法新增中文翻譯檔
CONSTRAINT ad_printformat_trl_key PRIMARY KEY (ad_printformat_id)
這個錯誤無法新增中文翻譯檔
先移除
再修正為 ad_printformat_id + ad_language 為主鍵
ALTER TABLE adempiere.ad_printformat_trl
--DROP CONSTRAINT ad_printformat_trl_key
ADD CONSTRAINT ad_printformat_trl_key PRIMARY KEY (ad_printformat_id,ad_language )
CREATE TABLE adempiere.ad_printformat_trl
(
ad_printformat_id numeric(10,0) NOT NULL DEFAULT 0,
ad_language character varying(6) NOT NULL,
ad_client_id numeric(10,0) NOT NULL,
ad_org_id numeric(10,0) NOT NULL,
isactive character(1) NOT NULL DEFAULT 'Y'::bpchar,
created timestamp without time zone NOT NULL DEFAULT statement_timestamp(),
createdby numeric(10,0) NOT NULL,
updated timestamp without time zone NOT NULL DEFAULT statement_timestamp(),
updatedby numeric(10,0) NOT NULL,
name character varying(60) NOT NULL,
description character varying(255) DEFAULT NULL::character varying,
istranslated character(1) NOT NULL,
ad_printformat_trl_uu character varying(36) DEFAULT NULL::character varying,
CONSTRAINT ad_printformat_trl_key PRIMARY KEY (ad_printformat_id),
CONSTRAINT ad_printformat_trl_uu_idx UNIQUE (ad_printformat_trl_uu),
CONSTRAINT ad_printformat_trl_isactive_check CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])),
CONSTRAINT ad_printformat_trl_istranslated_check CHECK (istranslated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
)
WITH (
OIDS=FALSE
);
ALTER TABLE adempiere.ad_printformat_trl
OWNER TO adempiere;
訂閱:
張貼留言 (Atom)
沒有留言:
張貼留言