cMw1hZQR

1-- --------------------------------------------------------
2-- Host:                         127.0.0.1
3-- Server version:               5.7.14 - MySQL Community Server (GPL)
4-- Server OS:                    Win64
5-- HeidiSQL Verzió:              9.5.0.5196
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Dumping structure for tábla kecske_wcms.products
15CREATE TABLE IF NOT EXISTS `products` (
16  `id` int(11) NOT NULL AUTO_INCREMENT,
17  `category_id` int(11) NOT NULL,
18  `created_by` int(11) NOT NULL,
19  `created_at` int(11) NOT NULL,
20  `deleted_by` int(11) NOT NULL,
21  `deleted_at` int(11) NOT NULL,
22  PRIMARY KEY (`id`),
23  KEY `category_id` (`category_id`)
24) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='termékek';
25
26-- Dumping data for table kecske_wcms.products: 0 rows
27/*!40000 ALTER TABLE `products` DISABLE KEYS */;
28/*!40000 ALTER TABLE `products` ENABLE KEYS */;
29
30-- Dumping structure for tábla kecske_wcms.product_categories
31CREATE TABLE IF NOT EXISTS `product_categories` (
32  `id` int(11) NOT NULL AUTO_INCREMENT,
33  `parent_category_id` int(11) NOT NULL,
34  `name` tinytext NOT NULL,
35  `category_type` set('small','big') NOT NULL COMMENT 'kis vagy nagygép',
36  `created_by` int(11) NOT NULL,
37  `created_at` int(11) NOT NULL,
38  `deleted_by` int(11) NOT NULL,
39  `deleted_at` int(11) NOT NULL,
40  PRIMARY KEY (`id`),
41  KEY `parent_category_id` (`parent_category_id`)
42) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='termék kategóriák';
43
44-- Dumping data for table kecske_wcms.product_categories: 0 rows
45/*!40000 ALTER TABLE `product_categories` DISABLE KEYS */;
46/*!40000 ALTER TABLE `product_categories` ENABLE KEYS */;
47
48-- Dumping structure for tábla kecske_wcms.product_category_properties
49CREATE TABLE IF NOT EXISTS `product_category_properties` (
50  `id` int(11) NOT NULL AUTO_INCREMENT,
51  `category_id` int(11) NOT NULL,
52  `property_id` int(11) NOT NULL,
53  `created_by` int(11) NOT NULL,
54  `created_at` int(11) NOT NULL,
55  `deleted_by` int(11) NOT NULL,
56  `deleted_at` int(11) NOT NULL,
57  PRIMARY KEY (`id`)
58) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='kategóriához tartozó tulajdonság';
59
60-- Dumping data for table kecske_wcms.product_category_properties: 0 rows
61/*!40000 ALTER TABLE `product_category_properties` DISABLE KEYS */;
62/*!40000 ALTER TABLE `product_category_properties` ENABLE KEYS */;
63
64-- Dumping structure for tábla kecske_wcms.product_variants
65CREATE TABLE IF NOT EXISTS `product_variants` (
66  `id` int(11) NOT NULL AUTO_INCREMENT,
67  `name` int(11) NOT NULL,
68  `purchase_price` int(11) NOT NULL,
69  `selling_price` int(11) NOT NULL,
70  `images` varchar(250) NOT NULL,
71  PRIMARY KEY (`id`)
72) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='termékhez tartozó variánsok';
73
74-- Dumping data for table kecske_wcms.product_variants: 0 rows
75/*!40000 ALTER TABLE `product_variants` DISABLE KEYS */;
76/*!40000 ALTER TABLE `product_variants` ENABLE KEYS */;
77
78-- Dumping structure for tábla kecske_wcms.product_variant_property_values
79CREATE TABLE IF NOT EXISTS `product_variant_property_values` (
80  `id` int(11) NOT NULL AUTO_INCREMENT,
81  `variant_id` int(11) NOT NULL,
82  `property_id` int(11) NOT NULL,
83  `property_value` varchar(50) NOT NULL COMMENT 'tulajdonság értéke',
84  `created_by` int(11) NOT NULL,
85  `created_at` int(11) NOT NULL,
86  `deleted_by` int(11) NOT NULL,
87  `deleted_at` int(11) NOT NULL,
88  PRIMARY KEY (`id`)
89) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='variánsra vonatkozott tulajdonságok értékei';
90
91-- Dumping data for table kecske_wcms.product_variant_property_values: 0 rows
92/*!40000 ALTER TABLE `product_variant_property_values` DISABLE KEYS */;
93/*!40000 ALTER TABLE `product_variant_property_values` ENABLE KEYS */;
94
95-- Dumping structure for tábla kecske_wcms.properties
96CREATE TABLE IF NOT EXISTS `properties` (
97  `id` int(11) NOT NULL AUTO_INCREMENT,
98  `name` tinytext NOT NULL,
99  `unit_id` int(11) NOT NULL COMMENT 'mértékegység id',
100  `values` varchar(250) NOT NULL COMMENT '{''A'', ''A+''}',
101  `created_by` int(11) NOT NULL,
102  `created_at` int(11) NOT NULL,
103  `deleted_by` int(11) NOT NULL,
104  `deleted_at` int(11) NOT NULL,
105  PRIMARY KEY (`id`)
106) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='kategória tulajdonságok';
107
108-- Dumping data for table kecske_wcms.properties: 2 rows
109/*!40000 ALTER TABLE `properties` DISABLE KEYS */;
110INSERT INTO `properties` (`id`, `name`, `unit_id`, `values`, `created_by`, `created_at`, `deleted_by`, `deleted_at`) VALUES
111	(1, 'Energiaosztály', 0, '\'A\', \'A+\'', 0, 0, 0, 0),
112	(2, 'Fordulatszám', 1, '', 0, 0, 0, 0);
113/*!40000 ALTER TABLE `properties` ENABLE KEYS */;
114
115-- Dumping structure for tábla kecske_wcms.property_units
116CREATE TABLE IF NOT EXISTS `property_units` (
117  `id` int(11) NOT NULL,
118  `name` tinytext NOT NULL,
119  `unit` tinytext NOT NULL,
120  `created_by` int(11) NOT NULL,
121  `created_at` int(11) NOT NULL,
122  `deleted_by` int(11) NOT NULL,
123  `deleted_at` int(11) NOT NULL
124) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='mértékegységek';
125
126-- Dumping data for table kecske_wcms.property_units: 0 rows
127/*!40000 ALTER TABLE `property_units` DISABLE KEYS */;
128/*!40000 ALTER TABLE `property_units` ENABLE KEYS */;
129
130/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
131/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
132/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;