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 3565-3575 CREATE TABLE `additional_field_values` ( Link Here
3565
3565
3566
DROP TABLE IF EXISTS audio_alerts;
3566
DROP TABLE IF EXISTS audio_alerts;
3567
CREATE TABLE audio_alerts (
3567
CREATE TABLE audio_alerts (
3568
  audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
3568
  id int(11) NOT NULL AUTO_INCREMENT,
3569
  precedence smallint(5) unsigned NOT NULL,
3569
  precedence smallint(5) unsigned NOT NULL,
3570
  selector varchar(255) NOT NULL,
3570
  selector varchar(255) NOT NULL,
3571
  sound varchar(255) NOT NULL,
3571
  sound varchar(255) NOT NULL,
3572
  PRIMARY KEY (audio_alert_id),
3572
  PRIMARY KEY (id),
3573
  KEY precedence (precedence)
3573
  KEY precedence (precedence)
3574
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COLLATE=utf8_unicode_ci;
3574
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COLLATE=utf8_unicode_ci;
3575
3575
(-)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