[Asterisk-Dev] voicemessages table

[harry gaillac]

hello,

I got some errors with voicemessages table in
docs/README.odbcstorage :
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default
| Extra |
+----------------+-------------+------+-----+---------+-------+
| msgnum         | int(11)     | YES  |     | NULL   
|       |
| dir            | varchar(80) | YES  | MUL | NULL   
|       |
| context        | varchar(80) | YES  |     | NULL   
|       |
| macrocontext   | varchar(80) | YES  |     | NULL   
|       |
| callerid       | varchar(40) | YES  |     | NULL   
|       |
| origtime       | varchar(40) | YES  |     | NULL   
|       |
| duration       | varchar(20) | YES  |     | NULL   
|       |
| mailboxuser    | varchar(80) | YES  |     | NULL   
|       |*
| mailboxcontext | varchar(80) | YES  |     | NULL   
|       |*
| recording      | longblob    | YES  |     | NULL   
|       |
+----------------+-------------+------+-----+---------+-------+

according to app_voicemail.c i set
mysql> desc voicemessages;
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default
| Extra |
+----------------+-------------+------+-----+---------+-------+
| dir            | varchar(80) | YES  | MUL | NULL   
|       |
| msgnum         | int(11)     | YES  |     | NULL   
|       |
| recording      | longblob    | YES  |     | NULL   
|       |
| context        | varchar(80) | YES  |     | NULL   
|       |
| macrocontext   | varchar(80) | YES  |     | NULL   
|       |
| callerid       | varchar(40) | YES  |     | NULL   
|       |
| origtime       | varchar(40) | YES  |     | NULL   
|       |
| duration       | varchar(20) | YES  |     | NULL   
|       |
| mailboxuser    | varchar(80) | YES  |     | NULL   
|       |
| mailboxcontext | varchar(80) | YES  |     | NULL   
|       |
+----------------+-------------+------+-----+---------+-------+
10 rows in set (0.00 sec)

Harry



	

	
		
___________________________________________________________________________ 
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
Téléchargez cette version sur http://fr.messenger.yahoo.com