@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_35625.pl | 17 +++++++++++++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 18 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_35625.pl --- a/installer/data/mysql/atomicupdate/bug_35625.pl +++ a/installer/data/mysql/atomicupdate/bug_35625.pl @@ -0,0 +1,17 @@ +use Modern::Perl; + +return { + bug_number => "35625", + description => "Add is_system field to additional_fields table", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + unless ( column_exists( 'additional_fields', 'is_system' ) ) { + $dbh->do( + "ALTER TABLE `additional_fields` ADD COLUMN `is_system` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is this field required for system operation' AFTER `tablename`" + ); + say $out "Added column 'additional_fields.is_system'"; + } + }, +}; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -259,6 +259,7 @@ DROP TABLE IF EXISTS `additional_fields`; CREATE TABLE `additional_fields` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', `tablename` varchar(255) NOT NULL DEFAULT '' COMMENT 'tablename of the new field', + `is_system` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is this field required for system operation', `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'name of the field', `authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'is an authorised value category', `marcfield` varchar(16) NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record', --