/** 这个表只是记录日志用，所以可以不用管历史数据，直接重建 **/

IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_EB_BIZRULERPTCALRESULT') 
drop table T_EB_BIZRULERPTCALRESULT;

 CREATE TABLE T_EB_BIZRULERPTCALRESULT (
FID BIGINT DEFAULT 0 NOT NULL,
FMODELID BIGINT DEFAULT 0 NOT NULL,
FTEMPID BIGINT DEFAULT 0 NOT NULL,
FRULEGROUPID BIGINT DEFAULT 0 NOT NULL,
FCELLKEY NVARCHAR(100) DEFAULT ' ' NOT NULL,
FRULEID BIGINT DEFAULT 0 NOT NULL,
FLEFTRULE BIGINT DEFAULT 0 NOT NULL,
FDATASET BIGINT DEFAULT 0 NOT NULL,
FCELLDIMSCOPE NCLOB,
FSAVEDATE DATETIME,
FHANDDATE DATETIME,
FSAVESEQ INT DEFAULT 0 NOT NULL,
FEXECSEQ INT DEFAULT 0 NOT NULL,
FCALMETHOD INT DEFAULT 0 NOT NULL,
FOLAPDIMSCOPE NCLOB,
FOLAPVALUE NVARCHAR(500) DEFAULT ' ' NOT NULL
);
