[asterisk-users] Asterisk 1.8 mysql tables scheme

[OCEANET - Cédric BASSAGET]

Thanks a lot four your reply.

Cédric


Le 14/02/2013 15:26, Ishfaq Malik a écrit :
> On Thu, 2013-02-14 at 14:44 +0100, OCEANET - Cédric BASSAGET wrote:
>> Hi all,
>>
>> Does anybody know where it is possible to find latest mysql tables
>> schemes for asterisk 1.8 ?
>> I'm looking for the "queues" one, but it's not provided anymore in
>> asterisk sourcecode :
>>
>>
>> # ls /usr/local/src/asterisk-1.8.20.1/contrib/realtime/mysql/ -1
>> iaxfriends.sql
>> meetme.sql
>> musiconhold.sql
>> queue_log.sql
>> sippeers.sql
>> voicemail_data.sql
>> voicemail_messages.sql
>> voicemail.sql
>>
>>
>>
>> Thanks for your replies.
>> Cédric
>>
>> --
> Hi
>
> I know it's not exactly what you're asking for but this is what we have
> got working with 1.8.18
>
> CREATE TABLE `queues` (
>    `name` varchar(128) NOT NULL,
>    `musiconhold` varchar(128) DEFAULT NULL,
>    `announce` varchar(128) DEFAULT NULL,
>    `context` varchar(128) DEFAULT NULL,
>    `timeout` int(11) DEFAULT NULL,
>    `monitor_join` tinyint(1) DEFAULT NULL,
>    `monitor_format` varchar(128) DEFAULT NULL,
>    `queue_youarenext` varchar(128) DEFAULT NULL,
>    `queue_thereare` varchar(128) DEFAULT NULL,
>    `queue_callswaiting` varchar(128) DEFAULT NULL,
>    `queue_holdtime` varchar(128) DEFAULT NULL,
>    `queue_minutes` varchar(128) DEFAULT NULL,
>    `queue_seconds` varchar(128) DEFAULT NULL,
>    `queue_lessthan` varchar(128) DEFAULT NULL,
>    `queue_thankyou` varchar(128) DEFAULT NULL,
>    `queue_reporthold` varchar(128) DEFAULT NULL,
>    `announce_frequency` int(11) DEFAULT NULL,
>    `announce_position` varchar(10) DEFAULT NULL,
>    `announce_round_seconds` int(11) DEFAULT NULL,
>    `announce_holdtime` varchar(128) DEFAULT NULL,
>    `retry` int(11) DEFAULT NULL,
>    `wrapuptime` int(11) DEFAULT NULL,
>    `maxlen` int(11) DEFAULT NULL,
>    `servicelevel` int(11) DEFAULT NULL,
>    `strategy` varchar(128) DEFAULT NULL,
>    `joinempty` varchar(128) DEFAULT NULL,
>    `leavewhenempty` varchar(128) DEFAULT NULL,
>    `eventmemberstatus` tinyint(1) DEFAULT NULL,
>    `eventwhencalled` tinyint(1) DEFAULT NULL,
>    `reportholdtime` tinyint(1) DEFAULT NULL,
>    `memberdelay` int(11) DEFAULT NULL,
>    `weight` int(11) DEFAULT NULL,
>    `timeoutrestart` tinyint(1) DEFAULT NULL,
>    `periodic_announce` varchar(50) DEFAULT NULL,
>    `periodic_announce_frequency` int(11) DEFAULT NULL,
>    `ringinuse` tinyint(1) DEFAULT NULL,
>    `setinterfacevar` tinyint(1) DEFAULT NULL,
>    PRIMARY KEY (`name`)
> );
>
> BTW, the queue_log.sql file is incorrect. The time column needs to be a varchar (or char) type, not a datetime
>
> Hope this helps
>
> Ish
>


-- 
OCEANET
---------------------------------------------------------------
[AGENCE DU MANS]
7, rue des Frênes
ZAC de la Pointe
72190 SARGE LES LE MANS
[t] +33 (0)2.43.50.26.50
[f] +33 (0)2.43.72.21.14

[AGENCE D'ANGERS]
5, rue Fleming
Angers Technopole
49066 ANGERS
[t] +33 (0)2.41.19.28.65
[f] +33 (0)2.52.19.22.00

http://www.oceanet.com
http://www.oceanet-telecom.com