VbzCart/tables/cache queries
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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>