blob: 9928b60213de302976bf207d216b7ef0c4c6b5bf (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
PRAGMA foreign_keys=OFF;--> statement-breakpoint
CREATE TABLE `__new_sessions` (
`id` integer PRIMARY KEY NOT NULL,
`uuid` text NOT NULL,
`user_id` integer NOT NULL,
`last_use` integer DEFAULT current_timestamp NOT NULL
);
--> statement-breakpoint
INSERT INTO `__new_sessions`("id", "uuid", "user_id", "last_use") SELECT "id", "uuid", "user_id", "last_use" FROM `sessions`;--> statement-breakpoint
DROP TABLE `sessions`;--> statement-breakpoint
ALTER TABLE `__new_sessions` RENAME TO `sessions`;--> statement-breakpoint
PRAGMA foreign_keys=ON;--> statement-breakpoint
CREATE UNIQUE INDEX `sessions_uuid_unique` ON `sessions` (`uuid`);
|
