1. 下载TP6框架

下载tp6 , 项目命名为 ort

  1. composer create-project topthink/think ort

注意：

  • 默认安装 TP6是单应用模式，访问和以前稍有不同。
  • 先再根目录下创建 .env 文件，然后添加 APP_DEBUG = TRUE, 方便调试。

数据库搭建：

导入OK,然后需要做下面的测试。

  1. -- 将所有表的存储引擎改为 innodb
  2. SELECT CONCAT( 'ALTER TABLE ', TABLE_NAME, ' ENGINE=InnoDB;' )
  3. FROM information_schema.tables
  4. WHERE table_schema = 'ort'
  6. -- 执行
  7. ALTER TABLE fa_tracker_bison_efi ENGINE=InnoDB;
  8. ALTER TABLE fa_tracker_bison_efi_record ENGINE=InnoDB;
  9. ALTER TABLE fa_tracker_bison_efi_record_temp ENGINE=InnoDB;
  10. ALTER TABLE fa_tracker_bison_miniline ENGINE=InnoDB;
  11. ALTER TABLE fa_tracker_bison_miniline_record ENGINE=InnoDB;
  12. ALTER TABLE fa_tracker_bison_miniline_record_temp ENGINE=InnoDB;
  13. ALTER TABLE fa_tracker_jedi_efi ENGINE=InnoDB;
  14. ALTER TABLE fa_tracker_jedi_efi_record ENGINE=InnoDB;
  15. ALTER TABLE fa_tracker_jedi_efi_record_temp ENGINE=InnoDB;
  16. ALTER TABLE fa_tracker_jedi_miniline ENGINE=InnoDB;
  17. ALTER TABLE fa_tracker_jedi_miniline_record ENGINE=InnoDB;
  18. ALTER TABLE fa_tracker_jedi_miniline_record_temp ENGINE=InnoDB;
  19. ALTER TABLE fa_tracker_kirin_efi ENGINE=InnoDB;
  20. ALTER TABLE fa_tracker_kirin_efi_record ENGINE=InnoDB;
  21. ALTER TABLE fa_tracker_kirin_efi_record_temp ENGINE=InnoDB;
  22. ALTER TABLE fa_tracker_kirin_miniline ENGINE=InnoDB;
  23. ALTER TABLE fa_tracker_kirin_miniline_record ENGINE=InnoDB;
  24. ALTER TABLE fa_tracker_kirin_miniline_record_temp ENGINE=InnoDB;
  25. ALTER TABLE fa_tracker_mongoose_efi ENGINE=InnoDB;
  26. ALTER TABLE fa_tracker_mongoose_efi_record ENGINE=InnoDB;
  27. ALTER TABLE fa_tracker_mongoose_efi_record_temp ENGINE=InnoDB;
  28. ALTER TABLE fa_tracker_mongoose_miniline ENGINE=InnoDB;
  29. ALTER TABLE fa_tracker_mongoose_miniline_record ENGINE=InnoDB;
  30. ALTER TABLE fa_tracker_mongoose_miniline_record_temp ENGINE=InnoDB;
  31. ALTER TABLE fa_tracker_radar_dct ENGINE=InnoDB;
  32. ALTER TABLE fa_tracker_radar_dct_mapping ENGINE=InnoDB;
  33. ALTER TABLE fa_tracker_radar_log ENGINE=InnoDB;
  34. ALTER TABLE fa_tracker_radar_name_mapping ENGINE=InnoDB;
  35. ALTER TABLE fa_tracker_radar_record ENGINE=InnoDB;
  36. ALTER TABLE fa_tracker_result ENGINE=InnoDB;
  37. ALTER TABLE fa_tracker_select_category_fa3 ENGINE=InnoDB;
  38. ALTER TABLE fa_tracker_select_fa1 ENGINE=InnoDB;
  39. ALTER TABLE fa_tracker_select_fa2 ENGINE=InnoDB;
  40. ALTER TABLE fa_tracker_select_fa_judgement_result ENGINE=InnoDB;
  41. ALTER TABLE fa_tracker_select_fa_status ENGINE=InnoDB;
  42. ALTER TABLE fa_tracker_select_issue ENGINE=InnoDB;
  43. ALTER TABLE fa_tracker_select_sub_fa2 ENGINE=InnoDB;
  44. ALTER TABLE fa_tracker_star_efi ENGINE=InnoDB;
  45. ALTER TABLE fa_tracker_star_efi_record ENGINE=InnoDB;
  46. ALTER TABLE fa_tracker_star_efi_record_temp ENGINE=InnoDB;
  47. ALTER TABLE fa_tracker_star_miniline ENGINE=InnoDB;
  48. ALTER TABLE fa_tracker_star_miniline_record ENGINE=InnoDB;
  49. ALTER TABLE fa_tracker_star_miniline_record_temp ENGINE=InnoDB;
  50. ALTER TABLE logs ENGINE=InnoDB;
  51. ALTER TABLE material_exponent_bison ENGINE=InnoDB;
  52. ALTER TABLE material_exponent_jedi ENGINE=InnoDB;
  53. ALTER TABLE material_exponent_kirin ENGINE=InnoDB;
  54. ALTER TABLE material_exponent_mongoose ENGINE=InnoDB;
  55. ALTER TABLE material_exponent_star ENGINE=InnoDB;
  56. ALTER TABLE material_fa2_date ENGINE=InnoDB;
  57. ALTER TABLE material_sarl_bison ENGINE=InnoDB;
  58. ALTER TABLE material_sarl_jedi ENGINE=InnoDB;
  59. ALTER TABLE material_sarl_kirin ENGINE=InnoDB;
  60. ALTER TABLE material_sarl_mongoose ENGINE=InnoDB;
  61. ALTER TABLE material_sarl_star ENGINE=InnoDB;
  62. ALTER TABLE material_status ENGINE=InnoDB;
  63. ALTER TABLE material_tracker_bison ENGINE=InnoDB;
  64. ALTER TABLE material_tracker_jedi ENGINE=InnoDB;
  65. ALTER TABLE material_tracker_kirin ENGINE=InnoDB;
  66. ALTER TABLE material_tracker_mongoose ENGINE=InnoDB;
  67. ALTER TABLE material_tracker_star ENGINE=InnoDB;
  68. ALTER TABLE ts_check ENGINE=InnoDB;
  69. ALTER TABLE ts_fa_status ENGINE=InnoDB;
  70. ALTER TABLE ts_log ENGINE=InnoDB;
  71. ALTER TABLE ts_phase1_bison ENGINE=InnoDB;
  72. ALTER TABLE ts_phase1_jedi ENGINE=InnoDB;
  73. ALTER TABLE ts_phase1_kirin ENGINE=InnoDB;
  74. ALTER TABLE ts_phase1_mongoose ENGINE=InnoDB;
  75. ALTER TABLE ts_phase1_star ENGINE=InnoDB;
  76. ALTER TABLE ts_phase2_bison ENGINE=InnoDB;
  77. ALTER TABLE ts_phase2_jedi ENGINE=InnoDB;
  78. ALTER TABLE ts_phase2_kirin ENGINE=InnoDB;
  79. ALTER TABLE ts_phase2_mongoose ENGINE=InnoDB;
  80. ALTER TABLE ts_phase2_star ENGINE=InnoDB;
  81. ALTER TABLE ts_phase3_bison ENGINE=InnoDB;
  82. ALTER TABLE ts_phase3_jedi ENGINE=InnoDB;
  83. ALTER TABLE ts_phase3_kirin ENGINE=InnoDB;
  84. ALTER TABLE ts_phase3_mongoose ENGINE=InnoDB;
  85. ALTER TABLE ts_phase3_star ENGINE=InnoDB;
  86. ALTER TABLE ts_phase4_bison ENGINE=InnoDB;
  87. ALTER TABLE ts_phase4_jedi ENGINE=InnoDB;
  88. ALTER TABLE ts_phase4_kirin ENGINE=InnoDB;
  89. ALTER TABLE ts_phase4_mongoose ENGINE=InnoDB;
  90. ALTER TABLE ts_phase4_star ENGINE=InnoDB;
  91. ALTER TABLE ts_plan_status_mapping ENGINE=InnoDB;
  92. ALTER TABLE ts_plan_upload ENGINE=InnoDB;
  93. ALTER TABLE ts_project ENGINE=InnoDB;
  94. ALTER TABLE ts_sn_mapping ENGINE=InnoDB;
  95. ALTER TABLE ts_status_fixture_id ENGINE=InnoDB;
  96. ALTER TABLE ts_status_upload ENGINE=InnoDB;
  97. ALTER TABLE ts_test_flow_mapping ENGINE=InnoDB;
  98. ALTER TABLE user ENGINE=InnoDB;
  99. ALTER TABLE user_maintain ENGINE=InnoDB;
  100. ALTER TABLE wh_back_code ENGINE=InnoDB;
  101. ALTER TABLE wh_borrow_code ENGINE=InnoDB;
  102. ALTER TABLE wh_build ENGINE=InnoDB;
  103. ALTER TABLE wh_fa100_status ENGINE=InnoDB;
  104. ALTER TABLE wh_logs ENGINE=InnoDB;
  105. ALTER TABLE wh_machine_details ENGINE=InnoDB;
  106. ALTER TABLE wh_material ENGINE=InnoDB;
  107. ALTER TABLE wh_miniline ENGINE=InnoDB;
  108. ALTER TABLE wh_pr_unit ENGINE=InnoDB;
  109. ALTER TABLE wh_product ENGINE=InnoDB;
  110. ALTER TABLE wh_record ENGINE=InnoDB;
  111. ALTER TABLE wh_replace_material ENGINE=InnoDB;
  112. ALTER TABLE wh_storage_location_1 ENGINE=InnoDB;
  113. ALTER TABLE wh_storage_location_2 ENGINE=InnoDB;
  114. ALTER TABLE wh_storage_location_3 ENGINE=InnoDB;
  116. -- 查看数据所有表的储存引擎
  117. show table status from ort