User:Woozle/TaskFerret

task
DROP TABLE IF EXISTS `assign`; CREATE TABLE `assign` (  `ID`         INT          NOT NULL      AUTO_INCREMENT,   `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;

usr_prj
DROP TABLE IF EXISTS `usr_prj`; CREATE TABLE `usr_prj` (  `ID_Project` INT          NOT NULL      COMMENT "ID of project which is now a task for this user",   `ID_User`    INT          NOT NULL      COMMENT "ID of wiki user to whom task is currently assigned",   PRIMARY KEY(`ID_Project, ID_User`) ) ENGINE = MYISAM;

project
DROP TABLE IF EXISTS `project`; CREATE TABLE `project` (  `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_Parent` INT          DEFAULT NULL  COMMENT "parent project, if any (must be NULL if ID_Client isn't)",   `ID_Client` INT          DEFAULT NULL  COMMENT "client for whom this project is being done",   `ID_User`   INT          NOT NULL      COMMENT "user who is responsible for getting this project done",   PRIMARY KEY(`ID`) ) ENGINE = MYISAM;

client
DROP TABLE IF EXISTS `client`; CREATE TABLE `client` (  `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",   PRIMARY KEY(`ID`) ) ENGINE = MYISAM;