User:Woozle/TaskFerret

From HTYP, the free directory anyone can edit

Contents 1 Tables 1.1 task 1.2 usr_prj 1.3 project 1.4 client

[edit] Tables

[edit] 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;

[edit] 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;

[edit] 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;

[edit] 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;