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

(-)a/installer/data/mysql/atomicupdate/bug_38457.pl (+14 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => "38457",
5
    description => "Add additional fields to debit types",
6
    up          => sub {
7
        my ($args) = @_;
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
10
        $dbh->do(q{ ALTER TABLE additional_field_values MODIFY record_id VARCHAR(80) NOT NULL DEFAULT ''; });
11
12
        say $out "Converted record_id to VARCHAR(80)";
13
    },
14
};
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 247-253 DROP TABLE IF EXISTS `additional_field_values`; Link Here
247
CREATE TABLE `additional_field_values` (
247
CREATE TABLE `additional_field_values` (
248
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier',
248
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier',
249
  `field_id` int(11) NOT NULL COMMENT 'foreign key references additional_fields(id)',
249
  `field_id` int(11) NOT NULL COMMENT 'foreign key references additional_fields(id)',
250
  `record_id` varchar(11) NOT NULL COMMENT 'record_id',
250
  `record_id` varchar(80) NOT NULL COMMENT 'record_id',
251
  `value` varchar(255) NOT NULL DEFAULT '' COMMENT 'value for this field',
251
  `value` varchar(255) NOT NULL DEFAULT '' COMMENT 'value for this field',
252
  PRIMARY KEY (`id`),
252
  PRIMARY KEY (`id`),
253
  KEY `afv_fk` (`field_id`),
253
  KEY `afv_fk` (`field_id`),
254
- 

Return to bug 38457