Bugzilla – Attachment 44401 Details for
Bug 11431
Custom notification sounds
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 11431 [QA Followup] - Simplify audio_alert_id to just id
Bug-11431-QA-Followup---Simplify-audioalertid-to-j.patch (text/plain), 3.12 KB, created by
Kyle M Hall (khall)
on 2015-11-04 15:16:08 UTC
(
hide
)
Description:
Bug 11431 [QA Followup] - Simplify audio_alert_id to just id
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2015-11-04 15:16:08 UTC
Size:
3.12 KB
patch
obsolete
>From 977d6047a5f3b4944aaa88d235bdbb3bd6e57a06 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Wed, 19 Aug 2015 07:57:17 -0400 >Subject: [PATCH] Bug 11431 [QA Followup] - Simplify audio_alert_id to just id > >Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> >--- > Koha/Schema/Result/AudioAlert.pm | 12 ++++++------ > installer/data/mysql/kohastructure.sql | 4 ++-- > installer/data/mysql/updatedatabase.pl | 4 ++-- > 3 files changed, 10 insertions(+), 10 deletions(-) > >diff --git a/Koha/Schema/Result/AudioAlert.pm b/Koha/Schema/Result/AudioAlert.pm >index 696040b..24b2927 100644 >--- a/Koha/Schema/Result/AudioAlert.pm >+++ b/Koha/Schema/Result/AudioAlert.pm >@@ -23,7 +23,7 @@ __PACKAGE__->table("audio_alerts"); > > =head1 ACCESSORS > >-=head2 audio_alert_id >+=head2 id > > data_type: 'integer' > is_auto_increment: 1 >@@ -50,7 +50,7 @@ __PACKAGE__->table("audio_alerts"); > =cut > > __PACKAGE__->add_columns( >- "audio_alert_id", >+ "id", > { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, > "precedence", > { data_type => "smallint", extra => { unsigned => 1 }, is_nullable => 0 }, >@@ -64,17 +64,17 @@ __PACKAGE__->add_columns( > > =over 4 > >-=item * L</audio_alert_id> >+=item * L</id> > > =back > > =cut > >-__PACKAGE__->set_primary_key("audio_alert_id"); >+__PACKAGE__->set_primary_key("id"); > > >-# Created by DBIx::Class::Schema::Loader v0.07040 @ 2014-12-22 01:04:21 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yIXpJMcpovBDl3bBVrwLqg >+# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-08-19 08:01:06 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lPTnmrJd5V/X9fLebC8FHA > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 6cc0133..76ee26b 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3587,11 +3587,11 @@ CREATE TABLE `localization` ( > > DROP TABLE IF EXISTS audio_alerts; > CREATE TABLE audio_alerts ( >- audio_alert_id int(11) NOT NULL AUTO_INCREMENT, >+ id int(11) NOT NULL AUTO_INCREMENT, > precedence smallint(5) unsigned NOT NULL, > selector varchar(255) NOT NULL, > sound varchar(255) NOT NULL, >- PRIMARY KEY (audio_alert_id), >+ PRIMARY KEY (id), > KEY precedence (precedence) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index b530128..e3decbe 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -9678,11 +9678,11 @@ if ( CheckVersion($DBversion) ) { > > $dbh->do(q{ > CREATE TABLE audio_alerts ( >- audio_alert_id int(11) NOT NULL AUTO_INCREMENT, >+ id int(11) NOT NULL AUTO_INCREMENT, > precedence smallint(5) unsigned NOT NULL, > selector varchar(255) NOT NULL, > sound varchar(255) NOT NULL, >- PRIMARY KEY (audio_alert_id), >+ PRIMARY KEY (id), > KEY precedence (precedence) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > }); >-- >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 11431
:
29030
|
29031
|
29032
|
29033
|
29034
|
29035
|
29036
|
29037
|
29038
|
29039
|
29119
|
29120
|
29404
|
29764
|
29765
|
29766
|
29767
|
29768
|
29769
|
31145
|
31146
|
31147
|
31148
|
31149
|
31150
|
34637
|
34638
|
34639
|
34640
|
34641
|
34642
|
34643
|
34644
|
34645
|
34646
|
34647
|
34648
|
34649
|
34650
|
34651
|
34652
|
34653
|
34717
|
34718
|
34719
|
34720
|
34864
|
34865
|
34866
|
34867
|
35843
|
35844
|
35845
|
35846
|
38547
|
38548
|
40726
|
40727
|
40728
|
40729
|
40730
|
40731
|
40732
|
41634
|
41661
|
41662
|
42678
|
42679
|
42680
|
42681
|
42682
|
42683
|
42684
|
42685
|
42686
|
42687
|
42688
|
42689
|
42696
|
43753
|
43754
|
43755
|
43756
|
43757
|
43758
|
43759
|
43760
|
43761
|
43762
|
43763
|
43764
|
43765
|
43817
|
43820
|
43821
|
43822
|
43823
|
43824
|
43825
|
43887
|
43888
|
43889
|
43890
|
43891
|
43892
|
43893
|
43894
|
43895
|
43896
|
43897
|
43898
|
43899
|
43900
|
43901
|
43902
|
43903
|
44391
|
44392
|
44393
|
44394
|
44395
|
44396
|
44397
|
44398
|
44399
|
44400
| 44401 |
44402
|
44404
|
44405
|
44407
|
44408
|
44409
|
44411
|
44412
|
44599
|
45135