[Koha-bugs] [Bug 26947] kohastructure.sql should be updated for each release

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #51 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
Hum, I was going to push it and found:

% diff /var/spool/koha/kohadev/kohadev-schema-2021-01-12.sql
installer/data/mysql/kohastructure.sql                
1c1                                                                             
< -- MySQL dump 10.16  Distrib 10.1.47-MariaDB, for debian-linux-gnu (x86_64)   
---                                                                             
> -- MariaDB dump 10.18  Distrib 10.5.8-MariaDB, for debian-linux-gnu (x86_64)                                                                             
5c5                                                                             
< -- Server version     10.1.48-MariaDB-1~bionic                                
---                                                                             
> -- Server version     10.3.27-MariaDB-1:10.3.27+maria~focal                                                                            
28,31c28,31                                                                     
<   `can_be_added_manually` tinyint(4) NOT NULL DEFAULT '1',                    
<   `credit_number_enabled` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is
autogeneration of credit number enabled for this credit type',                  
<   `is_system` tinyint(1) NOT NULL DEFAULT '0',                                
<   `archived` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'boolean flag to denote
if this till is archived or not',                                 
---                                                                             
>   `can_be_added_manually` tinyint(4) NOT NULL DEFAULT 1,                                                                                         
>   `credit_number_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is autogeneration of credit number enabled for this credit type',                     
>   `is_system` tinyint(1) NOT NULL DEFAULT 0,                                                                                                        
>   `archived` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote if this till is archived or not',   
[SKIP]

% diff /var/spool/koha/kohadev/kohadev-schema-2021-01-12.sql
installer/data/mysql/kohastructure.sql | wc -l
1970

Default integer values got quoted in this version of MariaDB
(10.1.48-MariaDB-1~bionic), but wasn't in newer version
(10.3.27-MariaDB-1:10.3.27+maria~focal)

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