VbzCart/docs/tables/card auth code: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
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>...)
 
m (Woozle moved page VbzCart/VbzCart/tables/card auth code to VbzCart/docs/tables/card auth code without leaving a redirect: part 3/5)
 
(No difference)

Latest revision as of 01:56, 25 February 2024

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 />