/
githubmirror
/
zulip
Обзор
Документация
Войти
/
githubmirror
/
zulip
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
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:03
13243be
Код
Авторство
О чём код?
\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"