So I am writing a small Java api to add / edit /remove / list users in DBMail.
I tailed the mysql logs for the inserts. So far it looks like: // INSERT USER INSERT INTO dbmail_users (userid,passwd,client_idnr,maxmail_size,encryption_type, last_login) VALUES ('[userid]','[password]',WHAT IS THIS,'26214400','', CURRENT_TIMESTAMP) // GET USER_IDNR [user_idnr] = SELECT user_idnr FROM dbmail_users WHERE userid='[userid]' // CREATE MAILBOX FOR USER_IDNR INSERT INTO dbmail_mailboxes (name, owner_idnr,seen_flag, answered_flag, deleted_flag, flagged_flag, recent_flag, draft_flag, permission) VALUES ('INBOX', '[user_idnr]', 1, 1, 1, 1, 1, 1, 2) // CREATE MAILBOX ALIAS INSERT INTO dbmail_aliases (alias,deliver_to,client_idnr) VALUES ('[user email address]','[user_idnr]','[WHAT IS THIS]') Can someone help me fill in the blanks on the [WHAT IS THAT] stuff... and any query holes? - Kevin __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com