Project/logging.sql at master · lagzda/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
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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
drop database logging;
create database logging;
use logging;
CREATE TABLE IF NOT EXISTS `major` (
  `major_id` varchar(20) NOT NULL,
  `major_name` varchar(20) NOT NULL,
  PRIMARY KEY (`major_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `major` (`major_id`, `major_name`) VALUES
('1', 'computing'),
('2', 'software engineering'),
('3', 'network engineering');


CREATE TABLE IF NOT EXISTS `major_module` (
  `major_name` varchar(25) NOT NULL,
  `module_name` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `major_module` (`major_name`, `module_name`) VALUES
('computing', 'java'),
('computing', 'operating system'),
('computing', 'c++'),
('software engineering', 'data mining'),
('software engineering', 'database management'),
('software engineering', 'linear algebra');


CREATE TABLE IF NOT EXISTS `module` (
  `module_id` varchar(20) NOT NULL,
  `module_name` varchar(20) NOT NULL,
  `teacher` varchar(50) NOT NULL,
  `classroom` varchar(50) NOT NULL,
  `time` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `module` (`module_id`, `module_name`, `teacher`, `classroom`, `time`) VALUES
('m1', 'java', 'Kevin Gong', 'A202', 'Monday 12:00'),
('m2', 'operating system', 'Jason Lee', 'C307', 'Tuesday 14:00'),
('m3', 'c++', 'Cindy Chan', 'G408', 'Thursday 12:00'),
('m4', 'data mining', 'Tom Sit', 'F108', 'Friday 16:00'),
('m5', 'database management', 'Fiona Yeung', 'D517', 'Tuesday 16:00'),
('m6', 'linear algebra', 'Windy Chan', 'F408', 'Thursday 14:00');


CREATE TABLE IF NOT EXISTS `user` (
  `id` varchar(25) NOT NULL,
  `password` varchar(20) NOT NULL,
  `name` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `user` (`id`, `password`, `name`) VALUES
('20131003532@gdufs.com', '123', 'Dereck'),
('20131003641@gdufs.com', '123', 'Deft'),
('20131003694@gdufs.com', '123', 'Helen');


CREATE TABLE IF NOT EXISTS `user_major` (
  `id` varchar(25) NOT NULL,
  `major_id` varchar(20) NOT NULL,
  `major_name` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `user_major` (`id`, `major_id`, `major_name`) VALUES
('20131003694@gdufs.com', '1', 'computing'),
('20131003532@gdufs.com', '1', 'computing'),
('20131003641@gdufs.com', '2', 'software engineering');