-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `solaris_server`
--

DELIMITER $$
--
-- Procedures
--
CREATE DEFINER=`leonardo`@`localhost` PROCEDURE `kill_logic_procedure` (IN `source_id` INT, IN `proc_name` VARCHAR(50))  MODIFIES SQL DATA
BEGIN            DECLARE pid INT;            DECLARE finished INTEGER DEFAULT 0;            IF(proc_name = 'ALL') THEN                BEGIN                    DECLARE cur CURSOR FOR SELECT Process_Id FROM logic_threads WHERE Source=source_id;                    DECLARE CONTINUE HANDLER FOR NOT FOUND SET finished = 1;                    DECLARE CONTINUE HANDLER FOR 1094 BEGIN END;                    OPEN cur;                     FETCH NEXT FROM cur INTO pid;                     WHILE finished = 0 DO                         KILL pid;                         FETCH NEXT FROM cur INTO pid;                     END WHILE;                     CLOSE cur;                    DELETE FROM logic_threads WHERE Source=source_id;                END;            ELSE                BEGIN                    DECLARE cur CURSOR FOR SELECT Process_Id FROM logic_threads WHERE Procedure_Name=proc_name AND Source=source_id;                    DECLARE CONTINUE HANDLER FOR NOT FOUND SET finished = 1;                    DECLARE CONTINUE HANDLER FOR 1094 BEGIN END;                    OPEN cur;                     FETCH NEXT FROM cur INTO pid;                     WHILE finished = 0 DO                         KILL pid;                         FETCH NEXT FROM cur INTO pid;                     END WHILE;                     CLOSE cur;                    DELETE FROM logic_threads WHERE Procedure_Name=proc_name AND Source=source_id;                END;            END IF;            END$$

DELIMITER ;

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

--
-- Table structure for table `history`
--

CREATE TABLE `history` (
  `Id` int(11) NOT NULL,
  `Start_Time` timestamp NOT NULL DEFAULT current_timestamp(),
  `End_Time` timestamp NULL DEFAULT NULL,
  `Type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Cultivation',
  `Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Description` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `Units` varchar(50) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Storico dei workflow (da richiamare per la graficazione)';

--
-- Dumping data for table `history`
--

INSERT INTO `history` (`Id`, `Start_Time`, `End_Time`, `Type`, `Name`, `Description`, `Units`) VALUES
(1, '2016-01-01 07:00:00', '2016-01-03 02:16:02', 'Cultivation', 'TEST', 'Example data', '1'),
(2, '2019-08-09 14:13:13', '2019-08-12 07:02:56', 'Cultivation', 'W1', 'before cultivation', '1'),
(3, '2019-08-12 07:05:44', '2019-08-12 14:28:26', 'Cultivation', 'W2', 'before cultivation', '1'),
(5, '2019-08-12 14:29:58', '2019-08-12 14:31:20', 'Cultivation', 'W4', 'before cultivation', '1'),
(6, '2019-08-12 14:31:28', '2019-08-12 14:39:52', 'Cultivation', 'W5', 'before cultivation', '1'),
(7, '2019-08-12 14:39:59', '2019-08-12 14:41:40', 'Cultivation', 'W6', 'before cultivation', '1'),
(8, '2019-08-12 14:41:45', '2019-08-12 14:42:08', 'Cultivation', 'W7', 'before cultivation', '1'),
(9, '2019-08-12 14:42:18', '2019-08-21 15:16:52', 'Cultivation', 'W8', 'before cultivation', '1'),
(10, '2019-08-22 07:39:02', '2019-08-22 12:55:07', 'Cultivation', 'W9', 'before cultivation', '1'),
(11, '2019-08-22 12:55:16', '2019-08-22 14:56:48', 'Cultivation', 'W10', 'before cultivation', '1'),
(12, '2019-08-22 14:56:55', '2019-08-22 15:13:38', 'Cultivation', 'W11', 'before cultivation', '1'),
(13, '2019-08-22 15:13:41', '2019-09-05 14:09:40', 'Cultivation', 'W12', 'before cultivation', '1'),
(14, '2019-09-05 14:58:48', '2019-09-05 15:11:13', 'Cultivation', 'W13', '', '1'),
(15, '2019-09-05 15:24:13', '2019-09-06 08:34:40', 'Cultivation', 'W14', '', '1'),
(16, '2019-09-06 08:34:49', '2019-09-06 09:24:09', 'Cultivation', 'W15', 'test logic', '1'),
(17, '2019-09-06 09:27:01', '2019-09-06 09:27:11', 'Cultivation', 'W16', '', '1'),
(18, '2019-09-06 09:29:57', '2019-09-06 14:30:15', 'Cultivation', 'W17', '', '1'),
(19, '2019-09-06 14:31:26', '2019-09-06 14:31:32', 'Cultivation', 'W18', '', '1'),
(20, '2019-09-06 14:34:43', '2019-09-20 09:12:48', 'Cultivation', 'W19', '', '1'),
(21, '2019-09-20 09:14:22', NULL, 'Cultivation', 'W20', 'test logic antheia', '1');

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

--
-- Table structure for table `log`
--

CREATE TABLE `log` (
  `Id` int(10) UNSIGNED NOT NULL,
  `Time` timestamp NOT NULL DEFAULT current_timestamp(),
  `Source` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `IP` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Target` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `Description` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `Ack` int(11) NOT NULL DEFAULT 0 COMMENT '0=Utente deve dare acknowledge, 1=Acknowledge ricevuto,2=Macchina deve dare acknowledge'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `log`
--

INSERT INTO `log` (`Id`, `Time`, `Source`, `IP`, `Target`, `Type`, `Description`, `Ack`) VALUES
(1, '2019-08-09 14:09:18', 'Jupiter', '192.168.190.1', '1', 'INFO', 'Jupiter 1 CONNECTED', 1),
(2, '2019-08-09 14:11:27', 'Administrator', '192.168.0.250', '', 'ACTION', 'SELECT UPGRADE solaris.leonardo.vue.zip', 0),
(3, '2019-08-09 14:11:28', 'System', NULL, '', 'INFO', 'SOFTWARE UPGRADE COMPLETED', 1),
(4, '2019-08-09 14:11:33', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGOUT', 0),
(5, '2019-08-09 14:11:36', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGIN', 0),
(6, '2019-08-09 14:12:05', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(7, '2019-08-09 14:12:51', 'Administrator', '::1', '1', 'ACTION', 'PAR stirring (before cultivation) status=ON', 0),
(8, '2019-08-09 14:13:13', 'Administrator', '::1', '1', 'ACTION', 'START W1 before cultivation', 0),
(9, '2019-08-09 14:15:25', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(10, '2019-08-09 14:41:19', 'Administrator', '192.168.0.250', '1', 'ACTION', 'MAN a. out 1=0', 0),
(11, '2019-08-09 14:41:21', 'Administrator', '192.168.0.250', '1', 'ACTION', 'AUTO a. out 1', 0),
(12, '2019-08-09 14:41:35', 'Administrator', '192.168.0.250', '1', 'ACTION', 'AUTO air flow', 0),
(13, '2019-08-09 14:41:36', 'Administrator', '192.168.0.250', '1', 'ACTION', 'MAN air flow=3.8', 0),
(14, '2019-08-09 15:07:18', 'Administrator', '::1', '1', 'ACTION', 'MAN p4=0', 0),
(15, '2019-08-09 15:07:18', 'Administrator', '::1', '1', 'ACTION', 'MAN p4=100', 0),
(16, '2019-08-09 15:07:21', 'Administrator', '::1', '1', 'ACTION', 'MAN p4=0', 0),
(17, '2019-08-09 15:07:21', 'Administrator', '::1', '1', 'ACTION', 'AUTO p4', 0),
(18, '2019-08-09 15:07:29', 'Administrator', '::1', '1', 'ACTION', 'MAN air flow=11.1', 0),
(19, '2019-08-09 15:11:23', 'Administrator', '::1', '1', 'ACTION', 'PAR vessel temperature (before cultivation) status=OFF, Kp=0.7, Ki=0.0008, Kd=80, Kq=0.5, Q time=60, balance action (+)=1, balance action (-)=0.7, action time=5, alarm low=0, warning low=0, warning high=30, alarm high=70, alarm enabled=ON', 0),
(20, '2019-08-09 15:11:24', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(21, '2019-08-09 15:11:29', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=20', 0),
(22, '2019-08-09 15:52:09', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(23, '2019-08-09 15:52:11', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(24, '2019-08-09 15:52:22', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(25, '2019-08-09 15:52:22', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(26, '2019-08-09 15:52:23', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(27, '2019-08-12 07:02:54', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=23', 0),
(28, '2019-08-12 07:02:54', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=25', 0),
(29, '2019-08-12 07:02:56', 'Administrator', '::1', '1', 'ACTION', 'STOP', 0),
(30, '2019-08-12 07:03:07', 'Administrator', '::1', '1', 'ACTION', 'AUTO air flow', 0),
(31, '2019-08-12 07:05:25', 'Administrator', '::1', '1', 'ACTION', 'PROFILE Stirring (before cultivation)  (0,1800)', 0),
(32, '2019-08-12 07:05:44', 'Administrator', '::1', '1', 'ACTION', 'START W2 before cultivation', 0),
(33, '2019-08-12 07:05:53', 'Administrator', '::1', '1', 'ACTION', 'PROFILE Stirring (before cultivation)  (0,-1800)', 0),
(34, '2019-08-12 07:54:19', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(35, '2019-08-12 07:54:20', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(36, '2019-08-12 07:54:20', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(37, '2019-08-12 07:54:23', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(38, '2019-08-12 07:54:27', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(39, '2019-08-12 09:38:46', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0),
(40, '2019-08-12 09:39:17', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGIN', 0),
(41, '2019-08-12 09:39:20', 'Administrator', '192.168.0.250', '', 'ACTION', 'ACKNOWLEDGE Id=38', 0),
(42, '2019-08-12 09:39:21', 'Administrator', '192.168.0.250', '', 'ACTION', 'ACKNOWLEDGE Id=36', 0),
(43, '2019-08-12 09:39:21', 'Administrator', '192.168.0.250', '', 'ACTION', 'ACKNOWLEDGE Id=34', 0),
(44, '2019-08-12 09:39:31', 'Administrator', '192.168.0.250', '', 'ACTION', 'SELECT UPGRADE solaris.leonardo.vue.zip', 0),
(45, '2019-08-12 09:39:31', 'System', NULL, '', 'INFO', 'SOFTWARE UPGRADE COMPLETED', 1),
(46, '2019-08-12 09:39:56', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(47, '2019-08-12 10:57:00', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGIN', 0),
(48, '2019-08-12 10:57:44', 'Jupiter', '192.168.190.1', '1', 'INFO', 'Jupiter 1 CONNECTED', 1),
(49, '2019-08-12 10:57:45', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(50, '2019-08-12 10:57:47', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=49', 0),
(51, '2019-08-12 11:02:51', 'Administrator', '192.168.0.250', '1', 'ACTION', 'PAR vessel temperature (before cultivation) status=OFF, Kp=0.7, Ki=0.0008, Kd=80, Kq=0.5, Q time=60, balance action (+)=1, balance action (-)=0.7, action time=5, alarm low=0, warning low=0, warning high=55, alarm high=70, alarm enabled=ON', 0),
(52, '2019-08-12 11:02:51', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(53, '2019-08-12 11:02:54', 'Administrator', '192.168.0.250', '', 'ACTION', 'ACKNOWLEDGE Id=49', 0),
(54, '2019-08-12 12:01:08', '', '192.168.0.250', '1', 'ACTION', 'PAR dO2 (before cultivation) status=ON, alarm low=0, warning low=0, warning high=150, alarm high=150, alarm enabled=OFF', 0),
(55, '2019-08-12 12:01:23', '', '192.168.0.250', '1', 'ACTION', 'CAL dO2 Point 1 Raw=98.7332 Measured=-2  (X0=-100.7332 X1=1 X2=0)', 0),
(56, '2019-08-12 12:01:39', '', '192.168.0.250', '1', 'ACTION', 'CAL dO2 RESET', 0),
(57, '2019-08-12 12:01:50', '', '192.168.0.250', '1', 'ACTION', 'PAR pH (before cultivation) status=ON, Kp=0.03, neutral zone (+)=0.05, neutral zone (-)=0.05, Kq=0.05, Q time=4, balance action (+)=1, balance action (-)=1, action time=5, alarm low=0, warning low=0, warning high=14, alarm high=14, alarm enabled=OFF', 0),
(58, '2019-08-12 12:02:04', '', '192.168.0.250', '1', 'ACTION', 'CAL pH Point 1 Raw=7.75403 Measured=-2  (X0=-9.75403 X1=1 X2=0)', 0),
(59, '2019-08-12 12:02:15', '', '192.168.0.250', '1', 'ACTION', 'CAL pH RESET', 0),
(60, '2019-08-12 12:02:21', '', '192.168.0.250', '1', 'ACTION', 'PAR pH (before cultivation) status=OFF, Kp=0.03, neutral zone (+)=0.05, neutral zone (-)=0.05, Kq=0.05, Q time=4, balance action (+)=1, balance action (-)=1, action time=5, alarm low=0, warning low=0, warning high=14, alarm high=14, alarm enabled=OFF', 0),
(61, '2019-08-12 12:02:26', '', '192.168.0.250', '1', 'ACTION', 'PAR dO2 (before cultivation) status=OFF, alarm low=0, warning low=0, warning high=150, alarm high=150, alarm enabled=OFF', 0),
(62, '2019-08-12 12:24:29', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0),
(63, '2019-08-12 12:27:32', 'Jupiter', '192.168.190.1', '1', 'INFO', 'Jupiter 1 CONNECTED', 1),
(64, '2019-08-12 12:29:59', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(65, '2019-08-12 12:31:08', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(66, '2019-08-12 12:31:20', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(67, '2019-08-12 12:31:25', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(68, '2019-08-12 12:31:31', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(69, '2019-08-12 12:31:34', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(70, '2019-08-12 12:31:34', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(71, '2019-08-12 12:31:36', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(72, '2019-08-12 12:31:39', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(73, '2019-08-12 12:31:40', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(74, '2019-08-12 12:42:56', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGIN', 0),
(75, '2019-08-12 12:43:09', 'Administrator', '192.168.0.250', '', 'ACTION', 'SELECT UPGRADE solaris.leonardo.vue.zip', 0),
(76, '2019-08-12 12:43:09', 'System', NULL, '', 'INFO', 'SOFTWARE UPGRADE COMPLETED', 1),
(77, '2019-08-12 12:43:12', 'Administrator', '192.168.0.250', '', 'ACTION', 'ACKNOWLEDGE Id=69', 0),
(78, '2019-08-12 12:43:12', 'Administrator', '192.168.0.250', '', 'ACTION', 'ACKNOWLEDGE Id=71', 0),
(79, '2019-08-12 12:43:13', 'Administrator', '192.168.0.250', '', 'ACTION', 'ACKNOWLEDGE Id=67', 0),
(80, '2019-08-12 12:43:13', 'Administrator', '192.168.0.250', '', 'ACTION', 'ACKNOWLEDGE Id=65', 0),
(81, '2019-08-12 12:43:14', 'Administrator', '192.168.0.250', '', 'ACTION', 'ACKNOWLEDGE Id=73', 0),
(82, '2019-08-12 12:45:14', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=67', 0),
(83, '2019-08-12 12:45:14', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=69', 0),
(84, '2019-08-12 12:45:15', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=65', 0),
(85, '2019-08-12 12:45:15', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=71', 0),
(86, '2019-08-12 12:45:16', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=73', 0),
(87, '2019-08-12 14:26:44', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGIN', 0),
(88, '2019-08-12 14:26:58', 'Administrator', '192.168.0.250', '', 'SESSION', 'REMOTE SERVICE ENABLED', 0),
(89, '2019-08-12 14:28:13', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGOUT', 0),
(90, '2019-08-12 14:28:17', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGIN', 0),
(91, '2019-08-12 14:28:26', 'Administrator', '192.168.0.250', '1', 'ACTION', 'STOP', 0),
(92, '2019-08-12 14:28:34', 'Administrator', '192.168.0.250', '1', 'ACTION', 'START W3 before cultivation', 0),
(93, '2019-08-12 14:29:37', '', '192.168.0.250', NULL, 'SESSION', 'LOGOUT', 0),
(94, '2019-08-12 14:29:39', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGIN', 0),
(95, '2019-08-12 14:29:47', 'Administrator', '192.168.0.250', '1', 'ACTION', 'STOP', 0),
(96, '2019-08-12 14:29:58', 'Administrator', '192.168.0.250', '1', 'ACTION', 'START W4 before cultivation', 0),
(97, '2019-08-12 14:31:20', 'Administrator', '192.168.0.250', '1', 'ACTION', 'STOP', 0),
(98, '2019-08-12 14:31:28', 'Administrator', '192.168.0.250', '1', 'ACTION', 'START W5 before cultivation', 0),
(99, '2019-08-12 14:32:48', '', '192.168.0.250', NULL, 'SESSION', 'LOGOUT', 0),
(100, '2019-08-12 14:32:51', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGIN', 0),
(101, '2019-08-12 14:36:51', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGOUT', 0),
(102, '2019-08-12 14:36:54', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGIN', 0),
(103, '2019-08-12 14:39:27', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGIN', 0),
(104, '2019-08-12 14:39:52', 'Administrator', '192.168.0.250', '1', 'ACTION', 'STOP', 0),
(105, '2019-08-12 14:39:59', 'Administrator', '192.168.0.250', '1', 'ACTION', 'START W6 before cultivation', 0),
(106, '2019-08-12 14:41:31', 'Administrator', '192.168.0.250', '', 'ACTION', 'SELECT UPGRADE solaris.leonardo.vue.zip', 0),
(107, '2019-08-12 14:41:31', 'System', NULL, '', 'INFO', 'SOFTWARE UPGRADE COMPLETED', 1),
(108, '2019-08-12 14:41:40', 'Administrator', '192.168.0.250', '1', 'ACTION', 'STOP', 0),
(109, '2019-08-12 14:41:45', 'Administrator', '192.168.0.250', '1', 'ACTION', 'START W7 before cultivation', 0),
(110, '2019-08-12 14:42:08', 'Administrator', '192.168.0.250', '1', 'ACTION', 'STOP', 0),
(111, '2019-08-12 14:42:18', 'Administrator', '192.168.0.250', '1', 'ACTION', 'START W8 before cultivation', 0),
(112, '2019-08-12 14:55:03', 'Administrator', '192.168.0.250', '', 'ACTION', 'SELECT UPGRADE solaris.leonardo.vue.zip', 0),
(113, '2019-08-12 14:55:03', 'System', NULL, '', 'INFO', 'SOFTWARE UPGRADE COMPLETED', 1),
(114, '2019-08-13 07:09:49', 'Administrator', '::1', '1', 'ACTION', 'PAR vessel temperature (before cultivation) status=OFF, Kp=0.7, Ki=0.0008, Kd=80, Kq=0.5, Q time=60, balance action (+)=1, balance action (-)=0.7, action time=5, alarm low=0, warning low=0, warning high=60, alarm high=70, alarm enabled=ON', 0),
(115, '2019-08-13 07:09:50', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(116, '2019-08-14 10:35:04', 'Administrator', '::1', '1', 'ACTION', 'AUTO p2', 0),
(117, '2019-08-14 10:35:05', 'Administrator', '::1', '1', 'ACTION', 'MAN p2=100', 0),
(118, '2019-08-14 10:36:23', 'Administrator', '::1', '1', 'ACTION', 'AUTO p2', 0),
(119, '2019-08-14 10:36:52', 'Administrator', '::1', '1', 'ACTION', 'SET LOGIC ENABLE TO 0', 0),
(120, '2019-08-14 10:36:53', 'Administrator', '::1', '1', 'ACTION', 'SET LOGIC ENABLE TO 1', 0),
(121, '2019-08-14 10:58:18', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0),
(122, '2019-08-14 10:58:33', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(123, '2019-08-14 10:58:46', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGIN', 0),
(124, '2019-08-14 10:58:58', 'Administrator', '192.168.0.250', '', 'ACTION', 'SELECT UPGRADE solaris.leonardo.vue.zip', 0),
(125, '2019-08-14 10:58:59', 'System', NULL, '', 'INFO', 'SOFTWARE UPGRADE COMPLETED', 1),
(126, '2019-08-14 11:03:34', 'Administrator', '192.168.0.250', '', 'ACTION', 'SELECT UPGRADE solaris.leonardo.vue.zip', 0),
(127, '2019-08-14 11:03:34', 'System', NULL, '', 'INFO', 'SOFTWARE UPGRADE COMPLETED', 1),
(128, '2019-08-14 11:04:52', 'Administrator', '192.168.0.250', '', 'INFO', 'Exporting trends in CSV for workflows W8 ...', 1),
(129, '2019-08-14 11:20:23', 'Administrator', '192.168.0.250', '', 'ACTION', 'SELECT UPGRADE solaris.leonardo.vue.zip', 0),
(130, '2019-08-14 11:20:23', 'System', NULL, '', 'INFO', 'SOFTWARE UPGRADE COMPLETED', 1),
(131, '2019-08-19 07:05:13', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(132, '2019-08-19 12:12:42', 'Jupiter', '192.168.190.1', '1', 'INFO', 'Jupiter 1 CONNECTED', 1),
(133, '2019-08-19 12:13:33', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(134, '2019-08-19 12:13:48', 'Administrator', '::1', '1', 'ACTION', 'MAN p2=100', 0),
(135, '2019-08-19 12:13:49', 'Administrator', '::1', '1', 'ACTION', 'AUTO p2', 0),
(136, '2019-08-19 12:14:24', 'Administrator', '::1', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(137, '2019-08-20 08:53:18', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0),
(138, '2019-08-20 09:36:25', 'Jupiter', '192.168.190.1', '1', 'INFO', 'Jupiter 1 CONNECTED', 1),
(139, '2019-08-20 09:57:00', 'Jupiter', '192.168.190.1', '1', 'INFO', 'Jupiter 1 CONNECTED', 1),
(140, '2019-08-20 11:17:46', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(141, '2019-08-20 11:19:29', 'Administrator', '::1', '1', 'ACTION', 'MAN p1=0', 0),
(142, '2019-08-20 11:19:30', 'Administrator', '::1', '1', 'ACTION', 'MAN p1=100', 0),
(143, '2019-08-20 11:19:32', 'Administrator', '::1', '1', 'ACTION', 'MAN p2=100', 0),
(144, '2019-08-20 11:19:35', 'Administrator', '::1', '1', 'ACTION', 'MAN p3=0', 0),
(145, '2019-08-20 11:19:35', 'Administrator', '::1', '1', 'ACTION', 'MAN p3=100', 0),
(146, '2019-08-20 11:19:37', 'Administrator', '::1', '1', 'ACTION', 'MAN p4=0', 0),
(147, '2019-08-20 11:19:37', 'Administrator', '::1', '1', 'ACTION', 'MAN p4=100', 0),
(148, '2019-08-21 15:16:52', 'Administrator', '::1', '1', 'ACTION', 'STOP', 0),
(149, '2019-08-21 15:17:20', 'Administrator', '::1', '1', 'ACTION', 'AUTO p2', 0),
(150, '2019-08-21 15:17:22', 'Administrator', '::1', '1', 'ACTION', 'AUTO p4', 0),
(151, '2019-08-21 15:17:24', 'Administrator', '::1', '1', 'ACTION', 'AUTO p1', 0),
(152, '2019-08-21 15:17:26', 'Administrator', '::1', '1', 'ACTION', 'AUTO p3', 0),
(153, '2019-08-22 07:06:05', 'Jupiter', '192.168.190.1', '1', 'INFO', 'Jupiter 1 CONNECTED', 1),
(154, '2019-08-22 07:06:56', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(155, '2019-08-22 07:09:17', 'Jupiter', '192.168.190.1', '1', 'WARNING', 'Jupiter 1 DISCONNECTED', 1),
(156, '2019-08-22 07:09:22', 'Jupiter', '192.168.190.1', '1', 'INFO', 'Jupiter 1 CONNECTED', 1),
(157, '2019-08-22 07:11:29', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=155', 0),
(158, '2019-08-22 07:12:44', 'Administrator', '::1', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(159, '2019-08-22 07:12:48', 'Administrator', '::1', '1', 'ACTION', 'MAN p4=100', 0),
(160, '2019-08-22 07:12:51', 'Administrator', '::1', '1', 'ACTION', 'MAN p4=64', 0),
(161, '2019-08-22 07:12:51', 'Administrator', '::1', '1', 'ACTION', 'MAN p4=68', 0),
(162, '2019-08-22 07:12:52', 'Administrator', '::1', '1', 'ACTION', 'MAN p4=50', 0),
(163, '2019-08-22 07:12:52', 'Administrator', '::1', '1', 'ACTION', 'MAN p4=85', 0),
(164, '2019-08-22 07:12:53', 'Administrator', '::1', '1', 'ACTION', 'AUTO p4', 0),
(165, '2019-08-22 07:32:03', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0),
(166, '2019-08-22 07:32:42', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGIN', 0),
(167, '2019-08-22 07:38:26', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(168, '2019-08-22 07:38:31', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(169, '2019-08-22 07:38:46', 'Administrator', '192.168.0.250', '1', 'ACTION', 'PAR stirring (before cultivation) status=OFF', 0),
(170, '2019-08-22 07:39:02', 'Administrator', '192.168.0.250', '1', 'ACTION', 'START W9 before cultivation', 0),
(171, '2019-08-22 07:54:20', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(172, '2019-08-22 09:05:07', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(173, '2019-08-22 09:12:54', 'Jupiter', '192.168.190.1', '1', 'WARNING', 'Jupiter 1 DISCONNECTED', 1),
(174, '2019-08-22 09:13:02', 'Jupiter', '192.168.190.1', '1', 'INFO', 'Jupiter 1 CONNECTED', 1),
(175, '2019-08-22 09:13:53', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=173', 0),
(176, '2019-08-22 09:14:06', 'Administrator', '::1', '1', 'ACTION', 'MAN p1=100', 0),
(177, '2019-08-22 09:14:07', 'Administrator', '::1', '1', 'ACTION', 'AUTO p1', 0),
(178, '2019-08-22 12:55:07', 'Administrator', '::1', '1', 'ACTION', 'STOP', 0),
(179, '2019-08-22 12:55:13', 'Administrator', '::1', '1', 'ACTION', 'PAR stirring (before cultivation) status=ON', 0),
(180, '2019-08-22 12:55:16', 'Administrator', '::1', '1', 'ACTION', 'START W10 before cultivation', 0),
(181, '2019-08-22 13:07:29', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0),
(182, '2019-08-22 13:07:35', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(183, '2019-08-22 13:56:06', 'Administrator', '::1', '1', 'ACTION', 'SET LOGIC ENABLE TO 0', 0),
(184, '2019-08-22 13:56:08', 'Administrator', '::1', '1', 'ACTION', 'SET LOGIC ENABLE TO 1', 0),
(185, '2019-08-22 13:57:08', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(186, '2019-08-22 13:59:30', 'Administrator', '::1', '1', 'ACTION', 'MAN p1=100', 0),
(187, '2019-08-22 13:59:32', 'Administrator', '::1', '1', 'ACTION', 'MAN p2=100', 0),
(188, '2019-08-22 13:59:35', 'Administrator', '::1', '1', 'ACTION', 'MAN p3=100', 0),
(189, '2019-08-22 13:59:37', 'Administrator', '::1', '1', 'ACTION', 'MAN p4=85', 0),
(190, '2019-08-22 14:22:08', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(191, '2019-08-22 14:22:13', 'Administrator', '95.110.185.242', '1', 'ACTION', 'SET LOGIC ENABLE TO 0', 0),
(192, '2019-08-22 14:22:14', 'Administrator', '95.110.185.242', '1', 'ACTION', 'SET LOGIC ENABLE TO 1', 0),
(193, '2019-08-22 14:22:21', 'Administrator', '95.110.185.242', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(194, '2019-08-22 14:24:05', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGIN', 0),
(195, '2019-08-22 14:24:12', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(196, '2019-08-22 14:25:07', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(197, '2019-08-22 14:28:15', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(198, '2019-08-22 14:28:19', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(199, '2019-08-22 14:29:56', 'Administrator', '192.168.0.250', '1', 'ACTION', 'SET LOGIC ENABLE TO 0', 0),
(200, '2019-08-22 14:29:59', 'Administrator', '192.168.0.250', '1', 'ACTION', 'SET LOGIC ENABLE TO 1', 0),
(201, '2019-08-22 14:32:27', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0),
(202, '2019-08-22 14:32:37', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(203, '2019-08-22 14:33:30', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(204, '2019-08-22 14:33:36', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(205, '2019-08-22 14:33:39', 'Administrator', '192.168.0.250', '1', 'ACTION', 'SET LOGIC ENABLE TO 0', 0),
(206, '2019-08-22 14:33:41', 'Administrator', '192.168.0.250', '1', 'ACTION', 'SET LOGIC ENABLE TO 1', 0),
(207, '2019-08-22 14:35:32', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(208, '2019-08-22 14:35:36', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(209, '2019-08-22 14:40:15', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(210, '2019-08-22 14:40:20', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(211, '2019-08-22 14:40:22', 'Administrator', '192.168.0.250', '1', 'ACTION', 'SET LOGIC ENABLE TO 0', 0),
(212, '2019-08-22 14:40:24', 'Administrator', '192.168.0.250', '1', 'ACTION', 'SET LOGIC ENABLE TO 1', 0),
(213, '2019-08-22 14:52:42', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(214, '2019-08-22 14:52:46', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(215, '2019-08-22 14:52:49', 'Administrator', '192.168.0.250', '1', 'ACTION', 'SET LOGIC ENABLE TO 0', 0),
(216, '2019-08-22 14:52:51', 'Administrator', '192.168.0.250', '1', 'ACTION', 'SET LOGIC ENABLE TO 1', 0),
(217, '2019-08-22 14:54:39', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(218, '2019-08-22 14:54:44', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(219, '2019-08-22 14:56:48', 'Administrator', '192.168.0.250', '1', 'ACTION', 'STOP', 0),
(220, '2019-08-22 14:56:55', 'Jupiter', '192.168.190.1', 'Workflow', 'WARNING', 'Some parameters are still set in MANUAL from Synoptic page', 1),
(221, '2019-08-22 14:56:55', 'Administrator', '192.168.0.250', '1', 'ACTION', 'START W11 before cultivation', 0),
(222, '2019-08-22 14:56:57', 'Administrator', '192.168.0.250', '', 'ACTION', 'ACKNOWLEDGE Id=220', 0),
(223, '2019-08-22 15:09:00', 'Administrator', '192.168.0.250', '1', 'ACTION', 'AUTO p1', 0),
(224, '2019-08-22 15:09:07', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(225, '2019-08-22 15:09:14', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(226, '2019-08-22 15:09:22', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(227, '2019-08-22 15:11:27', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(228, '2019-08-22 15:11:34', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(229, '2019-08-22 15:13:30', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(230, '2019-08-22 15:13:38', 'Administrator', '192.168.0.250', '1', 'ACTION', 'STOP', 0),
(231, '2019-08-22 15:13:41', 'Jupiter', '192.168.190.1', 'Workflow', 'WARNING', 'Some parameters are still set in MANUAL from Synoptic page', 1),
(232, '2019-08-22 15:13:42', 'Administrator', '192.168.0.250', '1', 'ACTION', 'START W12 before cultivation', 0),
(233, '2019-08-22 15:13:46', 'Administrator', '192.168.0.250', '', 'ACTION', 'ACKNOWLEDGE Id=231', 0),
(234, '2019-08-22 15:14:13', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(235, '2019-08-22 15:15:38', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(236, '2019-08-22 15:15:43', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(237, '2019-08-22 15:16:35', 'Administrator', '192.168.0.250', '1', 'ACTION', 'SET LOGIC ENABLE TO 0', 0),
(238, '2019-08-22 15:16:38', 'Administrator', '192.168.0.250', '1', 'ACTION', 'SET LOGIC ENABLE TO 1', 0),
(239, '2019-08-23 01:30:51', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(240, '2019-08-23 01:30:51', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(241, '2019-08-23 01:30:51', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(242, '2019-08-23 01:30:52', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(243, '2019-08-23 01:31:02', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(244, '2019-08-23 01:31:04', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(245, '2019-08-23 01:31:04', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(246, '2019-08-23 01:31:05', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(247, '2019-08-23 01:31:30', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(248, '2019-08-23 01:31:30', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(249, '2019-08-23 01:31:31', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(250, '2019-08-23 01:31:33', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(251, '2019-08-23 01:33:26', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(252, '2019-08-23 01:33:29', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(253, '2019-08-23 01:33:30', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(254, '2019-08-23 01:33:35', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(255, '2019-08-23 01:33:42', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(256, '2019-08-23 01:33:42', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(257, '2019-08-23 01:33:44', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(258, '2019-08-23 01:33:45', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(259, '2019-08-23 01:33:47', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(260, '2019-08-23 01:33:51', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(261, '2019-08-23 01:34:00', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(262, '2019-08-23 01:34:06', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(263, '2019-08-23 01:34:11', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(264, '2019-08-23 01:34:16', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(265, '2019-08-23 01:34:24', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(266, '2019-08-23 01:34:30', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(267, '2019-08-23 01:34:36', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(268, '2019-08-23 01:34:39', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(269, '2019-08-23 01:34:39', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(270, '2019-08-23 01:34:40', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(271, '2019-08-23 01:35:08', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(272, '2019-08-23 01:35:12', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(273, '2019-08-23 01:35:14', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(274, '2019-08-23 01:35:14', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(275, '2019-08-23 01:35:16', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(276, '2019-08-23 01:35:24', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(277, '2019-08-23 01:35:33', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(278, '2019-08-23 01:35:48', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(279, '2019-08-23 01:35:55', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(280, '2019-08-23 01:36:16', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(281, '2019-08-23 01:36:21', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(282, '2019-08-23 01:36:29', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(283, '2019-08-23 01:36:31', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(284, '2019-08-23 01:36:31', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(285, '2019-08-23 01:36:34', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(286, '2019-08-23 01:36:36', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(287, '2019-08-23 01:36:40', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(288, '2019-08-23 01:36:46', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(289, '2019-08-23 01:36:48', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(290, '2019-08-23 01:36:49', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(291, '2019-08-23 01:37:04', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(292, '2019-08-23 01:37:05', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(293, '2019-08-23 01:37:06', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(294, '2019-08-23 01:37:12', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(295, '2019-08-23 01:37:12', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(296, '2019-08-23 01:37:13', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(297, '2019-08-23 01:37:14', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(298, '2019-08-23 01:37:15', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(299, '2019-08-23 01:37:16', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(300, '2019-08-23 01:37:21', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(301, '2019-08-23 01:37:35', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(302, '2019-08-23 01:37:44', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(303, '2019-08-23 01:37:45', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(304, '2019-08-23 01:37:53', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(305, '2019-08-23 01:38:03', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(306, '2019-08-23 01:38:17', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(307, '2019-08-23 01:38:17', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(308, '2019-08-23 01:38:42', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(309, '2019-08-23 01:38:50', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(310, '2019-08-23 01:38:51', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(311, '2019-08-23 01:38:53', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(312, '2019-08-23 01:39:06', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(313, '2019-08-23 01:39:09', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(314, '2019-08-23 01:39:10', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(315, '2019-08-23 01:39:21', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(316, '2019-08-23 01:39:29', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(317, '2019-08-23 01:39:33', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(318, '2019-08-23 01:39:33', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(319, '2019-08-23 01:39:35', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(320, '2019-08-23 01:39:36', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(321, '2019-08-23 01:39:36', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(322, '2019-08-23 01:39:42', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(323, '2019-08-23 01:39:44', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(324, '2019-08-23 01:39:50', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(325, '2019-08-23 01:39:52', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(326, '2019-08-23 01:39:52', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(327, '2019-08-23 01:40:00', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(328, '2019-08-23 01:40:01', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(329, '2019-08-23 01:40:01', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(330, '2019-08-23 01:40:07', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(331, '2019-08-23 01:40:08', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(332, '2019-08-23 01:40:11', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(333, '2019-08-23 01:40:11', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(334, '2019-08-23 01:40:14', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(335, '2019-08-23 01:40:20', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(336, '2019-08-23 01:40:26', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(337, '2019-08-23 01:40:31', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(338, '2019-08-23 01:40:34', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(339, '2019-08-23 01:40:36', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(340, '2019-08-23 01:40:41', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(341, '2019-08-23 01:40:42', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(342, '2019-08-23 01:40:46', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(343, '2019-08-23 01:40:46', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(344, '2019-08-23 01:40:47', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(345, '2019-08-23 01:40:49', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(346, '2019-08-23 01:40:49', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(347, '2019-08-23 01:40:55', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(348, '2019-08-23 01:40:57', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(349, '2019-08-23 01:40:57', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(350, '2019-08-23 01:40:58', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(351, '2019-08-23 01:40:58', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(352, '2019-08-23 01:40:59', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(353, '2019-08-23 01:41:02', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(354, '2019-08-23 01:41:08', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(355, '2019-08-23 01:41:16', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(356, '2019-08-23 01:41:16', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(357, '2019-08-23 01:41:17', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(358, '2019-08-23 01:41:20', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(359, '2019-08-23 01:41:21', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(360, '2019-08-23 01:41:22', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(361, '2019-08-23 01:41:25', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(362, '2019-08-23 01:41:26', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(363, '2019-08-23 01:41:32', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(364, '2019-08-23 01:41:32', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(365, '2019-08-23 01:41:35', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(366, '2019-08-23 01:41:42', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(367, '2019-08-23 01:41:43', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(368, '2019-08-23 01:41:59', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(369, '2019-08-23 01:42:04', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(370, '2019-08-23 01:42:31', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(371, '2019-08-23 01:42:31', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(372, '2019-08-23 01:42:40', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(373, '2019-08-23 01:42:43', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(374, '2019-08-23 01:42:49', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(375, '2019-08-23 01:42:50', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(376, '2019-08-23 01:42:55', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(377, '2019-08-23 01:42:57', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(378, '2019-08-23 01:42:58', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(379, '2019-08-23 01:42:59', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(380, '2019-08-23 01:43:15', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(381, '2019-08-23 01:43:15', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(382, '2019-08-23 01:43:18', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(383, '2019-08-23 01:43:21', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(384, '2019-08-23 01:45:54', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(385, '2019-08-23 01:45:55', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(386, '2019-08-23 06:55:02', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=239', 0),
(387, '2019-08-23 06:55:02', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=231', 0),
(388, '2019-08-23 06:55:02', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=241', 0),
(389, '2019-08-23 06:55:02', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=220', 0),
(390, '2019-08-23 06:55:04', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=243', 0),
(391, '2019-08-23 06:55:04', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=245', 0),
(392, '2019-08-23 06:55:04', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=247', 0),
(393, '2019-08-23 06:55:05', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=249', 0),
(394, '2019-08-23 06:55:06', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=251', 0),
(395, '2019-08-23 06:55:07', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=253', 0),
(396, '2019-08-23 06:55:41', 'Administrator', '::1', '1', 'ACTION', 'PAR vessel temperature (before cultivation) status=OFF, Kp=0.7, Ki=0.0008, Kd=80, Kq=0.5, Q time=60, balance action (+)=1, balance action (-)=0.7, action time=5, alarm low=0, warning low=0, warning high=70, alarm high=80, alarm enabled=ON', 0),
(397, '2019-08-23 06:55:42', 'Jupiter', '192.168.190.1', 'Temperature', 'INFO', 'In HIGH range', 1),
(398, '2019-08-23 06:55:43', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=261', 0),
(399, '2019-08-23 06:55:43', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=259', 0),
(400, '2019-08-23 06:55:44', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=257', 0),
(401, '2019-08-23 06:55:45', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=265', 0),
(402, '2019-08-23 06:55:45', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=263', 0),
(403, '2019-08-23 06:55:45', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=255', 0),
(404, '2019-08-23 06:55:47', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=269', 0),
(405, '2019-08-23 06:55:47', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=271', 0),
(406, '2019-08-23 06:55:48', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=267', 0),
(407, '2019-08-23 06:55:48', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=275', 0),
(408, '2019-08-23 06:55:49', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=273', 0),
(409, '2019-08-23 06:55:49', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=277', 0),
(410, '2019-08-23 06:55:50', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=279', 0),
(411, '2019-08-23 06:55:50', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=281', 0),
(412, '2019-08-23 06:55:51', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=283', 0),
(413, '2019-08-23 06:55:52', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=285', 0),
(414, '2019-08-23 06:55:53', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=287', 0),
(415, '2019-08-23 06:55:53', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=289', 0),
(416, '2019-08-23 06:55:54', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=291', 0),
(417, '2019-08-23 06:55:56', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=295', 0),
(418, '2019-08-23 06:56:06', 'Administrator', '::1', '1', 'ACTION', 'PAR vessel temperature (before cultivation) status=OFF, Kp=0.7, Ki=0.0008, Kd=80, Kq=0.5, Q time=60, balance action (+)=1, balance action (-)=0.7, action time=5, alarm low=0, warning low=0, warning high=70, alarm high=80, alarm enabled=ON', 0),
(419, '2019-08-23 08:08:35', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=293', 0),
(420, '2019-08-23 08:08:35', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=299', 0),
(421, '2019-08-23 08:08:37', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=303', 0),
(422, '2019-08-23 08:08:39', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=305', 0),
(423, '2019-08-23 08:08:46', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=297', 0),
(424, '2019-08-23 08:08:46', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=307', 0),
(425, '2019-08-23 08:08:47', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=309', 0),
(426, '2019-08-23 08:08:48', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=311', 0),
(427, '2019-08-23 08:08:50', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=301', 0),
(428, '2019-08-23 08:08:53', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=313', 0),
(429, '2019-08-23 08:08:54', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=317', 0),
(430, '2019-08-23 08:08:55', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=321', 0),
(431, '2019-08-23 08:08:55', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=319', 0),
(432, '2019-08-23 08:08:58', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=323', 0),
(433, '2019-08-23 08:09:03', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=327', 0),
(434, '2019-08-23 08:09:03', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=329', 0),
(435, '2019-08-23 08:09:18', 'Administrator', '::1', '1', 'ACTION', 'PAR vessel temperature (before cultivation) status=OFF, Kp=0.7, Ki=0.0008, Kd=80, Kq=0.5, Q time=60, balance action (+)=1, balance action (-)=0.7, action time=5, alarm low=0, warning low=0, warning high=70, alarm high=80, alarm enabled=OFF', 0),
(436, '2019-08-23 08:09:21', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=333', 0),
(437, '2019-08-23 08:09:30', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=337', 0),
(438, '2019-08-23 08:10:04', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=335', 0),
(439, '2019-08-23 08:10:05', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=339', 0),
(440, '2019-08-23 08:10:08', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=341', 0),
(441, '2019-08-23 08:10:09', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=331', 0),
(442, '2019-08-23 08:10:10', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=343', 0),
(443, '2019-08-23 08:10:11', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=345', 0),
(444, '2019-08-23 08:10:28', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=315', 0),
(445, '2019-08-23 08:10:30', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=347', 0),
(446, '2019-08-23 08:10:31', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=351', 0),
(447, '2019-08-23 08:10:33', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=349', 0),
(448, '2019-08-23 08:10:34', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=353', 0),
(449, '2019-08-23 08:10:35', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=355', 0),
(450, '2019-08-23 08:10:36', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=357', 0),
(451, '2019-08-23 08:10:37', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=359', 0),
(452, '2019-08-23 08:10:38', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=361', 0),
(453, '2019-08-23 08:10:38', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=363', 0),
(454, '2019-08-23 08:10:38', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=365', 0),
(455, '2019-08-23 08:10:39', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=367', 0),
(456, '2019-08-23 08:10:40', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=369', 0),
(457, '2019-08-23 08:10:40', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=371', 0),
(458, '2019-08-23 08:10:41', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=373', 0),
(459, '2019-08-23 08:10:42', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=375', 0),
(460, '2019-08-23 08:10:44', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=377', 0),
(461, '2019-08-23 08:10:45', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=381', 0),
(462, '2019-08-23 08:10:46', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=379', 0),
(463, '2019-08-23 08:10:47', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=383', 0),
(464, '2019-08-23 08:10:49', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=325', 0),
(465, '2019-08-23 08:10:49', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=385', 0),
(466, '2019-08-23 10:39:11', 'Administrator', '192.168.0.250', NULL, 'SESSION', 'LOGIN', 0),
(467, '2019-08-23 10:39:19', 'Administrator', '192.168.0.250', '1', 'ACTION', 'SET LOGIC ENABLE TO 0', 0),
(468, '2019-08-23 10:39:19', 'Administrator', '192.168.0.250', '1', 'ACTION', 'SET LOGIC ENABLE TO 1', 0),
(469, '2019-08-23 10:39:26', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(470, '2019-08-23 10:39:31', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(471, '2019-08-23 10:39:41', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(472, '2019-08-23 10:42:22', 'Administrator', '192.168.0.250', '1', 'ACTION', 'COMPILED LOGIC PROGRAM', 0),
(473, '2019-08-23 10:57:27', 'Administrator', '192.168.0.250', '1', 'ACTION', 'REPORT GENERATION', 0),
(474, '2019-08-23 11:41:06', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(475, '2019-08-23 11:41:35', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(476, '2019-08-23 11:41:47', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(477, '2019-08-23 11:42:48', 'Administrator', '192.168.0.250', '', 'ACTION', 'SELECT UPGRADE solaris.leonardo.vue.zip', 0),
(478, '2019-08-23 11:42:48', 'System', NULL, '', 'INFO', 'SOFTWARE UPGRADE COMPLETED', 1),
(479, '2019-08-23 11:43:10', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0),
(480, '2019-08-23 11:43:20', 'Jupiter', '192.168.190.1', '1', 'INFO', 'Jupiter 1 CONNECTED', 1),
(481, '2019-08-23 11:43:24', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(482, '2019-08-23 11:43:45', 'Administrator', '::1', '1', 'ACTION', 'PAR vessel temperature (before cultivation) status=OFF, Kp=0.7, Ki=0.0008, Kd=80, Kq=0.5, Q time=60, balance action (+)=1, balance action (-)=0.7, action time=5, alarm low=0, warning low=0, warning high=70, alarm high=80, alarm enabled=ON', 0),
(483, '2019-08-23 11:44:04', 'Administrator', '::1', '1', 'ACTION', 'PAR vessel temperature (before cultivation) status=OFF, Kp=0.7, Ki=0.0008, Kd=80, Kq=0.5, Q time=60, balance action (+)=1, balance action (-)=0.7, action time=5, alarm low=0, warning low=0, warning high=50, alarm high=80, alarm enabled=ON', 0),
(484, '2019-08-23 11:44:05', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Out of HIGH range', 1),
(485, '2019-08-23 11:47:59', 'Administrator', '192.168.0.250', '', 'ACTION', 'SELECT UPGRADE solaris.leonardo.vue.zip', 0),
(486, '2019-08-23 11:47:59', 'System', NULL, '', 'INFO', 'SOFTWARE UPGRADE COMPLETED', 1),
(487, '2019-08-23 11:48:15', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0);

INSERT INTO `log` (`Id`, `Time`, `Source`, `IP`, `Target`, `Type`, `Description`, `Ack`) VALUES
(998, '2019-09-06 09:28:54', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0),
(999, '2019-09-06 09:29:55', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(1000, '2019-09-06 09:29:57', 'Administrator', '::1', '1', 'ACTION', 'START W17 before cultivation', 0),
(1001, '2019-09-06 12:38:12', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(1002, '2019-09-06 14:00:03', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN Failed', 0),
(1003, '2019-09-06 14:00:06', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(1004, '2019-09-06 14:30:15', 'Administrator', '::1', '1', 'ACTION', 'STOP', 0),
(1005, '2019-09-06 14:30:25', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0),
(1006, '2019-09-06 14:31:16', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(1007, '2019-09-06 14:31:26', 'Administrator', '::1', '1', 'ACTION', 'START W18 before cultivation', 0),
(1008, '2019-09-06 14:31:32', 'Administrator', '::1', '1', 'ACTION', 'STOP', 0),
(1009, '2019-09-06 14:31:42', 'Administrator', '::1', '1', 'ACTION', 'SAVE RECIPE test 1', 0),
(1010, '2019-09-06 14:31:53', 'Administrator', '::1', '1', 'ACTION', 'LOAD RECIPE test 1', 0),
(1011, '2019-09-06 14:32:14', 'Administrator', '::1', '1', 'ACTION', 'PAR p1 (before cultivation) status=ON, function=FEED, working time=10', 0),
(1012, '2019-09-06 14:32:22', 'Administrator', '::1', '1', 'ACTION', 'PROFILE Pump1 (before cultivation)  (0,10)', 0),
(1013, '2019-09-06 14:32:29', 'Administrator', '::1', '1', 'ACTION', 'PAR p2 (custom 3) status=ON, function=ACID, working time=10', 0),
(1014, '2019-09-06 14:32:33', 'Administrator', '::1', '1', 'ACTION', 'PAR p3 (custom 3) status=ON, function=ALKALI, working time=10', 0),
(1015, '2019-09-06 14:32:43', 'Administrator', '::1', '1', 'ACTION', 'PAR p4 (custom 3) status=ON, function=LEVEL 1', 0),
(1016, '2019-09-06 14:32:50', 'Administrator', '::1', '1', 'ACTION', 'PROFILE Pump4 (before cultivation)  (0,15)', 0),
(1017, '2019-09-06 14:33:23', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0),
(1018, '2019-09-06 14:34:17', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(1019, '2019-09-06 14:34:43', 'Administrator', '::1', '1', 'ACTION', 'START W19 before cultivation', 0),
(1020, '2019-09-06 15:41:15', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(1021, '2019-09-06 18:03:37', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(1022, '2019-09-07 10:24:28', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(1023, '2019-09-07 12:01:43', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(1024, '2019-09-07 21:38:02', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(1025, '2019-09-07 21:38:47', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(1026, '2019-09-08 12:20:42', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(1027, '2019-09-09 06:48:39', 'Administrator', '95.110.185.242', NULL, 'SESSION', 'LOGIN', 0),
(1028, '2019-09-09 08:29:36', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0),
(1029, '2019-09-09 08:29:51', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(1030, '2019-09-09 08:30:13', 'Administrator', '::1', '1', 'ACTION', 'PAR p1 (before cultivation) status=ON, function=FEED, working time=10', 0),
(1031, '2019-09-09 08:30:18', 'Administrator', '::1', '1', 'ACTION', 'PAR p2 (custom 3) status=ON, function=ALKALI, working time=10', 0),
(1032, '2019-09-09 08:30:23', 'Administrator', '::1', '1', 'ACTION', 'PAR p3 (custom 3) status=ON, function=ACID, working time=10', 0),
(1033, '2019-09-09 08:30:30', 'Administrator', '::1', '1', 'ACTION', 'PAR p4 (custom 3) status=ON, function=LEVEL 2', 0),
(1034, '2019-09-09 08:30:35', 'Administrator', '::1', '1', 'ACTION', 'PROFILE Pump4 (before cultivation)  (0,15)', 0),
(1035, '2019-09-09 08:30:55', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0),
(1036, '2019-09-16 16:07:30', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(1037, '2019-09-17 07:26:23', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(1038, '2019-09-18 07:10:35', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0),
(1039, '2019-09-20 08:41:43', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(1040, '2019-09-20 08:41:45', 'Administrator', '::1', NULL, 'SESSION', 'SHUTDOWN', 0),
(1041, '2019-09-20 08:42:02', 'Jupiter', '192.168.190.1', '1', 'INFO', 'Jupiter 1 CONNECTED', 1),
(1042, '2019-09-20 08:42:03', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Analog measure error', 1),
(1043, '2019-09-20 08:42:04', 'Jupiter', '192.168.190.1', 'Temperature_Aux', 'WARNING', 'Analog measure error', 1),
(1044, '2019-09-20 08:42:13', 'Jupiter', '192.168.190.1', 'pH', 'WARNING', 'Bus connection error', 1),
(1045, '2019-09-20 08:42:14', 'Jupiter', '192.168.190.1', 'dO2', 'WARNING', 'Bus connection error', 1),
(1046, '2019-09-20 08:42:14', 'Jupiter', '192.168.190.1', 'Weight', 'WARNING', 'Bus connection error', 1),
(1047, '2019-09-20 08:42:14', 'Jupiter', '192.168.190.1', 'ORP', 'WARNING', 'Bus connection error', 1),
(1048, '2019-09-20 08:42:14', 'Jupiter', '192.168.190.1', 'Conductivity', 'WARNING', 'Bus connection error', 1),
(1049, '2019-09-20 08:42:14', 'Jupiter', '192.168.190.1', 'N2_Flow', 'WARNING', 'Bus connection error', 1),
(1050, '2019-09-20 08:43:29', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(1051, '2019-09-20 08:43:36', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1045', 0),
(1052, '2019-09-20 08:43:36', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1046', 0),
(1053, '2019-09-20 08:43:36', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1047', 0),
(1054, '2019-09-20 08:43:37', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1044', 0),
(1055, '2019-09-20 08:43:37', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1048', 0),
(1056, '2019-09-20 08:43:38', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1049', 0),
(1057, '2019-09-20 08:43:39', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1042', 0),
(1058, '2019-09-20 08:43:40', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1043', 0),
(1059, '2019-09-20 09:12:48', 'Administrator', '::1', '1', 'ACTION', 'STOP', 0),
(1060, '2019-09-20 09:14:22', 'Administrator', '::1', '1', 'ACTION', 'START W20 before cultivation', 0),
(1061, '2019-09-20 10:59:07', 'Administrator', '127.0.0.1', NULL, 'SESSION', 'LOGIN', 0),
(1062, '2019-09-20 11:00:59', 'Administrator', '127.0.0.1', '', 'ACTION', 'SELECT UPGRADE solaris.leonardo.vue.zip', 0),
(1063, '2019-09-20 11:02:32', 'Jupiter', '192.168.190.1', '1', 'INFO', 'Jupiter 1 CONNECTED', 1),
(1064, '2019-09-20 11:02:33', 'Jupiter', '192.168.190.1', 'Temperature', 'WARNING', 'Analog measure error', 1),
(1065, '2019-09-20 11:02:33', 'Jupiter', '192.168.190.1', 'pH', 'WARNING', 'Bus connection error', 1),
(1066, '2019-09-20 11:02:33', 'Jupiter', '192.168.190.1', 'ORP', 'WARNING', 'Bus connection error', 1),
(1067, '2019-09-20 11:02:33', 'Jupiter', '192.168.190.1', 'dO2', 'WARNING', 'Bus connection error', 1),
(1068, '2019-09-20 11:02:33', 'Jupiter', '192.168.190.1', 'Conductivity', 'WARNING', 'Bus connection error', 1),
(1069, '2019-09-20 11:02:33', 'Jupiter', '192.168.190.1', 'N2_Flow', 'WARNING', 'Bus connection error', 1),
(1070, '2019-09-20 11:02:33', 'Jupiter', '192.168.190.1', 'Temperature_Aux', 'WARNING', 'Analog measure error', 1),
(1071, '2019-09-20 11:02:33', 'Jupiter', '192.168.190.1', 'Weight', 'WARNING', 'Bus connection error', 1),
(1072, '2019-09-20 11:03:26', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(1073, '2019-09-20 11:03:57', 'Administrator', '::1', '1', 'ACTION', 'SET LOGIC ENABLE TO 0', 0),
(1074, '2019-09-20 11:04:01', 'Administrator', '::1', '1', 'ACTION', 'SET LOGIC ENABLE TO 1', 0),
(1075, '2019-09-20 11:04:03', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1071', 0),
(1076, '2019-09-20 11:04:04', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1069', 0),
(1077, '2019-09-20 11:04:05', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1067', 0),
(1078, '2019-09-20 11:04:06', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1065', 0),
(1079, '2019-09-20 11:04:10', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1064', 0),
(1080, '2019-09-20 11:04:11', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1066', 0),
(1081, '2019-09-20 11:04:13', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1070', 0),
(1082, '2019-09-20 11:04:14', 'Administrator', '::1', '', 'ACTION', 'ACKNOWLEDGE Id=1068', 0),
(1083, '2019-09-20 11:07:02', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(1084, '2019-09-20 11:08:35', 'Administrator', '::1', '', 'SESSION', 'REMOTE SERVICE DISABLED', 0),
(1085, '2019-09-20 11:08:41', 'Administrator', '::1', '', 'SESSION', 'REMOTE SERVICE ENABLED', 0),
(1086, '2019-09-20 11:09:28', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0),
(1087, '2019-09-22 08:28:51', 'Administrator', '::1', NULL, 'SESSION', 'LOGIN', 0);

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

--
-- Table structure for table `logic_threads`
--

CREATE TABLE `logic_threads` (
  `Process_Id` int(11) NOT NULL,
  `Source` int(11) NOT NULL,
  `Procedure_Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Sleep_Block` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `logic_threads`
--

INSERT INTO `logic_threads` (`Process_Id`, `Source`, `Procedure_Name`, `Sleep_Block`) VALUES
(147, 1, 'logic_procedure_1', '21968202212116524416023814421718120135657153144174197');

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

--
-- Stand-in structure for view `log_source_collapsed`
-- (See below for the actual view)
--
CREATE TABLE `log_source_collapsed` (
`Id` int(10) unsigned
,`Time` timestamp
,`Source` varchar(103)
,`Target` varchar(50)
,`Type` varchar(20)
,`Description` varchar(1000)
);

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

--
-- Table structure for table `saved_calibrations`
--

CREATE TABLE `saved_calibrations` (
  `Id` int(10) UNSIGNED NOT NULL,
  `Name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Description` varchar(1024) COLLATE utf8_unicode_ci NOT NULL,
  `x0` float NOT NULL DEFAULT 0,
  `x1` float NOT NULL DEFAULT 1,
  `x2` float NOT NULL DEFAULT 0,
  `x3` float NOT NULL DEFAULT 0,
  `Drift` double NOT NULL DEFAULT 0,
  `Raw_1` float DEFAULT NULL,
  `Point_1` float DEFAULT NULL,
  `Raw_2` float DEFAULT NULL,
  `Point_2` float DEFAULT NULL,
  `Raw_3` float DEFAULT NULL,
  `Point_3` float DEFAULT NULL,
  `Device_Type` enum('INPUT','OUTPUT') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'INPUT',
  `Probe_Config` varchar(2048) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Configurazione della sonda in formato JSON'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `saved_calibrations`
--

INSERT INTO `saved_calibrations` (`Id`, `Name`, `Description`, `x0`, `x1`, `x2`, `x3`, `Drift`, `Raw_1`, `Point_1`, `Raw_2`, `Point_2`, `Raw_3`, `Point_3`, `Device_Type`, `Probe_Config`) VALUES
(1, 'Pump1', '60 rpm, tube diameter 3.2 mm', 0, 3.508, 0, 0, 0, 100, 28.5, NULL, NULL, NULL, NULL, 'INPUT', NULL),
(2, 'Temperature', '4-20 mA, 0-150 °C', -37.5034, 0.00678181, 0, 0, 0, 5530, 0, 27648, 150, NULL, NULL, 'INPUT', NULL),
(3, 'Temperature', 'vessel pt100', -37.5034, 0.00678181, 0, 0, 0, 5530, 0, 27648, 150, NULL, NULL, 'INPUT', NULL);

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

--
-- Table structure for table `saved_profiles`
--

CREATE TABLE `saved_profiles` (
  `Profile_Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Time` int(10) UNSIGNED NOT NULL,
  `Name` varchar(50) CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL,
  `Setpoint` float NOT NULL,
  `Transition` enum('STEP','RAMP','LOOP') CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL DEFAULT 'STEP'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `saved_workflows`
--

CREATE TABLE `saved_workflows` (
  `Workflow_Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `DB_Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Units` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  `Read_Only` tinyint(4) NOT NULL DEFAULT 0,
  `Last_Saved` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `saved_workflows`
--

INSERT INTO `saved_workflows` (`Workflow_Name`, `DB_Name`, `Units`, `Read_Only`, `Last_Saved`) VALUES
('Default', 'solaris_workflow_20190809160839', '1', 1, '2019-08-09 16:08:39'),
('test', 'solaris_workflow_20190906112720', '1', 0, '2019-09-06 11:27:20'),
('test 1', 'solaris_workflow_20190906163142', '1', 0, '2019-09-06 16:31:42');

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

--
-- Table structure for table `units`
--

CREATE TABLE `units` (
  `Id` int(10) UNSIGNED NOT NULL,
  `Model` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Jupiter',
  `Synoptic` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Jupiter',
  `Class` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Fermentor',
  `Revision` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `IP` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Configuration` varchar(2048) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `units`
--

INSERT INTO `units` (`Id`, `Model`, `Synoptic`, `Class`, `Revision`, `IP`, `Configuration`) VALUES
(1, 'Jupiter', 'Jupiter', 'Fermentor', 3, '192.168.190.1', NULL);

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

--
-- Structure for view `log_source_collapsed`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`leonardo`@`localhost` SQL SECURITY DEFINER VIEW `log_source_collapsed`  AS  select `log`.`Id` AS `Id`,`log`.`Time` AS `Time`,concat(`log`.`Source`,' (',`log`.`IP`,')') AS `Source`,`log`.`Target` AS `Target`,`log`.`Type` AS `Type`,`log`.`Description` AS `Description` from `log` ;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `history`
--
ALTER TABLE `history`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `log`
--
ALTER TABLE `log`
  ADD PRIMARY KEY (`Id`),
  ADD KEY `Time` (`Time`),
  ADD KEY `Time_2` (`Time`);

--
-- Indexes for table `logic_threads`
--
ALTER TABLE `logic_threads`
  ADD PRIMARY KEY (`Process_Id`);

--
-- Indexes for table `saved_calibrations`
--
ALTER TABLE `saved_calibrations`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `saved_profiles`
--
ALTER TABLE `saved_profiles`
  ADD PRIMARY KEY (`Time`);

--
-- Indexes for table `saved_workflows`
--
ALTER TABLE `saved_workflows`
  ADD UNIQUE KEY `Workflow_Name` (`Workflow_Name`);

--
-- Indexes for table `units`
--
ALTER TABLE `units`
  ADD PRIMARY KEY (`Id`),
  ADD UNIQUE KEY `Index` (`Id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `history`
--
ALTER TABLE `history`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `log`
--
ALTER TABLE `log`
  MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1088;

--
-- AUTO_INCREMENT for table `saved_calibrations`
--
ALTER TABLE `saved_calibrations`
  MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `units`
--
ALTER TABLE `units`
  MODIFY `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

