/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_EB_CENTRALIZED_ENTITY') 
 CREATE TABLE T_EB_CENTRALIZED_ENTITY (
FID BIGINT DEFAULT 0 NOT NULL,
FNUMBER NVARCHAR(100) DEFAULT ' ' NOT NULL,
FMODEL BIGINT DEFAULT 0 NOT NULL,
FSTATUS CHAR(1) DEFAULT '1' NOT NULL,
FCREATER BIGINT DEFAULT 0 NOT NULL,
FMODIFIER BIGINT DEFAULT 0 NOT NULL,
FCREATEDATE DATETIME,
FMODIFYDATE DATETIME,
FACCOUNT NCLOB,
FSELFDIM1 NCLOB,
FSELFDIM2 NCLOB,
FSELFDIM3 NCLOB,
FSELFDIM4 NCLOB,
FSELFDIM5 NCLOB,
FSELFDIM6 NCLOB,
FTEXT0 NCLOB,
FTEXT1 NCLOB,
FTEXT2 NCLOB,
FTEXT3 NCLOB,
FTEXT6 NCLOB,
FTEXT4 NCLOB,
FTEXT5 NCLOB
);


IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_EB_CENTRALIZED_RANGE') 
 CREATE TABLE T_EB_CENTRALIZED_RANGE (
FENTRYID BIGINT DEFAULT 0 NOT NULL,
FID BIGINT DEFAULT 0 NOT NULL,
FSEQ INT DEFAULT 0 NOT NULL,
FENTITY BIGINT DEFAULT 0 NOT NULL,
FENTITYRANGE NCLOB,
FRANGE NCLOB,
FRANGENUMBERS NCLOB
);



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