| | |
| | | ADD COLUMN `ip` varchar(30) NULL, |
| | | ADD COLUMN `mac` varchar(40) NULL; |
| | | |
| | | CREATE TABLE `swspkmas`.`tr_cert` ( |
| | | CREATE TABLE `swspkmas`.`th_cert` ( |
| | | `id` bigint NOT NULL AUTO_INCREMENT, |
| | | `uuid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, |
| | | `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, |
| | |
| | | CREATE TABLE `swspkmas`.`th_question_bank` ( |
| | | `id` bigint NOT NULL AUTO_INCREMENT, |
| | | `uuid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, |
| | | `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, |
| | | `institution_id` bigint NOT NULL, |
| | | `institution_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, |
| | | `total_count` int NOT NULL COMMENT '题库题目总数量', |