Hi all
 
i'm planing to create a simple application interface to administer subscriber and alias data directly in the mysql db backend (i will use Andreas Granig's userloc-cl module).
Looking at the mysql database that comes with ser, there seem to be a lot of fields in the subscriber and aliases table that are not needed by ser itself but only by serweb. Do i get this right?
If so, is there any specification of the fields that are required by ser (incl. valid value range) so i know which fields i have to administer? Are there any fields needed by ser which i may not touch?
 
If there is no such documentation, maybe someone knows and would be willing to place a few comments to the table listings below?
 
Thanks a lot for your help!
 
Kind regards
Frank
 
 
 
subscriber
------------------------
phplib_id
username
domain
password
first_name
last_name
phone
email_address
datetime_created
datetime_modified
confirmation
flag
sendnotification
greeting
ha1
ha1b
allow_find
timezone
rpid
domn
uuid
 
 
 
aliases
------------------------
username
domain
contact
received
expires
q
callid
cseq
last_modified
replicate
state
flags
user_agent