
--
-- Create schema pizza
--

CREATE DATABASE IF NOT EXISTS pizza;
USE pizza;

--
-- Definition of table `pizza`
--

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


INSERT INTO `pizza` (`term`) VALUES
 ('americanHotPizza'), 
 ('americanaPizza'),
 ('cheesyPizza'),
 ('sohoPizza'),
 ('margheritaPizza');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

DROP TABLE IF EXISTS `hamTopping`;
CREATE TABLE `hamTopping` (
 `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 `americanaPizza`;
CREATE TABLE `americanaPizza` (
 `term` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`term`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

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

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

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

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

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

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


--
-- Definition of table `country`
--

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


--INSERT INTO `country` (`term`) VALUES
-- ('rosato'), 
-- ('rosso'), 
-- ('bianco'); 
 
--
-- Definition of table `hasTopping`
--

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



INSERT INTO `hasTopping` (`term1` ,`term2`) VALUES
 ('americanHotPizza','pepperoniTopping'),
 ('americanHotPizza','jalapenoTopping'),
 ('americanHotPizza','mozzarellaTopping'),
 ('americanHotPizza','tomatoTopping'),
 ('americanaPizza','tomatoTopping'),
 ('americanaPizza','mozzarellaTopping'),
 ('americanaPizza','pepperoniTopping'),
 ('cheesyPizza','cheeseTopping'),
 ('sohoPizza','tomatoTopping'),
 ('sohoPizza','oliveTopping'),
 ('sohoPizza','mozzarellaTopping'),
 ('sohoPizza','parmezanTopping'),
 ('margheritaPizza','tomatoTopping'),
 ('margheritaPizza','mozzarellaTopping');
 
--
-- Definition of table `isToppingOf`
--

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



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

--
-- Definition of table `isIngredientOf`
--

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



--
-- Definition of table `hasIngredient`
--

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



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


--
-- Definition of table `hasBase`
--

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




--
-- Definition of table `isBaseOf`
--

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



--
-- Definition of table `hasCountryOfOrigin`
--

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




--
-- Definition of table `pizzaBase`
--

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


INSERT INTO `pizzaBase` (`term`) VALUES
 ('thinAndCrispyBase'),
 ('deepPanBase');


--
-- Definition of table `pizzaTopping`
--

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



INSERT INTO `pizzaTopping` (`term`) VALUES
 ('onionTopping'),
 ('vegetableTopping'),
 ('pepperTopping'),
 ('tunaTopping'),
 ('seaFoodTopping'),
 ('pepperoniTopping'),
 ('jalapenoPepperTopping'),
 ('mozzarellaTopping'),
 ('tomatoTopping'),
 ('inconsistentTopping'),
 ('cheeseTopping'),
 ('meatTopping'),
 ('anchovyTopping'),
 ('caperTopping'),
 ('salamiTopping'),
 ('spicyBeefTopping'),
 ('mushroomTopping'),
 ('hamTopping'),
 ('greenPepperTopping'),
 ('oliveTopping'),
 ('parmezanTopping'),
 ('prawnTopping'),
 ('RedPepperTopping');







  
 
 
