Difference between revisions of "VbzCart/tables/cache tables"
Jump to navigation
Jump to search
(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 ...) |
|||
Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': List of tables involved in data caching (either as a source or as a cache) | * '''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) | ||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>DROP TABLE IF EXISTS `data_tables`; | <section begin=sql /><mysql>DROP TABLE IF EXISTS `data_tables`; | ||
Line 6: | Line 8: | ||
CREATE TABLE `data_tables` ( | CREATE TABLE `data_tables` ( | ||
`ID` INT NOT NULL AUTO_INCREMENT, | `ID` INT NOT NULL AUTO_INCREMENT, | ||
− | `Name` varchar(63) NOT NULL COMMENT "name of table being tracked", | + | `Name` varchar(63) NOT NULL COMMENT "name of table being tracked", |
− | `WhenUpdated` DATETIME DEFAULT NULL COMMENT "when the table's data was last modified", | + | `isActive` tinyint(1) NOT NULL default '0' COMMENT "FALSE = do not use this table", |
− | `Notes` varchar(255) DEFAULT NULL COMMENT "descriptive notes", | + | `WhenUpdated` DATETIME DEFAULT NULL COMMENT "when the table's data was last modified", |
+ | `Notes` varchar(255) DEFAULT NULL COMMENT "descriptive notes", | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) ENGINE = MYISAM;</mysql> | ) ENGINE = MYISAM;</mysql> | ||
<section end=sql /> | <section end=sql /> |
Revision as of 17:15, 12 April 2009
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)
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", `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>