InstaGov/schema/post - Revision history

Woozle: superceded by PostFerret, probably

2013-03-24T15:15:17Z

superceded by PostFerret, probably

← Older revision		Revision as of 15:15, 24 March 2013
Line 1:		Line 1:
	==About==		==About==
			* '''Status''': superceded (probably) by [http://iseeamess.com/wiki/PostFerret PostFerret].
	* '''Purpose''': a trackable piece of text (can be modified, has edit history, etc.)		* '''Purpose''': a trackable piece of text (can be modified, has edit history, etc.)
	*: for handling functionality common to several table types (question, answer, point)		*: for handling functionality common to several table types (question, answer, point)

Woozle: used by

2013-03-12T21:02:27Z

used by

← Older revision		Revision as of 21:02, 12 March 2013
Line 2:		Line 2:
	* '''Purpose''': a trackable piece of text (can be modified, has edit history, etc.)		* '''Purpose''': a trackable piece of text (can be modified, has edit history, etc.)
	*: for handling functionality common to several table types (question, answer, point)		*: for handling functionality common to several table types (question, answer, point)
			* '''Used by''': {{l/same\|claim}}; eventually {{l/same\|question}} and {{l/same\|answer}}.
	* '''History''':		* '''History''':
	** '''2013-03-12''' Created, but not yet in use.		** '''2013-03-12''' Created, but not yet in use.

Woozle: Created page with "==About== * '''Purpose''': a trackable piece of text (can be modified, has edit history, etc.) *: for handling functionality common to several table types (question, answer, p..."

2013-03-12T14:07:18Z

Created page with "==About== * '''Purpose''': a trackable piece of text (can be modified, has edit history, etc.) *: for handling functionality common to several table types (question, answer, p..."

New page

==About==
* '''Purpose''': a trackable piece of text (can be modified, has edit history, etc.)
*: for handling functionality common to several table types (question, answer, point)
* '''History''':
** '''2013-03-12''' Created, but not yet in use.
==SQL==
<mysql>
CREATE TABLE `post` (
`ID` INT NOT NULL AUTO_INCREMENT,
`Summary` VARCHAR(255) NOT NULL COMMENT "short description of post, for listings",
`URI` VARCHAR(255) DEFAULT NULL COMMENT "site-relative URI for more information",
`WhenCreated` DATETIME NOT NULL COMMENT "when this question was entered",
`WhoCreated` INT NOT NULL COMMENT "ID (site-defined) of user who added the question",
`WhenEdited` DATETIME DEFAULT NULL COMMENT "when this question was last edited",
`WhoEdited` INT DEFAULT NULL COMMENT "ID of user who last edited the question",
`QtyEdits` INT DEFAULT NULL COMMENT "number of times this question has been edited",
PRIMARY KEY(`ID`),
UNIQUE KEY `content` (`Summary`)
)
ENGINE = MYISAM;
</mysql>