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 'pkg/database/migrations.go')
| -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 |