User:Woozle/StockFerret/places

About

• Purpose: all kinds of places
• Adapted from: VbzCart/tables/stk places

SQL

<mysql> CREATE TABLE `places` (

  `ID` INT NOT NULL AUTO_INCREMENT,
  `ID_Parent`    INT                       COMMENT "self.ID of place in which this place is found; may be NULL",
  `Name`         VARCHAR(63)      NOT NULL COMMENT "brief descriptive name for listings and tree-paths",
  `Descr`        VARCHAR(127) DEFAULT NULL COMMENT "(optional) description of this place, so it can be located",
  PRIMARY KEY(`ID`)
) ENGINE = MYISAM;

</mysql>