Difference between revisions of "VbzCart/tables/cache flow"
Jump to navigation
Jump to search
(New page: ==About== * '''Purpose''': Keeps track of data dependencies between tables – which procs update which caches from which sources ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXIS...) |
(updating history and SQL before renaming page) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': Keeps track of data dependencies between tables – which procs update which caches from which sources | * '''Purpose''': Keeps track of data dependencies between tables – which procs update which caches from which sources | ||
| + | * '''Refers to''': {{vbzcart|table|cache_tables}}, {{vbzcart|table|cache_queries}} | ||
| + | * '''History''': | ||
| + | ** '''2010-11-09''' Renamed data_flow -> cache_flow; ID_Proc -> ID_Query | ||
==SQL== | ==SQL== | ||
| − | <section begin=sql /><mysql> | + | <section begin=sql /><mysql>CREATE TABLE `cache_flow` ( |
| − | + | ID_Srce INT NOT NULL COMMENT "cache_tables.ID of SOURCE table", | |
| − | CREATE TABLE ` | + | ID_Dest INT NOT NULL COMMENT "cache_tables.ID of DESTINATION table", |
| − | ID_Srce INT NOT NULL COMMENT " | + | ID_Query INT NOT NULL COMMENT "cache_queries.ID of stored procedure which calculates Dest data from Srce data", |
| − | ID_Dest INT NOT NULL COMMENT " | + | Notes VARCHAR(255) COMMENT "loose explanatory or descriptive notes", |
| − | + | PRIMARY KEY (`ID_Srce`,`ID_Dest`,`ID_Query`) | |
| − | Notes | ||
| − | PRIMARY KEY (`ID_Srce`,`ID_Dest`,` | ||
) ENGINE = MYISAM;</mysql> | ) ENGINE = MYISAM;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Revision as of 14:18, 9 November 2010
About
- Purpose: Keeps track of data dependencies between tables – which procs update which caches from which sources
- Refers to: cache_tables, cache_queries
- History:
- 2010-11-09 Renamed data_flow -> cache_flow; ID_Proc -> ID_Query
SQL
<mysql>CREATE TABLE `cache_flow` (
ID_Srce INT NOT NULL COMMENT "cache_tables.ID of SOURCE table", ID_Dest INT NOT NULL COMMENT "cache_tables.ID of DESTINATION table", ID_Query INT NOT NULL COMMENT "cache_queries.ID of stored procedure which calculates Dest data from Srce data", Notes VARCHAR(255) COMMENT "loose explanatory or descriptive notes", PRIMARY KEY (`ID_Srce`,`ID_Dest`,`ID_Query`) ) ENGINE = MYISAM;</mysql>