
--
-- Create schema vini
--

CREATE DATABASE IF NOT EXISTS vini;
USE vini;

--
-- Definition of table `vino`
--

DROP TABLE IF EXISTS `vino`;
CREATE TABLE `vino` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `rosato`;
CREATE TABLE `rosato` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `brunello`;
CREATE TABLE `brunello` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `vinoPerAntipasto`;
CREATE TABLE `vinoPerAntipasto` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `rosso`;
CREATE TABLE `rosso` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `chardonnayTrentino`;
CREATE TABLE `chardonnayTrentino` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `vinoDiFattoria`;
CREATE TABLE `vinoDiFattoria` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `aglianicoDelVulture`;
CREATE TABLE `aglianicoDelVulture` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `arrosto`;
CREATE TABLE `arrosto` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `formaggioDiPecora`;
CREATE TABLE `formaggioDiPecora` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `aleaticoDiPuglia`;
CREATE TABLE `aleaticoDiPuglia` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `chardonnay`;
CREATE TABLE `chardonnay` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `aleatico`;
CREATE TABLE `aleatico` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `amaroneValpolicella`;
CREATE TABLE `amaroneValpolicella` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `brasato`;
CREATE TABLE `brasato` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `regioneDelMezzogiorno`;
CREATE TABLE `regioneDelMezzogiorno` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `aglianico`;
CREATE TABLE `aglianico` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `vinoPerFormaggioDiPecora`;
CREATE TABLE `vinoPerFormaggioDiPecora` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `vinoVersatile`;
CREATE TABLE `vinoVersatile` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `thing`;
CREATE TABLE `thing` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `dessert`;
CREATE TABLE `dessert` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `vinoInconsistente`;
CREATE TABLE `vinoInconsistente` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `bianco`;
CREATE TABLE `bianco` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `vinoPerDessert`;
CREATE TABLE `vinoPerDessert` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `vinoPerArrosto`;
CREATE TABLE `vinoPerArrosto` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `brunelloDiMontalcino`;
CREATE TABLE `brunelloDiMontalcino` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `amarone`;
CREATE TABLE `amarone` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `vinoPugliese`;
CREATE TABLE `vinoPugliese` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `vinoMeridionale`;
CREATE TABLE `vinoMeridionale` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `regioneDelSettentrione`;
CREATE TABLE `regioneDelSettentrione` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `vinoAglianico`;
CREATE TABLE `vinoAglianico` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `vinoRosso`;
CREATE TABLE `vinoRosso` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `gravina`;
CREATE TABLE `gravina` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `vinoPerBrasato`;
CREATE TABLE `vinoPerBrasato` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `vino` (`term`) VALUES
 ('vinoPerAntipasto'), 
 ('vinoDiFattoria'),
 ('vinoPerFormaggioDiPecora'),
 ('vinoVersatile'),
 ('vinoInconsistente'),
 ('vinoPerDessert'),
 ('vinoPerArrosto'),
 ('vinoPerBrasato'),
 ('vinoPugliese'),
 ('vinoMeridionale'),
 ('vinoRosso'),
 ('vinoAglianico');


--
-- Definition of table `colore`
--

DROP TABLE IF EXISTS `colore`;
CREATE TABLE `colore` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `colore`
--
INSERT INTO `colore` (`term`) VALUES
 ('rosato'), 
 ('rosso'), 
 ('bianco'); 
 
--
-- Definition of table `haColore`
--

DROP TABLE IF EXISTS `haColore`;
CREATE TABLE `haColore` (
 `term1` varchar(100) NOT NULL default '',
 `term2` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term1`,`term2`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `haColore`
--

INSERT INTO `haColore` (`term1` ,`term2`) VALUES
 ('brunello','rosso'),
 ('aleatico','rosso'),
 ('aglianico','rosso'),
 ('amarone','rosso'),
 ('vinoPerAntipasto','rosso'),
 ('vinoInconsistente','rosso'),
 ('vinoInconsistente','bianco'); 
--
-- Definition of table `haRegione`
--

DROP TABLE IF EXISTS `haRegione`;
CREATE TABLE `haRegione` (
 `term1` varchar(100) NOT NULL default '',
 `term2` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term1`,`term2`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `haRegione`
--

INSERT INTO `haRegione` (`term1` ,`term2`) VALUES
 ('vinoMeridionale','regioneDelMezzogiorno');

--
-- Definition of table `haDenominazione`
--

DROP TABLE IF EXISTS `haDenominazione`;
CREATE TABLE `haDenominazione` (
 `term1` varchar(100) NOT NULL default '',
 `term2` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term1`,`term2`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `haDenominazione`
--

--
-- Definition of table `vinoDi`
--

DROP TABLE IF EXISTS `vinoDi`;
CREATE TABLE `vinoDi` (
 `term1` varchar(100) NOT NULL default '',
 `term2` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term1`,`term2`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vinoDi`
--

INSERT INTO `vinoDi` (`term1` ,`term2`) VALUES
 ('aglianicoDelVulture','arrosto'),
 ('amaroneValpolicella','brasato'),
 ('vinoPerFormaggioDiPecora','formaggioDiPecora'),
 ('vinoPerDessert','dessert'),
 ('vinoPerArrosto','arrosto'),
 ('aleaticoDiPuglia','dessert'),
 ('aleaticoDiPuglia','formaggioDiPecora'),
 ('vinoPerBrasato','brasato'),
 ('brunelloDiMontalcino','arrosto'),
 ('brunelloDiMontalcino','brasato');

--
-- Definition of table `haVino`
--

DROP TABLE IF EXISTS `haVino`;
CREATE TABLE `haVino` (
 `term1` varchar(100) NOT NULL default '',
 `term2` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term1`,`term2`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `haVino`
--

INSERT INTO `haVino` (`term1`, `term2`) VALUES
 ('formaggioDiPecora','aleaticoDiPuglia'),
 ('dessert','aleaticoDiPuglia'),
 ('brasato','brunelloDiMontalcino'),
 ('arrosto','aglianicoDelVulture');


--
-- Definition of table `regioneDi`
--

DROP TABLE IF EXISTS `regioneDi`;
CREATE TABLE `regioneDi` (
 `term1` varchar(100) NOT NULL default '',
 `term2` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term1`,`term2`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `regioneDi`
--

--
-- Definition of table `denominazioneDi`
--

DROP TABLE IF EXISTS `denominazioneDi`;
CREATE TABLE `denominazioneDi` (
 `term1` varchar(100) NOT NULL default '',
 `term2` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term1`,`term2`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `denominazioneDi`
--

--
-- Definition of table `coloreDi`
--

DROP TABLE IF EXISTS `coloreDi`;
CREATE TABLE `coloreDi` (
 `term1` varchar(100) NOT NULL default '',
 `term2` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term1`,`term2`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `coloreDi`
--

--
-- Definition of table `denominazione`
--

DROP TABLE IF EXISTS `denominazione`;
CREATE TABLE `denominazione` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `denominazione`
--

INSERT INTO `denominazione` (`term`) VALUES
 ('brunello'),
 ('aglianico'),
 ('chardonnay'),
 ('aleatico'),
 ('amarone');

--
-- Definition of table `cibo`
--

DROP TABLE IF EXISTS `cibo`;
CREATE TABLE `cibo` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cibo`
--

INSERT INTO `cibo` (`term`) VALUES
 ('formaggioDiPecora'),
 ('dessert'),
 ('brasato'),
 ('arrosto');

--
-- Definition of table `regione`
--

DROP TABLE IF EXISTS `regione`;
CREATE TABLE `regione` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `regione`
--

INSERT INTO `regione` (`term`) VALUES
 ('regioneDelMezzogiorno'),
 ('regioneDelSettentrione');
  
 
 
