aboutsummaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/migrations.go9
1 files changed, 8 insertions, 1 deletions
diff --git a/db/migrations.go b/db/migrations.go
index ce5caf6..286fe17 100644
--- a/db/migrations.go
+++ b/db/migrations.go
@@ -35,7 +35,14 @@ var migrations []Migration = []Migration{
35 )`, 35 )`,
36 "CREATE INDEX IF NOT EXISTS report_lines_report_id ON report_lines (report_id)", 36 "CREATE INDEX IF NOT EXISTS report_lines_report_id ON report_lines (report_id)",
37 "CREATE INDEX IF NOT EXISTS report_lines_type ON report_lines (type)", 37 "CREATE INDEX IF NOT EXISTS report_lines_type ON report_lines (type)",
38 `CREATE TABLE reports (
39 id BIGSERIAL PRIMARY KEY,
40 date timestamp with time zone NOT NULL,
41 market_config_id bigint NOT NULL,
42 debug boolean
43 )`,
44 "CREATE INDEX IF NOT EXISTS reports_market_config_id ON reports (market_config_id)",
38 }, 45 },
39 Down: []string{"DROP TABLE users", "DROP TABLE market_configs", "DROP TABLE report_lines"}, 46 Down: []string{"DROP TABLE users", "DROP TABLE market_configs", "DROP TABLE report_lines", "DROP TABLE reports"},
40 }, 47 },
41} 48}