h2 469 B

12345678910
  1. -- 将该建表 SQL 语句,添加到 jt-module-infra-biz 模块的 test/resources/sql/create_tables.sql 文件里
  2. CREATE TABLE IF NOT EXISTS "infra_category" (
  3. "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
  4. "name" varchar NOT NULL,
  5. "description" bigint NOT NULL,
  6. PRIMARY KEY ("id")
  7. ) COMMENT '分类表';
  8. -- 将该删表 SQL 语句,添加到 jt-module-infra-biz 模块的 test/resources/sql/clean.sql 文件里
  9. DELETE FROM "infra_category";