VbzCart/tables/data tables

From HTYP, the free directory anyone can edit

[edit] About

• Purpose: List of tables involved in data caching (either as a source or as a cache)
• History:
  • 2009-04-12 made the "isActive" field official, and changed it from BIT(1) to TINYINT(1)

[edit] SQL

DROP TABLE IF EXISTS `data_tables`;
 
CREATE TABLE `data_tables` (
    `ID` INT NOT NULL AUTO_INCREMENT,
    `Name` VARCHAR(63) NOT NULL                COMMENT "name of table being tracked",
    `isActive` TINYINT(1) NOT NULL DEFAULT '0' COMMENT "FALSE = do not use this table",
    `WhenUpdated` DATETIME DEFAULT NULL        COMMENT "when the table's data was last modified",
    `Notes` VARCHAR(255) DEFAULT NULL          COMMENT "descriptive notes",
   PRIMARY KEY(`ID`)
 ) ENGINE = MYISAM;