From 34e6c5037936bda1242e658093ff097e8be4ae5b Mon Sep 17 00:00:00 2001 From: Magnus Enger Date: Wed, 17 Sep 2014 10:15:34 +0200 Subject: [PATCH] Bug 11401 - Changes to Koha::Schema --- Koha/Schema/Result/Borrower.pm | 16 ++++- Koha/Schema/Result/BorrowerSync.pm | 122 +++++++++++++++++++++++++++++++++++++ 2 files changed, 137 insertions(+), 1 deletion(-) create mode 100644 Koha/Schema/Result/BorrowerSync.pm diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm index 48102dd..ef2db68 100644 --- a/Koha/Schema/Result/Borrower.pm +++ b/Koha/Schema/Result/Borrower.pm @@ -726,6 +726,21 @@ __PACKAGE__->has_many( { cascade_copy => 0, cascade_delete => 0 }, ); +=head2 borrower_syncs + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "borrower_syncs", + "Koha::Schema::Result::BorrowerSync", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + =head2 branchcode Type: belongs_to @@ -1105,6 +1120,5 @@ __PACKAGE__->many_to_many("courses", "course_instructors", "course"); # Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZzZiKYN4b/LuEARX4rawhA - # You can replace this text with custom content, and it will be preserved on regeneration 1; diff --git a/Koha/Schema/Result/BorrowerSync.pm b/Koha/Schema/Result/BorrowerSync.pm new file mode 100644 index 0000000..d03587c --- /dev/null +++ b/Koha/Schema/Result/BorrowerSync.pm @@ -0,0 +1,122 @@ +use utf8; +package Koha::Schema::Result::BorrowerSync; + +# Created by DBIx::Class::Schema::Loader +# DO NOT MODIFY THE FIRST PART OF THIS FILE + +=head1 NAME + +Koha::Schema::Result::BorrowerSync + +=cut + +use strict; +use warnings; + +use base 'DBIx::Class::Core'; + +=head1 TABLE: C + +=cut + +__PACKAGE__->table("borrower_sync"); + +=head1 ACCESSORS + +=head2 borrowersyncid + + data_type: 'integer' + is_auto_increment: 1 + is_nullable: 0 + +=head2 borrowernumber + + data_type: 'integer' + is_foreign_key: 1 + is_nullable: 0 + +=head2 synctype + + data_type: 'varchar' + is_nullable: 0 + size: 32 + +=head2 sync + + data_type: 'tinyint' + default_value: 0 + is_nullable: 0 + +=head2 syncstatus + + data_type: 'varchar' + is_nullable: 1 + size: 10 + +=head2 lastsync + + data_type: 'varchar' + is_nullable: 1 + size: 50 + +=head2 hashed_pin + + data_type: 'varchar' + is_nullable: 1 + size: 64 + +=cut + +__PACKAGE__->add_columns( + "borrowersyncid", + { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, + "borrowernumber", + { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, + "synctype", + { data_type => "varchar", is_nullable => 0, size => 32 }, + "sync", + { data_type => "tinyint", default_value => 0, is_nullable => 0 }, + "syncstatus", + { data_type => "varchar", is_nullable => 1, size => 10 }, + "lastsync", + { data_type => "varchar", is_nullable => 1, size => 50 }, + "hashed_pin", + { data_type => "varchar", is_nullable => 1, size => 64 }, +); + +=head1 PRIMARY KEY + +=over 4 + +=item * L + +=back + +=cut + +__PACKAGE__->set_primary_key("borrowersyncid"); + +=head1 RELATIONS + +=head2 borrowernumber + +Type: belongs_to + +Related object: L + +=cut + +__PACKAGE__->belongs_to( + "borrowernumber", + "Koha::Schema::Result::Borrower", + { borrowernumber => "borrowernumber" }, + { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-06-04 14:43:23 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7kXC+RmwDYY6S/uVpIfiJg + + +# You can replace this text with custom code or comments, and it will be preserved on regeneration +1; -- 1.9.1