Bugzilla – Attachment 54294 Details for
Bug 16829
action_logs should have an 'interface' column
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 16829: Add 'interface' column to action_logs
Bug-16829-Add-interface-column-to-actionlogs.patch (text/plain), 2.75 KB, created by
Jonathan Druart
on 2016-08-11 10:28:08 UTC
(
hide
)
Description:
Bug 16829: Add 'interface' column to action_logs
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2016-08-11 10:28:08 UTC
Size:
2.75 KB
patch
obsolete
>From 05fad3342b0575f4eaa2240da292b4caacf9af1e Mon Sep 17 00:00:00 2001 >From: Tomas Cohen Arazi <tomascohen@theke.io> >Date: Fri, 1 Jul 2016 17:48:37 -0300 >Subject: [PATCH] Bug 16829: Add 'interface' column to action_logs > >This patch introduces a new column for the action_logs table. It is >called 'interface' and it is intended to store the interface in which >the action was performed. > >Sponsored-by: NEKLS > >Signed-off-by: Nicole C Engard <nengard@bywatersolutions.com> > >Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >--- > .../mysql/atomicupdate/bug_16829_action_logs_interface.sql | 14 ++++++++++++++ > installer/data/mysql/kohastructure.sql | 4 +++- > 2 files changed, 17 insertions(+), 1 deletion(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_16829_action_logs_interface.sql > >diff --git a/installer/data/mysql/atomicupdate/bug_16829_action_logs_interface.sql b/installer/data/mysql/atomicupdate/bug_16829_action_logs_interface.sql >new file mode 100644 >index 0000000..9591824 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_16829_action_logs_interface.sql >@@ -0,0 +1,14 @@ >+ALTER TABLE `action_logs` ADD COLUMN `interface` VARCHAR(30) DEFAULT NULL AFTER `info`; >+ALTER TABLE `action_logs` ADD KEY `interface` (`interface`); >+ >+-- $DBversion = "16.06.00.XXX"; >+-- if ( CheckVersion($DBversion) ) { >+-- $dbh->do(q{ >+-- ALTER TABLE `action_logs` ADD COLUMN `interface` VARCHAR(30) DEFAULT NULL AFTER `info`; >+-- }); >+-- $dbh->do({ >+-- ALTER TABLE `action_logs` ADD KEY `interface` (`interface`); >+-- }); >+-- print "Upgrade to $DBversion done (Bug 16829: action_logs should have an 'interface' column)\n"; >+-- SetVersion($DBversion); >+-- } >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 76aa462..a05ef06 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -2715,13 +2715,15 @@ CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the > `action` text, -- the action (includes things like DELETED, ADDED, MODIFY, etc) > `object` int(11) default NULL, -- the object that the action was taken against (could be a borrowernumber, itemnumber, etc) > `info` text, -- information about the action (usually includes SQL statement) >+ `interface` VARCHAR(30) DEFAULT NULL, -- the context this action was taken in > PRIMARY KEY (`action_id`), > KEY `timestamp_idx` (`timestamp`), > KEY `user_idx` (`user`), > KEY `module_idx` (`module`(255)), > KEY `action_idx` (`action`(255)), > KEY `object_idx` (`object`), >- KEY `info_idx` (`info`(255)) >+ KEY `info_idx` (`info`(255)), >+ KEY `interface` (`interface`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > > -- >-- >2.8.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 16829
:
53060
|
53061
|
53062
|
53063
|
53064
|
53199
|
53200
|
53201
|
53202
|
53203
| 54294 |
54295
|
54296
|
54297
|
54298