VbzCart/docs/tables/card auth code

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
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 />