OCEANET - Cédric BASSAGET
2013-Feb-14 13:44 UTC
[asterisk-users] Asterisk 1.8 mysql tables scheme
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
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 -- Ishfaq Malik <ish at pack-net.co.uk> Department: VOIP Support Company: Packnet Limited t: +44 (0)845 004 4994 f: +44 (0)161 660 9825 e: ish at pack-net.co.uk w: http://www.pack-net.co.uk Registered Address: PACKNET LIMITED, 2A ENTERPRISE HOUSE, LLOYD STREET NORTH, MANCHESTER SCIENCE PARK, MANCHESTER, M156SE COMPANY REG NO. 04920552