From adf01566d5738531f35a3341ec400c803dca5a7a Mon Sep 17 00:00:00 2001 From: Andrew Nugged Date: Sun, 24 Jan 2021 12:51:50 +0200 Subject: [PATCH] Bug 20447: (Follow-up) Regenerate DBIX schema to match with latest DB state --- Koha/Schema/Result/Biblio.pm | 4 ++-- Koha/Schema/Result/Branch.pm | 4 ++-- Koha/Schema/Result/Deleteditem.pm | 6 ++++-- Koha/Schema/Result/Holding.pm | 26 ++++++++++++++++++++++++-- Koha/Schema/Result/HoldingsMetadata.pm | 6 ++++-- Koha/Schema/Result/Item.pm | 6 ++++-- 6 files changed, 40 insertions(+), 12 deletions(-) diff --git a/Koha/Schema/Result/Biblio.pm b/Koha/Schema/Result/Biblio.pm index e1cedfce3e..8e6a33b465 100644 --- a/Koha/Schema/Result/Biblio.pm +++ b/Koha/Schema/Result/Biblio.pm @@ -496,8 +496,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nmmsZusHYNAMimE9sImSNg +# Created by DBIx::Class::Schema::Loader v0.07048 @ 2021-01-24 12:34:57 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:v242VpRrw7sl6v8cfqn1uQ __PACKAGE__->has_one( diff --git a/Koha/Schema/Result/Branch.pm b/Koha/Schema/Result/Branch.pm index ef767c6182..7131437969 100644 --- a/Koha/Schema/Result/Branch.pm +++ b/Koha/Schema/Result/Branch.pm @@ -902,8 +902,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Uu8m3hyDhM50oTSeNTJbdg +# Created by DBIx::Class::Schema::Loader v0.07048 @ 2021-01-24 12:34:57 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BpKZR7xoWZ4dMocH6lKC3w __PACKAGE__->add_columns( '+pickup_location' => { is_boolean => 1 } diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm index 91d26f147e..04fef557d9 100644 --- a/Koha/Schema/Result/Deleteditem.pm +++ b/Koha/Schema/Result/Deleteditem.pm @@ -375,6 +375,8 @@ Exclude this item from local holds priority data_type: 'integer' is_nullable: 1 +foreign key from holdings table used to link this item to the right holdings record + =cut __PACKAGE__->add_columns( @@ -502,8 +504,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("itemnumber"); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ytND0t16cwo9dseU+JZSGQ +# Created by DBIx::Class::Schema::Loader v0.07048 @ 2021-01-24 12:34:57 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HDZPRz/I5vlIgkw/c44QcA __PACKAGE__->add_columns( '+exclude_from_local_holds_priority' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Holding.pm b/Koha/Schema/Result/Holding.pm index 0b2ae736a3..9254b6c81b 100644 --- a/Koha/Schema/Result/Holding.pm +++ b/Koha/Schema/Result/Holding.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("holdings"); is_auto_increment: 1 is_nullable: 0 +unique identifier assigned to each holdings record + =head2 biblionumber data_type: 'integer' @@ -36,6 +38,8 @@ __PACKAGE__->table("holdings"); is_foreign_key: 1 is_nullable: 0 +foreign key from biblio table used to link this record to the right bib record + =head2 frameworkcode data_type: 'varchar' @@ -43,6 +47,8 @@ __PACKAGE__->table("holdings"); is_nullable: 0 size: 4 +foreign key from the biblio_framework table to identify which framework was used in cataloging this record + =head2 holdingbranch data_type: 'varchar' @@ -50,29 +56,39 @@ __PACKAGE__->table("holdings"); is_nullable: 1 size: 10 +foreign key from the branches table for the library that owns this record (MARC21 852$a) + =head2 location data_type: 'varchar' is_nullable: 1 size: 80 +authorized value for the shelving location for this record (MARC21 852$b) + =head2 ccode data_type: 'varchar' is_nullable: 1 size: 80 +authorized value for the collection code associated with this item (MARC21 852$g) + =head2 callnumber data_type: 'varchar' is_nullable: 1 size: 255 +call number (852$h+$i in MARC21) + =head2 suppress data_type: 'tinyint' is_nullable: 1 +Boolean indicating whether the record is suppressed in OPAC + =head2 timestamp data_type: 'timestamp' @@ -80,18 +96,24 @@ __PACKAGE__->table("holdings"); default_value: current_timestamp is_nullable: 0 +date and time this record was last touched + =head2 datecreated data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 0 +the date this record was added to Koha + =head2 deleted_on data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +the date this record was deleted + =cut __PACKAGE__->add_columns( @@ -213,8 +235,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-05-15 12:37:06 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:r5dS7lMIAG11s3PYFp/NKQ +# Created by DBIx::Class::Schema::Loader v0.07048 @ 2021-01-24 12:34:57 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cb9mVGJ6TJ+GqAuqMaNEQQ =head2 metadata diff --git a/Koha/Schema/Result/HoldingsMetadata.pm b/Koha/Schema/Result/HoldingsMetadata.pm index 42d7f886e5..07446bbfdc 100644 --- a/Koha/Schema/Result/HoldingsMetadata.pm +++ b/Koha/Schema/Result/HoldingsMetadata.pm @@ -58,6 +58,8 @@ __PACKAGE__->table("holdings_metadata"); datetime_undef_if_invalid: 1 is_nullable: 1 +the date this record was deleted + =cut __PACKAGE__->add_columns( @@ -130,8 +132,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2019-02-20 16:55:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:42bY17ncjs1OZKH23z4SgQ +# Created by DBIx::Class::Schema::Loader v0.07048 @ 2021-01-24 12:34:57 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:msXxqOTn5rKZf188+KFk8g # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm index 68257b0aea..dbd3d0501d 100644 --- a/Koha/Schema/Result/Item.pm +++ b/Koha/Schema/Result/Item.pm @@ -380,6 +380,8 @@ Exclude this item from local holds priority is_foreign_key: 1 is_nullable: 1 +foreign key from holdings table used to link this item to the right holdings record + =cut __PACKAGE__->add_columns( @@ -878,8 +880,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:U5Tm2JfUnfhACRDJ4SpFgQ +# Created by DBIx::Class::Schema::Loader v0.07048 @ 2021-01-24 12:34:57 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OPCRh54tzKseh6b2dHhB2g __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" ); -- 2.30.0