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
