diff options
| author | Kjetil Orbekk <kjetil.orbekk@gmail.com> | 2020-01-29 19:15:28 -0500 |
|---|---|---|
| committer | Kjetil Orbekk <kjetil.orbekk@gmail.com> | 2020-01-29 19:15:28 -0500 |
| commit | c8db39dea2cf50dd1fa6c499600e09818b8db44a (patch) | |
| tree | b2eb940f9769323cd1d3e1c92bbe3c16d38d9dd6 /migrations/2020-01-29-094607_create_config | |
| parent | 6c16bcd190328443f15029fc3ee2467b6c270eed (diff) | |
Add database support
Diffstat (limited to 'migrations/2020-01-29-094607_create_config')
| -rw-r--r-- | migrations/2020-01-29-094607_create_config/down.sql | 1 | ||||
| -rw-r--r-- | migrations/2020-01-29-094607_create_config/up.sql | 8 |
2 files changed, 9 insertions, 0 deletions
diff --git a/migrations/2020-01-29-094607_create_config/down.sql b/migrations/2020-01-29-094607_create_config/down.sql new file mode 100644 index 0000000..2e6f861 --- /dev/null +++ b/migrations/2020-01-29-094607_create_config/down.sql @@ -0,0 +1 @@ +DROP TABLE config; diff --git a/migrations/2020-01-29-094607_create_config/up.sql b/migrations/2020-01-29-094607_create_config/up.sql new file mode 100644 index 0000000..ccd1abd --- /dev/null +++ b/migrations/2020-01-29-094607_create_config/up.sql @@ -0,0 +1,8 @@ +CREATE TABLE config ( + strava_client_secret varchar NOT NULL, + strava_client_id varchar NOT NULL, + rocket_secret_key varchar(64) NOT NULL, + singleton bool DEFAULT TRUE PRIMARY KEY, + +CONSTRAINT unique_config CHECK (singleton) +); |