VbzCart/docs/tables/event vc ord hold

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Revision as of 15:28, 27 December 2008 by imported>Woozle (extracted from VbzCart/tables)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

to be documented

SQL

<section begin=sql /><mysql>CREATE TABLE `ord_events` (

 `ID`        INT NOT NULL AUTO_INCREMENT,
 `ID_Ord`    INT NOT NULL COMMENT "core_orders.ID",
 `ID_Type`   INT NOT NULL COMMENT "ord_event_types.ID",
 `WhenDone`  DATETIME COMMENT "when the event happened",
 `Notes`     VARCHAR(255) COMMENT "human-entered notes, if needed",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql> <section end=sql />