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 'resources/setup.sql')
| -rw-r--r-- | resources/setup.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/resources/setup.sql b/resources/setup.sql new file mode 100644 index 0000000..dac150f --- /dev/null +++ b/resources/setup.sql @@ -0,0 +1,8 @@ +/* should be added manually at this point */ +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; |