[Serusers] Which database fields (table subscriber and aliases) are needed by ser?
Jan Janak
jan at iptel.org
Thu Oct 20 15:33:59 CEST 2005
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.
More information about the sr-users
mailing list