Bugzilla – Attachment 37109 Details for
Bug 13790
Add unique id issue_id to issues and old_issues tables
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 13790 - Update Koha Schema
Bug-13790---Update-Koha-Schema.patch (text/plain), 3.10 KB, created by
Kyle M Hall (khall)
on 2015-03-23 11:23:50 UTC
(
hide
)
Description:
Bug 13790 - Update Koha Schema
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2015-03-23 11:23:50 UTC
Size:
3.10 KB
patch
obsolete
>From 96d40f22a63a18d99ebb86af16506cc29feddf62 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Wed, 4 Mar 2015 01:29:23 -0800 >Subject: [PATCH] Bug 13790 - Update Koha Schema > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > Koha/Schema/Result/Issue.pm | 24 ++++++++++++++++++++++-- > Koha/Schema/Result/OldIssue.pm | 24 ++++++++++++++++++++++-- > 2 files changed, 44 insertions(+), 4 deletions(-) > >diff --git a/Koha/Schema/Result/Issue.pm b/Koha/Schema/Result/Issue.pm >index 5ec687e..7194ee5 100644 >--- a/Koha/Schema/Result/Issue.pm >+++ b/Koha/Schema/Result/Issue.pm >@@ -23,6 +23,12 @@ __PACKAGE__->table("issues"); > > =head1 ACCESSORS > >+=head2 issue_id >+ >+ data_type: 'integer' >+ is_auto_increment: 1 >+ is_nullable: 0 >+ > =head2 borrowernumber > > data_type: 'integer' >@@ -104,6 +110,8 @@ __PACKAGE__->table("issues"); > =cut > > __PACKAGE__->add_columns( >+ "issue_id", >+ { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, > "borrowernumber", > { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, > "itemnumber", >@@ -153,6 +161,18 @@ __PACKAGE__->add_columns( > { data_type => "integer", default_value => 0, is_nullable => 0 }, > ); > >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</issue_id> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("issue_id"); >+ > =head1 RELATIONS > > =head2 borrowernumber >@@ -196,8 +216,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-11-03 10:40:55 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7Y+5IerDnajn5GLwAY5thg >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-03-04 01:28:57 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6qScIJXFf22NupHb0j1Geg > > __PACKAGE__->belongs_to( > "borrower", >diff --git a/Koha/Schema/Result/OldIssue.pm b/Koha/Schema/Result/OldIssue.pm >index b56db99..60d6e4c 100644 >--- a/Koha/Schema/Result/OldIssue.pm >+++ b/Koha/Schema/Result/OldIssue.pm >@@ -23,6 +23,12 @@ __PACKAGE__->table("old_issues"); > > =head1 ACCESSORS > >+=head2 issue_id >+ >+ data_type: 'integer' >+ is_auto_increment: 1 >+ is_nullable: 0 >+ > =head2 borrowernumber > > data_type: 'integer' >@@ -104,6 +110,8 @@ __PACKAGE__->table("old_issues"); > =cut > > __PACKAGE__->add_columns( >+ "issue_id", >+ { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, > "borrowernumber", > { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, > "itemnumber", >@@ -153,6 +161,18 @@ __PACKAGE__->add_columns( > { data_type => "integer", default_value => 0, is_nullable => 0 }, > ); > >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</issue_id> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("issue_id"); >+ > =head1 RELATIONS > > =head2 borrowernumber >@@ -196,8 +216,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-11-03 10:40:55 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lNB9CDFcwG4DjD0pl14mvQ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-03-04 01:28:58 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RtXioj56llRjPoeKpTghPg > > > # You can replace this text with custom content, and it will be preserved on regeneration >-- >1.7.2.5
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 13790
:
36441
|
36442
|
37108
|
37109
|
37709
|
37710
|
38073
|
38081
|
38082
|
38155
|
38156
|
38157
|
38158
|
38182
|
38184
|
38349
|
38350
|
38351
|
38352
|
38353
|
38354
|
38429