IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_WEEKROLLENTA' AND KSQL_COL_NAME ='FENTRYCREATOR')
ALTER TABLE T_MDS_WEEKROLLENTA ADD (FENTRYCREATOR BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_WEEKROLLENTA' AND KSQL_COL_NAME ='FENTRYCREATEDATE')
ALTER TABLE T_MDS_WEEKROLLENTA ADD (FENTRYCREATEDATE DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_WEEKROLLENTA' AND KSQL_COL_NAME ='FENTRYMODIFIER')
ALTER TABLE T_MDS_WEEKROLLENTA ADD (FENTRYMODIFIER BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_WEEKROLLENTA' AND KSQL_COL_NAME ='FENTRYMODIFYDATE')
ALTER TABLE T_MDS_WEEKROLLENTA ADD (FENTRYMODIFYDATE DATETIME ); 


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_WEEKROLLENTB' AND KSQL_COL_NAME ='FENTRYCREATOR')
ALTER TABLE T_MDS_WEEKROLLENTB ADD (FENTRYCREATOR BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_WEEKROLLENTB' AND KSQL_COL_NAME ='FENTRYCREATEDATE')
ALTER TABLE T_MDS_WEEKROLLENTB ADD (FENTRYCREATEDATE DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_WEEKROLLENTB' AND KSQL_COL_NAME ='FENTRYMODIFIER')
ALTER TABLE T_MDS_WEEKROLLENTB ADD (FENTRYMODIFIER BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_WEEKROLLENTB' AND KSQL_COL_NAME ='FENTRYMODIFYDATE')
ALTER TABLE T_MDS_WEEKROLLENTB ADD (FENTRYMODIFYDATE DATETIME ); 

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_SETOFFSETENTS' AND KSQL_COL_NAME ='FENTRYCREATOR')
ALTER TABLE T_MDS_SETOFFSETENTS ADD (FENTRYCREATOR BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_SETOFFSETENTS' AND KSQL_COL_NAME ='FENTRYCREATEDATE')
ALTER TABLE T_MDS_SETOFFSETENTS ADD (FENTRYCREATEDATE DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_SETOFFSETENTS' AND KSQL_COL_NAME ='FENTRYMODIFIER')
ALTER TABLE T_MDS_SETOFFSETENTS ADD (FENTRYMODIFIER BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_SETOFFSETENTS' AND KSQL_COL_NAME ='FENTRYMODIFYDATE')
ALTER TABLE T_MDS_SETOFFSETENTS ADD (FENTRYMODIFYDATE DATETIME ); 

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_SETOFFSETENTG' AND KSQL_COL_NAME ='FENTRYCREATOR')
ALTER TABLE T_MDS_SETOFFSETENTG ADD (FENTRYCREATOR BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_SETOFFSETENTG' AND KSQL_COL_NAME ='FENTRYCREATEDATE')
ALTER TABLE T_MDS_SETOFFSETENTG ADD (FENTRYCREATEDATE DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_SETOFFSETENTG' AND KSQL_COL_NAME ='FENTRYMODIFIER')
ALTER TABLE T_MDS_SETOFFSETENTG ADD (FENTRYMODIFIER BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_SETOFFSETENTG' AND KSQL_COL_NAME ='FENTRYMODIFYDATE')
ALTER TABLE T_MDS_SETOFFSETENTG ADD (FENTRYMODIFYDATE DATETIME ); 


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_SETOFFTOOLENTRY' AND KSQL_COL_NAME ='FENTRYCREATOR')
ALTER TABLE T_MDS_SETOFFTOOLENTRY ADD (FENTRYCREATOR BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_SETOFFTOOLENTRY' AND KSQL_COL_NAME ='FENTRYCREATEDATE')
ALTER TABLE T_MDS_SETOFFTOOLENTRY ADD (FENTRYCREATEDATE DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_SETOFFTOOLENTRY' AND KSQL_COL_NAME ='FENTRYMODIFIER')
ALTER TABLE T_MDS_SETOFFTOOLENTRY ADD (FENTRYMODIFIER BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_SETOFFTOOLENTRY' AND KSQL_COL_NAME ='FENTRYMODIFYDATE')
ALTER TABLE T_MDS_SETOFFTOOLENTRY ADD (FENTRYMODIFYDATE DATETIME ); 


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_FCCORLENTRY' AND KSQL_COL_NAME ='FENTRYCREATOR')
ALTER TABLE T_MDS_FCCORLENTRY ADD (FENTRYCREATOR BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_FCCORLENTRY' AND KSQL_COL_NAME ='FENTRYCREATEDATE')
ALTER TABLE T_MDS_FCCORLENTRY ADD (FENTRYCREATEDATE DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_FCCORLENTRY' AND KSQL_COL_NAME ='FENTRYMODIFIER')
ALTER TABLE T_MDS_FCCORLENTRY ADD (FENTRYMODIFIER BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_FCCORLENTRY' AND KSQL_COL_NAME ='FENTRYMODIFYDATE')
ALTER TABLE T_MDS_FCCORLENTRY ADD (FENTRYMODIFYDATE DATETIME ); 


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_QUOTAINFO' AND KSQL_COL_NAME ='FENTRYCREATOR')
ALTER TABLE T_MDS_QUOTAINFO ADD (FENTRYCREATOR BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_QUOTAINFO' AND KSQL_COL_NAME ='FENTRYCREATEDATE')
ALTER TABLE T_MDS_QUOTAINFO ADD (FENTRYCREATEDATE DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_QUOTAINFO' AND KSQL_COL_NAME ='FENTRYMODIFIER')
ALTER TABLE T_MDS_QUOTAINFO ADD (FENTRYMODIFIER BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_QUOTAINFO' AND KSQL_COL_NAME ='FENTRYMODIFYDATE')
ALTER TABLE T_MDS_QUOTAINFO ADD (FENTRYMODIFYDATE DATETIME ); 