Rose-Schema für auth.*-Tabellen aktualisiert

diff --git a/SL/DB/MetaSetup/AuthGroupRight.pm b/SL/DB/MetaSetup/AuthGroupRight.pm
index 677796631473aa7e4939684111e03780965f993e..7c98d2ab24a1064073fc3f72d1e449c08a58e4f6 100644 (file)
--- a/SL/DB/MetaSetup/AuthGroupRight.pm
+++ b/SL/DB/MetaSetup/AuthGroupRight.pm
@@ -17,6 +17,13 @@ __PACKAGE__->meta->setup(
   ],
 
   primary_key_columns => [ 'group_id', 'right' ],
   ],
 
   primary_key_columns => [ 'group_id', 'right' ],

+
+  foreign_keys => [
+    group => {
+      class       => 'SL::DB::AuthGroup',
+      key_columns => { group_id => 'id' },
+    },
+  ],

 );
 
 1;
 );
 
 1;

diff --git a/SL/DB/MetaSetup/AuthUserConfig.pm b/SL/DB/MetaSetup/AuthUserConfig.pm
index 688998b57e7c9d0ffb9717f5f24ef62b0404c7ef..ef9e3489511f61dca5587f3bcbb2bc7f5b930b68 100644 (file)
--- a/SL/DB/MetaSetup/AuthUserConfig.pm
+++ b/SL/DB/MetaSetup/AuthUserConfig.pm
@@ -17,6 +17,13 @@ __PACKAGE__->meta->setup(
   ],
 
   primary_key_columns => [ 'user_id', 'cfg_key' ],
   ],
 
   primary_key_columns => [ 'user_id', 'cfg_key' ],

+
+  foreign_keys => [
+    user => {
+      class       => 'SL::DB::AuthUser',
+      key_columns => { user_id => 'id' },
+    },
+  ],

 );
 
 1;
 );
 
 1;

diff --git a/SL/DB/MetaSetup/AuthUserGroup.pm b/SL/DB/MetaSetup/AuthUserGroup.pm
index 86a0ed571816104b1d3b057da384ca16acba35b0..226921f3c236771ba8d5a92da9655faad781a225 100644 (file)
--- a/SL/DB/MetaSetup/AuthUserGroup.pm
+++ b/SL/DB/MetaSetup/AuthUserGroup.pm
@@ -18,15 +18,15 @@ __PACKAGE__->meta->setup(
   primary_key_columns => [ 'user_id', 'group_id' ],
 
   foreign_keys => [
   primary_key_columns => [ 'user_id', 'group_id' ],
 
   foreign_keys => [

-    user => {
-      class       => 'SL::DB::AuthUser',
-      key_columns => { user_id => 'id' },
-    },
-

     group => {
       class       => 'SL::DB::AuthGroup',
       key_columns => { group_id => 'id' },
     },
     group => {
       class       => 'SL::DB::AuthGroup',
       key_columns => { group_id => 'id' },
     },

+
+    user => {
+      class       => 'SL::DB::AuthUser',
+      key_columns => { user_id => 'id' },
+    },

   ],
 );
 
   ],
 );