diff options
author | Julien Dessaux | 2021-04-13 22:53:29 +0200 |
---|---|---|
committer | Julien Dessaux | 2021-04-13 22:57:10 +0200 |
commit | 2d75d2cb7443a2c398dc317ae6335153b4c05f03 (patch) | |
tree | 787bf916964e47635c4051472e20f59b24b468f1 /pkg/database/migrations.go | |
parent | Renamed password column to hash in database (diff) | |
download | trains-2d75d2cb7443a2c398dc317ae6335153b4c05f03.tar.gz trains-2d75d2cb7443a2c398dc317ae6335153b4c05f03.tar.bz2 trains-2d75d2cb7443a2c398dc317ae6335153b4c05f03.zip |
Added a session table and a CreateSession function
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 |