CREATE TABLE `sv` (
  `article` varchar(40) NOT NULL DEFAULT '',
  `name_sv` varchar(40) NOT NULL DEFAULT '',
  `description` varchar(40) NOT NULL DEFAULT '',
  `code` varchar(40) NOT NULL DEFAULT '',
  KEY `by_article` (`article`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE ` for_find` (
  `article` varchar(40) NOT NULL DEFAULT '',
  `model` varchar(40) NOT NULL DEFAULT '',
  `proizv` varchar(40) NOT NULL DEFAULT '',
  `dop_info` varchar(40) NOT NULL DEFAULT '',
  KEY `by_article` (`article`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

BEGIN
   if NEW.code='add1' then
      replace for_find (articul,model)VALUES(NEW.item_id,NEW.description);
   end if;
   if NEW.code='add2' then
      replace for_find (articul,proizv)VALUES(NEW.item_id,NEW.description);
   end if;   
   if NEW.code='add3' then
      replace for_find (articul,dop_info)VALUES(NEW.item_id,NEW.description);
   end if;
END