newinstall.sql

Revision 5701, 13.3 kB (checked in by p_lindheimer, 4 years ago)
module_xml needs to be mediumblob to handle larger xml files
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	`ringing` varchar(20) default NULL,
286	`mohclass` varchar(80) NOT NULL default 'default',
287	`description` varchar(80) default NULL,
288	`grppre` varchar (80) default NULL
289	);
290
291	--
292	-- Table structure for table `zapchandids`
293	--
294
295	DROP TABLE IF EXISTS `zapchandids`;
296	CREATE TABLE `zapchandids` (
297	`channel` int(11) NOT NULL default '0',
298	`description` varchar(40) NOT NULL default '',
299	`did` varchar(60) NOT NULL default '',
300	PRIMARY KEY (channel)
301	);
302
303	--
304	-- Dumping data for table `incoming`
305	--
306
307
308	/!40000 ALTER TABLE `incoming` DISABLE KEYS /;
309	-- LOCK TABLES `incoming` WRITE;
310	-- UNLOCK TABLES;
311	/!40000 ALTER TABLE `incoming` ENABLE KEYS /;
312
313	--
314	-- Table structure for table `modules`
315	--
316
317	DROP TABLE IF EXISTS `modules`;
318	CREATE TABLE `modules` (
319	`id` int(11) NOT NULL auto_increment,
320	`modulename` varchar(50) NOT NULL default '',
321	`version` varchar(20) NOT NULL default '',
322	`enabled` tinyint(4) NOT NULL default '0',
323	PRIMARY KEY (`id`)
324	);
325
326	--
327	-- Dumping data for table `modules`
328	--
329
330	DROP TABLE IF EXISTS `module_xml`;
331	CREATE TABLE `module_xml` (
332	`id` varchar(20) NOT NULL default 'xml',
333	`time` int(11) NOT NULL default '0',
334	`data` mediumblob NOT NULL,
335	PRIMARY KEY (`id`)
336	);
337
338	--
339	-- Table structure for table `sip`
340	--
341
342	DROP TABLE IF EXISTS `sip`;
343	CREATE TABLE `sip` (
344	`id` varchar(20) NOT NULL default '-1',
345	`keyword` varchar(30) NOT NULL default '',
346	`data` varchar(255) NOT NULL default '',
347	`flags` int(1) NOT NULL default '0',
348	PRIMARY KEY (`id`,`keyword`)
349	);
350
351	--
352	-- Dumping data for table `sip`
353	--
354
355
356	/!40000 ALTER TABLE `sip` DISABLE KEYS /;
357	-- LOCK TABLES `sip` WRITE;
358	-- UNLOCK TABLES;
359	/!40000 ALTER TABLE `sip` ENABLE KEYS /;
360
361	--
362	-- Table structure for table `users`
363	--
364
365	DROP TABLE IF EXISTS `users`;
366	CREATE TABLE `users` (
367	`extension` varchar(20) NOT NULL default '',
368	`password` varchar(20) default NULL,
369	`name` varchar(50) default NULL,
370	`voicemail` varchar(50) default NULL,
371	`ringtimer` int(3) default NULL,
372	`noanswer` varchar(100) default NULL,
373	`recording` varchar(50) default NULL,
374	`outboundcid` varchar(50) default NULL,
375	`directdid` varchar(50) default NULL,
376	`didalert` varchar(50) default NULL,
377	`faxexten` varchar(20) default NULL,
378	`faxemail` varchar(50) default NULL,
379	`answer` tinyint(1) default NULL,
380	`wait` int(2) default NULL,
381	`privacyman` tinyint(1) default NULL,
382	`mohclass` varchar(80) NOT NULL default 'default',
383	`sipname` varchar(50) default NULL
384	);
385
386	--
387	-- Dumping data for table `users`
388	--
389
390
391	/!40000 ALTER TABLE `users` DISABLE KEYS /;
392	-- LOCK TABLES `users` WRITE;
393	-- UNLOCK TABLES;
394	/!40000 ALTER TABLE `users` ENABLE KEYS /;
395
396	--
397	-- Table structure for table `zap`
398	--
399
400	DROP TABLE IF EXISTS `zap`;
401	CREATE TABLE `zap` (
402	`id` varchar(20) NOT NULL default '-1',
403	`keyword` varchar(30) NOT NULL default '',
404	`data` varchar(255) NOT NULL default '',
405	`flags` int(1) NOT NULL default '0',
406	PRIMARY KEY (`id`,`keyword`)
407	);
408
409	--
410	-- Dumping data for table `zap`
411	--
412
413	--
414	-- Table structure for table `notifications`
415	--
416
417	DROP TABLE IF EXISTS notifications;
418	CREATE TABLE notifications (
419	module varchar(24) NOT NULL default '',
420	id varchar(24) NOT NULL default '',
421	`level` int(11) NOT NULL default '0',
422	display_text varchar(255) NOT NULL default '',
423	extended_text blob NOT NULL,
424	link varchar(255) NOT NULL default '',
425	`reset` tinyint(4) NOT NULL default '0',
426	candelete tinyint(4) NOT NULL default '0',
427	`timestamp` int(11) NOT NULL default '0',
428	PRIMARY KEY (`module`,`id`)
429	);
430
431	CREATE TABLE IF NOT EXISTS `cronmanager` (
432	`module` varchar(24) NOT NULL default '',
433	`id` varchar(24) NOT NULL default '',
434	`time` varchar(5) default NULL,
435	`freq` int(11) NOT NULL default '0',
436	`lasttime` int(11) NOT NULL default '0',
437	`command` varchar(255) NOT NULL default '',
438	PRIMARY KEY (`module`,`id`)
439	);
440
441
442	/!40000 ALTER TABLE `zap` DISABLE KEYS /;
443	-- LOCK TABLES `zap` WRITE;
444	-- UNLOCK TABLES;
445	/!40000 ALTER TABLE `zap` ENABLE KEYS /;
446
447	/!40101 SET SQL_MODE=@OLD_SQL_MODE /;
448	/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
449	/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
450	/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
451	/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
452	/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;
453	/!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;

Note: See TracBrowser for help on using the browser.

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

Download in other formats:

Navigation

Downloads

Screenshots

Documentation

Training

Support

Store

Community

About