· 8 years ago · May 29, 2018, 08:08 PM
1-- phpMyAdmin SQL Dump
2-- version 3.3.2deb1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Apr 20, 2018 at 09:21 AM
7-- Server version: 5.1.73
8-- PHP Version: 5.3.2-1ubuntu4.7
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17
18--
19-- Database: `itn`
20--
21
22-- --------------------------------------------------------
23
24--
25-- Table structure for table `2018_ACCOUNTS`
26--
27
28CREATE TABLE IF NOT EXISTS `2018_ACCOUNTS` (
29 `ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
30 `LOGIN` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
31 `FIRST_NAME` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
32 `LAST_NAME` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
33 `DATE` datetime NOT NULL,
34 `EVENT` int(11) NOT NULL,
35 `UNIK` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
36 PRIMARY KEY (`ID`),
37 KEY `DATE` (`DATE`,`EVENT`)
38) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
39
40--
41-- Dumping data for table `2018_ACCOUNTS`
42--
43
44
45-- --------------------------------------------------------
46
47--
48-- Table structure for table `2018_ACCOUNTS_DEVICES`
49--
50
51CREATE TABLE IF NOT EXISTS `2018_ACCOUNTS_DEVICES` (
52 `ACCOUNTS_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
53 `DEVICES_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
54 `DATE` datetime NOT NULL,
55 `EVENT` int(11) NOT NULL,
56 PRIMARY KEY (`ACCOUNTS_ID`,`DEVICES_ID`),
57 KEY `EVENT` (`EVENT`)
58) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
59
60--
61-- Dumping data for table `2018_ACCOUNTS_DEVICES`
62--
63
64
65-- --------------------------------------------------------
66
67--
68-- Table structure for table `2018_ACCOUNTS_PROFILS`
69--
70
71CREATE TABLE IF NOT EXISTS `2018_ACCOUNTS_PROFILS` (
72 `ACCOUNTS_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
73 `PROFIL_UNIK` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
74 PRIMARY KEY (`ACCOUNTS_ID`,`PROFIL_UNIK`)
75) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
76
77--
78-- Dumping data for table `2018_ACCOUNTS_PROFILS`
79--
80
81
82-- --------------------------------------------------------
83
84--
85-- Table structure for table `2018_DEVICES`
86--
87
88CREATE TABLE IF NOT EXISTS `2018_DEVICES` (
89 `ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
90 `OS` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
91 `OS_VERSION` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
92 `SCREEN` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
93 `BRAND` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
94 `MODEL` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
95 `DATE` datetime NOT NULL,
96 `PLATFORM` enum('mobile', 'brower') COLLATE utf8_unicode_ci NOT NULL,
97 `PHONE_ID` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
98 `EVENTS_ID` int(11) NOT NULL,
99 PRIMARY KEY (`ID`, `EVENTS_ID` ),
100 KEY `DATE` (`DATE`,`PLATFORM`)
101) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
102
103--
104-- Dumping data for table `2018_DEVICES`
105--
106
107
108-- --------------------------------------------------------
109
110--
111-- Table structure for table `2018_DEVICES_EVENTS`
112--
113
114CREATE TABLE IF NOT EXISTS `2018_DEVICES_EVENTS` (
115 `DEVICES_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
116 `EVENTS_ID` int(11) NOT NULL,
117 `PUSH_TOKEN` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
118 PRIMARY KEY (`DEVICES_ID`,`EVENTS_ID`)
119) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
120
121--
122-- Dumping data for table `2018_DEVICES_EVENTS`
123--
124
125
126-- --------------------------------------------------------
127
128--
129-- Table structure for table `2018_MODULES`
130--
131
132CREATE TABLE IF NOT EXISTS `2018_MODULES` (
133 `ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
134 `EVENT` int(11) NOT NULL,
135 `TXT_FR` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
136 `TXT_EN` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
137 `TXT_DE` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
138 `TXT_ES` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
139 `TXT_CN` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
140 `TXT_IT` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
141 `TXT_SV` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
142 `TXT_PL` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
143 `TXT_CS` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
144 PRIMARY KEY (`ID`),
145 KEY `EVENT` (`EVENT`)
146) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
147
148--
149-- Dumping data for table `2018_MODULES`
150--
151
152
153-- --------------------------------------------------------
154
155--
156-- Table structure for table `2018_MODULES_USES`
157--
158
159CREATE TABLE IF NOT EXISTS `2018_MODULES_USES` (
160 `ID` int(11) NOT NULL AUTO_INCREMENT,
161 `MODULE_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
162 `DEVICE_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
163 `EVENT` int(11) NOT NULL,
164 `DATE` datetime NOT NULL,
165 `CATEGORY_ID` int(11) DEFAULT NULL,
166 `CATEGORY_UNIK` int(11) DEFAULT NULL,
167 `SHEET_ID` int(11) DEFAULT NULL,
168 `SHEET_UNIK` int(11) DEFAULT NULL,
169 `PARAMS` text COLLATE utf8_unicode_ci,
170 PRIMARY KEY (`ID`,`MODULE_ID`,`EVENT`,`DATE`),
171 KEY `MODULE_ID` (`MODULE_ID`),
172 KEY `DEVICE_ID` (`DEVICE_ID`)
173) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
174
175--
176-- Dumping data for table `2018_MODULES_USES`
177--
178
179
180-- --------------------------------------------------------
181
182--
183-- Table structure for table `2018_USES`
184--
185
186CREATE TABLE IF NOT EXISTS `2018_USES` (
187 `ID` int(11) NOT NULL AUTO_INCREMENT,
188 `DEVICE_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
189 `EVENT` int(11) NOT NULL,
190 `START` double NOT NULL,
191 `END` double NOT NULL,
192 `TIME` double NOT NULL,
193 PRIMARY KEY (`ID`,`DEVICE_ID`,`START`),
194 KEY `DEVICE_ID` (`DEVICE_ID`)
195) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
196
197--
198-- Dumping data for table `2018_USES`
199--
200
201
202-- --------------------------------------------------------
203
204--
205-- Table structure for table `2018_SEARCHES`
206--
207
208CREATE TABLE IF NOT EXISTS `2018_SEARCHES` (
209 `ID` int(11) NOT NULL AUTO_INCREMENT,
210 `DEVICE_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
211 `EVENT` int(11) NOT NULL,
212 `KEYWORD` varchar(300) NOT NULL,
213 PRIMARY KEY (`ID`,`DEVICE_ID`,`EVENT`,`KEYWORD`),
214 KEY `DEVICE_ID` (`DEVICE_ID`)
215) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
216
217--
218-- Dumping data for table `2018_SEARCHES`
219--
220
221
222-- --------------------------------------------------------
223
224--
225-- Table structure for table `2018_MAP_PATHFINDING`
226--
227
228CREATE TABLE IF NOT EXISTS `2018_MAP_PATHFINDING` (
229 `ID` int(11) NOT NULL AUTO_INCREMENT,
230 `DEVICE_ID` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
231 `EVENT` int(11) NOT NULL,
232 `DATE` datetime NOT NULL,
233 `START` datetime DEFAULT NULL,
234 `END` datetime DEFAULT NULL,
235 PRIMARY KEY (`ID`,`DEVICE_ID`,`EVENT`),
236 KEY `DEVICE_ID` (`DEVICE_ID`)
237) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
238
239--
240-- Dumping data for table `2018_MAP_PATHFINDING`
241--