VbzCart/tables/cache tables - Revision history

Woozle: updating SQL

2010-11-09T14:14:56Z

updating SQL

← Older revision		Revision as of 14:14, 9 November 2010
Line 5:		Line 5:
	** '''2010-11-09''' renamed data_tables -> cache tables		** '''2010-11-09''' renamed data_tables -> cache tables
	==SQL==		==SQL==
	<section begin=sql /><mysql>~~DROP TABLE IF EXISTS `data_tables`;~~		<section begin=sql /><mysql>CREATE TABLE `cache_tables` (

	CREATE TABLE `~~data_tables~~` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`Name` varchar(63) NOT NULL COMMENT "name of table being tracked",		`Name` varchar(63) NOT NULL COMMENT "name of table being tracked",

Woozle: history update

2010-11-09T14:11:13Z

history update

← Older revision		Revision as of 14:11, 9 November 2010
Line 3:		Line 3:
	* '''History''':		* '''History''':
	** '''2009-04-12''' made the "isActive" field official, and changed it from BIT(1) to TINYINT(1)		** '''2009-04-12''' made the "isActive" field official, and changed it from BIT(1) to TINYINT(1)
			** '''2010-11-09''' renamed data_tables -> cache tables
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `data_tables`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `data_tables`;

Woozle: moved VbzCart/tables/data tables to VbzCart/tables/cache tables: rewriting caching processes

2010-11-09T14:10:28Z

moved VbzCart/tables/data tables to VbzCart/tables/cache tables: rewriting caching processes

← Older revision	Revision as of 14:10, 9 November 2010
(No difference)

Woozle at 17:15, 12 April 2009

2009-04-12T17:15:59Z

← Older revision		Revision as of 17:15, 12 April 2009
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': List of tables involved in data caching (either as a source or as a cache)		* '''Purpose''': List of tables involved in data caching (either as a source or as a cache)
			* '''History''':
			** '''2009-04-12''' made the "isActive" field official, and changed it from BIT(1) to TINYINT(1)
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `data_tables`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `data_tables`;
Line 6:		Line 8:
	CREATE TABLE `data_tables` (		CREATE TABLE `data_tables` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`Name` varchar(63) NOT NULL COMMENT "name of table being tracked",		`Name` varchar(63) NOT NULL COMMENT "name of table being tracked",
	`WhenUpdated` DATETIME DEFAULT NULL COMMENT "when the table's data was last modified",		`isActive` tinyint(1) NOT NULL default '0' COMMENT "FALSE = do not use this table",
	`Notes` varchar(255) DEFAULT NULL COMMENT "descriptive notes",		`WhenUpdated` DATETIME DEFAULT NULL COMMENT "when the table's data was last modified",
			`Notes` varchar(255) DEFAULT NULL COMMENT "descriptive notes",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: New page: ==About== * '''Purpose''': List of tables involved in data caching (either as a source or as a cache) ==SQL==
DROP TABLE IF EXISTS `data_tables`; CREATE TABLE ...

2009-03-08T20:56:09Z

New page: ==About== * '''Purpose''': List of tables involved in data caching (either as a source or as a cache) ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `data_tables`; CREATE TABLE ...

New page

==About==
* '''Purpose''': List of tables involved in data caching (either as a source or as a cache)
==SQL==
<section begin=sql /><mysql>DROP TABLE IF EXISTS `data_tables`;

CREATE TABLE `data_tables` (
`ID` INT NOT NULL AUTO_INCREMENT,
`Name` varchar(63) NOT NULL COMMENT "name of table being tracked",
`WhenUpdated` DATETIME DEFAULT NULL COMMENT "when the table's data was last modified",
`Notes` varchar(255) DEFAULT NULL COMMENT "descriptive notes",
PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>
<section end=sql />

VbzCart/tables/cache tables - Revision history

Woozle: updating SQL

Woozle: history update

Woozle: moved VbzCart/tables/data tables to VbzCart/tables/cache tables: rewriting caching processes

Woozle at 17:15, 12 April 2009

Woozle: New page: ==About== * '''Purpose''': List of tables involved in data caching (either as a source or as a cache) ==SQL== DROP TABLE IF EXISTS `data_tables`; CREATE TABLE ...

Woozle: New page: ==About== * '''Purpose''': List of tables involved in data caching (either as a source or as a cache) ==SQL==
DROP TABLE IF EXISTS `data_tables`; CREATE TABLE ...