[Rt-devel] Question about the data model!

[Ruslan U. Zakirov]

May be you can test RTx::Shredder? :)

Sven Sternberger wrote:
> Hello!
> 
> I'm in the process of understanding the rt datamodel to clean up our 
> database. One think I don't understand if the query:
> 
> select Principals.id,PrincipalType from Principals
> left join Users on Principals.id=Users.id
> left join Groups on Principals.id=Groups.id
> where Users.id is NULL and Groups.id is NULL;
> 
> should give me an empty result or not. I think in "Principals"
> is one entry related to an user or a group?
It should be empty, but ...

> 
> In our database ther 150k row which related to nothing :-/
Oops. I think it's code in RT::Group::Delete.
     # TODO XXX
 
 

     # Remove the principal object
     # Remove this group from anything it's a member of.
     # Remove all cached members of this group
     # Remove any rights granted to this group
     # remove any rights delegated by way of this group 
 


I have 4k records.

> 
> best regards