-- phpMyAdmin SQL Dump -- version 3.5.2.2 -- http://www.phpmyadmin.net -- -- Hostiteľ: 127.0.0.1 -- Vygenerované: Št 10.Apr 2025, 11:32 -- Verzia serveru: 5.5.27 -- Verzia PHP: 5.4.7 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Databáza: `slm-end` -- -- -------------------------------------------------------- -- -- Štruktúra tabuľky pre tabuľku `benchpath` -- CREATE TABLE IF NOT EXISTS `benchpath` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `ItemNr` int(11) DEFAULT NULL, `Name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Qfrom` float DEFAULT NULL, `Qto` float DEFAULT NULL, `TempIn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `TempOut` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PressIn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PressOut` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PressMtrDelta` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `StopBFValve` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `ValvesOpen` varchar(8000) COLLATE utf8_unicode_ci DEFAULT NULL, `ValvesClose` varchar(8000) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ; -- -- Sťahujem dáta pre tabuľku `benchpath` -- INSERT INTO `benchpath` (`Id`, `ItemNr`, `Name`, `Qfrom`, `Qto`, `TempIn`, `TempOut`, `PressIn`, `PressOut`, `PressMtrDelta`, `StopBFValve`, `ValvesOpen`, `ValvesClose`) VALUES (1, 0, '', 0, 0, '---', '---', '---', '---', '---', NULL, '', ''), (2, 1, 'PBench1', 0.01, 100, 'T9', 'T10', 'Pr1', 'Pr2', 'Pr1', 'Vb', 'VL12;VI12', ''), (3, 2, 'PBench2', 0.01, 50, 'T9', 'T10', 'Pr1', 'Pr2', 'Pr1', 'Vb', 'VL12', 'VI12'), (4, 3, 'PBench3', 0, 0, 'T9', 'T10', 'Pr5', 'Pr6', '---', NULL, '', ''), (5, 4, 'pause', 0, 0, 'T9', 'T10', 'Pr1', 'Pr2', 'Pr1', 'Vb', 'VI12', 'VL12'); -- -------------------------------------------------------- -- -- Štruktúra tabuľky pre tabuľku `component` -- CREATE TABLE IF NOT EXISTS `component` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `ClassName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `ParentName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `ItemNr` int(11) DEFAULT NULL, `Mode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Logging` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Parameters` varchar(8000) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=83 ; -- -- Sťahujem dáta pre tabuľku `component` -- INSERT INTO `component` (`Id`, `Name`, `ClassName`, `ParentName`, `ItemNr`, `Mode`, `Logging`, `Parameters`) VALUES (1, 'BenchInfo', 'BenchInfoEx', '', 1, 'Normal', 'Off', '\r\n\r\n Endurance\r\n 2\r\n Slovenská legálna metrológia\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n'), (2, 'CB', 'ControlBoard', '', 2, 'Normal', 'Off', '\r\n\r\n 1\r\n 50\r\n 59\r\n'), (3, 'I1', 'FlowMeter', 'CB', 4, 'Normal', 'Off', '\r\n\r\n 1\r\n 50\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0007/312.03/19\r\n 2019-01-15T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 2021-01-15T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n'), (4, 'I2', 'FlowMeter', 'CB', 5, 'Normal', 'Off', '\r\n\r\n 2\r\n 50\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0008/312.03/19\r\n 2019-01-15T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 2021-01-15T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n'), (5, 'I3', 'FlowMeter', 'CB', 6, 'Normal', 'Off', '\r\n\r\n 3\r\n 0.5\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0\r\n 0009/312.03/19\r\n 2019-01-15T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 2021-01-15T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n 0001-01-01T00:00:00\r\n'), (6, 'VR1', 'RegulationValve', 'CB', 7, 'Normal', 'Off', '\r\n\r\n 1\r\n Output\r\n 20\r\n 435\r\n 500\r\n 5\r\n false\r\n false\r\n'), (7, 'VR2', 'RegulationValve', 'CB', 8, 'Normal', 'Off', '\r\n\r\n 2\r\n Output\r\n 45\r\n 465\r\n 500\r\n 5\r\n false\r\n false\r\n'), (8, 'VR3', 'RegulationValve', 'CB', 9, 'Normal', 'Off', '\r\n\r\n 3\r\n Output\r\n 61\r\n 443\r\n 500\r\n 5\r\n false\r\n false\r\n'), (9, 'VRZ1', 'RegulationValve', 'CB', 10, 'Normal', 'Off', '\r\n\r\n 4\r\n Feeding\r\n 100\r\n 500\r\n 500\r\n 5\r\n false\r\n false\r\n'), (10, 'P11', 'PumpWithFM', 'CB', 11, 'Normal', 'Off', '\r\n\r\n 8\r\n 0\r\n 1\r\n'), (11, 'P12', 'PumpWithFM', 'CB', 12, 'Normal', 'Off', '\r\n\r\n 9\r\n 1\r\n 1\r\n'), (12, 'P21', 'PumpWithFM', 'CB', 13, 'Normal', 'Off', '\r\n\r\n 10\r\n 2\r\n 1\r\n'), (13, 'P22', 'PumpWithFM', 'CB', 14, 'Normal', 'Off', '\r\n\r\n 11\r\n 3\r\n 1\r\n'), (14, 'VI11', 'Valve', 'CB', 21, 'Normal', 'All', '\r\n\r\n 0\r\n Output\r\n 1\r\n false\r\n \r\n false\r\n 0\r\n 0\r\n'), (15, 'VI21', 'Valve', 'CB', 22, 'Normal', 'Off', '\r\n\r\n 1\r\n Output\r\n 1\r\n false\r\n \r\n false\r\n 0\r\n 0\r\n'), (16, 'VI22', 'Valve', 'CB', 23, 'Normal', 'Off', '\r\n\r\n 2\r\n Output\r\n 1\r\n false\r\n \r\n false\r\n 0\r\n 0\r\n'), (17, 'VL12', 'Valve', 'CB', 24, 'Normal', 'Off', '\r\n\r\n 3\r\n Bench\r\n 1\r\n false\r\n \r\n false\r\n 0\r\n 0\r\n'), (18, 'VI12', 'Valve', 'CB', 25, 'Normal', 'Off', '\r\n\r\n 4\r\n Bench\r\n 1\r\n false\r\n \r\n false\r\n 0\r\n 0\r\n'), (19, 'VL13', 'Valve', 'CB', 26, 'Normal', 'Off', '\r\n\r\n 5\r\n Feeding\r\n 1\r\n false\r\n \r\n false\r\n 0\r\n 0\r\n'), (20, 'Gate', 'Valve', 'CB', 27, 'Normal', 'Off', '\r\n\r\n 13\r\n None\r\n 1\r\n false\r\n \r\n false\r\n 0\r\n 0\r\n'), (21, 'Del0', 'Valve', 'CB', 28, 'Normal', 'Off', '\r\n\r\n 14\r\n None\r\n 1\r\n false\r\n \r\n false\r\n 0\r\n 0\r\n'), (22, 'Del1', 'Valve', 'CB', 29, 'Normal', 'Off', '\r\n\r\n 15\r\n None\r\n 1\r\n false\r\n \r\n false\r\n 0\r\n 0\r\n'), (23, 'Zasobnik', 'Valve', 'CB', 30, 'Normal', 'Off', '\r\n\r\n 16\r\n Feeding\r\n 1\r\n false\r\n \r\n false\r\n 0\r\n 0\r\n'), (24, 'W', 'Dummy.Balance', '', 31, 'Normal', 'Off', '\r\n'), (25, 'Div', 'Dummy.Diverter', '', 32, 'Normal', 'Off', '\r\n'), (26, 'Vb', 'Dummy.Valve', '', 33, 'Normal', 'Off', '\r\n'), (27, 'Sick1', 'RegisterReader', 'CB', 34, 'Normal', 'Off', '\r\n\r\n 1\r\n'), (28, 'Sick2', 'RegisterReader', 'CB', 35, 'Normal', 'Off', '\r\n\r\n 2\r\n'), (29, 'Sick3', 'RegisterReader', 'CB', 36, 'Normal', 'Off', '\r\n\r\n 3\r\n'), (30, 'Sick4', 'RegisterReader', 'CB', 37, 'Normal', 'Off', '\r\n\r\n 4\r\n'), (31, 'Sick5', 'RegisterReader', 'CB', 38, 'Normal', 'Off', '\r\n\r\n 5\r\n'), (32, 'Sick6', 'RegisterReader', 'CB', 39, 'Normal', 'Off', '\r\n\r\n 6\r\n'), (33, 'Sick7', 'RegisterReader', 'CB', 40, 'Normal', 'Off', '\r\n\r\n 7\r\n'), (34, 'Sick8', 'RegisterReader', 'CB', 41, 'Normal', 'Off', '\r\n\r\n 8\r\n'), (35, 'Sick9', 'RegisterReader', 'CB', 42, 'Normal', 'Off', '\r\n\r\n 9\r\n'), (36, 'Sick10', 'RegisterReader', 'CB', 43, 'Normal', 'Off', '\r\n\r\n 10\r\n'), (37, 'WM1', 'WaterMeter', '', 44, 'Normal', 'Off', '\r\n\r\n'), (38, 'WM2', 'WaterMeter', '', 45, 'Normal', 'Off', '\r\n\r\n'), (39, 'WM3', 'WaterMeter', '', 46, 'Normal', 'Off', '\r\n\r\n'), (40, 'WM4', 'WaterMeter', '', 47, 'Normal', 'Off', '\r\n\r\n'), (41, 'WM5', 'WaterMeter', '', 48, 'Normal', 'Off', '\r\n\r\n'), (42, 'WM6', 'WaterMeter', '', 49, 'Normal', 'Off', '\r\n\r\n'), (43, 'WM7', 'WaterMeter', '', 50, 'Normal', 'Off', '\r\n\r\n'), (44, 'WM8', 'WaterMeter', '', 51, 'Normal', 'Off', '\r\n\r\n'), (45, 'WM9', 'WaterMeter', '', 52, 'Normal', 'Off', '\r\n\r\n'), (46, 'WM10', 'WaterMeter', '', 53, 'Normal', 'Off', '\r\n\r\n'), (47, 'Endurance1', 'TestMethods.Endurance', '', 54, 'Normal', 'Off', '\r\n\r\n 1000~25~32§15000~0~0§1000~32~8§15000~0~0\r\n'), (48, 'DataEntry-Standard', 'DataEntry-Standard-12', '', 55, 'Normal', 'Off', '\r\n\r\n false\r\n false\r\n false\r\n'), (49, 'FileWriter.Enhanced.Single', 'Output.FileWriters.Enhanced.Single', '', 56, 'Normal', 'Off', '\r\n\r\n C:\\Tbf\\Results\\\r\n \r\n FourDigit\r\n TwoDigit\r\n TwoDigit\r\n {0:yyMMdd-HHmm}.txt\r\n system\r\n None\r\n false\r\n false\r\n
Slovenská legálna metrológia n.o.
\r\n \r\n 15~Flow()~~None~~~0~Left\r\n 28~H amb()~~None~~~0~Left\r\n 31~Error()~~None~~~0~Left\r\n 24~P down end()~~None~~~0~Left\r\n 23~P down start()~~None~~~0~Left\r\n 21~P up end()~~None~~~0~Left\r\n 20~P up start()~~None~~~0~Left\r\n 29~Volume()~~None~~~0~Left\r\n \r\n \r\n 30~Vol.ref.()~~None~~~0~Left\r\n 19~P up()~~None~~f4~0~Left\r\n 22~P down()~~None~~f4~0~Left\r\n 12~T start()~~None~~~0~Left\r\n 13~T end()~~None~~~0~Left\r\n 31~Error()~~None~~~0~Left\r\n 16~T in()~~None~~~0~Left\r\n 17~T out()~~None~~~0~Left\r\n \r\n