blob: 5167bc68b0bc4cdf55e7e06ec7b9a8ae30c57c12 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
ALTER TABLE "rfq_last_vendor_responses" ALTER COLUMN "status" SET DEFAULT '대기중';--> statement-breakpoint
ALTER TABLE "rfq_last_vendor_responses" ADD COLUMN "participation_status" varchar(20) DEFAULT '미응답' NOT NULL;--> statement-breakpoint
ALTER TABLE "rfq_last_vendor_responses" ADD COLUMN "participation_replied_at" timestamp;--> statement-breakpoint
ALTER TABLE "rfq_last_vendor_responses" ADD COLUMN "participation_replied_by" integer;--> statement-breakpoint
ALTER TABLE "rfq_last_vendor_responses" ADD COLUMN "non_participation_reason" text;--> statement-breakpoint
ALTER TABLE "knox"."approval_logs" ADD COLUMN "contents_type" text DEFAULT 'HTML' NOT NULL;--> statement-breakpoint
ALTER TABLE "knox"."approval_logs" ADD COLUMN "sbm_dt" text;--> statement-breakpoint
ALTER TABLE "knox"."approval_logs" ADD COLUMN "sbm_lang" text DEFAULT 'ko' NOT NULL;--> statement-breakpoint
ALTER TABLE "knox"."approval_logs" ADD COLUMN "notify_option" text DEFAULT '0' NOT NULL;--> statement-breakpoint
ALTER TABLE "knox"."approval_logs" ADD COLUMN "urg_yn" text DEFAULT 'N' NOT NULL;--> statement-breakpoint
ALTER TABLE "knox"."approval_logs" ADD COLUMN "doc_secu_type" text DEFAULT 'PERSONAL' NOT NULL;--> statement-breakpoint
ALTER TABLE "knox"."approval_logs" ADD COLUMN "time_zone" text DEFAULT 'GMT+9' NOT NULL;--> statement-breakpoint
ALTER TABLE "knox"."approval_logs" ADD COLUMN "opinion" varchar(1000);--> statement-breakpoint
ALTER TABLE "knox"."approval_logs" ADD COLUMN "knox_user_id" text;--> statement-breakpoint
ALTER TABLE "knox"."approval_logs" ADD COLUMN "important_yn" varchar(1) DEFAULT 'N';--> statement-breakpoint
ALTER TABLE "knox"."approval_logs" ADD COLUMN "doc_mng_save_code" text DEFAULT '0' NOT NULL;--> statement-breakpoint
ALTER TABLE "rfq_last_vendor_responses" ADD CONSTRAINT "rfq_last_vendor_responses_participation_replied_by_users_id_fk" FOREIGN KEY ("participation_replied_by") REFERENCES "public"."users"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint
ALTER TABLE "knox"."approval_logs" DROP COLUMN "user_id";
|
