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

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

