SHARE
TWEET

Untitled

a guest Jan 12th, 2017 92 in 23 days
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
  2. SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
  3. SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
  4.  
  5. DROP SCHEMA IF EXISTS `todo` ;
  6. CREATE SCHEMA IF NOT EXISTS `todo` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
  7. USE `todo` ;
  8.  
  9. -- -----------------------------------------------------
  10. -- Table `todo`.`User`
  11. -- -----------------------------------------------------
  12. DROP TABLE IF EXISTS `todo`.`User` ;
  13.  
  14. CREATE 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`))
  21. ENGINE = InnoDB;
  22.  
  23.  
  24. -- -----------------------------------------------------
  25. -- Table `todo`.`ToDoList`
  26. -- -----------------------------------------------------
  27. DROP TABLE IF EXISTS `todo`.`ToDoList` ;
  28.  
  29. CREATE 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)
  42. ENGINE = InnoDB;
  43.  
  44.  
  45. -- -----------------------------------------------------
  46. -- Table `todo`.`ToDoItem`
  47. -- -----------------------------------------------------
  48. DROP TABLE IF EXISTS `todo`.`ToDoItem` ;
  49.  
  50. CREATE 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)
  74. ENGINE = InnoDB;
  75.  
  76.  
  77. -- -----------------------------------------------------
  78. -- Table `todo`.`ToDoAssignment`
  79. -- -----------------------------------------------------
  80. DROP TABLE IF EXISTS `todo`.`ToDoAssignment` ;
  81.  
  82. CREATE 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)
  98. ENGINE = InnoDB;
  99.  
  100.  
  101. -- -----------------------------------------------------
  102. -- Table `todo`.`Tag`
  103. -- -----------------------------------------------------
  104. DROP TABLE IF EXISTS `todo`.`Tag` ;
  105.  
  106. CREATE TABLE IF NOT EXISTS `todo`.`Tag` (
  107.   `Id` INT(11) NOT NULL AUTO_INCREMENT,
  108.   `Text` TEXT NULL,
  109.   PRIMARY KEY (`Id`))
  110. ENGINE = InnoDB;
  111.  
  112.  
  113. -- -----------------------------------------------------
  114. -- Table `todo`.`ItemTag`
  115. -- -----------------------------------------------------
  116. DROP TABLE IF EXISTS `todo`.`ItemTag` ;
  117.  
  118. CREATE 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)
  133. ENGINE = InnoDB;
  134.  
  135.  
  136. SET SQL_MODE=@OLD_SQL_MODE;
  137. SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
  138. SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
  139.  
  140. -- -----------------------------------------------------
  141. -- Data for table `todo`.`User`
  142. -- -----------------------------------------------------
  143. START TRANSACTION;
  144. USE `todo`;
  145. INSERT INTO `todo`.`User` (`Id`, `Name`, `Email`, `Username`, `Password`) VALUES (1, 'user1', 'user1@to.do', 'user1', 'pass1');
  146. INSERT INTO `todo`.`User` (`Id`, `Name`, `Email`, `Username`, `Password`) VALUES (2, 'user2', 'user2@to.do', 'user2', 'pass2');
  147.  
  148. COMMIT;
  149.  
  150.  
  151. -- -----------------------------------------------------
  152. -- Data for table `todo`.`ToDoList`
  153. -- -----------------------------------------------------
  154. START TRANSACTION;
  155. USE `todo`;
  156. INSERT INTO `todo`.`ToDoList` (`Id`, `Name`, `CreationDate`, `Owner`, `IsPublic`) VALUES (1, 'School', '2013-01-25 12:35:00', 1, 0);
  157. INSERT INTO `todo`.`ToDoList` (`Id`, `Name`, `CreationDate`, `Owner`, `IsPublic`) VALUES (2, 'Work', '2014-02-14 00:00:00', 1, 0);
  158. INSERT INTO `todo`.`ToDoList` (`Id`, `Name`, `CreationDate`, `Owner`, `IsPublic`) VALUES (3, 'Shared', '2014-09-05 00:00:00', 2, 1);
  159. INSERT INTO `todo`.`ToDoList` (`Id`, `Name`, `CreationDate`, `Owner`, `IsPublic`) VALUES (4, 'Personal', '2014-10-22 00:00:00', 2, 0);
  160.  
  161. COMMIT;
  162.  
  163.  
  164. -- -----------------------------------------------------
  165. -- Data for table `todo`.`ToDoItem`
  166. -- -----------------------------------------------------
  167. START TRANSACTION;
  168. USE `todo`;
  169. INSERT 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);
  170. INSERT 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);
  171. INSERT 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);
  172. INSERT 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);
  173. INSERT 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);
  174. INSERT 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);
  175. INSERT 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);
  176. INSERT 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);
  177. INSERT 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);
  178. INSERT 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);
  179. INSERT 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);
  180. INSERT 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);
  181. INSERT 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);
  182. INSERT 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);
  183. INSERT 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);
  184. INSERT 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);
  185. INSERT 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);
  186. INSERT 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);
  187. INSERT 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);
  188. INSERT 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);
  189. INSERT 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);
  190. INSERT 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);
  191. INSERT 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);
  192. INSERT 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);
  193. INSERT 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);
  194. INSERT 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);
  195. INSERT 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.  
  197. COMMIT;
  198.  
  199.  
  200. -- -----------------------------------------------------
  201. -- Data for table `todo`.`Tag`
  202. -- -----------------------------------------------------
  203. START TRANSACTION;
  204. USE `todo`;
  205. INSERT INTO `todo`.`Tag` (`Id`, `Text`) VALUES (1, 'webdata');
  206. INSERT INTO `todo`.`Tag` (`Id`, `Text`) VALUES (2, 'sport');
  207. INSERT INTO `todo`.`Tag` (`Id`, `Text`) VALUES (3, 'school');
  208. INSERT INTO `todo`.`Tag` (`Id`, `Text`) VALUES (4, 'work');
  209. INSERT INTO `todo`.`Tag` (`Id`, `Text`) VALUES (5, 'personal');
  210.  
  211. COMMIT;
  212.  
  213.  
  214. -- -----------------------------------------------------
  215. -- Data for table `todo`.`ItemTag`
  216. -- -----------------------------------------------------
  217. START TRANSACTION;
  218. USE `todo`;
  219. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (1, 1);
  220. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (1, 3);
  221. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (2, 1);
  222. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (2, 3);
  223. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (3, 1);
  224. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (3, 3);
  225. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (4, 4);
  226. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (5, 4);
  227. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (6, 3);
  228. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (7, 3);
  229. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (8, 3);
  230. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (9, 3);
  231. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (10, 3);
  232. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (11, 3);
  233. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (11, 5);
  234. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (12, 5);
  235. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (12, 2);
  236. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (13, 5);
  237. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (13, 2);
  238. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (14, 5);
  239. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (14, 2);
  240. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (15, 5);
  241. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (16, 5);
  242. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (17, 1);
  243. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (17, 3);
  244. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (18, 1);
  245. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (18, 3);
  246. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (19, 1);
  247. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (19, 3);
  248. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (20, 1);
  249. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (20, 3);
  250. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (21, 5);
  251. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (22, 1);
  252. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (22, 3);
  253. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (23, 1);
  254. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (23, 3);
  255. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (24, 1);
  256. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (24, 3);
  257. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (25, 1);
  258. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (25, 3);
  259. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (26, 1);
  260. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (26, 3);
  261. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (27, 1);
  262. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (27, 3);
  263. INSERT INTO `todo`.`ItemTag` (`ToDoId`, `TagId`) VALUES (27, 5);
  264.  
  265. COMMIT;
RAW Paste Data
Top