# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.6.38)
# Database: eliminacode-iom-produzione
# Generation Time: 2020-09-02 09:38:17 +0000
# ************************************************************




# Dump of table ec_accettazione
# ------------------------------------------------------------


CREATE TABLE `ec_accettazione` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_totem` int(11) NOT NULL,
  `id_prenotazione` int(11) NOT NULL,
  `id_operatore` int(11) NOT NULL,
  `id_prestazione` int(11) DEFAULT NULL,
  `id_modalita` int(11) NOT NULL,
  `id_servizio` int(11) DEFAULT NULL,
  `id_medico` int(11) DEFAULT NULL,
  `id_agenda` int(11) DEFAULT NULL,
  `data_inserimento` date NOT NULL,
  `ora_accettazione` time NOT NULL,
  `nome_paziente` varchar(45) NOT NULL,
  `data_nascita` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `ec_accettazione` (`id`, `id_totem`, `id_prenotazione`, `id_operatore`, `id_prestazione`, `id_modalita`, `id_servizio`, `id_medico`, `id_agenda`, `data_inserimento`, `ora_accettazione`, `nome_paziente`, `data_nascita`)
VALUES
	(1,1,31,1,1,1,6400,145,145,'2020-06-22','10:36:47','CAMILLERI GRAZIELLA','2020-06-16'),
	(2,1,166,1,2,1,6400,166,166,'2020-06-22','10:37:10','un paziente','2020-06-29'),
	(3,2,33,1,3,1,6400,145,145,'2020-06-22','10:38:12','SCUDERI ANGELA','2020-06-16'),
	(4,3,36,1,4,1,6400,145,145,'2020-06-22','10:39:01','REITANO CONCETTA','1939-08-05'),
	(5,6,6,1,1,2,0,0,NULL,'2020-06-22','10:50:53','GIORDANO SIMONETTA','1968-05-27'),
	(6,7,9,1,2,2,0,0,NULL,'2020-06-22','10:55:17','MARLETTA ANNA','1958-09-25'),
	(7,8,12,1,3,2,0,0,NULL,'2020-06-22','11:01:21','un paziente',NULL),
	(8,9,5,1,4,2,0,0,NULL,'2020-06-22','11:03:30','AURNIA GIOVANNA','1980-08-01'),
	(9,4,37,1,5,1,6400,145,145,'2020-06-22','11:21:26','LO IACONO ANGELO','2020-06-16'),
	(10,5,168,1,6,1,68,701,701,'2020-06-22','11:24:19','un paziente','2020-06-16'),
	(11,13,170,1,7,1,6400,145,145,'2020-06-22','11:26:12','un paziente','2020-06-30'),
	(12,14,120,1,8,1,68,701,701,'2020-06-22','11:27:48','FONTANABIANCA AGATA MARIA','1965-02-05'),
	(13,15,119,1,9,1,68,701,701,'2020-06-22','11:28:29','NICOTRA ALFIO','1966-04-20'),
	(14,15,34,1,10,1,6400,145,145,'2020-06-22','11:29:12','SCALZO CAMILLA','1936-01-31'),
	(15,15,108,1,11,1,6411,346,346,'2020-06-22','11:30:29','.','2020-06-16'),
	(16,11,64,0,1,3,2,0,201,'2020-06-22','11:49:13','SCIUTO GIUSEPPE','1961-04-08'),
	(17,12,63,0,2,3,2,0,201,'2020-06-22','11:50:49','FERRARA PIETRO','1952-06-02'),
	(18,18,69,0,3,3,2,0,202,'2020-06-22','11:52:53','GRIMALDI MARIA','1951-01-10'),
	(19,10,1,1,5,2,0,0,NULL,'2020-06-22','12:05:07','GAMUZZA LORENZO','1954-01-02'),
	(20,16,113,1,12,1,64,351,641,'2020-06-22','12:12:57','NOUN KHADIJA','1975-02-21'),
	(21,17,123,1,13,1,6401,351,1005,'2020-06-22','12:25:47','CANNIZZARO ANNA MARIA SANTA','1956-11-01'),
	(22,17,106,1,14,1,58,333,333,'2020-06-22','12:29:06','DI GIUNTA GIOVANNI','2020-06-16'),
	(23,23,137,1,15,1,0,351,1021,'2020-06-22','12:30:21','VISICARO CRISTINA','1976-07-24'),
	(24,23,142,1,16,1,0,351,1022,'2020-06-22','12:30:41','CANNIZZARO ANNA MARIA','2020-06-16'),
	(25,24,121,1,17,1,6401,386,1005,'2020-06-22','12:33:47','DI GREGORIO NATALINA','1959-12-23');



# Dump of table ec_agenda_servizi_giornaliera
# ------------------------------------------------------------


CREATE TABLE `ec_agenda_servizi_giornaliera` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_agenda_HTSAN` int(11) NOT NULL,
  `nome_agenda` varchar(45) DEFAULT NULL,
  `id_medico` int(11) DEFAULT NULL,
  `nome_medico` varchar(35) DEFAULT NULL,
  `id_servizio` int(11) DEFAULT NULL,
  `nome_servizio` varchar(35) DEFAULT NULL,
  `id_modalita` int(11) DEFAULT NULL,
  `data` date DEFAULT NULL,
  `ora_inizio` time DEFAULT NULL,
  `ora_fine` time DEFAULT NULL,
  `prenotati` int(2) DEFAULT NULL,
  `liberi` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `ec_agenda_servizi_giornaliera` (`id`, `id_agenda_HTSAN`, `nome_agenda`, `id_medico`, `nome_medico`, `id_servizio`, `nome_servizio`, `id_modalita`, `data`, `ora_inizio`, `ora_fine`, `prenotati`, `liberi`)
VALUES
	(1,7,'PAC DIAGNOSTICI D.I.',131,'CALTAVUTURO CLAUDIA',65,'TAC',1,'2020-06-22','10:00:00','12:00:00',NULL,NULL),
	(2,8,'PAC DIAGNOSTICO 2',116,'SIGNORELLI MARIO',63,'ECOGRAFIA',1,'2020-06-22','11:30:00','12:50:00',NULL,NULL),
	(3,35,'ONCOEMATOLOGIA PRIVATO',345,'SCIRE\' PAOLA',6404,'ONCOEMATOLOGIA',1,'2020-06-22','14:00:00','15:40:00',NULL,NULL),
	(4,76,'CHIRURGO SENOLOGO',783,'FISICHELLA GIACOMO',6411,'BREAST UNIT',1,'2020-06-22','00:00:00','00:00:00',NULL,NULL),
	(5,79,'INFILTRAZIONI',801,'MANFRE\' LUIGI',30,'NEUROCHIRURGIA',1,'2020-06-22','14:00:00','16:00:00',NULL,NULL),
	(6,81,'CRIOABLAZIONI',801,'MANFRE\' LUIGI',30,'NEUROCHIRURGIA',1,'2020-06-22','13:00:00','15:00:00',NULL,NULL),
	(7,89,'COLONSCOPIE VIRTUALI',27,'SCALIA ROSARIO',65,'TAC',1,'2020-06-22','09:00:00','10:00:00',NULL,NULL),
	(8,100,'DOTT.SSA GORGONE',53,'GORGONE SANTINA CRISTINA',6411,'BREAST UNIT',1,'2020-06-22','14:00:00','19:15:00',NULL,NULL),
	(9,107,'AMB 2 ONCOEMATOLOGIA',107,'AMATO GABRIELLA',6404,'ONCOEMATOLOGIA',1,'2020-06-22','11:00:00','13:00:00',NULL,NULL),
	(10,144,'AMB ENDOCRINOLOGIA',145,'GIUFFRIDA DARIO',0,'',1,'2020-06-22','14:50:00','18:30:00',NULL,NULL),
	(11,145,'AMB PRIMARIO ONCOLOGIA',145,'GIUFFRIDA DARIO',6400,'ONCOLOGIA MEDICA',1,'2020-06-22','14:20:00','19:00:00',NULL,NULL),
	(12,161,'Dermatologia',780,'GURGONE SILVIA',75,'DERMATOLOGIA',1,'2020-06-22','09:00:00','12:15:00',NULL,NULL),
	(13,166,'AMB ONCOLOGIA',166,'BLANCO GIUSI',6400,'ONCOLOGIA MEDICA',1,'2020-06-22','15:00:00','17:00:00',NULL,NULL),
	(14,201,'DH TERAPIA INF. LUNGA',0,'',2,'DAY HOSPITAL',3,'2020-06-22','07:30:00','08:00:00',NULL,NULL),
	(15,202,'DH TERAPIA INF. MEDIA',0,'',2,'DAY HOSPITAL',3,'2020-06-22','07:30:00','08:30:00',NULL,NULL),
	(16,203,'DH TERAPIA INF. BREVE',0,'',2,'DAY HOSPITAL',3,'2020-06-22','07:30:00','09:10:00',NULL,NULL),
	(17,333,'COSENTINO SALVATORE',333,'COSENTINO SALVATORE',58,'ENDOSCOPIA',1,'2020-06-22','10:00:00','11:30:00',NULL,NULL),
	(18,346,'AMB 1 SENOLOGIA',346,'CICALA SALVATORE',6411,'BREAST UNIT',1,'2020-06-22','16:00:00','17:00:00',NULL,NULL),
	(19,641,'AMB ONCOLOGIA',0,'',64,'ONCOLOGIA AMBUL.',1,'2020-06-22','11:00:00','13:30:00',NULL,NULL),
	(20,701,'COPPOLINO SINIBALDO',701,'COPPOLINO SINIBALDO',68,'PNEUMOLOGIA',1,'2020-06-22','15:00:00','17:00:00',NULL,NULL),
	(21,801,'VISITE NEURORADIOLOGIA',801,'MANFRE\' LUIGI',30,'NEUROCHIRURGIA',1,'2020-06-22','14:00:00','15:00:00',NULL,NULL),
	(22,1005,'PRERICOVERI GINECOLOGIA',0,'',6401,'CHIRURGIA ONCOLOGICA',1,'2020-06-22','09:40:00','11:00:00',NULL,NULL),
	(23,1007,'pre-ricoveri chir. oncologica',785,'GIANNONE GIORGIO',0,'',1,'2020-06-22','08:00:00','11:00:00',NULL,NULL),
	(24,1009,'pre ricovero interv.spinale',801,'MANFRE\' LUIGI',6901,'RADIOLOGIA INTERVENTISTICA',1,'2020-06-22','10:00:00','11:20:00',NULL,NULL),
	(25,1020,'TAMPONI AREA MEDICA',0,'',0,'',1,'2020-06-22','08:00:00','10:00:00',NULL,NULL),
	(26,1021,'TAMPONI AREA CHIRURGICA',0,'',0,'',1,'2020-06-22','08:00:00','09:20:00',NULL,NULL),
	(27,1022,'TAMPONI DAY SURGERY',0,'',0,'',1,'2020-06-22','08:00:00','08:15:00',NULL,NULL),
	(28,1023,'TAMPONI DAYSERVICE ONCOLOGICO',0,'',0,'',1,'2020-06-22','08:00:00','10:00:00',NULL,NULL);



# Dump of table ec_agende
# ------------------------------------------------------------


CREATE TABLE `ec_agende` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_agenda_HTSAN` int(11) NOT NULL,
  `nome_agenda` varchar(45) DEFAULT NULL,
  `id_servizio` int(11) DEFAULT NULL,
  `nome_servizio` varchar(45) DEFAULT NULL,
  `id_medico` int(11) DEFAULT NULL,
  `nome_medico` varchar(45) DEFAULT NULL,
  `tipo` varchar(16) DEFAULT NULL,
  `id_modalita` int(11) NOT NULL,
  `stato` int(3) DEFAULT NULL,
  `attiva_da` date DEFAULT NULL,
  `attiva_fino_a` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `ec_agende` (`id`, `id_agenda_HTSAN`, `nome_agenda`, `id_servizio`, `nome_servizio`, `id_medico`, `nome_medico`, `tipo`, `id_modalita`, `stato`, `attiva_da`, `attiva_fino_a`)
VALUES
	(1,173,'AGENDA DOTT.SA SCRIMINACI',0,'PSICOLOGIA',173,'SCRIMINACI MARIA CARMELA','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(2,58,'AMATO GABRIELLA',0,'ONCOEMATOLOGIA',107,'AMATO GABRIELLA','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(3,430,'AMBULATORIO UROLOGIA',0,'UROLOGIA',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(4,186,'ARRIGO ETTORE',0,'CHIRURGIA ONCOLOGICA AMB.',186,'ARRIGO ETTORE','',0,1,'2014-05-13','0000-00-00'),
	(5,166,'BLANCO GIUSY',0,'ONCOLOGIA MEDICA',166,'BLANCO GIUSI','',0,1,'2014-05-13','0000-00-00'),
	(6,131,'CALTAVUTURO (TAC/RX ESTERNI)',65,'TAC',131,'CALTAVUTURO CLAUDIA','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(7,2,'CARDIOLOGIA AMBULATORIALE',8,'CARDIOLOGIA',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(8,42,'CH.ONCOLOGICA PRIV. DR.FULLONE',0,'CHIRURGIA ONCOLOGICA',111,'FULLONE FRANCESCO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(9,43,'CH.ONCOLOGICA PRIV.DR.SALLUZZO',0,'CHIRURGIA ONCOLOGICA',112,'SALLUZZO SALVATORE','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(10,41,'CH.TORACICA DR.ARRIGO PRIVATO',0,'CHIRURGIA TORACICA',186,'ARRIGO ETTORE','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(11,28,'CHIR.ONCOLOGICA MEDICAZIONI',0,'CHIRURGIA ONCOLOGICA',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(12,27,'CHIR.PLAST. MEDICAZIONI',0,'CHIRURGIA ONCOLOGICA',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(13,16,'CHIRURGIA ONCOLOGICA',0,'CHIRURGIA ONCOLOGICA',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(14,6401,'CHIRURGIA ONCOLOGICA',0,'CHIRURGIA ONCOLOGICA',109,'IUPPA ANTONIO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(15,5,'CHIRURGIA TORACICA',0,'CHIRURGIA TORACICA',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(16,15,'CHIRURGIA TORACICA',0,'CHIRURGIA TORACICA',186,'ARRIGO ETTORE','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(17,346,'CICALA SALVATORE',0,'CHIRURGIA ONCOLOGICA AMB.',346,'CICALA SALVATORE','',0,1,'2014-05-13','0000-00-00'),
	(18,701,'COPPOLINO SINIBALDO',68,'PNEUMOLOGIA',701,'COPPOLINO SINIBALDO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(19,333,'COSENTINO SALVATORE',58,'ENDOSCOPIA',333,'COSENTINO SALVATORE','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(20,3,'CRINO\'',0,'AMBULATORI',3,'CRINO\' LUCIO','',0,1,'2014-05-13','0000-00-00'),
	(21,25,'CURE PALLIATIVE',0,'CURE PALLIATIVE',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(22,34,'CURE PALLIATIVE PRIVATO',0,'CURE PALLIATIVE',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(23,203,'DH TERAPIA INF. BREVE',2,'DAY HOSPITAL',0,'','RICOVERI',2,1,'2014-05-13','0000-00-00'),
	(24,201,'DH TERAPIA INF. LUNGA',2,'DAY HOSPITAL',0,'','RICOVERI',2,1,'2014-05-13','0000-00-00'),
	(25,202,'DH TERAPIA INF. MEDIA',2,'DAY HOSPITAL',0,'','RICOVERI',2,1,'2014-05-13','0000-00-00'),
	(26,369,'DI MAURO SEBASTIANO',75,'DERMATOLOGIA',369,'DI MAURO SEBASTIANO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(27,1,'DIAG.IMM. AMBULATORIALE',0,'',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(28,10,'DIETOLOGIA',0,'',0,'SCARFIA ALESSIA GIUSEPPINA','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(29,12,'EMATOLOGIA',0,'ONCOEMATOLOGIA',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(30,40,'EMATOLOGIA PRIV.DR.SSA SCIRE\'',0,'ONCOEMATOLOGIA',345,'SCIRE\' PAOLA','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(31,33,'ENDOCRINOCHIRURGIA DR.IPPOLITO',0,'CHIRURGIA ONCOLOGICA',398,'IPPOLITO ORAZIO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(32,24,'ENDOCRINOCHIRURGIA MEDICAZIONI',0,'CHIRURGIA ONCOLOGICA',398,'IPPOLITO ORAZIO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(33,366,'FALCONE LORENZO',0,'UROLOGIA',366,'FALCONE LORENZO','',0,1,'2014-05-13','0000-00-00'),
	(34,30,'FISIOTERAPIA',0,'',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(35,111,'FULLONE FRANCESCO',0,'CHIRURGIA ONCOLOGICA',111,'FULLONE FRANCESCO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(36,13,'GINECOLOGIA',0,'',354,'SPARTA\' ANNA','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(37,144,'GIUFFRIDA (ENDOCRINOLOGIA)',0,'',145,'GIUFFRIDA DARIO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(38,146,'GIUFFRIDA (MATTINA)',64,'ONCOLOGIA AMBUL.',145,'GIUFFRIDA DARIO','',0,1,'2014-05-13','0000-00-00'),
	(39,145,'GIUFFRIDA (POMERIGGIO)',0,'ONCOLOGIA MEDICA',145,'GIUFFRIDA DARIO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(40,171,'GIUFFRIDA C.MAURIZIO (PRIVATO)',0,'NEUROCHIRURGIA',171,'GIUFFRIDA CARMELO MAURIZIO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(41,53,'GIUFFRIDA CARMELO MAURIZIO',0,'NEUROCHIRURGIA',171,'GIUFFRIDA CARMELO MAURIZIO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(42,364,'GIUSTOLISI ROSARIO',0,'ONCOEMATOLOGIA AMBULAT./REF.',364,'GIUSTOLISI ROSARIO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(43,114,'GRASSO VINCENZO',0,'UROLOGIA',114,'GRASSO VINCENZO','',0,1,'2014-05-13','0000-00-00'),
	(44,161,'IMPALLOMENI RAFFAELLO',75,'DERMATOLOGIA',161,'IMPALLOMENI RAFFAELLO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(45,109,'IUPPA ANTONINO',0,'CHIRURGIA ONCOLOGICA',109,'IUPPA ANTONIO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(46,14,'IUPPA ANTONIO',0,'CHIRURGIA ONCOLOGICA',109,'IUPPA ANTONIO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(47,395,'IUPPA GIUSEPPE',0,'CHIRURGIA ONCOLOGICA',395,'IUPPA GIUSEPPE','',0,1,'2014-05-13','0000-00-00'),
	(48,359,'LENTINI GIUSEPPE',0,'OTORINOLARINGOIATRIA',359,'LENTINI GIUSEPPE','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(49,172,'LIPERA MARIO',0,'CHIRURGIA ONCOLOGICA AMB.',172,'LIPERA MARIO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(50,165,'MAFODDA ANTONINO',64,'ONCOLOGIA AMBUL.',0,'MAFODDA ANTONINO','AMBULATORIO (I+E',1,0,'2014-05-13','0000-00-00'),
	(51,394,'MAIO ROBERTA',69,'RADIOLOGIA',394,'MAIO ROBERTA FEDERICA','',0,1,'2014-05-13','0000-00-00'),
	(52,121,'MAJORANA MARCELLO',69,'RADIOLOGIA',121,'MAJORANA MARCELLO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(53,147,'MARE MARZIA',0,'ONCOLOGIA MEDICA',147,'MARE MARZIA','',0,1,'2014-05-13','0000-00-00'),
	(54,123,'MARTINO MASSIMO',0,'CURE PALLIATIVE',123,'MARTINO MASSIMO','',0,1,'2014-05-13','0000-00-00'),
	(55,175,'MUNAO\' STEFANIA',0,'ONCOLOGIA MEDICA',175,'MUNAO\' STEFANIA','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(56,54,'NEUROCHIRURGIA',0,'NEUROCHIRURGIA',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(57,661,'ONCOEMATOLOGIA',0,'ONCOEMATOLOGIA AMBULAT./REF.',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(58,35,'ONCOEMATOLOGIA PRIVATO',0,'ONCOEMATOLOGIA',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(59,32,'ONCOEMATOLOGIA PROF.GIUSTOLISI',0,'ONCOEMATOLOGIA',364,'GIUSTOLISI ROSARIO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(60,641,'ONCOLOGIA AMBULATORIALE',64,'ONCOLOGIA AMBUL.',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(61,23,'ONCOLOGIA MEDICA',0,'ONCOLOGIA MEDICA',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(62,22,'ORL',0,'OTORINOLARINGOIATRIA',359,'LENTINI GIUSEPPE','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(63,39,'ORL PRIVATO',0,'OTORINOLARINGOIATRIA',359,'LENTINI GIUSEPPE','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(64,7,'PAC DIAGNOSTICI D.I.',0,'',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(65,6,'PAC DIAGNOSTICO 1',0,'',333,'COSENTINO SALVATORE','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(66,8,'PAC DIAGNOSTICO 2',63,'ECOGRAFIA',116,'SIGNORELLI MARIO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(67,9,'PAC DIAGNOSTICO 3',0,'',121,'MAJORANA MARCELLO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(68,180,'PIETRO PINO',0,'UROLOGIA',180,'PINO PIETRO','',0,1,'2014-05-13','0000-00-00'),
	(69,29,'PNEUMOLOGIA',0,'',701,'COPPOLINO SINIBALDO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(70,393,'PORRETTO CONCETTA MARIA',0,'',0,'','',0,1,'2014-05-13','0000-00-00'),
	(71,51,'PRERICOVERI ANESTESIA',0,'',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(72,48,'PRERICOVERI CARDIOLOGIA',0,'',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(73,49,'PRERICOVERI RADIOLOGIA',0,'',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(74,47,'PRERICOVERO VISITA',0,'',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(75,388,'PRESTIFILIPPO ANGELA',64,'ONCOLOGIA AMBUL.',388,'PRESTIFILIPPO ANGELA','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(76,55,'PREVENZIONE TIROIDE',0,'',64,'RUSSO BARBARO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(77,56,'PULIAFITO IVANA',0,'ONCOLOGIA MEDICA',715,'PULIAFITO IVANA','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(78,46,'Prenotazione Chemioterapie',0,'',0,'','RICOVERI',2,0,'2014-05-13','0000-00-00'),
	(79,132,'RANNO CRISTIAN',0,'UROLOGIA',132,'RANNO CHRISTIAN','',0,1,'2014-05-13','0000-00-00'),
	(80,195,'RUGGERI LUCA',0,'',0,'RUGGERI LUCA','AMBULATORIO (I+E',1,0,'2014-05-13','0000-00-00'),
	(81,351,'RUSSO ALESSIO',69,'RADIOLOGIA',351,'RUSSO ALESSIO','',0,1,'2014-05-13','0000-00-00'),
	(82,112,'SALLUZZO SALVATORE',0,'CHIRURGIA ONCOLOGICA',112,'SALLUZZO SALVATORE','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(83,345,'SCIRE\' PAOLA',0,'ONCOEMATOLOGIA',345,'SCIRE\' PAOLA','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(84,11,'SENOLOGIA MEDICAZIONI',0,'BREAST UNIT',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(85,45,'SENOLOGIA PRIV. DR.LIPERA',0,'BREAST UNIT',172,'LIPERA MARIO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(86,44,'SENOLOGICA PRIV. DR.CICALA',0,'BREAST UNIT',346,'CICALA SALVATORE','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(87,116,'SIGNORELLI MARIO',63,'ECOGRAFIA',116,'SIGNORELLI MARIO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(88,354,'SPARTA\' ANNA',59,'GINECOLOGIA',354,'SPARTA\' ANNA','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(89,52,'TAC IN CONVENZIONE',65,'TAC',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(90,37,'TERAPIA ANTALGICA PRIVATO',0,'TERAPIA ANTALGICA',108,'SGALAMBRO FRANCESCO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(91,380,'TROVATO SEBASTIANO',0,'',0,'','',0,1,'2014-05-13','0000-00-00'),
	(92,21,'URODINAMICA',0,'UROLOGIA',114,'GRASSO VINCENZO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(93,26,'UROLOGIA',0,'UROLOGIA',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(94,18,'UROLOGIA DR.FALCONE',0,'UROLOGIA',366,'FALCONE LORENZO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(95,20,'UROLOGIA DR.GRASSO',0,'UROLOGIA',114,'GRASSO VINCENZO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(96,19,'UROLOGIA DR.PINO',0,'UROLOGIA',180,'PINO PIETRO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(97,17,'UROLOGIA MEDICAZIONI',0,'UROLOGIA',0,'','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(98,31,'UROLOGIA PRIVATO DR.FALCONE',0,'UROLOGIA',366,'FALCONE LORENZO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(99,36,'UROLOGIA PRIVATO DR.GRASSO',0,'UROLOGIA',114,'GRASSO VINCENZO','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00'),
	(100,38,'UROLOGIA PRIVATO DR.RANNO',0,'UROLOGIA',132,'RANNO CHRISTIAN','AMBULATORIO (I+E',1,1,'2014-05-13','0000-00-00');



# Dump of table ec_display
# ------------------------------------------------------------


CREATE TABLE `ec_display` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `logo` varchar(100) NOT NULL,
  `info` text NOT NULL,
  `organigramma` text NOT NULL,
  `id_meteo` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



# Dump of table ec_feed
# ------------------------------------------------------------


CREATE TABLE `ec_feed` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titolo` varchar(255) NOT NULL,
  `intervallo` int(11) NOT NULL,
  `url` varchar(255) NOT NULL,
  `categoria` varchar(255) NOT NULL,
  `blocco_entrata` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



# Dump of table ec_immagini
# ------------------------------------------------------------


CREATE TABLE `ec_immagini` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titolo` varchar(255) NOT NULL,
  `descrizione` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



# Dump of table ec_modalita
# ------------------------------------------------------------


CREATE TABLE `ec_modalita` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codice` varchar(50) NOT NULL,
  `nome` varchar(50) NOT NULL,
  `creato_da` int(11) NOT NULL,
  `modificato_da` int(11) NOT NULL,
  `data_creazione` datetime NOT NULL,
  `data_modifica` datetime NOT NULL,
  `eliminato` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `ec_modalita` (`id`, `codice`, `nome`, `creato_da`, `modificato_da`, `data_creazione`, `data_modifica`, `eliminato`)
VALUES
	(1,'01','Ambulatorio',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),
	(2,'02','Ricovero',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),
	(3,'03','Day Hospital',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),
	(4,'04','Triage/Informazioni',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0);



# Dump of table ec_news
# ------------------------------------------------------------


CREATE TABLE `ec_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titolo` varchar(255) NOT NULL,
  `data` datetime NOT NULL,
  `descrizione` text NOT NULL,
  `creato_da` int(11) NOT NULL,
  `modificato_da` int(11) NOT NULL,
  `data_creazione` datetime NOT NULL,
  `data_modifica` datetime NOT NULL,
  `eliminato` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `ec_news` (`id`, `titolo`, `data`, `descrizione`, `creato_da`, `modificato_da`, `data_creazione`, `data_modifica`, `eliminato`)
VALUES
	(11,'Notizia 1','2014-08-01 18:34:12','Martedì di sangue a Gerusalemme, dove questa mattina quattro israeliani sono stati uccisi e altri otto sono rimasti feriti nel corso di un attentato condotto da due palestinesi - armati di una scure, un coltello e un\'arma da fuoco - in un complesso religioso',84,84,'2014-08-01 18:34:22','2014-11-18 12:47:22',1),
	(12,'Notizia 2','2014-11-05 13:13:00','Il Sole 24 Ore\r\n	\r\nIl flop dell\'Abenomics spinge il Giappone alle elezioni anticipate\r\nIl Sole 24 Ore	 - ‎39 minuti fa‎	\r\n\r\nIl premier giapponese Shinzo Abe ha annunciato la decisione di sciogliere la Camera Bassa il prossimo 21 novembre in vista di elezioni politiche anticipate che si svolgeranno entro la fine dell\'anno. Abe ha anche comunicato che rinvierà di 18 mesi ...',84,84,'2014-11-18 12:54:41','2014-11-18 13:10:52',1),
	(13,'Notizia 3','2015-01-13 14:00:00','Sgombero di due centri sociali, scontri a Milano\r\nIl Secolo XIX	 - ‎11 minuti fa‎	\r\n	\r\nMilano - Cariche delle forze dell\'ordine e lancio di fumogeni, stamani, a Milano, nel corso di uno sgombero di due centri sociali adiacenti, in via Ravenna e via Pomposa, nella zona sud della città. Gli agenti hanno anche lanciato lacrimogeni, gli antagonisti ...',84,0,'2014-11-18 12:55:03','0000-00-00 00:00:00',1),
	(14,'FONDAZIONE IOM','2015-09-22 16:22:00','FONDAZIONE IOM INVESTE SUL TERRITORIO IN RICERCA E INNOVAZIONE - PREVENZIONE - FORMAZIONE.\r\nAIUTACI AD AIUTARE!\r\n5x1000 ALLA FONDAZIONE IOM\r\nCOD. FISCALE 90032390875\r\nNon costa nulla ed è un atto di estrema solidarietà\r\n',84,0,'2015-09-22 16:24:05','0000-00-00 00:00:00',0),
	(15,'INIZIATIVE DI PREVENZIONE GRATUITE','2015-09-22 16:26:00','Fondazione IOM ha avviato un progetto che prevede l\'organizzazione di iniziative di prevenzione ed informazione di vario genere. Per ulteriori informazioni e per conoscere le iniziative di prevenzione www.fondazioneiom.it',84,84,'2015-09-22 16:27:47','2019-04-01 12:14:11',0),
	(16,'ECM quando la malattia entra in famiglia','2015-09-22 16:28:00','SABATO 26 SETTEMBRE (ORE 8.30-14.30) \r\nCORSO ECM QUANDO LA MALATTIA ENTRA IN FAMIGLIA\r\nACCREDITO PER: MEDICI DI MEDICINA GENERALE, MEDICI PALLIATIVISTI, EMATOLOGI, ONCOLOGI, INFERMIERI\r\nCREDITI: 5. PER INFO WWW.GRUPPOSAMED.COM associazionesinapsy@gmail.com',84,0,'2015-09-22 16:30:37','0000-00-00 00:00:00',1),
	(17,'ANATOMIA E ISTOLOGIA PATOLOGICA','2015-09-25 11:20:00','ANATOMIA E ISTOLOGIA PATOLOGICA\r\nResponsabile Dott. Lorenzo Memeo',84,84,'2015-09-25 11:21:23','2015-10-05 13:33:57',0),
	(18,'UNITA’ OPERATIVA DI CHIRURGIA TORACICA','2015-09-25 11:21:00','UNITA’ OPERATIVA DI CHIRURGIA TORACICA\r\nDirettore Dott. Francesco Caronia\r\nDott. Ettore Arrigo\r\nDott. Sebastiano Trovato',84,84,'2015-09-25 11:22:19','2015-10-05 13:48:05',1),
	(19,'DIAGNOSTICA PER IMMAGINI','2015-09-25 11:23:00','DIAGNOSTICA PER IMMAGINI\r\nResponsabile Dott.ssa Claudia Caltavuturo ',84,84,'2015-09-25 11:24:55','2018-11-09 18:40:13',0),
	(20,'U.O. CHIRURGIA ONCOLOGICA GENERALE','2015-09-25 11:24:00','U.O. CHIRURGIA ONCOLOGICA GENERALE Direttore: dott. Giorgio Giannone; dott. Gaspare Foresta\r\n',84,84,'2015-09-25 11:25:59','2016-10-17 18:55:23',0),
	(21,'ECOGRAFIA','2015-09-25 11:25:00','ECOGRAFIA Responsabile Dott. Mario Signorelli',84,84,'2015-09-25 11:26:48','2015-10-05 13:35:24',0),
	(22,'ORL ','2015-09-25 11:26:00','ORL Dott. Giuseppe Lentini\r\n',84,84,'2015-09-25 11:27:39','2019-10-29 19:02:24',0),
	(72,'check-up','2019-11-08 18:19:00','CHECK-UP: Non perdere tempo, controlla il tuo stato di salute!  Info e prenotazioni Tel. 095 7924747 dalle 10 alle 12 e dalle 15 alle 17. www.grupposamed.com ',84,0,'2019-11-08 18:22:41','0000-00-00 00:00:00',0),
	(23,'U.O. ONCOEMATOLOGIA E TRAPIANTO MIDOLLO OSSEO','2015-09-25 11:27:00','U.O. ONCOEMATOLOGIA E TRAPIANTO MIDOLLO OSSEO\r\nDirettore oncoematologia Dott.ssa Gabriella Amato\r\nDirettore trapianto midollo osseo Dott. Gaetano Moschetti\r\nDott.ssa Paola Scirè\r\nDott. Paolo Spina',84,84,'2015-09-25 11:28:37','2018-04-24 15:36:15',0),
	(24,'UNITA’ OPERATIVA DI NEUROCHIRURGIA','2015-09-25 11:28:00','UNITA’ OPERATIVA DI NEUROCHIRURGIA\r\nDirettore - Dott.Orazio Giliberto\r\nDott. Daniele Cafarella',84,84,'2015-09-25 11:29:24','2015-10-05 13:49:26',1),
	(25,'U.O. CHIRURGIA SENOLOGICA E RICOSTRUTTIVA','2015-09-25 11:29:00','U.O. CHIRURGIA SENOLOGICA E RICOSTRUTTIVA\r\nDirettore dott. Giacomo Fisichella\r\nDott. Mario Lipera\r\nDott. Salvatore Cicala\r\n\r\n',84,84,'2015-09-25 11:30:10','2019-10-29 19:00:59',0),
	(26,'U.O. UROLOGIA','2015-09-25 11:29:00','U.O. UROLOGIA\r\nDirettore Dott. Pietro Pino\r\nDott. Lorenzo Falcone\r\nDott. Vincenzo Grasso',84,84,'2015-09-25 11:30:53','2015-10-05 13:47:18',0),
	(27,'UNITA’ OPERATIVA DI ONCOLOGIA MEDICA','2015-09-25 11:30:00','UNITA’ OPERATIVA DI ONCOLOGIA MEDICA\r\nDirettore Prof. Dario Giurida\r\nDott.ssa Giusi Blanco\r\nDott.ssa Marzia Mare\r\nDott.ssa Stefania Munaò\r\nDott.ssa Dorotea Sciacca\r\nDott.ssa Angela Prestilippo',84,84,'2015-09-25 11:31:37','2015-10-05 13:50:04',0),
	(28,'UNITA’ OPERATIVA DI CURE PALLIATIVE','2015-09-25 11:31:00','UNITA’ OPERATIVA DI CURE PALLIATIVE\r\nDirettore \r\nDott. Giuseppe Covato\r\nDott. Massimo Martino',84,84,'2015-09-25 11:32:26','2019-10-29 19:03:33',0),
	(29,'FISIOPATOLOGIA CARDIOVASCOLARE','2015-09-25 11:31:00','FISIOPATOLOGIA CARDIOVASCOLARE\r\nResponsabile Dott. Vittorio Casaccio\r\nDott. Giovanni Marchese\r\nDott. Giovanni Salici',84,84,'2015-09-25 11:33:06','2015-10-05 13:36:01',0),
	(30,'LABORATORIO ANALISI','2015-09-25 11:32:00','LABORATORIO ANALISI \r\nResponsabile Dott.ssa Daniela Carcò',84,84,'2015-09-25 11:33:44','2015-10-05 13:36:45',0),
	(31,'SERVIZIO DI PNEUMOLOGIA ONCOLOGICA','2015-09-25 11:33:00','SERVIZIO DI PNEUMOLOGIA ONCOLOGICA\r\nResponsabile Dott. Sinibaldo Coppolino',84,84,'2015-09-25 11:34:23','2015-10-05 13:37:34',0),
	(32,'SERVIZIO DI PSICONCOLOGIA','2015-09-25 11:33:00','SERVIZIO DI PSICONCOLOGIA\r\nResponsabile Dott.ssa Maria Carmela Scriminaci\r\nDott.ssa Anna Calcara',84,84,'2015-09-25 11:35:06','2015-10-05 13:38:12',0),
	(33,'ECM IL TRAPIANTO EMOPOIETICO','2015-10-09 10:17:00','ECM IL TRAPIANTO EMOPOIETICO: PROBLEMATICHE CLINICHE E ISTITUZIONALI.\r\nACCREDITATO PER MEDICI (ONCOLOGI, EMATOLOGI) BIOLOGI INFERMIERI\r\nCREDITI: 5,4\r\nPer informazioni e prenotazioni: associazionesinapsy@gmail.com\r\n095 7110232- 349 4328892',84,0,'2015-09-28 10:19:59','0000-00-00 00:00:00',1),
	(46,'carcinoma dell’endometrio','2016-09-24 09:00:00','SABATO 24 SETTEMBRE CORSO ECM per medici di famiglia e ginecologi\r\nDiagnosi precoce del carcinoma dell’endometrio: Rete Territoriale integrata\r\nDirettore del corso: dott. Alfio Cannavò. per info www.grupposamed.com, associazionesinapsy@gmail.com\r\n\r\n',84,0,'2016-08-31 13:07:07','0000-00-00 00:00:00',1),
	(50,'servizio di nutrizione','0000-00-00 00:00:00','SERVIZIO / AMBULATORIO DI NUTRIZIONE: dott.ssa Anna Roccaro',84,84,'2018-01-19 13:07:04','2018-01-19 13:08:14',0),
	(63,'prevenzione del melanoma','2019-01-15 09:32:00','Grazie al sostegno della Fondazione IOM, nei mesi di gennaio e febbraio è stata avviata una campagna di prevenzione del melanoma: visita e videodermatoscopia gratuite (solo su prenotazione, solo prime visite, fino ad esaurimento posti). Info 0957895000',84,0,'2019-01-09 09:38:18','0000-00-00 00:00:00',1),
	(34,'ECM ONCOLOGIA TORACICA','2015-10-05 13:49:00','ECM ONCOLOGIA TORACICA\r\nCrediti 5 per: Medici (Oncologia, pneumologia, Chir. gen., chir. tor., Radioterapia, Radiodiagnostica, Medicina generale, Anatomia patologica) Biologi, Farmacisti, TSRM. \r\nPer info associazionesinapsy@gmail.com 095 7110232- 349 4328892',84,0,'2015-10-05 13:55:35','0000-00-00 00:00:00',1),
	(35,'AMBULATORIO GRATUITO SENOLOGIA','2015-11-04 11:15:00','AMBULATORIO GRATUITO PER PAZIENTI SINTOMATICHE, attivo grazie al sostegno della Fondazione IOM.  Per info e prenotazioni tel. 0957895000 int. 404 -1148 www.grupposamed.com',84,0,'2015-11-04 11:18:30','0000-00-00 00:00:00',1),
	(36,'AMBULATORIO DI ALIMENTAZIONE E NUTRIZIONE','2015-11-13 14:00:00','AMBULATORIO DI ALIMENTAZIONE E NUTRIZIONE dott.ssa Agnello.\r\nOgni giovedì incontri gratuiti di orientamento su prenatazione\r\nOgni venerdì visite su prenotazione\r\n',84,84,'2015-11-13 14:01:41','2015-12-02 12:51:40',1),
	(38,'prevenzione odontoiatrica','2015-12-04 14:36:00','CAMPAGNA DI PREVENZIONE ED EDUCAZIONE A UNA BUONA SALUTE ORALE CON IL SOSTEGNO DELLA FONDAZIONE IOM PRESSO CASA DI CURA MUSUMECI GECAS: 1° VISITA E PIANO TRATTAMENTO GRATUITI SCONTO DEL 20% SU TUTTI I TRATTAMENTI. PER INFORMAZIONI E PRENOTAZIONI 095 7504767.',84,84,'2015-12-04 14:38:31','2016-06-15 12:49:57',1),
	(37,'asta libri','2015-12-02 12:43:00','Dona un libro per asta di beneficenza per acquisto di turbanti che la FONDAZIONE IOM distribuirà ai pazienti in chemioterapia.\r\nPer Info: Ass. sociale Francesca Gabriele Campisi. int 526',84,0,'2015-12-02 12:47:12','0000-00-00 00:00:00',1),
	(39,'CHIRURGIA VASCOLARE E DI FLEBOLOGIA','2015-12-04 14:39:00','AMBULATORIO DI CHIRURGIA VASCOLARE E DI FLEBOLOGIA- CAMPAGNA DI PREVENZIONE CON IL SUPPORTO DELLA FONDAZIONE IOM PRESSO CASA DI CURA MUSUMECI GECAS: 1° visita gratuita e sconto del 20% sui servizi. Per info e prenotazioni: tel. 095 7504768 www.grupposamed.com ',84,0,'2015-12-04 14:43:02','0000-00-00 00:00:00',1),
	(40,'incontro sui tumori neuroendocrini','2016-02-16 10:00:00','25 febbraio 2016 incontro di confronto e aggiornamento sui tumori neuroendocrini del tratto gastroenteropancreatico.',84,0,'2016-02-16 10:01:10','0000-00-00 00:00:00',1),
	(41,'I PERCORSI IN ONCOLOGIA','2016-02-16 10:03:00','4 marzo ecm per infermieri I PERCORSI IN ONCOLOGIA: GESTIONE, APPROPRIATEZZA E SICUREZZA DEI FARMACI ANTIBLASTICI. info associazionesinapsy@gmail.com',84,0,'2016-02-16 10:05:13','0000-00-00 00:00:00',1),
	(42,'ALZHEIMER E IL PROGETTO DIA–DE–MENTIS','2016-03-11 10:41:00','venerdi 11 marzo si svolgerà il convegno ecm LA  MALATTIA  DI  ALZHEIMER  E  IL  PROGETTO  DIA – DE – MENTIS. per info www.grupposamed.com ',84,0,'2016-02-25 10:44:07','0000-00-00 00:00:00',1),
	(43,'The New in the Practice Surgery&Anesthesia ','2016-04-15 12:52:00','The New in the Practice Surgery and Anesthesia convegno ECM per seguenti specialità: anestesia, chirurgia gen, chirurgia toracica, ORL. 15 e 16 aprile IOM. per info associazionesinapsy@gmail.com',84,0,'2016-03-18 12:53:21','0000-00-00 00:00:00',1),
	(44,'open week onda','2016-04-22 12:50:00','Dal 22 al 28 aprile open week onda: alcuni servizi gratuiti per le donne. Per info www.grupposamed.com, www.bollini.it 0957895000',84,0,'2016-04-04 13:02:26','0000-00-00 00:00:00',1),
	(45,'TIROIDE','2016-05-28 10:29:00','TIROIDE: Sabato 28 maggio ore 9.00 incontro informativo con il prof. Dario Giuffrida. Chi partecipa all\'incontro potrà effettuare gratuitamente un\'ecografia tiroidea (lo stesso giorno o nei giorni seguenti). E\' richiesta la prenotazione. ',84,0,'2016-05-04 10:33:03','0000-00-00 00:00:00',1),
	(47,'6° GIORN. REM DI MEDICINA NUCLEARE','2016-12-02 10:32:00','CONVEGNO ECM Venerdì 2 dic. 2016 \r\n6° GIORNATA  REM  DI  MEDICINA  NUCLEARE LA  PET/TC  CON  FDG: ATTUALITA’  CLINICHE,  APPROPRIATEZZE  E  VALENZA  ECONOMICA (Dir. del corso dott. Luigi Castorina). \r\nPer info e iscrizioni associazionesinapasy@gmail.com ',84,0,'2016-11-09 10:35:45','0000-00-00 00:00:00',1),
	(48,'CONV. ECM LA TERAPIA CELLULARE RIGENERATIVA','2016-11-25 10:33:00','25 nov. 2016 CONVEGNO ECM LA TERAPIA CELLULARE RIGENERATIVA. Per info e iscrizioni associazionesinapsy@gmail.com',84,0,'2016-11-09 10:37:23','0000-00-00 00:00:00',1),
	(49,'convegno dicembre','2017-12-15 13:59:00','15 e 16 dicembre CONVEGNO ECM AGGIORNAMENTO SULLA STRATEGIA TERAPEUTICA DEI TUMORI DEL PANCREAS E DEL COLON E DEL RETTO. Resp. scientifici prof. Giorgio Giannone, prof. Dario Giuffrida, prof. Stefano Pergolizzi. \r\nPer info comunicazione@grupposamed.com\r\n',84,0,'2017-11-28 14:03:03','0000-00-00 00:00:00',1),
	(51,'melanoma','2018-01-25 16:32:00','FEBBRAIO: PREVENZIONE DEL MELANOMA\r\nCampagna con il supporto della Fondazione IOM. Il dott. Di Mauro e la dott.ssa Gurgone effettueranno visita e videodermatoscopia gratuitamente su prenotazione Tel. 095 7895000. Fino ad esaurimento posti disponibili. ',84,0,'2018-01-25 16:33:26','0000-00-00 00:00:00',1),
	(52,'meeting mercoled\'','2018-02-12 16:10:00','Da settembre a dicembre MEETING INTERDISCIPLINARE DI AGGIORNAMENTO IN AMBITO ONCOLOGICO sulle novità e sui percorsi diagnostico- assistenziali partendo da esperienze cliniche per garantire al paziente una presa in carico globale e coordinata',84,84,'2018-02-12 16:16:32','2018-09-29 13:00:14',1),
	(53,'open week onda','2018-04-09 17:44:00','Open week: Giovedì 19 aprile dalle 14.30 visite nutrizionali gratuite su prenotazione, \r\nsabato 21 aprile ore 9 incontro informativo sulla prevenzione a seguire chi ha partecipato all\'incontro potrà effettuare una visita senologica gratuita.',84,84,'2018-04-09 17:48:39','2018-04-24 15:35:09',1),
	(54,'assicurazioni','0000-00-00 00:00:00','Attive convenzioni con ENTI ASSICURATIVI.\r\nNO liste, NO ticket, NO iter del SSN. Un privilegio che potresti già aver acquisito senza saperlo! Per informazioni: dott.ssa Domenica Annunziata 095 7924747 domenica.annunziata@grupposamed.com \r\n\r\n',84,0,'2018-04-20 15:41:56','0000-00-00 00:00:00',0),
	(55,'prevenzione urologica','2018-05-02 09:10:00','Fondazione IOM: sabato 5 maggio ore 10 v.le della Regione 24 Viagrande incontro PREVENZIONE UROLOGICA Tumore della prostata, tumore del testicolo, deficit di fertilità. Chi partecipa all\'incontro potrà prenotare gratuitamente PSA e visita allo IOM.',84,0,'2018-05-02 09:12:42','0000-00-00 00:00:00',1),
	(56,'settimana tiroide','0000-00-00 00:00:00','Settimana mondiale della TIROIDE: sabato 19 maggio ore 9.30 presso sala convegni incontro informativo. Chi partecipa all\'incontro potrà effettuare gratuitamente un\'ecografia tiroidea (solo prime visite). ',84,0,'2018-05-14 14:43:39','0000-00-00 00:00:00',1),
	(57,'E\' tempo di vita','2018-09-26 12:55:00','IOM aderisce al progetto nazionale E\' tempo di vita, affrontiamo insieme il tumore al seno avanzato. Il 27 ottobre ore 10.30 INCONTRO INFORMATIVO CON I MEDICI. Presente in struttura un totem per suggerire gli argomenti da trattare durante l\'incontro.  ',84,0,'2018-09-29 12:58:30','0000-00-00 00:00:00',1),
	(58,'tumori neuroendocrini','2018-09-28 12:59:00','13 ottobre evento ECM Tumori neuroendocrini approccio clinico e gestione',84,0,'2018-09-29 13:03:13','0000-00-00 00:00:00',1),
	(59,'MEETING ENDOCRINOLOGICAL ONCOLOGY','2018-10-05 09:53:00','Sabato 3 NOVEMBRE 2018: MEETING ON UPDATE IN ENDOCRINOLOGICAL ONCOLOGY. Resp. scientifico prof. Dario Giuffrida. Per info associazionesinapsy@gmail.com',84,0,'2018-10-05 09:56:45','0000-00-00 00:00:00',1),
	(60,'ANTIBLASTICI','2018-12-10 18:38:00','CORSO ECM PER INFERMIERI SUI PERCORSI IN ONCOLOGIA: \r\nGESTIONE, APPROPRIATEZZA E SICUREZZA DEI FARMACI ANTIBLASTICI. Responsabile scientifico: dott.ssa Maria Paola Vitale \r\n10 dicembre 2018\r\n',84,0,'2018-11-09 18:43:38','0000-00-00 00:00:00',1),
	(61,'CARCINOMA PROSTATA','2018-12-18 18:41:00','CORSO ECM PER MEDICI FARMACISTI FOCUS ON TRATTAMENTO DEL CARCINOMA PROSTATICO METASTATICO UNA CONTINUA EVOLUZIONE\r\nDirettore del corso: prof. Dario Giuffrida \r\n18 dicembre 2018\r\n',84,0,'2018-11-09 18:44:32','0000-00-00 00:00:00',1),
	(62,'SESSUALITA\'','2018-12-15 18:42:00','CORSO ECM PER MEDICI DI FAMIGLIA SU LA SESSUALITA’ NELL’UOMO: COME PRESERLARLA E COME CURARLA\r\nResp. scientifico: Prof. Rosario Leonardi\r\nSabato 15 Dicembre\r\nPRESSO Casa di cura Musumeci Gecas – Gravina di Catania (CT)\r\n',84,0,'2018-11-09 18:46:37','0000-00-00 00:00:00',1),
	(64,'TUMORI GASTROENTERICI','2019-01-31 17:59:00','22 e 23 febbraio convegno ECM sui TUMORI DEL TRATTO GASTROENTERICO organizzato dai prof. Giannone e Giuffrida. Per info e iscrizioni comunicazione@grupposamed.com',84,0,'2019-01-31 18:04:36','0000-00-00 00:00:00',1),
	(65,'Standard Europei Oncologia di Eccellenza','2019-03-16 17:30:00','25 marzo ore 9.30 presso la Sala Convegni dell\' Istituto Oncologico del Mediterraneo incontro scientifico sul tema \"Focus on Standard Europei per l\'Oncologia di Eccellenza\". ',84,0,'2019-03-16 17:35:43','0000-00-00 00:00:00',1),
	(66,'meeting casi clinici','2019-03-16 17:35:00','DAL 20 MARZO RICOMINCIANO I MEETING SETTIMANALI CON ECM SUI CASI CLINICI PER CONDIVIDERE ESPERIENZE CLINICHE IN AMBITO ONCOLOGICO CON APPROCCIO MULTIDISCIPLINARE ',84,0,'2019-03-16 17:39:28','0000-00-00 00:00:00',0),
	(67,'open week ','2019-04-01 12:00:00','13 aprile ore 10, sala convegni IOM: incontro informativo sul tumore della mammella. Chi partecipa all\'incontro potrà effettuare gratuitamente (nei giorni successivi) visita, mammografia/ecografia. solo su prenotazione: 0957924747 (ore 9.30 -13, 14.30-16)',84,0,'2019-04-01 12:18:53','0000-00-00 00:00:00',1),
	(68,'conv. trapiano','2019-04-01 12:17:00','Il 12 aprile si svolgerà presso la sala convegni IOM un convegno ECM Trapianto di midollo osseo: attualità e prospettive delle nuove terapie antiinfettive. Esperienza del centro metropolitano. ',84,0,'2019-04-01 12:21:34','0000-00-00 00:00:00',1),
	(69,'mammografia','0000-00-00 00:00:00','NUOVO MAMMOGRAFO DI ULTIMA GENERAZIONE\r\n3D DIMENSIONS CON TOMOSINTESI:  immagini più dettagliate, minor tempo di esecuzione, più confortevole, riduce gli ulteriori accertamenti, individua fino al 65% in più di tumori in più,  riduce la dose. INFO 0957895000',84,0,'2019-04-15 19:05:00','0000-00-00 00:00:00',0),
	(70,'settimana tiroide','2019-05-15 19:50:00','FONDAZIONE IOM. SABATO 25 MAGGIO ORE 16.30 PRESSO IOM INCONTRO INFORMATIVO SULLA PREVENZIONE DELLE MALATTIE TIROIDEE. CHI PARTECIPA ALL\'INCONTRO POTRA\' EFFETTUARE GRATUITAMENTE UNA ECOGRAFIA TIROIDEA. INFO 095 7924747\r\n\r\n',84,0,'2019-05-15 19:58:33','0000-00-00 00:00:00',1),
	(71,'progetto ginestra','0000-00-00 00:00:00','Sabato 15 giugno alle ore 10.00: incontro di presentazione del progetto Ginestra, progetto di consulenza d\'immagine dedicato alle donne in rinascita. ',84,0,'2019-05-29 19:46:30','0000-00-00 00:00:00',1),
	(73,'colonscopia vituale','2019-11-08 18:25:00','E\' stata attivata la colonscopia virtuale: meno invasiva, uguale accuratezza. Per info e prenotazioni 095 7895000 www.grupposamed.com ',84,0,'2019-11-08 18:26:03','0000-00-00 00:00:00',0),
	(74,'diagnostica e lab analisi','2019-11-08 18:29:00','E\' possibile effettuare, a tariffe vantaggiose: Colonscopia virtuale, Mammografia 3D con tomosintesi, TC, Radiografia, Ecografia, Esami di laboratorio analisi di routin e specifici. Per info e prenotazioni 095 7895000 www.grupposamed.com ',84,0,'2019-11-08 18:30:19','0000-00-00 00:00:00',0),
	(75,'prevenzione nicolosi','2019-11-29 16:00:00','venerdì 29 novembre ore 16.00 presso sala consiliare Comune di Nicolosi: incontro di informazione e prevenzione del tumore mammario. per info www.fondazioneiom.it ',84,0,'2019-11-12 17:40:23','0000-00-00 00:00:00',1),
	(76,'prevenzione melanoma','2020-01-30 10:51:00','Fondazione IOM. campagna di prevenzione del melanoma: è possibile eseguire gratuitamente la mappatura dei nei con il videodermatoscopio. Info Tel.  0957895000 ',84,0,'2020-01-21 10:53:26','0000-00-00 00:00:00',0);



# Dump of table ec_organigramma
# ------------------------------------------------------------


CREATE TABLE `ec_organigramma` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descrizione` varchar(500) NOT NULL,
  `creato_da` int(11) NOT NULL,
  `modificato_da` int(11) NOT NULL,
  `data_creazione` datetime NOT NULL,
  `data_modifica` datetime NOT NULL,
  `eliminato` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `ec_organigramma` (`id`, `descrizione`, `creato_da`, `modificato_da`, `data_creazione`, `data_modifica`, `eliminato`)
VALUES
	(2,'fjkberkjrbkejbvkv\r\nv jvb djkvbdjkb\r\nvdf vkfdbv ksjb',84,0,'2014-08-01 18:35:30','0000-00-00 00:00:00',0);



# Dump of table ec_prenotazioni_dh_ambulatori
# ------------------------------------------------------------


CREATE TABLE `ec_prenotazioni_dh_ambulatori` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data` date DEFAULT NULL,
  `ora` time DEFAULT NULL,
  `nome_paziente` varchar(45) DEFAULT NULL,
  `data_nascita` date DEFAULT NULL,
  `id_agenda` int(11) DEFAULT NULL,
  `nome_agenda` varchar(35) DEFAULT NULL,
  `fuorilista` int(11) DEFAULT '0',
  `accettato` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `ec_prenotazioni_dh_ambulatori` (`id`, `data`, `ora`, `nome_paziente`, `data_nascita`, `id_agenda`, `nome_agenda`, `fuorilista`, `accettato`)
VALUES
	(1,'2020-06-22','10:00:00','CASTORINA BARBARA','1939-11-27',7,'CALTAVUTURO CLAUDIA',0,NULL),
	(2,'2020-06-22','10:30:00','DORATA MARIA','1936-12-31',7,'CALTAVUTURO CLAUDIA',0,NULL),
	(3,'2020-06-22','11:00:00','TOMASELLO POMA ROSA','1950-04-13',7,'CALTAVUTURO CLAUDIA',0,NULL),
	(4,'2020-06-22','11:30:00','BIUSO ALFIA','1958-06-22',7,'CALTAVUTURO CLAUDIA',0,NULL),
	(5,'2020-06-22','12:00:00','PRIVITERA SEBASTIANO','1936-09-15',7,'CALTAVUTURO CLAUDIA',0,NULL),
	(6,'2020-06-22','11:00:00','DORATA MARIA','1936-12-31',8,'SIGNORELLI MARIO',0,NULL),
	(7,'2020-06-22','11:30:00','CASTORINA BARBARA','1939-11-27',8,'SIGNORELLI MARIO',0,NULL),
	(8,'2020-06-22','11:50:00','TOMASELLO POMA ROSA','1950-04-13',8,'SIGNORELLI MARIO',0,NULL),
	(9,'2020-06-22','12:10:00','BIUSO ALFIA','1958-06-22',8,'SIGNORELLI MARIO',0,NULL),
	(10,'2020-06-22','12:30:00','BIUSO ALFIA','1958-06-22',8,'SIGNORELLI MARIO',0,NULL),
	(11,'2020-06-22','12:50:00','PRIVITERA SEBASTIANO','1936-09-15',8,'SIGNORELLI MARIO',0,NULL),
	(12,'2020-06-22','10:00:00','CAMPISI ELOISE','2002-01-08',76,'FISICHELLA GIACOMO',0,NULL),
	(13,'2020-06-22','10:30:00','MERITO RITA','1944-07-24',76,'FISICHELLA GIACOMO',0,NULL),
	(14,'2020-06-22','11:00:00','INFANTINO LEILA','2020-06-16',107,'AMATO GABRIELLA',0,NULL),
	(15,'2020-06-22','11:30:00','FALSAPERLA DOMENICO','1935-12-22',107,'AMATO GABRIELLA',0,NULL),
	(16,'2020-06-22','14:50:00','GIARRATANA ANGELA ANNA','2020-06-16',144,'GIUFFRIDA DARIO',0,NULL),
	(17,'2020-06-22','15:10:00','SCHILLACI ALFIO ALDO','2020-06-16',144,'GIUFFRIDA DARIO',0,NULL),
	(18,'2020-06-22','15:30:00','SCANDURA ROSA','2020-06-16',144,'GIUFFRIDA DARIO',0,NULL),
	(19,'2020-06-22','15:50:00','PESCE ANTONINO','2020-06-16',144,'GIUFFRIDA DARIO',0,NULL),
	(20,'2020-06-22','16:10:00','CARUSO ROSARIA BARBARA','2020-06-16',144,'GIUFFRIDA DARIO',0,NULL),
	(21,'2020-06-22','16:15:00','SANDOVAL JOHN JAIRO SANDOVAN','2020-06-16',144,'GIUFFRIDA DARIO',0,NULL),
	(22,'2020-06-22','16:30:00','VITALE MARIA LUISA','2020-06-16',144,'GIUFFRIDA DARIO',0,NULL),
	(23,'2020-06-22','16:50:00','TRAMONTANA CONCETTA','1949-02-23',144,'GIUFFRIDA DARIO',0,NULL),
	(24,'2020-06-22','17:10:00','AITA SALVATORE','1944-03-08',144,'GIUFFRIDA DARIO',0,NULL),
	(25,'2020-06-22','17:30:00','LA SPINA VENERA','2020-06-16',144,'GIUFFRIDA DARIO',0,NULL),
	(26,'2020-06-22','17:50:00','ATTINA\' ROSSELLA','1955-10-05',144,'GIUFFRIDA DARIO',0,NULL),
	(27,'2020-06-22','18:10:00','OLIVERI MARISA','2020-06-16',144,'GIUFFRIDA DARIO',0,NULL),
	(28,'2020-06-22','18:30:00','CAMPO NICOLA','2020-06-16',144,'GIUFFRIDA DARIO',0,NULL),
	(29,'2020-06-22','18:45:00','VINTALORO FABIO','2020-06-16',144,'GIUFFRIDA DARIO',0,NULL),
	(30,'2020-06-22','10:20:00','MARINO DOMENICO','1938-04-03',145,'GIUFFRIDA DARIO',0,NULL),
	(31,'2020-06-22','10:40:00','CAMILLERI GRAZIELLA','2020-06-16',145,'GIUFFRIDA DARIO',0,1),
	(32,'2020-06-22','13:45:00','TURNATURI CARMELA','2020-06-16',145,'GIUFFRIDA DARIO',0,NULL),
	(33,'2020-06-22','14:00:00','SCUDERI ANGELA','2020-06-16',145,'GIUFFRIDA DARIO',0,1),
	(34,'2020-06-22','14:40:00','SCALZO CAMILLA','1936-01-31',145,'GIUFFRIDA DARIO',0,1),
	(35,'2020-06-22','15:00:00','SGROI GIOVANNI','1937-02-07',145,'GIUFFRIDA DARIO',0,NULL),
	(36,'2020-06-22','15:20:00','REITANO CONCETTA','1939-08-05',145,'GIUFFRIDA DARIO',0,1),
	(37,'2020-06-22','15:40:00','LO IACONO ANGELO','2020-06-16',145,'GIUFFRIDA DARIO',0,1),
	(38,'2020-06-22','16:00:00','PATANE\' SALVATORE','1952-09-11',145,'GIUFFRIDA DARIO',0,NULL),
	(39,'2020-06-22','16:20:00','SARAGOZZA SELENIA','2020-06-16',145,'GIUFFRIDA DARIO',0,NULL),
	(40,'2020-06-22','16:40:00','ZAMPOGNA MARIA ANNA','1936-01-19',145,'GIUFFRIDA DARIO',0,NULL),
	(41,'2020-06-22','17:00:00','BELLARDITA CONCETTA','2020-06-16',145,'GIUFFRIDA DARIO',0,NULL),
	(42,'2020-06-22','17:20:00','TIMPANARO FILIPPO','1953-06-20',145,'GIUFFRIDA DARIO',0,NULL),
	(43,'2020-06-22','17:40:00','MELINA AGATINO','2020-06-16',145,'GIUFFRIDA DARIO',0,NULL),
	(44,'2020-06-22','18:00:00','PORTO MARIA','1949-10-18',145,'GIUFFRIDA DARIO',0,NULL),
	(45,'2020-06-22','18:20:00','FIDUCIA SALVATORE','2020-06-16',145,'GIUFFRIDA DARIO',0,NULL),
	(46,'2020-06-22','18:40:00','SCALIA GRAZIA','2020-06-16',145,'GIUFFRIDA DARIO',0,NULL),
	(47,'2020-06-22','19:00:00','CASTRO PATRIZIA','1962-09-01',145,'GIUFFRIDA DARIO',0,NULL),
	(48,'2020-06-22','19:15:00','DRUGO GIOACCHINO','2020-06-16',145,'GIUFFRIDA DARIO',0,NULL),
	(49,'2020-06-22','09:00:00','FORTE MARIA GRAZIA','1966-11-21',161,'GURGONE SILVIA',0,NULL),
	(50,'2020-06-22','09:15:00','VINCIGUERRA GIORGIO','2020-06-16',161,'GURGONE SILVIA',0,NULL),
	(51,'2020-06-22','09:30:00','ARCIDIACONO MARIA CONCETTA','2020-06-16',161,'GURGONE SILVIA',0,NULL),
	(52,'2020-06-22','09:45:00','MACRI\' MARIO','2020-06-16',161,'GURGONE SILVIA',0,NULL),
	(53,'2020-06-22','10:00:00','NATALIA','2020-06-16',161,'GURGONE SILVIA',0,NULL),
	(54,'2020-06-22','10:15:00','SAPIENZA GIULIA','2020-06-16',161,'GURGONE SILVIA',0,NULL),
	(55,'2020-06-22','10:30:00','CARUANA THERESE','2020-06-16',161,'GURGONE SILVIA',0,NULL),
	(56,'2020-06-22','10:45:00','FARANNA AGNESE ADELAIDE','1982-03-04',161,'GURGONE SILVIA',0,NULL),
	(57,'2020-06-22','11:00:00','CICERO GIUSEPPE','1979-07-05',161,'GURGONE SILVIA',0,NULL),
	(58,'2020-06-22','11:15:00','BONACCORSI MARIA','2020-06-16',161,'GURGONE SILVIA',0,NULL),
	(59,'2020-06-22','11:30:00','MINUTOLA ANTONINO','1953-07-12',161,'GURGONE SILVIA',0,NULL),
	(60,'2020-06-22','11:45:00','FINOCCHIARO FILIPPO','1943-06-11',161,'GURGONE SILVIA',0,NULL),
	(61,'2020-06-22','12:00:00','CUTULI CONCETTA','1954-10-17',161,'GURGONE SILVIA',0,NULL),
	(62,'2020-06-22','12:15:00','GIOCASTRO DANIELA','1949-05-18',161,'GURGONE SILVIA',0,NULL),
	(63,'2020-06-22','07:30:00','FERRARA PIETRO','1952-06-02',201,'',0,1),
	(64,'2020-06-22','07:35:00','SCIUTO GIUSEPPE','1961-04-08',201,'',0,1),
	(65,'2020-06-22','07:40:00','BARBAGALLO GIUSEPPE','1960-09-18',201,'',0,NULL),
	(66,'2020-06-22','07:45:00','MUSMECI VENERA','1961-08-14',201,'',0,NULL),
	(67,'2020-06-22','07:50:00','ZAPPALA\' ANTONINO','1963-06-08',201,'',0,NULL),
	(68,'2020-06-22','07:55:00','CASSARINO SALVATORE','1949-02-07',201,'',0,NULL),
	(69,'2020-06-22','07:30:00','GRIMALDI MARIA','1951-01-10',202,'',0,1),
	(70,'2020-06-22','07:35:00','RUSSO SANTO','1948-11-01',202,'',0,NULL),
	(71,'2020-06-22','07:40:00','TOSCANO GIUSEPPE','1960-09-15',202,'',0,NULL),
	(72,'2020-06-22','07:45:00','NOBILE ALFIO','1963-03-20',202,'',0,NULL),
	(73,'2020-06-22','07:50:00','DEL POPOLO DANIELA','1973-08-28',202,'',0,NULL),
	(74,'2020-06-22','07:55:00','CASSARINO SALVATORE','1949-02-07',202,'',0,NULL),
	(75,'2020-06-22','08:00:00','RICHIUSA ANNA MARIA','1942-07-09',202,'',0,NULL),
	(76,'2020-06-22','08:05:00','CANZONIERI MARIANTONIA','1953-09-25',202,'',0,NULL),
	(77,'2020-06-22','08:10:00','MASSIMINO CARMELA','1957-06-07',202,'',0,NULL),
	(78,'2020-06-22','08:15:00','RAIMONDO CARMELO','1952-03-05',202,'',0,NULL),
	(79,'2020-06-22','08:25:00','MAGRI\' NUNZIA LETIZIA','1976-09-23',202,'',0,NULL),
	(80,'2020-06-22','08:30:00','URZI\' ANNA','1968-08-19',202,'',0,NULL),
	(81,'2020-06-22','07:30:00','SACCONE ANNA','1948-02-19',203,'',0,NULL),
	(82,'2020-06-22','07:35:00','DI MARIA PIETRO','1947-01-29',203,'',0,NULL),
	(83,'2020-06-22','07:40:00','GALVAGNO MELINA','1984-01-17',203,'',0,NULL),
	(84,'2020-06-22','07:45:00','CARMINIO MICHELE','1949-11-13',203,'',0,NULL),
	(85,'2020-06-22','07:50:00','NIGITA SALVATORE','1957-12-07',203,'',0,NULL),
	(86,'2020-06-22','07:55:00','INTILE IVANA','1990-07-30',203,'',0,NULL),
	(87,'2020-06-22','08:00:00','ROGGIO MARIA','1947-07-28',203,'',0,NULL),
	(88,'2020-06-22','08:05:00','ROMANO MARIA','1941-01-16',203,'',0,NULL),
	(89,'2020-06-22','08:10:00','FERRARA PIETRO','1952-06-02',203,'',0,NULL),
	(90,'2020-06-22','08:15:00','PELUSO GRAZIA','1958-08-26',203,'',0,NULL),
	(91,'2020-06-22','08:20:00','MUSMECI VENERA','1961-08-14',203,'',0,NULL),
	(92,'2020-06-22','08:25:00','DI PAOLA SALVATORE','1970-01-12',203,'',0,NULL),
	(93,'2020-06-22','08:30:00','MONACO GIUSEPPE SALVATORE','1958-06-21',203,'',0,NULL),
	(94,'2020-06-22','08:35:00','GULISANO AGATA','1959-12-29',203,'',0,NULL),
	(95,'2020-06-22','08:40:00','BAGLIERI GIUSEPPE','1959-09-03',203,'',0,NULL),
	(96,'2020-06-22','08:45:00','ZUMBO GIUSEPPE CORRADO','1960-02-10',203,'',0,NULL),
	(97,'2020-06-22','08:50:00','QUARTARONE MARIA','1951-03-04',203,'',0,NULL),
	(98,'2020-06-22','08:55:00','SIENA ANNA MARIA','1962-04-10',203,'',0,NULL),
	(99,'2020-06-22','09:00:00','BUA SALVATORE','1941-07-29',203,'',0,NULL),
	(100,'2020-06-22','09:05:00','SCIUTO GIUSEPPE','1961-04-08',203,'',0,NULL),
	(101,'2020-06-22','09:10:00','GALATI GIORDANO MELINA','1946-07-01',203,'',0,NULL),
	(102,'2020-06-22','09:00:00','GAMUZZA LORENZO','1954-01-02',333,'COSENTINO SALVATORE',0,NULL),
	(103,'2020-06-22','09:30:00','FINIELLI MARIA LUISA','1947-03-15',333,'COSENTINO SALVATORE',0,NULL),
	(104,'2020-06-22','10:00:00','PULVIRENTI UGO','1951-07-22',333,'COSENTINO SALVATORE',0,NULL),
	(105,'2020-06-22','10:30:00','PULVIRENTI UGO','1951-07-22',333,'COSENTINO SALVATORE',0,NULL),
	(106,'2020-06-22','11:00:00','DI GIUNTA GIOVANNI','2020-06-16',333,'COSENTINO SALVATORE',0,1),
	(107,'2020-06-22','09:00:00','BONACCORSO  ANTONINA GESSICA','2020-06-16',346,'CICALA SALVATORE',0,NULL),
	(108,'2020-06-22','09:20:00','.','2020-06-16',346,'CICALA SALVATORE',0,1),
	(109,'2020-06-22','09:40:00','.','2020-06-16',346,'CICALA SALVATORE',0,NULL),
	(110,'2020-06-22','08:15:00','VADALA\'','2020-06-16',641,'',0,NULL),
	(111,'2020-06-22','11:00:00','FORMOSA SALVATORE','2020-06-16',641,'',0,NULL),
	(112,'2020-06-22','11:30:00','GAMUZZA LORENZO','1954-01-02',641,'',0,NULL),
	(113,'2020-06-22','11:30:00','NOUN KHADIJA','1975-02-21',641,'',0,1),
	(114,'2020-06-22','12:00:00','LITRICO PIETRO','1956-06-04',641,'',0,NULL),
	(115,'2020-06-22','12:30:00','D\'URSO SALVATORE','1945-12-27',641,'',0,NULL),
	(116,'2020-06-22','13:00:00','D\'AMICO ROSAMARIA','2020-06-16',641,'',0,NULL),
	(117,'2020-06-22','13:30:00','GULISANO GIUSEPPA','2020-06-16',641,'',0,NULL),
	(118,'2020-06-22','14:00:00','VIGNERA FRANCESCA','2020-06-16',641,'',0,NULL),
	(119,'2020-06-22','15:00:00','NICOTRA ALFIO','1966-04-20',701,'COPPOLINO SINIBALDO',0,1),
	(120,'2020-06-22','16:00:00','FONTANABIANCA AGATA MARIA','1965-02-05',701,'COPPOLINO SINIBALDO',0,1),
	(121,'2020-06-22','00:00:00','DI GREGORIO NATALINA','1959-12-23',1005,'',0,1),
	(122,'2020-06-22','00:00:00','RUSSO ROSARIA','2020-06-16',1005,'',0,NULL),
	(123,'2020-06-22','00:00:00','CANNIZZARO ANNA MARIA SANTA','1956-11-01',1005,'',0,1),
	(124,'2020-06-22','00:00:00','PERNA CARMEN AURORA','1972-05-14',1005,'',0,NULL),
	(125,'2020-06-22','08:00:00','GRECO BARBARA','1931-12-08',1007,'GIANNONE GIORGIO',0,NULL),
	(126,'2020-06-22','08:20:00','LOPES GUGLIELMO','1962-12-19',1007,'GIANNONE GIORGIO',0,NULL),
	(127,'2020-06-22','08:00:00','LEONARDI SEBASTIANO','2020-06-16',1020,'',0,NULL),
	(128,'2020-06-22','08:30:00','SCOPAZZO FILIPPO','2020-06-16',1020,'',0,NULL),
	(129,'2020-06-22','09:00:00','ZAFARANA SEBASTIANO','1947-04-17',1020,'',0,NULL),
	(130,'2020-06-22','08:00:00','MESSINA SALVATORE','2020-06-16',1021,'',0,NULL),
	(131,'2020-06-22','08:05:00','GIGANTE ANNA ASSUNTA','2020-06-16',1021,'',0,NULL),
	(132,'2020-06-22','08:10:00','PASTANELLA CARMELO','2020-06-16',1021,'',0,NULL),
	(133,'2020-06-22','08:15:00','PENNISI SALVATORE','2020-06-16',1021,'',0,NULL),
	(134,'2020-06-22','08:20:00','GULINO MARIA','1949-01-23',1021,'',0,NULL),
	(135,'2020-06-22','08:25:00','VISICARO CRISTINA','1976-07-24',1021,'',0,NULL),
	(136,'2020-06-22','08:30:00','FERRO LUIGI PINO','2020-06-16',1021,'',0,NULL),
	(137,'2020-06-22','08:35:00','VISICARO CRISTINA','1976-07-24',1021,'',0,1),
	(138,'2020-06-22','08:40:00','LOPES GUGLIELMO','1962-12-19',1021,'',0,NULL),
	(139,'2020-06-22','08:45:00','NOTO FRANCESCO','1975-07-21',1021,'',0,NULL),
	(140,'2020-06-22','08:00:00','DI GREGORIO NATALIA','2020-06-16',1022,'',0,NULL),
	(141,'2020-06-22','08:05:00','RUSSO ROSARIA','2020-06-16',1022,'',0,NULL),
	(142,'2020-06-22','08:10:00','CANNIZZARO ANNA MARIA','2020-06-16',1022,'',0,1),
	(143,'2020-06-22','08:15:00','PERNA CARMEN','2020-06-16',1022,'',0,NULL),
	(144,'2020-06-22','08:00:00','CASERTA MARIA','2020-06-16',1023,'',0,NULL),
	(145,'2020-06-22','08:05:00','DI GREGORIO AGATA','2020-06-16',1023,'',0,NULL),
	(146,'2020-06-22','08:10:00','QUATTROCCHI STEFANO','2020-06-16',1023,'',0,NULL),
	(147,'2020-06-22','08:15:00','CONTRAFATTO MARCELLA','2020-06-16',1023,'',0,NULL),
	(148,'2020-06-22','08:20:00','CARAMBIA ANTONINO','2020-06-16',1023,'',0,NULL),
	(149,'2020-06-22','08:25:00','MAZZEO GIUSEPPA','2020-06-16',1023,'',0,NULL),
	(150,'2020-06-22','08:30:00','DELUCA GIOVANNI','2020-06-16',1023,'',0,NULL),
	(151,'2020-06-22','08:35:00','FALLICO ANNA','2020-06-16',1023,'',0,NULL),
	(152,'2020-06-22','08:40:00','CAUDULLO ARMANDO','2020-06-16',1023,'',0,NULL),
	(153,'2020-06-22','08:45:00','CASTIGLIA MARIA','2020-06-16',1023,'',0,NULL),
	(154,'2020-06-22','08:50:00','CACCAMO BARBARA','2020-06-16',1023,'',0,NULL),
	(155,'2020-06-22','08:55:00','CASCONE LINA','2020-06-16',1023,'',0,NULL),
	(156,'2020-06-22','09:00:00','MARCHESE MARIA','2020-06-16',1023,'',0,NULL),
	(157,'2020-06-22','09:05:00','RAPISARSA MARIA','2020-06-16',1023,'',0,NULL),
	(158,'2020-06-22','09:10:00','LONGO DONATELLA ELVIRA','2020-06-16',1023,'',0,NULL),
	(159,'2020-06-22','09:15:00','FRONTINI MATILDE','2020-06-16',1023,'',0,NULL),
	(160,'2020-06-22','09:20:00','RUTA ROSA','2020-06-16',1023,'',0,NULL),
	(161,'2020-06-22','09:25:00','MALATINO FILIPPO','2020-06-16',1023,'',0,NULL),
	(162,'2020-06-22','09:30:00','CULTRERA SEBASTIANA','2020-06-16',1023,'',0,NULL),
	(163,'2020-06-22','09:35:00','SQUATRITO FILIPPA','2020-06-16',1023,'',0,NULL),
	(164,'2020-06-22','09:40:00','RAGUSA SANTINA','2020-06-16',1023,'',0,NULL),
	(165,'2020-06-22','09:45:00','LUPO GAETANO','2020-06-16',1023,'',0,NULL),
	(166,'2020-06-22','17:15:00','un paziente','2020-06-29',166,'BLANCO GIUSY',1,1),
	(167,'2020-06-22','13:15:00','cds<','2020-06-23',107,NULL,1,0),
	(168,'2020-06-22','17:15:00','un paziente','2020-06-16',701,'COPPOLINO SINIBALDO',1,1),
	(169,'2020-06-22','10:15:00','un paziente','2020-06-29',89,NULL,1,0),
	(170,'2020-06-22','19:30:00','un paziente','2020-06-30',145,'GIUFFRIDA (POMERIGGIO)',1,1),
	(171,'2020-06-22','15:15:00','VFDZV','2020-06-23',81,NULL,1,0),
	(172,'2020-06-22','19:30:00','CDS<','2020-06-16',100,NULL,1,0),
	(173,'2020-06-22','16:15:00','LLL','2020-06-29',79,NULL,1,0),
	(174,'2020-06-22','15:15:00','DS<','2020-06-29',801,NULL,1,0);



# Dump of table ec_prenotazioni_ricoveri
# ------------------------------------------------------------


CREATE TABLE `ec_prenotazioni_ricoveri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data` date DEFAULT NULL,
  `ora` time DEFAULT NULL,
  `nome_paziente` varchar(45) DEFAULT NULL,
  `data_nascita` date DEFAULT NULL,
  `regime` varchar(35) DEFAULT NULL,
  `reparto` varchar(35) DEFAULT NULL,
  `id_medico` int(11) DEFAULT NULL,
  `fuorilista` int(11) DEFAULT '0',
  `accettato` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `ec_prenotazioni_ricoveri` (`id`, `data`, `ora`, `nome_paziente`, `data_nascita`, `regime`, `reparto`, `id_medico`, `fuorilista`, `accettato`)
VALUES
	(1,'2020-06-22','00:00:00','GAMUZZA LORENZO','1954-01-02','3','6401',NULL,0,'1'),
	(2,'2020-06-22','08:00:00','GIARDINA CONCETTA','1966-01-31','1','6404',NULL,0,NULL),
	(3,'2020-06-22','00:00:00','SPARTA\' FRANCESCA','1949-03-23','1','6411',NULL,0,NULL),
	(4,'2020-06-22','00:00:00','DI PIETRO MARIA CONCETTA','1975-12-07','2','0201',NULL,0,NULL),
	(5,'2020-06-22','00:00:00','AURNIA GIOVANNA','1980-08-01','1','6401',NULL,0,'1'),
	(6,'2020-06-22','00:00:00','GIORDANO SIMONETTA','1968-05-27','1','6401',NULL,0,'1'),
	(7,'2020-06-22','00:00:00','RAMETTA CORRADINA','1943-02-14','1','6411',NULL,0,NULL),
	(8,'2020-06-22','00:00:00','PENNISI GIANCARLO','1953-06-24','1','6433',NULL,0,NULL),
	(9,'2020-06-22','00:00:00','MARLETTA ANNA','1958-09-25','1','6401',NULL,0,'1'),
	(10,'2020-06-22','08:00:00','DI MARIA PIETRO','1947-01-29','1','6400',NULL,0,NULL),
	(11,'2020-06-22','00:00:00','GIGLIO MARIANNA','1956-02-10','1','6401',NULL,0,NULL),
	(12,'2020-06-22','08:15:00','un paziente',NULL,'','boh',0,1,'1');



# Dump of table ec_prestazione_ambulatorio
# ------------------------------------------------------------


CREATE TABLE `ec_prestazione_ambulatorio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_accettazione` int(11) NOT NULL,
  `codice_agenda` int(11) DEFAULT NULL,
  `id_infermiere` int(11) NOT NULL,
  `id_medico` int(11) DEFAULT NULL,
  `id_utente` int(11) DEFAULT NULL,
  `cod_prestazione` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `data` date NOT NULL,
  `inizio_prestazione` time DEFAULT NULL,
  `fine_prestazione` time DEFAULT NULL,
  `ora_presenza` time DEFAULT NULL,
  `ora_presa_carico` time DEFAULT NULL,
  `modalita` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `ec_prestazione_ambulatorio` (`id`, `id_accettazione`, `codice_agenda`, `id_infermiere`, `id_medico`, `id_utente`, `cod_prestazione`, `status`, `data`, `inizio_prestazione`, `fine_prestazione`, `ora_presenza`, `ora_presa_carico`, `modalita`)
VALUES
	(1,1,145,0,145,29,2,13,'2020-06-22','10:39:55','10:40:00','10:39:53','10:39:38','1'),
	(2,2,166,0,166,9,1,13,'2020-06-22','10:43:55','10:44:00','10:43:53','10:43:45','1'),
	(3,3,145,0,145,29,4,13,'2020-06-22','10:43:08','10:43:11','10:42:59','10:42:49','1'),
	(4,4,145,0,145,29,7,13,'2020-06-22','11:59:43','12:00:09','11:59:39','11:58:42','1'),
	(5,9,145,0,145,NULL,8,1,'2020-06-22',NULL,NULL,NULL,NULL,'1'),
	(6,10,701,0,701,17,3,13,'2020-06-22','11:41:47','11:41:50','11:41:34','11:41:26','1'),
	(7,11,145,0,145,NULL,20,1,'2020-06-22',NULL,NULL,NULL,NULL,'1'),
	(8,12,701,0,701,17,2,13,'2020-06-22','11:38:26','11:38:31','11:38:21','11:38:16','1'),
	(9,13,701,0,701,17,1,13,'2020-06-22','11:37:40','11:37:44','11:37:31','11:36:39','1'),
	(10,14,145,0,145,29,5,13,'2020-06-22','11:43:39','11:44:08','11:43:22','11:43:10','1'),
	(11,15,346,0,346,15,2,13,'2020-06-22','11:31:57','11:31:59','11:31:55','11:31:37','1'),
	(12,20,641,0,351,66,4,13,'2020-06-22','12:27:45','12:27:47','12:27:43','12:27:41','1'),
	(13,21,1005,0,351,NULL,3,1,'2020-06-22',NULL,NULL,NULL,NULL,'1'),
	(14,22,333,0,333,NULL,5,1,'2020-06-22',NULL,NULL,NULL,NULL,'1'),
	(15,23,1021,0,351,NULL,8,1,'2020-06-22',NULL,NULL,NULL,NULL,'1'),
	(16,24,1022,0,351,NULL,3,1,'2020-06-22',NULL,NULL,NULL,NULL,'1'),
	(17,25,1005,0,386,NULL,1,1,'2020-06-22',NULL,NULL,NULL,NULL,'1');



# Dump of table ec_prestazione_day_hospital
# ------------------------------------------------------------


CREATE TABLE `ec_prestazione_day_hospital` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_accettazione` int(11) NOT NULL,
  `id_infermiere` int(11) NOT NULL,
  `id_medico` int(11) NOT NULL,
  `data` date NOT NULL,
  `inizio_prelievo` time DEFAULT NULL,
  `fine_prelievo` time DEFAULT NULL,
  `status` int(11) NOT NULL,
  `cod_prestazione` int(11) DEFAULT NULL,
  `inizio_prestazione` time DEFAULT NULL,
  `fine_prestazione` time DEFAULT NULL,
  `ora_presa_carico` time DEFAULT NULL,
  `modalita` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `ec_prestazione_day_hospital` (`id`, `id_accettazione`, `id_infermiere`, `id_medico`, `data`, `inizio_prelievo`, `fine_prelievo`, `status`, `cod_prestazione`, `inizio_prestazione`, `fine_prestazione`, `ora_presa_carico`, `modalita`)
VALUES
	(1,16,1,29,'2020-06-22','11:49:13','11:49:17',18,4,'11:58:19','11:59:53',NULL,'3'),
	(2,17,1,29,'2020-06-22','11:50:49','11:51:08',18,1,'11:56:18','11:57:06',NULL,'3'),
	(3,18,1,0,'2020-06-22','11:52:53',NULL,15,2,NULL,NULL,NULL,'3');



# Dump of table ec_prestazione_ricovero
# ------------------------------------------------------------


CREATE TABLE `ec_prestazione_ricovero` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_accettazione` int(11) NOT NULL,
  `id_infermiere` int(11) NOT NULL,
  `cod_prestazione` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `data` date NOT NULL,
  `inizio_prestazione` time DEFAULT NULL,
  `fine_prestazione` time DEFAULT NULL,
  `ora_presa_carico` time DEFAULT NULL,
  `modalita` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `ec_prestazione_ricovero` (`id`, `id_accettazione`, `id_infermiere`, `cod_prestazione`, `status`, `data`, `inizio_prestazione`, `fine_prestazione`, `ora_presa_carico`, `modalita`)
VALUES
	(1,5,1,5,13,'2020-06-22','11:15:47','11:15:56','11:14:43','2'),
	(2,6,1,2,13,'2020-06-22','11:13:05','11:14:07','11:10:49','2'),
	(3,7,0,12,1,'2020-06-22',NULL,NULL,NULL,'2'),
	(4,8,1,7,13,'2020-06-22','11:16:35','11:16:48','11:16:04','2'),
	(5,19,0,1,1,'2020-06-22',NULL,NULL,NULL,'2');



# Dump of table ec_programma_agenda
# ------------------------------------------------------------


CREATE TABLE `ec_programma_agenda` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `giorno` varchar(35) NOT NULL,
  `am_inizio` time NOT NULL,
  `am_fine` time NOT NULL,
  `am_freq` int(11) NOT NULL,
  `pm_inizio` time NOT NULL,
  `pm_fine` time NOT NULL,
  `pm_freq` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



# Dump of table ec_programma_modalita
# ------------------------------------------------------------


CREATE TABLE `ec_programma_modalita` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_utente` int(11) NOT NULL,
  `id_modalita` int(11) NOT NULL,
  `data_inizio` datetime NOT NULL,
  `data_fine` datetime NOT NULL,
  `creato_da` int(11) NOT NULL,
  `modificato_da` int(11) NOT NULL,
  `data_creazione` datetime NOT NULL,
  `data_modifica` datetime NOT NULL,
  `eliminato` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `ec_programma_modalita` (`id`, `id_utente`, `id_modalita`, `data_inizio`, `data_fine`, `creato_da`, `modificato_da`, `data_creazione`, `data_modifica`, `eliminato`)
VALUES
	(16,3,4,'2014-10-26 16:28:00','2014-12-31 16:28:00',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),
	(14,3,1,'2014-10-15 16:28:00','2015-03-12 16:28:00',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),
	(15,3,2,'2014-07-09 16:28:00','2015-06-12 16:28:00',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),
	(7,4,1,'2014-05-01 16:27:09','2015-04-24 16:37:00',0,1,'0000-00-00 00:00:00','2014-12-04 16:32:37',0),
	(8,4,2,'2014-05-01 16:27:20','2015-04-21 16:37:00',0,1,'0000-00-00 00:00:00','2014-12-04 16:32:50',0),
	(12,83,2,'2014-09-04 18:33:00','2015-01-08 18:33:00',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),
	(13,83,1,'2015-06-29 13:44:00','2016-01-07 13:43:00',0,1,'0000-00-00 00:00:00','2015-07-03 13:44:29',0),
	(17,4,4,'2014-08-29 16:23:00','2015-03-05 16:23:00',1,0,'2014-12-04 16:18:44','0000-00-00 00:00:00',0),
	(18,1,1,'2015-03-04 16:53:00','2023-06-14 10:33:00',1,1,'2015-03-04 16:53:31','2020-06-22 10:33:44',0),
	(19,1,2,'2015-03-04 16:53:00','2024-06-12 10:34:00',1,1,'2015-03-04 16:53:54','2020-06-22 10:34:08',0),
	(20,1,4,'2015-03-04 16:54:00','2025-06-18 10:34:00',1,1,'2015-03-04 16:54:14','2020-06-22 10:34:18',0),
	(21,87,1,'2015-03-23 18:13:00','2016-05-23 18:00:00',1,0,'2015-03-23 18:14:24','0000-00-00 00:00:00',0),
	(22,87,2,'2015-03-23 18:14:00','2016-03-23 18:14:00',1,1,'2015-03-23 18:14:50','2015-03-23 18:15:06',0),
	(23,87,4,'2015-03-23 18:00:00','2016-03-23 18:00:00',1,0,'2015-03-23 18:15:28','0000-00-00 00:00:00',0),
	(24,89,1,'2015-03-23 18:00:00','2026-03-23 19:00:00',1,1,'2015-03-23 18:16:08','2016-03-25 14:15:31',0),
	(25,89,4,'2015-03-23 18:00:00','2026-03-23 19:00:00',1,1,'2015-03-23 18:16:35','2016-03-25 14:16:15',0),
	(26,92,2,'2015-03-23 18:00:00','2026-03-23 19:00:00',1,1,'2015-03-23 18:21:24','2016-03-25 14:17:48',0),
	(27,90,2,'2015-03-23 18:00:00','2026-03-23 14:14:00',1,1,'2015-03-23 18:22:47','2016-03-25 14:18:57',0),
	(28,94,1,'2015-03-23 18:00:00','2026-03-25 19:00:00',1,1,'2015-03-23 18:25:31','2016-03-25 14:19:53',0),
	(29,94,2,'2015-03-23 18:00:00','2026-03-25 19:00:00',1,1,'2015-03-23 18:25:52','2016-03-25 14:20:29',0),
	(30,94,4,'2015-03-23 18:00:00','2026-03-25 19:00:00',1,1,'2015-03-23 18:26:13','2016-03-25 14:20:07',0),
	(31,88,1,'2015-03-23 18:00:00','2016-03-23 18:00:00',1,0,'2015-03-23 18:29:19','0000-00-00 00:00:00',0),
	(32,88,4,'2015-03-23 18:00:00','2016-03-23 18:00:00',1,0,'2015-03-23 18:30:20','0000-00-00 00:00:00',0),
	(33,93,1,'2015-03-23 18:00:00','2026-03-30 10:00:00',1,1,'2015-03-23 18:31:23','2016-03-30 10:33:09',0),
	(34,93,4,'2015-03-23 18:00:00','2016-03-30 19:00:00',1,1,'2015-03-23 18:31:42','2016-03-30 10:34:05',0),
	(35,91,2,'2015-03-24 11:00:00','2026-03-24 19:00:00',1,1,'2015-03-25 11:07:22','2016-03-25 14:17:08',0),
	(36,96,1,'2015-07-29 16:43:00','2015-12-31 19:00:00',1,1,'2015-07-29 16:42:32','2015-07-29 16:44:24',0),
	(37,93,2,'2015-07-31 13:00:00','2015-07-31 14:00:00',1,0,'2015-07-31 13:54:13','0000-00-00 00:00:00',0),
	(38,97,1,'2015-09-01 12:48:00','2015-09-29 14:18:00',1,1,'2015-09-02 12:47:41','2015-09-29 14:19:41',0),
	(39,1,3,'2015-09-02 14:00:00','2024-06-19 10:33:00',1,1,'2015-09-02 14:12:08','2020-06-22 10:33:55',0),
	(40,29,3,'2015-09-07 09:00:00','2021-12-31 18:00:00',1,1,'2015-09-07 09:50:21','2017-09-07 11:40:41',0),
	(41,74,3,'2015-09-07 09:00:00','2016-09-07 19:00:00',1,0,'2015-09-07 09:51:40','0000-00-00 00:00:00',0),
	(42,6,3,'2015-09-07 09:00:00','2016-09-07 19:00:00',1,0,'2015-09-07 09:52:54','0000-00-00 00:00:00',0),
	(43,9,3,'2015-09-07 09:00:00','2016-09-07 19:00:00',1,0,'2015-09-07 10:21:29','0000-00-00 00:00:00',0),
	(44,98,3,'2015-09-07 14:00:00','2020-09-07 19:00:00',1,1,'2015-09-07 14:42:51','2016-09-08 09:47:29',0),
	(45,31,3,'2015-09-09 18:00:00','2016-09-10 21:00:00',1,0,'2015-09-10 18:18:31','0000-00-00 00:00:00',0),
	(46,50,3,'2015-09-09 18:18:00','2015-09-10 18:18:00',1,0,'2015-09-10 18:20:02','0000-00-00 00:00:00',0),
	(47,61,3,'2015-09-09 18:00:00','2016-09-10 22:00:00',1,0,'2015-09-10 18:20:51','0000-00-00 00:00:00',0),
	(48,46,3,'2015-09-09 18:00:00','2015-09-10 18:20:00',1,0,'2015-09-10 18:21:43','0000-00-00 00:00:00',0),
	(49,99,3,'2015-09-09 18:52:00','2015-09-10 23:00:00',1,0,'2015-09-10 18:54:16','0000-00-00 00:00:00',0),
	(50,99,1,'2015-09-10 09:34:00','2016-09-11 20:00:00',1,1,'2015-09-11 09:35:51','2015-09-11 09:37:40',0),
	(51,97,4,'2015-09-29 14:18:00','2017-12-31 20:00:00',1,1,'2015-09-29 14:20:06','2017-01-09 12:46:04',0),
	(52,101,1,'2017-04-19 08:49:00','2022-12-31 22:00:00',1,1,'2017-04-20 08:50:42','2018-07-03 08:53:24',0),
	(53,102,1,'2017-10-02 13:54:00','2020-12-31 13:54:00',1,0,'2017-10-03 13:54:04','0000-00-00 00:00:00',0),
	(54,102,4,'2017-10-02 13:54:00','2020-12-31 13:54:00',1,0,'2017-10-03 13:54:24','0000-00-00 00:00:00',0),
	(55,103,1,'2018-02-14 14:23:00','2020-12-31 19:00:00',1,1,'2018-02-15 14:24:33','2018-02-15 14:25:28',0),
	(56,103,4,'2018-02-14 14:23:00','2020-12-31 19:00:00',1,0,'2018-02-15 14:25:14','0000-00-00 00:00:00',0),
	(57,100,1,'2019-11-14 13:04:00','2021-01-31 18:00:00',1,0,'2019-11-14 13:04:57','0000-00-00 00:00:00',0),
	(67,106,4,'2020-03-11 10:00:00','2020-12-11 17:00:00',1,1,'2020-03-11 11:29:22','2020-03-11 11:30:47',0),
	(59,66,1,'2019-11-15 08:55:00','2025-12-31 21:00:00',1,0,'2019-11-15 08:56:42','0000-00-00 00:00:00',0),
	(60,79,1,'2019-11-15 09:00:00','2025-12-31 21:00:00',1,0,'2019-11-15 08:58:11','0000-00-00 00:00:00',0),
	(61,78,1,'2019-11-15 09:00:00','2025-12-15 20:00:00',1,0,'2019-11-15 09:03:44','0000-00-00 00:00:00',0),
	(62,18,1,'2019-11-15 09:00:00','2025-12-15 21:00:00',1,0,'2019-11-15 09:05:17','0000-00-00 00:00:00',0),
	(63,105,1,'2019-11-15 09:00:00','2025-12-15 21:00:00',1,0,'2019-11-15 09:08:02','0000-00-00 00:00:00',0),
	(65,11,1,'2019-11-17 10:47:00','2025-12-31 16:00:00',1,0,'2019-11-18 10:48:26','0000-00-00 00:00:00',0);



# Dump of table ec_rss
# ------------------------------------------------------------


CREATE TABLE `ec_rss` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titolo` varchar(45) NOT NULL,
  `canale` varchar(255) NOT NULL,
  `creato_da` int(11) NOT NULL,
  `modificato_da` int(11) NOT NULL,
  `data_creazione` datetime NOT NULL,
  `data_modifica` datetime NOT NULL,
  `eliminato` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `ec_rss` (`id`, `titolo`, `canale`, `creato_da`, `modificato_da`, `data_creazione`, `data_modifica`, `eliminato`)
VALUES
	(4,'Sport Google','http://xml.corriereobjects.it/rss/spettacoli.xml',84,84,'2014-08-01 18:34:57','2014-11-18 12:45:11',1),
	(5,'Rss Libero','http://libero-news.it.feedsportal.com/c/34068/f/618096/index.rss',1,0,'2015-03-23 15:15:13','0000-00-00 00:00:00',0),
	(6,'Live Sicilia catania','http://feeds.feedburner.com/UltimeNotizie-LiveSiciliaCatania',84,0,'2018-01-19 13:19:17','0000-00-00 00:00:00',0);



# Dump of table ec_ruoli
# ------------------------------------------------------------


CREATE TABLE `ec_ruoli` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ruolo` varchar(30) NOT NULL,
  `parent_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `ec_ruoli` (`id`, `ruolo`, `parent_id`)
VALUES
	(1,'super-amministratore',0),
	(2,'amministratore',0),
	(3,'operatore',0),
	(4,'infermiere',0),
	(5,'medico',0),
	(6,'comunicazione',0);



# Dump of table ec_servizi
# ------------------------------------------------------------


CREATE TABLE `ec_servizi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_servizio_HTSAN` int(11) DEFAULT NULL,
  `nome_servizio` varchar(35) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `ec_servizi` (`id`, `id_servizio_HTSAN`, `nome_servizio`)
VALUES
	(1,2,'DAY HOSPITAL'),
	(2,201,'DAY SURGERY'),
	(3,203,'UROLOGIA D.H.'),
	(4,204,'ONCOEMATOLOGIA D.H.'),
	(5,3,'ANATOMIA PATOLOGICA'),
	(6,5,'ANGIOLOGIA'),
	(7,8,'CARDIOLOGIA'),
	(8,120,'IORT'),
	(9,18,'EMOTRASFUSIONE'),
	(10,30,'NEUROCHIRURGIA'),
	(11,34,'OCULISTICA'),
	(12,38,'OTORINOLARINGOIATRIA'),
	(13,3801,'MICROCHIRURGIA ORL'),
	(14,43,'UROLOGIA'),
	(15,4301,'LITOTRISSIA'),
	(16,49,'TERAPIA INTENSIVA'),
	(17,50,'ANESTESIA/TERAP.ANTALGICA AMB.'),
	(18,56,'RECUPERO E RIABILITAZIONE'),
	(19,58,'ENDOSCOPIA'),
	(20,59,'GINECOLOGIA'),
	(21,61,'MEDICINA NUCLEARE'),
	(22,63,'ECOGRAFIA'),
	(23,631,'ECOGRAFIA DR.RIZZO'),
	(24,64,'ONCOLOGIA AMBUL.'),
	(25,6400,'ONCOLOGIA MEDICA'),
	(26,6401,'CHIRURGIA ONCOLOGICA'),
	(27,6402,'RADIOTERAPIA'),
	(28,6403,'TERAPIA ANTALGICA'),
	(29,6404,'ONCOEMATOLOGIA'),
	(30,6405,'TMO'),
	(31,6406,'CHIRURGIA TORACICA'),
	(32,6410,'CHIRURGIA ONCOLOGICA AMB.'),
	(33,6411,'BREAST UNIT'),
	(34,6433,'CURE PALLIATIVE'),
	(35,65,'TAC'),
	(36,66,'ONCOEMATOLOGIA AMBULAT./REF.'),
	(37,67,'RMN'),
	(38,68,'PNEUMOLOGIA'),
	(39,69,'RADIOLOGIA'),
	(40,6901,'RADIOLOGIA INTERVENTISTICA'),
	(41,70,'LABORATORIO ANALISI'),
	(42,7001,'CITOFLUORIMETRIA'),
	(43,75,'DERMATOLOGIA'),
	(44,76,'ORTOPEDIA ONCOLOGICA'),
	(45,90,'AMMINISTRAZIONE'),
	(46,901,'AMBULATORI'),
	(47,902,'SERVIZIO DIAGNOSTICA DH ONCOL.'),
	(48,91,'CUCINA'),
	(49,94,'PSICOLOGIA'),
	(50,95,'SERVIZIO SOCIALE'),
	(51,96,'SCREENING POLMONE'),
	(52,97,'SCREENING TIROIDEO');



# Dump of table ec_slideshow
# ------------------------------------------------------------


CREATE TABLE `ec_slideshow` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `filename` varchar(255) NOT NULL,
  `filetype` varchar(45) NOT NULL,
  `active` int(1) NOT NULL,
  `sorting` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Dump of table ec_status
# ------------------------------------------------------------


CREATE TABLE `ec_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome_status` varchar(35) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `ec_status` (`id`, `nome_status`)
VALUES
	(1,'Attivo'),
	(2,'Non Attivo'),
	(3,'Stampato'),
	(4,'Chiamata'),
	(5,'Presente'),
	(6,'Assente'),
	(7,'Chiuso');



# Dump of table ec_ticket_totem
# ------------------------------------------------------------


CREATE TABLE `ec_ticket_totem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_modalita` int(11) NOT NULL,
  `data` datetime NOT NULL,
  `contatore_locale` int(11) NOT NULL,
  `contatore_globale` int(11) NOT NULL,
  `codice_ticket` varchar(36) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_modalita` (`id_modalita`),
  KEY `contatore_locale` (`contatore_locale`),
  KEY `data` (`data`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `ec_ticket_totem` (`id`, `id_modalita`, `data`, `contatore_locale`, `contatore_globale`, `codice_ticket`)
VALUES
	(1,1,'2020-06-22 10:36:30',1,1,'A0001'),
	(2,1,'2020-06-22 10:36:31',2,2,'A0002'),
	(3,1,'2020-06-22 10:38:39',3,3,'A0003'),
	(4,1,'2020-06-22 10:38:40',4,4,'A0004'),
	(5,1,'2020-06-22 10:38:42',5,5,'A0005'),
	(6,2,'2020-06-22 10:44:59',1,6,'R0001'),
	(7,2,'2020-06-22 10:45:00',2,7,'R0002'),
	(8,2,'2020-06-22 10:45:02',3,8,'R0003'),
	(9,2,'2020-06-22 10:51:09',4,9,'R0004'),
	(10,2,'2020-06-22 10:51:10',5,10,'R0005'),
	(11,3,'2020-06-22 11:09:23',1,11,'D0001'),
	(12,3,'2020-06-22 11:09:25',2,12,'D0002'),
	(13,1,'2020-06-22 11:19:18',6,13,'A0006'),
	(14,1,'2020-06-22 11:27:05',7,14,'A0007'),
	(15,1,'2020-06-22 11:27:07',8,15,'A0008'),
	(16,1,'2020-06-22 11:27:08',9,16,'A0009'),
	(17,1,'2020-06-22 11:27:10',10,17,'A0010'),
	(18,3,'2020-06-22 11:47:06',3,18,'D0003'),
	(19,3,'2020-06-22 11:47:16',4,19,'D0004'),
	(20,4,'2020-06-22 12:03:39',1,20,'T0001'),
	(21,4,'2020-06-22 12:03:40',2,21,'T0002'),
	(22,4,'2020-06-22 12:03:42',3,22,'T0003'),
	(23,1,'2020-06-22 12:29:49',11,23,'A0011'),
	(24,1,'2020-06-22 12:29:50',12,24,'A0012'),
	(25,1,'2020-06-22 12:29:51',13,25,'A0013'),
	(26,1,'2020-06-22 12:29:52',14,26,'A0014'),
	(27,1,'2020-07-09 09:46:43',1,1,'A0001'),
	(28,1,'2020-07-09 09:46:45',2,2,'A0002');



# Dump of table ec_totem_configurazione
# ------------------------------------------------------------


CREATE TABLE `ec_totem_configurazione` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codice` int(11) NOT NULL,
  `nome` varchar(45) NOT NULL,
  `modalita` int(1) NOT NULL DEFAULT '0',
  `stato` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `ec_totem_configurazione` (`id`, `codice`, `nome`, `modalita`, `stato`)
VALUES
	(1,1,'Ambulatorio',1,1),
	(2,2,'Ricovero',1,1),
	(3,3,'Day Hospital',1,1),
	(4,4,'Triage Informazioni',1,1),
	(5,2,'DAY HOSPITAL',0,0),
	(6,201,'DAY SURGERY',0,0),
	(7,203,'UROLOGIA D.H.',0,0),
	(8,204,'ONCOEMATOLOGIA D.H.',0,0),
	(9,3,'ANATOMIA PATOLOGICA',0,0),
	(10,5,'ANGIOLOGIA',0,0),
	(11,8,'CARDIOLOGIA',0,0),
	(12,120,'IORT',0,0),
	(13,18,'EMOTRASFUSIONE',0,0),
	(14,30,'NEUROCHIRURGIA',0,0),
	(15,34,'OCULISTICA',0,0),
	(16,38,'OTORINOLARINGOIATRIA',0,0),
	(17,3801,'MICROCHIRURGIA ORL',0,0),
	(18,43,'UROLOGIA',0,0),
	(19,4301,'LITOTRISSIA',0,0),
	(20,49,'TERAPIA INTENSIVA',0,0),
	(21,50,'ANESTESIA/TERAP.ANTALGICA AMB.',0,0),
	(22,56,'RECUPERO E RIABILITAZIONE',0,0),
	(23,58,'ENDOSCOPIA',0,0),
	(24,59,'GINECOLOGIA',0,0),
	(25,61,'MEDICINA NUCLEARE',0,0),
	(26,63,'ECOGRAFIA',0,0),
	(27,631,'ECOGRAFIA DR.RIZZO',0,0),
	(28,64,'ONCOLOGIA AMBUL.',0,0),
	(29,6400,'ONCOLOGIA MEDICA',0,0),
	(30,6401,'CHIRURGIA ONCOLOGICA',0,0),
	(31,6402,'RADIOTERAPIA',0,0),
	(32,6403,'TERAPIA ANTALGICA',0,0),
	(33,6404,'ONCOEMATOLOGIA',0,0),
	(34,6405,'TMO',0,0),
	(35,6406,'CHIRURGIA TORACICA',0,0),
	(36,6410,'CHIRURGIA ONCOLOGICA AMB.',0,0),
	(37,6411,'BREAST UNIT',0,0),
	(38,6433,'CURE PALLIATIVE',0,0),
	(39,65,'TAC',0,0),
	(40,66,'ONCOEMATOLOGIA AMBULAT./REF.',0,0),
	(41,67,'RMN',0,0),
	(42,68,'PNEUMOLOGIA',0,0),
	(43,69,'RADIOLOGIA',0,0),
	(44,6901,'RADIOLOGIA INTERVENTISTICA',0,0),
	(45,70,'LABORATORIO ANALISI',0,0),
	(46,7001,'CITOFLUORIMETRIA',0,0),
	(47,75,'DERMATOLOGIA',0,0),
	(48,76,'ORTOPEDIA ONCOLOGICA',0,0),
	(49,90,'AMMINISTRAZIONE',0,0),
	(50,901,'AMBULATORI',0,0),
	(51,902,'SERVIZIO DIAGNOSTICA DH ONCOL.',0,0),
	(52,91,'CUCINA',0,0),
	(53,94,'PSICOLOGIA',0,0),
	(54,95,'SERVIZIO SOCIALE',0,0),
	(55,96,'SCREENING POLMONE',0,0),
	(56,97,'SCREENING TIROIDEO',0,0);



# Dump of table ec_tracking_operatore
# ------------------------------------------------------------


CREATE TABLE `ec_tracking_operatore` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_operatore` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `data` date NOT NULL,
  `ora` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `ec_tracking_operatore` (`id`, `id_operatore`, `status`, `data`, `ora`)
VALUES
	(1,1,8,'2020-06-22','10:44:51'),
	(2,1,8,'2020-06-22','11:46:38'),
	(3,1,8,'2020-06-22','12:03:22'),
	(4,1,8,'2020-06-22','12:28:41'),
	(5,1,8,'2020-06-22','12:32:00'),
	(6,1,8,'2020-07-09','09:46:02');



# Dump of table ec_tracking_status_ticket
# ------------------------------------------------------------


CREATE TABLE `ec_tracking_status_ticket` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ticket_id` int(11) NOT NULL,
  `utente_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `data` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `ec_tracking_status_ticket` (`id`, `ticket_id`, `utente_id`, `status`, `data`)
VALUES
	(1,1,0,3,'2020-06-22 10:36:30'),
	(2,2,0,3,'2020-06-22 10:36:31'),
	(3,1,1,4,'2020-06-22 10:36:37'),
	(4,1,1,5,'2020-06-22 10:36:39'),
	(5,1,1,7,'2020-06-22 10:36:47'),
	(6,1,1,19,'2020-06-22 10:36:52'),
	(7,1,1,7,'2020-06-22 10:37:10'),
	(8,2,1,4,'2020-06-22 10:37:50'),
	(9,2,1,5,'2020-06-22 10:37:56'),
	(10,2,1,7,'2020-06-22 10:38:12'),
	(11,3,0,3,'2020-06-22 10:38:39'),
	(12,4,0,3,'2020-06-22 10:38:40'),
	(13,5,0,3,'2020-06-22 10:38:42'),
	(14,3,1,4,'2020-06-22 10:38:47'),
	(15,3,1,5,'2020-06-22 10:38:50'),
	(16,3,1,7,'2020-06-22 10:39:01'),
	(17,6,0,3,'2020-06-22 10:44:59'),
	(18,7,0,3,'2020-06-22 10:45:00'),
	(19,8,0,3,'2020-06-22 10:45:02'),
	(20,6,1,4,'2020-06-22 10:45:40'),
	(21,6,1,5,'2020-06-22 10:50:45'),
	(22,6,1,7,'2020-06-22 10:50:53'),
	(23,9,0,3,'2020-06-22 10:51:09'),
	(24,10,0,3,'2020-06-22 10:51:10'),
	(25,7,1,4,'2020-06-22 10:53:45'),
	(26,7,1,5,'2020-06-22 10:54:01'),
	(27,7,1,7,'2020-06-22 10:55:17'),
	(28,8,1,4,'2020-06-22 10:59:57'),
	(29,8,1,5,'2020-06-22 10:59:59'),
	(30,8,1,7,'2020-06-22 11:01:21'),
	(31,9,1,4,'2020-06-22 11:01:38'),
	(32,9,1,6,'2020-06-22 11:02:03'),
	(33,9,1,5,'2020-06-22 11:03:22'),
	(34,9,1,7,'2020-06-22 11:03:30'),
	(35,11,0,3,'2020-06-22 11:09:23'),
	(36,12,0,3,'2020-06-22 11:09:25'),
	(37,13,0,3,'2020-06-22 11:19:18'),
	(38,4,1,4,'2020-06-22 11:20:12'),
	(39,4,1,5,'2020-06-22 11:20:37'),
	(40,4,1,7,'2020-06-22 11:21:26'),
	(41,5,1,4,'2020-06-22 11:22:21'),
	(42,5,1,5,'2020-06-22 11:22:24'),
	(43,5,1,7,'2020-06-22 11:24:19'),
	(44,13,1,4,'2020-06-22 11:24:49'),
	(45,13,1,5,'2020-06-22 11:25:01'),
	(46,13,1,7,'2020-06-22 11:26:12'),
	(47,14,0,3,'2020-06-22 11:27:05'),
	(48,15,0,3,'2020-06-22 11:27:07'),
	(49,16,0,3,'2020-06-22 11:27:08'),
	(50,17,0,3,'2020-06-22 11:27:10'),
	(51,14,1,4,'2020-06-22 11:27:17'),
	(52,14,1,6,'2020-06-22 11:27:26'),
	(53,14,1,5,'2020-06-22 11:27:35'),
	(54,14,1,7,'2020-06-22 11:27:48'),
	(55,15,1,4,'2020-06-22 11:28:13'),
	(56,15,1,5,'2020-06-22 11:28:16'),
	(57,15,1,7,'2020-06-22 11:28:28'),
	(58,15,1,19,'2020-06-22 11:28:35'),
	(59,15,1,7,'2020-06-22 11:29:12'),
	(60,15,1,19,'2020-06-22 11:29:31'),
	(61,15,1,7,'2020-06-22 11:30:29'),
	(62,18,0,3,'2020-06-22 11:47:06'),
	(63,19,0,3,'2020-06-22 11:47:16'),
	(64,11,1,4,'2020-06-22 11:48:59'),
	(65,11,1,7,'2020-06-22 11:49:13'),
	(66,12,1,4,'2020-06-22 11:49:45'),
	(67,12,1,7,'2020-06-22 11:50:49'),
	(68,18,1,4,'2020-06-22 11:51:58'),
	(69,18,1,7,'2020-06-22 11:52:53'),
	(70,20,0,3,'2020-06-22 12:03:39'),
	(71,21,0,3,'2020-06-22 12:03:40'),
	(72,22,0,3,'2020-06-22 12:03:42'),
	(73,20,1,4,'2020-06-22 12:03:47'),
	(74,20,1,5,'2020-06-22 12:03:52'),
	(75,21,1,4,'2020-06-22 12:04:06'),
	(76,21,1,6,'2020-06-22 12:04:08'),
	(77,21,1,5,'2020-06-22 12:04:19'),
	(78,10,1,4,'2020-06-22 12:04:30'),
	(79,10,1,6,'2020-06-22 12:04:38'),
	(80,22,1,4,'2020-06-22 12:04:47'),
	(81,22,1,6,'2020-06-22 12:04:50'),
	(82,10,1,5,'2020-06-22 12:04:59'),
	(83,10,1,7,'2020-06-22 12:05:07'),
	(84,16,1,4,'2020-06-22 12:09:21'),
	(85,16,1,5,'2020-06-22 12:10:34'),
	(86,16,1,7,'2020-06-22 12:12:57'),
	(87,17,1,4,'2020-06-22 12:13:13'),
	(88,17,1,5,'2020-06-22 12:13:16'),
	(89,17,1,7,'2020-06-22 12:25:47'),
	(90,17,1,19,'2020-06-22 12:25:53'),
	(91,17,1,7,'2020-06-22 12:29:06'),
	(92,23,0,3,'2020-06-22 12:29:49'),
	(93,24,0,3,'2020-06-22 12:29:50'),
	(94,25,0,3,'2020-06-22 12:29:51'),
	(95,26,0,3,'2020-06-22 12:29:52'),
	(96,23,1,4,'2020-06-22 12:29:57'),
	(97,23,1,5,'2020-06-22 12:29:59'),
	(98,23,1,7,'2020-06-22 12:30:21'),
	(99,23,1,19,'2020-06-22 12:30:26'),
	(100,23,1,7,'2020-06-22 12:30:41'),
	(101,24,1,4,'2020-06-22 12:32:19'),
	(102,24,1,5,'2020-06-22 12:33:12'),
	(103,24,1,7,'2020-06-22 12:33:47'),
	(104,27,0,3,'2020-07-09 09:46:43'),
	(105,28,0,3,'2020-07-09 09:46:45'),
	(106,27,1,4,'2020-07-09 09:46:50'),
	(107,27,1,5,'2020-07-09 09:46:52');



# Dump of table ec_tracking_ticket
# ------------------------------------------------------------


CREATE TABLE `ec_tracking_ticket` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_operatore` int(11) NOT NULL,
  `id_ticket` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `data` date NOT NULL,
  `ora` time NOT NULL,
  `in_carica` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_operatore` (`id_operatore`),
  KEY `id_ticket` (`id_ticket`),
  KEY `status` (`status`),
  KEY `data` (`data`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `ec_tracking_ticket` (`id`, `id_operatore`, `id_ticket`, `status`, `data`, `ora`, `in_carica`)
VALUES
	(1,1,1,7,'2020-06-22','10:36:30',0),
	(2,1,2,7,'2020-06-22','10:36:31',0),
	(3,1,3,7,'2020-06-22','10:38:39',0),
	(4,1,4,7,'2020-06-22','10:38:40',0),
	(5,1,5,7,'2020-06-22','10:38:42',0),
	(6,1,6,7,'2020-06-22','10:44:59',0),
	(7,1,7,7,'2020-06-22','10:45:00',0),
	(8,1,8,7,'2020-06-22','10:45:02',0),
	(9,1,9,7,'2020-06-22','10:51:09',1),
	(10,1,10,7,'2020-06-22','10:51:10',1),
	(11,1,11,7,'2020-06-22','11:09:23',0),
	(12,1,12,7,'2020-06-22','11:09:25',0),
	(13,1,13,7,'2020-06-22','11:19:18',0),
	(14,1,14,7,'2020-06-22','11:27:05',1),
	(15,1,15,7,'2020-06-22','11:27:07',0),
	(16,1,16,7,'2020-06-22','11:27:08',0),
	(17,1,17,7,'2020-06-22','11:27:10',0),
	(18,1,18,7,'2020-06-22','11:47:06',0),
	(19,0,19,3,'2020-06-22','11:47:16',0),
	(20,1,20,7,'2020-06-22','12:03:39',0),
	(21,1,21,7,'2020-06-22','12:03:40',1),
	(22,0,22,6,'2020-06-22','12:03:42',0),
	(23,1,23,7,'2020-06-22','12:29:49',0),
	(24,1,24,7,'2020-06-22','12:29:50',0),
	(25,0,25,3,'2020-06-22','12:29:51',0),
	(26,0,26,3,'2020-06-22','12:29:52',0),
	(27,1,27,5,'2020-07-09','09:46:43',0),
	(28,0,28,3,'2020-07-09','09:46:45',0);



# Dump of table ec_utenti_ruoli
# ------------------------------------------------------------


CREATE TABLE `ec_utenti_ruoli` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_utente` int(11) NOT NULL,
  `id_ruolo` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `ec_utenti_ruoli` (`id`, `id_utente`, `id_ruolo`)
VALUES
	(9,5,5),
	(10,6,5),
	(11,7,5),
	(12,8,5),
	(13,9,5),
	(14,10,5),
	(16,12,5),
	(17,13,5),
	(18,14,5),
	(19,15,5),
	(20,16,5),
	(21,17,5),
	(23,19,5),
	(24,20,5),
	(25,21,5),
	(26,22,5),
	(28,24,5),
	(29,25,5),
	(30,26,5),
	(31,27,5),
	(32,28,5),
	(33,29,5),
	(34,30,5),
	(35,31,5),
	(36,32,5),
	(37,33,5),
	(38,34,5),
	(39,35,5),
	(40,36,5),
	(41,37,5),
	(43,39,5),
	(44,40,5),
	(45,41,5),
	(46,42,5),
	(47,43,5),
	(48,44,5),
	(49,45,5),
	(51,47,5),
	(52,48,5),
	(53,49,5),
	(54,50,5),
	(55,51,5),
	(56,52,5),
	(57,53,5),
	(58,54,5),
	(59,55,5),
	(60,56,5),
	(61,57,5),
	(62,58,5),
	(63,59,5),
	(64,60,5),
	(65,61,5),
	(66,62,5),
	(67,63,5),
	(68,64,5),
	(69,65,5),
	(71,67,5),
	(72,68,5),
	(73,69,5),
	(74,70,5),
	(75,71,5),
	(76,72,5),
	(77,73,5),
	(78,74,5),
	(80,76,5),
	(81,77,5),
	(84,80,5),
	(85,81,5),
	(86,82,5),
	(87,83,4),
	(100,84,6),
	(101,85,3),
	(104,3,3),
	(105,3,4),
	(106,4,3),
	(111,86,3),
	(112,86,4),
	(113,86,5),
	(114,86,6),
	(116,1,1),
	(117,1,3),
	(118,87,3),
	(124,93,3),
	(128,95,4),
	(131,90,3),
	(137,96,4),
	(140,97,3),
	(141,97,4),
	(142,94,3),
	(143,98,4),
	(144,99,4),
	(147,23,5),
	(148,75,5),
	(150,46,5),
	(152,91,3),
	(153,89,3),
	(154,88,3),
	(157,101,3),
	(158,102,3),
	(159,103,3),
	(160,92,3),
	(161,100,4),
	(162,100,5),
	(163,38,5),
	(164,104,4),
	(165,104,5),
	(166,66,4),
	(167,66,5),
	(170,11,4),
	(171,11,5),
	(172,78,4),
	(173,78,5),
	(174,18,4),
	(175,18,5),
	(176,105,4),
	(177,105,5),
	(179,79,4),
	(180,79,5),
	(181,106,3);



# Dump of table ec_video
# ------------------------------------------------------------


CREATE TABLE `ec_video` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titolo` varchar(255) NOT NULL,
  `descrizione` text NOT NULL,
  `orario` time NOT NULL,
  `tipologia` varchar(36) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



# Dump of table flusso ambulatorio
# ------------------------------------------------------------

DROP VIEW IF EXISTS `flusso ambulatorio`;

CREATE TABLE `flusso ambulatorio` (
   `IdPrestazione` INT(11) NOT NULL DEFAULT '0',
   `IdModalita` VARCHAR(50) NOT NULL,
   `Data` VARCHAR(10) NULL DEFAULT NULL,
   `IdInfermiere` BIGINT(11) NULL DEFAULT NULL,
   `IdMedico` BIGINT(11) NULL DEFAULT NULL,
   `Accettato` TIME NOT NULL,
   `Chiamato` TIME NULL DEFAULT NULL,
   `InizioPrestazione` TIME NULL DEFAULT NULL,
   `FinePrestazione` TIME NULL DEFAULT NULL
) ENGINE=MyISAM;



# Dump of table flusso dh
# ------------------------------------------------------------

DROP VIEW IF EXISTS `flusso dh`;

CREATE TABLE `flusso dh` (
   `IdPrestazione` INT(11) NOT NULL DEFAULT '0',
   `IdModalita` VARCHAR(50) NOT NULL,
   `Data` VARCHAR(10) NULL DEFAULT NULL,
   `IdInfermiere` BIGINT(11) NULL DEFAULT NULL,
   `IdMedico` BIGINT(11) NULL DEFAULT NULL,
   `InizioPrelievo` TIME NULL DEFAULT NULL,
   `FinePrelievo` TIME NULL DEFAULT NULL,
   `InizioPrestazione` TIME NULL DEFAULT NULL,
   `FinePrestazione` TIME NULL DEFAULT NULL
) ENGINE=MyISAM;



# Dump of table flusso dh completo
# ------------------------------------------------------------

DROP VIEW IF EXISTS `flusso dh completo`;

CREATE TABLE `flusso dh completo` (
   `IdPrestazione` INT(11) NOT NULL DEFAULT '0',
   `IdTicket` INT(11) NOT NULL,
   `IdModalita` VARCHAR(50) NOT NULL,
   `Data` VARCHAR(10) NULL DEFAULT NULL,
   `IdOperatore` BIGINT(11) NULL DEFAULT NULL,
   `Prelevato` DATETIME NULL DEFAULT NULL,
   `Chiamato` DATETIME NULL DEFAULT NULL,
   `Presente` DATETIME NULL DEFAULT NULL,
   `Assente` DATETIME NULL DEFAULT NULL,
   `IdInfermiere` BIGINT(11) NULL DEFAULT NULL,
   `IdMedico` BIGINT(11) NULL DEFAULT NULL,
   `InizioPrelievo` TIME NULL DEFAULT NULL,
   `FinePrelievo` TIME NULL DEFAULT NULL,
   `InizioPrestazione` TIME NULL DEFAULT NULL,
   `FinePrestazione` TIME NULL DEFAULT NULL
) ENGINE=MyISAM;



# Dump of table flusso ricovero
# ------------------------------------------------------------

DROP VIEW IF EXISTS `flusso ricovero`;

CREATE TABLE `flusso ricovero` (
   `IdRicovero` INT(11) NOT NULL DEFAULT '0',
   `IdModalita` VARCHAR(50) NOT NULL,
   `Data` VARCHAR(10) NULL DEFAULT NULL,
   `IdInfermiere` BIGINT(11) NULL DEFAULT NULL,
   `Accettato` TIME NOT NULL,
   `Chiamato` TIME NULL DEFAULT NULL,
   `InizioRicovero` TIME NULL DEFAULT NULL,
   `FineRicovero` TIME NULL DEFAULT NULL
) ENGINE=MyISAM;



# Dump of table flusso ticket
# ------------------------------------------------------------

DROP VIEW IF EXISTS `flusso ticket`;

CREATE TABLE `flusso ticket` (
   `IdTicket` INT(11) NOT NULL,
   `IdModalita` INT(11) NOT NULL,
   `Data` VARCHAR(10) NULL DEFAULT NULL,
   `IdOperatore` BIGINT(11) NULL DEFAULT NULL,
   `Prelevato` DATETIME NULL DEFAULT NULL,
   `Chiamato` DATETIME NULL DEFAULT NULL,
   `Presente` DATETIME NULL DEFAULT NULL,
   `Assente` DATETIME NULL DEFAULT NULL,
   `Accettato` DATETIME NULL DEFAULT NULL
) ENGINE=MyISAM;





# Replace placeholder table for flusso ticket with correct view syntax
# ------------------------------------------------------------

DROP TABLE `flusso ticket`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `flusso ticket`
AS SELECT
   `t`.`ticket_id` AS `IdTicket`,
   `tt`.`id_modalita` AS `IdModalita`,date_format(`t`.`data`,'%Y-%m-%d') AS `Data`,max((case when (`t`.`utente_id` > 0) then `t`.`utente_id` end)) AS `IdOperatore`,max((case when (`t`.`status` = 3) then `t`.`data` end)) AS `Prelevato`,max((case when (`t`.`status` = 4) then `t`.`data` end)) AS `Chiamato`,max((case when (`t`.`status` = 5) then `t`.`data` end)) AS `Presente`,max((case when (`t`.`status` = 6) then `t`.`data` end)) AS `Assente`,max((case when (`t`.`status` = 7) then `t`.`data` end)) AS `Accettato`
FROM (`ec_tracking_status_ticket` `t` join `ec_ticket_totem` `tt` on((`t`.`ticket_id` = `tt`.`id`))) group by `t`.`ticket_id`;


# Replace placeholder table for flusso ricovero with correct view syntax
# ------------------------------------------------------------

DROP TABLE `flusso ricovero`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `flusso ricovero`
AS SELECT
   `pr`.`id` AS `IdRicovero`,
   `pr`.`modalita` AS `IdModalita`,date_format(`pr`.`data`,'%Y-%m-%d') AS `Data`,max((case when (`pr`.`id_infermiere` > 0) then `pr`.`id_infermiere` end)) AS `IdInfermiere`,
   `acc`.`ora_accettazione` AS `Accettato`,
   `pr`.`ora_presa_carico` AS `Chiamato`,
   `pr`.`inizio_prestazione` AS `InizioRicovero`,
   `pr`.`fine_prestazione` AS `FineRicovero`
FROM (`ec_prestazione_ricovero` `pr` join `ec_accettazione` `acc` on((`acc`.`id` = `pr`.`id_accettazione`))) group by `pr`.`id`;


# Replace placeholder table for flusso dh with correct view syntax
# ------------------------------------------------------------

DROP TABLE `flusso dh`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `flusso dh`
AS SELECT
   `pd`.`id` AS `IdPrestazione`,
   `pd`.`modalita` AS `IdModalita`,date_format(`pd`.`data`,'%Y-%m-%d') AS `Data`,max((case when (`pd`.`id_infermiere` > 0) then `pd`.`id_infermiere` end)) AS `IdInfermiere`,max((case when (`pd`.`id_medico` > 0) then `pd`.`id_medico` end)) AS `IdMedico`,
   `pd`.`inizio_prelievo` AS `InizioPrelievo`,
   `pd`.`fine_prelievo` AS `FinePrelievo`,
   `pd`.`inizio_prestazione` AS `InizioPrestazione`,
   `pd`.`fine_prestazione` AS `FinePrestazione`
FROM (`ec_prestazione_day_hospital` `pd` join `ec_accettazione` `acc` on((`acc`.`id` = `pd`.`id_accettazione`))) group by `pd`.`id`;


# Replace placeholder table for flusso ambulatorio with correct view syntax
# ------------------------------------------------------------

DROP TABLE `flusso ambulatorio`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `flusso ambulatorio`
AS SELECT
   `pa`.`id` AS `IdPrestazione`,
   `pa`.`modalita` AS `IdModalita`,date_format(`pa`.`data`,'%Y-%m-%d') AS `Data`,max((case when (`pa`.`id_infermiere` > 0) then `pa`.`id_infermiere` end)) AS `IdInfermiere`,max((case when (`pa`.`id_medico` > 0) then `pa`.`id_medico` end)) AS `IdMedico`,
   `acc`.`ora_accettazione` AS `Accettato`,
   `pa`.`ora_presa_carico` AS `Chiamato`,
   `pa`.`inizio_prestazione` AS `InizioPrestazione`,
   `pa`.`fine_prestazione` AS `FinePrestazione`
FROM (`ec_prestazione_ambulatorio` `pa` join `ec_accettazione` `acc` on((`acc`.`id` = `pa`.`id_accettazione`))) group by `pa`.`id`;


# Replace placeholder table for flusso dh completo with correct view syntax
# ------------------------------------------------------------

DROP TABLE `flusso dh completo`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `flusso dh completo`
AS SELECT
   `pd`.`id` AS `IdPrestazione`,
   `t`.`ticket_id` AS `IdTicket`,
   `pd`.`modalita` AS `IdModalita`,date_format(`pd`.`data`,'%Y-%m-%d') AS `Data`,max((case when (`t`.`utente_id` > 0) then `t`.`utente_id` end)) AS `IdOperatore`,max((case when (`t`.`status` = 3) then `t`.`data` end)) AS `Prelevato`,max((case when (`t`.`status` = 4) then `t`.`data` end)) AS `Chiamato`,max((case when (`t`.`status` = 7) then `t`.`data` end)) AS `Presente`,max((case when (`t`.`status` = 6) then `t`.`data` end)) AS `Assente`,max((case when (`pd`.`id_infermiere` > 0) then `pd`.`id_infermiere` end)) AS `IdInfermiere`,max((case when (`pd`.`id_medico` > 0) then `pd`.`id_medico` end)) AS `IdMedico`,
   `pd`.`inizio_prelievo` AS `InizioPrelievo`,
   `pd`.`fine_prelievo` AS `FinePrelievo`,
   `pd`.`inizio_prestazione` AS `InizioPrestazione`,
   `pd`.`fine_prestazione` AS `FinePrestazione`
FROM (((`ec_tracking_status_ticket` `t` join `ec_ticket_totem` `tt` on((`t`.`ticket_id` = `tt`.`id`))) join `ec_accettazione` `acc` on((`tt`.`id` = `acc`.`id_totem`))) join `ec_prestazione_day_hospital` `pd` on((`pd`.`id` = `acc`.`id_prestazione`))) where (`tt`.`id_modalita` = 3) group by `pd`.`id`;

