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 1109-1115 CREATE TABLE `biblioitems` ( Link Here
1109
  `notes` longtext DEFAULT NULL,
1109
  `notes` longtext DEFAULT NULL,
1110
  `size` varchar(255) DEFAULT NULL COMMENT 'material size (MARC21 300$c)',
1110
  `size` varchar(255) DEFAULT NULL COMMENT 'material size (MARC21 300$c)',
1111
  `place` varchar(255) DEFAULT NULL COMMENT 'publication place (MARC21 260$a)',
1111
  `place` varchar(255) DEFAULT NULL COMMENT 'publication place (MARC21 260$a)',
1112
  `lccn` varchar(25) DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)',
1112
  `lccn` longtext DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)',
1113
  `url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)',
1113
  `url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)',
1114
  `cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)',
1114
  `cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)',
1115
  `cn_class` varchar(30) DEFAULT NULL,
1115
  `cn_class` varchar(30) DEFAULT NULL,
Lines 2508-2514 CREATE TABLE `deletedbiblioitems` ( Link Here
2508
  `notes` longtext DEFAULT NULL,
2508
  `notes` longtext DEFAULT NULL,
2509
  `size` varchar(255) DEFAULT NULL COMMENT 'material size (MARC21 300$c)',
2509
  `size` varchar(255) DEFAULT NULL COMMENT 'material size (MARC21 300$c)',
2510
  `place` varchar(255) DEFAULT NULL COMMENT 'publication place (MARC21 260$a)',
2510
  `place` varchar(255) DEFAULT NULL COMMENT 'publication place (MARC21 260$a)',
2511
  `lccn` varchar(25) DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)',
2511
  `lccn` longtext DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)',
2512
  `url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)',
2512
  `url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)',
2513
  `cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)',
2513
  `cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)',
2514
  `cn_class` varchar(30) DEFAULT NULL,
2514
  `cn_class` varchar(30) DEFAULT NULL,
2515
- 

Return to bug 28328