Strona główna Odkrywaj Pomoc
Zaloguj się
zk-question
/
qrzk-tk
2
0
Forkuj 0
Pliki Problemy 0 Oczekujące zmiany 0 Wiki
Gałąź: master
Gałęzie Tagi
qrzk-tk
/
sql
/
db_add_guid.sql

db_add_guid.sql 11 KB
Bezpośredni odnośnik Historia Czysty

12345678910111213141516171819202122232425262728293031323334353637383940414243 
  1. ##升级所有的表，添加唯一键：guid，通过UUID()给原来的数据赋值##
    2. 

  2. ALTER TABLE `b_attachment` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE b_attachment set guid=UUID();ALTER TABLE `b_attachment` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    3. 

  3. ALTER TABLE `b_batch` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE b_batch set guid=UUID();ALTER TABLE `b_batch` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    4. 

  4. ALTER TABLE `b_book` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE b_book set guid=UUID();ALTER TABLE `b_book` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    5. 

  5. ALTER TABLE `b_course` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE b_course set guid=UUID();ALTER TABLE `b_course` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    6. 

  6. ALTER TABLE `b_course_book` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE b_course_book set guid=UUID();ALTER TABLE `b_course_book` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    7. 

  7. ALTER TABLE `b_course_question_type` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE b_course_question_type set guid=UUID();ALTER TABLE `b_course_question_type` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    8. 

  8. ALTER TABLE `b_question_type` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE b_question_type set guid=UUID();ALTER TABLE `b_question_type` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    9. 

  9. ALTER TABLE `qr_oper_log` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE qr_oper_log set guid=UUID();ALTER TABLE `qr_oper_log` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    10. 

  10. ALTER TABLE `qr_pager_construct` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE qr_pager_construct set guid=UUID();ALTER TABLE `qr_pager_construct` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    11. 

  11. ALTER TABLE `qr_pager_construct_detail` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE qr_pager_construct_detail set guid=UUID();ALTER TABLE `qr_pager_construct_detail` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    12. 

  12. ALTER TABLE `qr_pager_construct_qtype` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE qr_pager_construct_qtype set guid=UUID();ALTER TABLE `qr_pager_construct_qtype` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    13. 

  13. ALTER TABLE `qr_pager_templet` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE qr_pager_templet set guid=UUID();ALTER TABLE `qr_pager_templet` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    14. 

  14. ALTER TABLE `qr_paper` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE qr_paper set guid=UUID();ALTER TABLE `qr_paper` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    15. 

  15. ALTER TABLE `qr_paper_batch` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE qr_paper_batch set guid=UUID();ALTER TABLE `qr_paper_batch` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    16. 

  16. ALTER TABLE `qr_paper_dbf_paper_info` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE qr_paper_dbf_paper_info set guid=UUID();ALTER TABLE `qr_paper_dbf_paper_info` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    17. 

  17. ALTER TABLE `qr_paper_paper_batch` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE qr_paper_paper_batch set guid=UUID();ALTER TABLE `qr_paper_paper_batch` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    18. 

  18. ALTER TABLE `qr_paper_rel_dbf_paper_info` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE qr_paper_rel_dbf_paper_info set guid=UUID();ALTER TABLE `qr_paper_rel_dbf_paper_info` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    19. 

  19. ALTER TABLE `qr_paper_skeleton2` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE qr_paper_skeleton2 set guid=UUID();ALTER TABLE `qr_paper_skeleton2` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    20. 

  20. ALTER TABLE `qr_paper_skeleton2_detail` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE qr_paper_skeleton2_detail set guid=UUID();ALTER TABLE `qr_paper_skeleton2_detail` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    21. 

  21. ALTER TABLE `s_code` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE s_code set guid=UUID();ALTER TABLE `s_code` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    22. 

  22. ALTER TABLE `s_menu` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE s_menu set guid=UUID();ALTER TABLE `s_menu` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    23. 

  23. ALTER TABLE `s_role` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE s_role set guid=UUID();ALTER TABLE `s_role` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    24. 

  24. ALTER TABLE `s_role_menu` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE s_role_menu set guid=UUID();ALTER TABLE `s_role_menu` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    25. 

  25. ALTER TABLE `s_sys_param` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE s_sys_param set guid=UUID();ALTER TABLE `s_sys_param` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    26. 

  26. ALTER TABLE `s_user` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE s_user set guid=UUID();ALTER TABLE `s_user` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    27. 

  27. ALTER TABLE `s_user_course` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE s_user_course set guid=UUID();ALTER TABLE `s_user_course` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    28. 

  28. ALTER TABLE `s_user_role` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE s_user_role set guid=UUID();ALTER TABLE `s_user_role` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    29. 

  29. ALTER TABLE `tk_batch` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE tk_batch set guid=UUID();ALTER TABLE `tk_batch` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    30. 

  30. ALTER TABLE `tk_flow_log` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE tk_flow_log set guid=UUID();ALTER TABLE `tk_flow_log` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    31. 

  31. ALTER TABLE `tk_learn_center` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE tk_learn_center set guid=UUID();ALTER TABLE `tk_learn_center` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    32. 

  32. ALTER TABLE `tk_paper_difficulty_estimate` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE tk_paper_difficulty_estimate set guid=UUID();ALTER TABLE `tk_paper_difficulty_estimate` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    33. 

  33. ALTER TABLE `tk_paper_task` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE tk_paper_task set guid=UUID();ALTER TABLE `tk_paper_task` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    34. 

  34. ALTER TABLE `tk_teacher_assessment` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE tk_teacher_assessment set guid=UUID();ALTER TABLE `tk_teacher_assessment` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    35. 

  35. ALTER TABLE `tk_teacher_assessment_detail` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE tk_teacher_assessment_detail set guid=UUID();ALTER TABLE `tk_teacher_assessment_detail` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    36. 

  36. ALTER TABLE `tk_word_history` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE tk_word_history set guid=UUID();ALTER TABLE `tk_word_history` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    37. 

  37. ALTER TABLE `zk_import_question_history` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE zk_import_question_history set guid=UUID();ALTER TABLE `zk_import_question_history` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    38. 

  38. ALTER TABLE `zk_question` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE zk_question set guid=UUID();ALTER TABLE `zk_question` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    39. 

  39. ALTER TABLE `zk_question_attachment` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE zk_question_attachment set guid=UUID();ALTER TABLE `zk_question_attachment` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    40. 

  40. ALTER TABLE `zk_question_operation_log` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE zk_question_operation_log set guid=UUID();ALTER TABLE `zk_question_operation_log` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    41. 

  41. ALTER TABLE `zk_question_option` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE zk_question_option set guid=UUID();ALTER TABLE `zk_question_option` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    42. 

  42. ALTER TABLE `zk_question_option_version` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE zk_question_option_version set guid=UUID();ALTER TABLE `zk_question_option_version` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    43. 

  43. ALTER TABLE `zk_question_version` ADD COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci UNIQUE;UPDATE zk_question_version set guid=UUID();ALTER TABLE `zk_question_version` MODIFY COLUMN `guid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    44.