From e4a0993bdefd962a5212bf2a46d50ce78e9e9ea4 Mon Sep 17 00:00:00 2001 From: Petr Skoda Date: Mon, 24 Apr 2006 19:35:48 +0000 Subject: [PATCH] fixed log action inserts --- db/mysql.sql | 10 +++++----- db/postgres7.sql | 10 +++++----- 2 files changed, 10 insertions(+), 10 deletions(-) diff --git a/db/mysql.sql b/db/mysql.sql index 9cf93e54024..ecb8593b16b 100644 --- a/db/mysql.sql +++ b/db/mysql.sql @@ -1,4 +1,4 @@ -# $Id: mysql.sql,v 1.1 2006/03/12 18:40:01 skodak Exp $ +# $Id: mysql.sql,v 1.2 2006/04/24 19:35:48 skodak Exp $ # This file contains a complete database schema for all the # tables used by the book module, written in SQL @@ -35,7 +35,7 @@ CREATE TABLE prefix_book_chapters ( ) COMMENT='Defines book_chapters'; # -------------------------------------------------------- -INSERT INTO prefix_log_display VALUES ('book', 'update', 'book', 'name'); -INSERT INTO prefix_log_display VALUES ('book', 'view', 'book', 'name'); -INSERT INTO prefix_log_display VALUES ('book', 'view all', 'book', 'name'); -INSERT INTO prefix_log_display VALUES ('book', 'print', 'book', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('book', 'update', 'book', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('book', 'view', 'book', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('book', 'view all', 'book', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('book', 'print', 'book', 'name'); diff --git a/db/postgres7.sql b/db/postgres7.sql index 2d6a4ec77b2..9c74f3f7d47 100644 --- a/db/postgres7.sql +++ b/db/postgres7.sql @@ -1,4 +1,4 @@ -# $Id: postgres7.sql,v 1.1 2006/03/12 18:40:01 skodak Exp $ +# $Id: postgres7.sql,v 1.2 2006/04/24 19:35:48 skodak Exp $ # This file contains a complete database schema for all the # tables used by the book module, written in SQL @@ -33,7 +33,7 @@ CREATE TABLE prefix_book_chapters ( ); # -------------------------------------------------------- -INSERT INTO prefix_log_display VALUES ('book', 'update', 'book', 'name'); -INSERT INTO prefix_log_display VALUES ('book', 'view', 'book', 'name'); -INSERT INTO prefix_log_display VALUES ('book', 'view all', 'book', 'name'); -INSERT INTO prefix_log_display VALUES ('book', 'print', 'book', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('book', 'update', 'book', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('book', 'view', 'book', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('book', 'view all', 'book', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('book', 'print', 'book', 'name'); -- 2.43.0