Bugzilla – Attachment 108677 Details for
Bug 24857
Add ability to group items for records
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 24857: Update existing Schema files [DO NOT PUSH]
Bug-24857-Update-existing-Schema-files-DO-NOT-PUSH.patch (text/plain), 4.72 KB, created by
Kyle M Hall
on 2020-08-19 17:35:55 UTC
(
hide
)
Description:
Bug 24857: Update existing Schema files [DO NOT PUSH]
Filename:
MIME Type:
Creator:
Kyle M Hall
Created:
2020-08-19 17:35:55 UTC
Size:
4.72 KB
patch
obsolete
>From 7803f68665bbacc547fe4a319eab26f1d3e7d09f Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Fri, 15 May 2020 13:46:05 -0400 >Subject: [PATCH] Bug 24857: Update existing Schema files [DO NOT PUSH] > >Signed-off-by: Rebecca Coert <rcoert@arlingtonva.us> >--- > Koha/Schema/Result/Biblio.pm | 19 +++++++++++++++++-- > Koha/Schema/Result/Item.pm | 19 +++++++++++++++++-- > Koha/Schema/Result/Volume.pm | 18 ++++++++++++------ > Koha/Schema/Result/VolumeItem.pm | 20 ++++++++++++++++++-- > 4 files changed, 64 insertions(+), 12 deletions(-) > >diff --git a/Koha/Schema/Result/Biblio.pm b/Koha/Schema/Result/Biblio.pm >index 806faf87ad..9007f3115b 100644 >--- a/Koha/Schema/Result/Biblio.pm >+++ b/Koha/Schema/Result/Biblio.pm >@@ -450,9 +450,24 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 volumes > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-17 09:15:51 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:p2SIq565zPyE3ZUkSuXyBA >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Volume> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "volumes", >+ "Koha::Schema::Result::Volume", >+ { "foreign.biblionumber" => "self.biblionumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-05-15 17:43:21 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AQnP0926C/nCaNuMRT7BLQ > > > __PACKAGE__->has_one( >diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm >index cb77d96ee0..dfdb0bd2f4 100644 >--- a/Koha/Schema/Result/Item.pm >+++ b/Koha/Schema/Result/Item.pm >@@ -746,9 +746,24 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 volume_items > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-27 10:38:13 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IpI7wRweeZCbCeU1LhZbRQ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::VolumeItem> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "volume_items", >+ "Koha::Schema::Result::VolumeItem", >+ { "foreign.itemnumber" => "self.itemnumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-05-15 17:43:21 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Tbm1Md4p51ZGJjmQ3mn/Jw > > __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" ); > >diff --git a/Koha/Schema/Result/Volume.pm b/Koha/Schema/Result/Volume.pm >index 30388d165d..d7a4a35824 100644 >--- a/Koha/Schema/Result/Volume.pm >+++ b/Koha/Schema/Result/Volume.pm >@@ -36,6 +36,12 @@ __PACKAGE__->table("volumes"); > is_foreign_key: 1 > is_nullable: 0 > >+=head2 display_order >+ >+ data_type: 'integer' >+ default_value: 0 >+ is_nullable: 0 >+ > =head2 description > > data_type: 'mediumtext' >@@ -45,8 +51,7 @@ __PACKAGE__->table("volumes"); > > data_type: 'timestamp' > datetime_undef_if_invalid: 1 >- default_value: '0000-00-00 00:00:00' >- is_nullable: 0 >+ is_nullable: 1 > > =head2 updated_on > >@@ -67,14 +72,15 @@ __PACKAGE__->add_columns( > is_foreign_key => 1, > is_nullable => 0, > }, >+ "display_order", >+ { data_type => "integer", default_value => 0, is_nullable => 0 }, > "description", > { data_type => "mediumtext", is_nullable => 1 }, > "created_on", > { > data_type => "timestamp", > datetime_undef_if_invalid => 1, >- default_value => "0000-00-00 00:00:00", >- is_nullable => 0, >+ is_nullable => 1, > }, > "updated_on", > { >@@ -130,8 +136,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-04 15:22:18 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cXvLM2TgY18pxE2ZJBMouw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-05-15 17:43:22 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0synkJlBPpaIOLrX2KUKiA > > sub koha_objects_class { > 'Koha::Biblio::Volumes'; >diff --git a/Koha/Schema/Result/VolumeItem.pm b/Koha/Schema/Result/VolumeItem.pm >index 3ce549209b..835532daf0 100644 >--- a/Koha/Schema/Result/VolumeItem.pm >+++ b/Koha/Schema/Result/VolumeItem.pm >@@ -76,6 +76,22 @@ __PACKAGE__->add_columns( > > __PACKAGE__->set_primary_key("id"); > >+=head1 UNIQUE CONSTRAINTS >+ >+=head2 C<volume_id> >+ >+=over 4 >+ >+=item * L</volume_id> >+ >+=item * L</itemnumber> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->add_unique_constraint("volume_id", ["volume_id", "itemnumber"]); >+ > =head1 RELATIONS > > =head2 itemnumber >@@ -109,8 +125,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-03 18:25:20 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:i6YHB4Jq+79kVVYmuurzIQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-05-15 17:43:22 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jocpH15LNMhDBp6EbZJNsg > > sub koha_object_class { > 'Koha::Biblio::Volume::Item'; >-- >2.24.1 (Apple Git-126)
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 24857
:
100652
|
100653
|
100654
|
100655
|
100656
|
100657
|
100658
|
100659
|
100660
|
100661
|
100662
|
101637
|
101638
|
101639
|
101640
|
101641
|
101642
|
101643
|
101644
|
101645
|
101646
|
101647
|
101648
|
101650
|
101651
|
101652
|
101653
|
101654
|
101655
|
101656
|
101657
|
101658
|
101659
|
101660
|
101661
|
101670
|
101671
|
101672
|
101673
|
101674
|
101675
|
101676
|
101677
|
101678
|
101679
|
101680
|
101681
|
101730
|
101731
|
101732
|
101733
|
101734
|
101735
|
101736
|
101737
|
101738
|
101739
|
101740
|
101741
|
101752
|
101753
|
101754
|
101755
|
101756
|
101757
|
101758
|
101759
|
101760
|
101761
|
101762
|
101763
|
104952
|
104953
|
104954
|
104955
|
104956
|
104957
|
104958
|
104959
|
104960
|
104961
|
104962
|
104963
|
104964
|
104966
|
106728
|
106729
|
106730
|
106731
|
106732
|
106733
|
106734
|
106735
|
106736
|
106737
|
106738
|
106739
|
106740
|
106741
|
108443
|
108444
|
108445
|
108446
|
108447
|
108448
|
108449
|
108450
|
108451
|
108452
|
108453
|
108454
|
108455
|
108456
|
108666
|
108667
|
108668
|
108669
|
108670
|
108671
|
108672
|
108673
|
108674
|
108675
|
108676
|
108677
|
108678
|
108679
|
108680
|
108681
|
108682
|
108683
|
108684
|
108685
|
108686
|
109074
|
109075
|
109076
|
109077
|
109078
|
109079
|
109080
|
109081
|
109082
|
109083
|
109084
|
109085
|
109086
|
109087
|
109088
|
109089
|
109090
|
109091
|
109092
|
109093
|
109094
|
109795
|
109796
|
109797
|
109798
|
109799
|
109800
|
109801
|
109802
|
109803
|
109804
|
109805
|
109806
|
109807
|
109808
|
109809
|
109810
|
109811
|
109812
|
109813
|
109814
|
109815
|
109894
|
109901
|
109902
|
109903
|
109904
|
109905
|
109906
|
109907
|
109908
|
109909
|
109910
|
109911
|
109912
|
109913
|
109914
|
109915
|
109916
|
109917
|
109918
|
109919
|
109920
|
109921
|
109922
|
109923
|
113136
|
113137
|
113138
|
113139
|
113140
|
113141
|
113142
|
113143
|
113144
|
113145
|
113146
|
113147
|
113148
|
113149
|
113150
|
113151
|
113152
|
113153
|
113154
|
113155
|
113156
|
113157
|
113158
|
113159
|
113160
|
113168
|
113169
|
113170
|
113171
|
113172
|
113173
|
113174
|
113175
|
113176
|
113177
|
113178
|
113179
|
113180
|
113181
|
113182
|
113183
|
113184
|
113185
|
113186
|
113187
|
113188
|
113189
|
113190
|
113191
|
120495
|
120496
|
120497
|
120498
|
120499
|
120500
|
120501
|
120502
|
120503
|
120504
|
120505
|
120506
|
120507
|
120508
|
120509
|
120510
|
120511
|
120512
|
120513
|
120514
|
120515
|
120516
|
120517
|
120518
|
122808
|
122809
|
122810
|
122811
|
122812
|
122813
|
122814
|
122815
|
122816
|
122817
|
122818
|
122819
|
122820
|
122821
|
122822
|
122823
|
122824
|
122825
|
122826
|
122827
|
122828
|
122829
|
122830
|
122831
|
123882
|
123883
|
123884
|
123885
|
123886
|
123887
|
123888
|
123889
|
123890
|
123891
|
123892
|
123893
|
123894
|
123895
|
123896
|
123897
|
123898
|
123899
|
123900
|
123901
|
123902
|
123903
|
123904
|
123905
|
123906
|
123907
|
123908
|
123909
|
123910
|
123912
|
124021
|
124022
|
124023
|
124024
|
124025
|
124026
|
124027
|
124028
|
124029
|
124030
|
124031
|
124032
|
124033
|
124034
|
124035
|
124036
|
124037
|
124038
|
124039
|
124040
|
124041
|
124042
|
124043
|
124044
|
124045
|
124046
|
124047
|
124048
|
124049
|
124050
|
124051
|
124052
|
124053
|
124331
|
124332
|
124333
|
124334
|
124335
|
124336
|
124337
|
124338
|
124339
|
124340
|
124341
|
124342
|
124343
|
124344
|
124345
|
124346
|
124347
|
124348
|
124349
|
124351
|
124352
|
124353
|
124354
|
124355
|
124356
|
124357
|
124358
|
124359
|
124360
|
124361
|
124362
|
124363
|
124421
|
124463
|
124583
|
124584
|
124585
|
124586
|
124587
|
124588
|
124589
|
124590
|
124591
|
124592
|
124593
|
124594
|
124595
|
124596
|
124597
|
124598
|
124599
|
124600
|
124601
|
124602
|
124603
|
124604
|
124605
|
124606
|
124607
|
124608
|
124609
|
124610
|
124611
|
124612
|
124613
|
124614
|
124615
|
131449
|
131450
|
131451
|
131452
|
131453
|
131454
|
131455
|
131456
|
134288
|
134289
|
134290
|
134291
|
134292
|
134293
|
134294
|
134295
|
134296
|
135590
|
135591
|
135592
|
135593
|
135594
|
135595
|
135596
|
135597
|
135598
|
135599
|
135600
|
135601
|
135602
|
135603
|
135604
|
135605
|
135606
|
135607
|
135608
|
135609
|
135610
|
135614
|
135615
|
135616
|
135617
|
135618
|
135619
|
135620
|
135621
|
135622
|
135623
|
135624
|
135625
|
135626
|
135627
|
135628
|
135629
|
137259
|
137260
|
137261
|
137262
|
137263
|
137264
|
137265
|
137266
|
137267
|
137268
|
137311
|
137314
|
137315
|
137316
|
137317
|
137318
|
137319
|
137320
|
137321
|
137322
|
137323
|
137441
|
137442
|
137443
|
137608
|
138933