/**Begin D:\PDM_UPGRADE\PDM1\HOM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_HOM_COLLECTGROUP')
 CREATE TABLE T_HOM_COLLECTGROUP (
FID BIGINT DEFAULT 0 NOT NULL,
FCOLLECTACTIVITYID BIGINT DEFAULT 0 NOT NULL
);


IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_HOM_COLLECTGROUPENTRY')
 CREATE TABLE T_HOM_COLLECTGROUPENTRY (
FENTRYID BIGINT DEFAULT 0 NOT NULL,
FID BIGINT DEFAULT 0 NOT NULL,
FSEQ INT DEFAULT 0 NOT NULL,
FINFOGROUPID BIGINT DEFAULT 0 NOT NULL,
FINFOGROUPSTATUS INT DEFAULT 0 NOT NULL
);


IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_HOM_COLLECTFIELDSUB')
 CREATE TABLE T_HOM_COLLECTFIELDSUB (
FDETAILID BIGINT DEFAULT 0 NOT NULL,
FENTRYID BIGINT DEFAULT 0 NOT NULL,
FSEQ INT DEFAULT 0 NOT NULL,
FFIELDID BIGINT DEFAULT 0 NOT NULL,
FBUSINESSID BIGINT DEFAULT 0 NOT NULL,
FREMARK VARCHAR(200) DEFAULT ' ' NOT NULL
);



/**End D:\PDM_UPGRADE\PDM1\HOM_table.sql **/
