User:Woozle/TaskFerret

Tables

tasks

<mysql>DROP TABLE IF EXISTS `task`;

CREATE TABLE `task` (
  `ID`       INT          NOT NULL      AUTO_INCREMENT,
  `Name`     VARCHAR(63)  NOT NULL      COMMENT "brief name for lists",
  `Descr`    VARCHAR(255) DEFAULT NULL  COMMENT "longer description; may contain wiki links",
  `ID_User`  INT          NOT NULL      COMMENT "ID of wiki user to whom task is assigned",
  `WhenMade` DATETIME     NOT NULL      COMMENT "when this task was created",
  `WhenDone` DATETIME     NOT NULL      COMMENT "when task was completed or abandoned",
  PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>