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