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

(-)a/installer/data/mysql/kohastructure.sql (+31 lines)
Lines 3214-3219 CREATE TABLE IF NOT EXISTS plugin_data ( Link Here
3214
  PRIMARY KEY (plugin_class,plugin_key)
3214
  PRIMARY KEY (plugin_class,plugin_key)
3215
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3215
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3216
3216
3217
--
3218
-- Table structure for table addition_fields
3219
-- This table add the ability to add new fields for a record
3220
--
3221
3222
CREATE TABLE `additional_fields` (
3223
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3224
  `tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field
3225
  `name` varchar(255) NOT NULL DEFAULT '', -- name of the field
3226
  `authorised_value_category` varchar(16) NOT NULL DEFAULT '', -- is an authorised value category
3227
  `marcfield` varchar(16) NOT NULL DEFAULT '', -- contains the marc field to copied into the record
3228
  `searchable` tinyint(1) NOT NULL DEFAULT '0', -- is the field searchable?
3229
  PRIMARY KEY (`id`),
3230
  UNIQUE KEY `fields_uniq` (`tablename`,`name`)
3231
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
3232
3233
--
3234
-- Table structure for table addition_field_values
3235
-- This table store values for additional fields
3236
--
3237
3238
CREATE TABLE `additional_field_values` (
3239
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3240
  `field_id` int(11) NOT NULL, -- foreign key references addition_fields(id)
3241
  `record_id` int(11) NOT NULL, -- record_id
3242
  `value` varchar(255) NOT NULL DEFAULT '', -- value for this field
3243
  PRIMARY KEY (`id`),
3244
  UNIQUE KEY `field_record` (`field_id`,`record_id`),
3245
  CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
3246
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
3247
3217
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3248
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3218
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3249
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3219
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3250
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +38 lines)
Lines 7104-7109 if ( CheckVersion($DBversion) ) { Link Here
7104
    SetVersion($DBversion);
7104
    SetVersion($DBversion);
7105
}
7105
}
7106
7106
7107
7108
7109
7110
7111
7112
7113
$DBversion = "3.13.00.XXX";
7114
if ( CheckVersion($DBversion) ) {
7115
    $dbh->do(q|
7116
        CREATE TABLE `additional_fields` (
7117
          `id` int(11) NOT NULL AUTO_INCREMENT,
7118
          `tablename` varchar(255) NOT NULL DEFAULT '',
7119
          `name` varchar(255) NOT NULL DEFAULT '',
7120
          `authorised_value_category` varchar(16) NOT NULL DEFAULT '',
7121
          `marcfield` varchar(16) NOT NULL DEFAULT '',
7122
          `searchable` tinyint(1) NOT NULL DEFAULT '0',
7123
          PRIMARY KEY (`id`),
7124
          UNIQUE KEY `fields_uniq` (`tablename`,`name`)
7125
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
7126
    |);
7127
    $dbh->do(q|
7128
        CREATE TABLE `additional_field_values` (
7129
          `id` int(11) NOT NULL AUTO_INCREMENT,
7130
          `field_id` int(11) NOT NULL,
7131
          `record_id` int(11) NOT NULL,
7132
          `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
7133
          PRIMARY KEY (`id`),
7134
          UNIQUE KEY `field_record` (`field_id`,`record_id`),
7135
          CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
7136
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
7137
    |);
7138
    print "Upgrade to $DBversion done (MT 11449: Add tables additional_fields and additional_field_values)\n";
7139
    SetVersion($DBversion);
7140
}
7141
7142
7143
7144
7107
=head1 FUNCTIONS
7145
=head1 FUNCTIONS
7108
7146
7109
=head2 TableExists($table)
7147
=head2 TableExists($table)
7110
- 

Return to bug 10855