msramalho / feup-ltw Goto Github PK

CREATE TABLE `todoList` (
  `listId` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, -- COMMENT 'List ID',
  `title` TEXT NOT NULL, -- COMMENT 'List title',
  `tags` TEXT NOT NULL, -- COMMENT 'Serialized data for tags.',
  `colour` TEXT NOT NULL, -- COMMENT 'Colour for each list',
  `archived` INTEGER NOT NULL, -- COMMENT 'If the list is archived.',
  `link` TEXT, -- COMMENT 'The shareable hash for the list.'
  `user` INTEGER, -- COMMENT 'The userID of the owner of this list.'
  `project` INTEGER -- COMMENT '-1: not part of a project. Else, project's id.'
);

INSERT INTO `todolist` VALUES
(NULL, "My personal notes", "a:1:{i:0;s:8:""personal"";}", "red", 0, NULL, 0, -1);

INSERT INTO `todolist` VALUES
(NULL, "School", "a:1:{i:0;s:8:""personal"";}", "blue", 0, NULL, 0, -1);

INSERT INTO `todolist` VALUES
(NULL, "Reddit notes", "a:1:{i:0;s:3:""fun"";}", "green", 0, NULL, 1, -1);

INSERT INTO `todolist` VALUES
(NULL, "Hobbies", "a:1:{i:0;s:0:"""";}", "white", 0, NULL, 0, -1);