Форум пользователей MySQL

CREATE TABLE IF NOT EXISTS `nomenklatura2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(50) NOT NULL,
  `sklad` varchar(50) NOT NULL,
  `article` varchar(50) NOT NULL,
  `name` varchar(1000) NOT NULL,
  `original` varchar(2000) NOT NULL,
  `manufacturer` varchar(50) NOT NULL,
  `cen_grup` varchar(50) NOT NULL,
  `srok_sklad` tinyint(4) NOT NULL,
  `nal_sklad` smallint(6) NOT NULL,
  `big` tinyint(4) NOT NULL,
  `price` double NOT NULL,
  `val` varchar(3) NOT NULL,
  `ed` varchar(8) NOT NULL DEFAULT 'шт',
  `opisanie` varchar(1000) NOT NULL,
  `img` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`uid`,`sklad`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

LOAD DATA INFILE "/home/localhost/www/vgr/out.txt" REPLACE INTO TABLE nomenklatura2 (uid, sklad, article, name, original, manufacturer, cen_grup, srok_sklad, nal_sklad, big, price, val, ed)