VbzCart/tables/var global

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

<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>