/* 初始化系统内置主题  */
/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\BOS_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BAS_UITHEME' AND KSQL_COL_NAME ='FISPRESET') 
 ALTER TABLE T_BAS_UITHEME ADD (FISPRESET CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BAS_UITHEME' AND KSQL_COL_NAME ='FENABLE') 
 ALTER TABLE T_BAS_UITHEME ADD (FENABLE CHAR(1) DEFAULT '1' NOT NULL );
update T_BAS_UITheme set FISPRESET='1';
update T_BAS_UITheme set fcontent='{
    "theme": {
        "@theme-color": "#FC8555"
    }
}' where fnumber='orange';
update T_BAS_UITheme set fcontent='{
    "theme": {
        "@theme-color": "#5582F3"
    }
}' where fnumber='blue';
update T_BAS_UITheme set fcontent='{
    "theme": {
        "@theme-color": "#6869FB"
    }
}' where fnumber='purple';
update T_BAS_UITheme set fcontent='{
    "theme": {
        "@theme-color": "#29C392"
    }
}' where fnumber='green';
update T_BAS_UITheme set fcontent='{
    "theme": {
        "@theme-color": "#E94E4F"
    }
}' where fnumber='red';
/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\BOS_table.sql **/
