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

Revision 4053, 12.5 kB (checked in by p_lindheimer, 6 years ago)

Merged revisions 3726-3727,3729-3732,3734-3735,3737-3738,3740-3741,3743,3745,3747,3752-3753,3756,3758-3769,3771,3773-3774,3778-3793,3797,3799-3804,3807,3809-3825,3827-3829,3831-3836,3838-3845,3847,3850,3852-3856,3859-3869,3871,3873-3882,3884-3885,3887-3890,3892-3895,3897-3902,3904,3906,3908,3910-3916,3918,3920,3922-3927,3929-3932,3934,3936-3937,3939-3946,3948-3955,3957,3959,3964,3967,3969-3970,3972,3974-3977,3979-3980,3982-3994,3996-4001,4003-4005,4007-4010,4013-4014,4016-4017,4020-4052 via svnmerge from
https://amportal.svn.sourceforge.net/svnroot/amportal/freepbx/branches/2.2

........

r4052 | p_lindheimer | 2007-06-12 12:52:37 -0700 (Tue, 12 Jun 2007) | 1 line


#1989 - maximize the size of sip, zap, iax data field to maximum varchar supported by mysql 4.x to deal with long data lines

........

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   `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` integer NOT NULL PRIMARY KEY AUTOINCREMENT
36 ) ;
37
38 --
39 -- Dumping data for table `Backup`
40 --
41
42
43 /*!40000 ALTER TABLE `Backup` DISABLE KEYS */;
44 -- /* TABLES `Backup` WRITE;
45 --  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 --  TABLES `admin` WRITE;
66 INSERT INTO `admin` VALUES ('need_reload','true');
67 INSERT INTO `admin` VALUES ('version','2.2.0beta3');
68 --  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 --  TABLES `ampusers` WRITE;
93 INSERT INTO `ampusers` VALUES ('admin','admin','','','','*');
94 --  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 --  TABLES `devices` WRITE;
119 --  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 --  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 --  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 --  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 --  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 AUTOINCREMENT,
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` enum('error','warning','debug','devel-debug') NOT NULL,
195  `level` varchar(10),
196   `status` int(11) NOT NULL default '0',
197   `message` text NOT NULL
198 -- ,
199 --   PRIMARY KEY  (`id`),
200 --   KEY `time` (`time`,`level`)
201 ) ;
202
203 --
204 -- Dumping data for table `freepbx_log`
205 --
206
207
208 /*!40000 ALTER TABLE `freepbx_log` DISABLE KEYS */;
209 --  TABLES `freepbx_log` WRITE;
210 INSERT INTO `freepbx_log` VALUES (1,'2006-11-06 01:55:36','retrieve_conf','devel-debug',0,'Started retrieve_conf, DB Connection OK');
211 INSERT INTO `freepbx_log` VALUES (2,'2006-11-06 01:55:36','retrieve_conf','devel-debug',0,'Writing extensions_additional.conf');
212 --  TABLES;
213 /*!40000 ALTER TABLE `freepbx_log` ENABLE KEYS */;
214
215 --
216 -- Table structure for table `globals`
217 --
218
219 DROP TABLE IF EXISTS `globals`;
220 CREATE TABLE `globals` (
221   `variable` char(20) NOT NULL default '',
222   `value` char(50) NOT NULL default '',
223   PRIMARY KEY  (`variable`)
224 ) ;
225
226 --
227 -- Dumping data for table `globals`
228 --
229
230
231 /*!40000 ALTER TABLE `globals` DISABLE KEYS */;
232 --  /*TABLES*/ `globals` WRITE;
233 INSERT INTO `globals` VALUES ('CALLFILENAME','\"\"');
234 INSERT INTO `globals` VALUES ('DIAL_OPTIONS','tr');
235 INSERT INTO `globals` VALUES ('TRUNK_OPTIONS','');
236 INSERT INTO `globals` VALUES ('DIAL_OUT','9');
237 INSERT INTO `globals` VALUES ('FAX','');
238 INSERT INTO `globals` VALUES ('FAX_RX','system');
239 INSERT INTO `globals` VALUES ('FAX_RX_EMAIL','fax@mydomain.com');
240 INSERT INTO `globals` VALUES ('FAX_RX_FROM','freepbx@gmail.com');
241 INSERT INTO `globals` VALUES ('INCOMING','group-all');
242 INSERT INTO `globals` VALUES ('NULL','\"\"');
243 INSERT INTO `globals` VALUES ('OPERATOR','');
244 INSERT INTO `globals` VALUES ('OPERATOR_XTN','');
245 INSERT INTO `globals` VALUES ('PARKNOTIFY','SIP/200');
246 INSERT INTO `globals` VALUES ('RECORDEXTEN','\"\"');
247 INSERT INTO `globals` VALUES ('RINGTIMER','15');
248 INSERT INTO `globals` VALUES ('DIRECTORY','last');
249 INSERT INTO `globals` VALUES ('AFTER_INCOMING','');
250 INSERT INTO `globals` VALUES ('IN_OVERRIDE','forcereghours');
251 INSERT INTO `globals` VALUES ('REGTIME','7:55-17:05');
252 INSERT INTO `globals` VALUES ('REGDAYS','mon-fri');
253 INSERT INTO `globals` VALUES ('DIRECTORY_OPTS','');
254 INSERT INTO `globals` VALUES ('DIALOUTIDS','1');
255 INSERT INTO `globals` VALUES ('OUT_1','ZAP/g0');
256 INSERT INTO `globals` VALUES ('VM_PREFIX','*');
257 INSERT INTO `globals` VALUES ('VM_OPTS','');
258 INSERT INTO `globals` VALUES ('VM_GAIN','');
259 INSERT INTO `globals` VALUES ('VM_DDTYPE','u');
260 INSERT INTO `globals` VALUES ('TIMEFORMAT','kM');
261 INSERT INTO `globals` VALUES ('TONEZONE','us');
262 INSERT INTO `globals` VALUES ('ALLOW_SIP_ANON','no');
263 --  TABLES;
264 /*!40000 ALTER TABLE `globals` ENABLE KEYS */;
265
266 --
267 -- Table structure for table `iax`
268 --
269
270 DROP TABLE IF EXISTS `iax`;
271 CREATE TABLE `iax` (
272   `id` varchar(20) NOT NULL default '-1',
273   `keyword` varchar(30) NOT NULL default '',
274   `data` varchar(255) NOT NULL default '',
275   `flags` int(1) NOT NULL default '0',
276   PRIMARY KEY  (`id`,`keyword`)
277 ) ;
278
279 --
280 -- Dumping data for table `iax`
281 --
282
283
284 /*!40000 ALTER TABLE `iax` DISABLE KEYS */;
285 --  TABLES `iax` WRITE;
286 --  TABLES;
287 /*!40000 ALTER TABLE `iax` ENABLE KEYS */;
288
289 --
290 -- Table structure for table `incoming`
291 --
292
293 DROP TABLE IF EXISTS `incoming`;
294 CREATE TABLE `incoming` (
295   `cidnum` varchar(20) default NULL,
296   `extension` varchar(20) default NULL,
297   `destination` varchar(50) default NULL,
298   `faxexten` varchar(20) default NULL,
299   `faxemail` varchar(50) default NULL,
300   `answer` tinyint(1) default NULL,
301   `wait` int(2) default NULL,
302   `privacyman` tinyint(1) default NULL,
303   `alertinfo` varchar(32) default NULL,
304   `channel` varchar(20) default NULL,
305   `ringing` varchar(20) default NULL
306 ) ;
307
308 --
309 -- Dumping data for table `incoming`
310 --
311
312
313 /*!40000 ALTER TABLE `incoming` DISABLE KEYS */;
314 --  TABLES `incoming` WRITE;
315 --  TABLES;
316 /*!40000 ALTER TABLE `incoming` ENABLE KEYS */;
317
318 --
319 -- Table structure for table `modules`
320 --
321
322 DROP TABLE IF EXISTS `modules`;
323 CREATE TABLE `modules` (
324   `id` INTEGER NOT NULL  PRIMARY KEY AUTOINCREMENT,
325   `modulename` varchar(50) NOT NULL default '',
326   `version` varchar(20) NOT NULL default '',
327   `enabled` tinyint(4) NOT NULL default '0'
328 ) ;
329
330 --
331 -- Dumping data for table `modules`
332 --
333
334
335 /*!40000 ALTER TABLE `modules` DISABLE KEYS */;
336 --  TABLES `modules` WRITE;
337 INSERT INTO `modules` VALUES (1,'core','1.2',1);
338 --  TABLES;
339 /*!40000 ALTER TABLE `modules` ENABLE KEYS */;
340
341 --
342 -- Table structure for table `queues`
343 --
344
345 DROP TABLE IF EXISTS `queues`;
346 CREATE TABLE `queues` (
347   `id` bigint(11) NOT NULL default '-1',
348   `keyword` varchar(20) NOT NULL default '',
349   `data` varchar(150) NOT NULL default '',
350   `flags` int(1) NOT NULL default '0',
351   PRIMARY KEY  (`id`,`keyword`,`data`)
352 ) ;
353
354 --
355 -- Dumping data for table `queues`
356 --
357
358
359 /*!40000 ALTER TABLE `queues` DISABLE KEYS */;
360 --  TABLES `queues` WRITE;
361 --  TABLES;
362 /*!40000 ALTER TABLE `queues` ENABLE KEYS */;
363
364 --
365 -- Table structure for table `sip`
366 --
367
368 DROP TABLE IF EXISTS `sip`;
369 CREATE TABLE `sip` (
370   `id` varchar(20) NOT NULL default '-1',
371   `keyword` varchar(30) NOT NULL default '',
372   `data` varchar(255) NOT NULL default '',
373   `flags` int(1) NOT NULL default '0',
374   PRIMARY KEY  (`id`,`keyword`)
375 ) ;
376
377 --
378 -- Dumping data for table `sip`
379 --
380
381
382 /*!40000 ALTER TABLE `sip` DISABLE KEYS */;
383 --  TABLES `sip` WRITE;
384 --  TABLES;
385 /*!40000 ALTER TABLE `sip` ENABLE KEYS */;
386
387 --
388 -- Table structure for table `users`
389 --
390
391 DROP TABLE IF EXISTS `users`;
392 CREATE TABLE `users` (
393   `extension` varchar(20) NOT NULL default '',
394   `password` varchar(20) default NULL,
395   `name` varchar(50) default NULL,
396   `voicemail` varchar(50) default NULL,
397   `ringtimer` int(3) default NULL,
398   `noanswer` varchar(100) default NULL,
399   `recording` varchar(50) default NULL,
400   `outboundcid` varchar(50) default NULL,
401   `directdid` varchar(50) default NULL,
402   `didalert` varchar(50) default NULL,
403   `faxexten` varchar(20) default NULL,
404   `faxemail` varchar(50) default NULL,
405   `answer` tinyint(1) default NULL,
406   `wait` int(2) default NULL,
407   `privacyman` tinyint(1) default NULL
408 ) ;
409
410 --
411 -- Dumping data for table `users`
412 --
413
414
415 /*!40000 ALTER TABLE `users` DISABLE KEYS */;
416 --  TABLES `users` WRITE;
417 --  TABLES;
418 /*!40000 ALTER TABLE `users` ENABLE KEYS */;
419
420 --
421 -- Table structure for table `zap`
422 --
423
424 DROP TABLE IF EXISTS `zap`;
425 CREATE TABLE `zap` (
426   `id` varchar(20) NOT NULL default '-1',
427   `keyword` varchar(30) NOT NULL default '',
428   `data` varchar(255) NOT NULL default '',
429   `flags` int(1) NOT NULL default '0',
430   PRIMARY KEY  (`id`,`keyword`)
431 ) ;
432
433 --
434 -- Dumping data for table `zap`
435 --
436
437
438 /*!40000 ALTER TABLE `zap` DISABLE KEYS */;
439 --  TABLES `zap` WRITE;
440 --  TABLES;
441 /*!40000 ALTER TABLE `zap` ENABLE KEYS */;
442
443 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
444 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
445 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
446 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
447 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
448 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
449 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
450
Note: See TracBrowser for help on using the browser.