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

Eduardo Cerqueira eduardomcerqueira at gmail.com
Tue Feb 9 14:17:39 EST 2010


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.bestpractical.com/pipermail/rt-devel/attachments/20100209/764fb330/attachment.htm 


More information about the Rt-devel mailing list