From f53d75517e8c0bdf13b40e2b09e585f3957111fc Mon Sep 17 00:00:00 2001 From: vyshane Date: Mon, 24 Apr 2006 08:11:35 +0000 Subject: [PATCH] Fixed inserts for log_display table --- mod/exercise/db/mysql.sql | 10 +++++----- mod/exercise/db/oci8po.sql | 10 +++++----- mod/exercise/db/postgres7.sql | 10 +++++----- mod/forum/db/mysql.sql | 22 +++++++++++----------- mod/forum/db/oci8po.sql | 22 +++++++++++----------- mod/forum/db/postgres7.sql | 22 +++++++++++----------- 6 files changed, 48 insertions(+), 48 deletions(-) diff --git a/mod/exercise/db/mysql.sql b/mod/exercise/db/mysql.sql index 15bb2217e4..b6f40b58bd 100644 --- a/mod/exercise/db/mysql.sql +++ b/mod/exercise/db/mysql.sql @@ -120,9 +120,9 @@ CREATE TABLE `prefix_exercise_grades` ( -INSERT INTO `prefix_log_display` VALUES ('exercise', 'close', 'exercise', 'name'); -INSERT INTO `prefix_log_display` VALUES ('exercise', 'open', 'exercise', 'name'); -INSERT INTO `prefix_log_display` VALUES ('exercise', 'submit', 'exercise', 'name'); -INSERT INTO `prefix_log_display` VALUES ('exercise', 'view', 'exercise', 'name'); -INSERT INTO `prefix_log_display` VALUES ('exercise', 'update', 'exercise', 'name'); +INSERT INTO `prefix_log_display` (module, action, mtable, field) VALUES ('exercise', 'close', 'exercise', 'name'); +INSERT INTO `prefix_log_display` (module, action, mtable, field) VALUES ('exercise', 'open', 'exercise', 'name'); +INSERT INTO `prefix_log_display` (module, action, mtable, field) VALUES ('exercise', 'submit', 'exercise', 'name'); +INSERT INTO `prefix_log_display` (module, action, mtable, field) VALUES ('exercise', 'view', 'exercise', 'name'); +INSERT INTO `prefix_log_display` (module, action, mtable, field) VALUES ('exercise', 'update', 'exercise', 'name'); diff --git a/mod/exercise/db/oci8po.sql b/mod/exercise/db/oci8po.sql index 0e0531294e..ad2205d352 100755 --- a/mod/exercise/db/oci8po.sql +++ b/mod/exercise/db/oci8po.sql @@ -211,9 +211,9 @@ create INDEX ega_idx on prefix_exercise_grades (assessmentid); rem -------------------------------------------------------- -INSERT INTO prefix_log_display VALUES ('exercise', 'close', 'exercise', 'name'); -INSERT INTO prefix_log_display VALUES ('exercise', 'open', 'exercise', 'name'); -INSERT INTO prefix_log_display VALUES ('exercise', 'submit', 'exercise', 'name'); -INSERT INTO prefix_log_display VALUES ('exercise', 'view', 'exercise', 'name'); -INSERT INTO prefix_log_display VALUES ('exercise', 'update', 'exercise', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('exercise', 'close', 'exercise', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('exercise', 'open', 'exercise', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('exercise', 'submit', 'exercise', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('exercise', 'view', 'exercise', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('exercise', 'update', 'exercise', 'name'); diff --git a/mod/exercise/db/postgres7.sql b/mod/exercise/db/postgres7.sql index 6c5c7e077d..112a78bbfb 100644 --- a/mod/exercise/db/postgres7.sql +++ b/mod/exercise/db/postgres7.sql @@ -119,9 +119,9 @@ CREATE INDEX prefix_exercise_grades_exerciseid_idx ON prefix_exercise_grades (ex -INSERT INTO prefix_log_display VALUES ('exercise', 'close', 'exercise', 'name'); -INSERT INTO prefix_log_display VALUES ('exercise', 'open', 'exercise', 'name'); -INSERT INTO prefix_log_display VALUES ('exercise', 'submit', 'exercise', 'name'); -INSERT INTO prefix_log_display VALUES ('exercise', 'view', 'exercise', 'name'); -INSERT INTO prefix_log_display VALUES ('exercise', 'update', 'exercise', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('exercise', 'close', 'exercise', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('exercise', 'open', 'exercise', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('exercise', 'submit', 'exercise', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('exercise', 'view', 'exercise', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('exercise', 'update', 'exercise', 'name'); diff --git a/mod/forum/db/mysql.sql b/mod/forum/db/mysql.sql index 3ab3f89407..50861ebc86 100644 --- a/mod/forum/db/mysql.sql +++ b/mod/forum/db/mysql.sql @@ -158,14 +158,14 @@ CREATE TABLE prefix_forum_track_prefs ( # Dumping data for table `log_display` # -INSERT INTO prefix_log_display VALUES ('forum', 'add', 'forum', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'update', 'forum', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'add discussion', 'forum_discussions', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'add post', 'forum_posts', 'subject'); -INSERT INTO prefix_log_display VALUES ('forum', 'update post', 'forum_posts', 'subject'); -INSERT INTO prefix_log_display VALUES ('forum', 'move discussion', 'forum_discussions', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'view subscribers', 'forum', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'view discussion', 'forum_discussions', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'view forum', 'forum', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'subscribe', 'forum', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'unsubscribe', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'add', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'update', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'add discussion', 'forum_discussions', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'add post', 'forum_posts', 'subject'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'update post', 'forum_posts', 'subject'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'move discussion', 'forum_discussions', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'view subscribers', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'view discussion', 'forum_discussions', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'view forum', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'subscribe', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'unsubscribe', 'forum', 'name'); diff --git a/mod/forum/db/oci8po.sql b/mod/forum/db/oci8po.sql index 749a61b747..86d18a6ba1 100755 --- a/mod/forum/db/oci8po.sql +++ b/mod/forum/db/oci8po.sql @@ -202,16 +202,16 @@ rem rem Dumping data for table log_display rem delete from prefix_log_display where module = 'forum'; -INSERT INTO prefix_log_display VALUES ('forum', 'add', 'forum', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'update', 'forum', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'add discussion', 'forum_discussions', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'add post', 'forum_posts', 'subject'); -INSERT INTO prefix_log_display VALUES ('forum', 'update post', 'forum_posts', 'subject'); -INSERT INTO prefix_log_display VALUES ('forum', 'move discussion', 'forum_discussions', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'view subscribers', 'forum', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'view discussion', 'forum_discussions', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'view forum', 'forum', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'subscribe', 'forum', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'unsubscribe', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'add', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'update', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'add discussion', 'forum_discussions', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'add post', 'forum_posts', 'subject'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'update post', 'forum_posts', 'subject'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'move discussion', 'forum_discussions', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'view subscribers', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'view discussion', 'forum_discussions', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'view forum', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'subscribe', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'unsubscribe', 'forum', 'name'); select * from prefix_log_display where module = 'forum'; diff --git a/mod/forum/db/postgres7.sql b/mod/forum/db/postgres7.sql index 3059afc93b..96820bfc55 100644 --- a/mod/forum/db/postgres7.sql +++ b/mod/forum/db/postgres7.sql @@ -170,15 +170,15 @@ CREATE INDEX prefix_forum_track_user_forum_idx ON prefix_forum_track_prefs (user # Dumping data for table `log_display` # -INSERT INTO prefix_log_display VALUES ('forum', 'add', 'forum', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'update', 'forum', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'add discussion', 'forum_discussions', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'add post', 'forum_posts', 'subject'); -INSERT INTO prefix_log_display VALUES ('forum', 'update post', 'forum_posts', 'subject'); -INSERT INTO prefix_log_display VALUES ('forum', 'move discussion', 'forum_discussions', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'view subscribers', 'forum', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'view discussion', 'forum_discussions', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'view forum', 'forum', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'subscribe', 'forum', 'name'); -INSERT INTO prefix_log_display VALUES ('forum', 'unsubscribe', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'add', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'update', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'add discussion', 'forum_discussions', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'add post', 'forum_posts', 'subject'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'update post', 'forum_posts', 'subject'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'move discussion', 'forum_discussions', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'view subscribers', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'view discussion', 'forum_discussions', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'view forum', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'subscribe', 'forum', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('forum', 'unsubscribe', 'forum', 'name'); -- 2.39.5