VbzCart/tables/ctg groups

About

 * Purpose: Master list of Catalog Management Groups (CMGs, aka TGroups) -- see VbzCart/catalog/building
 * Fields:
 * ID_Supplier: supplier to which this group applies; NULL = no fixed supplier, can be used for any of them
 * ID_Redir: ctg_groups.ID -- if not null, redirect all references to the current ID to use ID_Redir instead. This is used to indicate a disused CMG (at the moment, I can't remember why it was better to do this than to just edit the existing CMG, but I'm sure there was a reason).
 * Future: It may be that ID_Redir isn't really a useful thing to have. For now (2010-11-17), I'm not going to bother making it editable in the administration screen for this table.

SQL
CREATE TABLE `ctg_groups` ( ID          INT NOT NULL AUTO_INCREMENT,  ID_Supplier INT DEFAULT NULL COMMENT "cat_supp.ID to which this CMG uniquely applies",  Name        VARCHAR(63) DEFAULT NULL COMMENT "Name of this group (brief)",  Descr       VARCHAR(127) DEFAULT NULL COMMENT "Description (for display; if NULL, use ItemType fields)",  isActive    BOOL DEFAULT FALSE,  Code        VARCHAR(7) DEFAULT NULL COMMENT "suffix for cat_items.CatNum",  Sort        VARCHAR(31) DEFAULT NULL COMMENT "sorting key within group list",  ID_Redir    INT DEFAULT NULL COMMENT "ctg_groups.ID of CMG to use instead of this one", PRIMARY KEY(`ID`) ) ENGINE = MYISAM;