GVDNwk5V

1-- phpMyAdmin SQL Dump
2-- version 4.0.8
3-- http://www.phpmyadmin.net
4--
5-- Host: mysql1-lc.lux.inn.eu
6-- Generation Time: Oct 12, 2016 at 11:29 AM
7-- Server version: 5.5.43-0+deb7u1-log
8-- PHP Version: 5.6.23-1+deprecated+dontuse+deb.sury.org~precise+1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `pladform_pladform`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `acl`
21--
22
23CREATE TABLE IF NOT EXISTS `acl` (
24  `id` int(11) NOT NULL AUTO_INCREMENT,
25  `user_id` int(11) NOT NULL,
26  `key` varchar(255) NOT NULL,
27  `result` tinyint(1) NOT NULL DEFAULT '0',
28  PRIMARY KEY (`id`),
29  UNIQUE KEY `user_id_key_idx` (`user_id`,`key`),
30  KEY `user_id_idx` (`user_id`)
31) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Access controll list' AUTO_INCREMENT=97373 ;
32
33-- --------------------------------------------------------
34
35--
36-- Table structure for table `acl_assignment`
37--
38
39CREATE TABLE IF NOT EXISTS `acl_assignment` (
40  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
41  `user_id` int(11) unsigned NOT NULL COMMENT 'ID пользователя',
42  `preset_id` int(11) unsigned DEFAULT NULL COMMENT 'ID пресета',
43  `right_id` int(11) unsigned DEFAULT NULL COMMENT 'ID правила',
44  `date_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата создания',
45  PRIMARY KEY (`id`),
46  KEY `user_id` (`user_id`)
47) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Таблица с политиками ролей системы. Здесь сосредоточены все права доступа к определенным контроллерам и методам' AUTO_INCREMENT=23 ;
48
49-- --------------------------------------------------------
50
51--
52-- Table structure for table `acl_methods`
53--
54
55CREATE TABLE IF NOT EXISTS `acl_methods` (
56  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
57  `method` varchar(2048) NOT NULL DEFAULT '' COMMENT 'Namespace метода в системе',
58  PRIMARY KEY (`id`)
59) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Таблица со списком методов системы' AUTO_INCREMENT=77 ;
60
61-- --------------------------------------------------------
62
63--
64-- Table structure for table `acl_presets`
65--
66
67CREATE TABLE IF NOT EXISTS `acl_presets` (
68  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID пресета',
69  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Название пресета',
70  PRIMARY KEY (`id`)
71) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Таблица с пресетами (ролями) доступа к методам и контероллерам системы' AUTO_INCREMENT=7 ;
72
73-- --------------------------------------------------------
74
75--
76-- Table structure for table `acl_rights`
77--
78
79CREATE TABLE IF NOT EXISTS `acl_rights` (
80  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
81  `preset_id` int(11) unsigned NOT NULL COMMENT 'ID пресета',
82  `method_id` int(11) unsigned NOT NULL COMMENT 'ID метода, к которму осуществляют доступ',
83  PRIMARY KEY (`id`),
84  KEY `preset_id` (`preset_id`),
85  KEY `method_id` (`method_id`)
86) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=98 ;
87
88-- --------------------------------------------------------
89
90--
91-- Table structure for table `ad2country`
92--
93
94CREATE TABLE IF NOT EXISTS `ad2country` (
95  `ad_company_id` int(11) NOT NULL,
96  `country_code` varchar(2) DEFAULT NULL,
97  UNIQUE KEY `ad_company_id` (`ad_company_id`,`country_code`)
98) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Стратегия отношения рекламы к стране';
99
100-- --------------------------------------------------------
101
102--
103-- Table structure for table `ad2player`
104--
105
106CREATE TABLE IF NOT EXISTS `ad2player` (
107  `ad_company_id` int(11) NOT NULL COMMENT 'ID рекламы',
108  `player_id` int(11) NOT NULL COMMENT 'ID плеера',
109  PRIMARY KEY (`ad_company_id`,`player_id`)
110) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Таблица рекламных кодов для плеера';
111
112-- --------------------------------------------------------
113
114--
115-- Table structure for table `ad2site`
116--
117
118CREATE TABLE IF NOT EXISTS `ad2site` (
119  `ad_company_id` int(11) NOT NULL,
120  `site_id` int(11) DEFAULT NULL,
121  UNIQUE KEY `id_company_id` (`ad_company_id`,`site_id`)
122) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Стратегия отношения рекламы к площадке';
123
124-- --------------------------------------------------------
125
126--
127-- Table structure for table `adfox_ages`
128--
129
130CREATE TABLE IF NOT EXISTS `adfox_ages` (
131  `id` int(11) NOT NULL,
132  `title` varchar(3) NOT NULL,
133  `age` int(11) NOT NULL,
134  PRIMARY KEY (`id`)
135) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='puid33 - возрастное ограничение adfox-gpmd';
136
137-- --------------------------------------------------------
138
139--
140-- Table structure for table `adfox_categories`
141--
142
143CREATE TABLE IF NOT EXISTS `adfox_categories` (
144  `id` int(11) NOT NULL AUTO_INCREMENT,
145  `title` varchar(32) NOT NULL,
146  PRIMARY KEY (`id`)
147) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='adfox - подробные категории' AUTO_INCREMENT=112 ;
148
149-- --------------------------------------------------------
150
151--
152-- Table structure for table `adfox_category2genre`
153--
154
155CREATE TABLE IF NOT EXISTS `adfox_category2genre` (
156  `adfox_category_id` int(11) NOT NULL COMMENT 'ID категории ГПМД',
157  `genre_id` int(11) DEFAULT NULL COMMENT 'ID жанра видео',
158  `type_id` int(11) NOT NULL COMMENT 'ID типа видео (videolib_types)',
159  UNIQUE KEY `uniq_idx` (`adfox_category_id`,`genre_id`,`type_id`) USING BTREE
160) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Отношение полной тематики гпмд к жанру видео';
161
162-- --------------------------------------------------------
163
164--
165-- Table structure for table `adfox_durations`
166--
167
168CREATE TABLE IF NOT EXISTS `adfox_durations` (
169  `id` int(11) NOT NULL,
170  `title` varchar(255) NOT NULL,
171  `start_second` int(11) NOT NULL,
172  `end_second` int(11) NOT NULL,
173  PRIMARY KEY (`id`)
174) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Удалить после обновления коммита Длительность adfox (puid41)';
175
176-- --------------------------------------------------------
177
178--
179-- Table structure for table `adfox_thematic2type`
180--
181
182CREATE TABLE IF NOT EXISTS `adfox_thematic2type` (
183  `adfox_thematic_id` int(11) NOT NULL COMMENT 'ID тематики adfox',
184  `type_id` int(11) NOT NULL COMMENT 'ID типа видео',
185  PRIMARY KEY (`adfox_thematic_id`,`type_id`)
186) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Отношение типа видео к тематики adfox';
187
188-- --------------------------------------------------------
189
190--
191-- Table structure for table `adfox_thematics`
192--
193
194CREATE TABLE IF NOT EXISTS `adfox_thematics` (
195  `id` int(11) NOT NULL,
196  `title` varchar(255) NOT NULL,
197  `type_id` int(11) DEFAULT NULL COMMENT 'ID типа видео (videolib_types)',
198  PRIMARY KEY (`id`),
199  KEY `type_id` (`type_id`)
200) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Тематики адфокса (puid22)';
201
202-- --------------------------------------------------------
203
204--
205-- Table structure for table `ad_companies`
206--
207
208CREATE TABLE IF NOT EXISTS `ad_companies` (
209  `id` int(11) NOT NULL AUTO_INCREMENT,
210  `user_id` int(11) NOT NULL,
211  `title` varchar(255) NOT NULL DEFAULT '',
212  `cost` decimal(10,2) NOT NULL DEFAULT '0.00',
213  `state` int(11) NOT NULL DEFAULT '0',
214  `type` enum('preroll','pause','pause_banner','overlay','postroll','midroll') DEFAULT NULL,
215  `added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
216  `url` text NOT NULL,
217  `is_mobile` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Работа на мобильной рекламе',
218  `is_web` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Работа на мобильной рекламе',
219  `is_smarttv` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Включение на smart-tv',
220  `priority` int(11) NOT NULL DEFAULT '0' COMMENT 'удалить после релиза',
221  PRIMARY KEY (`id`),
222  KEY `user_id` (`user_id`),
223  KEY `status` (`state`),
224  KEY `type` (`type`),
225  KEY `priority` (`priority`)
226) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='рекламные компании' AUTO_INCREMENT=754 ;
227
228-- --------------------------------------------------------
229
230--
231-- Table structure for table `ad_target`
232--
233
234CREATE TABLE IF NOT EXISTS `ad_target` (
235  `site_id` int(11) NOT NULL COMMENT 'ID площадки',
236  `country_code` char(3) NOT NULL COMMENT 'код страны',
237  `ad_id` int(11) NOT NULL COMMENT 'ID рекламной кампании',
238  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'дата создания таргетинга',
239  `priority` smallint(6) NOT NULL DEFAULT '0' COMMENT 'приоритет',
240  PRIMARY KEY (`site_id`,`country_code`,`ad_id`)
241) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Таргет рекламы на площадку';
242
243-- --------------------------------------------------------
244
245--
246-- Table structure for table `billing_avg_cpms`
247--
248
249CREATE TABLE IF NOT EXISTS `billing_avg_cpms` (
250  `id` int(11) NOT NULL AUTO_INCREMENT,
251  `ad_type` enum('gpmd','foreign','russia_other','everest') NOT NULL DEFAULT 'gpmd',
252  `report_id` int(11) NOT NULL,
253  `value` float DEFAULT '0',
254  PRIMARY KEY (`id`)
255) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=49004 ;
256
257-- --------------------------------------------------------
258
259--
260-- Table structure for table `billing_cpm`
261--
262
263CREATE TABLE IF NOT EXISTS `billing_cpm` (
264  `id` int(11) NOT NULL AUTO_INCREMENT,
265  `period_id` int(11) NOT NULL,
266  `type` enum('gpmd','vk','vkdirect','foreign') NOT NULL,
267  `advertiser_id` int(11) DEFAULT NULL,
268  `value` double DEFAULT NULL,
269  PRIMARY KEY (`id`)
270) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=580 ;
271
272-- --------------------------------------------------------
273
274--
275-- Table structure for table `billing_extra_data`
276--
277
278CREATE TABLE IF NOT EXISTS `billing_extra_data` (
279  `id` int(11) NOT NULL AUTO_INCREMENT,
280  `line_id` int(11) NOT NULL,
281  `param` varchar(256) NOT NULL,
282  `value` varchar(2048) NOT NULL,
283  PRIMARY KEY (`id`),
284  KEY `line_id` (`line_id`)
285) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11201828 ;
286
287-- --------------------------------------------------------
288
289--
290-- Table structure for table `billing_extra_lines`
291--
292
293CREATE TABLE IF NOT EXISTS `billing_extra_lines` (
294  `id` int(11) NOT NULL AUTO_INCREMENT,
295  `report_id` int(11) NOT NULL,
296  `type` enum('regular','total','copy','copy_total') DEFAULT 'regular',
297  PRIMARY KEY (`id`),
298  KEY `extra_id` (`report_id`),
299  KEY `type` (`type`)
300) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=674327 ;
301
302-- --------------------------------------------------------
303
304--
305-- Table structure for table `billing_extra_reports`
306--
307
308CREATE TABLE IF NOT EXISTS `billing_extra_reports` (
309  `id` int(11) NOT NULL AUTO_INCREMENT,
310  `period_id` int(11) NOT NULL,
311  `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
312  `show_name` varchar(50) NOT NULL,
313  `seller_id` int(11) DEFAULT NULL,
314  PRIMARY KEY (`id`)
315) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=362 ;
316
317-- --------------------------------------------------------
318
319--
320-- Table structure for table `billing_foreign_settings`
321--
322
323CREATE TABLE IF NOT EXISTS `billing_foreign_settings` (
324  `id` int(11) NOT NULL AUTO_INCREMENT,
325  `is_active` tinyint(1) DEFAULT '0',
326  `currency` enum('RUR','EUR','USD','') NOT NULL DEFAULT '',
327  `user_id` int(11) NOT NULL,
328  PRIMARY KEY (`id`),
329  KEY `user_id` (`user_id`)
330) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=324 ;
331
332-- --------------------------------------------------------
333
334--
335-- Table structure for table `billing_groups`
336--
337
338CREATE TABLE IF NOT EXISTS `billing_groups` (
339  `id` int(11) NOT NULL AUTO_INCREMENT,
340  `name` varchar(100) NOT NULL,
341  `formula` varchar(256) DEFAULT NULL,
342  PRIMARY KEY (`id`)
343) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
344
345-- --------------------------------------------------------
346
347--
348-- Table structure for table `billing_metrics`
349--
350
351CREATE TABLE IF NOT EXISTS `billing_metrics` (
352  `id` int(11) NOT NULL AUTO_INCREMENT,
353  `name` varchar(100) NOT NULL,
354  `formula` varchar(256) DEFAULT NULL,
355  `show_name` varchar(100) DEFAULT NULL,
356  `show` tinyint(4) NOT NULL DEFAULT '1',
357  `sum` tinyint(4) NOT NULL DEFAULT '0',
358  `format` varchar(100) DEFAULT NULL,
359  `cond_str` varchar(256) DEFAULT NULL,
360  `group_id` int(11) NOT NULL,
361  `vat` tinyint(1) NOT NULL DEFAULT '0',
362  `relnum` int(11) NOT NULL DEFAULT '1',
363  PRIMARY KEY (`id`)
364) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;
365
366-- --------------------------------------------------------
367
368--
369-- Table structure for table `billing_opeartions`
370--
371
372CREATE TABLE IF NOT EXISTS `billing_opeartions` (
373  `id` int(11) NOT NULL AUTO_INCREMENT,
374  `name` varchar(100) NOT NULL,
375  `opcode` varchar(256) DEFAULT NULL,
376  PRIMARY KEY (`id`)
377) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
378
379-- --------------------------------------------------------
380
381--
382-- Table structure for table `billing_periods`
383--
384
385CREATE TABLE IF NOT EXISTS `billing_periods` (
386  `id` int(11) NOT NULL AUTO_INCREMENT,
387  `status` enum('open','closed','error','generation') NOT NULL,
388  `code` varchar(10) NOT NULL,
389  `start_date` datetime DEFAULT NULL,
390  `end_date` datetime DEFAULT NULL,
391  `cpm` double DEFAULT NULL,
392  `percent` int(11) NOT NULL,
393  PRIMARY KEY (`id`)
394) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1993 ;
395
396-- --------------------------------------------------------
397
398--
399-- Table structure for table `billing_period_values`
400--
401
402CREATE TABLE IF NOT EXISTS `billing_period_values` (
403  `id` int(11) NOT NULL AUTO_INCREMENT,
404  `period_id` int(11) NOT NULL,
405  `param_name` int(11) NOT NULL,
406  `value` varchar(100) NOT NULL,
407  PRIMARY KEY (`id`)
408) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
409
410-- --------------------------------------------------------
411
412--
413-- Table structure for table `billing_quarters`
414--
415
416CREATE TABLE IF NOT EXISTS `billing_quarters` (
417  `id` int(11) NOT NULL AUTO_INCREMENT,
418  `status` enum('open','closed','error','generation') NOT NULL,
419  `code` varchar(10) NOT NULL,
420  `start_date` datetime DEFAULT NULL,
421  `end_date` datetime DEFAULT NULL,
422  `percent` int(11) NOT NULL,
423  PRIMARY KEY (`id`)
424) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=345 ;
425
426-- --------------------------------------------------------
427
428--
429-- Table structure for table `billing_quarter_reports`
430--
431
432CREATE TABLE IF NOT EXISTS `billing_quarter_reports` (
433  `id` int(11) NOT NULL AUTO_INCREMENT,
434  `user_id` int(11) NOT NULL,
435  `tarif_id` int(11) NOT NULL,
436  `period_id` int(11) NOT NULL,
437  `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
438  `show_name` varchar(50) NOT NULL,
439  PRIMARY KEY (`id`)
440) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3760 ;
441
442-- --------------------------------------------------------
443
444--
445-- Table structure for table `billing_reports`
446--
447
448CREATE TABLE IF NOT EXISTS `billing_reports` (
449  `id` int(11) NOT NULL AUTO_INCREMENT,
450  `user_id` int(11) NOT NULL,
451  `tarif_id` int(11) NOT NULL,
452  `period_id` int(11) NOT NULL,
453  `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
454  `show_name` varchar(50) NOT NULL,
455  `type` enum('month','quarter') NOT NULL DEFAULT 'month',
456  PRIMARY KEY (`id`)
457) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21804 ;
458
459-- --------------------------------------------------------
460
461--
462-- Table structure for table `billing_report_data`
463--
464
465CREATE TABLE IF NOT EXISTS `billing_report_data` (
466  `id` int(11) NOT NULL AUTO_INCREMENT,
467  `line_id` int(11) NOT NULL,
468  `metric_id` int(11) NOT NULL,
469  `value` varchar(2048) NOT NULL,
470  PRIMARY KEY (`id`),
471  KEY `line_id` (`line_id`)
472) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=266455221 ;
473
474-- --------------------------------------------------------
475
476--
477-- Table structure for table `billing_report_lines`
478--
479
480CREATE TABLE IF NOT EXISTS `billing_report_lines` (
481  `id` int(11) NOT NULL AUTO_INCREMENT,
482  `report_id` int(11) NOT NULL,
483  `type` enum('regular','total','copy','copy_total') DEFAULT 'regular',
484  `ad_type` enum('gpmd','foreign','russia_other','everest') NOT NULL DEFAULT 'gpmd',
485  PRIMARY KEY (`id`),
486  KEY `report_id` (`report_id`),
487  KEY `type` (`type`)
488) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=34595558 ;
489
490-- --------------------------------------------------------
491
492--
493-- Table structure for table `billing_report_quarter_data`
494--
495
496CREATE TABLE IF NOT EXISTS `billing_report_quarter_data` (
497  `id` int(11) NOT NULL AUTO_INCREMENT,
498  `line_id` int(11) NOT NULL,
499  `metric_id` int(11) NOT NULL,
500  `value` varchar(2048) NOT NULL,
501  PRIMARY KEY (`id`),
502  KEY `line_id` (`line_id`)
503) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=55757170 ;
504
505-- --------------------------------------------------------
506
507--
508-- Table structure for table `billing_report_quarter_lines`
509--
510
511CREATE TABLE IF NOT EXISTS `billing_report_quarter_lines` (
512  `id` int(11) NOT NULL AUTO_INCREMENT,
513  `report_id` int(11) NOT NULL,
514  `type` enum('regular','total','copy','copy_total') DEFAULT 'regular',
515  `ad_type` enum('gpmd','foreign','russia_other','everest') NOT NULL DEFAULT 'gpmd',
516  PRIMARY KEY (`id`),
517  KEY `report_id` (`report_id`),
518  KEY `type` (`type`)
519) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6617219 ;
520
521-- --------------------------------------------------------
522
523--
524-- Table structure for table `billing_report_short_type`
525--
526
527CREATE TABLE IF NOT EXISTS `billing_report_short_type` (
528  `id` int(11) NOT NULL AUTO_INCREMENT,
529  `type` enum('short','full') NOT NULL DEFAULT 'full',
530  `user_id` int(11) NOT NULL,
531  PRIMARY KEY (`id`),
532  KEY `user_id` (`user_id`)
533) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=324 ;
534
535-- --------------------------------------------------------
536
537--
538-- Table structure for table `billing_report_types`
539--
540
541CREATE TABLE IF NOT EXISTS `billing_report_types` (
542  `id` int(11) NOT NULL AUTO_INCREMENT,
543  `type` enum('quarter','month') NOT NULL DEFAULT 'month',
544  `user_id` int(11) NOT NULL,
545  PRIMARY KEY (`id`)
546) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=460 ;
547
548-- --------------------------------------------------------
549
550--
551-- Table structure for table `billing_rutube_users`
552--
553
554CREATE TABLE IF NOT EXISTS `billing_rutube_users` (
555  `id` int(11) NOT NULL AUTO_INCREMENT,
556  `user_id` int(11) NOT NULL,
557  `rutube_id` int(11) NOT NULL,
558  PRIMARY KEY (`id`)
559) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=323 ;
560
561-- --------------------------------------------------------
562
563--
564-- Table structure for table `billing_site_percents`
565--
566
567CREATE TABLE IF NOT EXISTS `billing_site_percents` (
568  `id` int(11) NOT NULL AUTO_INCREMENT,
569  `user_id` int(11) NOT NULL,
570  `site_id` int(11) NOT NULL,
571  `percent` float NOT NULL,
572  PRIMARY KEY (`id`),
573  KEY `user_id` (`user_id`)
574) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
575
576-- --------------------------------------------------------
577
578--
579-- Table structure for table `billing_tariffs`
580--
581
582CREATE TABLE IF NOT EXISTS `billing_tariffs` (
583  `id` int(11) NOT NULL AUTO_INCREMENT,
584  `name` varchar(100) NOT NULL,
585  `type_id` int(11) NOT NULL,
586  PRIMARY KEY (`id`)
587) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=79 ;
588
589-- --------------------------------------------------------
590
591--
592-- Table structure for table `billing_tariffs_conditions`
593--
594
595CREATE TABLE IF NOT EXISTS `billing_tariffs_conditions` (
596  `id` int(11) NOT NULL AUTO_INCREMENT,
597  `tarif_id` int(11) NOT NULL,
598  `condition_id` int(11) NOT NULL,
599  `operation_id` int(11) NOT NULL,
600  `value` varchar(100) NOT NULL,
601  PRIMARY KEY (`id`)
602) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
603
604-- --------------------------------------------------------
605
606--
607-- Table structure for table `billing_tariffs_groups`
608--
609
610CREATE TABLE IF NOT EXISTS `billing_tariffs_groups` (
611  `id` int(11) NOT NULL AUTO_INCREMENT,
612  `tarif_id` int(11) NOT NULL,
613  `group_id` int(11) NOT NULL,
614  PRIMARY KEY (`id`)
615) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
616
617-- --------------------------------------------------------
618
619--
620-- Table structure for table `billing_tariffs_metrics`
621--
622
623CREATE TABLE IF NOT EXISTS `billing_tariffs_metrics` (
624  `id` int(11) NOT NULL AUTO_INCREMENT,
625  `tarif_id` int(11) NOT NULL,
626  `metric_id` int(11) NOT NULL,
627  PRIMARY KEY (`id`)
628) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2481 ;
629
630-- --------------------------------------------------------
631
632--
633-- Table structure for table `billing_tariffs_params`
634--
635
636CREATE TABLE IF NOT EXISTS `billing_tariffs_params` (
637  `id` int(11) NOT NULL AUTO_INCREMENT,
638  `show_name` varchar(100) NOT NULL,
639  `name` varchar(100) NOT NULL,
640  `default_value` double NOT NULL,
641  PRIMARY KEY (`id`)
642) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
643
644-- --------------------------------------------------------
645
646--
647-- Table structure for table `billing_tariffs_params_values`
648--
649
650CREATE TABLE IF NOT EXISTS `billing_tariffs_params_values` (
651  `id` int(11) NOT NULL AUTO_INCREMENT,
652  `tarif_id` int(11) NOT NULL,
653  `param_id` int(11) NOT NULL,
654  `value` double NOT NULL,
655  PRIMARY KEY (`id`)
656) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=999 ;
657
658-- --------------------------------------------------------
659
660--
661-- Table structure for table `billing_tariffs_types`
662--
663
664CREATE TABLE IF NOT EXISTS `billing_tariffs_types` (
665  `id` int(11) NOT NULL AUTO_INCREMENT,
666  `name` varchar(100) NOT NULL,
667  `show_name` varchar(50) NOT NULL,
668  PRIMARY KEY (`id`)
669) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
670
671-- --------------------------------------------------------
672
673--
674-- Table structure for table `billing_tariffs_types_metrics`
675--
676
677CREATE TABLE IF NOT EXISTS `billing_tariffs_types_metrics` (
678  `id` int(11) NOT NULL AUTO_INCREMENT,
679  `type_id` int(11) NOT NULL,
680  `metric_id` int(11) NOT NULL,
681  PRIMARY KEY (`id`)
682) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=34 ;
683
684-- --------------------------------------------------------
685
686--
687-- Table structure for table `billing_tariffs_types_params`
688--
689
690CREATE TABLE IF NOT EXISTS `billing_tariffs_types_params` (
691  `id` int(11) NOT NULL AUTO_INCREMENT,
692  `type_id` int(11) NOT NULL,
693  `param_id` int(11) NOT NULL,
694  PRIMARY KEY (`id`)
695) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
696
697-- --------------------------------------------------------
698
699--
700-- Table structure for table `billing_tariffs_users`
701--
702
703CREATE TABLE IF NOT EXISTS `billing_tariffs_users` (
704  `id` int(11) NOT NULL AUTO_INCREMENT,
705  `user_id` int(11) NOT NULL,
706  `tarif_id` int(11) NOT NULL,
707  `traffic_type` enum('gpmd','foreign','everest') NOT NULL DEFAULT 'gpmd',
708  PRIMARY KEY (`id`)
709) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1396 ;
710
711-- --------------------------------------------------------
712
713--
714-- Table structure for table `billing_unf_items`
715--
716
717CREATE TABLE IF NOT EXISTS `billing_unf_items` (
718  `id` int(11) NOT NULL AUTO_INCREMENT,
719  `type` enum('video','category','user') NOT NULL,
720  `item_id` int(11) NOT NULL,
721  PRIMARY KEY (`id`),
722  KEY `type` (`type`,`item_id`)
723) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2265 ;
724
725-- --------------------------------------------------------
726
727--
728-- Table structure for table `billing_user_types`
729--
730
731CREATE TABLE IF NOT EXISTS `billing_user_types` (
732  `id` int(11) NOT NULL AUTO_INCREMENT,
733  `user_type` enum('private','private_4pay','legal') NOT NULL DEFAULT 'legal',
734  `user_id` int(11) NOT NULL,
735  PRIMARY KEY (`id`),
736  KEY `user_id` (`user_id`)
737) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=323 ;
738
739-- --------------------------------------------------------
740
741--
742-- Table structure for table `blacklist_sites`
743--
744
745CREATE TABLE IF NOT EXISTS `blacklist_sites` (
746  `id` int(11) NOT NULL AUTO_INCREMENT,
747  `domain` varchar(255) NOT NULL DEFAULT '' COMMENT 'домен',
748  PRIMARY KEY (`id`)
749) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Черный список площадок, которые не следует добавлять в систему' AUTO_INCREMENT=1 ;
750
751-- --------------------------------------------------------
752
753--
754-- Table structure for table `counters`
755--
756
757CREATE TABLE IF NOT EXISTS `counters` (
758  `id` int(11) NOT NULL AUTO_INCREMENT,
759  `ad_company_id` int(11) DEFAULT NULL,
760  `video_id` int(11) DEFAULT NULL,
761  `type` enum('ga','tns','camscore') NOT NULL,
762  `value` text NOT NULL,
763  `load` text NOT NULL,
764  `start` text NOT NULL,
765  `end` text NOT NULL,
766  PRIMARY KEY (`id`),
767  KEY `ad_company_id` (`ad_company_id`,`video_id`,`type`)
768) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='счетчики для видео или рекламы' AUTO_INCREMENT=1 ;
769
770-- --------------------------------------------------------
771
772--
773-- Table structure for table `country_codes`
774--
775
776CREATE TABLE IF NOT EXISTS `country_codes` (
777  `code` varchar(2) NOT NULL,
778  `country` varchar(255) NOT NULL,
779  `adfox_region_id` int(11) DEFAULT NULL,
780  PRIMARY KEY (`code`),
781  KEY `adfox_region_id` (`adfox_region_id`)
782) ENGINE=InnoDB DEFAULT CHARSET=utf8;
783
784-- --------------------------------------------------------
785
786--
787-- Table structure for table `distribution_categories`
788--
789
790CREATE TABLE IF NOT EXISTS `distribution_categories` (
791  `category_id` int(11) NOT NULL,
792  `start_date` datetime DEFAULT NULL COMMENT 'Время начала вещания',
793  `end_date` datetime DEFAULT NULL COMMENT 'Время окончания вещания',
794  PRIMARY KEY (`category_id`),
795  KEY `category_id_idx` (`category_id`)
796) ENGINE=InnoDB DEFAULT CHARSET=utf8;
797
798-- --------------------------------------------------------
799
800--
801-- Table structure for table `distribution_categories2countries`
802--
803
804CREATE TABLE IF NOT EXISTS `distribution_categories2countries` (
805  `category_id` int(11) NOT NULL COMMENT 'ID сезона',
806  `country_code` varchar(2) NOT NULL COMMENT 'Символьный код страны',
807  PRIMARY KEY (`category_id`,`country_code`),
808  KEY `category_id_idx` (`category_id`)
809) ENGINE=InnoDB DEFAULT CHARSET=utf8;
810
811-- --------------------------------------------------------
812
813--
814-- Table structure for table `distribution_categories2sites`
815--
816
817CREATE TABLE IF NOT EXISTS `distribution_categories2sites` (
818  `category_id` int(11) NOT NULL COMMENT 'ID сезона',
819  `site_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID площадки',
820  PRIMARY KEY (`category_id`,`site_id`),
821  KEY `category_id_idx` (`category_id`),
822  KEY `site_id_idx` (`site_id`)
823) ENGINE=InnoDB DEFAULT CHARSET=utf8;
824
825-- --------------------------------------------------------
826
827--
828-- Table structure for table `distribution_log`
829--
830
831CREATE TABLE IF NOT EXISTS `distribution_log` (
832  `id` int(11) NOT NULL AUTO_INCREMENT,
833  `site_id` int(11) NOT NULL COMMENT 'ID площадки для которой добавляли видео',
834  `video_id` int(11) NOT NULL COMMENT 'ID видео, которое дистрибьютировали',
835  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'дата создания',
836  `external_video_id` varchar(255) NOT NULL COMMENT 'ID видео в удаленной системе',
837  `external_post_id` bigint(11) DEFAULT NULL COMMENT 'ID поста в удаленной системе',
838  PRIMARY KEY (`id`),
839  KEY `site_id` (`site_id`),
840  KEY `video_id` (`video_id`)
841) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='таблица лога пушинга партнерами видео в социальные сети' AUTO_INCREMENT=33187 ;
842
843-- --------------------------------------------------------
844
845--
846-- Table structure for table `distribution_seasons`
847--
848
849CREATE TABLE IF NOT EXISTS `distribution_seasons` (
850  `season_id` int(11) NOT NULL,
851  `start_date` datetime DEFAULT NULL COMMENT 'Время начала вещания',
852  `end_date` datetime DEFAULT NULL COMMENT 'Время окончания вещания',
853  PRIMARY KEY (`season_id`),
854  KEY `season_id_idx` (`season_id`)
855) ENGINE=InnoDB DEFAULT CHARSET=utf8;
856
857-- --------------------------------------------------------
858
859--
860-- Table structure for table `distribution_seasons2countries`
861--
862
863CREATE TABLE IF NOT EXISTS `distribution_seasons2countries` (
864  `season_id` int(11) NOT NULL COMMENT 'ID сезона',
865  `country_code` varchar(2) NOT NULL COMMENT 'Символьный код страны',
866  PRIMARY KEY (`season_id`,`country_code`),
867  KEY `season_id_idx` (`season_id`)
868) ENGINE=InnoDB DEFAULT CHARSET=utf8;
869
870-- --------------------------------------------------------
871
872--
873-- Table structure for table `distribution_seasons2sites`
874--
875
876CREATE TABLE IF NOT EXISTS `distribution_seasons2sites` (
877  `season_id` int(11) NOT NULL COMMENT 'ID сезона',
878  `site_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID площадки',
879  PRIMARY KEY (`season_id`,`site_id`),
880  KEY `season_id_idx` (`season_id`),
881  KEY `site_id_idx` (`site_id`)
882) ENGINE=InnoDB DEFAULT CHARSET=utf8;
883
884-- --------------------------------------------------------
885
886--
887-- Table structure for table `distribution_videos`
888--
889
890CREATE TABLE IF NOT EXISTS `distribution_videos` (
891  `video_id` int(11) NOT NULL,
892  `start_date` datetime DEFAULT NULL COMMENT 'Время начала вещания',
893  `end_date` datetime DEFAULT NULL COMMENT 'Время окончания вещания',
894  PRIMARY KEY (`video_id`),
895  KEY `video_id_idx` (`video_id`)
896) ENGINE=InnoDB DEFAULT CHARSET=utf8;
897
898-- --------------------------------------------------------
899
900--
901-- Table structure for table `distribution_videos2countries`
902--
903
904CREATE TABLE IF NOT EXISTS `distribution_videos2countries` (
905  `video_id` int(11) NOT NULL COMMENT 'ID сезона',
906  `country_code` varchar(2) NOT NULL COMMENT 'Символьный код страны',
907  PRIMARY KEY (`video_id`,`country_code`),
908  KEY `video_id_idx` (`video_id`)
909) ENGINE=InnoDB DEFAULT CHARSET=utf8;
910
911-- --------------------------------------------------------
912
913--
914-- Table structure for table `distribution_videos2sites`
915--
916
917CREATE TABLE IF NOT EXISTS `distribution_videos2sites` (
918  `video_id` int(11) NOT NULL COMMENT 'ID сезона',
919  `site_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID площадки',
920  PRIMARY KEY (`video_id`,`site_id`),
921  KEY `video_id_idx` (`video_id`),
922  KEY `site_id_idx` (`site_id`)
923) ENGINE=InnoDB DEFAULT CHARSET=utf8;
924
925-- --------------------------------------------------------
926
927--
928-- Table structure for table `email_template`
929--
930
931CREATE TABLE IF NOT EXISTS `email_template` (
932  `id` int(11) NOT NULL AUTO_INCREMENT,
933  `key_name` varchar(30) NOT NULL,
934  `description` varchar(255) NOT NULL,
935  `variables` varchar(255) NOT NULL,
936  `subject` varchar(255) NOT NULL,
937  `body` text NOT NULL,
938  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
939  PRIMARY KEY (`id`),
940  KEY `name` (`key_name`),
941  KEY `description` (`description`)
942) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
943
944-- --------------------------------------------------------
945
946--
947-- Table structure for table `external_videos`
948--
949
950CREATE TABLE IF NOT EXISTS `external_videos` (
951  `id` int(11) NOT NULL AUTO_INCREMENT,
952  `rutube_id` varchar(255) NOT NULL COMMENT 'ID видео в системе rutube',
953  `rutube_user_id` int(11) DEFAULT NULL COMMENT 'ID пользователя в системе rutube',
954  `title` text NOT NULL COMMENT 'Наименование',
955  `last_update_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'дата обновления',
956  `hits` int(11) NOT NULL,
957  `created_ts` timestamp NULL DEFAULT NULL COMMENT 'дата создания ролика',
958  `image` text NOT NULL,
959  `embed` text NOT NULL,
960  `is_use` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'маркер использования',
961  PRIMARY KEY (`id`),
962  UNIQUE KEY `rutube_id` (`rutube_id`)
963) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='видео рутюба' AUTO_INCREMENT=253528 ;
964
965-- --------------------------------------------------------
966
967--
968-- Table structure for table `fourpay_history`
969--
970
971CREATE TABLE IF NOT EXISTS `fourpay_history` (
972  `id` int(11) NOT NULL AUTO_INCREMENT,
973  `log_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата события',
974  `transaction_id` int(11) NOT NULL COMMENT 'ID транзакции',
975  `operation` varchar(32) NOT NULL COMMENT 'операция',
976  `request` text NOT NULL COMMENT 'запрос',
977  `response` text NOT NULL COMMENT 'ответ',
978  PRIMARY KEY (`id`),
979  KEY `transaction_id` (`transaction_id`)
980) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='История обращений к 4pay' AUTO_INCREMENT=2941 ;
981
982-- --------------------------------------------------------
983
984--
985-- Table structure for table `income_money_cache`
986--
987
988CREATE TABLE IF NOT EXISTS `income_money_cache` (
989  `id` bigint(20) NOT NULL AUTO_INCREMENT,
990  `type` enum('distributor','rightholder','other') DEFAULT NULL COMMENT 'Тип начисления ',
991  `itv_partners_id` int(11) NOT NULL COMMENT 'ID пользователя, для которого зарегистрирована запись',
992  `itv_partners_sites_id` int(11) DEFAULT NULL COMMENT 'ID площадки',
993  `ad_company_id` int(11) DEFAULT NULL COMMENT 'ID рекламы',
994  `sum` double NOT NULL DEFAULT '0' COMMENT 'Сумма начисления',
995  `ad_shows` int(11) DEFAULT NULL COMMENT 'Кол-во показов рекламы, за которые произошло начисление',
996  `income_date` date NOT NULL COMMENT 'Дата начисления',
997  `comment` text NOT NULL COMMENT 'коментарий',
998  PRIMARY KEY (`id`),
999  KEY `itv_partners_id_day_idx` (`itv_partners_id`,`income_date`),
1000  KEY `user_id_idx` (`itv_partners_id`),
1001  KEY `site_id_idx` (`itv_partners_sites_id`),
1002  KEY `ad_company_idx` (`ad_company_id`),
1003  KEY `type_idx` (`type`),
1004  KEY `income_date` (`income_date`)
1005) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Входящие транзакции' AUTO_INCREMENT=202267641 ;
1006
1007-- --------------------------------------------------------
1008
1009--
1010-- Table structure for table `ip2country`
1011--
1012
1013CREATE TABLE IF NOT EXISTS `ip2country` (
1014  `start` bigint(10) DEFAULT NULL,
1015  `end` bigint(10) DEFAULT NULL,
1016  `code` varchar(2) DEFAULT NULL,
1017  UNIQUE KEY `end` (`end`,`code`)
1018) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1019
1020-- --------------------------------------------------------
1021
1022--
1023-- Table structure for table `itv_partners`
1024--
1025
1026CREATE TABLE IF NOT EXISTS `itv_partners` (
1027  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1028  `is_admin` tinyint(1) NOT NULL DEFAULT '0',
1029  `is_partner` tinyint(1) NOT NULL DEFAULT '0',
1030  `is_advert` tinyint(1) NOT NULL DEFAULT '0',
1031  `is_owner` tinyint(1) NOT NULL DEFAULT '0',
1032  `is_trust` tinyint(1) NOT NULL DEFAULT '0',
1033  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Состояние пользователя (бывш. is_active)',
1034  `update_state_date` timestamp NULL DEFAULT NULL,
1035  `login` varchar(250) NOT NULL,
1036  `is_confirm` tinyint(1) NOT NULL DEFAULT '0',
1037  `password` varchar(250) NOT NULL,
1038  `email` varchar(250) DEFAULT NULL,
1039  `title` varchar(32) NOT NULL COMMENT 'Тайтл пользователя',
1040  `phone` varchar(250) DEFAULT NULL,
1041  `name` varchar(255) NOT NULL,
1042  `surname` varchar(255) NOT NULL,
1043  `last_login` timestamp NULL DEFAULT NULL,
1044  `last_login_system` enum('partner','owner','advert','admin','billing') DEFAULT NULL,
1045  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1046  `partner_type` int(1) NOT NULL DEFAULT '0',
1047  `is_v_auto_moder` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Автоматическая модерация видео при публикации',
1048  `title_type` enum('company','distributor','rightholder','licensee','partner') DEFAULT NULL,
1049  `is_billing` tinyint(4) NOT NULL DEFAULT '0',
1050  `is_resident` tinyint(4) NOT NULL DEFAULT '1',
1051  `referer_user_id` int(11) DEFAULT NULL COMMENT 'ID реферера',
1052  `payment_account_id` int(11) DEFAULT NULL COMMENT 'id платежного аккаунта',
1053  PRIMARY KEY (`id`),
1054  UNIQUE KEY `login` (`login`),
1055  KEY `login_2` (`login`,`password`),
1056  KEY `email` (`email`),
1057  KEY `referer_idx` (`referer_user_id`),
1058  KEY `payment_account_id` (`payment_account_id`)
1059) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7547 ;
1060
1061-- --------------------------------------------------------
1062
1063--
1064-- Table structure for table `itv_partners_observed_players`
1065--
1066
1067CREATE TABLE IF NOT EXISTS `itv_partners_observed_players` (
1068  `user_id` int(11) NOT NULL COMMENT 'ID пользователя',
1069  `player_id` int(11) NOT NULL COMMENT 'ID плеера',
1070  PRIMARY KEY (`user_id`,`player_id`)
1071) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Таблица наблюдаемых плееров пользователем';
1072
1073-- --------------------------------------------------------
1074
1075--
1076-- Table structure for table `itv_partners_palyers_sizes`
1077--
1078
1079CREATE TABLE IF NOT EXISTS `itv_partners_palyers_sizes` (
1080  `id` int(11) NOT NULL AUTO_INCREMENT,
1081  `user_id` int(11) NOT NULL,
1082  `width` int(11) NOT NULL DEFAULT '0',
1083  `height` int(11) NOT NULL DEFAULT '0',
1084  PRIMARY KEY (`id`),
1085  KEY `user_id` (`user_id`)
1086) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=711 ;
1087
1088-- --------------------------------------------------------
1089
1090--
1091-- Table structure for table `itv_partners_players`
1092--
1093
1094CREATE TABLE IF NOT EXISTS `itv_partners_players` (
1095  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1096  `state` int(11) NOT NULL DEFAULT '1',
1097  `site_id` int(10) unsigned NOT NULL,
1098  `playlist_id` int(11) DEFAULT NULL,
1099  `skin_id` int(11) DEFAULT NULL,
1100  `title` varchar(250) NOT NULL,
1101  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1102  `is_autoplay` tinyint(1) NOT NULL DEFAULT '0',
1103  `is_check_domain` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'проверка домена',
1104  `autoplay_per_uniq` int(11) NOT NULL DEFAULT '0',
1105  `redirect` tinyint(1) NOT NULL DEFAULT '0',
1106  `type` enum('original','content-roll','vk','vkppd') NOT NULL DEFAULT 'original' COMMENT 'тип плеера',
1107  `icons` text NOT NULL,
1108  `logo` text NOT NULL,
1109  `is_endscreen` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Финальный экран плеера',
1110  PRIMARY KEY (`id`),
1111  KEY `site_id` (`site_id`),
1112  KEY `type` (`type`),
1113  KEY `state` (`state`)
1114) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=104139 ;
1115
1116-- --------------------------------------------------------
1117
1118--
1119-- Table structure for table `itv_partners_players_settings`
1120--
1121
1122CREATE TABLE IF NOT EXISTS `itv_partners_players_settings` (
1123  `player_id` int(11) NOT NULL COMMENT 'ID плеера',
1124  `key` varchar(255) NOT NULL COMMENT 'ключ',
1125  `value` text NOT NULL COMMENT 'значение',
1126  PRIMARY KEY (`player_id`,`key`)
1127) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='настройки плееров';
1128
1129-- --------------------------------------------------------
1130
1131--
1132-- Table structure for table `itv_partners_presets`
1133--
1134
1135CREATE TABLE IF NOT EXISTS `itv_partners_presets` (
1136  `id` int(11) NOT NULL AUTO_INCREMENT,
1137  `owner_id` int(11) unsigned DEFAULT NULL COMMENT 'ID пользователя',
1138  `title` varchar(255) NOT NULL COMMENT 'Описание пресета',
1139  `json` text NOT NULL COMMENT 'Сериализованные настройки пресета в JSON-формате',
1140  `type` varchar(16) NOT NULL COMMENT 'Тип объекта',
1141  `sort` int(11) DEFAULT NULL COMMENT 'Пользовательская сортировка',
1142  PRIMARY KEY (`id`),
1143  KEY `owner_type_idx` (`owner_id`,`type`)
1144) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=872 ;
1145
1146-- --------------------------------------------------------
1147
1148--
1149-- Table structure for table `itv_partners_settings`
1150--
1151
1152CREATE TABLE IF NOT EXISTS `itv_partners_settings` (
1153  `user_id` int(11) NOT NULL DEFAULT '0',
1154  `key` varchar(255) NOT NULL DEFAULT '',
1155  `value` text NOT NULL,
1156  PRIMARY KEY (`user_id`,`key`)
1157) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='настройки пользователя';
1158
1159-- --------------------------------------------------------
1160
1161--
1162-- Table structure for table `itv_partners_sites`
1163--
1164
1165CREATE TABLE IF NOT EXISTS `itv_partners_sites` (
1166  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1167  `external_id` varchar(255) DEFAULT NULL COMMENT 'ID внешнего источника',
1168  `partner_id` int(10) unsigned NOT NULL,
1169  `sites_categories_id` int(11) DEFAULT NULL,
1170  `type` enum('original','vk','vkppd') NOT NULL DEFAULT 'original' COMMENT 'тип площадки (просто сайт, группа ВК)',
1171  `url` varchar(250) NOT NULL,
1172  `titlename` varchar(255) NOT NULL DEFAULT '' COMMENT 'Наименование площадки',
1173  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1174  `site_state` int(10) unsigned NOT NULL DEFAULT '0',
1175  `update_state_date` timestamp NULL DEFAULT NULL,
1176  `is_autoplay` tinyint(1) NOT NULL DEFAULT '0',
1177  `rb_section_id` int(11) DEFAULT '42' COMMENT 'ID секции РБ pladform',
1178  `groupacl_id` int(11) NOT NULL DEFAULT '4' COMMENT 'ID группы прав для видео',
1179  PRIMARY KEY (`id`),
1180  KEY `partner_id` (`partner_id`),
1181  KEY `site_state` (`site_state`)
1182) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7122 ;
1183
1184-- --------------------------------------------------------
1185
1186--
1187-- Table structure for table `itv_partners_sites_settings`
1188--
1189
1190CREATE TABLE IF NOT EXISTS `itv_partners_sites_settings` (
1191  `id` int(11) NOT NULL AUTO_INCREMENT,
1192  `site_id` int(11) DEFAULT NULL COMMENT 'ID площадки',
1193  `key` varchar(255) NOT NULL DEFAULT '' COMMENT 'ключ',
1194  `value` text NOT NULL COMMENT 'значение',
1195  PRIMARY KEY (`id`),
1196  UNIQUE KEY `uniq_idx` (`site_id`,`key`),
1197  KEY `site_id_idx` (`site_id`)
1198) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='настройки площадки' AUTO_INCREMENT=1785 ;
1199
1200-- --------------------------------------------------------
1201
1202--
1203-- Table structure for table `log`
1204--
1205
1206CREATE TABLE IF NOT EXISTS `log` (
1207  `id` int(11) NOT NULL AUTO_INCREMENT,
1208  `player_id` int(11) DEFAULT NULL,
1209  `user_id` int(11) DEFAULT NULL,
1210  `level` int(11) DEFAULT NULL,
1211  `code` int(11) DEFAULT NULL,
1212  `comment` text NOT NULL,
1213  `log_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1214  `system_data` text NOT NULL,
1215  PRIMARY KEY (`id`),
1216  KEY `code` (`code`),
1217  KEY `level` (`level`),
1218  KEY `player_id_idx` (`player_id`),
1219  KEY `user_id_idx` (`user_id`),
1220  KEY `user_id2level_idx` (`user_id`,`level`),
1221  KEY `player_id2level_idx` (`player_id`,`level`)
1222) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Лог системных сообщений' AUTO_INCREMENT=42691444 ;
1223
1224-- --------------------------------------------------------
1225
1226--
1227-- Table structure for table `mixmarket_reports`
1228--
1229
1230CREATE TABLE IF NOT EXISTS `mixmarket_reports` (
1231  `id` int(11) NOT NULL AUTO_INCREMENT,
1232  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата создания',
1233  `close_month` date NOT NULL COMMENT 'месяц закрытия',
1234  `ammount` decimal(10,2) NOT NULL COMMENT 'финальная сумма',
1235  `output_xml` longtext NOT NULL COMMENT 'XML для миксмаркет',
1236  PRIMARY KEY (`id`),
1237  UNIQUE KEY `close_month_idx` (`close_month`)
1238) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='отчеты в миксмаркет' AUTO_INCREMENT=48 ;
1239
1240-- --------------------------------------------------------
1241
1242--
1243-- Table structure for table `mixmarket_reports_transactions`
1244--
1245
1246CREATE TABLE IF NOT EXISTS `mixmarket_reports_transactions` (
1247  `id` int(11) NOT NULL AUTO_INCREMENT,
1248  `mixmarket_report_id` int(11) NOT NULL COMMENT 'ID миксмаркет отчета',
1249  `outcome_money_id` int(11) NOT NULL COMMENT 'ID транзакции',
1250  `ad_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'Кол-во показов рекламы',
1251  PRIMARY KEY (`id`),
1252  KEY `mixmarket_report_id` (`mixmarket_report_id`)
1253) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='транзакции миксмаркет отчета' AUTO_INCREMENT=4455 ;
1254
1255-- --------------------------------------------------------
1256
1257--
1258-- Table structure for table `outcome_money`
1259--
1260
1261CREATE TABLE IF NOT EXISTS `outcome_money` (
1262  `id` int(11) NOT NULL AUTO_INCREMENT,
1263  `itv_partners_id` int(11) NOT NULL,
1264  `sum` double NOT NULL DEFAULT '0',
1265  `state` int(11) NOT NULL DEFAULT '0',
1266  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1267  `close_date` timestamp NULL DEFAULT NULL,
1268  `comment` varchar(255) NOT NULL,
1269  `mixmarket_key` varchar(32) DEFAULT NULL,
1270  `wallet` varchar(255) NOT NULL,
1271  `payment_account_id` int(11) DEFAULT NULL COMMENT 'ID платежного аккаунта',
1272  PRIMARY KEY (`id`),
1273  KEY `itv_partners_id` (`itv_partners_id`,`state`),
1274  KEY `itv_partners_id_2` (`itv_partners_id`)
1275) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Исходящие транзакции' AUTO_INCREMENT=8028 ;
1276
1277-- --------------------------------------------------------
1278
1279--
1280-- Table structure for table `outpladformru_log`
1281--
1282
1283CREATE TABLE IF NOT EXISTS `outpladformru_log` (
1284  `id` int(11) NOT NULL AUTO_INCREMENT,
1285  `log_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата события',
1286  `method` varchar(32) NOT NULL COMMENT 'используемый метод',
1287  `request` text NOT NULL COMMENT 'запрос',
1288  `response` text NOT NULL COMMENT 'ответ',
1289  PRIMARY KEY (`id`)
1290) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Лог отправки запросов на out.pladform.ru' AUTO_INCREMENT=134804 ;
1291
1292-- --------------------------------------------------------
1293
1294--
1295-- Table structure for table `parsers_log`
1296--
1297
1298CREATE TABLE IF NOT EXISTS `parsers_log` (
1299  `id` int(11) NOT NULL AUTO_INCREMENT,
1300  `mode` varchar(12) NOT NULL,
1301  `user_id` int(11) NOT NULL COMMENT 'правообладатель',
1302  `start_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'начало парсинга',
1303  `end_date` timestamp NULL DEFAULT NULL COMMENT 'конец парсинга',
1304  `insert_categories` int(11) NOT NULL DEFAULT '0' COMMENT 'новых категорий',
1305  `update_categories` int(11) NOT NULL DEFAULT '0' COMMENT 'обновлено категорий',
1306  `insert_video` int(11) NOT NULL DEFAULT '0' COMMENT 'новых видео',
1307  `update_video` int(11) NOT NULL DEFAULT '0' COMMENT 'обновлено видео',
1308  `errors_cnt` int(11) NOT NULL DEFAULT '0' COMMENT 'кол-во ошибок',
1309  PRIMARY KEY (`id`)
1310) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='лог парсинга' AUTO_INCREMENT=1425 ;
1311
1312-- --------------------------------------------------------
1313
1314--
1315-- Table structure for table `partner_prices`
1316--
1317
1318CREATE TABLE IF NOT EXISTS `partner_prices` (
1319  `id` int(11) NOT NULL AUTO_INCREMENT,
1320  `user_id` int(11) DEFAULT NULL,
1321  `site_id` int(11) DEFAULT NULL,
1322  `ad_company_id` int(11) DEFAULT NULL,
1323  `cost` decimal(12,4) NOT NULL DEFAULT '0.0000',
1324  `comment` varchar(255) NOT NULL,
1325  PRIMARY KEY (`id`),
1326  UNIQUE KEY `user_id_site_id_ad_company_id_idx` (`user_id`,`site_id`,`ad_company_id`)
1327) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Партнерские цены на рекламу' AUTO_INCREMENT=2586 ;
1328
1329-- --------------------------------------------------------
1330
1331--
1332-- Table structure for table `payment_account`
1333--
1334
1335CREATE TABLE IF NOT EXISTS `payment_account` (
1336  `id` int(11) NOT NULL AUTO_INCREMENT,
1337  `state_remove` int(11) NOT NULL DEFAULT '1' COMMENT 'статус',
1338  `user_id` int(11) NOT NULL COMMENT 'ID пользователя',
1339  `payment_system_id` int(11) NOT NULL COMMENT 'ID платежной системы',
1340  `legal_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Физик-юрик',
1341  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата создания',
1342  `wallet_type` enum('wmr','bank','phone') DEFAULT NULL COMMENT 'типы кошельков (wmr, банковский счет)',
1343  `wallet` varchar(32) DEFAULT NULL COMMENT 'кошелек',
1344  `org_title` varchar(255) DEFAULT NULL COMMENT 'Наименование организации',
1345  `legal_address` varchar(755) DEFAULT NULL COMMENT 'Юридический адрес',
1346  `actual_address` varchar(755) DEFAULT NULL COMMENT 'Физический адрес',
1347  `inn` int(10) DEFAULT NULL COMMENT 'инн',
1348  `kpp` int(9) DEFAULT NULL COMMENT 'кпп',
1349  `ogrn` bigint(13) DEFAULT NULL COMMENT 'огрн',
1350  `bik` int(9) DEFAULT NULL COMMENT 'БИК',
1351  PRIMARY KEY (`id`)
1352) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Платежные аккаунты пользователей' AUTO_INCREMENT=10086 ;
1353
1354-- --------------------------------------------------------
1355
1356--
1357-- Table structure for table `payment_system`
1358--
1359
1360CREATE TABLE IF NOT EXISTS `payment_system` (
1361  `id` int(11) NOT NULL AUTO_INCREMENT,
1362  `title` varchar(255) NOT NULL COMMENT 'Наименование системы вывода',
1363  PRIMARY KEY (`id`)
1364) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Платежные системы' AUTO_INCREMENT=4 ;
1365
1366-- --------------------------------------------------------
1367
1368--
1369-- Table structure for table `persons`
1370--
1371
1372CREATE TABLE IF NOT EXISTS `persons` (
1373  `id` int(11) NOT NULL AUTO_INCREMENT,
1374  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
1375  `surname` varchar(255) CHARACTER SET utf8 NOT NULL,
1376  `imdb_id` varchar(255) CHARACTER SET utf8 NOT NULL,
1377  `kinopoisk_id` varchar(255) CHARACTER SET utf8 NOT NULL,
1378  PRIMARY KEY (`id`),
1379  KEY `name` (`name`,`surname`,`imdb_id`,`kinopoisk_id`)
1380) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;
1381
1382-- --------------------------------------------------------
1383
1384--
1385-- Table structure for table `planning_views`
1386--
1387
1388CREATE TABLE IF NOT EXISTS `planning_views` (
1389  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
1390  `site_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID площадки, 0 - вся система',
1391  `ad_start` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Кол-во показов рекламы',
1392  `video_start` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Кол-во показов видео ',
1393  `code_start` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Кол-во показов кода',
1394  `year` year(4) NOT NULL COMMENT 'Год планирования',
1395  `month` int(2) NOT NULL COMMENT 'Месяц планирования',
1396  `date_created` datetime DEFAULT NULL COMMENT 'Дата создания плана',
1397  `date_updated` datetime DEFAULT NULL COMMENT 'Дата обновления плана',
1398  `user_id` int(11) DEFAULT NULL COMMENT 'Пользователь',
1399  PRIMARY KEY (`id`),
1400  UNIQUE KEY `site_id` (`site_id`,`year`,`month`),
1401  KEY `year_idx` (`year`)
1402) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=62 ;
1403
1404-- --------------------------------------------------------
1405
1406--
1407-- Table structure for table `player_skins`
1408--
1409
1410CREATE TABLE IF NOT EXISTS `player_skins` (
1411  `id` int(11) NOT NULL AUTO_INCREMENT,
1412  `name` varchar(255) NOT NULL,
1413  PRIMARY KEY (`id`)
1414) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Скины плеера' AUTO_INCREMENT=40 ;
1415
1416-- --------------------------------------------------------
1417
1418--
1419-- Table structure for table `playlists`
1420--
1421
1422CREATE TABLE IF NOT EXISTS `playlists` (
1423  `id` int(11) NOT NULL AUTO_INCREMENT,
1424  `itv_partners_id` int(11) NOT NULL,
1425  `type` enum('original','vk') NOT NULL DEFAULT 'original' COMMENT 'тип плейлиста',
1426  `state` int(11) NOT NULL DEFAULT '1' COMMENT 'Статус плейлиста',
1427  `title` varchar(255) NOT NULL,
1428  `is_random` tinyint(1) NOT NULL DEFAULT '0',
1429  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1430  PRIMARY KEY (`id`),
1431  KEY `itv_partners_id` (`itv_partners_id`),
1432  KEY `state_idx` (`state`)
1433) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Плейлисты пользователя' AUTO_INCREMENT=96043 ;
1434
1435-- --------------------------------------------------------
1436
1437--
1438-- Table structure for table `playlists_items`
1439--
1440
1441CREATE TABLE IF NOT EXISTS `playlists_items` (
1442  `id` int(11) NOT NULL AUTO_INCREMENT,
1443  `playlist_id` int(11) NOT NULL,
1444  `item_id` int(11) DEFAULT NULL,
1445  `type` enum('video','category') DEFAULT NULL,
1446  PRIMARY KEY (`id`),
1447  KEY `playlist_id` (`playlist_id`)
1448) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Итемы плейлиста' AUTO_INCREMENT=599400 ;
1449
1450-- --------------------------------------------------------
1451
1452--
1453-- Table structure for table `price_video`
1454--
1455
1456CREATE TABLE IF NOT EXISTS `price_video` (
1457  `id` int(11) NOT NULL AUTO_INCREMENT,
1458  `video_id` bigint(20) NOT NULL COMMENT 'ID видео',
1459  `price` decimal(12,4) NOT NULL COMMENT 'Доп. цена для видео',
1460  PRIMARY KEY (`id`),
1461  UNIQUE KEY `video_id_idx` (`video_id`)
1462) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Таблица цен для видео - биржа' AUTO_INCREMENT=1 ;
1463
1464-- --------------------------------------------------------
1465
1466--
1467-- Table structure for table `purposes`
1468--
1469
1470CREATE TABLE IF NOT EXISTS `purposes` (
1471  `id` int(11) NOT NULL AUTO_INCREMENT,
1472  `date` date NOT NULL,
1473  `itv_partners_id` int(11) NOT NULL,
1474  `itv_partners_sites_id` int(11) NOT NULL,
1475  `videolib_categories_id` int(11) NOT NULL,
1476  `purpose_type` enum('adv','content') NOT NULL DEFAULT 'adv',
1477  `shows_expect` int(11) NOT NULL DEFAULT '0',
1478  `shows_real` int(11) NOT NULL DEFAULT '0',
1479  `is_remove` enum('0','1') NOT NULL DEFAULT '0',
1480  `daemon_status` enum('free','use','new') NOT NULL DEFAULT 'new',
1481  `daemon_last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1482  `shows_real_json` text,
1483  PRIMARY KEY (`id`)
1484) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=78 ;
1485
1486-- --------------------------------------------------------
1487
1488--
1489-- Table structure for table `rb_stat`
1490--
1491
1492CREATE TABLE IF NOT EXISTS `rb_stat` (
1493  `id` int(11) NOT NULL AUTO_INCREMENT,
1494  `puid2` smallint(6) NOT NULL COMMENT 'PUID2',
1495  `date` date NOT NULL COMMENT 'Дата',
1496  `load` int(11) NOT NULL COMMENT 'Кол-во загрузок',
1497  `show` int(11) NOT NULL COMMENT 'Кол-во показов',
1498  `click` int(11) NOT NULL COMMENT 'Кол-во кликов',
1499  PRIMARY KEY (`id`),
1500  UNIQUE KEY `puid2` (`puid2`,`date`)
1501) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COMMENT='Статистика из РБ' AUTO_INCREMENT=5942 ;
1502
1503-- --------------------------------------------------------
1504
1505--
1506-- Table structure for table `rutube_vk`
1507--
1508
1509CREATE TABLE IF NOT EXISTS `rutube_vk` (
1510  `rutube_id` varchar(255) NOT NULL COMMENT 'ID видео rutube',
1511  `cnt` bigint(20) NOT NULL DEFAULT '0' COMMENT 'кол-во ',
1512  `state` int(11) NOT NULL COMMENT 'статус',
1513  `title` text NOT NULL COMMENT 'Наименование',
1514  `description` text NOT NULL,
1515  `author_name` varchar(255) NOT NULL,
1516  `author_id` int(11) NOT NULL,
1517  `category_title` varchar(255) NOT NULL,
1518  `category_id` int(11) NOT NULL,
1519  `download_file_name` varchar(255) NOT NULL COMMENT 'имя скаченного файла',
1520  `vk_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'ID вконтакте'
1521) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='парсинг рутюба во ВК';
1522
1523-- --------------------------------------------------------
1524
1525--
1526-- Table structure for table `sequence_category`
1527--
1528
1529CREATE TABLE IF NOT EXISTS `sequence_category` (
1530  `id` int(11) NOT NULL AUTO_INCREMENT,
1531  PRIMARY KEY (`id`)
1532) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1021542 ;
1533
1534-- --------------------------------------------------------
1535
1536--
1537-- Table structure for table `sequence_video`
1538--
1539
1540CREATE TABLE IF NOT EXISTS `sequence_video` (
1541  `id` int(11) NOT NULL AUTO_INCREMENT,
1542  PRIMARY KEY (`id`)
1543) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=946880 ;
1544
1545-- --------------------------------------------------------
1546
1547--
1548-- Table structure for table `settings`
1549--
1550
1551CREATE TABLE IF NOT EXISTS `settings` (
1552  `key` varchar(255) NOT NULL,
1553  `value` text NOT NULL,
1554  UNIQUE KEY `key` (`key`)
1555) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1556
1557-- --------------------------------------------------------
1558
1559--
1560-- Table structure for table `showcase_subscribe`
1561--
1562
1563CREATE TABLE IF NOT EXISTS `showcase_subscribe` (
1564  `id` int(11) NOT NULL AUTO_INCREMENT,
1565  `itv_partners_players_id` int(11) DEFAULT NULL,
1566  `email` varchar(255) NOT NULL,
1567  `added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1568  PRIMARY KEY (`id`)
1569) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Подписка из витрины' AUTO_INCREMENT=1333 ;
1570
1571-- --------------------------------------------------------
1572
1573--
1574-- Table structure for table `sites_categories`
1575--
1576
1577CREATE TABLE IF NOT EXISTS `sites_categories` (
1578  `id` int(11) NOT NULL AUTO_INCREMENT,
1579  `title` varchar(255) NOT NULL,
1580  PRIMARY KEY (`id`)
1581) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='варианты категорий для сайта' AUTO_INCREMENT=49 ;
1582
1583-- --------------------------------------------------------
1584
1585--
1586-- Table structure for table `site_aclgroups`
1587--
1588
1589CREATE TABLE IF NOT EXISTS `site_aclgroups` (
1590  `id` int(11) NOT NULL AUTO_INCREMENT,
1591  `title` varchar(255) NOT NULL COMMENT 'Наименование группы',
1592  PRIMARY KEY (`id`)
1593) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Группы площадок для видеоправ' AUTO_INCREMENT=6 ;
1594
1595-- --------------------------------------------------------
1596
1597--
1598-- Table structure for table `statistics_cache_heavy`
1599--
1600
1601CREATE TABLE IF NOT EXISTS `statistics_cache_heavy` (
1602  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1603  `player_id` int(11) DEFAULT NULL COMMENT 'ID плеера',
1604  `log_date` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Дата события',
1605  `video_id` int(11) DEFAULT NULL COMMENT 'ID видео',
1606  `country_code` varchar(2) NOT NULL DEFAULT '' COMMENT 'Двухзначный код страны',
1607  `ad_company_id` int(11) DEFAULT NULL COMMENT 'ID рекламы',
1608  `video_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'сумма показов видео',
1609  `preroll_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'сумма показов преролов',
1610  `pause_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'сумма показов паузролов и паузбаннеров',
1611  `overlay_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'сумма показов оверлеев',
1612  `postroll_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'сумма показов постролов',
1613  `midroll_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'сумма показов мидролов',
1614  `click` int(11) NOT NULL DEFAULT '0' COMMENT 'сумма кликов по рекламе',
1615  `profit` double NOT NULL DEFAULT '0' COMMENT 'заработок дистрибутора',
1616  PRIMARY KEY (`id`,`log_date`),
1617  UNIQUE KEY `player_id_2` (`player_id`,`log_date`,`video_id`,`country_code`,`ad_company_id`),
1618  KEY `player_id` (`player_id`),
1619  KEY `log_date` (`log_date`),
1620  KEY `video_id` (`video_id`),
1621  KEY `country_code` (`country_code`),
1622  KEY `ad_company_id` (`ad_company_id`)
1623) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='самая детальная статистика'
1624/*!50100 PARTITION BY RANGE ( TO_DAYS(log_date))
1625(PARTITION y2013m1 VALUES LESS THAN (735265) ENGINE = InnoDB,
1626 PARTITION y2013m2 VALUES LESS THAN (735293) ENGINE = InnoDB,
1627 PARTITION y2013m3 VALUES LESS THAN (735324) ENGINE = InnoDB,
1628 PARTITION y2013m4 VALUES LESS THAN (735354) ENGINE = InnoDB,
1629 PARTITION y2013m5 VALUES LESS THAN (735385) ENGINE = InnoDB,
1630 PARTITION y2013m6 VALUES LESS THAN (735415) ENGINE = InnoDB,
1631 PARTITION y2013m7 VALUES LESS THAN (735446) ENGINE = InnoDB,
1632 PARTITION y2013m8 VALUES LESS THAN (735477) ENGINE = InnoDB,
1633 PARTITION y2013m9 VALUES LESS THAN (735507) ENGINE = InnoDB,
1634 PARTITION y2013m10 VALUES LESS THAN (735538) ENGINE = InnoDB,
1635 PARTITION y2013m11 VALUES LESS THAN (735568) ENGINE = InnoDB,
1636 PARTITION y2013m12 VALUES LESS THAN (735599) ENGINE = InnoDB,
1637 PARTITION y2014m1 VALUES LESS THAN (735630) ENGINE = InnoDB,
1638 PARTITION y2014m2 VALUES LESS THAN (735658) ENGINE = InnoDB,
1639 PARTITION y2014m3 VALUES LESS THAN (735689) ENGINE = InnoDB,
1640 PARTITION y2014m4 VALUES LESS THAN (735719) ENGINE = InnoDB,
1641 PARTITION y2014m5 VALUES LESS THAN (735750) ENGINE = InnoDB,
1642 PARTITION y2014m6 VALUES LESS THAN (735780) ENGINE = InnoDB,
1643 PARTITION y2014m7 VALUES LESS THAN (735811) ENGINE = InnoDB,
1644 PARTITION y2014m8 VALUES LESS THAN (735842) ENGINE = InnoDB,
1645 PARTITION y2014m9 VALUES LESS THAN (735872) ENGINE = InnoDB,
1646 PARTITION y2014m10 VALUES LESS THAN (735903) ENGINE = InnoDB,
1647 PARTITION y2014m11 VALUES LESS THAN (735933) ENGINE = InnoDB,
1648 PARTITION y2014m12 VALUES LESS THAN (735964) ENGINE = InnoDB,
1649 PARTITION y2015m1 VALUES LESS THAN (735995) ENGINE = InnoDB,
1650 PARTITION y2015m2 VALUES LESS THAN (736023) ENGINE = InnoDB,
1651 PARTITION y2015m3 VALUES LESS THAN (736054) ENGINE = InnoDB,
1652 PARTITION y2015m4 VALUES LESS THAN (736084) ENGINE = InnoDB,
1653 PARTITION y2015m5 VALUES LESS THAN (736115) ENGINE = InnoDB,
1654 PARTITION y2015m6 VALUES LESS THAN (736145) ENGINE = InnoDB,
1655 PARTITION y2015m7 VALUES LESS THAN (736176) ENGINE = InnoDB,
1656 PARTITION y2015m8 VALUES LESS THAN (736207) ENGINE = InnoDB,
1657 PARTITION y2015m9 VALUES LESS THAN (736237) ENGINE = InnoDB,
1658 PARTITION y2015m10 VALUES LESS THAN (736268) ENGINE = InnoDB,
1659 PARTITION y2015m11 VALUES LESS THAN (736298) ENGINE = InnoDB,
1660 PARTITION y2015m12 VALUES LESS THAN (736329) ENGINE = InnoDB,
1661 PARTITION y2016m1 VALUES LESS THAN (736360) ENGINE = InnoDB,
1662 PARTITION y2016m2 VALUES LESS THAN (736389) ENGINE = InnoDB,
1663 PARTITION y2016m3 VALUES LESS THAN (736420) ENGINE = InnoDB,
1664 PARTITION y2016m4 VALUES LESS THAN (736450) ENGINE = InnoDB,
1665 PARTITION y2016m5 VALUES LESS THAN (736481) ENGINE = InnoDB,
1666 PARTITION y2016m6 VALUES LESS THAN (736511) ENGINE = InnoDB,
1667 PARTITION y2016m7 VALUES LESS THAN (736542) ENGINE = InnoDB,
1668 PARTITION y2016m8 VALUES LESS THAN (736573) ENGINE = InnoDB,
1669 PARTITION y2016m9 VALUES LESS THAN (736603) ENGINE = InnoDB,
1670 PARTITION y2016m10 VALUES LESS THAN (736634) ENGINE = InnoDB,
1671 PARTITION y2016m11 VALUES LESS THAN (736664) ENGINE = InnoDB,
1672 PARTITION y2016m12 VALUES LESS THAN (736695) ENGINE = InnoDB,
1673 PARTITION y2017m1 VALUES LESS THAN (736726) ENGINE = InnoDB,
1674 PARTITION y2017m2 VALUES LESS THAN (736754) ENGINE = InnoDB,
1675 PARTITION y2017m3 VALUES LESS THAN (736785) ENGINE = InnoDB,
1676 PARTITION y2017m4 VALUES LESS THAN (736815) ENGINE = InnoDB,
1677 PARTITION y2017m5 VALUES LESS THAN (736846) ENGINE = InnoDB,
1678 PARTITION y2017m6 VALUES LESS THAN (736876) ENGINE = InnoDB,
1679 PARTITION y2017m7 VALUES LESS THAN (736907) ENGINE = InnoDB,
1680 PARTITION y2017m8 VALUES LESS THAN (736938) ENGINE = InnoDB,
1681 PARTITION y2017m9 VALUES LESS THAN (736968) ENGINE = InnoDB,
1682 PARTITION y2017m10 VALUES LESS THAN (736999) ENGINE = InnoDB,
1683 PARTITION y2017m11 VALUES LESS THAN (737029) ENGINE = InnoDB,
1684 PARTITION y2017m12 VALUES LESS THAN (737060) ENGINE = InnoDB,
1685 PARTITION y2018m1 VALUES LESS THAN (737091) ENGINE = InnoDB,
1686 PARTITION y2018m2 VALUES LESS THAN (737119) ENGINE = InnoDB,
1687 PARTITION y2018m3 VALUES LESS THAN (737150) ENGINE = InnoDB,
1688 PARTITION y2018m4 VALUES LESS THAN (737180) ENGINE = InnoDB,
1689 PARTITION y2018m5 VALUES LESS THAN (737211) ENGINE = InnoDB,
1690 PARTITION y2018m6 VALUES LESS THAN (737241) ENGINE = InnoDB,
1691 PARTITION y2018m7 VALUES LESS THAN (737272) ENGINE = InnoDB,
1692 PARTITION y2018m8 VALUES LESS THAN (737303) ENGINE = InnoDB,
1693 PARTITION y2018m9 VALUES LESS THAN (737333) ENGINE = InnoDB,
1694 PARTITION y2018m10 VALUES LESS THAN (737364) ENGINE = InnoDB,
1695 PARTITION y2018m11 VALUES LESS THAN (737394) ENGINE = InnoDB,
1696 PARTITION y2018m12 VALUES LESS THAN (737425) ENGINE = InnoDB,
1697 PARTITION y2019m1 VALUES LESS THAN (737456) ENGINE = InnoDB,
1698 PARTITION y2019m2 VALUES LESS THAN (737484) ENGINE = InnoDB,
1699 PARTITION y2019m3 VALUES LESS THAN (737515) ENGINE = InnoDB,
1700 PARTITION y2019m4 VALUES LESS THAN (737545) ENGINE = InnoDB,
1701 PARTITION y2019m5 VALUES LESS THAN (737576) ENGINE = InnoDB,
1702 PARTITION y2019m6 VALUES LESS THAN (737606) ENGINE = InnoDB,
1703 PARTITION y2019m7 VALUES LESS THAN (737637) ENGINE = InnoDB,
1704 PARTITION y2019m8 VALUES LESS THAN (737668) ENGINE = InnoDB,
1705 PARTITION y2019m9 VALUES LESS THAN (737698) ENGINE = InnoDB,
1706 PARTITION y2019m10 VALUES LESS THAN (737729) ENGINE = InnoDB,
1707 PARTITION y2019m11 VALUES LESS THAN (737759) ENGINE = InnoDB,
1708 PARTITION y2019m12 VALUES LESS THAN (737790) ENGINE = InnoDB) */ AUTO_INCREMENT=1148020705 ;
1709
1710-- --------------------------------------------------------
1711
1712--
1713-- Table structure for table `statistics_cache_light`
1714--
1715
1716CREATE TABLE IF NOT EXISTS `statistics_cache_light` (
1717  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1718  `uniqkey` varchar(255) NOT NULL DEFAULT '',
1719  `player_id` int(11) DEFAULT NULL,
1720  `log_date` date NOT NULL DEFAULT '0000-00-00',
1721  `video_shows` int(11) NOT NULL DEFAULT '0',
1722  `click` int(11) NOT NULL DEFAULT '0',
1723  `preroll_shows` int(11) NOT NULL DEFAULT '0',
1724  `pause_shows` int(11) NOT NULL DEFAULT '0',
1725  `overlay_shows` int(11) NOT NULL DEFAULT '0',
1726  `midroll_shows` int(11) NOT NULL DEFAULT '0',
1727  `postroll_shows` int(11) NOT NULL DEFAULT '0',
1728  `profit` double NOT NULL DEFAULT '0',
1729  PRIMARY KEY (`id`,`log_date`),
1730  UNIQUE KEY `uniqkey` (`player_id`,`log_date`),
1731  KEY `player_id` (`player_id`),
1732  KEY `log_date` (`log_date`)
1733) ENGINE=InnoDB  DEFAULT CHARSET=utf8
1734/*!50100 PARTITION BY RANGE ( TO_DAYS(log_date))
1735(PARTITION y2013m1 VALUES LESS THAN (735265) ENGINE = InnoDB,
1736 PARTITION y2013m2 VALUES LESS THAN (735293) ENGINE = InnoDB,
1737 PARTITION y2013m3 VALUES LESS THAN (735324) ENGINE = InnoDB,
1738 PARTITION y2013m4 VALUES LESS THAN (735354) ENGINE = InnoDB,
1739 PARTITION y2013m5 VALUES LESS THAN (735385) ENGINE = InnoDB,
1740 PARTITION y2013m6 VALUES LESS THAN (735415) ENGINE = InnoDB,
1741 PARTITION y2013m7 VALUES LESS THAN (735446) ENGINE = InnoDB,
1742 PARTITION y2013m8 VALUES LESS THAN (735477) ENGINE = InnoDB,
1743 PARTITION y2013m9 VALUES LESS THAN (735507) ENGINE = InnoDB,
1744 PARTITION y2013m10 VALUES LESS THAN (735538) ENGINE = InnoDB,
1745 PARTITION y2013m11 VALUES LESS THAN (735568) ENGINE = InnoDB,
1746 PARTITION y2013m12 VALUES LESS THAN (735599) ENGINE = InnoDB,
1747 PARTITION y2014m1 VALUES LESS THAN (735630) ENGINE = InnoDB,
1748 PARTITION y2014m2 VALUES LESS THAN (735658) ENGINE = InnoDB,
1749 PARTITION y2014m3 VALUES LESS THAN (735689) ENGINE = InnoDB,
1750 PARTITION y2014m4 VALUES LESS THAN (735719) ENGINE = InnoDB,
1751 PARTITION y2014m5 VALUES LESS THAN (735750) ENGINE = InnoDB,
1752 PARTITION y2014m6 VALUES LESS THAN (735780) ENGINE = InnoDB,
1753 PARTITION y2014m7 VALUES LESS THAN (735811) ENGINE = InnoDB,
1754 PARTITION y2014m8 VALUES LESS THAN (735842) ENGINE = InnoDB,
1755 PARTITION y2014m9 VALUES LESS THAN (735872) ENGINE = InnoDB,
1756 PARTITION y2014m10 VALUES LESS THAN (735903) ENGINE = InnoDB,
1757 PARTITION y2014m11 VALUES LESS THAN (735933) ENGINE = InnoDB,
1758 PARTITION y2014m12 VALUES LESS THAN (735964) ENGINE = InnoDB,
1759 PARTITION y2015m1 VALUES LESS THAN (735995) ENGINE = InnoDB,
1760 PARTITION y2015m2 VALUES LESS THAN (736023) ENGINE = InnoDB,
1761 PARTITION y2015m3 VALUES LESS THAN (736054) ENGINE = InnoDB,
1762 PARTITION y2015m4 VALUES LESS THAN (736084) ENGINE = InnoDB,
1763 PARTITION y2015m5 VALUES LESS THAN (736115) ENGINE = InnoDB,
1764 PARTITION y2015m6 VALUES LESS THAN (736145) ENGINE = InnoDB,
1765 PARTITION y2015m7 VALUES LESS THAN (736176) ENGINE = InnoDB,
1766 PARTITION y2015m8 VALUES LESS THAN (736207) ENGINE = InnoDB,
1767 PARTITION y2015m9 VALUES LESS THAN (736237) ENGINE = InnoDB,
1768 PARTITION y2015m10 VALUES LESS THAN (736268) ENGINE = InnoDB,
1769 PARTITION y2015m11 VALUES LESS THAN (736298) ENGINE = InnoDB,
1770 PARTITION y2015m12 VALUES LESS THAN (736329) ENGINE = InnoDB,
1771 PARTITION y2016m1 VALUES LESS THAN (736360) ENGINE = InnoDB,
1772 PARTITION y2016m2 VALUES LESS THAN (736389) ENGINE = InnoDB,
1773 PARTITION y2016m3 VALUES LESS THAN (736420) ENGINE = InnoDB,
1774 PARTITION y2016m4 VALUES LESS THAN (736450) ENGINE = InnoDB,
1775 PARTITION y2016m5 VALUES LESS THAN (736481) ENGINE = InnoDB,
1776 PARTITION y2016m6 VALUES LESS THAN (736511) ENGINE = InnoDB,
1777 PARTITION y2016m7 VALUES LESS THAN (736542) ENGINE = InnoDB,
1778 PARTITION y2016m8 VALUES LESS THAN (736573) ENGINE = InnoDB,
1779 PARTITION y2016m9 VALUES LESS THAN (736603) ENGINE = InnoDB,
1780 PARTITION y2016m10 VALUES LESS THAN (736634) ENGINE = InnoDB,
1781 PARTITION y2016m11 VALUES LESS THAN (736664) ENGINE = InnoDB,
1782 PARTITION y2016m12 VALUES LESS THAN (736695) ENGINE = InnoDB,
1783 PARTITION y2017m1 VALUES LESS THAN (736726) ENGINE = InnoDB,
1784 PARTITION y2017m2 VALUES LESS THAN (736754) ENGINE = InnoDB,
1785 PARTITION y2017m3 VALUES LESS THAN (736785) ENGINE = InnoDB,
1786 PARTITION y2017m4 VALUES LESS THAN (736815) ENGINE = InnoDB,
1787 PARTITION y2017m5 VALUES LESS THAN (736846) ENGINE = InnoDB,
1788 PARTITION y2017m6 VALUES LESS THAN (736876) ENGINE = InnoDB,
1789 PARTITION y2017m7 VALUES LESS THAN (736907) ENGINE = InnoDB,
1790 PARTITION y2017m8 VALUES LESS THAN (736938) ENGINE = InnoDB,
1791 PARTITION y2017m9 VALUES LESS THAN (736968) ENGINE = InnoDB,
1792 PARTITION y2017m10 VALUES LESS THAN (736999) ENGINE = InnoDB,
1793 PARTITION y2017m11 VALUES LESS THAN (737029) ENGINE = InnoDB,
1794 PARTITION y2017m12 VALUES LESS THAN (737060) ENGINE = InnoDB,
1795 PARTITION y2018m1 VALUES LESS THAN (737091) ENGINE = InnoDB,
1796 PARTITION y2018m2 VALUES LESS THAN (737119) ENGINE = InnoDB,
1797 PARTITION y2018m3 VALUES LESS THAN (737150) ENGINE = InnoDB,
1798 PARTITION y2018m4 VALUES LESS THAN (737180) ENGINE = InnoDB,
1799 PARTITION y2018m5 VALUES LESS THAN (737211) ENGINE = InnoDB,
1800 PARTITION y2018m6 VALUES LESS THAN (737241) ENGINE = InnoDB,
1801 PARTITION y2018m7 VALUES LESS THAN (737272) ENGINE = InnoDB,
1802 PARTITION y2018m8 VALUES LESS THAN (737303) ENGINE = InnoDB,
1803 PARTITION y2018m9 VALUES LESS THAN (737333) ENGINE = InnoDB,
1804 PARTITION y2018m10 VALUES LESS THAN (737364) ENGINE = InnoDB,
1805 PARTITION y2018m11 VALUES LESS THAN (737394) ENGINE = InnoDB,
1806 PARTITION y2018m12 VALUES LESS THAN (737425) ENGINE = InnoDB,
1807 PARTITION y2019m1 VALUES LESS THAN (737456) ENGINE = InnoDB,
1808 PARTITION y2019m2 VALUES LESS THAN (737484) ENGINE = InnoDB,
1809 PARTITION y2019m3 VALUES LESS THAN (737515) ENGINE = InnoDB,
1810 PARTITION y2019m4 VALUES LESS THAN (737545) ENGINE = InnoDB,
1811 PARTITION y2019m5 VALUES LESS THAN (737576) ENGINE = InnoDB,
1812 PARTITION y2019m6 VALUES LESS THAN (737606) ENGINE = InnoDB,
1813 PARTITION y2019m7 VALUES LESS THAN (737637) ENGINE = InnoDB,
1814 PARTITION y2019m8 VALUES LESS THAN (737668) ENGINE = InnoDB,
1815 PARTITION y2019m9 VALUES LESS THAN (737698) ENGINE = InnoDB,
1816 PARTITION y2019m10 VALUES LESS THAN (737729) ENGINE = InnoDB,
1817 PARTITION y2019m11 VALUES LESS THAN (737759) ENGINE = InnoDB,
1818 PARTITION y2019m12 VALUES LESS THAN (737790) ENGINE = InnoDB) */ AUTO_INCREMENT=302270388 ;
1819
1820-- --------------------------------------------------------
1821
1822--
1823-- Table structure for table `statistics_cache_middle`
1824--
1825
1826CREATE TABLE IF NOT EXISTS `statistics_cache_middle` (
1827  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1828  `uniqkey` varchar(255) NOT NULL DEFAULT '',
1829  `player_id` int(11) DEFAULT NULL,
1830  `video_id` int(11) DEFAULT NULL,
1831  `log_date` date NOT NULL DEFAULT '0000-00-00',
1832  `video_shows` int(11) NOT NULL DEFAULT '0',
1833  `click` int(11) NOT NULL DEFAULT '0',
1834  `preroll_shows` int(11) NOT NULL DEFAULT '0',
1835  `pause_shows` int(11) NOT NULL DEFAULT '0',
1836  `overlay_shows` int(11) NOT NULL DEFAULT '0',
1837  `midroll_shows` int(11) NOT NULL DEFAULT '0',
1838  `postroll_shows` int(11) NOT NULL DEFAULT '0',
1839  `profit` double NOT NULL DEFAULT '0',
1840  PRIMARY KEY (`id`,`log_date`),
1841  UNIQUE KEY `player_id_2` (`player_id`,`video_id`,`log_date`),
1842  KEY `player_id` (`player_id`),
1843  KEY `log_date` (`log_date`),
1844  KEY `video_id` (`video_id`)
1845) ENGINE=InnoDB  DEFAULT CHARSET=utf8
1846/*!50100 PARTITION BY RANGE ( TO_DAYS(log_date))
1847(PARTITION y2013m1 VALUES LESS THAN (735265) ENGINE = InnoDB,
1848 PARTITION y2013m2 VALUES LESS THAN (735293) ENGINE = InnoDB,
1849 PARTITION y2013m3 VALUES LESS THAN (735324) ENGINE = InnoDB,
1850 PARTITION y2013m4 VALUES LESS THAN (735354) ENGINE = InnoDB,
1851 PARTITION y2013m5 VALUES LESS THAN (735385) ENGINE = InnoDB,
1852 PARTITION y2013m6 VALUES LESS THAN (735415) ENGINE = InnoDB,
1853 PARTITION y2013m7 VALUES LESS THAN (735446) ENGINE = InnoDB,
1854 PARTITION y2013m8 VALUES LESS THAN (735477) ENGINE = InnoDB,
1855 PARTITION y2013m9 VALUES LESS THAN (735507) ENGINE = InnoDB,
1856 PARTITION y2013m10 VALUES LESS THAN (735538) ENGINE = InnoDB,
1857 PARTITION y2013m11 VALUES LESS THAN (735568) ENGINE = InnoDB,
1858 PARTITION y2013m12 VALUES LESS THAN (735599) ENGINE = InnoDB,
1859 PARTITION y2014m1 VALUES LESS THAN (735630) ENGINE = InnoDB,
1860 PARTITION y2014m2 VALUES LESS THAN (735658) ENGINE = InnoDB,
1861 PARTITION y2014m3 VALUES LESS THAN (735689) ENGINE = InnoDB,
1862 PARTITION y2014m4 VALUES LESS THAN (735719) ENGINE = InnoDB,
1863 PARTITION y2014m5 VALUES LESS THAN (735750) ENGINE = InnoDB,
1864 PARTITION y2014m6 VALUES LESS THAN (735780) ENGINE = InnoDB,
1865 PARTITION y2014m7 VALUES LESS THAN (735811) ENGINE = InnoDB,
1866 PARTITION y2014m8 VALUES LESS THAN (735842) ENGINE = InnoDB,
1867 PARTITION y2014m9 VALUES LESS THAN (735872) ENGINE = InnoDB,
1868 PARTITION y2014m10 VALUES LESS THAN (735903) ENGINE = InnoDB,
1869 PARTITION y2014m11 VALUES LESS THAN (735933) ENGINE = InnoDB,
1870 PARTITION y2014m12 VALUES LESS THAN (735964) ENGINE = InnoDB,
1871 PARTITION y2015m1 VALUES LESS THAN (735995) ENGINE = InnoDB,
1872 PARTITION y2015m2 VALUES LESS THAN (736023) ENGINE = InnoDB,
1873 PARTITION y2015m3 VALUES LESS THAN (736054) ENGINE = InnoDB,
1874 PARTITION y2015m4 VALUES LESS THAN (736084) ENGINE = InnoDB,
1875 PARTITION y2015m5 VALUES LESS THAN (736115) ENGINE = InnoDB,
1876 PARTITION y2015m6 VALUES LESS THAN (736145) ENGINE = InnoDB,
1877 PARTITION y2015m7 VALUES LESS THAN (736176) ENGINE = InnoDB,
1878 PARTITION y2015m8 VALUES LESS THAN (736207) ENGINE = InnoDB,
1879 PARTITION y2015m9 VALUES LESS THAN (736237) ENGINE = InnoDB,
1880 PARTITION y2015m10 VALUES LESS THAN (736268) ENGINE = InnoDB,
1881 PARTITION y2015m11 VALUES LESS THAN (736298) ENGINE = InnoDB,
1882 PARTITION y2015m12 VALUES LESS THAN (736329) ENGINE = InnoDB,
1883 PARTITION y2016m1 VALUES LESS THAN (736360) ENGINE = InnoDB,
1884 PARTITION y2016m2 VALUES LESS THAN (736389) ENGINE = InnoDB,
1885 PARTITION y2016m3 VALUES LESS THAN (736420) ENGINE = InnoDB,
1886 PARTITION y2016m4 VALUES LESS THAN (736450) ENGINE = InnoDB,
1887 PARTITION y2016m5 VALUES LESS THAN (736481) ENGINE = InnoDB,
1888 PARTITION y2016m6 VALUES LESS THAN (736511) ENGINE = InnoDB,
1889 PARTITION y2016m7 VALUES LESS THAN (736542) ENGINE = InnoDB,
1890 PARTITION y2016m8 VALUES LESS THAN (736573) ENGINE = InnoDB,
1891 PARTITION y2016m9 VALUES LESS THAN (736603) ENGINE = InnoDB,
1892 PARTITION y2016m10 VALUES LESS THAN (736634) ENGINE = InnoDB,
1893 PARTITION y2016m11 VALUES LESS THAN (736664) ENGINE = InnoDB,
1894 PARTITION y2016m12 VALUES LESS THAN (736695) ENGINE = InnoDB,
1895 PARTITION y2017m1 VALUES LESS THAN (736726) ENGINE = InnoDB,
1896 PARTITION y2017m2 VALUES LESS THAN (736754) ENGINE = InnoDB,
1897 PARTITION y2017m3 VALUES LESS THAN (736785) ENGINE = InnoDB,
1898 PARTITION y2017m4 VALUES LESS THAN (736815) ENGINE = InnoDB,
1899 PARTITION y2017m5 VALUES LESS THAN (736846) ENGINE = InnoDB,
1900 PARTITION y2017m6 VALUES LESS THAN (736876) ENGINE = InnoDB,
1901 PARTITION y2017m7 VALUES LESS THAN (736907) ENGINE = InnoDB,
1902 PARTITION y2017m8 VALUES LESS THAN (736938) ENGINE = InnoDB,
1903 PARTITION y2017m9 VALUES LESS THAN (736968) ENGINE = InnoDB,
1904 PARTITION y2017m10 VALUES LESS THAN (736999) ENGINE = InnoDB,
1905 PARTITION y2017m11 VALUES LESS THAN (737029) ENGINE = InnoDB,
1906 PARTITION y2017m12 VALUES LESS THAN (737060) ENGINE = InnoDB,
1907 PARTITION y2018m1 VALUES LESS THAN (737091) ENGINE = InnoDB,
1908 PARTITION y2018m2 VALUES LESS THAN (737119) ENGINE = InnoDB,
1909 PARTITION y2018m3 VALUES LESS THAN (737150) ENGINE = InnoDB,
1910 PARTITION y2018m4 VALUES LESS THAN (737180) ENGINE = InnoDB,
1911 PARTITION y2018m5 VALUES LESS THAN (737211) ENGINE = InnoDB,
1912 PARTITION y2018m6 VALUES LESS THAN (737241) ENGINE = InnoDB,
1913 PARTITION y2018m7 VALUES LESS THAN (737272) ENGINE = InnoDB,
1914 PARTITION y2018m8 VALUES LESS THAN (737303) ENGINE = InnoDB,
1915 PARTITION y2018m9 VALUES LESS THAN (737333) ENGINE = InnoDB,
1916 PARTITION y2018m10 VALUES LESS THAN (737364) ENGINE = InnoDB,
1917 PARTITION y2018m11 VALUES LESS THAN (737394) ENGINE = InnoDB,
1918 PARTITION y2018m12 VALUES LESS THAN (737425) ENGINE = InnoDB,
1919 PARTITION y2019m1 VALUES LESS THAN (737456) ENGINE = InnoDB,
1920 PARTITION y2019m2 VALUES LESS THAN (737484) ENGINE = InnoDB,
1921 PARTITION y2019m3 VALUES LESS THAN (737515) ENGINE = InnoDB,
1922 PARTITION y2019m4 VALUES LESS THAN (737545) ENGINE = InnoDB,
1923 PARTITION y2019m5 VALUES LESS THAN (737576) ENGINE = InnoDB,
1924 PARTITION y2019m6 VALUES LESS THAN (737606) ENGINE = InnoDB,
1925 PARTITION y2019m7 VALUES LESS THAN (737637) ENGINE = InnoDB,
1926 PARTITION y2019m8 VALUES LESS THAN (737668) ENGINE = InnoDB,
1927 PARTITION y2019m9 VALUES LESS THAN (737698) ENGINE = InnoDB,
1928 PARTITION y2019m10 VALUES LESS THAN (737729) ENGINE = InnoDB,
1929 PARTITION y2019m11 VALUES LESS THAN (737759) ENGINE = InnoDB,
1930 PARTITION y2019m12 VALUES LESS THAN (737790) ENGINE = InnoDB) */ AUTO_INCREMENT=619445190 ;
1931
1932-- --------------------------------------------------------
1933
1934--
1935-- Table structure for table `statistics_endscreen`
1936--
1937
1938CREATE TABLE IF NOT EXISTS `statistics_endscreen` (
1939  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1940  `video_id` int(11) DEFAULT NULL COMMENT 'ID видео',
1941  `log_date` date NOT NULL DEFAULT '0000-00-00' COMMENT 'дата логирования',
1942  `video_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'кол-во показов',
1943  PRIMARY KEY (`id`,`log_date`),
1944  UNIQUE KEY `video_id-date-idx` (`video_id`,`log_date`),
1945  KEY `video_id` (`video_id`),
1946  KEY `log_date-idx` (`log_date`)
1947) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Статистика по показам видео в эндскрине'
1948/*!50100 PARTITION BY RANGE ( TO_DAYS(log_date))
1949(PARTITION y2015m1 VALUES LESS THAN (735995) ENGINE = InnoDB,
1950 PARTITION y2015m2 VALUES LESS THAN (736023) ENGINE = InnoDB,
1951 PARTITION y2015m3 VALUES LESS THAN (736054) ENGINE = InnoDB,
1952 PARTITION y2015m4 VALUES LESS THAN (736084) ENGINE = InnoDB,
1953 PARTITION y2015m5 VALUES LESS THAN (736115) ENGINE = InnoDB,
1954 PARTITION y2015m6 VALUES LESS THAN (736145) ENGINE = InnoDB,
1955 PARTITION y2015m7 VALUES LESS THAN (736176) ENGINE = InnoDB,
1956 PARTITION y2015m8 VALUES LESS THAN (736207) ENGINE = InnoDB,
1957 PARTITION y2015m9 VALUES LESS THAN (736237) ENGINE = InnoDB,
1958 PARTITION y2015m10 VALUES LESS THAN (736268) ENGINE = InnoDB,
1959 PARTITION y2015m11 VALUES LESS THAN (736298) ENGINE = InnoDB,
1960 PARTITION y2015m12 VALUES LESS THAN (736329) ENGINE = InnoDB,
1961 PARTITION y2016m1 VALUES LESS THAN (736360) ENGINE = InnoDB,
1962 PARTITION y2016m2 VALUES LESS THAN (736389) ENGINE = InnoDB,
1963 PARTITION y2016m3 VALUES LESS THAN (736420) ENGINE = InnoDB,
1964 PARTITION y2016m4 VALUES LESS THAN (736450) ENGINE = InnoDB,
1965 PARTITION y2016m5 VALUES LESS THAN (736481) ENGINE = InnoDB,
1966 PARTITION y2016m6 VALUES LESS THAN (736511) ENGINE = InnoDB,
1967 PARTITION y2016m7 VALUES LESS THAN (736542) ENGINE = InnoDB,
1968 PARTITION y2016m8 VALUES LESS THAN (736573) ENGINE = InnoDB,
1969 PARTITION y2016m9 VALUES LESS THAN (736603) ENGINE = InnoDB,
1970 PARTITION y2016m10 VALUES LESS THAN (736634) ENGINE = InnoDB,
1971 PARTITION y2016m11 VALUES LESS THAN (736664) ENGINE = InnoDB,
1972 PARTITION y2016m12 VALUES LESS THAN (736695) ENGINE = InnoDB,
1973 PARTITION y2017m1 VALUES LESS THAN (736726) ENGINE = InnoDB,
1974 PARTITION y2017m2 VALUES LESS THAN (736754) ENGINE = InnoDB,
1975 PARTITION y2017m3 VALUES LESS THAN (736785) ENGINE = InnoDB,
1976 PARTITION y2017m4 VALUES LESS THAN (736815) ENGINE = InnoDB,
1977 PARTITION y2017m5 VALUES LESS THAN (736846) ENGINE = InnoDB,
1978 PARTITION y2017m6 VALUES LESS THAN (736876) ENGINE = InnoDB,
1979 PARTITION y2017m7 VALUES LESS THAN (736907) ENGINE = InnoDB,
1980 PARTITION y2017m8 VALUES LESS THAN (736938) ENGINE = InnoDB,
1981 PARTITION y2017m9 VALUES LESS THAN (736968) ENGINE = InnoDB,
1982 PARTITION y2017m10 VALUES LESS THAN (736999) ENGINE = InnoDB,
1983 PARTITION y2017m11 VALUES LESS THAN (737029) ENGINE = InnoDB,
1984 PARTITION y2017m12 VALUES LESS THAN (737060) ENGINE = InnoDB,
1985 PARTITION y2018m1 VALUES LESS THAN (737091) ENGINE = InnoDB,
1986 PARTITION y2018m2 VALUES LESS THAN (737119) ENGINE = InnoDB,
1987 PARTITION y2018m3 VALUES LESS THAN (737150) ENGINE = InnoDB,
1988 PARTITION y2018m4 VALUES LESS THAN (737180) ENGINE = InnoDB,
1989 PARTITION y2018m5 VALUES LESS THAN (737211) ENGINE = InnoDB,
1990 PARTITION y2018m6 VALUES LESS THAN (737241) ENGINE = InnoDB,
1991 PARTITION y2018m7 VALUES LESS THAN (737272) ENGINE = InnoDB,
1992 PARTITION y2018m8 VALUES LESS THAN (737303) ENGINE = InnoDB,
1993 PARTITION y2018m9 VALUES LESS THAN (737333) ENGINE = InnoDB,
1994 PARTITION y2018m10 VALUES LESS THAN (737364) ENGINE = InnoDB,
1995 PARTITION y2018m11 VALUES LESS THAN (737394) ENGINE = InnoDB,
1996 PARTITION y2018m12 VALUES LESS THAN (737425) ENGINE = InnoDB,
1997 PARTITION y2019m1 VALUES LESS THAN (737456) ENGINE = InnoDB,
1998 PARTITION y2019m2 VALUES LESS THAN (737484) ENGINE = InnoDB,
1999 PARTITION y2019m3 VALUES LESS THAN (737515) ENGINE = InnoDB,
2000 PARTITION y2019m4 VALUES LESS THAN (737545) ENGINE = InnoDB,
2001 PARTITION y2019m5 VALUES LESS THAN (737576) ENGINE = InnoDB,
2002 PARTITION y2019m6 VALUES LESS THAN (737606) ENGINE = InnoDB,
2003 PARTITION y2019m7 VALUES LESS THAN (737637) ENGINE = InnoDB,
2004 PARTITION y2019m8 VALUES LESS THAN (737668) ENGINE = InnoDB,
2005 PARTITION y2019m9 VALUES LESS THAN (737698) ENGINE = InnoDB,
2006 PARTITION y2019m10 VALUES LESS THAN (737729) ENGINE = InnoDB,
2007 PARTITION y2019m11 VALUES LESS THAN (737759) ENGINE = InnoDB,
2008 PARTITION y2019m12 VALUES LESS THAN (737790) ENGINE = InnoDB) */ AUTO_INCREMENT=1 ;
2009
2010-- --------------------------------------------------------
2011
2012--
2013-- Table structure for table `statistics_hide_ads`
2014--
2015
2016CREATE TABLE IF NOT EXISTS `statistics_hide_ads` (
2017  `id` bigint(20) NOT NULL AUTO_INCREMENT,
2018  `player_id` int(11) DEFAULT NULL,
2019  `log_date` date NOT NULL DEFAULT '0000-00-00',
2020  `video_id` int(11) DEFAULT NULL,
2021  `country_code` varchar(2) NOT NULL DEFAULT '',
2022  `ad_company_id` int(11) DEFAULT NULL,
2023  `ad_shows` int(11) NOT NULL DEFAULT '0',
2024  PRIMARY KEY (`id`,`log_date`),
2025  UNIQUE KEY `player_id` (`player_id`,`log_date`,`video_id`,`country_code`,`ad_company_id`)
2026) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Табличка статистики скрытой рекламы'
2027/*!50100 PARTITION BY RANGE ( TO_DAYS(log_date))
2028(PARTITION y2015m1 VALUES LESS THAN (735995) ENGINE = InnoDB,
2029 PARTITION y2015m2 VALUES LESS THAN (736023) ENGINE = InnoDB,
2030 PARTITION y2015m3 VALUES LESS THAN (736054) ENGINE = InnoDB,
2031 PARTITION y2015m4 VALUES LESS THAN (736084) ENGINE = InnoDB,
2032 PARTITION y2015m5 VALUES LESS THAN (736115) ENGINE = InnoDB,
2033 PARTITION y2015m6 VALUES LESS THAN (736145) ENGINE = InnoDB,
2034 PARTITION y2015m7 VALUES LESS THAN (736176) ENGINE = InnoDB,
2035 PARTITION y2015m8 VALUES LESS THAN (736207) ENGINE = InnoDB,
2036 PARTITION y2015m9 VALUES LESS THAN (736237) ENGINE = InnoDB,
2037 PARTITION y2015m10 VALUES LESS THAN (736268) ENGINE = InnoDB,
2038 PARTITION y2015m11 VALUES LESS THAN (736298) ENGINE = InnoDB,
2039 PARTITION y2015m12 VALUES LESS THAN (736329) ENGINE = InnoDB,
2040 PARTITION y2016m1 VALUES LESS THAN (736360) ENGINE = InnoDB,
2041 PARTITION y2016m2 VALUES LESS THAN (736389) ENGINE = InnoDB,
2042 PARTITION y2016m3 VALUES LESS THAN (736420) ENGINE = InnoDB,
2043 PARTITION y2016m4 VALUES LESS THAN (736450) ENGINE = InnoDB,
2044 PARTITION y2016m5 VALUES LESS THAN (736481) ENGINE = InnoDB,
2045 PARTITION y2016m6 VALUES LESS THAN (736511) ENGINE = InnoDB,
2046 PARTITION y2016m7 VALUES LESS THAN (736542) ENGINE = InnoDB,
2047 PARTITION y2016m8 VALUES LESS THAN (736573) ENGINE = InnoDB,
2048 PARTITION y2016m9 VALUES LESS THAN (736603) ENGINE = InnoDB,
2049 PARTITION y2016m10 VALUES LESS THAN (736634) ENGINE = InnoDB,
2050 PARTITION y2016m11 VALUES LESS THAN (736664) ENGINE = InnoDB,
2051 PARTITION y2016m12 VALUES LESS THAN (736695) ENGINE = InnoDB,
2052 PARTITION y2017m1 VALUES LESS THAN (736726) ENGINE = InnoDB,
2053 PARTITION y2017m2 VALUES LESS THAN (736754) ENGINE = InnoDB,
2054 PARTITION y2017m3 VALUES LESS THAN (736785) ENGINE = InnoDB,
2055 PARTITION y2017m4 VALUES LESS THAN (736815) ENGINE = InnoDB,
2056 PARTITION y2017m5 VALUES LESS THAN (736846) ENGINE = InnoDB,
2057 PARTITION y2017m6 VALUES LESS THAN (736876) ENGINE = InnoDB,
2058 PARTITION y2017m7 VALUES LESS THAN (736907) ENGINE = InnoDB,
2059 PARTITION y2017m8 VALUES LESS THAN (736938) ENGINE = InnoDB,
2060 PARTITION y2017m9 VALUES LESS THAN (736968) ENGINE = InnoDB,
2061 PARTITION y2017m10 VALUES LESS THAN (736999) ENGINE = InnoDB,
2062 PARTITION y2017m11 VALUES LESS THAN (737029) ENGINE = InnoDB,
2063 PARTITION y2017m12 VALUES LESS THAN (737060) ENGINE = InnoDB,
2064 PARTITION y2018m1 VALUES LESS THAN (737091) ENGINE = InnoDB,
2065 PARTITION y2018m2 VALUES LESS THAN (737119) ENGINE = InnoDB,
2066 PARTITION y2018m3 VALUES LESS THAN (737150) ENGINE = InnoDB,
2067 PARTITION y2018m4 VALUES LESS THAN (737180) ENGINE = InnoDB,
2068 PARTITION y2018m5 VALUES LESS THAN (737211) ENGINE = InnoDB,
2069 PARTITION y2018m6 VALUES LESS THAN (737241) ENGINE = InnoDB,
2070 PARTITION y2018m7 VALUES LESS THAN (737272) ENGINE = InnoDB,
2071 PARTITION y2018m8 VALUES LESS THAN (737303) ENGINE = InnoDB,
2072 PARTITION y2018m9 VALUES LESS THAN (737333) ENGINE = InnoDB,
2073 PARTITION y2018m10 VALUES LESS THAN (737364) ENGINE = InnoDB,
2074 PARTITION y2018m11 VALUES LESS THAN (737394) ENGINE = InnoDB,
2075 PARTITION y2018m12 VALUES LESS THAN (737425) ENGINE = InnoDB,
2076 PARTITION y2019m1 VALUES LESS THAN (737456) ENGINE = InnoDB,
2077 PARTITION y2019m2 VALUES LESS THAN (737484) ENGINE = InnoDB,
2078 PARTITION y2019m3 VALUES LESS THAN (737515) ENGINE = InnoDB,
2079 PARTITION y2019m4 VALUES LESS THAN (737545) ENGINE = InnoDB,
2080 PARTITION y2019m5 VALUES LESS THAN (737576) ENGINE = InnoDB,
2081 PARTITION y2019m6 VALUES LESS THAN (737606) ENGINE = InnoDB,
2082 PARTITION y2019m7 VALUES LESS THAN (737637) ENGINE = InnoDB,
2083 PARTITION y2019m8 VALUES LESS THAN (737668) ENGINE = InnoDB,
2084 PARTITION y2019m9 VALUES LESS THAN (737698) ENGINE = InnoDB,
2085 PARTITION y2019m10 VALUES LESS THAN (737729) ENGINE = InnoDB,
2086 PARTITION y2019m11 VALUES LESS THAN (737759) ENGINE = InnoDB,
2087 PARTITION y2019m12 VALUES LESS THAN (737790) ENGINE = InnoDB) */ AUTO_INCREMENT=14168346 ;
2088
2089-- --------------------------------------------------------
2090
2091--
2092-- Table structure for table `statistics_hour`
2093--
2094
2095CREATE TABLE IF NOT EXISTS `statistics_hour` (
2096  `id` bigint(20) NOT NULL AUTO_INCREMENT,
2097  `log_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата с градацией по часам',
2098  `ad_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'Кол-во показов рекламы',
2099  `video_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'Кол-во показов видео',
2100  PRIMARY KEY (`id`),
2101  UNIQUE KEY `log_date_idx` (`log_date`)
2102) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Статистика по часам' AUTO_INCREMENT=1722715869 ;
2103
2104-- --------------------------------------------------------
2105
2106--
2107-- Table structure for table `statistics_vkvideo`
2108--
2109
2110CREATE TABLE IF NOT EXISTS `statistics_vkvideo` (
2111  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
2112  `vk_video_id` int(11) DEFAULT NULL,
2113  `vk_owner_id` int(11) DEFAULT NULL,
2114  `title` text,
2115  `video_shows` int(11) DEFAULT NULL,
2116  `log_date` date DEFAULT NULL,
2117  PRIMARY KEY (`id`),
2118  KEY `vk_video_id` (`vk_video_id`),
2119  KEY `vk_owner_id` (`vk_owner_id`),
2120  KEY `log_date` (`log_date`)
2121) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1054795 ;
2122
2123-- --------------------------------------------------------
2124
2125--
2126-- Table structure for table `statistic_queue`
2127--
2128
2129CREATE TABLE IF NOT EXISTS `statistic_queue` (
2130  `id` int(11) NOT NULL AUTO_INCREMENT,
2131  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата создания задания',
2132  `request_data` varchar(550) NOT NULL COMMENT 'Данные запроса фильтра статистики',
2133  `type` char(255) NOT NULL COMMENT 'Тип группировки статистики',
2134  `status` enum('new','in_work','success','error') DEFAULT 'new' COMMENT 'Статус задачи',
2135  `result` varchar(550) NOT NULL COMMENT 'Результат обработки: ссылка на файл csv',
2136  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Признак удаления площадки = 1',
2137  `log` text NOT NULL COMMENT 'Лог ошибки обработки скрипта STDOUT',
2138  PRIMARY KEY (`id`)
2139) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=905 ;
2140
2141-- --------------------------------------------------------
2142
2143--
2144-- Table structure for table `subscribe`
2145--
2146
2147CREATE TABLE IF NOT EXISTS `subscribe` (
2148  `id` int(11) NOT NULL AUTO_INCREMENT,
2149  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
2150  `send_date` timestamp NULL DEFAULT NULL,
2151  `subject` text NOT NULL,
2152  `body` text NOT NULL,
2153  PRIMARY KEY (`id`)
2154) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=61 ;
2155
2156-- --------------------------------------------------------
2157
2158--
2159-- Table structure for table `subscribe_users`
2160--
2161
2162CREATE TABLE IF NOT EXISTS `subscribe_users` (
2163  `id` int(11) NOT NULL AUTO_INCREMENT,
2164  `subscribe_id` int(11) DEFAULT NULL,
2165  `itv_partners_id` int(11) DEFAULT NULL,
2166  `is_send` tinyint(1) NOT NULL DEFAULT '0',
2167  `is_receive` tinyint(1) NOT NULL DEFAULT '0',
2168  PRIMARY KEY (`id`),
2169  KEY `subscribe_id` (`subscribe_id`)
2170) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=36976 ;
2171
2172-- --------------------------------------------------------
2173
2174--
2175-- Table structure for table `tags`
2176--
2177
2178CREATE TABLE IF NOT EXISTS `tags` (
2179  `id` int(11) NOT NULL AUTO_INCREMENT,
2180  `tag` varchar(255) NOT NULL COMMENT 'Тег',
2181  `rate` int(11) NOT NULL DEFAULT '0' COMMENT 'рейтинг тега',
2182  PRIMARY KEY (`id`),
2183  UNIQUE KEY `tag_idx` (`tag`)
2184) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Теги' AUTO_INCREMENT=18 ;
2185
2186-- --------------------------------------------------------
2187
2188--
2189-- Table structure for table `t_statistics_cache_heavy`
2190--
2191
2192CREATE TABLE IF NOT EXISTS `t_statistics_cache_heavy` (
2193  `id` bigint(20) NOT NULL AUTO_INCREMENT,
2194  `player_id` int(11) DEFAULT NULL COMMENT 'ID плеера',
2195  `log_date` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Дата события',
2196  `video_id` int(11) DEFAULT NULL COMMENT 'ID видео',
2197  `country_code` varchar(2) NOT NULL DEFAULT '' COMMENT 'Двухзначный код страны',
2198  `ad_company_id` int(11) DEFAULT NULL COMMENT 'ID рекламы',
2199  `video_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'сумма показов видео',
2200  `preroll_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'сумма показов преролов',
2201  `pause_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'сумма показов паузролов и паузбаннеров',
2202  `overlay_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'сумма показов оверлеев',
2203  `postroll_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'сумма показов постролов',
2204  `midroll_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'сумма показов мидролов',
2205  `click` int(11) NOT NULL DEFAULT '0' COMMENT 'сумма кликов по рекламе',
2206  `profit` double NOT NULL DEFAULT '0' COMMENT 'заработок дистрибутора',
2207  PRIMARY KEY (`id`,`log_date`),
2208  UNIQUE KEY `player_id_2` (`player_id`,`log_date`,`video_id`,`country_code`,`ad_company_id`),
2209  KEY `player_id` (`player_id`),
2210  KEY `log_date` (`log_date`),
2211  KEY `video_id` (`video_id`),
2212  KEY `country_code` (`country_code`),
2213  KEY `ad_company_id` (`ad_company_id`)
2214) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='самая детальная статистика'
2215/*!50100 PARTITION BY RANGE ( TO_DAYS(log_date))
2216(PARTITION y2013m1 VALUES LESS THAN (735265) ENGINE = InnoDB,
2217 PARTITION y2013m2 VALUES LESS THAN (735293) ENGINE = InnoDB,
2218 PARTITION y2013m3 VALUES LESS THAN (735324) ENGINE = InnoDB,
2219 PARTITION y2013m4 VALUES LESS THAN (735354) ENGINE = InnoDB,
2220 PARTITION y2013m5 VALUES LESS THAN (735385) ENGINE = InnoDB,
2221 PARTITION y2013m6 VALUES LESS THAN (735415) ENGINE = InnoDB,
2222 PARTITION y2013m7 VALUES LESS THAN (735446) ENGINE = InnoDB,
2223 PARTITION y2013m8 VALUES LESS THAN (735477) ENGINE = InnoDB,
2224 PARTITION y2013m9 VALUES LESS THAN (735507) ENGINE = InnoDB,
2225 PARTITION y2013m10 VALUES LESS THAN (735538) ENGINE = InnoDB,
2226 PARTITION y2013m11 VALUES LESS THAN (735568) ENGINE = InnoDB,
2227 PARTITION y2013m12 VALUES LESS THAN (735599) ENGINE = InnoDB,
2228 PARTITION y2014m1 VALUES LESS THAN (735630) ENGINE = InnoDB,
2229 PARTITION y2014m2 VALUES LESS THAN (735658) ENGINE = InnoDB,
2230 PARTITION y2014m3 VALUES LESS THAN (735689) ENGINE = InnoDB,
2231 PARTITION y2014m4 VALUES LESS THAN (735719) ENGINE = InnoDB,
2232 PARTITION y2014m5 VALUES LESS THAN (735750) ENGINE = InnoDB,
2233 PARTITION y2014m6 VALUES LESS THAN (735780) ENGINE = InnoDB,
2234 PARTITION y2014m7 VALUES LESS THAN (735811) ENGINE = InnoDB,
2235 PARTITION y2014m8 VALUES LESS THAN (735842) ENGINE = InnoDB,
2236 PARTITION y2014m9 VALUES LESS THAN (735872) ENGINE = InnoDB,
2237 PARTITION y2014m10 VALUES LESS THAN (735903) ENGINE = InnoDB,
2238 PARTITION y2014m11 VALUES LESS THAN (735933) ENGINE = InnoDB,
2239 PARTITION y2014m12 VALUES LESS THAN (735964) ENGINE = InnoDB,
2240 PARTITION y2015m1 VALUES LESS THAN (735995) ENGINE = InnoDB,
2241 PARTITION y2015m2 VALUES LESS THAN (736023) ENGINE = InnoDB,
2242 PARTITION y2015m3 VALUES LESS THAN (736054) ENGINE = InnoDB,
2243 PARTITION y2015m4 VALUES LESS THAN (736084) ENGINE = InnoDB,
2244 PARTITION y2015m5 VALUES LESS THAN (736115) ENGINE = InnoDB,
2245 PARTITION y2015m6 VALUES LESS THAN (736145) ENGINE = InnoDB,
2246 PARTITION y2015m7 VALUES LESS THAN (736176) ENGINE = InnoDB,
2247 PARTITION y2015m8 VALUES LESS THAN (736207) ENGINE = InnoDB,
2248 PARTITION y2015m9 VALUES LESS THAN (736237) ENGINE = InnoDB,
2249 PARTITION y2015m10 VALUES LESS THAN (736268) ENGINE = InnoDB,
2250 PARTITION y2015m11 VALUES LESS THAN (736298) ENGINE = InnoDB,
2251 PARTITION y2015m12 VALUES LESS THAN (736329) ENGINE = InnoDB,
2252 PARTITION y2016m1 VALUES LESS THAN (736360) ENGINE = InnoDB,
2253 PARTITION y2016m2 VALUES LESS THAN (736389) ENGINE = InnoDB,
2254 PARTITION y2016m3 VALUES LESS THAN (736420) ENGINE = InnoDB,
2255 PARTITION y2016m4 VALUES LESS THAN (736450) ENGINE = InnoDB,
2256 PARTITION y2016m5 VALUES LESS THAN (736481) ENGINE = InnoDB,
2257 PARTITION y2016m6 VALUES LESS THAN (736511) ENGINE = InnoDB,
2258 PARTITION y2016m7 VALUES LESS THAN (736542) ENGINE = InnoDB,
2259 PARTITION y2016m8 VALUES LESS THAN (736573) ENGINE = InnoDB,
2260 PARTITION y2016m9 VALUES LESS THAN (736603) ENGINE = InnoDB,
2261 PARTITION y2016m10 VALUES LESS THAN (736634) ENGINE = InnoDB,
2262 PARTITION y2016m11 VALUES LESS THAN (736664) ENGINE = InnoDB,
2263 PARTITION y2016m12 VALUES LESS THAN (736695) ENGINE = InnoDB,
2264 PARTITION y2017m1 VALUES LESS THAN (736726) ENGINE = InnoDB,
2265 PARTITION y2017m2 VALUES LESS THAN (736754) ENGINE = InnoDB,
2266 PARTITION y2017m3 VALUES LESS THAN (736785) ENGINE = InnoDB,
2267 PARTITION y2017m4 VALUES LESS THAN (736815) ENGINE = InnoDB,
2268 PARTITION y2017m5 VALUES LESS THAN (736846) ENGINE = InnoDB,
2269 PARTITION y2017m6 VALUES LESS THAN (736876) ENGINE = InnoDB,
2270 PARTITION y2017m7 VALUES LESS THAN (736907) ENGINE = InnoDB,
2271 PARTITION y2017m8 VALUES LESS THAN (736938) ENGINE = InnoDB,
2272 PARTITION y2017m9 VALUES LESS THAN (736968) ENGINE = InnoDB,
2273 PARTITION y2017m10 VALUES LESS THAN (736999) ENGINE = InnoDB,
2274 PARTITION y2017m11 VALUES LESS THAN (737029) ENGINE = InnoDB,
2275 PARTITION y2017m12 VALUES LESS THAN (737060) ENGINE = InnoDB,
2276 PARTITION y2018m1 VALUES LESS THAN (737091) ENGINE = InnoDB,
2277 PARTITION y2018m2 VALUES LESS THAN (737119) ENGINE = InnoDB,
2278 PARTITION y2018m3 VALUES LESS THAN (737150) ENGINE = InnoDB,
2279 PARTITION y2018m4 VALUES LESS THAN (737180) ENGINE = InnoDB,
2280 PARTITION y2018m5 VALUES LESS THAN (737211) ENGINE = InnoDB,
2281 PARTITION y2018m6 VALUES LESS THAN (737241) ENGINE = InnoDB,
2282 PARTITION y2018m7 VALUES LESS THAN (737272) ENGINE = InnoDB,
2283 PARTITION y2018m8 VALUES LESS THAN (737303) ENGINE = InnoDB,
2284 PARTITION y2018m9 VALUES LESS THAN (737333) ENGINE = InnoDB,
2285 PARTITION y2018m10 VALUES LESS THAN (737364) ENGINE = InnoDB,
2286 PARTITION y2018m11 VALUES LESS THAN (737394) ENGINE = InnoDB,
2287 PARTITION y2018m12 VALUES LESS THAN (737425) ENGINE = InnoDB,
2288 PARTITION y2019m1 VALUES LESS THAN (737456) ENGINE = InnoDB,
2289 PARTITION y2019m2 VALUES LESS THAN (737484) ENGINE = InnoDB,
2290 PARTITION y2019m3 VALUES LESS THAN (737515) ENGINE = InnoDB,
2291 PARTITION y2019m4 VALUES LESS THAN (737545) ENGINE = InnoDB,
2292 PARTITION y2019m5 VALUES LESS THAN (737576) ENGINE = InnoDB,
2293 PARTITION y2019m6 VALUES LESS THAN (737606) ENGINE = InnoDB,
2294 PARTITION y2019m7 VALUES LESS THAN (737637) ENGINE = InnoDB,
2295 PARTITION y2019m8 VALUES LESS THAN (737668) ENGINE = InnoDB,
2296 PARTITION y2019m9 VALUES LESS THAN (737698) ENGINE = InnoDB,
2297 PARTITION y2019m10 VALUES LESS THAN (737729) ENGINE = InnoDB,
2298 PARTITION y2019m11 VALUES LESS THAN (737759) ENGINE = InnoDB,
2299 PARTITION y2019m12 VALUES LESS THAN (737790) ENGINE = InnoDB) */ AUTO_INCREMENT=973663 ;
2300
2301-- --------------------------------------------------------
2302
2303--
2304-- Table structure for table `t_statistics_cache_light`
2305--
2306
2307CREATE TABLE IF NOT EXISTS `t_statistics_cache_light` (
2308  `id` bigint(20) NOT NULL AUTO_INCREMENT,
2309  `uniqkey` varchar(255) NOT NULL DEFAULT '',
2310  `player_id` int(11) DEFAULT NULL,
2311  `log_date` date NOT NULL DEFAULT '0000-00-00',
2312  `video_shows` int(11) NOT NULL DEFAULT '0',
2313  `click` int(11) NOT NULL DEFAULT '0',
2314  `preroll_shows` int(11) NOT NULL DEFAULT '0',
2315  `pause_shows` int(11) NOT NULL DEFAULT '0',
2316  `overlay_shows` int(11) NOT NULL DEFAULT '0',
2317  `midroll_shows` int(11) NOT NULL DEFAULT '0',
2318  `postroll_shows` int(11) NOT NULL DEFAULT '0',
2319  `profit` double NOT NULL DEFAULT '0',
2320  PRIMARY KEY (`id`,`log_date`),
2321  UNIQUE KEY `uniqkey` (`player_id`,`log_date`),
2322  KEY `player_id` (`player_id`),
2323  KEY `log_date` (`log_date`)
2324) ENGINE=InnoDB  DEFAULT CHARSET=utf8
2325/*!50100 PARTITION BY RANGE ( TO_DAYS(log_date))
2326(PARTITION y2013m1 VALUES LESS THAN (735265) ENGINE = InnoDB,
2327 PARTITION y2013m2 VALUES LESS THAN (735293) ENGINE = InnoDB,
2328 PARTITION y2013m3 VALUES LESS THAN (735324) ENGINE = InnoDB,
2329 PARTITION y2013m4 VALUES LESS THAN (735354) ENGINE = InnoDB,
2330 PARTITION y2013m5 VALUES LESS THAN (735385) ENGINE = InnoDB,
2331 PARTITION y2013m6 VALUES LESS THAN (735415) ENGINE = InnoDB,
2332 PARTITION y2013m7 VALUES LESS THAN (735446) ENGINE = InnoDB,
2333 PARTITION y2013m8 VALUES LESS THAN (735477) ENGINE = InnoDB,
2334 PARTITION y2013m9 VALUES LESS THAN (735507) ENGINE = InnoDB,
2335 PARTITION y2013m10 VALUES LESS THAN (735538) ENGINE = InnoDB,
2336 PARTITION y2013m11 VALUES LESS THAN (735568) ENGINE = InnoDB,
2337 PARTITION y2013m12 VALUES LESS THAN (735599) ENGINE = InnoDB,
2338 PARTITION y2014m1 VALUES LESS THAN (735630) ENGINE = InnoDB,
2339 PARTITION y2014m2 VALUES LESS THAN (735658) ENGINE = InnoDB,
2340 PARTITION y2014m3 VALUES LESS THAN (735689) ENGINE = InnoDB,
2341 PARTITION y2014m4 VALUES LESS THAN (735719) ENGINE = InnoDB,
2342 PARTITION y2014m5 VALUES LESS THAN (735750) ENGINE = InnoDB,
2343 PARTITION y2014m6 VALUES LESS THAN (735780) ENGINE = InnoDB,
2344 PARTITION y2014m7 VALUES LESS THAN (735811) ENGINE = InnoDB,
2345 PARTITION y2014m8 VALUES LESS THAN (735842) ENGINE = InnoDB,
2346 PARTITION y2014m9 VALUES LESS THAN (735872) ENGINE = InnoDB,
2347 PARTITION y2014m10 VALUES LESS THAN (735903) ENGINE = InnoDB,
2348 PARTITION y2014m11 VALUES LESS THAN (735933) ENGINE = InnoDB,
2349 PARTITION y2014m12 VALUES LESS THAN (735964) ENGINE = InnoDB,
2350 PARTITION y2015m1 VALUES LESS THAN (735995) ENGINE = InnoDB,
2351 PARTITION y2015m2 VALUES LESS THAN (736023) ENGINE = InnoDB,
2352 PARTITION y2015m3 VALUES LESS THAN (736054) ENGINE = InnoDB,
2353 PARTITION y2015m4 VALUES LESS THAN (736084) ENGINE = InnoDB,
2354 PARTITION y2015m5 VALUES LESS THAN (736115) ENGINE = InnoDB,
2355 PARTITION y2015m6 VALUES LESS THAN (736145) ENGINE = InnoDB,
2356 PARTITION y2015m7 VALUES LESS THAN (736176) ENGINE = InnoDB,
2357 PARTITION y2015m8 VALUES LESS THAN (736207) ENGINE = InnoDB,
2358 PARTITION y2015m9 VALUES LESS THAN (736237) ENGINE = InnoDB,
2359 PARTITION y2015m10 VALUES LESS THAN (736268) ENGINE = InnoDB,
2360 PARTITION y2015m11 VALUES LESS THAN (736298) ENGINE = InnoDB,
2361 PARTITION y2015m12 VALUES LESS THAN (736329) ENGINE = InnoDB,
2362 PARTITION y2016m1 VALUES LESS THAN (736360) ENGINE = InnoDB,
2363 PARTITION y2016m2 VALUES LESS THAN (736389) ENGINE = InnoDB,
2364 PARTITION y2016m3 VALUES LESS THAN (736420) ENGINE = InnoDB,
2365 PARTITION y2016m4 VALUES LESS THAN (736450) ENGINE = InnoDB,
2366 PARTITION y2016m5 VALUES LESS THAN (736481) ENGINE = InnoDB,
2367 PARTITION y2016m6 VALUES LESS THAN (736511) ENGINE = InnoDB,
2368 PARTITION y2016m7 VALUES LESS THAN (736542) ENGINE = InnoDB,
2369 PARTITION y2016m8 VALUES LESS THAN (736573) ENGINE = InnoDB,
2370 PARTITION y2016m9 VALUES LESS THAN (736603) ENGINE = InnoDB,
2371 PARTITION y2016m10 VALUES LESS THAN (736634) ENGINE = InnoDB,
2372 PARTITION y2016m11 VALUES LESS THAN (736664) ENGINE = InnoDB,
2373 PARTITION y2016m12 VALUES LESS THAN (736695) ENGINE = InnoDB,
2374 PARTITION y2017m1 VALUES LESS THAN (736726) ENGINE = InnoDB,
2375 PARTITION y2017m2 VALUES LESS THAN (736754) ENGINE = InnoDB,
2376 PARTITION y2017m3 VALUES LESS THAN (736785) ENGINE = InnoDB,
2377 PARTITION y2017m4 VALUES LESS THAN (736815) ENGINE = InnoDB,
2378 PARTITION y2017m5 VALUES LESS THAN (736846) ENGINE = InnoDB,
2379 PARTITION y2017m6 VALUES LESS THAN (736876) ENGINE = InnoDB,
2380 PARTITION y2017m7 VALUES LESS THAN (736907) ENGINE = InnoDB,
2381 PARTITION y2017m8 VALUES LESS THAN (736938) ENGINE = InnoDB,
2382 PARTITION y2017m9 VALUES LESS THAN (736968) ENGINE = InnoDB,
2383 PARTITION y2017m10 VALUES LESS THAN (736999) ENGINE = InnoDB,
2384 PARTITION y2017m11 VALUES LESS THAN (737029) ENGINE = InnoDB,
2385 PARTITION y2017m12 VALUES LESS THAN (737060) ENGINE = InnoDB,
2386 PARTITION y2018m1 VALUES LESS THAN (737091) ENGINE = InnoDB,
2387 PARTITION y2018m2 VALUES LESS THAN (737119) ENGINE = InnoDB,
2388 PARTITION y2018m3 VALUES LESS THAN (737150) ENGINE = InnoDB,
2389 PARTITION y2018m4 VALUES LESS THAN (737180) ENGINE = InnoDB,
2390 PARTITION y2018m5 VALUES LESS THAN (737211) ENGINE = InnoDB,
2391 PARTITION y2018m6 VALUES LESS THAN (737241) ENGINE = InnoDB,
2392 PARTITION y2018m7 VALUES LESS THAN (737272) ENGINE = InnoDB,
2393 PARTITION y2018m8 VALUES LESS THAN (737303) ENGINE = InnoDB,
2394 PARTITION y2018m9 VALUES LESS THAN (737333) ENGINE = InnoDB,
2395 PARTITION y2018m10 VALUES LESS THAN (737364) ENGINE = InnoDB,
2396 PARTITION y2018m11 VALUES LESS THAN (737394) ENGINE = InnoDB,
2397 PARTITION y2018m12 VALUES LESS THAN (737425) ENGINE = InnoDB,
2398 PARTITION y2019m1 VALUES LESS THAN (737456) ENGINE = InnoDB,
2399 PARTITION y2019m2 VALUES LESS THAN (737484) ENGINE = InnoDB,
2400 PARTITION y2019m3 VALUES LESS THAN (737515) ENGINE = InnoDB,
2401 PARTITION y2019m4 VALUES LESS THAN (737545) ENGINE = InnoDB,
2402 PARTITION y2019m5 VALUES LESS THAN (737576) ENGINE = InnoDB,
2403 PARTITION y2019m6 VALUES LESS THAN (737606) ENGINE = InnoDB,
2404 PARTITION y2019m7 VALUES LESS THAN (737637) ENGINE = InnoDB,
2405 PARTITION y2019m8 VALUES LESS THAN (737668) ENGINE = InnoDB,
2406 PARTITION y2019m9 VALUES LESS THAN (737698) ENGINE = InnoDB,
2407 PARTITION y2019m10 VALUES LESS THAN (737729) ENGINE = InnoDB,
2408 PARTITION y2019m11 VALUES LESS THAN (737759) ENGINE = InnoDB,
2409 PARTITION y2019m12 VALUES LESS THAN (737790) ENGINE = InnoDB) */ AUTO_INCREMENT=6590 ;
2410
2411-- --------------------------------------------------------
2412
2413--
2414-- Table structure for table `t_statistics_cache_middle`
2415--
2416
2417CREATE TABLE IF NOT EXISTS `t_statistics_cache_middle` (
2418  `id` bigint(20) NOT NULL AUTO_INCREMENT,
2419  `uniqkey` varchar(255) NOT NULL DEFAULT '',
2420  `player_id` int(11) DEFAULT NULL,
2421  `video_id` int(11) DEFAULT NULL,
2422  `log_date` date NOT NULL DEFAULT '0000-00-00',
2423  `video_shows` int(11) NOT NULL DEFAULT '0',
2424  `click` int(11) NOT NULL DEFAULT '0',
2425  `preroll_shows` int(11) NOT NULL DEFAULT '0',
2426  `pause_shows` int(11) NOT NULL DEFAULT '0',
2427  `overlay_shows` int(11) NOT NULL DEFAULT '0',
2428  `midroll_shows` int(11) NOT NULL DEFAULT '0',
2429  `postroll_shows` int(11) NOT NULL DEFAULT '0',
2430  `profit` double NOT NULL DEFAULT '0',
2431  PRIMARY KEY (`id`,`log_date`),
2432  UNIQUE KEY `player_id_2` (`player_id`,`video_id`,`log_date`),
2433  KEY `player_id` (`player_id`),
2434  KEY `log_date` (`log_date`),
2435  KEY `video_id` (`video_id`)
2436) ENGINE=InnoDB  DEFAULT CHARSET=utf8
2437/*!50100 PARTITION BY RANGE ( TO_DAYS(log_date))
2438(PARTITION y2013m1 VALUES LESS THAN (735265) ENGINE = InnoDB,
2439 PARTITION y2013m2 VALUES LESS THAN (735293) ENGINE = InnoDB,
2440 PARTITION y2013m3 VALUES LESS THAN (735324) ENGINE = InnoDB,
2441 PARTITION y2013m4 VALUES LESS THAN (735354) ENGINE = InnoDB,
2442 PARTITION y2013m5 VALUES LESS THAN (735385) ENGINE = InnoDB,
2443 PARTITION y2013m6 VALUES LESS THAN (735415) ENGINE = InnoDB,
2444 PARTITION y2013m7 VALUES LESS THAN (735446) ENGINE = InnoDB,
2445 PARTITION y2013m8 VALUES LESS THAN (735477) ENGINE = InnoDB,
2446 PARTITION y2013m9 VALUES LESS THAN (735507) ENGINE = InnoDB,
2447 PARTITION y2013m10 VALUES LESS THAN (735538) ENGINE = InnoDB,
2448 PARTITION y2013m11 VALUES LESS THAN (735568) ENGINE = InnoDB,
2449 PARTITION y2013m12 VALUES LESS THAN (735599) ENGINE = InnoDB,
2450 PARTITION y2014m1 VALUES LESS THAN (735630) ENGINE = InnoDB,
2451 PARTITION y2014m2 VALUES LESS THAN (735658) ENGINE = InnoDB,
2452 PARTITION y2014m3 VALUES LESS THAN (735689) ENGINE = InnoDB,
2453 PARTITION y2014m4 VALUES LESS THAN (735719) ENGINE = InnoDB,
2454 PARTITION y2014m5 VALUES LESS THAN (735750) ENGINE = InnoDB,
2455 PARTITION y2014m6 VALUES LESS THAN (735780) ENGINE = InnoDB,
2456 PARTITION y2014m7 VALUES LESS THAN (735811) ENGINE = InnoDB,
2457 PARTITION y2014m8 VALUES LESS THAN (735842) ENGINE = InnoDB,
2458 PARTITION y2014m9 VALUES LESS THAN (735872) ENGINE = InnoDB,
2459 PARTITION y2014m10 VALUES LESS THAN (735903) ENGINE = InnoDB,
2460 PARTITION y2014m11 VALUES LESS THAN (735933) ENGINE = InnoDB,
2461 PARTITION y2014m12 VALUES LESS THAN (735964) ENGINE = InnoDB,
2462 PARTITION y2015m1 VALUES LESS THAN (735995) ENGINE = InnoDB,
2463 PARTITION y2015m2 VALUES LESS THAN (736023) ENGINE = InnoDB,
2464 PARTITION y2015m3 VALUES LESS THAN (736054) ENGINE = InnoDB,
2465 PARTITION y2015m4 VALUES LESS THAN (736084) ENGINE = InnoDB,
2466 PARTITION y2015m5 VALUES LESS THAN (736115) ENGINE = InnoDB,
2467 PARTITION y2015m6 VALUES LESS THAN (736145) ENGINE = InnoDB,
2468 PARTITION y2015m7 VALUES LESS THAN (736176) ENGINE = InnoDB,
2469 PARTITION y2015m8 VALUES LESS THAN (736207) ENGINE = InnoDB,
2470 PARTITION y2015m9 VALUES LESS THAN (736237) ENGINE = InnoDB,
2471 PARTITION y2015m10 VALUES LESS THAN (736268) ENGINE = InnoDB,
2472 PARTITION y2015m11 VALUES LESS THAN (736298) ENGINE = InnoDB,
2473 PARTITION y2015m12 VALUES LESS THAN (736329) ENGINE = InnoDB,
2474 PARTITION y2016m1 VALUES LESS THAN (736360) ENGINE = InnoDB,
2475 PARTITION y2016m2 VALUES LESS THAN (736389) ENGINE = InnoDB,
2476 PARTITION y2016m3 VALUES LESS THAN (736420) ENGINE = InnoDB,
2477 PARTITION y2016m4 VALUES LESS THAN (736450) ENGINE = InnoDB,
2478 PARTITION y2016m5 VALUES LESS THAN (736481) ENGINE = InnoDB,
2479 PARTITION y2016m6 VALUES LESS THAN (736511) ENGINE = InnoDB,
2480 PARTITION y2016m7 VALUES LESS THAN (736542) ENGINE = InnoDB,
2481 PARTITION y2016m8 VALUES LESS THAN (736573) ENGINE = InnoDB,
2482 PARTITION y2016m9 VALUES LESS THAN (736603) ENGINE = InnoDB,
2483 PARTITION y2016m10 VALUES LESS THAN (736634) ENGINE = InnoDB,
2484 PARTITION y2016m11 VALUES LESS THAN (736664) ENGINE = InnoDB,
2485 PARTITION y2016m12 VALUES LESS THAN (736695) ENGINE = InnoDB,
2486 PARTITION y2017m1 VALUES LESS THAN (736726) ENGINE = InnoDB,
2487 PARTITION y2017m2 VALUES LESS THAN (736754) ENGINE = InnoDB,
2488 PARTITION y2017m3 VALUES LESS THAN (736785) ENGINE = InnoDB,
2489 PARTITION y2017m4 VALUES LESS THAN (736815) ENGINE = InnoDB,
2490 PARTITION y2017m5 VALUES LESS THAN (736846) ENGINE = InnoDB,
2491 PARTITION y2017m6 VALUES LESS THAN (736876) ENGINE = InnoDB,
2492 PARTITION y2017m7 VALUES LESS THAN (736907) ENGINE = InnoDB,
2493 PARTITION y2017m8 VALUES LESS THAN (736938) ENGINE = InnoDB,
2494 PARTITION y2017m9 VALUES LESS THAN (736968) ENGINE = InnoDB,
2495 PARTITION y2017m10 VALUES LESS THAN (736999) ENGINE = InnoDB,
2496 PARTITION y2017m11 VALUES LESS THAN (737029) ENGINE = InnoDB,
2497 PARTITION y2017m12 VALUES LESS THAN (737060) ENGINE = InnoDB,
2498 PARTITION y2018m1 VALUES LESS THAN (737091) ENGINE = InnoDB,
2499 PARTITION y2018m2 VALUES LESS THAN (737119) ENGINE = InnoDB,
2500 PARTITION y2018m3 VALUES LESS THAN (737150) ENGINE = InnoDB,
2501 PARTITION y2018m4 VALUES LESS THAN (737180) ENGINE = InnoDB,
2502 PARTITION y2018m5 VALUES LESS THAN (737211) ENGINE = InnoDB,
2503 PARTITION y2018m6 VALUES LESS THAN (737241) ENGINE = InnoDB,
2504 PARTITION y2018m7 VALUES LESS THAN (737272) ENGINE = InnoDB,
2505 PARTITION y2018m8 VALUES LESS THAN (737303) ENGINE = InnoDB,
2506 PARTITION y2018m9 VALUES LESS THAN (737333) ENGINE = InnoDB,
2507 PARTITION y2018m10 VALUES LESS THAN (737364) ENGINE = InnoDB,
2508 PARTITION y2018m11 VALUES LESS THAN (737394) ENGINE = InnoDB,
2509 PARTITION y2018m12 VALUES LESS THAN (737425) ENGINE = InnoDB,
2510 PARTITION y2019m1 VALUES LESS THAN (737456) ENGINE = InnoDB,
2511 PARTITION y2019m2 VALUES LESS THAN (737484) ENGINE = InnoDB,
2512 PARTITION y2019m3 VALUES LESS THAN (737515) ENGINE = InnoDB,
2513 PARTITION y2019m4 VALUES LESS THAN (737545) ENGINE = InnoDB,
2514 PARTITION y2019m5 VALUES LESS THAN (737576) ENGINE = InnoDB,
2515 PARTITION y2019m6 VALUES LESS THAN (737606) ENGINE = InnoDB,
2516 PARTITION y2019m7 VALUES LESS THAN (737637) ENGINE = InnoDB,
2517 PARTITION y2019m8 VALUES LESS THAN (737668) ENGINE = InnoDB,
2518 PARTITION y2019m9 VALUES LESS THAN (737698) ENGINE = InnoDB,
2519 PARTITION y2019m10 VALUES LESS THAN (737729) ENGINE = InnoDB,
2520 PARTITION y2019m11 VALUES LESS THAN (737759) ENGINE = InnoDB,
2521 PARTITION y2019m12 VALUES LESS THAN (737790) ENGINE = InnoDB) */ AUTO_INCREMENT=675376 ;
2522
2523-- --------------------------------------------------------
2524
2525--
2526-- Table structure for table `t_statistics_hide_ads`
2527--
2528
2529CREATE TABLE IF NOT EXISTS `t_statistics_hide_ads` (
2530  `id` bigint(20) NOT NULL AUTO_INCREMENT,
2531  `player_id` int(11) DEFAULT NULL,
2532  `log_date` date NOT NULL DEFAULT '0000-00-00',
2533  `video_id` int(11) DEFAULT NULL,
2534  `country_code` varchar(2) NOT NULL DEFAULT '',
2535  `ad_company_id` int(11) DEFAULT NULL,
2536  `ad_shows` int(11) NOT NULL DEFAULT '0',
2537  PRIMARY KEY (`id`,`log_date`),
2538  UNIQUE KEY `player_id` (`player_id`,`log_date`,`video_id`,`country_code`,`ad_company_id`)
2539) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Табличка статистики скрытой рекламы'
2540/*!50100 PARTITION BY RANGE ( TO_DAYS(log_date))
2541(PARTITION y2015m1 VALUES LESS THAN (735995) ENGINE = InnoDB,
2542 PARTITION y2015m2 VALUES LESS THAN (736023) ENGINE = InnoDB,
2543 PARTITION y2015m3 VALUES LESS THAN (736054) ENGINE = InnoDB,
2544 PARTITION y2015m4 VALUES LESS THAN (736084) ENGINE = InnoDB,
2545 PARTITION y2015m5 VALUES LESS THAN (736115) ENGINE = InnoDB,
2546 PARTITION y2015m6 VALUES LESS THAN (736145) ENGINE = InnoDB,
2547 PARTITION y2015m7 VALUES LESS THAN (736176) ENGINE = InnoDB,
2548 PARTITION y2015m8 VALUES LESS THAN (736207) ENGINE = InnoDB,
2549 PARTITION y2015m9 VALUES LESS THAN (736237) ENGINE = InnoDB,
2550 PARTITION y2015m10 VALUES LESS THAN (736268) ENGINE = InnoDB,
2551 PARTITION y2015m11 VALUES LESS THAN (736298) ENGINE = InnoDB,
2552 PARTITION y2015m12 VALUES LESS THAN (736329) ENGINE = InnoDB,
2553 PARTITION y2016m1 VALUES LESS THAN (736360) ENGINE = InnoDB,
2554 PARTITION y2016m2 VALUES LESS THAN (736389) ENGINE = InnoDB,
2555 PARTITION y2016m3 VALUES LESS THAN (736420) ENGINE = InnoDB,
2556 PARTITION y2016m4 VALUES LESS THAN (736450) ENGINE = InnoDB,
2557 PARTITION y2016m5 VALUES LESS THAN (736481) ENGINE = InnoDB,
2558 PARTITION y2016m6 VALUES LESS THAN (736511) ENGINE = InnoDB,
2559 PARTITION y2016m7 VALUES LESS THAN (736542) ENGINE = InnoDB,
2560 PARTITION y2016m8 VALUES LESS THAN (736573) ENGINE = InnoDB,
2561 PARTITION y2016m9 VALUES LESS THAN (736603) ENGINE = InnoDB,
2562 PARTITION y2016m10 VALUES LESS THAN (736634) ENGINE = InnoDB,
2563 PARTITION y2016m11 VALUES LESS THAN (736664) ENGINE = InnoDB,
2564 PARTITION y2016m12 VALUES LESS THAN (736695) ENGINE = InnoDB,
2565 PARTITION y2017m1 VALUES LESS THAN (736726) ENGINE = InnoDB,
2566 PARTITION y2017m2 VALUES LESS THAN (736754) ENGINE = InnoDB,
2567 PARTITION y2017m3 VALUES LESS THAN (736785) ENGINE = InnoDB,
2568 PARTITION y2017m4 VALUES LESS THAN (736815) ENGINE = InnoDB,
2569 PARTITION y2017m5 VALUES LESS THAN (736846) ENGINE = InnoDB,
2570 PARTITION y2017m6 VALUES LESS THAN (736876) ENGINE = InnoDB,
2571 PARTITION y2017m7 VALUES LESS THAN (736907) ENGINE = InnoDB,
2572 PARTITION y2017m8 VALUES LESS THAN (736938) ENGINE = InnoDB,
2573 PARTITION y2017m9 VALUES LESS THAN (736968) ENGINE = InnoDB,
2574 PARTITION y2017m10 VALUES LESS THAN (736999) ENGINE = InnoDB,
2575 PARTITION y2017m11 VALUES LESS THAN (737029) ENGINE = InnoDB,
2576 PARTITION y2017m12 VALUES LESS THAN (737060) ENGINE = InnoDB,
2577 PARTITION y2018m1 VALUES LESS THAN (737091) ENGINE = InnoDB,
2578 PARTITION y2018m2 VALUES LESS THAN (737119) ENGINE = InnoDB,
2579 PARTITION y2018m3 VALUES LESS THAN (737150) ENGINE = InnoDB,
2580 PARTITION y2018m4 VALUES LESS THAN (737180) ENGINE = InnoDB,
2581 PARTITION y2018m5 VALUES LESS THAN (737211) ENGINE = InnoDB,
2582 PARTITION y2018m6 VALUES LESS THAN (737241) ENGINE = InnoDB,
2583 PARTITION y2018m7 VALUES LESS THAN (737272) ENGINE = InnoDB,
2584 PARTITION y2018m8 VALUES LESS THAN (737303) ENGINE = InnoDB,
2585 PARTITION y2018m9 VALUES LESS THAN (737333) ENGINE = InnoDB,
2586 PARTITION y2018m10 VALUES LESS THAN (737364) ENGINE = InnoDB,
2587 PARTITION y2018m11 VALUES LESS THAN (737394) ENGINE = InnoDB,
2588 PARTITION y2018m12 VALUES LESS THAN (737425) ENGINE = InnoDB,
2589 PARTITION y2019m1 VALUES LESS THAN (737456) ENGINE = InnoDB,
2590 PARTITION y2019m2 VALUES LESS THAN (737484) ENGINE = InnoDB,
2591 PARTITION y2019m3 VALUES LESS THAN (737515) ENGINE = InnoDB,
2592 PARTITION y2019m4 VALUES LESS THAN (737545) ENGINE = InnoDB,
2593 PARTITION y2019m5 VALUES LESS THAN (737576) ENGINE = InnoDB,
2594 PARTITION y2019m6 VALUES LESS THAN (737606) ENGINE = InnoDB,
2595 PARTITION y2019m7 VALUES LESS THAN (737637) ENGINE = InnoDB,
2596 PARTITION y2019m8 VALUES LESS THAN (737668) ENGINE = InnoDB,
2597 PARTITION y2019m9 VALUES LESS THAN (737698) ENGINE = InnoDB,
2598 PARTITION y2019m10 VALUES LESS THAN (737729) ENGINE = InnoDB,
2599 PARTITION y2019m11 VALUES LESS THAN (737759) ENGINE = InnoDB,
2600 PARTITION y2019m12 VALUES LESS THAN (737790) ENGINE = InnoDB) */ AUTO_INCREMENT=45526 ;
2601
2602-- --------------------------------------------------------
2603
2604--
2605-- Table structure for table `t_statistics_hour`
2606--
2607
2608CREATE TABLE IF NOT EXISTS `t_statistics_hour` (
2609  `id` bigint(20) NOT NULL AUTO_INCREMENT,
2610  `log_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата с градацией по часам',
2611  `ad_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'Кол-во показов рекламы',
2612  `video_shows` int(11) NOT NULL DEFAULT '0' COMMENT 'Кол-во показов видео',
2613  PRIMARY KEY (`id`),
2614  UNIQUE KEY `log_date_idx` (`log_date`)
2615) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Статистика по часам' AUTO_INCREMENT=7729639 ;
2616
2617-- --------------------------------------------------------
2618
2619--
2620-- Table structure for table `user_history`
2621--
2622
2623CREATE TABLE IF NOT EXISTS `user_history` (
2624  `id` int(11) NOT NULL AUTO_INCREMENT,
2625  `user_id` int(11) NOT NULL COMMENT 'ID пользователя',
2626  `action` int(11) DEFAULT NULL COMMENT 'действие',
2627  `comment` text NOT NULL COMMENT 'Комментарий',
2628  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата события',
2629  `request` text NOT NULL COMMENT 'запрос',
2630  `ip` varchar(15) NOT NULL DEFAULT '' COMMENT 'IP адрес пользователя',
2631  `useragent` text NOT NULL COMMENT 'User-agent',
2632  `referer` text NOT NULL COMMENT 'Рефер',
2633  PRIMARY KEY (`id`),
2634  KEY `user_id_idx` (`user_id`)
2635) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Действия партнера' AUTO_INCREMENT=599 ;
2636
2637-- --------------------------------------------------------
2638
2639--
2640-- Table structure for table `user_rightholder_meta`
2641--
2642
2643CREATE TABLE IF NOT EXISTS `user_rightholder_meta` (
2644  `user_id` int(11) NOT NULL COMMENT 'ID пользователя',
2645  `responsible_user_id` int(11) DEFAULT NULL COMMENT 'ID отвественного лица',
2646  `contract_start_date` date DEFAULT NULL COMMENT 'Начало контракта',
2647  `contract_end_date` date DEFAULT NULL COMMENT 'Окончание контракта',
2648  `contract_num` varchar(16) DEFAULT NULL COMMENT 'Номер договора',
2649  `contract_auto` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Автопролонгация контракта',
2650  `content_type_id` int(11) DEFAULT NULL COMMENT 'ID типа контента',
2651  `documents` text NOT NULL COMMENT 'JSON массив документов',
2652  `contacts` text NOT NULL COMMENT 'Контакты (json объект определяемый фронтэндом)',
2653  PRIMARY KEY (`user_id`),
2654  KEY `responsible_user_id_idx` (`responsible_user_id`),
2655  KEY `contract_end_date_idx` (`contract_end_date`),
2656  KEY `content_type_id_idx` (`content_type_id`)
2657) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Правообладательская мета информация ';
2658
2659-- --------------------------------------------------------
2660
2661--
2662-- Table structure for table `videolib_ad_params`
2663--
2664
2665CREATE TABLE IF NOT EXISTS `videolib_ad_params` (
2666  `id` int(11) NOT NULL AUTO_INCREMENT,
2667  `video_id` int(11) NOT NULL COMMENT 'видео или копия в системе',
2668  `key` varchar(64) NOT NULL COMMENT 'ключ',
2669  `value` varchar(512) NOT NULL COMMENT 'значение',
2670  PRIMARY KEY (`id`),
2671  UNIQUE KEY `video_id_key` (`video_id`,`key`),
2672  KEY `video_id` (`video_id`)
2673) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='таблица рекламных параметров для видео' AUTO_INCREMENT=50251117 ;
2674
2675-- --------------------------------------------------------
2676
2677--
2678-- Table structure for table `videolib_cat2sites_disable_remove`
2679--
2680
2681CREATE TABLE IF NOT EXISTS `videolib_cat2sites_disable_remove` (
2682  `videolib_category_id` int(11) NOT NULL COMMENT 'ID категории',
2683  `site_id` int(11) DEFAULT NULL COMMENT 'ID площадки',
2684  KEY `site_id` (`site_id`),
2685  KEY `videolib_category_id` (`videolib_category_id`)
2686) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='таблица блокировки показа категорий к площадкам';
2687
2688-- --------------------------------------------------------
2689
2690--
2691-- Table structure for table `videolib_categories`
2692--
2693
2694CREATE TABLE IF NOT EXISTS `videolib_categories` (
2695  `id` int(11) NOT NULL AUTO_INCREMENT,
2696  `parent_id` int(11) DEFAULT NULL,
2697  `videolib_owner_id` int(11) DEFAULT NULL,
2698  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Состояние категории',
2699  `title` varchar(255) NOT NULL,
2700  `description` text,
2701  `cover` varchar(255) DEFAULT NULL,
2702  `type_id` int(11) DEFAULT NULL COMMENT 'ID типа',
2703  `start_date` timestamp NULL DEFAULT NULL COMMENT 'Дата начала вещания',
2704  `end_date` timestamp NULL DEFAULT NULL COMMENT 'Дата окончания вещания',
2705  `sort` bigint(20) DEFAULT NULL COMMENT 'Порядок сортировки',
2706  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата создания',
2707  PRIMARY KEY (`id`),
2708  KEY `parent_id` (`parent_id`),
2709  KEY `videolib_owner_id` (`videolib_owner_id`),
2710  KEY `sort_idx` (`sort`),
2711  KEY `state` (`state`),
2712  KEY `type_id` (`type_id`),
2713  KEY `end_date` (`end_date`),
2714  KEY `start_date_idx` (`start_date`)
2715) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Категории видеотеки' AUTO_INCREMENT=110051667 ;
2716
2717-- --------------------------------------------------------
2718
2719--
2720-- Table structure for table `videolib_categories2countries`
2721--
2722
2723CREATE TABLE IF NOT EXISTS `videolib_categories2countries` (
2724  `category_id` int(11) NOT NULL COMMENT 'ID категории',
2725  `country_code` varchar(2) NOT NULL COMMENT 'Двухзначный код страны',
2726  PRIMARY KEY (`category_id`,`country_code`),
2727  KEY `category_id_idx` (`category_id`) USING BTREE
2728) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Права стран для категорий';
2729
2730-- --------------------------------------------------------
2731
2732--
2733-- Table structure for table `videolib_categories2sites`
2734--
2735
2736CREATE TABLE IF NOT EXISTS `videolib_categories2sites` (
2737  `videolib_category_id` int(11) NOT NULL COMMENT 'ID категории',
2738  `site_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID площадки',
2739  PRIMARY KEY (`videolib_category_id`,`site_id`),
2740  KEY `site_id_idx` (`site_id`),
2741  KEY `videolib_category_id_idx` (`videolib_category_id`)
2742) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='таблица активности категории для площадки';
2743
2744-- --------------------------------------------------------
2745
2746--
2747-- Table structure for table `videolib_category2genre`
2748--
2749
2750CREATE TABLE IF NOT EXISTS `videolib_category2genre` (
2751  `genre_id` int(11) NOT NULL,
2752  `category_id` int(11) NOT NULL,
2753  PRIMARY KEY (`genre_id`,`category_id`),
2754  KEY `genre_id` (`genre_id`),
2755  KEY `category_id` (`category_id`)
2756) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='отношения категории к жанру';
2757
2758-- --------------------------------------------------------
2759
2760--
2761-- Table structure for table `videolib_countries_origin`
2762--
2763
2764CREATE TABLE IF NOT EXISTS `videolib_countries_origin` (
2765  `video_id` int(11) NOT NULL COMMENT 'ID пользователя',
2766  `country_code` varchar(2) NOT NULL COMMENT 'Двухсимвольный код страны',
2767  PRIMARY KEY (`video_id`,`country_code`)
2768) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Таблица со странами производства видео';
2769
2770-- --------------------------------------------------------
2771
2772--
2773-- Table structure for table `videolib_durations`
2774--
2775
2776CREATE TABLE IF NOT EXISTS `videolib_durations` (
2777  `id` int(11) NOT NULL AUTO_INCREMENT,
2778  `title` varchar(255) NOT NULL,
2779  `start_second` int(11) NOT NULL DEFAULT '0',
2780  `end_second` int(11) NOT NULL DEFAULT '0',
2781  PRIMARY KEY (`id`)
2782) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Длительность' AUTO_INCREMENT=7 ;
2783
2784-- --------------------------------------------------------
2785
2786--
2787-- Table structure for table `videolib_exchange`
2788--
2789
2790CREATE TABLE IF NOT EXISTS `videolib_exchange` (
2791  `id` int(11) NOT NULL AUTO_INCREMENT,
2792  `video_id` bigint(20) NOT NULL COMMENT 'ID видео',
2793  `price` decimal(12,4) NOT NULL COMMENT 'Доп. цена для видео',
2794  PRIMARY KEY (`id`),
2795  UNIQUE KEY `video_id_idx` (`video_id`)
2796) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Таблица цен для видео - биржа' AUTO_INCREMENT=1 ;
2797
2798-- --------------------------------------------------------
2799
2800--
2801-- Table structure for table `videolib_ext_params`
2802--
2803
2804CREATE TABLE IF NOT EXISTS `videolib_ext_params` (
2805  `id` int(11) NOT NULL AUTO_INCREMENT,
2806  `video_id` int(11) NOT NULL COMMENT 'видео или копия в системе',
2807  `key` varchar(64) NOT NULL COMMENT 'ключ',
2808  `value` varchar(64) NOT NULL COMMENT 'значение',
2809  PRIMARY KEY (`id`),
2810  UNIQUE KEY `video_id_key` (`video_id`,`key`),
2811  KEY `video_id` (`video_id`)
2812) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='таблица спец. параметров для видео' AUTO_INCREMENT=5 ;
2813
2814-- --------------------------------------------------------
2815
2816--
2817-- Table structure for table `videolib_genre2video`
2818--
2819
2820CREATE TABLE IF NOT EXISTS `videolib_genre2video` (
2821  `id` int(11) NOT NULL AUTO_INCREMENT,
2822  `genre_id` int(11) NOT NULL,
2823  `video_id` int(11) NOT NULL,
2824  PRIMARY KEY (`id`),
2825  KEY `genre_video_idx` (`genre_id`,`video_id`),
2826  KEY `video_id_idx` (`video_id`)
2827) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='отношения жанра и видео' AUTO_INCREMENT=311134 ;
2828
2829-- --------------------------------------------------------
2830
2831--
2832-- Table structure for table `videolib_genres`
2833--
2834
2835CREATE TABLE IF NOT EXISTS `videolib_genres` (
2836  `id` int(11) NOT NULL AUTO_INCREMENT,
2837  `title` varchar(255) NOT NULL,
2838  PRIMARY KEY (`id`)
2839) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='жанры видео' AUTO_INCREMENT=112 ;
2840
2841-- --------------------------------------------------------
2842
2843--
2844-- Table structure for table `videolib_geo_rules`
2845--
2846
2847CREATE TABLE IF NOT EXISTS `videolib_geo_rules` (
2848  `id` int(11) NOT NULL AUTO_INCREMENT,
2849  `video_id` int(11) NOT NULL,
2850  `country_code` varchar(2) NOT NULL,
2851  PRIMARY KEY (`id`),
2852  UNIQUE KEY `video_id_idx` (`video_id`,`country_code`)
2853) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=156102790 ;
2854
2855-- --------------------------------------------------------
2856
2857--
2858-- Table structure for table `videolib_midpoints`
2859--
2860
2861CREATE TABLE IF NOT EXISTS `videolib_midpoints` (
2862  `id` int(11) NOT NULL AUTO_INCREMENT,
2863  `video_id` int(11) NOT NULL COMMENT 'ID видео',
2864  `time` int(11) NOT NULL COMMENT 'секунда размещения',
2865  PRIMARY KEY (`id`),
2866  KEY `video_id_idx` (`video_id`)
2867) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Мидпоинты (время размещения) видео ' AUTO_INCREMENT=580782 ;
2868
2869-- --------------------------------------------------------
2870
2871--
2872-- Table structure for table `videolib_persons`
2873--
2874
2875CREATE TABLE IF NOT EXISTS `videolib_persons` (
2876  `id` int(11) NOT NULL AUTO_INCREMENT,
2877  `video_id` int(11) NOT NULL,
2878  `name` varchar(255) NOT NULL,
2879  `surname` varchar(255) NOT NULL,
2880  `imdb_id` int(11) DEFAULT NULL,
2881  `kinopoisk_id` int(11) DEFAULT NULL,
2882  `type` enum('director','producer','scenario','operator','actor') CHARACTER SET utf8 NOT NULL,
2883  `role` varchar(255) CHARACTER SET utf8 NOT NULL,
2884  PRIMARY KEY (`id`),
2885  KEY `video_id` (`video_id`,`type`,`role`)
2886) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4819117 ;
2887
2888-- --------------------------------------------------------
2889
2890--
2891-- Table structure for table `videolib_season2genre`
2892--
2893
2894CREATE TABLE IF NOT EXISTS `videolib_season2genre` (
2895  `season_id` int(11) NOT NULL COMMENT 'ID сезона из таблицы videolib_seasons',
2896  `genre_id` int(11) NOT NULL COMMENT 'ID жанра из таблицы videolib_genres',
2897  PRIMARY KEY (`season_id`,`genre_id`)
2898) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Таблица связей сезонов с жанрами';
2899
2900-- --------------------------------------------------------
2901
2902--
2903-- Table structure for table `videolib_season2sites`
2904--
2905
2906CREATE TABLE IF NOT EXISTS `videolib_season2sites` (
2907  `season_id` int(11) NOT NULL COMMENT 'ID сезона',
2908  `site_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID площадки',
2909  PRIMARY KEY (`season_id`,`site_id`),
2910  KEY `season_id_idx` (`season_id`),
2911  KEY `site_id_idx` (`site_id`)
2912) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2913
2914-- --------------------------------------------------------
2915
2916--
2917-- Table structure for table `videolib_seasons`
2918--
2919
2920CREATE TABLE IF NOT EXISTS `videolib_seasons` (
2921  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
2922  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Название сезона',
2923  `category_id` int(11) NOT NULL COMMENT 'ID категории (проекта)',
2924  `cover` varchar(255) DEFAULT NULL COMMENT 'Путь до обложки сезона',
2925  `num` int(11) unsigned DEFAULT NULL,
2926  `description` text COMMENT 'Описание сезона',
2927  `state` int(1) DEFAULT NULL COMMENT 'Статус сезона',
2928  PRIMARY KEY (`id`),
2929  UNIQUE KEY `idx_category_num` (`category_id`,`num`),
2930  KEY `category_id` (`category_id`),
2931  KEY `idx_sort` (`num`)
2932) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Таблица с сезонами видео' AUTO_INCREMENT=2868 ;
2933
2934-- --------------------------------------------------------
2935
2936--
2937-- Table structure for table `videolib_seasons2countries`
2938--
2939
2940CREATE TABLE IF NOT EXISTS `videolib_seasons2countries` (
2941  `season_id` int(11) NOT NULL COMMENT 'ID сезона',
2942  `country_code` varchar(2) NOT NULL COMMENT 'Символьный код страны',
2943  PRIMARY KEY (`season_id`,`country_code`),
2944  KEY `season_id_idx` (`season_id`)
2945) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2946
2947-- --------------------------------------------------------
2948
2949--
2950-- Table structure for table `videolib_selection`
2951--
2952
2953CREATE TABLE IF NOT EXISTS `videolib_selection` (
2954  `id` int(11) NOT NULL AUTO_INCREMENT,
2955  `title` varchar(255) NOT NULL COMMENT 'Наименование подборки',
2956  `cover` text NOT NULL COMMENT 'Обложка подборки',
2957  PRIMARY KEY (`id`)
2958) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Видеоподборки' AUTO_INCREMENT=1 ;
2959
2960-- --------------------------------------------------------
2961
2962--
2963-- Table structure for table `videolib_selection_items`
2964--
2965
2966CREATE TABLE IF NOT EXISTS `videolib_selection_items` (
2967  `id` int(11) NOT NULL AUTO_INCREMENT,
2968  `selection_id` int(11) NOT NULL COMMENT 'ID подборки',
2969  `video_id` int(11) NOT NULL COMMENT 'ID видео',
2970  PRIMARY KEY (`id`),
2971  KEY `selection_id_idx` (`selection_id`)
2972) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Видео видеоподборки' AUTO_INCREMENT=1 ;
2973
2974-- --------------------------------------------------------
2975
2976--
2977-- Table structure for table `videolib_storage`
2978--
2979
2980CREATE TABLE IF NOT EXISTS `videolib_storage` (
2981  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
2982  `uri` varchar(2048) DEFAULT NULL,
2983  PRIMARY KEY (`id`)
2984) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
2985
2986-- --------------------------------------------------------
2987
2988--
2989-- Table structure for table `videolib_thematic2video`
2990--
2991
2992CREATE TABLE IF NOT EXISTS `videolib_thematic2video` (
2993  `id` int(11) NOT NULL AUTO_INCREMENT,
2994  `videolib_thematic_id` int(11) NOT NULL,
2995  `videolib_video_id` int(11) NOT NULL,
2996  PRIMARY KEY (`id`),
2997  KEY `videolib_thematic_id` (`videolib_thematic_id`,`videolib_video_id`),
2998  KEY `videolib_video_id` (`videolib_video_id`)
2999) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='отношения тематики и видео' AUTO_INCREMENT=6034175 ;
3000
3001-- --------------------------------------------------------
3002
3003--
3004-- Table structure for table `videolib_thematics`
3005--
3006
3007CREATE TABLE IF NOT EXISTS `videolib_thematics` (
3008  `id` int(11) NOT NULL AUTO_INCREMENT,
3009  `title` varchar(255) NOT NULL,
3010  `adfox_thematic_id` int(11) DEFAULT NULL,
3011  PRIMARY KEY (`id`)
3012) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='тематики видео' AUTO_INCREMENT=32 ;
3013
3014-- --------------------------------------------------------
3015
3016--
3017-- Table structure for table `videolib_type2genre`
3018--
3019
3020CREATE TABLE IF NOT EXISTS `videolib_type2genre` (
3021  `type_id` int(11) NOT NULL,
3022  `genre_id` int(11) NOT NULL,
3023  UNIQUE KEY `type_id_idx` (`type_id`,`genre_id`)
3024) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='набор жанров доступных для типа видео';
3025
3026-- --------------------------------------------------------
3027
3028--
3029-- Table structure for table `videolib_types`
3030--
3031
3032CREATE TABLE IF NOT EXISTS `videolib_types` (
3033  `id` int(11) NOT NULL AUTO_INCREMENT,
3034  `title` varchar(255) NOT NULL COMMENT 'Наименование',
3035  PRIMARY KEY (`id`)
3036) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Типы видео' AUTO_INCREMENT=11 ;
3037
3038-- --------------------------------------------------------
3039
3040--
3041-- Table structure for table `videolib_users2sites_remove`
3042--
3043
3044CREATE TABLE IF NOT EXISTS `videolib_users2sites_remove` (
3045  `id` int(11) NOT NULL AUTO_INCREMENT,
3046  `user_id` int(11) DEFAULT NULL COMMENT 'правообладатель',
3047  `site_id` int(11) DEFAULT NULL COMMENT 'ID площадки для которого разрешено видео',
3048  PRIMARY KEY (`id`),
3049  KEY `site_id_idx` (`site_id`),
3050  KEY `user_id_idx` (`user_id`)
3051) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Удалить после обновления' AUTO_INCREMENT=32392 ;
3052
3053-- --------------------------------------------------------
3054
3055--
3056-- Table structure for table `videolib_video2tag`
3057--
3058
3059CREATE TABLE IF NOT EXISTS `videolib_video2tag` (
3060  `video_id` int(11) NOT NULL COMMENT 'ID видео',
3061  `tag_id` int(11) NOT NULL COMMENT 'ID тега',
3062  PRIMARY KEY (`video_id`,`tag_id`)
3063) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Отношение видео к тегу';
3064
3065-- --------------------------------------------------------
3066
3067--
3068-- Table structure for table `videolib_videos`
3069--
3070
3071CREATE TABLE IF NOT EXISTS `videolib_videos` (
3072  `id` int(11) NOT NULL,
3073  `original_id` varchar(255) DEFAULT NULL,
3074  `type_id` int(11) DEFAULT NULL COMMENT 'ID типа видео (videolib_types)',
3075  `videolib_category_id` int(11) NOT NULL,
3076  `videolib_owner_id` int(11) DEFAULT NULL,
3077  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата добавления видео',
3078  `publish_date` timestamp NULL DEFAULT NULL COMMENT 'Дата публикации видео',
3079  `search_string` text NOT NULL,
3080  `title` varchar(255) NOT NULL,
3081  `description` text NOT NULL,
3082  `cover` varchar(255) DEFAULT NULL,
3083  `embed` text NOT NULL,
3084  `duration` int(11) NOT NULL DEFAULT '0',
3085  `age` tinyint(1) NOT NULL DEFAULT '0',
3086  `is_publish` tinyint(1) NOT NULL DEFAULT '0',
3087  `start_date` timestamp NULL DEFAULT NULL,
3088  `end_date` timestamp NULL DEFAULT NULL,
3089  `sort` bigint(20) NOT NULL DEFAULT '0',
3090  `season_num` int(11) NOT NULL DEFAULT '0',
3091  `ctr` int(11) NOT NULL DEFAULT '0' COMMENT 'CTR видео',
3092  `sellout` int(11) NOT NULL DEFAULT '0' COMMENT 'Sellout видео',
3093  `ecpm` int(11) NOT NULL DEFAULT '0' COMMENT 'ECPM видео',
3094  `price` decimal(10,4) NOT NULL DEFAULT '0.0000' COMMENT 'Денормализованная наценка для видео (оригинал в price_video)',
3095  `season_id` int(11) DEFAULT NULL COMMENT 'ID cезонa',
3096  `episode` smallint(11) DEFAULT NULL COMMENT 'Серия',
3097  `system_state` int(11) DEFAULT NULL COMMENT 'Системный статус видео',
3098  PRIMARY KEY (`id`),
3099  KEY `videolib_category_id` (`videolib_category_id`),
3100  KEY `is_publish` (`is_publish`),
3101  KEY `videolib_owner_id` (`videolib_owner_id`),
3102  KEY `sort` (`sort`),
3103  KEY `type_id_idx` (`type_id`),
3104  KEY `start_date` (`start_date`),
3105  KEY `end_date` (`end_date`),
3106  KEY `season_id` (`season_id`)
3107) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Видео видеотеки';
3108
3109-- --------------------------------------------------------
3110
3111--
3112-- Table structure for table `videolib_videos2sites`
3113--
3114
3115CREATE TABLE IF NOT EXISTS `videolib_videos2sites` (
3116  `videolib_video_id` int(11) NOT NULL COMMENT 'ID видео',
3117  `site_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID площадки для которого разрешено видео',
3118  PRIMARY KEY (`videolib_video_id`,`site_id`),
3119  KEY `site_id_idx` (`site_id`),
3120  KEY `videolib_videos_id_idx` (`videolib_video_id`)
3121) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Доступность видео партнерам';
3122
3123-- --------------------------------------------------------
3124
3125--
3126-- Table structure for table `videolib_videos_copies`
3127--
3128
3129CREATE TABLE IF NOT EXISTS `videolib_videos_copies` (
3130  `id` int(11) NOT NULL,
3131  `type` enum('vk.com') DEFAULT NULL COMMENT 'тип системы, откуда видео',
3132  `state` int(11) NOT NULL DEFAULT '1' COMMENT 'Статус копии',
3133  `original_id` varchar(255) NOT NULL COMMENT 'оригинальный ID видео',
3134  `user_id` int(11) DEFAULT NULL COMMENT 'Владелец копии видео',
3135  `video_id` int(11) DEFAULT NULL COMMENT 'ID видео, на которую данная копия',
3136  `parent_id` int(11) DEFAULT NULL COMMENT 'ID родителя, на которую сделали замену',
3137  `title` varchar(255) NOT NULL COMMENT 'наименование ролика',
3138  `cover` varchar(255) NOT NULL COMMENT 'картинка',
3139  `landing` text NOT NULL COMMENT 'урл размещения',
3140  `embed` text NOT NULL COMMENT 'Эмбед плеера',
3141  `duration` int(11) NOT NULL DEFAULT '0' COMMENT 'длительность',
3142  `category_id` int(11) DEFAULT NULL,
3143  PRIMARY KEY (`id`),
3144  UNIQUE KEY `type_original_id_idx` (`type`,`original_id`),
3145  KEY `user_id_idx` (`user_id`)
3146) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Видео видеотеки';
3147
3148-- --------------------------------------------------------
3149
3150--
3151-- Table structure for table `videolib_videos_distribution`
3152--
3153
3154CREATE TABLE IF NOT EXISTS `videolib_videos_distribution` (
3155  `video_id` int(11) NOT NULL COMMENT 'ID видео',
3156  `method` varchar(16) NOT NULL DEFAULT '' COMMENT 'метод раздачи - video,api,rutube  и т.д.',
3157  `quality` enum('240p','360p','576p','720p','1080p') NOT NULL COMMENT 'качество раздачи',
3158  `source` varchar(255) NOT NULL COMMENT 'источник раздачи',
3159  PRIMARY KEY (`video_id`,`method`,`quality`),
3160  UNIQUE KEY `video_id_quality_idx` (`video_id`,`quality`),
3161  KEY `video_id_idx` (`video_id`)
3162) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Таблица хранения источников раздачи видео';
3163
3164-- --------------------------------------------------------
3165
3166--
3167-- Table structure for table `videolib_videos_log`
3168--
3169
3170CREATE TABLE IF NOT EXISTS `videolib_videos_log` (
3171  `id` int(11) NOT NULL,
3172  `video_id` int(11) NOT NULL COMMENT 'ID видео',
3173  `action` varchar(64) NOT NULL COMMENT 'действие',
3174  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'дата действия',
3175  `comment` text NOT NULL COMMENT 'комментарий',
3176  PRIMARY KEY (`id`),
3177  KEY `video_id_idx` (`video_id`)
3178) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Лог действий над видео';
3179
3180-- --------------------------------------------------------
3181
3182--
3183-- Table structure for table `videolib_videos_mxf`
3184--
3185
3186CREATE TABLE IF NOT EXISTS `videolib_videos_mxf` (
3187  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
3188  `video_id` int(11) NOT NULL,
3189  `intervals` text,
3190  PRIMARY KEY (`id`)
3191) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Данные из MXF-формата' AUTO_INCREMENT=13 ;
3192
3193-- --------------------------------------------------------
3194
3195--
3196-- Table structure for table `videolib_videos_params`
3197--
3198
3199CREATE TABLE IF NOT EXISTS `videolib_videos_params` (
3200  `id` int(11) NOT NULL AUTO_INCREMENT,
3201  `videolib_video_id` int(11) NOT NULL COMMENT 'ID видео',
3202  `key` varchar(255) NOT NULL COMMENT 'ключ',
3203  `value` text NOT NULL COMMENT 'значение',
3204  PRIMARY KEY (`id`),
3205  UNIQUE KEY `video_id_key` (`videolib_video_id`,`key`),
3206  KEY `videolib_video_id` (`videolib_video_id`),
3207  KEY `key` (`key`)
3208) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Параметры видео' AUTO_INCREMENT=18477192 ;
3209
3210-- --------------------------------------------------------
3211
3212--
3213-- Table structure for table `videolib_videos_persons`
3214--
3215
3216CREATE TABLE IF NOT EXISTS `videolib_videos_persons` (
3217  `id` int(11) NOT NULL AUTO_INCREMENT,
3218  `video_id` int(11) NOT NULL,
3219  `person_id` int(11) NOT NULL,
3220  `type` enum('director','producer','scenario','operator','actor') CHARACTER SET utf8 NOT NULL,
3221  `role` varchar(255) CHARACTER SET utf8 NOT NULL,
3222  PRIMARY KEY (`id`),
3223  KEY `video_id` (`video_id`,`person_id`,`type`,`role`)
3224) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
3225
3226-- --------------------------------------------------------
3227
3228--
3229-- Table structure for table `videolib_video_id`
3230--
3231
3232CREATE TABLE IF NOT EXISTS `videolib_video_id` (
3233  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'регистрируемый ID',
3234  `target` enum('original','copies') NOT NULL COMMENT 'маркер таблицы, в которой находится видео',
3235  `source` enum('rightholder','vk','nowru') DEFAULT NULL COMMENT 'источник видео',
3236  `user_id` int(11) DEFAULT NULL COMMENT 'ID владельца видео',
3237  PRIMARY KEY (`id`)
3238) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='таблица регистрации видео ID' AUTO_INCREMENT=1000938104 ;
3239
3240-- --------------------------------------------------------
3241
3242--
3243-- Table structure for table `video_covers`
3244--
3245
3246CREATE TABLE IF NOT EXISTS `video_covers` (
3247  `id` int(11) NOT NULL AUTO_INCREMENT,
3248  `video_id` int(11) NOT NULL COMMENT 'ID видео',
3249  `filename` varchar(255) NOT NULL COMMENT 'Имя файла обложки',
3250  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата добавления',
3251  PRIMARY KEY (`id`),
3252  KEY `video_id_idx` (`video_id`)
3253) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Обложки для видео' AUTO_INCREMENT=678 ;
3254
3255-- --------------------------------------------------------
3256
3257--
3258-- Table structure for table `video_events`
3259--
3260
3261CREATE TABLE IF NOT EXISTS `video_events` (
3262  `id` int(11) NOT NULL AUTO_INCREMENT,
3263  `video_id` int(11) NOT NULL COMMENT 'ID видео',
3264  `event` enum('load_begin','load_in_progress','load_finished','load_error','check_video_begin','check_video_ok','check_error','thumb_begin','thumb_in_progress','thumb_finished','thumb_error','origin_cover_upload_begin','origin_cover_upload_in_progress','origin_cover_upload_finished','origin_cover_upload_error','origin_video_upload_begin','origin_video_upload_in_progress','origin_video_upload_finished','origin_video_upload_error','video_set_distribution') NOT NULL COMMENT 'Событие',
3265  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата события',
3266  `data` text,
3267  PRIMARY KEY (`id`),
3268  KEY `video_id_idx` (`video_id`),
3269  KEY `event_video_idx` (`event`,`video_id`)
3270) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='События загрузки видео' AUTO_INCREMENT=998 ;
3271
3272-- --------------------------------------------------------
3273
3274--
3275-- Table structure for table `video_source`
3276--
3277
3278CREATE TABLE IF NOT EXISTS `video_source` (
3279  `id` int(11) NOT NULL AUTO_INCREMENT,
3280  `video_id` int(11) NOT NULL COMMENT 'ID видео',
3281  `filename` varchar(255) DEFAULT '' COMMENT 'Имя видеофайла',
3282  `add_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата добавления',
3283  `update_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Дата обновления',
3284  `state` int(11) NOT NULL DEFAULT '0' COMMENT 'Статус',
3285  `conv_sort` int(11) NOT NULL DEFAULT '0' COMMENT 'Порядок обработки',
3286  `conv_attempts` int(11) NOT NULL DEFAULT '0' COMMENT 'Кол-во попыток конвертации',
3287  `type` enum('file','link','youtube','rutube') DEFAULT NULL COMMENT 'Тип источника видео',
3288  `source` varchar(512) DEFAULT NULL COMMENT 'Данные источника видео',
3289  `duration` time DEFAULT '00:00:00',
3290  `mime` varchar(128) DEFAULT NULL,
3291  PRIMARY KEY (`id`),
3292  KEY `video_id_idx` (`video_id`),
3293  KEY `state_idx` (`state`) USING BTREE
3294) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Исходники видео и его состояние загрузки и конвертации' AUTO_INCREMENT=88 ;
3295
3296-- --------------------------------------------------------
3297
3298--
3299-- Table structure for table `vkcheats`
3300--
3301
3302CREATE TABLE IF NOT EXISTS `vkcheats` (
3303  `id` int(11) NOT NULL AUTO_INCREMENT,
3304  `title` text NOT NULL,
3305  PRIMARY KEY (`id`)
3306) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Тайтлы для пушинга ВКонтакте' AUTO_INCREMENT=585884 ;
3307
3308-- --------------------------------------------------------
3309
3310--
3311-- Table structure for table `vk_application_log`
3312--
3313
3314CREATE TABLE IF NOT EXISTS `vk_application_log` (
3315  `id` int(11) NOT NULL AUTO_INCREMENT,
3316  `type` enum('push','upload','setlegalowner','replacelegal','removelegalowner') NOT NULL DEFAULT 'push',
3317  `video_id` int(11) NOT NULL,
3318  `user_id` int(11) DEFAULT NULL,
3319  `log_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
3320  `title` text NOT NULL,
3321  `vk_video_id` int(11) DEFAULT NULL,
3322  `vk_owner_id` int(11) DEFAULT NULL,
3323  `owner_id` int(11) DEFAULT NULL,
3324  PRIMARY KEY (`id`),
3325  KEY `video` (`video_id`),
3326  KEY `type` (`type`),
3327  KEY `user_id` (`user_id`)
3328) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3957125 ;
3329
3330-- --------------------------------------------------------
3331
3332--
3333-- Table structure for table `vk_folders`
3334--
3335
3336CREATE TABLE IF NOT EXISTS `vk_folders` (
3337  `id` int(11) NOT NULL AUTO_INCREMENT,
3338  `title` varchar(255) NOT NULL,
3339  `owner_id` int(11) NOT NULL,
3340  `category_id` int(11) NOT NULL,
3341  `vk_folder_id` int(11) NOT NULL,
3342  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
3343  PRIMARY KEY (`id`)
3344) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=116 ;
3345
3346-- --------------------------------------------------------
3347
3348--
3349-- Table structure for table `vk_keywords`
3350--
3351
3352CREATE TABLE IF NOT EXISTS `vk_keywords` (
3353  `id` int(11) NOT NULL AUTO_INCREMENT,
3354  `keyword` varchar(76) DEFAULT NULL,
3355  `is_use` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'маркер использования',
3356  PRIMARY KEY (`id`)
3357) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9863 ;
3358
3359--
3360-- Constraints for dumped tables
3361--
3362
3363--
3364-- Constraints for table `fourpay_history`
3365--
3366ALTER TABLE `fourpay_history`
3367  ADD CONSTRAINT `transaction_id_fk` FOREIGN KEY (`transaction_id`) REFERENCES `outcome_money` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;