init_med.sql 1.3 KB

12345678910111213141516171819202122232425262728293031
  1. use `med`;
  2. ALTER TABLE `kl_library_info` drop INDEX NAME_TYPE_INDEX_UNIQUE;
  3. ALTER TABLE `kl_library_info`
  4. ADD COLUMN `name_en` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '加密name' AFTER `name`;
  5. ALTER TABLE `kl_library_info`
  6. ADD COLUMN `name_de` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '解密name_en' AFTER `name`;
  7. ALTER TABLE `kl_library_info`
  8. ADD COLUMN `spell_en` varchar(100) COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '加密spell' AFTER `spell`;
  9. ALTER TABLE `kl_library_info`
  10. ADD COLUMN `spell_de` varchar(100) COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '解密spell_en' AFTER `spell`;
  11. ALTER TABLE `kl_concept`
  12. ADD COLUMN `lib_name_en` varchar(255) NOT NULL DEFAULT '' COMMENT '加密lib_name' AFTER `lib_name`;
  13. ALTER TABLE `kl_concept`
  14. ADD COLUMN `lib_name_de` varchar(255) NOT NULL DEFAULT '' COMMENT '解密lib_name_en' AFTER `lib_name`;
  15. -- 删除临时添加字段
  16. -- ALTER TABLE `kl_library_info` drop `name_en`;
  17. -- ALTER TABLE `kl_library_info` drop `name_de`;
  18. -- ALTER TABLE `kl_library_info` drop `spell_en`;
  19. -- ALTER TABLE `kl_library_info` drop `spell_de`;
  20. -- ALTER TABLE `kl_concept` drop `lib_name_en`;
  21. -- ALTER TABLE `kl_concept` drop `lib_name_de`;
  22. -- ALTER TABLE `kl_library_info` ADD UNIQUE INDEX NAME_TYPE_INDEX_UNIQUE(`name`, `type_id`);