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
Woozle (talk | contribs)
Bureaucrats, Interface administrators, interwiki, Administrators, trusted
20,104 edits
VisualWikitext
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..."
 
stuff
 
(5 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.
** '''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-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 {{l/same|text}}.
==SQL==
==SQL==
<mysql>
<mysql>
CREATE TABLE `atom` (
CREATE TABLE `pf_atom` (
   `ID`          INT             NOT NULL AUTO_INCREMENT,
   `ID`          INT NOT NULL AUTO_INCREMENT,
   `WhenCreated` DATETIME        NOT NULL COMMENT "when this question was entered",
   `ID_Class`    INT 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",
   PRIMARY KEY(`ID`)
  `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;
  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>
</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.
  • 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>

Retrieved from "https://htyp.org/mw/index.php?title=User:Woozle/PostFerret/sql/atom&oldid=21055"