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

(-)a/Koha/Schema/Result/LibraryGroup.pm (-2 / +16 lines)
Lines 104-109 __PACKAGE__->add_columns( Link Here
104
104
105
__PACKAGE__->set_primary_key("id");
105
__PACKAGE__->set_primary_key("id");
106
106
107
=head1 UNIQUE CONSTRAINTS
108
109
=head2 C<title>
110
111
=over 4
112
113
=item * L</title>
114
115
=back
116
117
=cut
118
119
__PACKAGE__->add_unique_constraint("title", ["title"]);
120
107
=head1 RELATIONS
121
=head1 RELATIONS
108
122
109
=head2 branchcode
123
=head2 branchcode
Lines 162-169 __PACKAGE__->belongs_to( Link Here
162
);
176
);
163
177
164
178
165
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-11-02 13:23:16
179
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-03-01 13:07:33
166
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aQJgATq8JW4hCBFZfYus7w
180
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:K63IXlbjifZWzBnbvFIz0A
167
181
168
182
169
# You can replace this text with custom code or comments, and it will be preserved on regeneration
183
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/installer/data/mysql/atomicupdate/library_groups.sql (-1 / +2 lines)
Lines 8-12 CREATE TABLE library_groups ( Link Here
8
    updated_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- Date and time of last
8
    updated_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- Date and time of last
9
    PRIMARY KEY id ( id ),
9
    PRIMARY KEY id ( id ),
10
    FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE,
10
    FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE,
11
    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE
11
    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE,
12
    UNIQUE( title )
12
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
13
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 3970-3976 CREATE TABLE library_groups ( Link Here
3970
    updated_on DATETIME NULL DEFAULT NULL, -- Date and time of last
3970
    updated_on DATETIME NULL DEFAULT NULL, -- Date and time of last
3971
    PRIMARY KEY id ( id ),
3971
    PRIMARY KEY id ( id ),
3972
    FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE,
3972
    FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE,
3973
    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE
3973
    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE,
3974
    UNIQUE( title )
3974
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3975
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3975
3976
3976
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3977
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3977
- 

Return to bug 15707