· 4 years ago · Feb 06, 2021, 10:04 AM
1/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2/*!40101 SET NAMES utf8 */;
3/*!50503 SET NAMES utf8mb4 */;
4/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
5/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
6
7CREATE TABLE IF NOT EXISTS `article_cross` (
8 `manufacturerId` int(10) unsigned NOT NULL,
9 `OENbr` varchar(64) NOT NULL,
10 `SupplierId` smallint(4) unsigned NOT NULL,
11 `PartsDataSupplierArticleNumber` varchar(32) NOT NULL,
12 KEY `manufacturerId` (`manufacturerId`),
13 KEY `OENbr` (`OENbr`),
14 KEY `SupplierId` (`SupplierId`,`PartsDataSupplierArticleNumber`)
15) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
16
17/*!40000 ALTER TABLE `article_cross` DISABLE KEYS */;
18INSERT INTO `article_cross` (`manufacturerId`, `OENbr`, `SupplierId`, `PartsDataSupplierArticleNumber`) VALUES
19 (1, '0005783', 435, 'L01230'),
20 (1, '0066473', 435, 'FL0207'),
21 (1, '10012488', 80, '852869N'),
22 (1, '10012488', 299, '82D0156216CA'),
23 (1, '10012488', 299, '82D0156216MA'),
24 (1, '10012488', 313, '920.20261'),
25 (1, '10012488', 4725, '20A8234'),
26 (1, '10012488', 4819, '241580'),
27 (1, '10116767', 20, 'ACP459'),
28 (1, '10116767', 123, '899917'),
29 (1, '10116767', 205, '32706'),
30 (1, '10116767', 205, '32706G'),
31 (1, '10116767', 226, '51-0360'),
32 (1, '10116767', 299, '82D0156322CA'),
33 (1, '10116767', 460, '700510360'),
34 (1, '10116767', 4534, 'CC1122'),
35 (1, '10116767', 4595, '87-55002-SX'),
36 (1, '10116767', 4725, '20A8139'),
37 (1, '10116769', 2, '8FK 351 128-131'),
38 (1, '10116769', 80, '852869N'),
39 (1, '10116769', 105, '8FK 351 128-131'),
40 (1, '10116769', 205, '32807G'),