Y6XJJ2dJ

1create table if not exists guilds (
2	ID bigserial not null,
3	guild_id varchar not null,
4	name varchar,
5	ticket_channel varchar not null,
6	fact_channel varchar not null,
7	fact_num int default 0 not null,
8	question_channel varchar not null,
9	last_question varchar default null,
10	premium boolean default false not null,
11    prefix varchar default '/' not null,
12    user_count int default 0 not null,
13    welcome_message text default '' not null,
14    goodbye_message text default '' not null,
15    leaderboard_channel varchar default '' not null,
16    leaderboard_message varchar default '' not null,
17    min_xp int default 5 not null,
18    max_xp int default 25 not null,
19    level_xp int default 250 not null,
20    color int default 255 not null, -- blue
21    color_error int default 16646144 not null -- red
22);
23
24create unique index guilds_guild_id_uindex
25	on guilds (guild_id);
26
27create unique index guilds_id_uindex
28	on guilds (ID);
29
30alter table guilds
31	add constraint guilds_pk
32		primary key (ID);
33
34create table if not exists message_count (
35	ID bigserial not null,
36	guild_id bigint references guilds(id) not null,
37	channel_id varchar not null,
38	message_number bigint default 0 not null
39);
40
41create unique index message_count_id_uindex
42	on message_count (ID);
43
44alter table message_count
45	add constraint message_count_pk
46		primary key (ID);
47
48create table if not exists tickets (
49	id bigserial not null,
50	guild_id bigint references guilds(id) not null,
51	message_id varchar not null,
52	requested_id varchar not null,
53    helper_id varchar default null
54);
55
56create unique index tickets_id_uindex
57	on tickets (id);
58
59alter table tickets
60	add constraint tickets_pk
61		primary key (id);
62
63create table if not exists users (
64    ID bigserial not null,
65	user_id varchar not null,
66	messages int default 0 not null,
67	xp int default 0 not null,
68	answers int default 0 not null,
69	answer_date timestamp default '1970-01-01 00:00:00' not null
70);
71
72create unique index users_id_uindex
73	on users (id);
74
75create unique index users_user_id_uindex
76	on users (user_id);
77
78alter table users
79	add constraint users_pk
80		primary key (id);
81
82create table if not exists users_guilds (
83    ID bigserial not null,
84    user_id bigint references users(id) not null,
85    guild_id bigint references guilds(id) not null,
86    messages int default 0 not null,
87    xp int default 0 not null,
88    answers int default 0 not null,
89	answer_date timestamp default '1970-01-01 00:00:00' not null
90);
91
92create unique index users_guilds_id_uindex
93	on users_guilds (id);
94
95alter table users_guilds
96	add constraint users_guilds_pk
97		primary key (id);
98
99create table if not exists premium_users (
100    ID bigserial not null,
101    username varchar not null,
102    password varchar not null,
103	join_date timestamp default now() not null
104);
105
106create unique index premium_users_id_uindex
107	on premium_users (id);
108
109alter table premium_users
110	add constraint premium_users_pk
111		primary key (id);
112