From f7052e9117ee6cca04168c973f6d041bff0b4170 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Thu, 19 Aug 2004 09:35:16 +0000
Subject: [PATCH] Added database controls for Paypal module

---
 enrol/paypal/db/mysql.php     | 19 +++++++++++++++++++
 enrol/paypal/db/mysql.sql     | 23 +++++++++++++++++++++++
 enrol/paypal/db/postgres7.php | 19 +++++++++++++++++++
 enrol/paypal/db/postgres7.sql | 22 ++++++++++++++++++++++
 4 files changed, 83 insertions(+)
 create mode 100644 enrol/paypal/db/mysql.php
 create mode 100644 enrol/paypal/db/mysql.sql
 create mode 100644 enrol/paypal/db/postgres7.php
 create mode 100644 enrol/paypal/db/postgres7.sql

diff --git a/enrol/paypal/db/mysql.php b/enrol/paypal/db/mysql.php
new file mode 100644
index 0000000000..e3fc4d5e72
--- /dev/null
+++ b/enrol/paypal/db/mysql.php
@@ -0,0 +1,19 @@
+<?PHP  //$Id$
+
+// MySQL commands for upgrading this enrolment module
+
+function paypal_upgrade($oldversion=0) {
+
+    global $CFG, $THEME, $db;
+
+    $result = true;
+
+    if ($oldversion == 0) {
+        $result = modify_database("$CFG->dirroot/enrol/paypal/db/mysql.sql");
+    }
+
+    return $result;
+
+}
+
+?>
diff --git a/enrol/paypal/db/mysql.sql b/enrol/paypal/db/mysql.sql
new file mode 100644
index 0000000000..c5ab17714d
--- /dev/null
+++ b/enrol/paypal/db/mysql.sql
@@ -0,0 +1,23 @@
+CREATE TABLE `enrol_paypal` (
+  `id` int(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` int(10) unsigned NOT NULL default '0',
+  `userid` int(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` int(10) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`id`)
+) TYPE=MyISAM COMMENT='Holds all known information about Paypal transactions' ;
diff --git a/enrol/paypal/db/postgres7.php b/enrol/paypal/db/postgres7.php
new file mode 100644
index 0000000000..19468eeae5
--- /dev/null
+++ b/enrol/paypal/db/postgres7.php
@@ -0,0 +1,19 @@
+<?PHP  //$Id$
+
+// PostgreSQL commands for upgrading this enrolment module
+
+function paypal_upgrade($oldversion=0) {
+
+    global $CFG, $THEME, $db;
+
+    $result = true;
+
+    if ($oldversion == 0) {
+        $result = modify_database("$CFG->dirroot/enrol/paypal/db/postgres7.sql");
+    }
+
+    return $result;
+
+}
+
+?>
diff --git a/enrol/paypal/db/postgres7.sql b/enrol/paypal/db/postgres7.sql
new file mode 100644
index 0000000000..dc3073b1c0
--- /dev/null
+++ b/enrol/paypal/db/postgres7.sql
@@ -0,0 +1,22 @@
+CREATE TABLE prefix_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'
+);
-- 
2.39.5