From f21cc86bca013bb0b1bc99b2931ecf6d335b8c90 Mon Sep 17 00:00:00 2001 From: toyomoyo Date: Mon, 24 Apr 2006 08:10:55 +0000 Subject: [PATCH] changed formats for log_display table --- mod/quiz/db/mysql.sql | 24 ++++++++++++------------ mod/quiz/db/postgres7.sql | 24 ++++++++++++------------ mod/resource/db/mysql.sql | 6 +++--- mod/resource/db/oci8po.sql | 2 +- mod/resource/db/postgres7.sql | 6 +++--- mod/scorm/db/mysql.sql | 8 ++++---- mod/scorm/db/postgres7.sql | 8 ++++---- mod/survey/db/mysql.sql | 14 +++++++------- mod/survey/db/oci8po.sql | 10 +++++----- mod/survey/db/postgres7.sql | 14 +++++++------- mod/workshop/db/mysql.sql | 16 ++++++++-------- mod/workshop/db/oci8po.sql | 22 +++++++++++----------- mod/workshop/db/postgres7.sql | 16 ++++++++-------- 13 files changed, 85 insertions(+), 85 deletions(-) diff --git a/mod/quiz/db/mysql.sql b/mod/quiz/db/mysql.sql index cdf48f2fd2..9f9d34c0f9 100644 --- a/mod/quiz/db/mysql.sql +++ b/mod/quiz/db/mysql.sql @@ -287,15 +287,15 @@ CREATE TABLE prefix_question_states ( -- -------------------------------------------------------- -INSERT INTO prefix_log_display VALUES ('quiz', 'add', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'update', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'view', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'report', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'attempt', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'submit', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'review', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'editquestions', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'preview', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'start attempt', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'close attempt', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'continue attempt', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'add', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'update', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'view', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'report', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'attempt', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'submit', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'review', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'editquestions', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'preview', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'start attempt', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'close attempt', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'continue attempt', 'quiz', 'name'); diff --git a/mod/quiz/db/postgres7.sql b/mod/quiz/db/postgres7.sql index 94baa168e3..5c771567d8 100644 --- a/mod/quiz/db/postgres7.sql +++ b/mod/quiz/db/postgres7.sql @@ -280,15 +280,15 @@ CREATE INDEX prefix_question_states_attempt_idx ON prefix_question_states (attem CREATE INDEX prefix_question_states_question_idx ON prefix_question_states (question);; -INSERT INTO prefix_log_display VALUES ('quiz', 'add', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'update', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'view', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'report', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'attempt', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'submit', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'review', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'editquestions', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'preview', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'start attempt', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'close attempt', 'quiz', 'name'); -INSERT INTO prefix_log_display VALUES ('quiz', 'continue attempt', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'add', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'update', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'view', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'report', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'attempt', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'submit', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'review', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'editquestions', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'preview', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'start attempt', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'close attempt', 'quiz', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('quiz', 'continue attempt', 'quiz', 'name'); diff --git a/mod/resource/db/mysql.sql b/mod/resource/db/mysql.sql index 9e6dd68f55..75274e4106 100755 --- a/mod/resource/db/mysql.sql +++ b/mod/resource/db/mysql.sql @@ -35,6 +35,6 @@ CREATE TABLE prefix_resource ( # Dumping data for table `log_display` # -INSERT INTO prefix_log_display VALUES ('resource', 'view', 'resource', 'name'); -INSERT INTO prefix_log_display VALUES ('resource', 'update', 'resource', 'name'); -INSERT INTO prefix_log_display VALUES ('resource', 'add', 'resource', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('resource', 'view', 'resource', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('resource', 'update', 'resource', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('resource', 'add', 'resource', 'name'); diff --git a/mod/resource/db/oci8po.sql b/mod/resource/db/oci8po.sql index a90de96147..427e5d31e9 100755 --- a/mod/resource/db/oci8po.sql +++ b/mod/resource/db/oci8po.sql @@ -41,5 +41,5 @@ rem Dumping data for table log_display rem delete from prefix_log_display where module = 'resource'; -INSERT INTO prefix_log_display VALUES ('resource', 'view', 'resource', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('resource', 'view', 'resource', 'name'); select * from prefix_log_display where module = 'resource'; diff --git a/mod/resource/db/postgres7.sql b/mod/resource/db/postgres7.sql index 2a619077e9..8660faf5cb 100644 --- a/mod/resource/db/postgres7.sql +++ b/mod/resource/db/postgres7.sql @@ -33,6 +33,6 @@ CREATE INDEX prefix_resource_course_idx ON prefix_resource (course); # Dumping data for table `log_display` # -INSERT INTO prefix_log_display VALUES ('resource', 'view', 'resource', 'name'); -INSERT INTO prefix_log_display VALUES ('resource', 'update', 'resource', 'name'); -INSERT INTO prefix_log_display VALUES ('resource', 'add', 'resource', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('resource', 'view', 'resource', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('resource', 'update', 'resource', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('resource', 'add', 'resource', 'name'); diff --git a/mod/scorm/db/mysql.sql b/mod/scorm/db/mysql.sql index c6c61dbbdf..b4b6cacd6d 100755 --- a/mod/scorm/db/mysql.sql +++ b/mod/scorm/db/mysql.sql @@ -71,7 +71,7 @@ CREATE TABLE prefix_scorm_scoes_track ( # Dumping data for table log_display # -INSERT INTO prefix_log_display VALUES ('scorm', 'view', 'scorm', 'name'); -INSERT INTO prefix_log_display VALUES ('scorm', 'review', 'scorm', 'name'); -INSERT INTO prefix_log_display VALUES ('scorm', 'update', 'scorm', 'name'); -INSERT INTO prefix_log_display VALUES ('scorm', 'add', 'scorm', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('scorm', 'view', 'scorm', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('scorm', 'review', 'scorm', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('scorm', 'update', 'scorm', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('scorm', 'add', 'scorm', 'name'); diff --git a/mod/scorm/db/postgres7.sql b/mod/scorm/db/postgres7.sql index a734d07f10..9715611eaf 100755 --- a/mod/scorm/db/postgres7.sql +++ b/mod/scorm/db/postgres7.sql @@ -68,7 +68,7 @@ CREATE INDEX prefix_scorm_scoes_track_element_idx ON prefix_scorm_scoes_track (e # Dumping data for table `log_display` # -INSERT INTO prefix_log_display VALUES ('resource', 'view', 'resource', 'name'); -INSERT INTO prefix_log_display VALUES ('resource', 'review', 'resource', 'name'); -INSERT INTO prefix_log_display VALUES ('resource', 'update', 'resource', 'name'); -INSERT INTO prefix_log_display VALUES ('resource', 'add', 'resource', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('resource', 'view', 'resource', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('resource', 'review', 'resource', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('resource', 'update', 'resource', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('resource', 'add', 'resource', 'name'); diff --git a/mod/survey/db/mysql.sql b/mod/survey/db/mysql.sql index 4e9bb2946e..bdba5bf730 100755 --- a/mod/survey/db/mysql.sql +++ b/mod/survey/db/mysql.sql @@ -184,10 +184,10 @@ INSERT INTO `prefix_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intr # Dumping data for table `log_display` # -INSERT INTO prefix_log_display VALUES ('survey', 'add', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'update', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'download', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'view form', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'view graph', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'view report', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'submit', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'add', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'update', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'download', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'view form', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'view graph', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'view report', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'submit', 'survey', 'name'); diff --git a/mod/survey/db/oci8po.sql b/mod/survey/db/oci8po.sql index 7e1599e5a9..105eca6df7 100755 --- a/mod/survey/db/oci8po.sql +++ b/mod/survey/db/oci8po.sql @@ -219,9 +219,9 @@ rem Dumping data for table log_display rem delete from prefix_log_display where module = 'survey'; -INSERT INTO prefix_log_display VALUES ('survey', 'download', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'view form', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'view graph', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'view report', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'submit', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'download', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'view form', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'view graph', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'view report', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'submit', 'survey', 'name'); select * from prefix_log_display where module = 'survey'; diff --git a/mod/survey/db/postgres7.sql b/mod/survey/db/postgres7.sql index 550eba862d..899c5df748 100755 --- a/mod/survey/db/postgres7.sql +++ b/mod/survey/db/postgres7.sql @@ -193,10 +193,10 @@ SELECT setval('prefix_survey_questions_id_seq', (select max(id) from prefix_surv # Dumping data for table log_display # -INSERT INTO prefix_log_display VALUES ('survey', 'add', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'update', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'download', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'view form', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'view graph', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'view report', 'survey', 'name'); -INSERT INTO prefix_log_display VALUES ('survey', 'submit', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'add', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'update', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'download', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'view form', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'view graph', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'view report', 'survey', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('survey', 'submit', 'survey', 'name'); diff --git a/mod/workshop/db/mysql.sql b/mod/workshop/db/mysql.sql index caa0fc6965..25e7bbae0b 100644 --- a/mod/workshop/db/mysql.sql +++ b/mod/workshop/db/mysql.sql @@ -177,11 +177,11 @@ CREATE TABLE `prefix_workshop_comments` ( -INSERT INTO `prefix_log_display` VALUES ('workshop', 'assessments', 'workshop', 'name'); -INSERT INTO `prefix_log_display` VALUES ('workshop', 'close', 'workshop', 'name'); -INSERT INTO `prefix_log_display` VALUES ('workshop', 'display', 'workshop', 'name'); -INSERT INTO `prefix_log_display` VALUES ('workshop', 'resubmit', 'workshop', 'name'); -INSERT INTO `prefix_log_display` VALUES ('workshop', 'set up', 'workshop', 'name'); -INSERT INTO `prefix_log_display` VALUES ('workshop', 'submissions', 'workshop', 'name'); -INSERT INTO `prefix_log_display` VALUES ('workshop', 'view', 'workshop', 'name'); -INSERT INTO `prefix_log_display` VALUES ('workshop', 'update', 'workshop', 'name'); +INSERT INTO `prefix_log_display` (module, action, mtable, field) VALUES ('workshop', 'assessments', 'workshop', 'name'); +INSERT INTO `prefix_log_display` (module, action, mtable, field) VALUES ('workshop', 'close', 'workshop', 'name'); +INSERT INTO `prefix_log_display` (module, action, mtable, field) VALUES ('workshop', 'display', 'workshop', 'name'); +INSERT INTO `prefix_log_display` (module, action, mtable, field) VALUES ('workshop', 'resubmit', 'workshop', 'name'); +INSERT INTO `prefix_log_display` (module, action, mtable, field) VALUES ('workshop', 'set up', 'workshop', 'name'); +INSERT INTO `prefix_log_display` (module, action, mtable, field) VALUES ('workshop', 'submissions', 'workshop', 'name'); +INSERT INTO `prefix_log_display` (module, action, mtable, field) VALUES ('workshop', 'view', 'workshop', 'name'); +INSERT INTO `prefix_log_display` (module, action, mtable, field) VALUES ('workshop', 'update', 'workshop', 'name'); diff --git a/mod/workshop/db/oci8po.sql b/mod/workshop/db/oci8po.sql index 4e20789282..1a9e2e9055 100755 --- a/mod/workshop/db/oci8po.sql +++ b/mod/workshop/db/oci8po.sql @@ -21,8 +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, - overallocation 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, @@ -305,14 +305,14 @@ rem -------------------------------------------------------- delete from prefix_log_display where module='workshop'; -INSERT INTO prefix_log_display VALUES ('workshop', 'assess', 'workshop', 'name'); -INSERT INTO prefix_log_display VALUES ('workshop', 'close', 'workshop', 'name'); -INSERT INTO prefix_log_display VALUES ('workshop', 'display grades', 'workshop', 'name'); -INSERT INTO prefix_log_display VALUES ('workshop', 'grade', 'workshop', 'name'); -INSERT INTO prefix_log_display VALUES ('workshop', 'hide grades', 'workshop', 'name'); -INSERT INTO prefix_log_display VALUES ('workshop', 'open', 'workshop', 'name'); -INSERT INTO prefix_log_display VALUES ('workshop', 'submit', 'workshop', 'name'); -INSERT INTO prefix_log_display VALUES ('workshop', 'view', 'workshop', 'name'); -INSERT INTO prefix_log_display VALUES ('workshop', 'update', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'assess', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'close', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'display grades', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'grade', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'hide grades', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'open', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'submit', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'view', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'update', 'workshop', 'name'); select * from prefix_log_display where module='workshop' order by 1,2; diff --git a/mod/workshop/db/postgres7.sql b/mod/workshop/db/postgres7.sql index 1485241390..2949af37c3 100644 --- a/mod/workshop/db/postgres7.sql +++ b/mod/workshop/db/postgres7.sql @@ -164,13 +164,13 @@ CREATE TABLE prefix_workshop_stockcomments ( comments text NOT NULL ); -INSERT INTO prefix_log_display VALUES ('workshop', 'assessments', 'workshop', 'name'); -INSERT INTO prefix_log_display VALUES ('workshop', 'close', 'workshop', 'name'); -INSERT INTO prefix_log_display VALUES ('workshop', 'display', 'workshop', 'name'); -INSERT INTO prefix_log_display VALUES ('workshop', 'resubmit', 'workshop', 'name'); -INSERT INTO prefix_log_display VALUES ('workshop', 'set up', 'workshop', 'name'); -INSERT INTO prefix_log_display VALUES ('workshop', 'submissions', 'workshop', 'name'); -INSERT INTO prefix_log_display VALUES ('workshop', 'view', 'workshop', 'name'); -INSERT INTO prefix_log_display VALUES ('workshop', 'update', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'assessments', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'close', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'display', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'resubmit', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'set up', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'submissions', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'view', 'workshop', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('workshop', 'update', 'workshop', 'name'); COMMIT; -- 2.39.5