RWAServer/DBScript/李庚谱/002-DML.sql

delete from sys_noun where NOUNITEM = 'TERM';
insert into sys_noun
select 'TERM', '202412', '默认上季度期次', nounsuper, nounlevel, nounorder, nounmodule, nounvalidity, readonly, nounprop, nounremarks, nounrelation, orgflag from sys_noun a where a.NOUNITEM = 'WORKDATE';


DELETE FROM SYS_NOUN WHERE NOUNITEM = 'CALC_STATE';

INSERT INTO sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG)
VALUES ('CALC_STATE', 'CALC_STATE', '计算任务执行状态', 'BUSDICT', 2.000000000000000000000000000000, 0.000000000000000000000000000000, 'common', '0', '0', null, null, '1', '0');
INSERT INTO sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG)
VALUES ('CALC_STATE', 'READY', '准备中', 'BUSDICT', 3.000000000000000000000000000000, 1.000000000000000000000000000000, 'common', '1', '0', null, null, '1', '0');
INSERT INTO sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG)
VALUES ('CALC_STATE', 'RUNNING', '执行中', 'BUSDICT', 3.000000000000000000000000000000, 2.000000000000000000000000000000, 'common', '1', '0', null, null, '1', '0');
INSERT INTO sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG)
VALUES ('CALC_STATE', 'END', '已完成', 'BUSDICT', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'common', '1', '0', null, null, '1', '0');
INSERT INTO sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG)
VALUES ('CALC_STATE', 'ERROR', '异常', 'BUSDICT', 3.000000000000000000000000000000, 4.000000000000000000000000000000, 'common', '1', '0', null, null, '1', '0');