VbzCart/docs/tables/cache queries: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
("Sort" too difficult to implement in code as compared to the benefit)
m (Woozle moved page VbzCart/VbzCart/tables/cache queries to VbzCart/docs/tables/cache queries without leaving a redirect: part 3/5)
 
(No difference)

Latest revision as of 01:56, 25 February 2024

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

<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 />

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/tables/cache_queries&oldid=6858"