Bugzilla – Attachment 75419 Details for
Bug 11897
Stock Rotation for Koha
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 11897: DO NOT PUSH: (follow-up) Update stock rotation schema files.
Bug-11897-DO-NOT-PUSH-follow-up-Update-stock-rotat.patch (text/plain), 3.77 KB, created by
Martin Renvoize (ashimema)
on 2018-05-18 10:47:04 UTC
(
hide
)
Description:
Bug 11897: DO NOT PUSH: (follow-up) Update stock rotation schema files.
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2018-05-18 10:47:04 UTC
Size:
3.77 KB
patch
obsolete
>From 7ef1b10512215a11a19a1b8e1006c3940f397e25 Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Tue, 17 Apr 2018 16:46:19 +0100 >Subject: [PATCH] Bug 11897: DO NOT PUSH: (follow-up) Update stock rotation > schema files. > >We we're missing a unique constraint on stockrationrota.title >--- > Koha/Schema/Result/Branch.pm | 4 ++-- > Koha/Schema/Result/Item.pm | 5 ++--- > Koha/Schema/Result/Stockrotationrota.pm | 18 ++++++++++++++++-- > installer/data/mysql/atomicupdate/stockrot_tables.sql | 4 +++- > 4 files changed, 23 insertions(+), 8 deletions(-) > >diff --git a/Koha/Schema/Result/Branch.pm b/Koha/Schema/Result/Branch.pm >index 1f2bcb4c73..fceb86b672 100644 >--- a/Koha/Schema/Result/Branch.pm >+++ b/Koha/Schema/Result/Branch.pm >@@ -624,8 +624,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QOMUFz2EjvAVWCkIpNmvtg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-04-17 16:37:51 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0hfhEZW9VseBN7k05ByvpQ > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm >index bc439c7ef8..027075e9c4 100644 >--- a/Koha/Schema/Result/Item.pm >+++ b/Koha/Schema/Result/Item.pm >@@ -702,8 +702,8 @@ __PACKAGE__->might_have( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-12-12 17:02:24 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oo/Eubwpc1tcaGAO9Oja1A >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-04-17 16:37:51 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aOcn/Am4XilK4NblfY5zXQ > > __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" ); > >@@ -728,5 +728,4 @@ sub effective_itemtype { > } > } > >-# You can replace this text with custom code or comments, and it will be preserved on regeneration > 1; >diff --git a/Koha/Schema/Result/Stockrotationrota.pm b/Koha/Schema/Result/Stockrotationrota.pm >index 46661c635f..48f401df32 100644 >--- a/Koha/Schema/Result/Stockrotationrota.pm >+++ b/Koha/Schema/Result/Stockrotationrota.pm >@@ -79,6 +79,20 @@ __PACKAGE__->add_columns( > > __PACKAGE__->set_primary_key("rota_id"); > >+=head1 UNIQUE CONSTRAINTS >+ >+=head2 C<stockrotationrotas_title> >+ >+=over 4 >+ >+=item * L</title> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->add_unique_constraint("stockrotationrotas_title", ["title"]); >+ > =head1 RELATIONS > > =head2 stockrotationstages >@@ -97,8 +111,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-17 16:18:21 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gglRP/Dh1RIu9eH834lStA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-04-17 16:37:51 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KOv8PNKzQd3gLTskL1GiHw > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/installer/data/mysql/atomicupdate/stockrot_tables.sql b/installer/data/mysql/atomicupdate/stockrot_tables.sql >index cbbb5c5976..8ca89a0c6b 100644 >--- a/installer/data/mysql/atomicupdate/stockrot_tables.sql >+++ b/installer/data/mysql/atomicupdate/stockrot_tables.sql >@@ -6,7 +6,9 @@ CREATE TABLE IF NOT EXISTS stockrotationrotas ( > description text NOT NULL default '', -- Description for this rota > cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling? > active tinyint(1) NOT NULL default 0, -- Is this rota currently active? >- PRIMARY KEY (`rota_id`) >+ PRIMARY KEY (`rota_id`), >+ CONSTRAINT `stockrotationrotas_title` >+ UNIQUE (`title`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > > -- Stock Rotation Stages >-- >2.14.2
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 11897
:
25887
|
58207
|
58208
|
58209
|
58210
|
58211
|
58212
|
58213
|
58214
|
58215
|
58216
|
58217
|
58218
|
58219
|
58280
|
58281
|
58687
|
58692
|
58693
|
58694
|
58695
|
58696
|
60175
|
60715
|
61825
|
61826
|
61827
|
61828
|
61829
|
61830
|
61831
|
61832
|
61833
|
61834
|
61835
|
61836
|
61837
|
61838
|
61839
|
61885
|
62730
|
62750
|
62751
|
62752
|
62753
|
62754
|
62755
|
62756
|
62757
|
62758
|
62759
|
62760
|
62761
|
62762
|
62763
|
62764
|
62765
|
62766
|
62767
|
63063
|
63064
|
63065
|
63066
|
63067
|
63068
|
63069
|
63070
|
63071
|
63072
|
63073
|
63074
|
63075
|
63076
|
63077
|
63078
|
63079
|
63080
|
63114
|
64850
|
64851
|
65715
|
65716
|
65717
|
65718
|
65719
|
65720
|
65721
|
65722
|
65723
|
65724
|
65725
|
65726
|
65727
|
65728
|
65729
|
65730
|
65731
|
65732
|
65733
|
65734
|
65735
|
65736
|
65737
|
65738
|
65739
|
65740
|
65741
|
65742
|
65743
|
65744
|
65745
|
65746
|
65747
|
65748
|
65749
|
65750
|
65751
|
65752
|
65753
|
65754
|
65755
|
65756
|
65757
|
65758
|
66381
|
70496
|
70497
|
70498
|
70499
|
70500
|
70501
|
70502
|
70503
|
70504
|
70505
|
70506
|
70507
|
70508
|
70509
|
70510
|
70511
|
70512
|
70513
|
70514
|
70515
|
70516
|
70517
|
70518
|
70519
|
70520
|
70521
|
70522
|
70523
|
70524
|
72124
|
72125
|
72126
|
72127
|
72128
|
74003
|
74004
|
74005
|
74006
|
74007
|
74008
|
74010
|
74011
|
74012
|
74013
|
74014
|
74015
|
74016
|
74017
|
74197
|
74198
|
74199
|
74200
|
74201
|
74202
|
74203
|
74204
|
74205
|
74206
|
74319
|
74320
|
74360
|
74459
|
74460
|
74461
|
74462
|
74463
|
74464
|
74465
|
74466
|
74467
|
74468
|
74469
|
74470
|
75409
|
75410
|
75411
|
75412
|
75413
|
75414
|
75415
|
75416
|
75417
|
75418
|
75419
|
75420
|
76121
|
76122
|
76123
|
76124
|
76125
|
76126
|
76127
|
76128
|
76129
|
76130
|
76131
|
76132
|
76133
|
76134
|
76135
|
76144
|
76706
|
76707
|
76708
|
76709
|
76710
|
77623
|
77624
|
77625
|
77626
|
78387
|
78388
|
78389
|
78390
|
78391
|
78392
|
78393
|
78394
|
78404
|
78405
|
78406
|
78407
|
78408
|
79040
|
79041
|
79042
|
79043
|
79044
|
79738
|
79739
|
79740
|
79741
|
79742
|
79746
|
79747
|
79748
|
79749
|
79750
|
79964
|
79965
|
79966
|
79967
|
79968
|
79969
|
79970
|
79971
|
79972
|
79973
|
79974
|
79975
|
80068
|
80087
|
80088
|
80089
|
80090
|
80091
|
80092
|
80093
|
80094
|
80095
|
80096
|
80097
|
80098
|
80099
|
80100
|
80118
|
80260
|
80261
|
80262
|
80263
|
80264
|
80265
|
80266
|
80267
|
80268
|
80269
|
80270
|
80271
|
80272
|
80273
|
80274
|
80275
|
80289
|
80298
|
80299
|
80300