[Koha-bugs] [Bug 21294] Indentify boolean fields on the DB structure

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Apr 17 15:48:56 CEST 2020


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21294

--- Comment #9 from Tomás Cohen Arazi <tomascohen at gmail.com> ---
Created attachment 103165
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=103165&action=edit
Bug 21294: Replace BOOLEAN with TINYINT(1) in our DB structure

To match the coding guideline SQL12.
We do this for consistency.
Note that we do not need an update DB as BOOLEAN is an alias for
TINYINT(1).

The is_boolean flags have been added to the schema.

Test plan:
1. `dbic` should run correctly
2. kohastructure.sql should be syntaxicaly correct
3. `git grep -i boolean installer/data/mysql/kohastructure.sql`
should not return relevant occurrences.

Signed-off-by: Tomas Cohen Arazi <tomascohen at theke.io>

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list