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
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
