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

Woozle: stuff

2015-06-29T23:02:54Z

stuff

← Older revision		Revision as of 23:02, 29 June 2015
Line 2:		Line 2:
	* '''Purpose''': root record for all content types		* '''Purpose''': root record for all content types
	* '''Fields''':		* '''Fields''':
	** '''~~Class~~''': ID of {{l/same\|class}} record that is applicable to this Atom		** '''ID_Class''': ID of {{l/same\|class}} record that is applicable to this Atom
			*** This makes it possible to locate the appropriate code to display (or do other things with) an atom given only the atom's ID.
	* '''History''':		* '''History''':
	** '''2013-03-12''' Created, but not yet in use.		** '''2013-03-12''' Created, but not yet in use.
Line 9:		Line 10:
	** '''2013-07-19''' Added "Class" field; corrected field descriptions referring to "question"		** '''2013-07-19''' Added "Class" field; corrected field descriptions referring to "question"
	*** Maybe "QtyEdits" should be renamed "Version".		*** Maybe "QtyEdits" should be renamed "Version".
			** '''2015-06-29''' Stripped off timestamps, ownership, and revision #, since that stuff is now tracked in {{l/same\|text}}.
	==SQL==		==SQL==
	<mysql>		<mysql>
	CREATE TABLE `pf_atom` (		CREATE TABLE `pf_atom` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`~~Class~~` ~~VARCHAR(15)~~ NOT NULL COMMENT "what type of chain is using this atom",		`ID_Class` INT NOT NULL COMMENT "what type of chain is using this atom",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)
Line 25:		Line 27:
	`WhenEdited` DATETIME DEFAULT NULL COMMENT "when it was last edited",		`WhenEdited` DATETIME DEFAULT NULL COMMENT "when it was last edited",
	`WhoEdited` INT DEFAULT NULL COMMENT "ID of user who last edited it",		`WhoEdited` INT DEFAULT NULL COMMENT "ID of user who last edited it",
	`~~Revision~~` INT DEFAULT NULL COMMENT "number of times it has been edited~~; referenced by version history~~",		`QtyEdits` INT DEFAULT NULL COMMENT "number of times it has been edited",
	</mysql>		</mysql>

Woozle: stripping out stuff not needed (yet)

2015-06-29T22:42:11Z

stripping out stuff not needed (yet)

← Older revision		Revision as of 22:42, 29 June 2015
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''':		* '''Purpose''': root record for all content types
	* '''Fields''':		* '''Fields''':
			** '''Class''': ID of {{l/same\|class}} record that is applicable to this Atom
	* '''History''':		* '''History''':
	** '''2013-03-12''' Created, but not yet in use.		** '''2013-03-12''' Created, but not yet in use.
Line 10:		Line 11:
	==SQL==		==SQL==
	<mysql>		<mysql>
	CREATE TABLE `~~atom~~` (		CREATE TABLE `pf_atom` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`Class` VARCHAR(15) NOT NULL COMMENT "what type of chain is using this atom",		`Class` VARCHAR(15) NOT NULL COMMENT "what type of chain is using this atom",
			PRIMARY KEY(`ID`)
			)
			ENGINE = MYISAM;
			</mysql>
			==Not Used==
			I might later decide that some of these would be useful, but for now I'm taking out anything I can't immediately see a use for:
			<mysql>
	`WhenCreated` DATETIME NOT NULL COMMENT "when the record-chain attached to this atom was created",		`WhenCreated` DATETIME NOT NULL COMMENT "when the record-chain attached to this atom was created",
	`WhoCreated` INT NOT NULL COMMENT "ID (site-defined) of user who created it",		`WhoCreated` INT NOT NULL COMMENT "ID (site-defined) of user who created it",
	`WhenEdited` DATETIME DEFAULT NULL COMMENT "when it was last edited",		`WhenEdited` DATETIME DEFAULT NULL COMMENT "when it was last edited",
	`WhoEdited` INT DEFAULT NULL COMMENT "ID of user who last edited it",		`WhoEdited` INT DEFAULT NULL COMMENT "ID of user who last edited it",
	`~~QtyEdits~~` INT DEFAULT NULL COMMENT "number of times it has been edited ~~(i.e.~~ version ~~number)~~",		`Revision` INT DEFAULT NULL COMMENT "number of times it has been edited; referenced by version history",
	~~PRIMARY KEY(`ID`)~~
	)
	~~ENGINE = MYISAM;~~
	</mysql>		</mysql>

Woozle: 4 revisions imported: PostFerret from ICMS

2015-06-29T01:51:40Z

4 revisions imported: PostFerret from ICMS

← Older revision	Revision as of 01:51, 29 June 2015
(No difference)

Woozle: Class field and comment tweaks

2013-07-19T18:48:40Z

Class field and comment tweaks

← Older revision		Revision as of 18:48, 19 July 2013
Line 6:		Line 6:
	** '''2013-03-15''' Most fields moved from {{l/same\|post}} to {{l/same\|atom}}.		** '''2013-03-15''' Most fields moved from {{l/same\|post}} to {{l/same\|atom}}.
	** '''2013-06-28''' "Summary" can't be a key if it's no longer a field.		** '''2013-06-28''' "Summary" can't be a key if it's no longer a field.
			** '''2013-07-19''' Added "Class" field; corrected field descriptions referring to "question"
			*** Maybe "QtyEdits" should be renamed "Version".
	==SQL==		==SQL==
	<mysql>		<mysql>
	CREATE TABLE `atom` (		CREATE TABLE `atom` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`WhenCreated` DATETIME NOT NULL COMMENT "when this ~~question~~ was ~~entered~~",		`Class` VARCHAR(15) NOT NULL COMMENT "what type of chain is using this atom",
	`WhoCreated` INT NOT NULL COMMENT "ID (site-defined) of user who ~~added the question~~",		`WhenCreated` DATETIME NOT NULL COMMENT "when the record-chain attached to this atom was created",
	`WhenEdited` DATETIME DEFAULT NULL COMMENT "when ~~this question~~ was last edited",		`WhoCreated` INT NOT NULL COMMENT "ID (site-defined) of user who created it",
	`WhoEdited` INT DEFAULT NULL COMMENT "ID of user who last edited ~~the question~~",		`WhenEdited` DATETIME DEFAULT NULL COMMENT "when it was last edited",
	`QtyEdits` INT DEFAULT NULL COMMENT "number of times ~~this question~~ has been edited",		`WhoEdited` INT DEFAULT NULL COMMENT "ID of user who last edited it",
			`QtyEdits` INT DEFAULT NULL COMMENT "number of times it has been edited (i.e. version number)",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)
	ENGINE = MYISAM;		ENGINE = MYISAM;
	</mysql>		</mysql>

Woozle: syntax fix

2013-07-14T15:17:06Z

syntax fix

← Older revision		Revision as of 15:17, 14 July 2013
Line 15:		Line 15:
	`WhoEdited` INT DEFAULT NULL COMMENT "ID of user who last edited the question",		`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",		`QtyEdits` INT DEFAULT NULL COMMENT "number of times this question has been edited",
	PRIMARY KEY(`ID`),		PRIMARY KEY(`ID`)
	)		)
	ENGINE = MYISAM;		ENGINE = MYISAM;
	</mysql>		</mysql>

Woozle: leftover bugfix

2013-06-28T18:38:00Z

leftover bugfix

← Older revision		Revision as of 18:38, 28 June 2013
Line 5:		Line 5:
	** '''2013-03-12''' Created, but not yet in use.		** '''2013-03-12''' Created, but not yet in use.
	** '''2013-03-15''' Most fields moved from {{l/same\|post}} to {{l/same\|atom}}.		** '''2013-03-15''' Most fields moved from {{l/same\|post}} to {{l/same\|atom}}.
			** '''2013-06-28''' "Summary" can't be a key if it's no longer a field.
	==SQL==		==SQL==
	<mysql>		<mysql>
Line 15:		Line 16:
	`QtyEdits` INT DEFAULT NULL COMMENT "number of times this question has been edited",		`QtyEdits` INT DEFAULT NULL COMMENT "number of times this question has been edited",
	PRIMARY KEY(`ID`),		PRIMARY KEY(`ID`),
	~~UNIQUE KEY `content` (`Summary`)~~
	)		)
	ENGINE = MYISAM;		ENGINE = MYISAM;
	</mysql>		</mysql>

Woozle: Created page with "==About== * '''Purpose''': * '''Fields''': * '''History''': '''2013-03-12''' Created, but not yet in use. '''2013-03-15''' Most fields moved from {{l/same|post}} to {{l..."

2013-03-15T20:48:27Z

Created page with "==About== * '''Purpose''': * '''Fields''': * '''History''': ** '''2013-03-12''' Created, but not yet in use. ** '''2013-03-15''' Most fields moved from {{l/same|post}} to {{l..."

New page

==About==
* '''Purpose''':
* '''Fields''':
* '''History''':
** '''2013-03-12''' Created, but not yet in use.
** '''2013-03-15''' Most fields moved from {{l/same|post}} to {{l/same|atom}}.
==SQL==
<mysql>
CREATE TABLE `atom` (
`ID` INT NOT NULL AUTO_INCREMENT,
`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>