25 lines
1.5 KiB
SQL
25 lines
1.5 KiB
SQL
PRAGMA foreign_keys=OFF;--> statement-breakpoint
|
|
CREATE TABLE `__new_rooms` (
|
|
`id` text PRIMARY KEY NOT NULL,
|
|
`name` text NOT NULL,
|
|
`type` text DEFAULT 'meeting_room' NOT NULL,
|
|
`sq_ft` integer,
|
|
`internal_price_per_hour_cents` integer,
|
|
`external_price_per_hour_cents` integer,
|
|
`internal_price_per_day_cents` integer,
|
|
`external_price_per_day_cents` integer,
|
|
`internal_price_per_half_day_cents` integer,
|
|
`external_price_per_half_day_cents` integer,
|
|
`max_attendees` integer,
|
|
`workstations` integer,
|
|
`price_per_month_cents` integer,
|
|
`created_at` integer DEFAULT (cast(unixepoch('subsecond') * 1000 as integer)) NOT NULL,
|
|
`updated_at` integer DEFAULT (cast(unixepoch('subsecond') * 1000 as integer)) NOT NULL,
|
|
`archived_at` integer
|
|
);
|
|
--> statement-breakpoint
|
|
INSERT INTO `__new_rooms`("id", "name", "type", "sq_ft", "internal_price_per_hour_cents", "external_price_per_hour_cents", "internal_price_per_day_cents", "external_price_per_day_cents", "internal_price_per_half_day_cents", "external_price_per_half_day_cents", "max_attendees", "workstations", "price_per_month_cents", "created_at", "updated_at", "archived_at") SELECT "id", "name", CASE WHEN "type" = 'office' THEN 'private_office' ELSE 'meeting_room' END, NULL, "hourly_rate_cents", "hourly_rate_cents", NULL, NULL, NULL, NULL, "capacity", NULL, NULL, "created_at", "updated_at", "archived_at" FROM `rooms`;--> statement-breakpoint
|
|
DROP TABLE `rooms`;--> statement-breakpoint
|
|
ALTER TABLE `__new_rooms` RENAME TO `rooms`;--> statement-breakpoint
|
|
PRAGMA foreign_keys=ON;
|