Re: [hylafax-users] database schema for FaxAccounting

[Lee Howard <faxguy@xxxxxxxxxxxxxxxx>]

marek cervenka wrote:
> hi,
>
> can you someone post db schema for FaxAccounting from 
> http://hylafax.sourceforge.net/howto/misc/FaxAccounting ?
>
> or dump schema from current db
> mysqldump -d hylafax xferfaxlog 

#
# The database table would look something like this:
#
#
# mysql> describe xferfaxlog;
# +-------------+--------------+------+-----+---------+----------------+
# | Field       | Type         | Null | Key | Default | Extra          |
# +-------------+--------------+------+-----+---------+----------------+
# | id          | int(11)      | NO   | PRI | NULL    | auto_increment | 
# | timestamp   | datetime     | NO   | MUL |         |                | 
# | entrytype   | varchar(20)  | YES  |     | NULL    |                | 
# | commid      | varchar(20)  | YES  |     | NULL    |                | 
# | modem       | varchar(20)  | YES  |     | NULL    |                | 
# | jobid       | varchar(20)  | YES  |     | NULL    |                | 
# | jobtag      | varchar(100) | YES  |     | NULL    |                | 
# | user        | char(100)    | YES  |     | NULL    |                | 
# | localnumber | varchar(50)  | YES  |     | NULL    |                | 
# | tsi         | varchar(25)  | YES  |     | NULL    |                | 
# | params      | varchar(20)  | YES  |     | NULL    |                | 
# | npages      | int(11)      | YES  |     | NULL    |                | 
# | jobtime     | time         | NO   |     |         |                | 
# | conntime    | time         | NO   |     |         |                | 
# | reason      | char(200)    | YES  |     | NULL    |                | 
# | CIDName     | char(100)    | YES  |     | NULL    |                | 
# | CIDNumber   | char(100)    | YES  |     | NULL    |                | 
# | callid      | char(200)    | YES  |     | NULL    |                | 
# | owner       | char(50)     | YES  |     | NULL    |                | 
# | dcs         | char(100)    | YES  |     | NULL    |                | 
# | jobinfo     | char(200)    | YES  |     | NULL    |                | 
# +-------------+--------------+------+-----+---------+----------------+
# 21 rows in set (0.01 sec)
# 
# mysql> 
#


Thanks,

Lee.


____________________ HylaFAX(tm) Users Mailing List _______________________
 To subscribe/unsubscribe, click http://lists.hylafax.org/cgi-bin/lsg2.cgi
On UNIX: mail -s unsubscribe hylafax-users-request@xxxxxxxxxxx < /dev/null
 *To learn about commercial HylaFAX(tm) support, mail sales@xxxxxxxxx*