From 8c5c6133a8bcbf8c566361da0879ad154fbe7dc7 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Sat, 26 Jun 2004 09:09:00 +0000
Subject: [PATCH] Adding a field "cost" to courses.   :-)

---
 lib/db/mysql.php     | 4 ++++
 lib/db/mysql.sql     | 1 +
 lib/db/postgres7.php | 3 +++
 lib/db/postgres7.sql | 1 +
 version.php          | 2 +-
 5 files changed, 10 insertions(+), 1 deletion(-)

diff --git a/lib/db/mysql.php b/lib/db/mysql.php
index d115b6d50f..7707a5eae9 100644
--- a/lib/db/mysql.php
+++ b/lib/db/mysql.php
@@ -785,6 +785,10 @@ function main_upgrade($oldversion=0) {
         execute_sql('UPDATE '.$CFG->prefix.'course SET idnumber = shortname');   // By default
     }
 
+    if ($oldversion < 2004062600) {
+        table_column('course', '', 'cost', 'varchar', '10', '', '', 'not null', 'lang');
+    }
+
 
     return $result;
 
diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql
index f4245c1866..8ba452bc62 100644
--- a/lib/db/mysql.sql
+++ b/lib/db/mysql.sql
@@ -56,6 +56,7 @@ CREATE TABLE `prefix_course` (
   `groupmode` int(4) unsigned NOT NULL default '0',
   `groupmodeforce` int(4) unsigned NOT NULL default '0',
   `lang` varchar(10) NOT NULL default '',
+  `cost` varchar(10) NOT NULL default '',
   `timecreated` int(10) unsigned NOT NULL default '0',
   `timemodified` int(10) unsigned NOT NULL default '0',
   PRIMARY KEY  (`id`),
diff --git a/lib/db/postgres7.php b/lib/db/postgres7.php
index fde22d3fce..c11f6e08a6 100644
--- a/lib/db/postgres7.php
+++ b/lib/db/postgres7.php
@@ -527,6 +527,9 @@ function main_upgrade($oldversion=0) {
         execute_sql('UPDATE '.$CFG->prefix.'course SET idnumber = shortname');   // By default
     }
 
+    if ($oldversion < 2004062600) {
+        table_column('course', '', 'cost', 'varchar', '10', '', '', 'not null', 'lang');
+    }
 
     return $result;
 
diff --git a/lib/db/postgres7.sql b/lib/db/postgres7.sql
index 0aa75b647e..d21c60ce3e 100644
--- a/lib/db/postgres7.sql
+++ b/lib/db/postgres7.sql
@@ -34,6 +34,7 @@ CREATE TABLE prefix_course (
    groupmode integer NOT NULL default '0',
    groupmodeforce integer NOT NULL default '0',
    lang varchar(10) NOT NULL default '',
+   cost varchar(10) NOT NULL default '',
    timecreated integer NOT NULL default '0',
    timemodified integer NOT NULL default '0'
 );
diff --git a/version.php b/version.php
index 35dbf74b68..d16f78c60c 100644
--- a/version.php
+++ b/version.php
@@ -5,7 +5,7 @@
 // database to determine whether upgrades should
 // be performed (see lib/db/*.php)
 
-$version = 2004062401;   // The current version is a date (YYYYMMDDXX)
+$version = 2004062600;   // The current version is a date (YYYYMMDDXX)
 
 $release = "1.4 development";   // User-friendly version number
 
-- 
2.39.5