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 3587-3597 CREATE TABLE `localization` ( Link Here
3587
3587
3588
DROP TABLE IF EXISTS audio_alerts;
3588
DROP TABLE IF EXISTS audio_alerts;
3589
CREATE TABLE audio_alerts (
3589
CREATE TABLE audio_alerts (
3590
  audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
3590
  id int(11) NOT NULL AUTO_INCREMENT,
3591
  precedence smallint(5) unsigned NOT NULL,
3591
  precedence smallint(5) unsigned NOT NULL,
3592
  selector varchar(255) NOT NULL,
3592
  selector varchar(255) NOT NULL,
3593
  sound varchar(255) NOT NULL,
3593
  sound varchar(255) NOT NULL,
3594
  PRIMARY KEY (audio_alert_id),
3594
  PRIMARY KEY (id),
3595
  KEY precedence (precedence)
3595
  KEY precedence (precedence)
3596
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COLLATE=utf8_unicode_ci;
3596
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COLLATE=utf8_unicode_ci;
3597
3597
(-)a/installer/data/mysql/updatedatabase.pl (-3 / +2 lines)
Lines 9678-9688 if ( CheckVersion($DBversion) ) { Link Here
9678
9678
9679
    $dbh->do(q{
9679
    $dbh->do(q{
9680
        CREATE TABLE audio_alerts (
9680
        CREATE TABLE audio_alerts (
9681
            audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
9681
            id int(11) NOT NULL AUTO_INCREMENT,
9682
            precedence smallint(5) unsigned NOT NULL,
9682
            precedence smallint(5) unsigned NOT NULL,
9683
            selector varchar(255) NOT NULL,
9683
            selector varchar(255) NOT NULL,
9684
            sound varchar(255) NOT NULL,
9684
            sound varchar(255) NOT NULL,
9685
            PRIMARY KEY (audio_alert_id),
9685
            PRIMARY KEY (id),
9686
            KEY precedence (precedence)
9686
            KEY precedence (precedence)
9687
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9687
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9688
    });
9688
    });
9689
- 

Return to bug 11431