From cf29432dcd92e0aaadc135b4bb23536553eb1998 Mon Sep 17 00:00:00 2001 From: vyshane Date: Mon, 24 Apr 2006 08:09:00 +0000 Subject: [PATCH] Fixing inserts for log_display table. --- mod/data/db/mysql.php | 14 +++++++------- mod/data/db/mysql.sql | 16 ++++++++-------- mod/data/db/postgres7.php | 16 ++++++++-------- mod/data/db/postgres7.sql | 16 ++++++++-------- 4 files changed, 31 insertions(+), 31 deletions(-) diff --git a/mod/data/db/mysql.php b/mod/data/db/mysql.php index edcd727723..1403b41971 100644 --- a/mod/data/db/mysql.php +++ b/mod/data/db/mysql.php @@ -30,13 +30,13 @@ function data_upgrade($oldversion) { } if ($oldversion < 2006030700) { - modify_database('', "INSERT INTO prefix_log_display VALUES ('data', 'add', 'data', 'name')"); - modify_database('', "INSERT INTO prefix_log_display VALUES ('data', 'update', 'data', 'name')"); - modify_database('', "INSERT INTO prefix_log_display VALUES ('data', 'record delete', 'data', 'name')"); - modify_database('', "INSERT INTO prefix_log_display VALUES ('data', 'fields add', 'data_fields', 'name')"); - modify_database('', "INSERT INTO prefix_log_display VALUES ('data', 'fields update', 'data_fields', 'name')"); - modify_database('', "INSERT INTO prefix_log_display VALUES ('data', 'templates saved', 'data', 'name')"); - modify_database('', "INSERT INTO prefix_log_display VALUES ('data', 'templates def', 'data', 'name')"); + modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'add', 'data', 'name')"); + modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'update', 'data', 'name')"); + modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'record delete', 'data', 'name')"); + modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'fields add', 'data_fields', 'name')"); + modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'fields update', 'data_fields', 'name')"); + modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'templates saved', 'data', 'name')"); + modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'templates def', 'data', 'name')"); } if ($oldversion < 2006032700) { diff --git a/mod/data/db/mysql.sql b/mod/data/db/mysql.sql index 99e5a886ba..fb855fdcd5 100755 --- a/mod/data/db/mysql.sql +++ b/mod/data/db/mysql.sql @@ -109,11 +109,11 @@ CREATE TABLE prefix_data_ratings ( ) TYPE=MyISAM; -INSERT INTO prefix_log_display VALUES ('data', 'view', 'data', 'name'); -INSERT INTO prefix_log_display VALUES ('data', 'add', 'data', 'name'); -INSERT INTO prefix_log_display VALUES ('data', 'update', 'data', 'name'); -INSERT INTO prefix_log_display VALUES ('data', 'record delete', 'data', 'name'); -INSERT INTO prefix_log_display VALUES ('data', 'fields add', 'data_fields', 'name'); -INSERT INTO prefix_log_display VALUES ('data', 'fields update', 'data_fields', 'name'); -INSERT INTO prefix_log_display VALUES ('data', 'templates saved', 'data', 'name'); -INSERT INTO prefix_log_display VALUES ('data', 'templates def', 'data', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'view', 'data', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'add', 'data', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'update', 'data', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'record delete', 'data', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'fields add', 'data_fields', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'fields update', 'data_fields', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'templates saved', 'data', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'templates def', 'data', 'name'); diff --git a/mod/data/db/postgres7.php b/mod/data/db/postgres7.php index a4d67dfe29..a0977e758a 100644 --- a/mod/data/db/postgres7.php +++ b/mod/data/db/postgres7.php @@ -30,14 +30,14 @@ function data_upgrade($oldversion) { } if ($oldversion < 2006030700) { - modify_database('', "INSERT INTO prefix_log_display VALUES ('data', 'view', 'data', 'name');"); - modify_database('', "INSERT INTO prefix_log_display VALUES ('data', 'add', 'data', 'name')"); - modify_database('', "INSERT INTO prefix_log_display VALUES ('data', 'update', 'data', 'name')"); - modify_database('', "INSERT INTO prefix_log_display VALUES ('data', 'record delete', 'data', 'name')"); - modify_database('', "INSERT INTO prefix_log_display VALUES ('data', 'fields add', 'data_fields', 'name')"); - modify_database('', "INSERT INTO prefix_log_display VALUES ('data', 'fields update', 'data_fields', 'name')"); - modify_database('', "INSERT INTO prefix_log_display VALUES ('data', 'templates saved', 'data', 'name')"); - modify_database('', "INSERT INTO prefix_log_display VALUES ('data', 'templates defaults', 'data', 'name')"); + modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'view', 'data', 'name');"); + modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'add', 'data', 'name')"); + modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'update', 'data', 'name')"); + modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'record delete', 'data', 'name')"); + modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'fields add', 'data_fields', 'name')"); + modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'fields update', 'data_fields', 'name')"); + modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'templates saved', 'data', 'name')"); + modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'templates defaults', 'data', 'name')"); } if ($oldversion < 2006032700) { diff --git a/mod/data/db/postgres7.sql b/mod/data/db/postgres7.sql index 77395b7aea..0993f87733 100755 --- a/mod/data/db/postgres7.sql +++ b/mod/data/db/postgres7.sql @@ -89,11 +89,11 @@ CREATE TABLE prefix_data_ratings ( rating int4 NOT NULL default '0' ); -INSERT INTO prefix_log_display VALUES ('data', 'view', 'data', 'name'); -INSERT INTO prefix_log_display VALUES ('data', 'add', 'data', 'name'); -INSERT INTO prefix_log_display VALUES ('data', 'update', 'data', 'name'); -INSERT INTO prefix_log_display VALUES ('data', 'record delete', 'data', 'name'); -INSERT INTO prefix_log_display VALUES ('data', 'fields add', 'data_fields', 'name'); -INSERT INTO prefix_log_display VALUES ('data', 'fields update', 'data_fields', 'name'); -INSERT INTO prefix_log_display VALUES ('data', 'templates saved', 'data', 'name'); -INSERT INTO prefix_log_display VALUES ('data', 'templates def', 'data', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'view', 'data', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'add', 'data', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'update', 'data', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'record delete', 'data', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'fields add', 'data_fields', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'fields update', 'data_fields', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'templates saved', 'data', 'name'); +INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'templates def', 'data', 'name'); -- 2.39.5