| 提交 | 用户 | 时间 | ||
| e7c126 | 1 | CREATE TABLE IF NOT EXISTS "bpm_user_group" ( |
| H | 2 | "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY, |
| 3 | "name" varchar(63) NOT NULL, | |
| 4 | "description" varchar(255) NOT NULL, | |
| 5 | "status" tinyint NOT NULL, | |
| 6 | "user_ids" varchar(255) NOT NULL, | |
| 7 | "creator" varchar(64) DEFAULT '', | |
| 8 | "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| 9 | "updater" varchar(64) DEFAULT '', | |
| 10 | "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| 11 | "deleted" bit NOT NULL DEFAULT FALSE, | |
| 12 | PRIMARY KEY ("id") | |
| 13 | ) COMMENT '用户组'; | |
| 14 | ||
| 15 | CREATE TABLE IF NOT EXISTS "bpm_category" ( | |
| 16 | "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY, | |
| 17 | "name" varchar(63) NOT NULL, | |
| 18 | "code" varchar(63) NOT NULL, | |
| 19 | "description" varchar(255) NOT NULL, | |
| 20 | "status" tinyint NOT NULL, | |
| 21 | "sort" int NOT NULL, | |
| 22 | "creator" varchar(64) DEFAULT '', | |
| 23 | "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| 24 | "updater" varchar(64) DEFAULT '', | |
| 25 | "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| 26 | "deleted" bit NOT NULL DEFAULT FALSE, | |
| 27 | PRIMARY KEY ("id") | |
| 28 | ) COMMENT '分类'; | |
| 29 | ||
| 30 | CREATE TABLE IF NOT EXISTS "bpm_form" ( | |
| 31 | "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY, | |
| 32 | "name" varchar(63) NOT NULL, | |
| 33 | "status" tinyint NOT NULL, | |
| 34 | "fields" varchar(255) NOT NULL, | |
| 35 | "conf" varchar(255) NOT NULL, | |
| 36 | "remark" varchar(255), | |
| 37 | "creator" varchar(64) DEFAULT '', | |
| 38 | "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| 39 | "updater" varchar(64) DEFAULT '', | |
| 40 | "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| 41 | "deleted" bit NOT NULL DEFAULT FALSE, | |
| 42 | PRIMARY KEY ("id") | |
| 43 | ) COMMENT '动态表单'; | |
