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.