VbzCart/tables/ctg sources

About

 * Used by:
 * Fields:
 * ID_Supercede: Supplier Catalogs].ID of catalog which supercedes this one; NULL = this one is current
 * isCloseOut:
 * TRUE = this catalog is a list of discontinued items no longer in print (closeouts)
 * FALSE = normal catalog; items will be marked as "in print"
 * Notes:
 * To discontinue a supplier, set ID_Supercede=ID for all active sources; the catalog will then show only current stock as avaialble.

SQL
CREATE TABLE `ctg_sources` ( ID          INT NOT NULL AUTO_INCREMENT,  Name        VARCHAR(63) NOT NULL COMMENT "name of source",  Abbr        VARCHAR(15) NOT NULL COMMENT "abbreviation, for drop-down lists",  ID_Supplier INT NOT NULL COMMENT "Suppliers.ID - supplier for this source",  DateAvail   DATETIME DEFAULT NULL COMMENT "earliest date on which this source is valid",  ID_Supercede INT DEFAULT NULL COMMENT "[Supplier Catalogs].ID of catalog which supercedes this one, if any",  isCloseOut  BOOL DEFAULT FALSE COMMENT "is this a close-out catalog?",  PRIMARY KEY(`ID`) ) ENGINE = MYISAM;