Hi Daniel.
There it goes:
mysql> desc location;
+---------------+------------------+------+-----+---------------------+----------------+
| Field |
Type
| Null | Key |
Default
| Extra |
+---------------+------------------+------+-----+---------------------+----------------+
| id
| int(10) unsigned | NO | PRI |
NULL
| auto_increment |
| username |
varchar(64) | NO | MUL
|
|
|
| domain |
varchar(128) | NO
|
|
|
|
| contact |
varchar(255) | NO
|
|
|
|
| received |
varchar(255) | YES
| |
NULL
|
|
| path |
varchar(255) | YES
| |
NULL
|
|
| expires |
datetime |
NO | | 2020-05-28 21:32:15
|
|
|
q
| float(10,2) | NO
| |
1.00
|
|
| callid |
varchar(255) | NO
| | Default-Call-ID
|
|
| cseq |
int(11) |
NO | |
13
|
|
| last_modified |
datetime |
NO | | 1900-01-01 00:00:00
|
|
| flags |
int(11) |
NO | |
0
|
|
| cflags |
int(11) |
NO | |
0
|
|
| user_agent | varchar(255) |
NO |
|
|
|
| socket |
varchar(128) | YES
| |
NULL
|
|
| methods |
int(11) |
YES | |
NULL
|
|
+---------------+------------------+------+-----+---------------------+----------------+
| location | CREATE TABLE `location` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(64) NOT NULL default '',
`domain` varchar(128) NOT NULL default '',
`contact` varchar(255) NOT NULL default '',
`received` varchar(255) default NULL,
`path` varchar(255) default NULL,
`expires` datetime NOT NULL default '2020-05-28 21:32:15',
`q` float(10,2) NOT NULL default '1.00',
`callid` varchar(255) NOT NULL default 'Default-Call-ID',
`cseq` int(11) NOT NULL default '13',
`last_modified` datetime NOT NULL default '1900-01-01 00:00:00',
`flags` int(11) NOT NULL default '0',
`cflags` int(11) NOT NULL default '0',
`user_agent` varchar(255) NOT NULL default '',
`socket` varchar(128) default NULL,
`methods` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `udc_loc` (`username`,`domain`,`contact`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 |
mysql> select * from location;
+----+----------+--------+---------------------------------+----------+------+---------------------+-------+-------------------------------------------+------+---------------------+-------+--------+--------------------------------------------+--------------------------+---------+
| id | username | domain |
contact
| received | path |
expires
| q |
callid
| cseq | last_modified | flags |
cflags |
user_agent
|
socket
| methods |
+----+----------+--------+---------------------------------+----------+------+---------------------+-------+-------------------------------------------+------+---------------------+-------+--------+--------------------------------------------+--------------------------+---------+
| 13 | 3950031 | |
sip:3950031@192.168.198.10:5060 | NULL | NULL |
2007-03-27 00:46:08 | -1.00 | 5e897d38-ce5af712-6f3a7b51@192.168.198.10
| 75 | 2007-03-27 00:45:08 | 0
| 0 |
PolycomSoundPointIP-SPIP_300-UA/1.6.5.0043 | udp:192.168.199.200:5060
| 8063 |
+----+----------+--------+---------------------------------+----------+------+---------------------+-------+-------------------------------------------+------+---------------------+-------+--------+--------------------------------------------+--------------------------+---------+
The last information is the record I have stored.
Kind regards.