blob: 23de4ce65ccf67cadb0bfc44e6295c9c3ae812e0 (
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 (unixepoch()) 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`);
|
