VbzCart/docs/tables/cache queries: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==About== * '''Purpose''': List of stored procedures which update one table from others ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `data_procs`; CREATE T...) |
imported>Woozle (changing name internally prior to renaming page; history update) |
||
| 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 | ||
* '''History''': | |||
** '''2010-11-09''' Renamed data_procs -> cache_queries | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql> | <section begin=sql /><mysql>CREATE TABLE `cache_queries` ( | ||
`ID` INT AUTO_INCREMENT NOT NULL COMMENT "procedure ID", | |||
CREATE TABLE ` | `Name` VARCHAR(127) NOT NULL COMMENT "name of SQL stored procedure", | ||
`ID` INT NOT NULL | `isActive` BOOL COMMENT "FALSE = skip this record", | ||
`Name` | `doesClear` BOOL COMMENT "TRUE = clears all data from table before starting", | ||
`isActive` BOOL COMMENT "FALSE = skip this record", | `Notes` VARCHAR(255) DEFAULT NULL COMMENT "explanatory notes", | ||
`doesClear` BOOL COMMENT "TRUE = clears all data from table before starting", | |||
`Notes` | |||
PRIMARY KEY (`ID`) | PRIMARY KEY (`ID`) | ||
) ENGINE = MYISAM;</mysql> | ) ENGINE = MYISAM;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Revision as of 14:13, 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 />