[asterisk-users] Realtime Extensions -- Comments?

Jason Parker jparker at digium.com
Tue Aug 22 08:57:28 MST 2006


----- 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.

That is, iirc..

-- 
Jason Parker
Digium




More information about the asterisk-users mailing list