1 # @tag: auth_schema_normalization_1
2 # @description: Auth-Datenbankschema Normalisierungen Teil 1
4 package SL::DBUpgrade2::auth_schema_normalization_1;
9 use parent qw(SL::DBUpgrade2::Base);
12 my ($self, $query) = @_;
14 if ($self->dbh->do($query)) {
17 $self->dbh->rollback();
24 $self->dbh($::auth->dbconnect);
26 my @queries = ( qq|ALTER TABLE auth.group_rights ADD PRIMARY KEY (group_id, "right");|,
27 qq|ALTER TABLE auth.user_config ADD PRIMARY KEY (user_id, cfg_key);|,
28 qq|ALTER TABLE auth.user_group ADD PRIMARY KEY (user_id, group_id);|);
30 $self->do_one($_) for @queries;