-
Notifications
You must be signed in to change notification settings - Fork 0
/
create_database.sql
46 lines (43 loc) · 1.18 KB
/
create_database.sql
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
38
39
40
41
42
43
44
45
46
create table chat_messages
(
message_id varchar(22),
send_date date,
current_rank varchar(36),
current_username varchar(16),
users_uuid char(36) default NULL,
message text,
primary key (message_id),
foreign key (users_uuid) references users (uuid)
);
create index message_id_index on chat_messages (message_id);
create index uname_index on chat_messages (current_username);
create index date_index on chat_messages (send_date);
create index message_index on chat_messages (message);
create table users
(
uuid char(36),
uuid_id char(22),
first_seen date,
PRIMARY KEY (uuid),
unique (uuid_id)
);
create table user_ips
(
log_in_id varchar(22),
users_uuid char(36),
ip varchar(16),
log_in_date date,
foreign key (users_uuid) references users (uuid),
primary key (log_in_id)
);
create table usernames
(
username_id varchar(22),
users_uuid char(36),
username varchar(16),
first_seen date,
foreign key (users_uuid) references users (uuid),
primary key (username_id),
unique (username, users_uuid)
);
create index username_index on usernames (username);