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;

沒有留言:

張貼留言