migration.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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;