VbzCart/docs/tables/ord msg media

About

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

SQL

<section begin=sql /><mysql>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');</mysql>

<section end=sql />