alter table x_email modify (InfoContent VARCHAR(2000)); ---知识库添加 20220430 INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) VALUES ('09','知识库','0','/0/09/','0','','','false','true','complaint.repository.tree','menu','8.00'); INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) VALUES ('0901','知识浏览','09','/0/09/0901/','1','/myconsole/complaint/repository/index1','','true','true','complaint.repository.index1','menu','3.00'); INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) VALUES ('0902','知识维护','09','/0/09/0902/','1','/myconsole/webinfo','','true','true','work.web.weblist','menu','1.00'); INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) VALUES ('090201','新建','0902','/0/09/0902/090201','2','/myconsole/webinfo/saveOrUpdate','','true','true','work.web.insert','function','1.00'); INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) VALUES ('090202','编辑','0902','/0/09/0902/090202','2','/myconsole/webinfo/saveOrUpdate','','true','true','work.web.update','function','2.00'); INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) VALUES ('090203','发布','0902','/0/09/0902/090203','2','/myconsole/webinfo/release','','true','true','work.web.release','function','3.00'); INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) VALUES ('090204','撤稿','0902','/0/09/0902/090204','2','/myconsole/webinfo/setWithdraw','','true','true','work.web.withdraw','function','4.00'); INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) VALUES ('090205','删除','0902','/0/09/0902/090205','2','/myconsole/webinfo/saveOrUpdate','','true','true','work.web.delete','function','5.00'); INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) INSERT INTO t_menu (KeyID,Menuname,Parentid,Insertuserid,Inserttime,Updateuserid,Updatetime,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) VALUES ('0903', '文件夹目录维护', '09', NULL, NULL, NULL, NULL, '/0/09/0903/', '2', '/myconsole/column', NULL, 'true', 'true', 'web.column.columnlist', 'menu', '2.00'); INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('090301', '添加', '0903', NULL, NULL, NULL, NULL, '/0/09/0903/090301/', '3', '/myconsole/column/saveOrUpdate', NULL, 'true', 'true', 'web.column.insert', 'function', '1.00'); INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('090302', '编辑', '0903', NULL, NULL, NULL, NULL, '/0/09/0903/090302/', '3', '/myconsole/column/saveOrUpdate', NULL, 'true', 'true', 'web.column.update', 'function', '2.00'); INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('090303', '删除', '0903', NULL, NULL, NULL, NULL, '/0/09/0903/090303/', '3', '/myconsole/column/saveOrUpdate', NULL, 'true', 'true', 'web.column.delete', 'function', '3.00'); create table X_WEBCOLLECTION ( keyid VARCHAR2(32) not null, userid VARCHAR2(32), webkeyid VARCHAR2(32), columnid VARCHAR2(32), tstate VARCHAR2(32), title VARCHAR2(500), recordtime VARCHAR2(19), isornot VARCHAR2(10) ) ---2022-05-02 alter table x_appeal add (GroupType VARCHAR(20)); alter table x_preinflow add (NoNormalPay int); alter table x_result add (ReturnAudioNo VARCHAR(40)); -- ************************************************** -- Name: x_fund -- Purpose: 基金总额表 -- Deviser: 韩林平 -- Devistime: 2022-05-01 -- ************************************************** drop table x_fund; create table x_fund ( OrgID VARCHAR(255) not null, -- 机构编号 OrgName VARCHAR(255) , -- 机构名称 FundMoney DECIMAL(10,2) , -- 基金余额 constraint PK_x_fund primary key (OrgID) ); -- ************************************************** -- Name: x_fundrecharge -- Purpose: 基金充值表 -- Deviser: 韩林平 -- Devistime: 2022-05-01 -- ************************************************** --drop table x_fundrecharge; create table x_fundrecharge ( KeyID VARCHAR(60) not null, -- 数据编号 OrgID VARCHAR(255) , -- 机构编号 OrgName VARCHAR(255) , -- 机构名称 FundMoney DECIMAL(10,2) , -- 充值金额 FundYear VARCHAR(4) , -- 基金所属年份 RecordUserID VARCHAR(50) , -- 充值人编号 RecordUserName VARCHAR(50) , -- 充值人名称 RecordTime VARCHAR(19) , -- 充值时间 存贮到年月日小时秒分 constraint PK_x_fundrecharge primary key (KeyID) ); -- ************************************************** -- Name: x_funduse -- Purpose: 基金使用表 -- Deviser: 韩林平 -- Devistime: 2022-05-01 -- ************************************************** --drop table x_funduse; create table x_funduse ( KeyID VARCHAR(60) not null, -- 数据编号 AppealID VARCHAR(40) , -- 事项表ID TName VARCHAR(50) , -- 客诉人姓名 SerialNumber VARCHAR(60) , -- 客诉件流水号 （事项信息冗余） AppealDate VARCHAR(19) , -- 投诉日期 存贮到年月日 OrgID VARCHAR(255) , -- 机构编号 OrgName VARCHAR(255) , -- 机构名称 FundMoney DECIMAL(10,2) , -- 使用金额 FundYear VARCHAR(4) , -- 基金所属年份 RecordUserID VARCHAR(50) , -- 使用人编号 RecordUserName VARCHAR(50) , -- 使用人名称 RecordTime VARCHAR(19) , -- 使用时间 存贮到年月日小时秒分 constraint PK_x_funduse primary key (KeyID) ); INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) VALUES ('0611','基金登记','06','/0/01/0611/','1','/myconsole/complaint/register/money','','true','true','complaint.register.money','menu','11.00'); INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) VALUES ('0612','基金查询','06','/0/01/0612/','1','/myconsole/complaint/transact/moneyList','','true','true','complaint.transact.moneyList','menu','12.00'); INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) VALUES ('0613','基金使用查詢','06','/0/01/0613/','1','/myconsole/complaint/transact/moneyListUse','','true','true','complaint.transact.moneyListUse','menu','13.00'); INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) VALUES ('0614','基金充值查询','06','/0/01/0614/','1','/myconsole/complaint/transact/moneyListAdd','','true','true','complaint.transact.moneyListAdd','menu','14.00'); ---2022-05-05 alter table x_appeal add (CurDoUserInfo VARCHAR(500)); alter table x_result add (CheckApproveInfo VARCHAR(200)); alter table x_result add (CheckApproveResult VARCHAR(20)); alter table x_result add (CheckApproveTime VARCHAR(19)); ---2022-05-07 INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) VALUES ('0605','默认办理规则','06','/0/06/0605/','0','/myconsole/complaint/rule/defaultdo','','true','true','complaint.rule.defaultdo','menu','5.00'); delete from dic_complainttype; insert into dic_complainttype values ('01','01','一般投诉','','0','false',1.0,1,'/0/01/','admin','超级管理员','2017-01-31'); insert into dic_complainttype values ('02','02','疑难投诉','','0','true',2.0,1,'/0/02/','admin','超级管理员','2017-01-31'); insert into dic_complainttype values ('03','03','重大投诉','','0','true',3.0,1,'/0/03/','admin','超级管理员','2017-01-31'); alter table x_appeal add (AskMoney DECIMAL(10,2)); alter table x_transact add (AskMoney DECIMAL(10,2)); ---2022-05-10 alter table x_result add (MediateUseDate int); INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) VALUES ('0304','核查件查询','03','/0/03/0304/','1','/myconsole/complaint/list/check','','true','true','complaint.list.check','menu','1.5');