Bugzilla – Attachment 48053 Details for
Bug 9021
Add SMS via email as an alternative to SMS services via SMS::Send drivers
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 9021: Schema update
Bug-9021-Schema-update.patch (text/plain), 4.55 KB, created by
Jonathan Druart
on 2016-02-15 16:29:21 UTC
(
hide
)
Description:
Bug 9021: Schema update
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2016-02-15 16:29:21 UTC
Size:
4.55 KB
patch
obsolete
>From 84e9819d6fd978bcf78ecb625122c4673f8983bf Mon Sep 17 00:00:00 2001 >From: Mark Tompsett <mtompset@hotmail.com> >Date: Thu, 31 Dec 2015 16:49:31 -0500 >Subject: [PATCH] Bug 9021: Schema update > >This ensures that the DBIx structure matches the SQL structure changes. >See comment #48 as to how this was generated. >Also, I had to modify misc/devel/update_dbix_class_files.pl >to have an "overwrite_modifications => 1" option to get it to generate. >This should correct issues raised in comment #45. > >Signed-off-by: Mark Tompsett <mtompset@hotmail.com> > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> > >Signed-off-by: Mark Tompsett <mtompset@hotmail.com> > >Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >--- > Koha/Schema/Result/Borrower.pm | 32 +++++++++++- > Koha/Schema/Result/SmsProvider.pm | 104 ++++++++++++++++++++++++++++++++++++++ > 2 files changed, 134 insertions(+), 2 deletions(-) > create mode 100644 Koha/Schema/Result/SmsProvider.pm > >diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm >index 97f65d0..4094b44 100644 >--- a/Koha/Schema/Result/Borrower.pm >+++ b/Koha/Schema/Result/Borrower.pm >@@ -389,6 +389,12 @@ __PACKAGE__->table("borrowers"); > is_nullable: 1 > size: 50 > >+=head2 sms_provider_id >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ > =head2 privacy > > data_type: 'integer' >@@ -564,6 +570,8 @@ __PACKAGE__->add_columns( > { data_type => "varchar", is_nullable => 1, size => 50 }, > "smsalertnumber", > { data_type => "varchar", is_nullable => 1, size => 50 }, >+ "sms_provider_id", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, > "privacy", > { data_type => "integer", default_value => 1, is_nullable => 0 }, > "privacy_guarantor_checkouts", >@@ -1030,6 +1038,26 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 sms_provider >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::SmsProvider> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "sms_provider", >+ "Koha::Schema::Result::SmsProvider", >+ { id => "sms_provider_id" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "RESTRICT", >+ on_update => "RESTRICT", >+ }, >+); >+ > =head2 subscriptionroutinglists > > Type: has_many >@@ -1176,8 +1204,8 @@ Composing rels: L</aqorder_users> -> ordernumber > __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-01-06 11:59:52 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0nIBbkzhb+Yfp6qpSLo51A >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-12-31 16:48:38 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dd1tdtsFTruFwsmCZU6ogQ > > __PACKAGE__->belongs_to( > "guarantor", >diff --git a/Koha/Schema/Result/SmsProvider.pm b/Koha/Schema/Result/SmsProvider.pm >new file mode 100644 >index 0000000..f9015ea >--- /dev/null >+++ b/Koha/Schema/Result/SmsProvider.pm >@@ -0,0 +1,104 @@ >+use utf8; >+package Koha::Schema::Result::SmsProvider; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::SmsProvider >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<sms_providers> >+ >+=cut >+ >+__PACKAGE__->table("sms_providers"); >+ >+=head1 ACCESSORS >+ >+=head2 id >+ >+ data_type: 'integer' >+ is_auto_increment: 1 >+ is_nullable: 0 >+ >+=head2 name >+ >+ data_type: 'varchar' >+ is_nullable: 0 >+ size: 255 >+ >+=head2 domain >+ >+ data_type: 'varchar' >+ is_nullable: 0 >+ size: 255 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "id", >+ { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, >+ "name", >+ { data_type => "varchar", is_nullable => 0, size => 255 }, >+ "domain", >+ { data_type => "varchar", is_nullable => 0, size => 255 }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</id> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("id"); >+ >+=head1 UNIQUE CONSTRAINTS >+ >+=head2 C<name> >+ >+=over 4 >+ >+=item * L</name> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->add_unique_constraint("name", ["name"]); >+ >+=head1 RELATIONS >+ >+=head2 borrowers >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Borrower> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "borrowers", >+ "Koha::Schema::Result::Borrower", >+ { "foreign.sms_provider_id" => "self.id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-12-31 16:48:38 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:U3LGi1zy3YN2Amin+bhXlA >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >-- >2.7.0
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 9021
:
13290
|
13291
|
13293
|
13294
|
14166
|
14167
|
14363
|
15685
|
15687
|
15689
|
15691
|
16628
|
17311
|
21729
|
22478
|
28488
|
29927
|
32453
|
34180
|
34181
|
35816
|
40720
|
44331
|
45152
|
46163
|
46164
|
46165
|
46168
|
46169
|
46170
|
46171
|
47128
|
47129
|
47130
|
47133
|
47134
|
47135
|
47338
|
47339
|
47814
|
47815
|
47816
|
47817
|
47818
|
47845
|
47846
|
47847
|
47848
|
47995
|
48024
|
48025
|
48026
|
48027
|
48028
|
48029
|
48030
|
48031
|
48032
|
48033
|
48034
|
48035
|
48036
|
48052
| 48053 |
48054
|
48055
|
48056
|
48057
|
48058
|
48059
|
48060
|
48061
|
48062
|
48063
|
48064
|
48065
|
48066