VbzCart/tables/ord msg media

About

 * Used by:
 * History:
 * 2009-07-09 Adapted from MS Access (was [Message Media])

SQL
CREATE TABLE `ord_msg_media` ( `ID`    INT             NOT NULL AUTO_INCREMENT,  `Abbr`  VARCHAR(15)     NOT NULL COMMENT "abbreviation for combo boxes and lists",  `Descr` VARCHAR(63) DEFAULT NULL COMMENT "longer description",  PRIMARY KEY(`ID`) ) ENGINE = MYISAM;

INSERT INTO `ord_msg_media` VALUES (1,'OrdInst','Instructions in submitted order'), (2,'PkSlip','Packing slip'), (3,'Email','Email'), (4,'Phone','Phone call'), (5,'Mail','Snail mail'), (6,'Fax','Faxed message'), (7,'AddrLbl','Shipping label (for delivery instructions)'), (8,'Internal','stored in this database only'), (9,'Unknown','not sure - was NULL in old db');