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

IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_SEC_GATEDLAUNCHUSER') 
 CREATE TABLE T_SEC_GATEDLAUNCHUSER (
FID BIGINT DEFAULT 0 NOT NULL,
FUSERID BIGINT DEFAULT 0 NOT NULL
);

EXEC P_ALTERPK 'PK_T_SEC_GATEDLAUNCHUSER', 'T_SEC_GATEDLAUNCHUSER', 'FID', '1';

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SEC_GATEDLAUNCHUSER_USER') CREATE INDEX IDX_SEC_GATEDLAUNCHUSER_USER ON T_SEC_GATEDLAUNCHUSER ( FUSERID );


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