@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_20447-add_holdings_tables.perl | 2 +- installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) --- a/installer/data/mysql/atomicupdate/bug_20447-add_holdings_tables.perl +++ a/installer/data/mysql/atomicupdate/bug_20447-add_holdings_tables.perl @@ -10,7 +10,7 @@ if( CheckVersion( $DBversion ) ) { `location` varchar(80) default NULL, -- authorized value for the shelving location for this record (MARC21 852$b) `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 852$g) `callnumber` varchar(255) default NULL, -- call number (852$h+$i in MARC21) - `suppress` tinyint(1) default NULL, -- Boolean indicating whether the record is suppressed in OPAC + `suppress` tinyint(1) NOT NULL DEFAULT 0, -- Boolean indicating whether the record is suppressed in OPAC `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched `datecreated` DATE NOT NULL, -- the date this record was added to Koha `deleted_on` DATETIME DEFAULT NULL, -- the date this record was deleted --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -2649,7 +2649,7 @@ CREATE TABLE `holdings` ( `location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this record (MARC21 852$b)', `ccode` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the collection code associated with this item (MARC21 852$g)', `callnumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'call number (852$h+$i in MARC21)', - `suppress` tinyint(1) DEFAULT NULL COMMENT 'Boolean indicating whether the record is suppressed in OPAC', + `suppress` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Boolean indicating whether the record is suppressed in OPAC', `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this record was last touched', `datecreated` date NOT NULL COMMENT 'the date this record was added to Koha', `deleted_on` datetime DEFAULT NULL COMMENT 'the date this record was deleted', --