VbzCart/tables/cache tables
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>