1 drop table if exists paypal_ipn;
2 create table paypal_ipn (
3 id int unique auto_increment,
4 txn_id varchar(250) not null default "",
5 status varchar(250) not null default "",
6 ipn_at int(11) not null default 0,
7 txn_type varchar(100) not null default "",
8 subscr_id varchar(100) not null default "",
9 custom varchar(250) not null default "",
10 for_table_id int not null default 0,
11 for_row_id int not null default 0,
12 processed int(1) not null default 0,
13 item_name varchar(250) not null default "",
14 item_number varchar(250) not null default "",
15 needs_review int(1) not null default 0,
16 payment_status varchar(250) not null default "",
17 mc_gross varchar(250) not null default "",
18 mc_currency varchar(250) not null default "",
19 receiver_email varchar(250) not null default "",
20 payer_email varchar(250) not null default "",
21 log text not null default "");