Created
August 11, 2012 13:24
-
-
Save craigchristenson/3324426 to your computer and use it in GitHub Desktop.
2Checkout INS Table SQL Example
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE 2checkout_ins ( | |
id bigint(20) NOT NULL auto_increment, | |
timestamp varchar(18) NOT NULL default '0', | |
message_type varchar(32) NOT NULL default '0', | |
message_description varchar(64) NOT NULL default '0', | |
md5_hash varchar(32) NOT NULL default '0', | |
message_id bigint(20) NOT NULL default '0', | |
key_count smallint(6) NOT NULL default '0', | |
vendor_id int(8) NOT NULL default '0', | |
sale_id bigint(10) NOT NULL default '0', | |
sale_date_placed varchar(18) NOT NULL default '0', | |
vendor_order_id varchar(50) default '0', | |
invoice_id bigint(20) NOT NULL default '0', | |
recurring bit NOT NULL default 0, | |
payment_type varchar(16) NOT NULL default '0', | |
list_currency varchar(3) NOT NULL default '0', | |
cust_currency varchar(3) NOT NULL default '0', | |
auth_exp varchar(10) NOT NULL default '0', | |
invoice_status varchar(16) NOT NULL default '0', | |
fraud_status varchar(16) NOT NULL default '0', | |
invoice_list_amount float(16) NOT NULL default '0', | |
invoice_usd_amount float(16) NOT NULL default '0', | |
invoice_cust_amount float(16) NOT NULL default '0', | |
customer_first_name varchar(64) NOT NULL default '0', | |
customer_last_name varchar(64) NOT NULL default '0', | |
customer_name varchar(128) NOT NULL default '0', | |
customer_email varchar(128) NOT NULL default '0', | |
customer_phone varchar(16) NOT NULL default '0', | |
customer_ip varchar(16) NOT NULL default '0', | |
customer_ip_country varchar(32) NOT NULL default '0', | |
bill_street_address varchar(128) NOT NULL default '0', | |
bill_street_address2 varchar(128) default '0', | |
bill_city varchar(32) NOT NULL default '0', | |
bill_state varchar(32) NOT NULL default '0', | |
bill_postal_code varchar(32) NOT NULL default '0', | |
bill_country varchar(3) NOT NULL default '0', | |
ship_status varchar(32) NOT NULL default '0', | |
ship_tracking_number varchar(64) NOT NULL default '0', | |
ship_name varchar(128) NOT NULL default '0', | |
ship_street_address varchar(128) NOT NULL default '0', | |
ship_street_address2 varchar(128) NOT NULL default '0', | |
ship_city varchar(64) NOT NULL default '0', | |
ship_state varchar(64) NOT NULL default '0', | |
ship_postal_code varchar(32) NOT NULL default '0', | |
ship_country varchar(3) NOT NULL default '0', | |
item_count int(8) NOT NULL default '0', | |
item_name_1 varchar(64) NOT NULL default '0', | |
item_id_1 varchar(64) NOT NULL default '0', | |
item_list_amount_1 float(16) NOT NULL default '0', | |
item_usd_amount_1 float(16) NOT NULL default '0', | |
item_cust_amount_1 float(16) NOT NULL default '0', | |
item_type_1 varchar(16) NOT NULL default '0', | |
item_duration_1 varchar(16) NOT NULL default '0', | |
item_recurrence_1 varchar(16) NOT NULL default '0', | |
item_rec_list_amount_1 float(16) NOT NULL default '0', | |
item_rec_status_1 varchar(16) NOT NULL default '0', | |
item_rec_date_next_1 varchar(10) NOT NULL default '0', | |
item_rec_install_billed_1 varchar(16) NOT NULL default '0', | |
PRIMARY KEY (id) | |
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment