diff options
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 |