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 3542-3552 CREATE TABLE discharges ( Link Here
3542
3542
3543
DROP TABLE IF EXISTS audio_alerts;
3543
DROP TABLE IF EXISTS audio_alerts;
3544
CREATE TABLE audio_alerts (
3544
CREATE TABLE audio_alerts (
3545
  audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
3545
  id int(11) NOT NULL AUTO_INCREMENT,
3546
  precedence smallint(5) unsigned NOT NULL,
3546
  precedence smallint(5) unsigned NOT NULL,
3547
  selector varchar(255) NOT NULL,
3547
  selector varchar(255) NOT NULL,
3548
  sound varchar(255) NOT NULL,
3548
  sound varchar(255) NOT NULL,
3549
  PRIMARY KEY (audio_alert_id),
3549
  PRIMARY KEY (id),
3550
  KEY precedence (precedence)
3550
  KEY precedence (precedence)
3551
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COLLATE=utf8_unicode_ci;
3551
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COLLATE=utf8_unicode_ci;
3552
3552
(-)a/installer/data/mysql/updatedatabase.pl (-3 / +2 lines)
Lines 9679-9689 if ( CheckVersion($DBversion) ) { Link Here
9679
9679
9680
    $dbh->do(q{
9680
    $dbh->do(q{
9681
        CREATE TABLE audio_alerts (
9681
        CREATE TABLE audio_alerts (
9682
            audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
9682
            id int(11) NOT NULL AUTO_INCREMENT,
9683
            precedence smallint(5) unsigned NOT NULL,
9683
            precedence smallint(5) unsigned NOT NULL,
9684
            selector varchar(255) NOT NULL,
9684
            selector varchar(255) NOT NULL,
9685
            sound varchar(255) NOT NULL,
9685
            sound varchar(255) NOT NULL,
9686
            PRIMARY KEY (audio_alert_id),
9686
            PRIMARY KEY (id),
9687
            KEY precedence (precedence)
9687
            KEY precedence (precedence)
9688
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9688
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9689
    });
9689
    });
9690
- 

Return to bug 11431