-- http://www.phpmyadmin.net
--
-- Versione del server: 5.5.34


--
-- Database: `tracciamentoCampioni`
--

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

--
-- Struttura della tabella `bb_anamnesi`
--

CREATE TABLE `bb_anamnesi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` char(10) NOT NULL,
  `apf1` varchar(45) DEFAULT NULL,
  `apf2` varchar(45) NOT NULL,
  `apf3` varchar(45) NOT NULL,
  `apf4` varchar(45) NOT NULL,
  `apf5` varchar(45) NOT NULL,
  `apf6` varchar(45) NOT NULL,
  `apf7` varchar(45) NOT NULL,
  `apf8` varchar(45) NOT NULL,
  `apf9` varchar(45) NOT NULL,
  `apf10` varchar(45) NOT NULL,
  `apf11` varchar(45) NOT NULL,
  `apf12` varchar(45) NOT NULL,
  `apf13` varchar(45) NOT NULL,
  `apf14` varchar(45) NOT NULL,
  `apf15` varchar(45) NOT NULL,
  `apf16` varchar(45) NOT NULL,
  `apf17` varchar(45) NOT NULL,
  `apf18` varchar(45) NOT NULL,
  `af1` varchar(45) NOT NULL,
  `af2` varchar(45) NOT NULL,
  `af3` varchar(45) NOT NULL,
  `af4` varchar(45) NOT NULL,
  `apr1` varchar(45) DEFAULT NULL,
  `apr2` varchar(45) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_birth` date NOT NULL,
  `date_registration` datetime NOT NULL,
  `date_modification` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;

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

INSERT INTO `bb_anamnesi` (`id`, `code`, `apf1`, `apf2`, `apf3`, `apf4`, `apf5`, `apf6`, `apf7`, `apf8`, `apf9`, `apf10`, `apf11`, `apf12`, `apf13`, `apf14`, `apf15`, `apf16`, `apf17`, `apf18`, `af1`, `af2`, `af3`, `af4`, `apr1`, `apr2`, `created_by`, `edited_by`, `date_birth`, `date_registration`, `date_modification`) VALUES
(1, 'SDK2PTWV', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 1, 0, '0000-00-00', '2015-08-12 16:38:16', '0000-00-00 00:00:00'),
(2, '86VEHKZK', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 1, 0, '0000-00-00', '2015-09-29 17:38:42', '0000-00-00 00:00:00'),
(3, 'YTFK4SSC', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 1, 0, '0000-00-00', '2015-09-29 17:39:56', '0000-00-00 00:00:00'),
(4, 'GZNEA7RS', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 1, 0, '0000-00-00', '2015-10-14 15:39:29', '0000-00-00 00:00:00'),
(5, 'EHNC7DX2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 1, 0, '0000-00-00', '2015-10-14 15:42:59', '0000-00-00 00:00:00'),
(6, 'CCNZBUHU', '', '0', '', '0', '0', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, '0000-00-00', '0000-00-00 00:00:00', '2015-10-30 10:36:13'),
(7, 'JJ2E9Z96', '', '0', '', '0', '0', '', '0', '', '', '', '', '', '2', '', '', '', '', '', '2,9', '0', '3', '0', '0', '0', 1, 1, '0000-00-00', '2015-10-16 11:31:13', '2015-10-28 12:57:54'),
(8, '93CHH45Z', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 1, 0, '0000-00-00', '2015-10-16 11:35:34', '0000-00-00 00:00:00'),
(9, 'W8WFDQM9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 1, 0, '0000-00-00', '2015-10-16 11:55:43', '0000-00-00 00:00:00'),
(10, '2XR9MADM', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 1, 0, '0000-00-00', '2015-10-16 15:36:22', '0000-00-00 00:00:00'),
(11, 'ATXTN9JV', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 1, 0, '0000-00-00', '2015-10-16 15:41:53', '0000-00-00 00:00:00'),
(12, 'RRW6JWR2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 1, 0, '0000-00-00', '2015-10-16 15:43:47', '0000-00-00 00:00:00'),
(13, '2RP5Z3KX', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 1, 0, '0000-00-00', '2015-10-16 15:53:47', '0000-00-00 00:00:00'),
(14, '9SUWNYUJ', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 1, 0, '0000-00-00', '2015-10-16 16:01:10', '0000-00-00 00:00:00'),
(15, 'A5PCR5FG', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 1, 0, '0000-00-00', '2015-10-16 16:03:38', '0000-00-00 00:00:00'),
(16, 'ENSMRXRM', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 1, 0, '0000-00-00', '2015-10-16 16:11:18', '0000-00-00 00:00:00'),
(17, 'WMYFT3Z7', '', '0', '', '0', '0', '', '0', '', '', '', '', '', '', '', '', '', '', '', '4', '4', '1', '3', '6', '6', 1, 1, '0000-00-00', '2015-10-29 18:05:01', '2015-10-29 18:12:56');

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

--
-- Struttura della tabella `bb_box`
--

CREATE TABLE `bb_box` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `barcode` varchar(45) DEFAULT '0',
  `num_rows` int(11) NOT NULL,
  `num_cols` int(11) NOT NULL,
  `description` text NOT NULL,
  `created_by` int(11) NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_registration` datetime NOT NULL,
  `date_modification` datetime NOT NULL,
  `date_elimination` datetime NOT NULL,
  `eliminated` int(11) NOT NULL,
  `delete_container` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7318 ;

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

INSERT INTO `bb_box` (`id`, `name`, `barcode`, `num_rows`, `num_cols`, `description`, `created_by`, `edited_by`, `date_registration`, `date_modification`, `date_elimination`, `eliminated`, `delete_container`) VALUES
(367, 'AAA1', 'AAA1', 1, 1, '', 1, 16, '2015-08-12 15:39:53', '2015-09-01 11:28:15', '0000-00-00 00:00:00', 0, 7272),
(1610, 'Can A02', '012457009', 5, 5, '', 1, 0, '2015-06-24 11:03:21', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 5676),
(2050, 'Can A01', '80008590', 1, 6, '', 1, 1, '2015-06-23 12:52:48', '2015-06-24 11:45:32', '0000-00-00 00:00:00', 0, 7272),
(2052, 'Box A02.02', 'AAA', 5, 3, '', 1, 1, '2015-08-12 15:36:16', '2015-08-12 15:39:18', '0000-00-00 00:00:00', 0, 5676),
(2871, 'can A03', '090909', 10, 10, '', 1, 0, '2015-07-02 13:14:36', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 5676),
(7317, 'box esempio', 'AAAAAA', 4, 3, '', 1, 0, '2015-07-07 15:20:24', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 5676);

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

--
-- Struttura della tabella `bb_box_position`
--

CREATE TABLE `bb_box_position` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idBox` varchar(10) NOT NULL,
  `coordinate_box` varchar(10) CHARACTER SET utf8 NOT NULL,
  `idCampione` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_registration` datetime NOT NULL,
  `date_modification` datetime NOT NULL,
  `date_elimination` datetime NOT NULL,
  `eliminated` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;

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

INSERT INTO `bb_box_position` (`id`, `idBox`, `coordinate_box`, `idCampione`, `created_by`, `edited_by`, `date_registration`, `date_modification`, `date_elimination`, `eliminated`) VALUES
(1, '2050', '1:1', 1, 1, 1, '2015-09-01 15:58:06', '2015-09-29 17:41:39', '0000-00-00 00:00:00', 0),
(2, '2050', '1:2', 2, 1, 1, '2015-09-01 15:58:06', '2015-09-29 17:41:54', '0000-00-00 00:00:00', 0),
(3, '2050', '1:3', 3, 1, 1, '2015-09-01 15:58:06', '2015-09-29 17:42:10', '0000-00-00 00:00:00', 0),
(4, '2050', '1:4', 4, 1, 1, '2015-09-01 15:58:06', '2015-09-29 17:42:27', '0000-00-00 00:00:00', 0),
(5, '2050', '1:5', 5, 1, 1, '2015-09-01 15:58:06', '2015-09-29 17:42:41', '0000-00-00 00:00:00', 0),
(6, '2050', '1:6', 6, 1, 0, '2015-09-01 15:58:06', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(7, '', '', 7, 1, 1, '2015-09-04 19:05:04', '2015-09-29 18:06:11', '0000-00-00 00:00:00', 0),
(8, '', '', 8, 1, 1, '2015-09-04 19:05:04', '2015-09-29 17:40:59', '0000-00-00 00:00:00', 0),
(9, '', '', 9, 1, 1, '2015-09-04 19:05:04', '2015-09-29 17:41:23', '0000-00-00 00:00:00', 0),
(10, '', '', 10, 1, 1, '2015-09-04 19:05:04', '2015-09-29 17:42:57', '0000-00-00 00:00:00', 0),
(11, '', '', 11, 1, 1, '2015-09-04 19:05:04', '2015-09-29 17:43:10', '0000-00-00 00:00:00', 0),
(12, '1610', '1:1', 12, 1, 1, '2015-09-29 17:45:48', '2015-09-29 18:04:34', '0000-00-00 00:00:00', 0),
(13, '1610', '1:2', 13, 1, 0, '2015-09-29 17:53:31', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(14, '1610', '1:3', 14, 1, 1, '2015-09-29 17:53:32', '2015-10-05 16:51:36', '0000-00-00 00:00:00', 0),
(15, '1610', '3:4', 15, 1, 0, '2015-11-02 17:42:18', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(16, '367', '1:1', 16, 1, 0, '2015-11-03 12:57:03', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(17, '2052', '1:2', 17, 1, 0, '2015-11-03 13:02:15', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(18, '7317', '1:2', 0, 1, 0, '2015-11-03 13:13:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(19, '7317', '1:2', 0, 1, 0, '2015-11-03 13:14:08', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(20, '7317', '1:2', 0, 1, 0, '2015-11-03 13:14:35', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(21, '7317', '1:2', 0, 1, 0, '2015-11-03 13:14:54', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(22, '7317', '1:2', 0, 1, 0, '2015-11-03 13:16:29', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(23, '7317', '1:2', 0, 1, 0, '2015-11-03 13:16:48', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(24, '', '', 19, 1, 0, '2015-11-03 13:19:30', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(25, '2052', '2:2', 0, 1, 0, '2015-11-03 18:12:14', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(26, '2052', '2:2', 0, 1, 0, '2015-11-03 18:13:08', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(27, '7317', '2:2', 0, 1, 0, '2015-11-03 18:13:40', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(28, '', '', 0, 1, 0, '2015-11-04 10:29:22', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(29, '', '', 0, 17, 0, '2015-11-04 10:41:42', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(30, '', '', 26, 1, 1, '2015-11-04 10:48:04', '2015-11-04 10:48:34', '0000-00-00 00:00:00', 0),
(31, '', '', 27, 1, 0, '2015-11-04 10:48:04', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(32, '', '', 28, 1, 0, '2015-11-04 10:48:04', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(33, '', '', 29, 1, 0, '2015-11-04 10:48:04', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0);

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

--
-- Struttura della tabella `bb_campioni`
--

CREATE TABLE `bb_campioni` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(45) CHARACTER SET utf8 NOT NULL,
  `barcode` varchar(45) CHARACTER SET utf8 NOT NULL DEFAULT '0',
  `tipo` int(11) NOT NULL,
  `volume` float DEFAULT NULL,
  `paziente` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
  `box` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `coordinate_box` varchar(10) CHARACTER SET utf8 NOT NULL,
  `tipo_contenitore` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `anatomical_site` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
  `concentrazione` float DEFAULT NULL,
  `purezza` float DEFAULT NULL,
  `purezza_diluenti` float DEFAULT NULL,
  `fattore_diluzione` int(11) DEFAULT NULL,
  `giorni_astinenza` int(11) DEFAULT NULL,
  `tempo_liquifazione` time DEFAULT NULL,
  `ph` float DEFAULT NULL,
  `viscosita` float DEFAULT NULL,
  `conc_spermatozoi` int(11) DEFAULT NULL,
  `num_spermatozoi` int(11) DEFAULT NULL,
  `motilita_rpr` int(11) DEFAULT NULL,
  `motilita_pr` int(11) DEFAULT NULL,
  `motilita_is` int(11) DEFAULT NULL,
  `motilita_i` int(11) DEFAULT NULL,
  `vitalita` int(11) DEFAULT NULL,
  `morfologia` int(11) DEFAULT NULL,
  `leuciti` int(11) DEFAULT NULL,
  `descrizione` text CHARACTER SET utf8,
  `consenso` int(11) DEFAULT '0',
  `created_by` int(11) NOT NULL,
  `date_registration` datetime NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_modification` datetime NOT NULL,
  `date_elimination` datetime NOT NULL,
  `eliminated` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `barcode` (`barcode`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;

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

INSERT INTO `bb_campioni` (`id`, `nome`, `barcode`, `tipo`, `volume`, `paziente`, `box`, `coordinate_box`, `tipo_contenitore`, `parent_id`, `anatomical_site`, `concentrazione`, `purezza`, `purezza_diluenti`, `fattore_diluzione`, `giorni_astinenza`, `tempo_liquifazione`, `ph`, `viscosita`, `conc_spermatozoi`, `num_spermatozoi`, `motilita_rpr`, `motilita_pr`, `motilita_is`, `motilita_i`, `vitalita`, `morfologia`, `leuciti`, `descrizione`, `consenso`, `created_by`, `date_registration`, `edited_by`, `date_modification`, `date_elimination`, `eliminated`) VALUES
(1, 'Sample A001', 'A001', 5, 0.3, '86VEHKZK', '2050', '1:1', 1, 0, 'lingua', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-09-01 15:58:06', 1, '2015-09-29 17:41:39', '0000-00-00 00:00:00', 0),
(2, 'Sample A002', 'A002', 5, 0.3, '86VEHKZK', '2050', '1:2', 1, 0, 'lingua', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-09-01 15:58:06', 1, '2015-09-29 17:41:53', '0000-00-00 00:00:00', 0),
(3, 'Sample A003', 'A003', 5, 0.3, '86VEHKZK', '2050', '1:3', 1, 0, 'lingua', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-09-01 15:58:06', 1, '2015-09-29 17:42:10', '0000-00-00 00:00:00', 0),
(4, 'Sample A004', 'A004', 5, 0.3, '86VEHKZK', '2050', '1:4', 1, 0, 'lingua', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-09-01 15:58:06', 1, '2015-09-29 17:42:27', '0000-00-00 00:00:00', 0),
(5, 'Sample A005', 'A005', 5, 0.3, '86VEHKZK', '2050', '1:5', 1, 0, 'lingua', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-09-01 15:58:06', 1, '2015-09-29 17:42:41', '0000-00-00 00:00:00', 0),
(6, 'Sample A006', 'A006', 5, 0.3, 'SDK2PTWV', '2050', '1:6', 1, NULL, 'lingua', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1, 1, '2015-09-01 15:58:06', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(7, 'GPHI1', '999', 1, 0, '', '', '', 0, 12, '', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-09-04 19:05:04', 1, '2015-09-29 18:06:10', '0000-00-00 00:00:00', 0),
(8, 'GPHI2', 'GPHI2', 1, 0, 'SDK2PTWV', '', '', 0, 0, '', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-09-04 19:05:04', 1, '2015-09-29 17:40:59', '0000-00-00 00:00:00', 0),
(9, 'GPH3', '90900', 1, 0, 'SDK2PTWV', '', '', 0, 0, '', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-09-04 19:05:04', 1, '2015-09-29 17:41:22', '0000-00-00 00:00:00', 0),
(10, 'GPH4', '9090', 1, 0, 'SDK2PTWV', '', '', 0, 2, '', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-09-04 19:05:04', 1, '2015-09-29 17:42:57', '0000-00-00 00:00:00', 0),
(11, 'GPH5', '2222', 1, 0, 'SDK2PTWV', '', '', 0, 2, '', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-09-04 19:05:04', 1, '2015-09-29 17:43:10', '0000-00-00 00:00:00', 0),
(12, 'CAMPIONE01', 'CAMPIONE01', 0, 0, '', '1610', '1:1', 1, 1, '', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-09-29 17:45:48', 1, '2015-09-29 18:04:34', '0000-00-00 00:00:00', 0),
(13, 'CAMPIONE03', 'CAMPIONE03', 0, 0, 'YTFK4SSC', '1610', '1:2', 1, 0, '', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1, 1, '2015-09-29 17:53:31', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(14, 'CAMPIONE04', 'CAMPIONE04', 0, 0, 'SDK2PTWV', '1610', '1:3', 1, 6, '', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-09-29 17:53:32', 1, '2015-10-05 16:51:36', '0000-00-00 00:00:00', 0),
(15, 'AAA', 'AAA', 17, 0, '86VEHKZK', '1610', '3:4', 1, 1, '', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-11-02 17:42:18', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(16, 'AAAA', 'AAAA', 0, 0.8, '', '367', '1:1', 2, 0, '', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-11-03 12:57:03', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(17, 'AAA2', 'AAA2', 16, 0, '', '2052', '1:2', 1, 0, '', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-11-03 13:02:15', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(18, 'GHGH', 'GHGH', 17, 0, '86VEHKZK', '7317', '1:2', 0, 3, '', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-11-03 13:16:48', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(19, 'KKK', 'KKKK', 18, 0, '', '', '', 0, 0, '', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-11-03 13:19:30', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(23, 'LLLLL', 'LLLL', 0, 0, '', '', '', 0, 0, '', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-11-04 10:27:37', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(24, 'AGATA', 'AGATA', 16, 0, '', '', '', 0, 0, '', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-11-04 10:29:22', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(25, 'AGATA', 'FILIPPA', 15, 0, '', '', '', 0, 0, '', 0, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 17, '2015-11-04 10:41:42', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(26, 'CAMPIONETRANS', 'CAMPIONETRANS', 0, 0, '', '', '', 0, 0, '', 0.9, 0, 0, 0, 0, '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, '2015-11-04 10:48:03', 1, '2015-11-04 10:48:34', '0000-00-00 00:00:00', 0),
(27, 'CAMPIONETRANS', 'CAMPIONETRANS2', 1, 0, '', '', '', 0, 0, '', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1, 1, '2015-11-04 10:48:04', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(28, 'CAMPIONETRANS', 'CAMPIONETRANS3', 1, 0, '', '', '', 0, 0, '', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1, 1, '2015-11-04 10:48:04', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(29, 'CAMPIONETRANS', 'CAMPIONETRANS4', 1, 0, '', '', '', 0, 0, '', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1, 1, '2015-11-04 10:48:04', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0);

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

--
-- Struttura della tabella `bb_consensi`
--

CREATE TABLE `bb_consensi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titolo` varchar(255) NOT NULL,
  `data` date DEFAULT NULL,
  `file` text NOT NULL,
  `descrizione` text,
  `idCampione` int(11) DEFAULT NULL,
  `idPaziente` varchar(8) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `date_registration` datetime NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_modification` datetime NOT NULL,
  `date_elimination` datetime NOT NULL,
  `eliminated` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

INSERT INTO `bb_consensi` (`id`, `titolo`, `data`, `file`, `descrizione`, `idCampione`, `idPaziente`, `created_by`, `date_registration`, `edited_by`, `date_modification`, `date_elimination`, `eliminated`) VALUES
(1, 'Consenso A01', '2018-05-14', 'a:5:{s:4:"name";s:63:"Anteprima di “Visualizza per stampa - phpMyAdmin 4.1.9”.pdf";s:4:"type";s:15:"application/pdf";s:8:"tmp_name";s:83:"./data/uploads/file/Anteprima di “Visualizza per stampa - phpMyAdmin 4.1.9”.pdf";s:5:"error";i:0;s:4:"size";i:45976;}', 'consenso informato per l''utilizzo di embrioni', 3, 'SDK2PTWV', 1, '2015-06-24 11:21:25', 1, '2015-09-14 17:16:20', '0000-00-00 00:00:00', 0),
(2, 'Consenso A02', '2015-11-20', 'a:5:{s:4:"name";s:11:"barcode.png";s:4:"type";s:9:"image/png";s:8:"tmp_name";s:31:"./data/uploads/file/barcode.png";s:5:"error";i:0;s:4:"size";i:3181;}', 'consenso informato', 8, 'SDK2PTWV', 1, '2015-06-24 11:24:14', 1, '2015-09-14 17:17:03', '0000-00-00 00:00:00', 0);

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

--
-- Struttura della tabella `bb_containers`
--

CREATE TABLE `bb_containers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `location` text NOT NULL,
  `temperature` int(11) NOT NULL,
  `description` text NOT NULL,
  `created_by` int(11) NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_registration` datetime NOT NULL,
  `date_modification` datetime NOT NULL,
  `date_elimination` datetime NOT NULL,
  `eliminated` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7273 ;

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

INSERT INTO `bb_containers` (`id`, `name`, `location`, `temperature`, `description`, `created_by`, `edited_by`, `date_registration`, `date_modification`, `date_elimination`, `eliminated`) VALUES
(5676, 'Tank A02', 'via cosenza 4', -300, '', 1, 0, '2015-06-24 11:00:42', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(7272, 'Tank A01', 'via etnea 2', -180, '', 1, 1, '2015-06-23 12:51:53', '2015-06-24 11:01:17', '0000-00-00 00:00:00', 0);

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

--
-- Struttura della tabella `bb_contatto`
--

CREATE TABLE `bb_contatto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `zip` int(11) DEFAULT NULL,
  `phone` int(45) DEFAULT NULL,
  `city` varchar(45) DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL,
  `country` varchar(45) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `date_registration` datetime NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_modification` datetime NOT NULL,
  `date_elimination` datetime NOT NULL,
  `eliminated` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=56 ;

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

INSERT INTO `bb_contatto` (`id`, `address`, `zip`, `phone`, `city`, `email`, `country`, `created_by`, `date_registration`, `edited_by`, `date_modification`, `date_elimination`, `eliminated`) VALUES
(1, 'ghgh', 8989, 0, 'lentini', 'admin@admin.com', '', 1, '2015-07-30 18:24:50', 1, '2015-10-23 11:25:42', '2015-07-30 18:26:51', 0),
(13, 'via ventimiglia 67', 9090, 2147483647, 'cbdjskbds', 'medico@medico.it', 'italia', 1, '2015-07-31 15:35:12', 14, '2015-08-07 10:55:33', '0000-00-00 00:00:00', 0),
(14, 'via dei gracchi', 0, 0, '', 'ricercatore@ricercatore.it', '', 1, '2015-07-31 15:44:38', 0, '0000-00-00 00:00:00', '2015-07-31 15:49:00', 1),
(15, 'via tecnici 78', 98989, 0, '', 'tecnico@hotmail.com', '', 1, '2015-07-31 15:45:21', 1, '2015-07-31 15:48:12', '0000-00-00 00:00:00', 0),
(16, 'via monastero 20', 96016, 98676767, 'Lentini (SR)', 'lucia.zarbano@gmail.com', 'Italia', 1, '2015-07-31 15:50:34', 1, '2015-07-31 15:51:56', '2015-08-04 15:49:46', 1),
(17, 'via monastero 20', 898989, 0, '', '', '', 1, '2015-08-04 16:57:18', 0, '0000-00-00 00:00:00', '2015-08-04 17:16:21', 1),
(18, 'via ciao no so', 0, 0, '', '', '', 1, '2015-08-05 12:30:57', 1, '2015-08-06 10:30:50', '2015-08-06 16:04:37', 1),
(19, 'via monastero 20', 90900, 0, '', '', '', 1, '2015-08-05 16:22:09', 1, '2015-08-05 17:58:32', '0000-00-00 00:00:00', 0),
(20, 'via gorizia 10', 989898, 0, 'Catania', '', '', 1, '2015-08-05 17:02:23', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(21, '', 0, 0, '', '', '', 1, '2015-08-05 17:56:23', 1, '2015-08-05 18:17:26', '0000-00-00 00:00:00', 0),
(22, '', 0, 0, '', '', '', 1, '2015-08-05 18:19:35', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(23, '', 0, 0, '', '', '', 1, '2015-08-05 18:31:18', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(24, '', 0, 0, '', '', '', 1, '2015-08-05 18:31:39', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(25, '', 0, 0, '', '', '', 1, '2015-08-05 18:32:03', 1, '2015-08-06 10:44:42', '0000-00-00 00:00:00', 0),
(26, '', 0, 0, '', '', '', 1, '2015-08-06 10:45:01', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(27, '', 0, 0, '', '', '', 1, '2015-08-06 10:47:02', 1, '2015-08-06 11:54:23', '0000-00-00 00:00:00', 0),
(28, '', 0, 0, '', '', '', 1, '2015-08-06 11:31:04', 1, '2015-08-06 11:51:40', '0000-00-00 00:00:00', 0),
(29, '', 0, 0, '', '', '', 1, '2015-08-06 11:42:35', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(30, '', 0, 0, '', '', '', 1, '2015-08-06 11:43:17', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(31, '', 0, 0, '', '', '', 1, '2015-08-06 11:55:07', 1, '2015-08-06 12:46:09', '0000-00-00 00:00:00', 0),
(32, '', 0, 0, '', '', '', 1, '2015-08-06 12:46:58', 1, '2015-08-06 12:53:36', '0000-00-00 00:00:00', 0),
(33, '', 0, 0, '', '', '', 1, '2015-08-06 12:57:37', 1, '2015-08-06 13:09:06', '0000-00-00 00:00:00', 0),
(34, '', 0, 0, '', '', '', 1, '2015-08-06 13:10:26', 1, '2015-08-06 13:10:52', '0000-00-00 00:00:00', 0),
(35, '', 0, 0, '', '', '', 1, '2015-08-12 16:38:16', 0, '0000-00-00 00:00:00', '2015-10-16 15:59:23', 1),
(36, 'via monastero 20', 96016, 2147483647, 'lentini', 'lucia.zarbano@gmail.com', 'Italia', 1, '2015-09-29 17:38:41', 0, '0000-00-00 00:00:00', '2015-10-16 15:59:35', 1),
(37, 'via cosenza 4', 95128, 95435678, 'Catania', 'a.fassari@pyxisos.com', 'italia', 1, '2015-09-29 17:39:56', 1, '2015-10-16 12:06:30', '2015-10-16 15:59:46', 1),
(38, 'via gorizia 10', 0, 0, '', 'salvatore@gmail.com', '', 1, '2015-10-14 15:39:29', 1, '2015-10-14 15:43:44', '2015-10-16 15:59:55', 1),
(39, '', 0, 0, '', '', '', 1, '2015-10-14 15:41:03', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(40, '', 0, 0, '', '', '', 1, '2015-10-14 15:42:10', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(41, '', 0, 0, '', '', '', 1, '2015-10-14 15:42:59', 1, '2015-10-16 15:57:25', '2015-10-16 16:00:44', 1),
(42, '', 0, 0, '', '', '', 1, '2015-10-16 11:29:35', 0, '0000-00-00 00:00:00', '2015-11-12 15:58:17', 1),
(43, '', 0, 0, '', '', '', 1, '2015-10-16 11:30:59', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(44, '', 0, 0, '', '', '', 1, '2015-10-16 11:31:12', 1, '2015-10-16 11:34:56', '2015-11-12 15:58:25', 1),
(45, '', 0, 0, '', '', '', 1, '2015-10-16 11:35:34', 1, '2015-10-16 12:07:07', '2015-10-16 15:46:02', 1),
(46, '', 0, 0, '', '', '', 1, '2015-10-16 11:55:42', 0, '0000-00-00 00:00:00', '2015-11-12 15:58:32', 1),
(47, '', 0, 0, '', '', '', 1, '2015-10-16 15:36:21', 0, '0000-00-00 00:00:00', '2015-10-16 15:45:53', 1),
(48, '', 0, 0, '', '', '', 1, '2015-10-16 15:41:52', 0, '0000-00-00 00:00:00', '2015-11-12 15:58:41', 1),
(49, '', 0, 0, '', '', '', 1, '2015-10-16 15:43:47', 0, '0000-00-00 00:00:00', '2015-11-12 15:58:48', 1),
(50, '', 0, 0, '', '', '', 1, '2015-10-16 15:53:45', 0, '0000-00-00 00:00:00', '2015-11-12 15:58:54', 1),
(51, '', 0, 0, '', '', '', 1, '2015-10-16 16:01:09', 0, '0000-00-00 00:00:00', '2015-11-12 15:58:07', 1),
(52, 'via etnea 45', 98980, 2147483647, 'siracusa', 'mario.rossi@gmail.com', 'italia', 1, '2015-10-16 16:03:37', 1, '2015-11-12 15:59:43', '0000-00-00 00:00:00', 0),
(53, 'via etnea 45', 98980, 989090, 'siracusa', 'lucia.zarbano@gmail.com', 'italia', 1, '2015-10-16 16:11:18', 1, '2015-11-12 16:00:44', '0000-00-00 00:00:00', 0),
(54, '', 0, 0, '', '', '', 1, '2015-10-29 18:05:00', 1, '2015-11-12 16:01:40', '0000-00-00 00:00:00', 0),
(55, '', 0, 0, '', 'a.fassari@pyxisos.com', '', 1, '2015-11-04 10:31:42', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0);

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

--
-- Struttura della tabella `bb_parent_containers`
--

CREATE TABLE `bb_parent_containers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_box_container` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `type_parent` int(11) NOT NULL,
  `id_container` int(11) NOT NULL,
  `delete_container` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_box_container` (`id_box_container`),
  UNIQUE KEY `id_box_container_2` (`id_box_container`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

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

INSERT INTO `bb_parent_containers` (`id`, `id_box_container`, `type`, `type_parent`, `id_container`, `delete_container`) VALUES
(1, 5544, 1, 1, 7272, 7272),
(2, 2050, 2, 2, 5544, 7272),
(3, 6894, 1, 1, 5676, 5676),
(4, 1610, 2, 2, 6894, 5676),
(5, 2871, 2, 1, 5676, 5676),
(6, 5893, 1, 2, 6894, 5676),
(7, 7317, 2, 2, 5893, 5676),
(8, 1837, 1, 2, 6894, 5676),
(9, 2052, 2, 2, 1837, 5676),
(10, 367, 2, 2, 5544, 7272);

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

--
-- Struttura della tabella `bb_pazienti`
--

CREATE TABLE `bb_pazienti` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(8) NOT NULL,
  `name` text NOT NULL,
  `surname` text NOT NULL,
  `taxcode` text NOT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `ethnic_group` varchar(255) NOT NULL,
  `birth_date` varchar(255) NOT NULL,
  `survey_data` varchar(255) DEFAULT NULL,
  `death_date` varchar(255) DEFAULT NULL,
  `death_cause` varchar(255) DEFAULT NULL,
  `contact_information` int(11) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_registration` datetime NOT NULL,
  `date_modification` datetime NOT NULL,
  `date_elimination` datetime NOT NULL,
  `eliminated` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;

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

INSERT INTO `bb_pazienti` (`id`, `code`, `name`, `surname`, `taxcode`, `sex`, `ethnic_group`, `birth_date`, `survey_data`, `death_date`, `death_cause`, `contact_information`, `created_by`, `edited_by`, `date_registration`, `date_modification`, `date_elimination`, `eliminated`) VALUES
(1, 'SDK2PTWV', '642025df75220043151601ff827994525cb4d1a67d38bc1ae45de2206bd742d8+8QpvuwFWj1ntZFf7g38Zn2egM67xWCrb2asi36Bcn0=', 'c9b5dc0adb133579c42736cca8d4c4353a52afaeba222a35d9d658f44cf45cc3l/3jFpCtJwtMqjCR4cD0SVQfPFJgHzDOWiGwzHq/xP0=', '', '0', '0', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', 35, 1, 0, '2015-08-12 16:38:16', '0000-00-00 00:00:00', '2015-10-16 15:59:23', 1),
(2, '86VEHKZK', 'd589b10c17538836c7122619678437fe6db26fdab156ec5476b8f890b7dff1e2B2zuBp4j+dSbF/iCg/Kyx84fO5X5KejZCbyMIJ9QYXs=', 'a603fc8849ff7b094fa6c34a28a2ade02756474f633457cdbbe3447a863a2299PPOiBRsGoo0RhVNNwbHoKoUzYKJRs6aA9pQG6IGMjNk=', 'f3e310a177cbbf92b6a2c28d953b11a2c3a66d91df3cb8c6afa2313d913d607fMnS9e4S4CB+N6mOA0vbVj1jPCgfF/rLET6qIMwRXM7mKBBonTDnoyrlwn+qIG3Pv', '2', '2', '1982-06-25 18:00:58', '', '0000-00-00 00:00:00', '', 36, 1, 0, '2015-09-29 17:38:42', '0000-00-00 00:00:00', '2015-10-16 15:59:35', 1),
(3, 'YTFK4SSC', '95144828f5a0add5327ff8d11f13f553da6d22a30fef1de9220735b278fdfa32EIEvx9rXJ8b7H+otHImFJQXmJDK/m8/Oa1VZxSaVyxI=', 'ff6c3dddc1117954ec2edcf141373a2e69ccf6a27842300fb6b51ef0bb2b42b5IsN10wH/ZmUewakv4FHQXDX0xhX23nx3Cj56Zs35pKE=', '8ad6da3f90c6fc7eda1cf3b1661e8e21cb5f4d5e00ada15a2f94c3f00c299164HAywAIk6quhm9e9uf1L0lKCdgf+9Acrgp/mf8wKDcjs=', '1', '2', '2015-10-22 15:49:15', 'kjkj', '0000-00-00 00:00:00', '', 37, 1, 1, '2015-09-29 17:39:56', '2015-10-16 12:06:30', '2015-10-16 15:59:46', 1),
(4, 'GZNEA7RS', '5de29617678208ac5dc383b7b4b8aa1249f5897f36160d908648c1947a122fdcravho+0JSnVbvIJgEk/J4ZkIc116+Q7x+acS+DWXQ8A=', 'd229ea8c2c22f533e8caad3c77cc385eb61edcf4331c235aaf12348fa58f4f7elVgtomY75RC16rMNDiPMZH0Nx1BsLRFYx56HxJPu0sY=', 'fedc43749f8ebf09874fc101668569f0b3b31e2ed4b19782182671f3ab792aab5C+jdbRFwADiQwdO2uTcVvoiG27m182nTyhHWqhEvSI=', '3', '0', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', 38, 1, 1, '2015-10-14 15:39:29', '2015-10-14 15:43:44', '2015-10-16 15:59:55', 1),
(5, 'EHNC7DX2', 'f9f9743fb1259921ff4dc1682bb2faf6ad032d4936473bad0d068493d5be1302Rhw4s6xFWDRll/UX5yujrEhi5xOTw0Pnhsiwmxg+J3U=', '015ad494035ca347df7163111a7026dda41f1914ad991e809a874699b45c3881xA4zWJkC0L152qJoIJb5mdJoicZY2Iq4EUNnUt/oYCU=', '16731d2342ff2164750d4c4394ccd83618fdade241b0fa967f2a87e8d96c7e6excj6CHHhr/o3Y2lFrC5DuI0zlqYGfNpYIoqJtXmLsWg=', '48', '7a', '75ff31200922f1342e56504b5f9c4e1d0654ea42de5a62ce717b50900ec9cb3btozGhD+lAXtoht/NsOmvo8HHY0HZo3bjHibw0RU/jEJrQjsZGU65xCPdOAQ4wzyw', '', '1970-01-01 01:00:00', '', 41, 1, 1, '2015-10-14 15:42:59', '2015-10-16 15:57:25', '2015-10-16 16:00:44', 1),
(6, 'CCNZBUHU', 'bb68d1a3db1e3340a42da06059e2f5981f6bb09c88d13bcfb2efc0d07d0921c9ovuZXVryFoJAVi12ntpa5b4s/AbfAquQJ92Ym4fnp4k=', '6a577edae177abb2aa67826185809b0210cc921f035a3f375004be67b59fa1a0zgsiND/TPF482+Bosg6+2dUqvvE9R3ymDdciluIP6Y0=', '21d025ff20de279780631ae080cd9139e3af88d62578d3b49608c5ff766cef1fNyZu3tw5blT8i1DajDIygBkhDDd9nsxDfaoZmmH3GX4=', '0', '21', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', 42, 1, 0, '2015-10-16 11:29:36', '0000-00-00 00:00:00', '2015-11-12 15:58:17', 1),
(7, 'JJ2E9Z96', '1f87ee45e56d440a317398ea5e4eee3b82ec471abcb87e15b66ccbf22aa912d1qRVvUKLhM35khmo8mjlesoC0u+6+cITBoyB3iKqD8YE=', 'deb604c24922180d56354c1bd1205f67e33e15ec026e762979870a6a86e63842zUHtYfhYmtGgmSWN6+dEpbz6FZFQU/ir6DrIpjBukQ8=', '2714ac837c391d188ca0b978124940b01bdd7c2d0353485a01f1b89f814c1e30Z84qsmJMoIFtFeE8wae2Bjy/kXr1wvUrDdR0FtruNto=', '0', '0', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', 44, 1, 1, '2015-10-16 11:31:12', '2015-10-16 11:34:56', '2015-11-12 15:58:25', 1),
(8, '93CHH45Z', '0dd495b13453170775ccc4f012fc3da571ad8fc2e99712dfe287bdd695080d24RBfQNlZGaG5WE8A2RXmStRKkPF+KKEDVPvQYjqRO94c=', 'ad398ba7df3d661b055f293ba8bfb3c6072f13b9e6ad336c5191b2df18510d7fGyr/OJBl7w4j74FdxnZ1hp5qChOgMTSJ5ojzyoLwrh8=', 'b45251c63ef943c2bb276ee663b4a6e921d8388b5f64dcee9134bb23fefe4abfsjBEZH+D1aWIL5k2+6/WDejWoOHWKW7XEfAZzlEJ5rU=', '1', '2', '0000-00-00 00:00:00', 'hjhj', '0000-00-00 00:00:00', '', 45, 1, 1, '2015-10-16 11:35:34', '2015-10-16 12:07:07', '2015-10-16 15:46:02', 1),
(9, 'W8WFDQM9', 'f87a166fa29109c0f02c1cf597c9761e3e682ba21926085508c172cbdc8c4d77Lc3mSxVYiqN5W+EpwZcviATJ0N1nxbmhk+kcq/aVEMQ=', 'b2b0f9de01e90b950e2de859794ff942c778b4144fdb1d5134bb4cf54f9ccbbaAsfe0m5b+GOF5TI2lTzMpIur+3OQmA9EmRhjNERR2I4=', '', '0', '9', '0000-00-00 00:00:00', '7cd5858c2e545b9543a228c92ea38794876ead5dbe63b7ad5b873caf84d2f33cnM1ZkQHdv/o4RCgThW4iLcowMjWcsm1nBWoaPkv4s9o=', '0000-00-00 00:00:00', '', 46, 1, 0, '2015-10-16 11:55:42', '0000-00-00 00:00:00', '2015-11-12 15:58:32', 1),
(10, '2XR9MADM', '2591c52d5a74d737903c08e46aa153c8ef819ac1f196f19c18b5512ff7547160iV6a6zirBqDx360u9UZ9cPTQRvuUSPs4nEED+UCacdc=', 'caa7e9a43e0dd997fda8c39f71dcfc765a9131171ea632e0711a024a4ec7ea5bYWXF901KBO9G+9gDoX3l2URPkRov8M7hH0zG6eMLHQY=', '0be314bba54ce7fce34c74ae98bae2008f206ffb84e3f81d9b25b6c2e7735962K0U28qKm72PMaEhYSqsSNu6Vigt0JdLNAPLpf1AWFMY=', '0', '0', '0000-00-00 00:00:00', '88e2cb3eb091fc25e4f8acd2f2a812839e6ab2c131d648165db99033aae9141bNyggF3XOIZ3dJz2ZZOfyaxQJULsqcdSrws77yPGMFoc=', '0000-00-00 00:00:00', '', 47, 1, 0, '2015-10-16 15:36:21', '0000-00-00 00:00:00', '2015-10-16 15:45:53', 1),
(11, 'ATXTN9JV', '48e077a2e1bd33865080940e51d779e1f8538836a3032dadf4d72cee0eb4e277j0O2hflSaPjQrvsMYRTmsmusf+0jA6108Or4KyBrGCY=', 'd72d364020a338d29903f574ebbcfd4c84b850467feab3a7874a68ae8f1fce31IETbHQCdOAaoqpFlzLt1grdSBuzy4OwfizR9d8Ferjo=', '', '0', '0', '0000-00-00 00:00:00', '575bfa820f06b0cdce48fe81b5ad4bdc1ce9e9e7e9ffc9eb0d96c45f14972bf46OX1rtGGdnCwAO/MV5GrAsSp48YL4fm4/Kg8LvIsDBg=', '0000-00-00 00:00:00', '', 48, 1, 0, '2015-10-16 15:41:52', '0000-00-00 00:00:00', '2015-11-12 15:58:41', 1),
(12, 'RRW6JWR2', '2651d93717452a09c867bd4a3b19c787f52cc8dbb3c58e9331f7961380a080c6n4YVmSQUvXfG4KNhASRji8Y7X6DaJK/hFUa8UKBCPRM=', 'b86661231eca7e6c7c9f48612c3476f8272ba225bf6851361843135a6fc3011d3n/MAGuxRTu+Mn2SlbuL0+KWpw0drUqGqu5sZJiI1sw=', '', '0', '0', '9b714d4a5516d6356e215adde7cca2ae6e6b47072a5432f174fd3d9630a2c570L/ENnxc/L7NXv5NoaJHcs0aFuHITZ+NENhhLJkQ25So6ir+VX95bqje12cpWXLyb', '', '0000-00-00 00:00:00', '', 49, 1, 0, '2015-10-16 15:43:47', '0000-00-00 00:00:00', '2015-11-12 15:58:48', 1),
(13, '2RP5Z3KX', '540dca6b939a857e79066600ffb56ec7593c1d78cf8e556bfffc905311c2e3c0/W8hk1Qkst3HLdLYqIUUk0zgvxRy20P0o0Uun/yHdM8=', '1d1499ec89f3af70d7d3efde3915184a9da14e3861c514e3f9300e4267fbb1e2G5J3zuL0C7RMMj80B3+Oc4nFOaveSSbmJkh69YZ+VTQ=', '', 'cf', '44', 'fad57e70c24554f62b6cb187d6d8f4443e3031a911f7340849d91f3c3a8707c5/wkjF19TmQATabkhuyb1VhFQOI60dpVwoWHzRnnrELsv6L+A+GjkaLO8N8Oa7XyX', '44c9abd65ba13100c4b58c5aba958c5a177923b7dda60f9062f14c1095f7ab27x5RGirXOeNIOOtdkgjMIKrpcmXlhQsgCdSKF2m2O/PY=', '2015-10-27 15:53:40', 'cfdsvd', 50, 1, 0, '2015-10-16 15:53:46', '0000-00-00 00:00:00', '2015-11-12 15:58:54', 1),
(14, '9SUWNYUJ', 'd9b6f0adb5be0c6b7168cd0cf758a904b5937a426ca2be6ae1570f798f7362c3xuguMSKrSMJK7/dAHpivRsFOXXhK4mT3jrTPUkEe8RQ=', 'f29241b29e2ec63ca96936db87a5d08c10dcb439f87e462c8e3e3de8287f1dd2/DNwfzXoW6asDFchukYKKQUqlIT73qvwkI6iQr7pNs4=', '', 'ec65227d89b7d6359d4c8176cd7fa88b3f598224045c16b78fe2b59c77043864o4+U1y9jKxg/jRui3O/LO5oKK4vxbzVttFG5BoE7QQk=', '9ab7288ad1b914b84ef22766f3e35b7b29a5c55d1dde76460905503d5badae75/LxZfv1kIytxp6Zt335tk2BRtEpKCKWd4xqySrmyE+M=', 'cf8ab2d70420f6bbd29a496c9cbec34852ffebc5e2a4f8f4dd1dd9457949ae11BkD5DmMDBiS2/s1Zl5tNLG6hGvstuJE71kgyiEvI/yO7pgfhkVxPCuH0MtFZSLB0', '8e9725aa9996fee991e7a2c2a64cdbc3d745761d383a4777afeac4f99e77f459A5PHHEj4E6tj7qVxNGZDIY8DgPsBlp9zOh4I1mbFXHg=', '2015-10-26 16:01:04', 'kkk', 51, 1, 0, '2015-10-16 16:01:09', '0000-00-00 00:00:00', '2015-11-12 15:58:07', 1),
(15, 'A5PCR5FG', '8055e4fcd429d844b735b14efaec51f4d799cdb551c1cc340dd271753ae46f61VoAbMEGwMucR4Ir/RHoVQ9BJzNDftf9ZP0LdXzNPLr4=', 'fe719a5dff3e49b95f42f16dd723f7f9f3995a42fd5bfc2bda19cfde0d0e9a93wi105fz4G7QVbYpod7UYDAhkZFbBD6xujTfsvkenX4k=', 'a0ca19eedf35313093b5f2bcff80d616742998217c6a01bcba58cd4ad4802ff8ZVYR6kdqakHEFYvcchjB1/1u5fLEBIJMP//d8cpGjZs=', '0ff3e136557947317341455c44489e1df5441d5a0374c7c875b84a131a44d1fdok7OXogsNHrpdn4XN7CaraK1LY0zlp8LnRtL/exWc+0=', '6e867d9eb9b0fd0e322c664620ad6984174134b4cf1e43d9cb5bb15581d46bfeuGlHbZINc2Ok5seNSUPt1g1+MS8Z48cnq0+NwnCt+YA=', 'd96d0fb9448bd0d8cfbe0f75a22ec628d9ab9e05e18b2dba08dc6767a342bf0cs8SiqUyHA2I1+kSGjhIKoyccYOF/z5riEIKhXyNANDHSIr5ZPjkDXytBZqv1YgFa', '', '2015-10-04 19:00:14', 'Incidente', 52, 1, 1, '2015-10-16 16:03:37', '2015-11-12 15:59:43', '0000-00-00 00:00:00', 0),
(16, 'ENSMRXRM', 'c9e0b0cc7748ee71d90d86cd6f291ba27b5535bb4c3c138187866a0c27817269xM9ZXzo3m6C/fxzg/1qMOmv+zwO3ZjLBTyF/MU4oX1g=', '3aeef58fb16201abacb6c844d1d16e4bf2d38a17784cd35aa0db84f1f6883b7dFQ+R8Cz4lOTxhNyvxbiCFajKRoExdbEIwbM0/n+Ept4=', '01c20648efe42c08499808127ea971b9a0fe61de54d4e3a2f85871b1f4dbb071VuOIDv/fVkL1bfJffCbRhI6ixRF9TxtgfwElZZRBZsYtOfYyoEhTWfe43NUptmLV', '8d4fef692417069de71fdc4d48fa44ff2354c34f7aa108c10c3ddb385cf6d727KtHnByEeu3IstVWRMDu4mdRT4K+XDT59CxENNET5vXg=', '13fde059b62f3084a42d7c8f13a159c0cf2328335a037a8ce0adbff0ebbf6bbbnWL0eDQldLvi13mfaCVpanVlknFceYTwU5NXN/NqS8I=', '29f87eaa7e188104dd77746f7613b898521e5b5c6192e0b250b889ad3efcc62aMZN3eGKln+JKYvpiw6kLfh2P4aJ3Mxh3sU2swdwHZVh8+tQCrv634QFs8OfOORrC', '', '00-00-0000 00:00:00', '', 53, 1, 1, '2015-10-16 16:11:18', '2015-11-12 16:00:44', '0000-00-00 00:00:00', 0),
(17, 'WMYFT3Z7', '8a7a99b4a424b67f0cca9febd983c9c51d1436f8dfa5a8c2d984a540f8c2c9b3KAR5vTrtzdBF8HNpUNAAYjyrGcexi6unT9ujbZiBdbE=', '29c2a675becdc30bc91b7973516eecda4e469035b5f615c1fca7e366d77fc624GPHx9MX340hXUPUQEuTN/1ldUg2u+fU9GmanjKJrb8g=', 'c05f5851c5bc32b11eceecc256f990a3f4185686b58e3c5417bf58f91f2ec493bhokInI6lX1uyHzrvMEfvyIA4M0pu5xO38bWQyVBcLM=', 'ff984482102dbf5c8898e5b6a5003c204b6ed9b617479aaec14ebddc775743f0BXXSG9DzDCFx2f64sjOKIEEieMxdN5uLrUJV/z1D6pA=', '2392a3de84f3c2666307c4a2336fe166972905208bb9b9e328ee78552b2fad01HTS9ebAvb6CDzZEpiWZ7Elj0u+uIV43Ff0owEI9DhAY=', 'd739ca970be19cb3aa86c4069a72369c52ebb7afd3f8aabec4d484e8209677ffjJtO0fEktMvObZdniSpWR/d0XU1zkMwO7U65XhVzAqusYP13pytDx603dHT+sR/O', '', '00-00-0000 00:00:00', '', 54, 1, 1, '2015-10-29 18:05:00', '2015-11-12 16:01:40', '0000-00-00 00:00:00', 0);

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

--
-- Struttura della tabella `bb_relazioni_pazienti`
--

CREATE TABLE `bb_relazioni_pazienti` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `anamnesi_id` int(11) NOT NULL,
  `code_paziente` varchar(8) NOT NULL,
  `date_registration` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struttura della tabella `bb_relazioni_ruoli_utenti`
--

CREATE TABLE `bb_relazioni_ruoli_utenti` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;

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

INSERT INTO `bb_relazioni_ruoli_utenti` (`id`, `role_id`, `user_id`) VALUES
(30, 2, 14),
(34, 3, 16),
(35, 5, 1),
(36, 2, 1),
(37, 1, 17);

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

--
-- Struttura della tabella `bb_ruoli`
--

CREATE TABLE `bb_ruoli` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(45) NOT NULL,
  `parent_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `role` (`role`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

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

INSERT INTO `bb_ruoli` (`id`, `role`, `parent_id`) VALUES
(1, 'admin', 0),
(2, 'medico', 0),
(3, 'operatore', 0),
(4, 'ricercatore', 0),
(5, 'super_amministratore', 0);

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

--
-- Struttura della tabella `bb_sop`
--

CREATE TABLE `bb_sop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titolo` varchar(100) NOT NULL,
  `numero` varchar(45) DEFAULT NULL,
  `versione` varchar(45) DEFAULT NULL,
  `categoria` int(11) DEFAULT NULL,
  `sop_sostituita` int(11) DEFAULT NULL,
  `approvata_da` int(11) DEFAULT NULL,
  `destinatario` int(11) DEFAULT NULL,
  `scopo` varchar(255) DEFAULT NULL,
  `ambito` varchar(255) DEFAULT NULL,
  `materiale` varchar(255) DEFAULT NULL,
  `riferimenti` varchar(255) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `date_registration` datetime NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_modification` datetime NOT NULL,
  `date_elimination` datetime NOT NULL,
  `eliminated` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

INSERT INTO `bb_sop` (`id`, `titolo`, `numero`, `versione`, `categoria`, `sop_sostituita`, `approvata_da`, `destinatario`, `scopo`, `ambito`, `materiale`, `riferimenti`, `created_by`, `date_registration`, `edited_by`, `date_modification`, `date_elimination`, `eliminated`) VALUES
(1, 'Sop 2', '12', '0.7', NULL, NULL, 17, 17, '', '', '', 'http://www.google.com', 1, '2015-11-05 10:56:11', 1, '2015-11-05 17:11:25', '0000-00-00 00:00:00', 0),
(2, 'Sop 1', '01', '01.1', NULL, NULL, 17, 17, 'scopo della sop non sp', 'ambito della sop', 'materiale 1, materiale 2', 'bo', 1, '2015-11-05 12:03:04', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(3, 'Sop 3', '3', '4.6', NULL, NULL, 1, 17, '', '', '', '', 1, '2015-11-05 17:12:00', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0);

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

--
-- Struttura della tabella `bb_sop_avanzate`
--

CREATE TABLE `bb_sop_avanzate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titolo` varchar(45) CHARACTER SET utf8 NOT NULL,
  `descrizione` text CHARACTER SET utf8,
  `codice` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
  `metodo` int(11) DEFAULT NULL,
  `data` datetime DEFAULT NULL,
  `paziente_1` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
  `paziente_2` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
  `id_ciclo` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
  `pickup` datetime DEFAULT NULL,
  `ora_post_ph` time DEFAULT NULL,
  `tot_ore` int(11) DEFAULT NULL,
  `campioni_residui` int(11) DEFAULT NULL,
  `campioni_utilizzati` int(11) DEFAULT NULL,
  `campioni_scartati` int(11) DEFAULT NULL,
  `livello_coltura` int(11) DEFAULT NULL,
  `ora_post_ins` time DEFAULT NULL,
  `ora_inizio` time DEFAULT NULL,
  `ora_fine` time DEFAULT NULL,
  `medium` int(11) DEFAULT NULL,
  `lotto` int(11) DEFAULT NULL,
  `data_scadenza` datetime DEFAULT NULL,
  `codice_box` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `date_registration` datetime NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_modification` datetime NOT NULL,
  `date_elimination` datetime NOT NULL,
  `eliminated` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

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

INSERT INTO `bb_sop_avanzate` (`id`, `titolo`, `descrizione`, `codice`, `metodo`, `data`, `paziente_1`, `paziente_2`, `id_ciclo`, `pickup`, `ora_post_ph`, `tot_ore`, `campioni_residui`, `campioni_utilizzati`, `campioni_scartati`, `livello_coltura`, `ora_post_ins`, `ora_inizio`, `ora_fine`, `medium`, `lotto`, `data_scadenza`, `codice_box`, `created_by`, `date_registration`, `edited_by`, `date_modification`, `date_elimination`, `eliminated`) VALUES
(4, 'Sop Avanzata 1', '', '01', 0, '0000-00-00 00:00:00', '', '', '', '0000-00-00 00:00:00', '13:40:00', 0, 0, 0, 3, 0, '13:25:00', '00:00:00', '00:00:00', 0, 0, '0000-00-00 00:00:00', '', 7, '2015-06-22 13:19:59', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(5, 'SOP A01', 'sop per il congelamento di campioni', 'A01', 1, '0000-00-00 00:00:00', 'MVX9C8S9', '', '01', '0000-00-00 00:00:00', '11:25:00', 1, 5, 3, 2, 2, '11:30:00', '11:40:00', '12:35:00', 0, 2, '0000-00-00 00:00:00', '2050', 1, '2015-06-24 11:19:52', 1, '2015-06-24 11:20:20', '0000-00-00 00:00:00', 0);

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

--
-- Struttura della tabella `bb_sop_azioni`
--

CREATE TABLE `bb_sop_azioni` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bb_sop_id` int(11) NOT NULL,
  `ordine` int(11) NOT NULL,
  `titolo` varchar(100) NOT NULL,
  `descrizione` varchar(255) DEFAULT NULL,
  `avviso` varchar(255) DEFAULT NULL,
  `propedeuticita` varchar(45) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `date_registration` datetime NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_modification` datetime NOT NULL,
  `date_elimination` datetime NOT NULL,
  `eliminated` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_bb_sop_azioni_bb_sop1_idx` (`bb_sop_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

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

INSERT INTO `bb_sop_azioni` (`id`, `bb_sop_id`, `ordine`, `titolo`, `descrizione`, `avviso`, `propedeuticita`, `created_by`, `date_registration`, `edited_by`, `date_modification`, `date_elimination`, `eliminated`) VALUES
(1, 1, 3, 'Azione 1', '<p>descrizione della sop</p>\r\n', '<p>avviso</p>\r\n', NULL, 1, '2015-11-05 16:06:16', 1, '2015-11-12 11:47:31', '0000-00-00 00:00:00', 0),
(2, 1, 4, 'Azione 2', '<p>vfmd,nvfkd</p>\r\n', 'vfdkvdfk', NULL, 1, '2015-11-05 16:26:56', 1, '2015-11-12 11:47:31', '0000-00-00 00:00:00', 0),
(3, 1, 1, 'Azione 3', '<p>v</p>\r\n', ' v', NULL, 1, '2015-11-05 16:41:13', 1, '2015-11-11 17:53:03', '0000-00-00 00:00:00', 0),
(4, 1, 2, 'Azione 4', '<p>Seguire la seguente procedeura: mettere nel boccale due campioni e centrifugare.</p>\r\n', 'gg', NULL, 1, '2015-11-06 11:22:07', 1, '2015-11-12 11:47:31', '0000-00-00 00:00:00', 0),
(5, 2, 1, 'Azione 4', 'cfjekbvfjk', 'nvfjksbvf', NULL, 1, '2015-11-09 12:40:51', 1, '2015-11-09 12:41:19', '0000-00-00 00:00:00', 0),
(6, 2, 2, 'Azion1 1', 'vgsbg', 'bg', NULL, 1, '2015-11-09 12:41:08', 1, '2015-11-09 12:41:19', '0000-00-00 00:00:00', 0),
(7, 3, 1, 'sop 3 - azione 1', 'testo', 'avviso', NULL, 1, '2015-11-11 17:55:50', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0);

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

--
-- Struttura della tabella `bb_sop_esecuzione_sop`
--

CREATE TABLE `bb_sop_esecuzione_sop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bb_sop_id` int(11) NOT NULL,
  `stato` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) NOT NULL,
  `date_registration` datetime NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_modification` datetime NOT NULL,
  PRIMARY KEY (`id`,`bb_sop_id`),
  KEY `fk_bb_sop_esecuzione_sop_bb_sop1_idx` (`bb_sop_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=105 ;

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

INSERT INTO `bb_sop_esecuzione_sop` (`id`, `bb_sop_id`, `stato`, `created_by`, `date_registration`, `edited_by`, `date_modification`) VALUES
(92, 1, 0, 1, '2015-11-11 15:41:41', 0, '0000-00-00 00:00:00'),
(93, 2, 0, 1, '2015-11-11 16:07:24', 0, '0000-00-00 00:00:00'),
(94, 2, 0, 1, '2015-11-11 16:07:46', 0, '0000-00-00 00:00:00'),
(95, 1, 0, 1, '2015-11-11 17:52:18', 0, '0000-00-00 00:00:00'),
(96, 3, 0, 1, '2015-11-11 17:53:46', 0, '0000-00-00 00:00:00'),
(97, 3, 0, 1, '2015-11-11 17:54:00', 0, '0000-00-00 00:00:00'),
(98, 1, 0, 1, '2015-11-11 17:54:08', 0, '0000-00-00 00:00:00'),
(99, 3, 0, 1, '2015-11-11 17:55:15', 0, '0000-00-00 00:00:00'),
(100, 2, 0, 1, '2015-11-11 18:15:29', 0, '0000-00-00 00:00:00'),
(101, 1, 0, 1, '2015-11-12 11:16:44', 0, '0000-00-00 00:00:00'),
(102, 1, 0, 1, '2015-11-12 11:40:47', 0, '0000-00-00 00:00:00'),
(103, 1, 0, 1, '2015-11-12 12:45:29', 0, '0000-00-00 00:00:00'),
(104, 1, 0, 1, '2015-11-12 12:59:39', 0, '0000-00-00 00:00:00');

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

--
-- Struttura della tabella `bb_sop_esecuzione_sop_azioni`
--

CREATE TABLE `bb_sop_esecuzione_sop_azioni` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bb_sop_esecuzione_sop_id` int(11) NOT NULL,
  `bb_sop_azioni_id` int(11) NOT NULL,
  `note` varchar(255) DEFAULT NULL,
  `errori` varchar(255) DEFAULT NULL,
  `stato` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) NOT NULL,
  `date_registration` datetime NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_modification` datetime NOT NULL,
  PRIMARY KEY (`id`,`bb_sop_esecuzione_sop_id`,`bb_sop_azioni_id`),
  KEY `fk_bb_sop_esecuzione_sop_azioni_bb_sop_esecuzione_sop1_idx` (`bb_sop_esecuzione_sop_id`),
  KEY `fk_bb_sop_esecuzione_sop_azioni_bb_sop_azioni1` (`bb_sop_azioni_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=65 ;

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

INSERT INTO `bb_sop_esecuzione_sop_azioni` (`id`, `bb_sop_esecuzione_sop_id`, `bb_sop_azioni_id`, `note`, `errori`, `stato`, `created_by`, `date_registration`, `edited_by`, `date_modification`) VALUES
(31, 92, 4, 'nota notina', 'errore errorino', 0, 0, '0000-00-00 00:00:00', 1, '2015-11-12 15:35:20'),
(32, 92, 3, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(33, 92, 2, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(34, 92, 1, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(35, 93, 5, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(36, 93, 6, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(37, 94, 5, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(38, 94, 6, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(39, 95, 4, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(40, 95, 3, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(41, 95, 2, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(42, 95, 1, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(43, 98, 3, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(44, 98, 4, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(45, 98, 1, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(46, 98, 2, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(47, 100, 5, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(48, 100, 6, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(49, 101, 3, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(50, 101, 2, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(51, 101, 4, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(52, 101, 1, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(53, 102, 3, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(54, 102, 2, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(55, 102, 4, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(56, 102, 1, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(57, 103, 3, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(58, 103, 4, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(59, 103, 1, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(60, 103, 2, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(61, 104, 3, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(62, 104, 4, 'ggg', 'gg', 0, 0, '0000-00-00 00:00:00', 1, '2015-11-12 15:29:36'),
(63, 104, 1, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(64, 104, 2, NULL, NULL, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00');

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

--
-- Struttura della tabella `bb_sop_tracking_sop`
--

CREATE TABLE `bb_sop_tracking_sop` (
  `id` int(11) NOT NULL,
  `bb_sop_id` int(11) NOT NULL,
  `stato` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) NOT NULL,
  `date_registration` datetime NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_modification` datetime NOT NULL,
  PRIMARY KEY (`id`,`bb_sop_id`),
  KEY `fk_bb_sop_tracking_sop_bb_sop1_idx` (`bb_sop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struttura della tabella `bb_sop_tracking_status_sop`
--

CREATE TABLE `bb_sop_tracking_status_sop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bb_sop_esecuzione_sop_id` int(11) NOT NULL,
  `stato` int(11) NOT NULL DEFAULT '0',
  `data_modification` datetime NOT NULL,
  `edited_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struttura della tabella `bb_sop_tracking_status_sop_azioni`
--

CREATE TABLE `bb_sop_tracking_status_sop_azioni` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bb_sop_esecuzione_sop_azioni_id` int(11) NOT NULL,
  `stato` int(11) NOT NULL DEFAULT '0',
  `data_modification` datetime NOT NULL,
  `edited_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struttura della tabella `bb_subcontainers`
--

CREATE TABLE `bb_subcontainers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_type_subcontainer` int(11) NOT NULL,
  `name` varchar(45) NOT NULL,
  `description` text NOT NULL,
  `created_by` int(11) NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_registration` datetime NOT NULL,
  `date_modification` datetime NOT NULL,
  `date_elimination` datetime NOT NULL,
  `eliminated` int(11) NOT NULL,
  `delete_container` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6895 ;

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

INSERT INTO `bb_subcontainers` (`id`, `id_type_subcontainer`, `name`, `description`, `created_by`, `edited_by`, `date_registration`, `date_modification`, `date_elimination`, `eliminated`, `delete_container`) VALUES
(1837, 1, 'Canister A02.2', 'canister a03 per contenere urina', 1, 1, '2015-08-11 10:40:03', '2015-08-11 10:41:59', '0000-00-00 00:00:00', 0, 5676),
(5544, 1, 'Canister A01', '', 1, 0, '2015-06-23 12:52:23', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 7272),
(5893, 1, 'Contenitore Tmp', 'descrizione del''es', 1, 1, '2015-07-07 15:19:29', '2015-11-12 16:02:22', '0000-00-00 00:00:00', 0, 5676),
(6894, 1, 'Canister A02', 'canister associato al Tank A02', 1, 0, '2015-06-24 11:02:17', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 5676);

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

--
-- Struttura della tabella `bb_tipologia_subcontainers`
--

CREATE TABLE `bb_tipologia_subcontainers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `if_container` int(11) NOT NULL,
  `name` varchar(45) NOT NULL,
  `description` text NOT NULL,
  `created_by` int(11) NOT NULL,
  `edited_by` int(11) NOT NULL,
  `date_registration` datetime NOT NULL,
  `date_modification` datetime NOT NULL,
  `date_elimination` datetime NOT NULL,
  `eliminated` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

INSERT INTO `bb_tipologia_subcontainers` (`id`, `if_container`, `name`, `description`, `created_by`, `edited_by`, `date_registration`, `date_modification`, `date_elimination`, `eliminated`) VALUES
(1, 1, 'canister', '', 1, 0, '2015-06-23 12:52:08', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(2, 0, 'cd', '', 1, 0, '2015-10-14 18:14:45', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0);

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

--
-- Struttura della tabella `bb_tipologie_campioni`
--

CREATE TABLE `bb_tipologie_campioni` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(54) CHARACTER SET utf8 NOT NULL,
  `descrizione` text CHARACTER SET utf8,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Limiti per le tabelle scaricate
--

--
-- Limiti per la tabella `bb_sop_azioni`
--
ALTER TABLE `bb_sop_azioni`
  ADD CONSTRAINT `fk_bb_sop_azioni_bb_sop1` FOREIGN KEY (`bb_sop_id`) REFERENCES `bb_sop` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limiti per la tabella `bb_sop_tracking_sop`
--
ALTER TABLE `bb_sop_tracking_sop`
  ADD CONSTRAINT `fk_bb_sop_tracking_sop_bb_sop1` FOREIGN KEY (`bb_sop_id`) REFERENCES `bb_sop` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
