From 264523e90f829cd159b5a54079a208a2da30b2af Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Wed, 19 Aug 2015 07:57:17 -0400 Subject: [PATCH] Bug 11431 [QA Followup] - Simplify audio_alert_id to just id --- 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 +=item * L =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 7a97ce9..e1139b1 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3542,11 +3542,11 @@ CREATE TABLE discharges ( 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 98fadc6..9de0444 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -9679,11 +9679,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