Fast overview....of SER's tables:
*acc* acounting purpouses. If you are using acc modules, transactions will be logged here.
*active_sessions* used by SERWEB to know current active sessions, not sure if it's populated via acc
*admin_privileges* used by SERWEB to set permissions to the web interface
*aliases* used by the lookup("aliases") call and usually populated via serctl. It contains the aliases :P
*calls_forwarding* Not sure but used by SERWEB(?) when you configure call forward...
*config* SERWEB stuff
*domain* Table used in multi-domain setups since it contains the domains that will return true for the calls of the module domain.
*event* ????SERWEB
*grp* Table used in the is_user_in calls to check which groups the users belogns to.
*location* table containing the current maping of the registrar module, which stores here the entries with save() config calls.
*missed_calls* acc logs here missed calls to be shown via SERWEB
*pending* acc logs here pending calls to be shown via SERWEB
*phonebook* SERWEB stuff. Used whenever users set their phonebook via the web interface...
*preferences_types* ????
*reserved* ??????
*server_monitoring* SERWEB
*server_monitoring_agg* SERWEB
*silo* table storing IM for non-registered users...
*speed_dial* table containing the speeddial module mapings. Required for sd_lookup() calls. It can be populated via SERWEB.
*subscriber* Table containing "customers" (username/password) used in auth_db calls such as {www|proxy}_authorize. Populated via serctl|SERWEB
*trusted* Table containing the "IPs" which SER setup has to trust. Used by permission module, this table is required for allow_trusted and so calls..
*uri* Used by the uri_db module...check_to() and related..
*usr_preferences* apv_ops module
*version* Internal SER table containg the version of the rest of tables to avoid incompatibility problems between different SER versions and DB backends..
Hope someone can confirm what I've written and expand the info...
Samuel.
2006/10/3, Nick Hoffman nick.hoffman@voxpak.com:
On Tue September 26 2006 20:40, Kamal.Mann@t-systems.com wrote:
Hi All
I need to understand what each table is used for, as well as when and why each table is populated. This will enable me to make projections on how much data will be stored in the database in the coming days & what is the use of each n every table. Is there any current discussion going in or any document??
Kamal Mann
Hi Kamal. Did you receive any responses to your email asking about SER's database?
Cheers, -- Nick e: nick.hoffman@voxpak.com p: +61 7 5591 3588 f: +61 7 5591 6588
If you receive this email by mistake, please notify us and do not make any use of the email. We do not waive any privilege, confidentiality or copyright associated with it. _______________________________________________ Serusers mailing list Serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers