From c2c39cc2756230c1de29d8065b8b320f2f084045 Mon Sep 17 00:00:00 2001
From: Thibaut Horel <thibaut.horel@gmail.com>
Date: Sat, 19 Nov 2016 17:35:07 -0500
Subject: Initial commit

---
 migration.sql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 migration.sql

(limited to 'migration.sql')

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;
-- 
cgit v1.2.3-70-g09d2