diff options
Diffstat (limited to 'db/migrations/0348_violet_blue_blade.sql')
| -rw-r--r-- | db/migrations/0348_violet_blue_blade.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/db/migrations/0348_violet_blue_blade.sql b/db/migrations/0348_violet_blue_blade.sql new file mode 100644 index 00000000..5167bc68 --- /dev/null +++ b/db/migrations/0348_violet_blue_blade.sql @@ -0,0 +1,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";
\ No newline at end of file |