Index: branches/b_4_14_00_00/Database/UpgradeScripts/Upgrade_v.4.13.00.00_to_v.4.14.00.00.sql =================================================================== diff -u -r256408 -r256409 --- branches/b_4_14_00_00/Database/UpgradeScripts/Upgrade_v.4.13.00.00_to_v.4.14.00.00.sql (.../Upgrade_v.4.13.00.00_to_v.4.14.00.00.sql) (revision 256408) +++ branches/b_4_14_00_00/Database/UpgradeScripts/Upgrade_v.4.13.00.00_to_v.4.14.00.00.sql (.../Upgrade_v.4.13.00.00_to_v.4.14.00.00.sql) (revision 256409) @@ -26,7 +26,7 @@ SET v_last_rev = 'v.4.13.00.00'; SET v_this_rev = 'v.4.14.00.00'; SET v_rev_date = '2024-06-26'; -SET v_rev_note = 'This release implements change(s) SPP-196, SPP-245, SPP-201, SPP-200'; +SET v_rev_note = 'This release implements change(s) SPP-196, SPP-245, SPP-201, SPP-200, EOD-192'; SET b_upgrade = 1; SET i_script_type = 1; @@ -281,7 +281,22 @@ -- End SPP-200 +-- Begin EOD-192 +IF EXISTS (SELECT * FROM systable st JOIN syscolumn sc ON sc.table_id = st.table_id + WHERE table_name = 'VENDOR' AND column_name = 'EXPORT_ORDER_AS_CSV') THEN + ALTER TABLE VENDOR MODIFY EXPORT_ORDER_AS_CSV TINYINT DEFAULT 0 + CHECK (EXPORT_ORDER_AS_CSV IN (0, 1, 10, 11)); +ELSE + ALTER TABLE VENDOR ADD EXPORT_ORDER_AS_CSV TINYINT DEFAULT 0 + CHECK (EXPORT_ORDER_AS_CSV IN (0, 1, 10, 11)); +END IF; +ALTER TABLE VENDOR MODIFY EXPORT_ORDER_AS_CSV NOT NULL; +COMMENT ON COLUMN VENDOR.EXPORT_ORDER_AS_CSV IS '0=No; 1=Yes; 10=Locked No; 11=Locked Yes'; + +-- End EOD-192 + + MESSAGE '30% done...' TO CLIENT; IF i_script_type = 1 THEN UPDATE db_release SET notes = SUBSTRING(notes, 1, CHARINDEX('%', notes) - 3) || '30% done.' WHERE release_num = 'NOLOG';