· 5 years ago · Mar 04, 2020, 02:14 PM
1CREATE TABLE IF NOT EXISTS `machineproductionsetup` (
2 `MachineIdent` char(50) NOT NULL,
3 `AllowedTimeBetweenPieces` int(10) NOT NULL COMMENT 'Seconds',
4 `MaxAllowedTimeBetweenPieces` int(10) NOT NULL COMMENT 'Seconds',
5 `RunRateTargetValue` int(20) NOT NULL,
6 `RunRateTargetUnit` char(10) NOT NULL,
7 `MachineUtilizationTarget` int(10) NOT NULL,
8 `DelayCodeArray` varchar(5000) DEFAULT NULL COMMENT 'csv',
9 PRIMARY KEY (`MachineIdent`)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1;