diff options
Diffstat (limited to 'pkg/database/migrations.go')
| -rw-r--r-- | pkg/database/migrations.go | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/pkg/database/migrations.go b/pkg/database/migrations.go index 8cc6420..7de255a 100644 --- a/pkg/database/migrations.go +++ b/pkg/database/migrations.go @@ -17,6 +17,12 @@ var allMigrations = []func(tx *sql.Tx) error{ email TEXT, created_at DATE DEFAULT (datetime('now')), last_login_at DATE DEFAULT NULL + ); + CREATE TABLE sessions ( + token TEXT NOT NULL UNIQUE, + user_id INTEGER NOT NULL, + created_at DATE DEFAULT (datetime('now')), + FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE );` _, err = tx.Exec(sql) return err |