From a87ed739ec48e60fd5361beb0000bb3759731963 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 29 Aug 2014 17:38:33 +0200 Subject: [PATCH] Bug 11944: (follow-up) Convert DB tables to utf8_unicode_ci Some lines didn't match the regex I used! --- installer/data/mysql/kohastructure.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 2da5da6..fcf2d3d 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -482,7 +482,7 @@ CREATE TABLE collections ( colDesc text NOT NULL, colBranchcode varchar(4) DEFAULT NULL comment 'branchcode for branch where item should be held.', PRIMARY KEY (colId) -) ENGINE=InnoDB DEFAULT CHARACTER SET utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Table: collections_tracking @@ -493,7 +493,7 @@ CREATE TABLE collections_tracking ( colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId', itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber', PRIMARY KEY (collections_tracking_id) -) ENGINE=InnoDB DEFAULT CHARACTER SET utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Table structure for table `courses` @@ -957,7 +957,7 @@ CREATE TABLE `export_format` ( `encoding` varchar(255) NOT NULL, `type` varchar(255) DEFAULT 'marc', PRIMARY KEY (`export_format_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Used for CSV export'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used for CSV export'; -- @@ -1917,7 +1917,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`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Opac search history results'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Opac search history results'; -- @@ -2982,7 +2982,7 @@ CREATE TABLE `aqcontract` ( PRIMARY KEY (`contractnumber`), CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -- Table structure for table `aqorders` -- 2.0.0.rc2