<?xml version="1.0" encoding="UTF-8"?>
<prices>
	<tovar idimp="15e9b8c48d">
		<name>Пиво Жигулевское</name>
		<kategor idimp="bgr07ed95">Алкогольные напитки</kategor>
		<edizm idimp="f93e1128c83a">Ящик</edizm>
		<col>5</col>
		<price>240.5</price>
	</tovar>
	<tovar idimp="65lc8we24s">
		<name>Груши</name>
		<kategor idimp="fd512dfser3">Фрукты</kategor>
		<edizm idimp="f93e1128c83a">ящик</edizm>
		<col>3</col>
		<price>1055.47</price>
	</tovar>
	<tovar idimp="dys51te3z89v">
		<name>Ананас</name>
		<kategor idimp="fd512dfser3">Фрукты</kategor>
		<edizm idimp="dskut7fd2d">шт.</edizm>
		<col>5</col>
		<price>195.7</price>
	</tovar>
	<tovar idimp="k8eg5r6t5">
		<name>Топор</name>
		<kategor>Инструменты</kategor>
		<edizm idimp="dskut7fd2d">шт.</edizm>
		<col>10</col>
		<price>159.99</price>
	</tovar>
	<tovar idimp="lekrw6kdr">
		<name>Яблоки красные</name>
		<kategor idimp="fd512dfser3">Фрукты</kategor>
		<edizm idimp="zve5sr0ht6">кг</edizm>
		<col>50</col>
		<price>55.2</price>
	</tovar>
</prices>

CREATE DATABASE `test`;

USE `test`;

CREATE TABLE `kategor` ( `id` INT NOT NULL AUTO_INCREMENT , `kname` VARCHAR(70) NOT NULL , `descr` VARCHAR(155) NULL , `id_kimport` VARCHAR(15) NULL , PRIMARY KEY (`id`), INDEX `kname` (`kname`)) ENGINE = InnoDB;

CREATE TABLE `ediz` ( `id` INT NOT NULL AUTO_INCREMENT , `iname` VARCHAR(10) NOT NULL , `id_iimport` VARCHAR(15) NULL , PRIMARY KEY (`id`), INDEX `iname` (`iname`)) ENGINE = InnoDB;

CREATE TABLE `catalog` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT , `id_kategor` INT NOT NULL , `cname` VARCHAR(150) NOT NULL , `kol` INT NOT NULL DEFAULT '0' , `id_ediz` INT NOT NULL , `price` DECIMAL(15.2) NOT NULL,
`id_cimport` VARCHAR(15) NULL, DEFAULT '0' , PRIMARY KEY (`id`), INDEX `indName` (`cname`)) ENGINE = InnoDB;

INSERT INTO `test`.`ediz` (`id`, `iname`, `id_iimport`) VALUES (NULL, 'шт.', 'dskut7fd2d');
INSERT INTO `kategor` (`id`, `kname`, `descr`, `id_kimport`) VALUES (NULL, 'Фрукты', NULL, 'fd512dfser3');
INSERT INTO `test`.`catalog` (`id`, `id_kategor`, `cname`, `kol`, `id_ediz`, `price`, `id_cimport`) VALUES (NULL, '1', 'Ананас', '10', '1', '180', 'dys51te3z89v');