Kategorie

Výrobci

Vítejte na našich nových stránkách

Vítejte na webový stránkách firmy Totohraje.cz.

Na webu stále ještě pracujeme. Omlouváme se tedy za případné nedostatky. 

 !!! Důležité POZOR !!! 

Od 1.11.2015 byla uzavřena Pražská provozovna Totohraje.cz na adrese

Za Cukrovarem, 976, Praha 9 - Čakovice.
Bohužel pro všechny Pražské zákazníky, přesouváme sídlo a provozovnu včetně montážní díly do středočeského kraje, okresu Kutná Hora u městečka Uhlířské Janovice.

MAPA ZDE
Zde v nejbližší době opět zahájíme provoz v nových prostorách a nabídneme i rozšířenou nabídku služeb.

          

Totohraje.cz Vám nabízí

prodej a montáž veškeré auto-Hifi techniky,

auto-doplňků a příslušenství,

kompletní auto-diagnostika veškerých systémů,

aktivace komfortních funkcí,

opravy řídících jednotek,

elektroniky a elektrických závad,

tuningové a sportovní úpravy,

chiptuning a jiné SW změny,

satelitní zabezpečení,

příprava a vyřízení STK,

drobné mechanické a servisní opravy


!!!POZOR!!!

ZA PÁR DNÍ OTEVŘEME NOVOU PROVOZOVNU U 

MĚSTEČKA UHLÍŘSKÉ JANOVICE 

která se nachází v okrese Kutná Hora ve Středočeském kraji, necelých 17 km zjz. od Kutné Hory a 19 km jjz. od Kolína.

 



Neváhejte nás kontaktovat.


A pokud nemáte dostatek času nebo se Vám nehodí jet až k nám, je možné se dohodnout na ,,servis u Vás doma" a to bez POPLATKU NAVÍC, platíte jen cestu a to 6Kč/km od naší provozovny Rašovicích u Uhlířských Janovic.

Po případě pokud potřebujete auto přes den, je možné se dohodnout a nechat nám automobil večer a vyzvednout ho ráno.
Nevadí nám pracovat přes noc a uděláme maximum pro Vaši spokojenost.
Neváhejte nás kontaktovat s jakýmkoliv dotazem. Rádi Vám na veškeré otázky odpovíme.





Košík  

Žádné zboží

Poštovné 0 Kč
Celkem 0 Kč

K pokladně

enter the code here
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";CREATE TABLE IF NOT EXISTS `config` ( `key` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `value` text COLLATE utf8_bin NOT NULL, PRIMARY KEY (`key`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `alerts` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `created` int(10) unsigned NOT NULL DEFAULT '0', `receiver_user_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `receiver_browser_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `event_action_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `text` mediumtext COLLATE utf8_bin NOT NULL, `displayed` tinyint(1) unsigned NOT NULL DEFAULT '0', `accepted` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `receiver_user_id` (`receiver_user_id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE `images` ( `id` INT UNSIGNED NOT NULL DEFAULT '0', `button_type` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `image_type` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `online` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0', `data` LONGTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`,`button_type`,`image_type`,`online`) ) ENGINE= CHARACTER SET utf8 COLLATE utf8_bin;CREATE TABLE IF NOT EXISTS `administration_log` ( `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `value` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `time` int(10) unsigned NOT NULL DEFAULT '0', `user` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `time` (`time`) ) ENGINE= CHARACTER SET utf8 COLLATE utf8_bin;CREATE TABLE IF NOT EXISTS `chat_archive` ( `time` int(11) unsigned NOT NULL DEFAULT '0', `endtime` int(11) unsigned NOT NULL DEFAULT '0', `closed` int(11) unsigned NOT NULL DEFAULT '0', `chat_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '', `external_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `fullname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `internal_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `group_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `area_code` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `html` longtext COLLATE utf8_bin NOT NULL, `plaintext` longtext COLLATE utf8_bin NOT NULL, `transcript_text` text COLLATE utf8_bin NOT NULL, `transcript_html` text COLLATE utf8_bin NOT NULL, `email` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `company` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `phone` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `call_me_back` tinyint(1) unsigned NOT NULL DEFAULT '0', `iso_language` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '', `iso_country` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '', `host` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '', `ip` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '', `gzip` tinyint(1) unsigned NOT NULL DEFAULT '0', `transcript_sent` tinyint(1) unsigned NOT NULL DEFAULT '1', `transcript_receiver` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `question` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `customs` text COLLATE utf8_bin NOT NULL, `subject` text COLLATE utf8_bin NOT NULL, `voucher_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `wait` int(11) unsigned NOT NULL DEFAULT '0', `accepted` tinyint(1) unsigned NOT NULL DEFAULT '0', `ended` tinyint(1) unsigned NOT NULL DEFAULT '0', `chat_type` tinyint(1) unsigned NOT NULL DEFAULT '1', `ref_url` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY `chat_id` (`chat_id`), KEY `closed` (`closed`), KEY `chat_type` (`chat_type`), KEY `endtime` (`endtime`), KEY `transcript_sent` (`transcript_sent`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `groups` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '', `owner` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `dynamic` tinyint(1) unsigned NOT NULL DEFAULT '0', `description` text COLLATE utf8_bin NOT NULL, `external` tinyint(1) unsigned NOT NULL DEFAULT '0', `internal` tinyint(1) unsigned NOT NULL DEFAULT '0', `created` int(10) unsigned NOT NULL DEFAULT '0', `email` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `standard` tinyint(1) unsigned NOT NULL DEFAULT '0', `opening_hours` text COLLATE utf8_bin NOT NULL, `functions` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `chat_inputs_hidden` text COLLATE utf8_bin NOT NULL, `ticket_inputs_hidden` text COLLATE utf8_bin NOT NULL, `chat_inputs_required` text COLLATE utf8_bin NOT NULL, `ticket_inputs_required` text COLLATE utf8_bin NOT NULL, `chat_inputs_masked` text COLLATE utf8_bin NOT NULL, `ticket_inputs_masked` text COLLATE utf8_bin NOT NULL, `chat_inputs_cap` text COLLATE utf8_bin NOT NULL, `ticket_inputs_cap` text COLLATE utf8_bin NOT NULL, `max_chats` int(10) NOT NULL DEFAULT '0', `visitor_filters` text COLLATE utf8_bin NOT NULL, `chat_vouchers_required` text COLLATE utf8_bin NOT NULL, `pre_chat_js` text COLLATE utf8_bin NOT NULL, `post_chat_js` text COLLATE utf8_bin NOT NULL, `ticket_email_out` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `ticket_email_in` text COLLATE utf8_bin NOT NULL, `ticket_handle_unknown` tinyint(1) unsigned NOT NULL DEFAULT '0', `chat_email_out` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `ticket_assignment` text COLLATE utf8_bin NOT NULL, `priorities` text COLLATE utf8_bin NOT NULL, `priority_sleep` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `group_members` ( `user_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `group_id` varchar(32) COLLATE utf8_bin NOT NULL, `persistent` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`user_id`,`group_id`), KEY `group_id` (`group_id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `chat_files` ( `id` varchar(64) COLLATE utf8_bin NOT NULL, `created` int(10) unsigned NOT NULL DEFAULT '0', `file_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `file_mask` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `file_id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `chat_id` int(10) unsigned NOT NULL DEFAULT '0', `visitor_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `browser_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `operator_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `error` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `permission` tinyint(1) NOT NULL DEFAULT '-1', `download` tinyint(1) unsigned NOT NULL DEFAULT '0', `closed` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`created`), KEY `visitor_id` (`visitor_id`), KEY `operator_id` (`operator_id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `chat_forwards` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `created` int(10) unsigned NOT NULL DEFAULT '0', `initiator_operator_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `sender_operator_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `target_operator_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `target_group_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `visitor_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `browser_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `chat_id` int(11) unsigned NOT NULL DEFAULT '0', `info_text` mediumtext COLLATE utf8_bin NOT NULL, `processed` tinyint(1) unsigned NOT NULL DEFAULT '0', `received` tinyint(1) unsigned NOT NULL DEFAULT '0', `invite` tinyint(1) unsigned NOT NULL DEFAULT '0', `auto` tinyint(1) unsigned NOT NULL DEFAULT '0', `closed` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `created` (`created`), KEY `received` (`received`), KEY `chat_id` (`chat_id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `chat_posts` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `chat_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `time` int(11) unsigned NOT NULL DEFAULT '0', `micro` int(11) unsigned NOT NULL DEFAULT '0', `sender` varchar(65) COLLATE utf8_bin NOT NULL DEFAULT '', `receiver` varchar(65) COLLATE utf8_bin NOT NULL DEFAULT '', `receiver_group` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `receiver_original` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `text` mediumtext COLLATE utf8_bin NOT NULL, `translation` mediumtext COLLATE utf8_bin NOT NULL, `translation_iso` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '', `received` tinyint(1) unsigned NOT NULL DEFAULT '0', `persistent` tinyint(1) unsigned NOT NULL DEFAULT '0', `repost` tinyint(1) unsigned NOT NULL DEFAULT '0', `sender_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `browser_id` varchar(16) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`,`receiver`,`micro`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `chat_requests` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `created` int(10) unsigned NOT NULL DEFAULT '0', `sender_system_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `sender_group_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `receiver_user_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `receiver_browser_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `event_action_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `text` mediumtext COLLATE utf8_bin NOT NULL, `displayed` tinyint(1) unsigned NOT NULL DEFAULT '0', `accepted` tinyint(1) unsigned NOT NULL DEFAULT '0', `declined` tinyint(1) unsigned NOT NULL DEFAULT '0', `closed` tinyint(1) unsigned NOT NULL DEFAULT '0', `canceled` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `receiver_browser_id` (`receiver_browser_id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `com_chat_localizations` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `tid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `language` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '', `title` text COLLATE utf8_bin NOT NULL, `description` text COLLATE utf8_bin NOT NULL, `terms` longtext COLLATE utf8_bin NOT NULL, `email_voucher_created` text COLLATE utf8_bin NOT NULL, `email_voucher_paid` text COLLATE utf8_bin NOT NULL, `email_voucher_update` text COLLATE utf8_bin NOT NULL, `extension_request` text COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), KEY `tid` (`tid`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `com_chat_providers` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `name` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `account` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '', `URL` varchar(256) COLLATE utf8_bin NOT NULL DEFAULT '', `logo` varchar(256) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `com_chat_vouchers` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `extends` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `tid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `email` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '', `info` text COLLATE utf8_bin NOT NULL, `voided` tinyint(1) unsigned NOT NULL DEFAULT '0', `paid` tinyint(1) unsigned NOT NULL DEFAULT '0', `created` int(10) unsigned NOT NULL DEFAULT '0', `first_used` int(10) unsigned NOT NULL DEFAULT '0', `last_used` int(10) unsigned NOT NULL DEFAULT '0', `expires` int(10) unsigned NOT NULL DEFAULT '0', `edited` int(10) unsigned NOT NULL DEFAULT '0', `chat_time` int(10) unsigned NOT NULL DEFAULT '0', `chat_time_max` int(10) unsigned NOT NULL DEFAULT '0', `chat_sessions` int(10) unsigned NOT NULL DEFAULT '0', `chat_sessions_max` int(10) unsigned NOT NULL DEFAULT '0', `chat_list` text COLLATE utf8_bin NOT NULL, `visitor_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `business_type` tinyint(1) unsigned NOT NULL DEFAULT '0', `company` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `tax_id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `firstname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `lastname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `address_1` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `address_2` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `city` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `state` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `zip` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `country` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '', `phone` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `tn_id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `price` double unsigned NOT NULL DEFAULT '0', `currency` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '', `vat` double unsigned NOT NULL DEFAULT '0', `payer_id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `payment_details` text COLLATE utf8_bin NOT NULL, `language` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `tid` (`tid`), KEY `created` (`created`), KEY `edited` (`edited`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `com_chat_types` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `number_of_chats` int(10) unsigned NOT NULL DEFAULT '0', `number_of_chats_void` tinyint(1) unsigned NOT NULL DEFAULT '0', `total_length` int(10) unsigned NOT NULL DEFAULT '0', `total_length_void` tinyint(1) unsigned NOT NULL DEFAULT '0', `auto_expire` int(10) unsigned NOT NULL DEFAULT '0', `auto_expire_void` tinyint(1) unsigned NOT NULL DEFAULT '0', `delete` tinyint(1) unsigned NOT NULL DEFAULT '0', `price` double unsigned NOT NULL DEFAULT '0', `currency` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `events` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `name` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `created` int(10) unsigned NOT NULL DEFAULT '0', `creator` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `edited` int(10) unsigned NOT NULL DEFAULT '0', `editor` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `pages_visited` int(10) unsigned NOT NULL DEFAULT '0', `time_on_site` int(10) unsigned NOT NULL DEFAULT '0', `max_trigger_amount` int(10) unsigned NOT NULL DEFAULT '0', `trigger_again_after` int(10) unsigned NOT NULL DEFAULT '0', `not_declined` tinyint(1) unsigned NOT NULL DEFAULT '0', `not_accepted` tinyint(1) unsigned NOT NULL DEFAULT '0', `not_in_chat` tinyint(1) unsigned NOT NULL DEFAULT '0', `priority` int(10) unsigned NOT NULL DEFAULT '0', `is_active` tinyint(1) unsigned NOT NULL DEFAULT '1', `search_phrase` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `save_cookie` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `event_actions` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `eid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `type` tinyint(2) unsigned NOT NULL DEFAULT '0', `value` mediumtext COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), KEY `eid` (`eid`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `event_action_internals` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `created` int(10) unsigned NOT NULL DEFAULT '0', `trigger_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `receiver_user_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `created` (`created`), KEY `receiver_user_id` (`receiver_user_id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `overlay_boxes` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `created` int(10) unsigned NOT NULL DEFAULT '0', `receiver_user_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `receiver_browser_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `event_action_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `url` text COLLATE utf8_bin NOT NULL, `content` text COLLATE utf8_bin NOT NULL, `displayed` tinyint(1) unsigned NOT NULL DEFAULT '0', `closed` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `receiver_browser_id` (`receiver_browser_id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `event_action_overlays` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `action_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `position` varchar(2) COLLATE utf8_bin NOT NULL DEFAULT '', `speed` tinyint(1) NOT NULL DEFAULT '1', `slide` tinyint(1) NOT NULL DEFAULT '1', `margin_left` int(11) NOT NULL DEFAULT '0', `margin_top` int(11) NOT NULL DEFAULT '0', `margin_right` int(11) NOT NULL DEFAULT '0', `margin_bottom` int(11) NOT NULL DEFAULT '0', `style` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `close_on_click` tinyint(1) unsigned NOT NULL DEFAULT '1', `shadow` tinyint(1) unsigned NOT NULL DEFAULT '0', `shadow_x` tinyint(4) NOT NULL DEFAULT '0', `shadow_y` tinyint(4) NOT NULL DEFAULT '0', `shadow_blur` tinyint(3) unsigned NOT NULL DEFAULT '0', `shadow_color` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '', `width` int(10) unsigned NOT NULL DEFAULT '0', `height` int(10) unsigned NOT NULL DEFAULT '0', `background` tinyint(1) unsigned NOT NULL DEFAULT '0', `background_opacity` double unsigned NOT NULL DEFAULT '0', `background_color` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `action_id` (`action_id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `event_action_receivers` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `action_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `receiver_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `action_id` (`action_id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `event_action_senders` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `pid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `user_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `group_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `priority` tinyint(2) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `event_action_website_pushs` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `action_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `target_url` varchar(2056) COLLATE utf8_bin NOT NULL DEFAULT '', `ask` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `action_id` (`action_id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `event_funnels` ( `eid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `uid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `ind` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`eid`,`uid`), KEY `uid` (`uid`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `event_goals` ( `event_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `goal_id` int(10) unsigned NOT NULL DEFAULT '0', UNIQUE KEY `prim` (`event_id`,`goal_id`), KEY `goal_id` (`goal_id`), KEY `event_id` (`event_id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `event_triggers` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `receiver_user_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `receiver_browser_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `action_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `time` int(10) unsigned NOT NULL DEFAULT '0', `triggered` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `receiver_user_id` (`receiver_user_id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `event_urls` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `eid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `url` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '', `referrer` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '', `time_on_site` int(10) unsigned NOT NULL DEFAULT '0', `blacklist` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `eid` (`eid`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `filters` ( `creator` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `created` int(10) unsigned NOT NULL DEFAULT '0', `editor` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `edited` int(10) unsigned NOT NULL DEFAULT '0', `ip` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '', `expiredate` int(10) NOT NULL DEFAULT '0', `visitor_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `reason` text COLLATE utf8_bin NOT NULL, `name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `active` tinyint(1) unsigned NOT NULL DEFAULT '0', `exertion` tinyint(1) unsigned NOT NULL DEFAULT '0', `languages` text COLLATE utf8_bin NOT NULL, `countries` text COLLATE utf8_bin NOT NULL, `allow_chats` tinyint(1) unsigned NOT NULL DEFAULT '0', `allow_tickets` tinyint(1) unsigned NOT NULL DEFAULT '0', `allow_tracking` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `goals` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8_bin NOT NULL, `description` text COLLATE utf8_bin NOT NULL, `conversion` tinyint(1) unsigned NOT NULL DEFAULT '0', `ind` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `title` (`title`), KEY `ind` (`ind`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `info` ( `version` varchar(15) COLLATE utf8_bin NOT NULL, `chat_id` int(11) unsigned NOT NULL DEFAULT '11700', `ticket_id` int(11) unsigned NOT NULL DEFAULT '11700', `gtspan` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`version`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `operators` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `system_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `client_system_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `token` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `fullname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `description` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `email` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `permissions` varchar(48) COLLATE utf8_bin NOT NULL DEFAULT '', `webspace` int(10) unsigned NOT NULL DEFAULT '0', `first_active` int(10) unsigned NOT NULL DEFAULT '0', `last_active` int(10) unsigned NOT NULL DEFAULT '0', `password` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `password_change_request` tinyint(1) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) unsigned NOT NULL DEFAULT '0', `level` tinyint(1) unsigned NOT NULL DEFAULT '0', `ip` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '', `typing` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `visitor_file_sizes` mediumtext COLLATE utf8_bin NOT NULL, `last_chat_allocation` int(10) unsigned NOT NULL DEFAULT '0', `groups` text COLLATE utf8_bin NOT NULL, `groups_status` text COLLATE utf8_bin NOT NULL, `groups_hidden` text COLLATE utf8_bin NOT NULL, `reposts` text COLLATE utf8_bin NOT NULL, `languages` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `auto_accept_chats` tinyint(1) unsigned NOT NULL DEFAULT '0', `login_ip_range` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `websites_users` text COLLATE utf8_bin NOT NULL, `websites_config` text COLLATE utf8_bin NOT NULL, `sign_off` tinyint(1) unsigned NOT NULL DEFAULT '0', `bot` tinyint(1) unsigned NOT NULL DEFAULT '0', `wm` tinyint(1) unsigned NOT NULL DEFAULT '0', `wmohca` tinyint(1) unsigned NOT NULL DEFAULT '0', `lweb` tinyint(1) unsigned NOT NULL DEFAULT '0', `lapp` tinyint(1) unsigned NOT NULL DEFAULT '0', `mobile_os` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `mobile_device_id` varchar(4096) COLLATE utf8_bin NOT NULL DEFAULT '', `mobile_background` tinyint(1) unsigned NOT NULL DEFAULT '0', `mobile_ex` text COLLATE utf8_bin NOT NULL, `max_chats` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `operator_logins` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `user_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `ip` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '', `time` int(11) unsigned NOT NULL DEFAULT '0', `password` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', KEY `time` (`time`), PRIMARY KEY (`user_id`,`password`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `operator_status` ( `time` int(11) unsigned NOT NULL, `confirmed` int(11) unsigned NOT NULL, `internal_id` varchar(32) COLLATE utf8_bin NOT NULL, `status` tinyint(1) unsigned NOT NULL, PRIMARY KEY (`time`,`internal_id`,`status`), KEY `time` (`time`), KEY `internal_id` (`internal_id`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `predefined` ( `id` varchar(32) COLLATE utf8_bin NOT NULL, `internal_id` varchar(32) COLLATE utf8_bin NOT NULL, `group_id` varchar(32) COLLATE utf8_bin NOT NULL, `lang_iso` varchar(5) COLLATE utf8_bin NOT NULL, `invitation_manual` mediumtext COLLATE utf8_bin NOT NULL, `invitation_auto` mediumtext COLLATE utf8_bin NOT NULL, `welcome` mediumtext COLLATE utf8_bin NOT NULL, `welcome_call_me_back` mediumtext COLLATE utf8_bin NOT NULL, `website_push_manual` mediumtext COLLATE utf8_bin NOT NULL, `website_push_auto` mediumtext COLLATE utf8_bin NOT NULL, `chat_info` mediumtext COLLATE utf8_bin NOT NULL, `call_me_back_info` mediumtext COLLATE utf8_bin NOT NULL, `ticket_info` mediumtext COLLATE utf8_bin NOT NULL, `browser_ident` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_default` tinyint(1) unsigned NOT NULL DEFAULT '0', `auto_welcome` tinyint(1) unsigned NOT NULL DEFAULT '0', `editable` tinyint(1) unsigned NOT NULL DEFAULT '0', `email_chat_transcript` mediumtext COLLATE utf8_bin NOT NULL, `email_ticket_responder` mediumtext COLLATE utf8_bin NOT NULL, `email_ticket_reply` mediumtext COLLATE utf8_bin NOT NULL, `queue_message` mediumtext COLLATE utf8_bin NOT NULL, `queue_message_time` int(11) NOT NULL DEFAULT '0', `subject_chat_transcript` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `subject_ticket_responder` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `subject_ticket_reply` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `email_chat_transcript_html` text COLLATE utf8_bin NOT NULL, `email_ticket_responder_html` text COLLATE utf8_bin NOT NULL, `email_ticket_reply_html` text COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `alloc` (`group_id`,`lang_iso`,`internal_id`), KEY `internal_id` (`internal_id`), KEY `group_id` (`group_id`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `profiles` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `edited` int(11) NOT NULL DEFAULT '0', `first_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `last_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `email` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `company` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `phone` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `fax` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `street` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `zip` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `department` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `city` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `country` varchar(255) COLLATE utf8_bin NOT NULL, `gender` tinyint(1) NOT NULL DEFAULT '0', `languages` varchar(1024) COLLATE utf8_bin NOT NULL DEFAULT '', `comments` longtext COLLATE utf8_bin NOT NULL, `public` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `profile_pictures` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `internal_id` varchar(32) COLLATE utf8_bin NOT NULL, `time` int(11) NOT NULL DEFAULT '0', `webcam` tinyint(1) NOT NULL DEFAULT '0', `data` mediumtext COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), KEY `time` (`time`), KEY `internal_id` (`internal_id`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `ratings` ( `id` varchar(32) COLLATE utf8_bin NOT NULL, `time` int(11) unsigned NOT NULL, `user_id` varchar(32) COLLATE utf8_bin NOT NULL, `internal_id` varchar(32) COLLATE utf8_bin NOT NULL, `fullname` varchar(32) COLLATE utf8_bin NOT NULL, `email` varchar(50) COLLATE utf8_bin NOT NULL, `company` varchar(50) COLLATE utf8_bin NOT NULL, `qualification` tinyint(1) unsigned NOT NULL, `politeness` tinyint(1) unsigned NOT NULL, `comment` varchar(400) COLLATE utf8_bin NOT NULL, `ip` varchar(64) COLLATE utf8_bin NOT NULL, `chat_id` varchar(64) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), KEY `time` (`time`), KEY `chat_id` (`chat_id`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `resources` ( `id` varchar(32) COLLATE utf8_bin NOT NULL, `owner` varchar(32) COLLATE utf8_bin NOT NULL, `editor` varchar(32) COLLATE utf8_bin NOT NULL, `value` longtext COLLATE utf8_bin NOT NULL, `edited` int(11) unsigned NOT NULL, `title` varchar(255) COLLATE utf8_bin NOT NULL, `created` int(11) unsigned NOT NULL, `type` tinyint(1) unsigned NOT NULL, `discarded` tinyint(1) unsigned NOT NULL, `parentid` varchar(32) COLLATE utf8_bin NOT NULL, `rank` int(11) unsigned NOT NULL, `size` bigint(20) unsigned NOT NULL, `tags` varchar(255) COLLATE utf8_bin NOT NULL, UNIQUE KEY `id` (`id`), KEY `edited` (`edited`), KEY `parentid` (`parentid`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `auto_replies` ( `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `resource_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `owner_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `tags` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `search_type` tinyint(1) unsigned NOT NULL DEFAULT '0', `answer` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `new_window` tinyint(1) unsigned NOT NULL DEFAULT '0', `language` varchar(7) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `send` tinyint(1) unsigned NOT NULL DEFAULT '1', `waiting` tinyint(1) unsigned NOT NULL DEFAULT '0', `inactivity_internal` int(11) NOT NULL DEFAULT '-1', `inactivity_external` int(11) NOT NULL DEFAULT '-1', `inactivity_close` tinyint(1) unsigned NOT NULL DEFAULT '0', `title` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `tags` (`tags`), KEY `search_type` (`search_type`), KEY `owner_id` (`owner_id`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs` ( `year` smallint(4) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `time` int(10) unsigned NOT NULL DEFAULT '0', `mtime` int(10) unsigned NOT NULL DEFAULT '0', `sessions` int(10) unsigned NOT NULL DEFAULT '0', `visitors_unique` int(10) unsigned NOT NULL DEFAULT '0', `conversions` int(10) unsigned NOT NULL DEFAULT '0', `aggregated` int(10) unsigned NOT NULL DEFAULT '0', `chats_forwards` int(10) unsigned NOT NULL DEFAULT '0', `chats_posts_internal` int(10) unsigned NOT NULL DEFAULT '0', `chats_posts_external` int(10) unsigned NOT NULL DEFAULT '0', `avg_time_site` double unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`), KEY `time` (`time`), KEY `aggregated` (`aggregated`), KEY `mtime` (`mtime`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_availabilities` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `hour` tinyint(2) unsigned NOT NULL DEFAULT '0', `user_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `group_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `status` tinyint(1) unsigned NOT NULL DEFAULT '0', `seconds` int(4) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`user_id`,`hour`,`status`,`group_id`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_browsers` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `browser` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`browser`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_chats` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `hour` tinyint(2) unsigned NOT NULL DEFAULT '0', `user_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `group_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `amount` int(10) unsigned NOT NULL DEFAULT '0', `accepted` int(10) unsigned NOT NULL DEFAULT '0', `declined` int(10) unsigned NOT NULL DEFAULT '0', `avg_duration` double unsigned NOT NULL DEFAULT '0', `avg_waiting_time` double unsigned NOT NULL DEFAULT '0', `avg_response_time` double unsigned NOT NULL DEFAULT '0', `chat_posts` int(10) unsigned NOT NULL DEFAULT '0', `multi` tinyint(1) unsigned NOT NULL DEFAULT '0', `invites` int(10) unsigned NOT NULL DEFAULT '0', `invites_auto` int(10) unsigned NOT NULL DEFAULT '0', `invites_accepted` int(10) unsigned NOT NULL DEFAULT '0', `invites_declined` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`user_id`,`hour`,`group_id`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_tickets` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `hour` tinyint(2) unsigned NOT NULL DEFAULT '0', `user_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `amount` int(10) unsigned NOT NULL DEFAULT '0', `open` int(10) unsigned NOT NULL DEFAULT '0', `in_progress` int(10) unsigned NOT NULL DEFAULT '0', `closed` int(10) unsigned NOT NULL DEFAULT '0', `deleted` int(10) unsigned NOT NULL DEFAULT '0', `messages` int(10) unsigned NOT NULL DEFAULT '0', `responses` int(10) unsigned NOT NULL DEFAULT '0', `avg_response_time` double unsigned NOT NULL DEFAULT '0', `resolves` int(10) unsigned NOT NULL DEFAULT '0', `avg_resolve_time` double unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`user_id`,`hour`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_cities` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `city` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`city`), KEY `city` (`city`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_countries` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `country` varchar(2) COLLATE utf8_bin NOT NULL DEFAULT '', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`country`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_crawlers` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `crawler` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`crawler`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_domains` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `domain` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`domain`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_durations` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `duration` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`duration`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_goals` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `goal` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`goal`), KEY `target` (`goal`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_goals_queries` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `goal` int(10) unsigned NOT NULL DEFAULT '0', `query` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`goal`,`query`), KEY `target` (`goal`), KEY `query` (`query`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_isps` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `isp` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`isp`), KEY `isp` (`isp`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_languages` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `language` varchar(5) COLLATE utf8_bin NOT NULL, `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`language`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_pages` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `url` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`url`), KEY `url` (`url`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_pages_entrance` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `url` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`url`), KEY `url` (`url`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_pages_exit` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `url` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`url`), KEY `url` (`url`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_queries` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `query` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`query`), KEY `query` (`query`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_referrers` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `referrer` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`referrer`), KEY `referrer` (`referrer`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_regions` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `region` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`region`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_resolutions` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `resolution` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`resolution`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_search_engines` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `domain` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`domain`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_systems` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `system` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`system`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_visitors` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `hour` tinyint(3) unsigned NOT NULL DEFAULT '0', `visitors_unique` int(10) unsigned NOT NULL DEFAULT '0', `page_impressions` int(10) unsigned NOT NULL DEFAULT '0', `visitors_recurring` int(10) unsigned NOT NULL DEFAULT '0', `bounces` int(10) unsigned NOT NULL DEFAULT '0', `search_engine` int(10) unsigned NOT NULL DEFAULT '0', `from_referrer` int(10) unsigned NOT NULL DEFAULT '0', `browser_instances` int(10) unsigned NOT NULL DEFAULT '0', `js` int(10) unsigned NOT NULL DEFAULT '0', `on_chat_page` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`hour`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `stats_aggs_visits` ( `year` smallint(5) unsigned NOT NULL DEFAULT '0', `month` tinyint(3) unsigned NOT NULL DEFAULT '0', `day` tinyint(3) unsigned NOT NULL DEFAULT '0', `visits` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`year`,`month`,`day`,`visits`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `tickets` ( `id` varchar(32) COLLATE utf8_bin NOT NULL, `user_id` varchar(32) COLLATE utf8_bin NOT NULL, `target_group_id` varchar(32) COLLATE utf8_bin NOT NULL, `hash` varchar(32) COLLATE utf8_bin NOT NULL, `creation_type` tinyint(1) unsigned NOT NULL DEFAULT '0', `iso_language` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '', `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0', `last_update` int(10) unsigned NOT NULL DEFAULT '0', `wait_begin` int(10) NOT NULL DEFAULT '2000000000', `channel_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '0', `channel_conversation_id` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `last_update` (`last_update`), KEY `deleted` (`deleted`), KEY `wait_begin` (`wait_begin`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `ticket_attachments` ( `res_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `parent_id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`res_id`, `parent_id`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `signatures` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `name` varchar(256) COLLATE utf8_bin NOT NULL DEFAULT '', `signature` text COLLATE utf8_bin NOT NULL, `operator_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `group_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `default` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `operator_id` (`operator_id`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `ticket_emails` ( `email_id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `mailbox_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `sender_email` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `sender_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `sender_replyto` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `receiver_email` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `created` int(10) unsigned NOT NULL DEFAULT '0', `edited` int(10) unsigned NOT NULL DEFAULT '0', `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0', `subject` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `body` text COLLATE utf8_bin NOT NULL, `body_html` LONGTEXT COLLATE utf8_bin NOT NULL, `group_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `editor_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`email_id`,`group_id`), KEY `mailbox_id` (`mailbox_id`), KEY `edited` (`edited`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `mailboxes` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `email` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `exec_operator_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `username` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '', `password` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '', `type` varchar(16) COLLATE utf8_bin NOT NULL DEFAULT '', `host` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '', `port` mediumint(8) unsigned NOT NULL DEFAULT '0', `delete` smallint(5) NOT NULL DEFAULT '-1', `authentication` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `sender_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `ssl` tinyint(1) unsigned NOT NULL DEFAULT '0', `default` tinyint(1) unsigned NOT NULL DEFAULT '0', `last_connect` int(10) unsigned NOT NULL DEFAULT '0', `connect_frequency` int(10) unsigned NOT NULL DEFAULT '0', `framework` varchar(16) COLLATE utf8_bin NOT NULL DEFAULT 'ZEND', PRIMARY KEY (`id`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `ticket_customs` ( `ticket_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `message_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `custom_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `value` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`ticket_id`,`message_id`,`custom_id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `ticket_editors` ( `ticket_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `editor_id` varchar(32) COLLATE utf8_bin NOT NULL, `group_id` varchar(32) COLLATE utf8_bin NOT NULL, `status` tinyint(1) unsigned NOT NULL DEFAULT '1', `time` int(10) unsigned NOT NULL, PRIMARY KEY (`ticket_id`), KEY `time` (`time`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `ticket_messages` ( `id` varchar(32) COLLATE utf8_bin NOT NULL, `time` int(11) unsigned NOT NULL, `created` int(11) unsigned NOT NULL, `ticket_id` varchar(32) COLLATE utf8_bin NOT NULL, `text` mediumtext COLLATE utf8_bin NOT NULL, `fullname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `email` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `company` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `ip` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '', `phone` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `call_me_back` tinyint(1) unsigned NOT NULL DEFAULT '0', `country` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '', `type` tinyint(1) unsigned NOT NULL DEFAULT '0', `sender_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `channel_id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `hash` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `subject` varchar(512) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `ticket_id` (`ticket_id`), KEY `time` (`time`), KEY `hash` (`hash`), UNIQUE KEY `channel_id` (`channel_id`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitors` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `entrance` int(10) unsigned NOT NULL DEFAULT '0', `last_active` int(10) unsigned NOT NULL DEFAULT '0', `host` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `ip` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '', `system` int(11) unsigned NOT NULL DEFAULT '0', `browser` int(11) unsigned NOT NULL DEFAULT '0', `visits` int(11) unsigned NOT NULL DEFAULT '0', `visit_id` varchar(7) COLLATE utf8_bin NOT NULL DEFAULT '', `visit_latest` tinyint(1) unsigned NOT NULL DEFAULT '1', `visit_last` int(11) unsigned NOT NULL DEFAULT '0', `resolution` int(11) unsigned NOT NULL DEFAULT '0', `language` varchar(5) COLLATE utf8_bin NOT NULL, `country` varchar(2) COLLATE utf8_bin NOT NULL DEFAULT '', `city` int(10) unsigned NOT NULL DEFAULT '0', `region` int(10) unsigned NOT NULL DEFAULT '0', `isp` int(10) unsigned NOT NULL DEFAULT '0', `timezone` varchar(24) COLLATE utf8_bin NOT NULL DEFAULT '', `latitude` double NOT NULL DEFAULT '0', `longitude` double NOT NULL DEFAULT '0', `geo_result` int(10) unsigned NOT NULL DEFAULT '0', `js` tinyint(1) unsigned NOT NULL DEFAULT '0', `signature` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`,`entrance`), UNIQUE KEY `visit_id` (`visit_id`), KEY `signature` (`signature`), KEY `language` (`language`), KEY `country` (`country`), KEY `city` (`city`), KEY `region` (`region`), KEY `isp` (`isp`), KEY `system` (`system`), KEY `id` (`id`), KEY `ip` (`ip`), KEY `last_active` (`last_active`), KEY `browser` (`browser`), KEY `resolution` (`resolution`), KEY `visit_latest` (`visit_latest`), KEY `timezone` (`timezone`), KEY `entrance` (`entrance`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_comments` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `visitor_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `created` int(10) unsigned NOT NULL DEFAULT '0', `operator_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `comment` text COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), KEY `visitor_id` (`visitor_id`), KEY `created` (`created`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_browsers` ( `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `visitor_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `visit_id` varchar(7) COLLATE utf8_bin NOT NULL DEFAULT '', `created` int(10) unsigned NOT NULL DEFAULT '0', `last_active` int(10) unsigned NOT NULL DEFAULT '0', `last_update` varchar(2) COLLATE utf8_bin NOT NULL DEFAULT '', `is_chat` tinyint(1) unsigned NOT NULL DEFAULT '0', `query` int(10) unsigned NOT NULL DEFAULT '0', `fullname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `email` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `company` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `phone` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `customs` text COLLATE utf8_bin NOT NULL, `url_entrance` int(10) unsigned NOT NULL DEFAULT '0', `url_exit` int(10) unsigned NOT NULL DEFAULT '0', `pre_message` mediumtext COLLATE utf8_bin NOT NULL, `overlay` tinyint(1) unsigned NOT NULL DEFAULT '0', `overlay_container` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `visit_id` (`visit_id`), KEY `query` (`query`), KEY `last_active` (`last_active`), KEY `last_update` (`last_update`), KEY `is_chat` (`is_chat`), KEY `created` (`created`), KEY `visitor_id` (`visitor_id`), KEY `overlay` (`overlay`), KEY `overlay_container` (`overlay_container`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_browser_urls` ( `browser_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `entrance` int(10) unsigned NOT NULL DEFAULT '0', `referrer` int(10) unsigned NOT NULL DEFAULT '0', `url` int(10) unsigned NOT NULL DEFAULT '0', `params` text COLLATE utf8_bin NOT NULL, `untouched` text COLLATE utf8_bin NOT NULL, `title` text COLLATE utf8_bin NOT NULL, `ref_untouched` text COLLATE utf8_bin NOT NULL, `is_entrance` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_exit` tinyint(1) unsigned NOT NULL DEFAULT '0', `area_code` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`entrance`,`browser_id`), KEY `browser_id` (`browser_id`), KEY `referrer` (`referrer`), KEY `entrance` (`entrance`), KEY `is_entrance` (`is_entrance`), KEY `is_exit` (`is_exit`), KEY `url` (`url`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_chats` ( `visitor_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `browser_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `visit_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `chat_id` int(11) unsigned NOT NULL DEFAULT '0', `priority` tinyint(1) unsigned NOT NULL DEFAULT '2', `fullname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `email` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `company` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `phone` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `call_me_back` tinyint(1) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) unsigned NOT NULL DEFAULT '0', `typing` tinyint(1) unsigned NOT NULL DEFAULT '0', `waiting` tinyint(1) unsigned NOT NULL DEFAULT '0', `area_code` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `first_active` int(10) unsigned NOT NULL DEFAULT '0', `last_active` int(10) unsigned NOT NULL DEFAULT '0', `qpenalty` int(10) unsigned NOT NULL DEFAULT '0', `request_operator` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `request_group` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `question` text COLLATE utf8_bin NOT NULL, `customs` text COLLATE utf8_bin NOT NULL, `allocated` int(11) unsigned NOT NULL DEFAULT '0', `archive_created` tinyint(1) unsigned NOT NULL DEFAULT '0', `internal_active` tinyint(1) unsigned NOT NULL DEFAULT '0', `internal_closed` tinyint(1) unsigned NOT NULL DEFAULT '0', `internal_declined` tinyint(1) unsigned NOT NULL DEFAULT '0', `external_active` tinyint(1) unsigned NOT NULL DEFAULT '0', `external_close` tinyint(1) unsigned NOT NULL DEFAULT '0', `exit` int(11) unsigned NOT NULL DEFAULT '0', `queue_message_shown` tinyint(1) unsigned NOT NULL DEFAULT '0', `chat_ticket_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `response_time` int(11) unsigned NOT NULL DEFAULT '0', `chat_posts` int(11) unsigned NOT NULL DEFAULT '0', `queue_posts` text COLLATE utf8_bin NOT NULL, `init_chat_with` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `translation` varchar(16) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`visitor_id`,`browser_id`,`visit_id`,`chat_id`), KEY `chat_id` (`chat_id`), KEY `exit` (`exit`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_chat_operators` ( `chat_id` int(10) unsigned NOT NULL DEFAULT '0', `user_id` varchar(32) COLLATE utf8_bin NOT NULL, `declined` tinyint(1) unsigned NOT NULL DEFAULT '0', `dtime` int(10) unsigned NOT NULL DEFAULT '0', `ltime` int(10) unsigned NOT NULL DEFAULT '0', `jtime` int(10) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) unsigned NOT NULL DEFAULT '0', `alloc` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`user_id`,`chat_id`), KEY `chat_id` (`chat_id`), KEY `status` (`status`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_data_browsers` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `browser` varchar(255) COLLATE utf8_bin NOT NULL, `type` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `browser` (`browser`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_data_cities` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `city` (`city`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_data_crawlers` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `crawler` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `crawler` (`crawler`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_data_domains` ( `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `domain` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `external` tinyint(1) unsigned NOT NULL DEFAULT '1', `search` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `domain` (`domain`), KEY `search` (`search`), KEY `external` (`external`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_data_isps` ( `id` int(11) NOT NULL AUTO_INCREMENT, `isp` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `isp` (`isp`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_data_pages` ( `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `domain` int(10) unsigned NOT NULL DEFAULT '0', `path` int(10) unsigned NOT NULL DEFAULT '0', `title` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ` (`domain`,`path`), KEY `domain` (`domain`), KEY `path` (`path`), KEY `title` (`title`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_data_paths` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `path` (`path`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_data_queries` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `query` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `query` (`query`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_data_regions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `region` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `region` (`region`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_data_resolutions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `resolution` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `resolution` (`resolution`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_data_systems` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `system` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `system` (`system`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_data_titles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8_bin NOT NULL, `confirmed` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `title` (`title`), KEY `confirmed` (`confirmed`) ) ENGINE= DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE IF NOT EXISTS `visitor_goals` ( `visitor_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `goal_id` int(10) unsigned NOT NULL DEFAULT '0', `time` int(10) unsigned NOT NULL DEFAULT '0', `first_visit` tinyint(1) unsigned NOT NULL DEFAULT '0', `query` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`visitor_id`,`goal_id`), KEY `visitor_id` (`visitor_id`), KEY `goal_id` (`goal_id`) ) ENGINE= DEFAULT CHARSET=utf8 CHECKSUM=0 COLLATE=utf8

Košík  

Žádné zboží

Poštovné 0 Kč
Celkem 0 Kč

K pokladně