Difference between revisions of "VbzCart/tables/var global"
Jump to navigation
Jump to search
(New page: ==About== * '''Status''': not currently being used, but is probably needed for proper stats display in controlbar * '''Purpose''':computed variables, cache timestamps, and other variable s...) |
(structural changes, documentation) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Status''': not currently being used, but is probably needed for proper stats display in controlbar | * '''Status''': not currently being used, but is probably needed for proper stats display in controlbar | ||
| − | * '''Purpose''': | + | * '''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== | ==SQL== | ||
| − | <section begin=sql /><mysql> CREATE TABLE ` | + | <section begin=sql /><mysql> CREATE TABLE `var_global` ( |
| − | `Name` | + | `Name` VARCHAR(255) NOT NULL COMMENT "name of variable", |
| − | `Value` | + | `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`) | PRIMARY KEY(`Name`) | ||
) ENGINE = MYISAM;</mysql> | ) ENGINE = MYISAM;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Latest revision as of 15:34, 27 September 2009
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
- 2009-09-27 renamed from "stats" to "var_global" to reflect new purpose
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>