VbzCart/archive/tables - Revision history

Woozle: more tables already marked obsolete

2016-03-07T21:31:50Z

more tables already marked obsolete

← Older revision		Revision as of 21:31, 7 March 2016
Line 2:		Line 2:
	* {{l/vc/table\|ctg_updates}}		* {{l/vc/table\|ctg_updates}}
	* {{l/vc/table\|stk_history_legacy}} - for accommodating old nonconforming data; no longer used		* {{l/vc/table\|stk_history_legacy}} - for accommodating old nonconforming data; no longer used
			* {{l/vc/table\|core_restocks}}
			* {{l/vc/table\|rstk_lines}}
			* {{l/vc/table\|shop_cart_data_type}}
			* {{l/vc/table\|shop_log}} - not sure if it was ever used, or what it would have been for

	==updates==		==updates==

2016-03-03T23:02:09Z

stk_history_legacy

← Older revision		Revision as of 23:02, 3 March 2016
Line 1:		Line 1:
	==on other pages==		==on other pages==
	* {{~~vbzcart~~\|table\|~~ctg_updates~~}}		* {{l/vc/table\|ctg_updates}}
			* {{l/vc/table\|stk_history_legacy}} - for accommodating old nonconforming data; no longer used

	==updates==		==updates==
	* '''Purpose''': timestamps on tables so we know when update queries need to be run		* '''Purpose''': timestamps on tables so we know when update queries need to be run

2014-12-19T02:05:47Z

← Older revision	Revision as of 02:05, 19 December 2014
(No difference)

2012-12-23T00:09:49Z

← Older revision	Revision as of 00:09, 23 December 2012
(No difference)

2012-12-22T13:59:12Z

moved archival page from VbzWiki

@@ Line 5: / Line 5: @@
 * '''Status''': probably superceded by data flow tables and procs
 ===SQL===
-<section begin=sql /><mysql> CREATE TABLE `updates` (
+<mysql> CREATE TABLE `updates` (
      `Name` varchar(32) NOT NULL COMMENT 'name of thing which gets updated',
      `Updated` datetime COMMENT 'when last updated',
     PRIMARY KEY(`Name`)
   ) ENGINE = MYISAM;</mysql>
 Function to record an update (not tested):
-<section begin=sql /><mysql> CREATE PROCEDURE SetUpdate(IN iName varchar(32))
+<mysql> CREATE PROCEDURE SetUpdate(IN iName varchar(32))
   BEGIN
     REPLACE INTO updates(Name,Updated) values(iName, NOW());
   END</mysql>
-<section end=sql />
+==MS Access version==

2009-07-02T23:50:02Z

ctg_updates now discarded

← Older revision		Revision as of 23:50, 2 July 2009
Line 1:		Line 1:
			==on other pages==
			* {{vbzcart\|table\|ctg_updates}}
	==updates==		==updates==
	* '''Purpose''': timestamps on tables so we know when update queries need to be run		* '''Purpose''': timestamps on tables so we know when update queries need to be run

← Older revision		Revision as of 21:31, 7 March 2016
Line 2:		Line 2:
	* {{l/vc/table\|ctg_updates}}		* {{l/vc/table\|ctg_updates}}
	* {{l/vc/table\|stk_history_legacy}} - for accommodating old nonconforming data; no longer used		* {{l/vc/table\|stk_history_legacy}} - for accommodating old nonconforming data; no longer used
			* {{l/vc/table\|core_restocks}}
			* {{l/vc/table\|rstk_lines}}
			* {{l/vc/table\|shop_cart_data_type}}
			* {{l/vc/table\|shop_log}} - not sure if it was ever used, or what it would have been for

	==updates==		==updates==