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

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
(updating history and SQL before renaming page)
imported>Woozle
m (moved VbzCart/tables/data flow to VbzCart/tables/cache flow: rewriting caching processes)
(No difference)

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=5663"