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

(-)a/installer/data/mysql/db_revs/241200018.pl (-1 / +2 lines)
Lines 18-24 return { Link Here
18
            say_info( $out, "Converting record_id from int(11) to VARCHAR(11)...\n" );
18
            say_info( $out, "Converting record_id from int(11) to VARCHAR(11)...\n" );
19
19
20
            $dbh->do(
20
            $dbh->do(
21
                q{ ALTER TABLE additional_field_values ADD COLUMN new_record_id VARCHAR(11) NOT NULL DEFAULT ''; });
21
                q{ ALTER TABLE additional_field_values ADD COLUMN new_record_id VARCHAR(11) NOT NULL DEFAULT '' COMMENT "record_id" AFTER field_id; }
22
            );
22
            $dbh->do(q{ UPDATE additional_field_values SET new_record_id = CAST(record_id AS CHAR(11)); });
23
            $dbh->do(q{ UPDATE additional_field_values SET new_record_id = CAST(record_id AS CHAR(11)); });
23
            $dbh->do(q{ ALTER TABLE additional_field_values DROP COLUMN record_id; });
24
            $dbh->do(q{ ALTER TABLE additional_field_values DROP COLUMN record_id; });
24
            $dbh->do(q{ ALTER TABLE additional_field_values RENAME COLUMN new_record_id TO record_id; });
25
            $dbh->do(q{ ALTER TABLE additional_field_values RENAME COLUMN new_record_id TO record_id; });
(-)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(11) NOT NULL DEFAULT '' 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 38663