Get current user session

1 files changed, 13 insertions, 0 deletions

diff --git a/migrations/0001_funny_ronan.sql b/migrations/0001_funny_ronan.sql
new file mode 100644
index 0000000..9928b60
--- /dev/null
+++ b/migrations/0001_funny_ronan.sql
@@ -0,0 +1,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`);
\ No newline at end of file