Show
Ignore:
Timestamp:
06/07/09 09:04:32 (4 years ago)
Author:
xrobau
Message:

Re-created SQLite NewInstall? script. Probably needs tuning before 2.6 release (Are all the 'required' modules enabled?)

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • freepbx/trunk/SQL/newinstall.sqlite3.sql

    r6458 r7798  
    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 `admin` 
    18 -- 
    19  
    20 DROP TABLE IF EXISTS `admin`; 
     1BEGIN TRANSACTION; 
    212CREATE TABLE `admin` ( 
    223  `variable` varchar(20) NOT NULL default '', 
    234  `value` varchar(80) NOT NULL default '', 
    245  PRIMARY KEY  (`variable`) 
    25 ) ; 
    26  
    27 -- 
    28 -- Dumping data for table `admin` 
    29 -- 
    30  
    31  
    32 /*!40000 ALTER TABLE `admin` DISABLE KEYS */; 
    33 --  TABLES `admin` WRITE; 
    34 INSERT INTO `admin` VALUES ('need_reload','true'); 
    35 INSERT INTO `admin` VALUES ('version','2.2.0beta3'); 
    36 --  TABLES; 
    37 /*!40000 ALTER TABLE `admin` ENABLE KEYS */; 
    38  
    39 -- 
    40 -- Table structure for table `ampusers` 
    41 -- 
    42  
    43 DROP TABLE IF EXISTS `ampusers`; 
     6); 
     7INSERT INTO "admin" VALUES('need_reload', 'true'); 
     8INSERT INTO "admin" VALUES('version', '2.6.0beta1'); 
    449CREATE TABLE `ampusers` ( 
    4510  `username` varchar(20) NOT NULL default '', 
    46   `password` varchar(20) NOT NULL default '', 
     11  `password_sha1` varchar(20) NOT NULL default '', 
    4712  `extension_low` varchar(20) NOT NULL default '', 
    4813  `extension_high` varchar(20) NOT NULL default '', 
    …… 
    5015  `sections` varchar(255) NOT NULL default '', 
    5116  PRIMARY KEY  (`username`) 
    52 ) ; 
    53  
    54 -- 
    55 -- Dumping data for table `ampusers` 
    56 -- 
    57  
    58  
    59 /*!40000 ALTER TABLE `ampusers` DISABLE KEYS */; 
    60 --  TABLES `ampusers` WRITE; 
    61 INSERT INTO `ampusers` VALUES ('admin','admin','','','','*'); 
    62 --  TABLES; 
    63 /*!40000 ALTER TABLE `ampusers` ENABLE KEYS */; 
    64  
    65 -- 
    66 -- Table structure for table `devices` 
    67 -- 
    68  
    69 DROP TABLE IF EXISTS `devices`; 
     17); 
     18INSERT INTO "ampusers" VALUES('admin', 'd033e22ae348aeb5660fc2140aec35850c4da997', '', '', '', '*'); 
    7019CREATE TABLE `devices` ( 
    7120  `id` varchar(20) NOT NULL default '', 
    …… 
    7625  `description` varchar(50) default NULL, 
    7726  `emergency_cid` varchar(100) default NULL 
    78 ) ; 
    79  
    80 -- 
    81 -- Dumping data for table `devices` 
    82 -- 
    83  
    84  
    85 /*!40000 ALTER TABLE `devices` DISABLE KEYS */; 
    86 --  TABLES `devices` WRITE; 
    87 --  TABLES; 
    88 /*!40000 ALTER TABLE `devices` ENABLE KEYS */; 
    89  
    90 -- 
    91 -- Table structure for table `extensions` 
    92 -- 
    93  
    94 DROP TABLE IF EXISTS `extensions`; 
     27); 
    9528CREATE TABLE `extensions` ( 
    9629  `context` varchar(45) NOT NULL default 'default', 
    …… 
    10235  `flags` int(1) NOT NULL default '0', 
    10336  PRIMARY KEY  (`context`,`extension`,`priority`) 
    104 ) ; 
    105  
    106 -- 
    107 -- Dumping data for table `extensions` 
    108 -- 
    109  
    110  
    111 /*!40000 ALTER TABLE `extensions` DISABLE KEYS */; 
    112 --  TABLES `extensions` WRITE; 
    113 INSERT INTO `extensions` VALUES ('outrt-001-9_outside','_9.','1','Macro','dialout-trunk,1,${EXTEN:1}',NULL,0); 
    114 INSERT INTO `extensions` VALUES ('outrt-001-9_outside','_9.','2','Macro','outisbusy','No available circuits',0); 
    115 INSERT INTO `extensions` VALUES ('outbound-allroutes','include','1','outrt-001-9_outside','','',2); 
    116 --  TABLES; 
    117 /*!40000 ALTER TABLE `extensions` ENABLE KEYS */; 
    118  
    119 -- 
    120 -- Table structure for table `featurecodes` 
    121 -- 
    122  
    123 DROP TABLE IF EXISTS `featurecodes`; 
     37); 
     38INSERT INTO "extensions" VALUES('outrt-001-9_outside', '_9.', '1', 'Macro', 'dialout-trunk,1,${EXTEN:1}', NULL, 0); 
     39INSERT INTO "extensions" VALUES('outrt-001-9_outside', '_9.', '2', 'Macro', 'outisbusy', 'No available circuits', 0); 
     40INSERT INTO "extensions" VALUES('outbound-allroutes', 'include', '1', 'outrt-001-9_outside', '', '', 2); 
    12441CREATE TABLE `featurecodes` ( 
    12542  `modulename` varchar(50) NOT NULL default '', 
    …… 
    13148  PRIMARY KEY  (`modulename`,`featurename`) 
    13249--   KEY `enabled` (`enabled`) 
    133 ) ; 
    134  
    135 -- 
    136 -- Dumping data for table `featurecodes` 
    137 -- 
    138  
    139  
    140 /*!40000 ALTER TABLE `featurecodes` DISABLE KEYS */; 
    141 --  TABLES `featurecodes` WRITE; 
    142 INSERT INTO `featurecodes` VALUES ('core','userlogon','User Logon','*11',NULL,1); 
    143 INSERT INTO `featurecodes` VALUES ('core','userlogoff','User Logoff','*12',NULL,1); 
    144 INSERT INTO `featurecodes` VALUES ('core','zapbarge','ZapBarge','888',NULL,1); 
    145 INSERT INTO `featurecodes` VALUES ('core','simu_pstn','Simulate Incoming Call','7777',NULL,1); 
    146 INSERT INTO `featurecodes` VALUES ('core','simu_fax','Simulate Incoming FAX Call','666',NULL,1); 
    147 INSERT INTO `featurecodes` VALUES ('core','chanspy','ChanSpy','555',NULL,1); 
    148 INSERT INTO `featurecodes` VALUES ('core','pickup','Call Pickup (Can be used with GXP-2000)','**',NULL,1); 
    149 --  TABLES; 
    150 /*!40000 ALTER TABLE `featurecodes` ENABLE KEYS */; 
    151  
    152 -- 
    153 -- Table structure for table `freepbx_log` 
    154 -- 
    155  
    156 DROP TABLE IF EXISTS `freepbx_log`; 
     50); 
     51INSERT INTO "featurecodes" VALUES('core', 'userlogon', 'User Logon', '*11', NULL, 1); 
     52INSERT INTO "featurecodes" VALUES('core', 'userlogoff', 'User Logoff', '*12', NULL, 1); 
     53INSERT INTO "featurecodes" VALUES('core', 'zapbarge', 'ZapBarge', '888', NULL, 1); 
     54INSERT INTO "featurecodes" VALUES('core', 'simu_pstn', 'Simulate Incoming Call', '7777', NULL, 1); 
     55INSERT INTO "featurecodes" VALUES('core', 'simu_fax', 'Dial System FAX', '666', NULL, 1); 
     56INSERT INTO "featurecodes" VALUES('core', 'chanspy', 'ChanSpy', '555', NULL, 1); 
     57INSERT INTO "featurecodes" VALUES('core', 'pickup', 'Directed Call Pickup', '**', NULL, 1); 
     58INSERT INTO "featurecodes" VALUES('core', 'pickupexten', 'Asterisk General Call Pickup', '*8', NULL, 1); 
     59INSERT INTO "featurecodes" VALUES('core', 'blindxfer', 'In-Call Asterisk Blind Transfer', '##', NULL, 1); 
     60INSERT INTO "featurecodes" VALUES('core', 'atxfer', 'In-Call Asterisk Attended Transfer', '*2', NULL, 1); 
     61INSERT INTO "featurecodes" VALUES('core', 'automon', 'In-Call Asterisk Toggle Call Recording', '*1', NULL, 1); 
     62INSERT INTO "featurecodes" VALUES('core', 'disconnect', 'In-Call Asterisk Disconnect Code', '**', NULL, 1); 
     63INSERT INTO "featurecodes" VALUES('voicemail', 'myvoicemail', 'My Voicemail', '*97', NULL, 1); 
     64INSERT INTO "featurecodes" VALUES('voicemail', 'dialvoicemail', 'Dial Voicemail', '*98', NULL, 1); 
     65INSERT INTO "featurecodes" VALUES('recordings', 'record_save', 'Save Recording', '*77', NULL, 1); 
     66INSERT INTO "featurecodes" VALUES('recordings', 'record_check', 'Check Recording', '*99', NULL, 1); 
    15767CREATE TABLE `freepbx_log` ( 
    15868  `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, 
    …… 
    16777--   PRIMARY KEY  (`id`), 
    16878--   KEY `time` (`time`,`level`) 
    169 ) ; 
    170  
    171 -- 
    172 -- Dumping data for table `freepbx_log` 
    173 -- 
    174  
    175  
    176 /*!40000 ALTER TABLE `freepbx_log` DISABLE KEYS */; 
    177 --  TABLES `freepbx_log` WRITE; 
    178 INSERT INTO `freepbx_log` VALUES (1,'2006-11-06 01:55:36','retrieve_conf','devel-debug',0,'Started retrieve_conf, DB Connection OK'); 
    179 INSERT INTO `freepbx_log` VALUES (2,'2006-11-06 01:55:36','retrieve_conf','devel-debug',0,'Writing extensions_additional.conf'); 
    180 --  TABLES; 
    181 /*!40000 ALTER TABLE `freepbx_log` ENABLE KEYS */; 
    182  
    183 -- 
    184 -- Table structure for table `globals` 
    185 -- 
    186  
    187 DROP TABLE IF EXISTS `globals`; 
     79); 
     80INSERT INTO "freepbx_log" VALUES(1, '2006-11-06 01:55:36', 'retrieve_conf', 'devel-debug', 0, 'Started retrieve_conf, DB Connection OK'); 
     81INSERT INTO "freepbx_log" VALUES(2, '2006-11-06 01:55:36', 'retrieve_conf', 'devel-debug', 0, 'Writing extensions_additional.conf'); 
     82DELETE FROM sqlite_sequence; 
     83INSERT INTO "sqlite_sequence" VALUES('freepbx_log', 2); 
     84INSERT INTO "sqlite_sequence" VALUES('modules', 8); 
     85INSERT INTO "sqlite_sequence" VALUES('recordings', 20); 
    18886CREATE TABLE `globals` ( 
    18987  `variable` varchar(255) NOT NULL default '', 
    19088  `value` varchar(255) NOT NULL default '', 
    19189  PRIMARY KEY  (`variable`) 
    192 ) ; 
    193  
    194 -- 
    195 -- Dumping data for table `globals` 
    196 -- 
    197  
    198  
    199 /*!40000 ALTER TABLE `globals` DISABLE KEYS */; 
    200 --  /*TABLES*/ `globals` WRITE; 
    201 INSERT INTO `globals` VALUES ('CALLFILENAME','\"\"'); 
    202 INSERT INTO `globals` VALUES ('DIAL_OPTIONS','tr'); 
    203 INSERT INTO `globals` VALUES ('TRUNK_OPTIONS',''); 
    204 INSERT INTO `globals` VALUES ('DIAL_OUT','9'); 
    205 INSERT INTO `globals` VALUES ('FAX',''); 
    206 INSERT INTO `globals` VALUES ('FAX_RX','system'); 
    207 INSERT INTO `globals` VALUES ('FAX_RX_EMAIL','fax@mydomain.com'); 
    208 INSERT INTO `globals` VALUES ('FAX_RX_FROM','freepbx@gmail.com'); 
    209 INSERT INTO `globals` VALUES ('INCOMING','group-all'); 
    210 INSERT INTO `globals` VALUES ('NULL','\"\"'); 
    211 INSERT INTO `globals` VALUES ('OPERATOR',''); 
    212 INSERT INTO `globals` VALUES ('OPERATOR_XTN',''); 
    213 INSERT INTO `globals` VALUES ('PARKNOTIFY','SIP/200'); 
    214 INSERT INTO `globals` VALUES ('RECORDEXTEN','\"\"'); 
    215 INSERT INTO `globals` VALUES ('RINGTIMER','15'); 
    216 INSERT INTO `globals` VALUES ('DIRECTORY','last'); 
    217 INSERT INTO `globals` VALUES ('AFTER_INCOMING',''); 
    218 INSERT INTO `globals` VALUES ('IN_OVERRIDE','forcereghours'); 
    219 INSERT INTO `globals` VALUES ('REGTIME','7:55-17:05'); 
    220 INSERT INTO `globals` VALUES ('REGDAYS','mon-fri'); 
    221 INSERT INTO `globals` VALUES ('DIRECTORY_OPTS',''); 
    222 INSERT INTO `globals` VALUES ('DIALOUTIDS','1'); 
    223 INSERT INTO `globals` VALUES ('OUT_1','ZAP/g0'); 
    224 INSERT INTO `globals` VALUES ('VM_PREFIX','*'); 
    225 INSERT INTO `globals` VALUES ('VM_OPTS',''); 
    226 INSERT INTO `globals` VALUES ('VM_GAIN',''); 
    227 INSERT INTO `globals` VALUES ('VM_DDTYPE','u'); 
    228 INSERT INTO `globals` VALUES ('TIMEFORMAT','kM'); 
    229 INSERT INTO `globals` VALUES ('TONEZONE','us'); 
    230 INSERT INTO `globals` VALUES ('ALLOW_SIP_ANON','no'); 
    231 INSERT INTO `globals` VALUES ('VMX_CONTEXT','from-internal'); 
    232 INSERT INTO `globals` VALUES ('VMX_PRI','1'); 
    233 INSERT INTO `globals` VALUES ('VMX_TIMEDEST_CONTEXT',''); 
    234 INSERT INTO `globals` VALUES ('VMX_TIMEDEST_EXT','dovm'); 
    235 INSERT INTO `globals` VALUES ('VMX_TIMEDEST_PRI','1'); 
    236 INSERT INTO `globals` VALUES ('VMX_LOOPDEST_CONTEXT',''); 
    237 INSERT INTO `globals` VALUES ('VMX_LOOPDEST_EXT','dovm'); 
    238 INSERT INTO `globals` VALUES ('VMX_LOOPDEST_PRI','1'); 
    239 INSERT INTO `globals` VALUES ('VMX_OPTS_TIMEOUT',''); 
    240 INSERT INTO `globals` VALUES ('VMX_OPTS_LOOP',''); 
    241 INSERT INTO `globals` VALUES ('VMX_OPTS_DOVM',''); 
    242 INSERT INTO `globals` VALUES ('VMX_TIMEOUT','2'); 
    243 INSERT INTO `globals` VALUES ('VMX_REPEAT','1'); 
    244 INSERT INTO `globals` VALUES ('VMX_LOOPS','1'); 
    245 INSERT INTO `globals` VALUES ('TRANSFER_CONTEXT','from-internal-xfer'); 
    246 INSERT INTO `globals` VALUES ('MIXMON_FORMAT','wav'); 
    247 INSERT INTO `globals` VALUES ('MIXMON_DIR',''); 
    248 INSERT INTO `globals` VALUES ('MIXMON_POST',''); 
    249  
    250 --  TABLES; 
    251 /*!40000 ALTER TABLE `globals` ENABLE KEYS */; 
    252  
    253 -- 
    254 -- Table structure for table `iax` 
    255 -- 
    256  
    257 DROP TABLE IF EXISTS `iax`; 
     90); 
     91INSERT INTO "globals" VALUES('CALLFILENAME', '\"\"'); 
     92INSERT INTO "globals" VALUES('DIAL_OPTIONS', 'tr'); 
     93INSERT INTO "globals" VALUES('TRUNK_OPTIONS', ''); 
     94INSERT INTO "globals" VALUES('DIAL_OUT', '9'); 
     95INSERT INTO "globals" VALUES('FAX', ''); 
     96INSERT INTO "globals" VALUES('FAX_RX', 'system'); 
     97INSERT INTO "globals" VALUES('FAX_RX_EMAIL', 'fax@mydomain.com'); 
     98INSERT INTO "globals" VALUES('FAX_RX_FROM', 'freepbx@gmail.com'); 
     99INSERT INTO "globals" VALUES('INCOMING', 'group-all'); 
     100INSERT INTO "globals" VALUES('NULL', '\"\"'); 
     101INSERT INTO "globals" VALUES('OPERATOR', ''); 
     102INSERT INTO "globals" VALUES('OPERATOR_XTN', ''); 
     103INSERT INTO "globals" VALUES('PARKNOTIFY', 'SIP/200'); 
     104INSERT INTO "globals" VALUES('RECORDEXTEN', '\"\"'); 
     105INSERT INTO "globals" VALUES('RINGTIMER', '15'); 
     106INSERT INTO "globals" VALUES('DIRECTORY', 'last'); 
     107INSERT INTO "globals" VALUES('AFTER_INCOMING', ''); 
     108INSERT INTO "globals" VALUES('IN_OVERRIDE', 'forcereghours'); 
     109INSERT INTO "globals" VALUES('REGTIME', '7:55-17:05'); 
     110INSERT INTO "globals" VALUES('REGDAYS', 'mon-fri'); 
     111INSERT INTO "globals" VALUES('DIRECTORY_OPTS', ''); 
     112INSERT INTO "globals" VALUES('DIALOUTIDS', '1'); 
     113INSERT INTO "globals" VALUES('VM_PREFIX', '*'); 
     114INSERT INTO "globals" VALUES('VM_OPTS', ''); 
     115INSERT INTO "globals" VALUES('VM_GAIN', ''); 
     116INSERT INTO "globals" VALUES('VM_DDTYPE', 'u'); 
     117INSERT INTO "globals" VALUES('TIMEFORMAT', 'kM'); 
     118INSERT INTO "globals" VALUES('TONEZONE', 'us'); 
     119INSERT INTO "globals" VALUES('ALLOW_SIP_ANON', 'no'); 
     120INSERT INTO "globals" VALUES('VMX_CONTEXT', 'from-internal'); 
     121INSERT INTO "globals" VALUES('VMX_PRI', '1'); 
     122INSERT INTO "globals" VALUES('VMX_TIMEDEST_CONTEXT', ''); 
     123INSERT INTO "globals" VALUES('VMX_TIMEDEST_EXT', 'dovm'); 
     124INSERT INTO "globals" VALUES('VMX_TIMEDEST_PRI', '1'); 
     125INSERT INTO "globals" VALUES('VMX_LOOPDEST_CONTEXT', ''); 
     126INSERT INTO "globals" VALUES('VMX_LOOPDEST_EXT', 'dovm'); 
     127INSERT INTO "globals" VALUES('VMX_LOOPDEST_PRI', '1'); 
     128INSERT INTO "globals" VALUES('VMX_OPTS_TIMEOUT', ''); 
     129INSERT INTO "globals" VALUES('VMX_OPTS_LOOP', ''); 
     130INSERT INTO "globals" VALUES('VMX_OPTS_DOVM', ''); 
     131INSERT INTO "globals" VALUES('VMX_TIMEOUT', '2'); 
     132INSERT INTO "globals" VALUES('VMX_REPEAT', '1'); 
     133INSERT INTO "globals" VALUES('VMX_LOOPS', '1'); 
     134INSERT INTO "globals" VALUES('TRANSFER_CONTEXT', 'from-internal-xfer'); 
     135INSERT INTO "globals" VALUES('MIXMON_FORMAT', 'wav'); 
     136INSERT INTO "globals" VALUES('MIXMON_DIR', ''); 
     137INSERT INTO "globals" VALUES('MIXMON_POST', ''); 
     138INSERT INTO "globals" VALUES('RECORDING_STATE', 'ENABLED'); 
    258139CREATE TABLE `iax` ( 
    259140  `id` varchar(20) NOT NULL default '-1', 
    …… 
    262143  `flags` int(1) NOT NULL default '0', 
    263144  PRIMARY KEY  (`id`,`keyword`) 
    264 ) ; 
    265  
    266 -- 
    267 -- Dumping data for table `iax` 
    268 -- 
    269  
    270  
    271 /*!40000 ALTER TABLE `iax` DISABLE KEYS */; 
    272 --  TABLES `iax` WRITE; 
    273 --  TABLES; 
    274 /*!40000 ALTER TABLE `iax` ENABLE KEYS */; 
    275  
    276 -- 
    277 -- Table structure for table `incoming` 
    278 -- 
    279  
    280 DROP TABLE IF EXISTS `incoming`; 
     145); 
    281146CREATE TABLE `incoming` ( 
    282147  `cidnum` varchar(20) default NULL, 
    …… 
    294159  `grppre` varchar(80) default NULL , 
    295160  `delay_answer` int (2) default NULL 
    296 ) ; 
    297  
    298 -- 
    299 -- Table structure for table `zapchandids` 
    300 -- 
    301  
    302 DROP TABLE IF EXISTS `zapchandids`; 
     161, `pricid` VARCHAR(20) DEFAULT NULL); 
    303162CREATE TABLE `zapchandids` ( 
    304163  `channel` int(11) NOT NULL default '0', 
    …… 
    307166  PRIMARY KEY  (channel) 
    308167); 
    309  
    310 /*!40000 ALTER TABLE `incoming` DISABLE KEYS */; 
    311 --  TABLES `incoming` WRITE; 
    312 --  TABLES; 
    313 /*!40000 ALTER TABLE `incoming` ENABLE KEYS */; 
    314  
    315 -- 
    316 -- Table structure for table `modules` 
    317 -- 
    318  
    319 DROP TABLE IF EXISTS `modules`; 
    320168CREATE TABLE `modules` ( 
    321169  `id` INTEGER NOT NULL  PRIMARY KEY AUTOINCREMENT, 
    …… 
    323171  `version` varchar(20) NOT NULL default '', 
    324172  `enabled` tinyint(4) NOT NULL default '0' 
    325 ) ; 
    326  
    327 -- 
    328 -- Dumping data for table `modules` 
    329 -- 
    330  
    331 DROP TABLE IF EXISTS `module_xml`; 
     173); 
     174INSERT INTO "modules" VALUES(1, 'framework', '2.6.0.alpha1.2', 1); 
     175INSERT INTO "modules" VALUES(2, 'core', '2.6.0beta1.0', 1); 
     176INSERT INTO "modules" VALUES(3, 'dashboard', '2.5.0.7', 1); 
     177INSERT INTO "modules" VALUES(4, 'featurecodeadmin', '2.5.0.4', 1); 
     178INSERT INTO "modules" VALUES(5, 'voicemail', '2.5.1.6', 1); 
     179INSERT INTO "modules" VALUES(6, 'recordings', '3.3.9.0', 1); 
     180INSERT INTO "modules" VALUES(7, 'music', '2.5.1.3', 1); 
     181INSERT INTO "modules" VALUES(8, 'conferences', '2.6.0.0', 1); 
    332182CREATE TABLE `module_xml` ( 
    333183  `id` varchar(20) NOT NULL default 'xml', 
    …… 
    337187); 
    338188 
    339  
    340 -- 
    341 -- Table structure for table `sip` 
    342 -- 
    343  
    344 DROP TABLE IF EXISTS `sip`; 
    345189CREATE TABLE `sip` ( 
    346190  `id` varchar(20) NOT NULL default '-1', 
    …… 
    349193  `flags` int(1) NOT NULL default '0', 
    350194  PRIMARY KEY  (`id`,`keyword`) 
    351 ) ; 
    352  
    353 -- 
    354 -- Dumping data for table `sip` 
    355 -- 
    356  
    357  
    358 /*!40000 ALTER TABLE `sip` DISABLE KEYS */; 
    359 --  TABLES `sip` WRITE; 
    360 --  TABLES; 
    361 /*!40000 ALTER TABLE `sip` ENABLE KEYS */; 
    362  
    363 -- 
    364 -- Table structure for table `users` 
    365 -- 
    366  
    367 DROP TABLE IF EXISTS `users`; 
     195); 
    368196CREATE TABLE `users` ( 
    369197  `extension` varchar(20) NOT NULL default '', 
    …… 
    375203  `recording` varchar(50) default NULL, 
    376204  `outboundcid` varchar(50) default NULL 
    377 ) ; 
    378  
    379 -- 
    380 -- Dumping data for table `users` 
    381 -- 
    382  
    383  
    384 /*!40000 ALTER TABLE `users` DISABLE KEYS */; 
    385 --  TABLES `users` WRITE; 
    386 --  TABLES; 
    387 /*!40000 ALTER TABLE `users` ENABLE KEYS */; 
    388  
    389 -- 
    390 -- Table structure for table `zap` 
    391 -- 
    392  
    393 DROP TABLE IF EXISTS `zap`; 
     205, mohclass VARCHAR ( 80 ) DEFAULT "default", sipname VARCHAR ( 50 ) NULL); 
    394206CREATE TABLE `zap` ( 
    395207  `id` varchar(20) NOT NULL default '-1', 
    …… 
    398210  `flags` int(1) NOT NULL default '0', 
    399211  PRIMARY KEY  (`id`,`keyword`) 
    400 ) ; 
    401  
    402 -- 
    403 -- Dumping data for table `zap` 
    404 -- 
    405  
    406 --  
    407 -- Table structure for table `notifications` 
    408 --  
    409  
    410 DROP TABLE IF EXISTS notifications; 
     212); 
    411213CREATE TABLE notifications ( 
    412214  module varchar(24) NOT NULL default '', 
    …… 
    421223  PRIMARY KEY  (module,id) 
    422224); 
    423  
    424 CREATE TABLE IF NOT EXISTS `cronmanager` ( 
     225CREATE TABLE `cronmanager` ( 
    425226  `module` varchar(24) NOT NULL default '', 
    426227  `id` varchar(24) NOT NULL default '', 
    …… 
    431232  PRIMARY KEY  (`module`,`id`) 
    432233); 
    433  
    434 /*!40000 ALTER TABLE `zap` DISABLE KEYS */; 
    435 --  TABLES `zap` WRITE; 
    436 --  TABLES; 
    437 /*!40000 ALTER TABLE `zap` ENABLE KEYS */; 
    438  
    439 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 
    440 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 
    441 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 
    442 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 
    443 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 
    444 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 
    445 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 
    446  
     234INSERT INTO "cronmanager" VALUES('module_admin', 'UPDATES', '4', 24, 0, '/var/lib/asterisk/bin/module_admin listonline'); 
     235CREATE TABLE `trunks`  
     236  (  
     237    `trunkid` INTEGER, 
     238    `name` VARCHAR( 50 ) NOT NULL DEFAULT '',  
     239    `tech` VARCHAR( 20 ) NOT NULL ,  
     240    `outcid` VARCHAR( 40 ) NOT NULL DEFAULT '',  
     241    `keepcid` VARCHAR( 4 ) DEFAULT 'off', 
     242    `maxchans` VARCHAR( 6 ) DEFAULT '', 
     243    `failscript` VARCHAR( 255 ) NOT NULL DEFAULT '',  
     244    `dialoutprefix` VARCHAR( 255 ) NOT NULL DEFAULT '',  
     245    `channelid` VARCHAR( 255 ) NOT NULL DEFAULT '',  
     246    `usercontext` VARCHAR( 255 ) NULL,  
     247    `provider` VARCHAR( 40 ) NULL,  
     248    `disabled` VARCHAR( 4 ) DEFAULT 'off', 
     249   
     250    PRIMARY KEY  (`trunkid`, `tech`, `channelid`)  
     251  ); 
     252INSERT INTO "trunks" VALUES(1, '', 'zap', '', '', '', '', '', 'g0', '', NULL, 'off'); 
     253CREATE TABLE `trunks_dialpatterns`  
     254(  
     255  `trunkid` INTEGER, 
     256  `rule` VARCHAR( 255 ) NOT NULL,  
     257  `seq` INTEGER, 
     258  PRIMARY KEY  (`trunkid`, `rule`, `seq`)  
     259); 
     260INSERT INTO "trunks_dialpatterns" VALUES(4, '500+1|.', 1); 
     261CREATE TABLE recordings (  
     262    `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT,  
     263    displayname VARCHAR(50) , filename BLOB, description  
     264    VARCHAR(254), `fcode` TINYINT( 1 ) DEFAULT 0, `fcode_pass` VARCHAR( 20 ) NULL); 
     265CREATE TABLE `meetme` ( `exten` VARCHAR( 50 ) NOT NULL , `options` VARCHAR( 15 ) , `userpin` VARCHAR( 50 ) , `adminpin` VARCHAR( 50 ) , `description` VARCHAR( 50 ) , `joinmsg` VARCHAR( 255 ) , joinmsg_id INTEGER); 
     266COMMIT;