-- MySQL dump 9.07 -- -- Host: localhost Database: SCHOOL --------------------------------------------------------- -- Server version 4.0.12-standard -- -- Table structure for table 'assenze_personale' -- DROP TABLE IF EXISTS assenze_personale; CREATE TABLE `assenze_personale` ( `id` int(11) NOT NULL auto_increment, `dal` datetime NOT NULL default '0000-00-00 00:00:00', `al` datetime NOT NULL default '0000-00-00 00:00:00', `motivo` text, `idpersonale` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'assenze_personale' -- /*!40000 ALTER TABLE assenze_personale DISABLE KEYS */; LOCK TABLES assenze_personale WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE assenze_personale ENABLE KEYS */; -- -- Table structure for table 'assenze_studenti' -- DROP TABLE IF EXISTS assenze_studenti; CREATE TABLE `assenze_studenti` ( `id` int(11) NOT NULL auto_increment, `idstudente` int(11) NOT NULL default '0', `idmateria` int(11) NOT NULL default '0', `giorno` date NOT NULL default '0000-00-00', `ora` int(11) NOT NULL default '0', `idclasse` int(11) NOT NULL default '0', `giustificata` enum('Y','N') NOT NULL default 'N', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'assenze_studenti' -- /*!40000 ALTER TABLE assenze_studenti DISABLE KEYS */; LOCK TABLES assenze_studenti WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE assenze_studenti ENABLE KEYS */; -- -- Table structure for table 'cache' -- DROP TABLE IF EXISTS cache; CREATE TABLE `cache` ( `url` varchar(255) NOT NULL default '', `nfile` varchar(255) NOT NULL default '' ) TYPE=MyISAM; -- -- Dumping data for table 'cache' -- /*!40000 ALTER TABLE cache DISABLE KEYS */; LOCK TABLES cache WRITE; INSERT INTO cache VALUES ('/school/index.php?idsessione=314&sessione=16664990680923898462&modulo=menu&area=segreteria&sezione=admin','SCHcZ4Wov'),('/school/index.php?idsessione=315&sessione=76973582644825960054&modulo=menu&area=segreteria&sezione=admin','SCH0037ed'),('/school/ANNO2002_2003/index.php?idsessione=316&sessione=75748063670286596836&modulo=menu&area=segreteria&sezione=admin','SCHV8Ob6g'),('/school/ANNO2002_2003/index.php?idsessione=317&sessione=3635242281029820346&modulo=menu&area=segreteria&sezione=admin','SCH6uErxA'),('/school/index.php?idsessione=318&sessione=47095120150167314640&modulo=menu&area=genitori&sezione=admin','SCHkNTn2e'),('/school/index.php?idsessione=318&sessione=47095120150167314640&modulo=menu&area=segreteria&sezione=admin','SCHkYS5lN'),('/school/index.php?idsessione=318&sessione=47095120150167314640&modulo=menu&sezione=admin&area=segreteria','SCH535TxU'),('/school/index.php?idsessione=319&sessione=487372938241178152&modulo=menu&area=segreteria&sezione=admin','SCHHpUqqf'),('/school/index.php?idsessione=320&sessione=84939386528937878389&modulo=menu&area=segreteria&sezione=admin','SCHLfs1mg'),('/school/index.php?idsessione=321&sessione=92087058497932052139&modulo=menu&area=segreteria&sezione=admin','SCHuHfnDC'),('/school/index.php?idsessione=322&sessione=57427430577136999168&modulo=menu&area=segreteria&sezione=admin','SCHTbrRz6'),('/school/index.php?idsessione=323&sessione=59453458511848421160&modulo=menu&area=docenti&sezione=admin','SCHdW3maa'),('/school/index.php?idsessione=324&sessione=74592124263836511418&modulo=menu&area=studenti&sezione=admin','SCHfq3CrD'),('/school/index.php?idsessione=324&sessione=74592124263836511418&modulo=menu&area=segreteria&sezione=admin','SCHHQQhU7'),('/school/index.php?idsessione=325&sessione=78282157752744182840&modulo=menu&area=docenti&sezione=admin','SCHVLfqvR'),('/school/index.php?idsessione=325&sessione=78282157752744182840&modulo=menu&sezione=admin&area=docenti','SCHgdOSGg'),('/school/index.php?idsessione=326&sessione=6599383038132822889&modulo=menu&area=segreteria&sezione=admin','SCHyP2Gh7'),('/school/index.php?idsessione=327&sessione=5588127177495379867&modulo=menu&area=segreteria&sezione=admin','SCH9gcP1r'),('/school/index.php?idsessione=328&sessione=2540499139397623680&modulo=menu&area=segreteria&sezione=admin','SCHYBMA2T'),('/school/ANNO2002_2003/index.php?idsessione=1&sessione=21363792632439035350&modulo=menu&area=studenti&sezione=admin','SCHxtVyYH'),('/school/ANNO2002_2003/index.php?idsessione=1&sessione=21363792632439035350&modulo=menu&area=genitori&sezione=admin','SCHZcvOw1'),('/school/ANNO2002_2003/index.php?idsessione=3&sessione=44630342828211389333&modulo=menu&area=studenti&sezione=admin','SCH9gkxaG'),('/school/ANNO2002_2003/index.php?idsessione=3&sessione=44630342828211389333&modulo=menu&area=genitori&sezione=admin','SCH3kIovK'),('/school/ANNO2002_2003/index.php?idsessione=3&sessione=44630342828211389333&modulo=menu&area=docenti&sezione=admin','SCHf7ny2O'),('/school/ANNO2002_2003/index.php?idsessione=5&sessione=91057550774632871154&modulo=menu&area=studenti&sezione=admin','SCH17WUYZ'),('/school/ANNO2002_2003/index.php?idsessione=9&sessione=8329473577487463873&modulo=menu&area=genitori&sezione=admin','SCHeJfImX'),('/school/ANNO2002_2003/index.php?idsessione=11&sessione=5400604497278053828&modulo=menu&area=docenti&sezione=admin','SCHtkMrtk'); UNLOCK TABLES; /*!40000 ALTER TABLE cache ENABLE KEYS */; -- -- Table structure for table 'classi' -- DROP TABLE IF EXISTS classi; CREATE TABLE `classi` ( `id` int(11) NOT NULL auto_increment, `numero` int(11) NOT NULL default '1', `sezione` varchar(16) NOT NULL default '', `extra` varchar(16) NOT NULL default '', `idstudente1` int(11) NOT NULL default '0', `idstudente2` int(11) NOT NULL default '0', `idstudente3` int(11) NOT NULL default '0', `idstudente4` int(11) NOT NULL default '0', `idstudente5` int(11) NOT NULL default '0', `idstudente6` int(11) NOT NULL default '0', `idstudente7` int(11) NOT NULL default '0', `idstudente8` int(11) NOT NULL default '0', `idstudente9` int(11) NOT NULL default '0', `idstudente10` int(11) NOT NULL default '0', `idstudente11` int(11) NOT NULL default '0', `idstudente12` int(11) NOT NULL default '0', `idstudente13` int(11) NOT NULL default '0', `idstudente14` int(11) NOT NULL default '0', `idstudente15` int(11) NOT NULL default '0', `idstudente16` int(11) NOT NULL default '0', `idstudente17` int(11) NOT NULL default '0', `idstudente18` int(11) NOT NULL default '0', `idstudente19` int(11) NOT NULL default '0', `idstudente20` int(11) NOT NULL default '0', `idstudente21` int(11) NOT NULL default '0', `idstudente22` int(11) NOT NULL default '0', `idstudente23` int(11) NOT NULL default '0', `idstudente24` int(11) NOT NULL default '0', `idstudente25` int(11) NOT NULL default '0', `idstudente26` int(11) NOT NULL default '0', `idstudente27` int(11) NOT NULL default '0', `idstudente28` int(11) NOT NULL default '0', `idstudente29` int(11) NOT NULL default '0', `idstudente30` int(11) NOT NULL default '0', `idstudente31` int(11) NOT NULL default '0', `idstudente32` int(11) NOT NULL default '0', `idstudente33` int(11) NOT NULL default '0', `idstudente34` int(11) NOT NULL default '0', `idstudente35` int(11) NOT NULL default '0', `anno_scolastico` varchar(16) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'classi' -- /*!40000 ALTER TABLE classi DISABLE KEYS */; LOCK TABLES classi WRITE; INSERT INTO classi VALUES (1,1,'A','Ragioneria',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(3,2,'A','Ragioneria',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(4,3,'A','Ragioneria',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(5,4,'A','Ragioneria',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(6,4,'B','Ragioneria',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(7,5,'A','Ragioneria',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(10,2,'A','Geometri',39,40,41,54,43,44,45,47,48,49,50,51,55,52,53,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(11,3,'A','Geometri',56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(12,4,'A','Geometri',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(13,4,'B','Geometri',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(14,5,'A','Geometri',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(15,5,'B','Geometri',5,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,24,25,26,27,28,1,2,3,4,5,6,7,0,0,0,0,0,0,'2002/2003'),(18,5,'B','Ragioneria',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(24,1,'A','Geometri',29,30,31,32,33,34,35,36,37,38,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(20,4,'C','Ragioneria',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(21,5,'C','Ragioneria',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(22,4,'C','Geometri',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'),(23,5,'C','Geometri',6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2002/2003'); UNLOCK TABLES; /*!40000 ALTER TABLE classi ENABLE KEYS */; -- -- Table structure for table 'comunicazioni_classe' -- DROP TABLE IF EXISTS comunicazioni_classe; CREATE TABLE `comunicazioni_classe` ( `id` int(11) NOT NULL auto_increment, `idclasse` int(11) NOT NULL default '0', `iddocente` int(11) NOT NULL default '0', `data` date NOT NULL default '0000-00-00', `comunicazione` text, PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'comunicazioni_classe' -- /*!40000 ALTER TABLE comunicazioni_classe DISABLE KEYS */; LOCK TABLES comunicazioni_classe WRITE; INSERT INTO comunicazioni_classe VALUES (1,1,1,'2003-02-12','domani riunione collegio docenti'),(3,1,5,'0000-00-00','com'),(4,15,11,'2003-03-17',' \r\n '),(5,15,11,'0000-00-00',' \r\n '),(6,15,7,'2003-03-18',' \r\n '),(7,15,11,'2003-03-28',' \r\n '),(8,15,11,'2003-04-02',' \r\n tutto bene'),(9,15,10,'2003-05-16',' \r\n '); UNLOCK TABLES; /*!40000 ALTER TABLE comunicazioni_classe ENABLE KEYS */; -- -- Table structure for table 'comunicazioni_famiglia' -- DROP TABLE IF EXISTS comunicazioni_famiglia; CREATE TABLE `comunicazioni_famiglia` ( `id` int(11) NOT NULL auto_increment, `iddocente` int(11) NOT NULL default '0', `idgenitore` int(11) NOT NULL default '0', `idstudente` int(11) NOT NULL default '0', `idclasse` int(11) NOT NULL default '0', `comunicazione` text, `data` date NOT NULL default '0000-00-00', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'comunicazioni_famiglia' -- /*!40000 ALTER TABLE comunicazioni_famiglia DISABLE KEYS */; LOCK TABLES comunicazioni_famiglia WRITE; INSERT INTO comunicazioni_famiglia VALUES (1,1,1,1,1,'Test di comunicazione \r\nsu Cognome-Test Nome-test','2003-02-05'),(2,11,4,5,15,'NON HA CONSEGNATO IL PROGETTO','2003-03-28'),(3,11,21,7,15,'DISTURBA LA LEZIONE','2003-03-28'); UNLOCK TABLES; /*!40000 ALTER TABLE comunicazioni_famiglia ENABLE KEYS */; -- -- Table structure for table 'contratti_dipendenti' -- DROP TABLE IF EXISTS contratti_dipendenti; CREATE TABLE `contratti_dipendenti` ( `id` int(11) NOT NULL auto_increment, `contratto` varchar(64) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'contratti_dipendenti' -- /*!40000 ALTER TABLE contratti_dipendenti DISABLE KEYS */; LOCK TABLES contratti_dipendenti WRITE; INSERT INTO contratti_dipendenti VALUES (1,'Dipendente'),(2,'Autonomo'),(3,'Professionista'); UNLOCK TABLES; /*!40000 ALTER TABLE contratti_dipendenti ENABLE KEYS */; -- -- Table structure for table 'contratto_iscrizione' -- DROP TABLE IF EXISTS contratto_iscrizione; CREATE TABLE `contratto_iscrizione` ( `id` int(11) NOT NULL auto_increment, `idgenitore` int(11) NOT NULL default '0', `idstudente` int(11) NOT NULL default '0', `rata1` varchar(128) default '', `rata2` varchar(128) default '', `rata3` varchar(128) default '', `rata4` varchar(128) default '', `rata5` varchar(128) default '', `rata6` varchar(128) default '', `rata7` varchar(128) default '', `rata8` varchar(128) default '', `rata9` varchar(128) default '', `rata10` varchar(128) default '', `rata11` varchar(128) default '', `rata12` varchar(128) default '', `data_rata1` date default '0000-00-00', `data_rata2` date default '0000-00-00', `data_rata3` date default '0000-00-00', `data_rata4` date default '0000-00-00', `data_rata5` date default '0000-00-00', `data_rata6` date default '0000-00-00', `data_rata7` date default '0000-00-00', `data_rata8` date default '0000-00-00', `data_rata9` date default '0000-00-00', `data_rata10` date default '0000-00-00', `data_rata11` date default '0000-00-00', `data_rata12` date default '0000-00-00', `importo_rata1` double(4,2) default '0.00', `importo_rata2` double(4,2) default '0.00', `importo_rata3` double(4,2) default '0.00', `importo_rata4` double(4,2) default '0.00', `importo_rata5` double(4,2) default '0.00', `importo_rata6` double(4,2) default '0.00', `importo_rata7` double(4,2) default '0.00', `importo_rata8` double(4,2) default '0.00', `importo_rata9` double(4,2) default '0.00', `importo_rata10` double(4,2) default '0.00', `importo_rata11` double(4,2) default '0.00', `importo_rata12` double(4,2) default '0.00', `pagata1` enum('Y','N') default 'N', `pagata2` enum('Y','N') default 'N', `pagata3` enum('Y','N') default 'N', `pagata4` enum('Y','N') default 'N', `pagata5` enum('Y','N') default 'N', `pagata6` enum('Y','N') default 'N', `pagata7` enum('Y','N') default 'N', `pagata8` enum('Y','N') default 'N', `pagata9` enum('Y','N') default 'N', `pagata10` enum('Y','N') default 'N', `pagata11` enum('Y','N') default 'N', `pagata12` enum('Y','N') default 'N', `rata_anticipata` double(4,2) NOT NULL default '0.00', `costo_esame` double(4,2) NOT NULL default '0.00', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'contratto_iscrizione' -- /*!40000 ALTER TABLE contratto_iscrizione DISABLE KEYS */; LOCK TABLES contratto_iscrizione WRITE; INSERT INTO contratto_iscrizione VALUES (1,72,1,'SETTEMBRE','OTTOBRE','NOVEMBRE','DICEMBRE','GENNAIO','FEBBRAIO','MARZO','APRILE','MAGGIO','','','','2003-09-15','2003-10-05','2003-11-05','2003-12-05','2004-01-05','2004-02-05','2004-03-05','2004-04-05','2004-05-05','0000-00-00','0000-00-00','0000-00-00',400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,0.00,0.00,0.00,'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',400.00,400.00),(2,73,2,'SETTEMBRE','OTTOBRE','NOVEMBRE','DICEMBRE','GENNAIO','FEBBRAIO','MARZO','APRILE','MAGGIO','','','','2003-09-15','2003-10-05','2003-11-05','2003-12-05','2004-01-05','2004-02-05','2004-03-05','2004-04-05','2004-05-05','0000-00-00','0000-00-00','0000-00-00',400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,0.00,0.00,0.00,'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',400.00,400.00),(3,75,3,'SETTEMBRE','OTTOBRE','NOVEMBRE','DICEMBRE','GENNAIO','FEBBRAIO','MARZO','APRILE','MAGGIO','','','','2003-09-15','2003-10-05','2003-11-05','2003-12-05','2004-01-05','2004-02-05','2004-03-05','2004-04-05','2004-05-05','0000-00-00','0000-00-00','0000-00-00',400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,0.00,0.00,0.00,'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',400.00,400.00),(4,76,4,'SETTEMBRE','OTTOBRE','NOVEMBRE','DICEMBRE','GENNAIO','FEBBRAIO','MARZO','APRILE','MAGGIO','','','','2003-09-15','2003-10-05','2003-11-05','2003-12-05','2004-01-05','2004-02-05','2004-03-05','2004-04-05','2004-05-05','0000-00-00','0000-00-00','0000-00-00',400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,0.00,0.00,0.00,'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',400.00,400.00),(5,77,5,'SETTEMBRE','OTTOBRE','NOVEMBRE','DICEMBRE','GENNAIO','FEBBRAIO','MARZO','APRILE','MAGGIO','','','','2003-09-15','2003-10-05','2003-11-05','2003-12-05','2004-01-05','2004-02-05','2004-03-05','2004-04-05','2004-05-05','0000-00-00','0000-00-00','0000-00-00',400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,0.00,0.00,0.00,'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',400.00,400.00),(6,78,6,'SETTEMBRE','OTTOBRE','NOVEMBRE','DICEMBRE','GENNAIO','FEBBRAIO','MARZO','APRILE','MAGGIO','','','','2003-09-15','2003-10-05','2003-11-05','2003-12-05','2004-01-05','2004-02-05','2004-03-05','2004-04-05','2004-05-05','0000-00-00','0000-00-00','0000-00-00',400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,0.00,0.00,0.00,'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',400.00,400.00),(7,79,7,'SETTEMBRE','OTTOBRE','NOVEMBRE','DICEMBRE','GENNAIO','FEBBRAIO','MARZO','APRILE','MAGGIO','','','','2003-09-15','2003-10-05','2003-11-05','2003-12-05','2004-01-05','2004-02-05','2004-03-05','2004-04-05','2004-05-05','0000-00-00','0000-00-00','0000-00-00',400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,0.00,0.00,0.00,'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',400.00,400.00); UNLOCK TABLES; /*!40000 ALTER TABLE contratto_iscrizione ENABLE KEYS */; -- -- Table structure for table 'entrate_studenti' -- DROP TABLE IF EXISTS entrate_studenti; CREATE TABLE `entrate_studenti` ( `id` int(11) NOT NULL auto_increment, `ora` int(11) NOT NULL default '0', `giorno` date NOT NULL default '0000-00-00', `motivo` varchar(255) default '', `idstudente` int(11) NOT NULL default '0', `idclasse` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'entrate_studenti' -- /*!40000 ALTER TABLE entrate_studenti DISABLE KEYS */; LOCK TABLES entrate_studenti WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE entrate_studenti ENABLE KEYS */; -- -- Table structure for table 'esenzioni_studenti' -- DROP TABLE IF EXISTS esenzioni_studenti; CREATE TABLE `esenzioni_studenti` ( `id` int(11) NOT NULL auto_increment, `idstudente` int(11) NOT NULL default '0', `idmateria` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'esenzioni_studenti' -- /*!40000 ALTER TABLE esenzioni_studenti DISABLE KEYS */; LOCK TABLES esenzioni_studenti WRITE; INSERT INTO esenzioni_studenti VALUES (1,1,0),(2,39,23),(3,39,25); UNLOCK TABLES; /*!40000 ALTER TABLE esenzioni_studenti ENABLE KEYS */; -- -- Table structure for table 'genitori' -- DROP TABLE IF EXISTS genitori; CREATE TABLE `genitori` ( `id` int(11) NOT NULL auto_increment, `codicefiscale` varchar(16) NOT NULL default '', `cognome` varchar(32) NOT NULL default '', `nome` varchar(32) NOT NULL default '', `nato_a` varchar(32) NOT NULL default '', `nato_il` date NOT NULL default '0000-00-00', `residenza` varchar(32) NOT NULL default '', `via` varchar(64) NOT NULL default '', `documento_identita` varchar(32) NOT NULL default '', `di_numero` varchar(16) NOT NULL default '', `di_data` date NOT NULL default '0000-00-00', `di_presso` varchar(32) NOT NULL default '', `tel1` varchar(20) NOT NULL default '', `tel2` varchar(20) NOT NULL default '', `cell` varchar(20) NOT NULL default '', `email` varchar(255) NOT NULL default '', `professione` varchar(64) NOT NULL default '', `tipo` enum('T','G') NOT NULL default 'G', `padre_madre` enum('P','M') NOT NULL default 'P', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'genitori' -- /*!40000 ALTER TABLE genitori DISABLE KEYS */; LOCK TABLES genitori WRITE; INSERT INTO genitori VALUES (32,'','TURSI','GRAZIA','ALBEROBELLO (BA)','1951-07-23','PIOSSASCO (TO)','VIA VECELLIO 6/2','','AG6064524','2002-03-02','_______________','011/9065179','','','','','G','P'),(4,'PSCRSO58B51A056M','PESCE','ROSA','ADRANO (CT)','1958-05-11','RIVALTA (TO)','VIALE CADORE 74','Carta di Identita\'','AD8283157','0000-00-00','Comune','0119046418','','3398487821','','IMPIEGATO','G','P'),(31,'','MARCHIONE','MARCO','GIAVENO','1983-01-22','ORBASSANO (TO)','STRADA VOLVERA 25','','AE7274660','2001-03-02','_______________','011/9016332','','339/7788641','','','G','P'),(29,'','MACHIORLATTI','GRAZIANO','MATHI (TO)','1943-03-27','BARBANIA (TO)','BORGATA ZACCARIA 7','','AG4755879','2001-10-10','_______________','011/9243772','','333/1670749','','','G','P'),(30,'','PIRRITANO','EMMA','STIGNANO (RC)','1954-03-02','ORBASSANO (TO)','VIA VOLTURNO 12','','AC9095354','1999-04-15','_______________','011/9014850','011/6830367','','','','G','P'),(28,'','PALADINO','GRAZIA','TORITTO (BA)','1954-12-03','TORINO','VIA REFRANCORE 75','','AD6207439','2000-03-02','_______________','011/4557712','011/44228490','349/5383941','','','G','P'),(25,'','BARATELLA','SILVANA','TORINO','1950-12-08','CHIERI (TO)','VIA BALETTI 27','','AG9755038','2002-04-22','_______________','011/9423262','','349/6373104','','','G','P'),(26,'','FREGUIA','ANTONIO','CONTARINA (RO)','1955-02-25','VENARIA (TO)','VIA IV NOVEMBRE 38','','AC8898719','1998-10-10','_______________','011/4520918','011/497763','339/4936234','','','G','P'),(27,'','DAZZEO','ANTONIA','CERIGNOLA (FG)','1949-05-23','RIVOLI (TO)','VIA TEVERE 9','','TO3500829K','1992-12-05','_______________','011/9592566','','340/3114113','','','G','P'),(21,'','MANTOVANI','SERGIA','OCCHIOBELLO (RO)','1949-12-12','TORINO','CORSO CHIETI 23','','AD6191485','2020-00-02','_______________','011/8992273','011/796570','','','','G','P'),(22,'','CATALANO','ROSALIA','LERCARA FRIDDI (PA)','1957-09-05','TORINO','VIA BRANDIZZO 91','','AD0259590','1998-06-30','_______________','011/850425','','333/9922939','','','G','P'),(23,'','LOPORCARO','MAGRISTRALE','ALTAMURA (BA)','1960-12-03','BEINASCO (TO)','VIA PR. AMEDEO 29','','AD6214245','1999-10-20','_______________','011/3497024','011/3498004','','','','G','P'),(24,'','CONSOLENTE','FEDERICA','TORINO','1983-09-01','TRANA (TO)','VIA ASTI 16','','AG2609984','2002-10-09','_______________','011/933270','','339/2463508','','','G','P'),(33,'','QUIRICO','MARIA ANGELA','SAN MAURO (TO)','1959-11-01','SAN MAURO (TO)','VIA SETTIMO 236','','AD8713473','2000-11-07','_______________','011/8222365','','338/2241002','','','G','P'),(34,'','POLLIFRONE','VINCENZO','ARDORE (RC)','1950-09-28','GRUGLIASCO (TO)','VIA CAV. DI VITT. VENETO 27','','AD8639116','1999-12-31','_______________','011/787244','011/9662279','','','','G','P'),(35,'','PRETTI','ALESSANDRO','DRUENTO (TO)','1957-06-15','DRUENTO (TO)','VIA MULINO 9/2','','TO2186224','1977-03-10','_______________','011/9844078','011/484508','','','','G','P'),(36,'','REY','GIORGIO','SALBERTRAND (TO)','1955-09-05','SALBERTRAND (TO)','VIA GLEISETTA 4','','AG4756275','2002-04-18','_______________','0122/854652','','335/8376219','','','G','P'),(37,'','CARNINO','MARINA','AVIGLIANA (TO)','1954-04-03','GIAVENO (TO)','VIA COAZZE 247/B','','AD2001286','1998-12-01','_______________','011/9364959','','335/8182762','','','G','P'),(38,'','SCARAZZATI','DANIELE','FICAROLO (RO)','1956-05-01','ORBASSANO (TO)','VIA MARCONI 11','','AC3698816','2998-04-16','_______________','011/9014517','01/9002571','','','','G','P'),(39,'','PELLE','ANTONIA','SAN LUCA (RC)','1960-04-26','TORINO','VIA CARMAGNOLA 2','','AD8805234','2020-00-07','_______________','011/2484803','','','','','G','P'),(40,'','VOTA','CLAUDIO','TORINO','1955-01-19','TORINO','VIA VEZZOLANO 9','','AG4784483','2002-04-05','_______________','011/8903719','','335/5297474','','','G','P'),(41,'','MARTINI','EMANUELA','TORINO','1956-06-21','DRUENTO (TO)','STRADA TROGNANI 24/4','','AC7506785','1988-08-18','_______________','011/9845539','011/55233224','339/4288543','','','G','P'),(42,'','CARELLA','NUNZIA','CERIGNOLA (FG)','1951-11-13','TORINO','CORSO EINAUDI 5','','AC7490534','1998-04-01','_______________','011593273','','3356896086','','','G','P'),(43,'','LODIGIANI','MARIANO','TORINO','1924-10-09','TORINO','VIA PO 32','','','0000-00-00','_______________','0118171384','','','','','T','P'),(44,'','CARTA','GIAN FELICE','SASSARI','1951-10-09','TORINO','CORSO SEBASTOPOLI 206','','AE6044963','0000-00-00','_______________','011357892','011435491','','','','G','P'),(45,'','RUBECA','PIERO','TORINO','1960-08-06','VINOVO (TO)','VIA P. ALIBERTI 61','','TO5041431P','1996-05-30','_______________','0119656393','3356090281','3338206006','_____________________','','G','P'),(46,'','CHIAPELLO','MIRELLA','TORINO','1961-02-23','TORINO','CORSO FRANCIA 356/22','','TO5094873B','1997-03-29','_______________','011798445','','3357595730','_____________________','','G','P'),(47,'','ACQUADRO','ERMANNO','TOLLEGNO (BI)','1957-05-31','VIA MANCINI 4/B','TOLLEGNO (BI)','','AD9862894','2000-07-28','_______________','015421925','____________________','3382632663','____________________','','G','P'),(48,'','ARRIVABENI','PIERO ANTONIO','TORINO','1953-01-16','TORINO','CORSO SALVEMINI 35','','TO3704013P','1996-04-19','_______________','0113140752','___________________','3474685894','___________________','','G','P'),(49,'','DE ZARLO','RAFFAELE','________________','0000-00-00','SAN MAURO (TO)','VIA XXV APRILE 43','','________________','0000-00-00','_______________','0118985822','____________________','____________________','____________________','','G','P'),(50,'','DI NATALE','EMANUELE','TORINO','1960-06-24','TORINO','VIA DE GENEIS 13','','AD1208618','1999-05-05','_______________','0112200728','____________________','330770411','____________________','','G','P'),(51,'','BONGIORNI','SILVANA','CASTIGLIONE (TO)','1957-01-28','CASTIGLIONE (TO)','VIA SCURSATONE 61','','AC9103678','1998-10-20','_______________','011887413','','3382604336','','','G','P'),(52,'','MARCHISIO','STEFANO','CHIERI (TO)','1950-11-04','ANDEZENO (TO)','STRADA LA REZZA 18','','AC7523682','1998-07-21','_______________','0119434890','','____________________','','','G','P'),(53,'','DE FACIS','ROBERTO','TORINO','1954-07-03','TORINO','CORSO RE UMBERTO 50','','AE6086888','2001-04-06','_______________','0115694574','','3478807100','__________________','','G','P'),(54,'','PALMIERI','GIOVANNI','SAN SEVERO (FG)','1949-03-22','AVIGLIANA (TO)','VIA MONTE CUNEO 30/7','','TO5481425C','2002-09-24','_______________','0119312210','0115817338','__________________','__________________','','G','P'),(58,'','TUBILLA DE ALTAMIRANO','JUANA','ICA (PERU\')','1960-01-03','TORINO','VIA VENTIMIGLIA 146','Carta di Identita\'','AG2082484','2001-09-10','TORINO','0116635913','________________','________________','________________','','G','P'),(59,'','BERARDI','LUIGI','TORINO','1957-02-03','TORINO','VIA FREJUS 13','Carta di Identita\'','AD8818171','2000-08-11','TORINO','0117770206','________________','________________','________________','','G','P'),(60,'','DECOSTANZI','FABRIZIA','CASELLE (TO)','1964-02-02','CASELLE (TO)','VIA SUOR VINCENZA 28','Carta di Identita\'','AE3988948','2000-04-10','CASELLE (TO)','0119961243','0119975929','________________','fdecost@inwind.it','','G','P'),(61,'','DEMARIE','DANIELA','TORINO','1957-10-18','TORINO','VIA FATTORI 124','Carta di Identita\'','AD8765594','2000-11-21','TORINO','0117792189','________________','3333463545','________________','','G','P'),(62,'','FOIS','GIUSEPPINA','ALGHERO (SS)','1956-01-05','TORINO','VIA MAZZINI 26','Carta di Identita\'','AC9108018','1998-12-15','TORINO','0118123274','0113171560','________________','________________','','G','P'),(63,'','GUAZZOTTI','DANIELA','TORINO','1964-06-16','GRUGLIASCO (TO)','VIA S. ALLASON 20/2','Carta di Identita\'','AA7661349','1997-01-15','GRUGLIASCO','0116116018','________________','3405592740','________________','','G','P'),(64,'','ALOE','ROSA','CATONA DI REGGIO (RC)','1959-06-29','MONCALIERI (TO)','STRADA CARPICE 15','Patente','1469745','1998-05-08','REGGIO CALABRIA','0116467498','0116819580','________________','________________','','G','M'),(65,'','CHIAPUSSO','DONATELLA','TORINO','1946-10-08','TORINO','CORSO RAFFAELLO 27','Carta di Identita\'','AE7218293','2001-06-22','TORINO','011655845','________________','________________','________________','','G','P'),(66,'','GIULIETTO','LIVIO','TORINO','1947-10-23','TORRAZZA P.TE (TO)','VIA MONACO 7','Carta di Identita\'','AD1902511','1999-06-26','TORRAZZA P.TE','0119189663','0117784285','3284583448','________________','','G','P'),(67,'','ALI\'','ANNA MARIA','VENARIA (TO)','1962-10-26','TORINO','VIA NIZZA 348','Carta di Identita\'','AD0243931','1998-06-29','TORINO','0116638617','0116637800','________________','________________','','G','P'),(68,'','GUIDO','ROCCO','AMANTEA','1960-01-14','BUSSOLENO (TO)','VIA MOLETTA 2','Carta di Identita\'','AC9073472','1999-03-03','BUSSOLENO','012249315','________________','3483343774','________________','','G','P'),(69,'','SCHIORLIN','LUISELLA','TORINO','1962-11-30','MONCALIERI (TO)','VIA S.G. BOSCO 16','Carta di Identita\'','AG4768624','2001-03-01','MONCALIERI','0116061243','________________','________________','________________','','G','P'),(70,'','GARBARINO','SILVANA','SAN MAURO (TO)','1952-12-02','TORINO','PIAZZA NIZZA 75','Carta di Identita\'','AD8789220','2020-00-06','TORINO','0116687151','0116690090','________________','________________','','G','P'),(71,'','RAPETTI','CARLA','TORINO','1955-04-02','TORINO','CORSO TELESIO 93','Patente','TO3630261U','1994-05-10','TORINO','0117723085','0114425224','3335763718','________________','','G','P'),(72,'','BUCHMANN','ANGELIKA','MONDSEE (AUSTRIA)','1946-04-05','TRANA','VIA G. BRUNO 24','Carta di Identita\'','AD6228612','1999-03-16','TRANA','0119338368','011612263','________________','a.buchmann@libero.it','','G','M'),(73,'MRGMRA58D64L727E','MORGANA','MARIA','VENARIA','1958-04-24','VENARIA','VIA CARDUCCI 6','Carta di Identita\'','AG2599378','2001-03-22','VENARIA','0114526485','','3384455237','________________','','G','M'),(74,'','________________','________________','________________','0000-00-00','________________','________________','Carta di Identita\'','','0000-00-00','_______________','0112422509','________________','3357260111','________________','','G','P'),(75,'','ORTO','MARCO','________________','0000-00-00','________________','________________','Carta di Identita\'','','0000-00-00','_______________','0112422509','________________','3357260111','________________','','G','P'),(76,'LVRGNT57E20L583T','OLIVIERI','GIACINTO','TORINO','1957-05-20','TORINO','VIA MORETTA','Patente','TO2296091','1979-07-16','TORINO','0114474378','0114336826','________________','________________','','G','P'),(77,'CRSRRT53T23L219Z','CAROSSO','ROBERTO','TORINO','1953-12-23','TORINO','VIA CRISTALLIERA 19','Carta di Identita\'','AG4782741','2002-04-05','TORINO','0117490575','________________','3386564274','________________','','G','P'),(78,'PRNMRC56C14B960V','PERINO','MARCO','CASELLE (TO)','1956-03-14','CASELLE','VIA C. COLOMBO 4/7','Patente','TO5446478M','2002-04-09','CASELLE','0119975752','________________','3483512141','________________','','G','P'),(79,'','SIDDI','FRANCESCA','TORINO','1953-04-25','TORINO','C.SO ORBASSANO 227','Carta di Identita\'','AG5032783','2002-06-27','TORINO','011321400','________________','3387061506','________________','','T','P'),(80,'CNNMCR80M16L219H','CANNATA\'','MARC\'AURELIO','TORINO','1980-08-16','TORINO','CORSO BELGIO 19','Carta di Identita\'','AD8817956','2000-07-27','TORINO','01119707314','________________','3284877334','wasabi@fastwebnet.it','','G','P'); UNLOCK TABLES; /*!40000 ALTER TABLE genitori ENABLE KEYS */; -- -- Table structure for table 'incarichi_no_docenti' -- DROP TABLE IF EXISTS incarichi_no_docenti; CREATE TABLE `incarichi_no_docenti` ( `id` int(11) NOT NULL auto_increment, `incarico` varchar(64) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'incarichi_no_docenti' -- /*!40000 ALTER TABLE incarichi_no_docenti DISABLE KEYS */; LOCK TABLES incarichi_no_docenti WRITE; INSERT INTO incarichi_no_docenti VALUES (1,'Bidello'),(3,'Docente'),(4,'Segreteria didattica'),(5,'Dirigente scolastico'),(6,'Dirigente amministrativo'); UNLOCK TABLES; /*!40000 ALTER TABLE incarichi_no_docenti ENABLE KEYS */; -- -- Table structure for table 'incontri_genitori' -- DROP TABLE IF EXISTS incontri_genitori; CREATE TABLE `incontri_genitori` ( `id` int(11) NOT NULL auto_increment, `idclasse` int(11) NOT NULL default '0', `idconsiglio_classe` int(11) NOT NULL default '0', `data` date NOT NULL default '0000-00-00', `idstudente` int(11) NOT NULL default '0', `iddocente` int(11) NOT NULL default '0', `note` text, PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'incontri_genitori' -- /*!40000 ALTER TABLE incontri_genitori DISABLE KEYS */; LOCK TABLES incontri_genitori WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE incontri_genitori ENABLE KEYS */; -- -- Table structure for table 'lezioni' -- DROP TABLE IF EXISTS lezioni; CREATE TABLE `lezioni` ( `id` int(11) NOT NULL auto_increment, `idclasse` int(11) NOT NULL default '0', `da_ora` int(11) NOT NULL default '0', `num_ore` int(11) NOT NULL default '0', `argomento` text, `idmateria` int(11) NOT NULL default '0', `iddocente` int(11) NOT NULL default '0', `giorno` date NOT NULL default '0000-00-00', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'lezioni' -- /*!40000 ALTER TABLE lezioni DISABLE KEYS */; LOCK TABLES lezioni WRITE; INSERT INTO lezioni VALUES (14,15,1,2,'IDRAULICA',31,10,'2003-05-16'),(13,15,1,1,'tutto a posto',32,11,'2003-04-02'),(12,15,1,1,'LA LEZIONE',32,11,'2003-03-28'),(11,15,1,1,'ILLUSTRAZIONE MONOGRAFIE',8,7,'2003-03-18'),(10,15,1,2,'ESERCITAZIONI',32,11,'2003-03-17'); UNLOCK TABLES; /*!40000 ALTER TABLE lezioni ENABLE KEYS */; -- -- Table structure for table 'materie' -- DROP TABLE IF EXISTS materie; CREATE TABLE `materie` ( `id` int(11) NOT NULL auto_increment, `nome` varchar(32) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'materie' -- /*!40000 ALTER TABLE materie DISABLE KEYS */; LOCK TABLES materie WRITE; INSERT INTO materie VALUES (8,'Italiano'),(42,'Area Progetto'),(6,'Storia'),(9,'Inglese'),(10,'Francese'),(11,'Matematica'),(12,'Scienza della Materia'),(13,'Scienze della natura'),(14,'Economia aziendale'),(15,'Elementi di diritto'),(16,'Trattamento testi'),(17,'Educazione fisica femm.'),(18,'Educazione fisica masch.'),(19,'Fisica'),(20,'Scienze e geografia'),(21,'Chimica'),(22,'Disegno'),(23,'Conversazione inglese'),(41,'PROGETTO 2006'),(25,'Informatica'),(26,'Tecnologia rurale'),(27,'Economia Politica'),(28,'Economia Agraria'),(29,'Estimo'),(30,'Tecnologia delle Costruzioni'),(31,'Costruzioni'),(32,'Topografia'),(33,'Cad'),(34,'Progettazione'),(35,'Matematica finanziaria'),(36,'Diritto'),(37,'Scienza delle finanze'),(38,'Geografia economica'),(39,'Conversazione francese'),(40,'Contabilità automatizzata'); UNLOCK TABLES; /*!40000 ALTER TABLE materie ENABLE KEYS */; -- -- Table structure for table 'materie_docenti_classi' -- DROP TABLE IF EXISTS materie_docenti_classi; CREATE TABLE `materie_docenti_classi` ( `id` int(11) NOT NULL auto_increment, `idmateria` int(11) NOT NULL default '0', `iddocente` int(11) NOT NULL default '0', `idclasse` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'materie_docenti_classi' -- /*!40000 ALTER TABLE materie_docenti_classi DISABLE KEYS */; LOCK TABLES materie_docenti_classi WRITE; INSERT INTO materie_docenti_classi VALUES (10,6,7,15),(18,29,8,15),(13,31,10,15),(12,30,9,15),(9,8,7,15),(14,32,11,15),(15,36,12,15),(16,17,13,15),(17,18,14,15),(19,33,9,11),(20,33,11,12),(21,33,11,13),(22,33,11,22),(24,21,25,10),(25,21,25,11),(26,40,35,5),(27,40,35,6),(28,40,35,20),(29,39,28,1),(30,39,28,3),(31,39,28,4),(33,23,27,1),(34,23,27,10),(35,23,27,3),(36,23,27,4),(37,23,27,5),(38,23,27,6),(39,23,27,20),(40,31,10,11),(41,31,10,12),(42,31,9,13),(43,31,24,22),(44,31,10,14),(45,31,9,23),(118,15,23,3),(117,15,23,10),(116,15,23,1),(50,36,33,4),(51,36,33,5),(52,36,33,6),(53,36,33,7),(54,36,33,18),(55,36,39,20),(56,36,39,21),(57,36,12,12),(58,36,12,13),(59,36,12,14),(60,36,39,22),(61,36,12,23),(63,22,24,10),(64,22,9,11),(65,28,8,12),(66,28,8,13),(67,28,6,22),(68,14,21,1),(69,14,21,3),(70,14,21,4),(71,14,21,5),(72,14,36,6),(73,14,36,7),(74,14,23,18),(75,14,38,20),(76,14,38,21),(77,27,33,4),(78,27,33,5),(79,27,33,6),(80,27,39,20),(81,27,8,11),(82,37,33,7),(83,37,33,18),(84,37,39,21),(85,17,13,11),(86,17,13,4),(89,17,13,5),(91,17,13,6),(92,17,13,20),(93,17,13,14),(94,17,13,7),(95,17,13,18),(96,17,13,23),(97,17,13,21),(99,18,14,1),(100,18,14,10),(101,18,14,3),(102,18,14,11),(103,18,14,4),(104,18,14,12),(105,18,14,5),(106,18,14,13),(107,18,14,6),(108,18,14,14),(109,18,14,7),(110,18,14,18),(111,18,14,22),(112,18,14,20),(113,18,14,23),(114,18,14,21),(119,29,8,14),(120,29,6,23),(121,29,8,12),(122,29,8,13),(123,29,6,22),(125,19,24,10),(126,19,24,11),(127,10,20,1),(128,10,20,3),(129,10,20,4),(130,10,20,5),(131,10,20,6),(132,10,20,7),(133,10,20,18),(134,10,32,20),(135,10,32,21),(136,38,34,4),(137,38,25,5),(138,38,25,6),(139,38,25,20),(140,38,34,7),(141,38,34,18),(142,38,25,21),(144,25,30,1),(145,25,30,10),(146,25,30,3),(147,25,30,11),(148,25,30,4),(149,25,30,20),(151,9,22,1),(152,9,22,10),(153,9,22,3),(154,9,32,4),(155,9,22,5),(156,9,22,6),(157,9,32,20),(158,9,32,7),(159,9,32,18),(160,9,22,21),(162,8,19,1),(163,8,19,10),(164,8,19,3),(165,8,19,22),(166,8,19,20),(167,8,19,23),(168,8,19,21),(169,8,7,11),(170,8,7,12),(171,8,7,13),(172,8,7,14),(173,8,31,4),(174,8,31,5),(175,8,31,6),(176,8,31,7),(177,8,31,18),(179,11,18,1),(180,11,18,10),(181,11,18,3),(182,11,24,11),(183,11,24,12),(184,11,24,13),(185,11,37,22),(186,35,23,4),(187,35,23,5),(188,35,23,6),(189,35,37,20),(190,35,18,7),(191,35,18,18),(192,35,35,21),(193,34,11,12),(194,34,11,13),(195,34,11,22),(196,12,25,1),(197,12,25,3),(198,13,25,1),(199,13,25,3),(236,42,18,21),(201,20,25,10),(235,41,40,23),(203,6,19,1),(204,6,19,10),(205,6,19,3),(206,6,19,22),(207,6,19,20),(208,6,19,23),(209,6,19,21),(210,6,7,11),(211,6,7,12),(212,6,7,13),(213,6,7,14),(214,6,31,4),(215,6,31,5),(216,6,31,6),(217,6,31,7),(218,6,31,18),(219,16,26,1),(220,16,26,3),(221,26,8,11),(222,30,9,11),(223,30,9,12),(224,30,11,13),(225,30,9,14),(226,30,11,22),(227,30,11,23),(228,32,11,11),(229,32,40,12),(230,32,40,13),(231,32,40,14),(232,32,40,23),(233,32,41,22); UNLOCK TABLES; /*!40000 ALTER TABLE materie_docenti_classi ENABLE KEYS */; -- -- Table structure for table 'note_studenti' -- DROP TABLE IF EXISTS note_studenti; CREATE TABLE `note_studenti` ( `id` int(11) NOT NULL auto_increment, `nota` text, `idstudente` int(11) NOT NULL default '0', `idclasse` int(11) NOT NULL default '0', `data` date NOT NULL default '0000-00-00', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'note_studenti' -- /*!40000 ALTER TABLE note_studenti DISABLE KEYS */; LOCK TABLES note_studenti WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE note_studenti ENABLE KEYS */; -- -- Table structure for table 'orari' -- DROP TABLE IF EXISTS orari; CREATE TABLE `orari` ( `id` int(11) NOT NULL auto_increment, `idclasse` int(11) NOT NULL default '0', `giorno` enum('1','2','3','4','5','6') NOT NULL default '1', `idmateria1` int(11) NOT NULL default '0', `idmateria2` int(11) NOT NULL default '0', `idmateria3` int(11) NOT NULL default '0', `idmateria4` int(11) NOT NULL default '0', `idmateria5` int(11) NOT NULL default '0', `idmateria6` int(11) NOT NULL default '0', `idmateria7` int(11) NOT NULL default '0', `idmateria8` int(11) NOT NULL default '0', `idmateria9` int(11) NOT NULL default '0', `tipo` enum('D','S') NOT NULL default 'D', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'orari' -- /*!40000 ALTER TABLE orari DISABLE KEYS */; LOCK TABLES orari WRITE; INSERT INTO orari VALUES (1,1,'2',14,9,12,11,13,8,0,0,0,'D'),(3,15,'1',32,32,36,36,30,0,0,0,0,'D'),(4,15,'2',8,6,29,31,31,32,0,17,17,'D'),(5,15,'3',29,29,31,30,30,18,18,0,0,'D'),(6,15,'4',36,32,32,8,8,31,31,6,29,'D'),(7,15,'5',31,31,29,32,32,0,0,0,0,'D'),(92,23,'6',41,41,41,41,41,0,0,0,0,'S'),(12,1,'1',15,8,10,16,16,25,25,18,18,'D'),(13,1,'3',12,11,11,8,6,0,0,0,0,'D'),(14,1,'4',15,12,16,10,10,23,23,39,39,'D'),(15,1,'5',11,9,14,6,13,8,0,0,0,'D'),(16,10,'1',22,22,11,11,0,25,25,18,18,'D'),(17,10,'2',15,20,9,19,6,0,0,0,0,'D'),(18,10,'3',8,6,20,21,0,8,8,0,0,'D'),(19,10,'4',22,22,11,11,15,23,23,0,0,'D'),(20,10,'5',21,19,20,9,8,0,0,0,0,'D'),(21,3,'1',16,16,11,11,10,25,25,18,18,'D'),(22,3,'2',15,14,9,12,6,0,0,0,0,'D'),(23,3,'3',8,6,13,10,10,8,8,0,0,'D'),(24,3,'4',14,16,11,11,15,23,23,39,39,'D'),(25,3,'5',12,12,13,9,8,0,0,0,0,'D'),(26,4,'1',6,27,38,35,35,25,25,18,18,'D'),(27,4,'2',9,10,14,14,8,17,17,0,0,'D'),(28,4,'3',14,35,36,36,6,27,0,0,0,'D'),(29,4,'4',8,8,27,9,38,23,23,39,39,'D'),(30,4,'5',14,14,36,35,10,0,0,0,0,'D'),(31,5,'1',38,10,27,36,8,35,40,18,18,'D'),(32,5,'2',9,8,8,36,14,17,17,0,0,'D'),(33,5,'3',10,14,14,35,35,0,0,0,0,'D'),(34,5,'4',38,27,14,14,6,40,40,23,23,'D'),(35,5,'5',9,36,35,14,14,0,0,0,0,'D'),(36,6,'1',38,10,27,36,8,35,40,18,18,'D'),(37,6,'2',9,8,8,36,14,17,17,0,0,'D'),(38,6,'3',10,14,14,35,35,0,0,0,0,'D'),(39,6,'4',38,27,14,14,6,40,40,23,23,'D'),(40,6,'5',9,36,35,14,14,0,0,0,0,'D'),(41,7,'1',10,35,8,8,38,37,18,18,0,'D'),(42,7,'2',10,9,14,14,37,6,0,17,17,'D'),(43,7,'3',36,36,8,14,14,0,0,0,0,'D'),(44,7,'4',35,35,38,37,9,9,14,14,14,'D'),(45,7,'5',36,14,14,10,6,0,0,0,0,'D'),(46,18,'1',35,14,14,38,37,0,18,18,0,'D'),(47,18,'2',6,14,14,9,35,36,0,17,17,'D'),(48,18,'3',8,10,10,35,36,6,14,14,14,'D'),(49,18,'4',9,14,14,38,36,9,0,0,0,'D'),(50,18,'5',8,8,10,37,37,0,0,0,0,'D'),(51,11,'1',6,31,21,30,19,22,22,25,0,'D'),(52,11,'2',11,11,8,8,26,17,17,0,0,'D'),(53,11,'3',31,31,32,32,27,33,33,26,0,'D'),(54,11,'4',8,6,21,26,19,0,0,0,0,'D'),(55,11,'5',30,32,32,27,11,18,18,0,0,'D'),(56,12,'1',36,8,30,32,32,0,0,0,0,'D'),(57,12,'2',31,31,32,32,11,34,33,33,0,'D'),(58,12,'3',30,30,29,8,8,0,0,0,0,'D'),(59,12,'4',28,36,32,32,32,0,0,0,0,'D'),(60,12,'5',11,6,31,31,29,34,34,18,18,'D'),(61,13,'1',36,8,30,32,32,0,0,0,0,'D'),(62,13,'2',31,31,32,32,11,34,33,33,0,'D'),(63,13,'3',30,30,29,8,8,0,0,0,0,'D'),(64,13,'4',28,36,32,32,32,0,0,0,0,'D'),(65,13,'5',11,6,31,31,29,34,34,18,18,'D'),(66,14,'1',30,30,31,31,36,0,0,0,0,'D'),(67,14,'2',32,32,31,29,6,32,0,17,17,'D'),(68,14,'3',8,8,30,31,31,0,0,0,0,'D'),(69,14,'4',32,32,29,36,36,29,6,31,31,'D'),(70,14,'5',29,29,8,32,32,18,18,0,0,'D'),(71,22,'1',30,30,8,8,11,0,0,0,0,'S'),(72,22,'2',31,31,32,29,36,34,33,33,0,'S'),(73,22,'3',8,6,32,32,32,0,0,0,0,'S'),(74,22,'4',31,31,30,11,11,0,0,0,0,'S'),(75,22,'5',32,32,36,29,28,34,34,0,18,'S'),(76,20,'1',14,14,8,8,35,0,40,25,25,'S'),(77,20,'2',38,10,9,27,36,0,0,0,0,'S'),(78,20,'3',8,6,14,14,14,0,0,0,17,'S'),(79,20,'4',14,14,14,35,35,40,40,23,23,'S'),(80,20,'5',10,9,36,27,38,0,0,0,18,'S'),(81,21,'1',8,8,14,14,14,0,0,0,42,'S'),(82,21,'2',36,38,37,10,10,0,0,0,0,'S'),(83,21,'3',14,14,8,35,9,0,0,42,17,'S'),(84,21,'4',6,37,36,14,14,0,0,0,0,'S'),(85,21,'5',35,35,10,38,36,0,0,42,18,'S'),(86,21,'6',14,14,9,9,0,0,0,0,0,'S'),(87,23,'1',36,36,30,30,8,0,0,0,0,'S'),(88,23,'2',29,29,32,32,32,0,0,0,0,'S'),(89,23,'3',31,31,31,8,8,0,0,0,17,'S'),(90,23,'4',30,6,32,32,32,0,0,0,0,'S'),(91,23,'5',29,29,31,31,31,0,0,0,18,'S'); UNLOCK TABLES; /*!40000 ALTER TABLE orari ENABLE KEYS */; -- -- Table structure for table 'pagelle' -- DROP TABLE IF EXISTS pagelle; CREATE TABLE `pagelle` ( `id` int(11) NOT NULL auto_increment, `tipo` int(11) NOT NULL default '0', `idclasse` int(11) NOT NULL default '0', `idstudente` int(11) NOT NULL default '0', `idmateria` int(11) NOT NULL default '0', `media` double(4,2) NOT NULL default '0.00', `tipo_media` enum('S','O','T') NOT NULL default 'S', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'pagelle' -- /*!40000 ALTER TABLE pagelle DISABLE KEYS */; LOCK TABLES pagelle WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE pagelle ENABLE KEYS */; -- -- Table structure for table 'permessi_extra_segreteria' -- DROP TABLE IF EXISTS permessi_extra_segreteria; CREATE TABLE `permessi_extra_segreteria` ( `id` int(11) NOT NULL auto_increment, `idpersonale` int(11) NOT NULL default '0', `modulo` varchar(255) NOT NULL default '', `sotto_modulo` varchar(255) NOT NULL default '', `sezione` varchar(255) NOT NULL default 'admin', `area` varchar(255) NOT NULL default 'segreteria', `full_access` enum('Y','N') NOT NULL default 'N', `limited_access` enum('Y','N') NOT NULL default 'N', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'permessi_extra_segreteria' -- /*!40000 ALTER TABLE permessi_extra_segreteria DISABLE KEYS */; LOCK TABLES permessi_extra_segreteria WRITE; INSERT INTO permessi_extra_segreteria VALUES (1,42,'ALL','ALL','ALL','ALL','Y','Y'),(6,15,'ALL','ALL','ALL','ALL','Y','Y'),(7,16,'ALL','ALL','ALL','ALL','N','Y'); UNLOCK TABLES; /*!40000 ALTER TABLE permessi_extra_segreteria ENABLE KEYS */; -- -- Table structure for table 'personale' -- DROP TABLE IF EXISTS personale; CREATE TABLE `personale` ( `id` int(11) NOT NULL auto_increment, `codicefiscale` varchar(16) NOT NULL default '', `cognome` varchar(32) NOT NULL default '', `nome` varchar(32) NOT NULL default '', `nato_a` varchar(32) NOT NULL default '', `nato_il` date NOT NULL default '0000-00-00', `residenza` varchar(32) NOT NULL default '', `via` varchar(64) NOT NULL default '', `cap` varchar(5) NOT NULL default '', `tel1` varchar(20) NOT NULL default '', `cell` varchar(20) NOT NULL default '', `cittadinanza` varchar(32) NOT NULL default '', `laurea` text, `laurea_anno` varchar(4) NOT NULL default '0000', `abilitazione` enum('Y','N') NOT NULL default 'N', `laurea_voto` varchar(16) NOT NULL default '0', `classe_concorso` text, `anno_scol_contratto` varchar(16) NOT NULL default '0000/0000', `ore_settimanali` int(11) NOT NULL default '0', `decorrenza_assunzione` date NOT NULL default '0000-00-00', `scadenza_assunzione` date NOT NULL default '0000-00-00', `quota_oraria` double(4,2) NOT NULL default '0.00', `altri_incarichi` text, `tipo` enum('D','P') NOT NULL default 'P', `note` text, `idincarico` int(11) NOT NULL default '0', `idcontratto` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'personale' -- /*!40000 ALTER TABLE personale DISABLE KEYS */; LOCK TABLES personale WRITE; INSERT INTO personale VALUES (15,'','VILLA','DAVIDE','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','P','',6,0),(16,'','TRAPANI','TERESA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','P','',4,0),(17,'','BERTOCCHI','CLAUDIA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','P','',4,0),(6,'MNGFNC60R10D550G','MANGLAVITI','FRANCESCO','FERRAZZANO (CB)','1960-10-10','TORINO','VIA FRONT 20','10100','','3386919128','Italiana','LAUREA SCIENZE AGRARIE','1996','N','','','2002/03',7,'2002-09-09','2003-07-15',13.00,'','D','',0,2),(7,'','PAGNONE','ANDREA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(8,'','PANTUSA','SALVATORE','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(9,'','DE GREGORI','ROBERTO','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(10,'','MAGGI','DANIELA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(11,'','BOTRUGNO','MICHELE','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(12,'','CORRA\'','PAOLO','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(13,'','BALMA','CRISTINA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(14,'','PICICHE\'','BARTOLOMEO','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(18,'','SANZO','MARIA ELISABETTA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(19,'','AUTORINO','CLAUDIA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,2),(20,'','MARCHISIO','GIULIANA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(21,'','GEUNA','LORETTA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(22,'','GARNERO','FRANCO','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(23,'','GIOVANNINI','PATRIZIA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(24,'','POMPIGNA','GIOVANNI','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,3),(25,'','GRIFFA','ALESSANDRA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(26,'','CAPRIOGLIO','ESTER','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(27,'','MUSCAT','CHRISTOPHER','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,2),(28,'','BRAUNECKER','PAULETTE LYDIE','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,2),(29,'','CLERICI','PATRIZIA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,2),(30,'','DE FILIPPO','FRANCO','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,2),(31,'','MANFREDI','CINZIA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(32,'','PISTOCCHI','STEFANIA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(33,'','CORTESE','FILIPPO','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(34,'','SALMI','AZELIO','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,2),(35,'','BARTOLOMEI','CLAUDIA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,2),(36,'','LISI','MARIA ERSILIA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,2),(37,'','FANELLI','MICHELE','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,1),(38,'','CASTROREALE','VALTER','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,2),(39,'','POPPA','COSIMO','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,2),(40,'','ANGELINO','SILVIA','','0000-00-00','','','','','','Italiana','','','N','0','','',0,'0000-00-00','0000-00-00',0.00,'','D','.',3,1),(41,'','ARENA','CLAUDIA','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','D','',0,2),(42,'CODICEFISCALEXXX','ADMIN','ADMIN','','0000-00-00','','','','','','Italiana','','','N','','','',0,'0000-00-00','0000-00-00',0.00,'','P','NON CANCELLARE',7,0); UNLOCK TABLES; /*!40000 ALTER TABLE personale ENABLE KEYS */; -- -- Table structure for table 'promozioni_bocciature' -- DROP TABLE IF EXISTS promozioni_bocciature; CREATE TABLE `promozioni_bocciature` ( `id` int(11) NOT NULL auto_increment, `tipo` enum('P','B') NOT NULL default 'B', `idstudente` int(11) NOT NULL default '0', `idclasse` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'promozioni_bocciature' -- /*!40000 ALTER TABLE promozioni_bocciature DISABLE KEYS */; LOCK TABLES promozioni_bocciature WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE promozioni_bocciature ENABLE KEYS */; -- -- Table structure for table 'sessioni' -- DROP TABLE IF EXISTS sessioni; CREATE TABLE `sessioni` ( `id` int(11) NOT NULL auto_increment, `sessione` varchar(20) NOT NULL default '', `last_ack` datetime NOT NULL default '0000-00-00 00:00:00', `idutente` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'sessioni' -- /*!40000 ALTER TABLE sessioni DISABLE KEYS */; LOCK TABLES sessioni WRITE; INSERT INTO sessioni VALUES (11,'5400604497278053828','2009-02-20 16:29:28',12); UNLOCK TABLES; /*!40000 ALTER TABLE sessioni ENABLE KEYS */; -- -- Table structure for table 'studenti' -- DROP TABLE IF EXISTS studenti; CREATE TABLE `studenti` ( `id` int(11) NOT NULL auto_increment, `codicefiscale` varchar(16) NOT NULL default '', `idgenitore` int(11) NOT NULL default '0', `cognome` varchar(32) NOT NULL default '', `nome` varchar(32) NOT NULL default '', `nato_a` varchar(32) NOT NULL default '', `nato_il` date NOT NULL default '0000-00-00', `cittadinanza` varchar(32) NOT NULL default '', `residenza` varchar(32) NOT NULL default '', `residenza_via` varchar(32) NOT NULL default '', `residenza_cap` varchar(5) NOT NULL default '', `domicilio` varchar(32) NOT NULL default '', `domicilio_via` varchar(32) NOT NULL default '', `domicilio_cap` varchar(5) NOT NULL default '', `titolo_studio` varchar(64) NOT NULL default '', `ts_conseguito_nel` varchar(9) NOT NULL default '0000/0000', `ts_presso` varchar(64) NOT NULL default '', `lingue_straniere` text, `vaccinazione` enum('Y','N') NOT NULL default 'N', `padre` varchar(64) NOT NULL default '', `madre` varchar(64) NOT NULL default '', `sorelle` text, `fratelli` text, `corso` varchar(32) NOT NULL default '', `volta` int(11) default '1', `licenza_media` varchar(7) NOT NULL default '0000/00', `curriculum_superiori` text, PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'studenti' -- /*!40000 ALTER TABLE studenti DISABLE KEYS */; LOCK TABLES studenti WRITE; INSERT INTO studenti VALUES (1,'',72,'PELLEGRINO','DARIO','TORINO','1984-11-21','Italiana','TRANA','VIA G. BRUNO 24','10090','','','','IDONEITA\' V GEOMETRI','2002/2003','NS. ISTITUTO','________________','Y','________________','BUCHMANN ANGELIKA','________________','PELLEGRINO MARCO','',0,'0000/00','________________\r\n________________'),(2,'MBTLSS85B25L727E',73,'AIMO BOOT','ALESSIO','VENARIA (TO)','1985-02-25','Italiana','VENARIA (TO)','VIA CARDUCCI 6','10078','','','','IDONEITA\' V GEOMETRI','2002/2003','NS. ISTITUTO','________________','Y','________________','MORGANA MARIA','________________','________________','',0,'0000/00','________________\r\n________________'),(3,'RTOMRC83L11L219V',75,'ORTO','MARCO','TORINO','1983-07-11','Italiana','TORINO','VIA R. ZANDONAI 19','10100','','','','IDONEITA\' V GEOMETRI','2002/2003','NS. ISTITUTO','________________','Y','ORTO GIUSEPPE','PROCACCIANTI MARIA','________________','ORTO MARIO E ORTO EMANUELE','',0,'0000/00','________________\r\n________________'),(4,'LVRLSN83L18L219X',76,'OLIVIERI','ALESSANDRO','TORINO','1983-07-18','Italiana','TORINO','VIA MORETTA 64','10100','','','','IDONEITA\' V GEOMETRI','2002/2003','NS. ISTITUTO','________________','Y','OLIVIERI GIACINTO','FORLAI DANIELA','________________','________________','',0,'0000/00','________________\r\n________________'),(5,'CRSMTT85E30L219Y',77,'CAROSSO','MATTEO','TORINO','1985-05-30','Italiana','TORINO','VIA CRISTALLIERA 19','10100','','','','IDONEITA\' V GEOMETRI','2002/2003','NS. ISTITUTO','________________','Y','CAROSSO ROBERTO','MITOLI OTTAVIA','________________','________________','',0,'0000/00','________________\r\n________________'),(6,'',78,'PERINO','ELISA','TORINO','1984-07-26','Italiana','CASELLE (TO)','VIA C. COLOMBO 4/7','10072','','','','IDONEITA\' V GEOMETRI','2002/2003','NS. ISTITUTO','________________','Y','PERINO MARCO','CAVALLARO TERESA','PERINO ALESSANDRA','________________','',0,'0000/00','________________\r\n________________'),(7,'',79,'DONNET','ALESSANDRO','TORINO','1984-04-24','Italiana','TORINO','C.SO G. FERRARIS 138 BIS','10100','','','','IDONEITA\' V GEOMETRI','2002/2003','NS. ISTITUTO','________________','Y','________________','________________','________________','________________','',0,'0000/00','________________\r\n________________'); UNLOCK TABLES; /*!40000 ALTER TABLE studenti ENABLE KEYS */; -- -- Table structure for table 'supplenze' -- DROP TABLE IF EXISTS supplenze; CREATE TABLE `supplenze` ( `id` int(11) NOT NULL auto_increment, `idassente` int(11) NOT NULL default '0', `idsupplente` int(11) NOT NULL default '0', `dal` datetime NOT NULL default '0000-00-00 00:00:00', `al` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'supplenze' -- /*!40000 ALTER TABLE supplenze DISABLE KEYS */; LOCK TABLES supplenze WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE supplenze ENABLE KEYS */; -- -- Table structure for table 'tipo_pagelle' -- DROP TABLE IF EXISTS tipo_pagelle; CREATE TABLE `tipo_pagelle` ( `id` int(11) NOT NULL auto_increment, `tipo` varchar(32) NOT NULL default '', `data` date NOT NULL default '0000-00-00', `decide_promozione` enum('Y','N') NOT NULL default 'N', `dal` date NOT NULL default '0000-00-00', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'tipo_pagelle' -- /*!40000 ALTER TABLE tipo_pagelle DISABLE KEYS */; LOCK TABLES tipo_pagelle WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tipo_pagelle ENABLE KEYS */; -- -- Table structure for table 'tipologie_rate' -- DROP TABLE IF EXISTS tipologie_rate; CREATE TABLE `tipologie_rate` ( `id` int(11) NOT NULL auto_increment, `titolo` varchar(64) NOT NULL default '', `rata1` varchar(128) NOT NULL default '', `rata2` varchar(128) NOT NULL default '', `rata3` varchar(128) NOT NULL default '', `rata4` varchar(128) NOT NULL default '', `rata5` varchar(128) NOT NULL default '', `rata6` varchar(128) NOT NULL default '', `rata7` varchar(128) NOT NULL default '', `rata8` varchar(128) NOT NULL default '', `rata9` varchar(128) NOT NULL default '', `rata10` varchar(128) NOT NULL default '', `rata11` varchar(128) NOT NULL default '', `rata12` varchar(128) NOT NULL default '', `data_rata1` date NOT NULL default '0000-00-00', `data_rata2` date NOT NULL default '0000-00-00', `data_rata3` date NOT NULL default '0000-00-00', `data_rata4` date NOT NULL default '0000-00-00', `data_rata5` date NOT NULL default '0000-00-00', `data_rata6` date NOT NULL default '0000-00-00', `data_rata7` date NOT NULL default '0000-00-00', `data_rata8` date NOT NULL default '0000-00-00', `data_rata9` date NOT NULL default '0000-00-00', `data_rata10` date NOT NULL default '0000-00-00', `data_rata11` date NOT NULL default '0000-00-00', `data_rata12` date NOT NULL default '0000-00-00', `importo_rata1` double(4,2) NOT NULL default '0.00', `importo_rata2` double(4,2) NOT NULL default '0.00', `importo_rata3` double(4,2) NOT NULL default '0.00', `importo_rata4` double(4,2) NOT NULL default '0.00', `importo_rata5` double(4,2) NOT NULL default '0.00', `importo_rata6` double(4,2) NOT NULL default '0.00', `importo_rata7` double(4,2) NOT NULL default '0.00', `importo_rata8` double(4,2) NOT NULL default '0.00', `importo_rata9` double(4,2) NOT NULL default '0.00', `importo_rata10` double(4,2) NOT NULL default '0.00', `importo_rata11` double(4,2) NOT NULL default '0.00', `importo_rata12` double(4,2) NOT NULL default '0.00', `rata_anticipata` double(4,2) NOT NULL default '0.00', `costo_esame` double(4,2) NOT NULL default '0.00', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'tipologie_rate' -- /*!40000 ALTER TABLE tipologie_rate DISABLE KEYS */; LOCK TABLES tipologie_rate WRITE; INSERT INTO tipologie_rate VALUES (1,'RATE SENZA IMPORTI','SETTEMBRE','OTTOBRE','NOVEMBRE','DICEMBRE','GENNAIO','FEBBRAIO','MARZO','APRILE','MAGGIO','','','','2003-09-15','2003-10-05','2003-11-05','2003-12-05','2004-01-05','2004-02-05','2004-03-05','2004-04-05','2004-05-05','0000-00-00','0000-00-00','0000-00-00',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00),(2,'CLASSI QUINTE','SETTEMBRE','OTTOBRE','NOVEMBRE','DICEMBRE','GENNAIO','FEBBRAIO','MARZO','APRILE','MAGGIO','','','','2003-09-15','2003-10-05','2003-11-05','2003-12-05','2004-01-05','2004-02-05','2004-03-05','2004-04-05','2004-05-05','0000-00-00','0000-00-00','0000-00-00',400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,0.00,0.00,0.00,400.00,400.00),(3,'CLASSI QUARTE','SETTEMBRE','OTTOBRE','NOVEMBRE','DICEMBRE','GENNAIO','FEBBRAIO','MARZO','APRILE','MAGGIO','','','','2003-09-15','2003-10-05','2003-11-05','2003-12-05','2004-01-05','2004-02-05','2004-03-05','2004-04-05','2004-05-05','0000-00-00','0000-00-00','0000-00-00',350.00,350.00,350.00,350.00,350.00,350.00,350.00,350.00,350.00,0.00,0.00,0.00,400.00,0.00),(4,'CLASSI TERZE','SETTEMBRE','OTTOBRE','NOVEMBRE','DICEMBRE','GENNAIO','FEBBRAIO','MARZO','APRILE','MAGGIO','','','','2003-09-15','2003-10-05','2003-11-05','2003-12-05','2004-01-05','2004-02-05','2004-03-05','2004-04-05','2004-05-05','0000-00-00','0000-00-00','0000-00-00',320.00,320.00,320.00,320.00,320.00,320.00,320.00,320.00,320.00,0.00,0.00,0.00,400.00,0.00),(5,'QUINTE SERALI','SETTEMBRE','OTTOBRE','NOVEMBRE','DICEMBRE','GENNAIO','FEBBRAIO','MARZO','APRILE','MAGGIO','','','','2003-09-15','2003-10-05','2003-11-05','2003-12-05','2004-01-05','2004-02-05','2004-03-05','2004-04-05','2004-05-05','0000-00-00','0000-00-00','0000-00-00',300.00,300.00,300.00,300.00,300.00,300.00,300.00,300.00,300.00,0.00,0.00,0.00,400.00,400.00),(6,'CLASSI SECONDE','SETTEMBRE','OTTOBRE','NOVEMBRE','DICEMBRE','GENNAIO','FEBBRAIO','MARZO','APRILE','MAGGIO','','','','2003-09-15','2003-10-05','2003-11-05','2003-12-05','2004-01-05','2004-02-05','2004-03-05','2004-04-05','2004-05-05','0000-00-00','0000-00-00','0000-00-00',270.00,270.00,270.00,270.00,270.00,270.00,270.00,270.00,270.00,0.00,0.00,0.00,400.00,0.00),(7,'CLASSI PRIME','SETTEMBRE','OTTOBRE','NOVEMBRE','DICEMBRE','GENNAIO','FEBBRAIO','MARZO','APRILE','MAGGIO','','','','2003-09-15','2003-10-05','2003-11-05','2003-12-05','2004-01-05','2004-02-05','2004-03-05','2004-04-05','2004-05-05','0000-00-00','0000-00-00','0000-00-00',250.00,250.00,250.00,250.00,250.00,250.00,250.00,250.00,250.00,0.00,0.00,0.00,400.00,0.00),(8,'JUVENTUS','SETTEMBRE','OTTOBRE','NOVEMBRE','DICEMBRE','GENNAIO','FEBBRAIO','MARZO','APRILE','MAGGIO','','','','2002-09-15','2002-10-05','2002-11-05','2002-12-05','2003-01-05','2003-02-05','2003-03-05','2003-04-05','2003-05-05','0000-00-00','0000-00-00','0000-00-00',330.00,330.00,330.00,330.00,330.00,330.00,330.00,330.00,330.00,0.00,0.00,0.00,330.00,0.00); UNLOCK TABLES; /*!40000 ALTER TABLE tipologie_rate ENABLE KEYS */; -- -- Table structure for table 'uscite_studenti' -- DROP TABLE IF EXISTS uscite_studenti; CREATE TABLE `uscite_studenti` ( `id` int(11) NOT NULL auto_increment, `ora` int(11) NOT NULL default '0', `giorno` date NOT NULL default '0000-00-00', `motivo` varchar(255) default '', `idstudente` int(11) NOT NULL default '0', `idclasse` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'uscite_studenti' -- /*!40000 ALTER TABLE uscite_studenti DISABLE KEYS */; LOCK TABLES uscite_studenti WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE uscite_studenti ENABLE KEYS */; -- -- Table structure for table 'utenti' -- DROP TABLE IF EXISTS utenti; CREATE TABLE `utenti` ( `id` int(11) NOT NULL auto_increment, `tipo` enum('Se','St','Do','Ge') NOT NULL default 'St', `user` varchar(15) NOT NULL default '', `password` varchar(15) NOT NULL default '', `idspecifico` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'utenti' -- /*!40000 ALTER TABLE utenti DISABLE KEYS */; LOCK TABLES utenti WRITE; INSERT INTO utenti VALUES (2,'Do','ANGELINO','NGLSLV3184',40),(3,'Do','PANTUSA','PNTSVT6484',8),(4,'Do','DEGREGORI','DGRRRT7884',9),(5,'Do','BOTRUGNO','BTRMHL7784',11),(6,'Do','AUTORINO','TRNCLD3985',19),(7,'Do','BALMA','BLMSRN2185',13),(8,'Do','PICICHE','PCCBTL2085',14),(9,'Do','MAGGI','MGGDNL1884',10),(10,'Do','CORRA','CRRPLA1784',12),(11,'Do','PAGNONE','PGNNDR1184',7),(12,'Se','DAVIDE','ROBADEMAT',15),(13,'Se','TERESA','FORZAINTER',16),(14,'Ge','BUCHMANN','5970966323',72),(15,'Ge','MORGANA','2468696542',73),(16,'Ge','_______________','6938066816',74),(17,'Ge','ORTO','4959383059',75),(18,'Ge','OLIVIERI','6013031685',76),(19,'Ge','CAROSSO','8338837383',77),(20,'Ge','PERINO','478427610',78),(21,'Ge','SIDDI','4939517010',79); UNLOCK TABLES; /*!40000 ALTER TABLE utenti ENABLE KEYS */; -- -- Table structure for table 'voti_studenti' -- DROP TABLE IF EXISTS voti_studenti; CREATE TABLE `voti_studenti` ( `id` int(11) NOT NULL auto_increment, `voto` double(4,2) NOT NULL default '0.00', `data` date NOT NULL default '0000-00-00', `note` text, `idmateria` int(11) NOT NULL default '0', `idclasse` int(11) NOT NULL default '0', `idstudente` int(11) NOT NULL default '0', `tipo` enum('S','O','T') NOT NULL default 'S', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table 'voti_studenti' -- /*!40000 ALTER TABLE voti_studenti DISABLE KEYS */; LOCK TABLES voti_studenti WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE voti_studenti ENABLE KEYS */;