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
← Older editNewer edit →
Woozle (talk | contribs)
Bureaucrats, Interface administrators, interwiki, Administrators, trusted
20,104 edits
VisualWikitext
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"