diff options
| author | Matthew Lemon <y@yulqen.org> | 2024-04-10 19:33:21 +0100 |
|---|---|---|
| committer | Matthew Lemon <y@yulqen.org> | 2024-04-10 19:33:21 +0100 |
| commit | e69391d4f309f6268440632585bbddf3a2a5bd60 (patch) | |
| tree | 9e0faa4a92f06dbd8c228ba80752ea5f4d89dd17 /resources/setup.sql | |
| parent | d36c48b3251b9da483f06318ecaa14b9a4fa7118 (diff) | |
First introduction of migrations using golang-migrate
Diffstat (limited to '')
| -rw-r--r-- | resources/setup.sql (renamed from migrations/setup.sql) | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/migrations/setup.sql b/resources/setup.sql index 3d95044..dac150f 100644 --- a/migrations/setup.sql +++ b/resources/setup.sql @@ -3,4 +3,6 @@ CREATE DATABASE dbasik; \c dbasik CREATE ROLE 'dbasik' WITH LOGIN PASSWORD 'dbasik'; +GRANT ALL PRIVILEGES ON DATABASE 'dbasik' TO 'dbasik'; +ALTER DATABASE 'dbasik' OWNER TO 'dbasik'; CREATE EXTENSION IF NOT EXISTS citext; |