View | Details | Raw Unified | Return to bug 35625
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_35625.pl (+17 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => "35625",
5
    description => "Add is_system field to additional_fields table",
6
    up          => sub {
7
        my ($args) = @_;
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
10
        unless ( column_exists( 'additional_fields', 'is_system' ) ) {
11
            $dbh->do(
12
                "ALTER TABLE `additional_fields` ADD COLUMN `is_system` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is this field required for system operation' AFTER `tablename`"
13
            );
14
            say $out "Added column 'additional_fields.is_system'";
15
        }
16
    },
17
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 259-264 DROP TABLE IF EXISTS `additional_fields`; Link Here
259
CREATE TABLE `additional_fields` (
259
CREATE TABLE `additional_fields` (
260
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier',
260
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier',
261
  `tablename` varchar(255) NOT NULL DEFAULT '' COMMENT 'tablename of the new field',
261
  `tablename` varchar(255) NOT NULL DEFAULT '' COMMENT 'tablename of the new field',
262
  `is_system` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is this field required for system operation',
262
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'name of the field',
263
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'name of the field',
263
  `authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'is an authorised value category',
264
  `authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'is an authorised value category',
264
  `marcfield` varchar(16) NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record',
265
  `marcfield` varchar(16) NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record',
265
- 

Return to bug 35625