aboutsummaryrefslogtreecommitdiff
path: root/migrations/2018-06-04-144510_create_guilds/up.sql
blob: a7ea5990d7d5e5d55f0eea37146dde91434d3530 (plain) (blame)
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
CREATE TABLE guilds (
	id BIGINT PRIMARY KEY,
	admin_roles BIGINT [] NOT NULL DEFAULT array[]::bigint[],
	audit BOOL NOT NULL DEFAULT 'f',
	audit_channel BIGINT NOT NULL DEFAULT 0,
	audit_threshold SMALLINT NOT NULL DEFAULT 0,
	autorole BOOL NOT NULL DEFAULT 'f',
	autoroles BIGINT [] NOT NULL DEFAULT array[]::bigint[],
	ignored_channels BIGINT [] NOT NULL DEFAULT array[]::bigint[],
	ignore_level SMALLINT NOT NULL DEFAULT 3,
	introduction BOOL NOT NULL DEFAULT 'f',
	introduction_channel BIGINT NOT NULL DEFAULT 0,
	introduction_message TEXT NOT NULL DEFAULT '',
	introduction_type TEXT NOT NULL DEFAULT 'plain',
	mod_roles BIGINT [] NOT NULL DEFAULT array[]::bigint[],
	modlog BOOL NOT NULL DEFAULT 'f',
	modlog_channel BIGINT NOT NULL DEFAULT 0,
	mute_setup BOOL NOT NULL DEFAULT 'f',
	prefix TEXT NOT NULL DEFAULT 'w.',
	welcome BOOL NOT NULL DEFAULT 'f',
	welcome_channel BIGINT NOT NULL DEFAULT 0,
	welcome_message TEXT NOT NULL DEFAULT '',
	welcome_type TEXT NOT NULL DEFAULT 'plain',
	goodbye BOOL NOT NULL DEFAULT 'f',
	goodbye_channel BIGINT NOT NULL DEFAULT 0,
	goodbye_message TEXT NOT NULL DEFAULT '',
	goodbye_type TEXT NOT NULL DEFAULT 'plain',
	commands TEXT [] NOT NULL DEFAULT array[]::text[],
	logging TEXT [] NOT NULL DEFAULT array[]::text[]
)