/**Begin D:\PDM_UPGRADE\PDM1\EB_table.sql **/

IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_EB_INTEGRATION_QUERY') 
 CREATE TABLE T_EB_INTEGRATION_QUERY (
FID BIGINT DEFAULT 0 NOT NULL,
FINTEGRATIONID BIGINT DEFAULT 0 NOT NULL,
QUERYJSON NCLOB,
FCREATERFIELD BIGINT DEFAULT 0 NOT NULL,
FCREATEDATEFIELD DATETIME,
FMODIFYDATEFIELD DATETIME
);


IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_EB_EXECUTECASERANGE') 
 CREATE TABLE T_EB_EXECUTECASERANGE (
FID BIGINT DEFAULT 0 NOT NULL,
FNUMBER NVARCHAR(50) DEFAULT ' ' NOT NULL,
FNAME NVARCHAR(50) DEFAULT ' ' NOT NULL,
FMODEL BIGINT DEFAULT 0 NOT NULL,
FBUSINESSMODEL BIGINT DEFAULT 0 NOT NULL,
FSCOPE NCLOB,
FCREATER BIGINT DEFAULT 0 NOT NULL,
FMODIFIER BIGINT DEFAULT 0 NOT NULL,
FMODIFYDATE DATETIME,
FCREATEDATE DATETIME
);



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