SET sql_log_bin = 0;
-- MariaDB dump 10.19  Distrib 10.5.9-6-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: dmw_fmcg_col_1453
-- ------------------------------------------------------
-- Server version	10.5.9-6-MariaDB-enterprise-log

/*!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 */;

--
-- Current Database: `dmw_fmcg_col_1453`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `masstest` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `masstest`;

--
-- Table structure for table `affiliato`
--

DROP TABLE IF EXISTS `affiliato`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `affiliato` (
  `af_id` int(11) DEFAULT NULL,
  `af_desc` varchar(40) DEFAULT NULL,
  `af_in_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `azienda_famiglia`
--

DROP TABLE IF EXISTS `azienda_famiglia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `azienda_famiglia` (
  `af_az_id` smallint(6) DEFAULT NULL,
  `af_fa_id` smallint(6) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `campagna_web`
--

DROP TABLE IF EXISTS `campagna_web`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campagna_web` (
  `cw_id` int(11) DEFAULT NULL,
  `cw_desc` varchar(100) DEFAULT NULL,
  `cw_datainizio` date DEFAULT NULL,
  `cw_datafine` date DEFAULT NULL,
  `cw_in_id` int(11) DEFAULT NULL,
  `cw_url` varchar(255) DEFAULT NULL,
  `cw_nota` varchar(255) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `campagna_web_codice`
--

DROP TABLE IF EXISTS `campagna_web_codice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campagna_web_codice` (
  `cwc_id` int(11) DEFAULT NULL,
  `cwc_cw_id` int(11) DEFAULT NULL,
  `cwc_cd_id` int(11) DEFAULT NULL,
  `cwc_codice` varchar(30) DEFAULT NULL,
  `cwc_prezzo` decimal(12,2) DEFAULT NULL,
  `cwc_prezzoListino` decimal(12,2) DEFAULT NULL,
  `cwc_prezzoSpedizione` decimal(8,2) DEFAULT NULL,
  `cwc_in_id` int(11) DEFAULT NULL,
  `cwc_datainizio` date DEFAULT NULL,
  `cwc_datafine` date DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `campagna_web_codice_azione`
--

DROP TABLE IF EXISTS `campagna_web_codice_azione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campagna_web_codice_azione` (
  `cwz_cwc_id` int(11) DEFAULT NULL,
  `cwz_azw_id` int(11) DEFAULT NULL,
  `cwz_value` varchar(450) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `canale`
--

DROP TABLE IF EXISTS `canale`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `canale` (
  `cn_id` tinyint(4) DEFAULT NULL,
  `cn_desc` varchar(40) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `canale_lang`
--

DROP TABLE IF EXISTS `canale_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `canale_lang` (
  `cnl_cn_id` tinyint(4) DEFAULT NULL,
  `cnl_lg_id` tinyint(4) DEFAULT NULL,
  `cnl_desc` varchar(40) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `caratteristica`
--

DROP TABLE IF EXISTS `caratteristica`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `caratteristica` (
  `cr_id` int(11) DEFAULT NULL,
  `cr_desc` varchar(40) DEFAULT NULL,
  `cr_tipo` char(1) DEFAULT NULL,
  `cr_format` varchar(6) DEFAULT NULL,
  `cr_az_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `caratteristica_lang`
--

DROP TABLE IF EXISTS `caratteristica_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `caratteristica_lang` (
  `crl_lg_id` tinyint(4) DEFAULT NULL,
  `crl_cr_id` int(11) DEFAULT NULL,
  `crl_desc` varchar(40) DEFAULT NULL,
  `crl_help` longtext DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `categoria`
--

DROP TABLE IF EXISTS `categoria`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categoria` (
  `ca_id` int(11) DEFAULT NULL,
  `ca_desc` varchar(40) DEFAULT NULL,
  `ca_mr_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `categoria_lang`
--

DROP TABLE IF EXISTS `categoria_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categoria_lang` (
  `cal_lg_id` tinyint(4) DEFAULT NULL,
  `cal_ca_id` int(11) DEFAULT NULL,
  `cal_desc` varchar(40) DEFAULT NULL,
  `cal_desc_ext` varchar(40) DEFAULT NULL,
  `cal_desc_short` varchar(5) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `centrale`
--

DROP TABLE IF EXISTS `centrale`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `centrale` (
  `ce_id` int(11) DEFAULT NULL,
  `ce_desc` varchar(30) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `codice`
--

DROP TABLE IF EXISTS `codice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `codice` (
  `CDID` int(11) DEFAULT NULL,
  `CODICE` varchar(30) DEFAULT NULL,
  `MOID` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `contaril`
--

DROP TABLE IF EXISTS `contaril`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contaril` (
  `ri_na_id` tinyint(4) DEFAULT NULL,
  `ri_fa_id` int(11) DEFAULT NULL,
  `ri_vi_id` bigint(20) DEFAULT NULL,
  `ri_pv_id` int(11) DEFAULT NULL,
  `CNTRIL` bigint(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `famiglia`
--

DROP TABLE IF EXISTS `famiglia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `famiglia` (
  `fa_id` int(11) DEFAULT NULL,
  `fa_desc` varchar(40) DEFAULT NULL,
  `fa_ca_id` int(11) DEFAULT NULL,
  `fa_cr_quantita` smallint(6) DEFAULT NULL,
  `fa_cr_misura` smallint(6) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `famiglia_lang`
--

DROP TABLE IF EXISTS `famiglia_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `famiglia_lang` (
  `FAL_LG_ID` int(11) DEFAULT NULL,
  `FAL_FA_ID` int(11) DEFAULT NULL,
  `FAL_DESC` varchar(45) DEFAULT NULL,
  `fal_desc_ext` varchar(50) DEFAULT NULL,
  `fal_desc_short` varchar(5) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `insegna`
--

DROP TABLE IF EXISTS `insegna`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `insegna` (
  `in_id` int(11) DEFAULT NULL,
  `in_desc` varchar(40) DEFAULT NULL,
  `in_logo` varchar(255) DEFAULT NULL,
  `in_image` varchar(30) DEFAULT NULL,
  `in_image2` varchar(30) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `macrocategoria`
--

DROP TABLE IF EXISTS `macrocategoria`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `macrocategoria` (
  `mr_id` int(11) DEFAULT NULL,
  `mr_desc` varchar(40) DEFAULT NULL,
  `mr_set_id` tinyint(4) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `macrocategoria_lang`
--

DROP TABLE IF EXISTS `macrocategoria_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `macrocategoria_lang` (
  `MRL_LG_ID` int(11) DEFAULT NULL,
  `MRL_MR_ID` int(11) DEFAULT NULL,
  `MRL_DESC` varchar(40) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `marca`
--

DROP TABLE IF EXISTS `marca`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `marca` (
  `ma_id` int(11) DEFAULT NULL,
  `ma_desc` varchar(50) DEFAULT NULL,
  `ma_pd_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `marca_nazione`
--

DROP TABLE IF EXISTS `marca_nazione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `marca_nazione` (
  `mn_ma_id` int(11) DEFAULT NULL,
  `mn_na_id` tinyint(4) DEFAULT NULL,
  `mn_pd_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello`
--

DROP TABLE IF EXISTS `modello`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello` (
  `mo_id` int(11) DEFAULT NULL,
  `mo_desc` varchar(100) DEFAULT NULL,
  `mo_ma_id` int(11) DEFAULT NULL,
  `mo_fa_id` int(11) DEFAULT NULL,
  `mo_ti_id` int(11) DEFAULT NULL,
  `mo_datacreazione` date DEFAULT NULL,
  `mo_flag_ns` decimal(1,0) DEFAULT NULL,
  `mo_flag_ok` char(1) DEFAULT NULL,
  `mo_pic` varchar(255) DEFAULT NULL,
  `mo_id_padre` int(11) DEFAULT NULL,
  `mo_ma_desc` varchar(50) DEFAULT NULL,
  `mo_ct` bigint(20) DEFAULT NULL,
  `mo_mis` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello_1`
--

DROP TABLE IF EXISTS `modello_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello_1` (
  `mo_id` int(11) DEFAULT NULL,
  `mo_desc` varchar(100) DEFAULT NULL,
  `mo_ma_id` int(11) DEFAULT NULL,
  `mo_fa_id` int(11) DEFAULT NULL,
  `mo_ti_id` int(11) DEFAULT NULL,
  `mo_datacreazione` date DEFAULT NULL,
  `mo_flag_ns` decimal(1,0) DEFAULT NULL,
  `mo_flag_ok` char(1) DEFAULT NULL,
  `mo_pic` varchar(255) DEFAULT NULL,
  `mo_id_padre` int(11) DEFAULT NULL,
  `mo_ma_desc` varchar(50) DEFAULT NULL,
  `mo_ct` bigint(20) DEFAULT NULL,
  `mo_mis` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello_1369`
--

DROP TABLE IF EXISTS `modello_1369`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello_1369` (
  `mo_id` int(11) DEFAULT NULL,
  `mo_desc` varchar(100) DEFAULT NULL,
  `mo_ma_id` int(11) DEFAULT NULL,
  `mo_fa_id` int(11) DEFAULT NULL,
  `mo_ti_id` int(11) DEFAULT NULL,
  `mo_datacreazione` date DEFAULT NULL,
  `mo_flag_ns` decimal(1,0) DEFAULT NULL,
  `mo_flag_ok` char(1) DEFAULT NULL,
  `mo_pic` varchar(255) DEFAULT NULL,
  `mo_id_padre` int(11) DEFAULT NULL,
  `mo_ma_desc` varchar(50) DEFAULT NULL,
  `mo_ct` bigint(20) DEFAULT NULL,
  `mo_mis` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello_caratteristica`
--

DROP TABLE IF EXISTS `modello_caratteristica`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello_caratteristica` (
  `mc_mo_id` int(11) DEFAULT NULL,
  `mc_cr_id` int(11) DEFAULT NULL,
  `mc_value` varchar(60) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `nazione`
--

DROP TABLE IF EXISTS `nazione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nazione` (
  `na_id` tinyint(4) DEFAULT NULL,
  `na_desc` varchar(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `nazione_famiglia`
--

DROP TABLE IF EXISTS `nazione_famiglia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nazione_famiglia` (
  `nf_fa_id` int(11) DEFAULT NULL,
  `nf_na_id` tinyint(4) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `nril`
--

DROP TABLE IF EXISTS `nril`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nril` (
  `AZID` int(11) DEFAULT NULL,
  `NAZ` int(11) DEFAULT NULL,
  `NRIL` int(11) DEFAULT NULL,
  `NVIS` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `panel`
--

DROP TABLE IF EXISTS `panel`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `panel` (
  `pl_periodo` int(11) DEFAULT NULL,
  `pl_anno` int(11) DEFAULT NULL,
  `pl_tipo` char(2) DEFAULT NULL,
  `pl_si_id` int(11) DEFAULT NULL,
  `pl_pv_id` int(11) DEFAULT NULL,
  `pl_fa_id` int(11) DEFAULT NULL,
  `pl_ti_id` int(11) DEFAULT NULL,
  `pl_ca_id` int(11) DEFAULT NULL,
  `pl_mr_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `produttore`
--

DROP TABLE IF EXISTS `produttore`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `produttore` (
  `pd_id` int(11) DEFAULT NULL,
  `pd_desc` varchar(50) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `puntovendita`
--

DROP TABLE IF EXISTS `puntovendita`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puntovendita` (
  `pv_id` int(11) DEFAULT NULL,
  `pv_desc` varchar(60) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_indirizzo` varchar(60) DEFAULT NULL,
  `pv_citta` varchar(70) DEFAULT NULL,
  `pv_pn_id` char(3) DEFAULT NULL,
  `pv_cap` varchar(20) DEFAULT NULL,
  `pv_latitudine` double DEFAULT NULL,
  `pv_longitudine` double DEFAULT NULL,
  `pv_datanascita` date DEFAULT NULL,
  `pv_datamorte` date DEFAULT NULL,
  `pv_telefono` varchar(30) DEFAULT NULL,
  `pv_fr_id` int(11) DEFAULT NULL,
  `pv_cd_id` int(11) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pv_co_id` bigint(20) DEFAULT NULL,
  `pv_mq` smallint(6) DEFAULT NULL,
  `pv_image` varchar(30) DEFAULT NULL,
  `pv_re_id` smallint(6) DEFAULT NULL,
  `pv_pot_iss` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `puntovendita_1`
--

DROP TABLE IF EXISTS `puntovendita_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puntovendita_1` (
  `pv_id` int(11) DEFAULT NULL,
  `pv_desc` varchar(60) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_indirizzo` varchar(60) DEFAULT NULL,
  `pv_citta` varchar(70) DEFAULT NULL,
  `pv_pn_id` char(3) DEFAULT NULL,
  `pv_cap` varchar(20) DEFAULT NULL,
  `pv_latitudine` double DEFAULT NULL,
  `pv_longitudine` double DEFAULT NULL,
  `pv_datanascita` date DEFAULT NULL,
  `pv_datamorte` date DEFAULT NULL,
  `pv_telefono` varchar(30) DEFAULT NULL,
  `pv_fr_id` int(11) DEFAULT NULL,
  `pv_cd_id` int(11) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pv_co_id` bigint(20) DEFAULT NULL,
  `pv_mq` smallint(6) DEFAULT NULL,
  `pv_image` varchar(30) DEFAULT NULL,
  `pv_re_id` smallint(6) DEFAULT NULL,
  `pv_pot_iss` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `puntovendita_1369`
--

DROP TABLE IF EXISTS `puntovendita_1369`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puntovendita_1369` (
  `pv_id` int(11) DEFAULT NULL,
  `pv_desc` varchar(60) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_indirizzo` varchar(60) DEFAULT NULL,
  `pv_citta` varchar(70) DEFAULT NULL,
  `pv_pn_id` char(3) DEFAULT NULL,
  `pv_cap` varchar(20) DEFAULT NULL,
  `pv_latitudine` double DEFAULT NULL,
  `pv_longitudine` double DEFAULT NULL,
  `pv_datanascita` date DEFAULT NULL,
  `pv_datamorte` date DEFAULT NULL,
  `pv_telefono` varchar(30) DEFAULT NULL,
  `pv_fr_id` int(11) DEFAULT NULL,
  `pv_cd_id` int(11) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pv_co_id` bigint(20) DEFAULT NULL,
  `pv_mq` smallint(6) DEFAULT NULL,
  `pv_image` varchar(30) DEFAULT NULL,
  `pv_re_id` smallint(6) DEFAULT NULL,
  `pv_pot_iss` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `qanalisi`
--

DROP TABLE IF EXISTS `qanalisi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qanalisi` (
  `qa_id` smallint(6) DEFAULT NULL,
  `qa_desc` varchar(50) DEFAULT NULL,
  `qa_enabled` char(1) DEFAULT NULL,
  `qa_qt_id` bigint(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `qanalisi_lang`
--

DROP TABLE IF EXISTS `qanalisi_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qanalisi_lang` (
  `qal_qa_id` smallint(6) DEFAULT NULL,
  `qal_lg_id` tinyint(4) DEFAULT NULL,
  `qal_desc` varchar(50) DEFAULT NULL,
  `qal_help` varchar(100) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `qanalisi_tab`
--

DROP TABLE IF EXISTS `qanalisi_tab`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qanalisi_tab` (
  `qt_id` bigint(20) DEFAULT NULL,
  `qt_desc` varchar(30) DEFAULT NULL,
  `qt_icon` varchar(30) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `qanalisi_tab_lang`
--

DROP TABLE IF EXISTS `qanalisi_tab_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qanalisi_tab_lang` (
  `qtl_qt_id` bigint(20) DEFAULT NULL,
  `qtl_lg_id` tinyint(4) DEFAULT NULL,
  `qtl_desc` varchar(100) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ra_15`
--

DROP TABLE IF EXISTS `ra_15`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ra_15` (
  `ra_ri_id` bigint(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ra_22`
--

DROP TABLE IF EXISTS `ra_22`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ra_22` (
  `ra_ri_id` bigint(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rilevazione`
--

DROP TABLE IF EXISTS `rilevazione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rilevazione` (
  `ri_id` bigint(20) DEFAULT NULL,
  `ri_vi_id` bigint(20) DEFAULT NULL,
  `ri_mo_id` int(11) DEFAULT NULL,
  `ri_rw_id` int(11) DEFAULT NULL,
  `ri_codice` varchar(30) DEFAULT NULL,
  `ri_va_id` tinyint(4) DEFAULT NULL,
  `ri_prezzo` decimal(11,2) DEFAULT NULL,
  `ri_prezzo_listino` decimal(11,2) DEFAULT NULL,
  `ri_prezzo_spedizione` decimal(11,2) DEFAULT NULL,
  `ri_prezzo_carta` decimal(11,2) DEFAULT NULL,
  `ri_npezzi` int(11) DEFAULT NULL,
  `ri_pgdir` bigint(20) DEFAULT NULL,
  `ri_posizione` tinyint(4) DEFAULT NULL,
  `ri_fa_id` int(11) DEFAULT NULL,
  `ri_ca_id` int(11) DEFAULT NULL,
  `ri_mr_id` int(11) DEFAULT NULL,
  `ri_ma_id` int(11) DEFAULT NULL,
  `ri_pd_id` int(11) DEFAULT NULL,
  `ri_pv_id` int(11) DEFAULT NULL,
  `ri_ti_id` int(11) DEFAULT NULL,
  `ri_re_id` int(11) DEFAULT NULL,
  `ri_pn_id` char(1) DEFAULT NULL,
  `ri_in_id` int(11) DEFAULT NULL,
  `ri_cn_id` tinyint(4) DEFAULT NULL,
  `ri_af_id` int(11) DEFAULT NULL,
  `ri_na_id` tinyint(4) DEFAULT NULL,
  `ri_data` date DEFAULT NULL,
  `ri_settimana` int(11) DEFAULT NULL,
  `ri_mese` int(11) DEFAULT NULL,
  `ri_periodo` int(11) DEFAULT NULL,
  `ri_si_id` int(11) DEFAULT NULL,
  `ri_ce_id` int(11) DEFAULT NULL,
  `ri_prezzouni` decimal(9,2) DEFAULT NULL,
  `ri_mo_ct` int(11) DEFAULT NULL,
  `ri_prezzomis` decimal(9,2) DEFAULT NULL,
  `ri_mo_mis` float DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tipo`
--

DROP TABLE IF EXISTS `tipo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tipo` (
  `ti_id` int(11) DEFAULT NULL,
  `ti_desc` varchar(40) DEFAULT NULL,
  `ti_fa_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tipo_lang`
--

DROP TABLE IF EXISTS `tipo_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tipo_lang` (
  `til_ti_id` int(11) DEFAULT NULL,
  `til_lg_id` int(11) DEFAULT NULL,
  `til_desc` varchar(100) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `valuta`
--

DROP TABLE IF EXISTS `valuta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `valuta` (
  `va_id` tinyint(4) DEFAULT NULL,
  `va_desc` varchar(40) DEFAULT NULL,
  `va_code` char(3) DEFAULT NULL,
  `va_sigla` varchar(3) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `visita`
--

DROP TABLE IF EXISTS `visita`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `visita` (
  `vi_id` bigint(20) DEFAULT NULL,
  `vi_pv_id` int(11) DEFAULT NULL,
  `vi_mese` int(11) DEFAULT NULL,
  `vi_data` date DEFAULT NULL,
  `vi_periodo` int(11) DEFAULT NULL,
  `vi_nota` char(1) DEFAULT NULL,
  `vi_in_id` int(11) DEFAULT NULL,
  `vi_af_id` int(11) DEFAULT NULL,
  `vi_re_id` int(11) DEFAULT NULL,
  `vi_pn_id` char(1) DEFAULT NULL,
  `vi_si_id` int(11) DEFAULT NULL,
  `vi_nril` bigint(20) DEFAULT NULL,
  `vi_ce_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `visiteweb`
--

DROP TABLE IF EXISTS `visiteweb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `visiteweb` (
  `vw_id` int(11) DEFAULT NULL,
  `vi_tipo` varchar(2) DEFAULT NULL,
  `vi_id` bigint(20) DEFAULT NULL,
  `vw_si_id` int(11) DEFAULT NULL,
  `vw_cd_id` int(11) DEFAULT NULL,
  `vw_giorno` date DEFAULT NULL,
  `vw_mese` int(11) DEFAULT NULL,
  `vw_periodo` int(11) DEFAULT NULL,
  `pv_id` int(11) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_pn_id` char(1) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pn_re_id` int(11) DEFAULT NULL,
  `vw_settimana` int(11) DEFAULT NULL,
  `CEID` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Current Database: `dmw_fmcg_latam_1553`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `masstest` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `masstest`;

--
-- Table structure for table `affiliato`
--

DROP TABLE IF EXISTS `affiliato`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `affiliato` (
  `af_id` int(11) DEFAULT NULL,
  `af_desc` varchar(40) DEFAULT NULL,
  `af_in_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `azienda_famiglia`
--

DROP TABLE IF EXISTS `azienda_famiglia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `azienda_famiglia` (
  `af_az_id` smallint(6) DEFAULT NULL,
  `af_fa_id` smallint(6) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `campagna_web`
--

DROP TABLE IF EXISTS `campagna_web`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campagna_web` (
  `cw_id` int(11) DEFAULT NULL,
  `cw_desc` varchar(100) DEFAULT NULL,
  `cw_datainizio` date DEFAULT NULL,
  `cw_datafine` date DEFAULT NULL,
  `cw_in_id` int(11) DEFAULT NULL,
  `cw_url` varchar(255) DEFAULT NULL,
  `cw_nota` varchar(255) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `campagna_web_codice`
--

DROP TABLE IF EXISTS `campagna_web_codice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campagna_web_codice` (
  `cwc_id` int(11) DEFAULT NULL,
  `cwc_cw_id` int(11) DEFAULT NULL,
  `cwc_cd_id` int(11) DEFAULT NULL,
  `cwc_codice` varchar(30) DEFAULT NULL,
  `cwc_prezzo` decimal(12,2) DEFAULT NULL,
  `cwc_prezzoListino` decimal(12,2) DEFAULT NULL,
  `cwc_prezzoSpedizione` decimal(8,2) DEFAULT NULL,
  `cwc_in_id` int(11) DEFAULT NULL,
  `cwc_datainizio` date DEFAULT NULL,
  `cwc_datafine` date DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `campagna_web_codice_azione`
--

DROP TABLE IF EXISTS `campagna_web_codice_azione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campagna_web_codice_azione` (
  `cwz_cwc_id` int(11) DEFAULT NULL,
  `cwz_azw_id` int(11) DEFAULT NULL,
  `cwz_value` varchar(450) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `canale`
--

DROP TABLE IF EXISTS `canale`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `canale` (
  `cn_id` tinyint(4) DEFAULT NULL,
  `cn_desc` varchar(40) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `canale_lang`
--

DROP TABLE IF EXISTS `canale_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `canale_lang` (
  `cnl_cn_id` tinyint(4) DEFAULT NULL,
  `cnl_lg_id` tinyint(4) DEFAULT NULL,
  `cnl_desc` varchar(40) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `caratteristica`
--

DROP TABLE IF EXISTS `caratteristica`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `caratteristica` (
  `cr_id` int(11) DEFAULT NULL,
  `cr_desc` varchar(40) DEFAULT NULL,
  `cr_tipo` char(1) DEFAULT NULL,
  `cr_format` varchar(6) DEFAULT NULL,
  `cr_az_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `caratteristica_lang`
--

DROP TABLE IF EXISTS `caratteristica_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `caratteristica_lang` (
  `crl_lg_id` tinyint(4) DEFAULT NULL,
  `crl_cr_id` int(11) DEFAULT NULL,
  `crl_desc` varchar(40) DEFAULT NULL,
  `crl_help` longtext DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `categoria`
--

DROP TABLE IF EXISTS `categoria`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categoria` (
  `ca_id` int(11) DEFAULT NULL,
  `ca_desc` varchar(40) DEFAULT NULL,
  `ca_mr_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `categoria_lang`
--

DROP TABLE IF EXISTS `categoria_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categoria_lang` (
  `cal_lg_id` tinyint(4) DEFAULT NULL,
  `cal_ca_id` int(11) DEFAULT NULL,
  `cal_desc` varchar(40) DEFAULT NULL,
  `cal_desc_ext` varchar(40) DEFAULT NULL,
  `cal_desc_short` varchar(5) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `codice`
--

DROP TABLE IF EXISTS `codice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `codice` (
  `CDID` int(11) DEFAULT NULL,
  `CODICE` varchar(30) DEFAULT NULL,
  `MOID` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `contaril`
--

DROP TABLE IF EXISTS `contaril`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contaril` (
  `ri_na_id` tinyint(4) DEFAULT NULL,
  `ri_fa_id` int(11) DEFAULT NULL,
  `ri_vi_id` bigint(20) DEFAULT NULL,
  `ri_pv_id` int(11) DEFAULT NULL,
  `CNTRIL` bigint(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `famiglia`
--

DROP TABLE IF EXISTS `famiglia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `famiglia` (
  `fa_id` int(11) DEFAULT NULL,
  `fa_desc` varchar(40) DEFAULT NULL,
  `fa_ca_id` int(11) DEFAULT NULL,
  `fa_cr_quantita` smallint(6) DEFAULT NULL,
  `fa_cr_misura` smallint(6) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `famiglia_lang`
--

DROP TABLE IF EXISTS `famiglia_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `famiglia_lang` (
  `FAL_LG_ID` int(11) DEFAULT NULL,
  `FAL_FA_ID` int(11) DEFAULT NULL,
  `FAL_DESC` varchar(45) DEFAULT NULL,
  `fal_desc_ext` varchar(50) DEFAULT NULL,
  `fal_desc_short` varchar(5) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `insegna`
--

DROP TABLE IF EXISTS `insegna`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `insegna` (
  `in_id` int(11) DEFAULT NULL,
  `in_desc` varchar(40) DEFAULT NULL,
  `in_logo` varchar(255) DEFAULT NULL,
  `in_image` varchar(30) DEFAULT NULL,
  `in_image2` varchar(30) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `macrocategoria`
--

DROP TABLE IF EXISTS `macrocategoria`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `macrocategoria` (
  `mr_id` int(11) DEFAULT NULL,
  `mr_desc` varchar(40) DEFAULT NULL,
  `mr_set_id` tinyint(4) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `macrocategoria_lang`
--

DROP TABLE IF EXISTS `macrocategoria_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `macrocategoria_lang` (
  `MRL_LG_ID` int(11) DEFAULT NULL,
  `MRL_MR_ID` int(11) DEFAULT NULL,
  `MRL_DESC` varchar(40) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `marca`
--

DROP TABLE IF EXISTS `marca`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `marca` (
  `ma_id` int(11) DEFAULT NULL,
  `ma_desc` varchar(50) DEFAULT NULL,
  `ma_pd_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `marca_nazione`
--

DROP TABLE IF EXISTS `marca_nazione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `marca_nazione` (
  `mn_ma_id` int(11) DEFAULT NULL,
  `mn_na_id` tinyint(4) DEFAULT NULL,
  `mn_pd_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello`
--

DROP TABLE IF EXISTS `modello`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello` (
  `mo_id` int(11) DEFAULT NULL,
  `mo_desc` varchar(100) DEFAULT NULL,
  `mo_ma_id` int(11) DEFAULT NULL,
  `mo_fa_id` int(11) DEFAULT NULL,
  `mo_ti_id` int(11) DEFAULT NULL,
  `mo_datacreazione` date DEFAULT NULL,
  `mo_flag_ns` decimal(1,0) DEFAULT NULL,
  `mo_flag_ok` char(1) DEFAULT NULL,
  `mo_pic` varchar(255) DEFAULT NULL,
  `mo_id_padre` int(11) DEFAULT NULL,
  `mo_ma_desc` varchar(50) DEFAULT NULL,
  `mo_ct` bigint(20) DEFAULT NULL,
  `mo_mis` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello_1`
--

DROP TABLE IF EXISTS `modello_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello_1` (
  `mo_id` int(11) DEFAULT NULL,
  `mo_desc` varchar(100) DEFAULT NULL,
  `mo_ma_id` int(11) DEFAULT NULL,
  `mo_fa_id` int(11) DEFAULT NULL,
  `mo_ti_id` int(11) DEFAULT NULL,
  `mo_datacreazione` date DEFAULT NULL,
  `mo_flag_ns` decimal(1,0) DEFAULT NULL,
  `mo_flag_ok` char(1) DEFAULT NULL,
  `mo_pic` varchar(255) DEFAULT NULL,
  `mo_id_padre` int(11) DEFAULT NULL,
  `mo_ma_desc` varchar(50) DEFAULT NULL,
  `mo_ct` bigint(20) DEFAULT NULL,
  `mo_mis` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello_caratteristica`
--

DROP TABLE IF EXISTS `modello_caratteristica`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello_caratteristica` (
  `mc_mo_id` int(11) DEFAULT NULL,
  `mc_cr_id` int(11) DEFAULT NULL,
  `mc_value` varchar(60) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `nazione`
--

DROP TABLE IF EXISTS `nazione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nazione` (
  `na_id` tinyint(4) DEFAULT NULL,
  `na_desc` varchar(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `nazione_famiglia`
--

DROP TABLE IF EXISTS `nazione_famiglia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nazione_famiglia` (
  `nf_fa_id` int(11) DEFAULT NULL,
  `nf_na_id` tinyint(4) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `nril`
--

DROP TABLE IF EXISTS `nril`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nril` (
  `AZID` int(11) DEFAULT NULL,
  `NAZ` int(11) DEFAULT NULL,
  `NRIL` int(11) DEFAULT NULL,
  `NVIS` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `panel`
--

DROP TABLE IF EXISTS `panel`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `panel` (
  `pl_periodo` int(11) DEFAULT NULL,
  `pl_anno` int(11) DEFAULT NULL,
  `pl_tipo` char(2) DEFAULT NULL,
  `pl_si_id` int(11) DEFAULT NULL,
  `pl_pv_id` int(11) DEFAULT NULL,
  `pl_fa_id` int(11) DEFAULT NULL,
  `pl_ti_id` int(11) DEFAULT NULL,
  `pl_ca_id` int(11) DEFAULT NULL,
  `pl_mr_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `produttore`
--

DROP TABLE IF EXISTS `produttore`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `produttore` (
  `pd_id` int(11) DEFAULT NULL,
  `pd_desc` varchar(50) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `puntovendita`
--

DROP TABLE IF EXISTS `puntovendita`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puntovendita` (
  `pv_id` int(11) DEFAULT NULL,
  `pv_desc` varchar(60) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_indirizzo` varchar(60) DEFAULT NULL,
  `pv_citta` varchar(70) DEFAULT NULL,
  `pv_pn_id` char(3) DEFAULT NULL,
  `pv_cap` varchar(20) DEFAULT NULL,
  `pv_latitudine` double DEFAULT NULL,
  `pv_longitudine` double DEFAULT NULL,
  `pv_datanascita` date DEFAULT NULL,
  `pv_datamorte` date DEFAULT NULL,
  `pv_telefono` varchar(30) DEFAULT NULL,
  `pv_fr_id` int(11) DEFAULT NULL,
  `pv_cd_id` int(11) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pv_co_id` bigint(20) DEFAULT NULL,
  `pv_mq` smallint(6) DEFAULT NULL,
  `pv_image` varchar(30) DEFAULT NULL,
  `pv_re_id` smallint(6) DEFAULT NULL,
  `pv_pot_iss` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `puntovendita_1`
--

DROP TABLE IF EXISTS `puntovendita_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puntovendita_1` (
  `pv_id` int(11) DEFAULT NULL,
  `pv_desc` varchar(60) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_indirizzo` varchar(60) DEFAULT NULL,
  `pv_citta` varchar(70) DEFAULT NULL,
  `pv_pn_id` char(3) DEFAULT NULL,
  `pv_cap` varchar(20) DEFAULT NULL,
  `pv_latitudine` double DEFAULT NULL,
  `pv_longitudine` double DEFAULT NULL,
  `pv_datanascita` date DEFAULT NULL,
  `pv_datamorte` date DEFAULT NULL,
  `pv_telefono` varchar(30) DEFAULT NULL,
  `pv_fr_id` int(11) DEFAULT NULL,
  `pv_cd_id` int(11) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pv_co_id` bigint(20) DEFAULT NULL,
  `pv_mq` smallint(6) DEFAULT NULL,
  `pv_image` varchar(30) DEFAULT NULL,
  `pv_re_id` smallint(6) DEFAULT NULL,
  `pv_pot_iss` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `qanalisi`
--

DROP TABLE IF EXISTS `qanalisi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qanalisi` (
  `qa_id` smallint(6) DEFAULT NULL,
  `qa_desc` varchar(50) DEFAULT NULL,
  `qa_enabled` char(1) DEFAULT NULL,
  `qa_qt_id` bigint(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `qanalisi_lang`
--

DROP TABLE IF EXISTS `qanalisi_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qanalisi_lang` (
  `qal_qa_id` smallint(6) DEFAULT NULL,
  `qal_lg_id` tinyint(4) DEFAULT NULL,
  `qal_desc` varchar(50) DEFAULT NULL,
  `qal_help` varchar(100) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `qanalisi_tab`
--

DROP TABLE IF EXISTS `qanalisi_tab`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qanalisi_tab` (
  `qt_id` bigint(20) DEFAULT NULL,
  `qt_desc` varchar(30) DEFAULT NULL,
  `qt_icon` varchar(30) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `qanalisi_tab_lang`
--

DROP TABLE IF EXISTS `qanalisi_tab_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qanalisi_tab_lang` (
  `qtl_qt_id` bigint(20) DEFAULT NULL,
  `qtl_lg_id` tinyint(4) DEFAULT NULL,
  `qtl_desc` varchar(100) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ra_15`
--

DROP TABLE IF EXISTS `ra_15`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ra_15` (
  `ra_ri_id` bigint(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ra_22`
--

DROP TABLE IF EXISTS `ra_22`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ra_22` (
  `ra_ri_id` bigint(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rilevazione`
--

DROP TABLE IF EXISTS `rilevazione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rilevazione` (
  `ri_id` bigint(20) DEFAULT NULL,
  `ri_vi_id` bigint(20) DEFAULT NULL,
  `ri_mo_id` int(11) DEFAULT NULL,
  `ri_rw_id` int(11) DEFAULT NULL,
  `ri_codice` varchar(30) DEFAULT NULL,
  `ri_va_id` tinyint(4) DEFAULT NULL,
  `ri_prezzo` decimal(11,2) DEFAULT NULL,
  `ri_prezzo_listino` decimal(11,2) DEFAULT NULL,
  `ri_prezzo_spedizione` decimal(11,2) DEFAULT NULL,
  `ri_npezzi` int(11) DEFAULT NULL,
  `ri_pgdir` bigint(20) DEFAULT NULL,
  `ri_posizione` tinyint(4) DEFAULT NULL,
  `ri_fa_id` int(11) DEFAULT NULL,
  `ri_ca_id` int(11) DEFAULT NULL,
  `ri_mr_id` int(11) DEFAULT NULL,
  `ri_ma_id` int(11) DEFAULT NULL,
  `ri_pd_id` int(11) DEFAULT NULL,
  `ri_pv_id` int(11) DEFAULT NULL,
  `ri_ti_id` int(11) DEFAULT NULL,
  `ri_re_id` int(11) DEFAULT NULL,
  `ri_pn_id` char(1) DEFAULT NULL,
  `ri_in_id` int(11) DEFAULT NULL,
  `ri_cn_id` tinyint(4) DEFAULT NULL,
  `ri_af_id` int(11) DEFAULT NULL,
  `ri_na_id` tinyint(4) DEFAULT NULL,
  `ri_data` date DEFAULT NULL,
  `ri_settimana` int(11) DEFAULT NULL,
  `ri_mese` int(11) DEFAULT NULL,
  `ri_periodo` int(11) DEFAULT NULL,
  `ri_si_id` int(11) DEFAULT NULL,
  `ri_prezzouni` decimal(9,2) DEFAULT NULL,
  `ri_mo_ct` int(11) DEFAULT NULL,
  `ri_prezzomis` decimal(9,2) DEFAULT NULL,
  `ri_mo_mis` float DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tipo`
--

DROP TABLE IF EXISTS `tipo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tipo` (
  `ti_id` int(11) DEFAULT NULL,
  `ti_desc` varchar(40) DEFAULT NULL,
  `ti_fa_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tipo_lang`
--

DROP TABLE IF EXISTS `tipo_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tipo_lang` (
  `til_ti_id` int(11) DEFAULT NULL,
  `til_lg_id` int(11) DEFAULT NULL,
  `til_desc` varchar(100) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `valuta`
--

DROP TABLE IF EXISTS `valuta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `valuta` (
  `va_id` tinyint(4) DEFAULT NULL,
  `va_desc` varchar(40) DEFAULT NULL,
  `va_code` char(3) DEFAULT NULL,
  `va_sigla` varchar(3) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `visita`
--

DROP TABLE IF EXISTS `visita`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `visita` (
  `vi_id` bigint(20) DEFAULT NULL,
  `vi_pv_id` int(11) DEFAULT NULL,
  `vi_mese` int(11) DEFAULT NULL,
  `vi_data` date DEFAULT NULL,
  `vi_periodo` int(11) DEFAULT NULL,
  `vi_nota` char(1) DEFAULT NULL,
  `vi_in_id` int(11) DEFAULT NULL,
  `vi_af_id` int(11) DEFAULT NULL,
  `vi_re_id` int(11) DEFAULT NULL,
  `vi_pn_id` char(1) DEFAULT NULL,
  `vi_si_id` int(11) DEFAULT NULL,
  `vi_nril` bigint(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `visiteweb`
--

DROP TABLE IF EXISTS `visiteweb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `visiteweb` (
  `vw_id` int(11) DEFAULT NULL,
  `vi_tipo` varchar(2) DEFAULT NULL,
  `vi_id` bigint(20) DEFAULT NULL,
  `vw_si_id` int(11) DEFAULT NULL,
  `vw_cd_id` int(11) DEFAULT NULL,
  `vw_giorno` date DEFAULT NULL,
  `vw_mese` int(11) DEFAULT NULL,
  `vw_periodo` int(11) DEFAULT NULL,
  `pv_id` int(11) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_pn_id` char(1) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pn_re_id` int(11) DEFAULT NULL,
  `vw_settimana` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Current Database: `dmw_fmcg_ita_2543`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `masstest` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `masstest`;

--
-- Table structure for table `affiliato`
--

DROP TABLE IF EXISTS `affiliato`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `affiliato` (
  `af_id` int(11) DEFAULT NULL,
  `af_desc` varchar(40) DEFAULT NULL,
  `af_in_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `azienda_famiglia`
--

DROP TABLE IF EXISTS `azienda_famiglia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `azienda_famiglia` (
  `af_az_id` smallint(6) DEFAULT NULL,
  `af_fa_id` smallint(6) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `campagna_web`
--

DROP TABLE IF EXISTS `campagna_web`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campagna_web` (
  `cw_id` int(11) DEFAULT NULL,
  `cw_desc` varchar(100) DEFAULT NULL,
  `cw_datainizio` date DEFAULT NULL,
  `cw_datafine` date DEFAULT NULL,
  `cw_in_id` int(11) DEFAULT NULL,
  `cw_url` varchar(255) DEFAULT NULL,
  `cw_nota` varchar(255) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `campagna_web_codice`
--

DROP TABLE IF EXISTS `campagna_web_codice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campagna_web_codice` (
  `cwc_id` int(11) DEFAULT NULL,
  `cwc_cw_id` int(11) DEFAULT NULL,
  `cwc_cd_id` int(11) DEFAULT NULL,
  `cwc_codice` varchar(30) DEFAULT NULL,
  `cwc_prezzo` decimal(12,2) DEFAULT NULL,
  `cwc_prezzoListino` decimal(12,2) DEFAULT NULL,
  `cwc_prezzoSpedizione` decimal(8,2) DEFAULT NULL,
  `cwc_in_id` int(11) DEFAULT NULL,
  `cwc_datainizio` date DEFAULT NULL,
  `cwc_datafine` date DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `campagna_web_codice_azione`
--

DROP TABLE IF EXISTS `campagna_web_codice_azione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campagna_web_codice_azione` (
  `cwz_cwc_id` int(11) DEFAULT NULL,
  `cwz_azw_id` int(11) DEFAULT NULL,
  `cwz_value` varchar(450) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `canale`
--

DROP TABLE IF EXISTS `canale`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `canale` (
  `cn_id` tinyint(4) DEFAULT NULL,
  `cn_desc` varchar(40) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `canale_lang`
--

DROP TABLE IF EXISTS `canale_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `canale_lang` (
  `cnl_cn_id` tinyint(4) DEFAULT NULL,
  `cnl_lg_id` tinyint(4) DEFAULT NULL,
  `cnl_desc` varchar(40) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `caratteristica`
--

DROP TABLE IF EXISTS `caratteristica`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `caratteristica` (
  `cr_id` int(11) DEFAULT NULL,
  `cr_desc` varchar(40) DEFAULT NULL,
  `cr_tipo` char(1) DEFAULT NULL,
  `cr_format` varchar(6) DEFAULT NULL,
  `cr_az_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `caratteristica_lang`
--

DROP TABLE IF EXISTS `caratteristica_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `caratteristica_lang` (
  `crl_lg_id` tinyint(4) DEFAULT NULL,
  `crl_cr_id` int(11) DEFAULT NULL,
  `crl_desc` varchar(40) DEFAULT NULL,
  `crl_help` longtext DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `categoria`
--

DROP TABLE IF EXISTS `categoria`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categoria` (
  `ca_id` int(11) DEFAULT NULL,
  `ca_desc` varchar(40) DEFAULT NULL,
  `ca_mr_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `categoria_lang`
--

DROP TABLE IF EXISTS `categoria_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categoria_lang` (
  `cal_lg_id` tinyint(4) DEFAULT NULL,
  `cal_ca_id` int(11) DEFAULT NULL,
  `cal_desc` varchar(40) DEFAULT NULL,
  `cal_desc_ext` varchar(40) DEFAULT NULL,
  `cal_desc_short` varchar(5) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `centrale`
--

DROP TABLE IF EXISTS `centrale`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `centrale` (
  `ce_id` int(11) DEFAULT NULL,
  `ce_desc` varchar(30) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `codice`
--

DROP TABLE IF EXISTS `codice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `codice` (
  `CDID` int(11) DEFAULT NULL,
  `CODICE` varchar(30) DEFAULT NULL,
  `MOID` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `contaril`
--

DROP TABLE IF EXISTS `contaril`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contaril` (
  `ri_na_id` tinyint(4) DEFAULT NULL,
  `ri_fa_id` int(11) DEFAULT NULL,
  `ri_vi_id` bigint(20) DEFAULT NULL,
  `ri_pv_id` int(11) DEFAULT NULL,
  `CNTRIL` bigint(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `famiglia`
--

DROP TABLE IF EXISTS `famiglia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `famiglia` (
  `fa_id` int(11) DEFAULT NULL,
  `fa_desc` varchar(40) DEFAULT NULL,
  `fa_ca_id` int(11) DEFAULT NULL,
  `fa_cr_quantita` smallint(6) DEFAULT NULL,
  `fa_cr_misura` smallint(6) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `famiglia_lang`
--

DROP TABLE IF EXISTS `famiglia_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `famiglia_lang` (
  `FAL_LG_ID` int(11) DEFAULT NULL,
  `FAL_FA_ID` int(11) DEFAULT NULL,
  `FAL_DESC` varchar(45) DEFAULT NULL,
  `fal_desc_ext` varchar(50) DEFAULT NULL,
  `fal_desc_short` varchar(5) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `insegna`
--

DROP TABLE IF EXISTS `insegna`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `insegna` (
  `in_id` int(11) DEFAULT NULL,
  `in_desc` varchar(40) DEFAULT NULL,
  `in_logo` varchar(255) DEFAULT NULL,
  `in_image` varchar(30) DEFAULT NULL,
  `in_image2` varchar(30) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `macrocategoria`
--

DROP TABLE IF EXISTS `macrocategoria`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `macrocategoria` (
  `mr_id` int(11) DEFAULT NULL,
  `mr_desc` varchar(40) DEFAULT NULL,
  `mr_set_id` tinyint(4) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `macrocategoria_lang`
--

DROP TABLE IF EXISTS `macrocategoria_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `macrocategoria_lang` (
  `MRL_LG_ID` int(11) DEFAULT NULL,
  `MRL_MR_ID` int(11) DEFAULT NULL,
  `MRL_DESC` varchar(40) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `marca`
--

DROP TABLE IF EXISTS `marca`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `marca` (
  `ma_id` int(11) DEFAULT NULL,
  `ma_desc` varchar(50) DEFAULT NULL,
  `ma_pd_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `marca_nazione`
--

DROP TABLE IF EXISTS `marca_nazione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `marca_nazione` (
  `mn_ma_id` int(11) DEFAULT NULL,
  `mn_na_id` tinyint(4) DEFAULT NULL,
  `mn_pd_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello`
--

DROP TABLE IF EXISTS `modello`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello` (
  `mo_id` int(11) DEFAULT NULL,
  `mo_desc` varchar(100) DEFAULT NULL,
  `mo_ma_id` int(11) DEFAULT NULL,
  `mo_fa_id` int(11) DEFAULT NULL,
  `mo_ti_id` int(11) DEFAULT NULL,
  `mo_datacreazione` date DEFAULT NULL,
  `mo_flag_ns` decimal(1,0) DEFAULT NULL,
  `mo_flag_ok` char(1) DEFAULT NULL,
  `mo_pic` varchar(255) DEFAULT NULL,
  `mo_id_padre` int(11) DEFAULT NULL,
  `mo_ma_desc` varchar(50) DEFAULT NULL,
  `mo_ct` bigint(20) DEFAULT NULL,
  `mo_mis` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello_1`
--

DROP TABLE IF EXISTS `modello_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello_1` (
  `mo_id` int(11) DEFAULT NULL,
  `mo_desc` varchar(100) DEFAULT NULL,
  `mo_ma_id` int(11) DEFAULT NULL,
  `mo_fa_id` int(11) DEFAULT NULL,
  `mo_ti_id` int(11) DEFAULT NULL,
  `mo_datacreazione` date DEFAULT NULL,
  `mo_flag_ns` decimal(1,0) DEFAULT NULL,
  `mo_flag_ok` char(1) DEFAULT NULL,
  `mo_pic` varchar(255) DEFAULT NULL,
  `mo_id_padre` int(11) DEFAULT NULL,
  `mo_ma_desc` varchar(50) DEFAULT NULL,
  `mo_ct` bigint(20) DEFAULT NULL,
  `mo_mis` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello_1107`
--

DROP TABLE IF EXISTS `modello_1107`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello_1107` (
  `mo_id` int(11) DEFAULT NULL,
  `mo_desc` varchar(100) DEFAULT NULL,
  `mo_ma_id` int(11) DEFAULT NULL,
  `mo_fa_id` int(11) DEFAULT NULL,
  `mo_ti_id` int(11) DEFAULT NULL,
  `mo_datacreazione` date DEFAULT NULL,
  `mo_flag_ns` decimal(1,0) DEFAULT NULL,
  `mo_flag_ok` char(1) DEFAULT NULL,
  `mo_pic` varchar(255) DEFAULT NULL,
  `mo_id_padre` int(11) DEFAULT NULL,
  `mo_ma_desc` varchar(50) DEFAULT NULL,
  `mo_ct` bigint(20) DEFAULT NULL,
  `mo_mis` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello_1263`
--

DROP TABLE IF EXISTS `modello_1263`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello_1263` (
  `mo_id` int(11) DEFAULT NULL,
  `mo_desc` varchar(100) DEFAULT NULL,
  `mo_ma_id` int(11) DEFAULT NULL,
  `mo_fa_id` int(11) DEFAULT NULL,
  `mo_ti_id` int(11) DEFAULT NULL,
  `mo_datacreazione` date DEFAULT NULL,
  `mo_flag_ns` decimal(1,0) DEFAULT NULL,
  `mo_flag_ok` char(1) DEFAULT NULL,
  `mo_pic` varchar(255) DEFAULT NULL,
  `mo_id_padre` int(11) DEFAULT NULL,
  `mo_ma_desc` varchar(50) DEFAULT NULL,
  `mo_ct` bigint(20) DEFAULT NULL,
  `mo_mis` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello_1272`
--

DROP TABLE IF EXISTS `modello_1272`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello_1272` (
  `mo_id` int(11) DEFAULT NULL,
  `mo_desc` varchar(100) DEFAULT NULL,
  `mo_ma_id` int(11) DEFAULT NULL,
  `mo_fa_id` int(11) DEFAULT NULL,
  `mo_ti_id` int(11) DEFAULT NULL,
  `mo_datacreazione` date DEFAULT NULL,
  `mo_flag_ns` decimal(1,0) DEFAULT NULL,
  `mo_flag_ok` char(1) DEFAULT NULL,
  `mo_pic` varchar(255) DEFAULT NULL,
  `mo_id_padre` int(11) DEFAULT NULL,
  `mo_ma_desc` varchar(50) DEFAULT NULL,
  `mo_ct` bigint(20) DEFAULT NULL,
  `mo_mis` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello_1401`
--

DROP TABLE IF EXISTS `modello_1401`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello_1401` (
  `mo_id` int(11) DEFAULT NULL,
  `mo_desc` varchar(100) DEFAULT NULL,
  `mo_ma_id` int(11) DEFAULT NULL,
  `mo_fa_id` int(11) DEFAULT NULL,
  `mo_ti_id` int(11) DEFAULT NULL,
  `mo_datacreazione` date DEFAULT NULL,
  `mo_flag_ns` decimal(1,0) DEFAULT NULL,
  `mo_flag_ok` char(1) DEFAULT NULL,
  `mo_pic` varchar(255) DEFAULT NULL,
  `mo_id_padre` int(11) DEFAULT NULL,
  `mo_ma_desc` varchar(50) DEFAULT NULL,
  `mo_ct` bigint(20) DEFAULT NULL,
  `mo_mis` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello_453`
--

DROP TABLE IF EXISTS `modello_453`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello_453` (
  `mo_id` int(11) DEFAULT NULL,
  `mo_desc` varchar(100) DEFAULT NULL,
  `mo_ma_id` int(11) DEFAULT NULL,
  `mo_fa_id` int(11) DEFAULT NULL,
  `mo_ti_id` int(11) DEFAULT NULL,
  `mo_datacreazione` date DEFAULT NULL,
  `mo_flag_ns` decimal(1,0) DEFAULT NULL,
  `mo_flag_ok` char(1) DEFAULT NULL,
  `mo_pic` varchar(255) DEFAULT NULL,
  `mo_id_padre` int(11) DEFAULT NULL,
  `mo_ma_desc` varchar(50) DEFAULT NULL,
  `mo_ct` bigint(20) DEFAULT NULL,
  `mo_mis` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello_622`
--

DROP TABLE IF EXISTS `modello_622`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello_622` (
  `mo_id` int(11) DEFAULT NULL,
  `mo_desc` varchar(100) DEFAULT NULL,
  `mo_ma_id` int(11) DEFAULT NULL,
  `mo_fa_id` int(11) DEFAULT NULL,
  `mo_ti_id` int(11) DEFAULT NULL,
  `mo_datacreazione` date DEFAULT NULL,
  `mo_flag_ns` decimal(1,0) DEFAULT NULL,
  `mo_flag_ok` char(1) DEFAULT NULL,
  `mo_pic` varchar(255) DEFAULT NULL,
  `mo_id_padre` int(11) DEFAULT NULL,
  `mo_ma_desc` varchar(50) DEFAULT NULL,
  `mo_ct` bigint(20) DEFAULT NULL,
  `mo_mis` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello_628`
--

DROP TABLE IF EXISTS `modello_628`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello_628` (
  `mo_id` int(11) DEFAULT NULL,
  `mo_desc` varchar(100) DEFAULT NULL,
  `mo_ma_id` int(11) DEFAULT NULL,
  `mo_fa_id` int(11) DEFAULT NULL,
  `mo_ti_id` int(11) DEFAULT NULL,
  `mo_datacreazione` date DEFAULT NULL,
  `mo_flag_ns` decimal(1,0) DEFAULT NULL,
  `mo_flag_ok` char(1) DEFAULT NULL,
  `mo_pic` varchar(255) DEFAULT NULL,
  `mo_id_padre` int(11) DEFAULT NULL,
  `mo_ma_desc` varchar(50) DEFAULT NULL,
  `mo_ct` bigint(20) DEFAULT NULL,
  `mo_mis` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello_872`
--

DROP TABLE IF EXISTS `modello_872`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello_872` (
  `mo_id` int(11) DEFAULT NULL,
  `mo_desc` varchar(100) DEFAULT NULL,
  `mo_ma_id` int(11) DEFAULT NULL,
  `mo_fa_id` int(11) DEFAULT NULL,
  `mo_ti_id` int(11) DEFAULT NULL,
  `mo_datacreazione` date DEFAULT NULL,
  `mo_flag_ns` decimal(1,0) DEFAULT NULL,
  `mo_flag_ok` char(1) DEFAULT NULL,
  `mo_pic` varchar(255) DEFAULT NULL,
  `mo_id_padre` int(11) DEFAULT NULL,
  `mo_ma_desc` varchar(50) DEFAULT NULL,
  `mo_ct` bigint(20) DEFAULT NULL,
  `mo_mis` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `modello_caratteristica`
--

DROP TABLE IF EXISTS `modello_caratteristica`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modello_caratteristica` (
  `mc_mo_id` int(11) DEFAULT NULL,
  `mc_cr_id` int(11) DEFAULT NULL,
  `mc_value` varchar(60) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `nazione`
--

DROP TABLE IF EXISTS `nazione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nazione` (
  `na_id` tinyint(4) DEFAULT NULL,
  `na_desc` varchar(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `nazione_famiglia`
--

DROP TABLE IF EXISTS `nazione_famiglia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nazione_famiglia` (
  `nf_fa_id` int(11) DEFAULT NULL,
  `nf_na_id` tinyint(4) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `nril`
--

DROP TABLE IF EXISTS `nril`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nril` (
  `AZID` int(11) DEFAULT NULL,
  `NAZ` int(11) DEFAULT NULL,
  `NRIL` int(11) DEFAULT NULL,
  `NVIS` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `panel`
--

DROP TABLE IF EXISTS `panel`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `panel` (
  `pl_periodo` int(11) DEFAULT NULL,
  `pl_anno` int(11) DEFAULT NULL,
  `pl_tipo` char(2) DEFAULT NULL,
  `pl_si_id` int(11) DEFAULT NULL,
  `pl_pv_id` int(11) DEFAULT NULL,
  `pl_fa_id` int(11) DEFAULT NULL,
  `pl_ti_id` int(11) DEFAULT NULL,
  `pl_ca_id` int(11) DEFAULT NULL,
  `pl_mr_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `produttore`
--

DROP TABLE IF EXISTS `produttore`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `produttore` (
  `pd_id` int(11) DEFAULT NULL,
  `pd_desc` varchar(50) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `puntovendita`
--

DROP TABLE IF EXISTS `puntovendita`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puntovendita` (
  `pv_id` int(11) DEFAULT NULL,
  `pv_desc` varchar(60) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_indirizzo` varchar(60) DEFAULT NULL,
  `pv_citta` varchar(70) DEFAULT NULL,
  `pv_pn_id` char(3) DEFAULT NULL,
  `pv_cap` varchar(20) DEFAULT NULL,
  `pv_latitudine` double DEFAULT NULL,
  `pv_longitudine` double DEFAULT NULL,
  `pv_datanascita` date DEFAULT NULL,
  `pv_datamorte` date DEFAULT NULL,
  `pv_telefono` varchar(30) DEFAULT NULL,
  `pv_fr_id` int(11) DEFAULT NULL,
  `pv_cd_id` int(11) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pv_co_id` bigint(20) DEFAULT NULL,
  `pv_mq` smallint(6) DEFAULT NULL,
  `pv_image` varchar(30) DEFAULT NULL,
  `pv_re_id` smallint(6) DEFAULT NULL,
  `pv_pot_iss` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `puntovendita_1`
--

DROP TABLE IF EXISTS `puntovendita_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puntovendita_1` (
  `pv_id` int(11) DEFAULT NULL,
  `pv_desc` varchar(60) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_indirizzo` varchar(60) DEFAULT NULL,
  `pv_citta` varchar(70) DEFAULT NULL,
  `pv_pn_id` char(3) DEFAULT NULL,
  `pv_cap` varchar(20) DEFAULT NULL,
  `pv_latitudine` double DEFAULT NULL,
  `pv_longitudine` double DEFAULT NULL,
  `pv_datanascita` date DEFAULT NULL,
  `pv_datamorte` date DEFAULT NULL,
  `pv_telefono` varchar(30) DEFAULT NULL,
  `pv_fr_id` int(11) DEFAULT NULL,
  `pv_cd_id` int(11) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pv_co_id` bigint(20) DEFAULT NULL,
  `pv_mq` smallint(6) DEFAULT NULL,
  `pv_image` varchar(30) DEFAULT NULL,
  `pv_re_id` smallint(6) DEFAULT NULL,
  `pv_pot_iss` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `puntovendita_1107`
--

DROP TABLE IF EXISTS `puntovendita_1107`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puntovendita_1107` (
  `pv_id` int(11) DEFAULT NULL,
  `pv_desc` varchar(60) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_indirizzo` varchar(60) DEFAULT NULL,
  `pv_citta` varchar(70) DEFAULT NULL,
  `pv_pn_id` char(3) DEFAULT NULL,
  `pv_cap` varchar(20) DEFAULT NULL,
  `pv_latitudine` double DEFAULT NULL,
  `pv_longitudine` double DEFAULT NULL,
  `pv_datanascita` date DEFAULT NULL,
  `pv_datamorte` date DEFAULT NULL,
  `pv_telefono` varchar(30) DEFAULT NULL,
  `pv_fr_id` int(11) DEFAULT NULL,
  `pv_cd_id` int(11) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pv_co_id` bigint(20) DEFAULT NULL,
  `pv_mq` smallint(6) DEFAULT NULL,
  `pv_image` varchar(30) DEFAULT NULL,
  `pv_re_id` smallint(6) DEFAULT NULL,
  `pv_pot_iss` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `puntovendita_1263`
--

DROP TABLE IF EXISTS `puntovendita_1263`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puntovendita_1263` (
  `pv_id` int(11) DEFAULT NULL,
  `pv_desc` varchar(60) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_indirizzo` varchar(60) DEFAULT NULL,
  `pv_citta` varchar(70) DEFAULT NULL,
  `pv_pn_id` char(3) DEFAULT NULL,
  `pv_cap` varchar(20) DEFAULT NULL,
  `pv_latitudine` double DEFAULT NULL,
  `pv_longitudine` double DEFAULT NULL,
  `pv_datanascita` date DEFAULT NULL,
  `pv_datamorte` date DEFAULT NULL,
  `pv_telefono` varchar(30) DEFAULT NULL,
  `pv_fr_id` int(11) DEFAULT NULL,
  `pv_cd_id` int(11) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pv_co_id` bigint(20) DEFAULT NULL,
  `pv_mq` smallint(6) DEFAULT NULL,
  `pv_image` varchar(30) DEFAULT NULL,
  `pv_re_id` smallint(6) DEFAULT NULL,
  `pv_pot_iss` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `puntovendita_1272`
--

DROP TABLE IF EXISTS `puntovendita_1272`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puntovendita_1272` (
  `pv_id` int(11) DEFAULT NULL,
  `pv_desc` varchar(60) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_indirizzo` varchar(60) DEFAULT NULL,
  `pv_citta` varchar(70) DEFAULT NULL,
  `pv_pn_id` char(3) DEFAULT NULL,
  `pv_cap` varchar(20) DEFAULT NULL,
  `pv_latitudine` double DEFAULT NULL,
  `pv_longitudine` double DEFAULT NULL,
  `pv_datanascita` date DEFAULT NULL,
  `pv_datamorte` date DEFAULT NULL,
  `pv_telefono` varchar(30) DEFAULT NULL,
  `pv_fr_id` int(11) DEFAULT NULL,
  `pv_cd_id` int(11) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pv_co_id` bigint(20) DEFAULT NULL,
  `pv_mq` smallint(6) DEFAULT NULL,
  `pv_image` varchar(30) DEFAULT NULL,
  `pv_re_id` smallint(6) DEFAULT NULL,
  `pv_pot_iss` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `puntovendita_1401`
--

DROP TABLE IF EXISTS `puntovendita_1401`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puntovendita_1401` (
  `pv_id` int(11) DEFAULT NULL,
  `pv_desc` varchar(60) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_indirizzo` varchar(60) DEFAULT NULL,
  `pv_citta` varchar(70) DEFAULT NULL,
  `pv_pn_id` char(3) DEFAULT NULL,
  `pv_cap` varchar(20) DEFAULT NULL,
  `pv_latitudine` double DEFAULT NULL,
  `pv_longitudine` double DEFAULT NULL,
  `pv_datanascita` date DEFAULT NULL,
  `pv_datamorte` date DEFAULT NULL,
  `pv_telefono` varchar(30) DEFAULT NULL,
  `pv_fr_id` int(11) DEFAULT NULL,
  `pv_cd_id` int(11) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pv_co_id` bigint(20) DEFAULT NULL,
  `pv_mq` smallint(6) DEFAULT NULL,
  `pv_image` varchar(30) DEFAULT NULL,
  `pv_re_id` smallint(6) DEFAULT NULL,
  `pv_pot_iss` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `puntovendita_453`
--

DROP TABLE IF EXISTS `puntovendita_453`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puntovendita_453` (
  `pv_id` int(11) DEFAULT NULL,
  `pv_desc` varchar(60) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_indirizzo` varchar(60) DEFAULT NULL,
  `pv_citta` varchar(70) DEFAULT NULL,
  `pv_pn_id` char(3) DEFAULT NULL,
  `pv_cap` varchar(20) DEFAULT NULL,
  `pv_latitudine` double DEFAULT NULL,
  `pv_longitudine` double DEFAULT NULL,
  `pv_datanascita` date DEFAULT NULL,
  `pv_datamorte` date DEFAULT NULL,
  `pv_telefono` varchar(30) DEFAULT NULL,
  `pv_fr_id` int(11) DEFAULT NULL,
  `pv_cd_id` int(11) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pv_co_id` bigint(20) DEFAULT NULL,
  `pv_mq` smallint(6) DEFAULT NULL,
  `pv_image` varchar(30) DEFAULT NULL,
  `pv_re_id` smallint(6) DEFAULT NULL,
  `pv_pot_iss` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `puntovendita_622`
--

DROP TABLE IF EXISTS `puntovendita_622`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puntovendita_622` (
  `pv_id` int(11) DEFAULT NULL,
  `pv_desc` varchar(60) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_indirizzo` varchar(60) DEFAULT NULL,
  `pv_citta` varchar(70) DEFAULT NULL,
  `pv_pn_id` char(3) DEFAULT NULL,
  `pv_cap` varchar(20) DEFAULT NULL,
  `pv_latitudine` double DEFAULT NULL,
  `pv_longitudine` double DEFAULT NULL,
  `pv_datanascita` date DEFAULT NULL,
  `pv_datamorte` date DEFAULT NULL,
  `pv_telefono` varchar(30) DEFAULT NULL,
  `pv_fr_id` int(11) DEFAULT NULL,
  `pv_cd_id` int(11) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pv_co_id` bigint(20) DEFAULT NULL,
  `pv_mq` smallint(6) DEFAULT NULL,
  `pv_image` varchar(30) DEFAULT NULL,
  `pv_re_id` smallint(6) DEFAULT NULL,
  `pv_pot_iss` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `puntovendita_628`
--

DROP TABLE IF EXISTS `puntovendita_628`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puntovendita_628` (
  `pv_id` int(11) DEFAULT NULL,
  `pv_desc` varchar(60) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_indirizzo` varchar(60) DEFAULT NULL,
  `pv_citta` varchar(70) DEFAULT NULL,
  `pv_pn_id` char(3) DEFAULT NULL,
  `pv_cap` varchar(20) DEFAULT NULL,
  `pv_latitudine` double DEFAULT NULL,
  `pv_longitudine` double DEFAULT NULL,
  `pv_datanascita` date DEFAULT NULL,
  `pv_datamorte` date DEFAULT NULL,
  `pv_telefono` varchar(30) DEFAULT NULL,
  `pv_fr_id` int(11) DEFAULT NULL,
  `pv_cd_id` int(11) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pv_co_id` bigint(20) DEFAULT NULL,
  `pv_mq` smallint(6) DEFAULT NULL,
  `pv_image` varchar(30) DEFAULT NULL,
  `pv_re_id` smallint(6) DEFAULT NULL,
  `pv_pot_iss` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `puntovendita_872`
--

DROP TABLE IF EXISTS `puntovendita_872`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puntovendita_872` (
  `pv_id` int(11) DEFAULT NULL,
  `pv_desc` varchar(60) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_indirizzo` varchar(60) DEFAULT NULL,
  `pv_citta` varchar(70) DEFAULT NULL,
  `pv_pn_id` char(3) DEFAULT NULL,
  `pv_cap` varchar(20) DEFAULT NULL,
  `pv_latitudine` double DEFAULT NULL,
  `pv_longitudine` double DEFAULT NULL,
  `pv_datanascita` date DEFAULT NULL,
  `pv_datamorte` date DEFAULT NULL,
  `pv_telefono` varchar(30) DEFAULT NULL,
  `pv_fr_id` int(11) DEFAULT NULL,
  `pv_cd_id` int(11) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pv_co_id` bigint(20) DEFAULT NULL,
  `pv_mq` smallint(6) DEFAULT NULL,
  `pv_image` varchar(30) DEFAULT NULL,
  `pv_re_id` smallint(6) DEFAULT NULL,
  `pv_pot_iss` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `qanalisi`
--

DROP TABLE IF EXISTS `qanalisi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qanalisi` (
  `qa_id` smallint(6) DEFAULT NULL,
  `qa_desc` varchar(50) DEFAULT NULL,
  `qa_enabled` char(1) DEFAULT NULL,
  `qa_qt_id` bigint(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `qanalisi_lang`
--

DROP TABLE IF EXISTS `qanalisi_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qanalisi_lang` (
  `qal_qa_id` smallint(6) DEFAULT NULL,
  `qal_lg_id` tinyint(4) DEFAULT NULL,
  `qal_desc` varchar(50) DEFAULT NULL,
  `qal_help` varchar(100) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `qanalisi_tab`
--

DROP TABLE IF EXISTS `qanalisi_tab`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qanalisi_tab` (
  `qt_id` bigint(20) DEFAULT NULL,
  `qt_desc` varchar(30) DEFAULT NULL,
  `qt_icon` varchar(30) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `qanalisi_tab_lang`
--

DROP TABLE IF EXISTS `qanalisi_tab_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qanalisi_tab_lang` (
  `qtl_qt_id` bigint(20) DEFAULT NULL,
  `qtl_lg_id` tinyint(4) DEFAULT NULL,
  `qtl_desc` varchar(100) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ra_15`
--

DROP TABLE IF EXISTS `ra_15`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ra_15` (
  `ra_ri_id` bigint(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ra_22`
--

DROP TABLE IF EXISTS `ra_22`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ra_22` (
  `ra_ri_id` bigint(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ra_42`
--

DROP TABLE IF EXISTS `ra_42`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ra_42` (
  `ra_ri_id` bigint(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ra_43`
--

DROP TABLE IF EXISTS `ra_43`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ra_43` (
  `ra_ri_id` bigint(20) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rilevazione`
--

DROP TABLE IF EXISTS `rilevazione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rilevazione` (
  `ri_id` bigint(20) DEFAULT NULL,
  `ri_vi_id` bigint(20) DEFAULT NULL,
  `ri_mo_id` int(11) DEFAULT NULL,
  `ri_rw_id` int(11) DEFAULT NULL,
  `ri_codice` varchar(30) DEFAULT NULL,
  `ri_va_id` tinyint(4) DEFAULT NULL,
  `ri_prezzo` decimal(11,2) DEFAULT NULL,
  `ri_prezzo_listino` decimal(11,2) DEFAULT NULL,
  `ri_prezzo_spedizione` decimal(11,2) DEFAULT NULL,
  `ri_npezzi` int(11) DEFAULT NULL,
  `ri_pgdir` bigint(20) DEFAULT NULL,
  `ri_posizione` tinyint(4) DEFAULT NULL,
  `ri_fa_id` int(11) DEFAULT NULL,
  `ri_ca_id` int(11) DEFAULT NULL,
  `ri_mr_id` int(11) DEFAULT NULL,
  `ri_ma_id` int(11) DEFAULT NULL,
  `ri_pd_id` int(11) DEFAULT NULL,
  `ri_pv_id` int(11) DEFAULT NULL,
  `ri_ti_id` int(11) DEFAULT NULL,
  `ri_re_id` int(11) DEFAULT NULL,
  `ri_pn_id` char(1) DEFAULT NULL,
  `ri_in_id` int(11) DEFAULT NULL,
  `ri_cn_id` tinyint(4) DEFAULT NULL,
  `ri_af_id` int(11) DEFAULT NULL,
  `ri_na_id` tinyint(4) DEFAULT NULL,
  `ri_data` date DEFAULT NULL,
  `ri_settimana` int(11) DEFAULT NULL,
  `ri_mese` int(11) DEFAULT NULL,
  `ri_periodo` int(11) DEFAULT NULL,
  `ri_si_id` int(11) DEFAULT NULL,
  `ri_ce_id` int(11) DEFAULT NULL,
  `ri_prezzouni` decimal(9,2) DEFAULT NULL,
  `ri_mo_ct` int(11) DEFAULT NULL,
  `ri_prezzomis` decimal(9,2) DEFAULT NULL,
  `ri_mo_mis` float DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tipo`
--

DROP TABLE IF EXISTS `tipo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tipo` (
  `ti_id` int(11) DEFAULT NULL,
  `ti_desc` varchar(40) DEFAULT NULL,
  `ti_fa_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tipo_lang`
--

DROP TABLE IF EXISTS `tipo_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tipo_lang` (
  `til_ti_id` int(11) DEFAULT NULL,
  `til_lg_id` int(11) DEFAULT NULL,
  `til_desc` varchar(100) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `valuta`
--

DROP TABLE IF EXISTS `valuta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `valuta` (
  `va_id` tinyint(4) DEFAULT NULL,
  `va_desc` varchar(40) DEFAULT NULL,
  `va_code` char(3) DEFAULT NULL,
  `va_sigla` varchar(3) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `visita`
--

DROP TABLE IF EXISTS `visita`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `visita` (
  `vi_id` bigint(20) DEFAULT NULL,
  `vi_pv_id` int(11) DEFAULT NULL,
  `vi_mese` int(11) DEFAULT NULL,
  `vi_data` date DEFAULT NULL,
  `vi_periodo` int(11) DEFAULT NULL,
  `vi_nota` char(1) DEFAULT NULL,
  `vi_in_id` int(11) DEFAULT NULL,
  `vi_af_id` int(11) DEFAULT NULL,
  `vi_re_id` int(11) DEFAULT NULL,
  `vi_pn_id` char(1) DEFAULT NULL,
  `vi_si_id` int(11) DEFAULT NULL,
  `vi_nril` bigint(20) DEFAULT NULL,
  `vi_ce_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `visiteweb`
--

DROP TABLE IF EXISTS `visiteweb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `visiteweb` (
  `vw_id` int(11) DEFAULT NULL,
  `vi_tipo` varchar(2) DEFAULT NULL,
  `vi_id` bigint(20) DEFAULT NULL,
  `vw_si_id` int(11) DEFAULT NULL,
  `vw_cd_id` int(11) DEFAULT NULL,
  `vw_giorno` date DEFAULT NULL,
  `vw_mese` int(11) DEFAULT NULL,
  `vw_periodo` int(11) DEFAULT NULL,
  `pv_id` int(11) DEFAULT NULL,
  `pv_in_id` int(11) DEFAULT NULL,
  `pv_af_id` int(11) DEFAULT NULL,
  `pv_na_id` tinyint(4) DEFAULT NULL,
  `pv_pn_id` char(1) DEFAULT NULL,
  `pv_cn_id` tinyint(4) DEFAULT NULL,
  `pn_re_id` int(11) DEFAULT NULL,
  `vw_settimana` int(11) DEFAULT NULL,
  `CEID` int(11) DEFAULT NULL
) ENGINE=Columnstore 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 2021-07-16 23:03:25
SET sql_log_bin = 1;