authorize plugin needs upgrading
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_enrol_authorize (
id BIGINT(10) unsigned NOT NULL auto_increment,
paymentmethod enum('cc', 'echeck') NOT NULL DEFAULT 'cc',
refundinfo SMALLINT(4) unsigned NOT NULL DEFAULT 0,
ccname VARCHAR(255) NOT NULL DEFAULT '',
courseid BIGINT(10) unsigned NOT NULL DEFAULT 0,
userid BIGINT(10) unsigned NOT NULL DEFAULT 0,
transid BIGINT(10) unsigned NOT NULL DEFAULT 0,
status BIGINT(10) unsigned NOT NULL DEFAULT 0,
timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0,
settletime BIGINT(10) unsigned NOT NULL DEFAULT 0,
amount VARCHAR(10) NOT NULL DEFAULT '',
currency VARCHAR(3) NOT NULL DEFAULT 'USD',
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_enrol_authorize COMMENT='Holds all known information about authorize.net transactions'
Success
(mysql): CREATE INDEX mdl_enroauth_cou_ix ON mdl_enrol_authorize (courseid)
Success
(mysql): CREATE INDEX mdl_enroauth_use_ix ON mdl_enrol_authorize (userid)
Success
(mysql): CREATE INDEX mdl_enroauth_sta_ix ON mdl_enrol_authorize (status)
Success
(mysql): CREATE INDEX mdl_enroauth_tra_ix ON mdl_enrol_authorize (transid)
Success
(mysql): CREATE TABLE mdl_enrol_authorize_refunds (
id BIGINT(10) unsigned NOT NULL auto_increment,
orderid BIGINT(10) unsigned NOT NULL DEFAULT 0,
status TINYINT(1) unsigned NOT NULL DEFAULT 0,
amount VARCHAR(10) NOT NULL DEFAULT '',
transid BIGINT(10) unsigned DEFAULT 0,
settletime BIGINT(10) unsigned NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_enrol_authorize_refunds COMMENT='Authorize.net refunds'
Success
(mysql): CREATE INDEX mdl_enroauthrefu_tra_ix ON mdl_enrol_authorize_refunds (transid)
Success
(mysql): CREATE INDEX mdl_enroauthrefu_ord_ix ON mdl_enrol_authorize_refunds (orderid)
Success
authorize tables have been set up correctly
paypal plugin needs upgrading
(mysql): CREATE TABLE mdl_enrol_paypal (
id BIGINT(10) unsigned NOT NULL auto_increment,
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 BIGINT(10) unsigned NOT NULL DEFAULT 0,
userid BIGINT(10) unsigned 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 BIGINT(10) unsigned NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_enrol_paypal COMMENT='Holds all known information about PayPal transactions'
Success
paypal tables have been set up correctly