From 0361508976056d341433dc8ff8dd627125cb7fb1 Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Thu, 15 Jan 2009 21:36:48 +0000
Subject: [PATCH] MDL-17457 moved all STATEMENTS into install.php

---
 lib/db/install.php                        |  3 ---
 mod/quiz/report/statistics/db/install.php | 16 ++++++++++++++++
 mod/quiz/report/statistics/db/install.xml |  7 -------
 3 files changed, 16 insertions(+), 10 deletions(-)
 create mode 100644 mod/quiz/report/statistics/db/install.php

diff --git a/lib/db/install.php b/lib/db/install.php
index 36da7860a3..b6e0d0f397 100644
--- a/lib/db/install.php
+++ b/lib/db/install.php
@@ -6,9 +6,6 @@
 function xmldb_main_install() {
     global $CFG, $DB, $SITE;
 
-/// TODO: move all statements from install.xml here
-
-
 /// make sure system context exists
     $syscontext = get_context_instance(CONTEXT_SYSTEM);
     if ($syscontext->id != 1) {
diff --git a/mod/quiz/report/statistics/db/install.php b/mod/quiz/report/statistics/db/install.php
new file mode 100644
index 0000000000..aa193d21f1
--- /dev/null
+++ b/mod/quiz/report/statistics/db/install.php
@@ -0,0 +1,16 @@
+<?php  //$Id$
+
+// This file is executed right after the install.xml
+//
+
+function xmldb_quizreport_statistics_install() {
+    global $DB;
+
+    $record = new object();
+    $record->name         = 'statistics';
+    $record->displayorder = 8000;
+    $record->cron         = 18000;
+    $record->capability   = 'quizreport/statistics:view';
+    $DB->insert_record('quiz_report', $record);
+
+}
\ No newline at end of file
diff --git a/mod/quiz/report/statistics/db/install.xml b/mod/quiz/report/statistics/db/install.xml
index d6812e7eac..0a1a8d1853 100644
--- a/mod/quiz/report/statistics/db/install.xml
+++ b/mod/quiz/report/statistics/db/install.xml
@@ -64,11 +64,4 @@
       </KEYS>
     </TABLE>
   </TABLES>
-  <STATEMENTS>
-    <STATEMENT NAME="insert quiz_report" TYPE="insert" TABLE="quiz_report" COMMENT="Initial insert of records on table quiz_report">
-      <SENTENCES>
-        <SENTENCE TEXT="(name, displayorder, cron, capability) VALUES ('statistics', 8000, 18000, 'quizreport/statistics:view')" />
-      </SENTENCES>
-    </STATEMENT>
-  </STATEMENTS>
 </XMLDB>
\ No newline at end of file
-- 
2.39.5