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

(-)a/C4/Items.pm (-1 / +4 lines)
Lines 439-445 my %default_values_for_mod_from_marc = ( Link Here
439
    barcode              => undef, 
439
    barcode              => undef, 
440
    booksellerid         => undef, 
440
    booksellerid         => undef, 
441
    ccode                => undef, 
441
    ccode                => undef, 
442
    'items.cn_source'    => undef, 
442
    'items.cn_source'     => undef, 
443
    coded_location_qualifier => undef,
443
    copynumber           => undef, 
444
    copynumber           => undef, 
444
    damaged              => 0,
445
    damaged              => 0,
445
#    dateaccessioned      => undef,
446
#    dateaccessioned      => undef,
Lines 2076-2081 sub _koha_new_item { Link Here
2076
            itemlost            = ?,
2077
            itemlost            = ?,
2077
            wthdrawn            = ?,
2078
            wthdrawn            = ?,
2078
            itemcallnumber      = ?,
2079
            itemcallnumber      = ?,
2080
            coded_location_qualifier = ?,
2079
            restricted          = ?,
2081
            restricted          = ?,
2080
            itemnotes           = ?,
2082
            itemnotes           = ?,
2081
            holdingbranch       = ?,
2083
            holdingbranch       = ?,
Lines 2117-2122 sub _koha_new_item { Link Here
2117
            $item->{'itemlost'},
2119
            $item->{'itemlost'},
2118
            $item->{'wthdrawn'},
2120
            $item->{'wthdrawn'},
2119
            $item->{'itemcallnumber'},
2121
            $item->{'itemcallnumber'},
2122
            $item->{'coded_location_qualifier'},
2120
            $item->{'restricted'},
2123
            $item->{'restricted'},
2121
            $item->{'itemnotes'},
2124
            $item->{'itemnotes'},
2122
            $item->{'holdingbranch'},
2125
            $item->{'holdingbranch'},
(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 1047-1052 CREATE TABLE `items` ( -- holdings/item information Link Here
1047
  `itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1)
1047
  `itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1)
1048
  `wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0)
1048
  `wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0)
1049
  `itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)
1049
  `itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)
1050
  `coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f)
1050
  `issues` smallint(6) default NULL, -- number of times this item has been checked out/issued
1051
  `issues` smallint(6) default NULL, -- number of times this item has been checked out/issued
1051
  `renewals` smallint(6) default NULL, -- number of times this item has been renewed
1052
  `renewals` smallint(6) default NULL, -- number of times this item has been renewed
1052
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
1053
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 6019-6024 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
6019
   SetVersion ($DBversion);
6019
   SetVersion ($DBversion);
6020
}
6020
}
6021
6021
6022
$DBversion = "3.09.00.XXX";
6023
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
6024
   $dbh->do('ALTER TABLE items ADD coded_location_qualifier varchar(10) default NULL');
6025
   print "Upgrade to $DBversion done (Bug 6428: Added coded_location_qualifier to the items table)\n";
6026
   SetVersion ($DBversion);
6027
}
6028
6029
6022
=head1 FUNCTIONS
6030
=head1 FUNCTIONS
6023
6031
6024
=head2 TableExists($table)
6032
=head2 TableExists($table)
6025
- 

Return to bug 6428