Difference between revisions of "VbzCart/tables/ord msg media"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(New page: ==About== * '''Used by''': {{vbzcart|table|ord_msg}} * '''History''': ** '''2009-07-09''' Adapted from MS Access (was [Message Media]) ==SQL== <section begin=sql /><mysql>CREATE TABLE `ord...)
 
(static data)
Line 10: Line 10:
 
   PRIMARY KEY(`ID`)
 
   PRIMARY KEY(`ID`)
 
)
 
)
−
ENGINE = MYISAM;</mysql>
+
ENGINE = MYISAM;
 +
 
 +
INSERT INTO `VbzCart`.`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 />
 
<section end=sql />

Revision as of 23:31, 23 September 2010

About

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

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 `VbzCart`.`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>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/tables/ord_msg_media&oldid=14203"