bonjour

je ne comprend pas pourquoi la colonne calldate n'est pas popullée. J'utilise Asterisk 1.8 et mySQL via ODBC

Code:
CREATE TABLE `cdr` (
`calldate` datetime NOT NULL default '0000-00-00 00:00:00',
`clid` varchar(80) NOT NULL default '',
`src` varchar(80) NOT NULL default '',
`dst` varchar(80) NOT NULL default '',
`dcontext` varchar(80) NOT NULL default '',
`channel` varchar(80) NOT NULL default '',
`dstchannel` varchar(80) NOT NULL default '',
`lastapp` varchar(80) NOT NULL default '',
`lastdata` varchar(80) NOT NULL default '',
`duration` int(11) NOT NULL default '0',
`billsec` int(11) NOT NULL default '0',
`disposition` varchar(45) NOT NULL default '',
`amaflags` int(11) NOT NULL default '0',
`accountcode` varchar(20) NOT NULL default '',
`uniqueid` varchar(32) NOT NULL default '',
`userfield` varchar(255) NOT NULL default ''
);

ALTER TABLE `cdr` ADD INDEX ( `calldate` );
ALTER TABLE `cdr` ADD INDEX ( `dst` );
ALTER TABLE `cdr` ADD INDEX ( `accountcode` );
Code:
mysql> select * from cdr
    -> ;
+---------------------+--------------------+------+------+----------+-------------------+------------+---------+----------+----------+---------+-------------+----------+-------------+--------------+-----------+
| calldate            | clid               | src  | dst  | dcontext | channel           | dstchannel | lastapp | lastdata | duration | billsec | disposition | amaflags | accountcode | uniqueid     | userfield |
+---------------------+--------------------+------+------+----------+-------------------+------------+---------+----------+----------+---------+-------------+----------+-------------+--------------+-----------+
| 0000-00-00 00:00:00 | "SoftPhone" <1001> | 1001 | **34 | Interne  | SIP/1001-00000001 |            | Hangup  |          |        3 |       3 | ANSWERED    |        3 |             | 1289875844.1 |           |
| 0000-00-00 00:00:00 | "SoftPhone" <1001> | 1001 | **34 | Interne  | SIP/1001-00000000 |            | Hangup  |          |        2 |       2 | ANSWERED    |        3 |             | 1289876820.0 |           |
+---------------------+--------------------+------+------+----------+-------------------+------------+---------+----------+----------+---------+-------------+----------+-------------+--------------+-----------+
2 rows in set (0.00 sec)

mysql>