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)
SQL
<mysql>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", `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>