VbzCart/tables/cache tables

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | tables
Revision as of 14:14, 9 November 2010 by Woozle (talk | contribs) (updating SQL)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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>