VbzCart/tables/cache queries: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
changing name internally prior to renaming page; history update |
m moved VbzCart/tables/data procs to VbzCart/tables/cache queries: rewriting caching processes |
(No difference)
| |
Revision as of 14:14, 9 November 2010
About
- Purpose: List of stored procedures which update one table from others
- History:
- 2010-11-09 Renamed data_procs -> cache_queries
SQL
<section begin=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>
<section end=sql />
