
Hi Guys, Can someone explain me what the ValidID and UserID is? I am assuming UserID is the numeric ID of the user, and ValidID? Is this the ID of the user creating the record? thanks for clearification. best regards -- Atif Ghaffar ---------------------------. +41 78 845 31 64 ¦ tel aghaffar@developer.ch ¦ email http://atifghaffar.com ¦ www 8206786 ¦ icq

Hi Atif, On Tue, Jun 04, 2002 at 02:09:20AM +0200, Atif Ghaffar wrote:
Can someone explain me what the ValidID and UserID is?
I am assuming UserID is the numeric ID of the user, and ValidID? Is this the ID of the user creating the record?
Right, UserID is a numeric ID (auto increment). ValidID --> the validity of the data record (valid|invalid|invalid-temporarily). Example: If you would delete a user (or queue, ...) from the database you will run in trouble if the application is working with database id references (a good database design is working with references). So set the data record to invalid an the record is still visible (e. g. for ticket history, ...) but not activ for the application. --> ValidID is a reference to the table "valid". ==> If a user is invalid (or invalid-temporarily), the user can't login or work with the system. Use invalid-temporarily if you get no money from a user/company for the ASP-solution. Use invalid for RIP.
-- Atif Ghaffar
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Noch 102 Tage bis zum Gäubodenvolksfest! ;-)

Hi Martin, thanks for the informations. So, CreateUser went fine. And Group? There is no Groups.pm Do you want to me to do one? best regards Martin Edenhofer wrote:
Hi Atif,
On Tue, Jun 04, 2002 at 02:09:20AM +0200, Atif Ghaffar wrote:
Can someone explain me what the ValidID and UserID is?
I am assuming UserID is the numeric ID of the user, and ValidID? Is this the ID of the user creating the record?
Right, UserID is a numeric ID (auto increment).
ValidID --> the validity of the data record (valid|invalid|invalid-temporarily).
Example: If you would delete a user (or queue, ...) from the database you will run in trouble if the application is working with database id references (a good database design is working with references). So set the data record to invalid an the record is still visible (e. g. for ticket history, ...) but not activ for the application.
--> ValidID is a reference to the table "valid".
==> If a user is invalid (or invalid-temporarily), the user can't login or work with the system. Use invalid-temporarily if you get no money from a user/company for the ASP-solution. Use invalid for RIP.
-- Atif Ghaffar
Martin
-- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Noch 102 Tage bis zum Gäubodenvolksfest! ;-) _______________________________________________ OpenTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
-- Atif Ghaffar ---------------------------. +41 78 845 31 64 ¦ tel aghaffar@developer.ch ¦ email http://atifghaffar.com ¦ www 8206786 ¦ icq

Hi Atif, On Tue, Jun 04, 2002 at 04:23:20AM +0200, Atif Ghaffar wrote:
thanks for the informations.
So, CreateUser went fine. And Group?
There is no Groups.pm
Do you want to me to do one?
Why not? :-)
Atif Ghaffar
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "The number of Unix installations has grown to 10, with more expected." The Unix Programmer's Manual, 2nd Edition, June 1972
participants (2)
-
Atif Ghaffar
-
Martin Edenhofer