View | Details | Raw Unified | Return to bug 11431
Collapse All | Expand All

(-)a/Koha/Schema/Result/AudioAlert.pm (-6 / +6 lines)
Lines 23-29 __PACKAGE__->table("audio_alerts"); Link Here
23
23
24
=head1 ACCESSORS
24
=head1 ACCESSORS
25
25
26
=head2 audio_alert_id
26
=head2 id
27
27
28
  data_type: 'integer'
28
  data_type: 'integer'
29
  is_auto_increment: 1
29
  is_auto_increment: 1
Lines 50-56 __PACKAGE__->table("audio_alerts"); Link Here
50
=cut
50
=cut
51
51
52
__PACKAGE__->add_columns(
52
__PACKAGE__->add_columns(
53
  "audio_alert_id",
53
  "id",
54
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
54
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
55
  "precedence",
55
  "precedence",
56
  { data_type => "smallint", extra => { unsigned => 1 }, is_nullable => 0 },
56
  { data_type => "smallint", extra => { unsigned => 1 }, is_nullable => 0 },
Lines 64-80 __PACKAGE__->add_columns( Link Here
64
64
65
=over 4
65
=over 4
66
66
67
=item * L</audio_alert_id>
67
=item * L</id>
68
68
69
=back
69
=back
70
70
71
=cut
71
=cut
72
72
73
__PACKAGE__->set_primary_key("audio_alert_id");
73
__PACKAGE__->set_primary_key("id");
74
74
75
75
76
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2014-12-22 01:04:21
76
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-08-19 08:01:06
77
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yIXpJMcpovBDl3bBVrwLqg
77
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lPTnmrJd5V/X9fLebC8FHA
78
78
79
79
80
# You can replace this text with custom code or comments, and it will be preserved on regeneration
80
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 3569-3579 CREATE TABLE `additional_field_values` ( Link Here
3569
3569
3570
DROP TABLE IF EXISTS audio_alerts;
3570
DROP TABLE IF EXISTS audio_alerts;
3571
CREATE TABLE audio_alerts (
3571
CREATE TABLE audio_alerts (
3572
  audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
3572
  id int(11) NOT NULL AUTO_INCREMENT,
3573
  precedence smallint(5) unsigned NOT NULL,
3573
  precedence smallint(5) unsigned NOT NULL,
3574
  selector varchar(255) NOT NULL,
3574
  selector varchar(255) NOT NULL,
3575
  sound varchar(255) NOT NULL,
3575
  sound varchar(255) NOT NULL,
3576
  PRIMARY KEY (audio_alert_id),
3576
  PRIMARY KEY (id),
3577
  KEY precedence (precedence)
3577
  KEY precedence (precedence)
3578
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COLLATE=utf8_unicode_ci;
3578
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COLLATE=utf8_unicode_ci;
3579
3579
(-)a/installer/data/mysql/updatedatabase.pl (-3 / +2 lines)
Lines 9680-9690 if ( CheckVersion($DBversion) ) { Link Here
9680
9680
9681
    $dbh->do(q{
9681
    $dbh->do(q{
9682
        CREATE TABLE audio_alerts (
9682
        CREATE TABLE audio_alerts (
9683
            audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
9683
            id int(11) NOT NULL AUTO_INCREMENT,
9684
            precedence smallint(5) unsigned NOT NULL,
9684
            precedence smallint(5) unsigned NOT NULL,
9685
            selector varchar(255) NOT NULL,
9685
            selector varchar(255) NOT NULL,
9686
            sound varchar(255) NOT NULL,
9686
            sound varchar(255) NOT NULL,
9687
            PRIMARY KEY (audio_alert_id),
9687
            PRIMARY KEY (id),
9688
            KEY precedence (precedence)
9688
            KEY precedence (precedence)
9689
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9689
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9690
    });
9690
    });
9691
- 

Return to bug 11431