smartsearch/doc/待更新脚本.txt

---2024-5-30日 购物车mysql脚本

create table cf_apply_form
(
    applyId              varchar(50) not null,
    applyUserId          varchar(50),
    applyUserName        varchar(50),
    status               int comment '1、审核中2、审核通过3、驳回',
    applyDate            datetime comment '申请时间',
    reason               varchar(300) comment '申请原因',
    primary key (applyId)
);

create table cf_apply_form_reviewer
(
    reviewerId           varchar(50) not null,
    applyId              varchar(50),
    reviewerUserId       varchar(50),
    reviewerUserName     varchar(50),
    reviewerAction       int,
    comments             varchar(300),
    reviewerDate         datetime,
    primary key (reviewerId)
);

alter table cf_apply_form_reviewer add constraint FK_Reference_34 foreign key (applyId)
    references cf_apply_form (applyId) on delete restrict on update restrict;

create table cf_apply_form_well_file
(
    wellFileId           varchar(50) not null,
    applyId              varchar(50) comment '关联申请单',
    well_common_name     varchar(200) comment '井',
    file_name            varchar(200) comment '文件名称',
    primary key (wellFileId)
);

alter table cf_apply_form_well_file add constraint FK_Reference_35 foreign key (applyId)
    references cf_apply_form (applyId) on delete restrict on update restrict;

INSERT INTO sys_function_code (FunctionCode, FunctionName, ParentFunctionCode, OrderNo) VALUES ('T0111', '我的审批', 'T01', 9);
INSERT INTO sys_menu (MenuNo, OrderNo, MenuName, Icon, ViewPath, Url, ParentMenuNo, Description, IsTopMenu, IsVisible, IsLeaf, FunctionCode, RecordStatus, ShortcutIcon)
VALUES ('T0111', 4, '我的审批', 'MailOutlined', 'views/reviewer', '/reviewer', 'T01', null, 0, 1, 1, 'T0111', 1, null);
INSERT INTO sys_menu (MenuNo, OrderNo, MenuName, Icon, ViewPath, Url, ParentMenuNo, Description, IsTopMenu, IsVisible, IsLeaf, FunctionCode, RecordStatus, ShortcutIcon)
VALUES ('T011101', 1, '我的审批', '', 'views/reviewerList', '/reviewer/list', 'T0111', null, 0, 0, 1, 'T0111', 1, null);

INSERT INTO sys_function_code (FunctionCode, FunctionName, ParentFunctionCode, OrderNo) VALUES ('T0110', '我的申请', 'T01', 9);
INSERT INTO sys_menu (MenuNo, OrderNo, MenuName, Icon, ViewPath, Url, ParentMenuNo, Description, IsTopMenu, IsVisible, IsLeaf, FunctionCode, RecordStatus, ShortcutIcon)
VALUES ('T0110', 4, '我的申请', 'FileDoneOutlined', 'views/apply', '/apply', 'T01', null, 0, 1, 1, 'T0110', 1, null);
INSERT INTO sys_menu (MenuNo, OrderNo, MenuName, Icon, ViewPath, Url, ParentMenuNo, Description, IsTopMenu, IsVisible, IsLeaf, FunctionCode, RecordStatus, ShortcutIcon)
VALUES ('T011001', 1, '我的申请', '', 'views/applyList', '/apply/list', 'T0110', null, 0, 0, 1, 'T0110', 1, null);

UPDATE sys_menu SET OrderNo=6 WHERE MenuNo='T0108';
UPDATE sys_menu SET OrderNo=5 WHERE MenuNo='T0109';


insert into sys_dictionary value('applyFormStatus','申请单状态',1,1);
insert into sys_dictionary_item values (uuid(),'','applyFormStatus',1,'审核中',1,1,1);
insert into sys_dictionary_item values (uuid(),'','applyFormStatus',2,'通过',2,1,1);
insert into sys_dictionary_item values (uuid(),'','applyFormStatus',3,'驳回',3,1,1);