Bugzilla – Attachment 63500 Details for
Bug 17705
Payments with cards through payment terminal
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 17705: Database schema objects updated
Bug-17705-Database-schema-objects-updated.patch (text/plain), 3.82 KB, created by
Radek Šiman (R-Bit Technology, s.r.o.)
on 2017-05-17 14:04:55 UTC
(
hide
)
Description:
Bug 17705: Database schema objects updated
Filename:
MIME Type:
Creator:
Radek Šiman (R-Bit Technology, s.r.o.)
Created:
2017-05-17 14:04:55 UTC
Size:
3.82 KB
patch
obsolete
>From 520a19e12181b31220a8b55169fedd118e384561 Mon Sep 17 00:00:00 2001 >From: =?UTF-8?q?Radek=20=C5=A0iman?= <rbit@rbit.cz> >Date: Wed, 17 May 2017 15:28:26 +0200 >Subject: [PATCH] Bug 17705: Database schema objects updated > >Brings neccessary changes in the database schema. > >Test plan: >1) Apply the patch >2) Open Koha/Schema/Result >3) Observe new relation in Accountline.pm >4) Check presence of PosTerminalTransaction.pm >--- > Koha/Schema/Result/Accountline.pm | 19 ++++- > Koha/Schema/Result/PosTerminalTransaction.pm | 111 +++++++++++++++++++++++++++ > 2 files changed, 128 insertions(+), 2 deletions(-) > create mode 100644 Koha/Schema/Result/PosTerminalTransaction.pm > >diff --git a/Koha/Schema/Result/Accountline.pm b/Koha/Schema/Result/Accountline.pm >index d3fa5b3..1747467 100644 >--- a/Koha/Schema/Result/Accountline.pm >+++ b/Koha/Schema/Result/Accountline.pm >@@ -220,9 +220,24 @@ __PACKAGE__->belongs_to( > }, > ); > >+=head2 pos_terminal_transactions > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-01-26 17:18:34 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RCQohhphtg+0+RszpB4wLg >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::PosTerminalTransaction> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "pos_terminal_transactions", >+ "Koha::Schema::Result::PosTerminalTransaction", >+ { "foreign.accountlines_id" => "self.accountlines_id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-02-24 05:19:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OcykebNXzfbeJ3cwHzmUXA > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/PosTerminalTransaction.pm b/Koha/Schema/Result/PosTerminalTransaction.pm >new file mode 100644 >index 0000000..2ceb0f1 >--- /dev/null >+++ b/Koha/Schema/Result/PosTerminalTransaction.pm >@@ -0,0 +1,111 @@ >+use utf8; >+package Koha::Schema::Result::PosTerminalTransaction; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::PosTerminalTransaction >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<pos_terminal_transactions> >+ >+=cut >+ >+__PACKAGE__->table("pos_terminal_transactions"); >+ >+=head1 ACCESSORS >+ >+=head2 id >+ >+ data_type: 'integer' >+ is_auto_increment: 1 >+ is_nullable: 0 >+ >+=head2 accountlines_id >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 0 >+ >+=head2 status >+ >+ data_type: 'varchar' >+ default_value: 'new' >+ is_nullable: 0 >+ size: 32 >+ >+=head2 response_code >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 5 >+ >+=head2 message_log >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "id", >+ { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, >+ "accountlines_id", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, >+ "status", >+ { >+ data_type => "varchar", >+ default_value => "new", >+ is_nullable => 0, >+ size => 32, >+ }, >+ "response_code", >+ { data_type => "varchar", is_nullable => 1, size => 5 }, >+ "message_log", >+ { data_type => "text", is_nullable => 1 }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</id> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("id"); >+ >+=head1 RELATIONS >+ >+=head2 accountline >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Accountline> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "accountline", >+ "Koha::Schema::Result::Accountline", >+ { accountlines_id => "accountlines_id" }, >+ { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-03-22 17:13:47 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9kf34Odpc7Yd46+Lu2pyJg >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >-- >2.1.4
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 17705
:
63499
|
63500
|
64526
|
64527
|
64528
|
64529
|
64613
|
76366
|
76367
|
76368