DNgQtYP7

1CREATE TABLE IF NOT EXISTS `2018_ACCOUNTS` (
2  `ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
3  `LOGIN` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
4  `FIRST_NAME` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
5  `LAST_NAME` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
6  `DATE` datetime NOT NULL,
7  `EVENT` int(11) NOT NULL,
8  `UNIK` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
9  PRIMARY KEY (`ID`),
10  KEY `DATE` (`DATE`,`EVENT`)
11) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
12
13CREATE TABLE IF NOT EXISTS `2018_ACCOUNTS_DEVICES` (
14  `ACCOUNTS_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
15  `DEVICES_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
16  `DATE` datetime NOT NULL,
17  `EVENT` int(11) NOT NULL,
18  PRIMARY KEY (`ACCOUNTS_ID`,`DEVICES_ID`),
19  KEY `EVENT` (`EVENT`)
20) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
21
22CREATE TABLE IF NOT EXISTS `2018_ACCOUNTS_PROFILS` (
23  `ACCOUNTS_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
24  `PROFIL_UNIK` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
25  PRIMARY KEY (`ACCOUNTS_ID`,`PROFIL_UNIK`)
26) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
27
28CREATE TABLE IF NOT EXISTS `2018_DEVICES` (
29  `ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
30  `OS` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
31  `OS_VERSION` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
32  `SCREEN` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
33  `BRAND` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
34  `MODEL` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
35  `DATE` datetime NOT NULL,
36  `PLATFORM` enum('mobile', 'brower') COLLATE utf8_unicode_ci NOT NULL,
37  `PHONE_ID` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
38  `EVENTS_ID` int(11) NOT NULL,
39  PRIMARY KEY (`ID`, `EVENTS_ID` ),
40  KEY `DATE` (`DATE`,`PLATFORM`)
41) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
42
43CREATE TABLE IF NOT EXISTS `2018_DEVICES_EVENTS` (
44  `DEVICES_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
45  `EVENTS_ID` int(11) NOT NULL,
46  `PUSH_TOKEN` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
47  PRIMARY KEY (`DEVICES_ID`,`EVENTS_ID`)
48) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
49
50CREATE TABLE IF NOT EXISTS `2018_MODULES` (
51  `ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
52  `EVENT` int(11) NOT NULL,
53  `TXT_FR` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
54  `TXT_EN` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
55  `TXT_DE` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
56  `TXT_ES` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
57  `TXT_CN` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
58  `TXT_IT` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
59  `TXT_SV` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
60  `TXT_PL` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
61  `TXT_CS` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
62  PRIMARY KEY (`ID`),
63  KEY `EVENT` (`EVENT`)
64) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
65
66CREATE TABLE IF NOT EXISTS `2018_MODULES_USES` (
67  `ID` int(11) NOT NULL AUTO_INCREMENT,
68  `MODULE_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
69  `DEVICE_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
70  `EVENT` int(11) NOT NULL,
71  `DATE` datetime NOT NULL,
72  `CATEGORY_ID` int(11) DEFAULT NULL,
73  `CATEGORY_UNIK` int(11) DEFAULT NULL,
74  `SHEET_ID` int(11) DEFAULT NULL,
75  `SHEET_UNIK` int(11) DEFAULT NULL,
76  `PARAMS` text COLLATE utf8_unicode_ci,
77  PRIMARY KEY (`ID`,`MODULE_ID`,`EVENT`,`DATE`),
78  KEY `MODULE_ID` (`MODULE_ID`),
79  KEY `DEVICE_ID` (`DEVICE_ID`)
80) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
81
82CREATE TABLE IF NOT EXISTS `2018_USES` (
83  `ID` int(11) NOT NULL AUTO_INCREMENT,
84  `DEVICE_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
85  `EVENT` int(11) NOT NULL,
86  `START` double NOT NULL,
87  `END` double NOT NULL,
88  `TIME` double NOT NULL,
89  PRIMARY KEY (`ID`,`DEVICE_ID`,`START`),
90  KEY `DEVICE_ID` (`DEVICE_ID`)
91) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
92
93CREATE TABLE IF NOT EXISTS `2018_SEARCHES` (
94  `ID` int(11) NOT NULL AUTO_INCREMENT,
95  `DEVICE_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
96  `EVENT` int(11) NOT NULL,
97  `KEYWORD` varchar(300) NOT NULL,
98  PRIMARY KEY (`ID`,`DEVICE_ID`,`EVENT`,`KEYWORD`),
99  KEY `DEVICE_ID` (`DEVICE_ID`)
100) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
101
102CREATE TABLE IF NOT EXISTS `2018_MAP_PATHFINDING` (
103  `ID` int(11) NOT NULL AUTO_INCREMENT,
104  `DEVICE_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
105  `EVENT` int(11) NOT NULL,
106  `DATE` datetime NOT NULL,
107  `START` datetime DEFAULT NULL,
108  `END` datetime DEFAULT NULL,
109  PRIMARY KEY (`ID`,`DEVICE_ID`,`EVENT`),
110  KEY `DEVICE_ID` (`DEVICE_ID`)
111) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;