17 lines
793 B
SQL
17 lines
793 B
SQL
 
|
DROP TABLE `recordings`;--> statement-breakpoint
|
||
|
|
PRAGMA foreign_keys=OFF;--> statement-breakpoint
|
||
|
|
CREATE TABLE `__new_play_sessions` (
|
||
|
|
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
|
||
|
|
`name` text,
|
||
|
|
`kind` text NOT NULL,
|
||
|
|
`status` text DEFAULT 'active' NOT NULL,
|
||
|
|
`started_at` integer NOT NULL,
|
||
|
|
`ended_at` integer,
|
||
|
|
`duration_ms` integer,
|
||
|
|
`notes` text
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
INSERT INTO `__new_play_sessions`("id", "name", "kind", "status", "started_at", "ended_at", "duration_ms", "notes") SELECT "id", "name", "kind", "status", "started_at", "ended_at", "duration_ms", "notes" FROM `play_sessions`;--> statement-breakpoint
|
||
|
|
DROP TABLE `play_sessions`;--> statement-breakpoint
|
||
|
|
ALTER TABLE `__new_play_sessions` RENAME TO `play_sessions`;--> statement-breakpoint
|
||
|
|
PRAGMA foreign_keys=ON;
|