githubmirror/zulip

scripts/setup/create-db.sql

20 строк584 B

Alex Vandiver

migrations: Move schema creation and search_path into pre_migrate hook.

17 дек 2025, 00:03

17 дек 2025, 00:0313243be

\set dbuser :dbuser
SELECT CASE WHEN :'dbuser' = ':dbuser' THEN 'zulip' ELSE :'dbuser' END AS dbuser \gset
\set dbname :dbname
SELECT CASE WHEN :'dbname' = ':dbname' THEN 'zulip' ELSE :'dbname' END AS dbname \gset

\connect postgres
DROP DATABASE IF EXISTS :"dbname";
SELECT format($$BEGIN
    CREATE USER %I;
EXCEPTION WHEN duplicate_object THEN
    RAISE NOTICE 'user already exists';
END$$, :'dbuser') AS code \gset
DO :'code';
CREATE DATABASE :"dbname"
    OWNER=:dbuser
    ENCODING=UTF8
    LC_COLLATE='C.UTF-8'
    LC_CTYPE='C.UTF-8'
    TEMPLATE=template0;
\connect :"dbname"