VbzCart/tables/ord hold type

About

to be documented

2008-12-27 Are we actually using this, or is it part of the future online ordering system redesign?

SQL

<mysql>CREATE TABLE `ord_event_types` (

 `ID`           INT NOT NULL AUTO_INCREMENT,
 `Display`      VARCHAR(63) COMMENT "brief name for this event type",
 `Descr`        VARCHAR(127) COMMENT "longer description of usage",
 `isActive`     BOOL COMMENT "TRUE = order is open or on hold",

/* these fields all have 3 possible values:

0 = no change
-1 = FORBID / TURN OFF
+1 = ALLOW / TURN ON

• /

 `doRestock`  TINYINT COMMENT "allow/forbid restocking this order's items",
 `doCharge`   TINYINT COMMENT "allow/forbid charging bank card for this order",
 `doContact`  TINYINT COMMENT "turn on/off need-to-contact flag for this order",
 `doExamine`  TINYINT COMMENT "turn on/off need-to-examine flag for this order",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>