VbzCart/obsolete/tables

updates

 * Purpose: timestamps on tables so we know when update queries need to be run
 * Status: probably superceded by data flow tables and procs

SQL
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;

Function to record an update (not tested): CREATE PROCEDURE SetUpdate(IN iName varchar(32)) BEGIN REPLACE INTO updates(Name,Updated) values(iName, NOW); END

MS Access version
These are notes on table design for vbz's order management system as implemented in Microsoft Access 97.

Titles

 * Last update: 2006-05-17