[Asterisk-Users] Re: [Asterisk-Dev] voicemessages table

[harry gaillac]

I agree you however i solved my problem with
app_voicemail.c

The table scheme provide in doc/README.odbcstorage
don't match to sql queries in app_voicemail.c

I think developpers who has written app_voicemail.c
for ARA provide a useable table !

Regards
Harry

--- Steve McMahon <voip at digitaldatabits.net> a écrit :

> These questions should be sent to Asterisk-Users
> this is not a developer
> issue.
> 
> Cheer's
> Steve McMahon
> ----- Original Message ----- 
> From: "harry gaillac" <gaillacharry at yahoo.fr>
> To: <asterisk-dev at lists.digium.com>
> Sent: Monday, August 29, 2005 9:18 AM
> Subject: [Asterisk-Dev] voicemessages table
> 
> 
> > 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
> > _______________________________________________
> > Asterisk-Dev mailing list
> > Asterisk-Dev at lists.digium.com
> >
>
http://lists.digium.com/mailman/listinfo/asterisk-dev
> > To UNSUBSCRIBE or update options visit:
> >   
>
http://lists.digium.com/mailman/listinfo/asterisk-dev
> 
> _______________________________________________
> Asterisk-Dev mailing list
> Asterisk-Dev at lists.digium.com
>
http://lists.digium.com/mailman/listinfo/asterisk-dev
> To UNSUBSCRIBE or update options visit:
>   
>
http://lists.digium.com/mailman/listinfo/asterisk-dev
> 



	

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