/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\BOS_table.sql **/
/**  EXEC p_AlterColumn 'T_INT_IDNUMBERFORMAT', 'FSERIALNO', 'VARCHAR(50)', 'NOT NULL', '0100', ''' ''';**/

IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_BAS_USER_PARAS_CONFIG') 
 CREATE TABLE T_BAS_USER_PARAS_CONFIG (
FID BIGINT DEFAULT 0 NOT NULL,
FUSERID BIGINT DEFAULT 0 NOT NULL,
FRECEIVEMESSAGE CHAR(1) DEFAULT '1',
FUSENEWPORTAL CHAR(1) DEFAULT '0',
FCREATORID BIGINT DEFAULT 0 NOT NULL,
FCREATETIME DATETIME,
FMODIFIERID BIGINT DEFAULT 0 NOT NULL,
FMODIFYTIME DATETIME
);



/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\BOS_table.sql **/
