· 8 years ago · Jan 13, 2018, 08:02 AM
1DROP TABLE IF EXISTS `sessions`;
2CREATE TABLE `sessions` (
3 `session_name` varchar(60) DEFAULT NULL,
4 `session_type` varchar(10) NOT NULL DEFAULT '',
5 `login_name` varchar(20) NOT NULL DEFAULT '',
6 `login_time` decimal(12,0) NOT NULL DEFAULT '0',
7 `net_address` varchar(16) NOT NULL DEFAULT '',
8 UNIQUE KEY `session_name` (`session_name`)
9) ENGINE=MyISAM DEFAULT CHARSET=utf8;
10
11
12DROP TABLE IF EXISTS `admins`;
13CREATE TABLE `admins` (
14 `admin_name` varchar(20) NOT NULL DEFAULT '',
15 `password` varchar(32) DEFAULT NULL,
16 `fullname` varchar(200) DEFAULT '',
17 `privs` text,
18 `allowedfrom` text,
19 `allowedtimes` text,
20 `status` tinyint(4) DEFAULT '0',
21 `comments` text,
22 `rol_id` int(3) unsigned DEFAULT NULL,
23 `is_login_before` int(1) NOT NULL DEFAULT '1',
24 `admin_expire_date` varchar(15) DEFAULT '20180111200507',
25 UNIQUE KEY `admin_name` (`admin_name`)
26) ENGINE=MyISAM DEFAULT CHARSET=utf8;
27
28INSERT INTO `admins` VALUES ('admin','21232f297a57a5a743894a0e4a801fc3','SBC Admin','GOD_ACCESS','','',1,'',0,1,'20180111200507');
29
30DROP TABLE IF EXISTS `genopts`;
31CREATE TABLE genopts (
32 op_key varchar(50) NOT NULL default '',
33 op_val varchar(250) default '',
34 UNIQUE KEY op_key (op_key)
35) ENGINE=MyISAM DEFAULT CHARSET=utf8;
36
37DROP TABLE IF EXISTS `routes`;
38DROP TABLE IF EXISTS `static_routes`;
39CREATE TABLE static_routes (
40 id int(11) NOT NULL auto_increment,
41 destination varchar(100) default NULL,
42 netmask varchar(100) default NULL,
43 gateway varchar(100) default NULL,
44 interface int(100),
45 PRIMARY KEY (id),
46 CONSTRAINT fk_interface FOREIGN KEY (interface) REFERENCES interfaces(id) ON DELETE CASCADE ON UPDATE CASCADE
47) ENGINE=MyISAM DEFAULT CHARSET=utf8;
48
49DROP TABLE IF EXISTS `interfaces`;
50CREATE TABLE interfaces (
51 id int(11) NOT NULL auto_increment,
52 name varchar(100) default NULL,
53 mac varchar(100) default NULL,
54 status tinyint(1) default NULL,
55 type varchar(100) default NULL,
56 br_priority int(11) default NULL,
57 br_aging varchar(100) default '300',
58 br_fd varchar(100) default '15',
59 br_hello varchar(100) default '2',
60 br_maxage varchar(100) default '20',
61 br_stp tinyint(1) default '0',
62 bond_mode varchar(10) default NULL,
63 bond_miimon varchar(10) default NULL,
64 bond_miirate varchar(10) default NULL,
65 bond_updelay varchar(10) default NULL,
66 bond_downdelay varchar(10) default NULL,
67 bond_lacprate varchar(10) default NULL,
68 bond_mtusize varchar(10) default NULL,
69 bond_xmit_hash_policy varchar(20) default NULL,
70 PRIMARY KEY (id)
71) ENGINE=MyISAM DEFAULT CHARSET=utf8;
72
73DROP TABLE IF EXISTS `interface_rels`;
74CREATE TABLE interface_rels (
75 id int(11) NOT NULL auto_increment,
76 master int(11),
77 slave int(11),
78 br_cost varchar(100) default '4',
79 br_priority varchar(100) default '0',
80 PRIMARY KEY (id),
81 CONSTRAINT fk_master FOREIGN KEY (master) REFERENCES interfaces(id) ON DELETE CASCADE ON UPDATE CASCADE,
82 CONSTRAINT fk_slave FOREIGN KEY (slave) REFERENCES interfaces(id) ON DELETE CASCADE ON UPDATE CASCADE
83) ENGINE=MyISAM DEFAULT CHARSET=utf8;
84
85
86
87CREATE TABLE ip_addresses (
88 id int(11) NOT NULL auto_increment,
89 interface int(100),
90 configuration varchar(100) default NULL,
91 hostname varchar(100) default NULL,
92 auto_dns tinyint(1) default NULL,
93 persistent_dhcp tinyint(1) default NULL,
94 address varchar(100) default NULL,
95 mask varchar(100) default NULL,
96 PRIMARY KEY (id),
97 CONSTRAINT fk_interface FOREIGN KEY (interface) REFERENCES interfaces(id) ON DELETE CASCADE ON UPDATE CASCADE
98) ENGINE=MyISAM DEFAULT CHARSET=utf8;
99
100--
101-- Dumping data for table `ip_addresses`
102--
103
104
105INSERT INTO ip_addresses VALUES (1,2,'IPv4-Static','',0,0,'192.168.233.16','255.255.255.0');
106INSERT INTO ip_addresses VALUES (2,2,'IPv4-Static','',0,0,'192.168.233.17','255.255.255.0');
107
108
109
110
111
112
113
114INSERT INTO interfaces VALUES (1,'lo','00:00:00:00:00:00',1,'physical',32767,'300','15','2','20',0,'4','1','1','0','0','1','900','1');
115INSERT INTO interfaces VALUES (2,'eth0','00:0c:29:52:d1:e1',1,'physical',32767,'300','15','2','20',0,'4','1','1','0','0','1','900','1');
116INSERT INTO interfaces VALUES (3,'eth1','00:50:56:30:da:dc',1,'physical',32767,'300','15','2','20',0,'4','1','1','0','0','1','900','1');
117INSERT INTO interfaces VALUES (4,'eth2','00:0c:29:52:d1:f5',1,'physical',32767,'300','15','2','20',0,'4','1','1','0','0','1','900','1');
118INSERT INTO interfaces VALUES (5,'eth3','00:0c:29:52:d1:ff',1,'physical',32767,'300','15','2','20',0,'4','1','1','0','0','1','900','1');
119INSERT INTO interfaces VALUES (14,'bond0',NULL,NULL,'bond',NULL,'300','15','2','20',0,'4','1','1','0','0','1','900','0');
120
121
122
123
124
125
126
127
128DROP TABLE IF EXISTS `sip_endpoint`;
129DROP TABLE IF EXISTS `sip_endpoints`;
130CREATE TABLE sip_endpoints (
131 id int(11) NOT NULL auto_increment,
132 name varchar(100) NOT NULL,
133 user_agent varchar(100) default NULL,
134 sip_ip int(11),
135 external_sip_ip varchar(50) default,
136 port int(11) default NULL,
137 transport varchar(50) default NULL,
138 outbound_proxy varchar(50) default NULL,
139 rtp_ip int(11),
140 external_rtp_ip varchar(50) default NULL,
141 inbound_bypass_media int(11) default NULL,
142 inbound_media_profile int(11) default NULL,
143 outbound_media_profile int(11) default NULL,
144 sip_trace int(11) default NULL,
145 reliability int(11) default NULL,
146 threepcc int(11) default NULL,
147 request_sip_dns_caching int(11) default NULL,
148 ignore_without_sdp int(11) default NULL,
149 fqnd_header varchar(100) default NULL,
150 max_sip_length varchar(50) default NULL,
151 notify_pefer_response int(11) default NULL,
152 renew_rtp_reinvite int(11) default NULL,
153 allow_payload_type int(11) default NULL,
154 always_outgoiing_sdp int(11) default NULL,
155 lync_interoperability int(11) default NULL,
156 allow_malformed_headers int(11) default NULL,
157 failed_response_code int(11) default NULL,
158 failed_reject_message varchar(50) default NULL,
159 strict_sdp_parsing int(11) default NULL,
160 support_talk_hold int(11) default NULL,
161 sip_session_timer int(11) default NULL,
162 session_expires int(11) default NULL,
163 min_session_expires int(11) default NULL,
164 rtcp_interval int(11) default NULL,
165 rtp_timeout int(11) default NULL,
166 sip_t1_timer int(11) default NULL,
167 sip_t1x64_timer int(11) default NULL,
168 sip_t2_timer int(11) default NULL,
169 sip_t4_timer int(11) default NULL,
170 tls_version varchar(100) default NULL,
171 tls_certificate int(11),
172 tls_passphrase varchar(100) default NULL,
173 certificate_date_verification int(11) default NULL,
174 certificate_verification_policy varchar(50) default NULL,
175 tls_port int(11) default NULL,
176 secure_rtp int(11) default NULL,
177 require_only_secure_rtp int(11) default NULL,
178 secure_avp int(11) default NULL,
179 crypto_life_time int(11) default NULL,
180 crypto_mki_length int(11) default NULL,
181 authenticate_calls int(11) default NULL,
182 accept_blind_auth int(11) default NULL,
183 auth_requests int(11) default NULL,
184 network_validation_acl varchar(50) default NULL,
185 acl_for_bound_calls varchar(100) default NULL,
186 acl_for_registration varchar(100) default NULL,
187 sip_tos_value int(11) default NULL,
188 rtp_tos_value int(11) default NULL,
189 nat_acl varchar(100) default NULL,
190 ping_nat_registration int(11) default NULL,
191 symmetric_response_routing varchar(100) default NULL,
192 ndlb_force_rport int(11) default NULL,
193 rtp_auto_adjust int(11) default NULL,
194 aggressive_nat_detection int(11) default NULL,
195 enable_load_limiting int(11) default NULL,
196 max_concurrent_sessions varchar(100) default NULL,
197 cpu_high_threshold int(11) default NULL,
198 cpu_low_threshold int(11) default NULL,
199 reject_response_code int(11) default NULL,
200 reject_message varchar(100) default NULL,
201 routing_plan int(11) default NULL,
202 manual_redirect_routing int(11) default NULL,
203 always_use_full_identification int(11) default NULL,
204 sip_message_routing int(11) default NULL,
205 unsolicited_sip_msg_routing_plan varchar(100) default NULL,
206 siprelay_allow_methods varchar(50) default NULL,
207 ingress varchar(50) default NULL,
208 egress varchar(50) default NULL,
209 accept_refer int(11) default NULL,
210 PRIMARY KEY (id),
211 CONSTRAINT fk_sip_ip FOREIGN KEY (sip_ip) REFERENCES ip_addresses(id) ON DELETE CASCADE ON UPDATE CASCADE,
212 CONSTRAINT fk_rtp_ip FOREIGN KEY (rtp_ip) REFERENCES ip_addresses(id) ON DELETE CASCADE ON UPDATE CASCADE,
213) ENGINE=MyISAM DEFAULT CHARSET=utf8;
214
215
216
217
218CREATE TABLE sip_domains (
219 id int(11) NOT NULL auto_increment,
220 name varchar(100) NOT NULL,
221 forward varchar(50) default NULL,
222 forward_sip_endpoint int(11),
223 first_trunk int(11),
224 second_trunk int(11),
225 force_expires int(11) default NULL,
226 forward_header int(11) default NULL,
227 PRIMARY KEY (id)
228) ENGINE=MyISAM DEFAULT CHARSET=utf8;
229
230
231CREATE TABLE sip_trunks (
232 id int(11) NOT NULL auto_increment,
233 name varchar(100) default NULL,
234 sip_endpoint varchar(100) default NULL,
235 realm varchar(100) default NULL,
236 register varchar(100) default NULL,
237 username varchar(100) default NULL,
238 password varchar(100) default NULL,
239 PRIMARY KEY (id)
240) ENGINE=MyISAM DEFAULT CHARSET=utf8;
241
242
243
244CREATE TABLE sip_endpoint_domain_rels (
245 id int(11) NOT NULL auto_increment,
246 sip_endpoint int(11),
247 sip_domain int(11),
248 PRIMARY KEY (id),
249 CONSTRAINT fk_sip_endpoint FOREIGN KEY (sip_endpoint) REFERENCES sip_endpoints(id) ON DELETE CASCADE ON UPDATE CASCADE,
250 CONSTRAINT fk_sip_domain FOREIGN KEY (sip_domain) REFERENCES sip_domains(id) ON DELETE CASCADE ON UPDATE CASCADE
251) ENGINE=MyISAM DEFAULT CHARSET=utf8;
252
253
254CREATE TABLE sip_domain_trunk_rels (
255 id int(11) NOT NULL auto_increment,
256 sip_domain int(11),
257 sip_trunk int(11),
258 PRIMARY KEY (id),
259 CONSTRAINT fk_sip_domain FOREIGN KEY (sip_domain) REFERENCES sip_domains(id) ON DELETE CASCADE ON UPDATE CASCADE,
260 CONSTRAINT fk_sip_trunk FOREIGN KEY (sip_trunk) REFERENCES sip_trunks(id) ON DELETE CASCADE ON UPDATE CASCADE
261) ENGINE=MyISAM DEFAULT CHARSET=utf8;
262
263
264CREATE TABLE media_profiles (
265 id int(11) NOT NULL auto_increment,
266 name varchar(100) NOT NULL,
267 codec1 varchar(100) default NULL,
268 codec2 varchar(100) default NULL,
269 codec3 varchar(100) default NULL,
270 codec4 varchar(100) default NULL,
271 codec5 varchar(100) default NULL,
272 codec_mode varchar(50) default NULL,
273 enable_suppression int(11) default NULL,
274 dtmf_mode varchar(50) default NULL,
275 PRIMARY KEY (id)
276) ENGINE=MyISAM DEFAULT CHARSET=utf8;
277
278CREATE TABLE call_routes (
279 id int(11) NOT NULL auto_increment,
280 name varchar(100) NOT NULL,
281 description text,
282 PRIMARY KEY (id)
283) ENGINE=MyISAM DEFAULT CHARSET=utf8;
284
285
286CREATE TABLE certificates (
287 id int(11) NOT NULL auto_increment,
288 name varchar(100) NOT NULL,
289 issuer varchar(100) default NULL,
290 subject varchar(100) default NULL,
291 expires datetime default NULL,
292 type varchar(100) default NULL,
293 filename varchar(100) NOT NULL,
294 PRIMARY KEY (id)
295) ENGINE=MyISAM DEFAULT CHARSET=utf8;