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

(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
Lines 904-909 CREATE TABLE `deleteditems` ( Link Here
904
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
904
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
905
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
905
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
906
  `itemnotes` mediumtext, -- public notes on this item (MARC21 952$x)
906
  `itemnotes` mediumtext, -- public notes on this item (MARC21 952$x)
907
  `itemnotes_nonpublic` mediumtext default NULL,
907
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
908
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
908
  `paidfor` mediumtext,
909
  `paidfor` mediumtext,
909
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
910
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
Lines 1202-1207 CREATE TABLE `items` ( -- holdings/item information Link Here
1202
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
1203
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
1203
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
1204
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
1204
  `itemnotes` mediumtext, -- public notes on this item (MARC21 952$x)
1205
  `itemnotes` mediumtext, -- public notes on this item (MARC21 952$x)
1206
  `nonpublicnote` mediumtext default NULL,
1205
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
1207
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
1206
  `paidfor` mediumtext,
1208
  `paidfor` mediumtext,
1207
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
1209
  `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 / +7 lines)
Lines 8781-8786 if ( CheckVersion($DBversion) ) { Link Here
8781
    SetVersion($DBversion);
8781
    SetVersion($DBversion);
8782
}
8782
}
8783
8783
8784
$DBversion = '3.17.00.XXX';
8785
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
8786
    $dbh->do("ALTER TABLE items ADD COLUMN itemnotes_nonpublic MEDIUMTEXT AFTER itemnotes");
8787
    $dbh->do("ALTER TABLE deleteditems ADD COLUMN itemnotes_nonpublic MEDIUMTEXT AFTER itemnotes");
8788
    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/maintenance/touch_all_items.pl </b>)\n";
8789
}
8790
8784
=head1 FUNCTIONS
8791
=head1 FUNCTIONS
8785
8792
8786
=head2 TableExists($table)
8793
=head2 TableExists($table)
8787
- 

Return to bug 13023