On 20-10-2005 15:14, Frank Fischer wrote:
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?
Yes.
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 -- Will be droped in the future
username -- Needed by ser (auth_db module)
domain -- Needed by ser (auth_db module)
password -- Needed by ser (auth_db module)
first_name -- serweb only
last_name -- serweb only
phone -- serweb only
email_address -- serweb and sems (voicemail)
datetime_created -- not needed
datetime_modified -- not needed
confirmation -- serweb only
flag -- serweb (and optionaly ser)
sendnotification -- serweb only
greeting -- serweb only
ha1 -- ser (auth_db module)
ha1b -- ser (auth_db module)
allow_find -- serweb only
timezone -- serweb and ser
rpid -- ser
domn -- not needed at the moment
uuid -- will be used in the future by serweb and ser
aliases
------------------------
username
domain
contact
received
expires
q
callid
cseq
last_modified -- not needed
replicate -- not needed
state
flags
user_agent
Jan.