2Checkout INS Table SQL Example

ins.sql

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)
);