Show
Ignore:
Timestamp:
11/27/06 23:06:31 (6 years ago)
Author:
qldrob
Message:

Merged revisions 3219-3224 via svnmerge from
https://svn.sourceforge.net/svnroot/amportal/freepbx/trunk

........

r3220 | qldrob | 2006-11-28 12:06:31 +1000 (Tue, 28 Nov 2006) | 2 lines


Update newinstall.sql

........

r3221 | qldrob | 2006-11-28 12:08:29 +1000 (Tue, 28 Nov 2006) | 2 lines


Forgot to enable core by default.

........

r3222 | qldrob | 2006-11-28 12:16:06 +1000 (Tue, 28 Nov 2006) | 2 lines


Update information on front page, and bump version to rc1

........

r3223 | qldrob | 2006-11-28 12:53:05 +1000 (Tue, 28 Nov 2006) | 2 lines


Uncomment '##' attended transfer in features.conf, to avoid confusion when trying to send # or * to a caller.

........

r3224 | qldrob | 2006-11-28 13:11:46 +1000 (Tue, 28 Nov 2006) | 2 lines


Fix thinko in redirect_standard_continue()

........

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • freepbx/branches/2.2

    • Property svnmerge-integrated changed from /freepbx/trunk:1-3218 to /freepbx/trunk:1-3224

  • freepbx/branches/2.2/SQL/newinstall.sql

    r3070 r3225  
    1 -- phpMyAdmin SQL Dump 
    2 -- version 2.6.0-alpha1 
    3 -- http://www.phpmyadmin.net 
    4 --  
    5 -- Host: localhost 
    6 -- Generation Time: May 20, 2004 at 04:00 PM 
    7 -- Server version: 3.23.58 
    8 -- PHP Version: 4.3.2 
    9 --  
    10 -- Database : `asterisk` 
    11 --  
    12  
    13 -- -------------------------------------------------------- 
    14  
    15 --  
     1-- MySQL dump 10.9 
     2-- 
     3-- Host: localhost    Database: asterisk 
     4-- ------------------------------------------------------ 
     5-- Server version 4.1.20 
     6 
     7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 
     8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 
     9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 
     10/*!40101 SET NAMES utf8 */; 
     11/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; 
     12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 
     13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; 
     14/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; 
     15 
     16-- 
     17-- Table structure for table `Backup` 
     18-- 
     19 
     20DROP TABLE IF EXISTS `Backup`; 
     21CREATE TABLE `Backup` ( 
     22  `Name` varchar(50) default NULL, 
     23  `Voicemail` varchar(50) default NULL, 
     24  `Recordings` varchar(50) default NULL, 
     25  `Configurations` varchar(50) default NULL, 
     26  `CDR` varchar(55) default NULL, 
     27  `FOP` varchar(50) default NULL, 
     28  `Minutes` varchar(50) default NULL, 
     29  `Hours` varchar(50) default NULL, 
     30  `Days` varchar(50) default NULL, 
     31  `Months` varchar(50) default NULL, 
     32  `Weekdays` varchar(50) default NULL, 
     33  `Command` varchar(200) default NULL, 
     34  `Method` varchar(50) default NULL, 
     35  `ID` int(11) NOT NULL auto_increment, 
     36  PRIMARY KEY  (`ID`) 
     37) ENGINE=MyISAM; 
     38 
     39-- 
     40-- Dumping data for table `Backup` 
     41-- 
     42 
     43 
     44/*!40000 ALTER TABLE `Backup` DISABLE KEYS */; 
     45LOCK TABLES `Backup` WRITE; 
     46UNLOCK TABLES; 
     47/*!40000 ALTER TABLE `Backup` ENABLE KEYS */; 
     48 
     49-- 
    1650-- Table structure for table `admin` 
    17 --  
    18  
    19 CREATE TABLE IF NOT EXISTS `admin` ( 
     51-- 
     52 
     53DROP TABLE IF EXISTS `admin`; 
     54CREATE TABLE `admin` ( 
    2055  `variable` varchar(20) NOT NULL default '', 
    2156  `value` varchar(80) NOT NULL default '', 
    2257  PRIMARY KEY  (`variable`) 
    23 ) TYPE=MyISAM; 
    24  
    25 --  
     58) ENGINE=MyISAM; 
     59 
     60-- 
    2661-- Dumping data for table `admin` 
    27 --  
    28  
    29 INSERT INTO `admin` VALUES ('need_reload', 'false'); 
    30 INSERT INTO `admin` VALUES ('version','2.0.0'); 
    31 -- -------------------------------------------------------- 
    32  
    33 --  
    34 -- Table structure for table `extensions` 
    35 --  
    36  
    37 CREATE TABLE IF NOT EXISTS `extensions` ( 
    38   `context` varchar(45) NOT NULL default 'default', 
    39   `extension` varchar(45) NOT NULL default '', 
    40   `priority` VARCHAR(5) NOT NULL default '1', 
    41   `application` varchar(45) NOT NULL default '', 
    42   `args` varchar(255) default NULL, 
    43   `descr` text, 
    44   `flags` int(1) NOT NULL default '0', 
    45   PRIMARY KEY  (`context`,`extension`,`priority`) 
    46 ) TYPE=MyISAM; 
    47  
    48  
    49 --  
    50 -- Create a default route (9 to get out) 
    51 --  
    52  
    53 INSERT INTO extensions (context, extension, priority, application, args) VALUES  
    54  ('outrt-001-9_outside','_9.','1','Macro','dialout-trunk,1,${EXTEN:1}'); 
    55  
    56 INSERT INTO extensions (context, extension, priority, application, args, descr) VALUES  
    57  ('outrt-001-9_outside','_9.','2','Macro','outisbusy','No available circuits'); 
    58  
    59 INSERT INTO extensions (context, extension, priority, application, args, descr, flags) VALUES  
    60  ('outbound-allroutes','include','1','outrt-001-9_outside','','','2'); 
    61   
    62 -- -------------------------------------------------------- 
    63  
    64 --  
    65 -- Table structure for table `globals` 
    66 --  
    67  
    68 CREATE TABLE IF NOT EXISTS `globals` ( 
    69   `variable` char(20) NOT NULL default '', 
    70   `value` char(50) NOT NULL default '', 
    71   PRIMARY KEY  (`variable`) 
    72 ) TYPE=MyISAM; 
    73  
    74 --  
    75 -- Dumping data for table `globals` 
    76 --  
    77  
    78 INSERT INTO `globals` VALUES ('CALLFILENAME', '""'); 
    79 INSERT INTO `globals` VALUES ('DIAL_OPTIONS', 'tr'); 
    80 INSERT INTO `globals` VALUES ('TRUNK_OPTIONS', ''); 
    81 INSERT INTO `globals` VALUES ('DIAL_OUT', '9'); 
    82 INSERT INTO `globals` VALUES ('FAX', ''); 
    83 INSERT INTO `globals` VALUES ('FAX_RX', 'system'); 
    84 INSERT INTO `globals` VALUES ('FAX_RX_EMAIL', 'fax@mydomain.com'); 
    85 INSERT INTO `globals` VALUES ('FAX_RX_FROM', 'freepbx@gmail.com'); 
    86 INSERT INTO `globals` VALUES ('INCOMING', 'group-all'); 
    87 INSERT INTO `globals` VALUES ('NULL', '""'); 
    88 INSERT INTO `globals` VALUES ('OPERATOR', ''); 
    89 INSERT INTO `globals` VALUES ('OPERATOR_XTN', ''); 
    90 INSERT INTO `globals` VALUES ('PARKNOTIFY', 'SIP/200'); 
    91 INSERT INTO `globals` VALUES ('RECORDEXTEN', '""'); 
    92 INSERT INTO `globals` VALUES ('RINGTIMER', '15'); 
    93 INSERT INTO `globals` VALUES ('DIRECTORY', 'last'); 
    94 INSERT INTO `globals` VALUES ('AFTER_INCOMING', ''); 
    95 INSERT INTO `globals` VALUES ('IN_OVERRIDE', 'forcereghours'); 
    96 INSERT INTO `globals` VALUES ('REGTIME', '7:55-17:05'); 
    97 INSERT INTO `globals` VALUES ('REGDAYS', 'mon-fri'); 
    98 INSERT INTO `globals` VALUES ('DIRECTORY_OPTS', ''); 
    99 INSERT INTO `globals` VALUES ('DIALOUTIDS', '1'); 
    100 INSERT INTO `globals` VALUES ('OUT_1', 'ZAP/g0'); 
    101 INSERT INTO `globals` VALUES ('VM_PREFIX', '*'); 
    102 INSERT INTO `globals` VALUES ('VM_OPTS', ''); 
    103 INSERT INTO `globals` VALUES ('VM_GAIN', ''); 
    104 INSERT INTO `globals` VALUES ('VM_DDTYPE', 'u'); 
    105 INSERT INTO `globals` VALUES ('TIMEFORMAT', 'kM'); 
    106 INSERT INTO `globals` VALUES ('TONEZONE', 'us'); 
    107 INSERT INTO `globals` VALUES ('ALLOW_SIP_ANON', 'no'); 
    108  
    109 -- -------------------------------------------------------- 
    110  
    111 --  
    112 -- Table structure for table `sip` 
    113 --  
    114  
    115 CREATE TABLE IF NOT EXISTS `sip` ( 
    116   `id` VARCHAR( 20 ) NOT NULL default '-1', 
    117   `keyword` varchar(30) NOT NULL default '', 
    118   `data` varchar(150) NOT NULL default '', 
    119   `flags` int(1) NOT NULL default '0', 
    120   PRIMARY KEY  (`id`,`keyword`) 
    121 ) TYPE=MyISAM; 
    122  
    123 --  
    124 -- Dumping data for table `sip` 
    125 --  
    126  
    127 -- ---------------------------------------------------------- 
    128  
    129  
    130 --  
     62-- 
     63 
     64 
     65/*!40000 ALTER TABLE `admin` DISABLE KEYS */; 
     66LOCK TABLES `admin` WRITE; 
     67INSERT INTO `admin` VALUES ('need_reload','true'),('version','2.2.0beta3'); 
     68UNLOCK TABLES; 
     69/*!40000 ALTER TABLE `admin` ENABLE KEYS */; 
     70 
     71-- 
    13172-- Table structure for table `ampusers` 
    132 --  
    133  
    134 CREATE TABLE IF NOT EXISTS `ampusers` ( 
     73-- 
     74 
     75DROP TABLE IF EXISTS `ampusers`; 
     76CREATE TABLE `ampusers` ( 
    13577  `username` varchar(20) NOT NULL default '', 
    13678  `password` varchar(20) NOT NULL default '', 
    …… 
    14082  `sections` varchar(255) NOT NULL default '', 
    14183  PRIMARY KEY  (`username`) 
    142 ) TYPE=MyISAM; 
    143  
    144 INSERT INTO ampusers (username, password, extension_low, extension_high, deptname, sections) VALUES  
    145  ('admin','admin','','','','*'); 
    146   
    147 --  
     84) ENGINE=MyISAM; 
     85 
     86-- 
     87-- Dumping data for table `ampusers` 
     88-- 
     89 
     90 
     91/*!40000 ALTER TABLE `ampusers` DISABLE KEYS */; 
     92LOCK TABLES `ampusers` WRITE; 
     93INSERT INTO `ampusers` VALUES ('admin','admin','','','','*'); 
     94UNLOCK TABLES; 
     95/*!40000 ALTER TABLE `ampusers` ENABLE KEYS */; 
     96 
     97-- 
     98-- Table structure for table `devices` 
     99-- 
     100 
     101DROP TABLE IF EXISTS `devices`; 
     102CREATE TABLE `devices` ( 
     103  `id` varchar(20) NOT NULL default '', 
     104  `tech` varchar(10) NOT NULL default '', 
     105  `dial` varchar(50) NOT NULL default '', 
     106  `devicetype` varchar(5) NOT NULL default '', 
     107  `user` varchar(50) default NULL, 
     108  `description` varchar(50) default NULL, 
     109  `emergency_cid` varchar(100) default NULL 
     110) ENGINE=MyISAM; 
     111 
     112-- 
     113-- Dumping data for table `devices` 
     114-- 
     115 
     116 
     117/*!40000 ALTER TABLE `devices` DISABLE KEYS */; 
     118LOCK TABLES `devices` WRITE; 
     119UNLOCK TABLES; 
     120/*!40000 ALTER TABLE `devices` ENABLE KEYS */; 
     121 
     122-- 
     123-- Table structure for table `extensions` 
     124-- 
     125 
     126DROP TABLE IF EXISTS `extensions`; 
     127CREATE TABLE `extensions` ( 
     128  `context` varchar(45) NOT NULL default 'default', 
     129  `extension` varchar(45) NOT NULL default '', 
     130  `priority` varchar(5) NOT NULL default '1', 
     131  `application` varchar(45) NOT NULL default '', 
     132  `args` varchar(255) default NULL, 
     133  `descr` text, 
     134  `flags` int(1) NOT NULL default '0', 
     135  PRIMARY KEY  (`context`,`extension`,`priority`) 
     136) ENGINE=MyISAM; 
     137 
     138-- 
     139-- Dumping data for table `extensions` 
     140-- 
     141 
     142 
     143/*!40000 ALTER TABLE `extensions` DISABLE KEYS */; 
     144LOCK TABLES `extensions` WRITE; 
     145INSERT 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); 
     146UNLOCK TABLES; 
     147/*!40000 ALTER TABLE `extensions` ENABLE KEYS */; 
     148 
     149-- 
     150-- Table structure for table `featurecodes` 
     151-- 
     152 
     153DROP TABLE IF EXISTS `featurecodes`; 
     154CREATE TABLE `featurecodes` ( 
     155  `modulename` varchar(50) NOT NULL default '', 
     156  `featurename` varchar(50) NOT NULL default '', 
     157  `description` varchar(200) NOT NULL default '', 
     158  `defaultcode` varchar(20) default NULL, 
     159  `customcode` varchar(20) default NULL, 
     160  `enabled` tinyint(4) NOT NULL default '0', 
     161  PRIMARY KEY  (`modulename`,`featurename`), 
     162  KEY `enabled` (`enabled`) 
     163) ENGINE=MyISAM; 
     164 
     165-- 
     166-- Dumping data for table `featurecodes` 
     167-- 
     168 
     169 
     170/*!40000 ALTER TABLE `featurecodes` DISABLE KEYS */; 
     171LOCK TABLES `featurecodes` WRITE; 
     172INSERT INTO `featurecodes` VALUES ('core','userlogon','User Logon','*11',NULL,1),('core','userlogoff','User Logoff','*12',NULL,1),('core','zapbarge','ZapBarge','888',NULL,1),('core','simu_pstn','Simulate Incoming Call','7777',NULL,1),('core','simu_fax','Simulate Incoming FAX Call','666',NULL,1),('core','chanspy','ChanSpy','555',NULL,1),('core','pickup','Call Pickup (Can be used with GXP-2000)','**',NULL,1); 
     173UNLOCK TABLES; 
     174/*!40000 ALTER TABLE `featurecodes` ENABLE KEYS */; 
     175 
     176-- 
     177-- Table structure for table `freepbx_log` 
     178-- 
     179 
     180DROP TABLE IF EXISTS `freepbx_log`; 
     181CREATE TABLE `freepbx_log` ( 
     182  `id` int(11) NOT NULL auto_increment, 
     183  `time` datetime NOT NULL default '0000-00-00 00:00:00', 
     184  `section` varchar(50) default NULL, 
     185  `level` enum('error','warning','debug','devel-debug') NOT NULL default 'error', 
     186  `status` int(11) NOT NULL default '0', 
     187  `message` text NOT NULL, 
     188  PRIMARY KEY  (`id`), 
     189  KEY `time` (`time`,`level`) 
     190) ENGINE=MyISAM; 
     191 
     192-- 
     193-- Dumping data for table `freepbx_log` 
     194-- 
     195 
     196 
     197/*!40000 ALTER TABLE `freepbx_log` DISABLE KEYS */; 
     198LOCK TABLES `freepbx_log` WRITE; 
     199INSERT INTO `freepbx_log` VALUES (1,'2006-11-06 01:55:36','retrieve_conf','devel-debug',0,'Started retrieve_conf, DB Connection OK'),(2,'2006-11-06 01:55:36','retrieve_conf','devel-debug',0,'Writing extensions_additional.conf'); 
     200UNLOCK TABLES; 
     201/*!40000 ALTER TABLE `freepbx_log` ENABLE KEYS */; 
     202 
     203-- 
     204-- Table structure for table `globals` 
     205-- 
     206 
     207DROP TABLE IF EXISTS `globals`; 
     208CREATE TABLE `globals` ( 
     209  `variable` char(20) NOT NULL default '', 
     210  `value` char(50) NOT NULL default '', 
     211  PRIMARY KEY  (`variable`) 
     212) ENGINE=MyISAM; 
     213 
     214-- 
     215-- Dumping data for table `globals` 
     216-- 
     217 
     218 
     219/*!40000 ALTER TABLE `globals` DISABLE KEYS */; 
     220LOCK TABLES `globals` WRITE; 
     221INSERT INTO `globals` VALUES ('CALLFILENAME','\"\"'),('DIAL_OPTIONS','tr'),('TRUNK_OPTIONS',''),('DIAL_OUT','9'),('FAX',''),('FAX_RX','system'),('FAX_RX_EMAIL','fax@mydomain.com'),('FAX_RX_FROM','freepbx@gmail.com'),('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'),('OUT_1','ZAP/g0'),('VM_PREFIX','*'),('VM_OPTS',''),('VM_GAIN',''),('VM_DDTYPE','u'),('TIMEFORMAT','kM'),('TONEZONE','us'),('ALLOW_SIP_ANON','no'); 
     222UNLOCK TABLES; 
     223/*!40000 ALTER TABLE `globals` ENABLE KEYS */; 
     224 
     225-- 
    148226-- Table structure for table `iax` 
    149 --  
    150             
    151 CREATE TABLE IF NOT EXISTS `iax` ( 
    152   `id` VARCHAR( 20 ) NOT NULL default '-1', 
     227-- 
     228 
     229DROP TABLE IF EXISTS `iax`; 
     230CREATE TABLE `iax` ( 
     231  `id` varchar(20) NOT NULL default '-1', 
    153232  `keyword` varchar(30) NOT NULL default '', 
    154233  `data` varchar(150) NOT NULL default '', 
    155234  `flags` int(1) NOT NULL default '0', 
    156235  PRIMARY KEY  (`id`,`keyword`) 
    157  ) TYPE=MyISAM; 
    158  
    159   
    160 --  
    161 -- Table structure for table `zap` 
    162 --  
    163  
    164 CREATE TABLE IF NOT EXISTS `zap` ( 
    165   `id` VARCHAR( 20 ) NOT NULL default '-1', 
    166   `keyword`varchar(30) NOT NULL default '', 
    167   `data`varchar(150) NOT NULL default '', 
    168   `flags` int(1) NOT NULL default '0', 
    169   PRIMARY KEY (`id`,`keyword`) 
    170   ) TYPE=MyISAM; 
    171    
    172 --  
     236) ENGINE=MyISAM; 
     237 
     238-- 
     239-- Dumping data for table `iax` 
     240-- 
     241 
     242 
     243/*!40000 ALTER TABLE `iax` DISABLE KEYS */; 
     244LOCK TABLES `iax` WRITE; 
     245UNLOCK TABLES; 
     246/*!40000 ALTER TABLE `iax` ENABLE KEYS */; 
     247 
     248-- 
     249-- Table structure for table `incoming` 
     250-- 
     251 
     252DROP TABLE IF EXISTS `incoming`; 
     253CREATE TABLE `incoming` ( 
     254  `cidnum` varchar(20) default NULL, 
     255  `extension` varchar(20) default NULL, 
     256  `destination` varchar(50) default NULL, 
     257  `faxexten` varchar(20) default NULL, 
     258  `faxemail` varchar(50) default NULL, 
     259  `answer` tinyint(1) default NULL, 
     260  `wait` int(2) default NULL, 
     261  `privacyman` tinyint(1) default NULL, 
     262  `alertinfo` varchar(32) default NULL, 
     263  `channel` varchar(20) default NULL, 
     264  `ringing` varchar(20) default NULL 
     265) ENGINE=MyISAM; 
     266 
     267-- 
     268-- Dumping data for table `incoming` 
     269-- 
     270 
     271 
     272/*!40000 ALTER TABLE `incoming` DISABLE KEYS */; 
     273LOCK TABLES `incoming` WRITE; 
     274UNLOCK TABLES; 
     275/*!40000 ALTER TABLE `incoming` ENABLE KEYS */; 
     276 
     277-- 
     278-- Table structure for table `modules` 
     279-- 
     280 
     281DROP TABLE IF EXISTS `modules`; 
     282CREATE TABLE `modules` ( 
     283  `id` int(11) NOT NULL auto_increment, 
     284  `modulename` varchar(50) NOT NULL default '', 
     285  `version` varchar(20) NOT NULL default '', 
     286  `enabled` tinyint(4) NOT NULL default '0', 
     287  PRIMARY KEY  (`id`) 
     288) ENGINE=MyISAM; 
     289 
     290-- 
     291-- Dumping data for table `modules` 
     292-- 
     293 
     294 
     295/*!40000 ALTER TABLE `modules` DISABLE KEYS */; 
     296LOCK TABLES `modules` WRITE; 
     297INSERT INTO `modules` VALUES (1,'core','1.2',1); 
     298UNLOCK TABLES; 
     299/*!40000 ALTER TABLE `modules` ENABLE KEYS */; 
     300 
     301-- 
    173302-- Table structure for table `queues` 
    174 --  
    175  
    176 CREATE TABLE IF NOT EXISTS `queues` ( 
     303-- 
     304 
     305DROP TABLE IF EXISTS `queues`; 
     306CREATE TABLE `queues` ( 
    177307  `id` bigint(11) NOT NULL default '-1', 
    178308  `keyword` varchar(20) NOT NULL default '', 
    …… 
    180310  `flags` int(1) NOT NULL default '0', 
    181311  PRIMARY KEY  (`id`,`keyword`,`data`) 
    182 ) TYPE=MyISAM;; 
    183  
    184 CREATE TABLE IF NOT EXISTS `devices` ( 
    185 `id` VARCHAR( 20 ) NOT NULL , 
    186 `tech` VARCHAR( 10 ) NOT NULL ,  
    187 `dial` VARCHAR( 50 ) NOT NULL ,  
    188 `devicetype` VARCHAR( 5 ) NOT NULL ,  
    189 `user` VARCHAR( 50 ) ,  
    190 `description` VARCHAR( 50 ) , 
    191 `emergency_cid` VARCHAR( 100 ) NULL 
    192 ) TYPE = MYISAM ; 
    193  
    194 CREATE TABLE IF NOT EXISTS users (extension VARCHAR( 20 ) NOT NULL , password VARCHAR( 20 ) , name VARCHAR( 50 ) , voicemail VARCHAR( 50 ) , ringtimer INT(3) , noanswer VARCHAR( 100 ) , recording VARCHAR( 50 ) ,  outboundcid VARCHAR( 50 ) , directdid VARCHAR( 50 ) NULL, didalert VARCHAR ( 50 ) NULL,  faxexten VARCHAR( 20 ) , faxemail VARCHAR( 50 ) , answer TINYINT( 1 ) , wait INT( 2 ) , privacyman TINYINT( 1 ) ); 
    195  
    196 -- 
    197 -- Needs to be changed to their new structure, comment out for now 
    198 -- 
    199 CREATE TABLE IF NOT EXISTS `incoming` ( `cidnum` VARCHAR( 20 ) , `extension` VARCHAR( 20 ) , `destination` VARCHAR( 50 ) , `faxexten` VARCHAR( 20 ) , `faxemail` VARCHAR( 50 ) , `answer` TINYINT( 1 ) , `wait` INT( 2 ) , `privacyman` TINYINT( 1 ) , alertinfo VARCHAR( 32 ) , `channel` VARCHAR( 20 ) ); 
    200 -- 
    201 -- 
    202  
    203 CREATE TABLE IF NOT EXISTS `Backup` (`Name` varchar(50) default NULL,`Voicemail` varchar(50) default NULL,`Recordings` varchar(50) default NULL,`Configurations` varchar(50) default NULL,`CDR` varchar(55) default NULL,`FOP` varchar(50) default NULL,`Minutes` varchar(50) default NULL,`Hours` varchar(50) default NULL,`Days` varchar(50) default NULL,`Months` varchar(50) default NULL,`Weekdays` varchar(50) default NULL,`Command` varchar(200) default NULL,`Method` varchar(50) default NULL,`ID` int(11) NOT NULL auto_increment,PRIMARY KEY  (ID)); 
    204  
    205 --  
    206 -- Create module tables 
    207 --  
    208  
    209 CREATE TABLE IF NOT EXISTS `modules` ( 
    210 `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , 
    211 `modulename` VARCHAR( 50 ) NOT NULL , 
    212 `version` VARCHAR( 20 ) NOT NULL , 
    213 `enabled` TINYINT NOT NULL 
    214 ) TYPE = MYISAM ; 
    215  
    216 -- 
    217 -- Table structure for table `featurecodes` 
    218 -- 
    219  
    220 CREATE TABLE IF NOT EXISTS `featurecodes` ( 
    221   `modulename` varchar(50) NOT NULL, 
    222   `featurename` varchar(50) NOT NULL, 
    223   `description` varchar(200) NOT NULL, 
    224   `defaultcode` varchar(20) default NULL, 
    225   `customcode` varchar(20) default NULL, 
    226   `enabled` tinyint(4) NOT NULL default '0', 
    227   PRIMARY KEY  (`modulename`,`featurename`), 
    228   KEY `enabled` (`enabled`) 
    229 ) TYPE=MyISAM; 
    230  
    231 CREATE TABLE IF NOT EXISTS `freepbx_log` ( 
    232   `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , 
    233   `time` DATETIME NOT NULL , 
    234   `section` VARCHAR( 50 ) NULL , 
    235   `level` ENUM( 'error', 'warning', 'debug', 'devel-debug' ) NOT NULL , 
    236   `status` INT NOT NULL, 
    237   `message` TEXT NOT NULL , 
    238   INDEX ( `time` , `level` ) 
    239 ) ENGINE = MYISAM ; 
     312) ENGINE=MyISAM; 
     313 
     314-- 
     315-- Dumping data for table `queues` 
     316-- 
     317 
     318 
     319/*!40000 ALTER TABLE `queues` DISABLE KEYS */; 
     320LOCK TABLES `queues` WRITE; 
     321UNLOCK TABLES; 
     322/*!40000 ALTER TABLE `queues` ENABLE KEYS */; 
     323 
     324-- 
     325-- Table structure for table `sip` 
     326-- 
     327 
     328DROP TABLE IF EXISTS `sip`; 
     329CREATE TABLE `sip` ( 
     330  `id` varchar(20) NOT NULL default '-1', 
     331  `keyword` varchar(30) NOT NULL default '', 
     332  `data` varchar(150) NOT NULL default '', 
     333  `flags` int(1) NOT NULL default '0', 
     334  PRIMARY KEY  (`id`,`keyword`) 
     335) ENGINE=MyISAM; 
     336 
     337-- 
     338-- Dumping data for table `sip` 
     339-- 
     340 
     341 
     342/*!40000 ALTER TABLE `sip` DISABLE KEYS */; 
     343LOCK TABLES `sip` WRITE; 
     344UNLOCK TABLES; 
     345/*!40000 ALTER TABLE `sip` ENABLE KEYS */; 
     346 
     347-- 
     348-- Table structure for table `users` 
     349-- 
     350 
     351DROP TABLE IF EXISTS `users`; 
     352CREATE TABLE `users` ( 
     353  `extension` varchar(20) NOT NULL default '', 
     354  `password` varchar(20) default NULL, 
     355  `name` varchar(50) default NULL, 
     356  `voicemail` varchar(50) default NULL, 
     357  `ringtimer` int(3) default NULL, 
     358  `noanswer` varchar(100) default NULL, 
     359  `recording` varchar(50) default NULL, 
     360  `outboundcid` varchar(50) default NULL, 
     361  `directdid` varchar(50) default NULL, 
     362  `didalert` varchar(50) default NULL, 
     363  `faxexten` varchar(20) default NULL, 
     364  `faxemail` varchar(50) default NULL, 
     365  `answer` tinyint(1) default NULL, 
     366  `wait` int(2) default NULL, 
     367  `privacyman` tinyint(1) default NULL 
     368) ENGINE=MyISAM; 
     369 
     370-- 
     371-- Dumping data for table `users` 
     372-- 
     373 
     374 
     375/*!40000 ALTER TABLE `users` DISABLE KEYS */; 
     376LOCK TABLES `users` WRITE; 
     377UNLOCK TABLES; 
     378/*!40000 ALTER TABLE `users` ENABLE KEYS */; 
     379 
     380-- 
     381-- Table structure for table `zap` 
     382-- 
     383 
     384DROP TABLE IF EXISTS `zap`; 
     385CREATE TABLE `zap` ( 
     386  `id` varchar(20) NOT NULL default '-1', 
     387  `keyword` varchar(30) NOT NULL default '', 
     388  `data` varchar(150) NOT NULL default '', 
     389  `flags` int(1) NOT NULL default '0', 
     390  PRIMARY KEY  (`id`,`keyword`) 
     391) ENGINE=MyISAM; 
     392 
     393-- 
     394-- Dumping data for table `zap` 
     395-- 
     396 
     397 
     398/*!40000 ALTER TABLE `zap` DISABLE KEYS */; 
     399LOCK TABLES `zap` WRITE; 
     400UNLOCK TABLES; 
     401/*!40000 ALTER TABLE `zap` ENABLE KEYS */; 
     402 
     403/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 
     404/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 
     405/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 
     406/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 
     407/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 
     408/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 
     409/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 
     410