Ticket #1727: newinstall.sql

File newinstall.sql, 13.5 kB (added by diego_iastrubni, 5 years ago)

Proposed newinstall.sql file

Line 
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
20 DROP TABLE IF EXISTS `Backup`;
21 CREATE TABLE `Backup` (
22   `ID` INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
23   `Name` varchar(50) default NULL,
24   `Voicemail` varchar(50) default NULL,
25   `Recordings` varchar(50) default NULL,
26   `Configurations` varchar(50) default NULL,
27   `CDR` varchar(55) default NULL,
28   `FOP` varchar(50) default NULL,
29   `Minutes` varchar(50) default NULL,
30   `Hours` varchar(50) default NULL,
31   `Days` varchar(50) default NULL,
32   `Months` varchar(50) default NULL,
33   `Weekdays` varchar(50) default NULL,
34   `Command` varchar(200) default NULL,
35   `Method` varchar(50) default NULL
36 );
37
38 --
39 -- Dumping data for table `Backup`
40 --
41
42
43 /*!40000 ALTER TABLE `Backup` DISABLE KEYS */;
44 -- LOCK TABLES `Backup` WRITE;
45 -- UNLOCK TABLES;
46 /*!40000 ALTER TABLE `Backup` ENABLE KEYS */;
47
48 --
49 -- Table structure for table `admin`
50 --
51
52 DROP TABLE IF EXISTS `admin`;
53 CREATE TABLE `admin` (
54   `variable` varchar(20) NOT NULL default '',
55   `value` varchar(80) NOT NULL default '',
56   PRIMARY KEY  (`variable`)
57 );
58
59 --
60 -- Dumping data for table `admin`
61 --
62
63
64 /*!40000 ALTER TABLE `admin` DISABLE KEYS */;
65 -- LOCK TABLES `admin` WRITE;
66 INSERT INTO `admin` VALUES ('need_reload','true');
67 INSERT INTO `admin` VALUES ('version','2.2.0beta3');
68 -- UNLOCK TABLES;
69 /*!40000 ALTER TABLE `admin` ENABLE KEYS */;
70
71 --
72 -- Table structure for table `ampusers`
73 --
74
75 DROP TABLE IF EXISTS `ampusers`;
76 CREATE TABLE `ampusers` (
77   `username` varchar(20) NOT NULL default '',
78   `password` varchar(20) NOT NULL default '',
79   `extension_low` varchar(20) NOT NULL default '',
80   `extension_high` varchar(20) NOT NULL default '',
81   `deptname` varchar(20) NOT NULL default '',
82   `sections` varchar(255) NOT NULL default '',
83   PRIMARY KEY  (`username`)
84 );
85
86 --
87 -- Dumping data for table `ampusers`
88 --
89
90
91 /*!40000 ALTER TABLE `ampusers` DISABLE KEYS */;
92 -- LOCK TABLES `ampusers` WRITE;
93 INSERT INTO `ampusers` VALUES ('admin','admin','','','','*');
94 -- UNLOCK TABLES;
95 /*!40000 ALTER TABLE `ampusers` ENABLE KEYS */;
96
97 --
98 -- Table structure for table `devices`
99 --
100
101 DROP TABLE IF EXISTS `devices`;
102 CREATE 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 );
111
112 --
113 -- Dumping data for table `devices`
114 --
115
116
117 /*!40000 ALTER TABLE `devices` DISABLE KEYS */;
118 -- LOCK TABLES `devices` WRITE;
119 -- UNLOCK TABLES;
120 /*!40000 ALTER TABLE `devices` ENABLE KEYS */;
121
122 --
123 -- Table structure for table `extensions`
124 --
125
126 DROP TABLE IF EXISTS `extensions`;
127 CREATE 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 );
137
138 --
139 -- Dumping data for table `extensions`
140 --
141
142
143 /*!40000 ALTER TABLE `extensions` DISABLE KEYS */;
144 -- LOCK TABLES `extensions` WRITE;
145 INSERT INTO `extensions` VALUES ('outrt-001-9_outside','_9.','1','Macro','dialout-trunk,1,${EXTEN:1}',NULL,0);
146 INSERT INTO `extensions` VALUES ('outrt-001-9_outside','_9.','2','Macro','outisbusy','No available circuits',0);
147 INSERT INTO `extensions` VALUES ('outbound-allroutes','include','1','outrt-001-9_outside','','',2);
148 -- UNLOCK TABLES;
149 /*!40000 ALTER TABLE `extensions` ENABLE KEYS */;
150
151 --
152 -- Table structure for table `featurecodes`
153 --
154
155 DROP TABLE IF EXISTS `featurecodes`;
156 CREATE TABLE `featurecodes` (
157   `modulename` varchar(50) NOT NULL default '',
158   `featurename` varchar(50) NOT NULL default '',
159   `description` varchar(200) NOT NULL default '',
160   `defaultcode` varchar(20) default NULL,
161   `customcode` varchar(20) default NULL,
162   `enabled` tinyint(4) NOT NULL default '0',
163   PRIMARY KEY  (`modulename`,`featurename`)
164 --   KEY `enabled` (`enabled`)
165 );
166
167 --
168 -- Dumping data for table `featurecodes`
169 --
170
171
172 /*!40000 ALTER TABLE `featurecodes` DISABLE KEYS */;
173 -- LOCK TABLES `featurecodes` WRITE;
174 INSERT INTO `featurecodes` VALUES ('core','userlogon','User Logon','*11',NULL,1);
175 INSERT INTO `featurecodes` VALUES ('core','userlogoff','User Logoff','*12',NULL,1);
176 INSERT INTO `featurecodes` VALUES ('core','zapbarge','ZapBarge','888',NULL,1);
177 INSERT INTO `featurecodes` VALUES ('core','simu_pstn','Simulate Incoming Call','7777',NULL,1);
178 INSERT INTO `featurecodes` VALUES ('core','simu_fax','Simulate Incoming FAX Call','666',NULL,1);
179 INSERT INTO `featurecodes` VALUES ('core','chanspy','ChanSpy','555',NULL,1);
180 INSERT INTO `featurecodes` VALUES ('core','pickup','Call Pickup (Can be used with GXP-2000)','**',NULL,1);
181 -- UNLOCK TABLES;
182 /*!40000 ALTER TABLE `featurecodes` ENABLE KEYS */;
183
184 --
185 -- Table structure for table `freepbx_log`
186 --
187
188 DROP TABLE IF EXISTS `freepbx_log`;
189 CREATE TABLE `freepbx_log` (
190   `ID` INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
191   `time` datetime NOT NULL default '0000-00-00 00:00:00',
192   `section` varchar(50) default NULL,
193 --   `level` enum('error','warning','debug','devel-debug') NOT NULL default 'error',
194   `level` varchar(15) NOT NULL default 'error',
195   `status` int(11) NOT NULL default '0',
196   `message` text NOT NULL
197 --   KEY `time` (`time`,`level`)
198 );
199
200 --
201 -- Dumping data for table `freepbx_log`
202 --
203
204
205 /*!40000 ALTER TABLE `freepbx_log` DISABLE KEYS */;
206 -- LOCK TABLES `freepbx_log` WRITE;
207 INSERT INTO `freepbx_log` VALUES (1,'2006-11-06 01:55:36','retrieve_conf','devel-debug',0,'Started retrieve_conf, DB Connection OK');
208 INSERT INTO `freepbx_log` VALUES (2,'2006-11-06 01:55:36','retrieve_conf','devel-debug',0,'Writing extensions_additional.conf');
209 -- UNLOCK TABLES;
210 /*!40000 ALTER TABLE `freepbx_log` ENABLE KEYS */;
211
212 --
213 -- Table structure for table `globals`
214 --
215
216 DROP TABLE IF EXISTS `globals`;
217 CREATE TABLE `globals` (
218   `variable` char(20) NOT NULL default '',
219   `value` char(50) NOT NULL default '',
220   PRIMARY KEY  (`variable`)
221 );
222
223 --
224 -- Dumping data for table `globals`
225 --
226
227
228 /*!40000 ALTER TABLE `globals` DISABLE KEYS */;
229 -- LOCK TABLES `globals` WRITE;
230 INSERT INTO `globals` VALUES ('CALLFILENAME','\"\"');
231 INSERT INTO `globals` VALUES ('DIAL_OPTIONS','tr');
232 INSERT INTO `globals` VALUES ('TRUNK_OPTIONS','');
233 INSERT INTO `globals` VALUES ('DIAL_OUT','9');
234 INSERT INTO `globals` VALUES ('FAX','');
235 INSERT INTO `globals` VALUES ('FAX_RX','system');
236 INSERT INTO `globals` VALUES ('FAX_RX_EMAIL','fax@mydomain.com');
237 INSERT INTO `globals` VALUES ('FAX_RX_FROM','freepbx@gmail.com');
238 INSERT INTO `globals` VALUES ('INCOMING','group-all');
239 INSERT INTO `globals` VALUES ('NULL','\"\"');
240 INSERT INTO `globals` VALUES ('OPERATOR','');
241 INSERT INTO `globals` VALUES ('OPERATOR_XTN','');
242 INSERT INTO `globals` VALUES ('PARKNOTIFY','SIP/200');
243 INSERT INTO `globals` VALUES ('RECORDEXTEN','\"\"');
244 INSERT INTO `globals` VALUES ('RINGTIMER','15');
245 INSERT INTO `globals` VALUES ('DIRECTORY','last');
246 INSERT INTO `globals` VALUES ('AFTER_INCOMING','');
247 INSERT INTO `globals` VALUES ('IN_OVERRIDE','forcereghours');
248 INSERT INTO `globals` VALUES ('REGTIME','7:55-17:05');
249 INSERT INTO `globals` VALUES ('REGDAYS','mon-fri');
250 INSERT INTO `globals` VALUES ('DIRECTORY_OPTS','');
251 INSERT INTO `globals` VALUES ('DIALOUTIDS','1');
252 INSERT INTO `globals` VALUES ('OUT_1','ZAP/g0');
253 INSERT INTO `globals` VALUES ('VM_PREFIX','*');
254 INSERT INTO `globals` VALUES ('VM_OPTS','');
255 INSERT INTO `globals` VALUES ('VM_GAIN','');
256 INSERT INTO `globals` VALUES ('VM_DDTYPE','u');
257 INSERT INTO `globals` VALUES ('TIMEFORMAT','kM');
258 INSERT INTO `globals` VALUES ('TONEZONE','us');
259 INSERT INTO `globals` VALUES ('ALLOW_SIP_ANON','no');
260 INSERT INTO `globals` VALUES ('VMX_CONTEXT','from-internal');
261 INSERT INTO `globals` VALUES ('VMX_PRI','1');
262 INSERT INTO `globals` VALUES ('VMX_TIMEDEST_CONTEXT','');
263 INSERT INTO `globals` VALUES ('VMX_TIMEDEST_EXT','dovm');
264 INSERT INTO `globals` VALUES ('VMX_TIMEDEST_PRI','1');
265 INSERT INTO `globals` VALUES ('VMX_LOOPDEST_CONTEXT','');
266 INSERT INTO `globals` VALUES ('VMX_LOOPDEST_EXT','dovm');
267 INSERT INTO `globals` VALUES ('VMX_LOOPDEST_PRI','1');
268 INSERT INTO `globals` VALUES ('VMX_OPTS_TIMEOUT','');
269 INSERT INTO `globals` VALUES ('VMX_OPTS_LOOP','');
270 INSERT INTO `globals` VALUES ('VMX_OPTS_DOVM','');
271 INSERT INTO `globals` VALUES ('VMX_TIMEOUT','2');
272 INSERT INTO `globals` VALUES ('VMX_REPEAT','1');
273 INSERT INTO `globals` VALUES ('VMX_LOOPS','1');
274
275 -- UNLOCK TABLES;
276 /*!40000 ALTER TABLE `globals` ENABLE KEYS */;
277
278 --
279 -- Table structure for table `iax`
280 --
281
282 DROP TABLE IF EXISTS `iax`;
283 CREATE TABLE `iax` (
284   `id` varchar(20) NOT NULL default '-1',
285   `keyword` varchar(30) NOT NULL default '',
286   `data` varchar(150) NOT NULL default '',
287   `flags` int(1) NOT NULL default '0',
288   PRIMARY KEY  (`id`,`keyword`)
289 );
290
291 --
292 -- Dumping data for table `iax`
293 --
294
295
296 /*!40000 ALTER TABLE `iax` DISABLE KEYS */;
297 -- LOCK TABLES `iax` WRITE;
298 -- UNLOCK TABLES;
299 /*!40000 ALTER TABLE `iax` ENABLE KEYS */;
300
301 --
302 -- Table structure for table `incoming`
303 --
304
305 DROP TABLE IF EXISTS `incoming`;
306 CREATE TABLE `incoming` (
307   `cidnum` varchar(20) default NULL,
308   `extension` varchar(20) default NULL,
309   `destination` varchar(50) default NULL,
310   `faxexten` varchar(20) default NULL,
311   `faxemail` varchar(50) default NULL,
312   `answer` tinyint(1) default NULL,
313   `wait` int(2) default NULL,
314   `privacyman` tinyint(1) default NULL,
315   `alertinfo` varchar(32) default NULL,
316   `channel` varchar(20) default NULL,
317   `ringing` varchar(20) default NULL,
318   `mohclass` varchar(80) NOT NULL default 'default'
319 );
320
321 --
322 -- Dumping data for table `incoming`
323 --
324
325
326 /*!40000 ALTER TABLE `incoming` DISABLE KEYS */;
327 -- LOCK TABLES `incoming` WRITE;
328 -- UNLOCK TABLES;
329 /*!40000 ALTER TABLE `incoming` ENABLE KEYS */;
330
331 --
332 -- Table structure for table `modules`
333 --
334
335 DROP TABLE IF EXISTS `modules`;
336 CREATE TABLE `modules` (
337   `ID` INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
338   `modulename` varchar(50) NOT NULL default '',
339   `version` varchar(20) NOT NULL default '',
340   `enabled` tinyint(4) NOT NULL default '0'
341 );
342
343 --
344 -- Dumping data for table `modules`
345 --
346
347
348 /*!40000 ALTER TABLE `modules` DISABLE KEYS */;
349 -- LOCK TABLES `modules` WRITE;
350 INSERT INTO `modules` VALUES (1,'core','1.2',1);
351 -- UNLOCK TABLES;
352 /*!40000 ALTER TABLE `modules` ENABLE KEYS */;
353
354 --
355 -- Table structure for table `queues`
356 --
357
358 DROP TABLE IF EXISTS `queues`;
359 CREATE TABLE `queues` (
360   `id` bigint(11) NOT NULL default '-1',
361   `keyword` varchar(20) NOT NULL default '',
362   `data` varchar(150) NOT NULL default '',
363   `flags` int(1) NOT NULL default '0',
364   PRIMARY KEY  (`id`,`keyword`,`data`)
365 );
366
367 --
368 -- Dumping data for table `queues`
369 --
370
371
372 /*!40000 ALTER TABLE `queues` DISABLE KEYS */;
373 -- LOCK TABLES `queues` WRITE;
374 -- UNLOCK TABLES;
375 /*!40000 ALTER TABLE `queues` ENABLE KEYS */;
376
377 --
378 -- Table structure for table `sip`
379 --
380
381 DROP TABLE IF EXISTS `sip`;
382 CREATE TABLE `sip` (
383   `id` varchar(20) NOT NULL default '-1',
384   `keyword` varchar(30) NOT NULL default '',
385   `data` varchar(150) NOT NULL default '',
386   `flags` int(1) NOT NULL default '0',
387   PRIMARY KEY  (`id`,`keyword`)
388 );
389
390 --
391 -- Dumping data for table `sip`
392 --
393
394
395 /*!40000 ALTER TABLE `sip` DISABLE KEYS */;
396 -- LOCK TABLES `sip` WRITE;
397 -- UNLOCK TABLES;
398 /*!40000 ALTER TABLE `sip` ENABLE KEYS */;
399
400 --
401 -- Table structure for table `users`
402 --
403
404 DROP TABLE IF EXISTS `users`;
405 CREATE TABLE `users` (
406   `extension` varchar(20) NOT NULL default '',
407   `password` varchar(20) default NULL,
408   `name` varchar(50) default NULL,
409   `voicemail` varchar(50) default NULL,
410   `ringtimer` int(3) default NULL,
411   `noanswer` varchar(100) default NULL,
412   `recording` varchar(50) default NULL,
413   `outboundcid` varchar(50) default NULL,
414   `directdid` varchar(50) default NULL,
415   `didalert` varchar(50) default NULL,
416   `faxexten` varchar(20) default NULL,
417   `faxemail` varchar(50) default NULL,
418   `answer` tinyint(1) default NULL,
419   `wait` int(2) default NULL,
420   `privacyman` tinyint(1) default NULL,
421   `mohclass` varchar(80) NOT NULL default 'default',
422   `sipname` varchar(50) default NULL
423 );
424
425 --
426 -- Dumping data for table `users`
427 --
428
429
430 /*!40000 ALTER TABLE `users` DISABLE KEYS */;
431 -- LOCK TABLES `users` WRITE;
432 -- UNLOCK TABLES;
433 /*!40000 ALTER TABLE `users` ENABLE KEYS */;
434
435 --
436 -- Table structure for table `zap`
437 --
438
439 DROP TABLE IF EXISTS `zap`;
440 CREATE TABLE `zap` (
441   `id` varchar(20) NOT NULL default '-1',
442   `keyword` varchar(30) NOT NULL default '',
443   `data` varchar(150) NOT NULL default '',
444   `flags` int(1) NOT NULL default '0',
445   PRIMARY KEY  (`id`,`keyword`)
446 );
447
448 --
449 -- Dumping data for table `zap`
450 --
451
452
453 /*!40000 ALTER TABLE `zap` DISABLE KEYS */;
454 -- LOCK TABLES `zap` WRITE;
455 -- UNLOCK TABLES;
456 /*!40000 ALTER TABLE `zap` ENABLE KEYS */;
457
458 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
459 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
460 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
461 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
462 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
463 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
464 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;