Bug 34065 - Remove unnecessary column-level collation settings for upgraded databases
Summary: Remove unnecessary column-level collation settings for upgraded databases
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: Main
Hardware: All All
: P5 - low minor
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-06-20 06:39 UTC by David Cook
Modified: 2023-06-21 00:07 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description David Cook 2023-06-20 06:39:31 UTC 
There is a discrepancy on column collation between kohastructure.sql and upgraded databases.

One example is the "localization" table. Upgraded databases will have "utf8_unicode_ci" set for column collation and table collation. 

However, kohastructure.sql only has it at the table level.

If you're using an audit script like in bug 34064, this difference will show up. While it's a minor difference, it's a noisy difference and a difference nonetheless.