[Serusers] Which database fields (table subscriber and aliases) are needed by ser?

Frank Fischer frank.fischer at digitalnomads.ch
Thu Oct 20 15:14:46 CEST 2005


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20051020/0084eb01/attachment.htm>


More information about the sr-users mailing list