From d5a28fdae9d20439a21c0491f2b3246e816f2b08 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Tue, 26 Sep 2006 15:56:18 +0000
Subject: [PATCH] Adding scorm->skipview to PostgreSQL

---
 mod/scorm/db/postgres7.php | 4 ++++
 mod/scorm/db/postgres7.sql | 1 +
 2 files changed, 5 insertions(+)

diff --git a/mod/scorm/db/postgres7.php b/mod/scorm/db/postgres7.php
index f95defe640..9e02e58d7f 100755
--- a/mod/scorm/db/postgres7.php
+++ b/mod/scorm/db/postgres7.php
@@ -240,6 +240,10 @@ function scorm_upgrade($oldversion) {
        modify_database('', 'ALTER TABLE prefix_scorm_scoes_track ADD CONSTRAINT prefix_scorm_scoes_track_userid_key UNIQUE (userid, scormid, scoid, attempt, element)');
     }
 
+    if ($oldversion < 2006102600) {
+        table_column("scorm", "", "skipview", "integer", "", "", "1", "NOT NULL"); 
+    }
+
     return true;
 }
 ?>
diff --git a/mod/scorm/db/postgres7.sql b/mod/scorm/db/postgres7.sql
index 65d53225fb..9b3bc1c754 100755
--- a/mod/scorm/db/postgres7.sql
+++ b/mod/scorm/db/postgres7.sql
@@ -11,6 +11,7 @@ CREATE TABLE prefix_scorm (
   grademethod integer NOT NULL default '0',
   maxattempt integer NOT NULL default '1',
   launch integer NOT NULL default '0',
+  skipview integer NOT NULL default '1',
   summary text NOT NULL default '',
   hidebrowse integer NOT NULL default '0',
   hidetoc integer NOT NULL default '0',
-- 
2.39.5