--UPDATE FROM 8.8.1.1 TO 8.8.1.2


DROP TABLE VERSION_8_8_1_1;



/*  VERSION_8_8_1_2  */
CREATE TABLE VERSION_8_8_1_2 (
	 DUMMY	NUMBER	    NULL
)
;


ALTER TABLE YETM ADD YETM_CHARGEDONCONSUMPTION NUMBER(1);

COMMENT ON COLUMN YETM.YETM_CHARGEDONCONSUMPTION IS 'Charged on consumption';

COMMENT ON COLUMN YHKS.YHKS_CLEAN IS ' 1 = Clean  0 = Dirty';

ALTER TABLE MCFG ADD MCFG_MLOG_PURGE_DAYS NUMBER(2,0);

COMMENT ON COLUMN MCFG.MCFG_MLOG_PURGE_DAYS IS 'number of days to purge mlog';

COMMENT ON COLUMN WRPP.WRPP_TYPE IS ' 0 = string  1 = integer  2 = date  3 = time  4 = Date type  5 = Combo Box  6 = Multi Select Box  7 = Boolean';

COMMENT ON COLUMN WSCT.WSCT_ROLE IS '1 Folio supplement, 2 Email Body Default, 3 City Ledger invoice supplement';
