-
Notifications
You must be signed in to change notification settings - Fork 1
/
Database.txt
66 lines (57 loc) · 2.12 KB
/
Database.txt
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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
create database chat;
use chat;
create table user(
id int(4) not null auto_increment,
firstName varchar(255) null,
midName varchar(255) not null,
lastName varchar(255) not null,
birthDay varchar(255) not null,
age int not null,
gender varchar(255) not null,
isOnline BOOLEAN not null,
username varchar(255) not null,
password varchar(255) not null,
img varchar(255) not null,
primary key(id)
);
create table room(
id varchar(255) not null,
numberOfUser int not null,
roomName text not null,
lastMess text,
primary key(id)
);
create table roomConnection(
roomID varchar(255) not null,
userID int(4) not null,
primary key(roomID,userID),
foreign key (roomID) references room(id),
foreign key (userID) references user(id)
);
create table messageRoom(
id int not null auto_increment,
roomID varchar(255) not null,
userID int(4) not null,
content text not null,
primary key (id),
foreign key (roomID) references room(id),
foreign key (userID) references user(id)
);
create table userConnection(
id int(5) not null auto_increment,
userID1 int(5) not null,
userID2 int(5) not null,
primary key (id),
foreign key (userID1) references user(id),
foreign key (userID2) references user(id)
);
create table messageBox(
id int(5) not null auto_increment,
username1 varchar(255) not null,
username2 varchar(255) not null,
content text not null,
primary key (id)
);
INSERT INTO `chat`.`user` (`firstName`, `midName`, `lastName`, `birthDay`, `age`, `gender`, `isOnline`, `username`, `password`, `img`) VALUES ('Tran', 'Trung', 'Hieu', '2000-5-3', '21', 'nam', '0', 'hieutran', 'root', 'oke');
INSERT INTO `chat`.`user` (`firstName`, `midName`, `lastName`, `birthDay`, `age`, `gender`, `isOnline`, `username`, `password`, `img`) VALUES ('Vu', 'Danh', 'Hung', '2000-5-3', '21', 'nam', '0', 'hungvu', 'root', 'oke');
INSERT INTO `chat`.`user` (`firstName`, `midName`, `lastName`, `birthDay`, `age`, `gender`, `isOnline`, `username`, `password`, `img`) VALUES ('Tran', 'Hung', 'Minh', '2000-5-3', '21', 'nam', '0', 'minhtran', 'root', 'oke');