--
-- Host: localhost    Database: tex
-- ------------------------------------------------------

--
-- Table structure for table `COLORS`
--

CREATE TABLE `COLORS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  `R` int(11) DEFAULT NULL,
  `G` int(11) DEFAULT NULL,
  `B` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `COLORS`
--

INSERT INTO `COLORS` VALUES (1,'STR_White',255,255,255),(2,'STR_Red',255,0,0),(3,'STR_Green',0,255,0),(4,'STR_Blue',0,0,255),(5,'STR_Dark_red',149,55,53),(6,'STR_Dark_green',0,204,102),(7,'STR_Azure',27,170,244),(8,'STR_Yellow',250,244,14),(9,'STR_Magenta',255,1,255),(10,'STR_Light_red',230,184,183),(11,'STR_Light_blue',51,204,255),(12,'STR_Green_bottle',70,104,70),(13,'STR_Green_spicy',0,174,0),(14,'STR_Orange',255,128,0),(15,'STR_Light_orange',253,216,206),(16,'STR_Ivory',185,185,125),(17,'STR_Light_ivory',210,210,165),(18,'STR_Dark_gray',50,50,50),(19,'STR_Gray',200,200,200);

--
-- Table structure for table `COMMODITY`
--

CREATE TABLE `COMMODITY` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  `Min_Density` float DEFAULT NULL,
  `Max_Density` float DEFAULT NULL,
  `API_Table` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `COMMODITY`
--

INSERT INTO `COMMODITY` VALUES (1,'STR_LPG',500,650,'ABC'),(2,'STR_Crude_oil',610,1165,'ABC'),(3,'STR_Gasoline',610,770,'ABC'),(4,'STR_Transition_zone',770,787,'ABC'),(5,'STR_Jet_fuel',787,838,'ABC'),(6,'STR_Fuel_oil',838,1163,'ABC'),(7,'STR_Lube_oil',800,1163,'ABC');

--
-- Table structure for table `COMPARTMENTS`
--

CREATE TABLE `COMPARTMENTS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Enable` tinyint(1) DEFAULT NULL,
  `Name` varchar(32) DEFAULT NULL,
  `Max_Vol` float DEFAULT NULL,
  `Over_Thr` float DEFAULT NULL,
  `Empty_Thr` float DEFAULT NULL,
  `Id_Product` int(11) DEFAULT NULL,
  `Gross_Vol_In` float DEFAULT NULL,
  `RT_Gross_Vol_Out` float DEFAULT NULL,
  `Order_Idx` int(11) DEFAULT NULL,
  `Menu_Group` int(11) DEFAULT 0,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `COMPARTMENTS`
--


--
-- Table structure for table `COM_PARITY_TYPES`
--

CREATE TABLE `COM_PARITY_TYPES` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
);

--
-- Dumping data for table `COM_PARITY_TYPES`
--

INSERT INTO `COM_PARITY_TYPES` VALUES (1,'STR_Not_used'),(2,'STR_Even'),(3,'STR_Odd');

--
-- Table structure for table `CREDENTIALS`
--

CREATE TABLE `CREDENTIALS` (
  `Id_User` int(11) DEFAULT NULL,
  `Id_Level` int(11) DEFAULT NULL,
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `CREDENTIALS`
--

INSERT INTO `CREDENTIALS` VALUES (1,1,1),(1,2,2),(1,3,3),(1,4,4),(1,5,5),(1,6,6),(2,1,7),(2,2,8),(2,3,9),(3,1,10),(6,2,18);

--
-- Table structure for table `DEBUG_CLIPBOARD_RT`
--

CREATE TABLE `DEBUG_CLIPBOARD_RT` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description` varchar(64) DEFAULT NULL,
  `Value` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `DEBUG_CLIPBOARD_RT`
--


--
-- Table structure for table `DEBUG_TASKHND_RT`
--

CREATE TABLE `DEBUG_TASKHND_RT` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Handler` varchar(64) DEFAULT NULL,
  `Task` varchar(64) DEFAULT NULL,
  `Cycles` int(11) DEFAULT NULL,
  `Running` tinyint(1) DEFAULT NULL,
  `Period_ms` int(11) DEFAULT NULL,
  `AvgExec_ms` int(11) DEFAULT NULL,
  `MaxExec_ms` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `DEBUG_TASKHND_RT`
--

INSERT INTO `DEBUG_TASKHND_RT` VALUES (104140,'MAIN HANDLER','MainTask',166349,1,50,0,131),(104141,'MAIN HANDLER','Routing_Scenario',166322,1,50,0,2),(104142,'BUS HANDLER','Gestione_Bus',83263,1,100,0,314),(104143,'BUS HANDLER','EH_BusHandler',83255,1,100,0,0),(104144,'LCD HANDLER','LVDS_SharedMem_Refresh',83283,1,100,11,62),(104145,'LCD HANDLER','LVDS_Update_TopBar',8333,1,1000,4,23),(104146,'LCD HANDLER','LVDS_Update_Skey',33320,1,250,2,25),(104147,'LCD HANDLER','LVDS_Update_MeterData_1',83227,1,100,16,46),(104148,'LCD HANDLER','Gestione_Screensaver',8331,1,1000,0,1),(104149,'HARDWARE HANDLER','UpdateSwitchWM',8331,1,1000,0,10),(104150,'HARDWARE HANDLER','GetRTC',16661,1,500,0,1),(104151,'HARDWARE HANDLER','Check_Keypad',378723,1,20,0,6),(104152,'DATABASE HANDLER','Ping_DB',2,1,3600000,12,14),(104153,'DATABASE HANDLER','DB_UpdateRT',33314,1,250,5,22),(104154,'EXTRA FUNCTIONS HANDLER','Gestione_Allarmi_Errori',16661,1,500,0,4),(104155,'EXTRA FUNCTIONS HANDLER','Check_USB',4165,1,2000,0,7),(104156,'EXTRA FUNCTIONS HANDLER','Check_Pending_Update',1666,1,5000,0,1),(104157,'EXTRA FUNCTIONS HANDLER','DB_Update_Debug_TaskHnd_RT',4165,1,2000,13,32),(104158,'EXTRA FUNCTIONS HANDLER','Update_Sim_Devices',83254,1,100,0,1),(104159,'TIMER HANDLER','Gestione_Timer_5s',1666,1,5000,0,1),(104160,'TIMER HANDLER','Gestione_Timer_1s',8332,1,1000,0,8),(104161,'TIMER HANDLER','Gestione_Timer_250ms',33312,1,250,0,11),(104162,'COMMUNICATION HANDLER','Gestione_PC_RX',166221,1,50,0,1),(104163,'COMMUNICATION HANDLER','Gestione_PC_TX',166223,1,50,0,1),(104164,'COMMUNICATION HANDLER','Gestione_Stampante_TX',27763,1,300,0,1);

--
-- Table structure for table `DLV_END_TYPES`
--

CREATE TABLE `DLV_END_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `DLV_END_TYPES`
--

INSERT INTO `DLV_END_TYPES` VALUES (1,'STR_Preset_quantity'),(2,'STR_Manual_stop'),(3,'STR_Pulse_timeout'),(4,'STR_Error'),(5,'STR_Alarm'),(6,'STR_Power_off');

--
-- Table structure for table `D_PROBES`
--

CREATE TABLE `D_PROBES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Enable` tinyint(1) DEFAULT 0,
  `Name` varchar(32) DEFAULT 'NEW 4-20MA',
  `Hw_Port` int(11) DEFAULT 1,
  `Offset` float DEFAULT 0,
  `Min_AD` int(11) DEFAULT 100,
  `Min_Value` float DEFAULT 500,
  `Max_AD` int(11) DEFAULT 4095,
  `Max_Value` float DEFAULT 1200,
  `Manual_Value` float DEFAULT 650,
  `Id_Err_Hnd` int(11) DEFAULT 1,
  `Order_Idx` int(11) DEFAULT NULL,
  `Menu_Group` int(11) DEFAULT 0,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `D_PROBES`
--

INSERT INTO `D_PROBES` VALUES (1,1,'DENSITA',1000,0,0,0,0,0,650,1,NULL,NULL);

--
-- Table structure for table `D_PROBES_RT`
--

CREATE TABLE `D_PROBES_RT` (
  `Id_D_Probe` int(11) DEFAULT NULL,
  `RT_Value` float(6,2) DEFAULT NULL,
  KEY `Id_D_Probe` (`Id_D_Probe`)
);

--
-- Dumping data for table `D_PROBES_RT`
--

INSERT INTO `D_PROBES_RT` VALUES (1,0.00);

--
-- Table structure for table `ENCODER_TYPES`
--

CREATE TABLE `ENCODER_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `ENCODER_TYPES`
--

INSERT INTO `ENCODER_TYPES` VALUES (3,'STR_Bichannel'),(1,'STR_Monochannel_A'),(2,'STR_Monochannel_B');

--
-- Table structure for table `EVENT_LOG`
--

CREATE TABLE `EVENT_LOG` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Id_Event_Type` int(11) DEFAULT NULL,
  `Id_Event_Sel` int(11) DEFAULT NULL,
  `Id_User` int(11) DEFAULT NULL,
  `WM_On` tinyint(1) DEFAULT NULL,
  `Download_TS` datetime DEFAULT NULL,
  `Record_TS` datetime,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `EVENT_LOG`
--

INSERT INTO `EVENT_LOG` VALUES (1,3,0,1,0,NULL,'2020-01-17 09:58:36'),(2,7,1,1,0,NULL,'2020-01-17 09:58:36'),(3,8,1,1,1,NULL,'2020-01-17 09:59:08'),(4,7,2,1,0,NULL,'2020-01-17 14:04:49'),(5,8,8902,1,1,NULL,'2020-01-17 14:49:04'),(6,1,1,1,1,NULL,'2020-01-17 16:18:12'),(7,8,2,0,0,NULL,'2020-01-17 16:28:49'),(8,7,3,1,0,NULL,'2020-01-17 16:28:55'),(9,7,4,1,0,NULL,'2020-01-17 16:32:26'),(10,7,5,1,0,NULL,'2020-01-17 16:35:47'),(11,7,6,1,0,NULL,'2020-01-17 17:03:41'),(12,3,1,1,1,NULL,'2020-01-20 10:54:41'),(13,3,2,1,1,NULL,'2020-01-20 10:54:42'),(14,3,0,1,0,NULL,'2020-01-20 11:06:44'),(15,7,7,1,0,NULL,'2020-01-20 11:06:44'),(16,7,8,1,0,NULL,'2020-01-20 11:09:11'),(17,3,3,1,1,NULL,'2020-01-20 11:13:45'),(18,3,4,1,1,NULL,'2020-01-20 11:14:31'),(19,3,0,1,0,NULL,'2020-01-20 11:43:51'),(20,7,9,1,0,NULL,'2020-01-20 11:43:52'),(21,7,10,1,0,NULL,'2020-01-20 11:54:21'),(22,7,11,1,0,NULL,'2020-01-20 11:59:14'),(23,7,12,1,0,NULL,'2020-01-20 12:09:23'),(24,3,5,1,1,NULL,'2020-01-20 12:10:25'),(25,3,0,1,0,NULL,'2020-01-20 12:19:25'),(26,7,13,1,0,NULL,'2020-01-20 12:19:25'),(27,7,14,1,0,NULL,'2020-01-20 12:19:49'),(28,7,15,1,0,NULL,'2020-01-20 12:20:28'),(29,7,16,1,0,NULL,'2020-01-20 12:22:57'),(30,7,17,1,0,NULL,'2020-01-20 13:17:34'),(31,7,18,1,0,NULL,'2020-01-20 13:20:09'),(32,7,19,1,0,NULL,'2020-01-20 13:22:58'),(33,7,20,1,0,NULL,'2020-01-20 13:57:03'),(34,3,6,1,1,NULL,'2020-01-20 13:58:05'),(35,3,7,1,1,NULL,'2020-01-20 13:58:42'),(36,3,0,1,0,NULL,'2020-01-20 14:05:28'),(37,7,21,1,0,NULL,'2020-01-20 14:05:30'),(38,7,22,1,0,NULL,'2020-01-20 14:07:23'),(39,7,23,1,0,NULL,'2020-01-20 14:11:36'),(40,7,24,1,0,NULL,'2020-01-20 14:14:13'),(41,7,25,1,0,NULL,'2020-01-20 14:18:42'),(42,7,26,1,0,NULL,'2020-01-20 14:29:58'),(43,7,27,1,0,NULL,'2020-01-20 14:35:44'),(44,7,28,1,0,NULL,'2020-01-20 14:37:48'),(45,7,29,1,0,NULL,'2020-01-20 14:39:20'),(46,7,30,1,0,NULL,'2020-01-20 14:41:38'),(47,7,31,1,0,NULL,'2020-01-20 14:42:32'),(48,7,32,1,0,NULL,'2020-01-20 14:45:26'),(49,7,33,1,0,NULL,'2020-01-20 15:27:56'),(50,7,34,1,0,NULL,'2020-01-20 15:33:36'),(51,7,35,1,0,NULL,'2020-01-20 15:36:00'),(52,7,36,1,0,NULL,'2020-01-20 15:37:25'),(53,7,37,1,0,NULL,'2020-01-20 15:38:58'),(54,7,38,1,0,NULL,'2020-01-20 16:05:58'),(55,7,39,1,0,NULL,'2020-01-20 16:08:54'),(56,8,3,1,1,NULL,'2020-01-20 16:10:10'),(57,7,40,1,0,NULL,'2020-01-20 16:27:08'),(58,7,41,1,0,NULL,'2020-01-20 16:30:25'),(59,7,42,1,0,NULL,'2020-01-20 16:34:42'),(60,7,43,1,0,NULL,'2020-01-20 16:38:43'),(61,8,921429,1,1,NULL,'2020-01-20 16:45:12'),(62,7,44,1,0,NULL,'2020-01-21 08:39:44'),(63,7,45,1,0,NULL,'2020-01-21 09:01:21'),(64,7,46,1,0,NULL,'2020-01-21 09:13:20'),(65,8,0,1,0,NULL,'2020-01-21 09:41:25'),(66,7,47,1,0,NULL,'2020-01-21 09:41:27'),(67,7,48,1,0,NULL,'2020-01-21 09:48:04'),(68,7,49,1,0,NULL,'2020-01-21 10:20:37'),(69,7,50,1,0,NULL,'2020-01-21 10:24:45'),(70,4,1,1,0,NULL,'2020-01-21 10:30:28'),(71,8,1148188,2,1,NULL,'2020-01-21 11:29:32'),(72,7,51,1,0,NULL,'2020-01-21 11:31:00'),(73,7,52,1,0,NULL,'2020-01-21 11:48:35'),(74,7,53,1,0,NULL,'2020-01-21 12:07:33'),(75,8,1171914,1,1,NULL,'2020-01-21 14:05:30'),(76,4,2,1,1,NULL,'2020-01-21 14:51:53'),(77,8,1179134,1,1,NULL,'2020-01-21 14:53:39'),(78,8,0,1,0,NULL,'2020-01-21 15:16:18'),(79,7,54,1,0,NULL,'2020-01-21 15:16:19'),(80,8,1182496,2,1,NULL,'2020-01-21 15:17:31'),(81,7,55,1,0,NULL,'2020-01-21 15:21:17'),(82,8,1183075,2,1,NULL,'2020-01-21 15:22:05'),(83,8,1183152,1,1,NULL,'2020-01-21 15:22:35'),(84,4,3,1,1,NULL,'2020-01-21 16:11:22'),(85,8,4,0,0,NULL,'2019-02-14 11:12:10'),(86,8,5,0,0,NULL,'2019-02-14 11:12:10'),(87,7,56,1,0,NULL,'2019-02-14 11:12:11'),(88,7,57,1,0,NULL,'2019-02-14 11:12:13'),(89,7,58,1,0,NULL,'2019-02-14 11:12:11'),(90,7,59,1,0,NULL,'2019-02-14 11:12:09');

--
-- Table structure for table `EVENT_LOG_RT`
--

CREATE TABLE `EVENT_LOG_RT` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Id_Event_Type` int(11) DEFAULT NULL,
  `Id_Event_RT_Sel` int(11) DEFAULT NULL,
  `Id_User` int(11) DEFAULT NULL,
  `WM_On` tinyint(1) DEFAULT NULL,
  `Start_TS` datetime,
  PRIMARY KEY (`Id`),
  KEY `Id_Event_Type` (`Id_Event_Type`),
  KEY `Id_User` (`Id_User`)
);

--
-- Dumping data for table `EVENT_LOG_RT`
--


--
-- Table structure for table `EVENT_TYPES`
--

CREATE TABLE `EVENT_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  `Table_Name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `EVENT_TYPES`
--

INSERT INTO `EVENT_TYPES` VALUES (1,'STR_Delivery','EV_DELIVERY_LOG'),(2,'STR_Leakage','EV_LEAKAGE_LOG'),(3,'STR_Error','EV_ERROR_LOG'),(4,'STR_Test','EV_TEST_LOG'),(5,'STR_Reset','EV_RESET_LOG'),(6,'STR_Sleep','EV_SLEEP_LOG'),(7,'STR_Power_on','EV_POWERON_LOG'),(8,'STR_Setup','EV_SETUP_LOG');

--
-- Table structure for table `EV_DELIVERY_LOG`
--

CREATE TABLE `EV_DELIVERY_LOG` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Id_Scenario` int(11) DEFAULT NULL,
  `Id_Meter` int(11) DEFAULT NULL,
  `Meter_Name` varchar(32) DEFAULT NULL,
  `Id_Product` int(11) DEFAULT NULL,
  `Product_Name` varchar(32) DEFAULT NULL,
  `Id_Ret_Product` int(11) DEFAULT NULL,
  `Ret_Product_Name` varchar(32) DEFAULT NULL,
  `Id_Hose` int(11) DEFAULT NULL,
  `Hose_Name` varchar(32) DEFAULT NULL,
  `Id_Compartment` int(11) DEFAULT NULL,
  `Id_Ret_Compartment` int(11) DEFAULT NULL,
  `Compartment_Seq` varchar(32) DEFAULT NULL,
  `Sales_Num` int(11) DEFAULT NULL,
  `Load_Num` int(11) DEFAULT NULL,
  `Id_Preset_Type` int(11) DEFAULT NULL,
  `Preset` float(16,2) DEFAULT NULL,
  `Gross_Vol` float(16,2) DEFAULT NULL,
  `Net_Vol` float(16,2) DEFAULT NULL,
  `Mass` float(16,2) DEFAULT NULL,
  `Gross_Tot_Start` double(16,2) DEFAULT NULL,
  `Net_Tot_Start` double(16,2) DEFAULT NULL,
  `Mass_Tot_Start` double(16,2) DEFAULT NULL,
  `Gross_Tot_End` double(16,2) DEFAULT NULL,
  `Net_Tot_End` double(16,2) DEFAULT NULL,
  `Mass_Tot_End` double(16,2) DEFAULT NULL,
  `Avg_Temperature` float DEFAULT NULL,
  `Avg_Density` float DEFAULT NULL,
  `Tref` float DEFAULT NULL,
  `Aref` float DEFAULT NULL,
  `Dref` float DEFAULT NULL,
  `Num_Stop` int(11) DEFAULT NULL,
  `Num_Poff` int(11) DEFAULT NULL,
  `Empty_Sensor` tinyint(1) DEFAULT NULL,
  `Id_Dlv_End_Type` int(11) DEFAULT NULL,
  `Id_UOM_Vol` int(11) DEFAULT NULL,
  `Id_UOM_Mass` int(11) DEFAULT NULL,
  `Id_UOM_Density` int(11) DEFAULT NULL,
  `Id_UOM_Temp` int(11) DEFAULT NULL,
  `Id_UOM_Flow` int(11) DEFAULT NULL,
  `Start_TS` datetime DEFAULT NULL,
  `End_TS` datetime DEFAULT NULL,
  `Id_UOM_Flow_Mass` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `EV_DELIVERY_LOG`
--

INSERT INTO `EV_DELIVERY_LOG` VALUES (1,1,1,'METER 1',1,'GASOLINE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,109,NULL,2,1000.00,0.00,0.00,0.00,39099.68,34765.46,0.00,39099.68,34765.46,0.00,999.9,0,15,0.00288,765,0,0,NULL,4,1,1,1,1,1,'2020-01-17 16:18:00','2020-01-17 16:18:11',1);

--
-- Table structure for table `EV_DELIVERY_LOG_RT`
--

CREATE TABLE `EV_DELIVERY_LOG_RT` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Id_Scenario` int(11) DEFAULT NULL,
  `Id_Meter` int(11) DEFAULT NULL,
  `Meter_Name` varchar(32) DEFAULT NULL,
  `Id_Product` int(11) DEFAULT NULL,
  `Product_Name` varchar(32) DEFAULT NULL,
  `Id_Ret_Product` int(11) DEFAULT NULL,
  `Ret_Product_Name` varchar(32) DEFAULT NULL,
  `Id_Hose` int(11) DEFAULT NULL,
  `Hose_Name` varchar(32) DEFAULT NULL,
  `Id_Compartment` int(11) DEFAULT NULL,
  `Id_Ret_Compartment` int(11) DEFAULT NULL,
  `Compartment_Seq` varchar(32) DEFAULT NULL,
  `Sales_Num` int(11) DEFAULT NULL,
  `Load_Num` int(11) DEFAULT NULL,
  `Id_Preset_Type` int(11) DEFAULT NULL,
  `Preset` float DEFAULT NULL,
  `Gross_Vol` float DEFAULT NULL,
  `Net_Vol` float DEFAULT NULL,
  `Mass` float DEFAULT NULL,
  `Gross_Tot_Start` double DEFAULT NULL,
  `Net_Tot_Start` double DEFAULT NULL,
  `Mass_Tot_Start` double DEFAULT NULL,
  `Gross_Tot_End` double DEFAULT NULL,
  `Net_Tot_End` double DEFAULT NULL,
  `Mass_Tot_End` double DEFAULT NULL,
  `Avg_Temperature` float DEFAULT NULL,
  `Avg_Density` float DEFAULT NULL,
  `Tref` float DEFAULT NULL,
  `Aref` float DEFAULT NULL,
  `Dref` float DEFAULT NULL,
  `Num_Stop` int(11) DEFAULT NULL,
  `Num_Poff` int(11) DEFAULT NULL,
  `Empty_Sensor` tinyint(1) DEFAULT NULL,
  `Id_Dlv_End_Type` int(11) DEFAULT NULL,
  `Id_UOM_Vol` int(11) DEFAULT NULL,
  `Id_UOM_Mass` int(11) DEFAULT NULL,
  `Id_UOM_Density` int(11) DEFAULT NULL,
  `Id_UOM_Temp` int(11) DEFAULT NULL,
  `Id_UOM_Flow` int(11) DEFAULT NULL,
  `Start_TS` datetime,
  `End_TS` datetime DEFAULT NULL,
  `Id_UOM_Flow_Mass` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `Id_Scenario` (`Id_Scenario`),
  KEY `Id_Meter` (`Id_Meter`),
  KEY `Id_Product` (`Id_Product`),
  KEY `Id_Ret_Product` (`Id_Ret_Product`),
  KEY `Id_Hose` (`Id_Hose`),
  KEY `Id_Compartment` (`Id_Compartment`),
  KEY `Id_Ret_Compartment` (`Id_Ret_Compartment`),
  KEY `Id_Preset_Type` (`Id_Preset_Type`),
  KEY `Id_Dlv_End_Type` (`Id_Dlv_End_Type`),
  KEY `Id_UOM_Vol` (`Id_UOM_Vol`),
  KEY `Id_UOM_Mass` (`Id_UOM_Mass`),
  KEY `Id_UOM_Density` (`Id_UOM_Density`),
  KEY `Id_UOM_Temp` (`Id_UOM_Temp`),
  KEY `Id_UOM_Flow` (`Id_UOM_Flow`),
  KEY `Id_UOM_Flow_Mass` (`Id_UOM_Flow_Mass`)
);

--
-- Dumping data for table `EV_DELIVERY_LOG_RT`
--


--
-- Table structure for table `EV_ERROR_LOG`
--

CREATE TABLE `EV_ERROR_LOG` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Error_Num` int(11) DEFAULT NULL,
  `Notes` text DEFAULT NULL,
  `Start_TS` datetime DEFAULT NULL,
  `End_TS` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `EV_ERROR_LOG`
--

INSERT INTO `EV_ERROR_LOG` VALUES (1,777,'C6.60 S0 L0','2020-01-20 10:54:41','2020-01-20 10:54:41'),(2,777,'C6.60 S0 L0','2020-01-20 10:54:42','2020-01-20 10:54:42'),(3,777,'C6.60 S0 L0','2020-01-20 11:13:45','2020-01-20 11:13:45'),(4,777,'C6.60 S0 L0','2020-01-20 11:14:31','2020-01-20 11:14:31'),(5,777,'C6.60 S0 L0','2020-01-20 12:10:25','2020-01-20 12:10:25'),(6,777,'C6.60 S0 L0','2020-01-20 13:58:05','2020-01-20 13:58:05'),(7,777,'C6.60 S0 L0','2020-01-20 13:58:42','2020-01-20 13:58:42');

--
-- Table structure for table `EV_ERROR_LOG_RT`
--

CREATE TABLE `EV_ERROR_LOG_RT` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Error_Num` int(11) DEFAULT NULL,
  `Start_TS` datetime,
  `End_TS` datetime DEFAULT NULL,
  `Notes` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `EV_ERROR_LOG_RT`
--


--
-- Table structure for table `EV_LEAKAGE_LOG`
--

CREATE TABLE `EV_LEAKAGE_LOG` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Id_Meter` int(11) DEFAULT NULL,
  `Meter_Name` varchar(32) DEFAULT NULL,
  `Gross_Vol` float(16,2) DEFAULT NULL,
  `Id_UOM_Vol` int(11) DEFAULT NULL,
  `Start_TS` datetime,
  `End_TS` datetime DEFAULT NULL,
  `Id_Scenario` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `EV_LEAKAGE_LOG`
--


--
-- Table structure for table `EV_LEAKAGE_LOG_RT`
--

CREATE TABLE `EV_LEAKAGE_LOG_RT` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Id_Meter` int(11) DEFAULT NULL,
  `Meter_Name` varchar(32) DEFAULT NULL,
  `Gross_Vol` float DEFAULT NULL,
  `Id_UOM_Vol` int(11) DEFAULT NULL,
  `Start_TS` datetime,
  `End_TS` datetime DEFAULT NULL,
  `Id_Scenario` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `Id_Meter` (`Id_Meter`),
  KEY `Id_UOM_Vol` (`Id_UOM_Vol`),
  KEY `Id_Scenario` (`Id_Scenario`)
);

--
-- Dumping data for table `EV_LEAKAGE_LOG_RT`
--


--
-- Table structure for table `EV_POWERON_LOG`
--

CREATE TABLE `EV_POWERON_LOG` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Start_TS` datetime DEFAULT NULL,
  `End_TS` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `EV_POWERON_LOG`
--

INSERT INTO `EV_POWERON_LOG` VALUES (1,'2020-01-17 09:58:36','2020-01-17 09:58:36'),(2,'2020-01-17 14:04:49','2020-01-17 14:04:49'),(3,'2020-01-17 16:28:55','2020-01-17 16:28:55'),(4,'2020-01-17 16:32:26','2020-01-17 16:32:26'),(5,'2020-01-17 16:35:46','2020-01-17 16:35:46'),(6,'2020-01-17 17:03:40','2020-01-17 17:03:40'),(7,'2020-01-20 11:06:44','2020-01-20 11:06:44'),(8,'2020-01-20 11:09:10','2020-01-20 11:09:10'),(9,'2020-01-20 11:43:52','2020-01-20 11:43:52'),(10,'2020-01-20 11:54:20','2020-01-20 11:54:20'),(11,'2020-01-20 11:59:13','2020-01-20 11:59:13'),(12,'2020-01-20 12:09:22','2020-01-20 12:09:22'),(13,'2020-01-20 12:19:25','2020-01-20 12:19:25'),(14,'2020-01-20 12:19:48','2020-01-20 12:19:48'),(15,'2020-01-20 12:20:28','2020-01-20 12:20:28'),(16,'2020-01-20 12:22:56','2020-01-20 12:22:56'),(17,'2020-01-20 13:17:33','2020-01-20 13:17:33'),(18,'2020-01-20 13:20:08','2020-01-20 13:20:08'),(19,'2020-01-20 13:22:57','2020-01-20 13:22:57'),(20,'2020-01-20 13:57:01','2020-01-20 13:57:01'),(21,'2020-01-20 14:05:29','2020-01-20 14:05:30'),(22,'2020-01-20 14:07:22','2020-01-20 14:07:22'),(23,'2020-01-20 14:11:35','2020-01-20 14:11:35'),(24,'2020-01-20 14:14:13','2020-01-20 14:14:13'),(25,'2020-01-20 14:18:42','2020-01-20 14:18:42'),(26,'2020-01-20 14:29:57','2020-01-20 14:29:57'),(27,'2020-01-20 14:35:44','2020-01-20 14:35:44'),(28,'2020-01-20 14:37:47','2020-01-20 14:37:47'),(29,'2020-01-20 14:39:20','2020-01-20 14:39:20'),(30,'2020-01-20 14:41:38','2020-01-20 14:41:38'),(31,'2020-01-20 14:42:30','2020-01-20 14:42:30'),(32,'2020-01-20 14:45:26','2020-01-20 14:45:26'),(33,'2020-01-20 15:27:56','2020-01-20 15:27:56'),(34,'2020-01-20 15:33:35','2020-01-20 15:33:35'),(35,'2020-01-20 15:35:59','2020-01-20 15:35:59'),(36,'2020-01-20 15:37:25','2020-01-20 15:37:25'),(37,'2020-01-20 15:38:57','2020-01-20 15:38:57'),(38,'2020-01-20 16:05:57','2020-01-20 16:05:57'),(39,'2020-01-20 16:08:52','2020-01-20 16:08:52'),(40,'2020-01-20 16:27:07','2020-01-20 16:27:07'),(41,'2020-01-20 16:30:24','2020-01-20 16:30:24'),(42,'2020-01-20 16:34:42','2020-01-20 16:34:42'),(43,'2020-01-20 16:38:41','2020-01-20 16:38:41'),(44,'2020-01-21 08:39:44','2020-01-21 08:39:44'),(45,'2020-01-21 09:01:20','2020-01-21 09:01:20'),(46,'2020-01-21 09:13:19','2020-01-21 09:13:19'),(47,'2020-01-21 09:41:27','2020-01-21 09:41:27'),(48,'2020-01-21 09:48:03','2020-01-21 09:48:03'),(49,'2020-01-21 10:20:36','2020-01-21 10:20:36'),(50,'2020-01-21 10:24:45','2020-01-21 10:24:45'),(51,'2020-01-21 11:30:59','2020-01-21 11:30:59'),(52,'2020-01-21 11:48:34','2020-01-21 11:48:34'),(53,'2020-01-21 12:07:32','2020-01-21 12:07:32'),(54,'2020-01-21 15:16:19','2020-01-21 15:16:19'),(55,'2020-01-21 15:21:16','2020-01-21 15:21:16'),(56,'2019-02-14 11:12:11','2019-02-14 11:12:11'),(57,'2019-02-14 11:12:13','2019-02-14 11:12:13'),(58,'2019-02-14 11:12:11','2019-02-14 11:12:11'),(59,'2019-02-14 11:12:09','2019-02-14 11:12:09');

--
-- Table structure for table `EV_POWERON_LOG_RT`
--

CREATE TABLE `EV_POWERON_LOG_RT` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Start_TS` datetime,
  `End_TS` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `EV_POWERON_LOG_RT`
--


--
-- Table structure for table `EV_RESET_LOG`
--

CREATE TABLE `EV_RESET_LOG` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Id_Reset_Type` int(11) DEFAULT NULL,
  `Start_TS` datetime DEFAULT NULL,
  `End_TS` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `EV_RESET_LOG`
--


--
-- Table structure for table `EV_RESET_LOG_RT`
--

CREATE TABLE `EV_RESET_LOG_RT` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Id_Reset_Type` int(11) DEFAULT NULL,
  `Start_TS` datetime,
  `End_TS` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `Id_Reset_Type` (`Id_Reset_Type`)
);

--
-- Dumping data for table `EV_RESET_LOG_RT`
--


--
-- Table structure for table `EV_SETUP_LOG`
--

CREATE TABLE `EV_SETUP_LOG` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Table_Name` varchar(32) DEFAULT NULL,
  `Field_Name` varchar(32) DEFAULT NULL,
  `Old_Value` varchar(32) DEFAULT NULL,
  `New_Value` varchar(32) DEFAULT NULL,
  `Start_TS` datetime DEFAULT NULL,
  `End_TS` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `EV_SETUP_LOG`
--



--
-- Table structure for table `EV_SETUP_LOG_RT`
--

CREATE TABLE `EV_SETUP_LOG_RT` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Table_Name` varchar(32) DEFAULT NULL,
  `Field_Name` varchar(32) DEFAULT NULL,
  `Old_Value` varchar(32) DEFAULT NULL,
  `New_Value` varchar(32) DEFAULT NULL,
  `Start_TS` datetime,
  `End_TS` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `EV_SETUP_LOG_RT`
--


--
-- Table structure for table `EV_SLEEP_LOG`
--

CREATE TABLE `EV_SLEEP_LOG` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Id_Meter` int(11) DEFAULT NULL,
  `Meter_Name` varchar(32) DEFAULT NULL,
  `Gross_Vol` float DEFAULT NULL,
  `Id_UOM_Vol` int(11) DEFAULT NULL,
  `CW_Pulses` int(11) DEFAULT NULL,
  `CCW_Pulses` int(11) DEFAULT NULL,
  `ERR_Pulses` int(11) DEFAULT NULL,
  `Start_TS` datetime DEFAULT NULL,
  `End_TS` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `EV_SLEEP_LOG`
--


--
-- Table structure for table `EV_TEST_LOG`
--

CREATE TABLE `EV_TEST_LOG` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Id_Test_Type` int(11) DEFAULT NULL,
  `Start_TS` datetime DEFAULT NULL,
  `End_TS` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `EV_TEST_LOG`
--

INSERT INTO `EV_TEST_LOG` VALUES (1,1,'2020-01-21 10:29:58','2020-01-21 10:30:27'),(2,1,'2020-01-21 14:26:06','2020-01-21 14:51:53'),(3,1,'2020-01-21 16:04:15','2020-01-21 16:11:21');

--
-- Table structure for table `EV_TEST_LOG_RT`
--

CREATE TABLE `EV_TEST_LOG_RT` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Id_Test_Type` int(11) DEFAULT NULL,
  `Start_TS` datetime,
  `End_TS` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `Id_Test_Type` (`Id_Test_Type`)
);

--
-- Dumping data for table `EV_TEST_LOG_RT`
--


--
-- Table structure for table `FK_REFERENCES`
--

CREATE TABLE `FK_REFERENCES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `SRC_Table` varchar(128) DEFAULT NULL,
  `SRC_Field` varchar(128) DEFAULT NULL,
  `FK_Table` varchar(128) DEFAULT NULL,
  `FK_Field` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `FK_REFERENCES`
--

INSERT INTO `FK_REFERENCES` VALUES (1,'COMPARTMENTS','Id_Product','PRODUCTS','Id'),(2,'CREDENTIALS','Id_User','USERS','Id'),(3,'CREDENTIALS','Id_Level','LEVELS','Id'),(4,'D_PROBES','Id_Err_Hnd','PROBE_ERROR_HND','Id'),(5,'EVENT_LOG','Id_Event_Type','EVENT_TYPES','Id'),(6,'EVENT_LOG','Id_User','USERS','Id'),(7,'EV_DELIVERY_LOG','Id_Scenario','SCENARIO','Id'),(8,'EV_DELIVERY_LOG','Id_UOM_Mass','UOM_MASS','Id'),(9,'EV_DELIVERY_LOG','Id_UOM_Density','UOM_DENSITY','Id'),(10,'EV_DELIVERY_LOG','Id_UOM_Temp','UOM_TEMP','Id'),(11,'EV_DELIVERY_LOG','Id_UOM_Flow','UOM_FLOW','Id'),(12,'EV_DELIVERY_LOG','Id_Preset_Type','PRESET_TYPES','Id'),(13,'EV_DELIVERY_LOG','Id_UOM_Flow_Mass','UOM_FLOW_MASS','Id'),(14,'EV_DELIVERY_LOG','Id_Meter','METERS','Id'),(15,'EV_DELIVERY_LOG','Id_Product','PRODUCTS','Id'),(16,'EV_DELIVERY_LOG','Id_Ret_Product','PRODUCTS','Id'),(17,'EV_DELIVERY_LOG','Id_Hose','HOSES','Id'),(18,'EV_DELIVERY_LOG','Id_Compartment','COMPARTMENTS','Id'),(19,'EV_DELIVERY_LOG','Id_Ret_Compartment','COMPARTMENTS','Id'),(20,'EV_DELIVERY_LOG','Id_Dlv_End_Type','DLV_END_TYPES','Id'),(21,'EV_DELIVERY_LOG','Id_UOM_Vol','UOM_VOL','Id'),(22,'EV_DELIVERY_LOG','Id_User','USERS','Id'),(23,'EV_LEAKAGE_LOG','Id_Meter','METERS','Id'),(24,'EV_LEAKAGE_LOG','Id_UOM_Vol','UOM_VOL','Id'),(25,'EV_LEAKAGE_LOG','Id_Scenario','SCENARIO','Id'),(26,'EV_RESET_LOG','Id_Reset_Type','RESET_TYPES','Id'),(27,'EV_SLEEP_LOG','Id_Meter','METERS','Id'),(28,'EV_SLEEP_LOG','Id_UOM_Vol','UOM_VOL','Id'),(29,'EV_TEST_LOG','Id_Test_Type','TEST_TYPES','Id'),(30,'HOSES','Id_Product','PRODUCTS','Id'),(31,'INPUTS_D','Id_Cmd_Input','INPUT_D_CMD_TYPES','Id'),(32,'METERS','Id_Meter_Type','METER_TYPES','Id'),(33,'METERS_M','Id_Parity_Setting','COM_PARITY_TYPES','Id'),(34,'METERS_M','Id_Value_Type','METER_VALUE_TYPES','Id'),(35,'METERS_M','Id_Pulse_Out_Type','METER_POUT_TYPES','Id'),(36,'METERS_M','Id_Model','METER_M_MODELS','Id'),(37,'METERS_P','Id_Encoder_Type','ENCODER_TYPES','Id'),(38,'METERS_P','Id_Value_Type','METER_VALUE_TYPES','Id'),(39,'METERS_X','Id_Meter_A_Type','METER_TYPES','Id'),(40,'METERS_X','Id_Meter_B_Type','METER_TYPES','Id'),(41,'METERS_X','Id_Meter_X_Type','METER_X_TYPES','Id'),(42,'OUTLETS','Id_Outlet_Type','OUTLET_TYPES','Id'),(43,'OUTPUTS_D','Id_Cmd_Output','OUTPUT_D_CMD_TYPES','Id'),(44,'PIPES','Id_Compartment','COMPARTMENTS','Id'),(45,'PIPES','Id_Meter','METERS','Id'),(46,'PRESET_VALVES','Id_Valve_Type','PRESET_VALVE_TYPES','Id'),(47,'PRINTERS','Id_Layout','TICKET_LAYOUTS','Id'),(48,'PRINTERS','Id_Printer_Type','PRINTER_TYPES','Id'),(49,'PRODUCTS','Id_Commodity','COMMODITY','Id'),(50,'PRODUCTS','Id_Color','COLORS','Id'),(51,'PRODUCTS','Id_Net_Calculation','NET_CALCULATION_TYPES','Id'),(52,'PRODUCT_ERR_CURVE','Id_Product','PRODUCTS','Id'),(53,'PRODUCT_METER_LINK','Id_Product','PRODUCTS','Id'),(54,'PRODUCT_METER_LINK','Id_Meter','METERS','Id'),(55,'SCENARIO_ITEMS','Id_Scenario','SCENARIO','Id'),(56,'SCENARIO_ITEMS','Id_Item_Type','ITEM_TYPES','Id'),(57,'SCREENS','Id_Screen_Layout','SCREEN_LAYOUTS','Id'),(58,'SCREENS','Id_Screen_Detail_1','SCREEN_DETAIL_TYPES','Id'),(59,'SCREENS','Id_Screen_Detail_2','SCREEN_DETAIL_TYPES','Id'),(60,'SCREENS','Id_Screen_Detail_3','SCREEN_DETAIL_TYPES','Id'),(61,'SCREENS','Id_Screen_Detail_4','SCREEN_DETAIL_TYPES','Id'),(62,'SCREENS','Id_Screen_Detail_5','SCREEN_DETAIL_TYPES','Id'),(63,'SCREENS','Id_Screen_Detail_6','SCREEN_DETAIL_TYPES','Id'),(64,'SCREENS','Id_Screen_Detail_7','SCREEN_DETAIL_TYPES','Id'),(65,'SCREENS','Id_Screen_Detail_8','SCREEN_DETAIL_TYPES','Id'),(66,'SYS_SETUP_COM','Id_Level','LEVELS','Id'),(67,'SYS_SETUP_ERRORS','Id_Level','LEVELS','Id'),(68,'SYS_SETUP_OTHERS','Id_Level','LEVELS','Id'),(69,'SYS_SETUP_TIMERS','Id_Level','LEVELS','Id'),(70,'SYS_SETUP_UOMS','Id_UOM_Vol','UOM_VOL','Id'),(71,'SYS_SETUP_UOMS','Id_UOM_Mass','UOM_MASS','Id'),(72,'SYS_SETUP_UOMS','Id_UOM_Density','UOM_DENSITY','Id'),(73,'SYS_SETUP_UOMS','Id_UOM_Flow','UOM_FLOW','Id'),(74,'SYS_SETUP_UOMS','Id_UOM_Temp','UOM_TEMP','Id'),(75,'SYS_SETUP_UOMS','Id_UOM_Flow_Mass','UOM_FLOW_MASS','Id'),(76,'TABLE_CREDENTIAL_LINK','Id_Level_Rd','LEVELS','Id'),(77,'TABLE_CREDENTIAL_LINK','Id_Level_Wr','LEVELS','Id'),(78,'TICKET_LAYOUT_DATA','Id_Layout','TICKET_LAYOUTS','Id'),(79,'TICKET_LAYOUT_DATA','Id_Font','TICKET_FONTS','Id'),(80,'TICKET_LAYOUT_DATA','Id_Field','TICKET_FIELDS','Id'),(81,'T_PROBES','Id_Err_Hnd','PROBE_ERROR_HND','Id'),(82,'PRODUCTS','Id_UOM_Vol','UOM_VOL','Id'),(83,'PRODUCTS','Id_UOM_Mass','UOM_MASS','Id'),(84,'SYS_SETUP_PLATE','Id_Level','LEVELS','Id'),(85,'SYS_SETUP_WIFI','Id_Level','LEVELS','Id'),(86,'USERS','Id_Level','LEVELS','Id');

--
-- Table structure for table `FK_STR`
--

CREATE TABLE `FK_STR` (
  `Table_Name` varchar(32) DEFAULT NULL,
  `Description_Field` varchar(32) DEFAULT NULL,
  `STR_Field` tinyint(1) DEFAULT NULL,
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `FK_STR`
--

INSERT INTO `FK_STR` VALUES ('COLORS','Description_STR',1,1),('COMMODITY','Description_STR',1,2),('COM_PARITY_TYPES','Description_STR',1,3),('D_PROBES','Name',0,4),('ENCODER_TYPES','Description_STR',1,5),('ITEM_TYPES','Description_STR',1,6),('LEVELS','Description',0,7),('METERS','Name',0,8),('METERS_M','Name',0,9),('METERS_P','Name',0,10),('METERS_X','Name',0,11),('METER_M_MODELS','Value',0,12),('METER_POUT_TYPES','Description_STR',1,13),('METER_TYPES','Description_STR',1,14),('METER_VALUE_TYPES','Description_STR',1,15),('METER_X_TYPES','Description_STR',1,16),('NET_CALCULATION_TYPES','Description_STR',1,17),('PRESET_TYPES','Description_STR',1,18),('PRESET_VALVES','Name',0,19),('PRESET_VALVES_S','Name',0,20),('PRESET_VALVE_TYPES','Description_STR',1,21),('PUMPS','Name',0,22),('SCENARIO','Name',0,23),('SETTINGS','Description_STR',1,24),('SETTING_OPTIONS','Description_STR',1,25),('SETTING_TYPES','Description_STR',1,26),('SYS_SETUP_ERRORS','Description_STR',1,27),('SYS_SETUP_OTHERS','Description_STR',1,28),('SYS_SETUP_TIMERS','Description_STR',1,29),('T_PROBES','Name',0,30),('UOM_DENSITY','Tag',0,31),('UOM_FLOW','Tag',0,32),('UOM_FLOW_MASS','Tag',0,33),('UOM_MASS','Tag',0,34),('UOM_TEMP','Tag',0,35),('UOM_VOL','Tag',0,36),('USERS','Name',0,37),('PRODUCTS','Name',0,38),('PROBE_ERROR_HND','Description_STR',1,39),('EVENT_TYPES','Description_STR',1,40),('DLV_END_TYPES','Description_STR',1,41),('TEST_TYPES','Description_STR',1,42),('RESET_TYPES','Description_STR',1,43),('PRINTER_TYPES','Name',0,44),('TICKET_LAYOUTS','Name',0,45),('TICKET_FIELDS','Description_STR',1,46),('SCREEN_LAYOUTS','Name',0,47),('SCREEN_DETAIL_TYPES','Description_STR',1,48),('OUTPUT_D_CMD_TYPES','Description_STR',1,49),('INPUT_D_CMD_TYPES','Description_STR',1,50);

--
-- Table structure for table `HOSES`
--

CREATE TABLE `HOSES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Enable` tinyint(1) DEFAULT NULL,
  `Name` varchar(32) DEFAULT NULL,
  `Volume` float DEFAULT NULL,
  `Id_Product` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `HOSES`
--


--
-- Table structure for table `INFO`
--

CREATE TABLE `INFO` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  `Value` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `INFO`
--

INSERT INTO `INFO` VALUES (1,'Signature','7fc46ca060c0c40683c778d0590e5389'),(2,'Software ver','TEX-STK-01-02-03'),(3,'DB ver','01.03'),(4,'License','-'),(5,'Unique ID','685729730'),(6,'CRC NLR','0xD8C577C1DBDAC0DB'),(7,'CRC LR','0x40F64A7C47A64140'),(8,'Installation date','2019-02-14 11:12:04'),(9,'Pending update','-'),(10,'Update alarm','-');

--
-- Table structure for table `INPUTS_D`
--

CREATE TABLE `INPUTS_D` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Enable` tinyint(1) DEFAULT 0,
  `Name` varchar(32) DEFAULT 'NEW INPUT',
  `Hw_Port` int(11) DEFAULT 1,
  `Inverse` tinyint(1) DEFAULT 0,
  `Id_Cmd_Input` int(11) DEFAULT 1,
  `Cmd_Data` char(128) DEFAULT '-',
  `Order_Idx` int(11) DEFAULT NULL,
  `Menu_Group` int(11) DEFAULT 0,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `INPUTS_D`
--


--
-- Table structure for table `INPUTS_D_RT`
--

CREATE TABLE `INPUTS_D_RT` (
  `Id_Input_D` int(11) DEFAULT NULL,
  `RT_Status` int(11) DEFAULT NULL,
  `En_Forced_Status` tinyint(1) DEFAULT 0,
  `Forced_Status` int(11) DEFAULT 0
);

--
-- Dumping data for table `INPUTS_D_RT`
--


--
-- Table structure for table `INPUT_D_CMD_TYPES`
--

CREATE TABLE `INPUT_D_CMD_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `INPUT_D_CMD_TYPES`
--

INSERT INTO `INPUT_D_CMD_TYPES` VALUES (1,'STR_Permissive'),(2,'STR_Force_LF'),(3,'STR_Force_HF'),(4,'STR_Remote_start'),(5,'STR_Remote_stop');

--
-- Table structure for table `ITEM_TYPES`
--

CREATE TABLE `ITEM_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  `Table_Name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `ITEM_TYPES`
--

INSERT INTO `ITEM_TYPES` VALUES (1,'STR_Meter','METERS'),(2,'STR_Product','PRODUCTS'),(3,'STR_Compartment','COMPARTMENTS'),(4,'STR_Pump','PUMPS'),(5,'STR_Temperature_probe','T_PROBES'),(6,'STR_Preset_valve','PRESET_VALVES'),(7,'STR_Outlet','OUTLETS'),(8,'STR_Printer','PRINTERS'),(9,'STR_Preset_type','PRESET_TYPES'),(10,'STR_Density_probe','D_PROBES'),(11,'STR_Screen','SCREENS'),(12,'STR_Digital_output','OUTPUTS_D'),(13,'STR_Digital_input','INPUTS_D');

--
-- Table structure for table `LANGUAGES`
--

CREATE TABLE `LANGUAGES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(32) DEFAULT NULL,
  `Charset` varchar(32) DEFAULT NULL,
  `Order_Idx` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `LANGUAGES`
--

INSERT INTO `LANGUAGES` VALUES (1,'Italiano','CP437',NULL),(2,'English','CP437',NULL),(3,'Français','CP437',NULL);

--
-- Table structure for table `LEVELS`
--

CREATE TABLE `LEVELS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Enable` tinyint(1) DEFAULT NULL,
  `Description` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `LEVELS`
--

INSERT INTO `LEVELS` VALUES (1,1,'User'),(2,1,'Admin'),(3,1,'Service'),(4,1,'Auditor'),(5,1,'Factory'),(6,1,'Debug');

--
-- Table structure for table `METERS`
--

CREATE TABLE `METERS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Enable` tinyint(1) DEFAULT 0,
  `Name` varchar(32) DEFAULT 'NEW METER',
  `Id_Meter_Type` int(11) DEFAULT 1,
  `Id_Meter_Sel` int(11) DEFAULT 1,
  `Min_Flow` float DEFAULT 50,
  `Max_Flow` float DEFAULT 1000,
  `Order_Idx` int(11) DEFAULT NULL,
  `Menu_Group` int(11) DEFAULT 0,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `METERS`
--

INSERT INTO `METERS` VALUES (1,1,'METER 1',1,1,38,5000,NULL,NULL);

--
-- Table structure for table `METERS_M`
--

CREATE TABLE `METERS_M` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(16) DEFAULT 'MODBUS METER',
  `Hw_Port` int(11) DEFAULT 1,
  `Address` int(11) DEFAULT 247,
  `Baudrate` int(11) DEFAULT 19200,
  `Id_Parity_Setting` int(11) DEFAULT 2,
  `Delay_Tx_Ms` int(11) DEFAULT 10,
  `Id_Value_Type` int(11) DEFAULT 3,
  `Forward_Direction` tinyint(1) DEFAULT 0,
  `Enable_Reverse` tinyint(1) DEFAULT 0,
  `Error_Reverse` tinyint(1) DEFAULT 0,
  `Cut_Off_Value` float DEFAULT 0,
  `Shock_Suppression` float DEFAULT 0,
  `Zero_Point` float DEFAULT 0,
  `Flow_Damping` int(11) DEFAULT 0,
  `Id_Pulse_Out_Type` int(11) DEFAULT 2,
  `Max_Pout_Freq` float DEFAULT 2000,
  `Max_Pout_Flow` float DEFAULT 2000,
  `Density_Gain` float DEFAULT 1,
  `Density_Offset` float DEFAULT 0,
  `Temp_Gain` float DEFAULT 1,
  `Temp_Offset` float DEFAULT 0,
  `Id_Model` int(11) DEFAULT 1,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `METERS_M`
--


--
-- Table structure for table `METERS_P`
--

CREATE TABLE `METERS_P` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(32) DEFAULT 'PULSE METER',
  `Hw_Port` int(11) DEFAULT 1,
  `Value_Rev` float DEFAULT 1,
  `Pulse_Rev` int(11) DEFAULT 100,
  `Id_Encoder_Type` int(11) DEFAULT 1,
  `Check_Invalid` tinyint(1) DEFAULT 1,
  `Invalid_Thr` int(11) DEFAULT 30,
  `Valid_Thr` int(11) DEFAULT 300,
  `Pout_Value` float DEFAULT 1,
  `Power_Min` int(11) DEFAULT 10,
  `Power_Max` int(11) DEFAULT 80,
  `Clockwise` tinyint(1) DEFAULT 1,
  `Id_Value_Type` int(11) DEFAULT 1,
  `Enable_Reverse` tinyint(1) DEFAULT 0,
  `Error_Reverse` tinyint(1) DEFAULT 1,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `METERS_P`
--

INSERT INTO `METERS_P` VALUES (1,'PULSER',9000,6.5,100,3,0,30,300,1,10,50,1,1,0,0);

--
-- Table structure for table `METERS_RT`
--

CREATE TABLE `METERS_RT` (
  `Id_Meter` int(11) DEFAULT NULL,
  `RT_Cw` int(11) DEFAULT NULL,
  `RT_Ccw` int(11) DEFAULT NULL,
  `RT_Err` int(11) DEFAULT NULL,
  `RT_Freq` int(11) DEFAULT NULL,
  `RT_Curr` int(11) DEFAULT NULL,
  `RT_Dlv_Num` int(11) DEFAULT NULL,
  `RT_Gross_Vol` float(16,2) DEFAULT NULL,
  `RT_Net_Vol` float(16,2) DEFAULT NULL,
  `RT_Mass` float(16,2) DEFAULT NULL,
  `RT_Flowrate` float(16,2) DEFAULT NULL,
  `RT_Status` int(11) DEFAULT NULL,
  `RT_ChA` int(11) DEFAULT NULL,
  `RT_ChB` int(11) DEFAULT NULL,
  `RT_En_Gross_Vol` tinyint(1) DEFAULT NULL,
  `RT_En_Net_Vol` tinyint(1) DEFAULT NULL,
  `RT_En_Mass` tinyint(1) DEFAULT NULL,
  `RT_En_Mass_Flow` tinyint(1) DEFAULT NULL,
  KEY `Id_Meter` (`Id_Meter`)
);

--
-- Dumping data for table `METERS_RT`
--

INSERT INTO `METERS_RT` VALUES (1,0,0,0,0,30,0,0.00,0.00,0.00,0.00,0,0,0,1,0,0,0);

--
-- Table structure for table `METERS_X`
--

CREATE TABLE `METERS_X` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(32) DEFAULT 'VIRTUAL METER',
  `Id_Meter_A_Type` int(11) DEFAULT 1,
  `Id_Meter_A_Sel` int(11) DEFAULT 1,
  `Id_Meter_B_Type` int(11) DEFAULT 1,
  `Id_Meter_B_Sel` int(11) DEFAULT 1,
  `Id_Meter_X_Type` int(11) DEFAULT 1,
  `Order_Idx` int(11) DEFAULT NULL,
  `Check_Invalid` tinyint(1) DEFAULT 0,
  `Enable_Reverse` tinyint(1) DEFAULT 0,
  `Error_Reverse` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `METERS_X`
--


--
-- Table structure for table `METER_M_MODELS`
--

CREATE TABLE `METER_M_MODELS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Value` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `METER_M_MODELS`
--

INSERT INTO `METER_M_MODELS` VALUES (1,'E-H- LPG Mass'),(2,'Emerson Mass');

--
-- Table structure for table `METER_POUT_TYPES`
--

CREATE TABLE `METER_POUT_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `METER_POUT_TYPES`
--

INSERT INTO `METER_POUT_TYPES` VALUES (1,'STR_Not_used'),(2,'STR_Mass'),(3,'STR_Gross_vol');

--
-- Table structure for table `METER_TYPES`
--

CREATE TABLE `METER_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  `Table_Name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `METER_TYPES`
--

INSERT INTO `METER_TYPES` VALUES (1,'STR_Meter_pulser','METERS_P'),(2,'STR_Modbus_meter','METERS_M'),(3,'STR_Virtual','METERS_X');

--
-- Table structure for table `METER_VALUE_TYPES`
--

CREATE TABLE `METER_VALUE_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `METER_VALUE_TYPES`
--

INSERT INTO `METER_VALUE_TYPES` VALUES (1,'STR_Gross_vol'),(2,'STR_Net_vol'),(3,'STR_Mass');

--
-- Table structure for table `METER_X_TYPES`
--

CREATE TABLE `METER_X_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `METER_X_TYPES`
--

INSERT INTO `METER_X_TYPES` VALUES (1,'STR_Series_meters');

--
-- Table structure for table `NET_CALCULATION_TYPES`
--

CREATE TABLE `NET_CALCULATION_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `NET_CALCULATION_TYPES`
--

INSERT INTO `NET_CALCULATION_TYPES` VALUES (1,'STR_Not_used'),(2,'STR_Density'),(3,'STR_Alpha');

--
-- Table structure for table `OUTLETS`
--

CREATE TABLE `OUTLETS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Enable` tinyint(1) DEFAULT NULL,
  `Name` varchar(32) DEFAULT NULL,
  `Id_Outlet_Type` int(11) DEFAULT NULL,
  `Id_Outlet_Sel` int(11) DEFAULT NULL,
  `Order_Idx` int(11) DEFAULT NULL,
  `Menu_Group` int(11) DEFAULT 0,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `OUTLETS`
--

INSERT INTO `OUTLETS` VALUES (1,1,'BULK',1,1,NULL,NULL);

--
-- Table structure for table `OUTLET_TYPES`
--

CREATE TABLE `OUTLET_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  `Table_Name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `OUTLET_TYPES`
--

INSERT INTO `OUTLET_TYPES` VALUES (1,'STR_Bulk',NULL),(2,'STR_Hose','HOSES'),(3,'STR_Return',NULL);

--
-- Table structure for table `OUTPUTS_D`
--

CREATE TABLE `OUTPUTS_D` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Enable` tinyint(1) DEFAULT 0,
  `Name` varchar(32) DEFAULT 'NEW OUTPUT',
  `Hw_Port` int(11) DEFAULT 1,
  `Inverse` tinyint(1) DEFAULT 0,
  `Id_Cmd_Output` int(11) DEFAULT 1,
  `Cmd_Data` varchar(128) DEFAULT '-',
  `Order_Idx` int(11) DEFAULT NULL,
  `Menu_Group` int(11) DEFAULT 0,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `OUTPUTS_D`
--

INSERT INTO `OUTPUTS_D` VALUES (1,1,'BF',1,0,2,'0',NULL,NULL),(2,1,'AF',2,0,3,'-',NULL,NULL),(3,1,'PMP',3,0,1,'-',NULL,NULL);

--
-- Table structure for table `OUTPUTS_D_RT`
--

CREATE TABLE `OUTPUTS_D_RT` (
  `RT_Status` int(11) DEFAULT NULL,
  `En_Forced_Status` tinyint(1) DEFAULT NULL,
  `Forced_Status` int(11) DEFAULT NULL,
  `Id_Output_D` int(11) DEFAULT NULL,
  KEY `Id_Output_D` (`Id_Output_D`)
);

--
-- Dumping data for table `OUTPUTS_D_RT`
--

INSERT INTO `OUTPUTS_D_RT` VALUES (0,NULL,NULL,1),(0,NULL,NULL,2),(0,NULL,NULL,3);

--
-- Table structure for table `OUTPUT_D_CMD_TYPES`
--

CREATE TABLE `OUTPUT_D_CMD_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `OUTPUT_D_CMD_TYPES`
--

INSERT INTO `OUTPUT_D_CMD_TYPES` VALUES (1,'STR_Pump_switch'),(2,'STR_LF_valve'),(3,'STR_HF_valve'),(4,'STR_Pulse_out');

--
-- Table structure for table `PIPES`
--

CREATE TABLE `PIPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Id_Compartment` int(11) DEFAULT NULL,
  `Id_Meter` int(11) DEFAULT NULL,
  `Gross_Vol` float DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `PIPES`
--


--
-- Table structure for table `PRESET_TYPES`
--

CREATE TABLE `PRESET_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `PRESET_TYPES`
--

INSERT INTO `PRESET_TYPES` VALUES (1,'STR_Not_used'),(2,'STR_Gross_vol'),(3,'STR_Net_vol'),(4,'STR_Mass');

--
-- Table structure for table `PRESET_VALVES`
--

CREATE TABLE `PRESET_VALVES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Enable` tinyint(1) DEFAULT 0,
  `Name` varchar(32) DEFAULT 'NEW VALVE',
  `Id_Valve_Type` int(11) DEFAULT 1,
  `Id_Valve_Sel` int(11) DEFAULT 1,
  `LF_to_HF` float DEFAULT 50,
  `HF_to_LF` float DEFAULT 50,
  `Pre_stop` float DEFAULT 0,
  `Delay_On` int(11) DEFAULT 0,
  `Order_Idx` int(11) DEFAULT NULL,
  `Menu_Group` int(11) DEFAULT 0,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `PRESET_VALVES`
--

INSERT INTO `PRESET_VALVES` VALUES (1,1,'VALVE 1',1,1,50,50,0,0,NULL,NULL);

--
-- Table structure for table `PRESET_VALVES_D`
--

CREATE TABLE `PRESET_VALVES_D` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(32) DEFAULT NULL,
  `Set_LF` float DEFAULT NULL,
  `Set_HF` float DEFAULT NULL,
  `Tolerance` float DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `PRESET_VALVES_D`
--


--
-- Table structure for table `PRESET_VALVES_RT`
--

CREATE TABLE `PRESET_VALVES_RT` (
  `Id_PValve` int(11) DEFAULT NULL,
  `RT_Status` int(11) DEFAULT NULL,
  KEY `Id_PValve` (`Id_PValve`)
);

--
-- Dumping data for table `PRESET_VALVES_RT`
--

INSERT INTO `PRESET_VALVES_RT` VALUES (1,0);

--
-- Table structure for table `PRESET_VALVES_S`
--

CREATE TABLE `PRESET_VALVES_S` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(32) DEFAULT '2 STAGES VALVE',
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `PRESET_VALVES_S`
--

INSERT INTO `PRESET_VALVES_S` VALUES (1,'VALVE M1');

--
-- Table structure for table `PRESET_VALVE_TYPES`
--

CREATE TABLE `PRESET_VALVE_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  `Table_Name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `PRESET_VALVE_TYPES`
--

INSERT INTO `PRESET_VALVE_TYPES` VALUES (1,'STR_Two_stages','PRESET_VALVES_S');

--
-- Table structure for table `PRINTERS`
--

CREATE TABLE `PRINTERS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Enable` tinyint(1) DEFAULT NULL,
  `Name` varchar(32) DEFAULT NULL,
  `Id_Printer_Type` int(11) DEFAULT NULL,
  `Id_Printer_Sel` int(11) DEFAULT NULL,
  `Id_Layout` int(11) DEFAULT NULL,
  `Order_Idx` int(11) DEFAULT NULL,
  `Menu_Group` int(11) DEFAULT 0,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `PRINTERS`
--

INSERT INTO `PRINTERS` VALUES (1,1,'STAMPANTE',1,1,1,NULL,NULL);

--
-- Table structure for table `PRINTERS_TM295`
--

CREATE TABLE `PRINTERS_TM295` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(32) DEFAULT NULL,
  `Hw_Port` int(11) DEFAULT NULL,
  `Baud` int(11) DEFAULT NULL,
  `Xon_Xoff` tinyint(1) DEFAULT NULL,
  `En_Buttons` tinyint(1) DEFAULT NULL,
  `En_Autoeject` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `PRINTERS_TM295`
--

INSERT INTO `PRINTERS_TM295` VALUES (1,'EPSON',1,9600,0,1,1);

--
-- Table structure for table `PRINTER_TYPES`
--

CREATE TABLE `PRINTER_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(32) DEFAULT NULL,
  `Table_Name` varchar(32) DEFAULT NULL,
  `Handler_Time` int(11) DEFAULT 300,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `PRINTER_TYPES`
--

INSERT INTO `PRINTER_TYPES` VALUES (1,'PDF','PRINTERS_PDF',300),(2,'EPSON TM295','PRINTERS_TM295',300);

--
-- Table structure for table `PROBE_ERROR_HND`
--

CREATE TABLE `PROBE_ERROR_HND` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `PROBE_ERROR_HND`
--

INSERT INTO `PROBE_ERROR_HND` VALUES (1,'STR_Not_used'),(2,'STR_System_error'),(3,'STR_Latest_value'),(4,'STR_Manual_value');

--
-- Table structure for table `PRODUCTS`
--

CREATE TABLE `PRODUCTS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Enable` tinyint(1) DEFAULT 0,
  `Name` varchar(32) DEFAULT 'NEW PRODUCT',
  `Shortname` varchar(8) DEFAULT 'NEW',
  `ADR` varchar(16) DEFAULT '-',
  `Id_Commodity` int(11) DEFAULT 3,
  `Id_Color` int(11) DEFAULT 2,
  `Tref` float DEFAULT 15,
  `Aref` float DEFAULT 0.00288,
  `Dref` float DEFAULT 750,
  `Static_Err_Gross` float DEFAULT 0,
  `Dlv_Num` int(11) DEFAULT 0,
  `Gross_Tot` double(16,2) DEFAULT NULL,
  `Net_Tot` double(16,2) DEFAULT NULL,
  `Mass_Tot` double(16,2) DEFAULT NULL,
  `Order_Idx` int(11) DEFAULT 0,
  `Id_Net_Calculation` int(11) DEFAULT 1,
  `Static_Err_Net` float DEFAULT 0,
  `Static_Err_Mass` float DEFAULT 0,
  `Min_Preset_Qty` float DEFAULT 0,
  `Max_Preset_Qty` float DEFAULT 999999,
  `Menu_Group` int(11) DEFAULT 0,
  `Id_UOM_Vol` int(11) DEFAULT 1,
  `Id_UOM_Mass` int(11) DEFAULT 1,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `PRODUCTS`
--

INSERT INTO `PRODUCTS` VALUES (1,1,'GASOLINE','GAS','ADR111',3,18,15,0.00288,765,0,109,39099.68,34765.46,0.00,0,2,0,0,50,99000,NULL,1,1),(2,1,'DIESEL','DSL','ADR222',6,1,15,0.00288,840,0,28,50393.50,2120.57,87.92,1,2,0,0,50,99900,NULL,1,1);

--
-- Table structure for table `PRODUCTS_RT`
--

CREATE TABLE `PRODUCTS_RT` (
  `Id_Product` int(11) DEFAULT NULL,
  `RT_Dlv_Num` int(11) DEFAULT NULL,
  `RT_Gross_Vol` float(16,2) DEFAULT NULL,
  `RT_Net_Vol` float(16,2) DEFAULT NULL,
  `RT_Mass` float(16,2) DEFAULT NULL,
  `RT_Flowrate` float(16,2) DEFAULT NULL,
  `RT_Temperature` float DEFAULT NULL,
  `RT_Density` float DEFAULT NULL,
  `RT_Gross_Tot` double(16,2) DEFAULT NULL,
  `RT_Net_Tot` double(16,2) DEFAULT NULL,
  `RT_Mass_Tot` double(16,2) DEFAULT NULL,
  `RT_Id_Preset_Type` int(11) DEFAULT NULL,
  `RT_Preset` float(16,2) DEFAULT NULL,
  KEY `Id_Product` (`Id_Product`),
  KEY `RT_Id_Preset_Type` (`RT_Id_Preset_Type`)
);

--
-- Dumping data for table `PRODUCTS_RT`
--

INSERT INTO `PRODUCTS_RT` VALUES (1,0,0.00,0.00,0.00,0.00,0,0,0.00,0.00,0.00,2,0.00),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `PRODUCT_ERR_CURVE`
--

CREATE TABLE `PRODUCT_ERR_CURVE` (
  `Id_Product` int(11) DEFAULT NULL,
  `Flowrate` float DEFAULT NULL,
  `Error` float DEFAULT NULL,
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `PRODUCT_ERR_CURVE`
--


--
-- Table structure for table `PRODUCT_METER_LINK`
--

CREATE TABLE `PRODUCT_METER_LINK` (
  `Id_Product` int(11) DEFAULT NULL,
  `Id_Meter` int(11) DEFAULT NULL,
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `PRODUCT_METER_LINK`
--

INSERT INTO `PRODUCT_METER_LINK` VALUES (1,1,1),(2,1,2);

--
-- Table structure for table `PUMPS`
--

CREATE TABLE `PUMPS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Enable` tinyint(1) DEFAULT 0,
  `Name` varchar(32) DEFAULT 'NEW PUMP',
  `Delay_On` int(11) DEFAULT 2,
  `Pause_Off` tinyint(1) DEFAULT 0,
  `Order_Idx` int(11) DEFAULT NULL,
  `Menu_Group` int(11) DEFAULT 0,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `PUMPS`
--

INSERT INTO `PUMPS` VALUES (1,1,'PUMP 1',-3000,0,NULL,NULL);

--
-- Table structure for table `PUMPS_RT`
--

CREATE TABLE `PUMPS_RT` (
  `Id_Pump` int(11) DEFAULT NULL,
  `RT_Status` int(11) DEFAULT NULL,
  KEY `Id_Pump` (`Id_Pump`)
);

--
-- Dumping data for table `PUMPS_RT`
--

INSERT INTO `PUMPS_RT` VALUES (1,0);

--
-- Table structure for table `RESET_TYPES`
--

CREATE TABLE `RESET_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `RESET_TYPES`
--

INSERT INTO `RESET_TYPES` VALUES (1,'STR_PARAMETERS'),(2,'STR_EVENTS'),(3,'STR_TOTALIZERS'),(4,'STR_FACTORY_RESET');

--
-- Table structure for table `SCENARIO`
--

CREATE TABLE `SCENARIO` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Enable` tinyint(1) DEFAULT 0,
  `Name` varchar(32) DEFAULT 'NEW SCENARIO',
  `Order_Idx` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `SCENARIO`
--

INSERT INTO `SCENARIO` VALUES (1,1,'PUMP + PRINT',1);

--
-- Table structure for table `SCENARIO_CMD`
--

CREATE TABLE `SCENARIO_CMD` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Id_Path` int(11) DEFAULT NULL,
  `Id_Cmd_Scenario` int(11) DEFAULT NULL,
  `Cmd_Data` varchar(128) DEFAULT '0',
  `Create_TS` datetime,
  `Process_TS` datetime DEFAULT NULL,
  `Id_Cmd_Return` int(11) DEFAULT NULL,
  `Cmd_Ret` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `Id_Cmd_Scenario` (`Id_Cmd_Scenario`),
  KEY `Id_Cmd_Return` (`Id_Cmd_Return`)
);

--
-- Dumping data for table `SCENARIO_CMD`
--


--
-- Table structure for table `SCENARIO_CMD_RET_TYPES`
--

CREATE TABLE `SCENARIO_CMD_RET_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `SCENARIO_CMD_RET_TYPES`
--

INSERT INTO `SCENARIO_CMD_RET_TYPES` VALUES (1,'Command executed'),(2,'User not allowed'),(3,'Command denied'),(4,'Command refused'),(5,'Error returned'),(6,'Command unknown');

--
-- Table structure for table `SCENARIO_CMD_TYPES`
--

CREATE TABLE `SCENARIO_CMD_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `SCENARIO_CMD_TYPES`
--

INSERT INTO `SCENARIO_CMD_TYPES` VALUES (1,'Set active product'),(2,'Set preset quantity'),(3,'Start delivery'),(4,'Pause delivery'),(5,'End delivery'),(6,'Jump to awaiting delivery'),(7,'Remote connection ping');

--
-- Table structure for table `SCENARIO_ITEMS`
--

CREATE TABLE `SCENARIO_ITEMS` (
  `Id_Scenario` int(11) DEFAULT 1,
  `Id_Item_Type` int(11) DEFAULT 1,
  `Id_Item_Sel` int(11) DEFAULT 1,
  `En_Menu` tinyint(1) DEFAULT 0,
  `Order_Idx` int(11) DEFAULT NULL,
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `SCENARIO_ITEMS`
--

INSERT INTO `SCENARIO_ITEMS` VALUES (1,1,1,0,1,1),(1,4,1,0,2,2),(1,6,1,0,3,3),(1,5,1,0,4,4),(1,7,1,0,5,5),(1,8,1,0,6,6),(1,9,2,0,7,7),(1,2,1,1,8,8),(1,10,1,0,9,9),(1,11,1,0,10,10),(1,12,1,0,11,11),(1,12,2,0,11,12),(1,12,3,0,11,13),(1,13,1,0,NULL,14);

--
-- Table structure for table `SCENARIO_RT`
--

CREATE TABLE `SCENARIO_RT` (
  `Id_Path` int(11) DEFAULT NULL,
  `RT_Now_TS` datetime DEFAULT NULL,
  `RT_Status` int(11) DEFAULT NULL,
  `RT_Status_Progress` int(11) DEFAULT NULL,
  `RT_Status_Details` varchar(128) DEFAULT NULL,
  `RT_Id_Scenario` int(11) DEFAULT NULL,
  `RT_Id_Meter` int(11) DEFAULT NULL,
  `RT_Id_Product` int(11) DEFAULT NULL,
  `RT_Id_Pump` int(11) DEFAULT NULL,
  `RT_Id_T_Probe` int(11) DEFAULT NULL,
  `RT_Id_D_Probe` int(11) DEFAULT NULL,
  `RT_Id_Preset_Valves` int(11) DEFAULT NULL,
  `RT_Id_Preset_Type` int(11) DEFAULT NULL,
  `RT_Preset` float DEFAULT NULL,
  `RT_Id_User` int(11) DEFAULT NULL,
  `RT_WM_On` tinyint(1) DEFAULT NULL,
  KEY `RT_Id_User` (`RT_Id_User`),
  KEY `RT_Id_Scenario` (`RT_Id_Scenario`),
  KEY `RT_Id_Meter` (`RT_Id_Meter`),
  KEY `RT_Id_Product` (`RT_Id_Product`),
  KEY `RT_Id_Pump` (`RT_Id_Pump`),
  KEY `RT_Id_T_Probe` (`RT_Id_T_Probe`),
  KEY `RT_Id_D_Probe` (`RT_Id_D_Probe`),
  KEY `RT_Id_Preset_Valves` (`RT_Id_Preset_Valves`),
  KEY `RT_Id_Preset_Type` (`RT_Id_Preset_Type`)
);

--
-- Dumping data for table `SCENARIO_RT`
--

INSERT INTO `SCENARIO_RT` VALUES (1,'2019-02-14 13:31:05',22,100,'-',1,1,1,1,1,1,1,2,0,1,0);

--
-- Table structure for table `SCREENS`
--

CREATE TABLE `SCREENS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Enable` tinyint(1) DEFAULT NULL,
  `Name` varchar(32) DEFAULT NULL,
  `Id_Screen_Layout` int(11) DEFAULT NULL,
  `Id_Screen_Detail_1` int(11) DEFAULT NULL,
  `Id_Screen_Detail_2` int(11) DEFAULT NULL,
  `Id_Screen_Detail_3` int(11) DEFAULT NULL,
  `Id_Screen_Detail_4` int(11) DEFAULT NULL,
  `Id_Screen_Detail_5` int(11) DEFAULT NULL,
  `Id_Screen_Detail_6` int(11) DEFAULT NULL,
  `Id_Screen_Detail_7` int(11) DEFAULT NULL,
  `Id_Screen_Detail_8` int(11) DEFAULT NULL,
  `En_Decimals` tinyint(1) DEFAULT NULL,
  `Order_Idx` int(11) DEFAULT NULL,
  `Menu_Group` int(11) DEFAULT 0,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `SCREENS`
--

INSERT INTO `SCREENS` VALUES (1,1,'Standard screen',1,5,2,8,14,6,3,10,11,1,1,NULL);

--
-- Table structure for table `SCREEN_DETAIL_TYPES`
--

CREATE TABLE `SCREEN_DETAIL_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `SCREEN_DETAIL_TYPES`
--

INSERT INTO `SCREEN_DETAIL_TYPES` VALUES (1,'Not used'),(2,'Gross total'),(3,'Net total'),(4,'Mass total'),(5,'Gross volume'),(6,'Net volume'),(7,'Mass'),(8,'Flowrate'),(9,'Meter status'),(10,'Temperature'),(11,'Density'),(12,'CW pulses'),(13,'CCW pulses'),(14,'ERR pulses');

--
-- Table structure for table `SCREEN_LAYOUTS`
--

CREATE TABLE `SCREEN_LAYOUTS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `SCREEN_LAYOUTS`
--

INSERT INTO `SCREEN_LAYOUTS` VALUES (1,'STANDARD');

--
-- Table structure for table `STR_LNG`
--

CREATE TABLE `STR_LNG` (
  `Id` varchar(128) DEFAULT NULL,
  `Id_Language` int(11) DEFAULT NULL,
  `Label` varchar(128) DEFAULT NULL
);

--
-- Dumping data for table `STR_LNG`
--

INSERT INTO `STR_LNG` VALUES ('Sales_Num',1,'Num.'),('Sales_Num',2,'Sales num.'),('Start_TS',1,'Data inizio'),('Start_TS',2,'Start date'),('Meter_Name',1,'Misuratore'),('Meter_Name',2,'Meter'),('Product_Name',1,'Prodotto'),('Product_Name',2,'Product'),('DETAILS',1,'DETTAGLI'),('DETAILS',2,'DETAILS'),('ZOOM',1,'ZOOM'),('ZOOM',2,'ZOOM'),('MENU',1,'MENU'),('MENU',2,'MENU'),('PRINT',1,'STAMPA'),('PRINT',2,'PRINT'),('START',1,'AVVIA'),('START',2,'START'),('GROSS VOL',1,'VOL AMB.'),('GROSS VOL',2,'GROSS VOL'),('GROSS TOT',1,'TOT AMB.'),('GROSS TOT',2,'GROSS TOT'),('NET VOL',1,'VOL COMP.'),('NET VOL',2,'NET VOL'),('NET TOT',1,'TOT COMP.'),('NET TOT',2,'NET TOT'),('MASS',1,'PESO'),('MASS',2,'MASS'),('MASS TOT',1,'TOT PESO'),('MASS TOT',2,'MASS TOT'),('FLOWRATE',1,'PORTATA'),('FLOWRATE',2,'FLOWRATE'),('TEMPERATURE',1,'TEMP.'),('TEMPERATURE',2,'TEMPERATURE'),('METER',1,'MISURATORE'),('METER',2,'METER'),('STATUS',1,'STATO'),('STATUS',2,'STATUS'),('DENSITY',1,'DENSITA'),('DENSITY',2,'DENSITY'),('GROSS VOLUME',1,'VOL AMBIENTE'),('GROSS VOLUME',2,'GROSS VOLUME'),('litres',1,'litri'),('litres',2,'litres'),('SELECT OPTION',1,'SELEZIONA'),('SELECT OPTION',2,'SELECT OPTION'),('INSERT PRESET QTY',1,'IMPOSTA QTA'),('INSERT PRESET QTY',2,'INSERT PRESET QTY'),('STOP',1,'STOP'),('STOP',2,'STOP'),('CHANGE',1,'MODIFICA'),('CHANGE',2,'CHANGE'),('RESUME',1,'RIPRENDI'),('RESUME',2,'RESUME'),('ABORT',1,'ANNULLA'),('ABORT',2,'ABORT'),('ADD QUANTITY',1,'AGGIUNGI QTA'),('ADD QUANTITY',2,'ADD QUANTITY'),('CHANGE PRESET',1,'MODIFICA QTA'),('CHANGE PRESET',2,'CHANGE PRESET'),('PRINTER',1,'STAMPANTE'),('PRINTER',2,'PRINTER'),('WAIT',1,'ATTENDERE'),('WAIT',2,'WAIT'),('INSERT PAPER',1,'MANCA CARTA'),('INSERT PAPER',2,'INSERT PAPER'),('PRINTER OFFLINE',1,'STAMP. SPENTA'),('PRINTER OFFLINE',2,'PRINTER OFFLINE'),('SET BRIGHTNESS',1,'IMP. LUMINOSITA'),('SET BRIGHTNESS',2,'SET BRIGHTNESS'),('ENTER SETUP',1,'ACCEDI SETUP'),('ENTER SETUP',2,'ENTER SETUP'),('CODE',1,'CODICE'),('CODE',2,'CODE'),('EXIT',1,'ESCI'),('EXIT',2,'EXIT'),('MAIN MENU',1,'MENU SETUP'),('MAIN MENU',2,'MAIN MENU'),('SET UP',1,'IMPOSTAZIONI'),('SET UP',2,'SET UP'),('TEST HW',1,'TEST HW'),('TEST HW',2,'TEST HW'),('DATABASE',1,'DATABASE'),('DATABASE',2,'DATABASE'),('RESET',1,'RESET'),('RESET',2,'RESET'),('USER',1,'UTENTE'),('USER',2,'USER'),('SYSTEM',1,'SISTEMA'),('SYSTEM',2,'SYSTEM'),('GENERAL',1,'GENERALE'),('GENERAL',2,'GENERAL'),('SCENARIO',1,'SCENARIO'),('SCENARIO',2,'SCENARIO'),('ELEMENTS',1,'COMPONENTI'),('ELEMENTS',2,'ELEMENTS'),('PRODUCTS',1,'PRODOTTI'),('PRODUCTS',2,'PRODUCTS'),('VIEW LIST',1,'LISTA'),('VIEW LIST',2,'VIEW LIST'),('PERMISSIONS',1,'CREDENZIALI'),('PERMISSIONS',2,'PERMISSIONS'),('SET DATE',1,'NUOVA DATA'),('SET DATE',2,'SET DATE'),('SET TIME',1,'NUOVA ORA'),('SET TIME',2,'SET TIME'),('LANGUAGE',1,'LINGUA'),('LANGUAGE',2,'LANGUAGE'),('UNIT OF MEASURE',1,'UNITA DI MISURA'),('UNIT OF MEASURE',2,'UNIT OF MEASURE'),('TIMERS',1,'TIMER'),('TIMERS',2,'TIMERS'),('ERRORS',1,'ERRORI'),('ERRORS',2,'ERRORS'),('OTHERS',1,'ALTRO'),('OTHERS',2,'ALTRO'),('LATEST TICKET',1,'ULTIMA EROG.'),('LATEST TICKET',2,'LATEST TICKET'),('VIEW LOG',1,'MOSTRA LOG'),('VIEW LOG',2,'VIEW LOG'),('SYS_SETUP_UOMS',1,'UNITA DI MISURA'),('SYS_SETUP_UOMS',2,'UNIT OF MEASURE'),('Id_UOM_Vol',1,'Unita vol.'),('Id_UOM_Vol',2,'Vol UOM'),('Id_UOM_Mass',1,'Unita peso'),('Id_UOM_Mass',2,'Mass UOM'),('Id_UOM_Flow',1,'Unita portata'),('Id_UOM_Flow',2,'Flow UOM'),('Description_STR',1,'Descrizione'),('Description_STR',2,'Description'),('Value',1,'Valore'),('Value',2,'Value'),('Field',1,'Parametro'),('Field',2,'Parameter'),('SYS_SETUP_TIMERS',1,'TIMER SISTEMA'),('SYS_SETUP_TIMERS',2,'SYSTEM TIMERS'),('SYS_SETUP_ERRORS',1,'GESTIONE ERRORI'),('SYS_SETUP_ERRORS',2,'ERRORS SETUP'),('SYS_SETUP_OTHERS',1,'ALTRE IMPOSTAZIONI'),('SYS_SETUP_OTHERS',2,'OTHER SETTINGS'),('Enable',1,'Abilita'),('Enable',2,'Enable'),('Order_Idx',1,'Ordine Idx'),('Order_Idx',2,'Order Idx'),('SCENARIO_ITEMS',1,'ELEMENTI SCENARIO'),('SCENARIO_ITEMS',2,'SCENARIO ITEMS'),('Id_Scenario',1,'Scenario'),('Id_Scenario',2,'Scenario'),('Id_Item_Type',1,'Tipo elemento'),('Id_Item_Type',2,'Item type'),('Id_Item_Sel',1,'Id elem.'),('Id_Item_Sel',2,'Item Id'),('En_Menu',1,'Abilita menu'),('En_Menu',2,'Enable menu'),('PREVIOUS VALUE',1,'VAL. ATTUALE'),('PREVIOUS VALUE',2,'PREVIOUS VALUE'),('PUMP',1,'POMPA'),('PUMP',2,'PUMP'),('PRESET VALVE',1,'VALVOLA PRED.'),('PRESET VALVE',2,'PRESET VALVE'),('PULSE METER',1,'MISUR. IMPULSI'),('PULSE METER',2,'PULSE METER'),('MODBUS METER',1,'MISUR. MODBUS'),('MODBUS METER',2,'MODBUS METER'),('VIRTUAL METER',1,'MISUR. VIRTUALE'),('VIRTUAL METER',2,'VIRTUAL METER'),('METERS',1,'MISURATORI'),('METERS',2,'METERS'),('Id_Meter_Type',1,'Tipo misur.'),('Id_Meter_Type',2,'Meter type'),('Id_Meter_Sel',1,'Id misur.'),('Id_Meter_Sel',2,'Meter Id'),('Min_Flow',1,'Portata min'),('Min_Flow',2,'Min flow'),('Max_Flow',1,'Portata max'),('Max_Flow',2,'Max flow'),('Hw_Port',1,'Porta Hw'),('Hw_Port',2,'Hw Port'),('Value_Rev',1,'Valore giro'),('Value_Rev',2,'Rev. value'),('Pulse_Rev',1,'Impulsi giro'),('Pulse_Rev',2,'Rev. pulses'),('Id_Encoder_Type',1,'Tipo encoder'),('Id_Encoder_Type',2,'Encoder type'),('Check_Invalid',1,'Controlla invalidi'),('Check_Invalid',2,'Check invalid'),('Invalid_Thr',1,'Soglia invalidi'),('Invalid_Thr',2,'Invalid thr.'),('Valid_Thr',1,'Soglia validi'),('Valid_Thr',2,'Valid thr.'),('Pout_Value',1,'Valore ripetizione'),('Pout_Value',2,'Pulse out value'),('Power_Min',1,'Corrente min'),('Power_Min',2,'Min power'),('Power_Max',1,'Corrente max'),('Power_Max',2,'Max power'),('Clockwise',1,'Verso orario'),('Clockwise',2,'Clockwise'),('Id_Value_Type',1,'Tipo valore'),('Id_Value_Type',2,'Value type'),('Enable_Reverse',1,'Abilita inverso'),('Enable_Reverse',2,'Enable reverse'),('Error_Reverse',1,'Errore inverso'),('Error_Reverse',2,'Error reverse'),('DELETE',1,'ELIMINA'),('DELETE',2,'DELETE'),('ADD',1,'AGG.'),('ADD',2,'ADD'),('Address',1,'Indirizzo'),('Address',2,'Address'),('Id_Model',1,'Modello'),('Id_Model',2,'Model'),('Id_Parity_Setting',1,'Parita COM'),('Id_Parity_Setting',2,'Parity Setting'),('Delay_Tx_Ms',2,'Delay Tx ms'),('Delay_Tx_Ms',2,'Delay Tx ms'),('Forward_Direction',1,'Direzione avanti'),('Forward_Direction',2,'Forward direction'),('Cut_Off_Value',1,'Valore cut-off'),('Cut_Off_Value',2,'Cut-off value'),('Shock_Suppression',1,'Shock suppression'),('Shock_Suppression',2,'Shock suppression'),('Zero_Point',1,'Zero point'),('Zero_Point',2,'Zero point'),('Flow_Damping',1,'Flow damping'),('Flow_Damping',2,'Flow damping'),('Id_Pulse_Out_Type',1,'Tipo uscita imp.'),('Id_Pulse_Out_Type',2,'Pulse out type'),('Max_Pout_Freq',1,'Max freq. uscita'),('Max_Pout_Freq',2,'Max out freq.'),('Max_Pout_Flow',1,'Max portata uscita'),('Max_Pout_Flow',2,'Max out flow'),('Density_Gain',1,'Gain densita'),('Density_Gain',2,'Density gain'),('Density_Offset',1,'Offset densita'),('Density_Offset',2,'Density offset'),('Temp_Gain',1,'Gain temperatura'),('Temp_Gain',2,'Temp. gain'),('TEST MODBUS LINE',1,'TEST LINEA MODBUS'),('TEST MODBUS LINE',2,'TEST MODBUS LINE'),('SEND CONFIGURATION',1,'INVIA CONFIGURAZIONE'),('SEND CONFIGURATION',2,'SEND CONFIGURATION'),('CALCULATE ZEROPOINT',1,'CALCOLA ZEROPOINT'),('CALCULATE ZEROPOINT',2,'CALCULATE ZEROPOINT'),('RESTART METER',1,'RIAVVIA MISURATORE'),('RESTART METER',2,'RESTART METER'),('METERS_M',1,'MISURATORI MODBUS'),('METERS_M',2,'MODBUS METERS'),('CREDENTIALS',1,'CREDENZIALI'),('CREDENTIALS',2,'CREDENTIALS'),('Id_User',1,'Utente'),('Id_User',2,'User'),('Id_Level',1,'Livello'),('Id_Level',2,'Level'),('ACTUAL DATE:',1,'CORRENTE:'),('ACTUAL DATE:',2,'ACTUAL DATE:'),('NEW DATE:',1,'NUOVA:'),('NEW DATE:',2,'NEW DATE:'),('ACTUAL TIME:',1,'CORRENTE:'),('ACTUAL TIME:',2,'ACTUAL TIME:'),('NEW TIME:',1,'NUOVA:'),('NEW TIME:',2,'NEW TIME:'),('METERS_X',1,'MISURATORI VIRTUALI'),('METERS_X',2,'VIRTUAL METERS'),('Id_Meter_X_Type',1,'Tipo misuratore'),('Id_Meter_X_Type',2,'Meter type'),('Id_Meter_A_Type',1,'Tipo misuratore A'),('Id_Meter_A_Type',2,'Meter A type'),('Id_Meter_A_Sel',1,'Id misuratore A'),('Id_Meter_A_Sel',2,'Meter A Id'),('Id_Meter_B_Type',1,'Timpo misuratore B'),('Id_Meter_B_Type',2,'Meter B type'),('Id_Meter_B_Sel',1,'Id misuratore B'),('Id_Meter_B_Sel',2,'Meter B Id'),('Id_Meter_X_Type',1,'Connessione virtuale'),('Id_Meter_X_Type',2,'Virtual connection'),('Offset',1,'Offset'),('Offset',2,'Offset'),('Manual_Value',1,'Valore manuale'),('Manual_Value',2,'Manual value'),('Id_Err_Hnd',1,'Gestione errore'),('Id_Err_Hnd',2,'In case of error'),('Min_AD',1,'AD min'),('Min_AD',2,'Min AD'),('Min_Value',1,'Valore min'),('Min_Value',2,'Min value'),('Max_AD',1,'AD max'),('Max_AD',2,'Max AD'),('Max_Value',1,'Valore max'),('Max_Value',2,'Max value'),('T_PROBES',1,'SONDE TEMPERATURA'),('T_PROBES',2,'TEMPERATURE PROBES'),('D_PROBES',1,'SONDE DENSITA'),('D_PROBES',2,'DENSITY PROBES'),('PUMPS',1,'POMPE'),('PUMPS',2,'PUMPS'),('Delay_On',1,'Ritardo avvio'),('Delay_On',2,'Delay on'),('Pause_Off',1,'Spegni su pausa'),('Pause_Off',2,'Off on pause'),('PUMPS',1,'POMPE'),('PUMPS',2,'PUMPS'),('Delay_On',1,'Ritardo avvio'),('Delay_On',2,'Delay on'),('Pause_Off',1,'Spegni su pausa'),('Pause_Off',2,'Off on pause'),('PRESET VALVES',1,'VALVOLE PRED.'),('PRESET VALVES',2,'PRESET VALVES'),('TWO STAGES VALVE',1,'VALV. DUE STADI'),('TWO STAGES VALVE',2,'TWO STAGES VALVE'),('PRESET_VALVES',1,'VALVOLE PRED.'),('PRESET_VALVES',2,'PRESET VALVES'),('Id_Valve_Type',1,'Tipo valvola'),('Id_Valve_Type',2,'Valve type'),('Id_Valve_Sel',1,'Id valvola'),('Id_Valve_Sel',2,'Valve Id'),('LF_to_HF',1,'Qta BF -> AF'),('LF_to_HF',2,'Qty LF -> HF'),('HF_to_LF',1,'Qta AF -> BF'),('HF_to_LF',2,'Qty HF -> LF'),('Pre_stop',1,'Anticipo stop'),('Pre_stop',2,'Adv. stop qty'),('Shortname',1,'Sigla'),('Shortname',2,'Shortname'),('ADR',1,'ADR'),('ADR',2,'ADR'),('Id_Commodity',1,'Tipologia'),('Id_\nCommodity',2,'Commodity'),('Id_Color',1,'Colore'),('Id_Color',2,'Color'),('Static_Err_Gross',1,'Err.\n\n statico Vamb.'),('Static_Err_Gross',2,'Static err. Vgross'),('Id_Net_Calculation',1,'Calcolo Vcomp.'),('Id_Net_Calculation',2,'Vnet calculation'),('Static_Err_Net',1,'Err. statico Vcomp-'),('Static_Err_Net',2,'Static err. Vnet'),('Static_Err_Mass',1,'Err. statico peso'),('Static_Err_Mass',2,'Static err. mass'),('Min_Preset_Qty',1,'Predeterminato min.'),('Min_Preset_Qty',2,'Min preset qty'),('Max_Preset_Qty',1,'Predeterminato max.'),('Max_Preset_Qty',2,'Max preset qty'),('METER LINK',1,'ASSOCIAZIONE MIS.'),('METER LINK',2,'METER LINK'),('PRODUCT_METER_LINK',1,'ASSOCIAZIONE MISURATORE'),('PRODUCT_METER_LINK',2,'PRODUCT METER LINK'),('Id_Product',1,'Prodotto'),('Id_Product',2,'Product'),('Id_Meter',1,'Misuratore'),('Id_Meter',2,'Meter'),('CPU',1,'CPU'),('CPU',2,'CPU'),('OUTPUTS',1,'USCITE'),('OUTPUTS',2,'OUTPUTS'),('INPUTS',1,'INGRESSI'),('INPUTS',2,'INPUTS'),('KEYBOARD',1,'TASTIERA'),('KEYBOARD',2,'KEYBOARD'),('DIAG:TCKET',1,'DIAG.TCKET'),('DIAG:TCKET',2,'DIAG.TCKET'),('SYSTEM SUMMARY',1,'INFO SISTEMA'),('SYSTEM SUMMARY',2,'SYSTEM SUMMARY'),('License:',1,'Licenza:'),('License:',2,'License:'),('internal bus frame TOT',1,'frame bus interno TOT'),('internal bus frame TOT',2,'internal bus frame TOT'),('internal bus frame ERR',1,'frame bus interno ERR'),('internal bus frame ERR',2,'internal bus frame ERR'),('DB Server version',1,'Versione Server DB'),('DB Server version',2,'DB Server version'),('DB used (free) memory',1,'Memoria DB usata (libera)'),('DB used (free) memory',2,'DB used (free) memory'),('DB uptime sec.',1,'Timer DB (sec)'),('DB uptime sec.',2,'DB uptime (sec)'),('KEY PRESSED',1,'TASTO PREMUTO'),('KEY PRESSED',2,'KEY PRESSED'),('KEY CODE (HEX)',1,'CODIFICA (HEX)'),('KEY CODE (HEX)',2,'KEY CODE (HEX)'),('STORED EVENTS:',1,'EVENTI TOT:'),('STORED EVENTS:',2,'STORED EVENTS:'),('POWER ON:',1,'ACCENSIONI:'),('POWER ON:',2,'POWER ON:'),('DELIVERIES:',1,'EROGAZIONI:'),('DELIVERIES:',2,'DELIVERIES:'),('LEAKAGES:',1,'TRAFILAMENTI:'),('LEAKAGES:',2,'LEAKAGES:'),('ERRORS:',1,'ERRORI:'),('ERRORS:',2,'ERRORS:'),('CALIBRATIONS:',1,'SETTAGGI:'),('CALIBRATIONS:',2,'CALIBRATIONS:'),('HARDWARE TEST:',1,'TEST HARDWARE:'),('HARDWARE TEST:',2,'HARDWARE TEST:'),('DATA RESET:',1,'RESET DATI:'),('DATA RESET:',2,'DATA RESET:'),('SHIFT TICKETS:',1,'STAMPE SHIFT:'),('SHIFT TICKETS:',2,'SHIFT TICKETS:'),('SET INVENTORY:',1,'IMPOSTAZ.CARICO:'),('SET INVENTORY:',2,'SET INVENTORY:'),('SLEEP PULSES:',1,'IMPULSI SLEEP:'),('SLEEP PULSES:',2,'SLEEP PULSES:'),('SHOW EVENT',1,'LISTA EVENTI'),('SHOW EVENT',2,'SHOW EVENT'),('DELIVERY',1,'EROGAZIONE'),('DELIVERY',2,'DELIVERY'),('LEAKAGE',1,'TRAFILAMENTO'),('LEAKAGE',2,'LEAKAGE'),('ERROR',1,'ERRORE'),('ERROR',2,'ERROR'),('CALIBRATION',1,'SETTAGGIO'),('CALIBRATION',2,'CALIBRATION'),('TEST HARDWARE',1,'TEST HARDWARE'),('TEST HARDWARE',2,'HARDWARE TEST'),('RESET',1,'RESET'),('RESET',2,'RESET'),('POWER ON',1,'ACCENSIONE'),('POWER ON',2,'POWER ON'),('EV_DELIVERY_LOG',1,'LOG EROGAZIONI'),('EV_DELIVERY_LOG',2,'DELIVERY LOG'),('Preset',1,'Predeterminato'),('Preset',2,'Preset'),('Gross_Vol',1,'Volume amb.'),('Gross_Vol',2,'Gross volume'),('Net_Vol',1,'Volume comp.'),('Net_Vol',2,'Net volume'),('Gross_Tot_Start',1,'Totale amb. inizio'),('Gross_Tot_Start',2,'Initial gross tot.'),('Net_Tot_Start',1,'Totale comp. inizio'),('Net_Tot_Start',2,'Initial net tot.'),('Mass_Tot_Start',1,'Totale peso inizio'),('Mass_Tot_Start',2,'Initial mass tot.'),('Gross_Tot_End',1,'Totale amb. fine'),('Gross_Tot_End',2,'Final gross tot.'),('Net_Tot_End',1,'Totale comp. fine'),('Net_Tot_End',2,'Final net tot.'),('Mass_Tot_End',1,'Totale peso fine'),('Mass_Tot_End',2,'Final mass tot.'),('Avg_Temperature',1,'Temp. media'),('Avg_Temperature',2,'Average temp.'),('Avg_Density',1,'Densita media'),('Avg_Density',2,'Average dens.'),('Num_Stop',1,'Num stop'),('Num_Stop',2,'Num stop'),('Num_Poff',1,'Num spegn.'),('Num_Poff',2,'Num pwr. off'),('Empty_Sensor',1,'Sensore vuoto'),('Empty_Sensor',2,'Empty sensor'),('Id_Dlv_End_Type',1,'Terminata per'),('Id_Dlv_End_Type',2,'Delivery end '),('End_TS',1,'Data fine'),('End_TS',2,'End date'),('Error_Num',1,'Num errore'),('Error_Num',2,'Error num.'),('Notes',1,'Note'),('Notes',2,'Notes'),('EV_LEAGAKE_LOG',1,'LOG TRAFILAMENTI'),('EV_LEAGAKE_LOG',2,'LEAKAGE LOG'),('EV_ERROR_LOG',1,'LOG ERRORI'),('EV_ERROR_LOG',2,'ERROR LOG'),('EV_SETUP_LOG',1,'LOG SETTAGGI'),('EV_SETUP_LOG',2,'SETUP LOG'),('Table_Name',1,'Nome tabella'),('Table_Name',2,'Table name'),('Field_Name',1,'Parametro'),('Field_Name',2,'Field name'),('Old_Value',1,'Vecchio valore'),('Old_Value',2,'Old value'),('New_Value',1,'Nuovo valore'),('New_Value',2,'New value'),('EV_TEST_LOG',1,'LOG TEST HW'),('EV_TEST_LOG',2,'HW TEST LOG'),('Id_Test_Type',1,'Tipo test'),('Id_Test_Type',2,'Test type'),('EV_RESET_LOG',1,'LOG RESET'),('EV_RESET_LOG',2,'RESET LOG'),('Id_Reset_Type',1,'Tipo reset'),('Id_Reset_Type',2,'Reset type'),('EV_POWERON_LOG',1,'LOG ACCENSIONI'),('EV_POWERON_LOG',2,'POWERON LOG'),('PARAMETERS',1,'IMPOSTAZIONI'),('PARAMETERS',2,'PARAMETERS'),('EVENTS',1,'LOG EVENTI'),('EVENTS',2,'EVENTS'),('TOTALIZERS',1,'TOTALIZZATORI'),('TOTALIZERS',2,'TOTALIZERS'),('FACTORY',1,'RESET DI FABBRICA'),('FACTORY',2,'FACTORY RESET'),('YES',1,'SI'),('YES',2,'YES'),('NO',1,'NO'),('NO',2,'NO'),('Use LEFT/RIGHT arrow keys to change brightness',1,'Usare freccia SX/DX per modificare la luminosita'),('Use LEFT/RIGHT arrow keys to change brightness',2,'Use LEFT/RIGHT arrow keys to change brightness'),('Press OK to confirm or BACK to abort',1,'Premere OK per confermare, CANC per annullare'),('Press OK to confirm or BACK to abort',2,'Press OK to confirm or BACK to abort'),('> HIGH FLOW <',1,'> ALTO FLUSSO <'),('> HIGH FLOW <',2,'> HIGH FLOW <'),('> LOW FLOW <',1,'> BASSO FLUSSO <'),('> LOW FLOW <',2,'> LOW FLOW <'),('> START PUMP <',1,'> AVVIO POMPA <'),('> START PUMP <',2,'> START PUMP <'),('> LEAKAGE <',1,'> TRAFILAMENTO <'),('> LEAKAGE <',2,'> LEAKAGE <'),('> NO PULSES <',1,'> NO IMPULSI <'),('> NO PULSES <',2,'> NO PULSES <'),('> CLOSING <',1,'> CHIUSURA <'),('> CLOSING <',2,'> CLOSING <'),('> STOP <',1,'> STOP <'),('> STOP <',2,'> STOP <'),('> WAIT START <',1,'> ATTESA START <'),('> WAIT START <',2,'> WAIT START <'),('> ERROR <',1,'> ERRORE <'),('> ERROR <',2,'> ERROR <'),('> PRINT <',1,'> STAMPA <'),('> PRINT <',2,'> PRINT <'),('METERS_P',1,'MISUR. IMPULSI'),('METERS_P',2,'PULSE METER'),('PRINTERS',1,'STAMPANTI'),('PRINTERS',2,'PRINTERS'),('Id_Layout',1,'Layout'),('Id_Layout',2,'Layout'),('Id_Printer_Type',1,'Tipo stampante'),('Id_Printer_Type',2,'Printer type'),('Id_Printer_Sel',1,'Id stampante'),('Id_Printer_Sel',2,'Printer Id'),('TM295 SETTINGS',1,'IMPOSTAZ. TM295'),('TM295 SETTINGS',2,'TM295 SETTINGS'),('En_Buttons',1,'Abilita pulsanti'),('En_Buttons',2,'Enable buttons'),('En_Autoeject',1,'Eject automatico'),('En_Autoeject',2,'Auto eject'),('PRINTERS_TM295',1,'STAMPANTI TM295'),('PRINTERS_TM295',2,'PRINTERS TM295'),('PRINT ALL DETAILS',1,'STAMPA DETTAGLI'),('PRINT ALL DETAILS',2,'PRINT ALL DETAILS'),('STR_Timeout_duplicate',1,'Timeout duplicato stampa'),('STR_Timeout_duplicate',2,'Duplicate menu timeout'),('STR_Font_Standard',1,'Font standard'),('STR_Font_Standard',2,'Standard font'),('STR_Font_Bold',1,'Font grassetto'),('STR_Font_Bold',2,'Bold font'),('STR_Font_Large',1,'Font grande'),('STR_Font_Large',2,'Large font'),('STR_Screen',1,'Schermo'),('STR_Screen',2,'Screen'),('STR_Timeout_remote_com',1,'Timeout connessione remota'),('STR_Timeout_remote_com',2,'Remote connection timeout'),('STR_Timer_screensaver',1,'Timer screensaver'),('STR_Timer_screensaver',2,'Screensaver timer'),('STR_Pump_switch',1,'Contatto pompa'),('STR_Pump_switch',2,'Pump switch'),('STR_LF_valve',1,'Valvola BF'),('STR_LF_valve',2,'LF valve'),('STR_HF_valve',1,'Valvola AF'),('STR_HF_valve',2,'HF valve'),('STR_Permissive',1,'Permissivo'),('STR_Permissive',2,'Permissive'),('STR_Digital_input',1,'Ingresso digitale'),('STR_Digital_input',2,'Digital input'),('STR_Digital_output',1,'Uscita digitale'),('STR_Digital_output',2,'Digital output'),('STR_Force_LF',1,'Forza BF'),('STR_Force_LF',2,'Force LF'),('STR_Force_HF',1,'Forza AF'),('STR_Force_HF',2,'Force HF'),('STR_Remote_start',1,'Start remoto'),('STR_Remote_start',2,'Remote start'),('STR_Remote_stop',1,'Stop remoto'),('STR_Remote_stop',2,'Remote stop'),('OUTPUTS_D',1,'USCITE DIGITALI'),('OUTPUTS_D',2,'DIGITAL OUTPUTS'),('Id_Cmd_Output',1,'Funzione uscita'),('Id_Cmd_Output',2,'Output command'),('Cmd_Data',1,'Dati comando'),('Cmd_Data',2,'Command data'),('Menu_Group',1,'Gruppo menu'),('Menu_Group',2,'Menu group'),('DIG. OUTPUT',1,'USCITE DIG.'),('DIG. OUTPUT',2,'DIG. OUTPUT'),('DIG. INPUT',1,'INGRESSI DIG.'),('DIG. INPUT',2,'DIG. INPUT'),('INPUTS_D',1,'INGRESSI DIGITALI'),('INPUTS_D',2,'DIGITAL INPUTS'),('Id_Cmd_Input',1,'Funzione ingresso'),('Id_Cmd_Input',2,'Input command'),('Inverse',1,'Inverso'),('Inverse',2,'Inverse'),('STR_Timeout_serial_com',1,'Timeout com. seriale'),('STR_Timeout_serial_com',2,'Serial com. timeout'),('Xon_Xoff',1,'Handshake xon/xoff'),('Xon_Xoff',2,'Xon / Xoff handshake'),('Enable serial com. protocol',1,'Abilita com. seriale'),('Enable serial com. protocol',2,'Enable serial communication'),('TEX Address',1,'Indirizzo TEX'),('TEX Address',2,'TEX address'),('Enable checksum',1,'Abilita checksum'),('Enable checksum',2,'Enable checksum'),('SCREEN',1,'SCHERMATA'),('SCREEN',2,'SCREEN'),('Id_Screen_Layout',1,'Layout schermo'),('Id_Screen_Layout',2,'Screen layout'),('Id_Screen_Detail_1',1,'Dettaglio 1'),('Id_Screen_Detail_2',1,'Dettaglio 2'),('Id_Screen_Detail_3',1,'Dettaglio 3'),('Id_Screen_Detail_4',1,'Dettaglio 4'),('Id_Screen_Detail_5',1,'Dettaglio 5'),('Id_Screen_Detail_6',1,'Dettaglio 6'),('Id_Screen_Detail_7',1,'Dettaglio 7'),('Id_Screen_Detail_8',1,'Dettaglio 8'),('Id_Screen_Detail_1',2,'Screen detail 1'),('Id_Screen_Detail_2',2,'Screen detail 2'),('Id_Screen_Detail_3',2,'Screen detail 3'),('Id_Screen_Detail_4',2,'Screen\n\n detail 4'),('Id_Screen_Detail_5',2,'Screen detail 5'),('Id_Screen_Detail_6',2,'Screen detail 6'),('Id_Screen_Detail_7',2,'Screen detail 7'),('Id_Screen_Detail_8',2,'Screen detail 8'),('En_Decimals',1,'Decimali'),('En_Decimals',2,'Decimals'),('PRODUCT',1,'PRODOTTO'),('PRODUCT',2,'PRODUCT'),('FINAL GROSS',1,'FINALE AMB.'),('FINAL GROSS',2,'FINAL GROSS'),('INIT GROSS',1,'INIZIALE AMB.'),('INIT GROSS',2,'INIT GROSS'),('DLV GROSS',1,'EROGATO AMB.'),('DLV GROSS',2,'DLV GROSS'),('FINAL',1,'FINE'),('FINAL',2,'FINAL'),('INIT',1,'INIZIO'),('INIT',2,'INIT'),('DLV',1,'ERO'),('DLV',2,'DLV'),('SZP Enable',1,'Abilita Smart Zero Preset'),('SZP Enable',2,'Enable Smart Zero Preset'),('SZP Percentage',1,'Percentuale Smart Zero Preset'),('SZP Percentage',2,'Smart Zero Preset percentage'),('STR_Volumetric',2,'Volumetric'),('STR_Volumetric',1,'Volumetrico'),('STR_Mass_meter',2,'Mass meter'),('STR_Mass_meter',1,'Massico'),('STR_Monochannel_A',2,'Monochannel A'),('STR_Monochannel_A',1,'Monocanale A'),('STR_Monochannel_B',2,'Monochannel B'),('STR_Monochannel_B',1,'Monocanale B'),('STR_Bichannel',2,'Quad channels'),('STR_Bichannel',1,'Quadratura'),('STR_LPG',2,'LPG'),('STR_LPG',1,'GPL'),('STR_Crude_oil',2,'Crude oil'),('STR_Crude_oil',1,'Greggio'),('STR_Gasoline',2,'Gasoline'),('STR_Gasoline',1,'Benzina'),('STR_Transition_zone',2,'Transition zone'),('STR_Transition_zone',1,'Zona di transizione'),('STR_Jet_fuel',2,'Jet fuel'),('STR_Jet_fuel',1,'Avio'),('STR_Fuel_oil',2,'Fuel oil'),('STR_Fuel_oil',1,'Diesel'),('STR_Lube_oil',2,'Lube oil'),('STR_Lube_oil',1,'Lube oil'),('STR_Red',2,'Red'),('STR_Red',1,'Rosso'),('STR_Green',2,'Green'),('STR_Green',1,'Verde'),('STR_Blue',2,'Blue'),('STR_Blue',1,'Blu'),('STR_Not_used',2,'Not used'),('STR_Not_used',1,'Non usato'),('STR_System_error',2,'System error'),('STR_System_error',1,'Errore'),('STR_Latest_value',2,'Latest value'),('STR_Latest_value',1,'Ultimo valore'),('STR_Manual_value',2,'Manual value'),('STR_Manual_value',1,'Valore manuale'),('STR_Two_stages',2,'Two stages'),('STR_Two_stages',1,'Doppio stadio'),('STR_Digital',2,'Digital'),('STR_Digital',1,'Digitale'),('STR_Font_Standard',2,'Standard Font'),('STR_Font_Standard',1,'Standard Font'),('STR_Font_Large',2,'Large Font'),('STR_Font_Large',1,'Font Grande'),('STR_Logo',2,'Logo'),('STR_Logo',1,'Logo'),('STR_Preset',2,'Preset'),('STR_Preset',1,'Predeterminato'),('STR_Gross_vol',2,'Gross volume'),('STR_Gross_vol',1,'Volume ambiente'),('STR_Net_vol',2,'Net volume'),('STR_Net_vol',1,'Volume compensato'),('STR_Mass',2,'Mass'),('STR_Mass',1,'Peso'),('STR_Logo',2,'Logo'),('STR_Logo',1,'Logo'),('STR_Preset',2,'Preset'),('STR_Preset',1,'Predeterminato'),('STR_Gross_vol',2,'Gross volume'),('STR_Gross_vol',1,'Volume ambiente'),('STR_Net_vol',2,'Net volume'),('STR_Net_vol',1,'Volume compensato'),('STR_Mass',2,'Mass'),('STR_Mass',1,'Peso'),('STR_Logo',2,'Logo'),('STR_Logo',1,'Logo'),('STR_Preset',2,'Preset'),('STR_Preset',1,'Predeterminato'),('STR_Gross_vol',2,'Gross volume'),('STR_Gross_vol',1,'Volume ambiente'),('STR_Net_vol',2,'Net volume'),('STR_Net_vol',1,'Volume compensato'),('STR_Mass',2,'Mass'),('STR_Mass',1,'Peso'),('STR_Gross_tot',1,'Totale ambiente'),('STR_Net_tot',2,'Net total'),('STR_Net_tot',1,'Totale compensato'),('STR_Mass_tot',2,'Mass total'),('STR_Mass_tot',1,'Totale peso'),('STR_Temperature',2,'Temperature'),('STR_Temperature',1,'Temperatura'),('STR_Density',2,'Density'),('STR_Density',1,'Densita'),('STR_Base_ref',2,'Base reference'),('STR_Base_ref',1,'Condizioni base'),('STR_Compartment',2,'Compartment'),('STR_Compartment',1,'Scomparto'),('STR_Meter',2,'Meter'),('STR_Meter',1,'Misuratore'),('STR_Product',2,'Product'),('STR_Product',1,'Prodotto'),('STR_Pump',2,'Pump'),('STR_Pump',1,'Pompa'),('STR_Preset_valve',2,'Preset valve'),('STR_Preset_valve',1,'Valvola preset'),('STR_Temperature_probe',2,'Temperature probe'),('STR_Temperature_probe',1,'Sonda temperatura'),('STR_Hose',2,'Hose'),('STR_Hose',1,'Manicotto'),('STR_Printer',2,'Printer'),('STR_Printer',1,'Stampante'),('STR_Bulk',2,'Bulk'),('STR_Bulk',1,'Diretto'),('STR_Return',2,'Return'),('STR_Return',1,'Ricircolo'),('STR_Outlet',2,'Outlet'),('STR_Outlet',1,'Uscita'),('STR_CPU',2,'CPU'),('STR_CPU',1,'CPU'),('STR_OUTPUTS',2,'OUTPUTS'),('STR_OUTPUTS',1,'USCITE'),('STR_INPUTS',2,'INPUTS'),('STR_INPUTS',1,'INGRESSI'),('STR_METER',2,'METER'),('STR_METER',1,'MISURATORE'),('STR_KEYBOARD',2,'KEYBOARD'),('STR_KEYBOARD',1,'TASTIERA'),('STR_PRINTER',2,'PRINTER'),('STR_PRINTER',1,'STAMPANTE'),('STR_DIAG_TICKET',2,'DIAG_TICKET'),('STR_DIAG_TICKET',1,'DIAG_TICKET'),('STR_PARAMETERS',2,'PARAMETERS'),('STR_PARAMETERS',1,'PARAMETRI'),('STR_EVENTS',2,'EVENTS'),('STR_EVENTS',1,'EVENTI'),('STR_TOTALIZERS',2,'TOTALIZERS'),('STR_TOTALIZERS',1,'TOTALIZZATORI'),('STR_FACTORY_RESET',2,'FACTORY RESET'),('STR_FACTORY_RESET',1,'FACTORY RESET'),('STR_Delivery',2,'Delivery'),('STR_Delivery',1,'Erogazione'),('STR_Leakage',2,'Leakage'),('STR_Leakage',1,'Trafilamento'),('STR_Error',2,'Error'),('STR_Error',1,'Errore'),('STR_Test',2,'Test'),('STR_Test',1,'Test'),('STR_Reset',2,'Reset'),('STR_Reset',1,'Reset'),('STR_Sleep',2,'Sleep pulses'),('STR_Sleep',1,'Impulsi spento'),('STR_Preset_type',2,'Preset type'),('STR_Preset_type',1,'Tipo predeterminazione'),('STR_Meter_pulser',2,'Pulse meter'),('STR_Meter_pulser',1,'Misuratore impulsivo'),('STR_Alpha',2,'Alpha'),('STR_Alpha',1,'Alfa'),('STR_Black',1,'Nero'),('STR_Black',2,'Black'),('STR_White',1,'Bianco'),('STR_White',2,'White'),('STR_Dark_red',1,'Rosso scuro'),('STR_Dark_red',2,'Dark red'),('STR_Dark_green',1,'Verde scuro'),('STR_Dark_green',2,'Dark green'),('STR_Dark_gray',1,'Grigio scuro'),('STR_Dark_gray',2,'Dark gray'),('STR_Gray',1,'Grigio'),('STR_Gray',2,'Gray'),('STR_Magenta',1,'Magenta'),('STR_Magenta',2,'Magenta'),('STR_Yellow',1,'Giallo'),('STR_Yellow',2,'Yellow'),('STR_Ivory',1,'Avorio'),('STR_Ivory',2,'Ivory'),('STR_Light_ivory',1,'Avorio chiaro'),('STR_Light_ivory',2,'Light ivory'),('STR_Azure',1,'Azzurro'),('STR_Azure',2,'Azure'),('STR_Light_red',1,'Rosso chiaro'),('STR_Light_red',2,'Light red'),('STR_Light_blue',1,'Blu chiaro'),('STR_Light_blue',2,'Light blue'),('STR_Green_bottle',1,'Verde bottiglia'),('STR_Green_bottle',2,'Green bottle'),('STR_Green_spicy',1,'Verde acceso'),('STR_Green_spicy',2,'Green spicy'),('STR_Orange',1,'Arancione'),('STR_Orange',2,'Orange'),('STR_Light_orange',1,'Arancione chiaro'),('STR_Light_orange',2,'Light orange'),('STR_Timeout_no_pulse',2,'No pulse timeout'),('STR_Timeout_no_pulse',1,'Timeout assenza impulsi'),('STR_Timeout_stop',2,'Stop timeout'),('STR_Timeout_stop',1,'Timeout stop manuale'),('STR_Timeout_error',2,'Error status timeout'),('STR_Timeout_error',1,'Timeout errori'),('STR_Pulses_reverse_leakage',2,'Reverse leakage pulses'),('STR_Pulses_reverse_leakage',1,'Impulsi trafilamento inverso'),('STR_Leakage_threshold',2,'Leakage threshold'),('STR_Leakage_threshold',1,'Soglia trafilamento'),('STR_Sales_per_product',2,'Sales num per product'),('STR_Sales_per_product',1,'Progressivo per prodotto'),('STR_Skip_boot_msg',2,'Skip message on boot'),('STR_Skip_boot_msg',1,'Salta messaggi boot'),('STR_Enable_zero_start',2,'Enable zero start'),('STR_Enable_zero_start',1,'Abilita zero start'),('STR_Wait_start_dlv',2,'Wait start delivery'),('STR_Wait_start_dlv',1,'Attesa avvio erogazione'),('STR_Default_add_vol',2,'Default add volume'),('STR_Default_add_vol',1,'Default add volume'),('STR_Enable_decimals',2,'Enable decimals'),('STR_Enable_decimals',1,'Abilita decimali'),('STR_Backlight',2,'Backlight'),('STR_Backlight',1,'Retroilluminazione'),('STR_Language',2,'Language'),('STR_Language',1,'Lingua'),('STR_Even',2,'Even'),('STR_Even',1,'Pari'),('STR_Odd',2,'Odd'),('STR_Odd',1,'Dispari'),('STR_Virtual',2,'Virtual'),('STR_Virtual',1,'Virtuale'),('STR_Series_meters',2,'Series meters'),('STR_Series_meters',1,'Misuratori in serie'),('STR_Density_probe',2,'Density probe'),('STR_Density_probe',1,'Sonda densita'),('STR_Modbus_meter',2,'Modbus meter'),('STR_Modbus_meter',1,'Misuratore su Modbus'),('STR_TEX_sn',2,'TEX serial number'),('STR_TEX_sn',1,'Numero di serie TEX'),('STR_Delivery',1,'Erogazione'),('STR_Delivery',2,'Delivery'),('STR_Leakage',1,'Trafilamento'),('STR_Leakage',2,'Leakage'),('STR_Error',1,'Errore'),('STR_Error',2,'Error'),('STR_Test',1,'Test'),('STR_Test',2,'Test'),('STR_Reset',1,'Reset'),('STR_Reset',2,'Reset'),('STR_Sleep',1,'Impulsi da spento'),('STR_Sleep',2,'Sleep pulses'),('STR_Preset_quantity',1,'Quantita preset'),('STR_Preset_quantity',2,'Preset quantity'),('STR_Manual_stop',1,'Stop manuale'),('STR_Manual_stop',2,'Manual stop'),('STR_Pulse_timeout',1,'Assenza impulsi'),('STR_Pulse_timeout',2,'Pulse timeout'),('STR_Alarm',1,'Allarme'),('STR_Alarm',2,'Alarm'),('STR_Power_off',1,'Spegnimento'),('STR_Power_off',2,'Power off'),('STR_Power_on',1,'Accensione'),('STR_Power_on',2,'Power on'),('BACK',1,'INDIETRO'),('BACK',2,'BACK'),('SUBMIT',1,'INVIA'),('SUBMIT',2,'SUBMIT'),('QUANTITY',1,'QUANTITA'),('QUANTITY',2,'QUANTITY'),('Loading...',1,'Caricamento...'),('Loading...',2,'Loading...'),('SHARE',1,'CONDIVIDI'),('SHARE',2,'SHARE'),('PRINTING TICKET',1,'STAMPA CARTELLINO'),('PRINTING TICKET',2,'PRINTING TICKET'),('DUPLICATE',1,'DUPLICATO'),('DUPLICATE',2,'DUPLICATE'),('SSH connection',1,'Connessione SSH'),('SSH connection',2,'SSH connection'),('PLATE',1,'TARGA'),('PLATE',2,'PLATE'),('WM_Seal',1,'WM'),('WM_Seal',2,'WM'),('SYS_SETUP_PLATE',1,'TARGA SISTEMA'),('SYS_SETUP_PLATE',2,'SYSTEM PLATE'),('SYS_SETUP_COM',1,'COM SERIALE'),('SYS_SETUP_COM',2,'SERIAL COM'),('SERIAL COM.',1,'COM SERIALE'),('SERIAL COM.',2,'SERIAL COM.'),('VIEW PLATE',1,'MOSTRA TARGA'),('VIEW PLATE',2,'VIEW PLATE'),('STR_Pulse_out',1,'Rip. impulsi'),('STR_Pulse_out',2,'Pulse out'),('> CLOSING <',3,'> CLOTURE <'),('> ERROR <',3,'> ERREUR <'),('> HIGH FLOW <',3,'> GRAND DEBIT <'),('> LEAKAGE <',3,'> FUITE <'),('> LOW FLOW <',3,'> PETIT DEBIT <'),('> NO PULSES <',3,'> ABSENCE\n IMPULSION <'),('> PRINT <',3,'> IMPRESSION <'),('> START PUMP <',3,'> DEMARRAGE POMPE <'),('> STOP <',3,'> ARRET<'),('> WAIT START <',3,'> ATTENTE DEMARRAGE <'),('ABORT',3,'ANNULE'),('ACTUAL DATE:',3,'DATE:'),('ACTUAL TIME:',3,'TEMPS:'),('ADD',3,'AJOUT'),('ADD QUANTITY',3,'AJOUT QUANTITE'),('Address',3,'Adresse'),('ADR',3,'ADR'),('Avg_Density',3,'Densité moyenne'),('Avg_Temperature',3,'Temp. moyenne'),('BACK',3,'EN ARRIERE'),('CALCULATE ZEROPOINT',3,'CALCULE POINT ZERO'),('CALIBRATION',3,'ETALONNAGE'),('CALIBRATIONS:',3,'ETALONNAGES:'),('CHANGE',3,'MODIFICATION'),('CHANGE PRESET',3,'MODF. PREREGLAGE'),('Check_Invalid',3,'Vérifier invalides'),('Clockwise',3,'Sens horaire'),('Cmd_Data',3,'Donnés commande'),('CODE',3,'CODE'),('CPU',3,'CARTE CPU'),('CREDENTIALS',3,'CREDENTIALES'),('Cut_Off_Value',3,'Valeur de cut-off'),('D_PROBES',3,'SONDES DE DENSITE'),('DATA RESET:',3,'RÉINITIALISER DONNÉES:'),('DATABASE',3,'BANQUE DE DONNEES'),('DB Server version',3,'Version Serveur DB'),('DB uptime sec.',3,'Temps de disponibilité db (sec)'),('DB used (free) memory',3,'Db mémoire utilisée (libre) '),('Delay_On',3,'Retard démarrage'),('Delay_On',3,'Retard démarrage'),('DELETE',3,'EFFACE'),('DELIVERIES:',3,'LIVRAISONS:'),('DELIVERY',3,'LIVRAISON'),('DENSITY',3,'DENSITE'),('Density_Gain',3,'Gain densité'),('Density_Offset',3,'Décalage densité'),('Description_STR',3,'Description'),('DETAILS',3,'DETAILS'),('DIAG:TCKET',3,'DIAG.TCKET'),('DIG. INPUT',3,'ENTREES NUMERIQUES'),('DIG. OUTPUT',3,'SORTIES NUMERIQUES'),('DLV',3,'LVR'),('DLV GROSS',3,'LIVRÉ BRUT'),('DUPLICATE',3,'DUPLICATA'),('ELEMENTS',3,'ÉLÉMENTS'),('Empty_Sensor',3,'Capteur vide'),('En_Autoeject',3,'Ejection automatique'),('En_Buttons',3,'Touches de validation'),('En_Decimals',3,'Décimales'),('En_Menu',3,'Menu de validation'),('Enable',3,'Autorise'),('Enable checksum',3,'Activer checksum'),('Enable serial com. protocol',3,'Active la communication série'),('Enable_Reverse',3,'Validation inverse'),('End_TS',3,'Date d\'échéance'),('ENTER SETUP',3,'ENTRE DANS L\'INSTALLATION'),('ERROR',3,'ERREUR'),('Error_Num',3,'Numéro erreur'),('Error_Reverse',3,'Erreur inverse'),('ERRORS',3,'ERREURS'),('ERRORS:',3,'ERREURS:'),('EV_DELIVERY_LOG',3,'REGISTRE DE LIVRAISONS'),('EV_ERROR_LOG',3,'REGISTRE DES ERREURS'),('EV_LEAGAKE_LOG',3,'REGISTRE DE FUITES'),('EV_POWERON_LOG',3,'REGISTRE DE DÉMARRAGE'),('EV_RESET_LOG',3,'REGISTRE DE RÉINITIALISATION'),('EV_SETUP_LOG',3,'REGISTRE D\'ETALONNAGE'),('EV_TEST_LOG',3,'JOURNAL TEST MATERIEL'),('EVENTS',3,'REGISTRE D\'ÉVÉNEMENTS'),('EXIT',3,'SORTIE'),('FACTORY',3,'RÉINITIALISATION D\'USINE'),('Field',3,'Paramétre'),('Field_Name',3,'Nom champ'),('FINAL',3,'FIN'),('FINAL GROSS',3,'BRUT FINAL'),('Flow_Damping',3,'Dumping de débit'),('FLOWRATE',3,'DEBIT'),('Forward_Direction',3,'Diréction avant'),('GENERAL',3,'GENERAL'),('GROSS TOT',3,'TOTAL BRUT'),('GROSS VOL',3,'VOLUME BRUT'),('GROSS VOLUME',3,'VOLUME BRUT'),('Gross_Tot_End',3,'Total brut final'),('Gross_Tot_Start',3,'Total brut initial'),('Gross_Vol',3,'Volume brut'),('HARDWARE TEST:',3,'ESSAI DE MATERIEL:'),('HF_to_LF',3,'QTE GD --> PD'),('Hw_Port',3,'Porte du matériel'),('Id_',3,''),('Id_Cmd_Input',3,'Commande d\'entrée'),('Id_Cmd_Output',3,'Commande de sortie'),('Id_Color',3,'Couleur'),('Id_Commodity',3,'Caractère'),('Id_Dlv_End_Type',3,'Fin livraison'),('Id_Encoder_Type',3,'Type d\'emetteur'),('Id_Err_Hnd',3,'Contrôle des erreurs'),('Id_Item_Sel',3,''),('Id_Item_Type',3,'Type d\'élément'),('Id_Layout',3,'Configuration'),('Id_Level',3,'Niveau'),('Id_Meter',3,'Compteur'),('Id_Meter_A_Sel',3,'Compteur de type Id'),('Id_Meter_A_Type',3,'Compteur de type A'),('Id_Meter_B_Sel',3,'Compteur B Id'),('Id_Meter_B_Type',3,'Compteur de type B'),('Id_Meter_Sel',3,'Compteur Id'),('Id_Meter_Type',3,'Compteur type'),('Id_Meter_X_Type',3,'Connexion virtuelle'),('Id_Meter_X_Type',3,'Compteur type'),('Id_Model',3,'Modèle'),('Id_Net_Calculation',3,'Calcul de connexion virtuelle'),('Id_Parity_Setting',3,'Réglage de parité'),('Id_Printer_Sel',3,'Imprimante Id'),('Id_Printer_Type',3,'Type d\'imprimante'),('Id_Product',3,'Produit'),('Id_Pulse_Out_Type',3,'Type de sortie d\'impulsion'),('Id_Reset_Type',3,'Type de réinitialisation'),('Id_Scenario',3,'Scénario'),('Id_Screen_Detail_1',3,'Ecran détail 1'),('Id_Screen_Detail_2',3,'Ecran détail 2'),('Id_Screen_Detail_3',3,'Ecran détail 3'),('Id_Screen_Detail_4',3,'Ecran détail 4'),('Id_Screen_Detail_5',3,'Ecran détail 5'),('Id_Screen_Detail_6',3,'Ecran détail 6'),('Id_Screen_Detail_7',3,'Ecran détail 7'),('Id_Screen_Detail_8',3,'Ecran détail 8'),('Id_Screen_Layout',3,'Configuration écran'),('Id_Test_Type',3,'Type de test'),('Id_UOM_Flow',3,'Unité de débit'),('Id_UOM_Mass',3,'Masse unitaire'),('Id_UOM_Vol',3,'Unité de volume'),('Id_User',3,'Utilisateur'),('Id_Value_Type',3,'Type de valeur'),('Id_Valve_Sel',3,'Vanne Id'),('Id_Valve_Type',3,'Type soupape'),('INIT',3,'DEBUT'),('INIT GROSS',3,'BRUT INITIAL'),('INPUTS',3,'ENTREES'),('INPUTS_D',3,'ENTREES NUMERIQUES'),('INSERT PAPER',3,'ABCENCE PAPIER'),('INSERT PRESET QTY',3,'INSERER LA QUANTITE PREREGLEE'),('internal bus frame ERR',3,'Erreur interne de trame de bus'),('internal bus frame TOT',3,'Total de la trame interne du bus'),('Invalid_Thr',3,'Seuil invalide'),('Inverse',3,'Inverse'),('KEY CODE (HEX)',3,'CODAGE (HEX)'),('KEY PRESSED',3,'CLE PRESSE'),('KEYBOARD',3,'CLAVIER'),('LANGUAGE',3,'LANGUE'),('LATEST TICKET',3,'DERNIERE LIVRAISON'),('LEAKAGE',3,'FUITE'),('LEAKAGES:',3,'FUITES:'),('LF_to_HF',3,'Qtè  PD -> GD'),('License:',3,'Licence d\'utilisation:'),('litres',3,'Litres'),('Loading...',3,'Chargement…'),('MAIN MENU',3,'MENU PRINCIPAL'),('Manual_Value',3,'Valeur manuelle'),('MASS',3,'POIDS'),('MASS TOT',3,'POIDS TOTAL'),('Mass_Tot_End',3,'Masse finale totale'),('Mass_Tot_Start',3,'Masse initiale totale'),('Max_AD',3,'Max AD'),('Max_Flow',3,'Débit maximum'),('Max_Pout_Flow',3,'Débit de sortie maximum'),('Max_Pout_Freq',3,'Fréquence de sortie maximale'),('Max_Preset_Qty',3,'Quantité maximum préréglée'),('Max_Value',3,'Valeur maximum'),('MENU',3,'MENU'),('Menu_Group',3,'Groupe de menus'),('METER',3,'COMPTEUR'),('METER LINK',3,'LIEN COMPTEUR'),('Meter_Name',3,'Compteur'),('METERS',3,'COMPTEURS'),('METERS_M',3,'COMPTEURS MODBUS'),('METERS_P',3,'COMPTEUR IMPULSIONS'),('METERS_X',3,'COMPTEURS VIRTUELS'),('Min_AD',3,'Min AD'),('Min_Flow',3,'Débit minimum'),('Min_Preset_Qty',3,'Quantité minimum préréglée'),('Min_Value',3,'Valeur minimum'),('MODBUS METER',3,'COMPTEUR MODBUS'),('NET TOT',3,'TOTAL NET'),('NET VOL',3,'VOLUME NET'),('Net_Tot_End',3,'Total final net'),('Net_Tot_Start',3,'Total initial net'),('Net_Vol',3,'Volume net'),('NEW DATE:',3,'NOUVELLE DATE'),('NEW TIME:',3,'NOUVEAU TEMPS:'),('New_Value',3,'Nouvelle valeur'),('NO',3,'NON'),('Notes',3,'Remarques'),('Num_Poff',3,'Nombre de déconnexions'),('Num_Stop',3,'Nombre d\'arrêts'),('Offset',3,'Décalage'),('Old_Value',3,'Vieille valeur'),('Order_Idx',3,'Liste Idx'),('OTHERS',3,'AUTRES'),('OUTPUTS',3,'SORTIES'),('OUTPUTS_D',3,'SORTIES NUMERIQUES'),('PARAMETERS',3,'PARAMETRES'),('Pause_Off',3,'Arrêt sur pause'),('Pause_Off',3,'Arrêt sur pause'),('PERMISSIONS',3,'AUTORISATIONS'),('Pout_Value',3,'Valeur sortie impulsion'),('POWER ON',3,'MISE EN MARCHE'),('POWER ON:',3,'MISES EN MARCHE:'),('Power_Max',3,'Puissance maximum'),('Power_Min',3,'Puissance minimum'),('Pre_stop',3,'Quantité d\'arrêt anticipé'),('Preset',3,'Préréglé'),('PRESET VALVE',3,'VANNE DE REGLAGE'),('PRESET VALVES',3,'VANNES DE REGLAGE'),('PRESET_VALVES',3,'VANNES DE REGLAGE'),('Press OK to confirm or BACK to abort',3,'Appuyez sur OK pour confirmer ou sur BACK pour annuler.'),('PREVIOUS VALUE',3,'VALEUR PRECEDENTE'),('PRINT',3,'IMPRESSION'),('PRINT ALL DETAILS',3,'IMPRIMER TOUS LES DÉTAILS'),('PRINTER',3,'IMPRIMANTE'),('PRINTER OFFLINE',3,'IMPRIMANTE HORS LIGNE'),('PRINTERS',3,'IMPRIMANTES'),('PRINTERS_TM295',3,'IMPRIMANTES TM295'),('PRINTING TICKET',3,'IMPRESSION TICKET'),('PRODUCT',3,'PRODUIT'),('PRODUCT_METER_LINK',3,'LIEN PRODUIT COMPTEUR'),('Product_Name',3,'Produit'),('PRODUCTS',3,'PRODUITS'),('PULSE METER',3,'COMPTEUR D\'IMPULSIONS'),('Pulse_Rev',3,'Impulsions par tour'),('PUMP',3,'POMPE'),('PUMPS',3,'POMPES'),('PUMPS',3,'POMPES'),('QUANTITY',3,'QUANTITE'),('RESET',3,'RÉINITIALISATION'),('RESET',3,'RÉINITIALISATION'),('RESTART METER',3,'REDÉMARRER COMPTEUR'),('RESUME',3,'RESUME'),('Sales_Num',3,'Num. Ventes'),('SCENARIO',3,'SCENARIO'),('SCENARIO_ITEMS',3,'POINTS SCENARIO'),('SCREEN',3,'ECRAN'),('SELECT OPTION',3,'SÉLECTIONNER OPTION'),('SEND CONFIGURATION',3,'ENVOYE CONFIGURATION'),('SET BRIGHTNESS',3,'RÉGLAGE LUMINOSITÉ'),('SET DATE',3,'FIXE DATE'),('SET INVENTORY:',3,'SET INVENTAIRE:'),('SET TIME',3,'RÉGLE L\'HEURE'),('SET UP',3,'CONFIGURATION'),('SHARE',3,'PARTAGE'),('SHIFT TICKETS:',3,'IMPRESSIONS SHIFT:'),('Shock_Suppression',3,'Suppression de choc'),('Shortname',3,'Nom abrégé'),('SHOW EVENT',3,'MONTRE ÉVÉNEMENT'),('SLEEP PULSES:',3,'PULSES DE SOMMEIL:'),('START',3,'MISE EN MARCHE'),('Start_TS',3,'Date mise en marche'),('Static_Err_Gross',3,'Erreur statique versus brut'),('Static_Err_Mass',3,'Erreur statique versus mass'),('Static_Err_Net',3,'Erreur statique versus net'),('STATUS',3,'ETAT'),('STOP',3,'ARRÊT'),('STORED EVENTS:',3,'EVENEMENTS MEMORISES:'),('STR_Alarm',3,'Alarme'),('STR_Alpha',3,'Alfa'),('STR_Azure',3,'Azur'),('STR_Backlight',3,'Rétroéclairage'),('STR_Base_ref',3,'Conditions de base'),('STR_Bichannel',3,'Quadrature'),('STR_Black',3,'Noir'),('STR_Blue',3,'Bleu'),('STR_Bulk',3,'Vrac'),('STR_Compartment',3,'Compartiment'),('STR_CPU',3,'CPU'),('STR_Crude_oil',3,'Pétrole brut'),('STR_Dark_gray',3,'Gris foncé'),('STR_Dark_green',3,'Vert foncé'),('STR_Dark_red',3,'Rouge foncé'),('STR_Default_add_vol',3,'Volume d\'ajout par défaut'),('STR_Delivery',3,'Livraison'),('STR_Delivery',3,'Livraison'),('STR_Density',3,'Densité'),('STR_Density_probe',3,'Sonde de densité'),('STR_DIAG_TICKET',3,'DIAG_TICKET'),('STR_Digital',3,'Numérique'),('STR_Digital_input',3,'Entrée\n numérique'),('STR_Digital_output',3,'Sortie numérique'),('STR_Enable_decimals',3,'Activer les numériques'),('STR_Enable_zero_start',3,'Activer zero start'),('STR_Error',3,'Erreur'),('STR_Error',3,'Erreur'),('STR_Even',3,'Pair'),('STR_EVENTS',3,'EVENEMENTS'),('STR_FACTORY_RESET',3,'REINITIALISATION USINE'),('STR_Font_Bold',3,'Caractères gras'),('STR_Font_Large',3,'Gros caractères'),('STR_Font_Large',3,'Gros caractères'),('STR_Font_Standard',3,'Caractères standard'),('STR_Font_Standard',3,'Caractères standard'),('STR_Force_HF',3,'Forcer HD'),('STR_Force_LF',3,'Forcer BD'),('STR_Fuel_oil',3,'Gasoil'),('STR_Gasoline',3,'Essence'),('STR_Gray',3,'Gris'),('STR_Green',3,'Vert '),('STR_Green_bottle',3,'Vert Bouteille'),('STR_Green_spicy',3,'Vert vif'),('STR_Gross_tot',3,'Volume brut'),('STR_Gross_vol',3,'Volume brut'),('STR_Gross_vol',3,'Volume brut'),('STR_Gross_vol',3,'Volume brut'),('STR_HF_valve',3,'Soupape HD'),('STR_Hose',3,'Manchette'),('STR_INPUTS',3,'ENTREES'),('STR_Ivory',3,'Ivoire'),('STR_Jet_fuel',3,'Combustible aviation'),('STR_KEYBOARD',3,'CLAVIER'),('STR_Language',3,'Langue'),('STR_Latest_value',3,'Dernière valeur'),('STR_Leakage',3,'Fuite'),('STR_Leakage',3,'Fuite'),('STR_Leakage_threshold',3,'Seuil de fuite'),('STR_LF_valve',3,'Soupape PD'),('STR_Light_blue',3,'Bleu clair'),('STR_Light_ivory',3,'Ivoire clair'),('STR_Light_orange',3,'Orange clair'),('STR_Light_red',3,'Rouge clair'),('STR_Logo',3,'Logo'),('STR_Logo',3,'Logo'),('STR_Logo',3,'Logo'),('STR_LPG',3,'GPL'),('STR_Lube_oil',3,'Huile lubrifiante'),('STR_Magenta',3,'Magenta'),('STR_Manual_stop',3,'Arrêt manuel'),('STR_Manual_value',3,'Valeur manuelle'),('STR_Mass',3,'Masse'),('STR_Mass',3,'Masse'),('STR_Mass',3,'Masse'),('STR_Mass_meter',3,'Compteur de masse'),('STR_Mass_tot',3,'Poids total'),('STR_Meter',3,'COMPTEUR'),('STR_METER',3,'COMPTEUR'),('STR_Meter_pulser',3,'Compteur à impulsions'),('STR_Modbus_meter',3,'Compteur Modbus'),('STR_Monochannel_A',3,'Monocanal A'),('STR_Monochannel_B',3,'Monocanal B'),('STR_Net_tot',3,'Total net'),('STR_Net_vol',3,'Volume net'),('STR_Net_vol',3,'Volume net'),('STR_Net_vol',3,'Volume net'),('STR_Not_used',3,'Non utilisé'),('STR_Odd',3,'Impair'),('STR_Orange',3,'Orange'),('STR_Outlet',3,'Sortie'),('STR_OUTPUTS',3,'SORTIES'),('STR_PARAMETERS',3,'PARAMETRES'),('STR_Permissive',3,'Permissif'),('STR_Power_off',3,'Arrêt'),('STR_Power_on',3,'Démarrage'),('STR_Preset',3,'Présélecté'),('STR_Preset',3,'Présélecté'),('STR_Preset',3,'Présélecté'),('STR_Preset_quantity',3,'Quantité présélectée'),('STR_Preset_type',3,'Type de présélection'),('STR_Preset_valve',3,'Vanne de présélection'),('STR_Printer',3,'Imprimante'),('STR_PRINTER',3,'IMPRIMANTE'),('STR_Product',3,'Produit'),('STR_Pulse_timeout',3,'Absence impulsions'),('STR_Pulses_reverse_leakage',3,'Impulsions de fuite inversée'),('STR_Pump',3,'Pompe'),('STR_Pump_switch',3,'Interrupteur pompe'),('STR_Red',3,'Rouge'),('STR_Remote_start',3,'Démarrage à distance'),('STR_Remote_stop',3,'Arrêt à distance'),('STR_Reset',3,'Réinitialisation'),('STR_Reset',3,'Réinitialisation'),('STR_Return',3,'Recirculation'),('STR_Sales_per_product',3,'Progressif par produit'),('STR_Screen',3,'Ecran'),('STR_Series_meters',3,'Compteurs série'),('STR_Skip_boot_msg',3,'Sauter messages de démarrage'),('STR_Sleep',3,'Impulsions de sommeil'),('STR_Sleep',3,'Impulsions de sommeil'),('STR_System_error',3,'Erreur de système'),('STR_Temperature',3,'Temperature'),('STR_Temperature_probe',3,'Sonde de température'),('STR_Test',3,'Test'),('STR_Test',3,'Test'),('STR_TEX_sn',3,'Numéro de série TEX'),('STR_Timeout_duplicate',3,'Délai d\'impression double'),('STR_Timeout_error',3,'Délai d\'erreur'),('STR_Timeout_no_pulse',3,'Délai d\'absence d\'impulsions'),('STR_Timeout_remote_com',3,'Délai de connexion à distance'),('STR_Timeout_serial_com',3,'Délai de communication série'),('STR_Timeout_stop',3,'Délai d\'arrêt manuel'),('STR_Timer_screensaver',3,'Minuterie écran de veille'),('STR_TOTALIZERS',3,'TOTALIZATEURS'),('STR_Transition_zone',3,'Zone de transition'),('STR_Two_stages',3,'Double étape'),('STR_Virtual',3,'Virtuel'),('STR_Volumetric',3,'Volumetrique'),('STR_Wait_start_dlv',3,'Attente debut livraison'),('STR_White',3,'Blanc'),('STR_Yellow',3,'Jaune'),('SUBMIT',3,'SOUMETTRE'),('SYS_SETUP_ERRORS',3,'CONFIGURATION DES ERREURS'),('SYS_SETUP_OTHERS',3,'AUTRES PARAMÈTRES'),('SYS_SETUP_TIMERS',3,'MINUTERIE DE SYSTÈME'),('SYS_SETUP_UOMS',3,'UNITÉ DE MESURE'),('SYSTEM',3,'SYSTEME'),('SYSTEM SUMMARY',3,'INFO SYSTÈME'),('SZP Enable',3,'Activer le préréglage du zéro intelligent'),('SZP Percentage',3,'Pourcentage de préréglage intelligent du zéro'),('T_PROBES',3,'SONDES DE TEMPÉRATURE'),('Table_Name',3,'Nom du tableau'),('Temp_Gain',3,'Gain de température'),('TEMPERATURE',3,'TEMPERATURE'),('TEST HARDWARE',3,'TEST DU MATÉRIEL'),('TEST HW',3,'TEST DU MATÉRIEL'),('TEST MODBUS LINE',3,'TEST DE LIGNE MODBUS'),('TEX Address',3,'Adresse TEX'),('TIMERS',3,'TIMERS'),('TM295 SETTINGS',3,'PARAMÈTRES TM295'),('TOTALIZERS',3,'TOTALIZATEURS'),('TWO STAGES VALVE',3,'VANNE DEUX ÉTAGES'),('UNIT OF MEASURE',3,'UNITÉ DE MESURE'),('Use LEFT/RIGHT arrow keys to change brightness',3,'Utilisez la flèche GAUCHE/DROITE pour modifier la luminosité'),('USER',3,'UTILISATEUR'),('Valid_Thr',3,'Seuil Valable'),('Value',3,'Valeur manuelle'),('Value_Rev',3,'Valeur revolution'),('VIEW LIST',3,'LISTE'),('VIEW LOG',3,'SHOW LOG'),('VIRTUAL METER',3,'COMPTEUR VIRTUEL'),('WAIT',3,'ATTENDRE'),('Xon_Xoff',3,'Xon / Xoff handshake'),('YES',3,'OUI'),('Zero_Point',3,'Point zéro'),('ZOOM',3,'ZOOM'),('Name',1,'Nome'),('Name',2,'Name'),('Name',3,'Prenom');

--
-- Table structure for table `STR_RT`
--

CREATE TABLE `STR_RT` (
  `Id` varchar(128) DEFAULT NULL,
  `Label` varchar(128) DEFAULT NULL
);

--
-- Dumping data for table `STR_RT`
--

INSERT INTO `STR_RT` VALUES ('Sales_Num','Num.'),('Start_TS','Data inizio'),('Meter_Name','Misuratore'),('Product_Name','Prodotto'),('DETAILS','DETTAGLI'),('ZOOM','ZOOM'),('MENU','MENU'),('PRINT','STAMPA'),('START','AVVIA'),('GROSS VOL','VOL AMB.'),('GROSS TOT','TOT AMB.'),('NET VOL','VOL COMP.'),('NET TOT','TOT COMP.'),('MASS','PESO'),('MASS TOT','TOT PESO'),('FLOWRATE','PORTATA'),('TEMPERATURE','TEMP.'),('METER','MISURATORE'),('STATUS','STATO'),('DENSITY','DENSITA'),('GROSS VOLUME','VOL AMBIENTE'),('litres','litri'),('SELECT OPTION','SELEZIONA'),('INSERT PRESET QTY','IMPOSTA QTA'),('STOP','STOP'),('CHANGE','MODIFICA'),('RESUME','RIPRENDI'),('ABORT','ANNULLA'),('ADD QUANTITY','AGGIUNGI QTA'),('CHANGE PRESET','MODIFICA QTA'),('PRINTER','STAMPANTE'),('WAIT','ATTENDERE'),('INSERT PAPER','MANCA CARTA'),('PRINTER OFFLINE','STAMP. SPENTA'),('SET BRIGHTNESS','IMP. LUMINOSITA'),('ENTER SETUP','ACCEDI SETUP'),('CODE','CODICE'),('EXIT','ESCI'),('MAIN MENU','MENU SETUP'),('SET UP','IMPOSTAZIONI'),('TEST HW','TEST HW'),('DATABASE','DATABASE'),('RESET','RESET'),('USER','UTENTE'),('SYSTEM','SISTEMA'),('GENERAL','GENERALE'),('SCENARIO','SCENARIO'),('ELEMENTS','COMPONENTI'),('PRODUCTS','PRODOTTI'),('VIEW LIST','LISTA'),('PERMISSIONS','CREDENZIALI'),('SET DATE','NUOVA DATA'),('SET TIME','NUOVA ORA'),('LANGUAGE','LINGUA'),('UNIT OF MEASURE','UNITA DI MISURA'),('TIMERS','TIMER'),('ERRORS','ERRORI'),('OTHERS','ALTRO'),('LATEST TICKET','ULTIMA EROG.'),('VIEW LOG','MOSTRA LOG'),('SYS_SETUP_UOMS','UNITA DI MISURA'),('Id_UOM_Vol','Unita vol.'),('Id_UOM_Mass','Unita peso'),('Id_UOM_Flow','Unita portata'),('Description_STR','Descrizione'),('Value','Valore'),('Field','Parametro'),('SYS_SETUP_TIMERS','TIMER SISTEMA'),('SYS_SETUP_ERRORS','GESTIONE ERRORI'),('SYS_SETUP_OTHERS','ALTRE IMPOSTAZIONI'),('Enable','Abilita'),('Order_Idx','Ordine Idx'),('SCENARIO_ITEMS','ELEMENTI SCENARIO'),('Id_Scenario','Scenario'),('Id_Item_Type','Tipo elemento'),('Id_Item_Sel','Id elem.'),('En_Menu','Abilita menu'),('PREVIOUS VALUE','VAL. ATTUALE'),('PUMP','POMPA'),('PRESET VALVE','VALVOLA PRED.'),('PULSE METER','MISUR. IMPULSI'),('MODBUS METER','MISUR. MODBUS'),('VIRTUAL METER','MISUR. VIRTUALE'),('METERS','MISURATORI'),('Id_Meter_Type','Tipo misur.'),('Id_Meter_Sel','Id misur.'),('Min_Flow','Portata min'),('Max_Flow','Portata max'),('Hw_Port','Porta Hw'),('Value_Rev','Valore giro'),('Pulse_Rev','Impulsi giro'),('Id_Encoder_Type','Tipo encoder'),('Check_Invalid','Controlla invalidi'),('Invalid_Thr','Soglia invalidi'),('Valid_Thr','Soglia validi'),('Pout_Value','Valore ripetizione'),('Power_Min','Corrente min'),('Power_Max','Corrente max'),('Clockwise','Verso orario'),('Id_Value_Type','Tipo valore'),('Enable_Reverse','Abilita inverso'),('Error_Reverse','Errore inverso'),('DELETE','ELIMINA'),('ADD','AGG.'),('Address','Indirizzo'),('Id_Model','Modello'),('Id_Parity_Setting','Parita COM'),('Forward_Direction','Direzione avanti'),('Cut_Off_Value','Valore cut-off'),('Shock_Suppression','Shock suppression'),('Zero_Point','Zero point'),('Flow_Damping','Flow damping'),('Id_Pulse_Out_Type','Tipo uscita imp.'),('Max_Pout_Freq','Max freq. uscita'),('Max_Pout_Flow','Max portata uscita'),('Density_Gain','Gain densita'),('Density_Offset','Offset densita'),('Temp_Gain','Gain temperatura'),('TEST MODBUS LINE','TEST LINEA MODBUS'),('SEND CONFIGURATION','INVIA CONFIGURAZIONE'),('CALCULATE ZEROPOINT','CALCOLA ZEROPOINT'),('RESTART METER','RIAVVIA MISURATORE'),('METERS_M','MISURATORI MODBUS'),('CREDENTIALS','CREDENZIALI'),('Id_User','Utente'),('Id_Level','Livello'),('ACTUAL DATE:','CORRENTE:'),('NEW DATE:','NUOVA:'),('ACTUAL TIME:','CORRENTE:'),('NEW TIME:','NUOVA:'),('METERS_X','MISURATORI VIRTUALI'),('Id_Meter_X_Type','Tipo misuratore'),('Id_Meter_A_Type','Tipo misuratore A'),('Id_Meter_A_Sel','Id misuratore A'),('Id_Meter_B_Type','Timpo misuratore B'),('Id_Meter_B_Sel','Id misuratore B'),('Id_Meter_X_Type','Connessione virtuale'),('Offset','Offset'),('Manual_Value','Valore manuale'),('Id_Err_Hnd','Gestione errore'),('Min_AD','AD min'),('Min_Value','Valore min'),('Max_AD','AD max'),('Max_Value','Valore max'),('T_PROBES','SONDE TEMPERATURA'),('D_PROBES','SONDE DENSITA'),('PUMPS','POMPE'),('Delay_On','Ritardo avvio'),('Pause_Off','Spegni su pausa'),('PUMPS','POMPE'),('Delay_On','Ritardo avvio'),('Pause_Off','Spegni su pausa'),('PRESET VALVES','VALVOLE PRED.'),('TWO STAGES VALVE','VALV. DUE STADI'),('PRESET_VALVES','VALVOLE PRED.'),('Id_Valve_Type','Tipo valvola'),('Id_Valve_Sel','Id valvola'),('LF_to_HF','Qta BF -> AF'),('HF_to_LF','Qta AF -> BF'),('Pre_stop','Anticipo stop'),('Shortname','Sigla'),('ADR','ADR'),('Id_Commodity','Tipologia'),('Id_Color','Colore'),('Static_Err_Gross','Err.\n\n statico Vamb.'),('Id_Net_Calculation','Calcolo Vcomp.'),('Static_Err_Net','Err. statico Vcomp-'),('Static_Err_Mass','Err. statico peso'),('Min_Preset_Qty','Predeterminato min.'),('Max_Preset_Qty','Predeterminato max.'),('METER LINK','ASSOCIAZIONE MIS.'),('PRODUCT_METER_LINK','ASSOCIAZIONE MISURATORE'),('Id_Product','Prodotto'),('Id_Meter','Misuratore'),('CPU','CPU'),('OUTPUTS','USCITE'),('INPUTS','INGRESSI'),('KEYBOARD','TASTIERA'),('DIAG:TCKET','DIAG.TCKET'),('SYSTEM SUMMARY','INFO SISTEMA'),('License:','Licenza:'),('internal bus frame TOT','frame bus interno TOT'),('internal bus frame ERR','frame bus interno ERR'),('DB Server version','Versione Server DB'),('DB used (free) memory','Memoria DB usata (libera)'),('DB uptime sec.','Timer DB (sec)'),('KEY PRESSED','TASTO PREMUTO'),('KEY CODE (HEX)','CODIFICA (HEX)'),('STORED EVENTS:','EVENTI TOT:'),('POWER ON:','ACCENSIONI:'),('DELIVERIES:','EROGAZIONI:'),('LEAKAGES:','TRAFILAMENTI:'),('ERRORS:','ERRORI:'),('CALIBRATIONS:','SETTAGGI:'),('HARDWARE TEST:','TEST HARDWARE:'),('DATA RESET:','RESET DATI:'),('SHIFT TICKETS:','STAMPE SHIFT:'),('SET INVENTORY:','IMPOSTAZ.CARICO:'),('SLEEP PULSES:','IMPULSI SLEEP:'),('SHOW EVENT','LISTA EVENTI'),('DELIVERY','EROGAZIONE'),('LEAKAGE','TRAFILAMENTO'),('ERROR','ERRORE'),('CALIBRATION','SETTAGGIO'),('TEST HARDWARE','TEST HARDWARE'),('RESET','RESET'),('POWER ON','ACCENSIONE'),('EV_DELIVERY_LOG','LOG EROGAZIONI'),('Preset','Predeterminato'),('Gross_Vol','Volume amb.'),('Net_Vol','Volume comp.'),('Gross_Tot_Start','Totale amb. inizio'),('Net_Tot_Start','Totale comp. inizio'),('Mass_Tot_Start','Totale peso inizio'),('Gross_Tot_End','Totale amb. fine'),('Net_Tot_End','Totale comp. fine'),('Mass_Tot_End','Totale peso fine'),('Avg_Temperature','Temp. media'),('Avg_Density','Densita media'),('Num_Stop','Num stop'),('Num_Poff','Num spegn.'),('Empty_Sensor','Sensore vuoto'),('Id_Dlv_End_Type','Terminata per'),('End_TS','Data fine'),('Error_Num','Num errore'),('Notes','Note'),('EV_LEAGAKE_LOG','LOG TRAFILAMENTI'),('EV_ERROR_LOG','LOG ERRORI'),('EV_SETUP_LOG','LOG SETTAGGI'),('Table_Name','Nome tabella'),('Field_Name','Parametro'),('Old_Value','Vecchio valore'),('New_Value','Nuovo valore'),('EV_TEST_LOG','LOG TEST HW'),('Id_Test_Type','Tipo test'),('EV_RESET_LOG','LOG RESET'),('Id_Reset_Type','Tipo reset'),('EV_POWERON_LOG','LOG ACCENSIONI'),('PARAMETERS','IMPOSTAZIONI'),('EVENTS','LOG EVENTI'),('TOTALIZERS','TOTALIZZATORI'),('FACTORY','RESET DI FABBRICA'),('YES','SI'),('NO','NO'),('Use LEFT/RIGHT arrow keys to change brightness','Usare freccia SX/DX per modificare la luminosita'),('Press OK to confirm or BACK to abort','Premere OK per confermare, CANC per annullare'),('> HIGH FLOW <','> ALTO FLUSSO <'),('> LOW FLOW <','> BASSO FLUSSO <'),('> START PUMP <','> AVVIO POMPA <'),('> LEAKAGE <','> TRAFILAMENTO <'),('> NO PULSES <','> NO IMPULSI <'),('> CLOSING <','> CHIUSURA <'),('> STOP <','> STOP <'),('> WAIT START <','> ATTESA START <'),('> ERROR <','> ERRORE <'),('> PRINT <','> STAMPA <'),('METERS_P','MISUR. IMPULSI'),('PRINTERS','STAMPANTI'),('Id_Layout','Layout'),('Id_Printer_Type','Tipo stampante'),('Id_Printer_Sel','Id stampante'),('TM295 SETTINGS','IMPOSTAZ. TM295'),('En_Buttons','Abilita pulsanti'),('En_Autoeject','Eject automatico'),('PRINTERS_TM295','STAMPANTI TM295'),('PRINT ALL DETAILS','STAMPA DETTAGLI'),('STR_Timeout_duplicate','Timeout duplicato stampa'),('STR_Font_Standard','Font standard'),('STR_Font_Bold','Font grassetto'),('STR_Font_Large','Font grande'),('STR_Screen','Schermo'),('STR_Timeout_remote_com','Timeout connessione remota'),('STR_Timer_screensaver','Timer screensaver'),('STR_Pump_switch','Contatto pompa'),('STR_LF_valve','Valvola BF'),('STR_HF_valve','Valvola AF'),('STR_Permissive','Permissivo'),('STR_Digital_input','Ingresso digitale'),('STR_Digital_output','Uscita digitale'),('STR_Force_LF','Forza BF'),('STR_Force_HF','Forza AF'),('STR_Remote_start','Start remoto'),('STR_Remote_stop','Stop remoto'),('OUTPUTS_D','USCITE DIGITALI'),('Id_Cmd_Output','Funzione uscita'),('Cmd_Data','Dati comando'),('Menu_Group','Gruppo menu'),('DIG. OUTPUT','USCITE DIG.'),('DIG. INPUT','INGRESSI DIG.'),('INPUTS_D','INGRESSI DIGITALI'),('Id_Cmd_Input','Funzione ingresso'),('Inverse','Inverso'),('STR_Timeout_serial_com','Timeout com. seriale'),('Xon_Xoff','Handshake xon/xoff'),('Enable serial com. protocol','Abilita com. seriale'),('TEX Address','Indirizzo TEX'),('Enable checksum','Abilita checksum'),('SCREEN','SCHERMATA'),('Id_Screen_Layout','Layout schermo'),('Id_Screen_Detail_1','Dettaglio 1'),('Id_Screen_Detail_2','Dettaglio 2'),('Id_Screen_Detail_3','Dettaglio 3'),('Id_Screen_Detail_4','Dettaglio 4'),('Id_Screen_Detail_5','Dettaglio 5'),('Id_Screen_Detail_6','Dettaglio 6'),('Id_Screen_Detail_7','Dettaglio 7'),('Id_Screen_Detail_8','Dettaglio 8'),('En_Decimals','Decimali'),('PRODUCT','PRODOTTO'),('FINAL GROSS','FINALE AMB.'),('INIT GROSS','INIZIALE AMB.'),('DLV GROSS','EROGATO AMB.'),('FINAL','FINE'),('INIT','INIZIO'),('DLV','ERO'),('SZP Enable','Abilita Smart Zero Preset'),('SZP Percentage','Percentuale Smart Zero Preset'),('STR_Volumetric','Volumetrico'),('STR_Mass_meter','Massico'),('STR_Monochannel_A','Monocanale A'),('STR_Monochannel_B','Monocanale B'),('STR_Bichannel','Quadratura'),('STR_LPG','GPL'),('STR_Crude_oil','Greggio'),('STR_Gasoline','Benzina'),('STR_Transition_zone','Zona di transizione'),('STR_Jet_fuel','Avio'),('STR_Fuel_oil','Diesel'),('STR_Lube_oil','Lube oil'),('STR_Red','Rosso'),('STR_Green','Verde'),('STR_Blue','Blu'),('STR_Not_used','Non usato'),('STR_System_error','Errore'),('STR_Latest_value','Ultimo valore'),('STR_Manual_value','Valore manuale'),('STR_Two_stages','Doppio stadio'),('STR_Digital','Digitale'),('STR_Font_Standard','Standard Font'),('STR_Font_Large','Font Grande'),('STR_Logo','Logo'),('STR_Preset','Predeterminato'),('STR_Gross_vol','Volume ambiente'),('STR_Net_vol','Volume compensato'),('STR_Mass','Peso'),('STR_Logo','Logo'),('STR_Preset','Predeterminato'),('STR_Gross_vol','Volume ambiente'),('STR_Net_vol','Volume compensato'),('STR_Mass','Peso'),('STR_Logo','Logo'),('STR_Preset','Predeterminato'),('STR_Gross_vol','Volume ambiente'),('STR_Net_vol','Volume compensato'),('STR_Mass','Peso'),('STR_Gross_tot','Totale ambiente'),('STR_Net_tot','Totale compensato'),('STR_Mass_tot','Totale peso'),('STR_Temperature','Temperatura'),('STR_Density','Densita'),('STR_Base_ref','Condizioni base'),('STR_Compartment','Scomparto'),('STR_Meter','Misuratore'),('STR_Product','Prodotto'),('STR_Pump','Pompa'),('STR_Preset_valve','Valvola preset'),('STR_Temperature_probe','Sonda temperatura'),('STR_Hose','Manicotto'),('STR_Printer','Stampante'),('STR_Bulk','Diretto'),('STR_Return','Ricircolo'),('STR_Outlet','Uscita'),('STR_CPU','CPU'),('STR_OUTPUTS','USCITE'),('STR_INPUTS','INGRESSI'),('STR_METER','MISURATORE'),('STR_KEYBOARD','TASTIERA'),('STR_PRINTER','STAMPANTE'),('STR_DIAG_TICKET','DIAG_TICKET'),('STR_PARAMETERS','PARAMETRI'),('STR_EVENTS','EVENTI'),('STR_TOTALIZERS','TOTALIZZATORI'),('STR_FACTORY_RESET','FACTORY RESET'),('STR_Delivery','Erogazione'),('STR_Leakage','Trafilamento'),('STR_Error','Errore'),('STR_Test','Test'),('STR_Reset','Reset'),('STR_Sleep','Impulsi spento'),('STR_Preset_type','Tipo predeterminazione'),('STR_Meter_pulser','Misuratore impulsivo'),('STR_Alpha','Alfa'),('STR_Black','Nero'),('STR_White','Bianco'),('STR_Dark_red','Rosso scuro'),('STR_Dark_green','Verde scuro'),('STR_Dark_gray','Grigio scuro'),('STR_Gray','Grigio'),('STR_Magenta','Magenta'),('STR_Yellow','Giallo'),('STR_Ivory','Avorio'),('STR_Light_ivory','Avorio chiaro'),('STR_Azure','Azzurro'),('STR_Light_red','Rosso chiaro'),('STR_Light_blue','Blu chiaro'),('STR_Green_bottle','Verde bottiglia'),('STR_Green_spicy','Verde acceso'),('STR_Orange','Arancione'),('STR_Light_orange','Arancione chiaro'),('STR_Timeout_no_pulse','Timeout assenza impulsi'),('STR_Timeout_stop','Timeout stop manuale'),('STR_Timeout_error','Timeout errori'),('STR_Pulses_reverse_leakage','Impulsi trafilamento inverso'),('STR_Leakage_threshold','Soglia trafilamento'),('STR_Sales_per_product','Progressivo per prodotto'),('STR_Skip_boot_msg','Salta messaggi boot'),('STR_Enable_zero_start','Abilita zero start'),('STR_Wait_start_dlv','Attesa avvio erogazione'),('STR_Default_add_vol','Default add volume'),('STR_Enable_decimals','Abilita decimali'),('STR_Backlight','Retroilluminazione'),('STR_Language','Lingua'),('STR_Even','Pari'),('STR_Odd','Dispari'),('STR_Virtual','Virtuale'),('STR_Series_meters','Misuratori in serie'),('STR_Density_probe','Sonda densita'),('STR_Modbus_meter','Misuratore su Modbus'),('STR_TEX_sn','Numero di serie TEX'),('STR_Delivery','Erogazione'),('STR_Leakage','Trafilamento'),('STR_Error','Errore'),('STR_Test','Test'),('STR_Reset','Reset'),('STR_Sleep','Impulsi da spento'),('STR_Preset_quantity','Quantita preset'),('STR_Manual_stop','Stop manuale'),('STR_Pulse_timeout','Assenza impulsi'),('STR_Alarm','Allarme'),('STR_Power_off','Spegnimento'),('STR_Power_on','Accensione'),('BACK','INDIETRO'),('SUBMIT','INVIA'),('QUANTITY','QUANTITA'),('Loading...','Caricamento...'),('SHARE','CONDIVIDI'),('PRINTING TICKET','STAMPA CARTELLINO'),('DUPLICATE','DUPLICATO'),('SSH connection','Connessione SSH'),('PLATE','TARGA'),('WM_Seal','WM'),('SYS_SETUP_PLATE','TARGA SISTEMA'),('SYS_SETUP_COM','COM SERIALE'),('SERIAL COM.','COM SERIALE'),('VIEW PLATE','MOSTRA TARGA'),('STR_Pulse_out','Rip. impulsi'),('Name','Nome');

--
-- Table structure for table `SYS_SETUP_COM`
--

CREATE TABLE `SYS_SETUP_COM` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  `Id_Level` int(11) DEFAULT NULL,
  `WM_Seal` int(1) DEFAULT 0,
  `Value` varchar(32) DEFAULT NULL,
  `Order_Idx` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `SYS_SETUP_COM`
--

INSERT INTO `SYS_SETUP_COM` VALUES (1,'Enable serial com. protocol',2,0,'0',NULL),(2,'Hw_Port',6,0,'1',NULL),(3,'Baud',6,0,'9600',NULL),(4,'Frame',6,0,'N81',NULL),(5,'Xon_Xoff',6,0,'0',NULL),(6,'TEX Address',2,0,'1',NULL),(7,'Enable checksum',2,0,'0',NULL),(8,'Enable challenge',2,0,'0',NULL);

--
-- Table structure for table `SYS_SETUP_ERRORS`
--

CREATE TABLE `SYS_SETUP_ERRORS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  `Id_Level` int(11) DEFAULT NULL,
  `WM_Seal` int(1) DEFAULT 0,
  `Value` varchar(32) DEFAULT NULL,
  `Order_Idx` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `SYS_SETUP_ERRORS`
--

INSERT INTO `SYS_SETUP_ERRORS` VALUES (1,'STR_Pulses_reverse_leakage',2,0,'100',NULL),(2,'STR_Leakage_threshold',2,0,'10',NULL),(3,'STR_Skip_boot_msg',2,0,'0',NULL);

--
-- Table structure for table `SYS_SETUP_OTHERS`
--

CREATE TABLE `SYS_SETUP_OTHERS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  `Id_Level` int(11) DEFAULT NULL,
  `WM_Seal` int(1) DEFAULT 0,
  `Value` varchar(32) DEFAULT NULL,
  `Order_Idx` int(11) DEFAULT NULL,
  `Hide` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `SYS_SETUP_OTHERS`
--

INSERT INTO `SYS_SETUP_OTHERS` VALUES (1,'STR_Sales_per_product',2,0,'1',5,0),(2,'STR_Enable_zero_start',2,0,'0',4,0),(3,'STR_Default_add_vol',2,0,'100',3,0),(4,'STR_Enable_decimals',2,1,'1',2,0),(5,'STR_Backlight',1,0,'6',NULL,1),(6,'STR_Language',1,0,'1',NULL,1),(7,'STR_TEX_sn',5,0,'12345678',1,0),(8,'Debugger data',6,0,'SIM',999,0),(9,'SZP Enable',2,1,'1',6,0),(10,'SZP Percentage',2,1,'.5',7,0),(11,'SSH connection',6,0,'1',8,0);

--
-- Table structure for table `SYS_SETUP_PLATE`
--

CREATE TABLE `SYS_SETUP_PLATE` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  `Id_Level` int(11) DEFAULT NULL,
  `WM_Seal` int(1) DEFAULT 1,
  `Value` varchar(32) DEFAULT NULL,
  `Order_Idx` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `SYS_SETUP_PLATE`
--

INSERT INTO `SYS_SETUP_PLATE` VALUES (1,'TEX serial num.',3,1,'TEX-SN',1),(2,'Printer serial num.',3,1,'PRINTER-SN',2),(3,'Meter data 1',3,1,'METER DATA1',3),(4,'Meter data 2',3,1,'METER DATA2',4),(5,'Meter data 3',3,1,'METER DATA3',5),(6,'Meter data 4',3,1,'METER DATA4',6);

--
-- Table structure for table `SYS_SETUP_TIMERS`
--

CREATE TABLE `SYS_SETUP_TIMERS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  `Id_Level` int(11) DEFAULT NULL,
  `WM_Seal` int(1) DEFAULT 0,
  `Value` int(11) DEFAULT NULL,
  `Order_Idx` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `SYS_SETUP_TIMERS`
--

INSERT INTO `SYS_SETUP_TIMERS` VALUES (1,'STR_Timeout_no_pulse',2,0,10000,NULL),(2,'STR_Timeout_stop',2,0,10000,NULL),(3,'STR_Timeout_error',2,0,5000,NULL),(4,'STR_Wait_start_dlv',2,0,0,NULL),(5,'STR_Timeout_duplicate',2,0,10000,NULL),(6,'STR_Timeout_remote_com',3,0,0,NULL),(7,'STR_Timer_screensaver',2,0,0,NULL),(8,'STR_Timeout_serial_com',2,0,0,NULL);

--
-- Table structure for table `SYS_SETUP_UOMS`
--

CREATE TABLE `SYS_SETUP_UOMS` (
  `Id_UOM_Vol` int(11) DEFAULT NULL,
  `Id_UOM_Mass` int(11) DEFAULT NULL,
  `Id_UOM_Flow` int(11) DEFAULT NULL,
  `Id_UOM_Density` int(11) DEFAULT NULL,
  `Id_UOM_Temp` int(11) DEFAULT NULL,
  `Id_UOM_Flow_Mass` int(11) DEFAULT NULL,
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `SYS_SETUP_UOMS`
--

INSERT INTO `SYS_SETUP_UOMS` VALUES (1,1,1,1,1,1,1);

--
-- Table structure for table `SYS_SETUP_WIFI`
--

CREATE TABLE `SYS_SETUP_WIFI` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  `Id_Level` int(11) DEFAULT NULL,
  `WM_Seal` int(1) DEFAULT 0,
  `Value` varchar(32) DEFAULT NULL,
  `Order_Idx` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `SYS_SETUP_WIFI`
--

INSERT INTO `SYS_SETUP_WIFI` VALUES (1,'Enable',3,0,'1',1),(2,'SSID',3,0,'TEX-AP',2),(3,'WPA2 Passphrase',3,0,'12983476',3);

--
-- Table structure for table `TABLE_CREDENTIAL_LINK`
--

CREATE TABLE `TABLE_CREDENTIAL_LINK` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Table_Name` varchar(32) DEFAULT NULL,
  `Field_Name` varchar(32) DEFAULT NULL,
  `Id_Level_Rd` int(11) DEFAULT NULL,
  `Id_Level_Wr` int(11) DEFAULT NULL,
  `Readonly` tinyint(1) DEFAULT NULL,
  `Hide` tinyint(1) DEFAULT NULL,
  `Wm` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `TABLE_CREDENTIAL_LINK`
--



--
-- Table structure for table `TEST_TYPES`
--

CREATE TABLE `TEST_TYPES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `TEST_TYPES`
--

INSERT INTO `TEST_TYPES` VALUES (1,'STR_CPU'),(2,'STR_OUTPUTS'),(3,'STR_INPUTS'),(4,'STR_METER'),(5,'STR_KEYBOARD'),(6,'STR_PRINTER'),(7,'STR_DIAG_TICKET');

--
-- Table structure for table `TICKET_FIELDS`
--

CREATE TABLE `TICKET_FIELDS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  `Order_Idx` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `TICKET_FIELDS`
--

INSERT INTO `TICKET_FIELDS` VALUES (1,'STR_Textline',10),(2,'STR_Logo',1),(3,'STR_Preset',20),(4,'STR_Gross_vol',100),(5,'STR_Net_vol',101),(6,'STR_Mass',102),(7,'STR_Gross_tot_ini',103),(8,'STR_Net_tot_ini',104),(9,'STR_Mass_tot_ini',105),(10,'STR_Temperature',21),(11,'STR_Density',22),(12,'STR_Base_ref',23),(13,'STR_Product_name',24),(14,'STR_Sales_num',25),(15,'STR_Meter_name',26),(16,'STR_Divider',2),(17,'STR_Solid_Divider',3),(18,'STR_Delivered_qty',27),(19,'STR_Gross_tot_end',106),(20,'STR_Net_tot_end',107),(21,'STR_Mass_tot_end',108),(22,'STR_Start_timestamp',28),(23,'STR_End_timestamp',29);

--
-- Table structure for table `TICKET_FONTS`
--

CREATE TABLE `TICKET_FONTS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Description_STR` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `TICKET_FONTS`
--

INSERT INTO `TICKET_FONTS` VALUES (1,'STR_Font_Standard'),(2,'STR_Font_Bold'),(3,'STR_Font_Large');

--
-- Table structure for table `TICKET_LAYOUTS`
--

CREATE TABLE `TICKET_LAYOUTS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Order_Idx` int(11) DEFAULT NULL,
  `Name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `TICKET_LAYOUTS`
--

INSERT INTO `TICKET_LAYOUTS` VALUES (1,1,'STANDARD');

--
-- Table structure for table `TICKET_LAYOUT_DATA`
--

CREATE TABLE `TICKET_LAYOUT_DATA` (
  `Id_Layout` int(11) DEFAULT NULL,
  `Id_Field` int(11) DEFAULT NULL,
  `Id_Font` int(11) DEFAULT NULL,
  `X` int(11) DEFAULT NULL,
  `Y` int(11) DEFAULT NULL,
  `Extra_Info` varchar(128) DEFAULT '1',
  `En_Label` tinyint(1) DEFAULT 1,
  `Tot_Digits` int(11) DEFAULT 0,
  `Dec_Digits` int(11) DEFAULT 0,
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `TICKET_LAYOUT_DATA`
--

INSERT INTO `TICKET_LAYOUT_DATA` VALUES (1,1,1,1,1,'S.A.M.P.I. SPA',0,0,0,45),(1,1,1,1,2,'VIA AMERIGO VESPUCCI, 1',0,0,0,46),(1,1,1,1,3,'ALTOPASCIO (LU) - ITALY',0,0,0,47),(1,16,1,1,5,'200',0,0,0,48),(1,13,3,2,6,'-',0,0,0,49),(1,1,1,1,9,'FINAL',1,0,0,51),(1,23,1,14,9,'-',0,0,0,52),(1,1,1,1,10,'INIT',1,0,0,53),(1,22,1,14,10,'-',0,0,0,54),(1,16,1,1,12,'200',0,0,0,55),(1,15,1,1,13,'-',1,0,0,56),(1,3,2,1,14,'-',1,0,0,57),(1,16,1,1,15,'200',1,0,0,58),(1,1,1,1,16,'FINAL GROSS',1,0,0,59),(1,1,1,1,17,'INIT GROSS',1,0,0,60),(1,1,2,1,18,'DLV GROSS',1,0,0,61),(1,19,1,20,16,'1',0,9,2,62),(1,7,1,20,17,'1',0,9,2,63),(1,4,2,20,18,'1',0,9,2,64),(1,17,1,1,20,'200',0,0,0,65),(1,18,3,7,21,'-',0,9,2,66),(1,17,1,1,24,'200',0,0,0,67),(1,1,1,1,25,'ABCDEFGHIJKLMNOPQRSTUVWXYZ123456789',1,0,0,68),(1,1,3,2,21,'DLV',1,0,0,69),(1,14,3,24,6,'1',0,5,0,70),(1,1,3,20,6,'N.',0,0,0,71);

--
-- Table structure for table `T_PROBES`
--

CREATE TABLE `T_PROBES` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Enable` tinyint(1) DEFAULT 0,
  `Name` varchar(32) DEFAULT 'NEW PT100',
  `Hw_Port` int(11) DEFAULT 1,
  `Offset` float DEFAULT 0,
  `Manual_Value` float DEFAULT 20,
  `Id_Err_Hnd` int(11) DEFAULT 1,
  `Order_Idx` int(11) DEFAULT NULL,
  `Menu_Group` int(11) DEFAULT 0,
  `Min_Value` float DEFAULT -30,
  `Max_Value` float DEFAULT 85,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `T_PROBES`
--

INSERT INTO `T_PROBES` VALUES (1,1,'PT100',1,0,20,1,NULL,NULL,-30,85);

--
-- Table structure for table `T_PROBES_RT`
--

CREATE TABLE `T_PROBES_RT` (
  `Id_T_Probe` int(11) DEFAULT NULL,
  `RT_Value` float(6,2) DEFAULT NULL,
  KEY `Id_T_Probe` (`Id_T_Probe`)
);

--
-- Dumping data for table `T_PROBES_RT`
--

INSERT INTO `T_PROBES_RT` VALUES (1,999.90);

--
-- Table structure for table `UOM_DENSITY`
--

CREATE TABLE `UOM_DENSITY` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Label` varchar(32) DEFAULT NULL,
  `Base_Unit` float DEFAULT NULL,
  `Tag` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `UOM_DENSITY`
--

INSERT INTO `UOM_DENSITY` VALUES (1,'kg/m3',1,'KG/M3');

--
-- Table structure for table `UOM_FLOW`
--

CREATE TABLE `UOM_FLOW` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Label` varchar(32) DEFAULT NULL,
  `Base_Unit` float DEFAULT NULL,
  `Tag` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `UOM_FLOW`
--

INSERT INTO `UOM_FLOW` VALUES (1,'Liters per minute',1,'L/MIN'),(2,'Gallons per minute',4.54609,'GUK/MIN'),(3,'Gallons per minute',3.78541,'GUS/MIN'),(4,'Cubic meters per hour',16.667,'M3/H'),(5,'Barrels per hour',2.6498,'BBL/H');

--
-- Table structure for table `UOM_FLOW_MASS`
--

CREATE TABLE `UOM_FLOW_MASS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Label` varchar(32) DEFAULT NULL,
  `Base_Unit` float DEFAULT NULL,
  `Tag` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `UOM_FLOW_MASS`
--

INSERT INTO `UOM_FLOW_MASS` VALUES (1,'kg per minute',1,'KG/MIN'),(2,'ton per hour',16.67,'T/H'),(3,'lb per minute',0.453592,'LB/MIN'),(4,'grams per second',0.06,'G/S'),(5,'once per minute',0.0283495,'OZ/MIN'),(6,'us ton per hour',15.1198,'TON/H');

--
-- Table structure for table `UOM_MASS`
--

CREATE TABLE `UOM_MASS` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Label` varchar(32) DEFAULT NULL,
  `Base_Unit` float DEFAULT NULL,
  `Tag` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `UOM_MASS`
--

INSERT INTO `UOM_MASS` VALUES (1,'kilogrs',1,'KG'),(2,'tons',1000,'T'),(3,'pounds',0.453592,'LB'),(4,'grams',0.001,'G'),(5,'once',0.0283495,'OZ'),(6,'short tons',907.185,'TON');

--
-- Table structure for table `UOM_TEMP`
--

CREATE TABLE `UOM_TEMP` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Label` varchar(32) DEFAULT NULL,
  `Base_Unit` float DEFAULT NULL,
  `Tag` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `UOM_TEMP`
--

INSERT INTO `UOM_TEMP` VALUES (1,'°C',1,'°C'),(2,'°F',1,'°F');

--
-- Table structure for table `UOM_VOL`
--

CREATE TABLE `UOM_VOL` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Label` varchar(32) DEFAULT NULL,
  `Base_Unit` float DEFAULT NULL,
  `Tag` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`Id`)
);

--
-- Dumping data for table `UOM_VOL`
--

INSERT INTO `UOM_VOL` VALUES (1,'litres',1,'L'),(2,'gallons',4.54609,'GUK'),(3,'gallons',3.78541,'GUS'),(4,'cubic meter',1000,'M3'),(5,'barrels',158.987,'BBL'),(6,'cubic cm',0.001,'CM3'),(7,'cubic dm',1,'DM3'),(8,'millilitre',0.001,'ML'),(9,'hectolitre',100,'HL'),(10,'kilolitre',1000,'KL'),(11,'cubic foot',28.3168,'FT3'),(12,'inch once force',0.00007,'OZF');


