Bugzilla – Attachment 153601 Details for
Bug 25159
Action logs should be stored in JSON (and as a diff of the change)
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 25159: DB Update
Bug-25159-DB-Update.patch (text/plain), 1.78 KB, created by
Kyle M Hall (khall)
on 2023-07-18 13:08:53 UTC
(
hide
)
Description:
Bug 25159: DB Update
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2023-07-18 13:08:53 UTC
Size:
1.78 KB
patch
obsolete
>From 6ff399ec8d1591d273d0c67a6990b93adde59650 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Tue, 18 Jul 2023 07:00:50 -0400 >Subject: [PATCH] Bug 25159: DB Update > >--- > installer/data/mysql/atomicupdate/bug_25159.pl | 13 +++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 14 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_25159.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_25159.pl b/installer/data/mysql/atomicupdate/bug_25159.pl >new file mode 100755 >index 0000000000..a2c24e7407 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_25159.pl >@@ -0,0 +1,13 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "251159", >+ description => "Add action logs should be stored in JSON ( and as a diff of the change )", >+ up => sub { >+ my ($args) = @_; >+ my ($dbh, $out) = @$args{qw(dbh out)}; >+ >+ $dbh->do(q{ALTER TABLE action_logs ADD COLUMN diff LONGTEXT NULL DEFAULT NULL AFTER trace;}); >+ say $out "Added column 'action_logs.diff'"; >+ }, >+}; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 5395e1f20c..54fcc7a8d5 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -173,6 +173,7 @@ CREATE TABLE `action_logs` ( > `interface` varchar(30) DEFAULT NULL COMMENT 'the context this action was taken in', > `script` varchar(255) DEFAULT NULL COMMENT 'the name of the cron script that caused this change', > `trace` text DEFAULT NULL COMMENT 'An optional stack trace enabled by ActionLogsTraceDepth', >+ `diff` LONGTEXT NULL DEFAULT NULL COMMENT 'Stores a diff of the changed object', > PRIMARY KEY (`action_id`), > KEY `timestamp_idx` (`timestamp`), > KEY `user_idx` (`user`), >-- >2.30.2
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 25159
:
153600
|
153601
|
153602
|
153603
|
153604
|
153606
|
153607
|
153608
|
153609
|
153611
|
153612
|
153613
|
153614
|
153637
|
153643
|
153644
|
153645
|
153646
|
159758
|
164597
|
164598
|
164599
|
164600
|
164601
|
165527
|
165528
|
165529
|
165530
|
165531
|
165532
|
166219