Michal Buzik
7072399225
Introduced new features including database upgrade logic, schema comparison, and schema-based updates. Refactored main program structure for modularity. Added unit tests and updated configuration files to support upgrades and enhanced mapping functionality.
53 lines
4.4 KiB
SQL
53 lines
4.4 KiB
SQL
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);
|