Bug 23805: DBRev 19.06.00.044

[koha-ffzg.git] / Koha / Schema / Result / Accountline.pm

diff --git a/Koha/Schema/Result/Accountline.pm b/Koha/Schema/Result/Accountline.pm
index 4ca754d..1d455e6 100644 (file)
--- a/Koha/Schema/Result/Accountline.pm
+++ b/Koha/Schema/Result/Accountline.pm
@@ -37,15 +37,8 @@ __PACKAGE__->table("accountlines");
 =head2 borrowernumber
 
   data_type: 'integer'
-  default_value: 0
   is_foreign_key: 1
-  is_nullable: 0
-
-=head2 accountno
-
-  data_type: 'smallint'
-  default_value: 0
-  is_nullable: 0
+  is_nullable: 1
 
 =head2 itemnumber
 
@@ -70,24 +63,33 @@ __PACKAGE__->table("accountlines");
   data_type: 'longtext'
   is_nullable: 1
 
-=head2 dispute
+=head2 credit_type_code
 
-  data_type: 'longtext'
+  data_type: 'varchar'
+  is_foreign_key: 1
   is_nullable: 1
+  size: 80
 
-=head2 accounttype
+=head2 debit_type_code
 
   data_type: 'varchar'
+  is_foreign_key: 1
   is_nullable: 1
-  size: 5
+  size: 80
 
-=head2 amountoutstanding
+=head2 status
 
-  data_type: 'decimal'
+  data_type: 'varchar'
   is_nullable: 1
-  size: [28,6]
+  size: 16
 
-=head2 lastincrement
+=head2 payment_type
+
+  data_type: 'varchar'
+  is_nullable: 1
+  size: 80
+
+=head2 amountoutstanding
 
   data_type: 'decimal'
   is_nullable: 1
@@ -108,7 +110,27 @@ __PACKAGE__->table("accountlines");
 =head2 manager_id
 
   data_type: 'integer'
+  is_foreign_key: 1
+  is_nullable: 1
+
+=head2 register_id
+
+  data_type: 'integer'
+  is_foreign_key: 1
+  is_nullable: 1
+
+=head2 interface
+
+  data_type: 'varchar'
+  is_nullable: 0
+  size: 16
+
+=head2 branchcode
+
+  data_type: 'varchar'
+  is_foreign_key: 1
   is_nullable: 1
+  size: 10
 
 =cut
 
@@ -118,14 +140,7 @@ __PACKAGE__->add_columns(
   "issue_id",
   { data_type => "integer", is_nullable => 1 },
   "borrowernumber",
-  {
-    data_type      => "integer",
-    default_value  => 0,
-    is_foreign_key => 1,
-    is_nullable    => 0,
-  },
-  "accountno",
-  { data_type => "smallint", default_value => 0, is_nullable => 0 },
+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
   "itemnumber",
   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
   "date",
@@ -134,14 +149,16 @@ __PACKAGE__->add_columns(
   { data_type => "decimal", is_nullable => 1, size => [28, 6] },
   "description",
   { data_type => "longtext", is_nullable => 1 },
-  "dispute",
-  { data_type => "longtext", is_nullable => 1 },
-  "accounttype",
-  { data_type => "varchar", is_nullable => 1, size => 5 },
+  "credit_type_code",
+  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 80 },
+  "debit_type_code",
+  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 80 },
+  "status",
+  { data_type => "varchar", is_nullable => 1, size => 16 },
+  "payment_type",
+  { data_type => "varchar", is_nullable => 1, size => 80 },
   "amountoutstanding",
   { data_type => "decimal", is_nullable => 1, size => [28, 6] },
-  "lastincrement",
-  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
   "timestamp",
   {
     data_type => "timestamp",
@@ -152,7 +169,13 @@ __PACKAGE__->add_columns(
   "note",
   { data_type => "mediumtext", is_nullable => 1 },
   "manager_id",
-  { data_type => "integer", is_nullable => 1 },
+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
+  "register_id",
+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
+  "interface",
+  { data_type => "varchar", is_nullable => 0, size => 16 },
+  "branchcode",
+  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
 );
 
 =head1 PRIMARY KEY
@@ -211,7 +234,72 @@ __PACKAGE__->belongs_to(
   "borrowernumber",
   "Koha::Schema::Result::Borrower",
   { borrowernumber => "borrowernumber" },
-  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+  {
+    is_deferrable => 1,
+    join_type     => "LEFT",
+    on_delete     => "SET NULL",
+    on_update     => "CASCADE",
+  },
+);
+
+=head2 branchcode
+
+Type: belongs_to
+
+Related object: L<Koha::Schema::Result::Branch>
+
+=cut
+
+__PACKAGE__->belongs_to(
+  "branchcode",
+  "Koha::Schema::Result::Branch",
+  { branchcode => "branchcode" },
+  {
+    is_deferrable => 1,
+    join_type     => "LEFT",
+    on_delete     => "SET NULL",
+    on_update     => "CASCADE",
+  },
+);
+
+=head2 credit_type_code
+
+Type: belongs_to
+
+Related object: L<Koha::Schema::Result::AccountCreditType>
+
+=cut
+
+__PACKAGE__->belongs_to(
+  "credit_type_code",
+  "Koha::Schema::Result::AccountCreditType",
+  { code => "credit_type_code" },
+  {
+    is_deferrable => 1,
+    join_type     => "LEFT",
+    on_delete     => "RESTRICT",
+    on_update     => "CASCADE",
+  },
+);
+
+=head2 debit_type_code
+
+Type: belongs_to
+
+Related object: L<Koha::Schema::Result::AccountDebitType>
+
+=cut
+
+__PACKAGE__->belongs_to(
+  "debit_type_code",
+  "Koha::Schema::Result::AccountDebitType",
+  { code => "debit_type_code" },
+  {
+    is_deferrable => 1,
+    join_type     => "LEFT",
+    on_delete     => "RESTRICT",
+    on_update     => "CASCADE",
+  },
 );
 
 =head2 itemnumber
@@ -230,14 +318,59 @@ __PACKAGE__->belongs_to(
     is_deferrable => 1,
     join_type     => "LEFT",
     on_delete     => "SET NULL",
-    on_update     => "SET NULL",
+    on_update     => "CASCADE",
+  },
+);
+
+=head2 manager
+
+Type: belongs_to
+
+Related object: L<Koha::Schema::Result::Borrower>
+
+=cut
+
+__PACKAGE__->belongs_to(
+  "manager",
+  "Koha::Schema::Result::Borrower",
+  { borrowernumber => "manager_id" },
+  {
+    is_deferrable => 1,
+    join_type     => "LEFT",
+    on_delete     => "SET NULL",
+    on_update     => "CASCADE",
+  },
+);
+
+=head2 register
+
+Type: belongs_to
+
+Related object: L<Koha::Schema::Result::CashRegister>
+
+=cut
+
+__PACKAGE__->belongs_to(
+  "register",
+  "Koha::Schema::Result::CashRegister",
+  { id => "register_id" },
+  {
+    is_deferrable => 1,
+    join_type     => "LEFT",
+    on_delete     => "SET NULL",
+    on_update     => "CASCADE",
   },
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Nqx+Byr+p91Kbsuncau0Ng
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-24 16:33:42
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:q4Ahb8xIxAsjT/aF9yjrdQ
 
+sub koha_objects_class {
+    'Koha::Account::Lines';
+}
+sub koha_object_class {
+    'Koha::Account::Line';
+}
 
-# You can replace this text with custom content, and it will be preserved on regeneration
 1;