core-jgi/migration/i7.1z/oracle/202008061811_IDEMPIERE-4398...

50 lines
1.4 KiB
SQL

SET SQLBLANKLINES ON
SET DEFINE OFF
-- IDEMPIERE-4398 Database inconsistency with dictionary for types CHAR
-- Aug 6, 2020, 6:04:11 PM CEST
ALTER TABLE AD_OrgInfo MODIFY DUNS VARCHAR2(11 CHAR)
;
-- Aug 6, 2020, 6:04:51 PM CEST
ALTER TABLE C_BPartner MODIFY DUNS VARCHAR2(11 CHAR) DEFAULT NULL
;
-- Aug 6, 2020, 6:05:10 PM CEST
ALTER TABLE C_BPartner MODIFY NAICS VARCHAR2(6 CHAR) DEFAULT NULL
;
-- Aug 6, 2020, 6:07:03 PM CEST
ALTER TABLE GL_JournalGenerator MODIFY GenerateGLJournal VARCHAR2(10) DEFAULT NULL
;
-- Aug 6, 2020, 6:07:58 PM CEST
UPDATE AD_Column SET FieldLength=1,Updated=TO_DATE('2020-08-06 18:07:58','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=200509
;
UPDATE gl_journalgenerator SET generategljournal=trim(generategljournal);
-- Aug 6, 2020, 6:08:00 PM CEST
ALTER TABLE GL_JournalGenerator MODIFY GenerateGLJournal CHAR(1) DEFAULT NULL
;
-- Aug 6, 2020, 6:08:38 PM CEST
ALTER TABLE I_BPartner MODIFY DUNS VARCHAR2(11 CHAR) DEFAULT NULL
;
-- Aug 6, 2020, 6:08:50 PM CEST
ALTER TABLE I_BPartner MODIFY NAICS VARCHAR2(6 CHAR) DEFAULT NULL
;
-- Aug 6, 2020, 6:09:14 PM CEST
ALTER TABLE M_Product_PO MODIFY Manufacturer VARCHAR2(30 CHAR) DEFAULT NULL
;
-- Aug 6, 2020, 6:09:31 PM CEST
ALTER TABLE M_Product_PO MODIFY VendorCategory VARCHAR2(30 CHAR) DEFAULT NULL
;
SELECT register_migration_script('202008061811_IDEMPIERE-4398.sql') FROM dual
;