CREATE TABLE `state` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`jobnr` VARCHAR(10) NULL DEFAULT NULL,
	`ordernr` VARCHAR(10) NULL DEFAULT NULL,
	`techid` INT(11) NOT NULL,
	`Class` VARCHAR(45) NULL DEFAULT NULL,
	`timestamp` DATETIME NOT NULL,
	`station` VARCHAR(45) NULL DEFAULT NULL,
	`app` VARCHAR(45) NULL DEFAULT NULL,
	`op` VARCHAR(45) NULL DEFAULT NULL,
	`info1` VARCHAR(1024) NULL DEFAULT NULL,
	`info2` VARCHAR(1024) NULL DEFAULT NULL,
	`info3` VARCHAR(1024) NULL DEFAULT NULL,
	`info4` VARCHAR(1024) NULL DEFAULT NULL,
	`info5` VARCHAR(1024) NULL DEFAULT NULL,
	`status` VARCHAR(10) NOT NULL,
	`side` CHAR(1) NOT NULL,
	`user` VARCHAR(45) NULL DEFAULT NULL,
	`origindate` DATETIME NULL DEFAULT NULL,
	`nextstatus` VARCHAR(10) NULL DEFAULT NULL,
	`nexttimestamp` DATETIME NULL DEFAULT NULL,
	PRIMARY KEY (`id`),
	INDEX `JobNumber` (`jobnr`, `timestamp`),
	INDEX `timestamp` (`timestamp`),
	INDEX `station` (`station`, `timestamp`),
	INDEX `iStatus` (`status`, `timestamp`),
	INDEX `iStatusNext` (`status`, `nextstatus`, `timestamp`),
	INDEX `iNextStatus` (`nextstatus`, `status`, `nexttimestamp`),
	INDEX `info1` (`info1`(20), `timestamp`),
	INDEX `info2` (`info2`(20), `timestamp`),
	INDEX `info3` (`info3`(20), `timestamp`),
	INDEX `info4` (`info4`(20), `timestamp`),
	INDEX `info5` (`info5`(20), `timestamp`),
	INDEX `iOrderid` (`ordernr`, `timestamp`),
	INDEX `techid` (`techid`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=208860409
;