diff options
author | Julien Dessaux | 2021-05-12 22:58:22 +0200 |
---|---|---|
committer | Julien Dessaux | 2021-05-12 22:58:22 +0200 |
commit | 1475b95491be100927460bc17a97bfc85ab51d3c (patch) | |
tree | 657f17d6d3bbcb296f2808a021ee629fc9e0d248 /pkg/database/migrations.go | |
parent | Fixed sessions schema (diff) | |
download | trains-1475b95491be100927460bc17a97bfc85ab51d3c.tar.gz trains-1475b95491be100927460bc17a97bfc85ab51d3c.tar.bz2 trains-1475b95491be100927460bc17a97bfc85ab51d3c.zip |
Added train_stops to schema
Diffstat (limited to '')
-rw-r--r-- | pkg/database/migrations.go | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/pkg/database/migrations.go b/pkg/database/migrations.go index 6a3d923..e977960 100644 --- a/pkg/database/migrations.go +++ b/pkg/database/migrations.go @@ -23,6 +23,10 @@ var allMigrations = []func(tx *sql.Tx) error{ user_id INTEGER NOT NULL, created_at DATE DEFAULT (datetime('now')), FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE + ); + CREATE TABLE train_stops ( + id TEXT PRIMARY KEY, + name TEXT NOT NULL UNIQUE );` _, err = tx.Exec(sql) return err |