From 9ae965d379e074d5370ecd9d7793a4b912b730f0 Mon Sep 17 00:00:00 2001
From: vyshane <vyshane>
Date: Thu, 21 Sep 2006 04:10:36 +0000
Subject: [PATCH] Removed column ratings from data table

---
 mod/data/db/install.xml   | 7 +++----
 mod/data/db/mysql.php     | 1 +
 mod/data/db/mysql.sql     | 1 -
 mod/data/db/postgres7.php | 1 +
 mod/data/db/postgres7.sql | 1 -
 5 files changed, 5 insertions(+), 6 deletions(-)

diff --git a/mod/data/db/install.xml b/mod/data/db/install.xml
index 7d2569d110..7ae8515696 100644
--- a/mod/data/db/install.xml
+++ b/mod/data/db/install.xml
@@ -4,14 +4,13 @@
     xsi:noNamespaceSchemaLocation="../../../lib/xmldb/xmldb.xsd"
 >
   <TABLES>
-    <TABLE NAME="data" COMMENT="Defines settings for each Database activity" NEXT="data_fields">
+    <TABLE NAME="data" COMMENT="Removed ratings column" NEXT="data_fields">
       <FIELDS>
         <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" SEQUENCE="true" ENUM="false" NEXT="course"/>
         <FIELD NAME="course" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="id" NEXT="name"/>
         <FIELD NAME="name" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="course" NEXT="intro"/>
-        <FIELD NAME="intro" TYPE="text" LENGTH="small" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="name" NEXT="ratings"/>
-        <FIELD NAME="ratings" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="intro" NEXT="comments"/>
-        <FIELD NAME="comments" TYPE="int" LENGTH="4" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="ratings" NEXT="timeavailablefrom"/>
+        <FIELD NAME="intro" TYPE="text" LENGTH="small" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="name" NEXT="comments"/>
+        <FIELD NAME="comments" TYPE="int" LENGTH="4" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="intro" NEXT="timeavailablefrom"/>
         <FIELD NAME="timeavailablefrom" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="comments" NEXT="timeavailableto"/>
         <FIELD NAME="timeavailableto" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="timeavailablefrom" NEXT="timeviewfrom"/>
         <FIELD NAME="timeviewfrom" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="timeavailableto" NEXT="timeviewto"/>
diff --git a/mod/data/db/mysql.php b/mod/data/db/mysql.php
index 541a62ef70..354d0a189c 100644
--- a/mod/data/db/mysql.php
+++ b/mod/data/db/mysql.php
@@ -104,6 +104,7 @@ function data_upgrade($oldversion) {
 
         modify_database('', 'ALTER TABLE prefix_data DROP COLUMN participants;');
         modify_database('', 'ALTER TABLE prefix_data DROP COLUMN assesspublic;');
+        modify_database('', 'ALTER TABLE prefix_data DROP COLUMN ratings;');
         
     }
     
diff --git a/mod/data/db/mysql.sql b/mod/data/db/mysql.sql
index 31dabf659b..6e71b25026 100755
--- a/mod/data/db/mysql.sql
+++ b/mod/data/db/mysql.sql
@@ -15,7 +15,6 @@ CREATE TABLE prefix_data (
   course int(10) unsigned NOT NULL default '0',
   name varchar(255) NOT NULL default '',
   intro text NOT NULL default '',
-  ratings int(10) NOT NULL default '0',
   comments int(4) unsigned NOT NULL default '0',
   timeavailablefrom int(10) unsigned NOT NULL default '0',
   timeavailableto int(10) unsigned NOT NULL default '0',
diff --git a/mod/data/db/postgres7.php b/mod/data/db/postgres7.php
index beebfab51c..f72426c726 100644
--- a/mod/data/db/postgres7.php
+++ b/mod/data/db/postgres7.php
@@ -188,6 +188,7 @@ function data_upgrade($oldversion) {
 
         modify_database('', 'ALTER TABLE prefix_data DROP COLUMN participants;');
         modify_database('', 'ALTER TABLE prefix_data DROP COLUMN assesspublic;');
+        modify_database('', 'ALTER TABLE prefix_data DROP COLUMN ratings;');
         
     }
     
diff --git a/mod/data/db/postgres7.sql b/mod/data/db/postgres7.sql
index 30711a475f..045d205315 100755
--- a/mod/data/db/postgres7.sql
+++ b/mod/data/db/postgres7.sql
@@ -4,7 +4,6 @@ CREATE TABLE prefix_data (
   course integer NOT NULL default '0',
   name varchar(255) NOT NULL default '',
   intro text NOT NULL default '',
-  ratings integer NOT NULL default '0',
   comments integer NOT NULL default '0',
   timeavailablefrom integer NOT NULL default '0',
   timeavailableto integer NOT NULL default '0',
-- 
2.39.5