[Rt-devel] ERM db schema and relationship with codes for disable an user

[Peter C. Lai]

Yeah as a general rule, use the API. It's there, it works.

On 2010-02-10 10:18:00AM +0000, Raed El-Hames wrote:
> Bare in mind tinkering in the database is not recommended , and as far 
> as I know, later versions of RT include a Shredder which allow you to 
> clean the database.
> 
> Hope that helped;
> 
> Regards;
> Roy
> 
> 
> 
> 
> 
> Eduardo Cerqueira wrote:
> > I'd like to understand the DB relationship. would we have the ERM or 
> > DB schema in some place on twiki? I took a glace there but with no 
> > successful.
> >
> > at this point I want to clean up old users from my DB (I have 265 
> > records) in my Users table and I am not sure how can I filter users 
> > disabled as into table there is no
> > flag field for this, at least I didn't find this.
> >
> > and I really would love to understand where is going Disabled value, 
> > for this case below I copied it from 
> > rt3/share/html/Admin/Users/Modify.html so I can't see this field in 
> > Users table.
> >
> > */can my DB schema is no updated?/*
> >
> >
> >     if ( defined $id && $id eq 'new') {
> > ( $val, $msg ) = $UserObj->Create(
> >     Name                  => $Name,
> >     EmailAddress          => $ARGS{'EmailAddress'},
> >     Name                  => $ARGS{'Name'},
> >     Comments              => $ARGS{'Comments'},
> >     Signature             => $ARGS{'Signature'},
> >     EmailAddress          => $ARGS{'EmailAddress'},
> >     FreeformContactInfo   => $ARGS{'FreeformContactInfo'},
> >     Organization          => $ARGS{'Organization'},
> >     RealName              => $ARGS{'RealName'},
> >     NickName              => $ARGS{'NickName'},
> >     Lang                  => $ARGS{'Lang'},
> >     EmailEncoding         => $ARGS{'EmailEncoding'},
> >     WebEncoding           => $ARGS{'WebEncoding'},
> >     ExternalContactInfoId => $ARGS{'ExternalContactInfoId'},
> >     ContactInfoSystem     => $ARGS{'ContactInfoSystem'},
> >     Gecos                 => $ARGS{'Gecos'},
> >     ExternalAuthId        => $ARGS{'ExternalAuthId'},
> >     AuthSystem            => $ARGS{'AuthSystem'},
> >     HomePhone             => $ARGS{'HomePhone'},
> >     WorkPhone             => $ARGS{'WorkPhone'},
> >     MobilePhone           => $ARGS{'MobilePhone'},
> >     PagerPhone            => $ARGS{'PagerPhone'},
> >     Address1              => $ARGS{'Address1'},
> >     Address2              => $ARGS{'Address2'},
> >     City                  => $ARGS{'City'},
> >     State                 => $ARGS{'State'},
> >     Zip                   => $ARGS{'Zip'},
> >     Country               => $ARGS{'Country'},
> >     Privileged           => $ARGS{'Privileged'},
> >     Disabled            => ($ARGS{'Enabled'} ? 0 : 1)
> > );
> >
> >
> > I really appreciate for your help.
> >
> > Thanks,
> > Eduardo 
> _______________________________________________
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel

-- 
===========================================================
Peter C. Lai                 | Bard College at Simon's Rock
Systems Administrator        | 84 Alford Rd.
Information Technology Svcs. | Gt. Barrington, MA 01230 USA
peter AT simons-rock.edu     | (413) 528-7428
===========================================================