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

[Jan Janak]

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.