enrol_paypal sql

Re: enrol_paypal sql

by Paul Evans -
Number of replies: 0
here is the postgres7 equiv:


CREATE TABLE enrol_paypal (
id SERIAL PRIMARY KEY,
business varchar(255) NOT NULL default '',
receiver_email varchar(255) NOT NULL default '',
receiver_id varchar(255) NOT NULL default '',
item_name varchar(255) NOT NULL default '',
courseid integer NOT NULL default '0',
userid integer NOT NULL default '0',
memo varchar(255) NOT NULL default '',
tax varchar(255) NOT NULL default '',
option_name1 varchar(255) NOT NULL default '',
option_selection1_x varchar(255) NOT NULL default '',
option_name2 varchar(255) NOT NULL default '',
option_selection2_x varchar(255) NOT NULL default '',
payment_status varchar(255) NOT NULL default '',
pending_reason varchar(255) NOT NULL default '',
reason_code varchar(30) NOT NULL default '',
txn_id varchar(255) NOT NULL default '',
parent_txn_id varchar(255) NOT NULL default '',
payment_type varchar(30) NOT NULL default '',
timeupdated integer NOT NULL default '0'
);

COMMENT ON TABLE enrol_paypal IS 'Holds all known information about Paypal transactions';

===================

can't actually perform a trx on it until tomorrow though.
no news is good news.