Bugzilla – Attachment 123112 Details for
Bug 28534
pending_offline_circulations table uses MyISAM engine
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 28534: Fix engine for pending_offline_circulations table
Bug-28534-Fix-engine-for-pendingofflinecirculation.patch (text/plain), 2.38 KB, created by
Kyle M Hall (khall)
on 2021-07-23 13:36:19 UTC
(
hide
)
Description:
Bug 28534: Fix engine for pending_offline_circulations table
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2021-07-23 13:36:19 UTC
Size:
2.38 KB
patch
obsolete
>From 1922f1a89dd3af7d1f25630ccad27450044205ba Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >Date: Wed, 9 Jun 2021 13:46:16 +0000 >Subject: [PATCH] Bug 28534: Fix engine for pending_offline_circulations table > >Signed-off-by: David Nind <david@davidnind.com> > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > installer/data/mysql/kohastructure.sql | 2 +- > installer/data/mysql/updatedatabase.pl | 2 +- > 2 files changed, 2 insertions(+), 2 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 58dadc1541..befd280789 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -4065,7 +4065,7 @@ CREATE TABLE `pending_offline_operations` ( > `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, > `amount` decimal(28,6) DEFAULT NULL, > PRIMARY KEY (`operationid`) >-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > /*!40101 SET character_set_client = @saved_cs_client */; > > -- >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index fd97a34c50..71a2db2781 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -4731,7 +4731,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { > > $DBversion = "3.07.00.018"; > if (C4::Context->preference("Version") < TransformToNum($DBversion)) { >- $dbh->do("CREATE TABLE pending_offline_operations ( operationid int(11) NOT NULL AUTO_INCREMENT, userid varchar(30) NOT NULL, branchcode varchar(10) NOT NULL, timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, action varchar(10) NOT NULL, barcode varchar(20) NOT NULL, cardnumber varchar(16) DEFAULT NULL, PRIMARY KEY (operationid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;"); >+ $dbh->do("CREATE TABLE pending_offline_operations ( operationid int(11) NOT NULL AUTO_INCREMENT, userid varchar(30) NOT NULL, branchcode varchar(10) NOT NULL, timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, action varchar(10) NOT NULL, barcode varchar(20) NOT NULL, cardnumber varchar(16) DEFAULT NULL, PRIMARY KEY (operationid) ) ENGINE=INNODB DEFAULT CHARSET=utf8;"); > print "Upgrade to $DBversion done ( adding offline operations table )\n"; > SetVersion($DBversion); > } >-- >2.30.1 (Apple Git-130)
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 28534
:
121746
|
121908
|
121917
|
121918
|
123112
|
123113
|
124865
|
125265
|
125266
|
125267
|
125393