8 lines
360 B
SQL
8 lines
360 B
SQL
CREATE TABLE "restaurant_settings" (
|
|
"id" serial PRIMARY KEY NOT NULL,
|
|
"reservation_interval_minutes" integer DEFAULT 15 NOT NULL,
|
|
"reservation_duration_minutes" integer DEFAULT 90 NOT NULL,
|
|
"min_lead_time_minutes" integer DEFAULT 60 NOT NULL
|
|
);
|
|
--> statement-breakpoint
|
|
ALTER TABLE "reservations" ADD COLUMN "duration_minutes" integer DEFAULT 90 NOT NULL; |