docker/postgres/init/01-create-databases.sql - master - dmitriysturov/workspaces_platform

docker/postgres/init/01-create-databases.sql

44 строки2 KB

dmitriysturov

vkr

04 июн 2026, 22:24

04 июн 2026, 22:24971dfdc

SELECT 'CREATE DATABASE auth_db'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'auth_db')\gexec

SELECT 'CREATE DATABASE workspace_db'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'workspace_db')\gexec

SELECT 'CREATE DATABASE module_db'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'module_db')\gexec

SELECT 'CREATE DATABASE files_db'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'files_db')\gexec

SELECT 'CREATE DATABASE office_db'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'office_db')\gexec

SELECT 'CREATE DATABASE docs_db'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'docs_db')\gexec

SELECT 'CREATE DATABASE sheets_db'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'sheets_db')\gexec

SELECT 'CREATE DATABASE presentations_db'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'presentations_db')\gexec

SELECT 'CREATE DATABASE tasks_db'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'tasks_db')\gexec

SELECT 'CREATE DATABASE whiteboard_db'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'whiteboard_db')\gexec

SELECT 'CREATE DATABASE notification_db'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'notification_db')\gexec

GRANT ALL PRIVILEGES ON DATABASE auth_db TO postgres;
GRANT ALL PRIVILEGES ON DATABASE workspace_db TO postgres;
GRANT ALL PRIVILEGES ON DATABASE module_db TO postgres;
GRANT ALL PRIVILEGES ON DATABASE files_db TO postgres;
GRANT ALL PRIVILEGES ON DATABASE office_db TO postgres;
GRANT ALL PRIVILEGES ON DATABASE docs_db TO postgres;
GRANT ALL PRIVILEGES ON DATABASE sheets_db TO postgres;
GRANT ALL PRIVILEGES ON DATABASE presentations_db TO postgres;
GRANT ALL PRIVILEGES ON DATABASE tasks_db TO postgres;
GRANT ALL PRIVILEGES ON DATABASE whiteboard_db TO postgres;
GRANT ALL PRIVILEGES ON DATABASE notification_db TO postgres;