Changeset 12407

Show
Ignore:
Timestamp:
08/13/11 19:28:55 (2 years ago)
Author:
xrobau
Message:

Fix ticket #4962 - newinstall.sql updated to 2.9

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • freepbx/trunk/SQL/newinstall.sql

    r12167 r12407  
    1 -- MySQL dump 10.9 
    2 -- 
    3 -- Host: localhost    Database: asterisk 
     1-- MySQL dump 10.13  Distrib 5.1.52, for unknown-linux-gnu (x86_64) 
     2-- 
     3-- Host: localhost    Database: hipbx 
    44-- ------------------------------------------------------ 
    5 -- Server version 4.1.20 
     5-- Server version 5.1.52 
    66 
    77/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 
     
    99/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 
    1010/*!40101 SET NAMES utf8 */; 
     11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; 
     12/*!40103 SET TIME_ZONE='+00:00' */; 
    1113/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; 
    1214/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 
     
    1517 
    1618-- 
     19-- Table structure for table `admin` 
     20-- 
     21 
     22DROP TABLE IF EXISTS `admin`; 
     23/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     24/*!40101 SET character_set_client = utf8 */; 
     25CREATE TABLE `admin` ( 
     26  `variable` varchar(20) NOT NULL DEFAULT '', 
     27  `value` varchar(80) NOT NULL DEFAULT '', 
     28  PRIMARY KEY (`variable`) 
     29) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     30/*!40101 SET character_set_client = @saved_cs_client */; 
     31 
     32-- 
     33-- Dumping data for table `admin` 
     34-- 
     35 
     36LOCK TABLES `admin` WRITE; 
     37/*!40000 ALTER TABLE `admin` DISABLE KEYS */; 
     38INSERT INTO `admin` VALUES ('need_reload','true'),('version','2.9.0'); 
     39/*!40000 ALTER TABLE `admin` ENABLE KEYS */; 
     40UNLOCK TABLES; 
     41 
     42-- 
     43-- Table structure for table `ampusers` 
     44-- 
     45 
     46DROP TABLE IF EXISTS `ampusers`; 
     47/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     48/*!40101 SET character_set_client = utf8 */; 
     49CREATE TABLE `ampusers` ( 
     50  `username` varchar(20) NOT NULL DEFAULT '', 
     51  `password_sha1` varchar(40) NOT NULL, 
     52  `extension_low` varchar(20) NOT NULL DEFAULT '', 
     53  `extension_high` varchar(20) NOT NULL DEFAULT '', 
     54  `deptname` varchar(20) NOT NULL DEFAULT '', 
     55  `sections` blob NOT NULL, 
     56  PRIMARY KEY (`username`) 
     57) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     58/*!40101 SET character_set_client = @saved_cs_client */; 
     59 
     60-- 
     61-- Dumping data for table `ampusers` 
     62-- 
     63 
     64LOCK TABLES `ampusers` WRITE; 
     65/*!40000 ALTER TABLE `ampusers` DISABLE KEYS */; 
     66INSERT INTO `ampusers` VALUES ('admin','d033e22ae348aeb5660fc2140aec35850c4da997','','','','*'); 
     67/*!40000 ALTER TABLE `ampusers` ENABLE KEYS */; 
     68UNLOCK TABLES; 
     69 
     70-- 
     71-- Table structure for table `cronmanager` 
     72-- 
     73 
     74DROP TABLE IF EXISTS `cronmanager`; 
     75/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     76/*!40101 SET character_set_client = utf8 */; 
     77CREATE TABLE `cronmanager` ( 
     78  `module` varchar(24) NOT NULL DEFAULT '', 
     79  `id` varchar(24) NOT NULL DEFAULT '', 
     80  `time` varchar(5) DEFAULT NULL, 
     81  `freq` int(11) NOT NULL DEFAULT '0', 
     82  `lasttime` int(11) NOT NULL DEFAULT '0', 
     83  `command` varchar(255) NOT NULL DEFAULT '', 
     84  PRIMARY KEY (`module`,`id`) 
     85) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     86/*!40101 SET character_set_client = @saved_cs_client */; 
     87 
     88-- 
     89-- Dumping data for table `cronmanager` 
     90-- 
     91 
     92LOCK TABLES `cronmanager` WRITE; 
     93/*!40000 ALTER TABLE `cronmanager` DISABLE KEYS */; 
     94INSERT INTO `cronmanager` VALUES ('module_admin','UPDATES','22',24,0,'/var/lib/asterisk/bin/module_admin listonline'); 
     95/*!40000 ALTER TABLE `cronmanager` ENABLE KEYS */; 
     96UNLOCK TABLES; 
     97 
     98-- 
     99-- Table structure for table `dahdi` 
     100-- 
     101 
     102DROP TABLE IF EXISTS `dahdi`; 
     103/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     104/*!40101 SET character_set_client = utf8 */; 
     105CREATE TABLE `dahdi` ( 
     106  `id` varchar(20) NOT NULL DEFAULT '-1', 
     107  `keyword` varchar(30) NOT NULL DEFAULT '', 
     108  `data` varchar(255) NOT NULL DEFAULT '', 
     109  `flags` int(1) NOT NULL DEFAULT '0', 
     110  PRIMARY KEY (`id`,`keyword`) 
     111) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     112/*!40101 SET character_set_client = @saved_cs_client */; 
     113 
     114-- 
     115-- Dumping data for table `dahdi` 
     116-- 
     117 
     118LOCK TABLES `dahdi` WRITE; 
     119/*!40000 ALTER TABLE `dahdi` DISABLE KEYS */; 
     120/*!40000 ALTER TABLE `dahdi` ENABLE KEYS */; 
     121UNLOCK TABLES; 
     122 
     123-- 
     124-- Table structure for table `devices` 
     125-- 
     126 
     127DROP TABLE IF EXISTS `devices`; 
     128/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     129/*!40101 SET character_set_client = utf8 */; 
     130CREATE TABLE `devices` ( 
     131  `id` varchar(20) NOT NULL DEFAULT '', 
     132  `tech` varchar(10) NOT NULL DEFAULT '', 
     133  `dial` varchar(50) NOT NULL DEFAULT '', 
     134  `devicetype` varchar(5) NOT NULL DEFAULT '', 
     135  `user` varchar(50) DEFAULT NULL, 
     136  `description` varchar(50) DEFAULT NULL, 
     137  `emergency_cid` varchar(100) DEFAULT NULL 
     138) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     139/*!40101 SET character_set_client = @saved_cs_client */; 
     140 
     141-- 
     142-- Dumping data for table `devices` 
     143-- 
     144 
     145LOCK TABLES `devices` WRITE; 
     146/*!40000 ALTER TABLE `devices` DISABLE KEYS */; 
     147/*!40000 ALTER TABLE `devices` ENABLE KEYS */; 
     148UNLOCK TABLES; 
     149 
     150-- 
     151-- Table structure for table `extensions` 
     152-- 
     153 
     154DROP TABLE IF EXISTS `extensions`; 
     155/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     156/*!40101 SET character_set_client = utf8 */; 
     157CREATE TABLE `extensions` ( 
     158  `context` varchar(45) NOT NULL DEFAULT 'default', 
     159  `extension` varchar(45) NOT NULL DEFAULT '', 
     160  `priority` varchar(5) NOT NULL DEFAULT '1', 
     161  `application` varchar(45) NOT NULL DEFAULT '', 
     162  `args` varchar(255) DEFAULT NULL, 
     163  `descr` text, 
     164  `flags` int(1) NOT NULL DEFAULT '0', 
     165  PRIMARY KEY (`context`,`extension`,`priority`) 
     166) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     167/*!40101 SET character_set_client = @saved_cs_client */; 
     168 
     169-- 
     170-- Dumping data for table `extensions` 
     171-- 
     172 
     173LOCK TABLES `extensions` WRITE; 
     174/*!40000 ALTER TABLE `extensions` DISABLE KEYS */; 
     175INSERT INTO `extensions` VALUES ('outrt-001-9_outside','_9.','1','Macro','dialout-trunk,1,${EXTEN:1}',NULL,0),('outrt-001-9_outside','_9.','2','Macro','outisbusy','No available circuits',0),('outbound-allroutes','include','1','outrt-001-9_outside','','',2); 
     176/*!40000 ALTER TABLE `extensions` ENABLE KEYS */; 
     177UNLOCK TABLES; 
     178 
     179-- 
     180-- Table structure for table `featurecodes` 
     181-- 
     182 
     183DROP TABLE IF EXISTS `featurecodes`; 
     184/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     185/*!40101 SET character_set_client = utf8 */; 
     186CREATE TABLE `featurecodes` ( 
     187  `modulename` varchar(50) NOT NULL DEFAULT '', 
     188  `featurename` varchar(50) NOT NULL DEFAULT '', 
     189  `description` varchar(200) NOT NULL DEFAULT '', 
     190  `defaultcode` varchar(20) DEFAULT NULL, 
     191  `customcode` varchar(20) DEFAULT NULL, 
     192  `enabled` tinyint(4) NOT NULL DEFAULT '0', 
     193  `providedest` tinyint(4) NOT NULL DEFAULT '0', 
     194  PRIMARY KEY (`modulename`,`featurename`), 
     195  KEY `enabled` (`enabled`) 
     196) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     197/*!40101 SET character_set_client = @saved_cs_client */; 
     198 
     199-- 
     200-- Dumping data for table `featurecodes` 
     201-- 
     202 
     203LOCK TABLES `featurecodes` WRITE; 
     204/*!40000 ALTER TABLE `featurecodes` DISABLE KEYS */; 
     205INSERT INTO `featurecodes` VALUES ('core','userlogon','User Logon','*11',NULL,1,0),('core','userlogoff','User Logoff','*12',NULL,1,0),('core','zapbarge','ZapBarge','888',NULL,1,1),('core','chanspy','ChanSpy','555',NULL,1,1),('core','simu_pstn','Simulate Incoming Call','7777',NULL,1,1),('core','pickup','Directed Call Pickup','**',NULL,1,0),('core','pickupexten','Asterisk General Call Pickup','*8',NULL,1,0),('core','blindxfer','In-Call Asterisk Blind Transfer','##',NULL,1,0),('core','atxfer','In-Call Asterisk Attended Transfer','*2',NULL,1,0),('core','automon','In-Call Asterisk Toggle Call Recording','*1',NULL,1,0),('core','disconnect','In-Call Asterisk Disconnect Code','**',NULL,1,0); 
     206/*!40000 ALTER TABLE `featurecodes` ENABLE KEYS */; 
     207UNLOCK TABLES; 
     208 
     209-- 
     210-- Table structure for table `freepbx_log` 
     211-- 
     212 
     213DROP TABLE IF EXISTS `freepbx_log`; 
     214/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     215/*!40101 SET character_set_client = utf8 */; 
     216CREATE TABLE `freepbx_log` ( 
     217  `id` int(11) NOT NULL AUTO_INCREMENT, 
     218  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', 
     219  `section` varchar(50) DEFAULT NULL, 
     220  `level` enum('error','warning','debug','devel-debug') NOT NULL DEFAULT 'error', 
     221  `status` int(11) NOT NULL DEFAULT '0', 
     222  `message` text NOT NULL, 
     223  PRIMARY KEY (`id`), 
     224  KEY `time` (`time`,`level`) 
     225) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; 
     226/*!40101 SET character_set_client = @saved_cs_client */; 
     227 
     228-- 
    17229-- Table structure for table `freepbx_settings` 
    18230-- 
    19231 
    20232DROP TABLE IF EXISTS `freepbx_settings`; 
     233/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     234/*!40101 SET character_set_client = utf8 */; 
    21235CREATE TABLE `freepbx_settings` ( 
    22   `keyword` varchar(50) default NULL, 
    23   `value` varchar(255) default NULL, 
    24   `name` varchar(80) default NULL, 
    25   `level` tinyint(1) default 0, 
    26   `description` text default NULL, 
    27   `type` varchar(25) default NULL, 
    28   `options` text default NULL, 
    29   `defaultval` varchar(255) default NULL, 
    30   `readonly` tinyint(1) default 0, 
    31   `hidden` tinyint(1) default 0, 
    32   `category` varchar(50) default NULL, 
    33   `module` varchar(25) default NULL, 
    34   `emptyok` tinyint(1) default 1, 
    35   `sortorder` int(11) default 0, 
    36   PRIMARY KEY  (`keyword`) 
    37  ); 
    38  
    39 -- 
    40 -- Table structure for table `admin` 
    41 -- 
    42  
    43 DROP TABLE IF EXISTS `admin`; 
    44 CREATE TABLE `admin` ( 
    45   `variable` varchar(20) NOT NULL default '', 
    46   `value` varchar(80) NOT NULL default '', 
    47   PRIMARY KEY  (`variable`) 
    48 ); 
    49  
    50 -- 
    51 -- Dumping data for table `admin` 
    52 -- 
    53  
    54  
    55 /*!40000 ALTER TABLE `admin` DISABLE KEYS */; 
    56 -- LOCK TABLES `admin` WRITE; 
    57 INSERT INTO `admin` VALUES ('need_reload','true'); 
    58 INSERT INTO `admin` VALUES ('version','2.2.0beta3'); 
    59 -- UNLOCK TABLES; 
    60 /*!40000 ALTER TABLE `admin` ENABLE KEYS */; 
    61  
    62 -- 
    63 -- Table structure for table `ampusers` 
    64 -- 
    65  
    66 DROP TABLE IF EXISTS `ampusers`; 
    67 CREATE TABLE `ampusers` ( 
    68   `username` varchar(20) NOT NULL default '', 
    69   `password` varchar(20) NOT NULL default '', 
    70   `extension_low` varchar(20) NOT NULL default '', 
    71   `extension_high` varchar(20) NOT NULL default '', 
    72   `deptname` varchar(20) NOT NULL default '', 
    73   `sections` varchar(255) NOT NULL default '', 
    74   PRIMARY KEY  (`username`) 
    75 ); 
    76  
    77 -- 
    78 -- Dumping data for table `ampusers` 
    79 -- 
    80  
    81  
    82 /*!40000 ALTER TABLE `ampusers` DISABLE KEYS */; 
    83 -- LOCK TABLES `ampusers` WRITE; 
    84 INSERT INTO `ampusers` VALUES ('admin','admin','','','','*'); 
    85 -- UNLOCK TABLES; 
    86 /*!40000 ALTER TABLE `ampusers` ENABLE KEYS */; 
    87  
    88 -- 
    89 -- Table structure for table `devices` 
    90 -- 
    91  
    92 DROP TABLE IF EXISTS `devices`; 
    93 CREATE TABLE `devices` ( 
    94   `id` varchar(20) NOT NULL default '', 
    95   `tech` varchar(10) NOT NULL default '', 
    96   `dial` varchar(50) NOT NULL default '', 
    97   `devicetype` varchar(5) NOT NULL default '', 
    98   `user` varchar(50) default NULL, 
    99   `description` varchar(50) default NULL, 
    100   `emergency_cid` varchar(100) default NULL 
    101 ); 
    102  
    103 -- 
    104 -- Dumping data for table `devices` 
    105 -- 
    106  
    107  
    108 /*!40000 ALTER TABLE `devices` DISABLE KEYS */; 
    109 -- LOCK TABLES `devices` WRITE; 
    110 -- UNLOCK TABLES; 
    111 /*!40000 ALTER TABLE `devices` ENABLE KEYS */; 
    112  
    113 -- 
    114 -- Table structure for table `extensions` 
    115 -- 
    116  
    117 DROP TABLE IF EXISTS `extensions`; 
    118 CREATE TABLE `extensions` ( 
    119   `context` varchar(45) NOT NULL default 'default', 
    120   `extension` varchar(45) NOT NULL default '', 
    121   `priority` varchar(5) NOT NULL default '1', 
    122   `application` varchar(45) NOT NULL default '', 
    123   `args` varchar(255) default NULL, 
    124   `descr` text, 
    125   `flags` int(1) NOT NULL default '0', 
    126   PRIMARY KEY  (`context`,`extension`,`priority`) 
    127 ); 
    128  
    129 -- 
    130 -- Dumping data for table `extensions` 
    131 -- 
    132  
    133  
    134 /*!40000 ALTER TABLE `extensions` DISABLE KEYS */; 
    135 -- LOCK TABLES `extensions` WRITE; 
    136 INSERT INTO `extensions` VALUES ('outrt-001-9_outside','_9.','1','Macro','dialout-trunk,1,${EXTEN:1}',NULL,0); 
    137 INSERT INTO `extensions` VALUES ('outrt-001-9_outside','_9.','2','Macro','outisbusy','No available circuits',0); 
    138 INSERT INTO `extensions` VALUES ('outbound-allroutes','include','1','outrt-001-9_outside','','',2); 
    139 -- UNLOCK TABLES; 
    140 /*!40000 ALTER TABLE `extensions` ENABLE KEYS */; 
    141  
    142 -- 
    143 -- Table structure for table `featurecodes` 
    144 -- 
    145  
    146 DROP TABLE IF EXISTS `featurecodes`; 
    147 CREATE TABLE `featurecodes` ( 
    148   `modulename` varchar(50) NOT NULL default '', 
    149   `featurename` varchar(50) NOT NULL default '', 
    150   `description` varchar(200) NOT NULL default '', 
    151   `defaultcode` varchar(20) default NULL, 
    152   `customcode` varchar(20) default NULL, 
    153   `enabled` tinyint(4) NOT NULL default '0', 
    154   `providedest` tinyint(4) NOT NULL default '0', 
    155   PRIMARY KEY  (`modulename`,`featurename`), 
    156   KEY `enabled` (`enabled`) 
    157 ); 
    158  
    159 -- 
    160 -- Table structure for table `freepbx_log` 
    161 -- 
    162  
    163 DROP TABLE IF EXISTS `freepbx_log`; 
    164 CREATE TABLE `freepbx_log` ( 
    165   `id` int(11) NOT NULL auto_increment, 
    166   `time` datetime NOT NULL default '0000-00-00 00:00:00', 
    167   `section` varchar(50) default NULL, 
    168   `level` enum('error','warning','debug','devel-debug') NOT NULL default 'error', 
    169   `status` int(11) NOT NULL default '0', 
    170   `message` text NOT NULL, 
    171   PRIMARY KEY  (`id`), 
    172   KEY `time` (`time`,`level`) 
    173 ); 
    174  
    175 -- 
    176 -- Dumping data for table `freepbx_log` 
    177 -- 
    178  
    179  
    180 /*!40000 ALTER TABLE `freepbx_log` DISABLE KEYS */; 
    181 -- LOCK TABLES `freepbx_log` WRITE; 
    182 INSERT INTO `freepbx_log` VALUES (1,'2006-11-06 01:55:36','retrieve_conf','devel-debug',0,'Started retrieve_conf, DB Connection OK'); 
    183 INSERT INTO `freepbx_log` VALUES (2,'2006-11-06 01:55:36','retrieve_conf','devel-debug',0,'Writing extensions_additional.conf'); 
    184 -- UNLOCK TABLES; 
    185 /*!40000 ALTER TABLE `freepbx_log` ENABLE KEYS */; 
     236  `keyword` varchar(50) NOT NULL DEFAULT '', 
     237  `value` varchar(255) DEFAULT NULL, 
     238  `name` varchar(80) DEFAULT NULL, 
     239  `level` tinyint(1) DEFAULT '0', 
     240  `description` text, 
     241  `type` varchar(25) DEFAULT NULL, 
     242  `options` text, 
     243  `defaultval` varchar(255) DEFAULT NULL, 
     244  `readonly` tinyint(1) DEFAULT '0', 
     245  `hidden` tinyint(1) DEFAULT '0', 
     246  `category` varchar(50) DEFAULT NULL, 
     247  `module` varchar(25) DEFAULT NULL, 
     248  `emptyok` tinyint(1) DEFAULT '1', 
     249  `sortorder` int(11) DEFAULT '0', 
     250  PRIMARY KEY (`keyword`) 
     251) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     252/*!40101 SET character_set_client = @saved_cs_client */; 
     253 
     254-- 
     255-- Dumping data for table `freepbx_settings` 
     256-- 
     257 
     258LOCK TABLES `freepbx_settings` WRITE; 
     259/*!40000 ALTER TABLE `freepbx_settings` DISABLE KEYS */; 
     260INSERT INTO `freepbx_settings` VALUES  
     261('AS_DISPLAY_HIDDEN_SETTINGS','0','Display Hidden Settings',0,'This will display settings that are normally hidden by the system. These settings are often internally used settings that are not of interest to most users.','bool','','0',0,0,'Advanced Settings Details','',0,0), 
     262('AS_DISPLAY_READONLY_SETTINGS','0','Display Readonly Settings',0,'This will display settings that are readonly. These settings are often internally used settings that are not of interest to most users. Since they are readonly they can only be viewed.','bool','','0',0,0,'Advanced Settings Details','',0,0), 
     263('AS_OVERRIDE_READONLY','0','Override Readonly Settings',0,'Setting this to true will allow you to override un-hidden readonly setting to change them. Settings that are readonly may be extremely volatile and have a high chance of breaking your system if you change them. Take extreme caution when electing to make such changes.','bool','','0',0,0,'Advanced Settings Details','',0,0), 
     264('AS_DISPLAY_FRIENDLY_NAME','1','Display Friendly Name',0,'Normally the friendly names will be displayed on this page and the internal freepbx_conf configuration names are shown in the tooltip. If you prefer to view the configuration variables, and the friendly name in the tooltip, set this to false..','bool','','1',0,0,'Advanced Settings Details','',0,0), 
     265('AMPSYSLOGLEVEL','FILE','FreePBX Log Routing',0,'Determine where to send log information if the log is enabled (\'Disable FreePBX Log\' (AMPDISABLELOG) false. There are two places to route the log messages. \'FILE\' will send all log messages to the defined \'FreePBX Log File\' (FPBX_LOG_FILE). All the other settings will route the log messages to your System Logging subsystem (syslog) using the specified log level. Syslog can be configured to route different levels to different locations. See \'syslog\' documentation (man syslog) on your system for more details.','select','FILE,LOG_EMERG,LOG_ALERT,LOG_CRIT,LOG_ERR,LOG_WARNING,LOG_NOTICE,LOG_INFO,LOG_DEBUG','FILE',0,0,'System Setup','',1,-190), 
     266('AMPDISABLELOG','0','Disable FreePBX Log',0,'Whether or not to invoke the FreePBX log facility.','bool','','0',0,0,'System Setup','',0,-180), 
     267('LOG_OUT_MESSAGES','1','Log Verbose Messages',0,'FreePBX has many verbose and useful messages displayed to users during module installation, system installations, loading configurations and other places. In order to accumulate these messages in the log files as well as the on screen display, set this to true.','bool','','1',0,0,'System Setup','',0,-170), 
     268('LOG_NOTIFICATIONS','1','Send Dashboard Notifications to Log',0,'When enabled all notification updates to the Dashboard notification panel will also be logged into the specified log file when enabled.','bool','','1',0,0,'System Setup','',0,-160), 
     269('FPBX_LOG_FILE','/var/log/asterisk/freepbx.log','FreePBX Log File',0,'Full path and name of the FreePBX Log File used in conjunction with the Syslog Level (AMPSYSLOGLEVEL) being set to FILE, not used otherwise. Initial installs may have some early logging sent to /tmp/freepbx_pre_install.log when it is first bootstrapping the installer.','text','','/var/log/asterisk/freepbx.log',0,0,'System Setup','',0,-150), 
     270('PHP_ERROR_HANDLER_OUTPUT','dbug','PHP Error Log Output',0,'Where to send PHP errors, warnings and notices by the FreePBX PHP error handler. Set to \'dbug\', they will go to the Debug File regardless of whether dbug Loggin is disabled or not. Set to \'freepbxlog\' will send them to the FreePBX Log. Set to \'off\' and they will be ignored.','select','dbug,freepbxlog,off','dbug',0,0,'System Setup','',0,-140), 
     271('AMPEXTENSIONS','extensions','User & Devices Mode',0,'Sets the extension behavior in FreePBX.  If set to <b>extensions</b>, Devices and Users are administered together as a unified Extension, and appear on a single page. If set to <b>deviceanduser</b>, Devices and Users will be administered separately. Devices (e.g. each individual line on a SIP phone) and Users (e.g. <b>101</b>) will be configured independent of each other, allowing association of one User to many Devices, or allowing Users to login and logout of Devices.','select','extensions,deviceanduser','extensions',0,0,'System Setup','',0,-135), 
     272('AUTHTYPE','database','Authorization Type',3,'Authentication type to use for web admin. If type set to <b>database</b>, the primary AMP admin credentials will be the AMPDBUSER/AMPDBPASS above. When using database you can create users that are restricted to only certain module pages. When set to none, you should make sure you have provided security at the apache level. When set to webserver, FreePBX will expect authentication to happen at the apache level, but will take the user credentials and apply any restrictions as if it were in database mode.','select','database,none,webserver','database',1,0,'System Setup','',0,-130), 
     273('AMP_ACCESS_DB_CREDS','0','Allow Login With DB Credentials',0,'When Set to True, admin access to the FreePBX GUI will be allowed using the FreePBX configured AMPDBUSER and AMPDBPASS credentials. This only applies when Authorization Type is \'database\' mode.','bool','','0',0,0,'System Setup','',0,-126), 
     274('ARI_ADMIN_USERNAME','','User Portal Admin Username',0,'This is the default admin name used to allow an administrator to login to ARI bypassing all security. Change this to whatever you want, do not forget to change the User Portal Admin Password as well. Default = not set','text','','',0,0,'System Setup','',1,-120), 
     275('ARI_ADMIN_PASSWORD','ari_password','User Portal Admin Password',0,'This is the default admin password to allow an administrator to login to ARI bypassing all security. Change this to a secure password. Default = not set','text','','ari_password',0,0,'System Setup','',0,-110), 
     276('FORCED_ASTVERSION','','Force Asterisk Version',4,'Normally FreePBX gets the current Asterisk version directly from Asterisk. This is required to generate proper dialplan for a given version. When using some custom Asterisk builds, the version may not be properly parsed and improper dialplan generated. Setting this to an equivalent Asterisk version will override what is read from Asterisk. This SHOULD be left blank unless you know what you are doing.','text','','',1,0,'System Setup','',1,-100), 
     277('AMPENGINE','asterisk','Telephony Engine',3,'The telephony backend engine being used, asterisk is the only option currently.','select','asterisk','asterisk',1,0,'System Setup','',0,-100),('AMPVMUMASK','007','Asterisk VMU Mask',4,'Defaults to 077 allowing only the asterisk user to have any permission on VM files. If set to something like 007, it would allow the group to have permissions. This can be used if setting apache to a different user then asterisk, so that the apache user (and thus ARI) can have access to read/write/delete the voicemail files. If changed, some of the voicemail directory structures may have to be manually changed.','text','','007',0,0,'System Setup','',0,-100), 
     278('AMPWEBADDRESS','192.168.1.1','FreePBX Web Address',4,'This is the address of your Web Server. It is mostly obsolete and derived when not supplied and will be phased out, but there are still some areas expecting a variable to be set and if you are using it this will migrate your value.','text','','',0,0,'System Setup','',1,-100), 
     279('AMPASTERISKUSER','apache','System Asterisk User',4,'The user Asterisk should be running as, used by freepbx_engine. Most systems should not change this.','text','','asterisk',1,0,'System Setup','',0,-100), 
     280('AMPASTERISKGROUP','apache','System Asterisk Group',4,'The user group Asterisk should be running as, used by freepbx_engine. Most systems should not change this.','text','','asterisk',1,0,'System Setup','',0,-100), 
     281('AMPASTERISKWEBUSER','apache','System Web User',4,'The user your httpd should be running as, used by freepbx_engine. Most systems should not change this.','text','','asterisk',1,0,'System Setup','',0,-100), 
     282('AMPASTERISKWEBGROUP','apache','System Web Group',4,'The user group your httpd should be running as, used by freepbx_engine. Most systems should not change this.','text','','asterisk',1,0,'System Setup','',0,-100), 
     283('AMPDEVUSER','apache','System Device User',4,'The user that various device directories should be set to, used by freepbx_engine. Examples include /dev/zap, /dev/dahdi, /dev/misdn, /dev/mISDN and /dev/dsp. Most systems should not change this.','text','','asterisk',1,0,'System Setup','',0,-100), 
     284('AMPDEVGROUP','apache','System Device Group',4,'The user group that various device directories should be set to, used by freepbx_engine. Examples include /dev/zap, /dev/dahdi, /dev/misdn, /dev/mISDN and /dev/dsp. Most systems should not change this.','text','','asterisk',1,0,'System Setup','',0,-100), 
     285('AMPBADNUMBER','1','Use bad-number Context',2,'Generate the bad-number context which traps any bogus number or feature code and plays a message to the effect. If you use the Early Dial feature on some Grandstream phones, you will want to set this to false.','bool','','1',0,0,'Dialplan and Operational','',0,-100), 
     286('CWINUSEBUSY','1','Occupied Lines CW Busy',0,'For extensions that have CW enabled, report unanswered CW calls as <b>busy</b> (resulting in busy voicemail greeting). If set to no, unanswered CW calls simply report as <b>no-answer</b>.','bool','','1',0,0,'Dialplan and Operational','',0,-100), 
     287('ZAP2DAHDICOMPAT','0','Convert ZAP Settings to DAHDi',0,'If set to true, FreePBX will check if you have chan_dahdi installed. If so, it will automatically use all your ZAP configuration settings (devices and trunks) and silently convert them, under the covers, to DAHDi so no changes are needed. The GUI will continue to refer to these as ZAP but it will use the proper DAHDi channels. This will also keep Zap Channel DIDs working.','bool','','0',1,0,'Dialplan and Operational','',0,-100), 
     288('DYNAMICHINTS','0','Dynamically Generate Hints',0,'If true, Core will not statically generate hints, but instead make a call to the AMPBIN php script, and generate_hints.php through an Asterisk #exec call. This requires asterisk.conf to be configured with <b>execincludes=yes<b> set in the [options] section.','bool','','0',1,0,'Dialplan and Operational','',0,-100), 
     289('ENABLECW','1','CW Enabled by Default',0,'Enable call waiting by default when an extension is created (Default is yes). Set to <b>no</b> to if you do not want phones to be commissioned with call waiting already enabled. The user would then be required to dial the CW feature code (*70 default) to enable their phone. Most installations should leave this alone. It allows multi-line phones to receive multiple calls on their line appearances.','bool','','1',0,0,'Dialplan and Operational','',0,-100), 
     290('FCBEEPONLY','0','Feature Codes Beep Only',0,'When set to true, a beep is played instead of confirmation message when activating/de-activating: CallForward, CallWaiting, DayNight, DoNotDisturb and FindMeFollow.','bool','','0',0,0,'Dialplan and Operational','',0,-100), 
     291('USEDEVSTATE','0','Enable Custom Device States',0,'If this is set, it assumes that you are running Asterisk 1.4 or higher and want to take advantage of the func_devstate.c backport available from Asterisk 1.6. This allows custom hints to be created to support BLF for server side feature codes such as daynight, followme, etc','bool','','0',0,0,'Dialplan and Operational','',0,-100), 
     292('USEGOOGLEDNSFORENUM','0','Use Google DNS for Enum',2,'Setting this flag will generate the required global variable so that enumlookup.agi will use Google DNS 8.8.8.8 when performing an ENUM lookup. Not all DNS deals with NAPTR record, but Google does. There is a drawback to this as Google tracks every lookup. If you are not comfortable with this, do not enable this setting. Please read Google FAQ about this: <b>http://code.google.com/speed/public-dns/faq.html#privacy</b>.','bool','','0',0,0,'Dialplan and Operational','',0,-100), 
     293('DISABLECUSTOMCONTEXTS','0','Disable -custom Context Includes',2,'Normally FreePBX auto-generates a custom context that may be usable for adding custom dialplan to modify the normal behavior of FreePBX. It takes a good understanding of how Asterisk processes these includes to use this and in many of the cases, there is no useful application. All includes will result in a WARNING in the Asterisk log if there is no context found to include though it results in no errors. If you know that you want the includes, you can set this to true. If you comment it out FreePBX will revert to legacy behavior and include the contexts.','bool','','0',0,0,'Dialplan and Operational','',0,-100), 
     294('NOOPTRACE','0','NoOp Traces in Dialplan',0,'Some modules will generate lots of NoOp() commands proceeded by a [TRACE](trace_level) that can be used during development or while trying to trace call flows. These NoOp() commands serve no other purpose so if you do not want to see excessive NoOp()s in your dialplan you can set this to 0. The higher the number the more detailed level of trace NoOp()s will be generated','select','0,1,2,3,4,5,6,7,8,9,10','0',0,0,'Dialplan and Operational','',0,-100), 
     295('DIVERSIONHEADER','0','Generate Diversion Headers',0,'If this value is set to true, then calls going out your outbound routes that originate from outside your PBX and were subsequently forwarded through a call forward, ring group, follow-me or other means, will have a SIP diversion header added to the call with the original incoming DID assuming there is a DID available. This is useful with some carriers that may require this under certain circumstances.','bool','','0',0,0,'Dialplan and Operational','',0,-100), 
     296('CFRINGTIMERDEFAULT','0','Call Forward Ringtimer Default',0,'This is the default time in seconds to try and connect a call that has been call forwarded by the server side CF, CFU and CFB options. (If your phones use client side CF such as SIP redirects, this will not have any affect) If set to the default of 0, it will use the standard ring timer. If set to -1 it will ring the forwarded number with no limit which is consistent with the behavior of some existing PBX systems. If set to any other value, it will ring for that duration before diverting the call to the users voicemail if they have one. This can be overridden for each extension.','select','-1,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120','0',0,0,'Dialplan and Operational','',0,-100), 
     297('DEFAULT_INTERNAL_AUTO_ANSWER','disabled','Internal Auto Answer Default',0,'Default setting for new extensions. When set to Intercom, calls to new extensions/users from other internal users act as if they were intercom calls meaning they will be auto-answered if the endpoint supports this feature and the system is configured to operate in this mode. All the normal white list and black list settings will be honored if they are set. External calls will still ring as normal, as will certain other circumstances such as blind transfers and when a Follow Me is configured and enabled. If Disabled, the phone rings as a normal phone.','select','disabled,intercom','disabled',0,0,'Dialplan and Operational','',0,-100), 
     298('FORCE_INTERNAL_AUTO_ANSWER_ALL','0','Force All Internal Auto Answer',0,'Force all extensions to operate in the Internal Auto Answer mode regardless of their individual settings. See \'Internal Auto Answer Default\' for more information.','bool','','0',0,0,'Dialplan and Operational','',0,-100), 
     299('CONCURRENCYLIMITDEFAULT','0','Extension Concurrency Limit',0,'Default maximum number of outbound simultaneous calls that an extension can make. This is also very useful as a Security Protection against a system that has been compromised. It will limit the number of simultaneous calls that can be made on the compromised extension. This default is used when an extension is created. A default of 0 means no limit.','select','0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120','0',0,0,'Dialplan and Operational','',0,-100), 
     300('BLOCK_OUTBOUND_TRUNK_CNAM','0','Block CNAM on External Trunks',0,'Some carriers will reject a call if a CallerID Name (CNAM) is presented. This occurs in several areas when configuring CID on the PBX using the format of \"CNAM\" <CNUM>. To remove the CNAM part of CID on all external trunks, set this value to true. This WILL NOT remove CNAM when a trunk is called from an Intra-Company route. This can be done on each individual trunk in addition to globally if there are trunks where it is desirable to keep CNAM information, though most carriers ignore CNAM.','bool','','0',0,0,'Dialplan and Operational','',0,-100), 
     301('ASTSTOPTIMEOUT','120','Waiting Period to Stop Asterisk',0,'When Asterisk is stopped or restarted with the \'amportal stop/restart\' commands, it does a graceful stop waiting for active channels to hangup. This sets the maximum time in seconds to wait prior to force stopping Asterisk','select','0,5,10,30,60,120,300,600,1800,3600,7200,10800','120',0,0,'Dialplan and Operational','',0,-100), 
     302('ASTSTOPPOLLINT','2','Polling Interval for Stopping Asterisk',0,'When Asterisk is stopped or restarted with the \'amportal stop/restart\' commands, it does a graceful stop waiting for active channels to hangup. This sets the polling interval to check if Asterisk is shutdown and update the countdown timer.','select','1,2,3,5,10','2',0,0,'Dialplan and Operational','',0,-100), 
     303('CID_PREPEND_REPLACE','1','Only Use Last CID Prepend',0,'Some modules allow the CNAM to be prepended. If a previous prepend was done, the default behavior is to remove the previous prepend and only use the most recent one. Setting this to false will turn that off allowing all prepends to be \'starcked\' in front of one another.','bool','','1',0,0,'Dialplan and Operational','',0,-100), 
     304('DITECH_VQA_INBOUND','7','Ditech VQA Inbound Setting',0,'If Ditech\'s VQA, Voice Quality application is installed, this setting will be used for all inbound calls. For more information \'core show application VQA\' at the Asterisk CLI will show the different settings.','select','0,1,2,3,4,5,6,7','7',0,0,'Dialplan and Operational','',0,-100), 
     305('DITECH_VQA_OUTBOUND','7','Ditech VQA Outbound Setting',0,'If Ditech\'s VQA, Voice Quality application is installed, this setting will be used for all outbound calls. For more information \'core show application VQA\' at the Asterisk CLI will show the different settings.','select','0,1,2,3,4,5,6,7','7',0,0,'Dialplan and Operational','',0,-100), 
     306('AMPBIN','/var/lib/asterisk/bin','FreePBX bin Dir',4,'Location of the FreePBX command line scripts.','dir','','/var/lib/asterisk/bin',1,0,'Directory Layout','',0,-100), 
     307('AMPSBIN','/usr/local/sbin','FreePBX sbin Dir',4,'Where (root) command line scripts are located.','dir','','/usr/sbin',1,0,'Directory Layout','',0,-100), 
     308('AMPWEBROOT','/var/www/html','FreePBX Web Root Dir',4,'The path to Apache webroot (leave off trailing slash).','dir','','/var/www/html',1,0,'Directory Layout','',0,-100), 
     309('ASTAGIDIR','/usr/share/asterisk/agi-bin','Asterisk AGI Dir',4,'This is the default directory for Asterisks agi files.','dir','','/var/lib/asterisk/agi-bin',1,0,'Directory Layout','',0,-100), 
     310('ASTETCDIR','/etc/asterisk','Asterisk etc Dir',4,'This is the default directory for Asterisks configuration files.','dir','','/etc/asterisk',1,0,'Directory Layout','',0,-100), 
     311('ASTLOGDIR','/var/log/asterisk','Asterisk Log Dir',4,'This is the default directory for Asterisks log files.','dir','','/var/log/asterisk',1,0,'Directory Layout','',0,-100), 
     312('ASTMODDIR','/usr/lib64/asterisk/modules','Asterisk Modules Dir',4,'This is the default directory for Asterisks modules.','dir','','/usr/lib/asterisk/modules',1,0,'Directory Layout','',0,-100), 
     313('ASTSPOOLDIR','/var/spool/asterisk','Asterisk Spool Dir',4,'This is the default directory for Asterisks spool directory.','dir','','/var/spool/asterisk',1,0,'Directory Layout','',0,-100), 
     314('ASTRUNDIR','/var/run/asterisk','Asterisk Run Dir',4,'This is the default directory for Asterisks run files.','dir','','/var/run/asterisk',1,0,'Directory Layout','',0,-100), 
     315('ASTVARLIBDIR','/usr/share/asterisk','Asterisk bin Dir',4,'This is the default directory for Asterisks lib files.','dir','','/var/lib/asterisk',1,0,'Directory Layout','',0,-100), 
     316('AMPCGIBIN','/var/www/cgi-bin ','CGI Dir',4,'The path to Apache cgi-bin dir (leave off trailing slash).','dir','','/var/www/cgi-bin ',1,0,'Directory Layout','',0,-100), 
     317('MOHDIR','mohmp3','MoH Subdirectory',4,'This is the subdirectory for the MoH files/directories which is located in ASTVARLIBDIR. Older installation may be using mohmp3 which was the old Asterisk default and should be set to that value if the music files are located there relative to the ASTVARLIBDIR.','select','moh,mohmp3','moh',1,0,'Directory Layout','',0,-100), 
     318('CHECKREFERER','1','Check Server Referrer',0,'When set to the default value of true, all requests into FreePBX that might possibly add/edit/delete settings will be validated to assure the request is coming from the server. This will protect the system from CSRF (cross site request forgery) attacks. It will have the effect of preventing legitimately entering URLs that could modify settings which can be allowed by changing this field to false.','bool','','1',0,0,'GUI Behavior','',0,-100), 
     319('MODULEADMINWGET','0','Use wget For Module Admin',0,'Module Admin normally tries to get its online information through direct file open type calls to URLs that go back to the freepbx.org server. If it fails, typically because of content filters in firewalls that do not like the way PHP formats the requests, the code will fall back and try a wget to pull the information. This will often solve the problem. However, in such environment there can be a significant timeout before the failed file open calls to the URLs return and there are often 2-3 of these that occur. Setting this value will force FreePBX to avoid the attempt to open the URL and go straight to the wget calls.','bool','','0',0,0,'GUI Behavior','',0,-100), 
     320('USECATEGORIES','1','Show Categories in Nav Menu',0,'Controls if the menu items in the admin interface are sorted by category (true) or sorted alphabetically with no categories shown (false). Defaults = true','bool','','1',0,0,'GUI Behavior','',0,-100), 
     321('SERVERINTITLE','0','Include Server Name in Browser',0,'Precede browser title with the server name.','bool','','0',0,0,'GUI Behavior','',0,-100), 
     322('RELOADCONFIRM','1','Require Confirm with Apply Changes',0,'When set to false, will bypass the confirm on Reload Box.','bool','','1',0,0,'GUI Behavior','',0,-100), 
     323('BADDESTABORT','0','Abort Config Gen on Bad Dest',3,'Setting either of these to true will result in retrieve_conf aborting during a reload if an extension conflict is detected or a destination is detected. It is usually better to allow the reload to go through and then correct the problem but these can be set if a more strict behavior is desired.','bool','','0',0,0,'GUI Behavior','',0,-100), 
     324('XTNCONFLICTABORT','0','Abort Config Gen on Exten Conflict',3,'Setting either of these to true will result in retrieve_conf aborting during a reload if an extension conflict is detected or a destination is detected. It is usually better to allow the reload to go through and then correct the problem but these can be set if a more strict behavior is desired.','bool','','0',0,0,'GUI Behavior','',0,-100), 
     325('CUSTOMASERROR','1','Report Unknown Dest as Error',2,'If false, then the Destination Registry will not report unknown destinations as errors. This should be left to the default true and custom destinations should be moved into the new custom apps registry.','bool','','1',0,0,'GUI Behavior','',0,-100), 
     326('ALWAYS_SHOW_DEVICE_DETAILS','0','Show all Device Setting on Add',0,'When adding a new extension/device, setting this to true will show most available device settings that are displayed when you edit the same extension/device. Otherwise, just a few basic settings are displayed.','bool','','0',0,0,'Device Settings','',0,10), 
     327('AMPMGRPASS','unset','Asterisk Manager Password',2,'Password for accessing the Asterisk Manager Interface (AMI), you must change this in manager.conf if changed here.','text','','amp111',1,0,'Asterisk Manager','',0,-100), 
     328('AMPMGRUSER','admin','Asterisk Manager User',2,'Username for accessing the Asterisk Manager Interface (AMI), you must change this in manager.conf if changed here.','text','','admin',1,0,'Asterisk Manager','',0,-100), 
     329('ASTMANAGERHOST','localhost','Asterisk Manager Host',2,'Hostname for the Asterisk Manager','text','','localhost',1,0,'Asterisk Manager','',0,-100), 
     330('ASTMANAGERPORT','5038','Asterisk Manager Port',2,'Port for the Asterisk Manager','int','1024,65535','5038',1,0,'Asterisk Manager','',0,-100), 
     331('ASTMANAGERPROXYPORT','','Asterisk Manager Proxy Port',2,'Optional port for an Asterisk Manager Proxy','int','1024,65535','',1,0,'Asterisk Manager','',1,-100), 
     332('FPBXDBUGFILE','/tmp/freepbx_debug.log','Debug File',2,'Full path and name of FreePBX debug file. Used by the dbug() function by developers.','text','','/tmp/freepbx_debug.log',0,0,'Developer and Customization','',0,-100), 
     333('FPBXDBUGDISABLE','1','Disable FreePBX dbug Logging',2,'Set to true to stop all dbug() calls from writing to the Debug File (FPBXDBUGFILE)','bool','','1',0,0,'Developer and Customization','',0,-100), 
     334('DIE_FREEPBX_VERBOSE','0','Provide Verbose Tracebacks',2,'Provides a very verbose traceback when die_freepbx() is called including extensive object details if present in the traceback.','bool','','0',0,0,'Developer and Customization','',0,-100), 
     335('DEVEL','0','Developer Mode',2,'This enables several debug features geared towards developers, including some page load timing information, some debug information in Module Admin, use of original CSS files and other future capabilities will be enabled.','bool','','0',0,0,'Developer and Customization','',0,-100), 
     336('USE_PACKAGED_JS','1','Use Packaged Javascript Library ',2,'FreePBX packages several javascript libraries and components into a compressed file called libfreepbx.javascript.js. By default this will be loaded instead of the individual uncompressed libraries. Setting this to false will force FreePBX to load all the libraries as individual uncompressed files. This is useful during development and debugging.','bool','','1',0,0,'Developer and Customization','',0,-100), 
     337('FORCE_JS_CSS_IMG_DOWNLOAD','0','Always Download Web Assets',2,'FreePBX appends versioning tags on the CSS and javascript files and some of the main logo images. The versioning will help force browsers to load new versions of the files when module versions are upgraded. Setting this value to true will try to force these to be loaded to the browser every page load by appending an additional timestamp in the version information. This is useful during development and debugging where changes are being made to javascript and CSS files.','bool','','0',0,0,'Developer and Customization','',0,-100), 
     338('DEVELRELOAD','0','Leave Reload Bar Up',2,'Forces the \"Apply Configuration Changes\" reload bar to always be present even when not necessary.','bool','','0',0,0,'Developer and Customization','',0,-100), 
     339('PRE_RELOAD','','PRE_RELOAD Script',2,'Optional script to run just prior to doing an extension reload to Asterisk through the manager after pressing Apply Configuration Changes in the GUI.','text','','',1,0,'Developer and Customization','',1,-100), 
     340('POST_RELOAD','','POST_RELOAD Script',2,'Automatically execute a script after applying changes in the AMP admin. Set POST_RELOAD to the script you wish to execute after applying changes. If POST_RELOAD_DEBUG=true, you will see the output of the script in the web page.','text','','',1,0,'Developer and Customization','',1,-100), 
     341('POST_RELOAD_DEBUG','0','POST_RELOAD Debug Mode',2,'Display debug output for script used if POST_RELOAD is used.','bool','','0',0,0,'Developer and Customization','',0,-100), 
     342('AMPLOCALBIN','','AMPLOCALBIN Dir for retrieve_conf',2,'If this directory is defined, retrieve_conf will check for a file called <i>retrieve_conf_post_custom</i> and if that file exists, it will be included after other processing thus having full access to the current environment for additional customization.','dir','','',1,0,'Developer and Customization','',1,-100), 
     343('DISABLE_CSS_AUTOGEN','0','Disable Mainstyle CSS Compression',2,'Stops the automatic generation of a stripped CSS file that replaces the primary sheet, usually mainstyle.css.','bool','','0',0,0,'Developer and Customization','',0,-100), 
     344('MODULEADMIN_SKIP_CACHE','0','Disable Module Admin Caching',2,'Module Admin caches a copy of the online XML document that describes what is available on the server. Subsequent online update checks will use the cached information if it is less than 5 minutes old. To bypass the cache and force it to go to the server each time, set this to True. This should normally be false but can be helpful during testing.','bool','','0',1,0,'Developer and Customization','',0,-100), 
     345('FOPSORT','extension','FOP Sort Mode',0,'How FOP sort extensions. By Last Name [lastname] or by Extension [extension].','select','extension,lastname','extension',0,0,'Flash Operator Panel','',0,-100), 
     346('FOPWEBROOT','/var/www/html/panel','FOP Web Root Dir',4,'Path to the Flash Operator Panel webroot (leave off trailing slash).','dir','','/var/www/html/panel',1,0,'Flash Operator Panel','',0,-100), 
     347('FOPPASSWORD','passw0rd','FOP Password',0,'Password for performing transfers and hangups in the Flash Operator Panel (FOP).','text','','passw0rd',0,0,'Flash Operator Panel','',0,-100), 
     348('FOPDISABLE','0','Disable FOP',0,'Set to true to disable FOP in interface and retrieve_conf.  Useful for sqlite3 or if you do not want FOP.','bool','','0',0,0,'Flash Operator Panel','',0,-100), 
     349('FOPRUN','1','Start FOP with amportal',0,'Set to true if you want FOP started by freepbx_engine (amportal_start), false otherwise.','bool','','1',0,0,'Flash Operator Panel','',0,-100), 
     350('CDRDBHOST','','Remote CDR DB Host',3,'DO NOT set this unless you know what you are doing. Only used if you do not use the default values provided by FreePBX.<br>Hostname of db server if not the same as AMPDBHOST.','text','','',1,0,'Remote CDR Database','',1,-100), 
     351('CDRDBNAME','','Remote CDR DB Name',3,'DO NOT set this unless you know what you are doing. Only used if you do not use the default values provided by FreePBX.<br>Name of database used for cdr records.','text','','',1,0,'Remote CDR Database','',1,-100), 
     352('CDRDBPASS','','Remote CDR DB Password',3,'DO NOT set this unless you know what you are doing. Only used if you do not use the default values provided by FreePBX.<br>Password for connecting to db if its not the same as AMPDBPASS.','text','','',1,0,'Remote CDR Database','',1,-100), 
     353('CDRDBPORT','','Remote CDR DB Port',3,'DO NOT set this unless you know what you are doing. Only used if you do not use the default values provided by FreePBX.<br>Port number for db host.','int','1024,65536','',1,0,'Remote CDR Database','',1,-100), 
     354('CDRDBTABLENAME','','Remote CDR DB Table',3,'DO NOT set this unless you know what you are doing. Only used if you do not use the default values provided by FreePBX. Name of the table in the db where the cdr is stored. cdr is default.','text','','',1,0,'Remote CDR Database','',1,-100), 
     355('CDRDBTYPE','','Remote CDR DB Type',3,'DO NOT set this unless you know what you are doing. Only used if you do not use the default values provided by FreePBX. Defaults to your configured AMDBENGINE.','select',',mysql,postgres','',1,0,'Remote CDR Database','',1,-100), 
     356('CDRDBUSER','','Remote CDR DB User',3,'DO NOT set this unless you know what you are doing. Only used if you do not use the default values provided by FreePBX. Username to connect to db with if it is not the same as AMPDBUSER.','text','','',1,0,'Remote CDR Database','',1,-100), 
     357('AMPADMINLOGO','','Legacy Right Logo',1,'Legacy setting, use BRAND_IMAGE_FREEPBX_RIGHT in the future. If set, this will override BRAND_IMAGE_FREEPBX_RIGHT. The setting is the name of the image file and is always assumed to be present in the admin/images directory. Overrides the standard logo that is to be displayed at the TOP RIGHT of the admin screen. This enables you to customize the look of the administration screen. NOTE: images need to be saved in the ..../admin/images directory of your AMP install. This image should be 55px in height.','text','','',1,0,'Styling and Logos','',1,0), 
     358('BRAND_IMAGE_HIDE_NAV_BACKGROUND','0','Hide Nav Background',1,'Hide the configured left navigation bar background.','bool','','0',0,0,'Styling and Logos','',0,10), 
     359('BRAND_IMAGE_SHADOW_SIDE_BACKGROUND','images/shadow-side-background.png','Image: shadow-side-background.png',1,'Styling image.','text','','images/shadow-side-background.png',1,0,'Styling and Logos','',1,20), 
     360('BRAND_IMAGE_FREEPBX_RIGHT','images/logo.png','Image: Right Upper',1,'Right upper logo. Use this setting instead of AMPADMINLOGO. Path is relative to admin.','text','','images/logo.png',1,0,'Styling and Logos','',0,30), 
     361('BRAND_IMAGE_FREEPBX_LEFT','images/freepbx_large.png','Image: Left Upper',1,'Left upper logo.  Path is relative to admin.','text','','images/freepbx_large.png',1,0,'Styling and Logos','',0,40), 
     362('BRAND_IMAGE_FREEPBX_FOOT','images/freepbx_small.png','Image: Footer',1,'Logo in footer.  Path is relative to admin.','text','','images/freepbx_small.png',1,0,'Styling and Logos','',1,50), 
     363('BRAND_IMAGE_RELOAD_LOADING','images/loading.gif','Image: Reload Screen',1,'Image used during a reload, default is animated GIF eating the * (asterisk).  Path is relative to admin.','text','','images/loading.gif',1,0,'Styling and Logos','',1,60), 
     364('BRAND_FREEPBX_ALT_LEFT','','Alt for Left Logo',1,'alt attribute to use in place of image and title hover value. Defaults to FreePBX','text','','',1,0,'Styling and Logos','',1,70), 
     365('BRAND_FREEPBX_ALT_RIGHT','','Alt for Right Logo',1,'alt attribute to use in place of image and title hover value. Defaults to FreePBX','text','','',1,0,'Styling and Logos','',1,80), 
     366('BRAND_FREEPBX_ALT_FOOT','','Alt for Footer Logo',1,'alt attribute to use in place of image and title hover value. Defaults to FreePBX','text','','',1,0,'Styling and Logos','',1,90), 
     367('BRAND_IMAGE_FREEPBX_LINK_LEFT','','Link for Left Logo',1,'link to follow when clicking on logo, defaults to http://www.freepbx.org','text','','',1,0,'Styling and Logos','',1,100), 
     368('BRAND_IMAGE_FREEPBX_LINK_RIGHT','','Link for Right Logo',1,'link to follow when clicking on logo, defaults to http://www.freepbx.org','text','','',1,0,'Styling and Logos','',1,110), 
     369('BRAND_IMAGE_FREEPBX_LINK_FOOT','','Link for Footer Logo',1,'link to follow when clicking on logo, defaults to http://www.freepbx.org','text','','',1,0,'Styling and Logos','',1,120), 
     370('BRAND_HIDE_LOGO_RIGHT','0','Hide Right Logo',1,'Setting to true will hide the upper right logo.','bool','','0',0,0,'Styling and Logos','',0,130), 
     371('BRAND_HIDE_HEADER_VERSION','0','Hide Left FreePBX Version',1,'Setting to true will hide the FreePBX version information below the left upper header.','bool','','0',0,0,'Styling and Logos','',0,140), 
     372('BRAND_HIDE_HEADER_MENUS','0','Hide Header Menus',1,'Setting to true will hide the complete horizontal menu bar in the header.','bool','','0',0,0,'Styling and Logos','',0,150), 
     373('BRAND_CSS_ALT_MAINSTYLE','','Primary CSS Stylesheet',1,'Set this to replace the default mainstyle.css style sheet with your own, relative to admin.','text','','',1,0,'Styling and Logos','',1,160), 
     374('BRAND_CSS_CUSTOM','','Optional Additional CSS Stylesheet',1,'Optional custom CSS style sheet included after the primary one and any module specific ones are loaded, relative to admin.','text','','',1,0,'Styling and Logos','',1,170), 
     375('VIEW_FREEPBX_ADMIN','views/freepbx_admin.php','View: freepbx_admin.php',1,'freepbx_admin.php view. This should never be changed except for very advanced layout changes.','text','','views/freepbx_admin.php',1,1,'Styling and Logos','',0,180), 
     376('VIEW_FREEPBX','views/freepbx.php','View: freepbx.php',1,'freepbx.php view. This should never be changed except for very advanced layout changes.','text','','views/freepbx.php',1,1,'Styling and Logos','',0,190), 
     377('VIEW_FREEPBX_RELOAD','views/freepbx_reload.php','View: freepbx_reload.php',1,'freepbx_reload.php view. This should never be changed except for very advanced layout changes.','text','','views/freepbx_reload.php',1,1,'Styling and Logos','',0,200), 
     378('VIEW_FREEPBX_RELOADBAR','views/freepbx_reloadbar.php','View: freepbx_reloadbar.php',1,'freepbx_reloadbar.php view. This should never be changed except for very advanced layout changes.','text','','views/freepbx_reloadbar.php',1,1,'Styling and Logos','',0,210), 
     379('VIEW_WELCOME','views/welcome.php','View: welcome.php',1,'welcome.php view. This should never be changed except for very advanced layout changes.','text','','views/welcome.php',1,1,'Styling and Logos','',0,220), 
     380('VIEW_WELCOME_NONMANAGER','views/welcome_nomanager.php','View: welcome_nomanager.php',1,'welcome_nomanager.php view. This should never be changed except for very advanced layout changes.','text','','views/welcome_nomanager.php',1,1,'Styling and Logos','',0,230), 
     381('VIEW_MENUITEM_DISABLED','views/menuitem_disabled.php','View: menuitem_disabled.php',1,'menuitem_disabled.php view. This should never be changed except for very advanced layout changes.','text','','views/menuitem_disabled.php',1,1,'Styling and Logos','',0,240), 
     382('VIEW_NOACCESS','views/noaccess.php','View: noaccess.php',1,'noaccess.php view. This should never be changed except for very advanced layout changes.','text','','views/noaccess.php',1,1,'Styling and Logos','',0,250), 
     383('VIEW_UNAUTHORIZED','views/unauthorized.php','View: unauthorized.php',1,'unauthorized.php view. This should never be changed except for very advanced layout changes.','text','','views/unauthorized.php',1,1,'Styling and Logos','',0,260), 
     384('VIEW_BAD_REFFERER','views/bad_refferer.php','View: bad_refferer.php',1,'bad_refferer.php view. This should never be changed except for very advanced layout changes.','text','','views/bad_refferer.php',1,1,'Styling and Logos','',0,270), 
     385('VIEW_LOGGEDOUT','views/loggedout.php','View: loggedout.php',1,'loggedout.php view. This should never be changed except for very advanced layout changes.','text','','views/loggedout.php',1,1,'Styling and Logos','',0,280), 
     386('VIEW_PANEL','views/panel.php','View: panel.php',1,'panel.php view. This should never be changed except for very advanced layout changes.','text','','views/panel.php',1,1,'Styling and Logos','',0,290), 
     387('VIEW_REPORTS','views/reports.php','View: reports.php',1,'reports.php view. This should never be changed except for very advanced layout changes.','text','','views/reports.php',1,1,'Styling and Logos','',0,300), 
     388('DEVICE_STRONG_SECRETS','1','Require Strong Secrets',0,'Requires a strong secret on SIP and IAX devices requiring at least two numeric and non-numeric characters and 6 or more characters. This can be disabled if using devices that can not meet these needs, or you prefer to put other constraints including more rigid constraints that this rule actually considers weak when it may not be.','bool','','1',0,0,'Device Settings','',0,12), 
     389('DEVICE_SIP_CANREINVITE','no','SIP canrenivite (directmedia)',0,'Default setting for SIP canreinvite (same as directmedia). See Asterisk documentation for details.','select','no,yes,nonat,update','no',0,0,'Device Settings','',0,20), 
     390('DEVICE_SIP_TRUSTRPID','yes','SIP trustrpid',0,'Default setting for SIP trustrpid. See Asterisk documentation for details.','select','no,yes','yes',0,0,'Device Settings','',0,30), 
     391('DEVICE_SIP_SENDRPID','no','SIP sendrpid',0,'Default setting for SIP sendrpid. A value of \'yes\' is equivalent to \'rpid\' and will send the \'Remote-Party-ID\' header. A value of \'pai\' is only valid starting with Asterisk 1.8 and will send the \'P-Asserted-Identity\' header. See Asterisk documentation for details.','select','no,yes,pai','no',0,0,'Device Settings','',0,40), 
     392('DEVICE_SIP_NAT','no','SIP nat',0,'Default setting for SIP nat. A \'yes\' will attempt to handle nat, also works for local (uses the network ports and address instead of the reported ports), \'no\' follows the protocol, \'never\' tries to block it, no RFC3581, \'route\' ignores the rport information. See Asterisk documentation for details.','select','no,yes,never,route','no',0,0,'Device Settings','',0,50), 
     393('DEVICE_SIP_ENCRYPTION','no','SIP encryption',0,'Default setting for SIP encryption. Whether to offer SRTP encrypted media (and only SRTP encrypted media) on outgoing calls to a peer. Calls will fail with HANGUPCAUSE=58 if the peer does not support SRTP. See Asterisk documentation for details.','select','no,yes','no',0,0,'Device Settings','',0,60), 
     394('DEVICE_SIP_QUALIFYFREQ','60','SIP qualifyfreq',0,'Default setting for SIP qualifyfreq. Only valid for Asterisk 1.6 and above. Frequency that \'qualify\' OPTIONS messages will be sent to the device. Can help to keep NAT holes open but not dependable for remote client firewalls. See Asterisk documentation for details.','int','15,86400','60',0,0,'Device Settings','',0,70), 
     395('DEVICE_QUALIFY','yes','SIP and IAX qualify',0,'Default setting for SIP and IAX qualify. Whether to send periodic OPTIONS messages (for SIP) or otherwise monitor the channel, and at what point to consider the channel unavailable. A value of \'yes\' is equivalent to 2000, time in msec. Can help to keep NAT holes open with SIP but not dependable for remote client firewalls. See Asterisk documentation for details.','text','','yes',0,0,'Device Settings','',0,80), 
     396('DEVICE_DISALLOW','','SIP and IAX disallow',0,'Default setting for SIP and IAX disallow (for codecs). Codecs to disallow, can help to reset from the general settings by setting a value of \'all\' and then specifically including allowed codecs with the \'allow\' directive. Values van be separated with \'&\' e.g. \'g729&g722\'. See Asterisk documentation for details.','text','','',0,0,'Device Settings','',1,90), 
     397('DEVICE_ALLOW','','SIP and IAX allow',0,'Default setting for SIP and IAX allow (for codecs). Codecs to allow in addition to those set in general settings unless explicitly \'disallowed\' for the device. Values van be separated with \'&\' e.g. \'ulaw&g729&g729\' where the preference order is preserved. See Asterisk documentation for details.','text','','',0,0,'Device Settings','',1,90), 
     398('DEVICE_CALLGROUP','','SIP and DAHDi callgroup',0,'Default setting for SIP, DAHDi (and Zap) callgroup. Callgroup(s) that the device is part of, can be one or more callgroups, e.g. \'1,3-5\' would be in groups 1,3,4,5. See Asterisk documentation for details.','text','','',0,0,'Device Settings','',1,100), 
     399('DEVICE_PICKUPGROUP','','SIP and DAHDi pickupgroup',0,'Default setting for SIP, DAHDi (and Zap) pickupgroup. Pickupgroups(s) that the device can pickup calls from, can be one or more groups, e.g. \'1,3-5\' would be in groups 1,3,4,5. Device does not have to be in a group to be able to pickup calls from that group. See Asterisk documentation for details.','text','','',0,0,'Device Settings','',1,110), 
     400('ASTVERSION','1.8.5.0','Asterisk Version',10,'Last Asterisk Version detected (or forced)','text','','',1,1,'Internal Use','',1,0), 
     401('AST_FUNC_DEVICE_STATE','DEVICE_STATE','Asterisk Function DEVICE_STATE',10,'Set to the function name if the function is present in this Asterisk install','text','','',1,1,'Internal Use','',1,0), 
     402('AST_FUNC_EXTENSION_STATE','EXTENSION_STATE','Asterisk Function EXTENSION_STATE',10,'Set to the function name if the function is present in this Asterisk install','text','','',1,1,'Internal Use','',1,0), 
     403('AST_FUNC_SHARED','SHARED','Asterisk Function SHARED',10,'Set to the function name if the function is present in this Asterisk install','text','','',1,1,'Internal Use','',1,0), 
     404('AST_FUNC_CONNECTEDLINE','CONNECTEDLINE','Asterisk Function CONNECTEDLINE',10,'Set to the function name if the function is present in this Asterisk install','text','','',1,1,'Internal Use','',1,0), 
     405('AST_FUNC_MASTER_CHANNEL','MASTER_CHANNEL','Asterisk Function MASTER_CHANNEL',10,'Set to the function name if the function is present in this Asterisk install','text','','',1,1,'Internal Use','',1,0), 
     406('AST_APP_VQA','','Asterisk Application VQA',10,'Set to the application name if the application is present in this Asterisk install','text','','',1,1,'Internal Use','',1,0), 
     407('AUTOMIXMON','0','Use Automixmon for One-Touch Recording',0,'Starting with Asterisk 1.6, one-touch-recording can be toggled on and off during a call if the dial options had \'x\' and/or \'X\' options set. When this is set to true, the \'In-Call Asterisk Toggle Call Recording\' will use the asterisk \'automixmon\' option instead of the \'automon\' option to set this. Only one or the other can be set from the GUI. You need to set the proper options of \'x\' and/or \'X\' when using this, or \'w\' and/or \'W\' if using the older \'automon\' version. Setting this to true will have no effect on systems running Asterisk 1.4 or earlier.','bool','','0',0,0,'Dialplan and Operational','',0,0), 
     408('VMX_CONTEXT','from-internal','VMX Default Context',9,'Used to do extremely advanced and customized changes to the macro-vm VmX locater. Check the dialplan for a thorough understanding of how to use this.','text','','from-internal',1,0,'VmX Locater','',0,0), 
     409('VMX_PRI','1','VMX Default Priority',9,'Used to do extremely advanced and customized changes to the macro-vm VmX locater. Check the dialplan for a thorough understanding of how to use this.','int','1,1000','1',1,0,'VmX Locater','',0,0), 
     410('VMX_TIMEDEST_CONTEXT','','VMX Default Timeout Context',9,'Used to do extremely advanced and customized changes to the macro-vm VmX locater. Check the dialplan for a thorough understanding of how to use this. The default location that a caller will be sent if they don\'t press any key (timeout) or press # which is interpreted as a timeout. Set this to \'dovm\' to go to voicemail (default).','text','','',1,0,'VmX Locater','',1,0), 
     411('VMX_TIMEDEST_EXT','dovm','VMX Default Timeout Extension',9,'Used to do extremely advanced and customized changes to the macro-vm VmX locater. Check the dialplan for a thorough understanding of how to use this. The default location that a caller will be sent if they don\'t press any key (timeout) or press # which is interpreted as a timeout. Set this to \'dovm\' to go to voicemail (default).','text','','dovm',1,0,'VmX Locater','',0,0), 
     412('VMX_TIMEDEST_PRI','1','VMX Default Timeout Priority',9,'Used to do extremely advanced and customized changes to the macro-vm VmX locater. Check the dialplan for a thorough understanding of how to use this. The default location that a caller will be sent if they don\'t press any key (timeout) or press # which is interpreted as a timeout. Set this to \'dovm\' to go to voicemail (default).','int','1,1000','1',1,0,'VmX Locater','',0,0), 
     413('VMX_LOOPDEST_CONTEXT','','VMX Default Loop Exceed Context',9,'Used to do extremely advanced and customized changes to the macro-vm VmX locater. Check the dialplan for a thorough understanding of how to use this. The default location that a caller will be sent if they press an invalid options too many times, as defined by the Maximum Loops count.','text','','',1,0,'VmX Locater','',1,0), 
     414('VMX_LOOPDEST_EXT','dovm','VMX Default Loop Exceed Extension',9,'Used to do extremely advanced and customized changes to the macro-vm VmX locater. Check the dialplan for a thorough understanding of how to use this. The default location that a caller will be sent if they press an invalid options too many times, as defined by the Maximum Loops count.','text','','dovm',1,0,'VmX Locater','',0,0), 
     415('VMX_LOOPDEST_PRI','1','VMX Default Loop Exceed Priority',9,'Used to do extremely advanced and customized changes to the macro-vm VmX locater. Check the dialplan for a thorough understanding of how to use this. The default location that a caller will be sent if they press an invalid options too many times, as defined by the Maximum Loops count.','int','1,1000','1',1,0,'VmX Locater','',0,0), 
     416('MIXMON_DIR','','Override Call Recording Location',9,'Override the default location where asterisk will store call recordings. Be sure to set proper permissions on the directory for the asterisk user.','dir','','',1,0,'Directory Layout','',1,0), 
     417('MIXMON_POST','','Post Call Recording Script',9,'An optional script to be run after the call is hangup. You can include channel and MixMon variables like ${CALLFILENAME}, ${MIXMON_FORMAT} and ${MIXMON_DIR}. To ensure that you variables are properly escaped, use the following notation: ^{MY_VAR}','text','','',1,0,'Developer and Customization','',1,0), 
     418('DASHBOARD_STATS_UPDATE_TIME','6','Dashboard Stats Update Frequency',0,'Update rate in seconds of all sections of the System Status panel except the Info box.','select','6,10,20,30,45,60,120,300,600','6',0,0,'GUI Behavior','dashboard',0,0), 
     419('DASHBOARD_INFO_UPDATE_TIME','30','Dashboard Info Update Frequency',0,'Update rate in seconds of the Info section of the System Status panel.','select','15,30,60,120,300,600','30',0,0,'GUI Behavior','dashboard',0,0), 
     420('SSHPORT','','Dashboard Non-Std SSH Port',2,'SSH port number configured on your system if not using the default port 22, this allows the dashboard monitoring to watch the poper port.','int','1,65535','',0,0,'System Setup','dashboard',1,0), 
     421('MAXCALLS','','Dashboard Max Calls Initial Scale',2,'Use this to pre-set the scale for maximum calls on the Dashboard display. If not set, the the scale is dynamically sized based on the active calls on the system.','int','0,3000','',0,0,'GUI Behavior','dashboard',1,0); 
     422/*!40000 ALTER TABLE `freepbx_settings` ENABLE KEYS */; 
     423UNLOCK TABLES; 
    186424 
    187425-- 
     
    190428 
    191429DROP TABLE IF EXISTS `globals`; 
     430/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     431/*!40101 SET character_set_client = utf8 */; 
    192432CREATE TABLE `globals` ( 
    193   `variable` varchar(255) NOT NULL default '', 
    194   `value` varchar(255) NOT NULL default '', 
    195   PRIMARY KEY  (`variable`) 
    196 ); 
     433  `variable` varchar(255) NOT NULL, 
     434  `value` varchar(255) NOT NULL, 
     435  PRIMARY KEY (`variable`) 
     436) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     437/*!40101 SET character_set_client = @saved_cs_client */; 
    197438 
    198439-- 
     
    200441-- 
    201442 
    202  
     443LOCK TABLES `globals` WRITE; 
    203444/*!40000 ALTER TABLE `globals` DISABLE KEYS */; 
    204 -- LOCK TABLES `globals` WRITE; 
    205 INSERT INTO `globals` VALUES ('CALLFILENAME','\"\"'); 
    206 INSERT INTO `globals` VALUES ('DIAL_OPTIONS','tr'); 
    207 INSERT INTO `globals` VALUES ('TRUNK_OPTIONS',''); 
    208 INSERT INTO `globals` VALUES ('DIAL_OUT','9'); 
    209 INSERT INTO `globals` VALUES ('FAX',''); 
    210 INSERT INTO `globals` VALUES ('FAX_RX','system'); 
    211 INSERT INTO `globals` VALUES ('FAX_RX_EMAIL','noreply@mydomain.tld'); 
    212 INSERT INTO `globals` VALUES ('FAX_RX_FROM','noreply@mydomain.tld'); 
    213 INSERT INTO `globals` VALUES ('INCOMING','group-all'); 
    214 INSERT INTO `globals` VALUES ('NULL','\"\"'); 
    215 INSERT INTO `globals` VALUES ('OPERATOR',''); 
    216 INSERT INTO `globals` VALUES ('OPERATOR_XTN',''); 
    217 INSERT INTO `globals` VALUES ('PARKNOTIFY','SIP/200'); 
    218 INSERT INTO `globals` VALUES ('RECORDEXTEN','\"\"'); 
    219 INSERT INTO `globals` VALUES ('RINGTIMER','15'); 
    220 INSERT INTO `globals` VALUES ('DIRECTORY','last'); 
    221 INSERT INTO `globals` VALUES ('AFTER_INCOMING',''); 
    222 INSERT INTO `globals` VALUES ('IN_OVERRIDE','forcereghours'); 
    223 INSERT INTO `globals` VALUES ('REGTIME','7:55-17:05'); 
    224 INSERT INTO `globals` VALUES ('REGDAYS','mon-fri'); 
    225 INSERT INTO `globals` VALUES ('DIRECTORY_OPTS',''); 
    226 INSERT INTO `globals` VALUES ('DIALOUTIDS','1'); 
    227 INSERT INTO `globals` VALUES ('OUT_1','ZAP/g0'); 
    228 INSERT INTO `globals` VALUES ('VM_PREFIX','*'); 
    229 INSERT INTO `globals` VALUES ('VM_OPTS',''); 
    230 INSERT INTO `globals` VALUES ('VM_GAIN',''); 
    231 INSERT INTO `globals` VALUES ('VM_DDTYPE','u'); 
    232 INSERT INTO `globals` VALUES ('TIMEFORMAT','kM'); 
    233 INSERT INTO `globals` VALUES ('TONEZONE','us'); 
    234 INSERT INTO `globals` VALUES ('ALLOW_SIP_ANON','no'); 
    235 INSERT INTO `globals` VALUES ('VMX_CONTEXT','from-internal'); 
    236 INSERT INTO `globals` VALUES ('VMX_PRI','1'); 
    237 INSERT INTO `globals` VALUES ('VMX_TIMEDEST_CONTEXT',''); 
    238 INSERT INTO `globals` VALUES ('VMX_TIMEDEST_EXT','dovm'); 
    239 INSERT INTO `globals` VALUES ('VMX_TIMEDEST_PRI','1'); 
    240 INSERT INTO `globals` VALUES ('VMX_LOOPDEST_CONTEXT',''); 
    241 INSERT INTO `globals` VALUES ('VMX_LOOPDEST_EXT','dovm'); 
    242 INSERT INTO `globals` VALUES ('VMX_LOOPDEST_PRI','1'); 
    243 INSERT INTO `globals` VALUES ('VMX_OPTS_TIMEOUT',''); 
    244 INSERT INTO `globals` VALUES ('VMX_OPTS_LOOP',''); 
    245 INSERT INTO `globals` VALUES ('VMX_OPTS_DOVM',''); 
    246 INSERT INTO `globals` VALUES ('VMX_TIMEOUT','2'); 
    247 INSERT INTO `globals` VALUES ('VMX_REPEAT','1'); 
    248 INSERT INTO `globals` VALUES ('VMX_LOOPS','1'); 
    249 INSERT INTO `globals` VALUES ('TRANSFER_CONTEXT','from-internal-xfer'); 
    250 INSERT INTO `globals` VALUES ('MIXMON_FORMAT','wav'); 
    251 INSERT INTO `globals` VALUES ('MIXMON_DIR',''); 
    252 INSERT INTO `globals` VALUES ('MIXMON_POST',''); 
    253  
    254  
    255 -- UNLOCK TABLES; 
     445INSERT INTO `globals` VALUES ('CALLFILENAME','\"\"'),('DIAL_OPTIONS','tr'),('TRUNK_OPTIONS',''),('DIAL_OUT','9'),('FAX',''),('FAX_RX','system'),('FAX_RX_EMAIL','noreply@mydomain.tld'),('FAX_RX_FROM','noreply@mydomain.tld'),('INCOMING','group-all'),('NULL','\"\"'),('OPERATOR',''),('OPERATOR_XTN',''),('PARKNOTIFY','SIP/200'),('RECORDEXTEN','\"\"'),('RINGTIMER','15'),('DIRECTORY','last'),('AFTER_INCOMING',''),('IN_OVERRIDE','forcereghours'),('REGTIME','7:55-17:05'),('REGDAYS','mon-fri'),('DIRECTORY_OPTS',''),('DIALOUTIDS','1'),('RECORDING_STATE','ENABLED'),('VM_PREFIX','*'),('VM_OPTS',''),('VM_GAIN',''),('VM_DDTYPE','u'),('TIMEFORMAT','kM'),('TONEZONE','us'),('ALLOW_SIP_ANON','no'),('VMX_OPTS_TIMEOUT',''),('VMX_OPTS_LOOP',''),('VMX_OPTS_DOVM',''),('VMX_TIMEOUT','2'),('VMX_REPEAT','1'),('VMX_LOOPS','1'),('TRANSFER_CONTEXT','from-internal-xfer'),('MIXMON_FORMAT','wav'); 
    256446/*!40000 ALTER TABLE `globals` ENABLE KEYS */; 
     447UNLOCK TABLES; 
    257448 
    258449-- 
     
    261452 
    262453DROP TABLE IF EXISTS `iax`; 
     454/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     455/*!40101 SET character_set_client = utf8 */; 
    263456CREATE TABLE `iax` ( 
    264   `id` varchar(20) NOT NULL default '-1', 
    265   `keyword` varchar(30) NOT NULL default '', 
    266   `data` varchar(255) NOT NULL default '', 
    267   `flags` int(1) NOT NULL default '0', 
    268   PRIMARY KEY  (`id`,`keyword`) 
    269 ); 
     457  `id` varchar(20) NOT NULL DEFAULT '-1', 
     458  `keyword` varchar(30) NOT NULL DEFAULT '', 
     459  `data` varchar(255) NOT NULL, 
     460  `flags` int(1) NOT NULL DEFAULT '0', 
     461  PRIMARY KEY (`id`,`keyword`) 
     462) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     463/*!40101 SET character_set_client = @saved_cs_client */; 
    270464 
    271465-- 
     
    273467-- 
    274468 
    275  
     469LOCK TABLES `iax` WRITE; 
    276470/*!40000 ALTER TABLE `iax` DISABLE KEYS */; 
    277 -- LOCK TABLES `iax` WRITE; 
    278 -- UNLOCK TABLES; 
    279471/*!40000 ALTER TABLE `iax` ENABLE KEYS */; 
     472UNLOCK TABLES; 
    280473 
    281474-- 
     
    284477 
    285478DROP TABLE IF EXISTS `incoming`; 
     479/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     480/*!40101 SET character_set_client = utf8 */; 
    286481CREATE TABLE `incoming` ( 
    287   `cidnum` varchar(20) default NULL, 
    288   `extension` varchar(50) default NULL, 
    289   `destination` varchar(50) default NULL, 
    290   `faxexten` varchar(20) default NULL, 
    291   `faxemail` varchar(50) default NULL, 
    292   `answer` tinyint(1) default NULL, 
    293   `wait` int(2) default NULL, 
    294   `privacyman` tinyint(1) default NULL, 
    295   `alertinfo` varchar(255) default NULL, 
    296   `ringing` varchar(20) default NULL, 
    297   `mohclass` varchar(80) NOT NULL default 'default', 
    298   `description` varchar(80) default NULL, 
    299   `grppre` varchar (80) default NULL , 
    300   `delay_answer` int (2) default NULL 
    301 ); 
     482  `cidnum` varchar(20) DEFAULT NULL, 
     483  `extension` varchar(50) NOT NULL, 
     484  `destination` varchar(50) DEFAULT NULL, 
     485  `faxexten` varchar(20) DEFAULT NULL, 
     486  `faxemail` varchar(50) DEFAULT NULL, 
     487  `answer` tinyint(1) DEFAULT NULL, 
     488  `wait` int(2) DEFAULT NULL, 
     489  `privacyman` tinyint(1) DEFAULT NULL, 
     490  `alertinfo` varchar(255) DEFAULT NULL, 
     491  `ringing` varchar(20) DEFAULT NULL, 
     492  `mohclass` varchar(80) NOT NULL DEFAULT 'default', 
     493  `description` varchar(80) DEFAULT NULL, 
     494  `grppre` varchar(80) DEFAULT NULL, 
     495  `delay_answer` int(2) DEFAULT NULL, 
     496  `pricid` varchar(20) DEFAULT NULL, 
     497  `pmmaxretries` varchar(2) DEFAULT NULL, 
     498  `pmminlength` varchar(2) DEFAULT NULL 
     499) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     500/*!40101 SET character_set_client = @saved_cs_client */; 
     501 
     502-- 
     503-- Table structure for table `module_xml` 
     504-- 
     505 
     506DROP TABLE IF EXISTS `module_xml`; 
     507/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     508/*!40101 SET character_set_client = utf8 */; 
     509CREATE TABLE `module_xml` ( 
     510  `id` varchar(20) NOT NULL DEFAULT 'xml', 
     511  `time` int(11) NOT NULL DEFAULT '0', 
     512  `data` mediumblob NOT NULL, 
     513  PRIMARY KEY (`id`) 
     514) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     515/*!40101 SET character_set_client = @saved_cs_client */; 
     516 
     517-- 
     518-- Table structure for table `modules` 
     519-- 
     520 
     521DROP TABLE IF EXISTS `modules`; 
     522/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     523/*!40101 SET character_set_client = utf8 */; 
     524CREATE TABLE `modules` ( 
     525  `id` int(11) NOT NULL AUTO_INCREMENT, 
     526  `modulename` varchar(50) NOT NULL DEFAULT '', 
     527  `version` varchar(20) NOT NULL DEFAULT '', 
     528  `enabled` tinyint(4) NOT NULL DEFAULT '0', 
     529  PRIMARY KEY (`id`) 
     530) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; 
     531/*!40101 SET character_set_client = @saved_cs_client */; 
     532 
     533-- 
     534-- Table structure for table `notifications` 
     535-- 
     536 
     537DROP TABLE IF EXISTS `notifications`; 
     538/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     539/*!40101 SET character_set_client = utf8 */; 
     540CREATE TABLE `notifications` ( 
     541  `module` varchar(24) NOT NULL DEFAULT '', 
     542  `id` varchar(24) NOT NULL DEFAULT '', 
     543  `level` int(11) NOT NULL DEFAULT '0', 
     544  `display_text` varchar(255) NOT NULL DEFAULT '', 
     545  `extended_text` blob NOT NULL, 
     546  `link` varchar(255) NOT NULL DEFAULT '', 
     547  `reset` tinyint(4) NOT NULL DEFAULT '0', 
     548  `candelete` tinyint(4) NOT NULL DEFAULT '0', 
     549  `timestamp` int(11) NOT NULL DEFAULT '0', 
     550  PRIMARY KEY (`module`,`id`) 
     551) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     552/*!40101 SET character_set_client = @saved_cs_client */; 
     553 
     554-- 
     555-- Table structure for table `outbound_route_patterns` 
     556-- 
     557 
     558DROP TABLE IF EXISTS `outbound_route_patterns`; 
     559/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     560/*!40101 SET character_set_client = utf8 */; 
     561CREATE TABLE `outbound_route_patterns` ( 
     562  `route_id` int(11) NOT NULL, 
     563  `match_pattern_prefix` varchar(60) NOT NULL DEFAULT '', 
     564  `match_pattern_pass` varchar(60) NOT NULL DEFAULT '', 
     565  `match_cid` varchar(60) NOT NULL DEFAULT '', 
     566  `prepend_digits` varchar(100) NOT NULL DEFAULT '', 
     567  PRIMARY KEY (`route_id`,`match_pattern_prefix`,`match_pattern_pass`,`match_cid`,`prepend_digits`) 
     568) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     569/*!40101 SET character_set_client = @saved_cs_client */; 
     570 
     571-- 
     572-- Dumping data for table `outbound_route_patterns` 
     573-- 
     574 
     575LOCK TABLES `outbound_route_patterns` WRITE; 
     576/*!40000 ALTER TABLE `outbound_route_patterns` DISABLE KEYS */; 
     577/*!40000 ALTER TABLE `outbound_route_patterns` ENABLE KEYS */; 
     578UNLOCK TABLES; 
     579 
     580-- 
     581-- Table structure for table `outbound_route_sequence` 
     582-- 
     583 
     584DROP TABLE IF EXISTS `outbound_route_sequence`; 
     585/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     586/*!40101 SET character_set_client = utf8 */; 
     587CREATE TABLE `outbound_route_sequence` ( 
     588  `route_id` int(11) NOT NULL, 
     589  `seq` int(11) NOT NULL, 
     590  PRIMARY KEY (`route_id`,`seq`) 
     591) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     592/*!40101 SET character_set_client = @saved_cs_client */; 
     593 
     594-- 
     595-- Dumping data for table `outbound_route_sequence` 
     596-- 
     597 
     598LOCK TABLES `outbound_route_sequence` WRITE; 
     599/*!40000 ALTER TABLE `outbound_route_sequence` DISABLE KEYS */; 
     600/*!40000 ALTER TABLE `outbound_route_sequence` ENABLE KEYS */; 
     601UNLOCK TABLES; 
     602 
     603-- 
     604-- Table structure for table `outbound_route_trunks` 
     605-- 
     606 
     607DROP TABLE IF EXISTS `outbound_route_trunks`; 
     608/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     609/*!40101 SET character_set_client = utf8 */; 
     610CREATE TABLE `outbound_route_trunks` ( 
     611  `route_id` int(11) NOT NULL, 
     612  `trunk_id` int(11) NOT NULL, 
     613  `seq` int(11) NOT NULL, 
     614  PRIMARY KEY (`route_id`,`trunk_id`,`seq`) 
     615) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     616/*!40101 SET character_set_client = @saved_cs_client */; 
     617 
     618-- 
     619-- Dumping data for table `outbound_route_trunks` 
     620-- 
     621 
     622LOCK TABLES `outbound_route_trunks` WRITE; 
     623/*!40000 ALTER TABLE `outbound_route_trunks` DISABLE KEYS */; 
     624/*!40000 ALTER TABLE `outbound_route_trunks` ENABLE KEYS */; 
     625UNLOCK TABLES; 
     626 
     627-- 
     628-- Table structure for table `outbound_routes` 
     629-- 
     630 
     631DROP TABLE IF EXISTS `outbound_routes`; 
     632/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     633/*!40101 SET character_set_client = utf8 */; 
     634CREATE TABLE `outbound_routes` ( 
     635  `route_id` int(11) NOT NULL AUTO_INCREMENT, 
     636  `name` varchar(40) DEFAULT NULL, 
     637  `outcid` varchar(40) DEFAULT NULL, 
     638  `outcid_mode` varchar(20) DEFAULT NULL, 
     639  `password` varchar(30) DEFAULT NULL, 
     640  `emergency_route` varchar(4) DEFAULT NULL, 
     641  `intracompany_route` varchar(4) DEFAULT NULL, 
     642  `mohclass` varchar(80) DEFAULT NULL, 
     643  `time_group_id` int(11) DEFAULT NULL, 
     644  PRIMARY KEY (`route_id`) 
     645) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     646/*!40101 SET character_set_client = @saved_cs_client */; 
     647 
     648-- 
     649-- Dumping data for table `outbound_routes` 
     650-- 
     651 
     652LOCK TABLES `outbound_routes` WRITE; 
     653/*!40000 ALTER TABLE `outbound_routes` DISABLE KEYS */; 
     654/*!40000 ALTER TABLE `outbound_routes` ENABLE KEYS */; 
     655UNLOCK TABLES; 
     656 
     657-- 
     658-- Table structure for table `sip` 
     659-- 
     660 
     661DROP TABLE IF EXISTS `sip`; 
     662/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     663/*!40101 SET character_set_client = utf8 */; 
     664CREATE TABLE `sip` ( 
     665  `id` varchar(20) NOT NULL DEFAULT '-1', 
     666  `keyword` varchar(30) NOT NULL DEFAULT '', 
     667  `data` varchar(255) NOT NULL, 
     668  `flags` int(1) NOT NULL DEFAULT '0', 
     669  PRIMARY KEY (`id`,`keyword`) 
     670) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     671/*!40101 SET character_set_client = @saved_cs_client */; 
     672 
     673-- 
     674-- Dumping data for table `sip` 
     675-- 
     676 
     677LOCK TABLES `sip` WRITE; 
     678/*!40000 ALTER TABLE `sip` DISABLE KEYS */; 
     679/*!40000 ALTER TABLE `sip` ENABLE KEYS */; 
     680UNLOCK TABLES; 
     681 
     682-- 
     683-- Table structure for table `trunk_dialpatterns` 
     684-- 
     685 
     686DROP TABLE IF EXISTS `trunk_dialpatterns`; 
     687/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     688/*!40101 SET character_set_client = utf8 */; 
     689CREATE TABLE `trunk_dialpatterns` ( 
     690  `trunkid` int(11) NOT NULL DEFAULT '0', 
     691  `match_pattern_prefix` varchar(50) NOT NULL DEFAULT '', 
     692  `match_pattern_pass` varchar(50) NOT NULL DEFAULT '', 
     693  `prepend_digits` varchar(50) NOT NULL DEFAULT '', 
     694  `seq` int(11) NOT NULL DEFAULT '0', 
     695  PRIMARY KEY (`trunkid`,`match_pattern_prefix`,`match_pattern_pass`,`prepend_digits`,`seq`) 
     696) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     697/*!40101 SET character_set_client = @saved_cs_client */; 
     698 
     699-- 
     700-- Dumping data for table `trunk_dialpatterns` 
     701-- 
     702 
     703LOCK TABLES `trunk_dialpatterns` WRITE; 
     704/*!40000 ALTER TABLE `trunk_dialpatterns` DISABLE KEYS */; 
     705/*!40000 ALTER TABLE `trunk_dialpatterns` ENABLE KEYS */; 
     706UNLOCK TABLES; 
     707 
     708-- 
     709-- Table structure for table `trunks` 
     710-- 
     711 
     712DROP TABLE IF EXISTS `trunks`; 
     713/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     714/*!40101 SET character_set_client = utf8 */; 
     715CREATE TABLE `trunks` ( 
     716  `trunkid` int(11) NOT NULL DEFAULT '0', 
     717  `name` varchar(50) NOT NULL DEFAULT '', 
     718  `tech` varchar(20) NOT NULL, 
     719  `outcid` varchar(40) NOT NULL DEFAULT '', 
     720  `keepcid` varchar(4) DEFAULT 'off', 
     721  `maxchans` varchar(6) DEFAULT '', 
     722  `failscript` varchar(255) NOT NULL DEFAULT '', 
     723  `dialoutprefix` varchar(255) NOT NULL DEFAULT '', 
     724  `channelid` varchar(255) NOT NULL DEFAULT '', 
     725  `usercontext` varchar(255) DEFAULT NULL, 
     726  `provider` varchar(40) DEFAULT NULL, 
     727  `disabled` varchar(4) DEFAULT 'off', 
     728  PRIMARY KEY (`trunkid`,`tech`,`channelid`) 
     729) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     730/*!40101 SET character_set_client = @saved_cs_client */; 
     731 
     732-- 
     733-- Dumping data for table `trunks` 
     734-- 
     735 
     736LOCK TABLES `trunks` WRITE; 
     737/*!40000 ALTER TABLE `trunks` DISABLE KEYS */; 
     738INSERT INTO `trunks` VALUES (1,'','zap','','','','','','g0','',NULL,'off'); 
     739/*!40000 ALTER TABLE `trunks` ENABLE KEYS */; 
     740UNLOCK TABLES; 
     741 
     742-- 
     743-- Table structure for table `users` 
     744-- 
     745 
     746DROP TABLE IF EXISTS `users`; 
     747/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     748/*!40101 SET character_set_client = utf8 */; 
     749CREATE TABLE `users` ( 
     750  `extension` varchar(20) NOT NULL DEFAULT '', 
     751  `password` varchar(20) DEFAULT NULL, 
     752  `name` varchar(50) DEFAULT NULL, 
     753  `voicemail` varchar(50) DEFAULT NULL, 
     754  `ringtimer` int(3) DEFAULT NULL, 
     755  `noanswer` varchar(100) DEFAULT NULL, 
     756  `recording` varchar(50) DEFAULT NULL, 
     757  `outboundcid` varchar(50) DEFAULT NULL, 
     758  `sipname` varchar(50) DEFAULT NULL, 
     759  `noanswer_cid` varchar(20) NOT NULL DEFAULT '', 
     760  `busy_cid` varchar(20) NOT NULL DEFAULT '', 
     761  `chanunavail_cid` varchar(20) NOT NULL DEFAULT '', 
     762  `noanswer_dest` varchar(255) NOT NULL DEFAULT '', 
     763  `busy_dest` varchar(255) NOT NULL DEFAULT '', 
     764  `chanunavail_dest` varchar(255) NOT NULL DEFAULT '', 
     765  `mohclass` varchar(80) DEFAULT 'default' 
     766) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     767/*!40101 SET character_set_client = @saved_cs_client */; 
     768 
     769-- 
     770-- Dumping data for table `users` 
     771-- 
     772 
     773LOCK TABLES `users` WRITE; 
     774/*!40000 ALTER TABLE `users` DISABLE KEYS */; 
     775/*!40000 ALTER TABLE `users` ENABLE KEYS */; 
     776UNLOCK TABLES; 
     777 
     778-- 
     779-- Table structure for table `zap` 
     780-- 
     781 
     782DROP TABLE IF EXISTS `zap`; 
     783/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     784/*!40101 SET character_set_client = utf8 */; 
     785CREATE TABLE `zap` ( 
     786  `id` varchar(20) NOT NULL DEFAULT '-1', 
     787  `keyword` varchar(30) NOT NULL DEFAULT '', 
     788  `data` varchar(255) NOT NULL, 
     789  `flags` int(1) NOT NULL DEFAULT '0', 
     790  PRIMARY KEY (`id`,`keyword`) 
     791) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     792/*!40101 SET character_set_client = @saved_cs_client */; 
     793 
     794-- 
     795-- Dumping data for table `zap` 
     796-- 
     797 
     798LOCK TABLES `zap` WRITE; 
     799/*!40000 ALTER TABLE `zap` DISABLE KEYS */; 
     800/*!40000 ALTER TABLE `zap` ENABLE KEYS */; 
     801UNLOCK TABLES; 
    302802 
    303803-- 
     
    306806 
    307807DROP TABLE IF EXISTS `zapchandids`; 
     808/*!40101 SET @saved_cs_client     = @@character_set_client */; 
     809/*!40101 SET character_set_client = utf8 */; 
    308810CREATE TABLE `zapchandids` ( 
    309   `channel` int(11) NOT NULL default '0', 
    310   `description` varchar(40) NOT NULL default '', 
    311   `did` varchar(60) NOT NULL default '', 
    312   PRIMARY KEY  (channel) 
    313 ); 
    314  
    315 -- 
    316 -- Dumping data for table `incoming` 
    317 -- 
    318  
    319  
    320 /*!40000 ALTER TABLE `incoming` DISABLE KEYS */; 
    321 -- LOCK TABLES `incoming` WRITE; 
    322 -- UNLOCK TABLES; 
    323 /*!40000 ALTER TABLE `incoming` ENABLE KEYS */; 
    324  
    325 -- 
    326 -- Table structure for table `modules` 
    327 -- 
    328  
    329 DROP TABLE IF EXISTS `modules`; 
    330 CREATE TABLE `modules` ( 
    331   `id` int(11) NOT NULL auto_increment, 
    332   `modulename` varchar(50) NOT NULL default '', 
    333   `version` varchar(20) NOT NULL default '', 
    334   `enabled` tinyint(4) NOT NULL default '0', 
    335   PRIMARY KEY  (`id`) 
    336 ); 
    337  
    338 -- 
    339 -- Dumping data for table `modules` 
    340 -- 
    341  
    342 DROP TABLE IF EXISTS `module_xml`; 
    343 CREATE TABLE `module_xml` ( 
    344   `id` varchar(20) NOT NULL default 'xml', 
    345   `time` int(11) NOT NULL default '0', 
    346   `data` mediumblob NOT NULL, 
    347   PRIMARY KEY  (`id`) 
    348 ); 
    349  
    350 -- 
    351 -- Table structure for table `sip` 
    352 -- 
    353  
    354 DROP TABLE IF EXISTS `sip`; 
    355 CREATE TABLE `sip` ( 
    356   `id` varchar(20) NOT NULL default '-1', 
    357   `keyword` varchar(30) NOT NULL default '', 
    358   `data` varchar(255) NOT NULL default '', 
    359   `flags` int(1) NOT NULL default '0', 
    360   PRIMARY KEY  (`id`,`keyword`) 
    361 ); 
    362  
    363 -- 
    364 -- Dumping data for table `sip` 
    365 -- 
    366  
    367  
    368 /*!40000 ALTER TABLE `sip` DISABLE KEYS */; 
    369 -- LOCK TABLES `sip` WRITE; 
    370 -- UNLOCK TABLES; 
    371 /*!40000 ALTER TABLE `sip` ENABLE KEYS */; 
    372  
    373 -- 
    374 -- Table structure for table `users` 
    375 -- 
    376  
    377 DROP TABLE IF EXISTS `users`; 
    378 CREATE TABLE `users` ( 
    379   `extension` varchar(20) NOT NULL default '', 
    380   `password` varchar(20) default NULL, 
    381   `name` varchar(50) default NULL, 
    382   `voicemail` varchar(50) default NULL, 
    383   `ringtimer` int(3) default NULL, 
    384   `noanswer` varchar(100) default NULL, 
    385   `recording` varchar(50) default NULL, 
    386   `outboundcid` varchar(50) default NULL, 
    387   `sipname` varchar(50) default NULL, 
    388   `noanswer_cid` varchar(20) NOT NULL default '', 
    389   `busy_cid` varchar(20) NOT NULL default '', 
    390   `chanunavail_cid` varchar(20) NOT NULL default '', 
    391   `noanswer_dest` varchar(255) NOT NULL default '', 
    392   `busy_dest` varchar(255) NOT NULL default '', 
    393   `chanunavail_dest` varchar(255) NOT NULL default '' 
    394 ); 
    395  
    396 -- 
    397 -- Dumping data for table `users` 
    398 -- 
    399  
    400  
    401 /*!40000 ALTER TABLE `users` DISABLE KEYS */; 
    402 -- LOCK TABLES `users` WRITE; 
    403 -- UNLOCK TABLES; 
    404 /*!40000 ALTER TABLE `users` ENABLE KEYS */; 
    405  
    406 -- 
    407 -- Table structure for table `zap` 
    408 -- 
    409  
    410 DROP TABLE IF EXISTS `zap`; 
    411 CREATE TABLE `zap` ( 
    412   `id` varchar(20) NOT NULL default '-1', 
    413   `keyword` varchar(30) NOT NULL default '', 
    414   `data` varchar(255) NOT NULL default '', 
    415   `flags` int(1) NOT NULL default '0', 
    416   PRIMARY KEY  (`id`,`keyword`) 
    417 ); 
    418  
    419 -- 
    420 -- Dumping data for table `zap` 
    421 -- 
    422  
    423 -- 
    424 -- Table structure for table `dahdi` 
    425 -- 
    426  
    427 DROP TABLE IF EXISTS `dahdi`; 
    428 CREATE TABLE `dahdi` ( 
    429   `id` varchar(20) NOT NULL default '-1', 
    430   `keyword` varchar(30) NOT NULL default '', 
    431   `data` varchar(255) NOT NULL default '', 
    432   `flags` int(1) NOT NULL default '0', 
    433   PRIMARY KEY  (`id`,`keyword`) 
    434 ); 
    435  
    436 -- 
    437 -- Dumping data for table `dahdi` 
    438 -- 
    439  
    440 DROP  TABLE IF EXISTS `outbound_routes`; 
    441 CREATE TABLE `outbound_routes` ( 
    442   `route_id` INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, 
    443   `name` VARCHAR( 40 ), 
    444   `outcid` VARCHAR( 40 ), 
    445   `outcid_mode` VARCHAR( 20 ), 
    446   `password` VARCHAR( 30 ), 
    447   `emergency_route` VARCHAR( 4 ), 
    448   `intracompany_route` VARCHAR( 4 ), 
    449   `mohclass` VARCHAR( 80 ), 
    450   `time_group_id` INTEGER DEFAULT NULL 
    451 ); 
    452  
    453 DROP TABLE IF EXISTS `outbound_route_patterns`; 
    454 CREATE TABLE `outbound_route_patterns` ( 
    455   `route_id` INTEGER NOT NULL, 
    456   `match_pattern_prefix` VARCHAR( 60 ), 
    457   `match_pattern_pass` VARCHAR( 60 ), 
    458   `match_cid` VARCHAR( 60 ), 
    459   `prepend_digits` VARCHAR( 100 ), 
    460   PRIMARY KEY (`route_id`, `match_pattern_prefix`, `match_pattern_pass`,`match_cid`,`prepend_digits`) 
    461 ); 
    462  
    463 DROP TABLE IF EXISTS `outbound_route_trunks`; 
    464 CREATE TABLE `outbound_route_trunks` ( 
    465   `route_id` INTEGER NOT NULL, 
    466   `trunk_id` INTEGER NOT NULL, 
    467   `seq` INTEGER NOT NULL, 
    468   PRIMARY KEY  (`route_id`, `trunk_id`, `seq`)  
    469 ); 
    470  
    471 DROP TABLE IF EXISTS `outbound_route_sequence`; 
    472 CREATE TABLE `outbound_route_sequence` ( 
    473   `route_id` INTEGER NOT NULL, 
    474   `seq` INTEGER NOT NULL, 
    475   PRIMARY KEY  (`route_id`, `seq`)  
    476 ); 
    477  
    478 --  
    479 -- Table structure for table `notifications` 
    480 --  
    481  
    482 DROP TABLE IF EXISTS notifications; 
    483 CREATE TABLE notifications ( 
    484   module varchar(24) NOT NULL default '', 
    485   id varchar(24) NOT NULL default '', 
    486   `level` int(11) NOT NULL default '0', 
    487   display_text varchar(255) NOT NULL default '', 
    488   extended_text blob NOT NULL, 
    489   link varchar(255) NOT NULL default '', 
    490   `reset` tinyint(4) NOT NULL default '0', 
    491   candelete tinyint(4) NOT NULL default '0', 
    492   `timestamp` int(11) NOT NULL default '0', 
    493   PRIMARY KEY  (`module`,`id`) 
    494 ); 
    495  
    496 CREATE TABLE IF NOT EXISTS `cronmanager` ( 
    497   `module` varchar(24) NOT NULL default '', 
    498   `id` varchar(24) NOT NULL default '', 
    499   `time` varchar(5) default NULL, 
    500   `freq` int(11) NOT NULL default '0', 
    501   `lasttime` int(11) NOT NULL default '0', 
    502   `command` varchar(255) NOT NULL default '', 
    503   PRIMARY KEY  (`module`,`id`) 
    504 ); 
    505  
    506  
    507 /*!40000 ALTER TABLE `zap` DISABLE KEYS */; 
    508 -- LOCK TABLES `zap` WRITE; 
    509 -- UNLOCK TABLES; 
    510 /*!40000 ALTER TABLE `zap` ENABLE KEYS */; 
     811  `channel` int(11) NOT NULL DEFAULT '0', 
     812  `description` varchar(40) NOT NULL DEFAULT '', 
     813  `did` varchar(60) NOT NULL DEFAULT '', 
     814  PRIMARY KEY (`channel`) 
     815) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     816/*!40101 SET character_set_client = @saved_cs_client */; 
     817 
     818-- 
     819-- Dumping data for table `zapchandids` 
     820-- 
     821 
     822LOCK TABLES `zapchandids` WRITE; 
     823/*!40000 ALTER TABLE `zapchandids` DISABLE KEYS */; 
     824/*!40000 ALTER TABLE `zapchandids` ENABLE KEYS */; 
     825UNLOCK TABLES; 
     826/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 
    511827 
    512828/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 
     
    518834/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 
    519835 
     836-- Dump completed on 2011-08-13 11:44:20