· 8 years ago · Dec 05, 2017, 06:18 PM
1/*
2SQLyog Ultimate v9.20
3MySQL - 5.1.41-3ubuntu12.10 : Database - newfies
4*********************************************************************
5*/
6
7
8/*!40101 SET NAMES utf8 */;
9
10/*!40101 SET SQL_MODE=''*/;
11
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
16CREATE DATABASE /*!32312 IF NOT EXISTS*/`newfies` /*!40100 DEFAULT CHARACTER SET utf8 */;
17
18USE `newfies`;
19
20/*Table structure for table `admin_tools_dashboard_preferences` */
21
22DROP TABLE IF EXISTS `admin_tools_dashboard_preferences`;
23
24CREATE TABLE `admin_tools_dashboard_preferences` (
25 `id` int(11) NOT NULL AUTO_INCREMENT,
26 `user_id` int(11) NOT NULL,
27 `data` longtext NOT NULL,
28 `dashboard_id` varchar(100) NOT NULL,
29 PRIMARY KEY (`id`),
30 KEY `admin_tools_dashboard_preferences_403f60f` (`user_id`)
31) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
32
33/*Table structure for table `admin_tools_menu_bookmark` */
34
35DROP TABLE IF EXISTS `admin_tools_menu_bookmark`;
36
37CREATE TABLE `admin_tools_menu_bookmark` (
38 `id` int(11) NOT NULL AUTO_INCREMENT,
39 `user_id` int(11) NOT NULL,
40 `url` varchar(255) NOT NULL,
41 `title` varchar(255) NOT NULL,
42 PRIMARY KEY (`id`),
43 KEY `admin_tools_menu_bookmark_403f60f` (`user_id`)
44) ENGINE=MyISAM DEFAULT CHARSET=utf8;
45
46/*Table structure for table `auth_group` */
47
48DROP TABLE IF EXISTS `auth_group`;
49
50CREATE TABLE `auth_group` (
51 `id` int(11) NOT NULL AUTO_INCREMENT,
52 `name` varchar(80) NOT NULL,
53 PRIMARY KEY (`id`),
54 UNIQUE KEY `name` (`name`)
55) ENGINE=MyISAM DEFAULT CHARSET=utf8;
56
57/*Table structure for table `auth_group_permissions` */
58
59DROP TABLE IF EXISTS `auth_group_permissions`;
60
61CREATE TABLE `auth_group_permissions` (
62 `id` int(11) NOT NULL AUTO_INCREMENT,
63 `group_id` int(11) NOT NULL,
64 `permission_id` int(11) NOT NULL,
65 PRIMARY KEY (`id`),
66 UNIQUE KEY `group_id` (`group_id`,`permission_id`),
67 KEY `auth_group_permissions_425ae3c4` (`group_id`),
68 KEY `auth_group_permissions_1e014c8f` (`permission_id`)
69) ENGINE=MyISAM DEFAULT CHARSET=utf8;
70
71/*Table structure for table `auth_message` */
72
73DROP TABLE IF EXISTS `auth_message`;
74
75CREATE TABLE `auth_message` (
76 `id` int(11) NOT NULL AUTO_INCREMENT,
77 `user_id` int(11) NOT NULL,
78 `message` longtext NOT NULL,
79 PRIMARY KEY (`id`),
80 KEY `auth_message_403f60f` (`user_id`)
81) ENGINE=MyISAM DEFAULT CHARSET=utf8;
82
83/*Table structure for table `auth_permission` */
84
85DROP TABLE IF EXISTS `auth_permission`;
86
87CREATE TABLE `auth_permission` (
88 `id` int(11) NOT NULL AUTO_INCREMENT,
89 `name` varchar(50) NOT NULL,
90 `content_type_id` int(11) NOT NULL,
91 `codename` varchar(100) NOT NULL,
92 PRIMARY KEY (`id`),
93 UNIQUE KEY `content_type_id` (`content_type_id`,`codename`),
94 KEY `auth_permission_1bb8f392` (`content_type_id`)
95) ENGINE=MyISAM AUTO_INCREMENT=125 DEFAULT CHARSET=utf8;
96
97/*Table structure for table `auth_user` */
98
99DROP TABLE IF EXISTS `auth_user`;
100
101CREATE TABLE `auth_user` (
102 `id` int(11) NOT NULL AUTO_INCREMENT,
103 `username` varchar(30) NOT NULL,
104 `first_name` varchar(30) NOT NULL,
105 `last_name` varchar(30) NOT NULL,
106 `email` varchar(75) NOT NULL,
107 `password` varchar(128) NOT NULL,
108 `is_staff` tinyint(1) NOT NULL,
109 `is_active` tinyint(1) NOT NULL,
110 `is_superuser` tinyint(1) NOT NULL,
111 `last_login` datetime NOT NULL,
112 `date_joined` datetime NOT NULL,
113 PRIMARY KEY (`id`),
114 UNIQUE KEY `username` (`username`)
115) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
116
117/*Table structure for table `auth_user_groups` */
118
119DROP TABLE IF EXISTS `auth_user_groups`;
120
121CREATE TABLE `auth_user_groups` (
122 `id` int(11) NOT NULL AUTO_INCREMENT,
123 `user_id` int(11) NOT NULL,
124 `group_id` int(11) NOT NULL,
125 PRIMARY KEY (`id`),
126 UNIQUE KEY `user_id` (`user_id`,`group_id`),
127 KEY `auth_user_groups_403f60f` (`user_id`),
128 KEY `auth_user_groups_425ae3c4` (`group_id`)
129) ENGINE=MyISAM DEFAULT CHARSET=utf8;
130
131/*Table structure for table `auth_user_user_permissions` */
132
133DROP TABLE IF EXISTS `auth_user_user_permissions`;
134
135CREATE TABLE `auth_user_user_permissions` (
136 `id` int(11) NOT NULL AUTO_INCREMENT,
137 `user_id` int(11) NOT NULL,
138 `permission_id` int(11) NOT NULL,
139 PRIMARY KEY (`id`),
140 UNIQUE KEY `user_id` (`user_id`,`permission_id`),
141 KEY `auth_user_user_permissions_403f60f` (`user_id`),
142 KEY `auth_user_user_permissions_1e014c8f` (`permission_id`)
143) ENGINE=MyISAM DEFAULT CHARSET=utf8;
144
145/*Table structure for table `countries_country` */
146
147DROP TABLE IF EXISTS `countries_country`;
148
149CREATE TABLE `countries_country` (
150 `iso` varchar(2) NOT NULL,
151 `name` varchar(128) NOT NULL,
152 `printable_name` varchar(128) NOT NULL,
153 `iso3` varchar(3) DEFAULT NULL,
154 `numcode` smallint(5) unsigned DEFAULT NULL,
155 PRIMARY KEY (`iso`)
156) ENGINE=MyISAM DEFAULT CHARSET=utf8;
157
158/*Table structure for table `dialer_callrequest` */
159
160DROP TABLE IF EXISTS `dialer_callrequest`;
161
162CREATE TABLE `dialer_callrequest` (
163 `id` int(11) NOT NULL AUTO_INCREMENT,
164 `user_id` int(11) NOT NULL,
165 `request_uuid` varchar(120) DEFAULT NULL,
166 `call_time` datetime NOT NULL,
167 `created_date` datetime NOT NULL,
168 `updated_date` datetime NOT NULL,
169 `call_type` int(11) DEFAULT NULL,
170 `status` int(11) DEFAULT NULL,
171 `callerid` varchar(80) NOT NULL,
172 `phone_number` varchar(80) NOT NULL,
173 `timeout` int(11) NOT NULL,
174 `timelimit` int(11) NOT NULL,
175 `extra_dial_string` varchar(500) NOT NULL,
176 `campaign_subscriber_id` int(11) DEFAULT NULL,
177 `campaign_id` int(11) DEFAULT NULL,
178 `aleg_gateway_id` int(11) DEFAULT NULL,
179 `voipapp_id` int(11) DEFAULT NULL,
180 `extra_data` varchar(120) NOT NULL,
181 `num_attempt` int(11) NOT NULL,
182 `last_attempt_time` datetime DEFAULT NULL,
183 `result` varchar(180) NOT NULL,
184 `hangup_cause` varchar(80) NOT NULL,
185 `parent_callrequest_id` int(11) DEFAULT NULL,
186 PRIMARY KEY (`id`),
187 KEY `dialer_callrequest_403f60f` (`user_id`),
188 KEY `dialer_callrequest_68cc62b4` (`request_uuid`),
189 KEY `dialer_callrequest_329c333c` (`campaign_subscriber_id`),
190 KEY `dialer_callrequest_702b94e6` (`campaign_id`),
191 KEY `dialer_callrequest_7093ac80` (`aleg_gateway_id`),
192 KEY `dialer_callrequest_5e833d6c` (`voipapp_id`),
193 KEY `dialer_callrequest_43bfd0d8` (`parent_callrequest_id`)
194) ENGINE=MyISAM DEFAULT CHARSET=utf8;
195
196/*Table structure for table `dialer_campaign` */
197
198DROP TABLE IF EXISTS `dialer_campaign`;
199
200CREATE TABLE `dialer_campaign` (
201 `id` int(11) NOT NULL AUTO_INCREMENT,
202 `campaign_code` varchar(20) NOT NULL,
203 `name` varchar(100) NOT NULL,
204 `description` longtext,
205 `user_id` int(11) NOT NULL,
206 `status` int(11) DEFAULT NULL,
207 `callerid` varchar(80) NOT NULL,
208 `startingdate` datetime NOT NULL,
209 `expirationdate` datetime NOT NULL,
210 `daily_start_time` time NOT NULL,
211 `daily_stop_time` time NOT NULL,
212 `monday` tinyint(1) NOT NULL,
213 `tuesday` tinyint(1) NOT NULL,
214 `wednesday` tinyint(1) NOT NULL,
215 `thursday` tinyint(1) NOT NULL,
216 `friday` tinyint(1) NOT NULL,
217 `saturday` tinyint(1) NOT NULL,
218 `sunday` tinyint(1) NOT NULL,
219 `frequency` int(11) DEFAULT NULL,
220 `callmaxduration` int(11) DEFAULT NULL,
221 `maxretry` int(11) DEFAULT NULL,
222 `intervalretry` int(11) DEFAULT NULL,
223 `calltimeout` int(11) DEFAULT NULL,
224 `aleg_gateway_id` int(11) NOT NULL,
225 `voipapp_id` int(11) NOT NULL,
226 `extra_data` varchar(120) NOT NULL,
227 `created_date` datetime NOT NULL,
228 `updated_date` datetime NOT NULL,
229 PRIMARY KEY (`id`),
230 UNIQUE KEY `campaign_code` (`campaign_code`),
231 KEY `dialer_campaign_403f60f` (`user_id`),
232 KEY `dialer_campaign_7093ac80` (`aleg_gateway_id`),
233 KEY `dialer_campaign_5e833d6c` (`voipapp_id`)
234) ENGINE=MyISAM DEFAULT CHARSET=utf8;
235
236/*Table structure for table `dialer_campaign_phonebook` */
237
238DROP TABLE IF EXISTS `dialer_campaign_phonebook`;
239
240CREATE TABLE `dialer_campaign_phonebook` (
241 `id` int(11) NOT NULL AUTO_INCREMENT,
242 `campaign_id` int(11) NOT NULL,
243 `phonebook_id` int(11) NOT NULL,
244 PRIMARY KEY (`id`),
245 UNIQUE KEY `campaign_id` (`campaign_id`,`phonebook_id`),
246 KEY `dialer_campaign_phonebook_702b94e6` (`campaign_id`),
247 KEY `dialer_campaign_phonebook_4a491766` (`phonebook_id`)
248) ENGINE=MyISAM DEFAULT CHARSET=utf8;
249
250/*Table structure for table `dialer_campaign_subscriber` */
251
252DROP TABLE IF EXISTS `dialer_campaign_subscriber`;
253
254CREATE TABLE `dialer_campaign_subscriber` (
255 `id` int(11) NOT NULL AUTO_INCREMENT,
256 `contact_id` int(11) DEFAULT NULL,
257 `campaign_id` int(11) DEFAULT NULL,
258 `last_attempt` datetime DEFAULT NULL,
259 `count_attempt` int(11) DEFAULT NULL,
260 `duplicate_contact` varchar(90) NOT NULL,
261 `status` int(11) DEFAULT NULL,
262 `created_date` datetime NOT NULL,
263 `updated_date` datetime NOT NULL,
264 PRIMARY KEY (`id`),
265 UNIQUE KEY `contact_id` (`contact_id`,`campaign_id`),
266 KEY `dialer_campaign_subscriber_170b8823` (`contact_id`),
267 KEY `dialer_campaign_subscriber_702b94e6` (`campaign_id`)
268) ENGINE=MyISAM DEFAULT CHARSET=utf8;
269
270/*Table structure for table `dialer_cdr` */
271
272DROP TABLE IF EXISTS `dialer_cdr`;
273
274CREATE TABLE `dialer_cdr` (
275 `id` int(11) NOT NULL AUTO_INCREMENT,
276 `user_id` int(11) NOT NULL,
277 `request_uuid` varchar(120) DEFAULT NULL,
278 `used_gateway_id` int(11) DEFAULT NULL,
279 `callrequest_id` int(11) DEFAULT NULL,
280 `callid` varchar(120) NOT NULL,
281 `callerid` varchar(120) NOT NULL,
282 `phone_number` varchar(120) DEFAULT NULL,
283 `dialcode_id` int(11) DEFAULT NULL,
284 `starting_date` datetime NOT NULL,
285 `duration` int(11) DEFAULT NULL,
286 `billsec` int(11) DEFAULT NULL,
287 `progresssec` int(11) DEFAULT NULL,
288 `answersec` int(11) DEFAULT NULL,
289 `waitsec` int(11) DEFAULT NULL,
290 `disposition` varchar(40) DEFAULT NULL,
291 `hangup_cause` varchar(40) DEFAULT NULL,
292 `hangup_cause_q850` varchar(10) DEFAULT NULL,
293 PRIMARY KEY (`id`),
294 KEY `dialer_cdr_403f60f` (`user_id`),
295 KEY `dialer_cdr_68cc62b4` (`request_uuid`),
296 KEY `dialer_cdr_12612318` (`used_gateway_id`),
297 KEY `dialer_cdr_1c96d88c` (`callrequest_id`),
298 KEY `dialer_cdr_5c6cbe7f` (`dialcode_id`)
299) ENGINE=MyISAM DEFAULT CHARSET=utf8;
300
301/*Table structure for table `dialer_contact` */
302
303DROP TABLE IF EXISTS `dialer_contact`;
304
305CREATE TABLE `dialer_contact` (
306 `id` int(11) NOT NULL AUTO_INCREMENT,
307 `phonebook_id` int(11) NOT NULL,
308 `contact` varchar(90) NOT NULL,
309 `last_name` varchar(120) DEFAULT NULL,
310 `first_name` varchar(120) DEFAULT NULL,
311 `email` varchar(75) DEFAULT NULL,
312 `country_id` int(11) DEFAULT NULL,
313 `city` varchar(120) DEFAULT NULL,
314 `description` longtext,
315 `status` int(11) DEFAULT NULL,
316 `additional_vars` varchar(100) NOT NULL,
317 `created_date` datetime NOT NULL,
318 `updated_date` datetime NOT NULL,
319 PRIMARY KEY (`id`),
320 UNIQUE KEY `contact` (`contact`,`phonebook_id`),
321 KEY `dialer_contact_4a491766` (`phonebook_id`),
322 KEY `dialer_contact_534dd89` (`country_id`)
323) ENGINE=MyISAM DEFAULT CHARSET=utf8;
324
325/*Table structure for table `dialer_gateway` */
326
327DROP TABLE IF EXISTS `dialer_gateway`;
328
329CREATE TABLE `dialer_gateway` (
330 `id` int(11) NOT NULL AUTO_INCREMENT,
331 `name` varchar(255) NOT NULL,
332 `status` int(11) DEFAULT NULL,
333 `description` longtext NOT NULL,
334 `addprefix` varchar(60) NOT NULL,
335 `removeprefix` varchar(60) NOT NULL,
336 `gateways` varchar(500) NOT NULL,
337 `gateway_codecs` varchar(500) NOT NULL,
338 `gateway_timeouts` varchar(500) NOT NULL,
339 `gateway_retries` varchar(500) NOT NULL,
340 `originate_dial_string` varchar(500) NOT NULL,
341 `secondused` int(11) DEFAULT NULL,
342 `created_date` datetime NOT NULL,
343 `updated_date` datetime NOT NULL,
344 `failover_id` int(11) DEFAULT NULL,
345 `addparameter` varchar(360) NOT NULL,
346 `count_call` int(11) DEFAULT NULL,
347 `count_in_use` int(11) DEFAULT NULL,
348 `maximum_call` int(11) DEFAULT NULL,
349 PRIMARY KEY (`id`),
350 UNIQUE KEY `name` (`name`),
351 KEY `dialer_gateway_3a8274ae` (`failover_id`)
352) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
353
354/*Table structure for table `dialer_phonebook` */
355
356DROP TABLE IF EXISTS `dialer_phonebook`;
357
358CREATE TABLE `dialer_phonebook` (
359 `id` int(11) NOT NULL AUTO_INCREMENT,
360 `name` varchar(90) NOT NULL,
361 `description` longtext,
362 `user_id` int(11) NOT NULL,
363 `created_date` datetime NOT NULL,
364 `updated_date` datetime NOT NULL,
365 PRIMARY KEY (`id`),
366 UNIQUE KEY `name` (`name`),
367 KEY `dialer_phonebook_403f60f` (`user_id`)
368) ENGINE=MyISAM DEFAULT CHARSET=utf8;
369
370/*Table structure for table `dialer_setting` */
371
372DROP TABLE IF EXISTS `dialer_setting`;
373
374CREATE TABLE `dialer_setting` (
375 `id` int(11) NOT NULL AUTO_INCREMENT,
376 `name` varchar(50) DEFAULT NULL,
377 `max_frequency` int(11) DEFAULT NULL,
378 `callmaxduration` int(11) DEFAULT NULL,
379 `maxretry` int(11) DEFAULT NULL,
380 `max_calltimeout` int(11) DEFAULT NULL,
381 `max_number_campaign` int(11) NOT NULL,
382 `max_number_subscriber_campaign` int(11) NOT NULL,
383 `blacklist` longtext,
384 `whitelist` longtext,
385 `created_date` datetime NOT NULL,
386 `updated_date` datetime NOT NULL,
387 PRIMARY KEY (`id`)
388) ENGINE=MyISAM DEFAULT CHARSET=utf8;
389
390/*Table structure for table `django_admin_log` */
391
392DROP TABLE IF EXISTS `django_admin_log`;
393
394CREATE TABLE `django_admin_log` (
395 `id` int(11) NOT NULL AUTO_INCREMENT,
396 `action_time` datetime NOT NULL,
397 `user_id` int(11) NOT NULL,
398 `content_type_id` int(11) DEFAULT NULL,
399 `object_id` longtext,
400 `object_repr` varchar(200) NOT NULL,
401 `action_flag` smallint(5) unsigned NOT NULL,
402 `change_message` longtext NOT NULL,
403 PRIMARY KEY (`id`),
404 KEY `django_admin_log_403f60f` (`user_id`),
405 KEY `django_admin_log_1bb8f392` (`content_type_id`)
406) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
407
408/*Table structure for table `django_content_type` */
409
410DROP TABLE IF EXISTS `django_content_type`;
411
412CREATE TABLE `django_content_type` (
413 `id` int(11) NOT NULL AUTO_INCREMENT,
414 `name` varchar(100) NOT NULL,
415 `app_label` varchar(100) NOT NULL,
416 `model` varchar(100) NOT NULL,
417 PRIMARY KEY (`id`),
418 UNIQUE KEY `app_label` (`app_label`,`model`)
419) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;
420
421/*Table structure for table `django_session` */
422
423DROP TABLE IF EXISTS `django_session`;
424
425CREATE TABLE `django_session` (
426 `session_key` varchar(40) NOT NULL,
427 `session_data` longtext NOT NULL,
428 `expire_date` datetime NOT NULL,
429 PRIMARY KEY (`session_key`),
430 KEY `django_session_3da3d3d8` (`expire_date`)
431) ENGINE=MyISAM DEFAULT CHARSET=utf8;
432
433/*Table structure for table `django_site` */
434
435DROP TABLE IF EXISTS `django_site`;
436
437CREATE TABLE `django_site` (
438 `id` int(11) NOT NULL AUTO_INCREMENT,
439 `domain` varchar(100) NOT NULL,
440 `name` varchar(50) NOT NULL,
441 PRIMARY KEY (`id`)
442) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
443
444/*Table structure for table `djcelery_crontabschedule` */
445
446DROP TABLE IF EXISTS `djcelery_crontabschedule`;
447
448CREATE TABLE `djcelery_crontabschedule` (
449 `id` int(11) NOT NULL AUTO_INCREMENT,
450 `minute` varchar(64) NOT NULL,
451 `hour` varchar(64) NOT NULL,
452 `day_of_week` varchar(64) NOT NULL,
453 PRIMARY KEY (`id`)
454) ENGINE=MyISAM DEFAULT CHARSET=utf8;
455
456/*Table structure for table `djcelery_intervalschedule` */
457
458DROP TABLE IF EXISTS `djcelery_intervalschedule`;
459
460CREATE TABLE `djcelery_intervalschedule` (
461 `id` int(11) NOT NULL AUTO_INCREMENT,
462 `every` int(11) NOT NULL,
463 `period` varchar(24) NOT NULL,
464 PRIMARY KEY (`id`)
465) ENGINE=MyISAM DEFAULT CHARSET=utf8;
466
467/*Table structure for table `djcelery_periodictask` */
468
469DROP TABLE IF EXISTS `djcelery_periodictask`;
470
471CREATE TABLE `djcelery_periodictask` (
472 `id` int(11) NOT NULL AUTO_INCREMENT,
473 `name` varchar(200) NOT NULL,
474 `task` varchar(200) NOT NULL,
475 `interval_id` int(11) DEFAULT NULL,
476 `crontab_id` int(11) DEFAULT NULL,
477 `args` longtext NOT NULL,
478 `kwargs` longtext NOT NULL,
479 `queue` varchar(200) DEFAULT NULL,
480 `exchange` varchar(200) DEFAULT NULL,
481 `routing_key` varchar(200) DEFAULT NULL,
482 `expires` datetime DEFAULT NULL,
483 `enabled` tinyint(1) NOT NULL,
484 `last_run_at` datetime DEFAULT NULL,
485 `total_run_count` int(10) unsigned NOT NULL,
486 `date_changed` datetime NOT NULL,
487 PRIMARY KEY (`id`),
488 UNIQUE KEY `name` (`name`),
489 KEY `djcelery_periodictask_17d2d99d` (`interval_id`),
490 KEY `djcelery_periodictask_7aa5fda` (`crontab_id`)
491) ENGINE=MyISAM DEFAULT CHARSET=utf8;
492
493/*Table structure for table `djcelery_periodictasks` */
494
495DROP TABLE IF EXISTS `djcelery_periodictasks`;
496
497CREATE TABLE `djcelery_periodictasks` (
498 `ident` smallint(6) NOT NULL,
499 `last_update` datetime NOT NULL,
500 PRIMARY KEY (`ident`)
501) ENGINE=MyISAM DEFAULT CHARSET=utf8;
502
503/*Table structure for table `djcelery_taskstate` */
504
505DROP TABLE IF EXISTS `djcelery_taskstate`;
506
507CREATE TABLE `djcelery_taskstate` (
508 `id` int(11) NOT NULL AUTO_INCREMENT,
509 `state` varchar(64) NOT NULL,
510 `task_id` varchar(36) NOT NULL,
511 `name` varchar(200) DEFAULT NULL,
512 `tstamp` datetime NOT NULL,
513 `args` longtext,
514 `kwargs` longtext,
515 `eta` datetime DEFAULT NULL,
516 `expires` datetime DEFAULT NULL,
517 `result` longtext,
518 `traceback` longtext,
519 `runtime` double DEFAULT NULL,
520 `retries` int(11) NOT NULL,
521 `worker_id` int(11) DEFAULT NULL,
522 `hidden` tinyint(1) NOT NULL,
523 PRIMARY KEY (`id`),
524 UNIQUE KEY `task_id` (`task_id`),
525 KEY `djcelery_taskstate_355bfc27` (`state`),
526 KEY `djcelery_taskstate_52094d6e` (`name`),
527 KEY `djcelery_taskstate_f459b00` (`tstamp`),
528 KEY `djcelery_taskstate_20fc5b84` (`worker_id`),
529 KEY `djcelery_taskstate_c91f1bf` (`hidden`)
530) ENGINE=MyISAM DEFAULT CHARSET=utf8;
531
532/*Table structure for table `djcelery_workerstate` */
533
534DROP TABLE IF EXISTS `djcelery_workerstate`;
535
536CREATE TABLE `djcelery_workerstate` (
537 `id` int(11) NOT NULL AUTO_INCREMENT,
538 `hostname` varchar(255) NOT NULL,
539 `last_heartbeat` datetime DEFAULT NULL,
540 PRIMARY KEY (`id`),
541 UNIQUE KEY `hostname` (`hostname`),
542 KEY `djcelery_workerstate_1475381c` (`last_heartbeat`)
543) ENGINE=MyISAM DEFAULT CHARSET=utf8;
544
545/*Table structure for table `notification_notice` */
546
547DROP TABLE IF EXISTS `notification_notice`;
548
549CREATE TABLE `notification_notice` (
550 `id` int(11) NOT NULL AUTO_INCREMENT,
551 `recipient_id` int(11) NOT NULL,
552 `sender_id` int(11) DEFAULT NULL,
553 `message` longtext NOT NULL,
554 `notice_type_id` int(11) NOT NULL,
555 `added` datetime NOT NULL,
556 `unseen` tinyint(1) NOT NULL,
557 `archived` tinyint(1) NOT NULL,
558 `on_site` tinyint(1) NOT NULL,
559 PRIMARY KEY (`id`),
560 KEY `notification_notice_32f69dc` (`recipient_id`),
561 KEY `notification_notice_6fe0a617` (`sender_id`),
562 KEY `notification_notice_d734034` (`notice_type_id`)
563) ENGINE=MyISAM DEFAULT CHARSET=utf8;
564
565/*Table structure for table `notification_noticequeuebatch` */
566
567DROP TABLE IF EXISTS `notification_noticequeuebatch`;
568
569CREATE TABLE `notification_noticequeuebatch` (
570 `id` int(11) NOT NULL AUTO_INCREMENT,
571 `pickled_data` longtext NOT NULL,
572 PRIMARY KEY (`id`)
573) ENGINE=MyISAM DEFAULT CHARSET=utf8;
574
575/*Table structure for table `notification_noticesetting` */
576
577DROP TABLE IF EXISTS `notification_noticesetting`;
578
579CREATE TABLE `notification_noticesetting` (
580 `id` int(11) NOT NULL AUTO_INCREMENT,
581 `user_id` int(11) NOT NULL,
582 `notice_type_id` int(11) NOT NULL,
583 `medium` varchar(1) NOT NULL,
584 `send` tinyint(1) NOT NULL,
585 PRIMARY KEY (`id`),
586 UNIQUE KEY `user_id` (`user_id`,`notice_type_id`,`medium`),
587 KEY `notification_noticesetting_403f60f` (`user_id`),
588 KEY `notification_noticesetting_d734034` (`notice_type_id`)
589) ENGINE=MyISAM DEFAULT CHARSET=utf8;
590
591/*Table structure for table `notification_noticetype` */
592
593DROP TABLE IF EXISTS `notification_noticetype`;
594
595CREATE TABLE `notification_noticetype` (
596 `id` int(11) NOT NULL AUTO_INCREMENT,
597 `label` varchar(40) NOT NULL,
598 `display` varchar(50) NOT NULL,
599 `description` varchar(100) NOT NULL,
600 `default` int(11) NOT NULL,
601 PRIMARY KEY (`id`)
602) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
603
604/*Table structure for table `notification_observeditem` */
605
606DROP TABLE IF EXISTS `notification_observeditem`;
607
608CREATE TABLE `notification_observeditem` (
609 `id` int(11) NOT NULL AUTO_INCREMENT,
610 `user_id` int(11) NOT NULL,
611 `content_type_id` int(11) NOT NULL,
612 `object_id` int(10) unsigned NOT NULL,
613 `notice_type_id` int(11) NOT NULL,
614 `added` datetime NOT NULL,
615 `signal` longtext NOT NULL,
616 PRIMARY KEY (`id`),
617 KEY `notification_observeditem_403f60f` (`user_id`),
618 KEY `notification_observeditem_1bb8f392` (`content_type_id`),
619 KEY `notification_observeditem_d734034` (`notice_type_id`)
620) ENGINE=MyISAM DEFAULT CHARSET=utf8;
621
622/*Table structure for table `sentry_filtervalue` */
623
624DROP TABLE IF EXISTS `sentry_filtervalue`;
625
626CREATE TABLE `sentry_filtervalue` (
627 `id` int(11) NOT NULL AUTO_INCREMENT,
628 `key` varchar(32) NOT NULL,
629 `value` varchar(200) NOT NULL,
630 PRIMARY KEY (`id`),
631 UNIQUE KEY `key` (`key`,`value`)
632) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
633
634/*Table structure for table `sentry_groupedmessage` */
635
636DROP TABLE IF EXISTS `sentry_groupedmessage`;
637
638CREATE TABLE `sentry_groupedmessage` (
639 `id` int(11) NOT NULL AUTO_INCREMENT,
640 `logger` varchar(64) NOT NULL,
641 `class_name` varchar(128) DEFAULT NULL,
642 `level` int(10) unsigned NOT NULL,
643 `message` longtext NOT NULL,
644 `traceback` longtext,
645 `view` varchar(200) DEFAULT NULL,
646 `checksum` varchar(32) NOT NULL,
647 `data` longtext,
648 `status` int(10) unsigned NOT NULL,
649 `times_seen` int(10) unsigned NOT NULL,
650 `last_seen` datetime NOT NULL,
651 `first_seen` datetime NOT NULL,
652 `score` int(11) NOT NULL,
653 PRIMARY KEY (`id`),
654 UNIQUE KEY `logger` (`logger`,`view`,`checksum`),
655 KEY `sentry_groupedmessage_147bb5bf` (`logger`),
656 KEY `sentry_groupedmessage_5420e8b5` (`class_name`),
657 KEY `sentry_groupedmessage_2a8f42e8` (`level`),
658 KEY `sentry_groupedmessage_36528e23` (`status`),
659 KEY `sentry_groupedmessage_74b0b5cf` (`times_seen`),
660 KEY `sentry_groupedmessage_ee4a0d0` (`last_seen`),
661 KEY `sentry_groupedmessage_4d23e6a1` (`first_seen`)
662) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
663
664/*Table structure for table `sentry_message` */
665
666DROP TABLE IF EXISTS `sentry_message`;
667
668CREATE TABLE `sentry_message` (
669 `id` int(11) NOT NULL AUTO_INCREMENT,
670 `logger` varchar(64) NOT NULL,
671 `class_name` varchar(128) DEFAULT NULL,
672 `level` int(10) unsigned NOT NULL,
673 `message` longtext NOT NULL,
674 `traceback` longtext,
675 `view` varchar(200) DEFAULT NULL,
676 `checksum` varchar(32) NOT NULL,
677 `data` longtext,
678 `message_id` varchar(32) DEFAULT NULL,
679 `group_id` int(11) DEFAULT NULL,
680 `datetime` datetime NOT NULL,
681 `url` varchar(200) DEFAULT NULL,
682 `server_name` varchar(128) NOT NULL,
683 `site` varchar(128) DEFAULT NULL,
684 PRIMARY KEY (`id`),
685 UNIQUE KEY `message_id` (`message_id`),
686 KEY `sentry_message_147bb5bf` (`logger`),
687 KEY `sentry_message_5420e8b5` (`class_name`),
688 KEY `sentry_message_2a8f42e8` (`level`),
689 KEY `sentry_message_425ae3c4` (`group_id`),
690 KEY `sentry_message_882a7e0` (`datetime`),
691 KEY `sentry_message_326e5a6b` (`server_name`),
692 KEY `sentry_message_1ff577e6` (`site`)
693) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
694
695/*Table structure for table `sentry_messageindex` */
696
697DROP TABLE IF EXISTS `sentry_messageindex`;
698
699CREATE TABLE `sentry_messageindex` (
700 `id` int(11) NOT NULL AUTO_INCREMENT,
701 `object_id` int(10) unsigned NOT NULL,
702 `column` varchar(32) NOT NULL,
703 `value` varchar(128) NOT NULL,
704 PRIMARY KEY (`id`),
705 UNIQUE KEY `column` (`column`,`value`,`object_id`)
706) ENGINE=MyISAM DEFAULT CHARSET=utf8;
707
708/*Table structure for table `simu_country` */
709
710DROP TABLE IF EXISTS `simu_country`;
711
712CREATE TABLE `simu_country` (
713 `id` int(11) NOT NULL AUTO_INCREMENT,
714 `countrycode` varchar(240) NOT NULL,
715 `countryprefix` int(11) NOT NULL,
716 `countryname` varchar(240) NOT NULL,
717 PRIMARY KEY (`id`)
718) ENGINE=MyISAM AUTO_INCREMENT=256 DEFAULT CHARSET=utf8;
719
720/*Table structure for table `simu_prefix` */
721
722DROP TABLE IF EXISTS `simu_prefix`;
723
724CREATE TABLE `simu_prefix` (
725 `prefix` int(11) NOT NULL,
726 `destination` varchar(180) NOT NULL,
727 `country_id` int(11) DEFAULT NULL,
728 `carrier_name` varchar(180) NOT NULL,
729 `prefix_type` int(11) NOT NULL,
730 PRIMARY KEY (`prefix`),
731 KEY `simu_prefix_534dd89` (`country_id`)
732) ENGINE=MyISAM DEFAULT CHARSET=utf8;
733
734/*Table structure for table `voip_app` */
735
736DROP TABLE IF EXISTS `voip_app`;
737
738CREATE TABLE `voip_app` (
739 `id` int(11) NOT NULL AUTO_INCREMENT,
740 `name` varchar(90) NOT NULL,
741 `description` longtext,
742 `type` int(11) DEFAULT NULL,
743 `gateway_id` int(11) DEFAULT NULL,
744 `data` varchar(500) NOT NULL,
745 `user_id` int(11) NOT NULL,
746 `created_date` datetime NOT NULL,
747 `updated_date` datetime NOT NULL,
748 PRIMARY KEY (`id`),
749 KEY `voip_app_7702dc03` (`gateway_id`),
750 KEY `voip_app_403f60f` (`user_id`)
751) ENGINE=MyISAM DEFAULT CHARSET=utf8;
752
753/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
754/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
755/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
756/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;