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

(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
Lines 912-917 CREATE TABLE `deleteditems` ( Link Here
912
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
912
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
913
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
913
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
914
  `itemnotes` mediumtext, -- public notes on this item (MARC21 952$x)
914
  `itemnotes` mediumtext, -- public notes on this item (MARC21 952$x)
915
  `itemnotes_nonpublic` mediumtext default NULL,
915
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
916
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
916
  `paidfor` mediumtext,
917
  `paidfor` mediumtext,
917
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
918
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
Lines 1211-1216 CREATE TABLE `items` ( -- holdings/item information Link Here
1211
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
1212
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
1212
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
1213
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
1213
  `itemnotes` mediumtext, -- public notes on this item (MARC21 952$x)
1214
  `itemnotes` mediumtext, -- public notes on this item (MARC21 952$x)
1215
  `itemnotes_nonpublic` mediumtext default NULL,
1214
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
1216
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
1215
  `paidfor` mediumtext,
1217
  `paidfor` mediumtext,
1216
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
1218
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 9480-9485 if (CheckVersion($DBversion)) { Link Here
9480
    SetVersion($DBversion);
9480
    SetVersion($DBversion);
9481
}
9481
}
9482
9482
9483
$DBversion = '3.17.00.XXX';
9484
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
9485
    $dbh->do("ALTER TABLE items ADD COLUMN itemnotes_nonpublic MEDIUMTEXT AFTER itemnotes");
9486
    $dbh->do("ALTER TABLE deleteditems ADD COLUMN itemnotes_nonpublic MEDIUMTEXT AFTER itemnotes");
9487
    print "Upgrade to $DBversion done (Bug 4222 - Nonpublic note not appearing in the staff client) <b>Please check each of your frameworks to ensure your non-public item notes are mapped to items.itemnotes_nonpublic. After doing so please have your administrator run misc/batchRebuildItemsTables.pl </b>)\n";
9488
    SetVersion($DBversion);
9489
}
9490
9483
=head1 FUNCTIONS
9491
=head1 FUNCTIONS
9484
9492
9485
=head2 TableExists($table)
9493
=head2 TableExists($table)
9486
- 

Return to bug 13023