Bug 21294: Replace BOOLEAN with TINYINT(1) in our DB structure
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Wed, 15 Apr 2020 14:15:33 +0000 (16:15 +0200)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Wed, 29 Apr 2020 15:58:45 +0000 (16:58 +0100)
commitfeab2cbeb2179589c74524135bd2ff57b660a8e1
treeb0ff2acfed1e947ac2019025acda0717c1b69a3b
parent76bf4dc056f0e234344045569fee2daa63ac2e45
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@theke.io>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Koha/Schema/Result/Aqcontact.pm
Koha/Schema/Result/EdifactMessage.pm
Koha/Schema/Result/OldReserve.pm
Koha/Schema/Result/SavedSql.pm
Koha/Schema/Result/SearchMarcToField.pm
Koha/Schema/Result/Subscription.pm
installer/data/mysql/kohastructure.sql