diff options
Diffstat (limited to 'migration.sql')
| -rw-r--r-- | migration.sql | 17 |
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; |
