From dcb1212c26fc7443c00a247cef8b6432bc744e78 Mon Sep 17 00:00:00 2001 From: Emmi Takkinen Date: Fri, 24 Nov 2023 14:14:41 +0200 Subject: [PATCH 1/2] DO NOT PUSH! Schema changes --- Koha/Schema/Result/Deleteditem.pm | 92 +++---------------------------- Koha/Schema/Result/Item.pm | 92 +++---------------------------- 2 files changed, 14 insertions(+), 170 deletions(-) diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm index a681163b1e..d255bd7f11 100644 --- a/Koha/Schema/Result/Deleteditem.pm +++ b/Koha/Schema/Result/Deleteditem.pm @@ -29,32 +29,24 @@ __PACKAGE__->table("deleteditems"); default_value: 0 is_nullable: 0 -primary key and unique identifier added by Koha - =head2 biblionumber data_type: 'integer' default_value: 0 is_nullable: 0 -foreign key from biblio table used to link this item to the right bib record - =head2 biblioitemnumber data_type: 'integer' default_value: 0 is_nullable: 0 -foreign key from the biblioitems table to link to item to additional information - =head2 barcode data_type: 'varchar' is_nullable: 1 size: 20 -item barcode (MARC21 952$p) - =head2 bookable data_type: 'tinyint' @@ -69,63 +61,47 @@ boolean value defining whether this item is available for bookings or not datetime_undef_if_invalid: 1 is_nullable: 1 -date the item was acquired or added to Koha (MARC21 952$d) - =head2 booksellerid data_type: 'longtext' is_nullable: 1 -where the item was purchased (MARC21 952$e) - =head2 homebranch data_type: 'varchar' is_nullable: 1 size: 10 -foreign key from the branches table for the library that owns this item (MARC21 952$a) - =head2 price data_type: 'decimal' is_nullable: 1 size: [8,2] -purchase price (MARC21 952$g) - =head2 replacementprice data_type: 'decimal' is_nullable: 1 size: [8,2] -cost the library charges to replace the item if it has been marked lost (MARC21 952$v) - =head2 replacementpricedate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 -the date the price is effective from (MARC21 952$w) - =head2 datelastborrowed data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 -the date the item was last checked out - =head2 datelastseen data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 -the date the item was last see (usually the last time the barcode was scanned or inventory was done) - =head2 stack data_type: 'tinyint' @@ -137,80 +113,60 @@ the date the item was last see (usually the last time the barcode was scanned or default_value: 0 is_nullable: 0 -authorized value defining why this item is not for loan (MARC21 952$7) - =head2 damaged data_type: 'tinyint' default_value: 0 is_nullable: 0 -authorized value defining this item as damaged (MARC21 952$4) - =head2 damaged_on data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 -the date and time an item was last marked as damaged, NULL if not damaged - =head2 itemlost data_type: 'tinyint' default_value: 0 is_nullable: 0 -authorized value defining this item as lost (MARC21 952$1) - =head2 itemlost_on data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 -the date and time an item was last marked as lost, NULL if not lost - =head2 withdrawn data_type: 'tinyint' default_value: 0 is_nullable: 0 -authorized value defining this item as withdrawn (MARC21 952$0) - =head2 withdrawn_on data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 -the date and time an item was last marked as withdrawn, NULL if not withdrawn - =head2 itemcallnumber data_type: 'varchar' is_nullable: 1 size: 255 -call number for this item (MARC21 952$o) - =head2 coded_location_qualifier data_type: 'varchar' is_nullable: 1 size: 10 -coded location qualifier(MARC21 952$f) - =head2 issues data_type: 'smallint' default_value: 0 is_nullable: 1 -number of times this item has been checked out - =head2 renewals data_type: 'smallint' @@ -230,37 +186,27 @@ number of times this item has been recorded as localuse data_type: 'smallint' is_nullable: 1 -number of times this item has been placed on hold/reserved - =head2 restricted data_type: 'tinyint' is_nullable: 1 -authorized value defining use restrictions for this item (MARC21 952$5) - =head2 itemnotes data_type: 'longtext' is_nullable: 1 -public notes on this item (MARC21 952$z) - =head2 itemnotes_nonpublic data_type: 'longtext' is_nullable: 1 -non-public notes on this item (MARC21 952$x) - =head2 holdingbranch data_type: 'varchar' is_nullable: 1 size: 10 -foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) - =head2 timestamp data_type: 'timestamp' @@ -268,8 +214,6 @@ foreign key from the branches table for the library that is currently in possess default_value: current_timestamp is_nullable: 0 -date and time this item was last altered - =head2 deleted_on data_type: 'datetime' @@ -284,15 +228,17 @@ date/time of deletion is_nullable: 1 size: 80 -authorized value for the shelving location for this item (MARC21 952$c) - =head2 permanent_location data_type: 'varchar' is_nullable: 1 size: 80 -linked to the CART and PROC temporary locations feature, stores the permanent shelving location +=head2 sub_location + + data_type: 'varchar' + is_nullable: 1 + size: 80 =head2 onloan @@ -300,99 +246,73 @@ linked to the CART and PROC temporary locations feature, stores the permanent sh datetime_undef_if_invalid: 1 is_nullable: 1 -defines if item is checked out (NULL for not checked out, and due date for checked out) - =head2 cn_source data_type: 'varchar' is_nullable: 1 size: 10 -classification source used on this item (MARC21 952$2) - =head2 cn_sort data_type: 'varchar' is_nullable: 1 size: 255 -normalized form of the call number (MARC21 952$o) used for sorting - =head2 ccode data_type: 'varchar' is_nullable: 1 size: 80 -authorized value for the collection code associated with this item (MARC21 952$8) - =head2 materials data_type: 'mediumtext' is_nullable: 1 -materials specified (MARC21 952$3) - =head2 uri data_type: 'mediumtext' is_nullable: 1 -URL for the item (MARC21 952$u) - =head2 itype data_type: 'varchar' is_nullable: 1 size: 10 -foreign key from the itemtypes table defining the type for this item (MARC21 952$y) - =head2 more_subfields_xml data_type: 'longtext' is_nullable: 1 -additional 952 subfields in XML format - =head2 enumchron data_type: 'mediumtext' is_nullable: 1 -serial enumeration/chronology for the item (MARC21 952$h) - =head2 copynumber data_type: 'varchar' is_nullable: 1 size: 32 -copy number (MARC21 952$t) - =head2 stocknumber data_type: 'varchar' is_nullable: 1 size: 32 -inventory number (MARC21 952$i) - =head2 new_status data_type: 'varchar' is_nullable: 1 size: 32 -'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. - =head2 exclude_from_local_holds_priority data_type: 'tinyint' is_nullable: 1 -Exclude this item from local holds priority - =cut __PACKAGE__->add_columns( @@ -491,6 +411,8 @@ __PACKAGE__->add_columns( { data_type => "varchar", is_nullable => 1, size => 80 }, "permanent_location", { data_type => "varchar", is_nullable => 1, size => 80 }, + "sub_location", + { data_type => "varchar", is_nullable => 1, size => 80 }, "onloan", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "cn_source", diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm index 92fe4d1088..d2a43cf969 100644 --- a/Koha/Schema/Result/Item.pm +++ b/Koha/Schema/Result/Item.pm @@ -29,8 +29,6 @@ __PACKAGE__->table("items"); is_auto_increment: 1 is_nullable: 0 -primary key and unique identifier added by Koha - =head2 biblionumber data_type: 'integer' @@ -38,8 +36,6 @@ primary key and unique identifier added by Koha is_foreign_key: 1 is_nullable: 0 -foreign key from biblio table used to link this item to the right bib record - =head2 biblioitemnumber data_type: 'integer' @@ -47,16 +43,12 @@ foreign key from biblio table used to link this item to the right bib record is_foreign_key: 1 is_nullable: 0 -foreign key from the biblioitems table to link to item to additional information - =head2 barcode data_type: 'varchar' is_nullable: 1 size: 20 -item barcode (MARC21 952$p) - =head2 bookable data_type: 'tinyint' @@ -71,15 +63,11 @@ boolean value defining whether this item is available for bookings or not datetime_undef_if_invalid: 1 is_nullable: 1 -date the item was acquired or added to Koha (MARC21 952$d) - =head2 booksellerid data_type: 'longtext' is_nullable: 1 -where the item was purchased (MARC21 952$e) - =head2 homebranch data_type: 'varchar' @@ -87,48 +75,36 @@ where the item was purchased (MARC21 952$e) is_nullable: 1 size: 10 -foreign key from the branches table for the library that owns this item (MARC21 952$a) - =head2 price data_type: 'decimal' is_nullable: 1 size: [8,2] -purchase price (MARC21 952$g) - =head2 replacementprice data_type: 'decimal' is_nullable: 1 size: [8,2] -cost the library charges to replace the item if it has been marked lost (MARC21 952$v) - =head2 replacementpricedate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 -the date the price is effective from (MARC21 952$w) - =head2 datelastborrowed data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 -the date the item was last checked out/issued - =head2 datelastseen data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 -the date the item was last see (usually the last time the barcode was scanned or inventory was done) - =head2 stack data_type: 'tinyint' @@ -140,80 +116,60 @@ the date the item was last see (usually the last time the barcode was scanned or default_value: 0 is_nullable: 0 -authorized value defining why this item is not for loan (MARC21 952$7) - =head2 damaged data_type: 'tinyint' default_value: 0 is_nullable: 0 -authorized value defining this item as damaged (MARC21 952$4) - =head2 damaged_on data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 -the date and time an item was last marked as damaged, NULL if not damaged - =head2 itemlost data_type: 'tinyint' default_value: 0 is_nullable: 0 -authorized value defining this item as lost (MARC21 952$1) - =head2 itemlost_on data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 -the date and time an item was last marked as lost, NULL if not lost - =head2 withdrawn data_type: 'tinyint' default_value: 0 is_nullable: 0 -authorized value defining this item as withdrawn (MARC21 952$0) - =head2 withdrawn_on data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 -the date and time an item was last marked as withdrawn, NULL if not withdrawn - =head2 itemcallnumber data_type: 'varchar' is_nullable: 1 size: 255 -call number for this item (MARC21 952$o) - =head2 coded_location_qualifier data_type: 'varchar' is_nullable: 1 size: 10 -coded location qualifier(MARC21 952$f) - =head2 issues data_type: 'smallint' default_value: 0 is_nullable: 1 -number of times this item has been checked out/issued - =head2 renewals data_type: 'smallint' @@ -233,29 +189,21 @@ number of times this item has been recorded as localuse data_type: 'smallint' is_nullable: 1 -number of times this item has been placed on hold/reserved - =head2 restricted data_type: 'tinyint' is_nullable: 1 -authorized value defining use restrictions for this item (MARC21 952$5) - =head2 itemnotes data_type: 'longtext' is_nullable: 1 -public notes on this item (MARC21 952$z) - =head2 itemnotes_nonpublic data_type: 'longtext' is_nullable: 1 -non-public notes on this item (MARC21 952$x) - =head2 holdingbranch data_type: 'varchar' @@ -263,8 +211,6 @@ non-public notes on this item (MARC21 952$x) is_nullable: 1 size: 10 -foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) - =head2 timestamp data_type: 'timestamp' @@ -272,8 +218,6 @@ foreign key from the branches table for the library that is currently in possess default_value: current_timestamp is_nullable: 0 -date and time this item was last altered - =head2 deleted_on data_type: 'datetime' @@ -288,15 +232,17 @@ date/time of deletion is_nullable: 1 size: 80 -authorized value for the shelving location for this item (MARC21 952$c) - =head2 permanent_location data_type: 'varchar' is_nullable: 1 size: 80 -linked to the CART and PROC temporary locations feature, stores the permanent shelving location +=head2 sub_location + + data_type: 'varchar' + is_nullable: 1 + size: 80 =head2 onloan @@ -304,99 +250,73 @@ linked to the CART and PROC temporary locations feature, stores the permanent sh datetime_undef_if_invalid: 1 is_nullable: 1 -defines if item is checked out (NULL for not checked out, and due date for checked out) - =head2 cn_source data_type: 'varchar' is_nullable: 1 size: 10 -classification source used on this item (MARC21 952$2) - =head2 cn_sort data_type: 'varchar' is_nullable: 1 size: 255 -normalized form of the call number (MARC21 952$o) used for sorting - =head2 ccode data_type: 'varchar' is_nullable: 1 size: 80 -authorized value for the collection code associated with this item (MARC21 952$8) - =head2 materials data_type: 'mediumtext' is_nullable: 1 -materials specified (MARC21 952$3) - =head2 uri data_type: 'mediumtext' is_nullable: 1 -URL for the item (MARC21 952$u) - =head2 itype data_type: 'varchar' is_nullable: 1 size: 10 -foreign key from the itemtypes table defining the type for this item (MARC21 952$y) - =head2 more_subfields_xml data_type: 'longtext' is_nullable: 1 -additional 952 subfields in XML format - =head2 enumchron data_type: 'mediumtext' is_nullable: 1 -serial enumeration/chronology for the item (MARC21 952$h) - =head2 copynumber data_type: 'varchar' is_nullable: 1 size: 32 -copy number (MARC21 952$t) - =head2 stocknumber data_type: 'varchar' is_nullable: 1 size: 32 -inventory number (MARC21 952$i) - =head2 new_status data_type: 'varchar' is_nullable: 1 size: 32 -'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. - =head2 exclude_from_local_holds_priority data_type: 'tinyint' is_nullable: 1 -Exclude this item from local holds priority - =cut __PACKAGE__->add_columns( @@ -505,6 +425,8 @@ __PACKAGE__->add_columns( { data_type => "varchar", is_nullable => 1, size => 80 }, "permanent_location", { data_type => "varchar", is_nullable => 1, size => 80 }, + "sub_location", + { data_type => "varchar", is_nullable => 1, size => 80 }, "onloan", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "cn_source", -- 2.34.1