Woozle: removed ID; this is now a class (content type)

2015-06-30T01:55:24Z

removed ID; this is now a class (content type)

← Older revision		Revision as of 01:55, 30 June 2015
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': text records/revisions		* '''Purpose''': content type -- text records/revisions
	** For now all revisions go in the same table; later, we should probably move old revisions into an archive so they don't slow down access to the ones currently in use.		** For now all revisions go in the same table; later, we should probably move old revisions into an archive so they don't slow down access to the ones currently in use.
	* '''History''':		* '''History''':
Line 7:		Line 7:
	<mysql>		<mysql>
	CREATE TABLE `pf_text` (		CREATE TABLE `pf_text` (
	`ID` INT NOT NULL ~~AUTO_INCREMENT~~,		`ID_Atom` INT NOT NULL COMMENT "Atom used by this record",
	`ID_Prev` INT NOT NULL COMMENT "ID of previous revision; if none, must equal self.ID",		`ID_Prev` INT NOT NULL COMMENT "ID of previous revision; if none, must equal self.ID",
	`Revision` INT NOT NULL COMMENT "revision number for this record; does not change; must be one higher than previous record's",		`Revision` INT NOT NULL COMMENT "revision number for this record; does not change; must be one higher than previous record's",
Line 13:		Line 13:
	`WhoSaved` INT DEFAULT NULL COMMENT "CMS-defined ID of who created this revision",		`WhoSaved` INT DEFAULT NULL COMMENT "CMS-defined ID of who created this revision",
	`Content` TEXT NOT NULL COMMENT "the actual text"		`Content` TEXT NOT NULL COMMENT "the actual text"
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID_Atom`)
	)		)
	ENGINE = MYISAM;		ENGINE = MYISAM;

Woozle: first draft

2015-06-29T23:02:18Z

first draft

New page

==About==
* '''Purpose''': text records/revisions
** For now all revisions go in the same table; later, we should probably move old revisions into an archive so they don't slow down access to the ones currently in use.
* '''History''':
** '''2015-06-29''' first draft
==SQL==
<mysql>
CREATE TABLE `pf_text` (
`ID` INT NOT NULL AUTO_INCREMENT,
`ID_Prev` INT NOT NULL COMMENT "ID of previous revision; if none, must equal self.ID",
`Revision` INT NOT NULL COMMENT "revision number for this record; does not change; must be one higher than previous record's",
`WhenSaved` DATETIME NOT NULL COMMENT "when this revision was created",
`WhoSaved` INT DEFAULT NULL COMMENT "CMS-defined ID of who created this revision",
`Content` TEXT NOT NULL COMMENT "the actual text"
PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;
</mysql>
==Not Used==
`ID_Atom` INT NOT NULL COMMENT "ID of atom to which this text belongs",

User:Woozle/PostFerret/sql/text - Revision history

Woozle: removed ID; this is now a class (content type)

Woozle: first draft