· 4 years ago · Mar 15, 2021, 12:46 AM
1-- Dumping structure for table timdb.selScoresClassroomDaily
2DROP TABLE IF EXISTS `selScoresClassroomDaily`;
3CREATE TABLE IF NOT EXISTS `selScoresClassroomDaily` (
4 `classSELID` int(11) NOT NULL AUTO_INCREMENT,
5 `classroomID` int(11) DEFAULT 0,
6 `emotion` int(11) DEFAULT 0,
7 `score` int(11) DEFAULT 0,
8 `startDate` datetime DEFAULT NULL,
9 `endDate` datetime DEFAULT NULL,
10 PRIMARY KEY (`classSELID`),
11 KEY `FK_CLASS_SEL_SCORE` (`classroomID`),
12 CONSTRAINT `FK_CLASS_SEL_SCORE` FOREIGN KEY (`classroomID`) REFERENCES `Classrooms` (`classroomID`)
13) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;
14
15-- Dumping data for table timdb.selScoresClassroomDaily: ~2 rows (approximately)
16DELETE FROM `selScoresClassroomDaily`;
17/*!40000 ALTER TABLE `selScoresClassroomDaily` DISABLE KEYS */;
18INSERT INTO `selScoresClassroomDaily` (`classSELID`, `classroomID`, `emotion`, `score`, `startDate`, `endDate`) VALUES
19 (1, 1, 1, -393, '2021-03-07 22:43:53', '2021-03-14 22:43:53'),
20 (8, 1, 1, 200, '2021-02-28 22:52:43', '2021-03-07 22:52:43'),
21 (9, 1, 1, 0, '2021-03-13 23:05:35', '2021-03-14 23:05:35'),
22 (10, 1, 1, 0, '2021-03-13 23:55:06', '2021-03-14 23:55:06'),
23 (11, 1, 1, 0, '2021-03-13 23:55:28', '2021-03-14 23:55:28');
24/*!40000 ALTER TABLE `selScoresClassroomDaily` ENABLE KEYS */;
25
26-- Dumping structure for table timdb.selScoresClassroomMonthly
27DROP TABLE IF EXISTS `selScoresClassroomMonthly`;
28CREATE TABLE IF NOT EXISTS `selScoresClassroomMonthly` (
29 `classSELID` int(11) NOT NULL AUTO_INCREMENT,
30 `classroomID` int(11) DEFAULT 0,
31 `emotion` int(11) DEFAULT 0,
32 `score` int(11) DEFAULT 0,
33 `startDate` datetime DEFAULT NULL,
34 `endDate` datetime DEFAULT NULL,
35 PRIMARY KEY (`classSELID`) USING BTREE,
36 KEY `FK_CLASS_SEL_SCORE` (`classroomID`) USING BTREE,
37 CONSTRAINT `selScoresClassroomMonthly_ibfk_1` FOREIGN KEY (`classroomID`) REFERENCES `Classrooms` (`classroomID`)
38) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
39
40-- Dumping data for table timdb.selScoresClassroomMonthly: ~1 rows (approximately)
41DELETE FROM `selScoresClassroomMonthly`;
42/*!40000 ALTER TABLE `selScoresClassroomMonthly` DISABLE KEYS */;
43INSERT INTO `selScoresClassroomMonthly` (`classSELID`, `classroomID`, `emotion`, `score`, `startDate`, `endDate`) VALUES
44 (9, 1, 1, -393, '2021-02-14 23:06:20', '2021-03-14 23:06:20'),
45 (10, 1, 1, -250, '2021-01-14 23:25:22', '2021-02-14 23:25:22');
46/*!40000 ALTER TABLE `selScoresClassroomMonthly` ENABLE KEYS */;
47
48-- Dumping structure for table timdb.selScoresClassroomWeekly
49DROP TABLE IF EXISTS `selScoresClassroomWeekly`;
50CREATE TABLE IF NOT EXISTS `selScoresClassroomWeekly` (
51 `classSELID` int(11) NOT NULL AUTO_INCREMENT,
52 `classroomID` int(11) DEFAULT 0,
53 `emotion` int(11) DEFAULT 0,
54 `score` int(11) DEFAULT 0,
55 `startDate` datetime DEFAULT NULL,
56 `endDate` datetime DEFAULT NULL,
57 PRIMARY KEY (`classSELID`) USING BTREE,
58 KEY `FK_CLASS_SEL_SCORE` (`classroomID`) USING BTREE,
59 CONSTRAINT `selScoresClassroomWeekly_ibfk_1` FOREIGN KEY (`classroomID`) REFERENCES `Classrooms` (`classroomID`)
60) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
61
62-- Dumping data for table timdb.selScoresClassroomWeekly: ~1 rows (approximately)
63DELETE FROM `selScoresClassroomWeekly`;
64/*!40000 ALTER TABLE `selScoresClassroomWeekly` DISABLE KEYS */;
65INSERT INTO `selScoresClassroomWeekly` (`classSELID`, `classroomID`, `emotion`, `score`, `startDate`, `endDate`) VALUES
66 (10, 1, 1, -393, '2021-03-07 23:05:54', '2021-03-14 23:05:54');
67/*!40000 ALTER TABLE `selScoresClassroomWeekly` ENABLE KEYS */;
68
69-- Dumping structure for table timdb.selScoresUsersDaily
70DROP TABLE IF EXISTS `selScoresUsersDaily`;
71CREATE TABLE IF NOT EXISTS `selScoresUsersDaily` (
72 `selID` int(11) NOT NULL AUTO_INCREMENT,
73 `userID` int(11) DEFAULT 0,
74 `score` double DEFAULT NULL,
75 `emotion` int(11) DEFAULT 0,
76 `startDate` datetime DEFAULT NULL,
77 `endDate` datetime DEFAULT NULL,
78 PRIMARY KEY (`selID`),
79 KEY `FK_USER_SCORE` (`userID`),
80 CONSTRAINT `FK_USER_SCORE` FOREIGN KEY (`userID`) REFERENCES `Users` (`userID`)
81) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=utf8mb4;
82
83-- Dumping data for table timdb.selScoresUsersDaily: ~9 rows (approximately)
84DELETE FROM `selScoresUsersDaily`;
85/*!40000 ALTER TABLE `selScoresUsersDaily` DISABLE KEYS */;
86INSERT INTO `selScoresUsersDaily` (`selID`, `userID`, `score`, `emotion`, `startDate`, `endDate`) VALUES
87 (37, 1, 300, 4, '2021-02-28 21:00:45', '2021-03-07 21:01:02'),
88 (38, 2, 500, 4, '2021-02-28 21:00:45', '2021-03-07 21:01:02'),
89 (39, 3, 120, 3, '2021-02-28 21:00:45', '2021-03-07 21:01:02'),
90 (40, 5, 250, 4, '2021-02-28 21:00:45', '2021-03-07 21:01:02'),
91 (41, 1, 250, 1, '2021-03-07 20:39:32', '2021-03-14 20:39:32');
92/*!40000 ALTER TABLE `selScoresUsersDaily` ENABLE KEYS */;
93
94-- Dumping structure for table timdb.selScoresUsersMonthly
95DROP TABLE IF EXISTS `selScoresUsersMonthly`;
96CREATE TABLE IF NOT EXISTS `selScoresUsersMonthly` (
97 `selID` int(11) NOT NULL AUTO_INCREMENT,
98 `userID` int(11) DEFAULT 0,
99 `score` double DEFAULT NULL,
100 `emotion` int(11) DEFAULT 0,
101 `startDate` datetime DEFAULT NULL,
102 `endDate` datetime DEFAULT NULL,
103 PRIMARY KEY (`selID`) USING BTREE,
104 KEY `FK_USER_SCORE` (`userID`) USING BTREE,
105 CONSTRAINT `selScoresUsersMonthly_ibfk_1` FOREIGN KEY (`userID`) REFERENCES `Users` (`userID`)
106) ENGINE=InnoDB AUTO_INCREMENT=193 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
107
108-- Dumping data for table timdb.selScoresUsersMonthly: ~4 rows (approximately)
109DELETE FROM `selScoresUsersMonthly`;
110/*!40000 ALTER TABLE `selScoresUsersMonthly` DISABLE KEYS */;
111INSERT INTO `selScoresUsersMonthly` (`selID`, `userID`, `score`, `emotion`, `startDate`, `endDate`) VALUES
112 (185, 1, -155, 1, '2021-02-14 23:06:20', '2021-03-14 23:06:20'),
113 (186, 2, -142.5, 1, '2021-02-14 23:06:20', '2021-03-14 23:06:20'),
114 (187, 3, -90.75, 1, '2021-02-14 23:06:20', '2021-03-14 23:06:20'),
115 (188, 5, -4.5, 2, '2021-02-14 23:06:20', '2021-03-14 23:06:20'),
116 (189, 1, -155, 1, '2021-02-14 23:25:22', '2021-03-14 23:25:22'),
117 (190, 2, -142.5, 1, '2021-02-14 23:25:22', '2021-03-14 23:25:22'),
118 (191, 3, -90.75, 1, '2021-02-14 23:25:22', '2021-03-14 23:25:22'),
119 (192, 5, -4.5, 2, '2021-02-14 23:25:22', '2021-03-14 23:25:22');
120/*!40000 ALTER TABLE `selScoresUsersMonthly` ENABLE KEYS */;
121
122-- Dumping structure for table timdb.selScoresUsersWeekly
123DROP TABLE IF EXISTS `selScoresUsersWeekly`;
124CREATE TABLE IF NOT EXISTS `selScoresUsersWeekly` (
125 `selID` int(11) NOT NULL AUTO_INCREMENT,
126 `userID` int(11) DEFAULT 0,
127 `score` double DEFAULT NULL,
128 `emotion` int(11) DEFAULT 0,
129 `startDate` datetime DEFAULT NULL,
130 `endDate` datetime DEFAULT NULL,
131 PRIMARY KEY (`selID`) USING BTREE,
132 KEY `FK_USER_SCORE` (`userID`) USING BTREE,
133 CONSTRAINT `selScoresUsersWeekly_ibfk_1` FOREIGN KEY (`userID`) REFERENCES `Users` (`userID`)
134) ENGINE=InnoDB AUTO_INCREMENT=193 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
135
136-- Dumping data for table timdb.selScoresUsersWeekly: ~4 rows (approximately)
137DELETE FROM `selScoresUsersWeekly`;
138/*!40000 ALTER TABLE `selScoresUsersWeekly` DISABLE KEYS */;
139INSERT INTO `selScoresUsersWeekly` (`selID`, `userID`, `score`, `emotion`, `startDate`, `endDate`) VALUES
140 (189, 1, -155, 1, '2021-03-07 23:05:54', '2021-03-14 23:05:54'),
141 (190, 2, -142.5, 1, '2021-03-07 23:05:54', '2021-03-14 23:05:54'),
142 (191, 3, -90.75, 1, '2021-03-07 23:05:54', '2021-03-14 23:05:54'),
143 (192, 5, -4.5, 2, '2021-03-07 23:05:54', '2021-03-14 23:05:54');
144/*!40000 ALTER TABLE `selScoresUsersWeekly` ENABLE KEYS */;
145