newinstall.sql

Revision 4895, 13.6 kB (checked in by p_lindheimer, 6 years ago)
#2277 make queues keywork length larger
Property svn:eol-style set to `native` Property svn:keywords set to `Author Date Id Revision`

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

Note: See TracBrowser for help on using the browser.

root/freepbx/branches/2.3/SQL/newinstall.sql

Download in other formats:

Navigation

Downloads

Screenshots

Documentation

Training

Support

Store

Community

About