VbzCart/docs/tables/card auth code

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Revision as of 01:33, 10 July 2009 by imported>Woozle (New page: ==About== * '''Purpose''': reference table which translates AVS codes into natural language * '''History''': ** '''2009-07-09''' Adapted from MS Access ==SQL== <section begin=sql /><mysql>...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

  • Purpose: reference table which translates AVS codes into natural language
  • History:
    • 2009-07-09 Adapted from MS Access

SQL

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

 `Ch`    CHAR(1)     NOT NULL COMMENT "character returned by AVS",
 `Descr` VARCHAR(63) NOT NULL COMMENT "description of what the code means",

PRIMARY KEY(`Ch`) ) ENGINE = MYISAM;</mysql> <section end=sql />