VbzCart/docs/tables/cache tables: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle m (moved VbzCart/tables/data tables to VbzCart/tables/cache tables: rewriting caching processes) |
m (Woozle moved page VbzCart/VbzCart/tables/cache tables to VbzCart/docs/tables/cache tables without leaving a redirect: part 3/5) |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 3: | Line 3: | ||
* '''History''': | * '''History''': | ||
** '''2009-04-12''' made the "isActive" field official, and changed it from BIT(1) to TINYINT(1) | ** '''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== | ==SQL== | ||
<section begin=sql /><mysql> | <section begin=sql /><mysql>CREATE TABLE `cache_tables` ( | ||
CREATE TABLE ` | |||
`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", | ||
Latest revision as of 01:56, 25 February 2024
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
<section begin=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>
<section end=sql />