-- MariaDB dump 10.19  Distrib 10.5.19-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: 212.237.39.166    Database: abbfirmato
-- ------------------------------------------------------
-- Server version	5.7.31-34

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `aauth_group_to_group`
--

DROP TABLE IF EXISTS `aauth_group_to_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aauth_group_to_group` (
  `group_id` int(10) unsigned NOT NULL,
  `subgroup_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`group_id`,`subgroup_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `aauth_groups`
--

DROP TABLE IF EXISTS `aauth_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aauth_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `definition` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `aauth_login_attempts`
--

DROP TABLE IF EXISTS `aauth_login_attempts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aauth_login_attempts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(39) DEFAULT NULL,
  `timestamp` datetime DEFAULT NULL,
  `login_attempts` tinyint(3) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=407 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `aauth_perm_to_group`
--

DROP TABLE IF EXISTS `aauth_perm_to_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aauth_perm_to_group` (
  `perm_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `aauth_perm_to_user`
--

DROP TABLE IF EXISTS `aauth_perm_to_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aauth_perm_to_user` (
  `perm_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`perm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `aauth_perms`
--

DROP TABLE IF EXISTS `aauth_perms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aauth_perms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `definition` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=330 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `aauth_pms`
--

DROP TABLE IF EXISTS `aauth_pms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aauth_pms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sender_id` int(10) unsigned NOT NULL,
  `receiver_id` int(10) unsigned NOT NULL,
  `title` varchar(225) NOT NULL,
  `message` text,
  `date_sent` datetime DEFAULT NULL,
  `date_read` datetime DEFAULT NULL,
  `pm_deleted_sender` int(11) DEFAULT NULL,
  `pm_deleted_receiver` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `aauth_user`
--

DROP TABLE IF EXISTS `aauth_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aauth_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `definition` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `aauth_user_to_group`
--

DROP TABLE IF EXISTS `aauth_user_to_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aauth_user_to_group` (
  `user_id` int(10) unsigned NOT NULL,
  `group_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `aauth_user_variables`
--

DROP TABLE IF EXISTS `aauth_user_variables`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aauth_user_variables` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `data_key` varchar(100) NOT NULL,
  `value` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `aauth_users`
--

DROP TABLE IF EXISTS `aauth_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aauth_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(100) NOT NULL,
  `oauth_uid` text,
  `oauth_provider` varchar(100) DEFAULT NULL,
  `pass` varchar(64) NOT NULL,
  `username` varchar(100) NOT NULL,
  `full_name` varchar(200) NOT NULL,
  `avatar` text NOT NULL,
  `banned` tinyint(1) DEFAULT '0',
  `last_login` datetime DEFAULT NULL,
  `last_activity` datetime DEFAULT NULL,
  `date_created` datetime DEFAULT NULL,
  `forgot_exp` text,
  `remember_time` datetime DEFAULT NULL,
  `remember_exp` text,
  `verification_code` text,
  `top_secret` varchar(16) DEFAULT NULL,
  `ip_address` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `blog`
--

DROP TABLE IF EXISTS `blog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `blog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `slug` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `image` text NOT NULL,
  `tags` text NOT NULL,
  `category` varchar(200) NOT NULL,
  `status` varchar(10) NOT NULL,
  `author` varchar(100) NOT NULL,
  `viewers` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `blog_category`
--

DROP TABLE IF EXISTS `blog_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `blog_category` (
  `category_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_name` varchar(200) NOT NULL,
  `category_desc` text NOT NULL,
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `captcha`
--

DROP TABLE IF EXISTS `captcha`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `captcha` (
  `captcha_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `captcha_time` int(11) DEFAULT NULL,
  `ip_address` varchar(45) NOT NULL,
  `word` varchar(20) NOT NULL,
  PRIMARY KEY (`captcha_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `category_home`
--

DROP TABLE IF EXISTS `category_home`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category_home` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `slug` varchar(255) NOT NULL,
  `img` varchar(255) NOT NULL,
  `ordinamento` int(1) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_type` (`type`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cc_options`
--

DROP TABLE IF EXISTS `cc_options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cc_options` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `option_name` varchar(200) NOT NULL,
  `option_value` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cc_session`
--

DROP TABLE IF EXISTS `cc_session`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cc_session` (
  `id` int(11) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `data` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `coda_email`
--

DROP TABLE IF EXISTS `coda_email`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `coda_email` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `sender` int(11) NOT NULL,
  `nome_mittente` varchar(255) NOT NULL,
  `nome_destinatario` varchar(255) NOT NULL,
  `mail_mittente` varchar(255) NOT NULL,
  `mail_destinatario` varchar(255) NOT NULL,
  `oggetto` varchar(255) NOT NULL,
  `messaggio` longtext NOT NULL,
  `tipo` int(1) NOT NULL,
  `html_txt` int(1) NOT NULL,
  `inserito` int(255) NOT NULL,
  `inviato` int(255) NOT NULL,
  `stato` int(1) NOT NULL,
  `sorgente` int(11) NOT NULL,
  `ctrl_time` varchar(35) NOT NULL,
  `allegato` text NOT NULL,
  `lista_allegati` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `stato` (`stato`),
  KEY `inserito` (`inserito`),
  KEY `inviato` (`inviato`),
  KEY `sender` (`sender`),
  KEY `dest` (`nome_destinatario`),
  FULLTEXT KEY `Oggetto per ricerca` (`oggetto`)
) ENGINE=InnoDB AUTO_INCREMENT=57489 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cron_exec`
--

DROP TABLE IF EXISTS `cron_exec`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cron_exec` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `data` bigint(14) NOT NULL,
  `comando` text NOT NULL,
  `stato` int(2) NOT NULL,
  `msg` varchar(255) NOT NULL,
  `priorita` int(10) NOT NULL,
  `coda` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `stato` (`stato`),
  KEY `priorita` (`priorita`)
) ENGINE=InnoDB AUTO_INCREMENT=3425 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crud`
--

DROP TABLE IF EXISTS `crud`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crud` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `table_name` varchar(200) NOT NULL,
  `primary_key` varchar(200) NOT NULL,
  `page_read` varchar(20) DEFAULT NULL,
  `page_create` varchar(20) DEFAULT NULL,
  `page_update` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crud_custom_option`
--

DROP TABLE IF EXISTS `crud_custom_option`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crud_custom_option` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `crud_field_id` int(11) NOT NULL,
  `crud_id` int(11) NOT NULL,
  `option_value` text NOT NULL,
  `option_label` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crud_field`
--

DROP TABLE IF EXISTS `crud_field`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crud_field` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `crud_id` int(11) NOT NULL,
  `field_name` varchar(200) NOT NULL,
  `field_label` varchar(200) DEFAULT NULL,
  `input_type` varchar(200) NOT NULL,
  `show_column` varchar(10) DEFAULT NULL,
  `show_add_form` varchar(10) DEFAULT NULL,
  `show_update_form` varchar(10) DEFAULT NULL,
  `show_detail_page` varchar(10) DEFAULT NULL,
  `sort` int(11) NOT NULL,
  `relation_table` varchar(200) DEFAULT NULL,
  `relation_value` varchar(200) DEFAULT NULL,
  `relation_label` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=723 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crud_field_configuration`
--

DROP TABLE IF EXISTS `crud_field_configuration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crud_field_configuration` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `crud_field_id` int(11) NOT NULL,
  `crud_id` int(11) NOT NULL,
  `group_config` varchar(200) NOT NULL,
  `config_name` text NOT NULL,
  `config_value` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crud_field_validation`
--

DROP TABLE IF EXISTS `crud_field_validation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crud_field_validation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `crud_field_id` int(11) NOT NULL,
  `crud_id` int(11) NOT NULL,
  `validation_name` varchar(200) NOT NULL,
  `validation_value` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1224 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crud_input_chained`
--

DROP TABLE IF EXISTS `crud_input_chained`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crud_input_chained` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `chain_field` varchar(250) DEFAULT NULL,
  `chain_field_eq` varchar(250) DEFAULT NULL,
  `crud_field_id` int(11) DEFAULT NULL,
  `crud_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crud_input_type`
--

DROP TABLE IF EXISTS `crud_input_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crud_input_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(200) NOT NULL,
  `relation` varchar(20) NOT NULL,
  `custom_value` int(11) NOT NULL,
  `validation_group` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crud_input_validation`
--

DROP TABLE IF EXISTS `crud_input_validation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crud_input_validation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `validation` varchar(200) NOT NULL,
  `input_able` varchar(20) NOT NULL,
  `group_input` text NOT NULL,
  `input_placeholder` text NOT NULL,
  `call_back` varchar(10) NOT NULL,
  `input_validation` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_automation_bit`
--

DROP TABLE IF EXISTS `e_automation_bit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_automation_bit` (
  `id_e_automation_bit` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_user` int(255) NOT NULL,
  `type` int(2) NOT NULL,
  `value` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_e_automation_bit`),
  KEY `id_e_user` (`id_e_user`),
  KEY `bit_notify_1` (`value`),
  KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_banner`
--

DROP TABLE IF EXISTS `e_banner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_banner` (
  `id_e_banner` int(10) NOT NULL AUTO_INCREMENT,
  `tipo_banner` int(1) NOT NULL DEFAULT '0',
  `id_zona` int(10) NOT NULL,
  `bg_sfondo` varchar(10) DEFAULT NULL,
  `bg_cta` varchar(10) DEFAULT NULL,
  `col_cta` varchar(10) DEFAULT NULL,
  `titolo1` varchar(255) DEFAULT NULL,
  `titolo2` varchar(255) DEFAULT NULL,
  `prezzo1` float(10,2) NOT NULL,
  `prezzo2` float(10,2) NOT NULL,
  `prezzo3` float(10,2) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `url_img` varchar(255) DEFAULT NULL,
  `ordinamento` int(1) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_e_banner`),
  KEY `id_zona` (`id_zona`),
  CONSTRAINT `id_zona` FOREIGN KEY (`id_zona`) REFERENCES `e_banner_zona` (`id_e_banner_zona`)
) ENGINE=InnoDB AUTO_INCREMENT=436 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_banner_zona`
--

DROP TABLE IF EXISTS `e_banner_zona`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_banner_zona` (
  `id_e_banner_zona` int(255) NOT NULL AUTO_INCREMENT,
  `nome` varchar(255) NOT NULL,
  `descrizione` text NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_e_banner_zona`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_brands`
--

DROP TABLE IF EXISTS `e_brands`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_brands` (
  `id_e_brands` int(11) NOT NULL AUTO_INCREMENT,
  `codice` varchar(100) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `url_img` varchar(255) NOT NULL,
  `rilevanza` int(10) NOT NULL DEFAULT '0',
  `promo` int(1) NOT NULL,
  `perc_sconto` float(10,2) NOT NULL,
  `moltiplicatore_prezzo` float(10,2) NOT NULL,
  `status` bit(1) DEFAULT b'1',
  PRIMARY KEY (`id_e_brands`),
  KEY `nome` (`nome`),
  KEY `promo` (`promo`),
  KEY `status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=245 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_brands_discount_log`
--

DROP TABLE IF EXISTS `e_brands_discount_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_brands_discount_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_brand` int(11) NOT NULL,
  `previous_discount` float(10,2) NOT NULL,
  `current_discount` float(10,2) NOT NULL,
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `id_user` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_user` (`id_user`),
  KEY `date` (`date`)
) ENGINE=InnoDB AUTO_INCREMENT=234 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_brands_esclusi`
--

DROP TABLE IF EXISTS `e_brands_esclusi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_brands_esclusi` (
  `id_e_brands_esclusi` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_brands` int(255) NOT NULL,
  `country` varchar(2) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_e_brands_esclusi`),
  UNIQUE KEY `id_e_brands_2` (`id_e_brands`,`country`),
  KEY `country` (`country`),
  KEY `id_e_brands` (`id_e_brands`),
  KEY `status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_brands_not_country`
--

DROP TABLE IF EXISTS `e_brands_not_country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_brands_not_country` (
  `id_e_brands_not_country` int(255) NOT NULL,
  `id_e_brands` int(255) NOT NULL,
  `country` varchar(5) NOT NULL,
  `not_product` int(1) NOT NULL,
  `not_fatturazione` int(1) NOT NULL,
  `not_spedizione` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_cart`
--

DROP TABLE IF EXISTS `e_cart`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_cart` (
  `id_e_cart` int(50) NOT NULL AUTO_INCREMENT,
  `session` varchar(255) NOT NULL,
  `id_e_products` int(50) NOT NULL,
  `nome_prodotto` varchar(255) NOT NULL,
  `quantita_carrello` int(10) unsigned NOT NULL,
  `prezzo_unitario` float unsigned NOT NULL,
  `prezzo_finale` float unsigned NOT NULL,
  `risparmio` float NOT NULL,
  `id_e_products_models` varchar(255) NOT NULL,
  `id_gruppo` int(11) NOT NULL,
  `pacco_regalo` int(11) NOT NULL,
  `prezzo_pacco_regalo` float(10,2) NOT NULL,
  `id_spedizione_prodotto` int(255) NOT NULL,
  `notifica` int(1) NOT NULL COMMENT '0=da inviare, 1:1°invio, 2°invio ecc...',
  `data_inserimento_carrello` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `qta_bloccate` int(1) NOT NULL DEFAULT '0',
  `tipo_prodotto` int(1) NOT NULL COMMENT '0 fisico, 2 drop',
  `market_iso` varchar(3) NOT NULL,
  PRIMARY KEY (`id_e_cart`),
  KEY `id_prodotto` (`id_e_products`),
  KEY `id_sessione_carrello` (`session`),
  KEY `id_gruppo` (`id_gruppo`),
  KEY `id_variazione` (`id_e_products_models`),
  KEY `pacco_regalo` (`pacco_regalo`),
  KEY `tipo_prodotto` (`tipo_prodotto`),
  KEY `market_iso` (`market_iso`)
) ENGINE=InnoDB AUTO_INCREMENT=73382 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_cart_gift_card_data`
--

DROP TABLE IF EXISTS `e_cart_gift_card_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_cart_gift_card_data` (
  `id_e_cart_gift_card_data` int(255) NOT NULL AUTO_INCREMENT,
  `session` varchar(255) NOT NULL,
  `id_e_products` int(255) NOT NULL,
  `id_e_products_models` int(255) NOT NULL,
  `da_nome` varchar(255) NOT NULL,
  `da_email` varchar(255) NOT NULL,
  `a_nome` varchar(255) NOT NULL,
  `a_email` varchar(255) NOT NULL,
  `messaggio` text NOT NULL,
  `id_template` int(10) NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`id_e_cart_gift_card_data`),
  UNIQUE KEY `session_2` (`session`,`id_e_products`,`id_e_products_models`),
  KEY `session` (`session`),
  KEY `id_e_products` (`id_e_products`),
  KEY `id_e_products_models` (`id_e_products_models`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_cart_import_file`
--

DROP TABLE IF EXISTS `e_cart_import_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_cart_import_file` (
  `id_e_cart_import_file` int(255) NOT NULL AUTO_INCREMENT,
  `session` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `data` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`id_e_cart_import_file`),
  KEY `session` (`session`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_cassa`
--

DROP TABLE IF EXISTS `e_cassa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_cassa` (
  `id_e_cassa` bigint(255) NOT NULL AUTO_INCREMENT,
  `valore_movimento` float(10,2) NOT NULL,
  `id_e_order` bigint(255) NOT NULL,
  `id_e_user` bigint(255) NOT NULL,
  `data_valuta` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `causale` varchar(255) NOT NULL,
  `data_inserimento` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tipo_movimento` int(1) NOT NULL DEFAULT '1' COMMENT '1 normale, 2 rimborso, 3 cashback',
  `notifica_1` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_e_cassa`),
  UNIQUE KEY `valore_movimento` (`valore_movimento`,`id_e_order`,`id_e_user`,`causale`),
  KEY `id_ordine` (`id_e_order`),
  KEY `id_utente` (`id_e_user`),
  KEY `tipo_movimento` (`tipo_movimento`),
  KEY `notifica` (`notifica_1`)
) ENGINE=InnoDB AUTO_INCREMENT=292 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_category_list`
--

DROP TABLE IF EXISTS `e_category_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_category_list` (
  `id_category_list` int(11) NOT NULL AUTO_INCREMENT,
  `id_category_group` int(11) NOT NULL,
  `nome` varchar(100) NOT NULL,
  `ordinamento` int(11) NOT NULL,
  `stato` int(11) NOT NULL COMMENT '0 = non attiva, 1 = attiva',
  `uomo` int(1) NOT NULL DEFAULT '0',
  `donna` int(1) NOT NULL DEFAULT '0',
  `bambino` int(1) NOT NULL DEFAULT '0',
  `bambina` int(1) NOT NULL DEFAULT '0',
  `slot_imballo` int(10) NOT NULL,
  PRIMARY KEY (`id_category_list`),
  KEY `ctegoria_gruppo` (`id_category_group`),
  KEY `nome` (`nome`),
  KEY `uomo` (`uomo`),
  KEY `donna` (`donna`),
  KEY `bambino` (`bambino`),
  KEY `bambina` (`bambina`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_color`
--

DROP TABLE IF EXISTS `e_color`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_color` (
  `id_e_colors` int(11) NOT NULL AUTO_INCREMENT,
  `id_colore_gruppo` int(11) NOT NULL,
  `nome` varchar(150) NOT NULL,
  `ordinamento` int(11) NOT NULL,
  `stato` int(11) NOT NULL DEFAULT '1',
  `esadecimale` varchar(200) NOT NULL,
  `esadecimale_check` varchar(10) NOT NULL,
  `css` text NOT NULL,
  `termini` text NOT NULL,
  PRIMARY KEY (`id_e_colors`),
  KEY `id_colore_gruppo` (`id_colore_gruppo`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_comune`
--

DROP TABLE IF EXISTS `e_comune`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_comune` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `slug` varchar(255) NOT NULL,
  `lat` varchar(255) NOT NULL,
  `lng` varchar(255) NOT NULL,
  `codice_provincia_istat` varchar(255) NOT NULL,
  `codice_comune_istat` varchar(255) NOT NULL,
  `codice_alfanumerico_istat` varchar(255) NOT NULL,
  `capoluogo_provincia` tinyint(1) NOT NULL,
  `capoluogo_regione` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `codice_provincia_istat` (`codice_provincia_istat`)
) ENGINE=InnoDB AUTO_INCREMENT=8093 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_contacts`
--

DROP TABLE IF EXISTS `e_contacts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_contacts` (
  `id_e_contacts` int(255) NOT NULL AUTO_INCREMENT,
  `nome` varchar(255) NOT NULL,
  `cognome` varchar(255) NOT NULL,
  `oggetto` varchar(255) NOT NULL,
  `contenuto` text NOT NULL,
  `email` varchar(255) NOT NULL,
  `data` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(1) NOT NULL,
  `notifica_1` int(1) NOT NULL,
  PRIMARY KEY (`id_e_contacts`)
) ENGINE=InnoDB AUTO_INCREMENT=224 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_corriere`
--

DROP TABLE IF EXISTS `e_corriere`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_corriere` (
  `id_e_corriere` int(10) NOT NULL AUTO_INCREMENT,
  `nome` varchar(255) NOT NULL,
  PRIMARY KEY (`id_e_corriere`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_country`
--

DROP TABLE IF EXISTS `e_country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iso` char(2) NOT NULL,
  `name` varchar(80) NOT NULL,
  `nicename` varchar(80) NOT NULL,
  `iso3` char(3) DEFAULT NULL,
  `numcode` smallint(6) DEFAULT NULL,
  `phonecode` int(5) NOT NULL,
  `ordine` int(10) NOT NULL,
  `shipping_cost_base` float(10,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `nicename` (`nicename`)
) ENGINE=InnoDB AUTO_INCREMENT=240 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_dictionary`
--

DROP TABLE IF EXISTS `e_dictionary`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_dictionary` (
  `id_e_dictionary` int(255) NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL,
  `id` int(255) NOT NULL,
  `string` varchar(255) NOT NULL,
  `lang_iso` varchar(3) NOT NULL,
  `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id_e_dictionary`),
  KEY `type` (`type`),
  KEY `lang_iso` (`lang_iso`),
  KEY `id` (`id`),
  KEY `type_2` (`type`,`id`,`lang_iso`)
) ENGINE=InnoDB AUTO_INCREMENT=263 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_export`
--

DROP TABLE IF EXISTS `e_export`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_export` (
  `id_e_export` int(11) NOT NULL AUTO_INCREMENT,
  `data_url` varchar(255) NOT NULL,
  `filter_category` varchar(255) NOT NULL,
  `filter_brand` varchar(255) NOT NULL,
  `filter_gender` varchar(255) NOT NULL,
  `filter_model` varchar(255) NOT NULL,
  `order_by` int(1) NOT NULL DEFAULT '1',
  `hash` varchar(255) NOT NULL,
  `data_inserimento` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `data_elaborazione` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `data_export` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(1) NOT NULL,
  `url_file` varchar(255) NOT NULL,
  `url_zip` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id_e_export`),
  KEY `hash` (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_export_data`
--

DROP TABLE IF EXISTS `e_export_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_export_data` (
  `id_e_export_data` int(255) NOT NULL AUTO_INCREMENT,
  `hash` varchar(255) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `miniatura` varchar(255) NOT NULL,
  `brand` varchar(50) NOT NULL,
  `sesso` varchar(20) NOT NULL,
  `subcategoria` varchar(255) NOT NULL,
  `sku_matrice` varchar(255) NOT NULL,
  `sku` varchar(255) NOT NULL,
  `colore` varchar(255) NOT NULL,
  `descrizione` varchar(255) NOT NULL,
  `composizione` varchar(255) NOT NULL,
  `taglia` varchar(10) NOT NULL,
  `quantita` int(10) NOT NULL,
  `price` float(10,2) NOT NULL,
  `retail_price` float(10,2) NOT NULL,
  `codice_ordine` varchar(255) NOT NULL,
  `codice_foto` varchar(255) NOT NULL,
  `dimensione_l` varchar(10) NOT NULL,
  `dimensione_p` varchar(10) NOT NULL,
  `dimensione_a` varchar(10) NOT NULL,
  `made_in` varchar(50) NOT NULL,
  `codice_brand` varchar(100) NOT NULL,
  `ean` varchar(100) NOT NULL,
  `foto_1` varchar(255) NOT NULL,
  `foto_2` varchar(255) NOT NULL,
  `foto_3` varchar(255) NOT NULL,
  `foto_4` varchar(255) NOT NULL,
  `foto_5` varchar(255) NOT NULL,
  `foto_6` varchar(255) NOT NULL,
  `barcodeint` varchar(255) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `nome_en` varchar(255) NOT NULL,
  `ordinamento` int(255) NOT NULL,
  `taglia_ordinamento` int(10) NOT NULL,
  PRIMARY KEY (`id_e_export_data`),
  KEY `hash` (`hash`),
  KEY `sku_matrice` (`sku_matrice`),
  KEY `sku` (`sku`),
  KEY `ordinamento` (`ordinamento`),
  KEY `taglia_ordinamento` (`taglia_ordinamento`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_foreign_exchange_rates`
--

DROP TABLE IF EXISTS `e_foreign_exchange_rates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_foreign_exchange_rates` (
  `id_e_foreign_exchange_rates` int(11) NOT NULL AUTO_INCREMENT,
  `from` varchar(3) NOT NULL,
  `to` varchar(3) NOT NULL,
  `rate` float(10,4) NOT NULL,
  `update_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_e_foreign_exchange_rates`)
) ENGINE=InnoDB AUTO_INCREMENT=6459 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_fornitore`
--

DROP TABLE IF EXISTS `e_fornitore`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_fornitore` (
  `id_fornitore` int(255) NOT NULL AUTO_INCREMENT,
  `id_merchant` int(11) NOT NULL DEFAULT '0',
  `nome` varchar(255) NOT NULL,
  `mail` varchar(255) NOT NULL,
  `categoria` varchar(255) NOT NULL,
  `mail_assistenza` varchar(255) NOT NULL,
  `note_assistenza` text NOT NULL,
  `telefono_assistenza` varchar(255) NOT NULL,
  `sito_web` varchar(255) NOT NULL,
  `tipo` varchar(3) NOT NULL DEFAULT '000',
  `info_partner` text NOT NULL,
  `condizioni_vendita` text NOT NULL,
  `indirizzo_sede_legale` text NOT NULL,
  `via_sede_legale` text NOT NULL,
  `citta_sede_legale` text NOT NULL,
  `cap_sede_legale` text NOT NULL,
  `provincia_sede_legale` text NOT NULL,
  `telefono_sede_legale` text NOT NULL,
  `piva_sede_legale` text NOT NULL,
  `rea_sede_legale` text NOT NULL,
  `indirizzo_reso` text NOT NULL,
  `nome_cognome_ref_com` varchar(255) NOT NULL,
  `ruolo_ref_com` varchar(255) NOT NULL,
  `telefono_ref_com` varchar(255) NOT NULL,
  `email_ref_com` varchar(255) NOT NULL,
  `procacciatore` text NOT NULL,
  `conto_fornitore` varchar(9) NOT NULL,
  `id_nazione` int(11) DEFAULT NULL,
  `brand` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_fornitore`),
  KEY `id_merchant` (`id_merchant`),
  KEY `tipo` (`tipo`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_giftcard_code`
--

DROP TABLE IF EXISTS `e_giftcard_code`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_giftcard_code` (
  `id_e_giftcard_code` int(255) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`id_e_giftcard_code`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_giftcard_log`
--

DROP TABLE IF EXISTS `e_giftcard_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_giftcard_log` (
  `id_e_gift_card_log` int(255) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_e_gift_card_log`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_giftcard_order`
--

DROP TABLE IF EXISTS `e_giftcard_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_giftcard_order` (
  `id_e_giftcard_order` int(255) NOT NULL AUTO_INCREMENT,
  `codice_ordine` varchar(100) NOT NULL,
  `id_e_user` int(255) NOT NULL,
  `id_e_order` int(255) NOT NULL,
  `id_e_giftcard_size` int(255) NOT NULL,
  `descrizione` varchar(255) NOT NULL,
  `url_img` varchar(255) NOT NULL,
  `taglio` float(10,2) NOT NULL,
  `importo_totale` float(10,2) NOT NULL,
  `id_pagamento` int(10) NOT NULL,
  `id_spedizione` int(10) NOT NULL,
  `data_acquisto` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `data_pagamento` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `data_emissione` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `data_riscatto` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `data_scadenza` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(1) NOT NULL,
  `nominativo_mittente` varchar(255) NOT NULL,
  `email_mittente` varchar(255) NOT NULL,
  `messaggio` text NOT NULL,
  `nominativo_destinatario` varchar(255) NOT NULL,
  `email_destinatario` varchar(255) NOT NULL,
  `id_e_giftcard_code` int(255) NOT NULL,
  `pagato` int(11) NOT NULL,
  `cash_back` float(10,2) NOT NULL,
  `cash_back_erogato` int(1) NOT NULL,
  `cash_back_data_generazione` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `obj_riscatto` text NOT NULL,
  `id_template` int(10) NOT NULL,
  `bit_notifica_1` int(1) NOT NULL,
  `bit_notifica_2` int(1) NOT NULL,
  `bit_notifica_3` int(11) NOT NULL,
  PRIMARY KEY (`id_e_giftcard_order`),
  KEY `id_e_user` (`id_e_user`),
  KEY `id_e_giftcard_size` (`id_e_giftcard_size`),
  KEY `id_e_giftcard_code` (`id_e_giftcard_code`),
  KEY `status` (`status`),
  KEY `pagato` (`pagato`),
  KEY `bit_notifica_1` (`bit_notifica_1`),
  KEY `bit_notifica_2` (`bit_notifica_2`),
  KEY `bit_notifica_3` (`bit_notifica_3`),
  KEY `id_e_order` (`id_e_order`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_giftcard_size`
--

DROP TABLE IF EXISTS `e_giftcard_size`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_giftcard_size` (
  `id_e_giftcard_size` int(255) NOT NULL AUTO_INCREMENT,
  `descrizione` varchar(255) NOT NULL,
  `url_img` varchar(255) NOT NULL,
  `valore` float(10,2) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_e_giftcard_size`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_import`
--

DROP TABLE IF EXISTS `e_import`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_import` (
  `id_e_import` int(255) NOT NULL AUTO_INCREMENT,
  `record_type` varchar(255) NOT NULL,
  `product_id` varchar(255) NOT NULL,
  `parent_id` varchar(255) NOT NULL,
  `sku` varchar(255) NOT NULL,
  `brand` varchar(255) NOT NULL,
  `codice_brand` varchar(10) NOT NULL,
  `model_name` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `quantity` varchar(255) NOT NULL,
  `prezzo_listino` float(10,2) NOT NULL,
  `prezzo_b2c` float(10,2) NOT NULL,
  `prezzo_b2b` float(10,2) NOT NULL,
  `prezzo_acquisto` float(10,2) NOT NULL,
  `description` varchar(255) NOT NULL,
  `weight` varchar(255) NOT NULL,
  `img_1` varchar(255) NOT NULL,
  `img_2` varchar(255) NOT NULL,
  `img_3` varchar(255) NOT NULL,
  `img_4` varchar(255) NOT NULL,
  `img_5` varchar(255) NOT NULL,
  `img_6` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `category1` varchar(255) NOT NULL,
  `category2` varchar(255) NOT NULL,
  `id_category1` int(255) NOT NULL,
  `id_category2` int(255) NOT NULL,
  `model_sku` varchar(255) NOT NULL,
  `ean` varchar(255) NOT NULL,
  `model_size` varchar(255) NOT NULL,
  `id_model_size` int(255) NOT NULL,
  `model_legend` varchar(10) NOT NULL,
  `color_code` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `id_color` int(255) NOT NULL,
  `made_in` varchar(255) NOT NULL,
  `material` varchar(255) NOT NULL,
  `id_fornitore` int(255) NOT NULL,
  `primavera` int(1) NOT NULL,
  `estate` int(1) NOT NULL,
  `autunno` int(1) NOT NULL,
  `inverno` int(1) NOT NULL,
  `uomo` int(1) NOT NULL DEFAULT '0',
  `donna` int(1) NOT NULL DEFAULT '0',
  `bambino` int(1) NOT NULL DEFAULT '0',
  `bambina` int(1) NOT NULL DEFAULT '0',
  `dimensioni` varchar(255) DEFAULT NULL,
  `codice_extra` varchar(255) NOT NULL,
  `check_integrity` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_e_import`),
  KEY `id_fornitore` (`id_fornitore`),
  KEY `sku` (`sku`),
  KEY `codice_extra` (`codice_extra`),
  KEY `ean` (`ean`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_import_error`
--

DROP TABLE IF EXISTS `e_import_error`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_import_error` (
  `id_e_import_error` int(255) NOT NULL AUTO_INCREMENT,
  `msg` varchar(255) NOT NULL,
  `id_tipo` int(1) NOT NULL DEFAULT '1',
  `data` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `notifica` smallint(1) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL,
  `channel_notify` char(5) DEFAULT NULL,
  PRIMARY KEY (`id_e_import_error`)
) ENGINE=InnoDB AUTO_INCREMENT=6713 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_languages`
--

DROP TABLE IF EXISTS `e_languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_languages` (
  `id_e_languages` int(10) NOT NULL AUTO_INCREMENT,
  `iso` varchar(3) NOT NULL,
  `name` varchar(255) NOT NULL,
  `url_default` varchar(255) NOT NULL,
  PRIMARY KEY (`id_e_languages`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_link_zone`
--

DROP TABLE IF EXISTS `e_link_zone`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_link_zone` (
  `id_link_zone` int(10) NOT NULL AUTO_INCREMENT,
  `nome` varchar(255) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_link_zone`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_link_zone_links`
--

DROP TABLE IF EXISTS `e_link_zone_links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_link_zone_links` (
  `id_e_link_zone_links` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_link_zone` int(255) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_e_link_zone_links`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_log_warning`
--

DROP TABLE IF EXISTS `e_log_warning`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_log_warning` (
  `id_e_log_warning` int(255) NOT NULL AUTO_INCREMENT,
  `msg` varchar(255) NOT NULL,
  `id_tipo` int(1) NOT NULL DEFAULT '1',
  `data` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`id_e_log_warning`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_order`
--

DROP TABLE IF EXISTS `e_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_order` (
  `id_e_order` int(255) NOT NULL AUTO_INCREMENT,
  `codice_ordine` varchar(100) NOT NULL,
  `id_e_products` int(255) NOT NULL,
  `id_e_user` int(255) NOT NULL,
  `cid` text NOT NULL,
  `id_agente` int(11) NOT NULL,
  `id_stato` int(255) NOT NULL,
  `sub_stato` varchar(9) NOT NULL DEFAULT '000000000',
  `id_sconto` int(255) NOT NULL,
  `codice_sconto` varchar(255) DEFAULT NULL,
  `valore_sconto` float(10,2) NOT NULL,
  `data_ordine` bigint(14) NOT NULL,
  `id_pagamento` int(255) NOT NULL DEFAULT '1',
  `assicurazione` int(1) NOT NULL,
  `imponibile` float(10,2) NOT NULL,
  `iva` float(10,2) NOT NULL,
  `totale` float(10,2) NOT NULL,
  `pagato` tinyint(1) NOT NULL DEFAULT '0',
  `data_evasione` bigint(14) NOT NULL,
  `data_consegna` bigint(14) NOT NULL,
  `email` varchar(255) NOT NULL,
  `data_consegna_stimata` bigint(20) NOT NULL,
  `tipo_ordine` int(11) NOT NULL,
  `attributi` text NOT NULL,
  `note_utente` text,
  `note_amministrazione` text,
  `file_fattura` varchar(255) NOT NULL,
  `fat_nome` varchar(255) NOT NULL,
  `fat_cognome` varchar(255) NOT NULL,
  `fat_rag_sociale` varchar(255) NOT NULL,
  `fat_pi` varchar(13) NOT NULL,
  `fat_cf` varchar(16) NOT NULL,
  `fat_indirizzo` varchar(255) NOT NULL,
  `fat_num_civico` varchar(20) DEFAULT NULL,
  `fat_cap` varchar(10) NOT NULL,
  `fat_citta` varchar(255) NOT NULL,
  `fat_provincia` varchar(2) NOT NULL,
  `fat_sdi` varchar(255) NOT NULL,
  `fat_pec` varchar(255) NOT NULL,
  `spe_nome` varchar(255) NOT NULL,
  `spe_cognome` varchar(255) NOT NULL,
  `spe_presso` varchar(255) NOT NULL,
  `spe_telefono` varchar(20) NOT NULL,
  `spe_indirizzo` varchar(255) NOT NULL,
  `spe_num_civico` varchar(20) DEFAULT NULL,
  `spe_cap` varchar(10) NOT NULL,
  `spe_citta` varchar(255) NOT NULL,
  `spe_provincia` varchar(2) NOT NULL,
  `spe_lat` varchar(10) NOT NULL,
  `spe_lon` varchar(10) NOT NULL,
  `costo_spedizione` float NOT NULL,
  `costo_pagamento` float NOT NULL,
  `id_opinione` int(11) NOT NULL,
  `id_corriere` int(11) NOT NULL,
  `tracking` varchar(255) NOT NULL,
  `codice_partner` varchar(255) NOT NULL,
  `id_sorgente` int(10) NOT NULL,
  `ob_json` text NOT NULL,
  `acconto` float(10,2) NOT NULL,
  `differenza` float(10,2) NOT NULL,
  `id_partner` int(11) NOT NULL,
  `num_oc` varchar(255) NOT NULL,
  `num_ft` varchar(255) NOT NULL,
  `data_ft` bigint(14) NOT NULL,
  `nome_ft_pdf` text NOT NULL,
  `info_paypal` text NOT NULL,
  `anomalie` varchar(4) NOT NULL DEFAULT '0000',
  `link_ekomi` text NOT NULL,
  `data_link_ekomi` bigint(14) NOT NULL,
  `id_transazione_ga` varchar(255) NOT NULL,
  `regalo` int(11) NOT NULL,
  `valore_cassa` float(10,2) NOT NULL,
  `data_consegna_stimata_fine` bigint(14) NOT NULL,
  `id_spedizione` int(11) NOT NULL,
  `prodotti_mancanti` int(11) DEFAULT NULL,
  `num_ord_gestionale` varchar(255) NOT NULL,
  `msg_esito_trasmissione` text NOT NULL,
  `fat_nazione` varchar(255) NOT NULL DEFAULT 'IT',
  `spe_nazione` varchar(255) NOT NULL DEFAULT 'IT',
  `ordine_interno` int(1) NOT NULL,
  `bit_notifica_9` int(1) NOT NULL DEFAULT '0',
  `bit_notifica_8` int(1) NOT NULL DEFAULT '0',
  `bit_notifica_7` int(1) NOT NULL DEFAULT '0',
  `bit_notifica_6` int(1) NOT NULL DEFAULT '0',
  `bit_notifica_5` int(1) NOT NULL DEFAULT '0',
  `bit_notifica_4` int(1) NOT NULL DEFAULT '0',
  `bit_notifica_3` int(1) NOT NULL DEFAULT '0',
  `bit_notifica_2` int(1) NOT NULL DEFAULT '0',
  `bit_notifica_10` int(1) NOT NULL DEFAULT '0',
  `bit_notifica_1` int(1) NOT NULL DEFAULT '0',
  `info_esito_pagamento` text NOT NULL,
  `gsped_trasmesso` int(1) NOT NULL DEFAULT '0',
  `gsped_check_off` int(1) NOT NULL DEFAULT '0',
  `gest_impegnabile` int(1) NOT NULL DEFAULT '0',
  `gest_impegnato` int(1) NOT NULL DEFAULT '0',
  `impegno_logico` int(1) DEFAULT '0',
  `printed` int(1) NOT NULL,
  `cash_back` float(10,2) NOT NULL DEFAULT '0.00',
  `cash_back_erogato` int(1) NOT NULL DEFAULT '0',
  `cash_back_data_generazione` bigint(14) NOT NULL,
  `hub_trasmesso` int(1) DEFAULT '0',
  `hub_codice` varchar(255) NOT NULL,
  `payment_intent` varchar(255) NOT NULL,
  `vies_status` int(1) NOT NULL DEFAULT '-1',
  `verifica_distribuzione_prodotti` int(1) NOT NULL DEFAULT '0',
  `numero_spedizioni` int(1) NOT NULL,
  `market_iso` varchar(3) NOT NULL,
  `data_richiesta_spedizione` varchar(20) NOT NULL,
  `cod_sito` varchar(20) NOT NULL,
  `platform` varchar(100) DEFAULT NULL,
  `app_version` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id_e_order`),
  KEY `id_prodotto` (`id_e_products`),
  KEY `id_utente` (`id_e_user`),
  KEY `codice_partner` (`codice_partner`),
  KEY `id_pagamento` (`id_pagamento`),
  KEY `num_ft` (`num_ft`),
  KEY `num_oc` (`num_oc`),
  KEY `pagato` (`pagato`),
  KEY `data_ordine` (`data_ordine`),
  KEY `data_evasione` (`data_evasione`),
  KEY `id_stato` (`id_stato`),
  KEY `id_sconto` (`id_sconto`),
  KEY `tipo_spedizione` (`id_spedizione`),
  KEY `tracking` (`tracking`),
  KEY `email` (`email`),
  KEY `id_sorgente` (`id_sorgente`),
  KEY `gsped_trasmesso` (`gsped_trasmesso`),
  KEY `gest_impegnato` (`gest_impegnato`),
  KEY `printed` (`printed`),
  KEY `codice_ordine` (`codice_ordine`),
  KEY `cash_back_erogato` (`cash_back_erogato`),
  KEY `hub_trasmesso` (`hub_trasmesso`),
  KEY `payment_intent` (`payment_intent`),
  KEY `vies_status` (`vies_status`),
  KEY `verifica_distribuzione_prodotti` (`verifica_distribuzione_prodotti`),
  KEY `numero_spedizioni` (`numero_spedizioni`),
  KEY `bit_notifica_1` (`bit_notifica_1`),
  KEY `bit_notifica_2` (`bit_notifica_2`),
  KEY `bit_notifica_3` (`bit_notifica_3`),
  KEY `bit_notifica_4` (`bit_notifica_4`),
  KEY `bit_notifica_5` (`bit_notifica_5`),
  KEY `bit_notifica_6` (`bit_notifica_6`),
  KEY `bit_notifica_7` (`bit_notifica_7`),
  KEY `bit_notifica_8` (`bit_notifica_8`),
  KEY `assicurazione` (`assicurazione`),
  KEY `market_iso` (`market_iso`),
  FULLTEXT KEY `Gruppo ricerca` (`email`,`num_oc`,`num_ft`,`tracking`)
) ENGINE=InnoDB AUTO_INCREMENT=5311 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_order_communications`
--

DROP TABLE IF EXISTS `e_order_communications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_order_communications` (
  `id_e_order_communications` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_order` int(255) NOT NULL,
  `id_type` int(1) NOT NULL,
  `id_template` int(1) NOT NULL,
  `language_iso` varchar(2) NOT NULL,
  `text` text NOT NULL,
  `status` int(1) NOT NULL,
  `data_insert` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `data_send` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id_e_order_communications`),
  KEY `id_e_order` (`id_e_order`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_order_gift_card_data`
--

DROP TABLE IF EXISTS `e_order_gift_card_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_order_gift_card_data` (
  `id_e_order_gift_card_data` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_order` int(255) NOT NULL,
  `id_e_user` int(255) NOT NULL,
  `id_e_products` int(255) NOT NULL,
  `id_e_products_models` int(255) NOT NULL,
  `da_nome` varchar(255) NOT NULL,
  `da_email` varchar(255) NOT NULL,
  `a_nome` varchar(255) NOT NULL,
  `a_email` varchar(255) NOT NULL,
  `messaggio` text NOT NULL,
  `id_template` int(10) NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`id_e_order_gift_card_data`),
  KEY `id_e_products` (`id_e_products`),
  KEY `id_e_products_models` (`id_e_products_models`),
  KEY `id_e_order` (`id_e_order`),
  KEY `id_e_user` (`id_e_user`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_order_indirizzi_spedizione`
--

DROP TABLE IF EXISTS `e_order_indirizzi_spedizione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_order_indirizzi_spedizione` (
  `id_e_order_indirizzi_spedizione` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_order` int(255) NOT NULL,
  `spe_nome` varchar(255) DEFAULT NULL,
  `spe_cognome` varchar(255) DEFAULT NULL,
  `spe_presso` varchar(255) DEFAULT NULL,
  `spe_telefono` varchar(255) DEFAULT NULL,
  `spe_indirizzo` varchar(255) DEFAULT NULL,
  `spe_num_civico` varchar(255) DEFAULT NULL,
  `spe_cap` varchar(10) DEFAULT NULL,
  `spe_citta` varchar(255) DEFAULT NULL,
  `spe_provincia` varchar(255) DEFAULT NULL,
  `spe_lat` varchar(20) DEFAULT NULL,
  `spe_lon` varchar(20) DEFAULT NULL,
  `spe_nazione` varchar(20) DEFAULT NULL,
  `data_inserimento` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_e_order_indirizzi_spedizione`),
  KEY `id_e_order` (`id_e_order`)
) ENGINE=InnoDB AUTO_INCREMENT=327 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_order_product`
--

DROP TABLE IF EXISTS `e_order_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_order_product` (
  `id_e_order_product` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_order` int(255) NOT NULL,
  `id_e_products` int(255) NOT NULL,
  `prezzo_unitario` float(10,2) NOT NULL,
  `prezzo_corrisposto_partner` float(10,2) NOT NULL,
  `quantita` int(255) NOT NULL,
  `prezzo_totale` float(10,2) NOT NULL,
  `id_e_products_models` varchar(255) NOT NULL,
  `data_consegna` bigint(20) NOT NULL,
  `peso` float(10,2) NOT NULL,
  `cash_back` float(10,2) NOT NULL,
  `costo_spedizione` float(10,2) NOT NULL,
  `pacco_regalo` int(11) NOT NULL,
  `prezzo_pacco_regalo` float(10,2) NOT NULL,
  `prezzo_corrisposto_partner_pacco_regalo` float(10,2) NOT NULL,
  `data_consegna_fine` bigint(20) NOT NULL,
  `stato_esistenza_prodotto` int(11) DEFAULT NULL COMMENT '0 = presente, 1 = non presente, 2 = in ordine al fornitore',
  `gest_impegnato` int(1) NOT NULL,
  `reso_attivo` int(1) NOT NULL,
  `richiesta_reso` int(11) NOT NULL DEFAULT '0',
  `plant_location` int(1) NOT NULL COMMENT 'identifica la logistica',
  `prezzo_unitario_or` float(10,2) NOT NULL,
  `sconto_totale` float(10,2) NOT NULL,
  PRIMARY KEY (`id_e_order_product`),
  KEY `id_ordine` (`id_e_order`),
  KEY `id_prodotto` (`id_e_products`),
  KEY `id_variazione` (`id_e_products_models`),
  KEY `quantita` (`quantita`),
  KEY `id_ordine_2` (`id_e_order`,`id_e_products`),
  KEY `gest_impegnato` (`gest_impegnato`),
  KEY `reso_attivo` (`reso_attivo`),
  KEY `richiesta_reso` (`richiesta_reso`),
  KEY `plant_location` (`plant_location`)
) ENGINE=InnoDB AUTO_INCREMENT=13753 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_order_return`
--

DROP TABLE IF EXISTS `e_order_return`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_order_return` (
  `id_e_order_return` int(255) NOT NULL AUTO_INCREMENT,
  `codice_reso` varchar(255) NOT NULL,
  `id_e_order` int(255) NOT NULL,
  `id_e_user` int(255) NOT NULL,
  `codice_ordine` varchar(255) NOT NULL,
  `id_e_products` int(255) NOT NULL,
  `id_e_products_models` int(255) NOT NULL,
  `data_acquisto` bigint(16) NOT NULL,
  `data_richiesta_reso` bigint(16) NOT NULL,
  `data_rimborso` bigint(16) NOT NULL,
  `prezzo_acquisto` float(10,2) NOT NULL,
  `qta_acquistata` int(255) NOT NULL,
  `qta_resa` int(255) NOT NULL,
  `valore_rimborso` float(10,2) NOT NULL,
  `id_metodo_rimborso` int(10) NOT NULL,
  `rimborsato` int(1) NOT NULL,
  `id_e_reso_causale` int(10) NOT NULL,
  `status` int(1) NOT NULL,
  `bit_notifica_4` int(1) NOT NULL DEFAULT '0',
  `bit_notifica_3` int(1) NOT NULL DEFAULT '0',
  `bit_notifica_2` int(1) NOT NULL DEFAULT '0',
  `bit_notifica_1` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_e_order_return`),
  KEY `id_e_order` (`id_e_order`),
  KEY `id_e_users` (`id_e_user`),
  KEY `id_e_products` (`id_e_products`),
  KEY `id_e_models` (`id_e_products_models`),
  KEY `id_e_products_2` (`id_e_products`,`id_e_products_models`),
  KEY `id_metodo_rimborso` (`id_metodo_rimborso`),
  KEY `rimborsato` (`rimborsato`),
  KEY `id_e_reso_causale` (`id_e_reso_causale`),
  KEY `status` (`status`),
  KEY `codice_reso` (`codice_reso`)
) ENGINE=InnoDB AUTO_INCREMENT=173 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_products`
--

DROP TABLE IF EXISTS `e_products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_products` (
  `id_e_products` int(255) NOT NULL AUTO_INCREMENT,
  `id_tipo` int(255) NOT NULL,
  `id_e_brands` int(255) NOT NULL,
  `codice` varchar(255) NOT NULL,
  `codice_old` varchar(255) NOT NULL,
  `codice_extra` varchar(255) DEFAULT NULL,
  `nome` varchar(255) NOT NULL,
  `descrizione` text NOT NULL,
  `prezzo_b2c` float(10,2) NOT NULL,
  `data_inizio` bigint(14) NOT NULL,
  `data_fine` bigint(14) NOT NULL,
  `data_ultima_modifica` varchar(255) NOT NULL,
  `id_operatore_ultima_modifica` int(11) NOT NULL,
  `quantita` int(255) NOT NULL,
  `costo_spedizione` float NOT NULL,
  `prezzo_listino` float(10,2) NOT NULL,
  `prezzo_acquisto` float(10,2) NOT NULL,
  `id_fornitore` int(255) NOT NULL,
  `pezzi_acquistabili` int(255) NOT NULL,
  `id_prodotto_gruppo` int(255) NOT NULL,
  `stato_spedizione` int(10) NOT NULL COMMENT '0 = spedizione durante offerta attiva, 1 = spedizione dopo scadenza offerta',
  `consegna_prodotto` int(255) NOT NULL,
  `tipo_prodotto` int(10) NOT NULL COMMENT '0 = prodotto fisico, 1 = prodotto virtuale',
  `metodi_pagamento` varchar(10) NOT NULL,
  `vendibile` tinyint(4) NOT NULL,
  `prenota` tinyint(4) NOT NULL,
  `gratis` tinyint(4) NOT NULL,
  `ciclico` int(11) NOT NULL,
  `durata_ciclo` bigint(20) NOT NULL,
  `scadenza_ciclo` varchar(255) NOT NULL,
  `data_inserimento` varchar(255) NOT NULL,
  `qta_minima_acquistabile` int(11) NOT NULL DEFAULT '1',
  `peso` float(10,2) NOT NULL,
  `cash_back` float(10,2) NOT NULL,
  `ordinamento` int(11) NOT NULL,
  `seo_title` text NOT NULL,
  `seo_description` text NOT NULL,
  `metodo_spedizione_default` int(10) NOT NULL,
  `pacco_regalo` int(11) NOT NULL,
  `prezzo_pacco_regalo` float(10,2) NOT NULL,
  `prezzo_corrisposto_partner_pacco_regalo` float(10,2) NOT NULL,
  `ean` varchar(16) NOT NULL,
  `prezzo_b2b` float(10,2) NOT NULL,
  `auto_price_reseller` int(1) NOT NULL DEFAULT '1' COMMENT 'se 1 il prezzo reseller viene calcolato in automatico',
  `made_in` varchar(255) DEFAULT NULL,
  `composizione` varchar(255) NOT NULL,
  `uomo` int(1) NOT NULL,
  `donna` int(1) NOT NULL,
  `bambino` int(1) NOT NULL,
  `bambina` int(1) NOT NULL,
  `primavera` int(1) NOT NULL,
  `estate` int(1) NOT NULL,
  `autunno` int(1) NOT NULL,
  `inverno` int(1) NOT NULL,
  `dimensioni` varchar(255) DEFAULT NULL,
  `order_logic` int(255) NOT NULL,
  `codice_fornitore` varchar(255) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  `check_integrity` varchar(255) DEFAULT NULL,
  `exclusion_check` int(16) NOT NULL,
  PRIMARY KEY (`id_e_products`),
  UNIQUE KEY `codice` (`codice`),
  KEY `data inizio` (`data_inizio`),
  KEY `data fine` (`data_fine`),
  KEY `nome` (`nome`),
  KEY `quantita` (`quantita`),
  KEY `id_fornitore` (`id_fornitore`),
  KEY `tipo_prodotto` (`tipo_prodotto`),
  KEY `id_prodotto_gruppo` (`id_prodotto_gruppo`),
  KEY `order_logic` (`order_logic`),
  KEY `status` (`status`),
  KEY `id_e_brands` (`id_e_brands`),
  KEY `exclusion_check` (`exclusion_check`)
) ENGINE=InnoDB AUTO_INCREMENT=21668 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_products_category`
--

DROP TABLE IF EXISTS `e_products_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_products_category` (
  `id_e_products_category` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_products` int(255) NOT NULL,
  `id_category_list` int(11) NOT NULL,
  PRIMARY KEY (`id_e_products_category`),
  KEY `id_prodotto` (`id_e_products`),
  KEY `id_categoria_multilivello` (`id_category_list`)
) ENGINE=InnoDB AUTO_INCREMENT=43335 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_products_foto`
--

DROP TABLE IF EXISTS `e_products_foto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_products_foto` (
  `id_e_products_foto` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_products` int(255) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `ordine` int(255) NOT NULL,
  `file_foto` text NOT NULL,
  `tipo` tinyint(4) NOT NULL,
  `file_foto_json` text NOT NULL,
  PRIMARY KEY (`id_e_products_foto`),
  KEY `id_prodotto` (`id_e_products`),
  KEY `tipo` (`tipo`),
  KEY `id_prodotto_2` (`id_e_products`,`tipo`),
  KEY `ordine` (`ordine`)
) ENGINE=InnoDB AUTO_INCREMENT=59438 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_products_groups`
--

DROP TABLE IF EXISTS `e_products_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_products_groups` (
  `nome_groups` varchar(255) NOT NULL,
  `id_e_products` int(255) NOT NULL,
  PRIMARY KEY (`nome_groups`,`id_e_products`),
  KEY `nome_groups` (`nome_groups`),
  KEY `id_e_products` (`id_e_products`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_products_models`
--

DROP TABLE IF EXISTS `e_products_models`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_products_models` (
  `id_e_products_models` int(11) NOT NULL AUTO_INCREMENT,
  `id_e_products` int(10) NOT NULL,
  `codice` varchar(255) NOT NULL,
  `codice_old` varchar(255) NOT NULL,
  `codice_extra` varchar(255) DEFAULT NULL,
  `id_attributo` varchar(255) NOT NULL,
  `id_campagna` int(11) NOT NULL,
  `prezzo_listino` float(10,2) NOT NULL,
  `prezzo_b2c` float(10,2) NOT NULL,
  `prezzo_acquisto` float(10,2) NOT NULL,
  `quantita` int(10) NOT NULL,
  `id_attributo_1` int(255) NOT NULL,
  `id_attributo_2` int(255) NOT NULL,
  `id_attributo_3` int(255) NOT NULL,
  `id_attributo_4` int(255) NOT NULL,
  `id_attributo_5` int(255) NOT NULL,
  `peso` float(10,2) NOT NULL,
  `cash_back` float(10,2) NOT NULL,
  `prenota` tinyint(4) NOT NULL,
  `condizioni_prenota` text NOT NULL,
  `id_taglia` int(255) NOT NULL,
  `valore_taglia` varchar(255) DEFAULT NULL,
  `ean` varchar(50) NOT NULL,
  `prezzo_b2b` float(10,2) NOT NULL,
  `codice_fornitore` varchar(255) NOT NULL,
  `time_check` bigint(15) DEFAULT '0',
  `check_integrity` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_e_products_models`),
  UNIQUE KEY `e_products_models_pk` (`codice`,`ean`),
  KEY `id_attributo_1` (`id_attributo_1`),
  KEY `id_attributo_2` (`id_attributo_2`),
  KEY `id_attributo_3` (`id_attributo_3`),
  KEY `id_attributo_4` (`id_attributo_4`),
  KEY `id_attributo_5` (`id_attributo_5`),
  KEY `id_attributo_1_2` (`id_attributo_1`,`id_attributo_2`,`id_attributo_3`,`id_attributo_4`,`id_attributo_5`),
  KEY `id_prodotto_2` (`id_e_products`),
  KEY `id_attributo` (`id_attributo`),
  KEY `id_prodotto_3` (`id_e_products`,`id_attributo`),
  KEY `id_prodotto` (`id_e_products`),
  KEY `codice` (`codice`),
  KEY `id_campagna` (`id_campagna`),
  KEY `time_check` (`time_check`),
  KEY `ean` (`ean`)
) ENGINE=InnoDB AUTO_INCREMENT=87612 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_products_models_price_rules`
--

DROP TABLE IF EXISTS `e_products_models_price_rules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_products_models_price_rules` (
  `id_e_products_models_price_rules` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_products` int(255) DEFAULT NULL,
  `id_e_product_model` int(255) DEFAULT NULL,
  `sku` varchar(255) NOT NULL,
  `ean` varchar(20) NOT NULL,
  `rules_name` varchar(255) NOT NULL,
  `rules_type` int(10) NOT NULL DEFAULT '1',
  `prezzo_listino` float(10,2) DEFAULT NULL,
  `prezzo_b2c` float(10,2) DEFAULT NULL,
  `prezzo_acquisto` float(10,2) DEFAULT NULL,
  `prezzo_b2b` float(10,2) DEFAULT NULL,
  `data_start` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `data_stop` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_e_products_models_price_rules`),
  KEY `id_e_products` (`id_e_products`),
  KEY `id_e_product_model` (`id_e_product_model`),
  KEY `id_e_products_2` (`id_e_products`,`id_e_product_model`),
  KEY `ean` (`ean`),
  KEY `rules_type` (`rules_type`),
  KEY `rules_name` (`rules_name`),
  KEY `status` (`status`),
  KEY `data_start` (`data_start`,`data_stop`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_products_preferito`
--

DROP TABLE IF EXISTS `e_products_preferito`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_products_preferito` (
  `id_e_products_preferito` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_user` int(255) NOT NULL,
  `id_e_products` int(255) NOT NULL,
  `notifica` int(1) NOT NULL DEFAULT '0',
  `data_aggiunta` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_e_products_preferito`),
  KEY `id_prodotto` (`id_e_products`),
  KEY `id_utente` (`id_e_user`)
) ENGINE=InnoDB AUTO_INCREMENT=26835 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_products_price_rules`
--

DROP TABLE IF EXISTS `e_products_price_rules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_products_price_rules` (
  `id_e_products_price_rules` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_products` int(255) NOT NULL,
  `sku` varchar(255) NOT NULL,
  `rules_name` varchar(255) NOT NULL,
  `rules_type` int(10) NOT NULL,
  `prezzo_listino` float(10,2) NOT NULL,
  `prezzo_b2c` float(10,2) NOT NULL,
  `prezzo_acquisto` float(10,2) NOT NULL,
  `prezzo_b2b` float(10,2) NOT NULL,
  `data_start` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `data_stop` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(1) NOT NULL,
  PRIMARY KEY (`id_e_products_price_rules`),
  KEY `id_e_products` (`id_e_products`),
  KEY `rules_name` (`rules_name`),
  KEY `rules_type` (`rules_type`),
  KEY `data_start` (`data_start`,`data_stop`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_products_subscription`
--

DROP TABLE IF EXISTS `e_products_subscription`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_products_subscription` (
  `id_e_products_subscription` int(255) NOT NULL AUTO_INCREMENT,
  `sku` varchar(100) NOT NULL,
  `ean` varchar(100) NOT NULL,
  `descrizione` varchar(255) NOT NULL,
  `giorni_durata` int(10) NOT NULL,
  PRIMARY KEY (`id_e_products_subscription`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_products_translate`
--

DROP TABLE IF EXISTS `e_products_translate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_products_translate` (
  `id_e_products_translate` int(255) NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL,
  `value` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `language_iso` varchar(2) NOT NULL,
  `id_e_products` int(255) NOT NULL,
  PRIMARY KEY (`id_e_products_translate`),
  KEY `id_e_products` (`id_e_products`),
  KEY `language_iso` (`language_iso`,`id_e_products`),
  KEY `type` (`type`,`language_iso`,`id_e_products`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_produtcs_colors`
--

DROP TABLE IF EXISTS `e_produtcs_colors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_produtcs_colors` (
  `id_e_produtcs_colors` int(11) NOT NULL AUTO_INCREMENT,
  `id_e_products` int(11) NOT NULL,
  `id_e_colors` int(11) NOT NULL,
  PRIMARY KEY (`id_e_produtcs_colors`),
  KEY `id_prodotto` (`id_e_products`),
  KEY `id_colore` (`id_e_colors`)
) ENGINE=InnoDB AUTO_INCREMENT=21668 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_record_contabili`
--

DROP TABLE IF EXISTS `e_record_contabili`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_record_contabili` (
  `id_e_record_contabile` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_user` int(255) NOT NULL,
  `denominazione` varchar(255) DEFAULT NULL,
  `indirizzo` varchar(255) DEFAULT NULL,
  `cap` varchar(10) DEFAULT NULL,
  `citta` varchar(255) DEFAULT NULL,
  `country` varchar(2) DEFAULT NULL,
  `vat` varchar(20) DEFAULT NULL,
  `sdi` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `file_name` varchar(255) NOT NULL,
  `data_record` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `numero_documento` varchar(100) NOT NULL,
  `data_documento` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `notifica_1` int(1) NOT NULL,
  `totale_documento` float(10,2) NOT NULL,
  PRIMARY KEY (`id_e_record_contabile`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_record_contabili_associati`
--

DROP TABLE IF EXISTS `e_record_contabili_associati`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_record_contabili_associati` (
  `id_e_record_contabili_associati` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_record_contabili` int(255) NOT NULL,
  `tipo_record` varchar(20) NOT NULL,
  `valore_record` varchar(255) NOT NULL,
  PRIMARY KEY (`id_e_record_contabili_associati`),
  KEY `tipo_record` (`tipo_record`),
  KEY `valore_record` (`valore_record`),
  KEY `id_e_record_contabili` (`id_e_record_contabili`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_redirect`
--

DROP TABLE IF EXISTS `e_redirect`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_redirect` (
  `id_e_redirect` int(255) NOT NULL AUTO_INCREMENT,
  `url_origine` varchar(255) NOT NULL,
  `url_destinazione` varchar(255) NOT NULL,
  `tipo_redirect` int(10) DEFAULT '301',
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_e_redirect`),
  KEY `url_origine` (`url_origine`)
) ENGINE=InnoDB AUTO_INCREMENT=31492 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_replace_data_onoff`
--

DROP TABLE IF EXISTS `e_replace_data_onoff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_replace_data_onoff` (
  `id_e_replace_data_onoff` int(255) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` int(10) NOT NULL,
  `d_table` varchar(255) NOT NULL,
  `d_key` varchar(255) NOT NULL,
  `d_key_value` int(255) NOT NULL,
  `d_field` varchar(255) NOT NULL,
  `from` varchar(255) NOT NULL,
  `to` varchar(255) NOT NULL,
  `start_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `stop_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(10) NOT NULL,
  PRIMARY KEY (`id_e_replace_data_onoff`),
  UNIQUE KEY `code_2` (`code`,`type`,`d_key_value`,`start_date`,`stop_date`,`status`),
  KEY `code` (`code`),
  KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_reso_causali`
--

DROP TABLE IF EXISTS `e_reso_causali`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_reso_causali` (
  `id_e_reso_causale` int(255) NOT NULL AUTO_INCREMENT,
  `causale` varchar(255) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_e_reso_causale`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_sconto`
--

DROP TABLE IF EXISTS `e_sconto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_sconto` (
  `id_e_sconto` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_user` int(255) DEFAULT NULL,
  `id_e_products` int(255) DEFAULT NULL,
  `codice_sconto` varchar(255) NOT NULL,
  `sconto` float(10,2) NOT NULL,
  `tipo_sconto` varchar(4) NOT NULL COMMENT '1 fisso, 2 %',
  `max` int(11) DEFAULT NULL,
  `data_start` timestamp NULL DEFAULT NULL,
  `data_stop` timestamp NULL DEFAULT NULL,
  `acquisto_minimo` int(11) DEFAULT NULL,
  `modalita_sconto` int(1) NOT NULL DEFAULT '1' COMMENT '1 limitato , 2 tutto',
  PRIMARY KEY (`id_e_sconto`),
  KEY `id_utente` (`id_e_user`),
  KEY `id_prodotto` (`id_e_products`),
  KEY `codice_sconto` (`codice_sconto`),
  KEY `data_fine` (`data_stop`),
  KEY `acquisto_minimo` (`acquisto_minimo`),
  KEY `sconto` (`sconto`)
) ENGINE=InnoDB AUTO_INCREMENT=14678 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_session`
--

DROP TABLE IF EXISTS `e_session`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_session` (
  `id_e_session` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `session` varchar(255) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id_e_session`),
  KEY `session` (`session`)
) ENGINE=InnoDB AUTO_INCREMENT=5073640 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_status_value`
--

DROP TABLE IF EXISTS `e_status_value`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_status_value` (
  `id` int(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_stockout_utility_log`
--

DROP TABLE IF EXISTS `e_stockout_utility_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_stockout_utility_log` (
  `id_e_stockout_utility_log` int(255) NOT NULL AUTO_INCREMENT,
  `session` varchar(255) NOT NULL,
  `id_e_products` int(255) NOT NULL,
  `id_e_products_models` int(255) NOT NULL,
  `quantita_carrello` int(255) NOT NULL,
  `quantita_gest` int(255) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sku_model` varchar(255) NOT NULL,
  `ean` varchar(255) NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`id_e_stockout_utility_log`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_survey_questions`
--

DROP TABLE IF EXISTS `e_survey_questions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_survey_questions` (
  `id_e_survey_questions` int(255) NOT NULL AUTO_INCREMENT,
  `domanda` varchar(255) NOT NULL,
  `descrizione` text NOT NULL,
  `tipo_risposta` int(1) NOT NULL,
  `step` int(2) NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`id_e_survey_questions`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_survey_response`
--

DROP TABLE IF EXISTS `e_survey_response`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_survey_response` (
  `id_e_survey_response` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_survey_questions` int(255) NOT NULL,
  `risposta` text NOT NULL,
  `data` datetime NOT NULL,
  `tipo_risposta` int(11) NOT NULL,
  `riferimento` varchar(255) NOT NULL,
  `notifica_1` int(1) NOT NULL,
  PRIMARY KEY (`id_e_survey_response`),
  KEY `id_e_survey_questions` (`id_e_survey_questions`),
  KEY `notifica_1` (`notifica_1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_taglia`
--

DROP TABLE IF EXISTS `e_taglia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_taglia` (
  `id_e_taglia` int(255) NOT NULL AUTO_INCREMENT,
  `nome` varchar(255) NOT NULL,
  `ordinamento` int(11) NOT NULL,
  `id_e_taglia_gruppo` int(255) NOT NULL,
  PRIMARY KEY (`id_e_taglia`),
  KEY `taglia` (`nome`),
  KEY `ordinamento` (`ordinamento`),
  KEY `grupppo` (`id_e_taglia_gruppo`)
) ENGINE=InnoDB AUTO_INCREMENT=490 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_taglia_gruppo`
--

DROP TABLE IF EXISTS `e_taglia_gruppo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_taglia_gruppo` (
  `id_e_taglia_gruppo` int(255) NOT NULL AUTO_INCREMENT,
  `codice` varchar(10) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `stato` int(1) NOT NULL,
  PRIMARY KEY (`id_e_taglia_gruppo`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_text_category`
--

DROP TABLE IF EXISTS `e_text_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_text_category` (
  `id_e_text_category` int(255) NOT NULL AUTO_INCREMENT,
  `gender` int(1) NOT NULL DEFAULT '0',
  `id_e_category` int(25) NOT NULL DEFAULT '0',
  `html` text NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_e_text_category`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_user`
--

DROP TABLE IF EXISTS `e_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_user` (
  `id_e_user` int(255) NOT NULL AUTO_INCREMENT,
  `cid` text NOT NULL,
  `id_padre` int(255) NOT NULL,
  `id_stato` int(255) NOT NULL,
  `id_promozione` int(255) NOT NULL,
  `id_socio` int(255) NOT NULL,
  `id_sessione` varchar(255) NOT NULL,
  `id_facebook` varchar(255) NOT NULL,
  `id_google_plus` varchar(255) NOT NULL,
  `id_linkedin` varchar(255) NOT NULL,
  `id_twitter` varchar(255) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `cognome` varchar(255) NOT NULL,
  `sesso` varchar(1) DEFAULT NULL,
  `data_nascita` date DEFAULT NULL,
  `data_registrazione` bigint(14) NOT NULL,
  `cellulare` varchar(20) NOT NULL,
  `company` varchar(255) NOT NULL,
  `vat_number` varchar(255) NOT NULL,
  `country` varchar(10) NOT NULL,
  `mail` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `ultimo_accesso` bigint(14) NOT NULL,
  `sconto_assegnato` float(10,2) NOT NULL DEFAULT '5.00',
  `id_reklame` varchar(255) NOT NULL,
  `pagamenti_accettati` varchar(255) NOT NULL DEFAULT '1111',
  `id_gruppo` int(11) NOT NULL,
  `classe_cliente` int(11) NOT NULL,
  `tipo_newsletter` varchar(10) NOT NULL DEFAULT '1111111111' COMMENT '1°: newsletter shopping giornaliera - 2°: newsletter viaggi giornaliera - 3°: newslettere shopping settimanale - 4°: newsletter viaggi settimanale',
  `status_utente` int(1) NOT NULL DEFAULT '1' COMMENT '1°: utenti confermati in double optin - 2°: utenti sospesi - 3°: social_sharing non chiedermelo più, 4°: single optin ricevuto',
  `data_cancellazione` bigint(14) NOT NULL,
  `privacy` text,
  `numero_ordini` int(11) NOT NULL,
  `numero_resi` int(11) NOT NULL,
  `sorgente` tinyint(4) NOT NULL,
  `data_ultimo_ordine` bigint(14) NOT NULL,
  `cap` varchar(5) NOT NULL,
  `salva_ricerca` int(1) NOT NULL,
  `reseller` tinyint(4) NOT NULL,
  `reseller_attivo` tinyint(4) NOT NULL,
  `no_iva` int(1) NOT NULL DEFAULT '0',
  `dropshipper` int(1) NOT NULL,
  `note_private` text NOT NULL,
  `fe_codice_destinatario` varchar(20) NOT NULL,
  `fe_pec` varchar(256) NOT NULL,
  `profilo_frequenza_nl` int(10) NOT NULL,
  `profilo_frequenza_nl_ultimo_aggiornamento` bigint(16) NOT NULL,
  `bit_notifica_doubleoptin` varchar(10) NOT NULL DEFAULT '00000',
  `cancellato_dem` int(1) NOT NULL,
  `bit_notifica_mailup` int(1) DEFAULT '0',
  `language_iso` varchar(3) NOT NULL DEFAULT '1',
  `data_invio_mailup` timestamp NULL DEFAULT NULL,
  `data_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `source_tag` varchar(100) NOT NULL,
  `platform` varchar(100) DEFAULT NULL,
  `app_version` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id_e_user`),
  KEY `mail` (`mail`),
  KEY `id_gruppo` (`id_gruppo`),
  KEY `id_stato` (`id_stato`),
  KEY `id_sessione` (`id_sessione`),
  KEY `id_facebook` (`id_facebook`),
  KEY `id_google_plus` (`id_google_plus`),
  KEY `data_nascita` (`data_nascita`),
  KEY `password` (`password`),
  KEY `cancellato_dem` (`cancellato_dem`),
  KEY `nome` (`nome`),
  KEY `source_tag` (`source_tag`),
  KEY `numero_ordini` (`numero_ordini`),
  KEY `classe_cliente` (`classe_cliente`),
  FULLTEXT KEY `Email per ricerca` (`mail`)
) ENGINE=InnoDB AUTO_INCREMENT=14679 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_user_custom_shipment_cost`
--

DROP TABLE IF EXISTS `e_user_custom_shipment_cost`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_user_custom_shipment_cost` (
  `id_e_user` int(255) NOT NULL,
  `type` int(11) NOT NULL COMMENT '1 = incremento fisso, 2 = incremento per collo, 3 = spedizione fissa',
  `value` float(10,2) NOT NULL,
  PRIMARY KEY (`id_e_user`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_user_fatturazione`
--

DROP TABLE IF EXISTS `e_user_fatturazione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_user_fatturazione` (
  `id_e_user_fatturazione` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_user` int(255) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `cognome` varchar(255) NOT NULL,
  `rag_sociale` varchar(255) NOT NULL,
  `pi` varchar(13) NOT NULL,
  `cf` varchar(16) NOT NULL,
  `indirizzo` varchar(255) NOT NULL,
  `num_civico` varchar(20) NOT NULL,
  `cap` varchar(10) NOT NULL,
  `citta` varchar(255) NOT NULL,
  `provincia` varchar(2) NOT NULL,
  `nazione` varchar(255) NOT NULL DEFAULT 'ITALIA',
  `lat` varchar(10) DEFAULT NULL,
  `lon` varchar(10) DEFAULT NULL,
  `telefono` varchar(20) NOT NULL,
  `fattura_richiesta` tinyint(4) NOT NULL,
  `fe_codice_destinatario` varchar(50) NOT NULL,
  `fe_pec` varchar(256) NOT NULL,
  `preferito` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_e_user_fatturazione`),
  KEY `id_utente` (`id_e_user`)
) ENGINE=InnoDB AUTO_INCREMENT=4076 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_user_grups`
--

DROP TABLE IF EXISTS `e_user_grups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_user_grups` (
  `id_e_user_grups` int(10) NOT NULL AUTO_INCREMENT,
  `nome` varchar(255) NOT NULL,
  `descrizione` varchar(255) NOT NULL,
  PRIMARY KEY (`id_e_user_grups`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_user_import_list`
--

DROP TABLE IF EXISTS `e_user_import_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_user_import_list` (
  `id_e_user_import_list` int(255) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `data_insert` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sorgente` varchar(10) NOT NULL,
  `batch_number` varchar(100) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id_e_user_import_list`),
  KEY `email` (`email`),
  KEY `sorgente` (`sorgente`),
  KEY `status` (`status`),
  KEY `batch_number` (`batch_number`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_user_payment_info`
--

DROP TABLE IF EXISTS `e_user_payment_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_user_payment_info` (
  `id_e_user_payment_info` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_user` int(255) NOT NULL,
  `id_pagamento` int(255) NOT NULL,
  `info_obj` text NOT NULL,
  PRIMARY KEY (`id_e_user_payment_info`),
  KEY `id_e_user` (`id_e_user`),
  KEY `id_e_user_2` (`id_e_user`,`id_pagamento`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_user_products_notify`
--

DROP TABLE IF EXISTS `e_user_products_notify`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_user_products_notify` (
  `id_e_user_products_notify` int(255) NOT NULL AUTO_INCREMENT,
  `type` int(1) NOT NULL,
  `id_e_user` int(255) NOT NULL,
  `id_e_products` int(255) NOT NULL,
  `id_e_products_models` int(255) NOT NULL,
  `date_insert` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `status` int(1) NOT NULL,
  `bit_notify_1` int(1) NOT NULL COMMENT 'notifica avvenuta iscrizione',
  `bit_notify_2` int(1) NOT NULL COMMENT 'notifica evento associato',
  PRIMARY KEY (`id_e_user_products_notify`),
  KEY `id_e_user` (`id_e_user`),
  KEY `id_e_products` (`id_e_products`,`id_e_products_models`),
  KEY `id_e_user_2` (`id_e_user`,`id_e_products`,`id_e_products_models`),
  KEY `status` (`status`),
  KEY `bit_notify_1` (`bit_notify_1`),
  KEY `bit_notify_2` (`bit_notify_2`),
  KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_user_spedizione`
--

DROP TABLE IF EXISTS `e_user_spedizione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_user_spedizione` (
  `id_e_user_spedizione` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_utente` int(255) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `cognome` varchar(255) NOT NULL,
  `presso` varchar(255) NOT NULL,
  `telefono` varchar(20) NOT NULL,
  `indirizzo` varchar(255) NOT NULL,
  `num_civico` varchar(20) NOT NULL,
  `cap` varchar(10) NOT NULL,
  `citta` varchar(255) NOT NULL,
  `provincia` varchar(2) NOT NULL,
  `nazione` varchar(255) NOT NULL DEFAULT 'ITALIA',
  `lat` varchar(10) DEFAULT NULL,
  `lon` varchar(10) DEFAULT NULL,
  `preferito` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_e_user_spedizione`),
  KEY `id_utente` (`id_e_utente`)
) ENGINE=InnoDB AUTO_INCREMENT=6460 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_user_subscription`
--

DROP TABLE IF EXISTS `e_user_subscription`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `e_user_subscription` (
  `id_ e_user_subscription` int(255) NOT NULL AUTO_INCREMENT,
  `id_e_user` int(255) NOT NULL,
  `record_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `subscription_type` int(5) NOT NULL,
  `start_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `stop_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id_ e_user_subscription`),
  KEY `id_e_user` (`id_e_user`),
  KEY `subscription_type` (`subscription_type`),
  KEY `start_date` (`start_date`),
  KEY `stop_date` (`stop_date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `form`
--

DROP TABLE IF EXISTS `form`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `form` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `table_name` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `form_custom_attribute`
--

DROP TABLE IF EXISTS `form_custom_attribute`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `form_custom_attribute` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `form_field_id` int(11) NOT NULL,
  `form_id` int(11) NOT NULL,
  `attribute_value` text NOT NULL,
  `attribute_label` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `form_custom_option`
--

DROP TABLE IF EXISTS `form_custom_option`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `form_custom_option` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `form_field_id` int(11) NOT NULL,
  `form_id` int(11) NOT NULL,
  `option_value` text NOT NULL,
  `option_label` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `form_field`
--

DROP TABLE IF EXISTS `form_field`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `form_field` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL,
  `field_name` varchar(200) NOT NULL,
  `input_type` varchar(200) NOT NULL,
  `field_label` varchar(200) DEFAULT NULL,
  `placeholder` text,
  `auto_generate_help_block` varchar(10) DEFAULT NULL,
  `help_block` text,
  `relation_table` varchar(200) DEFAULT NULL,
  `relation_value` varchar(200) DEFAULT NULL,
  `relation_label` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `form_field_validation`
--

DROP TABLE IF EXISTS `form_field_validation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `form_field_validation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `form_field_id` int(11) NOT NULL,
  `form_id` int(11) NOT NULL,
  `validation_name` varchar(200) NOT NULL,
  `validation_value` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `gest_data`
--

DROP TABLE IF EXISTS `gest_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gest_data` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `barcodeint` varchar(255) DEFAULT NULL,
  `barcode` varchar(255) DEFAULT NULL,
  `barcodeartcol` varchar(255) DEFAULT NULL,
  `anno` varchar(255) DEFAULT NULL,
  `artcod` varchar(255) DEFAULT NULL,
  `colorecod` varchar(255) DEFAULT NULL,
  `coloredes` varchar(255) DEFAULT NULL,
  `colorecodforn` varchar(255) DEFAULT NULL,
  `artdes` text,
  `codicepadre` varchar(255) DEFAULT NULL,
  `taglia` varchar(255) DEFAULT NULL,
  `postg` varchar(255) DEFAULT NULL,
  `brandcod` varchar(255) DEFAULT NULL,
  `branddes` varchar(255) DEFAULT NULL,
  `sessocod` varchar(255) DEFAULT NULL,
  `sessodes` varchar(255) DEFAULT NULL,
  `supercategoriacod` varchar(255) DEFAULT NULL,
  `supercategoriades` varchar(255) DEFAULT NULL,
  `categoriacod` varchar(255) DEFAULT NULL,
  `categoriades` varchar(255) DEFAULT NULL,
  `subcategoriacod` varchar(255) DEFAULT NULL,
  `subcategoriades` varchar(255) DEFAULT NULL,
  `stagione` varchar(255) DEFAULT NULL,
  `qta` varchar(255) DEFAULT NULL,
  `foto1` varchar(255) DEFAULT NULL,
  `foto2` varchar(255) DEFAULT NULL,
  `foto3` varchar(255) DEFAULT NULL,
  `foto4` varchar(255) DEFAULT NULL,
  `foto5` varchar(255) DEFAULT NULL,
  `foto6` varchar(255) DEFAULT NULL,
  `artdeslen1` text,
  `artdeslen2` varchar(255) DEFAULT NULL,
  `artdeslen3` varchar(255) DEFAULT NULL,
  `artdeslen4` varchar(255) DEFAULT NULL,
  `artdeslen5` varchar(255) DEFAULT NULL,
  `artdeslen6` varchar(255) DEFAULT NULL,
  `artdeslen7` varchar(255) DEFAULT NULL,
  `artdeslen8` varchar(255) DEFAULT NULL,
  `composizione` varchar(255) DEFAULT NULL,
  `madein` varchar(255) DEFAULT NULL,
  `coloredeslen1` varchar(255) DEFAULT NULL,
  `coloredeslen2` varchar(255) DEFAULT NULL,
  `coloredeslen3` varchar(255) DEFAULT NULL,
  `coloredeslen4` varchar(255) DEFAULT NULL,
  `prz1ingr` varchar(255) DEFAULT NULL,
  `prz2listino` varchar(255) DEFAULT NULL,
  `prz3web` varchar(255) DEFAULT NULL,
  `prz4negozio` varchar(255) DEFAULT NULL,
  `prz5` varchar(255) DEFAULT NULL,
  `prz6` varchar(255) DEFAULT NULL,
  `prz7` varchar(255) DEFAULT NULL,
  `prz8` varchar(255) DEFAULT NULL,
  `prz9` varchar(255) DEFAULT NULL,
  `prz10` varchar(255) DEFAULT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `ebay` varchar(255) DEFAULT NULL,
  `amazon` varchar(255) DEFAULT NULL,
  `scalataglia` varchar(255) DEFAULT NULL,
  `peso` varchar(255) DEFAULT NULL,
  `tipocolore` varchar(255) DEFAULT NULL,
  `epcprodotto` varchar(255) DEFAULT NULL,
  `rovinati` varchar(255) DEFAULT NULL,
  `przacquisto` varchar(255) DEFAULT NULL,
  `seriali` text,
  `dimensionel` varchar(255) DEFAULT NULL,
  `dimensionep` varchar(255) DEFAULT NULL,
  `dimensionea` varchar(255) DEFAULT NULL,
  `data_inserimento` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `id_fornitore` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `gest_data_disp`
--

DROP TABLE IF EXISTS `gest_data_disp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gest_data_disp` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `barcodeint` varchar(255) DEFAULT NULL,
  `barcode` varchar(255) DEFAULT NULL,
  `artcod` varchar(255) DEFAULT NULL,
  `colorecod` varchar(255) DEFAULT NULL,
  `coloredes` varchar(255) DEFAULT NULL,
  `colorecodforn` varchar(255) DEFAULT NULL,
  `qta` varchar(255) DEFAULT NULL,
  `prz1ingr` varchar(255) DEFAULT NULL,
  `prz2listino` varchar(255) DEFAULT NULL,
  `prz3web` varchar(255) DEFAULT NULL,
  `prz4negozio` varchar(255) DEFAULT NULL,
  `przacquisto` varchar(255) NOT NULL,
  `taglia` varchar(255) NOT NULL,
  `id_fornitore` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `gsped_status`
--

DROP TABLE IF EXISTS `gsped_status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gsped_status` (
  `id` decimal(4,1) DEFAULT NULL,
  `status` varchar(59) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `gsped_status_log`
--

DROP TABLE IF EXISTS `gsped_status_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gsped_status_log` (
  `id_gsped_status_log` int(11) NOT NULL AUTO_INCREMENT,
  `status_code` int(10) NOT NULL,
  `status` varchar(255) NOT NULL,
  `delivery_date` datetime NOT NULL,
  `fid_partenza` varchar(10) NOT NULL,
  `num_serie` varchar(255) NOT NULL,
  `num_spedizione` varchar(255) NOT NULL,
  `corriere_id` int(10) NOT NULL,
  `corriere` varchar(255) NOT NULL,
  `ddt_num` varchar(150) NOT NULL,
  `ddt_alpha` varchar(150) NOT NULL,
  `client_id` int(10) NOT NULL,
  `tracking_link` varchar(255) NOT NULL,
  PRIMARY KEY (`id_gsped_status_log`),
  KEY `status_code` (`status_code`),
  KEY `ddt_alpha` (`ddt_alpha`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `keys`
--

DROP TABLE IF EXISTS `keys`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `keys` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `key` varchar(40) NOT NULL,
  `level` int(11) NOT NULL,
  `ignore_limits` tinyint(1) NOT NULL,
  `is_private_key` tinyint(1) NOT NULL,
  `ip_addresses` text,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `menu`
--

DROP TABLE IF EXISTS `menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(200) DEFAULT NULL,
  `type` varchar(200) DEFAULT NULL,
  `icon_color` varchar(200) DEFAULT NULL,
  `link` varchar(200) DEFAULT NULL,
  `sort` int(11) NOT NULL,
  `parent` int(11) NOT NULL,
  `icon` varchar(50) DEFAULT NULL,
  `menu_type_id` int(11) NOT NULL,
  `active` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `menu_type`
--

DROP TABLE IF EXISTS `menu_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menu_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `definition` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `version` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oauth_access_tokens`
--

DROP TABLE IF EXISTS `oauth_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_access_tokens` (
  `access_token` varchar(40) NOT NULL,
  `client_id` varchar(80) NOT NULL,
  `user_id` varchar(80) DEFAULT NULL,
  `expires` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `scope` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`access_token`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oauth_authorization_codes`
--

DROP TABLE IF EXISTS `oauth_authorization_codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_authorization_codes` (
  `authorization_code` varchar(40) NOT NULL,
  `client_id` varchar(80) NOT NULL,
  `user_id` varchar(80) DEFAULT NULL,
  `redirect_uri` varchar(2000) DEFAULT NULL,
  `expires` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `scope` varchar(4000) DEFAULT NULL,
  `id_token` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`authorization_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oauth_clients`
--

DROP TABLE IF EXISTS `oauth_clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_clients` (
  `client_id` varchar(80) NOT NULL,
  `client_secret` varchar(80) DEFAULT NULL,
  `redirect_uri` varchar(2000) DEFAULT NULL,
  `grant_types` varchar(80) DEFAULT NULL,
  `scope` varchar(4000) DEFAULT NULL,
  `user_id` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oauth_jwt`
--

DROP TABLE IF EXISTS `oauth_jwt`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_jwt` (
  `client_id` varchar(80) NOT NULL,
  `subject` varchar(80) DEFAULT NULL,
  `public_key` varchar(2000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oauth_refresh_tokens`
--

DROP TABLE IF EXISTS `oauth_refresh_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_refresh_tokens` (
  `refresh_token` varchar(40) NOT NULL,
  `client_id` varchar(80) NOT NULL,
  `user_id` varchar(80) DEFAULT NULL,
  `expires` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `scope` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`refresh_token`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oauth_scopes`
--

DROP TABLE IF EXISTS `oauth_scopes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_scopes` (
  `scope` varchar(80) NOT NULL,
  `is_default` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`scope`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `oauth_users`
--

DROP TABLE IF EXISTS `oauth_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_users` (
  `username` varchar(80) NOT NULL,
  `password` varchar(80) DEFAULT NULL,
  `first_name` varchar(80) DEFAULT NULL,
  `last_name` varchar(80) DEFAULT NULL,
  `email` varchar(80) DEFAULT NULL,
  `email_verified` tinyint(1) DEFAULT NULL,
  `scope` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `page`
--

DROP TABLE IF EXISTS `page`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `page` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `type` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `fresh_content` text NOT NULL,
  `keyword` text,
  `description` text,
  `link` varchar(200) DEFAULT NULL,
  `template` varchar(200) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `page_block_element`
--

DROP TABLE IF EXISTS `page_block_element`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `page_block_element` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_name` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `image_preview` varchar(200) NOT NULL,
  `block_name` varchar(200) NOT NULL,
  `content_type` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `products_exclusion`
--

DROP TABLE IF EXISTS `products_exclusion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `products_exclusion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_e_brand` int(255) DEFAULT NULL,
  `id_category_list` int(11) DEFAULT NULL,
  `sku` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `exclusion_index` (`id_e_brand`,`id_category_list`,`sku`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rest`
--

DROP TABLE IF EXISTS `rest`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rest` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `subject` varchar(200) NOT NULL,
  `table_name` varchar(200) NOT NULL,
  `primary_key` varchar(200) NOT NULL,
  `x_api_key` varchar(20) DEFAULT NULL,
  `x_token` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rest_field`
--

DROP TABLE IF EXISTS `rest_field`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rest_field` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rest_id` int(11) NOT NULL,
  `field_name` varchar(200) NOT NULL,
  `field_label` varchar(200) DEFAULT NULL,
  `input_type` varchar(200) NOT NULL,
  `show_column` varchar(10) DEFAULT NULL,
  `show_add_api` varchar(10) DEFAULT NULL,
  `show_update_api` varchar(10) DEFAULT NULL,
  `show_detail_api` varchar(10) DEFAULT NULL,
  `relation_table` varchar(200) DEFAULT NULL,
  `relation_value` varchar(200) DEFAULT NULL,
  `relation_label` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rest_field_validation`
--

DROP TABLE IF EXISTS `rest_field_validation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rest_field_validation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rest_field_id` int(11) NOT NULL,
  `rest_id` int(11) NOT NULL,
  `validation_name` varchar(200) NOT NULL,
  `validation_value` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rest_input_type`
--

DROP TABLE IF EXISTS `rest_input_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rest_input_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(200) NOT NULL,
  `relation` varchar(20) NOT NULL,
  `validation_group` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-04-23 12:06:04
