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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 _______________________________________________ --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