From 5c32d7258d37be3ae359fbcfe6c2a5e0e60fe17b Mon Sep 17 00:00:00 2001
From: rkingdon <rkingdon>
Date: Thu, 25 Sep 2003 19:14:14 +0000
Subject: [PATCH] Addition of the overallocation field to the workshop table.

---
 mod/workshop/backuplib.php    | 1 +
 mod/workshop/db/oci8po.sql    | 3 ++-
 mod/workshop/db/postgres7.sql | 1 +
 mod/workshop/restorelib.php   | 1 +
 4 files changed, 5 insertions(+), 1 deletion(-)

diff --git a/mod/workshop/backuplib.php b/mod/workshop/backuplib.php
index 836671d4fb..2674c608ae 100644
--- a/mod/workshop/backuplib.php
+++ b/mod/workshop/backuplib.php
@@ -67,6 +67,7 @@
                 fwrite ($bf,full_tag("GRADE",4,false,$workshop->grade));
                 fwrite ($bf,full_tag("NTASSESSMENTS",4,false,$workshop->ntassessments));
                 fwrite ($bf,full_tag("NSASSESSMENTS",4,false,$workshop->nsassessments));
+                fwrite ($bf,full_tag("OVERALLOCATION",4,false,$workshop->nsassessments));
                 fwrite ($bf,full_tag("TIMEMODIFIED",4,false,$workshop->timemodified));
                 fwrite ($bf,full_tag("MERGEGRADES",4,false,$workshop->mergegrades));
                 fwrite ($bf,full_tag("TEACHERWEIGHT",4,false,$workshop->teacherweight));
diff --git a/mod/workshop/db/oci8po.sql b/mod/workshop/db/oci8po.sql
index 720e581ff0..0bc6a4607b 100755
--- a/mod/workshop/db/oci8po.sql
+++ b/mod/workshop/db/oci8po.sql
@@ -21,7 +21,8 @@ CREATE TABLE prefix_workshop (
   deadline number(10)  default '0' not null,
   grade number(10) default '0' not null,
   ntassessments number(3)  default '0' not null,
-  nsassessments number(3)  default '0' not null,
+  nsassessments number(3)  default '0' not null,
+  overallocation number(3)  default '0' not null,
   timemodified number(10)  default '0' not null,
   mergegrades number(3)  default '0' not null,
   teacherweight number(3)  default '5' NOT NULL,
diff --git a/mod/workshop/db/postgres7.sql b/mod/workshop/db/postgres7.sql
index 0448a62a30..14e2d75158 100644
--- a/mod/workshop/db/postgres7.sql
+++ b/mod/workshop/db/postgres7.sql
@@ -21,6 +21,7 @@ CREATE TABLE prefix_workshop (
   grade INT8 NOT NULL default '0',
   ntassessments INT  NOT NULL default '0',
   nsassessments INT  NOT NULL default '0',
+  overallocation INT  NOT NULL default '0',
   timemodified INT8  NOT NULL default '0',
   mergegrades INT  NOT NULL default '0',
   teacherweight INT  NOT NULL default '5',
diff --git a/mod/workshop/restorelib.php b/mod/workshop/restorelib.php
index ba341b9bd8..33b072c90c 100644
--- a/mod/workshop/restorelib.php
+++ b/mod/workshop/restorelib.php
@@ -70,6 +70,7 @@
             $workshop->grade = backup_todb($info['MOD']['#']['GRADE']['0']['#']);
             $workshop->ntassessments = backup_todb($info['MOD']['#']['NTASSESSMENTS']['0']['#']);
             $workshop->nsassessments = backup_todb($info['MOD']['#']['NSASSESSMENTS']['0']['#']);
+            $workshop->overallocation = backup_todb($info['MOD']['#']['OVERALLOCATION']['0']['#']);
             $workshop->timemodified = backup_todb($info['MOD']['#']['TIMEMODIFIED']['0']['#']);
             $workshop->mergegrades = backup_todb($info['MOD']['#']['MERGEGRADES']['0']['#']);
             $workshop->teacherweight = backup_todb($info['MOD']['#']['TEACHERWEIGHT']['0']['#']);
-- 
2.39.5