ehbj8cbe

1DROP TABLE IF EXISTS `product`;
2CREATE TABLE `product` (
3  `id` int(10) NOT NULL AUTO_INCREMENT,
4  `name` varchar(100) COLLATE utf8_czech_ci NOT NULL,
5  `nameext` varchar(120) COLLATE utf8_czech_ci NOT NULL,
6  `description` mediumtext COLLATE utf8_czech_ci NOT NULL,
7  `price` decimal(10,2) NOT NULL,
8  `price_vat` int(11) NOT NULL,
9  `active` tinyint(1) NOT NULL,
10  `manufactured_id` int(2) DEFAULT NULL,
11  `category_id` smallint(2) DEFAULT NULL,
12  `parameters_template` smallint(2) DEFAULT NULL,
13  `category_id_2` smallint(2) DEFAULT NULL,
14  `v_akci` enum('a','n') COLLATE utf8_czech_ci DEFAULT 'n',
15  `novinka` enum('a','n') COLLATE utf8_czech_ci NOT NULL DEFAULT 'n',
16  `na_uvod` enum('a','n') COLLATE utf8_czech_ci NOT NULL,
17  `bazar` enum('a','n') COLLATE utf8_czech_ci NOT NULL,
18  `annotation_auto` enum('a','n') COLLATE utf8_czech_ci NOT NULL,
19  `annotation` varchar(250) COLLATE utf8_czech_ci NOT NULL,
20  `tinymce` text COLLATE utf8_czech_ci NOT NULL,
21  `purchase_price` decimal(10,2) NOT NULL,
22  `margin` int(10) NOT NULL,
23  `discount` decimal(10,0) NOT NULL,
24  `discount_price` decimal(10,2) NOT NULL,
25  `discount_after` decimal(10,2) NOT NULL,
26  `discount_from` decimal(10,2) NOT NULL,
27  `discount_to` decimal(10,2) NOT NULL,
28  `availability_id` smallint(2) DEFAULT NULL,
29  `stock` smallint(2) NOT NULL,
30  `productno` varchar(20) COLLATE utf8_czech_ci NOT NULL,
31  `catalog_number` varchar(50) COLLATE utf8_czech_ci NOT NULL,
32  `guarantee_id` smallint(2) NOT NULL,
33  `title_seo_cs` text COLLATE utf8_czech_ci NOT NULL,
34  `meta_description_cs` varchar(250) COLLATE utf8_czech_ci NOT NULL,
35  `url_cs` varchar(20) COLLATE utf8_czech_ci NOT NULL,
36  `shows` enum('a','n') COLLATE utf8_czech_ci NOT NULL DEFAULT 'a',
37  `to_basket` enum('a','n') COLLATE utf8_czech_ci NOT NULL DEFAULT 'a',
38  `show_title` enum('true','false') COLLATE utf8_czech_ci NOT NULL,
39  `delivery_free` enum('a','n') COLLATE utf8_czech_ci NOT NULL DEFAULT 'n',
40  `erotic` enum('a','n') COLLATE utf8_czech_ci NOT NULL DEFAULT 'n',
41  `facebook` enum('a','n') COLLATE utf8_czech_ci NOT NULL DEFAULT 'n',
42  `galery` varchar(250) COLLATE utf8_czech_ci NOT NULL,
43  `slozeni` text COLLATE utf8_czech_ci NOT NULL,
44  `davkovani` text COLLATE utf8_czech_ci NOT NULL,
45  `poznamka` text COLLATE utf8_czech_ci NOT NULL,
46  PRIMARY KEY (`id`)
47) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
48
49DROP TABLE IF EXISTS `productVariant`;
50CREATE TABLE `productVariant` (
51  `id` smallint(10) NOT NULL AUTO_INCREMENT,
52  `id_Product` int(10) NOT NULL,
53  `group_1` smallint(10) DEFAULT NULL,
54  `group_2` smallint(10) DEFAULT NULL,
55  `variant1` varchar(200) DEFAULT NULL,
56  `variant2` varchar(200) NOT NULL,
57  `nameext` varchar(200) DEFAULT NULL,
58  `availability_id` smallint(2) NOT NULL,
59  `productno` varchar(50) DEFAULT NULL,
60  `catalog_number` varchar(50) DEFAULT NULL,
61  `ean` varchar(20) NOT NULL,
62  `equal` varchar(20) DEFAULT NULL,
63  `purchase_price` decimal(10,0) DEFAULT NULL,
64  `margin` int(10) DEFAULT NULL,
65  `price` decimal(10,2) NOT NULL,
66  `price_vat` int(2) DEFAULT NULL,
67  `standard_price` decimal(10,0) DEFAULT NULL,
68  `weight` int(5) DEFAULT NULL,
69  `length` int(5) DEFAULT NULL,
70  PRIMARY KEY (`id`),
71  KEY `id_Product` (`id_Product`)
72) ENGINE=InnoDB DEFAULT CHARSET=utf8;