eyVDEYDA

1-- phpMyAdmin SQL Dump
2-- version 4.8.5
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost
6-- Creato il: Apr 06, 2020 alle 10:17
7-- Versione del server: 5.7.29-0ubuntu0.18.04.1
8-- Versione PHP: 7.2.24-0ubuntu0.18.04.3
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `Brain`
23--
24CREATE DATABASE IF NOT EXISTS `Brain` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
25USE `Brain`;
26
27-- --------------------------------------------------------
28
29--
30-- Struttura della tabella `oneblock`
31--
32
33CREATE TABLE `oneblock` (
34  `player` varchar(255) NOT NULL,
35  `islandname` varchar(255) NOT NULL,
36  `friends` varchar(255) NOT NULL DEFAULT '',
37  `blocks` int(11) NOT NULL DEFAULT '-6',
38  `tier` int(255) NOT NULL DEFAULT '0',
39  `privacy` int(1) NOT NULL DEFAULT '2'
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41
42--
43-- Dump dei dati per la tabella `oneblock`
44--
45
46INSERT INTO `oneblock` (`player`, `islandname`, `friends`, `blocks`, `tier`, `privacy`) VALUES
47('0000000000000000000000000000000000000003', 'Diocan', '', 300, 1, 2),
48('0000000000000000000000000000000000000004', 'mio', '', 300, 1, 2);
49
50-- --------------------------------------------------------
51
52--
53-- Struttura della tabella `servers`
54--
55
56CREATE TABLE `servers` (
57  `game` varchar(25) NOT NULL,
58  `mode` varchar(25) NOT NULL,
59  `ip` varchar(255) NOT NULL,
60  `port` int(5) NOT NULL,
61  `status` int(1) NOT NULL,
62  `private` int(1) NOT NULL,
63  `password` varchar(255) NOT NULL
64) ENGINE=InnoDB DEFAULT CHARSET=latin1;
65
66--
67-- Dump dei dati per la tabella `servers`
68--
69
70INSERT INTO `servers` (`game`, `mode`, `ip`, `port`, `status`, `private`, `password`) VALUES
71('BungeeCord', 'BungeeCord', '127.0.0.1', 25565, 0, 0, 'BungeeCord'),
72('MainLobby', '1', '127.0.0.1', 301, 0, 0, 'MainLobby1'),
73('MainLobby', '2', '127.0.0.1', 302, 0, 0, 'MainLobby2'),
74('MainLobby', '3', '127.0.0.1', 303, 0, 0, 'MainLobby3');
75
76--
77-- Indici per le tabelle scaricate
78--
79
80--
81-- Indici per le tabelle `oneblock`
82--
83ALTER TABLE `oneblock`
84  ADD UNIQUE KEY `player` (`player`);
85
86--
87-- Indici per le tabelle `servers`
88--
89ALTER TABLE `servers`
90  ADD UNIQUE KEY `password` (`password`);
91--
92-- Database: `cpsupport`
93--
94CREATE DATABASE IF NOT EXISTS `cpsupport` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
95USE `cpsupport`;
96
97-- --------------------------------------------------------
98
99--
100-- Struttura della tabella `lh_abstract_auto_responder`
101--
102
103CREATE TABLE `lh_abstract_auto_responder` (
104  `id` int(11) NOT NULL,
105  `siteaccess` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
106  `wait_message` text COLLATE utf8mb4_unicode_ci NOT NULL,
107  `wait_timeout` int(11) NOT NULL,
108  `position` int(11) NOT NULL,
109  `timeout_message` text COLLATE utf8mb4_unicode_ci NOT NULL,
110  `bot_configuration` text COLLATE utf8mb4_unicode_ci NOT NULL,
111  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
112  `operator` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
113  `dep_id` int(11) NOT NULL,
114  `user_id` int(11) NOT NULL,
115  `only_proactive` int(11) NOT NULL,
116  `repeat_number` int(11) NOT NULL DEFAULT '1',
117  `survey_timeout` int(11) NOT NULL DEFAULT '0',
118  `survey_id` int(11) NOT NULL DEFAULT '0',
119  `wait_timeout_hold_1` int(11) NOT NULL,
120  `wait_timeout_hold_2` int(11) NOT NULL,
121  `wait_timeout_hold_3` int(11) NOT NULL,
122  `wait_timeout_hold_4` int(11) NOT NULL,
123  `wait_timeout_hold_5` int(11) NOT NULL,
124  `timeout_hold_message_1` text COLLATE utf8mb4_unicode_ci NOT NULL,
125  `timeout_hold_message_2` text COLLATE utf8mb4_unicode_ci NOT NULL,
126  `timeout_hold_message_3` text COLLATE utf8mb4_unicode_ci NOT NULL,
127  `timeout_hold_message_4` text COLLATE utf8mb4_unicode_ci NOT NULL,
128  `timeout_hold_message_5` text COLLATE utf8mb4_unicode_ci NOT NULL,
129  `wait_timeout_hold` text COLLATE utf8mb4_unicode_ci NOT NULL,
130  `wait_timeout_2` int(11) NOT NULL,
131  `timeout_message_2` text COLLATE utf8mb4_unicode_ci NOT NULL,
132  `wait_timeout_3` int(11) NOT NULL,
133  `timeout_message_3` text COLLATE utf8mb4_unicode_ci NOT NULL,
134  `wait_timeout_4` int(11) NOT NULL,
135  `timeout_message_4` text COLLATE utf8mb4_unicode_ci NOT NULL,
136  `wait_timeout_5` int(11) NOT NULL,
137  `timeout_message_5` text COLLATE utf8mb4_unicode_ci NOT NULL,
138  `wait_timeout_reply_1` int(11) NOT NULL,
139  `timeout_reply_message_1` text COLLATE utf8mb4_unicode_ci NOT NULL,
140  `wait_timeout_reply_2` int(11) NOT NULL,
141  `timeout_reply_message_2` text COLLATE utf8mb4_unicode_ci NOT NULL,
142  `wait_timeout_reply_3` int(11) NOT NULL,
143  `timeout_reply_message_3` text COLLATE utf8mb4_unicode_ci NOT NULL,
144  `wait_timeout_reply_4` int(11) NOT NULL,
145  `timeout_reply_message_4` text COLLATE utf8mb4_unicode_ci NOT NULL,
146  `wait_timeout_reply_5` int(11) NOT NULL,
147  `timeout_reply_message_5` text COLLATE utf8mb4_unicode_ci NOT NULL,
148  `languages` text COLLATE utf8mb4_unicode_ci NOT NULL,
149  `ignore_pa_chat` int(11) NOT NULL
150) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
151
152-- --------------------------------------------------------
153
154--
155-- Struttura della tabella `lh_abstract_auto_responder_chat`
156--
157
158CREATE TABLE `lh_abstract_auto_responder_chat` (
159  `id` int(11) NOT NULL,
160  `chat_id` int(11) NOT NULL,
161  `auto_responder_id` int(11) NOT NULL,
162  `wait_timeout_send` int(11) NOT NULL,
163  `pending_send_status` int(11) NOT NULL,
164  `active_send_status` int(11) NOT NULL
165) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
166
167-- --------------------------------------------------------
168
169--
170-- Struttura della tabella `lh_abstract_browse_offer_invitation`
171--
172
173CREATE TABLE `lh_abstract_browse_offer_invitation` (
174  `id` int(11) NOT NULL,
175  `siteaccess` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
176  `time_on_site` int(11) NOT NULL,
177  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
178  `callback_content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
179  `lhc_iframe_content` tinyint(4) NOT NULL,
180  `custom_iframe_url` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
181  `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
182  `identifier` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
183  `executed_times` int(11) NOT NULL,
184  `url` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
185  `active` int(11) NOT NULL,
186  `has_url` int(11) NOT NULL,
187  `is_wildcard` int(11) NOT NULL,
188  `referrer` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
189  `priority` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
190  `hash` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
191  `width` int(11) NOT NULL,
192  `height` int(11) NOT NULL,
193  `unit` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL
194) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
195
196-- --------------------------------------------------------
197
198--
199-- Struttura della tabella `lh_abstract_chat_column`
200--
201
202CREATE TABLE `lh_abstract_chat_column` (
203  `id` int(11) NOT NULL,
204  `column_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
205  `variable` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
206  `position` int(11) NOT NULL,
207  `enabled` tinyint(1) NOT NULL,
208  `online_enabled` tinyint(1) NOT NULL,
209  `chat_enabled` tinyint(1) NOT NULL,
210  `conditions` text COLLATE utf8mb4_unicode_ci NOT NULL,
211  `column_icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
212  `column_identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
213) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
214
215-- --------------------------------------------------------
216
217--
218-- Struttura della tabella `lh_abstract_chat_priority`
219--
220
221CREATE TABLE `lh_abstract_chat_priority` (
222  `id` int(11) NOT NULL,
223  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
224  `dep_id` int(11) NOT NULL,
225  `priority` int(11) NOT NULL
226) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
227
228-- --------------------------------------------------------
229
230--
231-- Struttura della tabella `lh_abstract_chat_variable`
232--
233
234CREATE TABLE `lh_abstract_chat_variable` (
235  `id` int(11) NOT NULL,
236  `var_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
237  `var_identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
238  `type` tinyint(1) NOT NULL,
239  `js_variable` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
240  `dep_id` int(11) NOT NULL
241) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
242
243-- --------------------------------------------------------
244
245--
246-- Struttura della tabella `lh_abstract_email_template`
247--
248
249CREATE TABLE `lh_abstract_email_template` (
250  `id` int(11) NOT NULL,
251  `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
252  `from_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
253  `from_name_ac` tinyint(4) NOT NULL,
254  `from_email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
255  `from_email_ac` tinyint(4) NOT NULL,
256  `user_mail_as_sender` tinyint(4) NOT NULL,
257  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
258  `subject` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
259  `bcc_recipients` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
260  `subject_ac` tinyint(4) NOT NULL,
261  `reply_to` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
262  `reply_to_ac` tinyint(4) NOT NULL,
263  `recipient` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL
264) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
265
266--
267-- Dump dei dati per la tabella `lh_abstract_email_template`
268--
269
270INSERT INTO `lh_abstract_email_template` (`id`, `name`, `from_name`, `from_name_ac`, `from_email`, `from_email_ac`, `user_mail_as_sender`, `content`, `subject`, `bcc_recipients`, `subject_ac`, `reply_to`, `reply_to_ac`, `recipient`) VALUES
271(1, 'Send mail to user', 'Live Helper Chat', 0, '', 0, 0, 'Dear {user_chat_nick},\r\n\r\n{additional_message}\r\n\r\nLive Support response:\r\n{messages_content}\r\n\r\nSincerely,\r\nLive Support Team\r\n', '{name_surname} has responded to your request', '', 1, '', 1, ''),
272(2, 'Support request from user', '', 0, '', 0, 0, 'Hello,\r\n\r\nUser request data:\r\nName: {name}\r\nEmail: {email}\r\nPhone: {phone}\r\nDepartment: {department}\r\nCountry: {country}\r\nCity: {city}\r\nIP: {ip}\r\n\r\nMessage:\r\n{message}\r\n\r\nAdditional data, if any:\r\n{additional_data}\r\n\r\nURL of page from which user has send request:\r\n{url_request}\r\n\r\nLink to chat if any:\r\n{prefillchat}\r\n\r\nSincerely,\r\nLive Support Team', '{name}, {country}, {department}, Support request from user', '', 0, '', 0, 'massimiliano@maxcode.it'),
273(3, 'User mail for himself', 'Live Helper Chat', 0, '', 0, 0, 'Dear {user_chat_nick},\r\n\r\nTranscript:\r\n{messages_content}\r\nChat ID: {chat_id}\n\r\nSincerely,\r\nLive Support Team\r\n', 'Chat transcript', '', 0, '', 0, ''),
274(4, 'New chat request', 'Live Helper Chat', 0, '', 0, 0, 'Hello,\r\n\r\nUser request data:\r\nName: {name}\r\nEmail: {email}\r\nPhone: {phone}\r\nDepartment: {department}\r\nCountry: {country}\r\nCity: {city}\r\nIP: {ip}\r\nCreated:	{created}\r\nUser left:	{user_left}\r\nWaited:	{waited}\r\nChat duration:	{chat_duration}\r\n\r\nMessage:\r\n{message}\r\n\r\nURL of page from which user has send request:\r\n{url_request}\r\n\r\nClick to accept chat automatically\r\n{url_accept}\r\n\r\nSurvey\r\n{survey}\r\n\r\nSincerely,\r\nLive Support Team', 'New chat request', '', 0, '', 0, 'massimiliano@maxcode.it'),
275(5, 'Chat was closed', 'Live Helper Chat', 0, '', 0, 0, 'Hello,\r\n\r\n{operator} has closed a chat\r\nName: {name}\r\nEmail: {email}\r\nPhone: {phone}\r\nDepartment: {department}\r\nCountry: {country}\r\nCity: {city}\r\nIP: {ip}\r\nCreated:	{created}\r\nUser left:	{user_left}\r\nWaited:	{waited}\r\nChat duration:	{chat_duration}\r\n\r\nMessage:\r\n{message}\r\n\r\nAdditional data, if any:\r\n{additional_data}\r\n\r\nURL of page from which user has send request:\r\n{url_request}\r\n\r\nSurvey:\r\n{survey}\r\n\r\nSincerely,\r\nLive Support Team', 'Chat was closed', '', 0, '', 0, 'massimiliano@maxcode.it'),
276(6, 'New FAQ question', 'Live Helper Chat', 0, '', 0, 0, 'Hello,\r\n\r\nNew FAQ question\r\nEmail: {email}\r\n\r\nQuestion:\r\n{question}\r\n\r\nQuestion URL:\r\n{url_question}\r\n\r\nURL to answer a question:\r\n{url_request}\r\n\r\nSincerely,\r\nLive Support Team', 'New FAQ question', '', 0, '', 0, 'massimiliano@maxcode.it'),
277(7, 'New unread message', 'Live Helper Chat', 0, '', 0, 0, 'Hello,\r\n\r\nUser request data:\r\nName: {name}\r\nEmail: {email}\r\nPhone: {phone}\r\nDepartment: {department}\r\nCountry: {country}\r\nCity: {city}\r\nIP: {ip}\r\nCreated:	{created}\r\nUser left:	{user_left}\r\nWaited:	{waited}\r\nChat duration:	{chat_duration}\r\n\r\nMessage:\r\n{message}\r\n\r\nURL of page from which user has send request:\r\n{url_request}\r\n\r\nClick to accept chat automatically\r\n{url_accept}\r\n\r\nSurvey:\r\n{survey}\r\n\r\nSincerely,\r\nLive Support Team', 'New unread message', '', 0, '', 0, 'massimiliano@maxcode.it'),
278(8, 'Filled form', 'MCFC', 0, '', 0, 0, 'Hello,\r\n\r\nUser has filled a form\r\nForm name - {form_name}\r\nUser IP - {ip}\r\nDownload filled data - {url_download}\r\nView filled data - {url_view}\r\n\r\n{content}\r\n\r\nSincerely,\r\nLive Support Team', 'Filled form - {form_name}', '', 0, '', 0, 'massimiliano@maxcode.it'),
279(9, 'Chat was accepted', 'Live Helper Chat', 0, '', 0, 0, 'Hello,\r\n\r\nOperator {user_name} has accepted a chat [{chat_id}]\r\n\r\nUser request data:\r\nName: {name}\r\nEmail: {email}\r\nPhone: {phone}\r\nDepartment: {department}\r\nCountry: {country}\r\nCity: {city}\r\nIP: {ip}\r\nCreated:	{created}\r\nUser left:	{user_left}\r\nWaited:	{waited}\r\nChat duration:	{chat_duration}\r\n\r\nMessage:\r\n{message}\r\n\r\nURL of page from which user has send request:\r\n{url_request}\r\n\r\nClick to accept chat automatically\r\n{url_accept}\r\n\r\nSurvey:\r\n{survey}\r\n\r\nSincerely,\r\nLive Support Team', 'Chat was accepted [{chat_id}]', '', 0, '', 0, 'massimiliano@maxcode.it'),
280(10, 'Permission request', 'Live Helper Chat', 0, '', 0, 0, 'Hello,\r\n\r\nOperator {user} has requested these permissions\n\r\n{permissions}\r\n\r\nSincerely,\r\nLive Support Team', 'Permission request from {user}', '', 0, '', 0, ''),
281(11, 'You have unread messages', 'Live Helper Chat', 0, '', 0, 0, 'Hello,\r\n\r\nOperator {operator} has answered to you\r\n\r\n{messages}\r\n\r\nSincerely,\r\nLive Support Team', 'Operator has answered to your request', '', 0, '', 0, ''),
282(12, 'Visitor returned', 'Live Helper Chat', 0, '', 0, 0, 'Hello,\r\n\r\nVisitor information\r\nName: {name}\r\nEmail: {email}\r\nPhone: {phone}\r\nDepartment: {department}\r\nCountry: {country}\r\nCity: {city}\r\nIP: {ip}\r\nCreated:	{created}\r\nUser left:	{user_left}\r\nWaited:	{waited}\r\nChat duration:	{chat_duration}\r\n\r\nSee more information at\r\n{url_accept}\r\n\r\nLast chat:\r\n{message}\r\n\r\nAdditional data, if any:\r\n{additional_data}\r\n\r\nSincerely,\r\nLive Support Team', 'Visitor returned - {username}', '', 0, '', 0, '');
283
284-- --------------------------------------------------------
285
286--
287-- Struttura della tabella `lh_abstract_form`
288--
289
290CREATE TABLE `lh_abstract_form` (
291  `id` int(11) NOT NULL,
292  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
293  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
294  `recipient` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
295  `active` int(11) NOT NULL,
296  `name_attr` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
297  `intro_attr` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
298  `xls_columns` text COLLATE utf8mb4_unicode_ci NOT NULL,
299  `pagelayout` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
300  `post_content` text COLLATE utf8mb4_unicode_ci NOT NULL
301) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
302
303-- --------------------------------------------------------
304
305--
306-- Struttura della tabella `lh_abstract_form_collected`
307--
308
309CREATE TABLE `lh_abstract_form_collected` (
310  `id` int(11) NOT NULL,
311  `form_id` int(11) NOT NULL,
312  `ctime` int(11) NOT NULL,
313  `ip` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
314  `identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
315  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL
316) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
317
318-- --------------------------------------------------------
319
320--
321-- Struttura della tabella `lh_abstract_proactive_chat_campaign`
322--
323
324CREATE TABLE `lh_abstract_proactive_chat_campaign` (
325  `id` bigint(20) NOT NULL,
326  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
327  `text` text COLLATE utf8mb4_unicode_ci NOT NULL
328) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
329
330-- --------------------------------------------------------
331
332--
333-- Struttura della tabella `lh_abstract_proactive_chat_campaign_conv`
334--
335
336CREATE TABLE `lh_abstract_proactive_chat_campaign_conv` (
337  `id` bigint(20) NOT NULL,
338  `device_type` tinyint(11) NOT NULL,
339  `invitation_type` tinyint(1) NOT NULL,
340  `invitation_status` tinyint(1) NOT NULL,
341  `chat_id` bigint(20) NOT NULL,
342  `campaign_id` int(11) NOT NULL,
343  `invitation_id` int(11) NOT NULL,
344  `department_id` int(11) NOT NULL,
345  `ctime` int(11) NOT NULL,
346  `con_time` int(11) NOT NULL,
347  `vid_id` bigint(20) DEFAULT NULL
348) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
349
350-- --------------------------------------------------------
351
352--
353-- Struttura della tabella `lh_abstract_proactive_chat_event`
354--
355
356CREATE TABLE `lh_abstract_proactive_chat_event` (
357  `id` int(11) NOT NULL,
358  `vid_id` int(11) NOT NULL,
359  `ev_id` int(11) NOT NULL,
360  `ts` int(11) NOT NULL,
361  `val` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL
362) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
363
364-- --------------------------------------------------------
365
366--
367-- Struttura della tabella `lh_abstract_proactive_chat_invitation`
368--
369
370CREATE TABLE `lh_abstract_proactive_chat_invitation` (
371  `id` int(11) NOT NULL,
372  `siteaccess` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
373  `time_on_site` int(11) NOT NULL,
374  `pageviews` int(11) NOT NULL,
375  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
376  `message_returning` text COLLATE utf8mb4_unicode_ci NOT NULL,
377  `executed_times` int(11) NOT NULL,
378  `dep_id` int(11) NOT NULL,
379  `hide_after_ntimes` int(11) NOT NULL,
380  `show_on_mobile` int(11) NOT NULL,
381  `delay` int(11) NOT NULL,
382  `delay_init` int(11) NOT NULL,
383  `show_instant` int(11) NOT NULL,
384  `autoresponder_id` int(11) NOT NULL,
385  `disabled` int(11) NOT NULL,
386  `inject_only_html` tinyint(1) NOT NULL,
387  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
388  `operator_ids` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
389  `message_returning_nick` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
390  `referrer` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
391  `show_random_operator` int(11) NOT NULL,
392  `operator_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
393  `campaign_id` int(11) NOT NULL,
394  `position` int(11) NOT NULL,
395  `event_invitation` int(11) NOT NULL,
396  `dynamic_invitation` int(11) NOT NULL,
397  `bot_id` int(11) NOT NULL,
398  `trigger_id` int(11) NOT NULL,
399  `bot_offline` tinyint(1) NOT NULL,
400  `identifier` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
401  `tag` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
402  `requires_email` int(11) NOT NULL,
403  `iddle_for` int(11) NOT NULL,
404  `event_type` int(11) NOT NULL,
405  `requires_username` int(11) NOT NULL,
406  `requires_phone` int(11) NOT NULL,
407  `design_data` longtext COLLATE utf8mb4_unicode_ci NOT NULL
408) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
409
410-- --------------------------------------------------------
411
412--
413-- Struttura della tabella `lh_abstract_proactive_chat_invitation_event`
414--
415
416CREATE TABLE `lh_abstract_proactive_chat_invitation_event` (
417  `id` int(11) NOT NULL,
418  `invitation_id` int(11) NOT NULL,
419  `event_id` int(11) NOT NULL,
420  `min_number` int(11) NOT NULL,
421  `during_seconds` int(11) NOT NULL
422) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
423
424-- --------------------------------------------------------
425
426--
427-- Struttura della tabella `lh_abstract_proactive_chat_variables`
428--
429
430CREATE TABLE `lh_abstract_proactive_chat_variables` (
431  `id` int(11) NOT NULL,
432  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
433  `identifier` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
434  `store_timeout` int(11) NOT NULL,
435  `filter_val` int(11) NOT NULL DEFAULT '0'
436) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
437
438-- --------------------------------------------------------
439
440--
441-- Struttura della tabella `lh_abstract_product`
442--
443
444CREATE TABLE `lh_abstract_product` (
445  `id` int(11) NOT NULL,
446  `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
447  `disabled` int(11) NOT NULL,
448  `priority` int(11) NOT NULL,
449  `departament_id` int(11) NOT NULL
450) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
451
452-- --------------------------------------------------------
453
454--
455-- Struttura della tabella `lh_abstract_product_departament`
456--
457
458CREATE TABLE `lh_abstract_product_departament` (
459  `id` int(11) NOT NULL,
460  `product_id` int(11) NOT NULL,
461  `departament_id` int(11) NOT NULL
462) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
463
464-- --------------------------------------------------------
465
466--
467-- Struttura della tabella `lh_abstract_rest_api_key`
468--
469
470CREATE TABLE `lh_abstract_rest_api_key` (
471  `id` int(11) NOT NULL,
472  `api_key` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
473  `user_id` int(11) NOT NULL DEFAULT '0',
474  `active` int(11) NOT NULL DEFAULT '0'
475) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
476
477-- --------------------------------------------------------
478
479--
480-- Struttura della tabella `lh_abstract_rest_api_key_remote`
481--
482
483CREATE TABLE `lh_abstract_rest_api_key_remote` (
484  `id` int(11) NOT NULL,
485  `api_key` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
486  `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
487  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
488  `host` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
489  `active` tinyint(1) NOT NULL DEFAULT '0',
490  `position` int(11) NOT NULL DEFAULT '0'
491) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
492
493-- --------------------------------------------------------
494
495--
496-- Struttura della tabella `lh_abstract_subject`
497--
498
499CREATE TABLE `lh_abstract_subject` (
500  `id` int(11) NOT NULL,
501  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
502) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
503
504-- --------------------------------------------------------
505
506--
507-- Struttura della tabella `lh_abstract_subject_chat`
508--
509
510CREATE TABLE `lh_abstract_subject_chat` (
511  `id` bigint(20) NOT NULL,
512  `subject_id` int(11) NOT NULL,
513  `chat_id` bigint(20) NOT NULL
514) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
515
516-- --------------------------------------------------------
517
518--
519-- Struttura della tabella `lh_abstract_subject_dep`
520--
521
522CREATE TABLE `lh_abstract_subject_dep` (
523  `id` int(11) NOT NULL,
524  `dep_id` int(11) NOT NULL,
525  `subject_id` int(11) NOT NULL
526) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
527
528-- --------------------------------------------------------
529
530--
531-- Struttura della tabella `lh_abstract_survey`
532--
533
534CREATE TABLE `lh_abstract_survey` (
535  `id` int(11) NOT NULL,
536  `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
537  `feedback_text` text COLLATE utf8mb4_unicode_ci NOT NULL,
538  `max_stars_1_title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
539  `max_stars_1_pos` int(11) NOT NULL,
540  `max_stars_2_title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
541  `max_stars_2_pos` int(11) NOT NULL,
542  `max_stars_2` int(11) NOT NULL,
543  `max_stars_3_title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
544  `max_stars_3_pos` int(11) NOT NULL,
545  `max_stars_3` int(11) NOT NULL,
546  `max_stars_4_title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
547  `max_stars_4_pos` int(11) NOT NULL,
548  `max_stars_4` int(11) NOT NULL,
549  `max_stars_5_title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
550  `max_stars_5_pos` int(11) NOT NULL,
551  `max_stars_5` int(11) NOT NULL,
552  `question_options_1` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
553  `question_options_1_items` text COLLATE utf8mb4_unicode_ci NOT NULL,
554  `question_options_1_pos` int(11) NOT NULL,
555  `question_options_2` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
556  `question_options_2_items` text COLLATE utf8mb4_unicode_ci NOT NULL,
557  `question_options_2_pos` int(11) NOT NULL,
558  `question_options_3` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
559  `question_options_3_items` text COLLATE utf8mb4_unicode_ci NOT NULL,
560  `question_options_3_pos` int(11) NOT NULL,
561  `question_options_4` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
562  `question_options_4_items` text COLLATE utf8mb4_unicode_ci NOT NULL,
563  `question_options_4_pos` int(11) NOT NULL,
564  `question_options_5` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
565  `question_options_5_items` text COLLATE utf8mb4_unicode_ci NOT NULL,
566  `question_options_5_pos` int(11) NOT NULL,
567  `question_plain_1` text COLLATE utf8mb4_unicode_ci NOT NULL,
568  `question_plain_1_pos` int(11) NOT NULL,
569  `question_plain_2` text COLLATE utf8mb4_unicode_ci NOT NULL,
570  `question_plain_2_pos` int(11) NOT NULL,
571  `question_plain_3` text COLLATE utf8mb4_unicode_ci NOT NULL,
572  `question_plain_3_pos` int(11) NOT NULL,
573  `question_plain_4` text COLLATE utf8mb4_unicode_ci NOT NULL,
574  `question_plain_4_pos` int(11) NOT NULL,
575  `question_plain_5` text COLLATE utf8mb4_unicode_ci NOT NULL,
576  `question_plain_5_pos` int(11) NOT NULL,
577  `max_stars_1_enabled` int(11) NOT NULL,
578  `max_stars_2_enabled` int(11) NOT NULL,
579  `max_stars_3_enabled` int(11) NOT NULL,
580  `max_stars_4_enabled` int(11) NOT NULL,
581  `max_stars_5_enabled` int(11) NOT NULL,
582  `question_options_1_enabled` int(11) NOT NULL,
583  `question_options_2_enabled` int(11) NOT NULL,
584  `question_options_3_enabled` int(11) NOT NULL,
585  `question_options_4_enabled` int(11) NOT NULL,
586  `question_options_5_enabled` int(11) NOT NULL,
587  `question_plain_1_enabled` int(11) NOT NULL,
588  `question_plain_2_enabled` int(11) NOT NULL,
589  `question_plain_3_enabled` int(11) NOT NULL,
590  `question_plain_4_enabled` int(11) NOT NULL,
591  `question_plain_5_enabled` int(11) NOT NULL,
592  `max_stars_1` int(11) NOT NULL,
593  `max_stars_1_req` int(11) NOT NULL,
594  `max_stars_2_req` int(11) NOT NULL,
595  `max_stars_3_req` int(11) NOT NULL,
596  `max_stars_4_req` int(11) NOT NULL,
597  `max_stars_5_req` int(11) NOT NULL,
598  `question_options_1_req` int(11) NOT NULL,
599  `question_options_2_req` int(11) NOT NULL,
600  `question_options_3_req` int(11) NOT NULL,
601  `question_options_4_req` int(11) NOT NULL,
602  `question_options_5_req` int(11) NOT NULL,
603  `question_plain_1_req` int(11) NOT NULL,
604  `question_plain_2_req` int(11) NOT NULL,
605  `question_plain_3_req` int(11) NOT NULL,
606  `question_plain_4_req` int(11) NOT NULL,
607  `question_plain_5_req` int(11) NOT NULL
608) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
609
610-- --------------------------------------------------------
611
612--
613-- Struttura della tabella `lh_abstract_survey_item`
614--
615
616CREATE TABLE `lh_abstract_survey_item` (
617  `id` bigint(20) NOT NULL,
618  `survey_id` int(11) NOT NULL,
619  `status` int(11) NOT NULL DEFAULT '0',
620  `chat_id` int(11) NOT NULL,
621  `user_id` int(11) NOT NULL,
622  `ftime` int(11) NOT NULL,
623  `dep_id` int(11) NOT NULL,
624  `max_stars_1` int(11) NOT NULL,
625  `max_stars_2` int(11) NOT NULL,
626  `max_stars_3` int(11) NOT NULL,
627  `max_stars_4` int(11) NOT NULL,
628  `max_stars_5` int(11) NOT NULL,
629  `question_options_1` int(11) NOT NULL,
630  `question_options_2` int(11) NOT NULL,
631  `question_options_3` int(11) NOT NULL,
632  `question_options_4` int(11) NOT NULL,
633  `question_options_5` int(11) NOT NULL,
634  `question_plain_1` text COLLATE utf8mb4_unicode_ci NOT NULL,
635  `question_plain_2` text COLLATE utf8mb4_unicode_ci NOT NULL,
636  `question_plain_3` text COLLATE utf8mb4_unicode_ci NOT NULL,
637  `question_plain_4` text COLLATE utf8mb4_unicode_ci NOT NULL,
638  `question_plain_5` text COLLATE utf8mb4_unicode_ci NOT NULL
639) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
640
641-- --------------------------------------------------------
642
643--
644-- Struttura della tabella `lh_abstract_widget_theme`
645--
646
647CREATE TABLE `lh_abstract_widget_theme` (
648  `id` int(11) NOT NULL,
649  `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
650  `name_company` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
651  `onl_bcolor` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
652  `bor_bcolor` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'e3e3e3',
653  `text_color` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
654  `online_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
655  `online_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
656  `offline_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
657  `offline_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
658  `logo_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
659  `logo_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
660  `need_help_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
661  `bot_status_text` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
662  `header_background` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
663  `need_help_tcolor` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
664  `need_help_bcolor` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
665  `need_help_border` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
666  `need_help_close_bg` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
667  `need_help_hover_bg` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
668  `need_help_close_hover_bg` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
669  `need_help_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
670  `bot_configuration` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
671  `notification_configuration` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
672  `custom_status_css` text COLLATE utf8mb4_unicode_ci NOT NULL,
673  `custom_container_css` text COLLATE utf8mb4_unicode_ci NOT NULL,
674  `custom_widget_css` text COLLATE utf8mb4_unicode_ci NOT NULL,
675  `custom_popup_css` text COLLATE utf8mb4_unicode_ci NOT NULL,
676  `need_help_header` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
677  `need_help_text` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
678  `online_text` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
679  `offline_text` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
680  `widget_border_color` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
681  `copyright_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
682  `copyright_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
683  `widget_copyright_url` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
684  `show_copyright` int(11) NOT NULL DEFAULT '1',
685  `explain_text` text COLLATE utf8mb4_unicode_ci NOT NULL,
686  `intro_operator_text` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
687  `operator_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
688  `operator_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
689  `minimize_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
690  `minimize_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
691  `restore_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
692  `restore_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
693  `close_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
694  `close_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
695  `popup_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
696  `popup_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
697  `support_joined` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
698  `support_closed` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
699  `pending_join` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
700  `pending_join_queue` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
701  `noonline_operators` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
702  `noonline_operators_offline` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
703  `hide_close` int(11) NOT NULL,
704  `show_need_help_delay` int(11) NOT NULL DEFAULT '0',
705  `show_status_delay` int(11) NOT NULL DEFAULT '0',
706  `modern_look` tinyint(1) NOT NULL DEFAULT '0',
707  `hide_popup` int(11) NOT NULL,
708  `show_need_help` int(11) NOT NULL DEFAULT '1',
709  `show_need_help_timeout` int(11) NOT NULL DEFAULT '24',
710  `header_height` int(11) NOT NULL,
711  `header_padding` int(11) NOT NULL,
712  `widget_border_width` int(11) NOT NULL,
713  `hide_ts` int(11) NOT NULL,
714  `modified` int(11) NOT NULL,
715  `widget_response_width` int(11) NOT NULL,
716  `show_voting` tinyint(1) NOT NULL DEFAULT '1',
717  `department_title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
718  `department_select` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
719  `buble_visitor_background` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
720  `buble_visitor_title_color` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
721  `buble_visitor_text_color` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
722  `buble_operator_background` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
723  `buble_operator_title_color` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
724  `buble_operator_text_color` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL
725) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
726
727-- --------------------------------------------------------
728
729--
730-- Struttura della tabella `lh_admin_theme`
731--
732
733CREATE TABLE `lh_admin_theme` (
734  `id` int(11) NOT NULL,
735  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
736  `static_content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
737  `static_js_content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
738  `static_css_content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
739  `css_attributes` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
740  `header_content` text COLLATE utf8mb4_unicode_ci NOT NULL,
741  `user_id` int(11) NOT NULL,
742  `header_css` text COLLATE utf8mb4_unicode_ci NOT NULL
743) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
744
745-- --------------------------------------------------------
746
747--
748-- Struttura della tabella `lh_audits`
749--
750
751CREATE TABLE `lh_audits` (
752  `id` bigint(20) NOT NULL,
753  `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
754  `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
755  `object_id` bigint(20) DEFAULT '0',
756  `line` bigint(20) DEFAULT NULL,
757  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
758  `severity` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
759  `source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
760  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
761) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
762
763-- --------------------------------------------------------
764
765--
766-- Struttura della tabella `lh_canned_msg`
767--
768
769CREATE TABLE `lh_canned_msg` (
770  `id` int(11) NOT NULL,
771  `msg` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
772  `fallback_msg` text COLLATE utf8mb4_unicode_ci NOT NULL,
773  `title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
774  `explain` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
775  `languages` text COLLATE utf8mb4_unicode_ci NOT NULL,
776  `additional_data` text COLLATE utf8mb4_unicode_ci NOT NULL,
777  `position` int(11) NOT NULL,
778  `department_id` int(11) NOT NULL,
779  `user_id` int(11) NOT NULL,
780  `delay` int(11) NOT NULL,
781  `auto_send` tinyint(1) NOT NULL,
782  `html_snippet` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
783  `attr_int_1` int(11) NOT NULL,
784  `attr_int_2` int(11) NOT NULL,
785  `attr_int_3` int(11) NOT NULL
786) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
787
788-- --------------------------------------------------------
789
790--
791-- Struttura della tabella `lh_canned_msg_tag`
792--
793
794CREATE TABLE `lh_canned_msg_tag` (
795  `id` int(11) NOT NULL,
796  `tag` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL
797) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
798
799-- --------------------------------------------------------
800
801--
802-- Struttura della tabella `lh_canned_msg_tag_link`
803--
804
805CREATE TABLE `lh_canned_msg_tag_link` (
806  `id` int(11) NOT NULL,
807  `tag_id` int(11) NOT NULL,
808  `canned_id` int(11) NOT NULL
809) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
810
811-- --------------------------------------------------------
812
813--
814-- Struttura della tabella `lh_chat`
815--
816
817CREATE TABLE `lh_chat` (
818  `id` int(11) NOT NULL,
819  `nick` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
820  `status` int(11) NOT NULL DEFAULT '0',
821  `status_sub` int(11) NOT NULL DEFAULT '0',
822  `status_sub_sub` int(11) NOT NULL DEFAULT '0',
823  `time` int(11) NOT NULL,
824  `user_id` int(11) NOT NULL,
825  `hash` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
826  `referrer` text COLLATE utf8mb4_unicode_ci NOT NULL,
827  `session_referrer` text COLLATE utf8mb4_unicode_ci NOT NULL,
828  `chat_variables` text COLLATE utf8mb4_unicode_ci NOT NULL,
829  `remarks` text COLLATE utf8mb4_unicode_ci NOT NULL,
830  `ip` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
831  `dep_id` int(11) NOT NULL,
832  `invitation_id` int(11) NOT NULL,
833  `sender_user_id` int(11) NOT NULL,
834  `product_id` int(11) NOT NULL,
835  `pnd_time` int(11) NOT NULL DEFAULT '0',
836  `cls_time` int(11) NOT NULL DEFAULT '0',
837  `usaccept` int(11) NOT NULL DEFAULT '0',
838  `user_status` int(11) NOT NULL DEFAULT '0',
839  `user_closed_ts` int(11) NOT NULL DEFAULT '0',
840  `support_informed` int(11) NOT NULL DEFAULT '0',
841  `unread_messages_informed` int(11) NOT NULL DEFAULT '0',
842  `reinform_timeout` int(11) NOT NULL DEFAULT '0',
843  `last_op_msg_time` int(11) NOT NULL DEFAULT '0',
844  `has_unread_op_messages` int(11) NOT NULL DEFAULT '0',
845  `unread_op_messages_informed` int(11) NOT NULL DEFAULT '0',
846  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
847  `country_code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
848  `country_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
849  `unanswered_chat` int(11) NOT NULL,
850  `anonymized` tinyint(1) NOT NULL,
851  `user_typing` int(11) NOT NULL,
852  `user_typing_txt` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
853  `operator_typing` int(11) NOT NULL,
854  `operator_typing_id` int(11) NOT NULL,
855  `phone` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
856  `has_unread_messages` int(11) NOT NULL,
857  `last_user_msg_time` int(11) NOT NULL,
858  `fbst` tinyint(1) NOT NULL,
859  `online_user_id` int(11) NOT NULL,
860  `auto_responder_id` int(11) NOT NULL,
861  `last_msg_id` int(11) NOT NULL,
862  `lsync` int(11) NOT NULL,
863  `transfer_uid` int(11) NOT NULL,
864  `additional_data` text COLLATE utf8mb4_unicode_ci NOT NULL,
865  `user_tz_identifier` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
866  `lat` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
867  `lon` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
868  `city` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
869  `operation` text COLLATE utf8mb4_unicode_ci NOT NULL,
870  `operation_admin` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
871  `status_sub_arg` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
872  `uagent` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
873  `chat_locale` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
874  `chat_locale_to` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
875  `mail_send` int(11) NOT NULL,
876  `screenshot_id` int(11) NOT NULL,
877  `wait_time` int(11) NOT NULL,
878  `chat_duration` int(11) NOT NULL,
879  `tslasign` int(11) NOT NULL,
880  `priority` int(11) NOT NULL,
881  `chat_initiator` int(11) NOT NULL,
882  `transfer_timeout_ts` int(11) NOT NULL,
883  `transfer_timeout_ac` int(11) NOT NULL,
884  `transfer_if_na` int(11) NOT NULL,
885  `na_cb_executed` int(11) NOT NULL,
886  `device_type` int(11) NOT NULL,
887  `nc_cb_executed` tinyint(1) NOT NULL
888) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
889
890-- --------------------------------------------------------
891
892--
893-- Struttura della tabella `lh_chatbox`
894--
895
896CREATE TABLE `lh_chatbox` (
897  `id` int(11) NOT NULL,
898  `identifier` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
899  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
900  `chat_id` int(11) NOT NULL,
901  `active` int(11) NOT NULL
902) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
903
904-- --------------------------------------------------------
905
906--
907-- Struttura della tabella `lh_chat_accept`
908--
909
910CREATE TABLE `lh_chat_accept` (
911  `id` int(11) NOT NULL,
912  `chat_id` int(11) NOT NULL,
913  `hash` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
914  `ctime` int(11) NOT NULL,
915  `wused` int(11) NOT NULL
916) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
917
918-- --------------------------------------------------------
919
920--
921-- Struttura della tabella `lh_chat_archive_range`
922--
923
924CREATE TABLE `lh_chat_archive_range` (
925  `id` int(11) NOT NULL,
926  `range_from` int(11) NOT NULL,
927  `range_to` int(11) NOT NULL,
928  `year_month` int(11) NOT NULL,
929  `older_than` int(11) NOT NULL,
930  `last_id` int(11) NOT NULL,
931  `first_id` int(11) NOT NULL
932) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
933
934-- --------------------------------------------------------
935
936--
937-- Struttura della tabella `lh_chat_blocked_user`
938--
939
940CREATE TABLE `lh_chat_blocked_user` (
941  `id` int(11) NOT NULL,
942  `ip` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
943  `user_id` int(11) NOT NULL,
944  `datets` int(11) NOT NULL
945) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
946
947-- --------------------------------------------------------
948
949--
950-- Struttura della tabella `lh_chat_config`
951--
952
953CREATE TABLE `lh_chat_config` (
954  `identifier` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
955  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
956  `type` tinyint(1) NOT NULL DEFAULT '0',
957  `explain` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
958  `hidden` int(11) NOT NULL DEFAULT '0'
959) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
960
961--
962-- Dump dei dati per la tabella `lh_chat_config`
963--
964
965INSERT INTO `lh_chat_config` (`identifier`, `value`, `type`, `explain`, `hidden`) VALUES
966('accept_chat_link_timeout', '300', 0, 'How many seconds chat accept link is valid. Set 0 to force login all the time manually.', 0),
967('accept_tos_link', '#', 0, 'Change to your site Terms of Service', 0),
968('activity_timeout', '5', 0, 'How long operator should go offline automatically because of inactivity. Value in minutes', 0),
969('activity_track_all', '0', 0, 'Track all logged operators activity and ignore their individual settings.', 0),
970('allow_reopen_closed', '1', 0, 'Allow user to reopen closed chats?', 0),
971('application_name', 'a:6:{s:3:\"eng\";s:31:\"Live Helper Chat - live support\";s:3:\"lit\";s:26:\"Live Helper Chat - pagalba\";s:3:\"hrv\";s:0:\"\";s:3:\"esp\";s:0:\"\";s:3:\"por\";s:0:\"\";s:10:\"site_admin\";s:31:\"Live Helper Chat - live support\";}', 1, 'Support application name, visible in browser title.', 0),
972('assign_workflow_timeout', '0', 0, 'Chats waiting in pending line more than n seconds should be auto assigned first. Time in seconds', 0),
973('autoclose_timeout', '0', 0, 'Automatic chats closing. 0 - disabled, n > 0 time in minutes before chat is automatically closed', 0),
974('autoclose_timeout_active', '0', 0, 'Automatic active chats closing. 0 - disabled, n > 0 time in minutes before chat is automatically closed', 0),
975('autoclose_timeout_bot', '0', 0, 'Automatic bot chats closing. 0 - disabled, n > 0 time in minutes before chat is automatically closed', 0),
976('autoclose_timeout_pending', '0', 0, 'Automatic pending chats closing. 0 - disabled, n > 0 time in minutes before chat is automatically closed', 0),
977('autologin_data', 'a:3:{i:0;b:0;s:11:\"secret_hash\";s:16:\"please_change_me\";s:7:\"enabled\";i:0;}', 0, 'Autologin configuration data', 1),
978('automatically_reopen_chat', '1', 0, 'Automatically reopen chat on widget open', 0),
979('autopurge_timeout', '0', 0, 'Automatic chats purging. 0 - disabled, n > 0 time in minutes before chat is automatically deleted', 0),
980('banned_ip_range', '', 0, 'Which ip should not be allowed to chat', 0),
981('bbc_button_visible', '1', 0, 'Show BB Code button', 0),
982('cduration_timeout_operator', '10', 0, 'How long visitor can wait for message from operator before time between messages are ignored. Values in minutes.', 0),
983('cduration_timeout_user', '4', 0, 'How long operator can wait for message from visitor before time between messages are ignored. Values in minutes.', 0),
984('chatbox_data', 'a:6:{i:0;b:0;s:20:\"chatbox_auto_enabled\";i:0;s:19:\"chatbox_secret_hash\";s:9:\"625417956\";s:20:\"chatbox_default_name\";s:7:\"Chatbox\";s:17:\"chatbox_msg_limit\";i:50;s:22:\"chatbox_default_opname\";s:7:\"Manager\";}', 0, 'Chatbox configuration', 1),
985('checkstatus_timeout', '0', 0, 'Interval between chat status checks in seconds, 0 disabled.', 0),
986('cleanup_cronjob', '0', 0, 'Cleanup should be done only using cronjob.', 0),
987('customer_company_name', 'Live Helper Chat', 0, 'Your company name - visible in bottom left corner', 0),
988('customer_site_url', 'http://livehelperchat.com', 0, 'Your site URL address', 0),
989('dashboard_order', '[[\"online_operators\",\"departments_stats\",\"online_visitors\"],[\"my_chats\",\"pending_chats\",\"transfered_chats\"],[\"active_chats\",\"bot_chats\"]]', 0, 'Home page dashboard widgets order', 0),
990('default_admin_theme_id', '0', 0, 'Default admin theme ID', 1),
991('default_theme_id', '0', 0, 'Default theme ID.', 1),
992('departament_availability', '364', 0, 'How long department availability statistic should be kept? (days)', 0),
993('disable_html5_storage', '1', 0, 'Disable HMTL5 storage, check it if your site is switching between http and https', 0),
994('disable_iframe_sharing', '1', 0, 'Disable iframes in sharing mode', 0),
995('disable_js_execution', '1', 0, 'Disable JS execution in Co-Browsing operator window', 0),
996('disable_live_autoassign', '0', 0, 'Disable live auto assign', 0),
997('disable_popup_restore', '0', 0, 'Disable option in widget to open new window. Restore icon will be hidden', 0),
998('disable_print', '0', 0, 'Disable chat print', 0),
999('disable_send', '0', 0, 'Disable chat transcript send', 0),
1000('do_no_track_ip', '0', 0, 'Do not track visitors IP', 0),
1001('encrypt_msg_after', '0', 0, 'After how many days anonymize messages', 0),
1002('encrypt_msg_op', '0', 0, 'Anonymize also operators messages', 0),
1003('explicit_http_mode', '', 0, 'Please enter explicit http mode. Either http: or https:, do not forget : at the end.', 0),
1004('export_hash', 'd711b5799', 0, 'Chats export secret hash', 0),
1005('faq_email_required', '0', 0, 'Is visitor e-mail required for FAQ', 0),
1006('file_configuration', 'a:7:{i:0;b:0;s:5:\"ft_op\";s:47:\"gif|jpe?g|png|zip|svg|rar|xls|doc|docx|xlsx|pdf\";s:5:\"ft_us\";s:30:\"gif|jpe?g|png|svg|doc|docx|pdf\";s:6:\"fs_max\";i:2048;s:18:\"active_user_upload\";b:0;s:16:\"active_op_upload\";b:1;s:19:\"active_admin_upload\";b:1;}', 0, 'Files configuration item', 1),
1007('footprint_background', '0', 0, 'Footprint updates should be processed in the background. Make sure you are running workflow background cronjob.', 0),
1008('front_tabs', 'dashboard,online_users,online_map', 0, 'Home page tabs order', 0),
1009('geo_data', 'a:5:{i:0;b:0;s:21:\"geo_detection_enabled\";i:1;s:22:\"geo_service_identifier\";s:8:\"max_mind\";s:23:\"max_mind_detection_type\";s:7:\"country\";s:22:\"max_mind_city_location\";s:37:\"var/external/geoip/GeoLite2-City.mmdb\";}', 0, '', 1),
1010('geo_location_data', 'a:3:{s:4:\"zoom\";i:4;s:3:\"lat\";s:7:\"49.8211\";s:3:\"lng\";s:7:\"11.7835\";}', 0, '', 1),
1011('geoadjustment_data', 'a:8:{i:0;b:0;s:18:\"use_geo_adjustment\";b:0;s:13:\"available_for\";s:0:\"\";s:15:\"other_countries\";s:6:\"custom\";s:8:\"hide_for\";s:0:\"\";s:12:\"other_status\";s:7:\"offline\";s:11:\"rest_status\";s:6:\"hidden\";s:12:\"apply_widget\";i:0;}', 0, 'Geo adjustment settings', 1),
1012('hide_button_dropdown', '0', 0, 'Hide close button in dropdown', 0),
1013('hide_disabled_department', '1', 0, 'Hide disabled department widget', 0),
1014('hide_right_column_frontpage', '1', 0, 'Hide right column in frontpage', 0),
1015('ignorable_ip', '', 0, 'Which ip should be ignored in online users list, separate by comma', 0),
1016('ignore_user_status', '0', 0, 'Ignore users online statuses and use departments online hours', 0),
1017('inform_unread_message', '0', 0, 'Inform visitor about unread messages from operator, value in minutes. 0 - disabled', 0),
1018('list_closed', '0', 0, 'List closed chats', 0),
1019('list_online_operators', '1', 0, 'List online operators.', 0),
1020('list_unread', '0', 0, 'List unread chats', 0),
1021('listd_op', '10', 0, 'Default number of online operators to show', 0),
1022('max_message_length', '500', 0, 'Maximum message length in characters', 0),
1023('message_seen_timeout', '24', 0, 'Proactive message timeout in hours. After how many hours proactive chat mesasge should be shown again.', 0),
1024('mheight', '', 0, 'Messages box height', 0),
1025('mheight_op', '200', 0, 'Messages box height for operator', 0),
1026('min_phone_length', '8', 0, 'Minimum phone number length', 0),
1027('need_help_tip', '1', 0, 'Show need help tooltip?', 0),
1028('need_help_tip_timeout', '24', 0, 'Need help tooltip timeout, after how many hours show again tooltip?', 0),
1029('no_wildcard_cookie', '0', 0, 'Cookie should be valid only for domain where Javascript is embedded (excludes subdomains)', 0),
1030('on_close_exit_chat', '0', 0, 'On chat close exit chat', 0),
1031('online_if', '0', 0, '', 0),
1032('open_closed_chat_timeout', '1800', 0, 'How many seconds customer has to open already closed chat.', 0),
1033('paidchat_data', '', 0, 'Paid chat configuration', 1),
1034('password_data', '', 0, 'Password requirements', 1),
1035('preload_iframes', '0', 0, 'Preload widget. It will avoid loading delay after clicking widget', 0),
1036('pro_active_invite', '1', 0, 'Is pro active chat invitation active. Online users tracking also has to be enabled', 0),
1037('pro_active_limitation', '-1', 0, 'Pro active chats invitations limitation based on pending chats, (-1) do not limit, (0,1,n+1) number of pending chats can be for invitation to be shown.', 0),
1038('pro_active_show_if_offline', '0', 0, 'Should invitation logic be executed if there is no online operators', 0),
1039('product_enabled_module', '0', 0, 'Product module is enabled', 1),
1040('product_show_departament', '0', 0, 'Enable products show by departments', 1),
1041('recaptcha_data', 'a:4:{i:0;b:0;s:8:\"site_key\";s:0:\"\";s:10:\"secret_key\";s:0:\"\";s:7:\"enabled\";i:0;}', 0, 'Re-captcha configuration', 1),
1042('reopen_as_new', '1', 0, 'Reopen closed chat as new? Otherwise it will be reopened as active.', 0),
1043('reopen_chat_enabled', '1', 0, 'Reopen chat functionality enabled', 0),
1044('reverse_pending', '0', 0, 'Make default pending chats order from old to new', 0),
1045('run_departments_workflow', '0', 0, 'Should cronjob run departments transfer workflow, even if user leaves a chat', 0),
1046('run_unaswered_chat_workflow', '0', 0, 'Should cronjob run unanswered chats workflow and execute unaswered chats callback, 0 - no, any other number bigger than 0 is a minits how long chat have to be not accepted before executing callback.', 0),
1047('session_captcha', '0', 0, 'Use session captcha. LHC have to be installed on the same domain or subdomain.', 0),
1048('sharing_auto_allow', '0', 0, 'Do not ask permission for users to see their screen', 0),
1049('sharing_nodejs_enabled', '0', 0, 'NodeJs support enabled', 0),
1050('sharing_nodejs_path', '', 0, 'socket.io path, optional', 0),
1051('sharing_nodejs_secure', '0', 0, 'Connect to NodeJs in https mode', 0),
1052('sharing_nodejs_sllocation', 'https://cdn.jsdelivr.net/npm/socket.io-client@2/dist/socket.io.js', 0, 'Location of SocketIO JS library', 0),
1053('sharing_nodejs_socket_host', '', 0, 'Host where NodeJs is running', 0),
1054('show_language_switcher', '0', 0, 'Show users option to switch language at widget', 0),
1055('show_languages', 'eng,lit,hrv,esp,por,nld,ara,ger,pol,rus,ita,fre,chn,cse,nor,tur,vnm,idn,sve,per,ell,dnk,rou,bgr,tha,geo,fin,alb', 0, 'Between what languages user should be able to switch', 0),
1056('smtp_data', 'a:5:{s:4:\"host\";s:0:\"\";s:4:\"port\";s:2:\"25\";s:8:\"use_smtp\";i:0;s:8:\"username\";s:0:\"\";s:8:\"password\";s:0:\"\";}', 0, 'SMTP configuration', 1),
1057('sound_invitation', '1', 0, 'Play sound on invitation to chat.', 0),
1058('speech_data', 'a:3:{i:0;b:0;s:8:\"language\";i:7;s:7:\"dialect\";s:5:\"en-US\";}', 1, '', 1),
1059('start_chat_data', 'a:23:{i:0;b:0;s:21:\"name_visible_in_popup\";b:1;s:27:\"name_visible_in_page_widget\";b:1;s:19:\"name_require_option\";s:8:\"required\";s:22:\"email_visible_in_popup\";b:0;s:28:\"email_visible_in_page_widget\";b:0;s:20:\"email_require_option\";s:8:\"required\";s:24:\"message_visible_in_popup\";b:1;s:30:\"message_visible_in_page_widget\";b:1;s:22:\"message_require_option\";s:8:\"required\";s:22:\"phone_visible_in_popup\";b:0;s:28:\"phone_visible_in_page_widget\";b:0;s:20:\"phone_require_option\";s:8:\"required\";s:21:\"force_leave_a_message\";b:0;s:29:\"offline_name_visible_in_popup\";b:1;s:35:\"offline_name_visible_in_page_widget\";b:1;s:27:\"offline_name_require_option\";s:8:\"required\";s:30:\"offline_phone_visible_in_popup\";b:0;s:36:\"offline_phone_visible_in_page_widget\";b:0;s:28:\"offline_phone_require_option\";s:8:\"required\";s:32:\"offline_message_visible_in_popup\";b:1;s:38:\"offline_message_visible_in_page_widget\";b:1;s:30:\"offline_message_require_option\";s:8:\"required\";}', 0, '', 1),
1060('suggest_leave_msg', '1', 0, 'Suggest user to leave a message then user chooses offline department', 0),
1061('sync_sound_settings', 'a:16:{i:0;b:0;s:12:\"repeat_sound\";i:1;s:18:\"repeat_sound_delay\";i:5;s:10:\"show_alert\";b:0;s:22:\"new_chat_sound_enabled\";b:1;s:31:\"new_message_sound_admin_enabled\";b:1;s:30:\"new_message_sound_user_enabled\";b:1;s:14:\"online_timeout\";d:300;s:22:\"check_for_operator_msg\";d:10;s:21:\"back_office_sinterval\";d:10;s:22:\"chat_message_sinterval\";d:3.5;s:20:\"long_polling_enabled\";b:0;s:30:\"polling_chat_message_sinterval\";d:1.5;s:29:\"polling_back_office_sinterval\";d:5;s:18:\"connection_timeout\";i:30;s:28:\"browser_notification_message\";b:0;}', 0, '', 1),
1062('track_activity', '0', 0, 'Track users activity on site?', 0),
1063('track_domain', '', 0, 'Set your domain to enable user tracking across different domain subdomains.', 0),
1064('track_footprint', '0', 0, 'Track users footprint. For this also online visitors tracking should be enabled', 0),
1065('track_if_offline', '0', 0, 'Track online visitors even if there is no online operators', 0),
1066('track_is_online', '0', 0, 'Track is user still on site, chat status checks also has to be enabled', 0),
1067('track_mouse_activity', '0', 0, 'Should mouse movement be tracked as activity measure, if not checked only basic events would be tracked', 0),
1068('track_online_visitors', '1', 0, 'Enable online site visitors tracking', 0),
1069('tracked_footprint_cleanup', '90', 0, 'How many days keep records of users footprint.', 0),
1070('tracked_users_cleanup', '160', 0, 'How many days keep records of online users.', 0),
1071('tracked_users_cleanup_last', '1586009663', 0, 'Track last cleanup', 1),
1072('transfer_configuration', '0', 0, 'Transfer configuration', 1),
1073('translation_data', 'a:6:{i:0;b:0;s:19:\"translation_handler\";s:4:\"bing\";s:19:\"enable_translations\";b:0;s:14:\"bing_client_id\";s:0:\"\";s:18:\"bing_client_secret\";s:0:\"\";s:14:\"google_api_key\";s:0:\"\";}', 0, 'Translation data', 1),
1074('uonline_sessions', '364', 0, 'How long keep operators online sessions data? (days)', 0),
1075('update_ip', '127.0.0.1', 0, 'Which ip should be allowed to update DB by executing http request, separate by comma?', 0),
1076('use_secure_cookie', '0', 0, 'Use secure cookie, check this if you want to force SSL all the time', 0),
1077('voting_days_limit', '7', 0, 'How many days voting widget should not be expanded after last show', 0),
1078('xmp_data', 'a:14:{i:0;b:0;s:4:\"host\";s:15:\"talk.google.com\";s:6:\"server\";s:9:\"gmail.com\";s:8:\"resource\";s:6:\"xmpphp\";s:4:\"port\";s:4:\"5222\";s:7:\"use_xmp\";i:0;s:8:\"username\";s:0:\"\";s:8:\"password\";s:0:\"\";s:11:\"xmp_message\";s:98:\"New chat request [{chat_id}] from [{department}]\r\n{messages}\r\nClick to accept a chat\r\n{url_accept}\";s:10:\"recipients\";s:0:\"\";s:20:\"xmp_accepted_message\";s:89:\"{user_name} has accepted a chat [{chat_id}] from [{department}]\r\n{messages}\r\n{url_accept}\";s:16:\"use_standard_xmp\";i:0;s:15:\"test_recipients\";s:0:\"\";s:21:\"test_group_recipients\";s:0:\"\";}', 0, 'XMP data', 1);
1079
1080-- --------------------------------------------------------
1081
1082--
1083-- Struttura della tabella `lh_chat_file`
1084--
1085
1086CREATE TABLE `lh_chat_file` (
1087  `id` int(11) UNSIGNED NOT NULL,
1088  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1089  `upload_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1090  `size` int(11) NOT NULL,
1091  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1092  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1093  `extension` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1094  `chat_id` int(11) NOT NULL,
1095  `persistent` int(11) NOT NULL,
1096  `online_user_id` int(11) NOT NULL,
1097  `user_id` int(11) NOT NULL,
1098  `date` int(11) NOT NULL
1099) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1100
1101-- --------------------------------------------------------
1102
1103--
1104-- Struttura della tabella `lh_chat_online_user`
1105--
1106
1107CREATE TABLE `lh_chat_online_user` (
1108  `id` int(11) NOT NULL,
1109  `vid` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1110  `ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1111  `current_page` text COLLATE utf8mb4_unicode_ci NOT NULL,
1112  `page_title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1113  `referrer` text COLLATE utf8mb4_unicode_ci NOT NULL,
1114  `chat_id` int(11) NOT NULL,
1115  `invitation_seen_count` int(11) NOT NULL,
1116  `invitation_id` int(11) NOT NULL,
1117  `last_visit` int(11) NOT NULL,
1118  `first_visit` int(11) NOT NULL,
1119  `total_visits` int(11) NOT NULL,
1120  `pages_count` int(11) NOT NULL,
1121  `tt_pages_count` int(11) NOT NULL,
1122  `invitation_count` int(11) NOT NULL,
1123  `last_check_time` int(11) NOT NULL,
1124  `dep_id` int(11) NOT NULL,
1125  `user_agent` text COLLATE utf8mb4_unicode_ci NOT NULL,
1126  `notes` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1127  `user_country_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1128  `user_country_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1129  `visitor_tz` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1130  `operator_message` text COLLATE utf8mb4_unicode_ci NOT NULL,
1131  `operator_user_proactive` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1132  `operator_user_id` int(11) NOT NULL,
1133  `conversion_id` int(11) NOT NULL,
1134  `message_seen` int(11) NOT NULL,
1135  `message_seen_ts` int(11) NOT NULL,
1136  `user_active` int(11) NOT NULL,
1137  `lat` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
1138  `lon` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
1139  `city` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1140  `reopen_chat` int(11) NOT NULL,
1141  `time_on_site` int(11) NOT NULL,
1142  `tt_time_on_site` int(11) NOT NULL,
1143  `requires_email` int(11) NOT NULL,
1144  `requires_username` int(11) NOT NULL,
1145  `requires_phone` int(11) NOT NULL,
1146  `screenshot_id` int(11) NOT NULL,
1147  `identifier` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1148  `operation` text COLLATE utf8mb4_unicode_ci NOT NULL,
1149  `online_attr_system` text COLLATE utf8mb4_unicode_ci NOT NULL,
1150  `operation_chat` text COLLATE utf8mb4_unicode_ci NOT NULL,
1151  `online_attr` text COLLATE utf8mb4_unicode_ci NOT NULL
1152) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1153
1154--
1155-- Dump dei dati per la tabella `lh_chat_online_user`
1156--
1157
1158INSERT INTO `lh_chat_online_user` (`id`, `vid`, `ip`, `current_page`, `page_title`, `referrer`, `chat_id`, `invitation_seen_count`, `invitation_id`, `last_visit`, `first_visit`, `total_visits`, `pages_count`, `tt_pages_count`, `invitation_count`, `last_check_time`, `dep_id`, `user_agent`, `notes`, `user_country_code`, `user_country_name`, `visitor_tz`, `operator_message`, `operator_user_proactive`, `operator_user_id`, `conversion_id`, `message_seen`, `message_seen_ts`, `user_active`, `lat`, `lon`, `city`, `reopen_chat`, `time_on_site`, `tt_time_on_site`, `requires_email`, `requires_username`, `requires_phone`, `screenshot_id`, `identifier`, `operation`, `online_attr_system`, `operation_chat`, `online_attr`) VALUES
1159(3, '1323707a0c4beed8aa9f', '151.29.26.47', 'https://host.hydromc.org/', 'Home - HydroMC Host', '', 0, 0, 0, 1585848037, 1585848026, 1, 2, 2, 0, 1585848037, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.116 Safari/537.36 OPR/67.0.3575.105', '', 'it', 'Italy', 'Europe/Paris', '', '', 0, 0, 0, 0, 1, '', '', '', 0, 11, 11, 0, 0, 0, 0, '', '', '', '', ''),
1160(4, '4c5e19327ea139ccda67', '79.19.179.206', 'https://host.hydromc.org/', 'Home - HydroMC Host', '', 0, 0, 0, 1586175994, 1586009665, 2, 1, 2, 0, 1586175994, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36', '', 'it', 'Italy', 'Europe/Paris', '', '', 0, 0, 0, 0, 1, '', '', '', 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '');
1161
1162-- --------------------------------------------------------
1163
1164--
1165-- Struttura della tabella `lh_chat_online_user_footprint`
1166--
1167
1168CREATE TABLE `lh_chat_online_user_footprint` (
1169  `id` int(11) NOT NULL,
1170  `chat_id` int(11) NOT NULL,
1171  `online_user_id` int(11) NOT NULL,
1172  `page` varchar(2083) COLLATE utf8mb4_unicode_ci NOT NULL,
1173  `vtime` int(11) NOT NULL
1174) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1175
1176-- --------------------------------------------------------
1177
1178--
1179-- Struttura della tabella `lh_chat_online_user_footprint_update`
1180--
1181
1182CREATE TABLE `lh_chat_online_user_footprint_update` (
1183  `online_user_id` bigint(20) NOT NULL,
1184  `command` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
1185  `args` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1186  `ctime` int(11) NOT NULL
1187) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1188
1189-- --------------------------------------------------------
1190
1191--
1192-- Struttura della tabella `lh_chat_paid`
1193--
1194
1195CREATE TABLE `lh_chat_paid` (
1196  `id` int(11) NOT NULL,
1197  `hash` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1198  `chat_id` int(11) NOT NULL
1199) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1200
1201-- --------------------------------------------------------
1202
1203--
1204-- Struttura della tabella `lh_chat_start_settings`
1205--
1206
1207CREATE TABLE `lh_chat_start_settings` (
1208  `id` int(11) NOT NULL,
1209  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1210  `data` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
1211  `department_id` int(11) NOT NULL
1212) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1213
1214-- --------------------------------------------------------
1215
1216--
1217-- Struttura della tabella `lh_cobrowse`
1218--
1219
1220CREATE TABLE `lh_cobrowse` (
1221  `id` int(11) NOT NULL,
1222  `chat_id` int(11) NOT NULL,
1223  `online_user_id` int(11) NOT NULL,
1224  `mtime` int(11) NOT NULL,
1225  `url` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1226  `initialize` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
1227  `modifications` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
1228  `finished` tinyint(1) NOT NULL,
1229  `w` int(11) NOT NULL,
1230  `wh` int(11) NOT NULL,
1231  `x` int(11) NOT NULL,
1232  `y` int(11) NOT NULL
1233) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1234
1235-- --------------------------------------------------------
1236
1237--
1238-- Struttura della tabella `lh_departament`
1239--
1240
1241CREATE TABLE `lh_departament` (
1242  `id` int(11) NOT NULL,
1243  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1244  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1245  `xmpp_recipients` text COLLATE utf8mb4_unicode_ci NOT NULL,
1246  `xmpp_group_recipients` text COLLATE utf8mb4_unicode_ci NOT NULL,
1247  `priority` int(11) NOT NULL,
1248  `sort_priority` int(11) NOT NULL,
1249  `department_transfer_id` int(11) NOT NULL,
1250  `transfer_timeout` int(11) NOT NULL,
1251  `exclude_inactive_chats` int(11) NOT NULL,
1252  `delay_before_assign` int(11) NOT NULL,
1253  `max_ac_dep_chats` int(11) NOT NULL,
1254  `assign_same_language` int(11) NOT NULL,
1255  `disabled` int(11) NOT NULL,
1256  `hidden` int(11) NOT NULL,
1257  `delay_lm` int(11) NOT NULL,
1258  `max_active_chats` int(11) NOT NULL,
1259  `max_timeout_seconds` int(11) NOT NULL,
1260  `identifier` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1261  `mod_start_hour` int(4) NOT NULL DEFAULT '-1',
1262  `mod_end_hour` int(4) NOT NULL DEFAULT '-1',
1263  `tud_start_hour` int(4) NOT NULL DEFAULT '-1',
1264  `tud_end_hour` int(4) NOT NULL DEFAULT '-1',
1265  `wed_start_hour` int(4) NOT NULL DEFAULT '-1',
1266  `wed_end_hour` int(4) NOT NULL DEFAULT '-1',
1267  `thd_start_hour` int(4) NOT NULL DEFAULT '-1',
1268  `thd_end_hour` int(4) NOT NULL DEFAULT '-1',
1269  `frd_start_hour` int(4) NOT NULL DEFAULT '-1',
1270  `frd_end_hour` int(4) NOT NULL DEFAULT '-1',
1271  `sad_start_hour` int(4) NOT NULL DEFAULT '-1',
1272  `sad_end_hour` int(4) NOT NULL DEFAULT '-1',
1273  `sud_start_hour` int(4) NOT NULL DEFAULT '-1',
1274  `sud_end_hour` int(4) NOT NULL DEFAULT '-1',
1275  `nc_cb_execute` tinyint(1) NOT NULL,
1276  `na_cb_execute` tinyint(1) NOT NULL,
1277  `inform_unread` tinyint(1) NOT NULL,
1278  `active_balancing` tinyint(1) NOT NULL,
1279  `visible_if_online` tinyint(1) NOT NULL,
1280  `inform_close` int(11) NOT NULL,
1281  `inform_unread_delay` int(11) NOT NULL,
1282  `inform_options` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1283  `online_hours_active` tinyint(1) NOT NULL,
1284  `inform_delay` int(11) NOT NULL,
1285  `attr_int_1` int(11) NOT NULL,
1286  `attr_int_2` int(11) NOT NULL,
1287  `attr_int_3` int(11) NOT NULL,
1288  `pending_max` int(11) NOT NULL,
1289  `pending_group_max` int(11) NOT NULL,
1290  `active_chats_counter` int(11) NOT NULL,
1291  `pending_chats_counter` int(11) NOT NULL,
1292  `closed_chats_counter` int(11) NOT NULL,
1293  `inform_close_all` int(11) NOT NULL,
1294  `inform_close_all_email` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1295  `product_configuration` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1296  `bot_configuration` text COLLATE utf8mb4_unicode_ci NOT NULL
1297) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1298
1299--
1300-- Dump dei dati per la tabella `lh_departament`
1301--
1302
1303INSERT INTO `lh_departament` (`id`, `name`, `email`, `xmpp_recipients`, `xmpp_group_recipients`, `priority`, `sort_priority`, `department_transfer_id`, `transfer_timeout`, `exclude_inactive_chats`, `delay_before_assign`, `max_ac_dep_chats`, `assign_same_language`, `disabled`, `hidden`, `delay_lm`, `max_active_chats`, `max_timeout_seconds`, `identifier`, `mod_start_hour`, `mod_end_hour`, `tud_start_hour`, `tud_end_hour`, `wed_start_hour`, `wed_end_hour`, `thd_start_hour`, `thd_end_hour`, `frd_start_hour`, `frd_end_hour`, `sad_start_hour`, `sad_end_hour`, `sud_start_hour`, `sud_end_hour`, `nc_cb_execute`, `na_cb_execute`, `inform_unread`, `active_balancing`, `visible_if_online`, `inform_close`, `inform_unread_delay`, `inform_options`, `online_hours_active`, `inform_delay`, `attr_int_1`, `attr_int_2`, `attr_int_3`, `pending_max`, `pending_group_max`, `active_chats_counter`, `pending_chats_counter`, `closed_chats_counter`, `inform_close_all`, `inform_close_all_email`, `product_configuration`, `bot_configuration`) VALUES
1304(1, 'Community Manager', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '');
1305
1306-- --------------------------------------------------------
1307
1308--
1309-- Struttura della tabella `lh_departament_availability`
1310--
1311
1312CREATE TABLE `lh_departament_availability` (
1313  `id` bigint(20) NOT NULL,
1314  `dep_id` int(11) NOT NULL,
1315  `hour` int(11) NOT NULL,
1316  `hourminute` int(4) NOT NULL,
1317  `minute` int(11) NOT NULL,
1318  `time` int(11) NOT NULL,
1319  `ymdhi` bigint(20) NOT NULL,
1320  `ymd` int(11) NOT NULL,
1321  `status` int(11) NOT NULL
1322) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1323
1324-- --------------------------------------------------------
1325
1326--
1327-- Struttura della tabella `lh_departament_custom_work_hours`
1328--
1329
1330CREATE TABLE `lh_departament_custom_work_hours` (
1331  `id` int(11) NOT NULL,
1332  `dep_id` int(11) NOT NULL,
1333  `date_from` int(11) NOT NULL,
1334  `date_to` int(11) NOT NULL,
1335  `start_hour` int(11) NOT NULL,
1336  `end_hour` int(11) NOT NULL
1337) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1338
1339-- --------------------------------------------------------
1340
1341--
1342-- Struttura della tabella `lh_departament_group`
1343--
1344
1345CREATE TABLE `lh_departament_group` (
1346  `id` int(11) NOT NULL,
1347  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL
1348) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1349
1350-- --------------------------------------------------------
1351
1352--
1353-- Struttura della tabella `lh_departament_group_member`
1354--
1355
1356CREATE TABLE `lh_departament_group_member` (
1357  `id` int(11) NOT NULL,
1358  `dep_id` int(11) NOT NULL,
1359  `dep_group_id` int(11) NOT NULL
1360) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1361
1362-- --------------------------------------------------------
1363
1364--
1365-- Struttura della tabella `lh_departament_group_user`
1366--
1367
1368CREATE TABLE `lh_departament_group_user` (
1369  `id` int(11) NOT NULL,
1370  `dep_group_id` int(11) NOT NULL,
1371  `user_id` int(11) NOT NULL
1372) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1373
1374-- --------------------------------------------------------
1375
1376--
1377-- Struttura della tabella `lh_departament_limit_group`
1378--
1379
1380CREATE TABLE `lh_departament_limit_group` (
1381  `id` int(11) NOT NULL,
1382  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1383  `pending_max` int(11) NOT NULL
1384) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1385
1386-- --------------------------------------------------------
1387
1388--
1389-- Struttura della tabella `lh_departament_limit_group_member`
1390--
1391
1392CREATE TABLE `lh_departament_limit_group_member` (
1393  `id` int(11) NOT NULL,
1394  `dep_id` int(11) NOT NULL,
1395  `dep_limit_group_id` int(11) NOT NULL
1396) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1397
1398-- --------------------------------------------------------
1399
1400--
1401-- Struttura della tabella `lh_faq`
1402--
1403
1404CREATE TABLE `lh_faq` (
1405  `id` int(11) NOT NULL,
1406  `question` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1407  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
1408  `url` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1409  `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1410  `identifier` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
1411  `active` int(11) NOT NULL,
1412  `has_url` tinyint(1) NOT NULL,
1413  `is_wildcard` tinyint(1) NOT NULL
1414) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1415
1416-- --------------------------------------------------------
1417
1418--
1419-- Struttura della tabella `lh_forgotpasswordhash`
1420--
1421
1422CREATE TABLE `lh_forgotpasswordhash` (
1423  `id` int(11) NOT NULL,
1424  `user_id` int(11) NOT NULL,
1425  `hash` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
1426  `created` int(11) NOT NULL
1427) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1428
1429-- --------------------------------------------------------
1430
1431--
1432-- Struttura della tabella `lh_generic_bot_bot`
1433--
1434
1435CREATE TABLE `lh_generic_bot_bot` (
1436  `id` bigint(20) NOT NULL,
1437  `configuration` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
1438  `filename` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1439  `filepath` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1440  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1441  `nick` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1442  `attr_str_1` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1443  `attr_str_2` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1444  `attr_str_3` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
1445) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1446
1447-- --------------------------------------------------------
1448
1449--
1450-- Struttura della tabella `lh_generic_bot_chat_event`
1451--
1452
1453CREATE TABLE `lh_generic_bot_chat_event` (
1454  `id` bigint(20) NOT NULL,
1455  `chat_id` bigint(20) NOT NULL,
1456  `counter` int(11) NOT NULL,
1457  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
1458  `ctime` int(11) NOT NULL
1459) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1460
1461-- --------------------------------------------------------
1462
1463--
1464-- Struttura della tabella `lh_generic_bot_chat_workflow`
1465--
1466
1467CREATE TABLE `lh_generic_bot_chat_workflow` (
1468  `id` bigint(20) NOT NULL,
1469  `chat_id` bigint(20) NOT NULL,
1470  `trigger_id` bigint(20) NOT NULL,
1471  `time` int(11) NOT NULL,
1472  `identifier` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1473  `status` int(11) NOT NULL,
1474  `collected_data` text COLLATE utf8mb4_unicode_ci
1475) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1476
1477-- --------------------------------------------------------
1478
1479--
1480-- Struttura della tabella `lh_generic_bot_exception`
1481--
1482
1483CREATE TABLE `lh_generic_bot_exception` (
1484  `id` bigint(20) NOT NULL,
1485  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1486  `priority` int(11) NOT NULL,
1487  `active` tinyint(1) NOT NULL
1488) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1489
1490-- --------------------------------------------------------
1491
1492--
1493-- Struttura della tabella `lh_generic_bot_exception_message`
1494--
1495
1496CREATE TABLE `lh_generic_bot_exception_message` (
1497  `id` bigint(20) NOT NULL,
1498  `code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
1499  `exception_group_id` int(11) NOT NULL,
1500  `priority` int(11) NOT NULL,
1501  `active` tinyint(1) NOT NULL,
1502  `message` text COLLATE utf8mb4_unicode_ci NOT NULL
1503) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1504
1505-- --------------------------------------------------------
1506
1507--
1508-- Struttura della tabella `lh_generic_bot_group`
1509--
1510
1511CREATE TABLE `lh_generic_bot_group` (
1512  `id` bigint(20) NOT NULL,
1513  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1514  `bot_id` bigint(20) NOT NULL
1515) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1516
1517-- --------------------------------------------------------
1518
1519--
1520-- Struttura della tabella `lh_generic_bot_payload`
1521--
1522
1523CREATE TABLE `lh_generic_bot_payload` (
1524  `id` bigint(20) NOT NULL,
1525  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1526  `payload` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1527  `bot_id` int(11) NOT NULL,
1528  `trigger_id` int(11) NOT NULL
1529) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1530
1531-- --------------------------------------------------------
1532
1533--
1534-- Struttura della tabella `lh_generic_bot_pending_event`
1535--
1536
1537CREATE TABLE `lh_generic_bot_pending_event` (
1538  `id` bigint(20) NOT NULL,
1539  `chat_id` bigint(20) NOT NULL,
1540  `trigger_id` int(11) NOT NULL
1541) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1542
1543-- --------------------------------------------------------
1544
1545--
1546-- Struttura della tabella `lh_generic_bot_repeat_restrict`
1547--
1548
1549CREATE TABLE `lh_generic_bot_repeat_restrict` (
1550  `id` bigint(20) NOT NULL,
1551  `chat_id` bigint(20) NOT NULL,
1552  `trigger_id` bigint(20) DEFAULT NULL,
1553  `counter` int(11) DEFAULT '0'
1554) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1555
1556-- --------------------------------------------------------
1557
1558--
1559-- Struttura della tabella `lh_generic_bot_trigger`
1560--
1561
1562CREATE TABLE `lh_generic_bot_trigger` (
1563  `id` bigint(20) NOT NULL,
1564  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1565  `actions` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
1566  `group_id` bigint(20) NOT NULL,
1567  `bot_id` int(11) NOT NULL,
1568  `default` int(11) NOT NULL,
1569  `default_unknown` int(11) NOT NULL,
1570  `default_always` int(11) NOT NULL
1571) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1572
1573-- --------------------------------------------------------
1574
1575--
1576-- Struttura della tabella `lh_generic_bot_trigger_event`
1577--
1578
1579CREATE TABLE `lh_generic_bot_trigger_event` (
1580  `id` bigint(20) NOT NULL,
1581  `pattern` text COLLATE utf8mb4_unicode_ci NOT NULL,
1582  `pattern_exc` text COLLATE utf8mb4_unicode_ci NOT NULL,
1583  `configuration` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
1584  `trigger_id` bigint(20) NOT NULL,
1585  `bot_id` int(11) NOT NULL,
1586  `on_start_type` tinyint(1) NOT NULL,
1587  `priority` int(11) NOT NULL,
1588  `type` int(11) NOT NULL
1589) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1590
1591-- --------------------------------------------------------
1592
1593--
1594-- Struttura della tabella `lh_generic_bot_tr_group`
1595--
1596
1597CREATE TABLE `lh_generic_bot_tr_group` (
1598  `id` int(11) NOT NULL,
1599  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1600  `filename` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1601  `filepath` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1602  `configuration` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
1603  `nick` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
1604) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1605
1606-- --------------------------------------------------------
1607
1608--
1609-- Struttura della tabella `lh_generic_bot_tr_item`
1610--
1611
1612CREATE TABLE `lh_generic_bot_tr_item` (
1613  `id` int(11) NOT NULL,
1614  `group_id` int(11) NOT NULL,
1615  `identifier` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1616  `translation` text COLLATE utf8mb4_unicode_ci NOT NULL
1617) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1618
1619-- --------------------------------------------------------
1620
1621--
1622-- Struttura della tabella `lh_group`
1623--
1624
1625CREATE TABLE `lh_group` (
1626  `id` int(11) NOT NULL,
1627  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1628  `disabled` tinyint(1) NOT NULL,
1629  `required` tinyint(1) NOT NULL DEFAULT '0'
1630) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1631
1632--
1633-- Dump dei dati per la tabella `lh_group`
1634--
1635
1636INSERT INTO `lh_group` (`id`, `name`, `disabled`, `required`) VALUES
1637(1, 'Administrators', 0, 0),
1638(2, 'Operators', 0, 0);
1639
1640-- --------------------------------------------------------
1641
1642--
1643-- Struttura della tabella `lh_grouprole`
1644--
1645
1646CREATE TABLE `lh_grouprole` (
1647  `id` int(11) NOT NULL,
1648  `group_id` int(11) NOT NULL,
1649  `role_id` int(11) NOT NULL
1650) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1651
1652--
1653-- Dump dei dati per la tabella `lh_grouprole`
1654--
1655
1656INSERT INTO `lh_grouprole` (`id`, `group_id`, `role_id`) VALUES
1657(1, 1, 1),
1658(2, 2, 2);
1659
1660-- --------------------------------------------------------
1661
1662--
1663-- Struttura della tabella `lh_groupuser`
1664--
1665
1666CREATE TABLE `lh_groupuser` (
1667  `id` int(11) NOT NULL,
1668  `group_id` int(11) NOT NULL,
1669  `user_id` int(11) NOT NULL
1670) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1671
1672--
1673-- Dump dei dati per la tabella `lh_groupuser`
1674--
1675
1676INSERT INTO `lh_groupuser` (`id`, `group_id`, `user_id`) VALUES
1677(1, 1, 1),
1678(2, 1, 2);
1679
1680-- --------------------------------------------------------
1681
1682--
1683-- Struttura della tabella `lh_group_object`
1684--
1685
1686CREATE TABLE `lh_group_object` (
1687  `id` bigint(20) NOT NULL,
1688  `object_id` bigint(20) NOT NULL,
1689  `group_id` bigint(20) NOT NULL,
1690  `type` bigint(20) NOT NULL
1691) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1692
1693-- --------------------------------------------------------
1694
1695--
1696-- Struttura della tabella `lh_group_work`
1697--
1698
1699CREATE TABLE `lh_group_work` (
1700  `id` int(11) NOT NULL,
1701  `group_id` int(11) NOT NULL,
1702  `group_work_id` int(11) NOT NULL
1703) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1704
1705-- --------------------------------------------------------
1706
1707--
1708-- Struttura della tabella `lh_msg`
1709--
1710
1711CREATE TABLE `lh_msg` (
1712  `id` int(11) NOT NULL,
1713  `msg` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
1714  `meta_msg` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
1715  `time` int(11) NOT NULL,
1716  `chat_id` int(11) NOT NULL DEFAULT '0',
1717  `user_id` int(11) NOT NULL DEFAULT '0',
1718  `name_support` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
1719) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1720
1721-- --------------------------------------------------------
1722
1723--
1724-- Struttura della tabella `lh_notification_subscriber`
1725--
1726
1727CREATE TABLE `lh_notification_subscriber` (
1728  `id` bigint(20) NOT NULL,
1729  `chat_id` bigint(20) NOT NULL,
1730  `online_user_id` bigint(20) NOT NULL,
1731  `dep_id` int(11) NOT NULL,
1732  `theme_id` int(11) NOT NULL,
1733  `ctime` int(11) NOT NULL,
1734  `utime` int(11) NOT NULL,
1735  `status` int(11) NOT NULL,
1736  `params` text COLLATE utf8mb4_unicode_ci NOT NULL,
1737  `device_type` tinyint(1) NOT NULL,
1738  `subscriber_hash` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1739  `uagent` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1740  `ip` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1741  `last_error` text COLLATE utf8mb4_unicode_ci NOT NULL
1742) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1743
1744-- --------------------------------------------------------
1745
1746--
1747-- Struttura della tabella `lh_question`
1748--
1749
1750CREATE TABLE `lh_question` (
1751  `id` int(11) NOT NULL,
1752  `question` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1753  `location` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1754  `active` int(11) NOT NULL,
1755  `priority` int(11) NOT NULL,
1756  `is_voting` int(11) NOT NULL,
1757  `question_intro` text COLLATE utf8mb4_unicode_ci NOT NULL,
1758  `revote` int(11) NOT NULL DEFAULT '0'
1759) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1760
1761-- --------------------------------------------------------
1762
1763--
1764-- Struttura della tabella `lh_question_answer`
1765--
1766
1767CREATE TABLE `lh_question_answer` (
1768  `id` int(11) NOT NULL,
1769  `ip` bigint(20) NOT NULL,
1770  `question_id` int(11) NOT NULL,
1771  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
1772  `ctime` int(11) NOT NULL
1773) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1774
1775-- --------------------------------------------------------
1776
1777--
1778-- Struttura della tabella `lh_question_option`
1779--
1780
1781CREATE TABLE `lh_question_option` (
1782  `id` int(11) NOT NULL,
1783  `question_id` int(11) NOT NULL,
1784  `option_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
1785  `priority` tinyint(4) NOT NULL
1786) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1787
1788-- --------------------------------------------------------
1789
1790--
1791-- Struttura della tabella `lh_question_option_answer`
1792--
1793
1794CREATE TABLE `lh_question_option_answer` (
1795  `id` int(11) NOT NULL,
1796  `question_id` int(11) NOT NULL,
1797  `option_id` int(11) NOT NULL,
1798  `ctime` int(11) NOT NULL,
1799  `ip` bigint(20) NOT NULL
1800) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1801
1802-- --------------------------------------------------------
1803
1804--
1805-- Struttura della tabella `lh_role`
1806--
1807
1808CREATE TABLE `lh_role` (
1809  `id` int(11) NOT NULL,
1810  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL
1811) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1812
1813--
1814-- Dump dei dati per la tabella `lh_role`
1815--
1816
1817INSERT INTO `lh_role` (`id`, `name`) VALUES
1818(1, 'Administrators'),
1819(2, 'Operators');
1820
1821-- --------------------------------------------------------
1822
1823--
1824-- Struttura della tabella `lh_rolefunction`
1825--
1826
1827CREATE TABLE `lh_rolefunction` (
1828  `id` int(11) NOT NULL,
1829  `role_id` int(11) NOT NULL,
1830  `module` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1831  `function` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1832  `limitation` text COLLATE utf8mb4_unicode_ci NOT NULL
1833) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1834
1835--
1836-- Dump dei dati per la tabella `lh_rolefunction`
1837--
1838
1839INSERT INTO `lh_rolefunction` (`id`, `role_id`, `module`, `function`, `limitation`) VALUES
1840(1, 1, '*', '*', ''),
1841(2, 2, 'lhuser', 'selfedit', ''),
1842(3, 2, 'lhuser', 'changeonlinestatus', ''),
1843(4, 2, 'lhuser', 'changeskypenick', ''),
1844(5, 2, 'lhuser', 'personalcannedmsg', ''),
1845(6, 2, 'lhuser', 'change_visibility_list', ''),
1846(7, 2, 'lhuser', 'see_assigned_departments', ''),
1847(8, 2, 'lhuser', 'canseedepartmentstats', ''),
1848(9, 2, 'lhchat', 'use', ''),
1849(10, 2, 'lhchat', 'open_all', ''),
1850(11, 2, 'lhchat', 'chattabschrome', ''),
1851(12, 2, 'lhchat', 'singlechatwindow', ''),
1852(13, 2, 'lhchat', 'allowopenremotechat', ''),
1853(14, 2, 'lhchat', 'allowchattabs', ''),
1854(15, 2, 'lhchat', 'use_onlineusers', ''),
1855(16, 2, 'lhchat', 'take_screenshot', ''),
1856(17, 2, 'lhfront', 'use', ''),
1857(18, 2, 'lhsystem', 'use', ''),
1858(19, 2, 'lhtranslation', 'use', ''),
1859(20, 2, 'lhchat', 'allowblockusers', ''),
1860(21, 2, 'lhsystem', 'generatejs', ''),
1861(22, 2, 'lhsystem', 'changelanguage', ''),
1862(23, 2, 'lhchat', 'allowredirect', ''),
1863(24, 2, 'lhchat', 'allowtransfer', ''),
1864(25, 2, 'lhchat', 'allowtransferdirectly', ''),
1865(26, 2, 'lhchat', 'administratecannedmsg', ''),
1866(27, 2, 'lhchat', 'sees_all_online_visitors', ''),
1867(28, 2, 'lhpermission', 'see_permissions', ''),
1868(29, 2, 'lhquestionary', 'manage_questionary', ''),
1869(30, 2, 'lhfaq', 'manage_faq', ''),
1870(31, 2, 'lhchatbox', 'manage_chatbox', ''),
1871(32, 2, 'lhbrowseoffer', 'manage_bo', ''),
1872(33, 2, 'lhxml', '*', ''),
1873(34, 2, 'lhcobrowse', 'browse', ''),
1874(35, 2, 'lhfile', 'use_operator', ''),
1875(36, 2, 'lhfile', 'file_delete_chat', ''),
1876(37, 2, 'lhstatistic', 'use', ''),
1877(38, 2, 'lhspeech', 'changedefaultlanguage', ''),
1878(39, 2, 'lhspeech', 'use', ''),
1879(40, 2, 'lhcannedmsg', 'use', ''),
1880(41, 2, 'lhtheme', 'personaltheme', ''),
1881(42, 2, 'lhuser', 'userlistonline', ''),
1882(43, 2, 'lhspeech', 'change_chat_recognition', '');
1883
1884-- --------------------------------------------------------
1885
1886--
1887-- Struttura della tabella `lh_speech_chat_language`
1888--
1889
1890CREATE TABLE `lh_speech_chat_language` (
1891  `id` int(11) NOT NULL,
1892  `chat_id` int(11) NOT NULL,
1893  `language_id` int(11) NOT NULL,
1894  `dialect` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL
1895) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1896
1897-- --------------------------------------------------------
1898
1899--
1900-- Struttura della tabella `lh_speech_language`
1901--
1902
1903CREATE TABLE `lh_speech_language` (
1904  `id` int(11) NOT NULL,
1905  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1906  `siteaccess` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
1907) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1908
1909--
1910-- Dump dei dati per la tabella `lh_speech_language`
1911--
1912
1913INSERT INTO `lh_speech_language` (`id`, `name`, `siteaccess`) VALUES
1914(1, 'Afrikaans', ''),
1915(2, 'Bahasa Indonesia', ''),
1916(3, 'Bahasa Melayu', ''),
1917(4, 'Català', ''),
1918(5, 'Čeština', ''),
1919(6, 'Deutsch', 'ger'),
1920(7, 'English', ''),
1921(8, 'Español', 'esp'),
1922(9, 'Euskara', ''),
1923(10, 'Français', 'fre'),
1924(11, 'Galego', ''),
1925(12, 'Hrvatski', ''),
1926(13, 'IsiZulu', ''),
1927(14, 'Íslenska', ''),
1928(15, 'Italiano', 'ita'),
1929(16, 'Magyar', ''),
1930(17, 'Nederlands', 'nld'),
1931(18, 'Norsk bokmål', ''),
1932(19, 'Polski', 'pol'),
1933(20, 'Português', 'por'),
1934(21, 'Română', ''),
1935(22, 'Slovenčina', ''),
1936(23, 'Suomi', 'fin'),
1937(24, 'Svenska', ''),
1938(25, 'Türkçe', 'tur'),
1939(26, 'български', ''),
1940(27, 'Pусский', 'rus'),
1941(28, 'Српски', ''),
1942(29, '한국어', ''),
1943(30, '中文', ''),
1944(31, '日本語', ''),
1945(32, 'Lingua latīna', ''),
1946(33, 'Lithuanian', 'lit'),
1947(34, 'Latvia', ''),
1948(35, 'Afar', ''),
1949(36, 'Arabic', ''),
1950(37, 'Assamese', ''),
1951(38, 'Azerbaijani', ''),
1952(39, 'Bulgarian', 'bgr'),
1953(40, 'Bangla', ''),
1954(41, 'Bosnian', ''),
1955(42, 'Cakchiquel', ''),
1956(43, 'Danish', ''),
1957(44, 'Greek', ''),
1958(45, 'Estonian', ''),
1959(46, 'Persian', ''),
1960(47, 'Filipino', ''),
1961(48, 'Gujarati', ''),
1962(49, 'Hebrew', ''),
1963(50, 'Croatian', ''),
1964(51, 'Indonesia', ''),
1965(52, 'Icelandic', ''),
1966(53, 'Georgian', ''),
1967(54, 'Maori (New Zealand)', ''),
1968(55, 'Macedonian', ''),
1969(56, 'Malay (Latin)', ''),
1970(57, 'Maltese', ''),
1971(58, 'Norwegian Nynorsk', ''),
1972(59, 'Norwegian', 'nor'),
1973(60, 'Northern Sotho (South Africa)', ''),
1974(61, 'Slovenian', ''),
1975(63, 'Thai', ''),
1976(64, 'Tagalog', ''),
1977(65, 'Tongan', ''),
1978(66, 'Ukrainian', ''),
1979(67, 'Vietnamese', 'vnm'),
1980(68, 'Chinese', 'chn');
1981
1982-- --------------------------------------------------------
1983
1984--
1985-- Struttura della tabella `lh_speech_language_dialect`
1986--
1987
1988CREATE TABLE `lh_speech_language_dialect` (
1989  `id` int(11) NOT NULL,
1990  `language_id` int(11) NOT NULL,
1991  `lang_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1992  `lang_code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
1993  `short_code` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
1994) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1995
1996--
1997-- Dump dei dati per la tabella `lh_speech_language_dialect`
1998--
1999
2000INSERT INTO `lh_speech_language_dialect` (`id`, `language_id`, `lang_name`, `lang_code`, `short_code`) VALUES
2001(1, 1, 'Afrikaans', 'af-ZA', 'af'),
2002(2, 2, 'Bahasa Indonesia', 'id-ID', 'id'),
2003(3, 3, 'Bahasa Melayu', 'ms-MY', ''),
2004(4, 4, 'Català', 'ca-ES', ''),
2005(5, 5, 'Čeština', 'cs-CZ', 'cs'),
2006(6, 6, 'Deutsch', 'de-DE', 'de'),
2007(7, 7, 'Australia', 'en-AU', ''),
2008(8, 7, 'Canada', 'en-CA', ''),
2009(9, 7, 'India', 'en-IN', ''),
2010(10, 7, 'New Zealand', 'en-NZ', ''),
2011(11, 7, 'South Africa', 'en-ZA', ''),
2012(12, 7, 'United Kingdom', 'en-GB', 'en'),
2013(13, 7, 'United States', 'en-US', ''),
2014(14, 8, 'Argentina', 'es-AR', ''),
2015(15, 8, 'Bolivia', 'es-BO', ''),
2016(16, 8, 'Chile', 'es-CL', ''),
2017(17, 8, 'Colombia', 'es-CO', ''),
2018(18, 8, 'Costa Rica', 'es-CR', ''),
2019(19, 8, 'Ecuador', 'es-EC', ''),
2020(20, 8, 'El Salvador', 'es-SV', ''),
2021(21, 8, 'España', 'es-ES', 'es'),
2022(22, 8, 'Estados Unidos', 'es-US', ''),
2023(23, 8, 'Guatemala', 'es-GT', ''),
2024(24, 8, 'Honduras', 'es-HN', ''),
2025(25, 8, 'México', 'es-MX', ''),
2026(26, 8, 'Nicaragua', 'es-NI', ''),
2027(27, 8, 'Panamá', 'es-PA', ''),
2028(28, 8, 'Paraguay', 'es-PY', ''),
2029(29, 8, 'Perú', 'es-PE', ''),
2030(30, 8, 'Puerto Rico', 'es-PR', ''),
2031(31, 8, 'República Dominicana', 'es-DO', ''),
2032(32, 8, 'Uruguay', 'es-UY', ''),
2033(33, 8, 'Venezuela', 'es-VE', ''),
2034(34, 9, 'Euskara', 'eu-ES', ''),
2035(35, 10, 'Français', 'fr-FR', 'fr'),
2036(36, 11, 'Galego', 'gl-ES', ''),
2037(37, 12, 'Hrvatski', 'hr_HR', ''),
2038(38, 13, 'IsiZulu', 'zu-ZA', ''),
2039(39, 14, 'Íslenska', 'is-IS', ''),
2040(40, 15, 'Italia', 'it-IT', 'it'),
2041(41, 15, 'Svizzera', 'it-CH', 'it'),
2042(42, 16, 'Magyar', 'hu-HU', 'hu'),
2043(43, 17, 'Nederlands', 'nl-NL', 'nl'),
2044(44, 18, 'Norsk bokmål', 'nb-NO', 'nb'),
2045(45, 19, 'Polski', 'pl-PL', 'pl'),
2046(46, 20, 'Brasil', 'pt-BR', ''),
2047(47, 20, 'Portugal', 'pt-PT', 'pt'),
2048(48, 21, 'Română', 'ro-RO', 'ro'),
2049(49, 22, 'Slovenčina', 'sk-SK', 'sk'),
2050(50, 23, 'Suomi', 'fi-FI', 'fi'),
2051(51, 24, 'Swedish', 'sv-SE', 'sv'),
2052(52, 25, 'Türkçe', 'tr-TR', 'tr'),
2053(53, 26, 'български', 'bg-BG', ''),
2054(54, 27, 'Pусский', 'ru-RU', 'ru'),
2055(55, 28, 'Serbian', 'sr-RS', 'sr'),
2056(56, 29, '한국어', 'ko-KR', 'ko'),
2057(57, 30, '普通话 (中国大陆)', 'cmn-Hans-CN', ''),
2058(58, 30, '普通话 (香港)', 'cmn-Hans-HK', ''),
2059(59, 30, '中文 (台灣)', 'cmn-Hant-TW', ''),
2060(60, 30, '粵語 (香港)', 'yue-Hant-HK', ''),
2061(61, 31, '日本語', 'ja-JP', 'ja'),
2062(62, 32, 'Lingua latīna', 'la', ''),
2063(64, 33, 'Lithuanian', 'lt-LT', 'lt'),
2064(65, 34, 'Latvia', 'lv-LV', 'lv'),
2065(66, 35, 'Afar', 'aa-DJ', 'aa'),
2066(67, 36, 'Egypt', 'ar-EG', 'ar'),
2067(68, 37, 'India', 'as-IN', 'as'),
2068(69, 38, 'Azerbaijani', 'az-AZ', 'az'),
2069(70, 39, 'Bulgarian', 'bg', 'bg'),
2070(71, 40, 'Bangla', 'bn', 'bn'),
2071(72, 41, 'Bosnian', 'bs-BA', 'bs'),
2072(73, 42, 'Cakchiquel', 'cak', 'cak'),
2073(74, 43, 'Danish', 'da-dk', 'da'),
2074(75, 44, 'Greek', 'el-GR', 'el'),
2075(76, 45, 'Estonian', 'et-EE', 'et'),
2076(77, 46, 'Persian', 'fa-IR', 'fa'),
2077(78, 47, 'Filipino', 'fil', 'fil'),
2078(79, 48, 'Gujarati', 'gu-IN', 'gu'),
2079(80, 49, 'Hebrew', 'he', 'he'),
2080(81, 50, 'Croatian', 'hr-HR', 'hr'),
2081(82, 51, 'Indonesia', 'in', 'in'),
2082(83, 52, 'Icelandic', 'is', 'is'),
2083(84, 53, 'Georgian', 'ka-ge', 'ka'),
2084(85, 54, 'Maori (New Zealand)', 'mi-nz', 'mi'),
2085(86, 55, 'Macedonian', 'mk-MK', 'mk'),
2086(87, 56, 'Malay (Latin)', 'ms', 'ms'),
2087(88, 57, 'Maltese', 'mt', 'mt'),
2088(89, 58, 'Norwegian Nynorsk', 'nn-NO', 'nn'),
2089(90, 59, 'Norwegian', 'no', 'no'),
2090(91, 60, 'Northern Sotho (South Africa)', 'nso-za', 'nso'),
2091(92, 61, 'Slovenian', 'sl-SI', 'sl'),
2092(94, 63, 'Thai', 'th-TH', 'th'),
2093(95, 64, 'Tagalog', 'tl', 'tl'),
2094(96, 65, 'Tongan', 'to-TO', 'to'),
2095(97, 66, 'Ukrainian', 'uk-UA', 'uk'),
2096(98, 67, 'Vietnamese', 'vi-VN', 'vi'),
2097(99, 68, 'Chinese', 'zh-CN', 'zh'),
2098(100, 36, 'Egypt', 'ar-AE', ''),
2099(101, 36, 'Egypt', 'ar-IQ', ''),
2100(102, 41, 'Bosnian', 'bs-Latn-BA', ''),
2101(103, 6, 'Deutsch', 'de-at', ''),
2102(104, 6, 'Deutsch', 'de-ch', ''),
2103(105, 6, 'Deutsch', 'de-GB', ''),
2104(106, 6, 'Deutsch', 'de-LI', ''),
2105(107, 6, 'Deutsch', 'de-LU', ''),
2106(108, 7, 'United Kingdom', 'en-029', ''),
2107(109, 7, 'United Kingdom', 'en-AS', ''),
2108(110, 7, 'United Kingdom', 'en-BE', ''),
2109(111, 7, 'United Kingdom', 'en-BM', ''),
2110(112, 7, 'United Kingdom', 'en-BS', ''),
2111(113, 7, 'United Kingdom', 'en-BW', ''),
2112(114, 7, 'United Kingdom', 'en-CH', ''),
2113(115, 7, 'United Kingdom', 'en-CX', ''),
2114(116, 7, 'United Kingdom', 'en-CY', ''),
2115(117, 7, 'United Kingdom', 'en-DE', ''),
2116(118, 7, 'United Kingdom', 'en-DK', ''),
2117(119, 7, 'United Kingdom', 'en-DM', ''),
2118(120, 7, 'United Kingdom', 'en-GY', ''),
2119(121, 7, 'United Kingdom', 'en-HK', ''),
2120(122, 7, 'United Kingdom', 'en-ie', ''),
2121(123, 7, 'United Kingdom', 'en-IM', ''),
2122(124, 7, 'United Kingdom', 'en-JM', ''),
2123(125, 7, 'United Kingdom', 'en-KY', ''),
2124(126, 7, 'United Kingdom', 'en-MY', ''),
2125(127, 7, 'United Kingdom', 'en-NF', ''),
2126(128, 7, 'United Kingdom', 'en-NG', ''),
2127(129, 7, 'United Kingdom', 'en-NL', ''),
2128(130, 7, 'United Kingdom', 'en-PH', ''),
2129(131, 7, 'United Kingdom', 'en-SE', ''),
2130(132, 7, 'United Kingdom', 'en-sg', ''),
2131(133, 7, 'United Kingdom', 'en-SI', ''),
2132(134, 7, 'United Kingdom', 'en-SS', ''),
2133(135, 7, 'United Kingdom', 'en-TO', ''),
2134(136, 7, 'United Kingdom', 'en-TZ', ''),
2135(137, 7, 'United Kingdom', 'en-UG', ''),
2136(138, 7, 'United Kingdom', 'en-UK', ''),
2137(139, 7, 'United Kingdom', 'en-ZG', ''),
2138(140, 7, 'United Kingdom', 'en-ZM', ''),
2139(141, 7, 'United Kingdom', 'en-ZW', ''),
2140(142, 8, 'España', 'es-419', ''),
2141(143, 8, 'España', 'es-xl', ''),
2142(144, 47, 'Filipino', 'fil-PH', ''),
2143(145, 10, 'Français', 'fr-BE', ''),
2144(146, 10, 'Français', 'fr-ca', ''),
2145(147, 10, 'Français', 'fr-ch', ''),
2146(148, 10, 'Français', 'fr-CM', ''),
2147(149, 10, 'Français', 'fr-MC', ''),
2148(150, 49, 'Hebrew', 'he-IL', ''),
2149(151, 50, 'Croatian', 'hr-BA', ''),
2150(152, 17, 'Nederlands', 'nl-BE', ''),
2151(153, 19, 'Polski', 'pl-GB', ''),
2152(154, 27, 'Pусский', 'ru-KZ', ''),
2153(155, 27, 'Pусский', 'ru-UA', ''),
2154(156, 28, 'Serbian', 'sr-BA', ''),
2155(157, 28, 'Serbian', 'sr-Latn-RS', ''),
2156(158, 68, 'Chinese', 'zh-MO', ''),
2157(159, 68, 'Chinese', 'zh-SG', ''),
2158(160, 68, 'Chinese', 'zh-TW', '');
2159
2160-- --------------------------------------------------------
2161
2162--
2163-- Struttura della tabella `lh_speech_user_language`
2164--
2165
2166CREATE TABLE `lh_speech_user_language` (
2167  `id` bigint(20) NOT NULL,
2168  `user_id` bigint(20) NOT NULL,
2169  `language` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL
2170) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2171
2172--
2173-- Dump dei dati per la tabella `lh_speech_user_language`
2174--
2175
2176INSERT INTO `lh_speech_user_language` (`id`, `user_id`, `language`) VALUES
2177(37, 1, 'en'),
2178(34, 1, 'en-029'),
2179(33, 1, 'en-AS'),
2180(42, 1, 'en-AU'),
2181(32, 1, 'en-BE'),
2182(31, 1, 'en-BM'),
2183(30, 1, 'en-BS'),
2184(29, 1, 'en-BW'),
2185(41, 1, 'en-CA'),
2186(28, 1, 'en-CH'),
2187(27, 1, 'en-CX'),
2188(26, 1, 'en-CY'),
2189(25, 1, 'en-DE'),
2190(24, 1, 'en-DK'),
2191(23, 1, 'en-DM'),
2192(36, 1, 'en-GB'),
2193(22, 1, 'en-GY'),
2194(21, 1, 'en-HK'),
2195(20, 1, 'en-ie'),
2196(19, 1, 'en-IM'),
2197(40, 1, 'en-IN'),
2198(18, 1, 'en-JM'),
2199(17, 1, 'en-KY'),
2200(16, 1, 'en-MY'),
2201(15, 1, 'en-NF'),
2202(14, 1, 'en-NG'),
2203(13, 1, 'en-NL'),
2204(39, 1, 'en-NZ'),
2205(12, 1, 'en-PH'),
2206(11, 1, 'en-SE'),
2207(10, 1, 'en-sg'),
2208(9, 1, 'en-SI'),
2209(8, 1, 'en-SS'),
2210(7, 1, 'en-TO'),
2211(6, 1, 'en-TZ'),
2212(5, 1, 'en-UG'),
2213(4, 1, 'en-UK'),
2214(35, 1, 'en-US'),
2215(38, 1, 'en-ZA'),
2216(3, 1, 'en-ZG'),
2217(2, 1, 'en-ZM'),
2218(1, 1, 'en-ZW'),
2219(44, 1, 'it'),
2220(46, 1, 'it'),
2221(43, 1, 'it-CH'),
2222(45, 1, 'it-IT');
2223
2224-- --------------------------------------------------------
2225
2226--
2227-- Struttura della tabella `lh_transfer`
2228--
2229
2230CREATE TABLE `lh_transfer` (
2231  `id` int(11) NOT NULL,
2232  `chat_id` int(11) NOT NULL,
2233  `dep_id` int(11) NOT NULL,
2234  `transfer_user_id` int(11) NOT NULL,
2235  `from_dep_id` int(11) NOT NULL,
2236  `ctime` int(11) NOT NULL,
2237  `transfer_to_user_id` int(11) NOT NULL
2238) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2239
2240-- --------------------------------------------------------
2241
2242--
2243-- Struttura della tabella `lh_userdep`
2244--
2245
2246CREATE TABLE `lh_userdep` (
2247  `id` int(11) NOT NULL,
2248  `user_id` int(11) NOT NULL,
2249  `dep_id` int(11) NOT NULL,
2250  `last_activity` int(11) NOT NULL,
2251  `exclude_autoasign` tinyint(1) NOT NULL DEFAULT '0',
2252  `hide_online` int(11) NOT NULL,
2253  `last_accepted` int(11) NOT NULL DEFAULT '0',
2254  `active_chats` int(11) NOT NULL DEFAULT '0',
2255  `pending_chats` int(11) NOT NULL DEFAULT '0',
2256  `inactive_chats` int(11) NOT NULL DEFAULT '0',
2257  `max_chats` int(11) NOT NULL DEFAULT '0',
2258  `type` int(11) NOT NULL DEFAULT '0',
2259  `ro` tinyint(1) NOT NULL DEFAULT '0',
2260  `hide_online_ts` int(11) NOT NULL DEFAULT '0',
2261  `dep_group_id` int(11) NOT NULL DEFAULT '0'
2262) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2263
2264--
2265-- Dump dei dati per la tabella `lh_userdep`
2266--
2267
2268INSERT INTO `lh_userdep` (`id`, `user_id`, `dep_id`, `last_activity`, `exclude_autoasign`, `hide_online`, `last_accepted`, `active_chats`, `pending_chats`, `inactive_chats`, `max_chats`, `type`, `ro`, `hide_online_ts`, `dep_group_id`) VALUES
2269(1, 1, 0, 1585855985, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
2270
2271-- --------------------------------------------------------
2272
2273--
2274-- Struttura della tabella `lh_users`
2275--
2276
2277CREATE TABLE `lh_users` (
2278  `id` int(11) NOT NULL,
2279  `username` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
2280  `password` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
2281  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
2282  `time_zone` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
2283  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
2284  `surname` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
2285  `filepath` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
2286  `filename` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
2287  `job_title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
2288  `departments_ids` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
2289  `chat_nickname` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
2290  `xmpp_username` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
2291  `session_id` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
2292  `operation_admin` text COLLATE utf8mb4_unicode_ci NOT NULL,
2293  `skype` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
2294  `exclude_autoasign` tinyint(1) NOT NULL,
2295  `disabled` tinyint(4) NOT NULL,
2296  `hide_online` tinyint(1) NOT NULL,
2297  `all_departments` tinyint(1) NOT NULL,
2298  `invisible_mode` tinyint(1) NOT NULL,
2299  `inactive_mode` tinyint(1) NOT NULL,
2300  `rec_per_req` tinyint(1) NOT NULL,
2301  `active_chats_counter` int(11) NOT NULL,
2302  `closed_chats_counter` int(11) NOT NULL,
2303  `pending_chats_counter` int(11) NOT NULL,
2304  `auto_accept` tinyint(1) NOT NULL,
2305  `max_active_chats` int(11) NOT NULL,
2306  `pswd_updated` int(11) NOT NULL,
2307  `attr_int_1` int(11) NOT NULL,
2308  `attr_int_2` int(11) NOT NULL,
2309  `attr_int_3` int(11) NOT NULL
2310) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2311
2312--
2313-- Dump dei dati per la tabella `lh_users`
2314--
2315
2316INSERT INTO `lh_users` (`id`, `username`, `password`, `email`, `time_zone`, `name`, `surname`, `filepath`, `filename`, `job_title`, `departments_ids`, `chat_nickname`, `xmpp_username`, `session_id`, `operation_admin`, `skype`, `exclude_autoasign`, `disabled`, `hide_online`, `all_departments`, `invisible_mode`, `inactive_mode`, `rec_per_req`, `active_chats_counter`, `closed_chats_counter`, `pending_chats_counter`, `auto_accept`, `max_active_chats`, `pswd_updated`, `attr_int_1`, `attr_int_2`, `attr_int_3`) VALUES
2317(1, 'massimiliano', '$2y$10$TGBomvr7P9/V3K6HCaLeuOviA/ufwZxLAu0TS4.T1Lky/kAoLUG2.', 'massimiliano@maxcode.it', '', 'Massimiliano', 'Fazzi', '', '', '', '0', '', '', '', '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1585846191, 0, 0, 0),
2318(2, 'MarcoLvr', '$2y$10$uHKc3NVkFh16EY0EnULsPuT7dTvtwjgNktSUVvx0OPiQOh/7N3MQS', 'marcolvr@hydromc.org', '', 'Marco', 'Lavarini', '', '', 'Developer', '', 'Marco Lavarini', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1585847393, 0, 0, 0);
2319
2320-- --------------------------------------------------------
2321
2322--
2323-- Struttura della tabella `lh_users_online_session`
2324--
2325
2326CREATE TABLE `lh_users_online_session` (
2327  `id` bigint(20) NOT NULL,
2328  `user_id` int(11) NOT NULL,
2329  `time` int(11) NOT NULL,
2330  `duration` int(11) NOT NULL,
2331  `lactivity` int(11) NOT NULL
2332) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2333
2334--
2335-- Dump dei dati per la tabella `lh_users_online_session`
2336--
2337
2338INSERT INTO `lh_users_online_session` (`id`, `user_id`, `time`, `duration`, `lactivity`) VALUES
2339(1, 1, 1585846246, 987, 1585847233),
2340(2, 1, 1585847291, 294, 1585847585),
2341(3, 1, 1585847634, 8332, 1585855966);
2342
2343-- --------------------------------------------------------
2344
2345--
2346-- Struttura della tabella `lh_users_remember`
2347--
2348
2349CREATE TABLE `lh_users_remember` (
2350  `id` int(11) NOT NULL,
2351  `user_id` int(11) NOT NULL,
2352  `mtime` int(11) NOT NULL
2353) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2354
2355--
2356-- Dump dei dati per la tabella `lh_users_remember`
2357--
2358
2359INSERT INTO `lh_users_remember` (`id`, `user_id`, `mtime`) VALUES
2360(1, 1, 1585846223);
2361
2362-- --------------------------------------------------------
2363
2364--
2365-- Struttura della tabella `lh_users_session`
2366--
2367
2368CREATE TABLE `lh_users_session` (
2369  `id` int(11) NOT NULL,
2370  `token` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
2371  `device_type` int(11) NOT NULL,
2372  `device_token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
2373  `user_id` int(11) NOT NULL,
2374  `created_on` int(11) NOT NULL,
2375  `updated_on` int(11) NOT NULL,
2376  `expires_on` int(11) NOT NULL
2377) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2378
2379-- --------------------------------------------------------
2380
2381--
2382-- Struttura della tabella `lh_users_setting`
2383--
2384
2385CREATE TABLE `lh_users_setting` (
2386  `id` int(11) NOT NULL,
2387  `user_id` int(11) NOT NULL,
2388  `identifier` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
2389  `value` text COLLATE utf8mb4_unicode_ci NOT NULL
2390) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2391
2392--
2393-- Dump dei dati per la tabella `lh_users_setting`
2394--
2395
2396INSERT INTO `lh_users_setting` (`id`, `user_id`, `identifier`, `value`) VALUES
2397(1, 1, 'user_language', 'en_EN'),
2398(2, 1, 'enable_pending_list', '1'),
2399(3, 1, 'enable_active_list', '1'),
2400(4, 1, 'enable_close_list', '0'),
2401(5, 1, 'enable_unread_list', '0'),
2402(6, 1, 'enable_mchats_list', '1'),
2403(7, 1, 'new_user_bn', '0'),
2404(8, 1, 'new_user_sound', '0'),
2405(9, 1, 'o_department', '0'),
2406(10, 1, 'ouser_timeout', '3600'),
2407(11, 1, 'oupdate_timeout', '10'),
2408(12, 1, 'omax_rows', '50'),
2409(13, 1, 'ogroup_by', 'none'),
2410(14, 1, 'ocountry', 'none'),
2411(15, 1, 'otime_on_site', ''),
2412(16, 1, 'omap_depid', '0'),
2413(17, 1, 'omap_mtimeout', '30'),
2414(18, 1, 'dwo', ''),
2415(19, 1, 'enable_bot_list', '1'),
2416(20, 1, 'admin_theme_enabled', '0'),
2417(21, 1, 'chat_message', '1'),
2418(22, 1, 'show_alert_transfer', '1'),
2419(23, 1, 'show_alert_chat', '0'),
2420(24, 1, 'new_chat_sound', '1'),
2421(25, 1, 'sn_off', '1'),
2422(26, 1, 'ownntfonly', '0'),
2423(27, 1, 'auto_uppercase', '1'),
2424(28, 1, 'trackactivitytimeout', '-1'),
2425(29, 1, 'trackactivity', '0'),
2426(30, 1, 'show_all_pending', '1'),
2427(31, 1, 'auto_preload', '0'),
2428(32, 1, 'speech_language', ''),
2429(33, 1, 'speech_dialect', '0'),
2430(34, 2, 'show_all_pending', '1');
2431
2432-- --------------------------------------------------------
2433
2434--
2435-- Struttura della tabella `lh_users_setting_option`
2436--
2437
2438CREATE TABLE `lh_users_setting_option` (
2439  `identifier` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
2440  `class` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
2441  `attribute` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL
2442) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2443
2444--
2445-- Dump dei dati per la tabella `lh_users_setting_option`
2446--
2447
2448INSERT INTO `lh_users_setting_option` (`identifier`, `class`, `attribute`) VALUES
2449('chat_message', '', ''),
2450('dwo', '', ''),
2451('enable_active_list', '', ''),
2452('enable_close_list', '', ''),
2453('enable_pending_list', '', ''),
2454('enable_unread_list', '', ''),
2455('new_chat_sound', '', ''),
2456('new_user_bn', '', ''),
2457('new_user_sound', '', ''),
2458('o_department', '', ''),
2459('ocountry', '', ''),
2460('ogroup_by', '', ''),
2461('omap_depid', '', ''),
2462('omap_mtimeout', '', ''),
2463('omax_rows', '', ''),
2464('otime_on_site', '', ''),
2465('oupdate_timeout', '', ''),
2466('ouser_timeout', '', '');
2467
2468--
2469-- Indici per le tabelle scaricate
2470--
2471
2472--
2473-- Indici per le tabelle `lh_abstract_auto_responder`
2474--
2475ALTER TABLE `lh_abstract_auto_responder`
2476  ADD PRIMARY KEY (`id`),
2477  ADD KEY `siteaccess_position` (`siteaccess`,`position`);
2478
2479--
2480-- Indici per le tabelle `lh_abstract_auto_responder_chat`
2481--
2482ALTER TABLE `lh_abstract_auto_responder_chat`
2483  ADD PRIMARY KEY (`id`),
2484  ADD KEY `chat_id` (`chat_id`);
2485
2486--
2487-- Indici per le tabelle `lh_abstract_browse_offer_invitation`
2488--
2489ALTER TABLE `lh_abstract_browse_offer_invitation`
2490  ADD PRIMARY KEY (`id`),
2491  ADD KEY `active` (`active`),
2492  ADD KEY `identifier` (`identifier`);
2493
2494--
2495-- Indici per le tabelle `lh_abstract_chat_column`
2496--
2497ALTER TABLE `lh_abstract_chat_column`
2498  ADD PRIMARY KEY (`id`),
2499  ADD KEY `enabled` (`enabled`),
2500  ADD KEY `online_enabled` (`online_enabled`),
2501  ADD KEY `chat_enabled` (`chat_enabled`);
2502
2503--
2504-- Indici per le tabelle `lh_abstract_chat_priority`
2505--
2506ALTER TABLE `lh_abstract_chat_priority`
2507  ADD PRIMARY KEY (`id`),
2508  ADD KEY `dep_id` (`dep_id`);
2509
2510--
2511-- Indici per le tabelle `lh_abstract_chat_variable`
2512--
2513ALTER TABLE `lh_abstract_chat_variable`
2514  ADD PRIMARY KEY (`id`),
2515  ADD KEY `dep_id` (`dep_id`);
2516
2517--
2518-- Indici per le tabelle `lh_abstract_email_template`
2519--
2520ALTER TABLE `lh_abstract_email_template`
2521  ADD PRIMARY KEY (`id`);
2522
2523--
2524-- Indici per le tabelle `lh_abstract_form`
2525--
2526ALTER TABLE `lh_abstract_form`
2527  ADD PRIMARY KEY (`id`);
2528
2529--
2530-- Indici per le tabelle `lh_abstract_form_collected`
2531--
2532ALTER TABLE `lh_abstract_form_collected`
2533  ADD PRIMARY KEY (`id`),
2534  ADD KEY `form_id` (`form_id`);
2535
2536--
2537-- Indici per le tabelle `lh_abstract_proactive_chat_campaign`
2538--
2539ALTER TABLE `lh_abstract_proactive_chat_campaign`
2540  ADD PRIMARY KEY (`id`);
2541
2542--
2543-- Indici per le tabelle `lh_abstract_proactive_chat_campaign_conv`
2544--
2545ALTER TABLE `lh_abstract_proactive_chat_campaign_conv`
2546  ADD PRIMARY KEY (`id`),
2547  ADD KEY `ctime` (`ctime`),
2548  ADD KEY `campaign_id` (`campaign_id`),
2549  ADD KEY `invitation_id` (`invitation_id`),
2550  ADD KEY `invitation_status` (`invitation_status`);
2551
2552--
2553-- Indici per le tabelle `lh_abstract_proactive_chat_event`
2554--
2555ALTER TABLE `lh_abstract_proactive_chat_event`
2556  ADD PRIMARY KEY (`id`),
2557  ADD KEY `vid_id_ev_id_val_ts` (`vid_id`,`ev_id`,`val`,`ts`),
2558  ADD KEY `vid_id_ev_id_ts` (`vid_id`,`ev_id`,`ts`);
2559
2560--
2561-- Indici per le tabelle `lh_abstract_proactive_chat_invitation`
2562--
2563ALTER TABLE `lh_abstract_proactive_chat_invitation`
2564  ADD PRIMARY KEY (`id`),
2565  ADD KEY `time_on_site_pageviews_siteaccess_position` (`time_on_site`,`pageviews`,`siteaccess`,`identifier`,`position`),
2566  ADD KEY `identifier` (`identifier`),
2567  ADD KEY `dynamic_invitation` (`dynamic_invitation`),
2568  ADD KEY `tag` (`tag`),
2569  ADD KEY `dep_id` (`dep_id`);
2570
2571--
2572-- Indici per le tabelle `lh_abstract_proactive_chat_invitation_event`
2573--
2574ALTER TABLE `lh_abstract_proactive_chat_invitation_event`
2575  ADD PRIMARY KEY (`id`),
2576  ADD KEY `invitation_id` (`invitation_id`),
2577  ADD KEY `event_id` (`event_id`);
2578
2579--
2580-- Indici per le tabelle `lh_abstract_proactive_chat_variables`
2581--
2582ALTER TABLE `lh_abstract_proactive_chat_variables`
2583  ADD PRIMARY KEY (`id`),
2584  ADD KEY `identifier` (`identifier`);
2585
2586--
2587-- Indici per le tabelle `lh_abstract_product`
2588--
2589ALTER TABLE `lh_abstract_product`
2590  ADD PRIMARY KEY (`id`),
2591  ADD KEY `departament_id` (`departament_id`);
2592
2593--
2594-- Indici per le tabelle `lh_abstract_product_departament`
2595--
2596ALTER TABLE `lh_abstract_product_departament`
2597  ADD PRIMARY KEY (`id`),
2598  ADD KEY `departament_id` (`departament_id`);
2599
2600--
2601-- Indici per le tabelle `lh_abstract_rest_api_key`
2602--
2603ALTER TABLE `lh_abstract_rest_api_key`
2604  ADD PRIMARY KEY (`id`),
2605  ADD KEY `api_key` (`api_key`),
2606  ADD KEY `user_id` (`user_id`);
2607
2608--
2609-- Indici per le tabelle `lh_abstract_rest_api_key_remote`
2610--
2611ALTER TABLE `lh_abstract_rest_api_key_remote`
2612  ADD PRIMARY KEY (`id`),
2613  ADD KEY `active` (`active`);
2614
2615--
2616-- Indici per le tabelle `lh_abstract_subject`
2617--
2618ALTER TABLE `lh_abstract_subject`
2619  ADD PRIMARY KEY (`id`);
2620
2621--
2622-- Indici per le tabelle `lh_abstract_subject_chat`
2623--
2624ALTER TABLE `lh_abstract_subject_chat`
2625  ADD PRIMARY KEY (`id`),
2626  ADD KEY `chat_id` (`chat_id`);
2627
2628--
2629-- Indici per le tabelle `lh_abstract_subject_dep`
2630--
2631ALTER TABLE `lh_abstract_subject_dep`
2632  ADD PRIMARY KEY (`id`),
2633  ADD KEY `subject_id` (`subject_id`);
2634
2635--
2636-- Indici per le tabelle `lh_abstract_survey`
2637--
2638ALTER TABLE `lh_abstract_survey`
2639  ADD PRIMARY KEY (`id`);
2640
2641--
2642-- Indici per le tabelle `lh_abstract_survey_item`
2643--
2644ALTER TABLE `lh_abstract_survey_item`
2645  ADD PRIMARY KEY (`id`),
2646  ADD KEY `survey_id` (`survey_id`),
2647  ADD KEY `chat_id` (`chat_id`),
2648  ADD KEY `user_id` (`user_id`),
2649  ADD KEY `dep_id` (`dep_id`),
2650  ADD KEY `ftime` (`ftime`),
2651  ADD KEY `max_stars_1` (`max_stars_1`),
2652  ADD KEY `max_stars_2` (`max_stars_2`),
2653  ADD KEY `max_stars_3` (`max_stars_3`),
2654  ADD KEY `max_stars_4` (`max_stars_4`),
2655  ADD KEY `max_stars_5` (`max_stars_5`),
2656  ADD KEY `question_options_1` (`question_options_1`),
2657  ADD KEY `question_options_2` (`question_options_2`),
2658  ADD KEY `question_options_3` (`question_options_3`),
2659  ADD KEY `question_options_4` (`question_options_4`),
2660  ADD KEY `question_options_5` (`question_options_5`);
2661
2662--
2663-- Indici per le tabelle `lh_abstract_widget_theme`
2664--
2665ALTER TABLE `lh_abstract_widget_theme`
2666  ADD PRIMARY KEY (`id`);
2667
2668--
2669-- Indici per le tabelle `lh_admin_theme`
2670--
2671ALTER TABLE `lh_admin_theme`
2672  ADD PRIMARY KEY (`id`),
2673  ADD KEY `user_id` (`user_id`);
2674
2675--
2676-- Indici per le tabelle `lh_audits`
2677--
2678ALTER TABLE `lh_audits`
2679  ADD PRIMARY KEY (`id`),
2680  ADD KEY `object_id` (`object_id`),
2681  ADD KEY `source` (`source`(191)),
2682  ADD KEY `category` (`category`(191));
2683
2684--
2685-- Indici per le tabelle `lh_canned_msg`
2686--
2687ALTER TABLE `lh_canned_msg`
2688  ADD PRIMARY KEY (`id`),
2689  ADD KEY `department_id` (`department_id`),
2690  ADD KEY `attr_int_1` (`attr_int_1`),
2691  ADD KEY `attr_int_2` (`attr_int_2`),
2692  ADD KEY `attr_int_3` (`attr_int_3`),
2693  ADD KEY `position_title_v2` (`position`,`title`(191)),
2694  ADD KEY `user_id` (`user_id`);
2695
2696--
2697-- Indici per le tabelle `lh_canned_msg_tag`
2698--
2699ALTER TABLE `lh_canned_msg_tag`
2700  ADD PRIMARY KEY (`id`),
2701  ADD KEY `tag` (`tag`);
2702
2703--
2704-- Indici per le tabelle `lh_canned_msg_tag_link`
2705--
2706ALTER TABLE `lh_canned_msg_tag_link`
2707  ADD PRIMARY KEY (`id`),
2708  ADD KEY `canned_id` (`canned_id`),
2709  ADD KEY `tag_id` (`tag_id`);
2710
2711--
2712-- Indici per le tabelle `lh_chat`
2713--
2714ALTER TABLE `lh_chat`
2715  ADD PRIMARY KEY (`id`),
2716  ADD KEY `status_user_id` (`status`,`user_id`),
2717  ADD KEY `unanswered_chat` (`unanswered_chat`),
2718  ADD KEY `online_user_id` (`online_user_id`),
2719  ADD KEY `dep_id` (`dep_id`),
2720  ADD KEY `product_id` (`product_id`),
2721  ADD KEY `unread_operator` (`has_unread_op_messages`,`unread_op_messages_informed`),
2722  ADD KEY `user_id_sender_user_id` (`user_id`,`sender_user_id`),
2723  ADD KEY `sender_user_id` (`sender_user_id`),
2724  ADD KEY `anonymized` (`anonymized`),
2725  ADD KEY `has_unread_messages` (`has_unread_messages`),
2726  ADD KEY `status` (`status`),
2727  ADD KEY `dep_id_status` (`dep_id`,`status`);
2728
2729--
2730-- Indici per le tabelle `lh_chatbox`
2731--
2732ALTER TABLE `lh_chatbox`
2733  ADD PRIMARY KEY (`id`),
2734  ADD KEY `identifier` (`identifier`);
2735
2736--
2737-- Indici per le tabelle `lh_chat_accept`
2738--
2739ALTER TABLE `lh_chat_accept`
2740  ADD PRIMARY KEY (`id`),
2741  ADD KEY `hash` (`hash`);
2742
2743--
2744-- Indici per le tabelle `lh_chat_archive_range`
2745--
2746ALTER TABLE `lh_chat_archive_range`
2747  ADD PRIMARY KEY (`id`);
2748
2749--
2750-- Indici per le tabelle `lh_chat_blocked_user`
2751--
2752ALTER TABLE `lh_chat_blocked_user`
2753  ADD PRIMARY KEY (`id`),
2754  ADD KEY `ip` (`ip`);
2755
2756--
2757-- Indici per le tabelle `lh_chat_config`
2758--
2759ALTER TABLE `lh_chat_config`
2760  ADD PRIMARY KEY (`identifier`);
2761
2762--
2763-- Indici per le tabelle `lh_chat_file`
2764--
2765ALTER TABLE `lh_chat_file`
2766  ADD PRIMARY KEY (`id`),
2767  ADD KEY `chat_id` (`chat_id`),
2768  ADD KEY `online_user_id` (`online_user_id`),
2769  ADD KEY `user_id` (`user_id`);
2770
2771--
2772-- Indici per le tabelle `lh_chat_online_user`
2773--
2774ALTER TABLE `lh_chat_online_user`
2775  ADD PRIMARY KEY (`id`),
2776  ADD KEY `vid` (`vid`),
2777  ADD KEY `dep_id` (`dep_id`),
2778  ADD KEY `last_visit_dep_id` (`last_visit`,`dep_id`);
2779
2780--
2781-- Indici per le tabelle `lh_chat_online_user_footprint`
2782--
2783ALTER TABLE `lh_chat_online_user_footprint`
2784  ADD PRIMARY KEY (`id`),
2785  ADD KEY `chat_id` (`chat_id`),
2786  ADD KEY `online_user_id` (`online_user_id`);
2787
2788--
2789-- Indici per le tabelle `lh_chat_online_user_footprint_update`
2790--
2791ALTER TABLE `lh_chat_online_user_footprint_update`
2792  ADD KEY `online_user_id` (`online_user_id`);
2793
2794--
2795-- Indici per le tabelle `lh_chat_paid`
2796--
2797ALTER TABLE `lh_chat_paid`
2798  ADD PRIMARY KEY (`id`),
2799  ADD KEY `hash` (`hash`(191)),
2800  ADD KEY `chat_id` (`chat_id`);
2801
2802--
2803-- Indici per le tabelle `lh_chat_start_settings`
2804--
2805ALTER TABLE `lh_chat_start_settings`
2806  ADD PRIMARY KEY (`id`),
2807  ADD KEY `department_id` (`department_id`);
2808
2809--
2810-- Indici per le tabelle `lh_cobrowse`
2811--
2812ALTER TABLE `lh_cobrowse`
2813  ADD PRIMARY KEY (`id`),
2814  ADD KEY `chat_id` (`chat_id`),
2815  ADD KEY `online_user_id` (`online_user_id`);
2816
2817--
2818-- Indici per le tabelle `lh_departament`
2819--
2820ALTER TABLE `lh_departament`
2821  ADD PRIMARY KEY (`id`),
2822  ADD KEY `identifier` (`identifier`),
2823  ADD KEY `attr_int_1` (`attr_int_1`),
2824  ADD KEY `attr_int_2` (`attr_int_2`),
2825  ADD KEY `attr_int_3` (`attr_int_3`),
2826  ADD KEY `active_chats_counter` (`active_chats_counter`),
2827  ADD KEY `pending_chats_counter` (`pending_chats_counter`),
2828  ADD KEY `closed_chats_counter` (`closed_chats_counter`),
2829  ADD KEY `disabled_hidden` (`disabled`,`hidden`),
2830  ADD KEY `sort_priority_name` (`sort_priority`,`name`),
2831  ADD KEY `active_mod` (`online_hours_active`,`mod_start_hour`,`mod_end_hour`),
2832  ADD KEY `active_tud` (`online_hours_active`,`tud_start_hour`,`tud_end_hour`),
2833  ADD KEY `active_wed` (`online_hours_active`,`wed_start_hour`,`wed_end_hour`),
2834  ADD KEY `active_thd` (`online_hours_active`,`thd_start_hour`,`thd_end_hour`),
2835  ADD KEY `active_frd` (`online_hours_active`,`frd_start_hour`,`frd_end_hour`),
2836  ADD KEY `active_sad` (`online_hours_active`,`sad_start_hour`,`sad_end_hour`),
2837  ADD KEY `active_sud` (`online_hours_active`,`sud_start_hour`,`sud_end_hour`);
2838
2839--
2840-- Indici per le tabelle `lh_departament_availability`
2841--
2842ALTER TABLE `lh_departament_availability`
2843  ADD PRIMARY KEY (`id`),
2844  ADD KEY `ymdhi` (`ymdhi`),
2845  ADD KEY `dep_id` (`dep_id`),
2846  ADD KEY `hourminute` (`hourminute`),
2847  ADD KEY `time` (`time`);
2848
2849--
2850-- Indici per le tabelle `lh_departament_custom_work_hours`
2851--
2852ALTER TABLE `lh_departament_custom_work_hours`
2853  ADD PRIMARY KEY (`id`),
2854  ADD KEY `dep_id` (`dep_id`),
2855  ADD KEY `date_from` (`date_from`),
2856  ADD KEY `search_active` (`date_from`,`date_to`,`dep_id`);
2857
2858--
2859-- Indici per le tabelle `lh_departament_group`
2860--
2861ALTER TABLE `lh_departament_group`
2862  ADD PRIMARY KEY (`id`);
2863
2864--
2865-- Indici per le tabelle `lh_departament_group_member`
2866--
2867ALTER TABLE `lh_departament_group_member`
2868  ADD PRIMARY KEY (`id`),
2869  ADD KEY `dep_group_id` (`dep_group_id`);
2870
2871--
2872-- Indici per le tabelle `lh_departament_group_user`
2873--
2874ALTER TABLE `lh_departament_group_user`
2875  ADD PRIMARY KEY (`id`),
2876  ADD KEY `dep_group_id` (`dep_group_id`),
2877  ADD KEY `user_id` (`user_id`);
2878
2879--
2880-- Indici per le tabelle `lh_departament_limit_group`
2881--
2882ALTER TABLE `lh_departament_limit_group`
2883  ADD PRIMARY KEY (`id`);
2884
2885--
2886-- Indici per le tabelle `lh_departament_limit_group_member`
2887--
2888ALTER TABLE `lh_departament_limit_group_member`
2889  ADD PRIMARY KEY (`id`),
2890  ADD KEY `dep_limit_group_id` (`dep_limit_group_id`);
2891
2892--
2893-- Indici per le tabelle `lh_faq`
2894--
2895ALTER TABLE `lh_faq`
2896  ADD PRIMARY KEY (`id`),
2897  ADD KEY `active` (`active`),
2898  ADD KEY `active_url_2` (`active`,`url`(191)),
2899  ADD KEY `has_url` (`has_url`),
2900  ADD KEY `identifier` (`identifier`),
2901  ADD KEY `is_wildcard` (`is_wildcard`);
2902
2903--
2904-- Indici per le tabelle `lh_forgotpasswordhash`
2905--
2906ALTER TABLE `lh_forgotpasswordhash`
2907  ADD PRIMARY KEY (`id`);
2908
2909--
2910-- Indici per le tabelle `lh_generic_bot_bot`
2911--
2912ALTER TABLE `lh_generic_bot_bot`
2913  ADD PRIMARY KEY (`id`);
2914
2915--
2916-- Indici per le tabelle `lh_generic_bot_chat_event`
2917--
2918ALTER TABLE `lh_generic_bot_chat_event`
2919  ADD PRIMARY KEY (`id`),
2920  ADD KEY `chat_id` (`chat_id`);
2921
2922--
2923-- Indici per le tabelle `lh_generic_bot_chat_workflow`
2924--
2925ALTER TABLE `lh_generic_bot_chat_workflow`
2926  ADD PRIMARY KEY (`id`),
2927  ADD KEY `chat_id` (`chat_id`);
2928
2929--
2930-- Indici per le tabelle `lh_generic_bot_exception`
2931--
2932ALTER TABLE `lh_generic_bot_exception`
2933  ADD PRIMARY KEY (`id`);
2934
2935--
2936-- Indici per le tabelle `lh_generic_bot_exception_message`
2937--
2938ALTER TABLE `lh_generic_bot_exception_message`
2939  ADD PRIMARY KEY (`id`),
2940  ADD KEY `code` (`code`),
2941  ADD KEY `exception_group_id` (`exception_group_id`);
2942
2943--
2944-- Indici per le tabelle `lh_generic_bot_group`
2945--
2946ALTER TABLE `lh_generic_bot_group`
2947  ADD PRIMARY KEY (`id`),
2948  ADD KEY `bot_id` (`bot_id`);
2949
2950--
2951-- Indici per le tabelle `lh_generic_bot_payload`
2952--
2953ALTER TABLE `lh_generic_bot_payload`
2954  ADD PRIMARY KEY (`id`),
2955  ADD KEY `bot_id` (`bot_id`),
2956  ADD KEY `trigger_id` (`trigger_id`);
2957
2958--
2959-- Indici per le tabelle `lh_generic_bot_pending_event`
2960--
2961ALTER TABLE `lh_generic_bot_pending_event`
2962  ADD PRIMARY KEY (`id`),
2963  ADD KEY `chat_id` (`chat_id`);
2964
2965--
2966-- Indici per le tabelle `lh_generic_bot_repeat_restrict`
2967--
2968ALTER TABLE `lh_generic_bot_repeat_restrict`
2969  ADD PRIMARY KEY (`id`),
2970  ADD KEY `chat_id_trigger_id` (`chat_id`,`trigger_id`);
2971
2972--
2973-- Indici per le tabelle `lh_generic_bot_trigger`
2974--
2975ALTER TABLE `lh_generic_bot_trigger`
2976  ADD PRIMARY KEY (`id`),
2977  ADD KEY `bot_id` (`bot_id`),
2978  ADD KEY `default_unknown` (`default_unknown`),
2979  ADD KEY `default_always` (`default_always`),
2980  ADD KEY `group_id` (`group_id`);
2981
2982--
2983-- Indici per le tabelle `lh_generic_bot_trigger_event`
2984--
2985ALTER TABLE `lh_generic_bot_trigger_event`
2986  ADD PRIMARY KEY (`id`),
2987  ADD KEY `pattern_v2` (`pattern`(191)),
2988  ADD KEY `type` (`type`),
2989  ADD KEY `on_start_type` (`on_start_type`),
2990  ADD KEY `trigger_id` (`trigger_id`);
2991
2992--
2993-- Indici per le tabelle `lh_generic_bot_tr_group`
2994--
2995ALTER TABLE `lh_generic_bot_tr_group`
2996  ADD PRIMARY KEY (`id`);
2997
2998--
2999-- Indici per le tabelle `lh_generic_bot_tr_item`
3000--
3001ALTER TABLE `lh_generic_bot_tr_item`
3002  ADD PRIMARY KEY (`id`),
3003  ADD KEY `identifier` (`identifier`),
3004  ADD KEY `group_id` (`group_id`);
3005
3006--
3007-- Indici per le tabelle `lh_group`
3008--
3009ALTER TABLE `lh_group`
3010  ADD PRIMARY KEY (`id`),
3011  ADD KEY `disabled` (`disabled`);
3012
3013--
3014-- Indici per le tabelle `lh_grouprole`
3015--
3016ALTER TABLE `lh_grouprole`
3017  ADD PRIMARY KEY (`id`),
3018  ADD KEY `group_id` (`role_id`,`group_id`),
3019  ADD KEY `group_id_primary` (`group_id`);
3020
3021--
3022-- Indici per le tabelle `lh_groupuser`
3023--
3024ALTER TABLE `lh_groupuser`
3025  ADD PRIMARY KEY (`id`),
3026  ADD KEY `group_id` (`group_id`),
3027  ADD KEY `user_id` (`user_id`),
3028  ADD KEY `group_id_2` (`group_id`,`user_id`);
3029
3030--
3031-- Indici per le tabelle `lh_group_object`
3032--
3033ALTER TABLE `lh_group_object`
3034  ADD PRIMARY KEY (`id`),
3035  ADD KEY `object_id_type` (`object_id`,`type`),
3036  ADD KEY `group_id` (`group_id`);
3037
3038--
3039-- Indici per le tabelle `lh_group_work`
3040--
3041ALTER TABLE `lh_group_work`
3042  ADD PRIMARY KEY (`id`),
3043  ADD KEY `group_id` (`group_id`);
3044
3045--
3046-- Indici per le tabelle `lh_msg`
3047--
3048ALTER TABLE `lh_msg`
3049  ADD PRIMARY KEY (`id`),
3050  ADD KEY `chat_id_id` (`chat_id`,`id`),
3051  ADD KEY `user_id` (`user_id`);
3052
3053--
3054-- Indici per le tabelle `lh_notification_subscriber`
3055--
3056ALTER TABLE `lh_notification_subscriber`
3057  ADD PRIMARY KEY (`id`),
3058  ADD KEY `chat_id` (`chat_id`),
3059  ADD KEY `dep_id` (`dep_id`),
3060  ADD KEY `online_user_id` (`online_user_id`);
3061
3062--
3063-- Indici per le tabelle `lh_question`
3064--
3065ALTER TABLE `lh_question`
3066  ADD PRIMARY KEY (`id`),
3067  ADD KEY `priority` (`priority`),
3068  ADD KEY `active_priority` (`active`,`priority`);
3069
3070--
3071-- Indici per le tabelle `lh_question_answer`
3072--
3073ALTER TABLE `lh_question_answer`
3074  ADD PRIMARY KEY (`id`),
3075  ADD KEY `ip` (`ip`),
3076  ADD KEY `question_id` (`question_id`);
3077
3078--
3079-- Indici per le tabelle `lh_question_option`
3080--
3081ALTER TABLE `lh_question_option`
3082  ADD PRIMARY KEY (`id`),
3083  ADD KEY `question_id` (`question_id`);
3084
3085--
3086-- Indici per le tabelle `lh_question_option_answer`
3087--
3088ALTER TABLE `lh_question_option_answer`
3089  ADD PRIMARY KEY (`id`),
3090  ADD KEY `question_id` (`question_id`),
3091  ADD KEY `ip` (`ip`);
3092
3093--
3094-- Indici per le tabelle `lh_role`
3095--
3096ALTER TABLE `lh_role`
3097  ADD PRIMARY KEY (`id`);
3098
3099--
3100-- Indici per le tabelle `lh_rolefunction`
3101--
3102ALTER TABLE `lh_rolefunction`
3103  ADD PRIMARY KEY (`id`),
3104  ADD KEY `role_id` (`role_id`);
3105
3106--
3107-- Indici per le tabelle `lh_speech_chat_language`
3108--
3109ALTER TABLE `lh_speech_chat_language`
3110  ADD PRIMARY KEY (`id`),
3111  ADD KEY `chat_id` (`chat_id`);
3112
3113--
3114-- Indici per le tabelle `lh_speech_language`
3115--
3116ALTER TABLE `lh_speech_language`
3117  ADD PRIMARY KEY (`id`);
3118
3119--
3120-- Indici per le tabelle `lh_speech_language_dialect`
3121--
3122ALTER TABLE `lh_speech_language_dialect`
3123  ADD PRIMARY KEY (`id`),
3124  ADD KEY `language_id` (`language_id`),
3125  ADD KEY `short_code` (`short_code`),
3126  ADD KEY `lang_code` (`lang_code`);
3127
3128--
3129-- Indici per le tabelle `lh_speech_user_language`
3130--
3131ALTER TABLE `lh_speech_user_language`
3132  ADD PRIMARY KEY (`id`),
3133  ADD KEY `user_id_language` (`user_id`,`language`);
3134
3135--
3136-- Indici per le tabelle `lh_transfer`
3137--
3138ALTER TABLE `lh_transfer`
3139  ADD PRIMARY KEY (`id`),
3140  ADD KEY `dep_id` (`dep_id`),
3141  ADD KEY `transfer_user_id_dep_id` (`transfer_user_id`,`dep_id`),
3142  ADD KEY `transfer_to_user_id` (`transfer_to_user_id`);
3143
3144--
3145-- Indici per le tabelle `lh_userdep`
3146--
3147ALTER TABLE `lh_userdep`
3148  ADD PRIMARY KEY (`id`),
3149  ADD KEY `last_activity_hide_online_dep_id` (`last_activity`,`hide_online`,`dep_id`),
3150  ADD KEY `dep_id` (`dep_id`),
3151  ADD KEY `user_id_type` (`user_id`,`type`);
3152
3153--
3154-- Indici per le tabelle `lh_users`
3155--
3156ALTER TABLE `lh_users`
3157  ADD PRIMARY KEY (`id`),
3158  ADD KEY `hide_online` (`hide_online`),
3159  ADD KEY `rec_per_req` (`rec_per_req`),
3160  ADD KEY `email` (`email`),
3161  ADD KEY `xmpp_username` (`xmpp_username`(191));
3162
3163--
3164-- Indici per le tabelle `lh_users_online_session`
3165--
3166ALTER TABLE `lh_users_online_session`
3167  ADD PRIMARY KEY (`id`),
3168  ADD KEY `user_id_lactivity` (`user_id`,`lactivity`);
3169
3170--
3171-- Indici per le tabelle `lh_users_remember`
3172--
3173ALTER TABLE `lh_users_remember`
3174  ADD PRIMARY KEY (`id`);
3175
3176--
3177-- Indici per le tabelle `lh_users_session`
3178--
3179ALTER TABLE `lh_users_session`
3180  ADD PRIMARY KEY (`id`),
3181  ADD KEY `device_token_device_type_v2` (`device_token`(191),`device_type`),
3182  ADD KEY `token` (`token`);
3183
3184--
3185-- Indici per le tabelle `lh_users_setting`
3186--
3187ALTER TABLE `lh_users_setting`
3188  ADD PRIMARY KEY (`id`),
3189  ADD KEY `user_id` (`user_id`,`identifier`);
3190
3191--
3192-- Indici per le tabelle `lh_users_setting_option`
3193--
3194ALTER TABLE `lh_users_setting_option`
3195  ADD PRIMARY KEY (`identifier`);
3196
3197--
3198-- AUTO_INCREMENT per le tabelle scaricate
3199--
3200
3201--
3202-- AUTO_INCREMENT per la tabella `lh_abstract_auto_responder`
3203--
3204ALTER TABLE `lh_abstract_auto_responder`
3205  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3206
3207--
3208-- AUTO_INCREMENT per la tabella `lh_abstract_auto_responder_chat`
3209--
3210ALTER TABLE `lh_abstract_auto_responder_chat`
3211  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3212
3213--
3214-- AUTO_INCREMENT per la tabella `lh_abstract_browse_offer_invitation`
3215--
3216ALTER TABLE `lh_abstract_browse_offer_invitation`
3217  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3218
3219--
3220-- AUTO_INCREMENT per la tabella `lh_abstract_chat_column`
3221--
3222ALTER TABLE `lh_abstract_chat_column`
3223  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3224
3225--
3226-- AUTO_INCREMENT per la tabella `lh_abstract_chat_priority`
3227--
3228ALTER TABLE `lh_abstract_chat_priority`
3229  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3230
3231--
3232-- AUTO_INCREMENT per la tabella `lh_abstract_chat_variable`
3233--
3234ALTER TABLE `lh_abstract_chat_variable`
3235  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3236
3237--
3238-- AUTO_INCREMENT per la tabella `lh_abstract_email_template`
3239--
3240ALTER TABLE `lh_abstract_email_template`
3241  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
3242
3243--
3244-- AUTO_INCREMENT per la tabella `lh_abstract_form`
3245--
3246ALTER TABLE `lh_abstract_form`
3247  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3248
3249--
3250-- AUTO_INCREMENT per la tabella `lh_abstract_form_collected`
3251--
3252ALTER TABLE `lh_abstract_form_collected`
3253  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3254
3255--
3256-- AUTO_INCREMENT per la tabella `lh_abstract_proactive_chat_campaign`
3257--
3258ALTER TABLE `lh_abstract_proactive_chat_campaign`
3259  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3260
3261--
3262-- AUTO_INCREMENT per la tabella `lh_abstract_proactive_chat_campaign_conv`
3263--
3264ALTER TABLE `lh_abstract_proactive_chat_campaign_conv`
3265  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3266
3267--
3268-- AUTO_INCREMENT per la tabella `lh_abstract_proactive_chat_event`
3269--
3270ALTER TABLE `lh_abstract_proactive_chat_event`
3271  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3272
3273--
3274-- AUTO_INCREMENT per la tabella `lh_abstract_proactive_chat_invitation`
3275--
3276ALTER TABLE `lh_abstract_proactive_chat_invitation`
3277  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3278
3279--
3280-- AUTO_INCREMENT per la tabella `lh_abstract_proactive_chat_invitation_event`
3281--
3282ALTER TABLE `lh_abstract_proactive_chat_invitation_event`
3283  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3284
3285--
3286-- AUTO_INCREMENT per la tabella `lh_abstract_proactive_chat_variables`
3287--
3288ALTER TABLE `lh_abstract_proactive_chat_variables`
3289  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3290
3291--
3292-- AUTO_INCREMENT per la tabella `lh_abstract_product`
3293--
3294ALTER TABLE `lh_abstract_product`
3295  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3296
3297--
3298-- AUTO_INCREMENT per la tabella `lh_abstract_product_departament`
3299--
3300ALTER TABLE `lh_abstract_product_departament`
3301  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3302
3303--
3304-- AUTO_INCREMENT per la tabella `lh_abstract_rest_api_key`
3305--
3306ALTER TABLE `lh_abstract_rest_api_key`
3307  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3308
3309--
3310-- AUTO_INCREMENT per la tabella `lh_abstract_rest_api_key_remote`
3311--
3312ALTER TABLE `lh_abstract_rest_api_key_remote`
3313  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3314
3315--
3316-- AUTO_INCREMENT per la tabella `lh_abstract_subject`
3317--
3318ALTER TABLE `lh_abstract_subject`
3319  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3320
3321--
3322-- AUTO_INCREMENT per la tabella `lh_abstract_subject_chat`
3323--
3324ALTER TABLE `lh_abstract_subject_chat`
3325  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3326
3327--
3328-- AUTO_INCREMENT per la tabella `lh_abstract_subject_dep`
3329--
3330ALTER TABLE `lh_abstract_subject_dep`
3331  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3332
3333--
3334-- AUTO_INCREMENT per la tabella `lh_abstract_survey`
3335--
3336ALTER TABLE `lh_abstract_survey`
3337  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3338
3339--
3340-- AUTO_INCREMENT per la tabella `lh_abstract_survey_item`
3341--
3342ALTER TABLE `lh_abstract_survey_item`
3343  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3344
3345--
3346-- AUTO_INCREMENT per la tabella `lh_abstract_widget_theme`
3347--
3348ALTER TABLE `lh_abstract_widget_theme`
3349  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3350
3351--
3352-- AUTO_INCREMENT per la tabella `lh_admin_theme`
3353--
3354ALTER TABLE `lh_admin_theme`
3355  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3356
3357--
3358-- AUTO_INCREMENT per la tabella `lh_audits`
3359--
3360ALTER TABLE `lh_audits`
3361  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3362
3363--
3364-- AUTO_INCREMENT per la tabella `lh_canned_msg`
3365--
3366ALTER TABLE `lh_canned_msg`
3367  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3368
3369--
3370-- AUTO_INCREMENT per la tabella `lh_canned_msg_tag`
3371--
3372ALTER TABLE `lh_canned_msg_tag`
3373  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3374
3375--
3376-- AUTO_INCREMENT per la tabella `lh_canned_msg_tag_link`
3377--
3378ALTER TABLE `lh_canned_msg_tag_link`
3379  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3380
3381--
3382-- AUTO_INCREMENT per la tabella `lh_chat`
3383--
3384ALTER TABLE `lh_chat`
3385  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3386
3387--
3388-- AUTO_INCREMENT per la tabella `lh_chatbox`
3389--
3390ALTER TABLE `lh_chatbox`
3391  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3392
3393--
3394-- AUTO_INCREMENT per la tabella `lh_chat_accept`
3395--
3396ALTER TABLE `lh_chat_accept`
3397  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3398
3399--
3400-- AUTO_INCREMENT per la tabella `lh_chat_archive_range`
3401--
3402ALTER TABLE `lh_chat_archive_range`
3403  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3404
3405--
3406-- AUTO_INCREMENT per la tabella `lh_chat_blocked_user`
3407--
3408ALTER TABLE `lh_chat_blocked_user`
3409  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3410
3411--
3412-- AUTO_INCREMENT per la tabella `lh_chat_file`
3413--
3414ALTER TABLE `lh_chat_file`
3415  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
3416
3417--
3418-- AUTO_INCREMENT per la tabella `lh_chat_online_user`
3419--
3420ALTER TABLE `lh_chat_online_user`
3421  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
3422
3423--
3424-- AUTO_INCREMENT per la tabella `lh_chat_online_user_footprint`
3425--
3426ALTER TABLE `lh_chat_online_user_footprint`
3427  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3428
3429--
3430-- AUTO_INCREMENT per la tabella `lh_chat_paid`
3431--
3432ALTER TABLE `lh_chat_paid`
3433  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3434
3435--
3436-- AUTO_INCREMENT per la tabella `lh_chat_start_settings`
3437--
3438ALTER TABLE `lh_chat_start_settings`
3439  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3440
3441--
3442-- AUTO_INCREMENT per la tabella `lh_cobrowse`
3443--
3444ALTER TABLE `lh_cobrowse`
3445  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3446
3447--
3448-- AUTO_INCREMENT per la tabella `lh_departament`
3449--
3450ALTER TABLE `lh_departament`
3451  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
3452
3453--
3454-- AUTO_INCREMENT per la tabella `lh_departament_availability`
3455--
3456ALTER TABLE `lh_departament_availability`
3457  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3458
3459--
3460-- AUTO_INCREMENT per la tabella `lh_departament_custom_work_hours`
3461--
3462ALTER TABLE `lh_departament_custom_work_hours`
3463  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3464
3465--
3466-- AUTO_INCREMENT per la tabella `lh_departament_group`
3467--
3468ALTER TABLE `lh_departament_group`
3469  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3470
3471--
3472-- AUTO_INCREMENT per la tabella `lh_departament_group_member`
3473--
3474ALTER TABLE `lh_departament_group_member`
3475  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3476
3477--
3478-- AUTO_INCREMENT per la tabella `lh_departament_group_user`
3479--
3480ALTER TABLE `lh_departament_group_user`
3481  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3482
3483--
3484-- AUTO_INCREMENT per la tabella `lh_departament_limit_group`
3485--
3486ALTER TABLE `lh_departament_limit_group`
3487  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3488
3489--
3490-- AUTO_INCREMENT per la tabella `lh_departament_limit_group_member`
3491--
3492ALTER TABLE `lh_departament_limit_group_member`
3493  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3494
3495--
3496-- AUTO_INCREMENT per la tabella `lh_faq`
3497--
3498ALTER TABLE `lh_faq`
3499  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3500
3501--
3502-- AUTO_INCREMENT per la tabella `lh_forgotpasswordhash`
3503--
3504ALTER TABLE `lh_forgotpasswordhash`
3505  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3506
3507--
3508-- AUTO_INCREMENT per la tabella `lh_generic_bot_bot`
3509--
3510ALTER TABLE `lh_generic_bot_bot`
3511  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3512
3513--
3514-- AUTO_INCREMENT per la tabella `lh_generic_bot_chat_event`
3515--
3516ALTER TABLE `lh_generic_bot_chat_event`
3517  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3518
3519--
3520-- AUTO_INCREMENT per la tabella `lh_generic_bot_chat_workflow`
3521--
3522ALTER TABLE `lh_generic_bot_chat_workflow`
3523  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3524
3525--
3526-- AUTO_INCREMENT per la tabella `lh_generic_bot_exception`
3527--
3528ALTER TABLE `lh_generic_bot_exception`
3529  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3530
3531--
3532-- AUTO_INCREMENT per la tabella `lh_generic_bot_exception_message`
3533--
3534ALTER TABLE `lh_generic_bot_exception_message`
3535  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3536
3537--
3538-- AUTO_INCREMENT per la tabella `lh_generic_bot_group`
3539--
3540ALTER TABLE `lh_generic_bot_group`
3541  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3542
3543--
3544-- AUTO_INCREMENT per la tabella `lh_generic_bot_payload`
3545--
3546ALTER TABLE `lh_generic_bot_payload`
3547  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3548
3549--
3550-- AUTO_INCREMENT per la tabella `lh_generic_bot_pending_event`
3551--
3552ALTER TABLE `lh_generic_bot_pending_event`
3553  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3554
3555--
3556-- AUTO_INCREMENT per la tabella `lh_generic_bot_repeat_restrict`
3557--
3558ALTER TABLE `lh_generic_bot_repeat_restrict`
3559  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3560
3561--
3562-- AUTO_INCREMENT per la tabella `lh_generic_bot_trigger`
3563--
3564ALTER TABLE `lh_generic_bot_trigger`
3565  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3566
3567--
3568-- AUTO_INCREMENT per la tabella `lh_generic_bot_trigger_event`
3569--
3570ALTER TABLE `lh_generic_bot_trigger_event`
3571  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3572
3573--
3574-- AUTO_INCREMENT per la tabella `lh_generic_bot_tr_group`
3575--
3576ALTER TABLE `lh_generic_bot_tr_group`
3577  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3578
3579--
3580-- AUTO_INCREMENT per la tabella `lh_generic_bot_tr_item`
3581--
3582ALTER TABLE `lh_generic_bot_tr_item`
3583  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3584
3585--
3586-- AUTO_INCREMENT per la tabella `lh_group`
3587--
3588ALTER TABLE `lh_group`
3589  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
3590
3591--
3592-- AUTO_INCREMENT per la tabella `lh_grouprole`
3593--
3594ALTER TABLE `lh_grouprole`
3595  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
3596
3597--
3598-- AUTO_INCREMENT per la tabella `lh_groupuser`
3599--
3600ALTER TABLE `lh_groupuser`
3601  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
3602
3603--
3604-- AUTO_INCREMENT per la tabella `lh_group_object`
3605--
3606ALTER TABLE `lh_group_object`
3607  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3608
3609--
3610-- AUTO_INCREMENT per la tabella `lh_group_work`
3611--
3612ALTER TABLE `lh_group_work`
3613  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3614
3615--
3616-- AUTO_INCREMENT per la tabella `lh_msg`
3617--
3618ALTER TABLE `lh_msg`
3619  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3620
3621--
3622-- AUTO_INCREMENT per la tabella `lh_notification_subscriber`
3623--
3624ALTER TABLE `lh_notification_subscriber`
3625  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
3626
3627--
3628-- AUTO_INCREMENT per la tabella `lh_question`
3629--
3630ALTER TABLE `lh_question`
3631  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3632
3633--
3634-- AUTO_INCREMENT per la tabella `lh_question_answer`
3635--
3636ALTER TABLE `lh_question_answer`
3637  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3638
3639--
3640-- AUTO_INCREMENT per la tabella `lh_question_option`
3641--
3642ALTER TABLE `lh_question_option`
3643  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3644
3645--
3646-- AUTO_INCREMENT per la tabella `lh_question_option_answer`
3647--
3648ALTER TABLE `lh_question_option_answer`
3649  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3650
3651--
3652-- AUTO_INCREMENT per la tabella `lh_role`
3653--
3654ALTER TABLE `lh_role`
3655  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
3656
3657--
3658-- AUTO_INCREMENT per la tabella `lh_rolefunction`
3659--
3660ALTER TABLE `lh_rolefunction`
3661  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;
3662
3663--
3664-- AUTO_INCREMENT per la tabella `lh_speech_chat_language`
3665--
3666ALTER TABLE `lh_speech_chat_language`
3667  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3668
3669--
3670-- AUTO_INCREMENT per la tabella `lh_speech_language`
3671--
3672ALTER TABLE `lh_speech_language`
3673  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;
3674
3675--
3676-- AUTO_INCREMENT per la tabella `lh_speech_language_dialect`
3677--
3678ALTER TABLE `lh_speech_language_dialect`
3679  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=161;
3680
3681--
3682-- AUTO_INCREMENT per la tabella `lh_speech_user_language`
3683--
3684ALTER TABLE `lh_speech_user_language`
3685  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
3686
3687--
3688-- AUTO_INCREMENT per la tabella `lh_transfer`
3689--
3690ALTER TABLE `lh_transfer`
3691  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3692
3693--
3694-- AUTO_INCREMENT per la tabella `lh_userdep`
3695--
3696ALTER TABLE `lh_userdep`
3697  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
3698
3699--
3700-- AUTO_INCREMENT per la tabella `lh_users`
3701--
3702ALTER TABLE `lh_users`
3703  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
3704
3705--
3706-- AUTO_INCREMENT per la tabella `lh_users_online_session`
3707--
3708ALTER TABLE `lh_users_online_session`
3709  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
3710
3711--
3712-- AUTO_INCREMENT per la tabella `lh_users_remember`
3713--
3714ALTER TABLE `lh_users_remember`
3715  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
3716
3717--
3718-- AUTO_INCREMENT per la tabella `lh_users_session`
3719--
3720ALTER TABLE `lh_users_session`
3721  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3722
3723--
3724-- AUTO_INCREMENT per la tabella `lh_users_setting`
3725--
3726ALTER TABLE `lh_users_setting`
3727  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
3728--
3729-- Database: `HydroHost`
3730--
3731CREATE DATABASE IF NOT EXISTS `HydroHost` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
3732USE `HydroHost`;
3733
3734-- --------------------------------------------------------
3735
3736--
3737-- Struttura della tabella `new-invoices`
3738--
3739
3740CREATE TABLE `new-invoices` (
3741  `email` varchar(255) NOT NULL,
3742  `service` varchar(255) NOT NULL,
3743  `amount` int(255) NOT NULL
3744) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3745
3746-- --------------------------------------------------------
3747
3748--
3749-- Struttura della tabella `services`
3750--
3751
3752CREATE TABLE `services` (
3753  `email` varchar(255) NOT NULL,
3754  `service` varchar(255) NOT NULL,
3755  `lday` int(255) NOT NULL,
3756  `lmonth` int(255) NOT NULL,
3757  `lyear` int(255) NOT NULL,
3758  `rday` int(2) NOT NULL,
3759  `rmonth` int(2) NOT NULL,
3760  `ryear` int(255) NOT NULL,
3761  `lamount` int(255) NOT NULL
3762) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3763
3764-- --------------------------------------------------------
3765
3766--
3767-- Struttura della tabella `users`
3768--
3769
3770CREATE TABLE `users` (
3771  `first` varchar(255) NOT NULL,
3772  `last` varchar(255) NOT NULL,
3773  `email` varchar(255) NOT NULL,
3774  `password` varchar(255) NOT NULL,
3775  `token` varchar(255) NOT NULL,
3776  `verified` int(1) NOT NULL,
3777  `locked` int(1) NOT NULL DEFAULT '0'
3778) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3779
3780--
3781-- Dump dei dati per la tabella `users`
3782--
3783
3784INSERT INTO `users` (`first`, `last`, `email`, `password`, `token`, `verified`, `locked`) VALUES
3785('Chickendrk', 'Chickendark', 'acmi0005@gmail.com', 'giusi1975', '', 1, 0),
3786('Francesco', 'Genio', 'antoninogenio@gmail.com', 'ciao1234', '', 1, 0),
3787('Emanuele', 'Greco', 'emagreco06@outlook.com', 'Pericolo08$', '', 1, 0),
3788('Luca', 'Da Rin', 'lucadarin12@gmail.com', 'famdarin', '', 1, 0),
3789('Marco', 'Lavarini', 'marco.lvr@outlook.it', 'Micr00nde', '', 1, 0),
3790('Daniele', 'Santi', 'minecraftone33@gmail.com', 'danielino66', '', 1, 0),
3791('Marco', 'Frassi', 'sottopallasudato04@gmail.com', 'Framas2004', '', 1, 0);
3792
3793--
3794-- Indici per le tabelle scaricate
3795--
3796
3797--
3798-- Indici per le tabelle `services`
3799--
3800ALTER TABLE `services`
3801  ADD PRIMARY KEY (`email`);
3802
3803--
3804-- Indici per le tabelle `users`
3805--
3806ALTER TABLE `users`
3807  ADD UNIQUE KEY `email` (`email`);
3808--
3809-- Database: `HydroMC`
3810--
3811CREATE DATABASE IF NOT EXISTS `HydroMC` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
3812USE `HydroMC`;
3813
3814-- --------------------------------------------------------
3815
3816--
3817-- Struttura della tabella `ci_sessions`
3818--
3819
3820CREATE TABLE `ci_sessions` (
3821  `id` varchar(40) NOT NULL,
3822  `ip_address` varchar(45) NOT NULL,
3823  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
3824  `data` blob NOT NULL
3825) ENGINE=MyISAM DEFAULT CHARSET=latin1;
3826
3827--
3828-- Dump dei dati per la tabella `ci_sessions`
3829--
3830
3831INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
3832('6m1errclidacame01va5odp247', '188.114.102.14', 1581111171, 0x5f5f63695f6c6173745f726567656e65726174657c693a313538313131313137313b),
3833('i8iaovm54gll80t92cgnubs75a', '188.114.102.14', 1581111190, 0x5f5f63695f6c6173745f726567656e65726174657c693a313538313131313139303b),
3834('ci5lmlrr6gvgt78uou628hd0ei', '188.114.102.14', 1581111193, 0x5f5f63695f6c6173745f726567656e65726174657c693a313538313131313139333b),
3835('d701mci1i7jqe3r2ofm1uo77ll', '188.114.102.14', 1581111201, 0x5f5f63695f6c6173745f726567656e65726174657c693a313538313131313230313b),
3836('ak47fr2cmnk31sr8ap9l6ddd71', '188.114.102.14', 1581111231, 0x5f5f63695f6c6173745f726567656e65726174657c693a313538313131313233313b),
3837('9aoqognt3j5ti1eilr7dcpuoeq', '188.114.102.14', 1581111241, 0x5f5f63695f6c6173745f726567656e65726174657c693a313538313131313234313b),
3838('dp9rpbo7iien7hudd1hopisovu', '188.114.102.14', 1581111282, 0x5f5f63695f6c6173745f726567656e65726174657c693a313538313131313238323b),
3839('3g9sjd7280hov3ruhpmss177ar', '188.114.102.14', 1581111321, 0x5f5f63695f6c6173745f726567656e65726174657c693a313538313131313332313b),
3840('sv2re68a3fir3abimntv0g0uba', '188.114.102.14', 1581111324, 0x5f5f63695f6c6173745f726567656e65726174657c693a313538313131313332343b),
3841('nh423f0i8o7brlov8ei40l022h', '188.114.102.14', 1581111361, 0x5f5f63695f6c6173745f726567656e65726174657c693a313538313131313336313b);
3842
3843-- --------------------------------------------------------
3844
3845--
3846-- Struttura della tabella `minecraft-sessions`
3847--
3848
3849CREATE TABLE `minecraft-sessions` (
3850  `minecraftname` varchar(16) NOT NULL,
3851  `ipv4` varchar(255) NOT NULL,
3852  `last-server` varchar(255) NOT NULL
3853) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3854
3855--
3856-- Dump dei dati per la tabella `minecraft-sessions`
3857--
3858
3859INSERT INTO `minecraft-sessions` (`minecraftname`, `ipv4`, `last-server`) VALUES
3860('Im_Not_Mine33', '', 'Secret'),
3861('MarcoLvr', '', 'lobby'),
3862('NakaShigetoki_', '', 'Secret'),
3863('xXEmaYTXx', '', 'lobby');
3864
3865-- --------------------------------------------------------
3866
3867--
3868-- Struttura della tabella `orders`
3869--
3870
3871CREATE TABLE `orders` (
3872  `oid` int(11) NOT NULL,
3873  `pid_fk` int(11) DEFAULT NULL,
3874  `uid_fk` int(11) DEFAULT NULL,
3875  `payerID` varchar(300) DEFAULT NULL,
3876  `paymentID` varchar(400) DEFAULT NULL,
3877  `token` varchar(400) DEFAULT NULL,
3878  `created` int(11) DEFAULT NULL
3879) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3880
3881--
3882-- Dump dei dati per la tabella `orders`
3883--
3884
3885INSERT INTO `orders` (`oid`, `pid_fk`, `uid_fk`, `payerID`, `paymentID`, `token`, `created`) VALUES
3886(5, 1, 1, '8B6CEM33UZFFG', 'PAY-4EU9291320072404VLG6EY3Q', 'EC-6M9829956F554642S', 1505665831),
3887(6, 2, 1, '8B6CEM33UZFFG', 'PAY-59X180707Y2127145LG75DRA', 'EC-5NW69550VG452514Y', 1505743317),
3888(7, 1, 1, '8B6CEM33UZFFG', 'PAY-1LP319553K4748813LG75WZQ', 'EC-52V24967TB735624C', 1505745783),
3889(8, 1, 1, '8B6CEM33UZFFG', 'PAY-75R31998X3933340BLG777KY', 'EC-8CN890966V0309306', 1505755075);
3890
3891-- --------------------------------------------------------
3892
3893--
3894-- Struttura della tabella `payments`
3895--
3896
3897CREATE TABLE `payments` (
3898  `txn_id` int(11) NOT NULL,
3899  `PaymentMethod` varchar(50) NOT NULL,
3900  `PayerStatus` varchar(50) NOT NULL,
3901  `PayerMail` int(100) NOT NULL,
3902  `Total` decimal(19,2) NOT NULL,
3903  `SubTotal` decimal(19,2) NOT NULL,
3904  `Tax` decimal(19,2) NOT NULL,
3905  `Payment_state` varchar(50) NOT NULL,
3906  `CreateTime` varchar(50) NOT NULL,
3907  `UpdateTime` varchar(50) NOT NULL
3908) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3909
3910-- --------------------------------------------------------
3911
3912--
3913-- Struttura della tabella `paypal_payments`
3914--
3915
3916CREATE TABLE `paypal_payments` (
3917  `id` int(11) NOT NULL,
3918  `item_no` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
3919  `transaction_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
3920  `payment_amount` float(10,2) NOT NULL,
3921  `currency_code` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
3922  `payment_status` varchar(255) COLLATE utf8_unicode_ci NOT NULL
3923) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3924
3925-- --------------------------------------------------------
3926
3927--
3928-- Struttura della tabella `paypal_products`
3929--
3930
3931CREATE TABLE `paypal_products` (
3932  `id` int(11) NOT NULL,
3933  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
3934  `price` float(10,2) NOT NULL
3935) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3936
3937--
3938-- Dump dei dati per la tabella `paypal_products`
3939--
3940
3941INSERT INTO `paypal_products` (`id`, `name`, `price`) VALUES
3942(1, 'test', 1.00);
3943
3944-- --------------------------------------------------------
3945
3946--
3947-- Struttura della tabella `products`
3948--
3949
3950CREATE TABLE `products` (
3951  `pid` int(11) NOT NULL,
3952  `product` varchar(255) DEFAULT NULL,
3953  `product_img` varchar(100) DEFAULT NULL,
3954  `price` int(11) DEFAULT NULL,
3955  `currency` varchar(10) DEFAULT NULL
3956) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3957
3958--
3959-- Dump dei dati per la tabella `products`
3960--
3961
3962INSERT INTO `products` (`pid`, `product`, `product_img`, `price`, `currency`) VALUES
3963(1, '9lessons Sticker', '9lessons.png', 2, 'USD'),
3964(2, 'WallScript Sticker', 'wallscript.png', 3, 'USD');
3965
3966-- --------------------------------------------------------
3967
3968--
3969-- Struttura della tabella `user-data`
3970--
3971
3972CREATE TABLE `user-data` (
3973  `firstname` varchar(255) NOT NULL,
3974  `lastname` varchar(255) NOT NULL,
3975  `username` varchar(16) NOT NULL,
3976  `minecraftname` varchar(16) NOT NULL,
3977  `email` varchar(255) NOT NULL,
3978  `password` varchar(255) NOT NULL,
3979  `token` varchar(255) NOT NULL,
3980  `actiontoken` varchar(255) NOT NULL,
3981  `action` varchar(255) NOT NULL DEFAULT '',
3982  `dekey` varchar(255) NOT NULL DEFAULT '',
3983  `friends` text,
3984  `lastip` varchar(255) NOT NULL DEFAULT '',
3985  `verified` int(1) NOT NULL DEFAULT '0',
3986  `locked` int(1) NOT NULL DEFAULT '0',
3987  `banned` int(1) NOT NULL DEFAULT '0',
3988  `staff` int(1) NOT NULL DEFAULT '0',
3989  `online` int(1) NOT NULL DEFAULT '0'
3990) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3991
3992--
3993-- Dump dei dati per la tabella `user-data`
3994--
3995
3996INSERT INTO `user-data` (`firstname`, `lastname`, `username`, `minecraftname`, `email`, `password`, `token`, `actiontoken`, `action`, `dekey`, `friends`, `lastip`, `verified`, `locked`, `banned`, `staff`, `online`) VALUES
3997('Nicola', 'Berti', 'Babil3us', 'Babil3us', 'babil3us.yt.contact@gmail.com', 'pinolo', '4040ABFF081BCB728CBA2F6B65FF8E355A370885', '', '', '', '', '0', 1, 0, 0, 0, 0),
3998('Claudio', 'Chiummariello', 'Cla_Chiumma', 'Cla_Chiumma', 'cla.chiummariello@gmail.com', 'Napoli1926', 'E6635A72A7B6A7BBD7ABF0CAC5256CF3B787EEEE', '', '', '', '', '0', 1, 0, 0, 0, 0),
3999('Luca', 'Lavarini', 'CursoryPlum7401', 'CursoryPlum7401', 'ydarklighty@gmail.com', 'asdrubal3', '513C29DBD354484DF2186E46F58913CC8C524496', '', '', '', '729E48E238DF7696F983696ED4E5AFF8CDCAC74B', '0', 1, 0, 0, 0, 0),
4000('Tommaso', 'Menegoi', 'Jovv1029', 'Jovv1029', 'Tommaso5.menegoi@gmail.com', 'Tommaso5', '0AF4E5E102558BBFD28F041008E6A91B443DCA2B', '', '', '', '', '0', 1, 0, 0, 0, 0),
4001('Juice', 'TM', 'JuiceTM', 'JuiceTM', 'JuiceTM@hydromc.org', 'pusolino23', 'B47C97C8F63F6CFFECFD88954A282297E5DD6548', 'R5jS5rD6lK5wJ6xL9mZ9cQ4eM8y', '', '', NULL, '', 1, 0, 0, 0, 0),
4002('Luca', 'Da Rin', 'LiveLuca', 'LiveLuke', 'lucadarin12@gmail.com', 'famdarin', 'CEA501B55B010E31D8F25ED5866423BD9FE54DBE', '', '', '', '', '87.14.253.110', 1, 0, 0, 1, 0),
4003('Marco', 'Lavarini', 'MarcoLvr', 'MarcoLvr', 'marco.lvr@outlook.it', 'Micr00nde', '729E48E238DF7696F983696ED4E5AFF8CDCAC74B', '', '', '', '', '87.13.122.59', 1, 0, 0, 1, 0),
4004('Daniele', 'Santi', 'Mine33', 'Im_Not_Mine33', 'minecraftone33@gmail.com', 'danielino66', '7C52E630F68C4D9A1F947083A2F1F12087C4FFB7', '', '', '', '', '79.19.179.206', 1, 0, 0, 1, 0),
4005('Massimiliano', 'Shigetoki', 'Nakamoto', 'NakaShigetoki_', 'nakamoto@maxcode.it', '19092018Nm', '7D4F35B44A8B83CE8C396DFB3C5DAE9EF32543ED', '', '', '', '', '151.29.26.47', 1, 0, 0, 1, 0),
4006('Luca', 'Giacchetto', 'Rengard', '', 'giacchettoluca44@gmail.com', 'diocane4', 'E3ECBE6BFD232CF2D355371B3A8B6ABE848A1676', '', '', '', '', '0', 1, 0, 0, 0, 0),
4007('Tommaso', 'Giannoni', 'Tommy4594', 'Tommy4594', 'giannonitommaso@hotmail.com\r\n', 'Karate1234', '12DC5F318F01BB64B3FBC966039B9FCDFC97F35C', '', '', '', '', '0', 1, 0, 0, 1, 0),
4008('Emanuele', 'Greco', 'xXEmaYTXx', 'xXEmaYTXx', 'emagreco06@gmail.com', 'Pericolo08$', 'BEDE2390BBF764983CBC5E6B4A7469682FCFFEFC', '', '', '', '', '', 1, 0, 0, 1, 0);
4009
4010-- --------------------------------------------------------
4011
4012--
4013-- Struttura della tabella `user-friends`
4014--
4015
4016CREATE TABLE `user-friends` (
4017  `sender` varchar(255) NOT NULL,
4018  `recipient` varchar(255) NOT NULL,
4019  `accepted` int(1) NOT NULL
4020) ENGINE=MyISAM DEFAULT CHARSET=latin1;
4021
4022--
4023-- Dump dei dati per la tabella `user-friends`
4024--
4025
4026INSERT INTO `user-friends` (`sender`, `recipient`, `accepted`) VALUES
4027('9f112b394832cf8d9fecbddbd26fb45efb4d4f41', '2bf468033722212a2e079867fc0117ffa8115212', 0);
4028
4029-- --------------------------------------------------------
4030
4031--
4032-- Struttura della tabella `user-games`
4033--
4034
4035CREATE TABLE `user-games` (
4036  `email` varchar(255) NOT NULL,
4037  `game2d` int(1) DEFAULT '0',
4038  `cyberrain` int(1) NOT NULL DEFAULT '0'
4039) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4040
4041--
4042-- Dump dei dati per la tabella `user-games`
4043--
4044
4045INSERT INTO `user-games` (`email`, `game2d`, `cyberrain`) VALUES
4046('cla.chiummariello@gmail.com', 0, 0),
4047('emagreco06@gmail.com', 0, 0),
4048('lucadarin12@gmail.com', 0, 0),
4049('marco.lvr@outlook.it', 0, 0),
4050('minecraftone33@gmail.com', 0, 0),
4051('nakamoto@maxcode.it', 0, 0),
4052('Tommaso5.menegoi@gmail.com', 0, 0);
4053
4054-- --------------------------------------------------------
4055
4056--
4057-- Struttura della tabella `user-minecraft`
4058--
4059
4060CREATE TABLE `user-minecraft` (
4061  `email` varchar(255) NOT NULL,
4062  `coins` int(255) NOT NULL DEFAULT '10'
4063) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4064
4065--
4066-- Dump dei dati per la tabella `user-minecraft`
4067--
4068
4069INSERT INTO `user-minecraft` (`email`, `coins`) VALUES
4070('babil3us.yt.contact@gmail.com', 872000),
4071('emagreco06@gmail.com', 9760000),
4072('giannonitommaso@hotmail.com\r\n', 1000000),
4073('JuiceTM@hydromc.org', 10),
4074('lucadarin12@gmail.com', 10),
4075('marco.lvr@outlook.it', 612000),
4076('minecraftone33@gmail.com', 746000),
4077('nakamoto@maxcode.it', 746000);
4078
4079-- --------------------------------------------------------
4080
4081--
4082-- Struttura della tabella `users`
4083--
4084
4085CREATE TABLE `users` (
4086  `uid` int(11) NOT NULL,
4087  `username` varchar(200) DEFAULT NULL,
4088  `password` varchar(400) DEFAULT NULL,
4089  `email` varchar(200) DEFAULT NULL
4090) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4091
4092--
4093-- Dump dei dati per la tabella `users`
4094--
4095
4096INSERT INTO `users` (`uid`, `username`, `password`, `email`) VALUES
4097(1, 'srinivas', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', 'srinivas@9lessons.info');
4098
4099--
4100-- Indici per le tabelle scaricate
4101--
4102
4103--
4104-- Indici per le tabelle `ci_sessions`
4105--
4106ALTER TABLE `ci_sessions`
4107  ADD PRIMARY KEY (`id`),
4108  ADD KEY `ci_sessions_timestamp` (`timestamp`);
4109
4110--
4111-- Indici per le tabelle `minecraft-sessions`
4112--
4113ALTER TABLE `minecraft-sessions`
4114  ADD UNIQUE KEY `minecraftname` (`minecraftname`);
4115
4116--
4117-- Indici per le tabelle `orders`
4118--
4119ALTER TABLE `orders`
4120  ADD PRIMARY KEY (`oid`);
4121
4122--
4123-- Indici per le tabelle `paypal_payments`
4124--
4125ALTER TABLE `paypal_payments`
4126  ADD PRIMARY KEY (`id`);
4127
4128--
4129-- Indici per le tabelle `paypal_products`
4130--
4131ALTER TABLE `paypal_products`
4132  ADD PRIMARY KEY (`id`);
4133
4134--
4135-- Indici per le tabelle `products`
4136--
4137ALTER TABLE `products`
4138  ADD PRIMARY KEY (`pid`);
4139
4140--
4141-- Indici per le tabelle `user-data`
4142--
4143ALTER TABLE `user-data`
4144  ADD UNIQUE KEY `username` (`username`),
4145  ADD UNIQUE KEY `email` (`email`),
4146  ADD UNIQUE KEY `token` (`token`);
4147
4148--
4149-- Indici per le tabelle `user-friends`
4150--
4151ALTER TABLE `user-friends`
4152  ADD PRIMARY KEY (`accepted`);
4153
4154--
4155-- Indici per le tabelle `user-games`
4156--
4157ALTER TABLE `user-games`
4158  ADD UNIQUE KEY `email` (`email`);
4159
4160--
4161-- Indici per le tabelle `user-minecraft`
4162--
4163ALTER TABLE `user-minecraft`
4164  ADD UNIQUE KEY `email` (`email`);
4165
4166--
4167-- Indici per le tabelle `users`
4168--
4169ALTER TABLE `users`
4170  ADD PRIMARY KEY (`uid`);
4171
4172--
4173-- AUTO_INCREMENT per le tabelle scaricate
4174--
4175
4176--
4177-- AUTO_INCREMENT per la tabella `orders`
4178--
4179ALTER TABLE `orders`
4180  MODIFY `oid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
4181
4182--
4183-- AUTO_INCREMENT per la tabella `paypal_payments`
4184--
4185ALTER TABLE `paypal_payments`
4186  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
4187
4188--
4189-- AUTO_INCREMENT per la tabella `paypal_products`
4190--
4191ALTER TABLE `paypal_products`
4192  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
4193
4194--
4195-- AUTO_INCREMENT per la tabella `products`
4196--
4197ALTER TABLE `products`
4198  MODIFY `pid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
4199
4200--
4201-- AUTO_INCREMENT per la tabella `users`
4202--
4203ALTER TABLE `users`
4204  MODIFY `uid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
4205--
4206-- Database: `MarcoLvr`
4207--
4208CREATE DATABASE IF NOT EXISTS `MarcoLvr` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
4209USE `MarcoLvr`;
4210
4211-- --------------------------------------------------------
4212
4213--
4214-- Struttura della tabella `subvanilla`
4215--
4216
4217CREATE TABLE `subvanilla` (
4218  `username` varchar(255) NOT NULL,
4219  `password` varchar(255) NOT NULL,
4220  `actiontoken` varchar(255) NOT NULL DEFAULT '',
4221  `action` varchar(255) NOT NULL DEFAULT '',
4222  `lastip` varchar(255) NOT NULL DEFAULT ''
4223) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4224
4225--
4226-- Dump dei dati per la tabella `subvanilla`
4227--
4228
4229INSERT INTO `subvanilla` (`username`, `password`, `actiontoken`, `action`, `lastip`) VALUES
4230('GINO BALLERINO', 'PASS', '', '', 'null'),
4231('Im_Not_Mine33', 'danielino66', '', '', '79.19.179.206'),
4232('MarcoLvr', 'Micr00nde', '', '', '87.13.122.59'),
4233('pioenonnine', '', '', '', 'null'),
4234('PORCO_DIO', 'gggg', '', '', 'null'),
4235('sendriu', 'ciaoatutti', '', '', '93.34.113.130'),
4236('xXEmaYTXx', 'Pericolo08$', '', '', '2.226.156.252');
4237
4238--
4239-- Indici per le tabelle scaricate
4240--
4241
4242--
4243-- Indici per le tabelle `subvanilla`
4244--
4245ALTER TABLE `subvanilla`
4246  ADD UNIQUE KEY `username` (`username`);
4247--
4248-- Database: `phpmyadmin`
4249--
4250CREATE DATABASE IF NOT EXISTS `phpmyadmin` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
4251USE `phpmyadmin`;
4252
4253-- --------------------------------------------------------
4254
4255--
4256-- Struttura della tabella `pma__bookmark`
4257--
4258
4259CREATE TABLE `pma__bookmark` (
4260  `id` int(11) NOT NULL,
4261  `dbase` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
4262  `user` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
4263  `label` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
4264  `query` text COLLATE utf8_bin NOT NULL
4265) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Bookmarks';
4266
4267-- --------------------------------------------------------
4268
4269--
4270-- Struttura della tabella `pma__central_columns`
4271--
4272
4273CREATE TABLE `pma__central_columns` (
4274  `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
4275  `col_name` varchar(64) COLLATE utf8_bin NOT NULL,
4276  `col_type` varchar(64) COLLATE utf8_bin NOT NULL,
4277  `col_length` text COLLATE utf8_bin,
4278  `col_collation` varchar(64) COLLATE utf8_bin NOT NULL,
4279  `col_isNull` tinyint(1) NOT NULL,
4280  `col_extra` varchar(255) COLLATE utf8_bin DEFAULT '',
4281  `col_default` text COLLATE utf8_bin
4282) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Central list of columns';
4283
4284-- --------------------------------------------------------
4285
4286--
4287-- Struttura della tabella `pma__column_info`
4288--
4289
4290CREATE TABLE `pma__column_info` (
4291  `id` int(5) UNSIGNED NOT NULL,
4292  `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4293  `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4294  `column_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4295  `comment` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
4296  `mimetype` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
4297  `transformation` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
4298  `transformation_options` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
4299  `input_transformation` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
4300  `input_transformation_options` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
4301) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column information for phpMyAdmin';
4302
4303-- --------------------------------------------------------
4304
4305--
4306-- Struttura della tabella `pma__designer_settings`
4307--
4308
4309CREATE TABLE `pma__designer_settings` (
4310  `username` varchar(64) COLLATE utf8_bin NOT NULL,
4311  `settings_data` text COLLATE utf8_bin NOT NULL
4312) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Settings related to Designer';
4313
4314-- --------------------------------------------------------
4315
4316--
4317-- Struttura della tabella `pma__export_templates`
4318--
4319
4320CREATE TABLE `pma__export_templates` (
4321  `id` int(5) UNSIGNED NOT NULL,
4322  `username` varchar(64) COLLATE utf8_bin NOT NULL,
4323  `export_type` varchar(10) COLLATE utf8_bin NOT NULL,
4324  `template_name` varchar(64) COLLATE utf8_bin NOT NULL,
4325  `template_data` text COLLATE utf8_bin NOT NULL
4326) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Saved export templates';
4327
4328--
4329-- Dump dei dati per la tabella `pma__export_templates`
4330--
4331
4332INSERT INTO `pma__export_templates` (`id`, `username`, `export_type`, `template_name`, `template_data`) VALUES
4333(1, 'access', 'server', 'HydroMC MySQL 4 4 2020', '{\"quick_or_custom\":\"quick\",\"what\":\"sql\",\"db_select[]\":[\"Brain\",\"cpsupport\",\"HydroHost\",\"HydroMC\",\"MarcoLvr\",\"phpmyadmin\",\"skywars\",\"Stats\"],\"aliases_new\":\"\",\"output_format\":\"sendit\",\"filename_template\":\"@SERVER@\",\"remember_template\":\"on\",\"charset\":\"utf-8\",\"compression\":\"none\",\"maxsize\":\"\",\"codegen_structure_or_data\":\"data\",\"codegen_format\":\"0\",\"csv_separator\":\",\",\"csv_enclosed\":\"\\\"\",\"csv_escaped\":\"\\\"\",\"csv_terminated\":\"AUTO\",\"csv_null\":\"NULL\",\"csv_structure_or_data\":\"data\",\"excel_null\":\"NULL\",\"excel_columns\":\"something\",\"excel_edition\":\"win\",\"excel_structure_or_data\":\"data\",\"json_structure_or_data\":\"data\",\"json_unicode\":\"something\",\"latex_caption\":\"something\",\"latex_structure_or_data\":\"structure_and_data\",\"latex_structure_caption\":\"Struttura della tabella @TABLE@\",\"latex_structure_continued_caption\":\"Struttura della tabella @TABLE@ (continua)\",\"latex_structure_label\":\"tab:@TABLE@-structure\",\"latex_relation\":\"something\",\"latex_comments\":\"something\",\"latex_mime\":\"something\",\"latex_columns\":\"something\",\"latex_data_caption\":\"Contenuto della tabella @TABLE@\",\"latex_data_continued_caption\":\"Contenuto della tabella @TABLE@ (continua)\",\"latex_data_label\":\"tab:@TABLE@-data\",\"latex_null\":\"\\\\textit{NULL}\",\"mediawiki_structure_or_data\":\"data\",\"mediawiki_caption\":\"something\",\"mediawiki_headers\":\"something\",\"htmlword_structure_or_data\":\"structure_and_data\",\"htmlword_null\":\"NULL\",\"ods_null\":\"NULL\",\"ods_structure_or_data\":\"data\",\"odt_structure_or_data\":\"structure_and_data\",\"odt_relation\":\"something\",\"odt_comments\":\"something\",\"odt_mime\":\"something\",\"odt_columns\":\"something\",\"odt_null\":\"NULL\",\"pdf_report_title\":\"\",\"pdf_structure_or_data\":\"data\",\"phparray_structure_or_data\":\"data\",\"sql_include_comments\":\"something\",\"sql_header_comment\":\"\",\"sql_use_transaction\":\"something\",\"sql_compatibility\":\"NONE\",\"sql_structure_or_data\":\"structure_and_data\",\"sql_create_table\":\"something\",\"sql_auto_increment\":\"something\",\"sql_create_view\":\"something\",\"sql_create_trigger\":\"something\",\"sql_backquotes\":\"something\",\"sql_type\":\"INSERT\",\"sql_insert_syntax\":\"both\",\"sql_max_query_size\":\"50000\",\"sql_hex_for_binary\":\"something\",\"sql_utc_time\":\"something\",\"texytext_structure_or_data\":\"structure_and_data\",\"texytext_null\":\"NULL\",\"yaml_structure_or_data\":\"data\",\"\":null,\"as_separate_files\":null,\"csv_removeCRLF\":null,\"csv_columns\":null,\"excel_removeCRLF\":null,\"json_pretty_print\":null,\"htmlword_columns\":null,\"ods_columns\":null,\"sql_dates\":null,\"sql_relation\":null,\"sql_mime\":null,\"sql_disable_fk\":null,\"sql_views_as_tables\":null,\"sql_metadata\":null,\"sql_drop_database\":null,\"sql_drop_table\":null,\"sql_if_not_exists\":null,\"sql_procedure_function\":null,\"sql_truncate\":null,\"sql_delayed\":null,\"sql_ignore\":null,\"texytext_columns\":null}');
4334
4335-- --------------------------------------------------------
4336
4337--
4338-- Struttura della tabella `pma__favorite`
4339--
4340
4341CREATE TABLE `pma__favorite` (
4342  `username` varchar(64) COLLATE utf8_bin NOT NULL,
4343  `tables` text COLLATE utf8_bin NOT NULL
4344) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Favorite tables';
4345
4346-- --------------------------------------------------------
4347
4348--
4349-- Struttura della tabella `pma__history`
4350--
4351
4352CREATE TABLE `pma__history` (
4353  `id` bigint(20) UNSIGNED NOT NULL,
4354  `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4355  `db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4356  `table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4357  `timevalue` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
4358  `sqlquery` text COLLATE utf8_bin NOT NULL
4359) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='SQL history for phpMyAdmin';
4360
4361-- --------------------------------------------------------
4362
4363--
4364-- Struttura della tabella `pma__navigationhiding`
4365--
4366
4367CREATE TABLE `pma__navigationhiding` (
4368  `username` varchar(64) COLLATE utf8_bin NOT NULL,
4369  `item_name` varchar(64) COLLATE utf8_bin NOT NULL,
4370  `item_type` varchar(64) COLLATE utf8_bin NOT NULL,
4371  `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
4372  `table_name` varchar(64) COLLATE utf8_bin NOT NULL
4373) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Hidden items of navigation tree';
4374
4375-- --------------------------------------------------------
4376
4377--
4378-- Struttura della tabella `pma__pdf_pages`
4379--
4380
4381CREATE TABLE `pma__pdf_pages` (
4382  `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4383  `page_nr` int(10) UNSIGNED NOT NULL,
4384  `page_descr` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT ''
4385) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='PDF relation pages for phpMyAdmin';
4386
4387-- --------------------------------------------------------
4388
4389--
4390-- Struttura della tabella `pma__recent`
4391--
4392
4393CREATE TABLE `pma__recent` (
4394  `username` varchar(64) COLLATE utf8_bin NOT NULL,
4395  `tables` text COLLATE utf8_bin NOT NULL
4396) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Recently accessed tables';
4397
4398--
4399-- Dump dei dati per la tabella `pma__recent`
4400--
4401
4402INSERT INTO `pma__recent` (`username`, `tables`) VALUES
4403('access', '[{\"db\":\"HydroMC\",\"table\":\"user-data\"},{\"db\":\"MarcoLvr\",\"table\":\"subvanilla\"},{\"db\":\"HydroHost\",\"table\":\"users\"},{\"db\":\"HydroHost\",\"table\":\"_gulagpro\"},{\"db\":\"HydroHost\",\"table\":\"services\"},{\"db\":\"Brain\",\"table\":\"oneblock\"},{\"db\":\"Brain\",\"table\":\"servers\"},{\"db\":\"HydroHost\",\"table\":\"new-invoices\"},{\"db\":\"HydroMC\",\"table\":\"user-minecraft\"},{\"db\":\"HydroMC\",\"table\":\"products\"}]');
4404
4405-- --------------------------------------------------------
4406
4407--
4408-- Struttura della tabella `pma__relation`
4409--
4410
4411CREATE TABLE `pma__relation` (
4412  `master_db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4413  `master_table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4414  `master_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4415  `foreign_db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4416  `foreign_table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4417  `foreign_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT ''
4418) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Relation table';
4419
4420-- --------------------------------------------------------
4421
4422--
4423-- Struttura della tabella `pma__savedsearches`
4424--
4425
4426CREATE TABLE `pma__savedsearches` (
4427  `id` int(5) UNSIGNED NOT NULL,
4428  `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4429  `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4430  `search_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4431  `search_data` text COLLATE utf8_bin NOT NULL
4432) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Saved searches';
4433
4434-- --------------------------------------------------------
4435
4436--
4437-- Struttura della tabella `pma__table_coords`
4438--
4439
4440CREATE TABLE `pma__table_coords` (
4441  `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4442  `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4443  `pdf_page_number` int(11) NOT NULL DEFAULT '0',
4444  `x` float UNSIGNED NOT NULL DEFAULT '0',
4445  `y` float UNSIGNED NOT NULL DEFAULT '0'
4446) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table coordinates for phpMyAdmin PDF output';
4447
4448-- --------------------------------------------------------
4449
4450--
4451-- Struttura della tabella `pma__table_info`
4452--
4453
4454CREATE TABLE `pma__table_info` (
4455  `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4456  `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4457  `display_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT ''
4458) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table information for phpMyAdmin';
4459
4460-- --------------------------------------------------------
4461
4462--
4463-- Struttura della tabella `pma__table_uiprefs`
4464--
4465
4466CREATE TABLE `pma__table_uiprefs` (
4467  `username` varchar(64) COLLATE utf8_bin NOT NULL,
4468  `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
4469  `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
4470  `prefs` text COLLATE utf8_bin NOT NULL,
4471  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
4472) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Tables'' UI preferences';
4473
4474--
4475-- Dump dei dati per la tabella `pma__table_uiprefs`
4476--
4477
4478INSERT INTO `pma__table_uiprefs` (`username`, `db_name`, `table_name`, `prefs`, `last_update`) VALUES
4479('access', 'Brain', 'oneblock', '{\"sorted_col\":\"`oneblock`.`tier`  ASC\"}', '2020-02-27 11:27:27'),
4480('access', 'HydroMC', 'user-data', '{\"sorted_col\":\"`user-data`.`action`  ASC\"}', '2020-03-24 18:44:29');
4481
4482-- --------------------------------------------------------
4483
4484--
4485-- Struttura della tabella `pma__tracking`
4486--
4487
4488CREATE TABLE `pma__tracking` (
4489  `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
4490  `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
4491  `version` int(10) UNSIGNED NOT NULL,
4492  `date_created` datetime NOT NULL,
4493  `date_updated` datetime NOT NULL,
4494  `schema_snapshot` text COLLATE utf8_bin NOT NULL,
4495  `schema_sql` text COLLATE utf8_bin,
4496  `data_sql` longtext COLLATE utf8_bin,
4497  `tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') COLLATE utf8_bin DEFAULT NULL,
4498  `tracking_active` int(1) UNSIGNED NOT NULL DEFAULT '1'
4499) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database changes tracking for phpMyAdmin';
4500
4501-- --------------------------------------------------------
4502
4503--
4504-- Struttura della tabella `pma__userconfig`
4505--
4506
4507CREATE TABLE `pma__userconfig` (
4508  `username` varchar(64) COLLATE utf8_bin NOT NULL,
4509  `timevalue` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4510  `config_data` text COLLATE utf8_bin NOT NULL
4511) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User preferences storage for phpMyAdmin';
4512
4513--
4514-- Dump dei dati per la tabella `pma__userconfig`
4515--
4516
4517INSERT INTO `pma__userconfig` (`username`, `timevalue`, `config_data`) VALUES
4518('access', '2020-04-06 14:17:08', '{\"Console\\/Mode\":\"show\",\"ThemeDefault\":\"pmahomme\",\"lang\":\"it\"}');
4519
4520-- --------------------------------------------------------
4521
4522--
4523-- Struttura della tabella `pma__usergroups`
4524--
4525
4526CREATE TABLE `pma__usergroups` (
4527  `usergroup` varchar(64) COLLATE utf8_bin NOT NULL,
4528  `tab` varchar(64) COLLATE utf8_bin NOT NULL,
4529  `allowed` enum('Y','N') COLLATE utf8_bin NOT NULL DEFAULT 'N'
4530) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User groups with configured menu items';
4531
4532-- --------------------------------------------------------
4533
4534--
4535-- Struttura della tabella `pma__users`
4536--
4537
4538CREATE TABLE `pma__users` (
4539  `username` varchar(64) COLLATE utf8_bin NOT NULL,
4540  `usergroup` varchar(64) COLLATE utf8_bin NOT NULL
4541) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and their assignments to user groups';
4542
4543--
4544-- Indici per le tabelle scaricate
4545--
4546
4547--
4548-- Indici per le tabelle `pma__bookmark`
4549--
4550ALTER TABLE `pma__bookmark`
4551  ADD PRIMARY KEY (`id`);
4552
4553--
4554-- Indici per le tabelle `pma__central_columns`
4555--
4556ALTER TABLE `pma__central_columns`
4557  ADD PRIMARY KEY (`db_name`,`col_name`);
4558
4559--
4560-- Indici per le tabelle `pma__column_info`
4561--
4562ALTER TABLE `pma__column_info`
4563  ADD PRIMARY KEY (`id`),
4564  ADD UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`);
4565
4566--
4567-- Indici per le tabelle `pma__designer_settings`
4568--
4569ALTER TABLE `pma__designer_settings`
4570  ADD PRIMARY KEY (`username`);
4571
4572--
4573-- Indici per le tabelle `pma__export_templates`
4574--
4575ALTER TABLE `pma__export_templates`
4576  ADD PRIMARY KEY (`id`),
4577  ADD UNIQUE KEY `u_user_type_template` (`username`,`export_type`,`template_name`);
4578
4579--
4580-- Indici per le tabelle `pma__favorite`
4581--
4582ALTER TABLE `pma__favorite`
4583  ADD PRIMARY KEY (`username`);
4584
4585--
4586-- Indici per le tabelle `pma__history`
4587--
4588ALTER TABLE `pma__history`
4589  ADD PRIMARY KEY (`id`),
4590  ADD KEY `username` (`username`,`db`,`table`,`timevalue`);
4591
4592--
4593-- Indici per le tabelle `pma__navigationhiding`
4594--
4595ALTER TABLE `pma__navigationhiding`
4596  ADD PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`);
4597
4598--
4599-- Indici per le tabelle `pma__pdf_pages`
4600--
4601ALTER TABLE `pma__pdf_pages`
4602  ADD PRIMARY KEY (`page_nr`),
4603  ADD KEY `db_name` (`db_name`);
4604
4605--
4606-- Indici per le tabelle `pma__recent`
4607--
4608ALTER TABLE `pma__recent`
4609  ADD PRIMARY KEY (`username`);
4610
4611--
4612-- Indici per le tabelle `pma__relation`
4613--
4614ALTER TABLE `pma__relation`
4615  ADD PRIMARY KEY (`master_db`,`master_table`,`master_field`),
4616  ADD KEY `foreign_field` (`foreign_db`,`foreign_table`);
4617
4618--
4619-- Indici per le tabelle `pma__savedsearches`
4620--
4621ALTER TABLE `pma__savedsearches`
4622  ADD PRIMARY KEY (`id`),
4623  ADD UNIQUE KEY `u_savedsearches_username_dbname` (`username`,`db_name`,`search_name`);
4624
4625--
4626-- Indici per le tabelle `pma__table_coords`
4627--
4628ALTER TABLE `pma__table_coords`
4629  ADD PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`);
4630
4631--
4632-- Indici per le tabelle `pma__table_info`
4633--
4634ALTER TABLE `pma__table_info`
4635  ADD PRIMARY KEY (`db_name`,`table_name`);
4636
4637--
4638-- Indici per le tabelle `pma__table_uiprefs`
4639--
4640ALTER TABLE `pma__table_uiprefs`
4641  ADD PRIMARY KEY (`username`,`db_name`,`table_name`);
4642
4643--
4644-- Indici per le tabelle `pma__tracking`
4645--
4646ALTER TABLE `pma__tracking`
4647  ADD PRIMARY KEY (`db_name`,`table_name`,`version`);
4648
4649--
4650-- Indici per le tabelle `pma__userconfig`
4651--
4652ALTER TABLE `pma__userconfig`
4653  ADD PRIMARY KEY (`username`);
4654
4655--
4656-- Indici per le tabelle `pma__usergroups`
4657--
4658ALTER TABLE `pma__usergroups`
4659  ADD PRIMARY KEY (`usergroup`,`tab`,`allowed`);
4660
4661--
4662-- Indici per le tabelle `pma__users`
4663--
4664ALTER TABLE `pma__users`
4665  ADD PRIMARY KEY (`username`,`usergroup`);
4666
4667--
4668-- AUTO_INCREMENT per le tabelle scaricate
4669--
4670
4671--
4672-- AUTO_INCREMENT per la tabella `pma__bookmark`
4673--
4674ALTER TABLE `pma__bookmark`
4675  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
4676
4677--
4678-- AUTO_INCREMENT per la tabella `pma__column_info`
4679--
4680ALTER TABLE `pma__column_info`
4681  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;
4682
4683--
4684-- AUTO_INCREMENT per la tabella `pma__export_templates`
4685--
4686ALTER TABLE `pma__export_templates`
4687  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
4688
4689--
4690-- AUTO_INCREMENT per la tabella `pma__history`
4691--
4692ALTER TABLE `pma__history`
4693  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
4694
4695--
4696-- AUTO_INCREMENT per la tabella `pma__pdf_pages`
4697--
4698ALTER TABLE `pma__pdf_pages`
4699  MODIFY `page_nr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
4700
4701--
4702-- AUTO_INCREMENT per la tabella `pma__savedsearches`
4703--
4704ALTER TABLE `pma__savedsearches`
4705  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;
4706--
4707-- Database: `skywars`
4708--
4709CREATE DATABASE IF NOT EXISTS `skywars` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
4710USE `skywars`;
4711
4712-- --------------------------------------------------------
4713
4714--
4715-- Struttura della tabella `user-kits`
4716--
4717
4718CREATE TABLE `user-kits` (
4719  `email` varchar(255) NOT NULL,
4720  `beginner` int(1) NOT NULL DEFAULT '0',
4721  `spiderman` int(1) NOT NULL DEFAULT '0',
4722  `slimy` int(1) NOT NULL DEFAULT '0',
4723  `destroyer` int(1) NOT NULL DEFAULT '0',
4724  `catastrophic` int(1) NOT NULL DEFAULT '0',
4725  `swimmer` int(1) NOT NULL DEFAULT '0',
4726  `friedchicken` int(1) NOT NULL DEFAULT '0'
4727) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4728
4729--
4730-- Dump dei dati per la tabella `user-kits`
4731--
4732
4733INSERT INTO `user-kits` (`email`, `beginner`, `spiderman`, `slimy`, `destroyer`, `catastrophic`, `swimmer`, `friedchicken`) VALUES
4734('babil3us.yt.contact@gmail.com', 0, 0, 0, 0, 0, 0, 1),
4735('emagreco06@gmail.com', 0, 0, 0, 1, 1, 1, 1),
4736('lucadarin12@gmail.com', 0, 0, 0, 0, 0, 0, 0),
4737('marco.lvr@outlook.it', 1, 1, 1, 1, 1, 1, 1),
4738('minecraftone33@gmail.com', 1, 1, 1, 1, 1, 1, 1),
4739('nakamoto@maxcode.it', 1, 1, 1, 1, 1, 1, 1);
4740
4741--
4742-- Indici per le tabelle scaricate
4743--
4744
4745--
4746-- Indici per le tabelle `user-kits`
4747--
4748ALTER TABLE `user-kits`
4749  ADD UNIQUE KEY `email` (`email`);
4750--
4751-- Database: `Stats`
4752--
4753CREATE DATABASE IF NOT EXISTS `Stats` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
4754USE `Stats`;
4755COMMIT;
4756
4757/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
4758/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
4759/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;