From d7e1c93f423905e3c5a621217a3719c34a31e2a0 Mon Sep 17 00:00:00 2001 From: Emmi Takkinen Date: Fri, 24 Nov 2023 14:14:41 +0200 Subject: [PATCH 2/2] DO NOT PUSH! Schema changes https://bugs.koha-community.org/show_bug.cgi?id=34142 --- Koha/Schema/Result/Deleteditem.pm | 98 +++---------------------------- Koha/Schema/Result/Item.pm | 98 +++---------------------------- 2 files changed, 18 insertions(+), 178 deletions(-) diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm index a30646271c..8992edad6b 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 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,123 +113,91 @@ 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' is_nullable: 1 -number of times this item has been renewed - =head2 reserves 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' @@ -261,8 +205,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' @@ -277,15 +219,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 @@ -293,99 +237,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( @@ -482,6 +400,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", @@ -523,8 +443,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("itemnumber"); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-10-02 11:06:29 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Afgr1jl6aeSy/rS9RJGq2g +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-24 14:12:38 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VQ+9kNL/sX6fAbtY9NW8ZQ __PACKAGE__->add_columns( '+bookable' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm index cc428b0a83..6b5219a572 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 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,115 +116,85 @@ 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' is_nullable: 1 -number of times this item has been renewed - =head2 reserves 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' @@ -256,8 +202,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' @@ -265,8 +209,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' @@ -281,15 +223,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 @@ -297,99 +241,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( @@ -496,6 +414,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", @@ -983,8 +903,8 @@ __PACKAGE__->might_have( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-03 14:18:06 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0jargxEw3HZOK57+ijsMHA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-24 14:12:38 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:X1201tjCWPb5wFpL/fir6A __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" ); -- 2.34.1