VbzCart/tables/cache tables

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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)
    • 2010-11-09 renamed data_tables -> cache tables

SQL

<mysql>CREATE TABLE `cache_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;</mysql>