Так же отдельными двумя таблицами входят 196 427 612 автонорм из немецких справочников. Демо-версия: http://autodatabases.ru/norms/
DROP TABLE IF EXISTS `carservice2018`;
CREATE TABLE `carservice2018` (
`make` varchar(70) DEFAULT NULL,
`model` varchar(255) DEFAULT NULL,
`groupID` int(11) unsigned DEFAULT NULL,
`workID` int(11) unsigned DEFAULT NULL,
`price` varchar(15) DEFAULT NULL,
`hours` varchar(15) DEFAULT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`),
KEY `make` (`make`),
KEY `make_2` (`make`,`model`),
KEY `groupID` (`groupID`,`workID`)
) ENGINE=MyISAM AUTO_INCREMENT=1496548 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `carservice2018_groups`;
CREATE TABLE `carservice2018_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`groupname` varchar(255) DEFAULT NULL,
KEY `id` (`id`) USING BTREE,
KEY `groupname` (`groupname`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `carservice2018_remont`;
CREATE TABLE `carservice2018_remont` (
`make` varchar(70) DEFAULT NULL,
`model` varchar(255) DEFAULT NULL,
`uzelID` int(11) unsigned DEFAULT NULL,
`workID` int(11) unsigned DEFAULT NULL,
`price` varchar(15) DEFAULT NULL,
`hours` varchar(15) DEFAULT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`),
KEY `make` (`make`),
KEY `make_2` (`make`,`model`),
KEY `make_3` (`make`,`model`,`uzelID`,`workID`)
) ENGINE=MyISAM AUTO_INCREMENT=100707 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `carservice2018_uzel`;
CREATE TABLE `carservice2018_uzel` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uzelname` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `uzelname` (`uzelname`)
) ENGINE=MyISAM AUTO_INCREMENT=165 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `carservice2018_works`;
CREATE TABLE `carservice2018_works` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`workname` varchar(255) DEFAULT NULL,
UNIQUE KEY `workname_2` (`workname`),
KEY `id` (`id`),
KEY `workname` (`workname`)
) ENGINE=MyISAM AUTO_INCREMENT=8254 DEFAULT CHARSET=utf8;