From 670b1364a055cc5be063127a8f35d7bce2f0da3b Mon Sep 17 00:00:00 2001 From: vyshane Date: Mon, 24 Apr 2006 08:26:33 +0000 Subject: [PATCH] Fixed inserts for log_display. --- mod/journal/db/mysql.sql | 8 ++++---- mod/journal/db/oci8po.sql | 8 ++++---- mod/journal/db/postgres7.sql | 8 ++++---- mod/lesson/db/mysql.php | 6 +++--- mod/lesson/db/mysql.sql | 6 +++--- mod/lesson/db/postgres7.php | 6 +++--- mod/lesson/db/postgres7.sql | 6 +++--- 7 files changed, 24 insertions(+), 24 deletions(-) diff --git a/mod/journal/db/mysql.sql b/mod/journal/db/mysql.sql index 88c1500512..2a21745dd2 100755 --- a/mod/journal/db/mysql.sql +++ b/mod/journal/db/mysql.sql @@ -53,7 +53,7 @@ CREATE TABLE prefix_journal_entries ( # Dumping data for table `log_display` # -INSERT INTO prefix_log_display VALUES ('journal', 'view', 'journal', 'name'); -INSERT INTO prefix_log_display VALUES ('journal', 'add entry', 'journal', 'name'); -INSERT INTO prefix_log_display VALUES ('journal', 'update entry', 'journal', 'name'); -INSERT INTO prefix_log_display VALUES ('journal', 'view responses', 'journal', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('journal', 'view', 'journal', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('journal', 'add entry', 'journal', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('journal', 'update entry', 'journal', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('journal', 'view responses', 'journal', 'name'); diff --git a/mod/journal/db/oci8po.sql b/mod/journal/db/oci8po.sql index 13c5f3eac4..4a20559fce 100755 --- a/mod/journal/db/oci8po.sql +++ b/mod/journal/db/oci8po.sql @@ -80,10 +80,10 @@ rem rem Dumping data for table log_display rem delete from prefix_log_display where module = 'journal'; -INSERT INTO prefix_log_display VALUES ('journal', 'view', 'journal', 'name'); -INSERT INTO prefix_log_display VALUES ('journal', 'add entry', 'journal', 'name'); -INSERT INTO prefix_log_display VALUES ('journal', 'update entry', 'journal', 'name'); -INSERT INTO prefix_log_display VALUES ('journal', 'view responses', 'journal', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('journal', 'view', 'journal', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('journal', 'add entry', 'journal', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('journal', 'update entry', 'journal', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('journal', 'view responses', 'journal', 'name'); col module format a10 select * from prefix_log_display where module = 'journal'; diff --git a/mod/journal/db/postgres7.sql b/mod/journal/db/postgres7.sql index b740ff7a3c..f9e2c75c01 100755 --- a/mod/journal/db/postgres7.sql +++ b/mod/journal/db/postgres7.sql @@ -54,7 +54,7 @@ CREATE INDEX prefix_journal_entries_userid_idx ON prefix_journal_entries (userid # Dumping data for table `log_display` # -INSERT INTO prefix_log_display VALUES ('journal', 'view', 'journal', 'name'); -INSERT INTO prefix_log_display VALUES ('journal', 'add entry', 'journal', 'name'); -INSERT INTO prefix_log_display VALUES ('journal', 'update entry', 'journal', 'name'); -INSERT INTO prefix_log_display VALUES ('journal', 'view responses', 'journal', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('journal', 'view', 'journal', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('journal', 'add entry', 'journal', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('journal', 'update entry', 'journal', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('journal', 'view responses', 'journal', 'name'); diff --git a/mod/lesson/db/mysql.php b/mod/lesson/db/mysql.php index 8634044195..5102d0daf0 100644 --- a/mod/lesson/db/mysql.php +++ b/mod/lesson/db/mysql.php @@ -10,9 +10,9 @@ function lesson_upgrade($oldversion) { delete_records("log_display", "module", "lesson"); - modify_database ("", "INSERT INTO prefix_log_display VALUES ('lesson', 'start', 'lesson', 'name');"); - modify_database ("", "INSERT INTO prefix_log_display VALUES ('lesson', 'end', 'lesson', 'name');"); - modify_database ("", "INSERT INTO prefix_log_display VALUES ('lesson', 'view', 'lesson_pages', 'title');"); + modify_database ("", "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('lesson', 'start', 'lesson', 'name');"); + modify_database ("", "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('lesson', 'end', 'lesson', 'name');"); + modify_database ("", "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('lesson', 'view', 'lesson_pages', 'title');"); } diff --git a/mod/lesson/db/mysql.sql b/mod/lesson/db/mysql.sql index ab2e46aa68..342ec8d88d 100644 --- a/mod/lesson/db/mysql.sql +++ b/mod/lesson/db/mysql.sql @@ -179,6 +179,6 @@ CREATE TABLE `prefix_lesson_high_scores` # -------------------------------------------------------- -INSERT INTO prefix_log_display VALUES ('lesson', 'start', 'lesson', 'name'); -INSERT INTO prefix_log_display VALUES ('lesson', 'end', 'lesson', 'name'); -INSERT INTO prefix_log_display VALUES ('lesson', 'view', 'lesson_pages', 'title'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('lesson', 'start', 'lesson', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('lesson', 'end', 'lesson', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('lesson', 'view', 'lesson_pages', 'title'); diff --git a/mod/lesson/db/postgres7.php b/mod/lesson/db/postgres7.php index 402c3a6400..6f402c0aaf 100644 --- a/mod/lesson/db/postgres7.php +++ b/mod/lesson/db/postgres7.php @@ -10,9 +10,9 @@ function lesson_upgrade($oldversion) { delete_records("log_display", "module", "lesson"); - modify_database ("", "INSERT INTO prefix_log_display VALUES ('lesson', 'start', 'lesson', 'name');"); - modify_database ("", "INSERT INTO prefix_log_display VALUES ('lesson', 'end', 'lesson', 'name');"); - modify_database ("", "INSERT INTO prefix_log_display VALUES ('lesson', 'view', 'lesson_pages', 'title');"); + modify_database ("", "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('lesson', 'start', 'lesson', 'name');"); + modify_database ("", "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('lesson', 'end', 'lesson', 'name');"); + modify_database ("", "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('lesson', 'view', 'lesson_pages', 'title');"); } diff --git a/mod/lesson/db/postgres7.sql b/mod/lesson/db/postgres7.sql index eee6fdb966..d0a6382cfd 100644 --- a/mod/lesson/db/postgres7.sql +++ b/mod/lesson/db/postgres7.sql @@ -174,6 +174,6 @@ CREATE TABLE prefix_lesson_high_scores ); -INSERT INTO prefix_log_display VALUES ('lesson', 'start', 'lesson', 'name'); -INSERT INTO prefix_log_display VALUES ('lesson', 'end', 'lesson', 'name'); -INSERT INTO prefix_log_display VALUES ('lesson', 'view', 'lesson_pages', 'title'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('lesson', 'start', 'lesson', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('lesson', 'end', 'lesson', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('lesson', 'view', 'lesson_pages', 'title'); -- 2.39.5