53 lines
4.4 KiB
MySQL
53 lines
4.4 KiB
MySQL
|
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);
|