-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathChess_details.sql
54 lines (44 loc) · 4.34 KB
/
Chess_details.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
47
48
49
50
51
52
53
54
------------------------------------------------------------------------
insert into chess Values('13','20073101','20073102','2','3','20073102');
insert into chess Values('14','20073103','20073104','1','4','20073104');
insert into chess Values('15','20073101','20073104','2','3','20073104');
insert into chess Values('16','20073102','20073103','3','2','20073102');
insert into chess Values('17','20073101','20073103','4','1','20073101');
insert into chess Values('18','20073102','20073104','3','2','20073102');
-----------------------------------------------------------------
insert into chess_points Values('20073101','3','1','2','+2');
insert into chess_points Values('20073102','3','3','0','+6');
insert into chess_points Values('20073103','3','0','3','0');
insert into chess_points Values('20073104','3','2','1','+4');
-------------------------------------------------------------
insert into chess_players_match Values('13','1','2016/04/10','20073101001','20073102004','20073101001','12:15');
insert into chess_players_match Values('13','2','2016/04/10','20073101002','20073102003','20073102003','14:19');
insert into chess_players_match Values('13','3','2016/04/10','20073101003','20073102005','20073101003','11:17');
insert into chess_players_match Values('13','4','2016/04/10','20073101004','20073102001','20073102001','13:18');
insert into chess_players_match Values('13','5','2016/04/10','20073101005','20073102002','20073102002','10:15');
insert into chess_players_match Values('14','1','2016/04/11','20073103003','20073104002','20073104002','14:18');
insert into chess_players_match Values('14','2','2016/04/11','20073103001','20073104004','20073104004','13:13');
insert into chess_players_match Values('14','3','2016/04/11','20073103002','20073104005','20073103002','14:13');
insert into chess_players_match Values('14','4','2016/04/11','20073103005','20073104003','20073104003','12:30');
insert into chess_players_match Values('14','5','2016/04/11','20073103004','20073104001','20073104004','12:14');
insert into chess_players_match Values('15','1','2016/04/12','20073101002','20073104001','20073104001','12:09');
insert into chess_players_match Values('15','2','2016/04/12','20073101004','20073104005','20073101004','11:19');
insert into chess_players_match Values('15','3','2016/04/12','20073101005','20073104003','20073104003','12:48');
insert into chess_players_match Values('15','4','2016/04/12','20073101001','20073104004','20073104004','10:25');
insert into chess_players_match Values('15','5','2016/04/12','20073101003','20073104002','20073101003','14:22');
insert into chess_players_match Values('16','1','2016/04/13','20073102003','20073103005','20073102003','11:22');
insert into chess_players_match Values('16','2','2016/04/13','20073102004','20073103002','20073103002','14:15');
insert into chess_players_match Values('16','3','2016/04/13','20073102001','20073103003','20073102001','10:01');
insert into chess_players_match Values('16','4','2016/04/13','20073102005','20073103004','20073102005','09:42');
insert into chess_players_match Values('16','5','2016/04/13','20073102002','20073103001','20073103001','14:13');
insert into chess_players_match Values('17','1','2016/04/14','20073101003','20073103002','20073101003','11:22');
insert into chess_players_match Values('17','2','2016/04/14','20073101002','20073103004','20073101002','10:24');
insert into chess_players_match Values('17','3','2016/04/14','20073101005','20073103001','20073103001','14:15');
insert into chess_players_match Values('17','4','2016/04/14','20073101004','20073103005','20073101004','12:42');
insert into chess_players_match Values('17','5','2016/04/14','20073101001','20073103003','20073101001','10:32');
insert into chess_players_match Values('18','1','2016/04/15','20073102003','20073104001','20073102003','11:22');
insert into chess_players_match Values('18','2','2016/04/15','20073102005','20073104003','20073102005','11:22');
insert into chess_players_match Values('18','3','2016/04/15','20073102001','20073104004','20073104004','11:22');
insert into chess_players_match Values('18','4','2016/04/15','20073102004','20073104002','20073102004','11:22');
insert into chess_players_match Values('18','5','2016/04/15','20073102002','20073104005','20073104005','11:22');
-------------------------------------------------------------------------------------------------------------