Woozle: more tables

2009-04-04T22:40:35Z

more tables

← Older revision		Revision as of 22:40, 4 April 2009
Line 1:		Line 1:
	==Tables==		==Tables==
	===~~tasks~~===		===task===
	<mysql>DROP TABLE IF EXISTS `task`;		<mysql>DROP TABLE IF EXISTS `assign`;
	CREATE TABLE `task` (		CREATE TABLE `assign` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`Name` VARCHAR(63) NOT NULL COMMENT "brief name for lists",		`WhenMade` DATETIME NOT NULL COMMENT "when this task was created",
	`Descr` VARCHAR(255) DEFAULT NULL COMMENT "longer description; may contain wiki links",		`WhenDone` DATETIME NOT NULL COMMENT "when task was completed or abandoned",
	`ID_User` INT NOT NULL COMMENT "~~ID of wiki~~ user ~~to whom task~~ is ~~assigned~~",		PRIMARY KEY(`ID`)
	`~~WhenMade~~` ~~DATETIME~~ NOT NULL COMMENT "~~when this task was created~~",		)
	`~~WhenDone~~` ~~DATETIME~~ ~~NOT~~ NULL COMMENT "~~when task was completed or abandoned~~",		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`)		PRIMARY KEY(`ID`)
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>

Woozle: saving work

2009-04-04T22:19:20Z

saving work

New page

==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>

User:Woozle/TaskFerret - Revision history

Woozle: more tables

Woozle: saving work