VbzCart/docs/tables/cache flow: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle m (moved VbzCart/tables/data flow to VbzCart/tables/cache flow: rewriting caching processes) |
imported>Woozle (updated purpose) |
||
Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': Keeps track of data dependencies between tables – which | * '''Purpose''': Keeps track of data dependencies between tables – which queries update cached data in which tables from which sources | ||
* '''Refers to''': {{vbzcart|table|cache_tables}}, {{vbzcart|table|cache_queries}} | * '''Refers to''': {{vbzcart|table|cache_tables}}, {{vbzcart|table|cache_queries}} | ||
* '''History''': | * '''History''': |
Revision as of 14:19, 9 November 2010
About
- Purpose: Keeps track of data dependencies between tables – which queries update cached data in which tables from which sources
- Refers to: Template:Vbzcart, Template:Vbzcart
- History:
- 2010-11-09 Renamed data_flow -> cache_flow; ID_Proc -> ID_Query
SQL
<section begin=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>
<section end=sql />