Bugzilla – Attachment 157300 Details for
Bug 34142
Add column sub_location to items table
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 34142: DO NOT PUSH! Schema changes
0002-Bug-34142-DO-NOT-PUSH-Schema-changes.patch (text/plain), 16.12 KB, created by
Emmi Takkinen
on 2023-10-18 06:32:40 UTC
(
hide
)
Description:
Bug 34142: DO NOT PUSH! Schema changes
Filename:
MIME Type:
Creator:
Emmi Takkinen
Created:
2023-10-18 06:32:40 UTC
Size:
16.12 KB
patch
obsolete
>From e2924898a62dc2f395059e656d493534cda54516 Mon Sep 17 00:00:00 2001 >From: Emmi Takkinen <emmi.takkinen@koha-suomi.fi> >Date: Tue, 17 Oct 2023 14:49:52 +0300 >Subject: [PATCH 2/2] Bug 34142: DO NOT PUSH! Schema changes > >--- > 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 7047142ba3..243b020a12 100644 >--- a/Koha/Schema/Result/Deleteditem.pm >+++ b/Koha/Schema/Result/Deleteditem.pm >@@ -29,95 +29,71 @@ __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 dateaccessioned > > data_type: 'date' > 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' >@@ -129,123 +105,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' >@@ -253,8 +197,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' >@@ -269,15 +211,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: 10 > > =head2 onloan > >@@ -285,99 +229,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( >@@ -472,6 +390,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 => 10 }, > "onloan", > { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, > "cn_source", >@@ -513,8 +433,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("itemnumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-05-12 18:18:47 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6TcVaUWoDdAGfBOr83ZOWQ >+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-10-17 14:37:52 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HU9jxoKR5UQnUr8OQ9Uppg > > __PACKAGE__->add_columns( > '+exclude_from_local_holds_priority' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm >index 3778fba936..40034e2340 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,31 +43,23 @@ 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 dateaccessioned > > data_type: 'date' > 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' >@@ -79,48 +67,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' >@@ -132,115 +108,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' >@@ -248,8 +194,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' >@@ -257,8 +201,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' >@@ -273,15 +215,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: 10 > > =head2 onloan > >@@ -289,99 +233,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( >@@ -486,6 +404,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 => 10 }, > "onloan", > { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, > "cn_source", >@@ -943,8 +863,8 @@ __PACKAGE__->might_have( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-07-26 17:44:52 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FHB+BvL4it4HrzlfNCxoKw >+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-10-17 14:44:11 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hDg9F34X/pDlWz0K6L447g > > __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" ); > >-- >2.34.1 >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 34142
:
157299
|
157300
|
159236
|
159237
|
164875
|
164876
|
164877
|
167714
|
172103
|
172104
|
179906
|
179907
|
180087
|
180088