Difference between revisions of "VbzCart/tables/ord trx type"
Jump to navigation
Jump to search
m (VbzCart/tables/ord trx types moved to VbzCart/tables/ord trx type: oops, trying to make table names singular from now on...) |
(fixed name of table in SQL) |
||
| Line 4: | Line 4: | ||
** '''2008-12-27''' Adapted from MS Access version (table "TrxTypes") | ** '''2008-12-27''' Adapted from MS Access version (table "TrxTypes") | ||
==SQL== | ==SQL== | ||
| − | <section begin=sql /><mysql>CREATE TABLE ` | + | <section begin=sql /><mysql>CREATE TABLE `ord_trx_type` ( |
`ID` INT NOT NULL AUTO_INCREMENT, | `ID` INT NOT NULL AUTO_INCREMENT, | ||
`Code` VARCHAR(15), | `Code` VARCHAR(15), | ||
Revision as of 18:13, 27 December 2008
About
- Purpose: Types of transactions for
- REDIRECT Template:l/vc/table
- History:
- 2008-12-27 Adapted from MS Access version (table "TrxTypes")
SQL
<mysql>CREATE TABLE `ord_trx_type` (
`ID` INT NOT NULL AUTO_INCREMENT, `Code` VARCHAR(15), `Descr` VARCHAR(255), `isCash` BIT COMMENT "is actual money being sent/recived", `isCard` BIT COMMENT "is checkcard or credit card (TRUE requires isCash=TRUE)", `isCheck` BIT COMMENT "is check or money order (TRUE requires isCash=TRUE)", `isShipg` BIT COMMENT "is shipping charge/refund", PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>