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

(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
Lines 930-935 CREATE TABLE `deleteditems` ( Link Here
930
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
930
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
931
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
931
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
932
  `itemnotes` mediumtext, -- public notes on this item (MARC21 952$x)
932
  `itemnotes` mediumtext, -- public notes on this item (MARC21 952$x)
933
  `itemnotes_nonpublic` mediumtext default NULL,
933
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
934
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
934
  `paidfor` mediumtext,
935
  `paidfor` mediumtext,
935
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
936
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
Lines 1229-1234 CREATE TABLE `items` ( -- holdings/item information Link Here
1229
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
1230
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
1230
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
1231
  `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)
1231
  `itemnotes` mediumtext, -- public notes on this item (MARC21 952$x)
1232
  `itemnotes` mediumtext, -- public notes on this item (MARC21 952$x)
1233
  `itemnotes_nonpublic` mediumtext default NULL,
1232
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
1234
  `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
1233
  `paidfor` mediumtext,
1235
  `paidfor` mediumtext,
1234
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
1236
  `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 9585-9590 if ( CheckVersion($DBversion) ) { Link Here
9585
    SetVersion ($DBversion);
9585
    SetVersion ($DBversion);
9586
}
9586
}
9587
9587
9588
$DBversion = '3.19.00.XXX';
9589
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
9590
    $dbh->do("ALTER TABLE items ADD COLUMN itemnotes_nonpublic MEDIUMTEXT AFTER itemnotes");
9591
    $dbh->do("ALTER TABLE deleteditems ADD COLUMN itemnotes_nonpublic MEDIUMTEXT AFTER itemnotes");
9592
    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";
9593
    SetVersion($DBversion);
9594
}
9595
9588
=head1 FUNCTIONS
9596
=head1 FUNCTIONS
9589
9597
9590
=head2 TableExists($table)
9598
=head2 TableExists($table)
9591
- 

Return to bug 13023