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
leftover bugfix
m syntax fix
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>

Revision as of 15:17, 14 July 2013

About

  • Purpose:
  • Fields:
  • 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.

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`)
)
ENGINE = MYISAM;

</mysql>

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