Bugzilla – Attachment 88856 Details for
Bug 11529
Add subtitle, medium and part fields to biblio table
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 11529: DBIx schema changes
Bug-11529-DBIx-schema-changes.patch (text/plain), 4.29 KB, created by
Josef Moravec
on 2019-04-26 07:36:33 UTC
(
hide
)
Description:
Bug 11529: DBIx schema changes
Filename:
MIME Type:
Creator:
Josef Moravec
Created:
2019-04-26 07:36:33 UTC
Size:
4.29 KB
patch
obsolete
>From 9871af292592e64f20c3fa4eb91e9287017428e0 Mon Sep 17 00:00:00 2001 >From: Ere Maijala <ere.maijala@helsinki.fi> >Date: Wed, 12 Dec 2018 14:05:36 +0200 >Subject: [PATCH] Bug 11529: DBIx schema changes > >Updates to Biblio schema and removal of FieldMapping schema. > >Signed-off-by: Michal Denar <black23@gmail.com> > >Signed-off-by: Michal Denar <black23@gmail.com> > >Signed-off-by: Josef Moravec <josef.moravec@gmail.com> >--- > Koha/Schema/Result/Biblio.pm | 37 ++++++++++++++-- > Koha/Schema/Result/Fieldmapping.pm | 90 -------------------------------------- > 2 files changed, 33 insertions(+), 94 deletions(-) > delete mode 100644 Koha/Schema/Result/Fieldmapping.pm > >diff --git a/Koha/Schema/Result/Biblio.pm b/Koha/Schema/Result/Biblio.pm >index c2623268e2..4f78e735c6 100644 >--- a/Koha/Schema/Result/Biblio.pm >+++ b/Koha/Schema/Result/Biblio.pm >@@ -46,6 +46,26 @@ __PACKAGE__->table("biblio"); > data_type: 'longtext' > is_nullable: 1 > >+=head2 medium >+ >+ data_type: 'longtext' >+ is_nullable: 1 >+ >+=head2 subtitle >+ >+ data_type: 'longtext' >+ is_nullable: 1 >+ >+=head2 part_number >+ >+ data_type: 'longtext' >+ is_nullable: 1 >+ >+=head2 part_name >+ >+ data_type: 'longtext' >+ is_nullable: 1 >+ > =head2 unititle > > data_type: 'longtext' >@@ -75,7 +95,7 @@ __PACKAGE__->table("biblio"); > > data_type: 'timestamp' > datetime_undef_if_invalid: 1 >- default_value: current_timestamp >+ default_value: 'current_timestamp()' > is_nullable: 0 > > =head2 datecreated >@@ -100,6 +120,14 @@ __PACKAGE__->add_columns( > { data_type => "longtext", is_nullable => 1 }, > "title", > { data_type => "longtext", is_nullable => 1 }, >+ "medium", >+ { data_type => "longtext", is_nullable => 1 }, >+ "subtitle", >+ { data_type => "longtext", is_nullable => 1 }, >+ "part_number", >+ { data_type => "longtext", is_nullable => 1 }, >+ "part_name", >+ { data_type => "longtext", is_nullable => 1 }, > "unititle", > { data_type => "longtext", is_nullable => 1 }, > "notes", >@@ -114,7 +142,7 @@ __PACKAGE__->add_columns( > { > data_type => "timestamp", > datetime_undef_if_invalid => 1, >- default_value => \"current_timestamp", >+ default_value => "current_timestamp()", > is_nullable => 0, > }, > "datecreated", >@@ -363,8 +391,9 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-03-11 12:56:41 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ebn7Szfm8/HbrdAc7ekTnA >+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2019-03-15 16:45:45 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:61+Di/Fke60nCaASGeXbvw >+ > > __PACKAGE__->has_one( > "metadata", >diff --git a/Koha/Schema/Result/Fieldmapping.pm b/Koha/Schema/Result/Fieldmapping.pm >deleted file mode 100644 >index d0b8730b3b..0000000000 >--- a/Koha/Schema/Result/Fieldmapping.pm >+++ /dev/null >@@ -1,90 +0,0 @@ >-use utf8; >-package Koha::Schema::Result::Fieldmapping; >- >-# Created by DBIx::Class::Schema::Loader >-# DO NOT MODIFY THE FIRST PART OF THIS FILE >- >-=head1 NAME >- >-Koha::Schema::Result::Fieldmapping >- >-=cut >- >-use strict; >-use warnings; >- >-use base 'DBIx::Class::Core'; >- >-=head1 TABLE: C<fieldmapping> >- >-=cut >- >-__PACKAGE__->table("fieldmapping"); >- >-=head1 ACCESSORS >- >-=head2 id >- >- data_type: 'integer' >- is_auto_increment: 1 >- is_nullable: 0 >- >-=head2 field >- >- data_type: 'varchar' >- is_nullable: 0 >- size: 255 >- >-=head2 frameworkcode >- >- data_type: 'char' >- default_value: (empty string) >- is_nullable: 0 >- size: 4 >- >-=head2 fieldcode >- >- data_type: 'char' >- is_nullable: 0 >- size: 3 >- >-=head2 subfieldcode >- >- data_type: 'char' >- is_nullable: 0 >- size: 1 >- >-=cut >- >-__PACKAGE__->add_columns( >- "id", >- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, >- "field", >- { data_type => "varchar", is_nullable => 0, size => 255 }, >- "frameworkcode", >- { data_type => "char", default_value => "", is_nullable => 0, size => 4 }, >- "fieldcode", >- { data_type => "char", is_nullable => 0, size => 3 }, >- "subfieldcode", >- { data_type => "char", is_nullable => 0, size => 1 }, >-); >- >-=head1 PRIMARY KEY >- >-=over 4 >- >-=item * L</id> >- >-=back >- >-=cut >- >-__PACKAGE__->set_primary_key("id"); >- >- >-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:x+izN6nqxs+W/g/demOpOg >- >- >-# You can replace this text with custom content, and it will be preserved on regeneration >-1; >-- >2.11.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 11529
:
81930
|
81931
|
82024
|
82025
|
82026
|
82027
|
82028
|
82029
|
82088
|
82089
|
82090
|
82428
|
82429
|
82430
|
82431
|
82538
|
82539
|
82540
|
82541
|
82542
|
83103
|
83104
|
83105
|
83106
|
83107
|
83108
|
83961
|
83962
|
83963
|
83964
|
83965
|
83966
|
85587
|
85588
|
85589
|
85590
|
85591
|
85592
|
86677
|
86678
|
86679
|
86680
|
86681
|
86682
|
87248
|
87249
|
87250
|
87251
|
87252
|
87253
|
87256
|
87257
|
87258
|
87259
|
87260
|
87261
|
87911
|
87912
|
87913
|
87914
|
87915
|
87916
|
87917
|
87918
|
87919
|
88247
|
88248
|
88249
|
88250
|
88251
|
88252
|
88253
|
88254
|
88255
|
88256
|
88406
|
88407
|
88408
|
88409
|
88410
|
88411
|
88412
|
88413
|
88414
|
88415
|
88416
|
88433
|
88434
|
88435
|
88436
|
88437
|
88438
|
88439
|
88440
|
88441
|
88442
|
88443
|
88762
|
88763
|
88764
|
88765
|
88766
|
88767
|
88768
|
88769
|
88770
|
88771
|
88772
|
88851
|
88852
|
88853
|
88854
|
88855
|
88856
|
88857
|
88858
|
88859
|
88860
|
88861
|
88862
|
89096
|
89097
|
89098
|
89099
|
89100
|
89101
|
89102
|
89103
|
89104
|
89105
|
89106
|
89107
|
89234
|
89235
|
89236
|
89237
|
89238
|
89239
|
89240
|
89241
|
89242
|
89243
|
89244
|
89245
|
89246
|
91680
|
91681
|
91682
|
91683
|
91684
|
91685
|
91686
|
91687
|
91688
|
91689
|
91690
|
91691
|
91692
|
91824
|
91825
|
91826
|
91827
|
91828
|
91829
|
91830
|
91831
|
91832
|
91833
|
91834
|
91835
|
91836
|
91837
|
92016
|
92019
|
92020
|
105667
|
105672