-- phpMyAdmin SQL Dump
-- version 4.2.7.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Set 22, 2017 alle 21:42
-- Versione del server: 5.5.27
-- PHP Version: 5.5.15

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


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

--
-- Database: `itiomar`
--

-- --------------------------------------------------------

--
-- Struttura della tabella `elenco_classi`
--

DROP TABLE IF EXISTS `elenco_classi`;
CREATE TABLE IF NOT EXISTS `elenco_classi` (
`idcl` int(11) NOT NULL,
  `classe` text NOT NULL,
  `coordinatore` tinytext NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=44 ;

--
-- Dump dei dati per la tabella `elenco_classi`
--

INSERT INTO `elenco_classi` (`idcl`, `classe`, `coordinatore`) VALUES
(1, '1CA', 'TORNOTTI MARIA LUISA'),
(2, '1CB', 'GARDINI EMANUELA'),
(3, '1CC', 'BERGONZI ELENA'),
(4, '1EA', 'GOBBI FRATTINI LAURA'),
(5, '1EB', 'MENESINI RENATA GABRIELLA'),
(6, '1EC', 'GAVI GABRIELE'),
(7, '1ED', 'PARONZINI CHIARA'),
(8, '1EE', 'ZOLESI GIUSEPPE'),
(9, '1EF', 'ZAPPA MASSIMO'),
(10, '1MA', 'BOZZOLA LAURA'),
(11, '1MB', 'POLICARO VINCENZO'),
(12, '1MD', 'SPATERI ANNA MARIA'),
(13, '1ME', 'LOBIANCO TERESA'),
(14, '1MF', 'LOBIANCO TERESA'),
(15, '2CB', 'RENOLFI LIVIA'),
(16, '2CC', 'VICARIO ANNAMARIA'),
(17, '2EA', 'FERRARI MARIANGELA'),
(18, '2EB', 'SEMPIO NADIA'),
(19, '2EC', 'VICARIO ANNAMARIA'),
(20, '2MA', 'RODINI CINZIA'),
(21, '2MB', 'BELLANOVA SABRINA'),
(22, '2MC', 'LA VITOLA GIORGIO MARIO'),
(23, '3CA', 'PARRAVICINI EMANUELA'),
(24, '3CB', 'BALZARETTI DARIO'),
(25, '3EA', 'BOZZOLA CARMEN'),
(26, '3MA', 'GANGEMI CATERINA'),
(27, '3MB', 'CORMANNI CARLO MARIA'),
(28, '3RA', 'PANIGATI PAOLA'),
(29, '3RB', 'CASTOLDI ANNALISA'),
(30, '4CA', 'FONTANETO CELESTINO'),
(31, '4CB', 'SEBASTIANI LORETTA'),
(32, '4EA', 'MACALUSO ELEONORA'),
(33, '4MA', 'GANGEMI CATERINA'),
(34, '4MB', 'BARINO SARA'),
(35, '4RA', 'PASTORE ANNA'),
(36, '5CA', 'QUARTARA LUISA'),
(37, '5CB', 'CAPRILE LAURA'),
(38, '5EA', 'IMPERATO CARLO'),
(39, '5MA', 'GATTO ANTONIO'),
(40, '5MB', 'ZANINETTI GIANCARLO'),
(41, '5RA', 'PALMA ALESSANDRO'),
(42, '1MC', ''),
(43, '2CA', '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `elenco_classi`
--
ALTER TABLE `elenco_classi`
 ADD PRIMARY KEY (`idcl`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `elenco_classi`
--
ALTER TABLE `elenco_classi`
MODIFY `idcl` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=44;
/*!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 */;
