User:Woozle/Snorp/design/snorp story

About

• Purpose: each record is the root node for a Story.

SQL

<mysql>

CREATE TABLE `snorp_story` (
  `ID`                INT NOT NULL AUTO_INCREMENT,
  ID_USER             INT NOT NULL COMMENT "every Story is owned by a User; Users can have zero or more Stories",
  Title               VARCHAR(64) NOT NULL COMMENT "title for use in lists and page headers",
  Summary             // currently arguing with myself about how this should work
  PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;

</mysql>