RichRawlings
Newbie

Posts: 5
|
 |
« Reply #2 on: April 23, 2008, 10:19:17 AM » |
|
Downloaded 2.0.3, I still had to manually add the database tables, but all seems to be working right now!
CREATE TABLE IF NOT EXISTS mh2tr_subscriptions( UID_Register BIGINT AUTO_INCREMENT, UID_member BIGINT, first_name VARCHAR(64), last_name VARCHAR(64), payer_business_name VARCHAR(127), payer_email VARCHAR(127), custom VARCHAR(255), subscr_status VARCHAR(20), subscr_id VARCHAR(20), subscr_date DATETIME, subscr_effective DATETIME, period3 VARCHAR(5), amount3 DECIMAL(10, 2), recur_times INT, times_filled INT, times_failed INT, times_refunded INT, PRIMARY KEY(UID_Register));
CREATE TABLE IF NOT EXISTS mh2tr_transactions( UID_transactions BIGINT AUTO_INCREMENT, business VARCHAR(127), item_name VARCHAR(127), item_number VARCHAR(127), receiver_email VARCHAR(127), receiver_id VARCHAR(127), address_street VARCHAR(200), address_city VARCHAR(40), address_state VARCHAR(40), address_zip VARCHAR(20) NOT NULL, address_country VARCHAR(64), first_name VARCHAR(64), last_name VARCHAR(64), payer_business_name VARCHAR(127), payer_email VARCHAR(127), payer_id VARCHAR(13), contact_phone VARCHAR(20), status_address VARCHAR(15), status_payer VARCHAR(15), custom VARCHAR(255), invoice VARCHAR(127), memo VARCHAR(255), option_selection1 VARCHAR(200), option_name2 VARCHAR(200), option_selection2 VARCHAR(200), payment_date DATETIME NOT NULL, payment_status VARCHAR(20), payment_type VARCHAR(10), pending_reason VARCHAR(20), reason_code VARCHAR(20), txn_id VARCHAR(20), txn_type VARCHAR(20), exchange_rate DECIMAL(5, 2), mc_currency VARCHAR(5) NOT NULL, mc_fee DECIMAL(10, 2), mc_gross DECIMAL(10, 2), payment_fee DECIMAL(10, 2), payment_gross DECIMAL(10, 2), settle_amount DECIMAL(10, 2), settle_currency VARCHAR(5), subscr_date DATETIME, subscr_effective DATETIME, period3 VARCHAR(5), amount3 DECIMAL(10, 2), mc_amount3 DECIMAL(10, 2), recurring TINYINT, reattempt TINYINT, retry_at DATETIME, recur_times INT, subscr_id VARCHAR(20), PRIMARY KEY(UID_transactions), UNIQUE INDEX IDX1_ppipns (UID_transactions));
Thanks Mick, and a donation will be on the way for your great support!
|