Difference between revisions of "User:Woozle/PostFerret/sql/atom"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
m (4 revisions imported: PostFerret from ICMS)
(stripping out stuff not needed (yet))
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>

Revision as of 22:42, 29 June 2015

About

  • Purpose: root record for all content types
  • Fields:
    • 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".

SQL

<mysql> CREATE TABLE `pf_atom` ( 

  `ID`          INT              NOT NULL AUTO_INCREMENT,
  `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",
  `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",
  `Revision`    INT          DEFAULT NULL COMMENT "number of times it has been edited; referenced by version history",

</mysql>

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