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

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
(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...)
 
imported>Woozle
(updating history and SQL before renaming page)
Line 1: Line 1:
==About==
==About==
* '''Purpose''': Keeps track of data dependencies between tables &ndash; which procs update which caches from which sources
* '''Purpose''': Keeps track of data dependencies between tables &ndash; 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>DROP TABLE IF EXISTS `data_flow`;
<section begin=sql /><mysql>CREATE TABLE `cache_flow` (
 
     ID_Srce INT NOT NULL COMMENT "cache_tables.ID of SOURCE table",
CREATE TABLE `data_flow` (
     ID_Dest INT NOT NULL COMMENT "cache_tables.ID of DESTINATION table",
     ID_Srce INT NOT NULL COMMENT "data_tables.ID of SOURCE table",
     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 "data_tables.ID of DESTINATION table",
     Notes   VARCHAR(255) COMMENT "loose explanatory or descriptive notes",
     ID_Proc INT NOT NULL COMMENT "data_procs.ID of stored procedure which calculates Dest data from Srce data",
     PRIMARY KEY (`ID_Srce`,`ID_Dest`,`ID_Query`)
     Notes varchar(255) COMMENT "loose explanatory or descriptive notes",
     PRIMARY KEY (`ID_Srce`,`ID_Dest`,`ID_Proc`)
  ) 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: 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 />

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