first stab at paypal_ipn framework

[wfpl-cms.git] / paypal_ipn.sql

diff --git a/paypal_ipn.sql b/paypal_ipn.sql
new file mode 100644 (file)
index 0000000..4806c35
--- /dev/null
+++ b/paypal_ipn.sql
@@ -0,0 +1,21 @@
+drop table if exists paypal_ipn;
+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 "");