| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288 |
- yarn run v1.22.10
- $ cross-env NODE_ENV=production node server/index.js
- 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;
- 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;
- 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;
- Executing (default): SHOW INDEX FROM `user`
- Executing (default): SHOW INDEX FROM `teacher`
- Executing (default): SHOW FULL COLUMNS FROM `teacher`;
- 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;
- Executing (default): ALTER TABLE `teacher` CHANGE `realName` `realName` VARCHAR(64) NOT NULL;
- READY Server listening on http://0.0.0.0:3111
- Executing (default): ALTER TABLE `teacher` CHANGE `organization` `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学';
- Executing (default): ALTER TABLE `teacher` CHANGE `jobNumber` `jobNumber` VARCHAR(64) NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `certificate` `certificate` VARCHAR(512) NOT NULL DEFAULT '';
- Executing (default): ALTER TABLE `teacher` CHANGE `phone` `phone` VARCHAR(64) NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `email` `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com';
- Executing (default): ALTER TABLE `teacher` CHANGE `uid` `uid` INTEGER NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `createdTime` `createdTime` DATETIME NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `state` `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying';
- Executing (default): SHOW INDEX FROM `teacher`
- yarn run v1.22.10
- $ cross-env NODE_ENV=production node server/index.js
- 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;
- 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;
- 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;
- Executing (default): SHOW FULL COLUMNS FROM `teacher`;
- 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;
- Executing (default): SHOW INDEX FROM `user`
- Executing (default): SHOW INDEX FROM `teacher`
- Executing (default): ALTER TABLE `teacher` CHANGE `realName` `realName` VARCHAR(64) NOT NULL;
- READY Server listening on http://0.0.0.0:3111
- Executing (default): ALTER TABLE `teacher` CHANGE `organization` `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学';
- Executing (default): ALTER TABLE `teacher` CHANGE `jobNumber` `jobNumber` VARCHAR(64) NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `certificate` `certificate` VARCHAR(512) NOT NULL DEFAULT '';
- Executing (default): ALTER TABLE `teacher` CHANGE `phone` `phone` VARCHAR(64) NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `email` `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com';
- Executing (default): ALTER TABLE `teacher` CHANGE `uid` `uid` INTEGER NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `createdTime` `createdTime` DATETIME NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `state` `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying';
- Executing (default): SHOW INDEX FROM `teacher`
- <-- GET /
- GET / - 4ms
- --> GET / 200 542ms -
- yarn run v1.22.10
- $ cross-env NODE_ENV=production node server/index.js
- 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;
- 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;
- READY Server listening on http://0.0.0.0:3111
- 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;
- Executing (default): SHOW INDEX FROM `user`
- Executing (default): SHOW INDEX FROM `teacher`
- Executing (default): SHOW FULL COLUMNS FROM `teacher`;
- 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;
- Executing (default): ALTER TABLE `teacher` CHANGE `realName` `realName` VARCHAR(64) NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `organization` `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学';
- Executing (default): ALTER TABLE `teacher` CHANGE `jobNumber` `jobNumber` VARCHAR(64) NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `certificate` `certificate` VARCHAR(512) NOT NULL DEFAULT '';
- Executing (default): ALTER TABLE `teacher` CHANGE `phone` `phone` VARCHAR(64) NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `email` `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com';
- Executing (default): ALTER TABLE `teacher` CHANGE `uid` `uid` INTEGER NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `createdTime` `createdTime` DATETIME NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `state` `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying';
- Executing (default): SHOW INDEX FROM `teacher`
- yarn run v1.22.10
- $ cross-env NODE_ENV=production node server/index.js
- 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;
- 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;
- READY Server listening on http://0.0.0.0:3111
- 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;
- Executing (default): SHOW INDEX FROM `user`
- Executing (default): SHOW FULL COLUMNS FROM `teacher`;
- 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;
- Executing (default): SHOW INDEX FROM `teacher`
- Executing (default): ALTER TABLE `teacher` CHANGE `realName` `realName` VARCHAR(64) NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `organization` `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学';
- Executing (default): ALTER TABLE `teacher` CHANGE `jobNumber` `jobNumber` VARCHAR(64) NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `certificate` `certificate` VARCHAR(512) NOT NULL DEFAULT '';
- Executing (default): ALTER TABLE `teacher` CHANGE `phone` `phone` VARCHAR(64) NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `email` `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com';
- Executing (default): ALTER TABLE `teacher` CHANGE `uid` `uid` INTEGER NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `createdTime` `createdTime` DATETIME NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `state` `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying';
- Executing (default): SHOW INDEX FROM `teacher`
- yarn run v1.22.10
- $ cross-env NODE_ENV=production node server/index.js
- 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;
- 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;
- 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;
- Executing (default): SHOW INDEX FROM `user`
- Executing (default): SHOW FULL COLUMNS FROM `teacher`;
- 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;
- Executing (default): SHOW INDEX FROM `teacher`
- Executing (default): ALTER TABLE `teacher` CHANGE `realName` `realName` VARCHAR(64) NOT NULL;
- READY Server listening on http://0.0.0.0:3111
- Executing (default): ALTER TABLE `teacher` CHANGE `organization` `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学';
- Executing (default): ALTER TABLE `teacher` CHANGE `jobNumber` `jobNumber` VARCHAR(64) NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `certificate` `certificate` VARCHAR(512) NOT NULL DEFAULT '';
- Executing (default): ALTER TABLE `teacher` CHANGE `phone` `phone` VARCHAR(64) NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `email` `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com';
- Executing (default): ALTER TABLE `teacher` CHANGE `uid` `uid` INTEGER NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `createdTime` `createdTime` DATETIME NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `state` `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying';
- Executing (default): SHOW INDEX FROM `teacher`
- <-- GET /
- GET / - 4ms
- --> GET / 200 542ms -
- <-- GET /
- GET / - 4ms
- --> GET / 200 29ms -
- <-- GET /
- GET / - 1ms
- --> GET / 200 30ms -
- <-- GET /_nuxt/bb64a5729f90a8f564f7.js
- <-- GET /_nuxt/bfcec24674531c1484bb.js
- GET /_nuxt/bb64a5729f90a8f564f7.js - 0ms
- GET /_nuxt/bfcec24674531c1484bb.js - 1ms
- --> GET /_nuxt/bb64a5729f90a8f564f7.js 200 10ms -
- <-- GET /_nuxt/08766fb18dd214448b96.js
- GET /_nuxt/08766fb18dd214448b96.js - 0ms
- <-- GET /_nuxt/339ae51fb65d58bdaa11.js
- <-- GET /_nuxt/74dd1110036b9c753556.js
- GET /_nuxt/339ae51fb65d58bdaa11.js - 0ms
- GET /_nuxt/74dd1110036b9c753556.js - 0ms
- --> GET /_nuxt/74dd1110036b9c753556.js 200 6ms -
- --> GET /_nuxt/339ae51fb65d58bdaa11.js 200 8ms -
- --> GET /_nuxt/bfcec24674531c1484bb.js 200 23ms -
- <-- GET /image/seec-logo--full.png
- GET /image/seec-logo--full.png - 0ms
- <-- GET /image/SEEC_banner3.png
- GET /image/SEEC_banner3.png - 0ms
- --> GET /image/seec-logo--full.png 200 5ms -
- --> GET /image/SEEC_banner3.png 200 7ms -
- <-- GET /image/java.png
- GET /image/java.png - 0ms
- --> GET /image/java.png 200 2ms -
- <-- GET /image/SE1.png
- GET /image/SE1.png - 0ms
- --> GET /image/SE1.png 200 3ms -
- <-- GET /image/SE2.png
- GET /image/SE2.png - 0ms
- --> GET /image/SE2.png 200 7ms -
- --> GET /_nuxt/08766fb18dd214448b96.js 200 107ms -
- <-- GET /_nuxt/fonts/535877f.woff
- GET /_nuxt/fonts/535877f.woff - 0ms
- --> GET /_nuxt/fonts/535877f.woff 200 3ms -
- <-- GET /image/deep_learning.png
- GET /image/deep_learning.png - 0ms
- --> GET /image/deep_learning.png 200 11ms -
- <-- GET /image/JVM.jpg
- <-- GET /image/block_chain.jpg
- GET /image/JVM.jpg - 0ms
- GET /image/block_chain.jpg - 1ms
- --> GET /image/block_chain.jpg 200 3ms -
- --> GET /image/JVM.jpg 200 4ms -
- <-- GET /image/zhihu_icon.jpg
- GET /image/zhihu_icon.jpg - 0ms
- --> GET /image/zhihu_icon.jpg 200 3ms -
- <-- GET /image/bilibili_icon.jpg
- GET /image/bilibili_icon.jpg - 0ms
- --> GET /image/bilibili_icon.jpg 200 2ms -
- <-- GET /seec.ico
- GET /seec.ico - 0ms
- --> GET /seec.ico 200 6ms -
- yarn run v1.22.10
- $ cross-env NODE_ENV=production node server/index.js
- 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;
- 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;
- 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;
- Executing (default): SHOW INDEX FROM `user`
- Executing (default): SHOW INDEX FROM `teacher`
- Executing (default): SHOW FULL COLUMNS FROM `teacher`;
- 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;
- Executing (default): ALTER TABLE `teacher` CHANGE `realName` `realName` VARCHAR(64) NOT NULL;
- READY Server listening on http://0.0.0.0:3111
- Executing (default): ALTER TABLE `teacher` CHANGE `organization` `organization` VARCHAR(64) NOT NULL DEFAULT '南京大学';
- Executing (default): ALTER TABLE `teacher` CHANGE `jobNumber` `jobNumber` VARCHAR(64) NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `certificate` `certificate` VARCHAR(512) NOT NULL DEFAULT '';
- Executing (default): ALTER TABLE `teacher` CHANGE `phone` `phone` VARCHAR(64) NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `email` `email` VARCHAR(512) NOT NULL DEFAULT 'xxxxx@xxx.com';
- Executing (default): ALTER TABLE `teacher` CHANGE `uid` `uid` INTEGER NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `createdTime` `createdTime` DATETIME NOT NULL;
- Executing (default): ALTER TABLE `teacher` CHANGE `state` `state` ENUM('identifying', 'identified', 'rejected') NOT NULL DEFAULT 'identifying';
- Executing (default): SHOW INDEX FROM `teacher`
- <-- GET /
- GET / - 4ms
- --> GET / 200 545ms -
- <-- GET /
- GET / - 1ms
- --> GET / 200 35ms -
- <-- GET /_nuxt/bb64a5729f90a8f564f7.js
- <-- GET /_nuxt/bfcec24674531c1484bb.js
- <-- GET /_nuxt/339ae51fb65d58bdaa11.js
- <-- GET /_nuxt/08766fb18dd214448b96.js
- <-- GET /_nuxt/74dd1110036b9c753556.js
- GET /_nuxt/bb64a5729f90a8f564f7.js - 0ms
- GET /_nuxt/bfcec24674531c1484bb.js - 0ms
- GET /_nuxt/339ae51fb65d58bdaa11.js - 0ms
- GET /_nuxt/08766fb18dd214448b96.js - 1ms
- GET /_nuxt/74dd1110036b9c753556.js - 1ms
- <-- GET /_nuxt/fonts/535877f.woff
- --> GET /_nuxt/bb64a5729f90a8f564f7.js 200 17ms -
- GET /_nuxt/fonts/535877f.woff - 1ms
- --> GET /_nuxt/74dd1110036b9c753556.js 200 16ms -
- --> GET /_nuxt/339ae51fb65d58bdaa11.js 200 20ms -
- --> GET /_nuxt/fonts/535877f.woff 200 7ms -
- --> GET /_nuxt/bfcec24674531c1484bb.js 200 28ms -
- <-- GET /image/SEEC_banner3.png
- <-- GET /image/java.png
- GET /image/SEEC_banner3.png - 0ms
- GET /image/java.png - 0ms
- <-- GET /image/deep_learning.png
- <-- GET /image/JVM.jpg
- GET /image/deep_learning.png - 1ms
- GET /image/JVM.jpg - 0ms
- --> GET /image/JVM.jpg 200 3ms -
- <-- GET /image/block_chain.jpg
- GET /image/block_chain.jpg - 0ms
- --> GET /image/block_chain.jpg 200 3ms -
- <-- GET /image/seec-logo--full.png
- GET /image/seec-logo--full.png - 0ms
- --> GET /image/seec-logo--full.png 200 2ms -
- <-- GET /image/SE2.png
- GET /image/SE2.png - 1ms
- --> GET /image/SEEC_banner3.png 200 125ms -
- <-- GET /image/SE1.png
- --> GET /image/java.png 200 126ms -
- GET /image/SE1.png - 1ms
- --> GET /image/SE1.png 200 3ms -
- --> GET /_nuxt/08766fb18dd214448b96.js 200 351ms -
- --> GET /image/deep_learning.png 200 383ms -
- --> GET /image/SE2.png 200 345ms -
- <-- GET /image/zhihu_icon.jpg
- GET /image/zhihu_icon.jpg - 0ms
- <-- GET /image/bilibili_icon.jpg
- --> GET /image/zhihu_icon.jpg 200 3ms -
- GET /image/bilibili_icon.jpg - 0ms
- --> GET /image/bilibili_icon.jpg 200 2ms -
- <-- GET /seec.ico
- GET /seec.ico - 0ms
- --> GET /seec.ico 200 2ms -
- <-- GET /
- GET / - 0ms
- --> GET / 304 20ms
- <-- GET /seec.ico
- <-- GET /image/seec-logo--full.png
- <-- GET /image/java.png
- GET /seec.ico - 1ms
- GET /image/seec-logo--full.png - 0ms
- <-- GET /image/SE1.png
- <-- GET /image/SEEC_banner3.png
- <-- GET /image/JVM.jpg
- GET /image/java.png - 0ms
- --> GET /seec.ico 304 6ms
- --> GET /image/seec-logo--full.png 304 5ms
- --> GET /image/java.png 304 5ms
- GET /image/SE1.png - 1ms
- GET /image/SEEC_banner3.png - 0ms
- GET /image/JVM.jpg - 2ms
- --> GET /image/SE1.png 304 7ms
- --> GET /image/SEEC_banner3.png 304 7ms
- --> GET /image/JVM.jpg 304 7ms
- <-- GET /image/zhihu_icon.jpg
- <-- GET /image/block_chain.jpg
- GET /image/zhihu_icon.jpg - 0ms
- <-- GET /image/SE2.png
- <-- GET /image/bilibili_icon.jpg
- <-- GET /image/deep_learning.png
- GET /image/block_chain.jpg - 0ms
- --> GET /image/zhihu_icon.jpg 304 4ms
- --> GET /image/block_chain.jpg 304 3ms
- GET /image/SE2.png - 0ms
- GET /image/bilibili_icon.jpg - 0ms
- GET /image/deep_learning.png - 1ms
- --> GET /image/SE2.png 304 4ms
- --> GET /image/bilibili_icon.jpg 304 4ms
- --> GET /image/deep_learning.png 304 4ms
|