Difference between revisions of "VbzCart/tables/cache queries"
Jump to navigation
Jump to search
(changing name internally prior to renaming page; history update) |
("Sort" too difficult to implement in code as compared to the benefit) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': List of [[VbzCart/procs|stored procedures]] which update one table from others | * '''Purpose''': List of [[VbzCart/procs|stored procedures]] which update one table from others | ||
| + | * '''Future''': rename to cache_procs | ||
* '''History''': | * '''History''': | ||
** '''2010-11-09''' Renamed data_procs -> cache_queries | ** '''2010-11-09''' Renamed data_procs -> cache_queries | ||
Latest revision as of 19:02, 24 December 2011
About
- Purpose: List of stored procedures which update one table from others
- Future: rename to cache_procs
- History:
- 2010-11-09 Renamed data_procs -> cache_queries
SQL
<mysql>CREATE TABLE `cache_queries` (
`ID` INT AUTO_INCREMENT NOT NULL COMMENT "procedure ID", `Name` VARCHAR(127) NOT NULL COMMENT "name of SQL stored procedure", `isActive` BOOL COMMENT "FALSE = skip this record", `doesClear` BOOL COMMENT "TRUE = clears all data from table before starting", `Notes` VARCHAR(255) DEFAULT NULL COMMENT "explanatory notes", PRIMARY KEY (`ID`) ) ENGINE = MYISAM;</mysql>