User:Woozle/TaskFerret

Tables

task

<mysql>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;</mysql>

usr_prj

<mysql>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;</mysql>

project

<mysql>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;</mysql>

client

<mysql>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;</mysql>