CREATE TABLE IF NOT EXISTS `test` (
                                      `Id` int(11) NOT NULL AUTO_INCREMENT,
                                      `ItemNr` int(11) DEFAULT NULL,
                                      `Name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
                                      `Part` int(11) DEFAULT NULL,
                                      `Publish` tinyint(4) DEFAULT NULL,
                                      `Evaluate` tinyint(1) DEFAULT NULL,
                                      `Qfrom` float DEFAULT NULL,
                                      `Qto` float DEFAULT NULL,
                                      `Volume` float DEFAULT NULL,
                                      `TstTime` float DEFAULT NULL,
                                      `Repeats` int(11) DEFAULT NULL,
                                      `Emptying` tinyint(1) DEFAULT NULL,
                                      `Zeroing` tinyint(1) DEFAULT NULL,
                                      `DoControlWaterTemp` tinyint(1) NOT NULL DEFAULT '0',
                                      `TempLimLo` float NOT NULL DEFAULT '15',
                                      `TempLimHi` float NOT NULL DEFAULT '25',
                                      `PumpPower` float DEFAULT NULL,
                                      `MassRepeats` int(11) DEFAULT NULL,
                                      `MassSpread` float DEFAULT NULL,
                                      `MassMethod` tinyint(1) DEFAULT NULL,
                                      `TimeBeforeFlow` int(11) DEFAULT NULL,
                                      `TimeFlow2Mass` int(11) DEFAULT NULL,
                                      `TimeMass2Start` int(11) DEFAULT NULL,
                                      `TimeStop2Mass` int(11) DEFAULT NULL,
                                      `Method` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
                                      `ErrLimLo` float DEFAULT NULL,
                                      `ErrLimHi` float DEFAULT NULL,
                                      `Uncertainty` float DEFAULT NULL,
                                      `TolerRed` double DEFAULT NULL,
                                      `RedType` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
                                      `FeedingPath` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
                                      `BenchPath` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
                                      `OutputPath` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
                                      `MetersPath` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
                                      `HeatMetersPath` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
                                      `RelTransBefore` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
                                      `RelTransBetween` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
                                      `RelTransAfter` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
                                      `TransitionAfter` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
                                      `Procedure_id` int(11) DEFAULT NULL,
                                      PRIMARY KEY (`Id`),
                                      KEY `Procedure_id` (`Procedure_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4322 ;

--
-- Sťahujem dáta pre tabuľku `test`
--

INSERT INTO `test` (`Id`, `ItemNr`, `Name`, `Part`, `Publish`, `Evaluate`, `Qfrom`, `Qto`, `Volume`, `TstTime`, `Repeats`, `Emptying`, `Zeroing`, `DoControlWaterTemp`, `TempLimLo`, `TempLimHi`, `PumpPower`, `MassRepeats`, `MassSpread`, `MassMethod`, `TimeBeforeFlow`, `TimeFlow2Mass`, `TimeMass2Start`, `TimeStop2Mass`, `Method`, `ErrLimLo`, `ErrLimHi`, `Uncertainty`, `TolerRed`, `RedType`, `FeedingPath`, `BenchPath`, `OutputPath`, `MetersPath`, `HeatMetersPath`, `RelTransBefore`, `RelTransBetween`, `RelTransAfter`, `TransitionAfter`, `Procedure_id`) VALUES
(1, 0, 'Test1', 0, 1, 1, 2, 2.2, 58.3333, 100, 1, 0, 0, 0, 15, 25, 60, 0, 0, 0, 10, 5, 1, 5, 'FlyingStart.Single', -2, 2, 0, 0, 'Fix', 'CFeed1', 'PBench1', 'CPQ1B', 'PSens1', NULL, '', '', '', '', 4),
(2, 0, 'Test1', 0, 1, 1, 2, 2.2, 100, 171.429, 1, 0, 0, 0, 15, 25, 60, 0, 0, 0, 10, 5, 1, 5, 'FlyingStart.Single', -2, 2, 0, 0, 'Fix', 'CFeed1', 'PBench1', 'CPQ1B', 'PSens1', NULL, '', '', '', '', 5);