71 lines
4.7 KiB
SQL
71 lines
4.7 KiB
SQL
-- 1、创建内置的几种角色
|
|
INSERT INTO `sys_role`(`id`, `role_name`, `role_code`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `parent_code`, `role_order`, `app_id`) VALUES ('817f7f818bb3506e018bb3506ef70000', '标准查询', 'BZCX', NULL, 'admin', '2023-11-09 17:01:15', NULL, NULL, NULL, NULL, NULL);
|
|
INSERT INTO `sys_role`(`id`, `role_name`, `role_code`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `parent_code`, `role_order`, `app_id`) VALUES ('817f7f818bb3506e018bb35153cb0002', '标准管理员', 'BZGLY', NULL, 'admin', '2023-11-09 17:02:13', NULL, NULL, NULL, NULL, NULL);
|
|
INSERT INTO `sys_role`(`id`, `role_name`, `role_code`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `parent_code`, `role_order`, `app_id`) VALUES ('8989f8bc8c5bd483018c5bd483060000', '标准化联络员', 'BZHLLY', '标准化联络员', 'admin', '2023-12-12 10:21:43', NULL, NULL, NULL, NULL, NULL);
|
|
UPDATE sys_role SET role_name = '系统管理员' WHERE id = 'f6817f48af4fb3af11b9e8bf182f618b' and role_name = '开发管理员';
|
|
|
|
-- 2、将IAM默认生成的角色id=123 的数据 修改成 标准查询 角色的id
|
|
UPDATE sys_user_role SET role_id = '817f7f818bb3506e018bb3506ef70000' WHERE role_id = '123';
|
|
|
|
-- 3、标准类别代号 字段的修改，删除多余的，将J10 改成J
|
|
-- DELETE FROM sys_dict_item WHERE dict_id = '1696792594350952450' AND item_value > 11;
|
|
-- UPDATE sys_dict_item SET item_text = 'J' WHERE dict_id = '1696792594350952450' AND item_value = 11;
|
|
|
|
-- 4、 UPDATE 国家/地区 数据字典 增加 欧洲经济委员会 2023-12-05
|
|
INSERT INTO `sys_dict_item`(`id`, `dict_id`, `parent_id`, `item_text`, `en_name`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `is_tag_dict`, `is_read_only`, `attribute_type`, `del_flag`, `stat_node`) VALUES ('1731917591764377602', '1706192138039345153', 'c138d98de3152e7811456b15c2577a3a', '欧洲经济委员会', 'ECE', 'ECE5', NULL, 99, 1, 'admin', '2023-12-05 14:05:06', 'admin', '2023-12-05 14:06:00', 1, 0, NULL, '0', NULL);
|
|
-- 5 一阶段先去掉【零部件名称】字段 2023-12-05
|
|
UPDATE laws_tag SET del_flag = 1 WHERE `db_field_txt` LIKE '%零部件名称%';
|
|
|
|
-- 6、 责任部门修改成 多选
|
|
UPDATE laws_tag SET field_show_type = 7 WHERE db_field_txt = '责任部门';
|
|
UPDATE laws_tag SET field_show_type = 7, db_length = 500 WHERE db_field_txt = '责任部门';
|
|
-- 修改 法规表对应的字段
|
|
ALTER TABLE laws_overseas_standard MODIFY COLUMN responsible_department VARCHAR(500) comment '责任部门';
|
|
ALTER TABLE laws_domestic_standard MODIFY COLUMN responsible_department VARCHAR(500) comment '责任部门';
|
|
|
|
|
|
-- bug79060 国外标准调整顺序 调整顺序
|
|
UPDATE laws_tag SET order_num = 24 WHERE db_field_txt = '代替标准号' AND id = '1696041640985288701';
|
|
UPDATE laws_tag SET order_num = 25 WHERE db_field_txt = '被代替标准号' AND id = '1696041812461019101';
|
|
UPDATE laws_tag SET order_num = 26 WHERE db_field_txt = '引用标准' AND id = '1696041991343890401';
|
|
|
|
-- bug79064 企标搜索中心 字段的处理
|
|
UPDATE laws_tag
|
|
SET is_show_search = 1
|
|
WHERE
|
|
table_name = 'laws_enterprise_standard'
|
|
AND (
|
|
db_field_txt = '企标编号'
|
|
OR db_field_txt = '企标名称'
|
|
OR db_field_txt = '企业标准代号'
|
|
OR db_field_txt = '企业名称代号'
|
|
OR db_field_txt = '标准类别代号'
|
|
OR db_field_txt = '年代号'
|
|
OR db_field_txt = '标准体系'
|
|
OR db_field_txt = '标准英文名称'
|
|
OR db_field_txt = '标准等级分类'
|
|
OR db_field_txt = '授权部门'
|
|
OR db_field_txt = '发布日期'
|
|
OR db_field_txt = '实施日期'
|
|
OR db_field_txt = '是否试行'
|
|
OR db_field_txt = '试行周期'
|
|
OR db_field_txt = '标准状态'
|
|
OR db_field_txt = '主起草人'
|
|
OR db_field_txt = '主起草单位'
|
|
OR db_field_txt = '主起草部门负责人'
|
|
OR db_field_txt = '配合单位'
|
|
OR db_field_txt = '标准推进人'
|
|
OR db_field_txt = '零部件名称'
|
|
OR db_field_txt = '标准适用范围'
|
|
OR db_field_txt = '代替标准号'
|
|
OR db_field_txt = '被代替标准号'
|
|
OR db_field_txt = '引用标准'
|
|
OR db_field_txt = '被引用标准'
|
|
OR db_field_txt = '采标程度'
|
|
OR db_field_txt = '采用国际标准号'
|
|
);
|
|
|
|
-- 2023-12-6 修改 海外标准 标准名称的长度为200 因为老法规数据导入的时候50报数据库长度不够
|
|
ALTER TABLE laws_overseas_standard MODIFY COLUMN standard_name VARCHAR(200) comment '标准名称';
|
|
ALTER TABLE laws_browsing_history MODIFY COLUMN standard_name VARCHAR(200) comment '标准名称';
|