1_Create.User.sql
722 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
CREATE USER wdauthen WITH PASSWORD 'BBEcLWu5Cdzy3aeH'
LOGIN
NOSUPERUSER
INHERIT
NOCREATEDB
NOCREATEROLE
NOREPLICATION;
CREATE USER wdchat WITH PASSWORD 'BBRyAPNh6g4H9qte'
LOGIN
NOSUPERUSER
INHERIT
NOCREATEDB
NOCREATEROLE
NOREPLICATION;
DROP DATABASE IF EXISTS "WDCHAT"
CREATE DATABASE "WDCHAT"
WITH
OWNER = wdchat
ENCODING = 'UTF8'
LC_COLLATE = 'en_US.UTF-8'
LC_CTYPE = 'en_US.UTF-8'
TABLESPACE = pg_default
CONNECTION LIMIT = -1;
DROP DATABASE IF EXISTS "WDAUTHEN"
CREATE DATABASE "WDAUTHEN"
WITH
OWNER = wdauthen
ENCODING = 'UTF8'
LC_COLLATE = 'en_US.UTF-8'
LC_CTYPE = 'en_US.UTF-8'
TABLESPACE = pg_default
CONNECTION LIMIT = -1;