The user_idnr is an auto-increment number. The database assigns that integer automatically. Then you use that number to create the rest of what you need. I had a perl script at one point to do this which would give you the queries that you needed. Most of them are pretty well documented though. As I recall there was a listing of the queries used somewhere. I just don't remember where.
Curtis Jorge Bastos wrote: > Hi, > > I'm going to develop a web interface to create user accounts, change > password's etc etc. > For the change password method i don't have any doubt but about the user > creation... i have some. > So, i have to insert values to the dbmail_users table, the "user_idnr" > field, can i just pick the available number that i want? about the rest of > the fields i don't have any doubt. > > Next, i have to create a record in the "dbmail_mailboxes" table, the > "mailbox_idnr" field can be just any available number? the "owner_idnr" is > the "user_idnr" that i've created for the "dbmail_users" table right? and > them i need to complete the record for this table with the "name" field > with the value "INBOX" just like the dbmail-users utility does, am i > right? and for the rest of the fields, 1 as value for all less > "no_inferiors" and "no_select" with value 0 and "permission" with value 2, > right? at least these are the values that the command like utility > creates. > > So far i think i'm going good, do i need to create something else? > > Thanks in advanced, > Jorge > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
