nohup.out 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288
  1. yarn run v1.22.10
  2. $ cross-env NODE_ENV=production node server/index.js
  3. Executing (default): CREATE TABLE IF NOT EXISTS `user` (`id` INTEGER NOT NULL auto_increment , `name` VARCHAR(64) NOT NULL, `password` VARCHAR(512) NOT NULL, `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `photo` VARCHAR(512) NOT NULL DEFAULT '/image/default-photo.jpg', `role` ENUM('STUDENT', 'TEACHER', 'ADMIN') NOT NULL DEFAULT 'STUDENT', `signature` VARCHAR(512) NOT NULL DEFAULT '无', `createdTime` DATETIME NOT NULL, `isValid` TINYINT(1) NOT NULL DEFAULT true, UNIQUE `column` (`name`, `phone`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  4. Executing (default): CREATE TABLE IF NOT EXISTS `teacher` (`id` INTEGER NOT NULL auto_increment , `realName` VARCHAR(64) NOT NULL, `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学', `jobNumber` VARCHAR(64) NOT NULL, `certificate` VARCHAR(512) NOT NULL DEFAULT '', `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `uid` INTEGER NOT NULL, `createdTime` DATETIME NOT NULL, `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying', UNIQUE `column` (`phone`, `uid`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  5. Executing (default): CREATE TABLE IF NOT EXISTS `teacher` (`id` INTEGER NOT NULL auto_increment , `realName` VARCHAR(64) NOT NULL, `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学', `jobNumber` VARCHAR(64) NOT NULL, `certificate` VARCHAR(512) NOT NULL DEFAULT '', `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `uid` INTEGER NOT NULL, `createdTime` DATETIME NOT NULL, `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying', UNIQUE `column` (`phone`, `uid`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  6. Executing (default): SHOW INDEX FROM `user`
  7. Executing (default): SHOW INDEX FROM `teacher`
  8. Executing (default): SHOW FULL COLUMNS FROM `teacher`;
  9. Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'teacher' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='seec_portal' AND REFERENCED_TABLE_NAME IS NOT NULL;
  10. Executing (default): ALTER TABLE `teacher` CHANGE `realName` `realName` VARCHAR(64) NOT NULL;
  11. READY Server listening on http://0.0.0.0:3111
  12. Executing (default): ALTER TABLE `teacher` CHANGE `organization` `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学';
  13. Executing (default): ALTER TABLE `teacher` CHANGE `jobNumber` `jobNumber` VARCHAR(64) NOT NULL;
  14. Executing (default): ALTER TABLE `teacher` CHANGE `certificate` `certificate` VARCHAR(512) NOT NULL DEFAULT '';
  15. Executing (default): ALTER TABLE `teacher` CHANGE `phone` `phone` VARCHAR(64) NOT NULL;
  16. Executing (default): ALTER TABLE `teacher` CHANGE `email` `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com';
  17. Executing (default): ALTER TABLE `teacher` CHANGE `uid` `uid` INTEGER NOT NULL;
  18. Executing (default): ALTER TABLE `teacher` CHANGE `createdTime` `createdTime` DATETIME NOT NULL;
  19. Executing (default): ALTER TABLE `teacher` CHANGE `state` `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying';
  20. Executing (default): SHOW INDEX FROM `teacher`
  21. yarn run v1.22.10
  22. $ cross-env NODE_ENV=production node server/index.js
  23. Executing (default): CREATE TABLE IF NOT EXISTS `user` (`id` INTEGER NOT NULL auto_increment , `name` VARCHAR(64) NOT NULL, `password` VARCHAR(512) NOT NULL, `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `photo` VARCHAR(512) NOT NULL DEFAULT '/image/default-photo.jpg', `role` ENUM('STUDENT', 'TEACHER', 'ADMIN') NOT NULL DEFAULT 'STUDENT', `signature` VARCHAR(512) NOT NULL DEFAULT '无', `createdTime` DATETIME NOT NULL, `isValid` TINYINT(1) NOT NULL DEFAULT true, UNIQUE `column` (`name`, `phone`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  24. Executing (default): CREATE TABLE IF NOT EXISTS `teacher` (`id` INTEGER NOT NULL auto_increment , `realName` VARCHAR(64) NOT NULL, `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学', `jobNumber` VARCHAR(64) NOT NULL, `certificate` VARCHAR(512) NOT NULL DEFAULT '', `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `uid` INTEGER NOT NULL, `createdTime` DATETIME NOT NULL, `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying', UNIQUE `column` (`phone`, `uid`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  25. Executing (default): CREATE TABLE IF NOT EXISTS `teacher` (`id` INTEGER NOT NULL auto_increment , `realName` VARCHAR(64) NOT NULL, `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学', `jobNumber` VARCHAR(64) NOT NULL, `certificate` VARCHAR(512) NOT NULL DEFAULT '', `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `uid` INTEGER NOT NULL, `createdTime` DATETIME NOT NULL, `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying', UNIQUE `column` (`phone`, `uid`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  26. Executing (default): SHOW FULL COLUMNS FROM `teacher`;
  27. Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'teacher' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='seec_portal' AND REFERENCED_TABLE_NAME IS NOT NULL;
  28. Executing (default): SHOW INDEX FROM `user`
  29. Executing (default): SHOW INDEX FROM `teacher`
  30. Executing (default): ALTER TABLE `teacher` CHANGE `realName` `realName` VARCHAR(64) NOT NULL;
  31. READY Server listening on http://0.0.0.0:3111
  32. Executing (default): ALTER TABLE `teacher` CHANGE `organization` `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学';
  33. Executing (default): ALTER TABLE `teacher` CHANGE `jobNumber` `jobNumber` VARCHAR(64) NOT NULL;
  34. Executing (default): ALTER TABLE `teacher` CHANGE `certificate` `certificate` VARCHAR(512) NOT NULL DEFAULT '';
  35. Executing (default): ALTER TABLE `teacher` CHANGE `phone` `phone` VARCHAR(64) NOT NULL;
  36. Executing (default): ALTER TABLE `teacher` CHANGE `email` `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com';
  37. Executing (default): ALTER TABLE `teacher` CHANGE `uid` `uid` INTEGER NOT NULL;
  38. Executing (default): ALTER TABLE `teacher` CHANGE `createdTime` `createdTime` DATETIME NOT NULL;
  39. Executing (default): ALTER TABLE `teacher` CHANGE `state` `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying';
  40. Executing (default): SHOW INDEX FROM `teacher`
  41. <-- GET /
  42. GET / - 4ms
  43. --> GET / 200 542ms -
  44. yarn run v1.22.10
  45. $ cross-env NODE_ENV=production node server/index.js
  46. Executing (default): CREATE TABLE IF NOT EXISTS `user` (`id` INTEGER NOT NULL auto_increment , `name` VARCHAR(64) NOT NULL, `password` VARCHAR(512) NOT NULL, `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `photo` VARCHAR(512) NOT NULL DEFAULT '/image/default-photo.jpg', `role` ENUM('STUDENT', 'TEACHER', 'ADMIN') NOT NULL DEFAULT 'STUDENT', `signature` VARCHAR(512) NOT NULL DEFAULT '无', `createdTime` DATETIME NOT NULL, `isValid` TINYINT(1) NOT NULL DEFAULT true, UNIQUE `column` (`name`, `phone`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  47. Executing (default): CREATE TABLE IF NOT EXISTS `teacher` (`id` INTEGER NOT NULL auto_increment , `realName` VARCHAR(64) NOT NULL, `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学', `jobNumber` VARCHAR(64) NOT NULL, `certificate` VARCHAR(512) NOT NULL DEFAULT '', `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `uid` INTEGER NOT NULL, `createdTime` DATETIME NOT NULL, `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying', UNIQUE `column` (`phone`, `uid`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  48. READY Server listening on http://0.0.0.0:3111
  49. Executing (default): CREATE TABLE IF NOT EXISTS `teacher` (`id` INTEGER NOT NULL auto_increment , `realName` VARCHAR(64) NOT NULL, `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学', `jobNumber` VARCHAR(64) NOT NULL, `certificate` VARCHAR(512) NOT NULL DEFAULT '', `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `uid` INTEGER NOT NULL, `createdTime` DATETIME NOT NULL, `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying', UNIQUE `column` (`phone`, `uid`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  50. Executing (default): SHOW INDEX FROM `user`
  51. Executing (default): SHOW INDEX FROM `teacher`
  52. Executing (default): SHOW FULL COLUMNS FROM `teacher`;
  53. Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'teacher' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='seec_portal' AND REFERENCED_TABLE_NAME IS NOT NULL;
  54. Executing (default): ALTER TABLE `teacher` CHANGE `realName` `realName` VARCHAR(64) NOT NULL;
  55. Executing (default): ALTER TABLE `teacher` CHANGE `organization` `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学';
  56. Executing (default): ALTER TABLE `teacher` CHANGE `jobNumber` `jobNumber` VARCHAR(64) NOT NULL;
  57. Executing (default): ALTER TABLE `teacher` CHANGE `certificate` `certificate` VARCHAR(512) NOT NULL DEFAULT '';
  58. Executing (default): ALTER TABLE `teacher` CHANGE `phone` `phone` VARCHAR(64) NOT NULL;
  59. Executing (default): ALTER TABLE `teacher` CHANGE `email` `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com';
  60. Executing (default): ALTER TABLE `teacher` CHANGE `uid` `uid` INTEGER NOT NULL;
  61. Executing (default): ALTER TABLE `teacher` CHANGE `createdTime` `createdTime` DATETIME NOT NULL;
  62. Executing (default): ALTER TABLE `teacher` CHANGE `state` `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying';
  63. Executing (default): SHOW INDEX FROM `teacher`
  64. yarn run v1.22.10
  65. $ cross-env NODE_ENV=production node server/index.js
  66. Executing (default): CREATE TABLE IF NOT EXISTS `user` (`id` INTEGER NOT NULL auto_increment , `name` VARCHAR(64) NOT NULL, `password` VARCHAR(512) NOT NULL, `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `photo` VARCHAR(512) NOT NULL DEFAULT '/image/default-photo.jpg', `role` ENUM('STUDENT', 'TEACHER', 'ADMIN') NOT NULL DEFAULT 'STUDENT', `signature` VARCHAR(512) NOT NULL DEFAULT '无', `createdTime` DATETIME NOT NULL, `isValid` TINYINT(1) NOT NULL DEFAULT true, UNIQUE `column` (`name`, `phone`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  67. Executing (default): CREATE TABLE IF NOT EXISTS `teacher` (`id` INTEGER NOT NULL auto_increment , `realName` VARCHAR(64) NOT NULL, `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学', `jobNumber` VARCHAR(64) NOT NULL, `certificate` VARCHAR(512) NOT NULL DEFAULT '', `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `uid` INTEGER NOT NULL, `createdTime` DATETIME NOT NULL, `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying', UNIQUE `column` (`phone`, `uid`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  68. READY Server listening on http://0.0.0.0:3111
  69. Executing (default): CREATE TABLE IF NOT EXISTS `teacher` (`id` INTEGER NOT NULL auto_increment , `realName` VARCHAR(64) NOT NULL, `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学', `jobNumber` VARCHAR(64) NOT NULL, `certificate` VARCHAR(512) NOT NULL DEFAULT '', `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `uid` INTEGER NOT NULL, `createdTime` DATETIME NOT NULL, `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying', UNIQUE `column` (`phone`, `uid`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  70. Executing (default): SHOW INDEX FROM `user`
  71. Executing (default): SHOW FULL COLUMNS FROM `teacher`;
  72. Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'teacher' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='seec_portal' AND REFERENCED_TABLE_NAME IS NOT NULL;
  73. Executing (default): SHOW INDEX FROM `teacher`
  74. Executing (default): ALTER TABLE `teacher` CHANGE `realName` `realName` VARCHAR(64) NOT NULL;
  75. Executing (default): ALTER TABLE `teacher` CHANGE `organization` `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学';
  76. Executing (default): ALTER TABLE `teacher` CHANGE `jobNumber` `jobNumber` VARCHAR(64) NOT NULL;
  77. Executing (default): ALTER TABLE `teacher` CHANGE `certificate` `certificate` VARCHAR(512) NOT NULL DEFAULT '';
  78. Executing (default): ALTER TABLE `teacher` CHANGE `phone` `phone` VARCHAR(64) NOT NULL;
  79. Executing (default): ALTER TABLE `teacher` CHANGE `email` `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com';
  80. Executing (default): ALTER TABLE `teacher` CHANGE `uid` `uid` INTEGER NOT NULL;
  81. Executing (default): ALTER TABLE `teacher` CHANGE `createdTime` `createdTime` DATETIME NOT NULL;
  82. Executing (default): ALTER TABLE `teacher` CHANGE `state` `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying';
  83. Executing (default): SHOW INDEX FROM `teacher`
  84. yarn run v1.22.10
  85. $ cross-env NODE_ENV=production node server/index.js
  86. Executing (default): CREATE TABLE IF NOT EXISTS `user` (`id` INTEGER NOT NULL auto_increment , `name` VARCHAR(64) NOT NULL, `password` VARCHAR(512) NOT NULL, `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `photo` VARCHAR(512) NOT NULL DEFAULT '/image/default-photo.jpg', `role` ENUM('STUDENT', 'TEACHER', 'ADMIN') NOT NULL DEFAULT 'STUDENT', `signature` VARCHAR(512) NOT NULL DEFAULT '无', `createdTime` DATETIME NOT NULL, `isValid` TINYINT(1) NOT NULL DEFAULT true, UNIQUE `column` (`name`, `phone`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  87. Executing (default): CREATE TABLE IF NOT EXISTS `teacher` (`id` INTEGER NOT NULL auto_increment , `realName` VARCHAR(64) NOT NULL, `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学', `jobNumber` VARCHAR(64) NOT NULL, `certificate` VARCHAR(512) NOT NULL DEFAULT '', `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `uid` INTEGER NOT NULL, `createdTime` DATETIME NOT NULL, `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying', UNIQUE `column` (`phone`, `uid`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  88. Executing (default): CREATE TABLE IF NOT EXISTS `teacher` (`id` INTEGER NOT NULL auto_increment , `realName` VARCHAR(64) NOT NULL, `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学', `jobNumber` VARCHAR(64) NOT NULL, `certificate` VARCHAR(512) NOT NULL DEFAULT '', `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `uid` INTEGER NOT NULL, `createdTime` DATETIME NOT NULL, `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying', UNIQUE `column` (`phone`, `uid`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  89. Executing (default): SHOW INDEX FROM `user`
  90. Executing (default): SHOW FULL COLUMNS FROM `teacher`;
  91. Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'teacher' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='seec_portal' AND REFERENCED_TABLE_NAME IS NOT NULL;
  92. Executing (default): SHOW INDEX FROM `teacher`
  93. Executing (default): ALTER TABLE `teacher` CHANGE `realName` `realName` VARCHAR(64) NOT NULL;
  94. READY Server listening on http://0.0.0.0:3111
  95. Executing (default): ALTER TABLE `teacher` CHANGE `organization` `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学';
  96. Executing (default): ALTER TABLE `teacher` CHANGE `jobNumber` `jobNumber` VARCHAR(64) NOT NULL;
  97. Executing (default): ALTER TABLE `teacher` CHANGE `certificate` `certificate` VARCHAR(512) NOT NULL DEFAULT '';
  98. Executing (default): ALTER TABLE `teacher` CHANGE `phone` `phone` VARCHAR(64) NOT NULL;
  99. Executing (default): ALTER TABLE `teacher` CHANGE `email` `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com';
  100. Executing (default): ALTER TABLE `teacher` CHANGE `uid` `uid` INTEGER NOT NULL;
  101. Executing (default): ALTER TABLE `teacher` CHANGE `createdTime` `createdTime` DATETIME NOT NULL;
  102. Executing (default): ALTER TABLE `teacher` CHANGE `state` `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying';
  103. Executing (default): SHOW INDEX FROM `teacher`
  104. <-- GET /
  105. GET / - 4ms
  106. --> GET / 200 542ms -
  107. <-- GET /
  108. GET / - 4ms
  109. --> GET / 200 29ms -
  110. <-- GET /
  111. GET / - 1ms
  112. --> GET / 200 30ms -
  113. <-- GET /_nuxt/bb64a5729f90a8f564f7.js
  114. <-- GET /_nuxt/bfcec24674531c1484bb.js
  115. GET /_nuxt/bb64a5729f90a8f564f7.js - 0ms
  116. GET /_nuxt/bfcec24674531c1484bb.js - 1ms
  117. --> GET /_nuxt/bb64a5729f90a8f564f7.js 200 10ms -
  118. <-- GET /_nuxt/08766fb18dd214448b96.js
  119. GET /_nuxt/08766fb18dd214448b96.js - 0ms
  120. <-- GET /_nuxt/339ae51fb65d58bdaa11.js
  121. <-- GET /_nuxt/74dd1110036b9c753556.js
  122. GET /_nuxt/339ae51fb65d58bdaa11.js - 0ms
  123. GET /_nuxt/74dd1110036b9c753556.js - 0ms
  124. --> GET /_nuxt/74dd1110036b9c753556.js 200 6ms -
  125. --> GET /_nuxt/339ae51fb65d58bdaa11.js 200 8ms -
  126. --> GET /_nuxt/bfcec24674531c1484bb.js 200 23ms -
  127. <-- GET /image/seec-logo--full.png
  128. GET /image/seec-logo--full.png - 0ms
  129. <-- GET /image/SEEC_banner3.png
  130. GET /image/SEEC_banner3.png - 0ms
  131. --> GET /image/seec-logo--full.png 200 5ms -
  132. --> GET /image/SEEC_banner3.png 200 7ms -
  133. <-- GET /image/java.png
  134. GET /image/java.png - 0ms
  135. --> GET /image/java.png 200 2ms -
  136. <-- GET /image/SE1.png
  137. GET /image/SE1.png - 0ms
  138. --> GET /image/SE1.png 200 3ms -
  139. <-- GET /image/SE2.png
  140. GET /image/SE2.png - 0ms
  141. --> GET /image/SE2.png 200 7ms -
  142. --> GET /_nuxt/08766fb18dd214448b96.js 200 107ms -
  143. <-- GET /_nuxt/fonts/535877f.woff
  144. GET /_nuxt/fonts/535877f.woff - 0ms
  145. --> GET /_nuxt/fonts/535877f.woff 200 3ms -
  146. <-- GET /image/deep_learning.png
  147. GET /image/deep_learning.png - 0ms
  148. --> GET /image/deep_learning.png 200 11ms -
  149. <-- GET /image/JVM.jpg
  150. <-- GET /image/block_chain.jpg
  151. GET /image/JVM.jpg - 0ms
  152. GET /image/block_chain.jpg - 1ms
  153. --> GET /image/block_chain.jpg 200 3ms -
  154. --> GET /image/JVM.jpg 200 4ms -
  155. <-- GET /image/zhihu_icon.jpg
  156. GET /image/zhihu_icon.jpg - 0ms
  157. --> GET /image/zhihu_icon.jpg 200 3ms -
  158. <-- GET /image/bilibili_icon.jpg
  159. GET /image/bilibili_icon.jpg - 0ms
  160. --> GET /image/bilibili_icon.jpg 200 2ms -
  161. <-- GET /seec.ico
  162. GET /seec.ico - 0ms
  163. --> GET /seec.ico 200 6ms -
  164. yarn run v1.22.10
  165. $ cross-env NODE_ENV=production node server/index.js
  166. Executing (default): CREATE TABLE IF NOT EXISTS `user` (`id` INTEGER NOT NULL auto_increment , `name` VARCHAR(64) NOT NULL, `password` VARCHAR(512) NOT NULL, `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `photo` VARCHAR(512) NOT NULL DEFAULT '/image/default-photo.jpg', `role` ENUM('STUDENT', 'TEACHER', 'ADMIN') NOT NULL DEFAULT 'STUDENT', `signature` VARCHAR(512) NOT NULL DEFAULT '无', `createdTime` DATETIME NOT NULL, `isValid` TINYINT(1) NOT NULL DEFAULT true, UNIQUE `column` (`name`, `phone`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  167. Executing (default): CREATE TABLE IF NOT EXISTS `teacher` (`id` INTEGER NOT NULL auto_increment , `realName` VARCHAR(64) NOT NULL, `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学', `jobNumber` VARCHAR(64) NOT NULL, `certificate` VARCHAR(512) NOT NULL DEFAULT '', `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `uid` INTEGER NOT NULL, `createdTime` DATETIME NOT NULL, `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying', UNIQUE `column` (`phone`, `uid`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  168. Executing (default): CREATE TABLE IF NOT EXISTS `teacher` (`id` INTEGER NOT NULL auto_increment , `realName` VARCHAR(64) NOT NULL, `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学', `jobNumber` VARCHAR(64) NOT NULL, `certificate` VARCHAR(512) NOT NULL DEFAULT '', `phone` VARCHAR(64) NOT NULL, `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com', `uid` INTEGER NOT NULL, `createdTime` DATETIME NOT NULL, `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying', UNIQUE `column` (`phone`, `uid`), PRIMARY KEY (`id`)) ENGINE=InnoDB;
  169. Executing (default): SHOW INDEX FROM `user`
  170. Executing (default): SHOW INDEX FROM `teacher`
  171. Executing (default): SHOW FULL COLUMNS FROM `teacher`;
  172. Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'teacher' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='seec_portal' AND REFERENCED_TABLE_NAME IS NOT NULL;
  173. Executing (default): ALTER TABLE `teacher` CHANGE `realName` `realName` VARCHAR(64) NOT NULL;
  174. READY Server listening on http://0.0.0.0:3111
  175. Executing (default): ALTER TABLE `teacher` CHANGE `organization` `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学';
  176. Executing (default): ALTER TABLE `teacher` CHANGE `jobNumber` `jobNumber` VARCHAR(64) NOT NULL;
  177. Executing (default): ALTER TABLE `teacher` CHANGE `certificate` `certificate` VARCHAR(512) NOT NULL DEFAULT '';
  178. Executing (default): ALTER TABLE `teacher` CHANGE `phone` `phone` VARCHAR(64) NOT NULL;
  179. Executing (default): ALTER TABLE `teacher` CHANGE `email` `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com';
  180. Executing (default): ALTER TABLE `teacher` CHANGE `uid` `uid` INTEGER NOT NULL;
  181. Executing (default): ALTER TABLE `teacher` CHANGE `createdTime` `createdTime` DATETIME NOT NULL;
  182. Executing (default): ALTER TABLE `teacher` CHANGE `state` `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying';
  183. Executing (default): SHOW INDEX FROM `teacher`
  184. <-- GET /
  185. GET / - 4ms
  186. --> GET / 200 545ms -
  187. <-- GET /
  188. GET / - 1ms
  189. --> GET / 200 35ms -
  190. <-- GET /_nuxt/bb64a5729f90a8f564f7.js
  191. <-- GET /_nuxt/bfcec24674531c1484bb.js
  192. <-- GET /_nuxt/339ae51fb65d58bdaa11.js
  193. <-- GET /_nuxt/08766fb18dd214448b96.js
  194. <-- GET /_nuxt/74dd1110036b9c753556.js
  195. GET /_nuxt/bb64a5729f90a8f564f7.js - 0ms
  196. GET /_nuxt/bfcec24674531c1484bb.js - 0ms
  197. GET /_nuxt/339ae51fb65d58bdaa11.js - 0ms
  198. GET /_nuxt/08766fb18dd214448b96.js - 1ms
  199. GET /_nuxt/74dd1110036b9c753556.js - 1ms
  200. <-- GET /_nuxt/fonts/535877f.woff
  201. --> GET /_nuxt/bb64a5729f90a8f564f7.js 200 17ms -
  202. GET /_nuxt/fonts/535877f.woff - 1ms
  203. --> GET /_nuxt/74dd1110036b9c753556.js 200 16ms -
  204. --> GET /_nuxt/339ae51fb65d58bdaa11.js 200 20ms -
  205. --> GET /_nuxt/fonts/535877f.woff 200 7ms -
  206. --> GET /_nuxt/bfcec24674531c1484bb.js 200 28ms -
  207. <-- GET /image/SEEC_banner3.png
  208. <-- GET /image/java.png
  209. GET /image/SEEC_banner3.png - 0ms
  210. GET /image/java.png - 0ms
  211. <-- GET /image/deep_learning.png
  212. <-- GET /image/JVM.jpg
  213. GET /image/deep_learning.png - 1ms
  214. GET /image/JVM.jpg - 0ms
  215. --> GET /image/JVM.jpg 200 3ms -
  216. <-- GET /image/block_chain.jpg
  217. GET /image/block_chain.jpg - 0ms
  218. --> GET /image/block_chain.jpg 200 3ms -
  219. <-- GET /image/seec-logo--full.png
  220. GET /image/seec-logo--full.png - 0ms
  221. --> GET /image/seec-logo--full.png 200 2ms -
  222. <-- GET /image/SE2.png
  223. GET /image/SE2.png - 1ms
  224. --> GET /image/SEEC_banner3.png 200 125ms -
  225. <-- GET /image/SE1.png
  226. --> GET /image/java.png 200 126ms -
  227. GET /image/SE1.png - 1ms
  228. --> GET /image/SE1.png 200 3ms -
  229. --> GET /_nuxt/08766fb18dd214448b96.js 200 351ms -
  230. --> GET /image/deep_learning.png 200 383ms -
  231. --> GET /image/SE2.png 200 345ms -
  232. <-- GET /image/zhihu_icon.jpg
  233. GET /image/zhihu_icon.jpg - 0ms
  234. <-- GET /image/bilibili_icon.jpg
  235. --> GET /image/zhihu_icon.jpg 200 3ms -
  236. GET /image/bilibili_icon.jpg - 0ms
  237. --> GET /image/bilibili_icon.jpg 200 2ms -
  238. <-- GET /seec.ico
  239. GET /seec.ico - 0ms
  240. --> GET /seec.ico 200 2ms -
  241. <-- GET /
  242. GET / - 0ms
  243. --> GET / 304 20ms
  244. <-- GET /seec.ico
  245. <-- GET /image/seec-logo--full.png
  246. <-- GET /image/java.png
  247. GET /seec.ico - 1ms
  248. GET /image/seec-logo--full.png - 0ms
  249. <-- GET /image/SE1.png
  250. <-- GET /image/SEEC_banner3.png
  251. <-- GET /image/JVM.jpg
  252. GET /image/java.png - 0ms
  253. --> GET /seec.ico 304 6ms
  254. --> GET /image/seec-logo--full.png 304 5ms
  255. --> GET /image/java.png 304 5ms
  256. GET /image/SE1.png - 1ms
  257. GET /image/SEEC_banner3.png - 0ms
  258. GET /image/JVM.jpg - 2ms
  259. --> GET /image/SE1.png 304 7ms
  260. --> GET /image/SEEC_banner3.png 304 7ms
  261. --> GET /image/JVM.jpg 304 7ms
  262. <-- GET /image/zhihu_icon.jpg
  263. <-- GET /image/block_chain.jpg
  264. GET /image/zhihu_icon.jpg - 0ms
  265. <-- GET /image/SE2.png
  266. <-- GET /image/bilibili_icon.jpg
  267. <-- GET /image/deep_learning.png
  268. GET /image/block_chain.jpg - 0ms
  269. --> GET /image/zhihu_icon.jpg 304 4ms
  270. --> GET /image/block_chain.jpg 304 3ms
  271. GET /image/SE2.png - 0ms
  272. GET /image/bilibili_icon.jpg - 0ms
  273. GET /image/deep_learning.png - 1ms
  274. --> GET /image/SE2.png 304 4ms
  275. --> GET /image/bilibili_icon.jpg 304 4ms
  276. --> GET /image/deep_learning.png 304 4ms