CREATE TABLE cc_trans (
    cctransid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    cartid INT UNSIGNED NOT NULL,
 
    gctaskref VARCHAR(255),
    dispatchtime INT UNSIGNED,
    jobstate VARCHAR(255),
    joberr VARCHAR(255),
 
    response CHAR(1),
    responsetext VARCHAR(255),
    authcode VARCHAR(255),
    transactionid VARCHAR(255),
    avsresponse CHAR(1),
    cvvresponse CHAR(1),
    responsecode mediumint UNSIGNED,
 
    ccnumhash VARCHAR(32) NOT NULL,
    expmon tinyint NOT NULL,
    expyear SMALLINT NOT NULL,
    firstname VARCHAR(25) NOT NULL,
    lastname VARCHAR(25) NOT NULL,
    street1 VARCHAR(100) NOT NULL,
    street2 VARCHAR(100),
    city VARCHAR(40) NOT NULL,
    state VARCHAR(40) NOT NULL,
    country CHAR(2) NOT NULL,
    zip VARCHAR(20) NOT NULL,
    phone VARCHAR(40),
    ipaddr VARCHAR(15) NOT NULL,
 
    PRIMARY KEY (cctransid),
    INDEX (cartid)
)