blob: a27b516321ac40aabd522f08d911559a6a832d59 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
CREATE TABLE "knox"."approval" (
"ap_inf_id" text PRIMARY KEY NOT NULL,
"user_id" text NOT NULL,
"ep_id" text NOT NULL,
"email_address" text NOT NULL,
"subject" text NOT NULL,
"content" text NOT NULL,
"status" text NOT NULL,
"aplns" jsonb NOT NULL,
"is_deleted" boolean DEFAULT false NOT NULL,
"created_at" timestamp DEFAULT now() NOT NULL,
"updated_at" timestamp DEFAULT now() NOT NULL
);
--> statement-breakpoint
ALTER TABLE "users" ADD COLUMN "epId" varchar(50);
|
