User:Woozle/PostFerret/sql/atom: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Class field and comment tweaks |
stuff |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': | * '''Purpose''': root record for all content types | ||
* '''Fields''': | * '''Fields''': | ||
** '''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 8: | 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 ` | CREATE TABLE `pf_atom` ( | ||
`ID` INT | `ID` INT NOT NULL AUTO_INCREMENT, | ||
` | `ID_Class` INT 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 | `QtyEdits` INT DEFAULT NULL COMMENT "number of times it has been edited", | ||
</mysql> | </mysql> | ||
Latest revision as of 23:02, 29 June 2015
About
- Purpose: root record for all content types
- Fields:
- ID_Class: ID of 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.
- ID_Class: ID of class record that is applicable to this Atom
- History:
- 2013-03-12 Created, but not yet in use.
- 2013-03-15 Most fields moved from post to atom.
- 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".
- 2015-06-29 Stripped off timestamps, ownership, and revision #, since that stuff is now tracked in text.
SQL
<mysql> CREATE TABLE `pf_atom` (
`ID` INT NOT NULL AUTO_INCREMENT, `ID_Class` INT 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", `WhoCreated` INT NOT NULL COMMENT "ID (site-defined) of user who created it", `WhenEdited` DATETIME DEFAULT NULL COMMENT "when it was last 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",
</mysql>
