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 20:56, 8 March 2009 by Woozle (talk | contribs) (New page: ==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 ...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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>