VbzCart/tables/var global - Revision history

Woozle: structural changes, documentation

2009-09-27T15:34:03Z

structural changes, documentation

← Older revision		Revision as of 15:34, 27 September 2009
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''':~~computed variables~~, ~~cache timestamps~~, ~~and other variable stuff~~		* '''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 `~~stats~~` (		<section begin=sql /><mysql> CREATE TABLE `var_global` (
	`Name` ~~varchar~~(32) NOT NULL COMMENT 'name of variable',		`Name` VARCHAR(255) NOT NULL COMMENT "name of variable",
	`Value` ~~varchar~~(255) COMMENT 'value 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`)		PRIMARY KEY(`Name`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: moved VbzCart/tables/stats to VbzCart/tables/var global: more universal and descriptive name

2009-09-27T15:19:51Z

moved VbzCart/tables/stats to VbzCart/tables/var global: more universal and descriptive name

← Older revision	Revision as of 15:19, 27 September 2009
(No difference)

Woozle: 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...

2009-03-08T19:20:51Z

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

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 stuff
==SQL==
<section begin=sql /><mysql> CREATE TABLE `stats` (
`Name` varchar(32) NOT NULL COMMENT 'name of variable',
`Value` varchar(255) COMMENT 'value of variable',
PRIMARY KEY(`Name`)
) ENGINE = MYISAM;</mysql>
<section end=sql />