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

IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_POM_MROMULPANELDEF') 
 CREATE TABLE T_POM_MROMULPANELDEF (
FPKID BIGINT DEFAULT 0 NOT NULL,
FENTRYID BIGINT DEFAULT 0 NOT NULL,
FBASEDATAID BIGINT DEFAULT 0 NOT NULL
);
 EXEC P_ALTERPK 'PK_POM_MROMULPANELDEF', 'T_POM_MROMULPANELDEF', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_POM_MROMULPANELDEF_FK') CREATE INDEX IDX_POM_MROMULPANELDEF_FK ON T_POM_MROMULPANELDEF ( FENTRYID );

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