| 提交 | 用户 | 时间 | ||
| e7c126 | 1 | -- 将该建表 SQL 语句，添加到 iailab-module-infra-biz 模块的 test/resources/sql/create_tables.sql 文件里 |
| H | 2 | CREATE TABLE IF NOT EXISTS "infra_student" ( |
| 3 | "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY, | |
| 4 | "name" varchar NOT NULL, | |
| 5 | "description" varchar NOT NULL, | |
| 6 | "birthday" varchar NOT NULL, | |
| 7 | "sex" int NOT NULL, | |
| 8 | "enabled" bit NOT NULL, | |
| 9 | "avatar" varchar NOT NULL, | |
| 10 | "video" varchar NOT NULL, | |
| 11 | "memo" varchar NOT NULL, | |
| 12 | "create_time" datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| 13 | PRIMARY KEY ("id") | |
| 14 | ) COMMENT '学生表'; | |
| 15 | ||
| 16 | -- 将该删表 SQL 语句，添加到 iailab-module-infra-biz 模块的 test/resources/sql/clean.sql 文件里 | |
| 17 | DELETE FROM "infra_student"; | |
