Files
alla-allaos-fullstack/drizzle/0002_opportunity_quotation_timeline_hot_project.sql
phaichayon ed28ff6b50 task-d.6.2
2026-07-01 13:57:16 +07:00

12 lines
582 B
SQL

ALTER TABLE "crm_opportunities"
ADD COLUMN "project_close_date" timestamp with time zone,
ADD COLUMN "delivery_date" timestamp with time zone,
ADD COLUMN "hot_project_auto_suggested" boolean DEFAULT false NOT NULL,
ADD COLUMN "hot_project_manually_overridden" boolean DEFAULT false NOT NULL;
ALTER TABLE "crm_quotations"
ADD COLUMN "project_close_date" timestamp with time zone,
ADD COLUMN "delivery_date" timestamp with time zone,
ADD COLUMN "hot_project_auto_suggested" boolean DEFAULT false NOT NULL,
ADD COLUMN "hot_project_manually_overridden" boolean DEFAULT false NOT NULL;