[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