<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1522" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Verdana size=2><SPAN class=536204312-20102005>Hi
all</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN class=536204312-20102005>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).</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=536204312-20102005>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?</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=536204312-20102005>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?</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN class=536204312-20102005>If there is no
such documentation, maybe someone knows and would be willing to place a few
comments to the table listings below?</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN class=536204312-20102005>Thanks a lot for
your help!</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN class=536204312-20102005>Kind
regards</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005>Frank</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005>subscriber</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005>------------------------</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2>phplib_id</FONT></DIV>
<DIV><FONT face=Verdana size=2>username</FONT></DIV>
<DIV><FONT face=Verdana size=2>domain</FONT></DIV>
<DIV><FONT face=Verdana size=2>password</FONT></DIV>
<DIV><FONT face=Verdana size=2>first_name</FONT></DIV>
<DIV><FONT face=Verdana size=2>last_name</FONT></DIV>
<DIV><FONT face=Verdana size=2>phone</FONT></DIV>
<DIV><FONT face=Verdana size=2>email_address</FONT></DIV>
<DIV><FONT face=Verdana size=2>datetime_created</FONT></DIV>
<DIV><FONT face=Verdana size=2>datetime_modified</FONT></DIV>
<DIV><FONT face=Verdana size=2>confirmation</FONT></DIV>
<DIV><FONT face=Verdana size=2>flag</FONT></DIV>
<DIV><FONT face=Verdana size=2>sendnotification</FONT></DIV>
<DIV><FONT face=Verdana size=2>greeting</FONT></DIV>
<DIV><FONT face=Verdana size=2>ha1</FONT></DIV>
<DIV><FONT face=Verdana size=2>ha1b</FONT></DIV>
<DIV><FONT face=Verdana size=2>allow_find</FONT></DIV>
<DIV><FONT face=Verdana size=2>timezone</FONT></DIV>
<DIV><FONT face=Verdana size=2>rpid</FONT></DIV>
<DIV><FONT face=Verdana size=2>domn</FONT></DIV>
<DIV><FONT face=Verdana size=2>uuid</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005>aliases</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005>------------------------</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005>username</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005>domain</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005>contact</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005>received</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005>expires</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005>q</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005>callid</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005>cseq</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=536204312-20102005>last_modified</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2>replicate</FONT></DIV>
<DIV><FONT face=Verdana size=2>state</FONT></DIV>
<DIV><FONT face=Verdana size=2>flags</FONT></DIV>
<DIV><FONT face=Verdana size=2>user_agent</FONT></DIV></BODY></HTML>