[asterisk-users] Realtime Extensions -- Comments?

[Don]

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