aboutsummaryrefslogtreecommitdiffstats
path: root/migration.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migration.sql')
-rw-r--r--migration.sql17
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;