Bugzilla – Attachment 99609 Details for
Bug 8628
Add digital signs to the OPAC
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 8628: Digital signs - schema updates
Bug-8628-Digital-signs---schema-updates.patch (text/plain), 8.59 KB, created by
Aleisha Amohia
on 2020-02-25 21:51:43 UTC
(
hide
)
Description:
Bug 8628: Digital signs - schema updates
Filename:
MIME Type:
Creator:
Aleisha Amohia
Created:
2020-02-25 21:51:43 UTC
Size:
8.59 KB
patch
obsolete
>From 728a6bb938941754a597271914d577f2deeae6ec Mon Sep 17 00:00:00 2001 >From: Aleisha Amohia <aleishaamohia@hotmail.com> >Date: Tue, 23 Apr 2019 22:19:42 +0000 >Subject: [PATCH] Bug 8628: Digital signs - schema updates > >Signed-off-by: Lisette Scheer <lisetteslatah@gmail.com> >--- > Koha/Schema/Result/SavedSql.pm | 21 +++++- > Koha/Schema/Result/Sign.pm | 132 ++++++++++++++++++++++++++++++++++++ > Koha/Schema/Result/SignStream.pm | 105 ++++++++++++++++++++++++++++ > Koha/Schema/Result/SignsToStream.pm | 114 +++++++++++++++++++++++++++++++ > 4 files changed, 370 insertions(+), 2 deletions(-) > create mode 100644 Koha/Schema/Result/Sign.pm > create mode 100644 Koha/Schema/Result/SignStream.pm > create mode 100644 Koha/Schema/Result/SignsToStream.pm > >diff --git a/Koha/Schema/Result/SavedSql.pm b/Koha/Schema/Result/SavedSql.pm >index f8567b3..5604846 100644 >--- a/Koha/Schema/Result/SavedSql.pm >+++ b/Koha/Schema/Result/SavedSql.pm >@@ -169,9 +169,26 @@ __PACKAGE__->add_columns( > > __PACKAGE__->set_primary_key("id"); > >+=head1 RELATIONS > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-01-23 12:56:39 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f7wxGGnBk3z6mw2CkaeD9A >+=head2 sign_streams >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::SignStream> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "sign_streams", >+ "Koha::Schema::Result::SignStream", >+ { "foreign.saved_sql_id" => "self.id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2019-04-23 22:14:56 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:49NVnmBe/cLc8xLJ2UFmpw > > sub koha_object_class { > 'Koha::Report'; >diff --git a/Koha/Schema/Result/Sign.pm b/Koha/Schema/Result/Sign.pm >new file mode 100644 >index 0000000..1911844 >--- /dev/null >+++ b/Koha/Schema/Result/Sign.pm >@@ -0,0 +1,132 @@ >+use utf8; >+package Koha::Schema::Result::Sign; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::Sign >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<signs> >+ >+=cut >+ >+__PACKAGE__->table("signs"); >+ >+=head1 ACCESSORS >+ >+=head2 sign_id >+ >+ data_type: 'integer' >+ is_auto_increment: 1 >+ is_nullable: 0 >+ >+=head2 name >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 64 >+ >+=head2 webapp >+ >+ data_type: 'integer' >+ default_value: 0 >+ is_nullable: 0 >+ >+=head2 transition >+ >+ data_type: 'char' >+ default_value: 'none' >+ is_nullable: 0 >+ size: 16 >+ >+=head2 swatch >+ >+ data_type: 'char' >+ default_value: (empty string) >+ is_nullable: 0 >+ size: 1 >+ >+=head2 idleafter >+ >+ data_type: 'integer' >+ default_value: 0 >+ is_nullable: 0 >+ >+=head2 pagedelay >+ >+ data_type: 'integer' >+ default_value: 0 >+ is_nullable: 0 >+ >+=head2 reloadafter >+ >+ data_type: 'integer' >+ default_value: 0 >+ is_nullable: 0 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "sign_id", >+ { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, >+ "name", >+ { data_type => "varchar", is_nullable => 1, size => 64 }, >+ "webapp", >+ { data_type => "integer", default_value => 0, is_nullable => 0 }, >+ "transition", >+ { data_type => "char", default_value => "none", is_nullable => 0, size => 16 }, >+ "swatch", >+ { data_type => "char", default_value => "", is_nullable => 0, size => 1 }, >+ "idleafter", >+ { data_type => "integer", default_value => 0, is_nullable => 0 }, >+ "pagedelay", >+ { data_type => "integer", default_value => 0, is_nullable => 0 }, >+ "reloadafter", >+ { data_type => "integer", default_value => 0, is_nullable => 0 }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</sign_id> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("sign_id"); >+ >+=head1 RELATIONS >+ >+=head2 signs_to_streams >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::SignsToStream> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "signs_to_streams", >+ "Koha::Schema::Result::SignsToStream", >+ { "foreign.sign_id" => "self.sign_id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2019-04-23 22:14:56 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sPXDFstwvROyMN0guYnQiA >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >diff --git a/Koha/Schema/Result/SignStream.pm b/Koha/Schema/Result/SignStream.pm >new file mode 100644 >index 0000000..a0fe0dc >--- /dev/null >+++ b/Koha/Schema/Result/SignStream.pm >@@ -0,0 +1,105 @@ >+use utf8; >+package Koha::Schema::Result::SignStream; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::SignStream >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<sign_streams> >+ >+=cut >+ >+__PACKAGE__->table("sign_streams"); >+ >+=head1 ACCESSORS >+ >+=head2 sign_stream_id >+ >+ data_type: 'integer' >+ is_auto_increment: 1 >+ is_nullable: 0 >+ >+=head2 saved_sql_id >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 0 >+ >+=head2 name >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 64 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "sign_stream_id", >+ { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, >+ "saved_sql_id", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, >+ "name", >+ { data_type => "varchar", is_nullable => 1, size => 64 }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</sign_stream_id> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("sign_stream_id"); >+ >+=head1 RELATIONS >+ >+=head2 saved_sql >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::SavedSql> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "saved_sql", >+ "Koha::Schema::Result::SavedSql", >+ { id => "saved_sql_id" }, >+ { is_deferrable => 1, on_delete => "CASCADE", on_update => "RESTRICT" }, >+); >+ >+=head2 signs_to_streams >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::SignsToStream> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "signs_to_streams", >+ "Koha::Schema::Result::SignsToStream", >+ { "foreign.sign_stream_id" => "self.sign_stream_id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2019-04-23 22:14:56 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:k94lZfT0zHEvDtc4GPWQKQ >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >diff --git a/Koha/Schema/Result/SignsToStream.pm b/Koha/Schema/Result/SignsToStream.pm >new file mode 100644 >index 0000000..88fa2c2 >--- /dev/null >+++ b/Koha/Schema/Result/SignsToStream.pm >@@ -0,0 +1,114 @@ >+use utf8; >+package Koha::Schema::Result::SignsToStream; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::SignsToStream >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<signs_to_streams> >+ >+=cut >+ >+__PACKAGE__->table("signs_to_streams"); >+ >+=head1 ACCESSORS >+ >+=head2 sign_to_stream_id >+ >+ data_type: 'integer' >+ is_auto_increment: 1 >+ is_nullable: 0 >+ >+=head2 sign_stream_id >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 0 >+ >+=head2 sign_id >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 0 >+ >+=head2 params >+ >+ data_type: 'varchar' >+ default_value: (empty string) >+ is_nullable: 0 >+ size: 255 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "sign_to_stream_id", >+ { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, >+ "sign_stream_id", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, >+ "sign_id", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, >+ "params", >+ { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</sign_to_stream_id> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("sign_to_stream_id"); >+ >+=head1 RELATIONS >+ >+=head2 sign >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Sign> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "sign", >+ "Koha::Schema::Result::Sign", >+ { sign_id => "sign_id" }, >+ { is_deferrable => 1, on_delete => "CASCADE", on_update => "RESTRICT" }, >+); >+ >+=head2 sign_stream >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::SignStream> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "sign_stream", >+ "Koha::Schema::Result::SignStream", >+ { sign_stream_id => "sign_stream_id" }, >+ { is_deferrable => 1, on_delete => "CASCADE", on_update => "RESTRICT" }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2019-04-23 22:14:56 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I8v4LIKe5HxaemotFqXI6A >+ >+ >+# 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 8628
:
42703
|
42704
|
45968
|
45969
|
58602
|
58603
|
58604
|
58605
|
62338
|
64249
|
66246
|
66247
|
66248
|
66249
|
66250
|
77025
|
77026
|
77027
|
77028
|
77141
|
77142
|
77143
|
77144
|
77145
|
78709
|
80248
|
80249
|
80250
|
80252
|
82896
|
82897
|
82898
|
82899
|
82900
|
82901
|
83312
|
88821
|
88822
|
88823
|
88824
|
88825
|
88826
|
93054
|
93055
|
93056
|
93057
|
93058
|
93059
|
93066
|
93067
|
93068
|
93069
|
93070
|
93071
|
99608
|
99609
|
99610
|
99611
|
99612
|
99613
|
99614
|
99615
|
99616
|
99617
|
99618
|
99619
|
99620
|
99621
|
99622
|
99623
|
99624
|
99717
|
99718
|
99801
|
118472
|
118473
|
118474
|
118475
|
118476
|
118477
|
118478
|
118479
|
118480
|
119455
|
131223
|
131224
|
145645
|
145646
|
145647
|
145648
|
145649
|
145650
|
145651
|
145652
|
145653
|
145654
|
147000
|
147001
|
147002
|
147003
|
147004
|
147005
|
147006
|
147007
|
147008
|
147009
|
147010