[Freeswitch-svn] [commit] r8079 - in freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl: . configuration sql

Freeswitch SVN intralanman at freeswitch.org
Thu Apr 10 00:49:07 EDT 2008


Author: intralanman
Date: Thu Apr 10 00:49:07 2008
New Revision: 8079

Modified:
   freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/configuration/spidermonkey.conf.php
   freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_dialplan.php
   freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_directory.php
   freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-4.0.sql
   freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0-with-samples.sql
   freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0.sql

Log:
a couple updates to allow mailboxes in schema and php (thanks to dasbus)
fixed typo in spidermonkey (thanks to danchris)
and fixed a pretty old boo boo where attribute continue was in condition instead of break


Modified: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/configuration/spidermonkey.conf.php
==============================================================================
--- freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/configuration/spidermonkey.conf.php	(original)
+++ freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/configuration/spidermonkey.conf.php	Thu Apr 10 00:49:07 2008
@@ -26,7 +26,7 @@
 
     private function get_params() {
         return array(
-        'mod_spidermonkey_teleone',
+        'mod_spidermonkey_teletone',
         'mod_spidermonkey_odbc',
         'mod_spidermonkey_core_db'
         );

Modified: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_dialplan.php
==============================================================================
--- freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_dialplan.php	(original)
+++ freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_dialplan.php	Thu Apr 10 00:49:07 2008
@@ -59,7 +59,7 @@
             $cf = $row['condition_field'];
             $ce = $row['condition_expression'];
             $rcd = $row['re_cdata'];
-            $cc = empty($row['condition_continue']) ? '0' : $row['condition_continue'];
+            $cc = empty($row['cond_break']) ? '0' : $row['cond_break'];
             $dp_array[$ct]["$et;$ec"]["$cf;$ce;$cc;$rcd"][] = array(
             'type'=>$type,
             'application'=>$app,
@@ -120,7 +120,7 @@
                             //$this -> debug($c_split[2]);
                             if ($c_split[2] != '0') {
                                 $this -> xmlw -> writeAttribute(
-                                'continue', $c_split[2]
+                                'break', $c_split[2]
                                 );
                             }
                             //$this -> debug($app_array);

Modified: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_directory.php
==============================================================================
--- freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_directory.php	(original)
+++ freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/fs_directory.php	Thu Apr 10 00:49:07 2008
@@ -261,8 +261,11 @@
         $this -> write_global_vars();
 
         for ($i=0; $i<$directory_count; $i++) {
+            $username = $directory[$i]['username'];
+            $mailbox = empty($directory[$i]['mailbox']) ? $username : $directory[$i]['mailbox'];
             $this -> xmlw -> startElement('user');
-            $this -> xmlw -> writeAttribute('id', $directory[$i]['username']);
+            $this -> xmlw -> writeAttribute('id', $username);
+            $this -> xmlw -> writeAttribute('mailbox', $mailbox);
             $this -> write_params($directory[$i]['id']);
             $this -> write_variables($directory[$i]['id']);
             $this -> write_gateways($directory[$i]['id']);

Modified: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-4.0.sql
==============================================================================
--- freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-4.0.sql	(original)
+++ freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-4.0.sql	Thu Apr 10 00:49:07 2008
@@ -1,524 +1,625 @@
--- MySQL dump 10.11
---
--- Host: localhost    Database: freeswitch
--- ------------------------------------------------------
--- Server version	5.0.45-community-nt
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL40' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `conference_advertise`
---
-
-DROP TABLE IF EXISTS `conference_advertise`;
-CREATE TABLE `conference_advertise` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `room` varchar(64) NOT NULL,
-  `status` varchar(128) NOT NULL,
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `unique_room` (`room`)
-) TYPE=InnoDB AUTO_INCREMENT=8;
-
---
--- Table structure for table `conference_controls`
---
-
-DROP TABLE IF EXISTS `conference_controls`;
-CREATE TABLE `conference_controls` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `conf_group` varchar(64) NOT NULL,
-  `action` varchar(64) NOT NULL,
-  `digits` varchar(16) NOT NULL,
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `unique_group_action` (`conf_group`,`action`)
-) TYPE=InnoDB AUTO_INCREMENT=25;
-
---
--- Table structure for table `conference_profiles`
---
-
-DROP TABLE IF EXISTS `conference_profiles`;
-CREATE TABLE `conference_profiles` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `profile_name` varchar(64) NOT NULL,
-  `param_name` varchar(64) NOT NULL,
-  `param_value` varchar(64) NOT NULL,
-  PRIMARY KEY  (`id`),
-  KEY `unique_profile_param` (`profile_name`,`param_name`)
-) TYPE=InnoDB AUTO_INCREMENT=13;
-
---
--- Table structure for table `db_data`
---
-
-DROP TABLE IF EXISTS `db_data`;
-CREATE TABLE `db_data` (
-  `hostname` varchar(255) default NULL,
-  `realm` varchar(255) default NULL,
-  `data_key` varchar(255) default NULL,
-  `data` varchar(255) default NULL
-) TYPE=MyISAM;
-
---
--- Table structure for table `dialplan`
---
-
-DROP TABLE IF EXISTS `dialplan`;
-CREATE TABLE `dialplan` (
-  `id` int(11) NOT NULL auto_increment,
-  `context` varchar(64) NOT NULL,
-  `extension` varchar(64) NOT NULL,
-  `condition_field` varchar(64) NOT NULL,
-  `condition_expression` varchar(64) NOT NULL,
-  `application_name` varchar(64) NOT NULL,
-  `application_data` text,
-  `weight` int(11) NOT NULL,
-  `type` varchar(16) NOT NULL default 'action',
-  `ext_continue` smallint(1) NOT NULL default '0',
-  `global_weight` int(11) NOT NULL default '10000',
-  `condition_continue` varchar(8) default NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM AUTO_INCREMENT=112;
-
---
--- Table structure for table `dingaling_profile_params`
---
-
-DROP TABLE IF EXISTS `dingaling_profile_params`;
-CREATE TABLE `dingaling_profile_params` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `dingaling_id` int(10) unsigned NOT NULL,
-  `param_name` varchar(64) NOT NULL,
-  `param_value` varchar(64) NOT NULL,
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `unique_type_name` (`dingaling_id`,`param_name`),
-  CONSTRAINT `dingaling_profile` FOREIGN KEY (`dingaling_id`) REFERENCES `dingaling_profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
-) TYPE=InnoDB AUTO_INCREMENT=5;
-
---
--- Table structure for table `dingaling_profiles`
---
-
-DROP TABLE IF EXISTS `dingaling_profiles`;
-CREATE TABLE `dingaling_profiles` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `profile_name` varchar(64) NOT NULL,
-  `type` varchar(64) NOT NULL,
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `unique_name` (`profile_name`)
-) TYPE=InnoDB AUTO_INCREMENT=3;
-
---
--- Table structure for table `dingaling_settings`
---
-
-DROP TABLE IF EXISTS `dingaling_settings`;
-CREATE TABLE `dingaling_settings` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `param_name` varchar(64) NOT NULL,
-  `param_value` varchar(64) NOT NULL,
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `unique_param` (`param_name`)
-) TYPE=InnoDB AUTO_INCREMENT=3;
-
---
--- Table structure for table `directory`
---
-
-DROP TABLE IF EXISTS `directory`;
-CREATE TABLE `directory` (
-  `id` int(11) NOT NULL auto_increment,
-  `username` varchar(255) NOT NULL,
-  `domain` varchar(255) NOT NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM AUTO_INCREMENT=5;
-
---
--- Table structure for table `directory_gateway_params`
---
-
-DROP TABLE IF EXISTS `directory_gateway_params`;
-CREATE TABLE `directory_gateway_params` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `d_gw_id` int(10) unsigned NOT NULL,
-  `param_name` varchar(64) NOT NULL,
-  `param_value` varchar(64) NOT NULL,
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `unique_gw_param` (`d_gw_id`,`param_name`)
-) TYPE=InnoDB AUTO_INCREMENT=10;
-
---
--- Table structure for table `directory_gateways`
---
-
-DROP TABLE IF EXISTS `directory_gateways`;
-CREATE TABLE `directory_gateways` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `directory_id` int(10) unsigned NOT NULL,
-  `gateway_name` varchar(128) NOT NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=InnoDB AUTO_INCREMENT=4;
-
---
--- Table structure for table `directory_params`
---
-
-DROP TABLE IF EXISTS `directory_params`;
-CREATE TABLE `directory_params` (
-  `id` int(11) NOT NULL auto_increment,
-  `directory_id` int(11) default NULL,
-  `param_name` varchar(255) default NULL,
-  `param_value` varchar(255) default NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=InnoDB AUTO_INCREMENT=6;
-
---
--- Table structure for table `directory_vars`
---
-
-DROP TABLE IF EXISTS `directory_vars`;
-CREATE TABLE `directory_vars` (
-  `id` int(11) NOT NULL auto_increment,
-  `directory_id` int(11) default NULL,
-  `var_name` varchar(255) default NULL,
-  `var_value` varchar(255) default NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM AUTO_INCREMENT=6;
-
---
--- Table structure for table `group_data`
---
-
-DROP TABLE IF EXISTS `group_data`;
-CREATE TABLE `group_data` (
-  `hostname` varchar(255) default NULL,
-  `groupname` varchar(255) default NULL,
-  `url` varchar(255) default NULL
-) TYPE=MyISAM;
-
---
--- Table structure for table `iax_conf`
---
-
-DROP TABLE IF EXISTS `iax_conf`;
-CREATE TABLE `iax_conf` (
-  `id` int(11) NOT NULL auto_increment,
-  `profile_name` varchar(255) default NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=InnoDB AUTO_INCREMENT=4;
-
---
--- Table structure for table `iax_settings`
---
-
-DROP TABLE IF EXISTS `iax_settings`;
-CREATE TABLE `iax_settings` (
-  `id` int(11) NOT NULL auto_increment,
-  `iax_id` int(11) default NULL,
-  `param_name` varchar(255) default NULL,
-  `param_value` varchar(255) default NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=InnoDB AUTO_INCREMENT=43;
-
---
--- Table structure for table `ivr_conf`
---
-
-DROP TABLE IF EXISTS `ivr_conf`;
-CREATE TABLE `ivr_conf` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `name` varchar(64) NOT NULL,
-  `greet_long` varchar(255) NOT NULL,
-  `greet_short` varchar(255) NOT NULL,
-  `invalid_sound` varchar(255) NOT NULL,
-  `exit_sound` varchar(255) NOT NULL,
-  `max_failures` int(10) unsigned NOT NULL default '3',
-  `timeout` int(11) NOT NULL default '5',
-  `tts_engine` varchar(64) default NULL,
-  `tts_voice` varchar(64) default NULL,
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `unique_name` (`name`)
-) TYPE=InnoDB AUTO_INCREMENT=4;
-
---
--- Table structure for table `ivr_entries`
---
-
-DROP TABLE IF EXISTS `ivr_entries`;
-CREATE TABLE `ivr_entries` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `ivr_id` int(10) unsigned NOT NULL,
-  `action` varchar(64) NOT NULL,
-  `digits` varchar(16) NOT NULL,
-  `params` varchar(255) default NULL,
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `unique_ivr_digits` (`ivr_id`,`digits`)
-) TYPE=InnoDB AUTO_INCREMENT=11;
-
---
--- Table structure for table `jabber_subscriptions`
---
-
-DROP TABLE IF EXISTS `jabber_subscriptions`;
-CREATE TABLE `jabber_subscriptions` (
-  `sub_from` varchar(255) default NULL,
-  `sub_to` varchar(255) default NULL,
-  `show_pres` varchar(255) default NULL,
-  `status` varchar(255) default NULL
-) TYPE=MyISAM;
-
---
--- Table structure for table `limit_conf`
---
-
-DROP TABLE IF EXISTS `limit_conf`;
-CREATE TABLE `limit_conf` (
-  `id` int(11) NOT NULL auto_increment,
-  `name` varchar(255) default NULL,
-  `value` varchar(255) default NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM AUTO_INCREMENT=2;
-
---
--- Table structure for table `limit_data`
---
-
-DROP TABLE IF EXISTS `limit_data`;
-CREATE TABLE `limit_data` (
-  `hostname` varchar(255) default NULL,
-  `realm` varchar(255) default NULL,
-  `id` varchar(255) default NULL,
-  `uuid` varchar(255) default NULL
-) TYPE=MyISAM;
-
---
--- Table structure for table `local_stream_conf`
---
-
-DROP TABLE IF EXISTS `local_stream_conf`;
-CREATE TABLE `local_stream_conf` (
-  `id` int(11) NOT NULL auto_increment,
-  `directory_name` varchar(255) default NULL,
-  `directory_path` text,
-  `param_name` varchar(255) default NULL,
-  `param_value` varchar(255) default NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
-
---
--- Table structure for table `post_load_modules_conf`
---
-
-DROP TABLE IF EXISTS `post_load_modules_conf`;
-CREATE TABLE `post_load_modules_conf` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `module_name` varchar(64) NOT NULL,
-  `load_module` tinyint(1) NOT NULL default '1',
-  `priority` int(10) unsigned NOT NULL default '1000',
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `unique_mod` (`module_name`)
-) TYPE=InnoDB AUTO_INCREMENT=52;
-
---
--- Table structure for table `rss_conf`
---
-
-DROP TABLE IF EXISTS `rss_conf`;
-CREATE TABLE `rss_conf` (
-  `id` int(11) NOT NULL auto_increment,
-  `directory_id` int(11) NOT NULL,
-  `feed` text NOT NULL,
-  `local_file` text NOT NULL,
-  `description` text,
-  `priority` int(11) NOT NULL default '1000',
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM AUTO_INCREMENT=15;
-
---
--- Table structure for table `sip_authentication`
---
-
-DROP TABLE IF EXISTS `sip_authentication`;
-CREATE TABLE `sip_authentication` (
-  `nonce` varchar(255) default NULL,
-  `expires` int(8) default NULL
-) TYPE=MyISAM;
-
---
--- Table structure for table `sip_registrations`
---
-
-DROP TABLE IF EXISTS `sip_registrations`;
-CREATE TABLE `sip_registrations` (
-  `call_id` varchar(255) default NULL,
-  `sip_user` varchar(255) default NULL,
-  `sip_host` varchar(255) default NULL,
-  `contact` varchar(1024) default NULL,
-  `status` varchar(255) default NULL,
-  `rpid` varchar(255) default NULL,
-  `expires` int(11) default NULL
-) TYPE=MyISAM;
-
---
--- Table structure for table `sip_subscriptions`
---
-
-DROP TABLE IF EXISTS `sip_subscriptions`;
-CREATE TABLE `sip_subscriptions` (
-  `proto` varchar(255) default NULL,
-  `sip_user` varchar(255) default NULL,
-  `sip_host` varchar(255) default NULL,
-  `sub_to_user` varchar(255) default NULL,
-  `sub_to_host` varchar(255) default NULL,
-  `event` varchar(255) default NULL,
-  `contact` varchar(1024) default NULL,
-  `call_id` varchar(255) default NULL,
-  `full_from` varchar(255) default NULL,
-  `full_via` varchar(255) default NULL,
-  `expires` int(11) default NULL
-) TYPE=MyISAM;
-
---
--- Table structure for table `sofia_aliases`
---
-
-DROP TABLE IF EXISTS `sofia_aliases`;
-CREATE TABLE `sofia_aliases` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `sofia_id` int(10) unsigned NOT NULL,
-  `alias_name` varchar(255) NOT NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=InnoDB AUTO_INCREMENT=5;
-
---
--- Table structure for table `sofia_conf`
---
-
-DROP TABLE IF EXISTS `sofia_conf`;
-CREATE TABLE `sofia_conf` (
-  `id` int(11) NOT NULL auto_increment,
-  `profile_name` varchar(255) default NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=InnoDB AUTO_INCREMENT=3;
-
---
--- Table structure for table `sofia_domains`
---
-
-DROP TABLE IF EXISTS `sofia_domains`;
-CREATE TABLE `sofia_domains` (
-  `id` int(11) NOT NULL auto_increment,
-  `sofia_id` int(11) default NULL,
-  `domain_name` varchar(255) default NULL,
-  `parse` tinyint(1) default NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=InnoDB;
-
---
--- Table structure for table `sofia_gateways`
---
-
-DROP TABLE IF EXISTS `sofia_gateways`;
-CREATE TABLE `sofia_gateways` (
-  `id` int(11) NOT NULL auto_increment,
-  `sofia_id` int(11) default NULL,
-  `gateway_name` varchar(255) default NULL,
-  `gateway_param` varchar(255) default NULL,
-  `gateway_value` varchar(255) default NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=InnoDB AUTO_INCREMENT=15;
-
---
--- Table structure for table `sofia_settings`
---
-
-DROP TABLE IF EXISTS `sofia_settings`;
-CREATE TABLE `sofia_settings` (
-  `id` int(11) NOT NULL auto_increment,
-  `sofia_id` int(11) default NULL,
-  `param_name` varchar(255) default NULL,
-  `param_value` varchar(255) default NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=InnoDB AUTO_INCREMENT=35;
-
---
--- Table structure for table `voicemail_conf`
---
-
-DROP TABLE IF EXISTS `voicemail_conf`;
-CREATE TABLE `voicemail_conf` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `vm_profile` varchar(64) NOT NULL,
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `unique_profile` (`vm_profile`)
-) TYPE=InnoDB AUTO_INCREMENT=3;
-
---
--- Table structure for table `voicemail_data`
---
-
-DROP TABLE IF EXISTS `voicemail_data`;
-CREATE TABLE `voicemail_data` (
-  `created_epoch` int(8) default NULL,
-  `read_epoch` int(8) default NULL,
-  `user` varchar(255) default NULL,
-  `domain` varchar(255) default NULL,
-  `uuid` varchar(255) default NULL,
-  `cid_name` varchar(255) default NULL,
-  `cid_number` varchar(255) default NULL,
-  `in_folder` varchar(255) default NULL,
-  `file_path` varchar(255) default NULL,
-  `flags` varchar(255) default NULL,
-  `read_flags` varchar(255) default NULL
-) TYPE=MyISAM;
-
---
--- Table structure for table `voicemail_email`
---
-
-DROP TABLE IF EXISTS `voicemail_email`;
-CREATE TABLE `voicemail_email` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `voicemail_id` int(10) unsigned NOT NULL,
-  `param_name` varchar(64) NOT NULL,
-  `param_value` varchar(64) NOT NULL,
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `unique_profile_param` (`param_name`,`voicemail_id`)
-) TYPE=InnoDB AUTO_INCREMENT=4;
-
---
--- Table structure for table `voicemail_prefs`
---
-
-DROP TABLE IF EXISTS `voicemail_prefs`;
-CREATE TABLE `voicemail_prefs` (
-  `user` varchar(255) default NULL,
-  `domain` varchar(255) default NULL,
-  `name_path` varchar(255) default NULL,
-  `greeting_path` varchar(255) default NULL
-) TYPE=MyISAM;
-
---
--- Table structure for table `voicemail_settings`
---
-
-DROP TABLE IF EXISTS `voicemail_settings`;
-CREATE TABLE `voicemail_settings` (
-  `id` int(11) NOT NULL auto_increment,
-  `voicemail_id` int(11) default NULL,
-  `param_name` varchar(255) default NULL,
-  `param_value` varchar(255) default NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=InnoDB AUTO_INCREMENT=31;
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2008-01-09 23:26:19
+-- MySQL dump 10.11
+--
+-- Host: localhost    Database: freeswitch
+-- ------------------------------------------------------
+-- Server version	5.0.32-Debian_7etch5-log
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL40' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Table structure for table `carrier_gateway`
+--
+
+DROP TABLE IF EXISTS `carrier_gateway`;
+CREATE TABLE `carrier_gateway` (
+  `id` int(11) NOT NULL auto_increment,
+  `carrier_id` int(11) default NULL,
+  `gateway` varchar(32) default NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `gateway` (`gateway`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `carriers`
+--
+
+DROP TABLE IF EXISTS `carriers`;
+CREATE TABLE `carriers` (
+  `id` int(11) NOT NULL auto_increment,
+  `Carrier_Name` varchar(255) default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `conference_advertise`
+--
+
+DROP TABLE IF EXISTS `conference_advertise`;
+CREATE TABLE `conference_advertise` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `room` varchar(64) NOT NULL,
+  `status` varchar(128) NOT NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `unique_room` (`room`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `conference_controls`
+--
+
+DROP TABLE IF EXISTS `conference_controls`;
+CREATE TABLE `conference_controls` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `conf_group` varchar(64) NOT NULL,
+  `action` varchar(64) NOT NULL,
+  `digits` varchar(16) NOT NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `unique_group_action` (`conf_group`,`action`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `conference_profiles`
+--
+
+DROP TABLE IF EXISTS `conference_profiles`;
+CREATE TABLE `conference_profiles` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `profile_name` varchar(64) NOT NULL,
+  `param_name` varchar(64) NOT NULL,
+  `param_value` varchar(64) NOT NULL,
+  PRIMARY KEY  (`id`),
+  KEY `unique_profile_param` (`profile_name`,`param_name`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `db_data`
+--
+
+DROP TABLE IF EXISTS `db_data`;
+CREATE TABLE `db_data` (
+  `hostname` varchar(255) default NULL,
+  `realm` varchar(255) default NULL,
+  `data_key` varchar(255) default NULL,
+  `data` varchar(255) default NULL
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `dialplan`
+--
+
+DROP TABLE IF EXISTS `dialplan`;
+CREATE TABLE `dialplan` (
+  `id` int(11) NOT NULL auto_increment,
+  `context` varchar(64) NOT NULL,
+  `extension` varchar(64) NOT NULL,
+  `condition_field` varchar(64) NOT NULL,
+  `condition_expression` varchar(64) NOT NULL,
+  `application_name` varchar(64) NOT NULL,
+  `application_data` text,
+  `weight` int(11) NOT NULL,
+  `type` varchar(16) NOT NULL default 'action',
+  `ext_continue` smallint(1) NOT NULL default '0',
+  `global_weight` int(11) NOT NULL default '10000',
+  `cond_break` varchar(8) default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `dingaling_profile_params`
+--
+
+DROP TABLE IF EXISTS `dingaling_profile_params`;
+CREATE TABLE `dingaling_profile_params` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `dingaling_id` int(10) unsigned NOT NULL,
+  `param_name` varchar(64) NOT NULL,
+  `param_value` varchar(64) NOT NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `unique_type_name` (`dingaling_id`,`param_name`),
+  CONSTRAINT `dingaling_profile` FOREIGN KEY (`dingaling_id`) REFERENCES `dingaling_profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `dingaling_profiles`
+--
+
+DROP TABLE IF EXISTS `dingaling_profiles`;
+CREATE TABLE `dingaling_profiles` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `profile_name` varchar(64) NOT NULL,
+  `type` varchar(64) NOT NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `unique_name` (`profile_name`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `dingaling_settings`
+--
+
+DROP TABLE IF EXISTS `dingaling_settings`;
+CREATE TABLE `dingaling_settings` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `param_name` varchar(64) NOT NULL,
+  `param_value` varchar(64) NOT NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `unique_param` (`param_name`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `directory`
+--
+
+DROP TABLE IF EXISTS `directory`;
+CREATE TABLE `directory` (
+  `id` int(11) NOT NULL auto_increment,
+  `username` varchar(255) NOT NULL,
+  `mailbox` varchar(255) NOT NULL,
+  `domain` varchar(255) NOT NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `directory_domains`
+--
+
+DROP TABLE IF EXISTS `directory_domains`;
+CREATE TABLE `directory_domains` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `domain_name` varchar(128) NOT NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `directory_gateway_params`
+--
+
+DROP TABLE IF EXISTS `directory_gateway_params`;
+CREATE TABLE `directory_gateway_params` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `d_gw_id` int(10) unsigned NOT NULL,
+  `param_name` varchar(64) NOT NULL,
+  `param_value` varchar(64) NOT NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `unique_gw_param` (`d_gw_id`,`param_name`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `directory_gateways`
+--
+
+DROP TABLE IF EXISTS `directory_gateways`;
+CREATE TABLE `directory_gateways` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `directory_id` int(10) unsigned NOT NULL,
+  `gateway_name` varchar(128) NOT NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `directory_global_params`
+--
+
+DROP TABLE IF EXISTS `directory_global_params`;
+CREATE TABLE `directory_global_params` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `param_name` varchar(64) NOT NULL,
+  `param_value` varchar(128) NOT NULL,
+  `domain_id` int(10) unsigned NOT NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `directory_global_vars`
+--
+
+DROP TABLE IF EXISTS `directory_global_vars`;
+CREATE TABLE `directory_global_vars` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `var_name` varchar(64) NOT NULL,
+  `var_value` varchar(128) NOT NULL,
+  `domain_id` int(10) unsigned NOT NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `directory_params`
+--
+
+DROP TABLE IF EXISTS `directory_params`;
+CREATE TABLE `directory_params` (
+  `id` int(11) NOT NULL auto_increment,
+  `directory_id` int(11) default NULL,
+  `param_name` varchar(255) default NULL,
+  `param_value` varchar(255) default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `directory_vars`
+--
+
+DROP TABLE IF EXISTS `directory_vars`;
+CREATE TABLE `directory_vars` (
+  `id` int(11) NOT NULL auto_increment,
+  `directory_id` int(11) default NULL,
+  `var_name` varchar(255) default NULL,
+  `var_value` varchar(255) default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `group_data`
+--
+
+DROP TABLE IF EXISTS `group_data`;
+CREATE TABLE `group_data` (
+  `hostname` varchar(255) default NULL,
+  `groupname` varchar(255) default NULL,
+  `url` varchar(255) default NULL
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `iax_conf`
+--
+
+DROP TABLE IF EXISTS `iax_conf`;
+CREATE TABLE `iax_conf` (
+  `id` int(11) NOT NULL auto_increment,
+  `profile_name` varchar(255) default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `iax_settings`
+--
+
+DROP TABLE IF EXISTS `iax_settings`;
+CREATE TABLE `iax_settings` (
+  `id` int(11) NOT NULL auto_increment,
+  `iax_id` int(11) default NULL,
+  `param_name` varchar(255) default NULL,
+  `param_value` varchar(255) default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `ivr_conf`
+--
+
+DROP TABLE IF EXISTS `ivr_conf`;
+CREATE TABLE `ivr_conf` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `name` varchar(64) NOT NULL,
+  `greet_long` varchar(255) NOT NULL,
+  `greet_short` varchar(255) NOT NULL,
+  `invalid_sound` varchar(255) NOT NULL,
+  `exit_sound` varchar(255) NOT NULL,
+  `max_failures` int(10) unsigned NOT NULL default '3',
+  `timeout` int(11) NOT NULL default '5',
+  `tts_engine` varchar(64) default NULL,
+  `tts_voice` varchar(64) default NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `unique_name` (`name`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `ivr_entries`
+--
+
+DROP TABLE IF EXISTS `ivr_entries`;
+CREATE TABLE `ivr_entries` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `ivr_id` int(10) unsigned NOT NULL,
+  `action` varchar(64) NOT NULL,
+  `digits` varchar(16) NOT NULL,
+  `params` varchar(255) default NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `unique_ivr_digits` (`ivr_id`,`digits`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `jabber_subscriptions`
+--
+
+DROP TABLE IF EXISTS `jabber_subscriptions`;
+CREATE TABLE `jabber_subscriptions` (
+  `sub_from` varchar(255) default NULL,
+  `sub_to` varchar(255) default NULL,
+  `show_pres` varchar(255) default NULL,
+  `status` varchar(255) default NULL
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `lcr`
+--
+
+DROP TABLE IF EXISTS `lcr`;
+CREATE TABLE `lcr` (
+  `id` int(11) NOT NULL auto_increment,
+  `digits` varchar(15) default NULL,
+  `rate` int(11) NOT NULL,
+  `carrier_id` int(11) NOT NULL,
+  `lead_strip` int(11) NOT NULL,
+  `trail_strip` int(11) NOT NULL,
+  `prefix` varchar(16) NOT NULL,
+  `suffix` varchar(16) NOT NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB AUTO_INCREMENT=6;
+
+--
+-- Table structure for table `limit_conf`
+--
+
+DROP TABLE IF EXISTS `limit_conf`;
+CREATE TABLE `limit_conf` (
+  `id` int(11) NOT NULL auto_increment,
+  `name` varchar(255) default NULL,
+  `value` varchar(255) default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `limit_data`
+--
+
+DROP TABLE IF EXISTS `limit_data`;
+CREATE TABLE `limit_data` (
+  `hostname` varchar(255) default NULL,
+  `realm` varchar(255) default NULL,
+  `id` varchar(255) default NULL,
+  `uuid` varchar(255) default NULL
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `local_stream_conf`
+--
+
+DROP TABLE IF EXISTS `local_stream_conf`;
+CREATE TABLE `local_stream_conf` (
+  `id` int(11) NOT NULL auto_increment,
+  `directory_name` varchar(255) default NULL,
+  `directory_path` text,
+  `param_name` varchar(255) default NULL,
+  `param_value` varchar(255) default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `post_load_modules_conf`
+--
+
+DROP TABLE IF EXISTS `post_load_modules_conf`;
+CREATE TABLE `post_load_modules_conf` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `module_name` varchar(64) NOT NULL,
+  `load_module` tinyint(1) NOT NULL default '1',
+  `priority` int(10) unsigned NOT NULL default '1000',
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `unique_mod` (`module_name`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `rss_conf`
+--
+
+DROP TABLE IF EXISTS `rss_conf`;
+CREATE TABLE `rss_conf` (
+  `id` int(11) NOT NULL auto_increment,
+  `directory_id` int(11) NOT NULL,
+  `feed` text NOT NULL,
+  `local_file` text NOT NULL,
+  `description` text,
+  `priority` int(11) NOT NULL default '1000',
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `sip_authentication`
+--
+
+DROP TABLE IF EXISTS `sip_authentication`;
+CREATE TABLE `sip_authentication` (
+  `nonce` varchar(255) default NULL,
+  `expires` int(8) default NULL
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `sip_dialogs`
+--
+
+DROP TABLE IF EXISTS `sip_dialogs`;
+CREATE TABLE `sip_dialogs` (
+  `call_id` varchar(255) default NULL,
+  `uuid` varchar(255) default NULL,
+  `sip_to_user` varchar(255) default NULL,
+  `sip_to_host` varchar(255) default NULL,
+  `sip_from_user` varchar(255) default NULL,
+  `sip_from_host` varchar(255) default NULL,
+  `contact_user` varchar(255) default NULL,
+  `contact_host` varchar(255) default NULL,
+  `state` varchar(255) default NULL,
+  `direction` varchar(255) default NULL,
+  `user_agent` varchar(255) default NULL
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `sip_registrations`
+--
+
+DROP TABLE IF EXISTS `sip_registrations`;
+CREATE TABLE `sip_registrations` (
+  `call_id` varchar(255) default NULL,
+  `sip_user` varchar(255) default NULL,
+  `sip_host` varchar(255) default NULL,
+  `contact` varchar(1024) default NULL,
+  `status` varchar(255) default NULL,
+  `rpid` varchar(255) default NULL,
+  `expires` int(11) default NULL,
+  `user_agent` varchar(255) default NULL
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `sip_subscriptions`
+--
+
+DROP TABLE IF EXISTS `sip_subscriptions`;
+CREATE TABLE `sip_subscriptions` (
+  `proto` varchar(255) default NULL,
+  `sip_user` varchar(255) default NULL,
+  `sip_host` varchar(255) default NULL,
+  `sub_to_user` varchar(255) default NULL,
+  `sub_to_host` varchar(255) default NULL,
+  `event` varchar(255) default NULL,
+  `contact` varchar(1024) default NULL,
+  `call_id` varchar(255) default NULL,
+  `full_from` varchar(255) default NULL,
+  `full_via` varchar(255) default NULL,
+  `expires` int(11) default NULL,
+  `user_agent` varchar(255) default NULL,
+  `accept` varchar(255) default NULL
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `sofia_aliases`
+--
+
+DROP TABLE IF EXISTS `sofia_aliases`;
+CREATE TABLE `sofia_aliases` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `sofia_id` int(10) unsigned NOT NULL,
+  `alias_name` varchar(255) NOT NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `sofia_conf`
+--
+
+DROP TABLE IF EXISTS `sofia_conf`;
+CREATE TABLE `sofia_conf` (
+  `id` int(11) NOT NULL auto_increment,
+  `profile_name` varchar(255) default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `sofia_domains`
+--
+
+DROP TABLE IF EXISTS `sofia_domains`;
+CREATE TABLE `sofia_domains` (
+  `id` int(11) NOT NULL auto_increment,
+  `sofia_id` int(11) default NULL,
+  `domain_name` varchar(255) default NULL,
+  `parse` tinyint(1) default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `sofia_gateways`
+--
+
+DROP TABLE IF EXISTS `sofia_gateways`;
+CREATE TABLE `sofia_gateways` (
+  `id` int(11) NOT NULL auto_increment,
+  `sofia_id` int(11) default NULL,
+  `gateway_name` varchar(255) default NULL,
+  `gateway_param` varchar(255) default NULL,
+  `gateway_value` varchar(255) default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `sofia_settings`
+--
+
+DROP TABLE IF EXISTS `sofia_settings`;
+CREATE TABLE `sofia_settings` (
+  `id` int(11) NOT NULL auto_increment,
+  `sofia_id` int(11) default NULL,
+  `param_name` varchar(255) default NULL,
+  `param_value` varchar(255) default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `voicemail_conf`
+--
+
+DROP TABLE IF EXISTS `voicemail_conf`;
+CREATE TABLE `voicemail_conf` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `vm_profile` varchar(64) NOT NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `unique_profile` (`vm_profile`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `voicemail_data`
+--
+
+DROP TABLE IF EXISTS `voicemail_data`;
+CREATE TABLE `voicemail_data` (
+  `created_epoch` int(8) default NULL,
+  `read_epoch` int(8) default NULL,
+  `user` varchar(255) default NULL,
+  `domain` varchar(255) default NULL,
+  `uuid` varchar(255) default NULL,
+  `cid_name` varchar(255) default NULL,
+  `cid_number` varchar(255) default NULL,
+  `in_folder` varchar(255) default NULL,
+  `file_path` varchar(255) default NULL,
+  `flags` varchar(255) default NULL,
+  `read_flags` varchar(255) default NULL
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `voicemail_email`
+--
+
+DROP TABLE IF EXISTS `voicemail_email`;
+CREATE TABLE `voicemail_email` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `voicemail_id` int(10) unsigned NOT NULL,
+  `param_name` varchar(64) NOT NULL,
+  `param_value` varchar(64) NOT NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `unique_profile_param` (`param_name`,`voicemail_id`)
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `voicemail_prefs`
+--
+
+DROP TABLE IF EXISTS `voicemail_prefs`;
+CREATE TABLE `voicemail_prefs` (
+  `user` varchar(255) default NULL,
+  `domain` varchar(255) default NULL,
+  `name_path` varchar(255) default NULL,
+  `greeting_path` varchar(255) default NULL
+) TYPE=InnoDB;
+
+--
+-- Table structure for table `voicemail_settings`
+--
+
+DROP TABLE IF EXISTS `voicemail_settings`;
+CREATE TABLE `voicemail_settings` (
+  `id` int(11) NOT NULL auto_increment,
+  `voicemail_id` int(11) default NULL,
+  `param_name` varchar(255) default NULL,
+  `param_value` varchar(255) default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=InnoDB;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+-- Dump completed on 2008-04-10  4:45:50

Modified: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0-with-samples.sql
==============================================================================
--- freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0-with-samples.sql	(original)
+++ freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0-with-samples.sql	Thu Apr 10 00:49:07 2008
@@ -103,9 +103,9 @@
   `type` varchar(16) NOT NULL default 'action',
   `ext_continue` smallint(1) NOT NULL default '0',
   `global_weight` int(11) NOT NULL default '10000',
-  `condition_continue` varchar(8) default NULL,
+  `cond_break` varchar(8) default NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=385 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=385 DEFAULT CHARSET=utf8;
 
 --
 -- Dumping data for table `dialplan`
@@ -196,9 +196,10 @@
 CREATE TABLE `directory` (
   `id` int(11) NOT NULL auto_increment,
   `username` varchar(255) NOT NULL,
+  `mailbox` varchar(255) NOT NULL,
   `domain` varchar(255) NOT NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
 
 --
 -- Dumping data for table `directory`
@@ -206,7 +207,7 @@
 
 LOCK TABLES `directory` WRITE;
 /*!40000 ALTER TABLE `directory` DISABLE KEYS */;
-INSERT INTO `directory` VALUES (1,'1000','example.com'),(2,'1001','example.org'),(3,'1002','example.net'),(5,'1003','example.info'),(6,'1004','example.com'),(7,'1005','example.org'),(8,'1006','example.net'),(9,'1007','example.info'),(10,'1008','$${domain}'),(11,'1009','$${local_ip_v4}');
+INSERT INTO `directory` VALUES (1,'1000','','example.com'),(2,'1001','','example.org'),(3,'1002','','example.net'),(5,'1003','','example.info'),(6,'1004','','example.com'),(7,'1005','','example.org'),(8,'1006','','example.net'),(9,'1007','','example.info'),(10,'1008','','$${domain}'),(11,'1009','','$${local_ip_v4}'),(12,'tester','1000','$${domain}');
 /*!40000 ALTER TABLE `directory` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -354,7 +355,7 @@
   `var_name` varchar(255) default NULL,
   `var_value` varchar(255) default NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
 
 --
 -- Dumping data for table `directory_vars`
@@ -475,7 +476,7 @@
   `name` varchar(255) default NULL,
   `value` varchar(255) default NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
 
 --
 -- Dumping data for table `limit_conf`
@@ -496,7 +497,7 @@
   `realm` varchar(255) default NULL,
   `id` varchar(255) default NULL,
   `uuid` varchar(255) default NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
 -- Dumping data for table `limit_data`
@@ -519,7 +520,7 @@
   `param_name` varchar(255) default NULL,
   `param_value` varchar(255) default NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
 -- Dumping data for table `local_stream_conf`
@@ -567,7 +568,7 @@
   `description` text,
   `priority` int(11) NOT NULL default '1000',
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
 
 --
 -- Dumping data for table `rss_conf`

Modified: freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0.sql
==============================================================================
--- freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0.sql	(original)
+++ freeswitch/trunk/scripts/contrib/intralanman/PHP/fs_curl/sql/mysql-5.0.sql	Thu Apr 10 00:49:07 2008
@@ -66,7 +66,7 @@
   `realm` varchar(255) default NULL,
   `data_key` varchar(255) default NULL,
   `data` varchar(255) default NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `dialplan`
@@ -85,11 +85,11 @@
   `type` varchar(16) NOT NULL default 'action',
   `ext_continue` smallint(1) NOT NULL default '0',
   `global_weight` int(11) NOT NULL default '10000',
-  `condition_continue` varchar(8) default NULL,
+  `cond_break` varchar(8) default NULL,
   `app_cdata` tinyint(1) NOT NULL default '0',
   `re_cdata` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=386 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=386 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `dingaling_profile_params`
@@ -140,9 +140,10 @@
 CREATE TABLE `directory` (
   `id` int(11) NOT NULL auto_increment,
   `username` varchar(255) NOT NULL,
+  `mailbox` varchar(255) NOT NULL,
   `domain` varchar(255) NOT NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `directory_gateway_params`
@@ -194,7 +195,7 @@
   `var_name` varchar(255) default NULL,
   `var_value` varchar(255) default NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `group_data`
@@ -205,7 +206,7 @@
   `hostname` varchar(255) default NULL,
   `groupname` varchar(255) default NULL,
   `url` varchar(255) default NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `iax_conf`
@@ -276,7 +277,7 @@
   `sub_to` varchar(255) default NULL,
   `show_pres` varchar(255) default NULL,
   `status` varchar(255) default NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `limit_conf`
@@ -288,7 +289,7 @@
   `name` varchar(255) default NULL,
   `value` varchar(255) default NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `limit_data`
@@ -300,7 +301,7 @@
   `realm` varchar(255) default NULL,
   `id` varchar(255) default NULL,
   `uuid` varchar(255) default NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `local_stream_conf`
@@ -314,7 +315,7 @@
   `param_name` varchar(255) default NULL,
   `param_value` varchar(255) default NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `post_load_modules_conf`
@@ -343,7 +344,7 @@
   `description` text,
   `priority` int(11) NOT NULL default '1000',
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `sip_authentication`
@@ -353,7 +354,7 @@
 CREATE TABLE `sip_authentication` (
   `nonce` varchar(255) default NULL,
   `expires` int(8) default NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `sip_dialogs`
@@ -503,7 +504,7 @@
   `file_path` varchar(255) default NULL,
   `flags` varchar(255) default NULL,
   `read_flags` varchar(255) default NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `voicemail_email`
@@ -529,7 +530,7 @@
   `domain` varchar(255) default NULL,
   `name_path` varchar(255) default NULL,
   `greeting_path` varchar(255) default NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `voicemail_settings`



More information about the Freeswitch-svn mailing list