20211209修改.sql 1.7 KB

12345678910111213141516171819202122
  1. alter table b_resource
  2. add location_type varchar(10);
  3. comment on column b_resource.location_type is '位置类型(水上和陆上)';
  4. INSERT INTO sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES (22, '资源位置类型', 'zhdd_location_type', '0', 'admin', '2021-09-28 15:55:09', 'admin', '2021-09-28 15:55:09', null);
  5. INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (144, 0, '水上', '1', 'zhdd_location_type', null,
  6. 'default', 'N', '0', 'admin', '2021-09-28 15:57:23', 'admin', '2021-09-28 15:57:23', null);
  7. INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (145, 0, '陆上', '2', 'zhdd_location_type', null,
  8. 'default', 'N', '0', 'admin', '2021-09-28 15:57:23', 'admin', '2021-09-28 15:57:23', null);
  9. alter table b_incident
  10. add conclusion varchar(1000);
  11. comment on column b_incident.conclusion is '归档总结';
  12. alter table b_incident
  13. add conclusion_file varchar(3000);
  14. comment on column b_incident.conclusion_file is '归档附件';