VbzCart/tables/cache queries

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
  • 2011-12-24 Adding Sort field so execution order can be specified

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",
   `Sort`      FLOAT          DEFAULT NULL COMMENT "optional: sorting order for execution",
   `Notes`     VARCHAR(255)   DEFAULT NULL COMMENT "explanatory notes",
   PRIMARY KEY (`ID`)
) ENGINE = MYISAM;</mysql>