SET NAMES latin1;
SET FOREIGN_KEY_CHECKS = 0;

BEGIN;
CREATE DATABASE `Salute2`; 
COMMIT;

USE `Salute2`;

-- ----------------------------
--  Table structure for `MEDICO`
-- ----------------------------
DROP TABLE IF EXISTS `MEDICO`;
CREATE TABLE `MEDICO` (
  `Matricola` char(50) NOT NULL,
  `Cognome` char(50) NOT NULL,
  `Nome` char(50) NOT NULL,
  `Specializzazione` char(50) NOT NULL,
  `Parcella` int(11) NOT NULL,
  `Citta` char(50) NOT NULL,
  PRIMARY KEY (`Matricola`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `MEDICO`
-- ----------------------------
BEGIN;
INSERT INTO `MEDICO` VALUES ('001', 'Rossi', 'Mario', 'Otorinolaringoiatria', '100', 'Pisa'), ('002', 'Verdi', 'Luigi', 'Otorinolaringoiatria', '150', 'Pisa'), ('003', 'Gialli', 'Franco', 'Otorinolaringoiatria', '200', 'Pisa'), ('004', 'Turchesi', 'Viola', 'Otorinolaringoiatria', '250', 'Pisa'), ('005', 'Neri', 'Marta', 'Gastroenterologia', '130', 'Milano'), ('006', 'Bianchi', 'Ada', 'Ortopedia', '160', 'Milano'), ('007', 'Rosi', 'Alvaro', 'Ortopedia', '180', 'Roma'), ('008', 'Gialli', 'Margherita', 'Nefrologia', '120', 'Roma'), ('009', 'Arancioni', 'Ugo', 'Nefrologia', '170', 'Firenze'), ('010', 'Celesti', 'Clelia', 'Neurologia', '200', 'Firenze'), ('011', 'Marroni', 'Osvaldo', 'Psichiatria', '150', 'Pisa'), ('012', 'Grigi', 'Ettore', 'Medicina generale', '50', 'Pisa'), ('013', 'Blu', 'Fabiola', 'Gastroenterologia', '110', 'Siena'), ('014', 'Indachi', 'Loredana', 'Cardiologia', '180', 'Pisa'), ('015', 'Ciani', 'Gualtiero', 'Cardiologia', '230', 'Pisa'), ('016', 'Verdolini', 'Maria Paola', 'Cardiologia', '220', 'Pisa'), ('017', 'Amaranti', 'Adevane', 'Cardiologia', '250', 'Pisa'), ('018', 'Terra di Siena', 'Bruciata', 'Cardiologia', '260', 'Siena');
COMMIT;


-- ----------------------------
--  Table structure for `PAZIENTE`
-- ----------------------------
DROP TABLE IF EXISTS `PAZIENTE`;
CREATE TABLE `PAZIENTE` (
  `CodFiscale` char(50) NOT NULL,
  `Cognome` char(50) NOT NULL,
  `Nome` char(50) NOT NULL,
  `Sesso` char(50) NOT NULL,
  `DataNascita` date NOT NULL,
  `Citta` char(50) NOT NULL,
  `Reddito` int(11) NOT NULL,
  PRIMARY KEY (`CodFiscale`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `PAZIENTE`
-- ----------------------------
BEGIN;
INSERT INTO `PAZIENTE` VALUES ('aaa1', 'Gatti', 'Tommaso', 'M', '1993-02-17', 'Pisa', '1000'), ('bbc4', 'Cani', 'Maria', 'F', '1925-11-28', 'Pisa', '1500'), ('bbe1', 'Bove', 'Maddalena', 'F', '1962-08-15', 'Firenze', '1800'), ('ccc2', 'Tigri', 'Romeo', 'M', '1954-03-05', 'Firenze', '2000'), ('ddd6', 'Cavalli', 'Roberto', 'M', '1948-07-30', 'Firenze', '5000'), ('eey9', 'Gallina', 'Ultima', 'F', '1921-05-23', 'Pisa', '2750'), ('erv4', 'Nutrie', 'Lorella', 'F', '1988-06-30', 'Prato', '1200'), ('ffq8', 'Facoceri', 'Osvaldo', 'M', '1966-11-06', 'Pisa', '3000'), ('fqa8', 'Faraona', 'Elettra', 'F', '1940-12-14', 'Pisa', '3000'), ('gox9', 'Orata', 'Marcello', 'M', '1971-01-27', 'Pisa', '1700'), ('gwp5', 'Cinghiali', 'Maria Rita', 'F', '1975-09-13', 'Siena', '1300'), ('hho1', 'Ricci', 'Egisto', 'M', '1942-09-15', 'Pisa', '2100'), ('kkw1', 'Pappagalli', 'Norina', 'F', '1926-03-03', 'Firenze', '2000'), ('kqp6', 'Cervi', 'Luigi', 'M', '1993-05-17', 'Grosseto', '1000'), ('psq9', 'Giaguaro', 'Vivetta', 'F', '1935-07-01', 'Roma', '1850'), ('slq6', 'Lepre', 'Edoardo', 'M', '1968-10-17', 'Pisa', '2150'), ('ttw2', 'Capra', 'Renzo', 'M', '1982-04-23', 'Roma', '1400'), ('uiw1', 'Muli', 'Antonella', 'F', '1974-12-25', 'Pisa', '1700');
COMMIT;


-- ----------------------------
--  Table structure for `VISITA`
-- ----------------------------
DROP TABLE IF EXISTS `VISITA`;
CREATE TABLE `VISITA` (
  `Medico` char(50) NOT NULL,
  `Paziente` char(50) NOT NULL,
  `Data` date NOT NULL,
  `Mutuata` int(11) NOT NULL,
  PRIMARY KEY (`Medico`,`Paziente`,`Data`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `VISITA`
-- ----------------------------
BEGIN;
INSERT INTO `VISITA` VALUES ('001', 'aaa1', '2003-04-02', '0'), ('001', 'aaa1', '2012-12-01', '0'), ('001', 'bbc4', '2005-03-30', '0'), ('001', 'bbe1', '2004-04-16', '0'), ('001', 'ccc2', '2012-07-27', '0'), ('001', 'ddd6', '2006-11-09', '0'), ('001', 'eey9', '2003-05-28', '0'), ('001', 'erv4', '2003-04-17', '0'), ('001', 'ffq8', '2013-02-01', '0'), ('001', 'fqa8', '2009-06-09', '0'), ('001', 'gox9', '2004-04-22', '0'), ('001', 'gox9', '2009-10-04', '0'), ('001', 'gwp5', '2008-05-05', '0'), ('001', 'gwp5', '2010-01-19', '0'), ('001', 'hho1', '2004-03-13', '0'), ('001', 'hho1', '2009-04-15', '0'), ('001', 'kkw1', '2007-09-05', '0'), ('001', 'kkw1', '2008-04-04', '0'), ('001', 'kqp6', '2012-08-24', '0'), ('001', 'psq9', '2003-06-27', '0'), ('001', 'psq9', '2007-01-27', '0'), ('001', 'slq6', '2003-06-03', '0'), ('001', 'slq6', '2004-04-05', '0'), ('001', 'ttw2', '2003-06-28', '0'), ('001', 'ttw2', '2006-12-02', '0'), ('001', 'uiw1', '2004-01-13', '0'), ('001', 'uiw1', '2008-09-02', '0'), ('002', 'aaa1', '2006-07-19', '0'), ('002', 'aaa1', '2009-06-15', '0'), ('002', 'bbc4', '2007-06-26', '0'), ('002', 'bbc4', '2008-02-09', '0'), ('002', 'bbe1', '2004-08-20', '0'), ('002', 'bbe1', '2009-01-10', '0'), ('002', 'ccc2', '2007-07-27', '0'), ('002', 'ddd6', '2008-01-27', '0'), ('002', 'ddd6', '2010-10-16', '0'), ('002', 'eey9', '2004-03-26', '0'), ('002', 'eey9', '2008-02-06', '0'), ('002', 'eey9', '2012-02-16', '0'), ('002', 'erv4', '2003-10-15', '0'), ('002', 'erv4', '2004-12-23', '0'), ('002', 'ffq8', '2007-06-08', '0'), ('002', 'ffq8', '2013-01-26', '0'), ('002', 'fqa8', '2009-02-01', '0'), ('002', 'fqa8', '2010-11-16', '0'), ('002', 'gox9', '2009-12-27', '0'), ('002', 'gwp5', '2004-04-06', '0'), ('002', 'gwp5', '2009-07-16', '0'), ('002', 'hho1', '2004-07-30', '0'), ('002', 'hho1', '2012-02-15', '0'), ('002', 'kkw1', '2004-09-13', '0'), ('002', 'kkw1', '2011-02-08', '0'), ('002', 'kqp6', '2003-12-21', '0'), ('002', 'kqp6', '2008-08-29', '0'), ('002', 'psq9', '2006-11-02', '0'), ('002', 'psq9', '2012-08-03', '0'), ('002', 'slq6', '2005-01-16', '0'), ('002', 'slq6', '2007-11-30', '0'), ('002', 'ttw2', '2008-08-20', '0'), ('002', 'ttw2', '2011-07-22', '0'), ('002', 'uiw1', '2006-04-17', '0'), ('002', 'uiw1', '2009-07-02', '0'), ('003', 'aaa1', '2009-09-12', '0'), ('003', 'aaa1', '2012-05-23', '0'), ('003', 'bbc4', '2006-10-31', '0'), ('003', 'bbc4', '2009-12-14', '0'), ('003', 'bbe1', '2009-06-07', '0'), ('003', 'bbe1', '2011-11-27', '0'), ('003', 'ccc2', '2004-02-28', '0'), ('003', 'ccc2', '2005-11-22', '0'), ('003', 'ddd6', '2009-05-03', '0'), ('003', 'eey9', '2011-01-23', '0'), ('003', 'erv4', '2004-02-27', '0'), ('003', 'erv4', '2005-09-23', '0'), ('003', 'ffq8', '2004-06-08', '0'), ('003', 'ffq8', '2009-02-01', '0'), ('003', 'fqa8', '2005-02-13', '0'), ('003', 'fqa8', '2006-07-21', '0'), ('003', 'gox9', '2005-03-06', '0'), ('003', 'gox9', '2006-04-24', '0'), ('003', 'gwp5', '2007-05-18', '0'), ('003', 'gwp5', '2008-09-30', '0'), ('003', 'hho1', '2008-03-12', '0'), ('003', 'hho1', '2011-08-31', '0'), ('003', 'kkw1', '2005-09-14', '0'), ('003', 'kkw1', '2008-12-04', '0'), ('003', 'kqp6', '2006-06-28', '0'), ('003', 'psq9', '2003-08-10', '0'), ('003', 'psq9', '2012-07-03', '0'), ('003', 'slq6', '2009-12-03', '0'), ('003', 'slq6', '2012-07-21', '0'), ('003', 'ttw2', '2008-10-25', '0'), ('003', 'ttw2', '2008-12-13', '0'), ('003', 'uiw1', '2003-04-10', '0'), ('003', 'uiw1', '2011-11-01', '0'), ('004', 'aaa1', '2006-09-29', '0'), ('004', 'aaa1', '2009-03-06', '0'), ('004', 'bbc4', '2010-10-03', '0'), ('004', 'bbe1', '2010-05-30', '0'), ('004', 'ccc2', '2006-08-19', '0'), ('004', 'ddd6', '2007-03-25', '0'), ('004', 'ddd6', '2008-10-07', '0'), ('004', 'eey9', '2005-06-15', '0'), ('004', 'eey9', '2010-10-16', '0'), ('004', 'erv4', '2004-07-09', '0'), ('004', 'erv4', '2012-06-07', '0'), ('004', 'ffq8', '2007-01-21', '0'), ('004', 'ffq8', '2012-09-03', '0'), ('004', 'fqa8', '2008-07-30', '0'), ('004', 'gox9', '2003-06-04', '0'), ('004', 'gox9', '2008-07-29', '0'), ('004', 'gwp5', '2003-12-30', '0'), ('004', 'gwp5', '2005-03-10', '0'), ('004', 'hho1', '2011-01-29', '0'), ('004', 'kkw1', '2010-04-12', '0'), ('004', 'kqp6', '2005-01-05', '0'), ('004', 'psq9', '2011-01-24', '0'), ('004', 'slq6', '2007-02-23', '0'), ('004', 'ttw2', '2003-12-03', '0'), ('004', 'ttw2', '2009-05-17', '0'), ('004', 'uiw1', '2008-11-10', '0'), ('004', 'uiw1', '2012-04-18', '0'), ('005', 'aaa1', '2009-05-27', '0'), ('005', 'aaa1', '2010-03-20', '0'), ('005', 'bbc4', '2007-04-16', '0'), ('005', 'bbc4', '2011-01-12', '0'), ('005', 'bbe1', '2005-01-27', '0'), ('005', 'bbe1', '2011-05-15', '0'), ('005', 'ccc2', '2010-05-09', '0'), ('005', 'ccc2', '2010-08-09', '0'), ('005', 'ddd6', '2003-05-29', '0'), ('005', 'ddd6', '2005-10-06', '0'), ('005', 'eey9', '2003-11-06', '0'), ('005', 'eey9', '2012-10-19', '0'), ('005', 'erv4', '2008-10-14', '0'), ('005', 'erv4', '2010-08-29', '0'), ('005', 'ffq8', '2009-04-02', '0'), ('005', 'ffq8', '2011-09-30', '0'), ('005', 'fqa8', '2003-08-09', '0'), ('005', 'fqa8', '2006-09-30', '0'), ('005', 'gox9', '2009-08-11', '0'), ('005', 'gox9', '2012-10-29', '0'), ('005', 'gwp5', '2004-02-10', '0'), ('005', 'hho1', '2008-07-20', '0'), ('005', 'hho1', '2012-02-23', '0'), ('005', 'kkw1', '2005-04-26', '0'), ('005', 'kkw1', '2007-04-17', '0'), ('005', 'kqp6', '2006-12-28', '0'), ('005', 'kqp6', '2007-08-23', '0'), ('005', 'psq9', '2003-03-13', '0'), ('005', 'psq9', '2005-11-08', '0'), ('005', 'slq6', '2005-02-22', '0'), ('005', 'slq6', '2009-11-21', '0'), ('005', 'ttw2', '2005-01-01', '0'), ('005', 'ttw2', '2006-09-21', '0'), ('005', 'uiw1', '2006-06-07', '0'), ('005', 'uiw1', '2010-10-13', '0'), ('006', 'aaa1', '2003-12-31', '0'), ('006', 'aaa1', '2010-08-09', '0'), ('006', 'bbc4', '2007-07-15', '0'), ('006', 'bbc4', '2007-07-17', '0'), ('006', 'bbe1', '2012-07-24', '0'), ('006', 'bbe1', '2012-09-10', '0'), ('006', 'ccc2', '2007-01-19', '0'), ('006', 'ccc2', '2007-09-27', '0'), ('006', 'ddd6', '2004-05-31', '0'), ('006', 'ddd6', '2007-06-10', '0'), ('006', 'eey9', '2007-10-05', '0'), ('006', 'eey9', '2010-11-02', '0'), ('006', 'erv4', '2008-09-22', '0'), ('006', 'erv4', '2012-05-30', '0'), ('006', 'ffq8', '2005-08-21', '0'), ('006', 'ffq8', '2007-12-19', '0'), ('006', 'fqa8', '2007-10-18', '0'), ('006', 'fqa8', '2010-06-30', '0'), ('006', 'fqa8', '2012-06-07', '0'), ('006', 'gox9', '2005-06-09', '0'), ('006', 'gox9', '2008-11-29', '0'), ('006', 'gox9', '2012-01-03', '0'), ('006', 'gwp5', '2008-01-14', '0'), ('006', 'gwp5', '2010-10-03', '0'), ('006', 'gwp5', '2012-07-18', '0'), ('006', 'hho1', '2003-04-12', '0'), ('006', 'hho1', '2010-04-14', '0'), ('006', 'kkw1', '2004-03-06', '0'), ('006', 'kkw1', '2005-08-02', '0'), ('006', 'kqp6', '2004-12-10', '0'), ('006', 'kqp6', '2006-11-13', '0'), ('006', 'kqp6', '2010-10-08', '0'), ('006', 'psq9', '2004-10-23', '0'), ('006', 'psq9', '2008-08-28', '0'), ('006', 'slq6', '2006-01-24', '0'), ('006', 'slq6', '2009-07-18', '0'), ('006', 'ttw2', '2008-08-06', '0'), ('006', 'ttw2', '2012-09-29', '0'), ('006', 'uiw1', '2011-03-14', '0'), ('006', 'uiw1', '2012-05-26', '0'), ('007', 'aaa1', '2007-01-24', '0'), ('007', 'aaa1', '2010-08-14', '0'), ('007', 'bbc4', '2008-07-27', '0'), ('007', 'bbc4', '2012-09-25', '0'), ('007', 'bbe1', '2008-07-04', '0'), ('007', 'bbe1', '2008-09-03', '0'), ('007', 'ccc2', '2003-09-06', '0'), ('007', 'ccc2', '2010-08-30', '0'), ('007', 'ccc2', '2012-01-04', '0'), ('007', 'ddd6', '2009-09-16', '0'), ('007', 'ddd6', '2010-08-04', '0'), ('007', 'ddd6', '2010-11-17', '0'), ('007', 'eey9', '2004-05-17', '0'), ('007', 'eey9', '2005-03-22', '0'), ('007', 'erv4', '2009-08-01', '0'), ('007', 'erv4', '2010-04-23', '0'), ('007', 'ffq8', '2011-08-28', '0'), ('007', 'ffq8', '2012-09-27', '0'), ('007', 'fqa8', '2006-05-19', '0'), ('007', 'fqa8', '2009-08-18', '0'), ('007', 'gox9', '2003-10-10', '0'), ('007', 'gox9', '2006-10-12', '0'), ('007', 'gwp5', '2006-07-26', '0'), ('007', 'gwp5', '2011-11-05', '0'), ('007', 'hho1', '2005-10-03', '0'), ('007', 'hho1', '2008-05-15', '0'), ('007', 'hho1', '2012-07-10', '0'), ('007', 'kkw1', '2009-01-02', '0'), ('007', 'kkw1', '2010-01-29', '0'), ('007', 'kqp6', '2006-10-08', '0'), ('007', 'kqp6', '2009-12-26', '0'), ('007', 'kqp6', '2010-04-13', '0'), ('007', 'psq9', '2003-09-05', '0'), ('007', 'psq9', '2006-07-16', '0'), ('007', 'slq6', '2004-11-30', '0'), ('007', 'slq6', '2009-08-01', '0'), ('007', 'ttw2', '2005-02-28', '0'), ('007', 'ttw2', '2010-05-22', '0'), ('007', 'uiw1', '2003-11-24', '0'), ('007', 'uiw1', '2004-01-26', '0'), ('008', 'aaa1', '2006-01-05', '0'), ('008', 'aaa1', '2010-11-01', '0'), ('008', 'bbe1', '2011-02-06', '0'), ('008', 'bbe1', '2012-04-30', '0'), ('008', 'ccc2', '2004-04-23', '0'), ('008', 'ccc2', '2004-05-27', '0'), ('008', 'ddd6', '2005-01-28', '0'), ('008', 'ddd6', '2011-11-07', '0'), ('008', 'erv4', '2005-11-15', '0'), ('008', 'erv4', '2008-02-15', '0'), ('008', 'ffq8', '2007-06-18', '0'), ('008', 'ffq8', '2009-07-30', '0'), ('008', 'fqa8', '2006-07-15', '0'), ('008', 'fqa8', '2010-05-13', '0'), ('008', 'gox9', '2007-02-21', '0'), ('008', 'gwp5', '2012-12-12', '0'), ('008', 'hho1', '2010-03-08', '0'), ('008', 'kkw1', '2008-11-30', '0'), ('008', 'kqp6', '2010-11-15', '0'), ('008', 'psq9', '2004-06-26', '0'), ('008', 'slq6', '2006-08-20', '0'), ('008', 'ttw2', '2006-07-30', '0'), ('008', 'ttw2', '2009-12-10', '0'), ('008', 'uiw1', '2005-06-20', '0'), ('008', 'uiw1', '2009-10-29', '0'), ('009', 'aaa1', '2004-05-11', '0'), ('009', 'aaa1', '2006-04-05', '0'), ('009', 'bbe1', '2004-12-07', '0'), ('009', 'bbe1', '2011-05-23', '0'), ('009', 'ccc2', '2004-10-26', '0'), ('009', 'ccc2', '2007-10-28', '0'), ('009', 'ddd6', '2006-02-21', '0'), ('009', 'ddd6', '2011-10-11', '0'), ('009', 'erv4', '2003-12-16', '0'), ('009', 'erv4', '2012-12-02', '0'), ('009', 'ffq8', '2004-08-17', '0'), ('009', 'ffq8', '2007-04-21', '0'), ('009', 'fqa8', '2011-03-17', '0'), ('009', 'fqa8', '2011-06-30', '0'), ('009', 'fqa8', '2012-11-30', '0'), ('009', 'gox9', '2009-01-05', '0'), ('009', 'gox9', '2012-06-04', '0'), ('009', 'gwp5', '2004-07-02', '0'), ('009', 'gwp5', '2008-04-16', '0'), ('009', 'hho1', '2011-04-05', '0'), ('009', 'hho1', '2012-01-23', '0'), ('009', 'kkw1', '2003-09-03', '0'), ('009', 'kkw1', '2008-04-15', '0'), ('009', 'kqp6', '2004-07-04', '0'), ('009', 'kqp6', '2009-01-04', '0'), ('009', 'psq9', '2004-07-08', '0'), ('009', 'psq9', '2010-11-22', '0'), ('009', 'slq6', '2004-04-16', '0'), ('009', 'slq6', '2005-11-28', '0'), ('009', 'ttw2', '2005-08-13', '0'), ('009', 'ttw2', '2012-11-01', '0'), ('009', 'uiw1', '2003-05-02', '0'), ('009', 'uiw1', '2012-01-19', '0'), ('010', 'aaa1', '2004-12-24', '0'), ('010', 'aaa1', '2010-04-11', '0'), ('010', 'bbc4', '2011-10-04', '0'), ('010', 'bbc4', '2012-01-25', '0'), ('010', 'bbe1', '2006-05-16', '0'), ('010', 'bbe1', '2010-09-14', '0'), ('010', 'ccc2', '2005-02-04', '0'), ('010', 'ccc2', '2012-06-27', '0'), ('010', 'ddd6', '2010-03-14', '0'), ('010', 'ddd6', '2010-03-17', '0'), ('010', 'eey9', '2010-05-17', '0'), ('010', 'eey9', '2012-08-10', '0'), ('010', 'erv4', '2008-02-16', '0'), ('010', 'erv4', '2009-04-13', '0'), ('010', 'ffq8', '2005-06-08', '0'), ('010', 'ffq8', '2006-05-09', '0'), ('010', 'fqa8', '2004-03-28', '0'), ('010', 'fqa8', '2006-03-01', '0'), ('010', 'gox9', '2008-12-21', '0'), ('010', 'gox9', '2011-05-12', '0'), ('010', 'gwp5', '2005-03-07', '0'), ('010', 'gwp5', '2009-01-02', '0'), ('010', 'hho1', '2004-12-17', '0'), ('010', 'hho1', '2008-08-28', '0'), ('010', 'kkw1', '2004-08-10', '0'), ('010', 'kkw1', '2004-08-17', '0'), ('010', 'kqp6', '2003-11-26', '0'), ('010', 'kqp6', '2005-02-08', '0'), ('010', 'psq9', '2008-07-02', '0'), ('010', 'psq9', '2012-07-13', '0'), ('010', 'slq6', '2004-01-17', '0'), ('010', 'slq6', '2007-10-29', '0'), ('010', 'ttw2', '2008-05-15', '0'), ('010', 'ttw2', '2011-07-19', '0'), ('010', 'uiw1', '2005-03-23', '0'), ('010', 'uiw1', '2012-06-18', '0'), ('011', 'aaa1', '2004-07-17', '0'), ('011', 'aaa1', '2007-11-07', '0'), ('011', 'bbc4', '2010-06-09', '0'), ('011', 'bbc4', '2012-02-23', '0'), ('011', 'bbe1', '2003-12-24', '0'), ('011', 'bbe1', '2005-06-28', '0'), ('011', 'ccc2', '2010-04-15', '0'), ('011', 'ccc2', '2012-12-22', '0'), ('011', 'ddd6', '2005-04-14', '0'), ('011', 'ddd6', '2006-05-13', '0'), ('011', 'eey9', '2004-04-30', '0'), ('011', 'eey9', '2007-10-18', '0'), ('011', 'erv4', '2006-09-26', '0'), ('011', 'erv4', '2012-08-18', '0'), ('011', 'ffq8', '2007-01-15', '0'), ('011', 'ffq8', '2007-02-22', '0'), ('011', 'fqa8', '2004-02-23', '0'), ('011', 'fqa8', '2012-05-11', '0'), ('011', 'gox9', '2006-06-12', '0'), ('011', 'gox9', '2007-03-26', '0'), ('011', 'gwp5', '2005-12-01', '0'), ('011', 'gwp5', '2006-08-26', '0'), ('011', 'hho1', '2004-09-28', '0'), ('011', 'hho1', '2010-10-04', '0'), ('011', 'kkw1', '2010-09-12', '0'), ('011', 'kkw1', '2012-10-21', '0'), ('011', 'kqp6', '2006-08-31', '0'), ('011', 'kqp6', '2008-01-24', '0'), ('011', 'psq9', '2005-01-29', '0'), ('011', 'psq9', '2011-09-30', '0'), ('011', 'slq6', '2005-08-06', '0'), ('011', 'slq6', '2008-01-17', '0'), ('011', 'ttw2', '2009-08-02', '0'), ('011', 'ttw2', '2011-11-03', '0'), ('011', 'uiw1', '2007-12-31', '0'), ('011', 'uiw1', '2011-12-03', '0'), ('012', 'aaa1', '2008-01-30', '0'), ('012', 'aaa1', '2010-12-10', '0'), ('012', 'bbc4', '2005-10-20', '0'), ('012', 'bbe1', '2013-01-05', '0'), ('012', 'ccc2', '2004-07-16', '0'), ('012', 'ddd6', '2010-06-26', '0'), ('012', 'eey9', '2005-09-02', '0'), ('012', 'erv4', '2003-04-04', '0'), ('012', 'erv4', '2003-09-29', '0'), ('012', 'gox9', '2007-07-09', '0'), ('012', 'gox9', '2012-12-10', '0'), ('012', 'gwp5', '2006-07-18', '0'), ('012', 'gwp5', '2010-01-25', '0'), ('012', 'hho1', '2004-08-24', '0'), ('012', 'hho1', '2010-09-24', '0'), ('012', 'kkw1', '2009-11-12', '0'), ('012', 'kkw1', '2010-11-17', '0'), ('012', 'kqp6', '2009-01-21', '0'), ('012', 'kqp6', '2012-03-31', '0'), ('012', 'psq9', '2008-06-29', '0'), ('012', 'psq9', '2009-07-02', '0'), ('012', 'slq6', '2007-03-07', '0'), ('012', 'slq6', '2012-07-25', '0'), ('012', 'ttw2', '2004-03-17', '0'), ('012', 'uiw1', '2010-03-05', '0'), ('013', 'aaa1', '2006-09-26', '0'), ('013', 'bbc4', '2010-12-17', '0'), ('013', 'bbe1', '2011-06-13', '0'), ('013', 'ccc2', '2011-03-20', '0'), ('013', 'ddd6', '2008-08-02', '0'), ('013', 'eey9', '2006-02-17', '0'), ('013', 'erv4', '2011-09-26', '0'), ('013', 'ffq8', '2007-02-27', '0'), ('013', 'fqa8', '2007-06-01', '0'), ('013', 'gox9', '2012-06-12', '0'), ('013', 'gwp5', '2006-11-09', '0'), ('013', 'hho1', '2003-10-14', '0'), ('013', 'kkw1', '2005-02-13', '0'), ('013', 'kkw1', '2005-03-12', '0'), ('013', 'kqp6', '2011-06-19', '0'), ('013', 'kqp6', '2011-11-28', '0'), ('013', 'psq9', '2008-08-08', '0'), ('014', 'aaa1', '2003-12-20', '0'), ('014', 'bbc4', '2009-04-10', '0'), ('014', 'bbe1', '2011-04-27', '0'), ('014', 'ccc2', '2005-08-22', '0'), ('014', 'ddd6', '2011-01-30', '0'), ('014', 'eey9', '2005-05-05', '0'), ('014', 'erv4', '2010-04-22', '0'), ('014', 'ffq8', '2012-05-10', '0'), ('014', 'fqa8', '2007-09-26', '0'), ('014', 'gox9', '2008-06-10', '0'), ('014', 'gox9', '2009-05-26', '0'), ('014', 'gwp5', '2005-11-10', '0'), ('014', 'hho1', '2010-10-22', '0'), ('014', 'kkw1', '2003-04-30', '0'), ('014', 'kqp6', '2011-01-16', '0'), ('014', 'psq9', '2012-02-06', '0'), ('014', 'slq6', '2004-03-24', '0'), ('014', 'ttw2', '2011-09-03', '0'), ('014', 'uiw1', '2012-07-15', '0'), ('015', 'aaa1', '2004-07-15', '0'), ('015', 'bbc4', '2011-11-26', '0'), ('015', 'bbe1', '2012-10-06', '0'), ('015', 'ccc2', '2004-12-21', '0'), ('015', 'ddd6', '2003-05-30', '0'), ('015', 'eey9', '2008-12-19', '0'), ('015', 'erv4', '2011-06-20', '0'), ('015', 'ffq8', '2007-04-16', '0'), ('015', 'fqa8', '2008-11-18', '0'), ('015', 'gwp5', '2007-03-19', '0'), ('015', 'hho1', '2004-09-14', '0'), ('015', 'kkw1', '2008-09-21', '0'), ('015', 'kqp6', '2006-05-12', '0'), ('015', 'slq6', '2010-03-02', '0'), ('015', 'ttw2', '2010-04-03', '0'), ('015', 'uiw1', '2007-08-16', '0'), ('016', 'aaa1', '2004-03-14', '0'), ('016', 'ccc2', '2007-07-27', '0'), ('016', 'ddd6', '2007-04-23', '0'), ('016', 'eey9', '2010-09-05', '0'), ('016', 'erv4', '2008-04-30', '0'), ('016', 'ffq8', '2006-06-15', '0'), ('016', 'fqa8', '2004-02-16', '0'), ('016', 'gox9', '2008-02-12', '0'), ('016', 'gwp5', '2005-01-20', '0'), ('016', 'hho1', '2007-10-09', '0'), ('016', 'kkw1', '2010-07-19', '0'), ('016', 'kqp6', '2006-04-12', '0'), ('016', 'psq9', '2006-08-05', '0'), ('016', 'slq6', '2010-12-25', '0'), ('016', 'ttw2', '2011-12-29', '0'), ('016', 'uiw1', '2003-11-14', '0'), ('017', 'aaa1', '2010-03-11', '0'), ('017', 'bbc4', '2006-03-23', '0'), ('017', 'bbe1', '2007-05-20', '0'), ('017', 'erv4', '2008-06-18', '0'), ('017', 'ffq8', '2011-11-20', '0'), ('017', 'fqa8', '2010-11-26', '0'), ('017', 'gwp5', '2012-09-04', '0'), ('017', 'kqp6', '2009-07-23', '0'), ('017', 'slq6', '2005-03-15', '0'), ('017', 'ttw2', '2008-08-21', '0'), ('017', 'uiw1', '2004-06-10', '0'), ('018', 'aaa1', '2013-02-16', '0'), ('018', 'bbc4', '2009-03-13', '0'), ('018', 'bbe1', '2003-06-11', '0'), ('018', 'ccc2', '2006-06-13', '0'), ('018', 'ddd6', '2008-10-09', '0'), ('018', 'eey9', '2011-05-18', '0'), ('018', 'ffq8', '2009-10-18', '0'), ('018', 'fqa8', '2003-08-04', '0'), ('018', 'gox9', '2005-09-16', '0'), ('018', 'gwp5', '2013-01-15', '0'), ('018', 'hho1', '2005-11-26', '0'), ('018', 'kkw1', '2007-03-22', '0'), ('018', 'kqp6', '2005-04-01', '0'), ('018', 'psq9', '2011-05-28', '0'), ('018', 'psq9', '2011-06-06', '0'), ('018', 'psq9', '2012-06-23', '0'), ('018', 'slq6', '2008-04-06', '0'), ('018', 'ttw2', '2003-11-17', '0'), ('018', 'uiw1', '2011-06-05', '0');
COMMIT;

