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 3555-3565 CREATE TABLE discharges ( Link Here
3555
3555
3556
DROP TABLE IF EXISTS audio_alerts;
3556
DROP TABLE IF EXISTS audio_alerts;
3557
CREATE TABLE audio_alerts (
3557
CREATE TABLE audio_alerts (
3558
  audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
3558
  id int(11) NOT NULL AUTO_INCREMENT,
3559
  precedence smallint(5) unsigned NOT NULL,
3559
  precedence smallint(5) unsigned NOT NULL,
3560
  selector varchar(255) NOT NULL,
3560
  selector varchar(255) NOT NULL,
3561
  sound varchar(255) NOT NULL,
3561
  sound varchar(255) NOT NULL,
3562
  PRIMARY KEY (audio_alert_id),
3562
  PRIMARY KEY (id),
3563
  KEY precedence (precedence)
3563
  KEY precedence (precedence)
3564
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COLLATE=utf8_unicode_ci;
3564
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COLLATE=utf8_unicode_ci;
3565
3565
(-)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