VbzCart/tables/cache queries - Revision history

Woozle: "Sort" too difficult to implement in code as compared to the benefit

2011-12-24T19:02:21Z

"Sort" too difficult to implement in code as compared to the benefit

← Older revision		Revision as of 19:02, 24 December 2011
Line 4:		Line 4:
	* '''History''':		* '''History''':
	** '''2010-11-09''' Renamed data_procs -> cache_queries		** '''2010-11-09''' Renamed data_procs -> cache_queries
	** '''2011-12-24''' Adding '''Sort''' field so execution order can be specified
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `cache_queries` (		<section begin=sql /><mysql>CREATE TABLE `cache_queries` (
Line 11:		Line 10:
	`isActive` BOOL COMMENT "FALSE = skip this record",		`isActive` BOOL COMMENT "FALSE = skip this record",
	`doesClear` BOOL COMMENT "TRUE = clears all data from table before starting",		`doesClear` BOOL COMMENT "TRUE = clears all data from table before starting",
	~~`Sort` FLOAT DEFAULT NULL COMMENT "optional: sorting order for execution",~~
	`Notes` VARCHAR(255) DEFAULT NULL COMMENT "explanatory notes",		`Notes` VARCHAR(255) DEFAULT NULL COMMENT "explanatory notes",
	PRIMARY KEY (`ID`)		PRIMARY KEY (`ID`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: Sort field

2011-12-24T18:17:28Z

Sort field

← Older revision		Revision as of 18:17, 24 December 2011
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': List of [[VbzCart/procs\|stored procedures]] which update one table from others		* '''Purpose''': List of [[VbzCart/procs\|stored procedures]] which update one table from others
			* '''Future''': rename to cache_procs
	* '''History''':		* '''History''':
	** '''2010-11-09''' Renamed data_procs -> cache_queries		** '''2010-11-09''' Renamed data_procs -> cache_queries
			** '''2011-12-24''' Adding '''Sort''' field so execution order can be specified
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `cache_queries` (		<section begin=sql /><mysql>CREATE TABLE `cache_queries` (
Line 9:		Line 11:
	`isActive` BOOL COMMENT "FALSE = skip this record",		`isActive` BOOL COMMENT "FALSE = skip this record",
	`doesClear` BOOL COMMENT "TRUE = clears all data from table before starting",		`doesClear` BOOL COMMENT "TRUE = clears all data from table before starting",
			`Sort` FLOAT DEFAULT NULL COMMENT "optional: sorting order for execution",
	`Notes` VARCHAR(255) DEFAULT NULL COMMENT "explanatory notes",		`Notes` VARCHAR(255) DEFAULT NULL COMMENT "explanatory notes",
	PRIMARY KEY (`ID`)		PRIMARY KEY (`ID`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

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

2010-11-09T14:14:10Z

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

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

Woozle: changing name internally prior to renaming page; history update

2010-11-09T14:13:53Z

changing name internally prior to renaming page; history update

← Older revision		Revision as of 14:13, 9 November 2010
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': List of [[VbzCart/procs\|stored procedures]] which update one table from others		* '''Purpose''': List of [[VbzCart/procs\|stored procedures]] which update one table from others
			* '''History''':
			** '''2010-11-09''' Renamed data_procs -> cache_queries
	==SQL==		==SQL==
	<section begin=sql /><mysql>~~DROP TABLE IF EXISTS `data_procs`;~~		<section begin=sql /><mysql>CREATE TABLE `cache_queries` (
			`ID` INT AUTO_INCREMENT NOT NULL COMMENT "procedure ID",
	CREATE TABLE `~~data_procs~~` (		`Name` VARCHAR(127) NOT NULL COMMENT "name of SQL stored procedure",
	`ID` INT NOT NULL ~~AUTO_INCREMENT~~ COMMENT "procedure ID",		`isActive` BOOL COMMENT "FALSE = skip this record",
	`Name` ~~varchar~~(127) NOT NULL COMMENT "name of SQL stored procedure",		`doesClear` BOOL COMMENT "TRUE = clears all data from table before starting",
	`isActive` BOOL COMMENT "FALSE = skip this record",		`Notes` VARCHAR(255) DEFAULT NULL COMMENT "explanatory notes",
	`doesClear` BOOL COMMENT "TRUE = clears all data from table before starting",
	`Notes` ~~varchar~~(255) DEFAULT NULL COMMENT "explanatory 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 stored procedures which update one table from others ==SQL==
DROP TABLE IF EXISTS `data_procs`; CREATE T...

2009-03-08T20:58:17Z

New page: ==About== * '''Purpose''': List of stored procedures which update one table from others ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `data_procs`; CREATE T...

New page

==About==
* '''Purpose''': List of [[VbzCart/procs|stored procedures]] which update one table from others
==SQL==
<section begin=sql /><mysql>DROP TABLE IF EXISTS `data_procs`;

CREATE TABLE `data_procs` (
`ID` INT NOT NULL AUTO_INCREMENT COMMENT "procedure ID",
`Name` varchar(127) NOT NULL COMMENT "name of SQL stored procedure",
`isActive` BOOL COMMENT "FALSE = skip this record",
`doesClear` BOOL COMMENT "TRUE = clears all data from table before starting",
`Notes` varchar(255) DEFAULT NULL COMMENT "explanatory notes",
PRIMARY KEY (`ID`)
) ENGINE = MYISAM;</mysql>
<section end=sql />

VbzCart/tables/cache queries - Revision history

Woozle: "Sort" too difficult to implement in code as compared to the benefit

Woozle: Sort field

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

Woozle: changing name internally prior to renaming page; history update

Woozle: New page: ==About== * '''Purpose''': List of stored procedures which update one table from others ==SQL== DROP TABLE IF EXISTS `data_procs`; CREATE T...

Woozle: New page: ==About== * '''Purpose''': List of stored procedures which update one table from others ==SQL==
DROP TABLE IF EXISTS `data_procs`; CREATE T...