F7DPdTJv

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
4
5DROP SCHEMA IF EXISTS `todo` ;
6CREATE SCHEMA IF NOT EXISTS `todo` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
7USE `todo` ;
8
9-- -----------------------------------------------------
10-- Table `todo`.`User`
11-- -----------------------------------------------------
12DROP TABLE IF EXISTS `todo`.`User` ;
13
14CREATE TABLE IF NOT EXISTS `todo`.`User` (
15  `Id` INT(11) NOT NULL AUTO_INCREMENT,
16  `Name` TEXT NULL,
17  `Email` TEXT NULL,
18  `Username` TEXT(20) NULL,
19  `Password` TEXT NULL,
20  PRIMARY KEY (`Id`))
21ENGINE = InnoDB;
22
23
24-- -----------------------------------------------------
25-- Table `todo`.`ToDoList`
26-- -----------------------------------------------------
27DROP TABLE IF EXISTS `todo`.`ToDoList` ;
28
29CREATE TABLE IF NOT EXISTS `todo`.`ToDoList` (
30  `Id` INT(11) NOT NULL AUTO_INCREMENT,
31  `Name` TEXT NULL,
32  `CreationDate` TIMESTAMP NULL,
33  `Owner` INT(11) NULL,
34  `IsPublic` TINYINT(1) NULL,
35  PRIMARY KEY (`Id`),
36  INDEX `list_owner_idx` (`Owner` ASC),
37  CONSTRAINT `list_owner`
38    FOREIGN KEY (`Owner`)
39    REFERENCES `todo`.`User` (`Id`)
40    ON DELETE NO ACTION
41    ON UPDATE NO ACTION)
42ENGINE = InnoDB;
43
44
45-- -----------------------------------------------------
46-- Table `todo`.`ToDoItem`
47-- -----------------------------------------------------
48DROP TABLE IF EXISTS `todo`.`ToDoItem` ;
49
50CREATE TABLE IF NOT EXISTS `todo`.`ToDoItem` (
51  `Id` INT(11) NOT NULL AUTO_INCREMENT,
52  `Title` TEXT NULL,
53  `Text` TEXT NULL,
54  `CreationDate` TIMESTAMP NULL,
55  `DueDate` TIMESTAMP NULL,
56  `Completed` TINYINT(1) NULL,
57  `CompletionDate` TIMESTAMP NULL,
58  `Priority` INT(11) NOT NULL,
59  `ToDoListID` INT(11) NULL,
60  `ParentToDo` INT(11) NULL,
61  PRIMARY KEY (`Id`, `Priority`),
62  INDEX `item_list_idx` (`ToDoListID` ASC),
63  INDEX `parent_child_idx` (`ParentToDo` ASC),
64  CONSTRAINT `item_list`
65    FOREIGN KEY (`ToDoListID`)
66    REFERENCES `todo`.`ToDoList` (`Id`)
67    ON DELETE NO ACTION
68    ON UPDATE NO ACTION,
69  CONSTRAINT `parent_child`
70    FOREIGN KEY (`ParentToDo`)
71    REFERENCES `todo`.`ToDoItem` (`Id`)
72    ON DELETE NO ACTION
73    ON UPDATE NO ACTION)
74ENGINE = InnoDB;
75
76
77-- -----------------------------------------------------
78-- Table `todo`.`ToDoAssignment`
79-- -----------------------------------------------------
80DROP TABLE IF EXISTS `todo`.`ToDoAssignment` ;
81
82CREATE TABLE IF NOT EXISTS `todo`.`ToDoAssignment` (
83  `ToDoId` INT(11) NOT NULL AUTO_INCREMENT,
84  `AssigneeId` INT(11) NOT NULL,
85  `AssignDate` TIMESTAMP NULL,
86  PRIMARY KEY (`ToDoId`, `AssigneeId`),
87  INDEX `assignee_id_idx` (`AssigneeId` ASC),
88  CONSTRAINT `assingment_todo`
89    FOREIGN KEY (`ToDoId`)
90    REFERENCES `todo`.`ToDoItem` (`Id`)
91    ON DELETE NO ACTION
92    ON UPDATE NO ACTION,
93  CONSTRAINT `assignment_assignee`
94    FOREIGN KEY (`AssigneeId`)
95    REFERENCES `todo`.`User` (`Id`)
96    ON DELETE NO ACTION
97    ON UPDATE NO ACTION)
98ENGINE = InnoDB;
99
100
101-- -----------------------------------------------------
102-- Table `todo`.`Tag`
103-- -----------------------------------------------------
104DROP TABLE IF EXISTS `todo`.`Tag` ;
105
106CREATE TABLE IF NOT EXISTS `todo`.`Tag` (
107  `Id` INT(11) NOT NULL AUTO_INCREMENT,
108  `Text` TEXT NULL,
109  PRIMARY KEY (`Id`))
110ENGINE = InnoDB;
111
112
113-- -----------------------------------------------------
114-- Table `todo`.`ItemTag`
115-- -----------------------------------------------------
116DROP TABLE IF EXISTS `todo`.`ItemTag` ;
117
118CREATE TABLE IF NOT EXISTS `todo`.`ItemTag` (
119  `ToDoId` INT(11) NOT NULL,
120  `TagId` INT(11) NOT NULL,
121  PRIMARY KEY (`ToDoId`, `TagId`),
122  INDEX `tag_id_idx` (`TagId` ASC),
123  CONSTRAINT `tag_todo`
124    FOREIGN KEY (`ToDoId`)
125    REFERENCES `todo`.`ToDoItem` (`Id`)
126    ON DELETE NO ACTION
127    ON UPDATE NO ACTION,
128  CONSTRAINT `tag_tag`
129    FOREIGN KEY (`TagId`)
130    REFERENCES `todo`.`Tag` (`Id`)
131    ON DELETE NO ACTION
132    ON UPDATE NO ACTION)
133ENGINE = InnoDB;
134
135
136SET SQL_MODE=@OLD_SQL_MODE;
137SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
138SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
139
140-- -----------------------------------------------------
141-- Data for table `todo`.`User`
142-- -----------------------------------------------------
143START TRANSACTION;
144USE `todo`;
145INSERT INTO `todo`.`User` (`Id`, `Name`, `Email`, `Username`, `Password`) VALUES (1, 'user1', 'user1@to.do', 'user1', 'pass1');
146INSERT INTO `todo`.`User` (`Id`, `Name`, `Email`, `Username`, `Password`) VALUES (2, 'user2', 'user2@to.do', 'user2', 'pass2');
147
148COMMIT;
149
150
151-- -----------------------------------------------------
152-- Data for table `todo`.`ToDoList`
153-- -----------------------------------------------------
154START TRANSACTION;
155USE `todo`;
156INSERT INTO `todo`.`ToDoList` (`Id`, `Name`, `CreationDate`, `Owner`, `IsPublic`) VALUES (1, 'School', '2013-01-25 12:35:00', 1, 0);
157INSERT INTO `todo`.`ToDoList` (`Id`, `Name`, `CreationDate`, `Owner`, `IsPublic`) VALUES (2, 'Work', '2014-02-14 00:00:00', 1, 0);
158INSERT INTO `todo`.`ToDoList` (`Id`, `Name`, `CreationDate`, `Owner`, `IsPublic`) VALUES (3, 'Shared', '2014-09-05 00:00:00', 2, 1);
159INSERT INTO `todo`.`ToDoList` (`Id`, `Name`, `CreationDate`, `Owner`, `IsPublic`) VALUES (4, 'Personal', '2014-10-22 00:00:00', 2, 0);
160
161COMMIT;
162
163
164-- -----------------------------------------------------
165-- Data for table `todo`.`ToDoItem`
166-- -----------------------------------------------------
167START TRANSACTION;
168USE `todo`;
169INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (1, 'Do assignment 1', 'Finish assignment one before the assessment time', '2014-11-17 12:56:12', '2014-11-20 23:59:59', 1, '2014-11-20 23:55:15', 3, 1, NULL);
170INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (3, 'Do HTML part of assignment 1', 'Do the html part of the first assignment: code and design', '2014-11-18 15:26:58', '2014-11-20 23:59:59', 1, '2014-11-19 15:59:36', 3, 1, 1);
171INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (2, 'Do telnet exercises', 'Do all telnet exercises and understand what is happening and why', '2014-11-18 22:51:48', '2014-11-20 23:59:59', 1, '2014-11-18 13:35:48', 3, 1, 1);
172INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (4, 'Bring presents to the children', 'Bring presents to all the children without being spotted', '2014-11-22 09:12:55', '2014-12-05 23:59:59', 0, NULL, 3, 2, NULL);
173INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (5, 'Do the paperwork', 'Do the paperwork to finish the work we did', '2014-11-22 09:13:25', '2014-12-22 12:00:00', 0, NULL, 1, 2, NULL);
174INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (6, 'Finish the group assignment', 'We need to finish the group assignment,preferably long before the deadline', '2014-09-05 12:45:35', '2014-12-10 23:59:59', 0, NULL, 2, 3, NULL);
175INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (7, 'Creates images', 'We can create images to make the assignment look better', '2014-10-25 21:25:55', '2014-12-09 23:59:59', 1, '2014-10-27 12:59:46', 1, 3, 6);
176INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (8, 'Finish chapter 1', 'Finish and check the text for chapter 1', '2014-10-05 21:26:54', '2014-12-09 23:59:59', 1, '2014-12-04 01:22:15', 2, 3, 6);
177INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (9, 'Finish chapter 2', 'Finish and check chapter 2', '2014-10-25 21:57:58', '2014-12-09 23:59:59', 1, '2014-12-05 12:35-22', 2, 3, 6);
178INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (10, 'Finish conclusion', 'Finish and check the conclusion', '2014-11-24 22:02:35', '2014-12-09 23:59:59', 0, NULL, 2, 3, 6);
179INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (11, 'Celebrate we finished the assignment', 'We need to celebrate after we finished the assignment!!', '2014-11-24 12:55:36', '2014-12-12 18:00:00', 0, NULL, 3, 3, NULL);
180INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (12, 'Leg day', 'Go to the gym', '2014-11-17 12:55:36', '2014-11-24 15:00:00', 1, '2014-11-24 15:05:56', 1, 4, NULL);
181INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (13, 'Exercise', 'Cycle 50 kms', '2014-11-20 14:52:45', '2014-11-27 16:00:00', 0, NULL, 1, 4, NULL);
182INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (14, 'Exercise', 'Run 10k', '2014-11-24 18:55:0', '2014-12-01 00:00:00', 0, NULL, 1, 4, NULL);
183INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (15, 'Celebrate birthday', 'With all my friends!', '2014-11-02 18:25:44', '2014-12-24 23:59:59', 0, NULL, 3, 4, NULL);
184INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (16, 'Visit grandma', 'Don\'t forget to bring a little present', '2014-05-14 11:52:44', '2014-05-22 15:00:00', 1, '2014-05-22 17:11:25', 2, 4, NULL);
185INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (17, 'Assignment 2', 'Fix all parts of assignment 2 for webdata', '2014-11-25 12:22:45', '2014-11-27 15:45:00', 1, '2014-11-27 12:52:33', 3, 1, NULL);
186INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (18, 'First part of 2', 'Do the first part of the second assignment', '2014-11-25 12:23:15', '2014-11-27 15:45:00', 1, '2014-11:26 09:12:52', 3, 1, 17);
187INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (19, 'Second part of 2', 'Do the second part of the second assignment', '2014-11-25 12:25:55', '2014-11-27 15:45:00', 1, '2014-11-27 12:52:33', 3, 1, 17);
188INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (20, 'Learn for Midterm', 'For webdata midterm', '2014-12-01 14:55:32', '2014-12-09 09:00:00', 1, '2014-11-08 22:55:15', 1, 1, NULL);
189INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (21, 'Vacuum', 'in my room', '2014-11-22 12:55:22', '2014-11-27 12:00:00', 1, '2014-11-25 15:44:22', 1, 4, NULL);
190INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (22, 'Assigment 3 and 4', 'For webdata', '2014-12-02 16:11:25', '2014-12-18 12:00:00', 0, NULL, 3, 1, NULL);
191INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (23, 'Assignemnt 3 part 1 ', 'part 1 for A3', '2014-12-02 16:12:11', '2014-12-18 12:00:00', 1, '2014-12-14 12:55:34', 3, 1, 22);
192INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (24, 'Assignment 3 part 2', 'part 2 for A3', '2014-12-02 16:12:55', '2014-12-18 12:00:00', 1, '2014-12-14 18:32:56', 3, 1, 22);
193INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (25, 'Assignment 4 part 1', 'part 1 for A4', '2014-12-02 16:14:25', '2014-12-18 12:00:00', 1, '2014-12-16 13:25:56', 3, 1, 22);
194INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (26, 'Assignment 4 part 2', 'part 2 for A4', '2014-12-02 16:15:45', '2014-12-18 12:00:00', 0, NULL, 3, 1, 22);
195INSERT INTO `todo`.`ToDoItem` (`Id`, `Title`, `Text`, `CreationDate`, `DueDate`, `Completed`, `CompletionDate`, `Priority`, `ToDoListID`, `ParentToDo`) VALUES (27, 'Create database for students', 'So they can practice with the assignments', '2014-12-12 15:48:55', '2014-12-16 23:59:59', 1, '2014-12-16 15:22:45', 3, 1, NULL);
196
197COMMIT;
198
199
200-- -----------------------------------------------------
201-- Data for table `todo`.`Tag`
202-- -----------------------------------------------------
203START TRANSACTION;
204USE `todo`;
205INSERT INTO `todo`.`Tag` (`Id`, `Text`) VALUES (1, 'webdata');
206INSERT INTO `todo`.`Tag` (`Id`, `Text`) VALUES (2, 'sport');
207INSERT INTO `todo`.`Tag` (`Id`, `Text`) VALUES (3, 'school');
208INSERT INTO `todo`.`Tag` (`Id`, `Text`) VALUES (4, 'work');
209INSERT INTO `todo`.`Tag` (`Id`, `Text`) VALUES (5, 'personal');
210
211COMMIT;
212
213
214-- -----------------------------------------------------
215-- Data for table `todo`.`ItemTag`
216-- -----------------------------------------------------
217START TRANSACTION;
218USE `todo`;
219INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (1, 1);
220INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (1, 3);
221INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (2, 1);
222INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (2, 3);
223INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (3, 1);
224INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (3, 3);
225INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (4, 4);
226INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (5, 4);
227INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (6, 3);
228INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (7, 3);
229INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (8, 3);
230INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (9, 3);
231INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (10, 3);
232INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (11, 3);
233INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (11, 5);
234INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (12, 5);
235INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (12, 2);
236INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (13, 5);
237INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (13, 2);
238INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (14, 5);
239INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (14, 2);
240INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (15, 5);
241INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (16, 5);
242INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (17, 1);
243INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (17, 3);
244INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (18, 1);
245INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (18, 3);
246INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (19, 1);
247INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (19, 3);
248INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (20, 1);
249INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (20, 3);
250INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (21, 5);
251INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (22, 1);
252INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (22, 3);
253INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (23, 1);
254INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (23, 3);
255INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (24, 1);
256INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (24, 3);
257INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (25, 1);
258INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (25, 3);
259INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (26, 1);
260INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (26, 3);
261INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (27, 1);
262INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (27, 3);
263INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (27, 5);
264
265COMMIT;