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.