VbzCart/docs/tables/cache tables

About

• Purpose: List of tables involved in data caching (either as a source or as a cache)

SQL

<section begin=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>

<section end=sql />