smartsearch/doc/待更新脚本

 INSERT INTO sys_function_code (FunctionCode, FunctionName, ParentFunctionCode, OrderNo) VALUES ('T0104', '领域检索', 'T01', 2);

 INSERT INTO sys_menu (MenuNo, OrderNo, MenuName, Icon, ViewPath, Url, ParentMenuNo, Description, IsTopMenu, IsVisible, IsLeaf, FunctionCode, RecordStatus, ShortcutIcon)
 VALUES ('T0104', 3, '领域检索', 'SearchOutlined', 'views/domain', '/domain', 'T01', null, 0, 1, 1, 'T0104', 1, null);
 INSERT INTO sys_menu (MenuNo, OrderNo, MenuName, Icon, ViewPath, Url, ParentMenuNo, Description, IsTopMenu, IsVisible, IsLeaf, FunctionCode, RecordStatus, ShortcutIcon)
 VALUES ('T010401', 1, '领域检索', null, 'views/domain', '/domain/index', 'T0104', null, 0, 0, 1, 'T0104', 1, null);
 INSERT INTO sys_menu (MenuNo, OrderNo, MenuName, Icon, ViewPath, Url, ParentMenuNo, Description, IsTopMenu, IsVisible, IsLeaf, FunctionCode, RecordStatus, ShortcutIcon)
 VALUES ('T010402', 2, '领域检索结果', null, 'views/domainResult', '/domain/result', 'T0104', null, 0, 0, 1, 'T0104', 1, null);


 INSERT INTO sys_function_code (FunctionCode, FunctionName, ParentFunctionCode, OrderNo) VALUES ('T0109', '索引定义', 'T01', 9);
 INSERT INTO sys_function_code (FunctionCode, FunctionName, ParentFunctionCode, OrderNo) VALUES ('T010900', '查看', 'T0109', 0);
 INSERT INTO sys_function_code (FunctionCode, FunctionName, ParentFunctionCode, OrderNo) VALUES ('T010901', '新增', 'T0109', 1);
 INSERT INTO sys_function_code (FunctionCode, FunctionName, ParentFunctionCode, OrderNo) VALUES ('T010902', '导入', 'T0109', 2);
 INSERT INTO sys_function_code (FunctionCode, FunctionName, ParentFunctionCode, OrderNo) VALUES ('T010903', '编辑', 'T0109', 3);
 INSERT INTO sys_function_code (FunctionCode, FunctionName, ParentFunctionCode, OrderNo) VALUES ('T010904', '删除', 'T0109', 4);

 INSERT INTO sys_menu (MenuNo, OrderNo, MenuName, Icon, ViewPath, Url, ParentMenuNo, Description, IsTopMenu, IsVisible, IsLeaf, FunctionCode, RecordStatus, ShortcutIcon)
 VALUES ('T0109', 5, '索引定义', 'ReadOutlined', 'views/esindex', '/esindex', 'T01', null, 0, 1, 1, 'T0109', 1, null);
 INSERT INTO sys_menu (MenuNo, OrderNo, MenuName, Icon, ViewPath, Url, ParentMenuNo, Description, IsTopMenu, IsVisible, IsLeaf, FunctionCode, RecordStatus, ShortcutIcon)
 VALUES ('T010901', 1, '索引管理', '', 'views/esindexlist', '/esindex/list', 'T0109', null, 0, 0, 1, 'T0109', 1, null);
 INSERT INTO sys_menu (MenuNo, OrderNo, MenuName, Icon, ViewPath, Url, ParentMenuNo, Description, IsTopMenu, IsVisible, IsLeaf, FunctionCode, RecordStatus, ShortcutIcon)
 VALUES ('T010902', 2, '字段定义', '', 'views/esindexedit', '/esindex/edit', 'T0109', null, 0, 0, 1, null, 1, null);
 INSERT INTO sys_menu (MenuNo, OrderNo, MenuName, Icon, ViewPath, Url, ParentMenuNo, Description, IsTopMenu, IsVisible, IsLeaf, FunctionCode, RecordStatus, ShortcutIcon)
 VALUES ('T010903', 3, '索引详细', '', 'views/esindexdetail', '/esindex/detail', 'T0109', null, 0, 0, 1, null, 1, null);

 create table es_index
 (
     indexId              varchar(50) not null,
     indexName            varchar(100) not null comment '索引名称',
     indexCode            varchar(100) not null comment '索引编码',
     indexDesc            varchar(200) comment '描述',
     displayType          int comment '显示类型1、生命周期2、普通表格3、列表4、图表5、文档',
     createdName          varchar(50) not null comment '创建姓名',
     createTime           datetime not null comment '创建时间',
     modiTime             datetime not null,
     createdBy            varchar(50) not null comment '创建人',
     status               int not null comment '状态(1 有效/0 无效)',
     primary key (indexId)
 );

 create table es_indexField
 (
     fieldId              varchar(50) not null,
     indexId              varchar(50) comment '索引id',
     fieldCode            varchar(100) not null comment '字段编码',
     fieldName            varchar(100) not null comment '字段名称',
     fieldDesc            varchar(200) comment '字段描述',
     dataType             varchar(20) not null comment '数据类型',
     queryTypeId          int not null comment '字典表queryType的值1、文本2、数值3、日期4、字典值5、级联选择6、穿梭选择',
     disOrder             int not null,
     isSearchField        int not null comment '1、是0、否 如是1则自助检索页面显示',
     isDisplay            int comment '1、显示0、隐藏',
     primary key (fieldId)
 );

 alter table es_indexField add constraint FK_Reference_33 foreign key (indexId)
     references es_index (indexId) on delete restrict on update restrict;


 insert into sys_dictionary value('displayType','索引显示类型',1,1);
 insert into sys_dictionary_item values (uuid(),'','displayType',1,'生命周期',1,1,1);
 insert into sys_dictionary_item values (uuid(),'','displayType',2,'表格',2,1,1);
 insert into sys_dictionary_item values (uuid(),'','displayType',3,'列表',3,1,1);
 insert into sys_dictionary_item values (uuid(),'','displayType',4,'图表',4,1,1);
 insert into sys_dictionary_item values (uuid(),'','displayType',5,'文档',5,1,1);