- create table paypal_ipn (
- id int unique auto_increment,
- txn_id varchar(250) not null default "",
- status varchar(250) not null default "",
- ipn_at int(11) not null default 0,
- txn_type varchar(100) not null default "",
- subscr_id varchar(100) not null default "",
- custom varchar(250) not null default "",
- for_table_id int not null default 0,
- for_row_id int not null default 0,
- processed int(1) not null default 0,
- item_name varchar(250) not null default "",
- item_number varchar(250) not null default "",
- needs_review int(1) not null default 0,
- payment_status varchar(250) not null default "",
- mc_gross varchar(250) not null default "",
- mc_currency varchar(250) not null default "",
- receiver_email varchar(250) not null default "",
- payer_email varchar(250) not null default "",
- log text not null default ""
- ) CHARSET=utf8;
+ create table paypal_ipn (
+ id int unique auto_increment,
+ txn_id varchar(250) not null default "",
+ status varchar(250) not null default "",
+ ipn_at int(11) not null default 0,
+ txn_type varchar(100) not null default "",
+ subscr_id varchar(100) not null default "",
+ custom varchar(250) not null default "",
+ for_table_id int not null default 0,
+ for_row_id int not null default 0,
+ processed int(1) not null default 0,
+ item_name varchar(250) not null default "",
+ item_number varchar(250) not null default "",
+ needs_review int(1) not null default 0,
+ payment_status varchar(250) not null default "",
+ mc_gross varchar(250) not null default "",
+ mc_currency varchar(250) not null default "",
+ receiver_email varchar(250) not null default "",
+ payer_email varchar(250) not null default "",
+ log text not null default ""
+ ) CHARSET=utf8;