asterisk users - Dec 2006 - Question about Realtime static table

Hi All:

I'd like to use Realtime Static in terms of the performance concern
about dynamic realtime. Assume that I create a table:
as following:
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; 

Can anyone help me how to add variable names and values into the
database?

Thanks,

Tielin

This is more of a MySQL question.. But its going to look something like:

ALTER TABLE `extensions_table` ADD `variable_name` <type> DEFAULT
'0'
NOT NULL ; 

>From the specs page:
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html


-----Original Message-----
From: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Tielin Xu
Sent: Tuesday, December 05, 2006 5:23 PM
To: asterisk-users@lists.digium.com
Subject: [asterisk-users] Question about Realtime static table

Hi All:

I'd like to use Realtime Static in terms of the performance concern
about dynamic realtime. Assume that I create a table:
as following:
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; 

Can anyone help me how to add variable names and values into the
database?

Thanks,

Tielin
_______________________________________________
--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