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

(-)a/installer/data/mysql/atomicupdate/bug_28328.pl (+19 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "28328",
5
    description => "Extend biblioitems.lccn",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        # Do you stuffs here
10
        $dbh->do(q{
11
            ALTER TABLE `biblioitems`
12
            MODIFY COLUMN `lccn` longtext DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)'
13
        });
14
        $dbh->do(q{
15
            ALTER TABLE `deletedbiblioitems`
16
            MODIFY COLUMN `lccn` longtext DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)'
17
        });
18
    },
19
};
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 1132-1138 CREATE TABLE `biblioitems` ( Link Here
1132
  `notes` longtext DEFAULT NULL,
1132
  `notes` longtext DEFAULT NULL,
1133
  `size` varchar(255) DEFAULT NULL COMMENT 'material size (MARC21 300$c)',
1133
  `size` varchar(255) DEFAULT NULL COMMENT 'material size (MARC21 300$c)',
1134
  `place` varchar(255) DEFAULT NULL COMMENT 'publication place (MARC21 260$a)',
1134
  `place` varchar(255) DEFAULT NULL COMMENT 'publication place (MARC21 260$a)',
1135
  `lccn` varchar(25) DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)',
1135
  `lccn` longtext DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)',
1136
  `url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)',
1136
  `url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)',
1137
  `cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)',
1137
  `cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)',
1138
  `cn_class` varchar(30) DEFAULT NULL,
1138
  `cn_class` varchar(30) DEFAULT NULL,
Lines 2531-2537 CREATE TABLE `deletedbiblioitems` ( Link Here
2531
  `notes` longtext DEFAULT NULL,
2531
  `notes` longtext DEFAULT NULL,
2532
  `size` varchar(255) DEFAULT NULL COMMENT 'material size (MARC21 300$c)',
2532
  `size` varchar(255) DEFAULT NULL COMMENT 'material size (MARC21 300$c)',
2533
  `place` varchar(255) DEFAULT NULL COMMENT 'publication place (MARC21 260$a)',
2533
  `place` varchar(255) DEFAULT NULL COMMENT 'publication place (MARC21 260$a)',
2534
  `lccn` varchar(25) DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)',
2534
  `lccn` longtext DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)',
2535
  `url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)',
2535
  `url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)',
2536
  `cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)',
2536
  `cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)',
2537
  `cn_class` varchar(30) DEFAULT NULL,
2537
  `cn_class` varchar(30) DEFAULT NULL,
2538
- 

Return to bug 28328