--
-- Host: 127.0.0.1    Database: migliozzi
-- ------------------------------------------------------


--
-- Table structure for table `account`
--

CREATE TABLE `account` (
  `IdAccount` int NOT NULL AUTO_INCREMENT,
  `IdTipoAccount` varchar(50) NOT NULL DEFAULT 'Agente',
  `UserId` varchar(500) NOT NULL DEFAULT '',
  `Password` varchar(500) NOT NULL DEFAULT '',
  `Abilitato` varchar(10) NOT NULL DEFAULT 'S',
  `IdProfiloAbilitazione` int NOT NULL DEFAULT '0',
  `Nominativo` varchar(100) NOT NULL DEFAULT '',
  `DescCognome` varchar(100) NOT NULL DEFAULT '',
  `DescNome` varchar(100) NOT NULL DEFAULT '',
  `CodiceFiscale` varchar(100) NOT NULL DEFAULT '',
  `PartitaIva` varchar(100) NOT NULL DEFAULT '',
  `FlagAttivo` varchar(10) NOT NULL DEFAULT 'S',
  `DescBlocco` varchar(500) NOT NULL DEFAULT '',
  `MailPrincipale` varchar(100) NOT NULL DEFAULT '',
  `MailSecondaria` varchar(100) NOT NULL DEFAULT '',
  `MailPec` varchar(100) NOT NULL DEFAULT '',
  `Cellulare` varchar(100) NOT NULL DEFAULT '',
  `IdStatoNascita` varchar(45) NOT NULL DEFAULT '',
  `ProvinciaResidenza` varchar(10) DEFAULT '',
  `ComuneResidenza` varchar(50) DEFAULT '',
  `DataNascita` int DEFAULT NULL,
  `LuogoNascita` varchar(50) DEFAULT NULL,
  `Indirizzo` varchar(100) DEFAULT '',
  `CapResidenza` varchar(10) DEFAULT '',
  `MailVerificata` int NOT NULL DEFAULT '0',
  `Sesso` char(1) NOT NULL DEFAULT '0',
  `IdProvinciaNascita` varchar(45) NOT NULL DEFAULT '',
  `IdComuneNascita` varchar(45) NOT NULL DEFAULT '',
  PRIMARY KEY (`IdAccount`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `account`
--

INSERT INTO `account` VALUES (1,'Admin','Admin','Admin1!','S',0,'Amministratore','','','','','S','','','','','','','','',20000101,'Eboli','','',1,'0','',''),(2,'Agente','MarioRossi','Password123','S',0,'Mario Rossi','Rossi','Mario','RSSMRA90R15H703C','','S','','','','','','','','',0,'','','',1,'0','',''),(4,'Agente','DAmbrosioGiuseppe','Test123','S',0,'D\'Ambrosio Giuseppe','D\'Ambrosio','Giuseppe','','','S','','','','','','','','',0,'','','',1,'0','',''),(5,'Agente','MigliozziAntonio','TestAccount123','S',0,'Migliozzi Antonio','Migliozzi','Antonio','','','S','','','','','','','','',0,'','','',1,'0','',''),(6,'BackO','BackO','BackO_Pass','S',0,'Back Office','Rossi','Luigi','','','S','','','','','','','','',0,'','','',1,'0','',''),(7,'Cliente','','','S',0,'','D\'AMBROSIO','GIUSEPPE','DMBGPP00P17D390H','','S','','dambrosio.giuseppe09@gmail.com','','','','IT','','',20000917,NULL,'','',0,'M','IT_SA','IT_D390'),(11,'Cliente','','','S',0,'','D\'AMBROSIO','GIUSEPPE','DMBGPP00P17D390Q','','S','','dambrosio.giuseppe09@gmail.com','','','','IT','','',20000917,NULL,'','',0,'M','IT_SA','IT_D390'),(12,'Cliente','','','S',0,'','D\'AMBROSIO','GIUSEPPE','DMBGPP00P17D390T','','S','','dambrosio.giuseppe09@gmail.com','','','','IT','','',20000917,NULL,'','',0,'M','IT_SA','IT_D390'),(13,'Cliente','','','S',0,'','D\'AMBROSIO','GIUSEPPE','DMBGPP00P17D390W','','S','','dambrosio.giuseppe09@gmail.com','','','','IT','','',20000917,NULL,'','',0,'M','IT_SA','IT_D390');


