W3TPL/dev

Class Data

After discovering the existence of page_props I began to think that these tables might actually be unnecessary, but I'm keeping these table specs here in case I change my mind later. I think some PHP code was written to use these tables, but it never got to the point of being usable; it should probably be stripped out (maybe archive it here).

These tables were originally intended to be added to the wiki's database, but with the possibility that they might go in a separate db to allow sharing between multiple wikis.

<mysql>CREATE TABLE `w3_class` (

  `ID` INT  NOT NULL AUTO_INCREMENT,
  `Name`     VARCHAR(63) COMMENT 'name of class',
  PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>

<mysql>CREATE TABLE `w3_method` (

  `ID_class` INT          NOT NULL AUTO_INCREMENT COMMENT "ID of w3_class to which this field belongs",
  `Name`     VARCHAR(63)  NOT NULL                COMMENT "name of method",
  `Code`     VARCHAR(255) NOT NULL                COMMENT "method's code",
  PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>

<mysql>CREATE TABLE `w3_object` (

  `ID`       INT NOT NULL AUTO_INCREMENT,
  `ID_class` INT NOT NULL COMMENT "ID of w3_class for this object"
  `Name`     VARCHAR(63)  COMMENT 'name of object',
  PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>

<mysql>CREATE TABLE `w3_field` (

  `ID_object` INT         NOT NULL AUTO_INCREMENT COMMENT "ID of w3_object to which this field belongs",
  `Name`     VARCHAR(63)  NOT NULL                COMMENT "name of field",
  `Value`    VARCHAR(255) NOT NULL                COMMENT "value of field",
  PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>