DROP TABLE IF EXISTS `goods`;
CREATE TABLE IF NOT EXISTS `goods` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_group` int(10) unsigned NOT NULL,
  `vendorCode` varchar(20) NOT NULL,
  `name` varchar(250) NOT NULL,
  `status` varchar(50) NOT NULL,
  `marka` text NOT NULL,
  `model` text NOT NULL,
  `kuzov` varchar(250) NOT NULL,
  `oemNF` text NOT NULL,
  `oemNSH` text NOT NULL,
  `engine` text NOT NULL,
  `year` varchar(50) NOT NULL,
  `brand` varchar(50) NOT NULL,
  `brandNF` varchar(50) NOT NULL,
  `brandNSH` varchar(50) NOT NULL,
  `madein` varchar(50) NOT NULL,
  `g_size` varchar(50) NOT NULL,
  `gType` varchar(50) NOT NULL,
  `lp` varchar(3) NOT NULL,
  `fr` varchar(3) NOT NULL,
  `ud` varchar(3) NOT NULL,
  `color` varchar(50) NOT NULL,
  `memo` text NOT NULL,
  `price` decimal(9,2) NOT NULL DEFAULT '0.00',
  `price_sale` decimal(9,2) NOT NULL DEFAULT '0.00',
  `photo` text NOT NULL,
  `analogKey` varchar(20) NOT NULL,
  `siteShow` enum('Y','N') NOT NULL DEFAULT 'Y',
  `goodsAmount` varchar(10) NOT NULL,
  `goodsUnit` enum('NONE','PCS','SET') NOT NULL DEFAULT 'NONE',
  `goodsInUnit` varchar(10) DEFAULT NULL,
  `rezerv` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

LOAD DATA LOCAL INFILE '/home/rexmist/city-motors.ru/api.city-motors.ru/uploads/PL_CM_2026-03-20.txt'
REPLACE INTO TABLE `goods`
CHARACTER SET 'cp1251'
FIELDS TERMINATED BY '	'
LINES TERMINATED BY '
'
(`id_group`,`vendorCode`,`name`,`status`,`marka`,`model`,`kuzov`,`oemNF`,`oemNSH`,`engine`,`year`,`brand`,`brandNF`,`brandNSH`,`madein`,
`g_size`,`gType`,`lp`,`fr`,`ud`,`color`,`memo`,@Price,@Price_Sale,`photo`,`analogKey`,`siteShow`,`goodsAmount`,`goodsUnit`,`goodsInUnit`)
SET  Price = CONVERT(REPLACE(@Price,',', '.'), DECIMAL(9,2)),
Price_Sale = CONVERT(REPLACE(@Price_Sale,',', '.'), DECIMAL(9,2));