Bugzilla – Attachment 71784 Details for
Bug 18336
Add support for Unicode supplementary characters
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 18336: Add explicit index names to kohastructure.sql
Bug-18336-Add-explicit-index-names-to-kohastructur.patch (text/plain), 3.15 KB, created by
Tomás Cohen Arazi (tcohen)
on 2018-02-16 14:27:05 UTC
(
hide
)
Description:
Bug 18336: Add explicit index names to kohastructure.sql
Filename:
MIME Type:
Creator:
Tomás Cohen Arazi (tcohen)
Created:
2018-02-16 14:27:05 UTC
Size:
3.15 KB
patch
obsolete
>From 23205b79e1abb24166ef56112638683889b39d94 Mon Sep 17 00:00:00 2001 >From: Tomas Cohen Arazi <tomascohen@theke.io> >Date: Tue, 23 Jan 2018 12:26:26 -0300 >Subject: [PATCH] Bug 18336: Add explicit index names to kohastructure.sql > >This patch just adds an explicit index name to the search_marc_map >table. The atomicupdate on this patchset is a good example of why we >better have them. > >Sponsored-by: Hotchkiss School > >Signed-off-by: Mark Tompsett <mtompset@hotmail.com> > >Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> >--- > installer/data/mysql/kohastructure.sql | 12 ++++++------ > 1 file changed, 6 insertions(+), 6 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 36f6cac1d4..b5b3d898fd 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1349,7 +1349,7 @@ CREATE TABLE `printers` ( > `printername` varchar(40) NOT NULL default '', > `printqueue` varchar(20) default NULL, > `printtype` varchar(20) default NULL, >- PRIMARY KEY (`printername`) >+ PRIMARY KEY (`printername`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > > -- >@@ -1441,7 +1441,7 @@ CREATE TABLE saved_reports ( > `report_id` int(11) default NULL, > `report` longtext, > `date_run` datetime default NULL, >- PRIMARY KEY (`id`) >+ PRIMARY KEY (`id`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > > -- >@@ -1455,7 +1455,7 @@ CREATE TABLE `search_field` ( > `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display', > `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine', > PRIMARY KEY (`id`), >- UNIQUE KEY (`name` (191) ) >+ UNIQUE KEY (`name` (191)) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > > -- >@@ -1474,7 +1474,7 @@ CREATE TABLE IF NOT EXISTS `search_history` ( -- patron's opac search history > `time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run > KEY `userid` (`userid`), > KEY `sessionid` (`sessionid`), >- PRIMARY KEY (`id`) >+ PRIMARY KEY (`id`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Opac search history results'; > > -- >@@ -1488,7 +1488,7 @@ CREATE TABLE `search_marc_map` ( > marc_type ENUM('marc21', 'unimarc', 'normarc') NOT NULL COMMENT 'what MARC type this map is for', > marc_field VARCHAR(255) NOT NULL COMMENT 'the MARC specifier for this field', > PRIMARY KEY(`id`), >- UNIQUE key(index_name, marc_field(191), marc_type), >+ UNIQUE key `index_name` (`index_name`, `marc_field` (191), `marc_type`), > INDEX (`index_name`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > >@@ -1529,7 +1529,7 @@ CREATE TABLE `serial` ( -- issues related to subscriptions > `claimdate` date default NULL, -- date claimed > claims_count int(11) default 0, -- number of claims made related to this issue > `routingnotes` text, -- notes from the routing list >- PRIMARY KEY (`serialid`) >+ PRIMARY KEY (`serialid`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > > -- >-- >2.14.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 18336
:
70854
|
70855
|
70856
|
70857
|
70858
|
70859
|
70904
|
70905
|
70906
|
70907
|
70908
|
70909
|
71022
|
71210
|
71211
|
71212
|
71213
|
71214
|
71215
|
71216
|
71337
|
71779
|
71780
|
71781
|
71782
|
71783
|
71784
|
71785
|
71786
|
71836
|
71843
|
71844
|
71845
|
71846
|
71847
|
71848
|
71849
|
71850
|
71851
|
71953