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

Revision 12167, 12.7 kB (checked in by p_lindheimer, 1 year ago)

Merged revisions 11124-11125,11128-11133,11135,11137,11145-11147,11149,11166,11168,11216,11228-11229,11240-11241,11243-11244,11255,11263-11264,11272,11278,11280,11282,11285,11291-11293,11300,11302,11321,11334,11339-11343,11352,11363-11364,11366,11368,11382-11384,11388-11390,11399,11405-11406,11421,11449,11453-11460,11462-11464,11471,11482,11485-11487,11493-11494,11498,11502,11504,11528,11530,11535,11543,11555,11558,11574-11576,11579,11581,11583,11585-11587,11589,11591-11592,11599,11622,11629,11631,11633,11637-11639,11641,11652,11662-11663,11666,11668,11671-11672,11675-11676,11704,11711,11714,11719,11721,11723,11725-11726,11732,11755,11760,11762-11764,11767,11769-11770,11772-11774,11796,11799-11800,11805,11807,11810,11812,11818,11822,11826,11828,11830,11841-11842,11853-11855,11891-11892,11900,11928,11931,11937-11940,11944,11954,11960,11968,11971-11974,11986-11987,12016,12021-12022,12024,12036-12037,12044-12046,12056,12061,12066,12068,12073,12076,12154-12156 via svnmerge from

Merged 2.9 branch to trunk.

Line 
1 BEGIN TRANSACTION;
2
3 DROP TABLE IF EXISTS `freepbx_settings`;
4 CREATE TABLE `freepbx_settings` (
5   `keyword` varchar(50) default NULL,
6   `value` varchar(255) default NULL,
7   `name` varchar(80) default NULL,
8   `level` tinyint(1) default 0,
9   `description` text default NULL,
10   `type` varchar(25) default NULL,
11   `options` text default NULL,
12   `defaultval` varchar(255) default NULL,
13   `readonly` tinyint(1) default 0,
14   `hidden` tinyint(1) default 0,
15   `category` varchar(50) default NULL,
16   `module` varchar(25) default NULL,
17   `emptyok` tinyint(1) default 1,
18   `sortorder` int(11) default 0,
19   PRIMARY KEY  (`keyword`)
20  );
21 CREATE TABLE `admin` (
22   `variable` varchar(20) NOT NULL default '',
23   `value` varchar(80) NOT NULL default '',
24   PRIMARY KEY  (`variable`)
25 );
26 INSERT INTO "admin" VALUES('need_reload', 'true');
27 INSERT INTO "admin" VALUES('version', '2.6.0beta1');
28 CREATE TABLE `ampusers` (
29   `username` varchar(20) NOT NULL default '',
30   `password_sha1` varchar(20) NOT NULL default '',
31   `extension_low` varchar(20) NOT NULL default '',
32   `extension_high` varchar(20) NOT NULL default '',
33   `deptname` varchar(20) NOT NULL default '',
34   `sections` varchar(255) NOT NULL default '',
35   PRIMARY KEY  (`username`)
36 );
37 INSERT INTO "ampusers" VALUES('admin', 'd033e22ae348aeb5660fc2140aec35850c4da997', '', '', '', '*');
38 CREATE TABLE `devices` (
39   `id` varchar(20) NOT NULL default '',
40   `tech` varchar(10) NOT NULL default '',
41   `dial` varchar(50) NOT NULL default '',
42   `devicetype` varchar(5) NOT NULL default '',
43   `user` varchar(50) default NULL,
44   `description` varchar(50) default NULL,
45   `emergency_cid` varchar(100) default NULL
46 );
47 CREATE TABLE `extensions` (
48   `context` varchar(45) NOT NULL default 'default',
49   `extension` varchar(45) NOT NULL default '',
50   `priority` varchar(5) NOT NULL default '1',
51   `application` varchar(45) NOT NULL default '',
52   `args` varchar(255) default NULL,
53   `descr` text,
54   `flags` int(1) NOT NULL default '0',
55   PRIMARY KEY  (`context`,`extension`,`priority`)
56 );
57 INSERT INTO "extensions" VALUES('outrt-001-9_outside', '_9.', '1', 'Macro', 'dialout-trunk,1,${EXTEN:1}', NULL, 0);
58 INSERT INTO "extensions" VALUES('outrt-001-9_outside', '_9.', '2', 'Macro', 'outisbusy', 'No available circuits', 0);
59 INSERT INTO "extensions" VALUES('outbound-allroutes', 'include', '1', 'outrt-001-9_outside', '', '', 2);
60 CREATE TABLE `featurecodes` (
61   `modulename` varchar(50) NOT NULL default '',
62   `featurename` varchar(50) NOT NULL default '',
63   `description` varchar(200) NOT NULL default '',
64   `defaultcode` varchar(20) default NULL,
65   `customcode` varchar(20) default NULL,
66   `enabled` tinyint(4) NOT NULL default '0',
67   `providedest` tinyint(4) NOT NULL default '0',
68   PRIMARY KEY  (`modulename`,`featurename`)
69 --   KEY `enabled` (`enabled`)
70 );
71 CREATE TABLE `freepbx_log` (
72   `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT,
73   `time` datetime NOT NULL default '0000-00-00 00:00:00',
74   `section` varchar(50) default NULL,
75 --   `level` enum('error','warning','debug','devel-debug') NOT NULL default 'error',
76 --  `level` enum('error','warning','debug','devel-debug') NOT NULL,
77  `level` varchar(10),
78   `status` int(11) NOT NULL default '0',
79   `message` text NOT NULL
80 -- ,
81 --   PRIMARY KEY  (`id`),
82 --   KEY `time` (`time`,`level`)
83 );
84 INSERT INTO "freepbx_log" VALUES(1, '2006-11-06 01:55:36', 'retrieve_conf', 'devel-debug', 0, 'Started retrieve_conf, DB Connection OK');
85 INSERT INTO "freepbx_log" VALUES(2, '2006-11-06 01:55:36', 'retrieve_conf', 'devel-debug', 0, 'Writing extensions_additional.conf');
86 DELETE FROM sqlite_sequence;
87 INSERT INTO "sqlite_sequence" VALUES('freepbx_log', 2);
88 INSERT INTO "sqlite_sequence" VALUES('modules', 8);
89 INSERT INTO "sqlite_sequence" VALUES('recordings', 20);
90 CREATE TABLE `globals` (
91   `variable` varchar(255) NOT NULL default '',
92   `value` varchar(255) NOT NULL default '',
93   PRIMARY KEY  (`variable`)
94 );
95 INSERT INTO "globals" VALUES('CALLFILENAME', '\"\"');
96 INSERT INTO "globals" VALUES('DIAL_OPTIONS', 'tr');
97 INSERT INTO "globals" VALUES('TRUNK_OPTIONS', '');
98 INSERT INTO "globals" VALUES('DIAL_OUT', '9');
99 INSERT INTO "globals" VALUES('FAX', '');
100 INSERT INTO "globals" VALUES('FAX_RX', 'system');
101 INSERT INTO "globals" VALUES('FAX_RX_EMAIL', 'noreply@mydomain.tld');
102 INSERT INTO "globals" VALUES('FAX_RX_FROM', 'noreply@mydomain.tld');
103 INSERT INTO "globals" VALUES('INCOMING', 'group-all');
104 INSERT INTO "globals" VALUES('NULL', '\"\"');
105 INSERT INTO "globals" VALUES('OPERATOR', '');
106 INSERT INTO "globals" VALUES('OPERATOR_XTN', '');
107 INSERT INTO "globals" VALUES('PARKNOTIFY', 'SIP/200');
108 INSERT INTO "globals" VALUES('RECORDEXTEN', '\"\"');
109 INSERT INTO "globals" VALUES('RINGTIMER', '15');
110 INSERT INTO "globals" VALUES('DIRECTORY', 'last');
111 INSERT INTO "globals" VALUES('AFTER_INCOMING', '');
112 INSERT INTO "globals" VALUES('IN_OVERRIDE', 'forcereghours');
113 INSERT INTO "globals" VALUES('REGTIME', '7:55-17:05');
114 INSERT INTO "globals" VALUES('REGDAYS', 'mon-fri');
115 INSERT INTO "globals" VALUES('DIRECTORY_OPTS', '');
116 INSERT INTO "globals" VALUES('DIALOUTIDS', '1');
117 INSERT INTO "globals" VALUES('VM_PREFIX', '*');
118 INSERT INTO "globals" VALUES('VM_OPTS', '');
119 INSERT INTO "globals" VALUES('VM_GAIN', '');
120 INSERT INTO "globals" VALUES('VM_DDTYPE', 'u');
121 INSERT INTO "globals" VALUES('TIMEFORMAT', 'kM');
122 INSERT INTO "globals" VALUES('TONEZONE', 'us');
123 INSERT INTO "globals" VALUES('ALLOW_SIP_ANON', 'no');
124 INSERT INTO "globals" VALUES('VMX_CONTEXT', 'from-internal');
125 INSERT INTO "globals" VALUES('VMX_PRI', '1');
126 INSERT INTO "globals" VALUES('VMX_TIMEDEST_CONTEXT', '');
127 INSERT INTO "globals" VALUES('VMX_TIMEDEST_EXT', 'dovm');
128 INSERT INTO "globals" VALUES('VMX_TIMEDEST_PRI', '1');
129 INSERT INTO "globals" VALUES('VMX_LOOPDEST_CONTEXT', '');
130 INSERT INTO "globals" VALUES('VMX_LOOPDEST_EXT', 'dovm');
131 INSERT INTO "globals" VALUES('VMX_LOOPDEST_PRI', '1');
132 INSERT INTO "globals" VALUES('VMX_OPTS_TIMEOUT', '');
133 INSERT INTO "globals" VALUES('VMX_OPTS_LOOP', '');
134 INSERT INTO "globals" VALUES('VMX_OPTS_DOVM', '');
135 INSERT INTO "globals" VALUES('VMX_TIMEOUT', '2');
136 INSERT INTO "globals" VALUES('VMX_REPEAT', '1');
137 INSERT INTO "globals" VALUES('VMX_LOOPS', '1');
138 INSERT INTO "globals" VALUES('TRANSFER_CONTEXT', 'from-internal-xfer');
139 INSERT INTO "globals" VALUES('MIXMON_FORMAT', 'wav');
140 INSERT INTO "globals" VALUES('MIXMON_DIR', '');
141 INSERT INTO "globals" VALUES('MIXMON_POST', '');
142 INSERT INTO "globals" VALUES('RECORDING_STATE', 'ENABLED');
143 CREATE TABLE `iax` (
144   `id` varchar(20) NOT NULL default '-1',
145   `keyword` varchar(30) NOT NULL default '',
146   `data` varchar(255) NOT NULL default '',
147   `flags` int(1) NOT NULL default '0',
148   PRIMARY KEY  (`id`,`keyword`)
149 );
150 CREATE TABLE `incoming` (
151   `cidnum` varchar(20) default NULL,
152   `extension` varchar(50) default NULL,
153   `destination` varchar(50) default NULL,
154   `faxexten` varchar(20) default NULL,
155   `faxemail` varchar(50) default NULL,
156   `answer` tinyint(1) default NULL,
157   `wait` int(2) default NULL,
158   `privacyman` tinyint(1) default NULL,
159   `alertinfo` varchar(255) default NULL,
160   `ringing` varchar(20) default NULL,
161   `mohclass` varchar(80) NOT NULL default 'default',
162   `description` varchar(80) default NULL,
163   `grppre` varchar(80) default NULL ,
164   `delay_answer` int (2) default NULL
165 , `pricid` VARCHAR(20) DEFAULT NULL);
166 CREATE TABLE `zapchandids` (
167   `channel` int(11) NOT NULL default '0',
168   `description` varchar(40) NOT NULL default '',
169   `did` varchar(60) NOT NULL default '',
170   PRIMARY KEY  (channel)
171 );
172 CREATE TABLE `modules` (
173   `id` INTEGER NOT NULL  PRIMARY KEY AUTOINCREMENT,
174   `modulename` varchar(50) NOT NULL default '',
175   `version` varchar(20) NOT NULL default '',
176   `enabled` tinyint(4) NOT NULL default '0'
177 );
178 INSERT INTO "modules" VALUES(1, 'framework', '2.6.0.alpha1.2', 1);
179 INSERT INTO "modules" VALUES(2, 'core', '2.6.0beta1.0', 1);
180 INSERT INTO "modules" VALUES(3, 'dashboard', '2.5.0.7', 1);
181 INSERT INTO "modules" VALUES(4, 'featurecodeadmin', '2.5.0.4', 1);
182 INSERT INTO "modules" VALUES(5, 'voicemail', '2.5.1.6', 1);
183 INSERT INTO "modules" VALUES(6, 'recordings', '3.3.9.0', 1);
184 INSERT INTO "modules" VALUES(7, 'music', '2.5.1.3', 1);
185 INSERT INTO "modules" VALUES(8, 'conferences', '2.6.0.0', 1);
186 CREATE TABLE `module_xml` (
187   `id` varchar(20) NOT NULL default 'xml',
188   `time` int(11) NOT NULL default '0',
189   `data` mediumblob NOT NULL,
190   PRIMARY KEY  (`id`)
191 );
192
193 CREATE TABLE `sip` (
194   `id` varchar(20) NOT NULL default '-1',
195   `keyword` varchar(30) NOT NULL default '',
196   `data` varchar(255) NOT NULL default '',
197   `flags` int(1) NOT NULL default '0',
198   PRIMARY KEY  (`id`,`keyword`)
199 );
200 CREATE TABLE `users` (
201   `extension` varchar(20) NOT NULL default '',
202   `password` varchar(20) default NULL,
203   `name` varchar(50) default NULL,
204   `voicemail` varchar(50) default NULL,
205   `ringtimer` int(3) default NULL,
206   `noanswer` varchar(100) default NULL,
207   `recording` varchar(50) default NULL,
208   `outboundcid` varchar(50) default NULL,
209   `mohclass` VARCHAR ( 80 ) DEFAULT "default",
210   `sipname` VARCHAR ( 50 ) NULL,
211   `noanswer_cid` varchar(20) NOT NULL default '',
212   `busy_cid` varchar(20) NOT NULL default '',
213   `chanunavail_cid` varchar(20) NOT NULL default '',
214   `noanswer_dest` varchar(255) NOT NULL default '',
215   `busy_dest` varchar(255) NOT NULL default '',
216   `chanunavail_dest` varchar(255) NOT NULL default ''
217 );
218 CREATE TABLE `zap` (
219   `id` varchar(20) NOT NULL default '-1',
220   `keyword` varchar(30) NOT NULL default '',
221   `data` varchar(255) NOT NULL default '',
222   `flags` int(1) NOT NULL default '0',
223   PRIMARY KEY  (`id`,`keyword`)
224 );
225 CREATE TABLE `dahdi` (
226   `id` varchar(20) NOT NULL default '-1',
227   `keyword` varchar(30) NOT NULL default '',
228   `data` varchar(255) NOT NULL default '',
229   `flags` int(1) NOT NULL default '0',
230   PRIMARY KEY  (`id`,`keyword`)
231 );
232 CREATE TABLE notifications (
233   module varchar(24) NOT NULL default '',
234   id varchar(24) NOT NULL default '',
235   `level` int(11) NOT NULL default '0',
236   display_text varchar(255) NOT NULL default '',
237   extended_text blob NOT NULL,
238   link varchar(255) NOT NULL default '',
239   `reset` tinyint(4) NOT NULL default '0',
240   candelete tinyint(4) NOT NULL default '0',
241   `timestamp` int(11) NOT NULL default '0',
242   PRIMARY KEY  (module,id)
243 );
244 CREATE TABLE `cronmanager` (
245   `module` varchar(24) NOT NULL default '',
246   `id` varchar(24) NOT NULL default '',
247   `time` varchar(5) default NULL,
248   `freq` int(11) NOT NULL default '0',
249   `lasttime` int(11) NOT NULL default '0',
250   `command` varchar(255) NOT NULL default '',
251   PRIMARY KEY  (`module`,`id`)
252 );
253 INSERT INTO "cronmanager" VALUES('module_admin', 'UPDATES', '4', 24, 0, '/var/lib/asterisk/bin/module_admin listonline');
254 CREATE TABLE `trunks`
255   (
256     `trunkid` INTEGER,
257     `name` VARCHAR( 50 ) NOT NULL DEFAULT '',
258     `tech` VARCHAR( 20 ) NOT NULL ,
259     `outcid` VARCHAR( 40 ) NOT NULL DEFAULT '',
260     `keepcid` VARCHAR( 4 ) DEFAULT 'off',
261     `maxchans` VARCHAR( 6 ) DEFAULT '',
262     `failscript` VARCHAR( 255 ) NOT NULL DEFAULT '',
263     `dialoutprefix` VARCHAR( 255 ) NOT NULL DEFAULT '',
264     `channelid` VARCHAR( 255 ) NOT NULL DEFAULT '',
265     `usercontext` VARCHAR( 255 ) NULL,
266     `provider` VARCHAR( 40 ) NULL,
267     `disabled` VARCHAR( 4 ) DEFAULT 'off',
268  
269     PRIMARY KEY  (`trunkid`, `tech`, `channelid`)
270   );
271 INSERT INTO "trunks" VALUES(1, '', 'zap', '', '', '', '', '', 'g0', '', NULL, 'off');
272 CREATE TABLE `trunks_dialpatterns`
273 ( 
274   `trunkid` INTEGER,
275   `rule` VARCHAR( 255 ) NOT NULL,
276   `seq` INTEGER,
277   PRIMARY KEY  (`trunkid`, `rule`, `seq`)
278 );
279 INSERT INTO "trunks_dialpatterns" VALUES(4, '500+1|.', 1);
280 CREATE TABLE recordings (
281     `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT,
282     displayname VARCHAR(50) , filename BLOB, description
283     VARCHAR(254), `fcode` TINYINT( 1 ) DEFAULT 0, `fcode_pass` VARCHAR( 20 ) NULL);
284 CREATE TABLE `meetme` (
285   `exten` VARCHAR( 50 ) NOT NULL ,
286   `options` VARCHAR( 15 ) ,
287   `userpin` VARCHAR( 50 ) ,
288   `adminpin` VARCHAR( 50 ) ,
289   `description` VARCHAR( 50 ) ,
290   `joinmsg` VARCHAR( 255 ) ,
291   joinmsg_id INTEGER
292 );
293
294 DROP  TABLE IF EXISTS `outbound_routes`;
295 CREATE TABLE `outbound_routes` (
296   `route_id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
297   `name` VARCHAR( 40 ),
298   `outcid` VARCHAR( 40 ),
299   `outcid_mode` VARCHAR( 20 ),
300   `password` VARCHAR( 30 ),
301   `emergency_route` VARCHAR( 4 ),
302   `intracompany_route` VARCHAR( 4 ),
303   `mohclass` VARCHAR( 80 ),
304   `time_group_id` INTEGER DEFAULT NULL
305 );
306
307 DROP TABLE IF EXISTS `outbound_route_patterns`;
308 CREATE TABLE `outbound_route_patterns` (
309   `route_id` INTEGER NOT NULL,
310   `match_pattern_prefix` VARCHAR( 60 ),
311   `match_pattern_pass` VARCHAR( 60 ),
312   `match_cid` VARCHAR( 60 ),
313   `prepend_digits` VARCHAR( 100 ),
314   PRIMARY KEY (`route_id`, `match_pattern_prefix`, `match_pattern_pass`,`match_cid`,`prepend_digits`)
315 );
316
317 DROP TABLE IF EXISTS `outbound_route_trunks`;
318 CREATE TABLE `outbound_route_trunks` (
319   `route_id` INTEGER NOT NULL,
320   `trunk_id` INTEGER NOT NULL,
321   `seq` INTEGER NOT NULL,
322   PRIMARY KEY  (`route_id`, `trunk_id`, `seq`)
323 );
324
325 DROP TABLE IF EXISTS `outbound_route_sequence`;
326 CREATE TABLE `outbound_route_sequence` (
327   `route_id` INTEGER NOT NULL,
328   `seq` INTEGER NOT NULL,
329   PRIMARY KEY  (`route_id`, `seq`)
330 );
331 COMMIT;
Note: See TracBrowser for help on using the browser.