Difference between revisions of "User:Woozle/PostFerret/sql/atom"
< User:Woozle | PostFerret | sql
Jump to navigation
Jump to search
(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...") |
(leftover bugfix) |
||
| Line 5: | Line 5: | ||
** '''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. | ||
==SQL== | ==SQL== | ||
<mysql> | <mysql> | ||
| Line 15: | Line 16: | ||
`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 18:38, 28 June 2013
About
- Purpose:
- Fields:
- History:
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>