socket_project/socket_data.sql at master · danlidan/socket_project · GitHub

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
create table pyq_comment(
	sender_id char(30),
    send_time datetime,
    commenter_id char(30),
    comments text,
    foreign key(sender_id) references users(id)
);

create table pyq_main(
	sender_id char(30),
    send_time datetime,
    content text,
    cool_counter integer,
    primary key(sender_id, send_time),
    foreign key(sender_id) references users(id)
);

create table chat_global(
	sender_id char(30),
    send_time datetime,
    content text,
    foreign key(sender_id) references users(id)
);

create table chat_records(
	sender_id char(30),
    recver_id char(30),
    send_time datetime,
    content text,
    primary key(sender_id, recver_id, send_time),
    foreign key(sender_id) references users(id),
    foreign key(recver_id) references users(id)
);

create table users(
	id char(30),
    pass char(30) not null,
    nick_name char(30) not null,
    primary key(id)
);