/**新增标签分组字段 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_LABELGROUP' AND KSQL_COL_NAME ='FLONGNUMBER')
 ALTER TABLE T_HRCS_LABELGROUP ADD (FLONGNUMBER VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_LABELGROUP' AND KSQL_COL_NAME ='FFULLNAME')
 ALTER TABLE T_HRCS_LABELGROUP ADD (FFULLNAME NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_LABELGROUP' AND KSQL_COL_NAME ='FSIMPLENAME')
 ALTER TABLE T_HRCS_LABELGROUP ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_LABELGROUP' AND KSQL_COL_NAME ='FDISABLERID')
 ALTER TABLE T_HRCS_LABELGROUP ADD (FDISABLERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_LABELGROUP' AND KSQL_COL_NAME ='FDISABLEDATE')
 ALTER TABLE T_HRCS_LABELGROUP ADD (FDISABLEDATE DATETIME );
/**新增标签分组多语言字段 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_LABELGROUP_L' AND KSQL_COL_NAME ='FFULLNAME')
 ALTER TABLE T_HRCS_LABELGROUP_L ADD (FFULLNAME NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_LABELGROUP_L' AND KSQL_COL_NAME ='FSIMPLENAME')
 ALTER TABLE T_HRCS_LABELGROUP_L ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
