CREATE DATABASE  IF NOT EXISTS `SSB_TEST` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `SSB_TEST`;
-- MySQL dump 10.13  Distrib 8.0.19, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: SSB_TEST
-- ------------------------------------------------------
-- Server version	5.7.36

/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!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 `COLUMN`
--

DROP TABLE IF EXISTS `COLUMN`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `COLUMN` (
                          `column_id` varchar(255) NOT NULL,
                          `column_name` varchar(255) NOT NULL,
                          `column_type` varchar(255) NOT NULL,
                          `isKey` int(11) NOT NULL,
                          `relationship_id` varchar(255) DEFAULT NULL,
                          `table_id` varchar(255) NOT NULL,
                          PRIMARY KEY (`column_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `COLUMN`
--

LOCK TABLES `COLUMN` WRITE;
/*!40000 ALTER TABLE `COLUMN` DISABLE KEYS */;
INSERT INTO `COLUMN` VALUES ('SSB_TEST_CUSTOMER_all_SSB_TEST_CUSTOMER','all_SSB_TEST_CUSTOMER','NULL',0,NULL,'SSB_TEST_CUSTOMER'),('SSB_TEST_CUSTOMER_CITY','CITY','VARCHAR',0,NULL,'SSB_TEST_CUSTOMER'),('SSB_TEST_CUSTOMER_CUSTKEY','CUSTKEY','NUMERIC',0,NULL,'SSB_TEST_CUSTOMER'),('SSB_TEST_CUSTOMER_CUSTOMER','CUSTOMER','VARCHAR',0,NULL,'SSB_TEST_CUSTOMER'),('SSB_TEST_CUSTOMER_POPULATION','POPULATION','NUMERIC',0,NULL,'SSB_TEST_CUSTOMER'),('SSB_TEST_LINEORDER_CUSTKEY','CUSTKEY','NUMERIC',1,'SSB_TEST_LINEORDER_SSB_TEST_CUSTOMER','SSB_TEST_LINEORDER'),('SSB_TEST_LINEORDER_EXTENDEDPRICE','EXTENDEDPRICE','FLOAT',0,NULL,'SSB_TEST_LINEORDER'),('SSB_TEST_LINEORDER_ORDTOTALPRICE','ORDTOTALPRICE','FLOAT',0,NULL,'SSB_TEST_LINEORDER'),('SSB_TEST_LINEORDER_PARTKEY','PARTKEY','NUMERIC',1,'SSB_TEST_LINEORDER_SSB_TEST_PART','SSB_TEST_LINEORDER'),('SSB_TEST_LINEORDER_QUANTITY','QUANTITY','FLOAT',0,NULL,'SSB_TEST_LINEORDER'),('SSB_TEST_PART_all_SSB_TEST_PART','all_SSB_TEST_PART','NULL',0,NULL,'SSB_TEST_PART'),('SSB_TEST_PART_CATEGORY','CATEGORY','VARCHAR',0,NULL,'SSB_TEST_PART'),('SSB_TEST_PART_PARTKEY','PARTKEY','NUMERIC',0,NULL,'SSB_TEST_PART'),('SSB_TEST_PART_PRODUCT','PRODUCT','VARCHAR',0,NULL,'SSB_TEST_PART');
/*!40000 ALTER TABLE `COLUMN` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `DATABASE`
--

DROP TABLE IF EXISTS `DATABASE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `DATABASE` (
                            `database_id` varchar(255) NOT NULL,
                            `database_name` varchar(255) NOT NULL,
                            `IPaddress` varchar(16) NOT NULL,
                            `port` int(11) NOT NULL,
                            PRIMARY KEY (`database_id`),
                            UNIQUE KEY `database_name` (`database_name`,`IPaddress`,`port`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `DATABASE`
--

LOCK TABLES `DATABASE` WRITE;
/*!40000 ALTER TABLE `DATABASE` DISABLE KEYS */;
INSERT INTO `DATABASE` VALUES ('research','research','137.204.74.10',1521);
/*!40000 ALTER TABLE `DATABASE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `FACT`
--

DROP TABLE IF EXISTS `FACT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FACT` (
                        `fact_id` varchar(255) NOT NULL,
                        `fact_name` varchar(255) NOT NULL,
                        `fact_synonyms` varchar(1000) DEFAULT NULL,
                        `database_id` varchar(255) DEFAULT NULL,
                        PRIMARY KEY (`fact_id`),
                        UNIQUE KEY `fact_name` (`fact_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `FACT`
--

LOCK TABLES `FACT` WRITE;
/*!40000 ALTER TABLE `FACT` DISABLE KEYS */;
INSERT INTO `FACT` VALUES ('SSB_TEST_LINEORDER','SSB_TEST_LINEORDER',NULL,'research');
/*!40000 ALTER TABLE `FACT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `GROUPBYOPERATOR`
--

DROP TABLE IF EXISTS `GROUPBYOPERATOR`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `GROUPBYOPERATOR` (
                                   `groupbyoperator_id` varchar(255) NOT NULL,
                                   `groupbyoperator_name` varchar(255) NOT NULL,
                                   `groupbyoperator_synonyms` varchar(1000) DEFAULT NULL,
                                   PRIMARY KEY (`groupbyoperator_id`),
                                   UNIQUE KEY `groupbyoperator_name` (`groupbyoperator_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `GROUPBYOPERATOR`
--

LOCK TABLES `GROUPBYOPERATOR` WRITE;
/*!40000 ALTER TABLE `GROUPBYOPERATOR` DISABLE KEYS */;
/*!40000 ALTER TABLE `GROUPBYOPERATOR` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `GROUPBYOPERATOR_OF_MEASURE`
--

DROP TABLE IF EXISTS `GROUPBYOPERATOR_OF_MEASURE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `GROUPBYOPERATOR_OF_MEASURE` (
                                              `groupbyoperator_id` varchar(255) NOT NULL,
                                              `measure_id` varchar(255) NOT NULL,
                                              PRIMARY KEY (`groupbyoperator_id`,`measure_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `GROUPBYOPERATOR_OF_MEASURE`
--

LOCK TABLES `GROUPBYOPERATOR_OF_MEASURE` WRITE;
/*!40000 ALTER TABLE `GROUPBYOPERATOR_OF_MEASURE` DISABLE KEYS */;
/*!40000 ALTER TABLE `GROUPBYOPERATOR_OF_MEASURE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `HIERARCHY`
--

DROP TABLE IF EXISTS `HIERARCHY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `HIERARCHY` (
                             `hierarchy_id` varchar(255) NOT NULL,
                             `hierarchy_name` varchar(255) NOT NULL,
                             `hierarchy_synonyms` varchar(1000) DEFAULT NULL,
                             PRIMARY KEY (`hierarchy_id`),
                             UNIQUE KEY `hierarchy_name` (`hierarchy_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `HIERARCHY`
--

LOCK TABLES `HIERARCHY` WRITE;
/*!40000 ALTER TABLE `HIERARCHY` DISABLE KEYS */;
INSERT INTO `HIERARCHY` VALUES ('SSB_TEST_CUSTOMER','SSB_TEST_CUSTOMER',NULL),('SSB_TEST_PART','SSB_TEST_PART',NULL);
/*!40000 ALTER TABLE `HIERARCHY` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `HIERARCHY_IN_FACT`
--

DROP TABLE IF EXISTS `HIERARCHY_IN_FACT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `HIERARCHY_IN_FACT` (
                                     `fact_id` varchar(255) NOT NULL,
                                     `hierarchy_id` varchar(255) NOT NULL,
                                     PRIMARY KEY (`fact_id`,`hierarchy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `HIERARCHY_IN_FACT`
--

LOCK TABLES `HIERARCHY_IN_FACT` WRITE;
/*!40000 ALTER TABLE `HIERARCHY_IN_FACT` DISABLE KEYS */;
INSERT INTO `HIERARCHY_IN_FACT` VALUES ('SSB_TEST_LINEORDER','SSB_TEST_CUSTOMER'),('SSB_TEST_LINEORDER','SSB_TEST_PART');
/*!40000 ALTER TABLE `HIERARCHY_IN_FACT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `LANGUAGE_OPERATOR`
--

DROP TABLE IF EXISTS `LANGUAGE_OPERATOR`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `LANGUAGE_OPERATOR` (
                                     `language_operator_id` varchar(255) NOT NULL,
                                     `language_operator_name` varchar(255) NOT NULL,
                                     `language_operator_synonyms` varchar(1000) DEFAULT NULL,
                                     `language_operator_type` varchar(255) DEFAULT NULL,
                                     PRIMARY KEY (`language_operator_id`),
                                     UNIQUE KEY `language_operator_name` (`language_operator_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `LANGUAGE_OPERATOR`
--

LOCK TABLES `LANGUAGE_OPERATOR` WRITE;
/*!40000 ALTER TABLE `LANGUAGE_OPERATOR` DISABLE KEYS */;
/*!40000 ALTER TABLE `LANGUAGE_OPERATOR` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `LANGUAGE_PREDICATE`
--

DROP TABLE IF EXISTS `LANGUAGE_PREDICATE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `LANGUAGE_PREDICATE` (
                                      `language_predicate_id` varchar(255) NOT NULL,
                                      `language_predicate_name` varchar(255) NOT NULL,
                                      `language_predicate_synonyms` varchar(1000) DEFAULT NULL,
                                      `language_predicate_type` varchar(255) DEFAULT NULL,
                                      PRIMARY KEY (`language_predicate_id`),
                                      UNIQUE KEY `language_predicate_name` (`language_predicate_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `LANGUAGE_PREDICATE`
--

LOCK TABLES `LANGUAGE_PREDICATE` WRITE;
/*!40000 ALTER TABLE `LANGUAGE_PREDICATE` DISABLE KEYS */;
/*!40000 ALTER TABLE `LANGUAGE_PREDICATE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `LEVEL`
--

DROP TABLE IF EXISTS `LEVEL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `LEVEL` (
                         `level_id` varchar(255) NOT NULL,
                         `level_type` varchar(255) NOT NULL,
                         `level_description` varchar(200) DEFAULT NULL,
                         `level_name` varchar(255) NOT NULL,
                         `cardinality` int(11) DEFAULT NULL,
                         `hierarchy_id` varchar(255) NOT NULL,
                         `level_synonyms` varchar(1000) DEFAULT NULL,
                         `column_id` varchar(255) NOT NULL,
                         `MIN` double DEFAULT NULL,
                         `MAX` double DEFAULT NULL,
                         `AVG` double DEFAULT NULL,
                         `isDescriptive` int(11) DEFAULT '0',
                         `mindate` date DEFAULT NULL,
                         `maxdate` date DEFAULT NULL,
                         PRIMARY KEY (`level_id`),
                         UNIQUE KEY `level_name` (`level_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `LEVEL`
--

LOCK TABLES `LEVEL` WRITE;
/*!40000 ALTER TABLE `LEVEL` DISABLE KEYS */;
INSERT INTO `LEVEL` VALUES ('SSB_TEST_CUSTOMER_all_SSB_TEST_CUSTOMER','NULL',NULL,'all_SSB_TEST_CUSTOMER',NULL,'SSB_TEST_CUSTOMER',NULL,'SSB_TEST_CUSTOMER_all_SSB_TEST_CUSTOMER',NULL,NULL,NULL,0,NULL,NULL),('SSB_TEST_CUSTOMER_CITY','VARCHAR',NULL,'CITY',2,'SSB_TEST_CUSTOMER',NULL,'SSB_TEST_CUSTOMER_CITY',NULL,NULL,NULL,0,NULL,NULL),('SSB_TEST_CUSTOMER_CUSTKEY','NUMERIC',NULL,'CUSTKEY',10,'SSB_TEST_CUSTOMER',NULL,'SSB_TEST_CUSTOMER_CUSTKEY',1,10,5.5,0,NULL,NULL),('SSB_TEST_CUSTOMER_CUSTOMER','VARCHAR',NULL,'CUSTOMER',10,'SSB_TEST_CUSTOMER',NULL,'SSB_TEST_CUSTOMER_CUSTOMER',NULL,NULL,NULL,0,NULL,NULL),('SSB_TEST_CUSTOMER_POPULATION','NUMERIC',NULL,'POPULATION',1,'SSB_TEST_CUSTOMER',NULL,'SSB_TEST_CUSTOMER_POPULATION',0,0,0,0,NULL,NULL),('SSB_TEST_PART_all_SSB_TEST_PART','NULL',NULL,'all_SSB_TEST_PART',NULL,'SSB_TEST_PART',NULL,'SSB_TEST_PART_all_SSB_TEST_PART',NULL,NULL,NULL,0,NULL,NULL),('SSB_TEST_PART_CATEGORY','VARCHAR',NULL,'CATEGORY',3,'SSB_TEST_PART',NULL,'SSB_TEST_PART_CATEGORY',NULL,NULL,NULL,0,NULL,NULL),('SSB_TEST_PART_PARTKEY','NUMERIC',NULL,'PARTKEY',10,'SSB_TEST_PART',NULL,'SSB_TEST_PART_PARTKEY',1,10,5.5,0,NULL,NULL),('SSB_TEST_PART_PRODUCT','VARCHAR',NULL,'PRODUCT',10,'SSB_TEST_PART',NULL,'SSB_TEST_PART_PRODUCT',NULL,NULL,NULL,0,NULL,NULL);
/*!40000 ALTER TABLE `LEVEL` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `MEASURE`
--

DROP TABLE IF EXISTS `MEASURE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `MEASURE` (
                           `measure_id` varchar(255) NOT NULL,
                           `measure_name` varchar(255) NOT NULL,
                           `fact_id` varchar(255) NOT NULL,
                           `measure_synonyms` varchar(1000) DEFAULT NULL,
                           `column_id` varchar(255) NOT NULL,
                           PRIMARY KEY (`measure_id`),
                           UNIQUE KEY `measure_name` (`measure_name`,`fact_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `MEASURE`
--

LOCK TABLES `MEASURE` WRITE;
/*!40000 ALTER TABLE `MEASURE` DISABLE KEYS */;
INSERT INTO `MEASURE` VALUES ('EXTENDEDPRICE','EXTENDEDPRICE','SSB_TEST_LINEORDER',NULL,'SSB_TEST_LINEORDER_EXTENDEDPRICE'),('ORDTOTALPRICE','ORDTOTALPRICE','SSB_TEST_LINEORDER',NULL,'SSB_TEST_LINEORDER_ORDTOTALPRICE'),('QUANTITY','QUANTITY','SSB_TEST_LINEORDER',NULL,'SSB_TEST_LINEORDER_QUANTITY');
/*!40000 ALTER TABLE `MEASURE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `MEMBER`
--

DROP TABLE IF EXISTS `MEMBER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `MEMBER` (
                          `member_id` varchar(255) NOT NULL,
                          `member_name` varchar(255) NOT NULL,
                          `level_id` varchar(255) NOT NULL,
                          `member_synonyms` varchar(1000) DEFAULT NULL,
                          PRIMARY KEY (`member_id`),
                          UNIQUE KEY `member_name` (`member_name`,`level_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `MEMBER`
--

LOCK TABLES `MEMBER` WRITE;
/*!40000 ALTER TABLE `MEMBER` DISABLE KEYS */;
INSERT INTO `MEMBER` VALUES ('0','1','SSB_TEST_CUSTOMER_CUSTKEY',NULL),('1','2','SSB_TEST_CUSTOMER_CUSTKEY',NULL),('10','c08','SSB_TEST_CUSTOMER_CUSTOMER',NULL),('11','c01','SSB_TEST_CUSTOMER_CUSTOMER',NULL),('12','c03','SSB_TEST_CUSTOMER_CUSTOMER',NULL),('13','c06','SSB_TEST_CUSTOMER_CUSTOMER',NULL),('14','c07','SSB_TEST_CUSTOMER_CUSTOMER',NULL),('15','c10','SSB_TEST_CUSTOMER_CUSTOMER',NULL),('16','c04','SSB_TEST_CUSTOMER_CUSTOMER',NULL),('17','c05','SSB_TEST_CUSTOMER_CUSTOMER',NULL),('18','c02','SSB_TEST_CUSTOMER_CUSTOMER',NULL),('19','c09','SSB_TEST_CUSTOMER_CUSTOMER',NULL),('2','3','SSB_TEST_CUSTOMER_CUSTKEY',NULL),('20','France','SSB_TEST_CUSTOMER_CITY',NULL),('21','Italy','SSB_TEST_CUSTOMER_CITY',NULL),('22','0','SSB_TEST_CUSTOMER_POPULATION',NULL),('23','1','SSB_TEST_PART_PARTKEY',NULL),('24','2','SSB_TEST_PART_PARTKEY',NULL),('25','3','SSB_TEST_PART_PARTKEY',NULL),('26','4','SSB_TEST_PART_PARTKEY',NULL),('27','5','SSB_TEST_PART_PARTKEY',NULL),('28','6','SSB_TEST_PART_PARTKEY',NULL),('29','7','SSB_TEST_PART_PARTKEY',NULL),('3','4','SSB_TEST_CUSTOMER_CUSTKEY',NULL),('30','8','SSB_TEST_PART_PARTKEY',NULL),('31','9','SSB_TEST_PART_PARTKEY',NULL),('32','10','SSB_TEST_PART_PARTKEY',NULL),('33','Beer','SSB_TEST_PART_PRODUCT',NULL),('34','p06','SSB_TEST_PART_PRODUCT',NULL),('35','Cola','SSB_TEST_PART_PRODUCT',NULL),('36','p09','SSB_TEST_PART_PRODUCT',NULL),('37','p08','SSB_TEST_PART_PRODUCT',NULL),('38','p10','SSB_TEST_PART_PRODUCT',NULL),('39','Wine','SSB_TEST_PART_PRODUCT',NULL),('4','5','SSB_TEST_CUSTOMER_CUSTKEY',NULL),('40','Pizza','SSB_TEST_PART_PRODUCT',NULL),('41','Bread','SSB_TEST_PART_PRODUCT',NULL),('42','p07','SSB_TEST_PART_PRODUCT',NULL),('43','France','SSB_TEST_PART_CATEGORY',NULL),('44','Food','SSB_TEST_PART_CATEGORY',NULL),('45','Beverages','SSB_TEST_PART_CATEGORY',NULL),('5','6','SSB_TEST_CUSTOMER_CUSTKEY',NULL),('6','7','SSB_TEST_CUSTOMER_CUSTKEY',NULL),('7','8','SSB_TEST_CUSTOMER_CUSTKEY',NULL),('8','9','SSB_TEST_CUSTOMER_CUSTKEY',NULL),('9','10','SSB_TEST_CUSTOMER_CUSTKEY',NULL);
/*!40000 ALTER TABLE `MEMBER` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `OLAPSESSION`
--

DROP TABLE IF EXISTS `OLAPSESSION`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `OLAPSESSION` (
                               `TIMESTAMP` int(11) DEFAULT NULL,
                               `session_id` varchar(255) DEFAULT NULL,
                               `annotation_id` varchar(255) DEFAULT NULL,
                               `value_en` varchar(1000) DEFAULT NULL,
                               `value_ita` varchar(1000) DEFAULT NULL,
                               `LIMIT` mediumtext,
                               `fullquery_serialized` blob,
                               `fullquery_tree` varchar(1000) DEFAULT NULL,
                               `olapoperator_serialized` blob
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `OLAPSESSION`
--

LOCK TABLES `OLAPSESSION` WRITE;
/*!40000 ALTER TABLE `OLAPSESSION` DISABLE KEYS */;
/*!40000 ALTER TABLE `OLAPSESSION` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `QUERIES`
--

DROP TABLE IF EXISTS `QUERIES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `QUERIES` (
                           `query` varchar(1000) DEFAULT NULL,
                           `mc` varchar(255) DEFAULT NULL,
                           `gc` varchar(255) DEFAULT NULL,
                           `sc` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `QUERIES`
--

LOCK TABLES `QUERIES` WRITE;
/*!40000 ALTER TABLE `QUERIES` DISABLE KEYS */;
/*!40000 ALTER TABLE `QUERIES` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `RELATIONSHIP`
--

DROP TABLE IF EXISTS `RELATIONSHIP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `RELATIONSHIP` (
                                `relationship_id` varchar(255) NOT NULL,
                                `table1` varchar(255) NOT NULL,
                                `table2` varchar(255) NOT NULL,
                                PRIMARY KEY (`relationship_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `RELATIONSHIP`
--

LOCK TABLES `RELATIONSHIP` WRITE;
/*!40000 ALTER TABLE `RELATIONSHIP` DISABLE KEYS */;
INSERT INTO `RELATIONSHIP` VALUES ('SSB_TEST_LINEORDER_SSB_TEST_CUSTOMER','SSB_TEST_LINEORDER','SSB_TEST_CUSTOMER'),('SSB_TEST_LINEORDER_SSB_TEST_PART','SSB_TEST_LINEORDER','SSB_TEST_PART');
/*!40000 ALTER TABLE `RELATIONSHIP` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `SSB_TEST_CUSTOMER`
--

DROP TABLE IF EXISTS `SSB_TEST_CUSTOMER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `SSB_TEST_CUSTOMER` (
                                     `CUSTKEY` int(11) NOT NULL,
                                     `CUSTOMER` text,
                                     `CITY` text,
                                     `POPULATION` int(11) DEFAULT NULL,
                                     PRIMARY KEY (`CUSTKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `SSB_TEST_CUSTOMER`
--

LOCK TABLES `SSB_TEST_CUSTOMER` WRITE;
/*!40000 ALTER TABLE `SSB_TEST_CUSTOMER` DISABLE KEYS */;
INSERT INTO `SSB_TEST_CUSTOMER` VALUES (1,'c01','Italy',NULL),(2,'c02','Italy',NULL),(3,'c03','Italy',NULL),(4,'c04','Italy',NULL),(5,'c05','Italy',NULL),(6,'c06','France',NULL),(7,'c07','France',NULL),(8,'c08','France',NULL),(9,'c09','France',NULL),(10,'c10','France',NULL);
/*!40000 ALTER TABLE `SSB_TEST_CUSTOMER` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `SSB_TEST_LINEORDER`
--

DROP TABLE IF EXISTS `SSB_TEST_LINEORDER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `SSB_TEST_LINEORDER` (
                                      `CUSTKEY` int(11) NOT NULL,
                                      `PARTKEY` int(11) NOT NULL,
                                      `QUANTITY` float DEFAULT NULL,
                                      `EXTENDEDPRICE` float DEFAULT NULL,
                                      `ORDTOTALPRICE` float DEFAULT NULL,
                                      PRIMARY KEY (`CUSTKEY`,`PARTKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `SSB_TEST_LINEORDER`
--

LOCK TABLES `SSB_TEST_LINEORDER` WRITE;
/*!40000 ALTER TABLE `SSB_TEST_LINEORDER` DISABLE KEYS */;
INSERT INTO `SSB_TEST_LINEORDER` VALUES (1,1,20,10,100),(2,1,15,10,100),(2,2,17,10,100),(3,2,15,10,100),(3,3,15,10,100),(4,3,15,10,100),(4,4,6,10,100),(5,5,5,10,100);
/*!40000 ALTER TABLE `SSB_TEST_LINEORDER` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `SSB_TEST_PART`
--

DROP TABLE IF EXISTS `SSB_TEST_PART`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `SSB_TEST_PART` (
                                 `PARTKEY` int(11) NOT NULL,
                                 `PRODUCT` text,
                                 `CATEGORY` text,
                                 PRIMARY KEY (`PARTKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `SSB_TEST_PART`
--

LOCK TABLES `SSB_TEST_PART` WRITE;
/*!40000 ALTER TABLE `SSB_TEST_PART` DISABLE KEYS */;
INSERT INTO `SSB_TEST_PART` VALUES (1,'Beer','Beverages'),(2,'Wine','Beverages'),(3,'Cola','Beverages'),(4,'Pizza','Food'),(5,'Bread','Food'),(6,'p06','France'),(7,'p07','France'),(8,'p08','France'),(9,'p09','France'),(10,'p10','France');
/*!40000 ALTER TABLE `SSB_TEST_PART` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `SYNONYM`
--

DROP TABLE IF EXISTS `SYNONYM`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `SYNONYM` (
                           `synonym_id` varchar(255) NOT NULL,
                           `table_name` varchar(255) NOT NULL,
                           `reference_id` varchar(255) NOT NULL,
                           `TERM` varchar(255) NOT NULL,
                           PRIMARY KEY (`synonym_id`),
                           UNIQUE KEY `TERM` (`TERM`,`reference_id`,`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `SYNONYM`
--

LOCK TABLES `SYNONYM` WRITE;
/*!40000 ALTER TABLE `SYNONYM` DISABLE KEYS */;
INSERT INTO `SYNONYM` VALUES ('81','MEMBER','22','0'),('59','MEMBER','0','1'),('82','MEMBER','23','1'),('91','MEMBER','32','10'),('68','MEMBER','9','10'),('60','MEMBER','1','2'),('83','MEMBER','24','2'),('61','MEMBER','2','3'),('84','MEMBER','25','3'),('85','MEMBER','26','4'),('62','MEMBER','3','4'),('86','MEMBER','27','5'),('63','MEMBER','4','5'),('87','MEMBER','28','6'),('64','MEMBER','5','6'),('88','MEMBER','29','7'),('65','MEMBER','6','7'),('89','MEMBER','30','8'),('66','MEMBER','7','8'),('90','MEMBER','31','9'),('67','MEMBER','8','9'),('49','LEVEL','SSB_TEST_CUSTOMER_all_SSB_TEST_CUSTOMER','all_SSB_TEST_CUSTOMER'),('54','LEVEL','SSB_TEST_PART_all_SSB_TEST_PART','all_SSB_TEST_PART'),('92','MEMBER','33','Beer'),('104','MEMBER','45','Beverages'),('100','MEMBER','41','Bread'),('70','MEMBER','11','c01'),('77','MEMBER','18','c02'),('71','MEMBER','12','c03'),('75','MEMBER','16','c04'),('76','MEMBER','17','c05'),('72','MEMBER','13','c06'),('73','MEMBER','14','c07'),('69','MEMBER','10','c08'),('78','MEMBER','19','c09'),('74','MEMBER','15','c10'),('57','LEVEL','SSB_TEST_PART_CATEGORY','CATEGORY'),('52','LEVEL','SSB_TEST_CUSTOMER_CITY','CITY'),('94','MEMBER','35','Cola'),('50','LEVEL','SSB_TEST_CUSTOMER_CUSTKEY','CUSTKEY'),('51','LEVEL','SSB_TEST_CUSTOMER_CUSTOMER','CUSTOMER'),('47','MEASURE','EXTENDEDPRICE','EXTENDEDPRICE'),('103','MEMBER','44','Food'),('79','MEMBER','20','France'),('102','MEMBER','43','France'),('80','MEMBER','21','Italy'),('48','MEASURE','ORDTOTALPRICE','ORDTOTALPRICE'),('93','MEMBER','34','p06'),('101','MEMBER','42','p07'),('96','MEMBER','37','p08'),('95','MEMBER','36','p09'),('97','MEMBER','38','p10'),('55','LEVEL','SSB_TEST_PART_PARTKEY','PARTKEY'),('99','MEMBER','40','Pizza'),('53','LEVEL','SSB_TEST_CUSTOMER_POPULATION','POPULATION'),('56','LEVEL','SSB_TEST_PART_PRODUCT','PRODUCT'),('46','MEASURE','QUANTITY','QUANTITY'),('58','FACT','SSB_TEST_LINEORDER','SSB_TEST_LINEORDER'),('98','MEMBER','39','Wine');
/*!40000 ALTER TABLE `SYNONYM` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TABLE`
--

DROP TABLE IF EXISTS `TABLE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `TABLE` (
                         `table_id` varchar(255) NOT NULL,
                         `table_name` varchar(255) NOT NULL,
                         `table_type` varchar(255) NOT NULL,
                         `fact_id` varchar(255) DEFAULT NULL,
                         `hierarchy_id` varchar(255) DEFAULT NULL,
                         PRIMARY KEY (`table_id`),
                         UNIQUE KEY `table_name` (`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `TABLE`
--

LOCK TABLES `TABLE` WRITE;
/*!40000 ALTER TABLE `TABLE` DISABLE KEYS */;
INSERT INTO `TABLE` VALUES ('SSB_TEST_CUSTOMER','SSB_TEST_CUSTOMER','DT',NULL,'SSB_TEST_CUSTOMER'),('SSB_TEST_LINEORDER','SSB_TEST_LINEORDER','FT','SSB_TEST_LINEORDER',NULL),('SSB_TEST_PART','SSB_TEST_PART','DT',NULL,'SSB_TEST_PART');
/*!40000 ALTER TABLE `TABLE` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2022-01-19 15:36:39
