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
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>
