| 1 | CREATE TYPE "public"."timesheet_duration" AS ENUM('weekly', 'biweekly', 'monthly');--> statement-breakpoint |
| 2 | CREATE TABLE "organization_settings" ( |
| 3 | "id" text PRIMARY KEY |
| 4 | "organization_id" text NOT NULL |
| 5 | "project_id" text, |
| 6 | "default_member_rate" integer DEFAULT |
| 7 | "default_currency" text DEFAULT |
| 8 | "default_timesheet_duration" timesheet_duration DEFAULT ' |
| 9 | "created_at" timestamp DEFAULT |
| 10 | "updated_at" timestamp DEFAULT |
| 11 | ); |
| 12 | --> statement-breakpoint |
| 13 | ALTER TABLE "organization_settings" ADD |
| 14 | ALTER TABLE "organization_settings" ADD |
| 15 | CREATE UNIQUE INDEX "org_settings_org_project_unique" ON |
| 16 | CREATE UNIQUE INDEX "org_settings_org_only_unique" ON |
| 17 | CREATE INDEX "org_settings_org_id_idx" ON |