Initial commit

1 files changed, 17 insertions, 0 deletions

diff --git a/migration.sql b/migration.sql
new file mode 100644
index 0000000..cd95209
--- /dev/null
+++ b/migration.sql
@@ -0,0 +1,17 @@
+BEGIN;
+
+    CREATE TABLE new_sessions (
+        user string,
+        key string PRIMARY KEY,
+        client string,
+        protocol string,
+        created int
+    );
+
+    INSERT INTO new_sessions SELECT * FROM sessions;
+    
+    DROP TABLE sessions;
+
+    ALTER TABLE new_sessions RENAME TO sessions;
+
+END;