VbzCart/docs/tables/var global

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search

About

  • Status: not currently being used, but is probably needed for proper stats display in controlbar
  • Purpose: any simple data which needs to be both persistent and easily updateable by the code
    • currently needed for tracking the current order number
    • later, may be used for storing calculated statistics for the sidebar
  • History:
    • 2009-09-27 renamed from "stats" to "var_global" to reflect new purpose
      • Name length increased from 32 to 255 to make it easier to indicate hierarchy, if needed
      • Added When* fields, mainly as a sort of debug/reality check

SQL

<section begin=sql /><mysql> CREATE TABLE `var_global` ( 

   `Name`    VARCHAR(255)     NOT NULL COMMENT "name of variable",
   `Value`   VARCHAR(255) DEFAULT NULL COMMENT "value of variable",
   `WhenCreated` DATETIME     NOT NULL COMMENT "when variable was first created",
   `WhenUpdated` DATETIME DEFAULT NULL COMMENT "when variable's value was changed",
  PRIMARY KEY(`Name`)
) ENGINE = MYISAM;</mysql>

<section end=sql />

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