VbzCart/tables/cust emails

About

 * History:
 * 2009-07-09 moved to separate wiki page; no design changes
 * 2011-11-23 added WhenEnt and WhenUpd
 * Notes:
 * (2011-11-23) Possibly WhenUpd should be removed and replaced with one or both of:
 * WhenCnf (when confirmed) -- stamp whenever a new order is received that contains this email
 * WhenEdt (when edited) -- stamp whenever an admin saves the record
 * same for and

SQL
CREATE TABLE `cust_emails` ( `ID`         INT          NOT NULL AUTO_INCREMENT,  `WhenEnt`    DATETIME     NOT NULL COMMENT "date when record was first created",  `WhenUpd`    DATETIME DEFAULT NULL COMMENT "date when record was last updated",  `Name`       VARCHAR(31)           COMMENT "human-assigned name for this address (work, home...)",  `ID_Cust`    INT                   COMMENT "core_custs.ID",  `Email`      VARCHAR(255) NOT NULL COMMENT "the email address itself",  `isActive`   BOOL    DEFAULT FALSE COMMENT "NO=former address; do not use",  PRIMARY KEY(`ID`) ) ENGINE = MYISAM;