[asterisk-users] Realtime Extensions -- Comments?

Douglas Garstang dgarstang at oneeighty.com
Tue Aug 22 10:24:43 MST 2006


Yes, but that doesn't stop Asterisk from still treating that row as a valid extension.

> -----Original Message-----
> From: Don [mailto:sales at xwebfactor.com]
> Sent: Tuesday, August 22, 2006 10:38 AM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [asterisk-users] Realtime Extensions -- Comments?
> 
> 
> He meant he added another column in the database table...
> In the asterisk source everything database related for the 
> default database 
> stuff is explicitly named...
> Like INSERT INTO blah(col1,col2,col3) Values(foo,foo,foo)
> 
> ----- Original Message ----- 
> From: "Douglas Garstang" <dgarstang at oneeighty.com>
> To: "Asterisk Users Mailing List - Non-Commercial Discussion" 
> <asterisk-users at lists.digium.com>
> Sent: Tuesday, August 22, 2006 12:14 PM
> Subject: RE: [asterisk-users] Realtime Extensions -- Comments?
> 
> 
> >> -----Original Message-----
> >> From: Jason Parker [mailto:jparker at digium.com]
> >> Sent: Tuesday, August 22, 2006 9:57 AM
> >> To: Asterisk Users Mailing List - Non-Commercial Discussion
> >> Subject: Re: [asterisk-users] Realtime Extensions -- Comments?
> >>
> >>
> >> ----- Douglas Garstang <dgarstang at oneeighty.com> wrote:
> >> > The unofficial docs on the voip wiki for the realtime
> >> extensions table
> >> > structure is:
> >> >
> >> > CREATE TABLE `extensions_table` (
> >> >  `id` int(11) NOT NULL auto_increment,
> >> >  `context` varchar(20) NOT NULL default '',
> >> >  `exten` varchar(20) NOT NULL default '',
> >> >  `priority` tinyint(4) NOT NULL default '0',
> >> >  `app` varchar(20) NOT NULL default '',
> >> >  `appdata` varchar(128) NOT NULL default '',
> >> >  PRIMARY KEY  (`context`,`exten`,`priority`),
> >> >  KEY `id` (`id`)
> >> > ) TYPE=MyISAM;
> >> >
> >> > Uhm... what abouts comments? What if I wanted to temporarily
> >> > deactivate a couple of extensions? Without a comment flag,
> >> I'd have to
> >> > completely remove those entries from the extensions table!
> >> That's not
> >> > very friendly is it... Is there a better way?
> >> >
> >> > Doug.
> >> > _______________________________________________
> >> > --Bandwidth and Colocation provided by Easynews.com --
> >> >
> >> > asterisk-users mailing list
> >> > To UNSUBSCRIBE or update options visit:
> >> >    http://lists.digium.com/mailman/listinfo/asterisk-users
> >>
> >> I cheated, and just added a comments field to the table.
> >> Asterisk only reads fields by name, so extra columns don't
> >> hurt at all.
> >
> > How did an extra field that Asterisk doesn't know anything 
> about, change 
> > it's behaviour?
> >
> > Doug.
> >
> 
> 
> --------------------------------------------------------------
> ------------------
> 
> 
> > _______________________________________________
> > --Bandwidth and Colocation provided by Easynews.com --
> >
> > asterisk-users mailing list
> > To UNSUBSCRIBE or update options visit:
> >   http://lists.digium.com/mailman/listinfo/asterisk-users
> >
> 
> 
> --------------------------------------------------------------
> ------------------
> 
> 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.405 / Virus Database: 268.11.5/425 - Release 
> Date: 8/22/2006
> 
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> 


More information about the asterisk-users mailing list