blob: eb0aa96d0d61035194ee67adb5fdd8d97ad73605 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
|
CREATE TABLE users (
id BIGINT NOT NULL,
guild_id BIGINT NOT NULL,
username TEXT NOT NULL DEFAULT '',
nickname TEXT NOT NULL DEFAULT '',
roles BIGINT [] NOT NULL DEFAULT array[]::bigint[],
watchlist BOOL NOT NULL DEFAULT 'f',
xp BIGINT NOT NULL DEFAULT 0,
last_message TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(),
registered TIMESTAMP WITH TIME ZONE,
PRIMARY KEY(id, guild_id)
)
|