-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.7.14 - MySQL Community Server (GPL)
-- Server OS:                    Win64
-- HeidiSQL Verzió:              9.5.0.5196
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Dumping structure for tábla kecske_wcms.products
CREATE TABLE IF NOT EXISTS `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` int(11) NOT NULL,
  `deleted_by` int(11) NOT NULL,
  `deleted_at` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='termékek';

-- Dumping data for table kecske_wcms.products: 0 rows
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
/*!40000 ALTER TABLE `products` ENABLE KEYS */;

-- Dumping structure for tábla kecske_wcms.product_categories
CREATE TABLE IF NOT EXISTS `product_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_category_id` int(11) NOT NULL,
  `name` tinytext NOT NULL,
  `category_type` set('small','big') NOT NULL COMMENT 'kis vagy nagygép',
  `created_by` int(11) NOT NULL,
  `created_at` int(11) NOT NULL,
  `deleted_by` int(11) NOT NULL,
  `deleted_at` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_category_id` (`parent_category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='termék kategóriák';

-- Dumping data for table kecske_wcms.product_categories: 0 rows
/*!40000 ALTER TABLE `product_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_categories` ENABLE KEYS */;

-- Dumping structure for tábla kecske_wcms.product_category_properties
CREATE TABLE IF NOT EXISTS `product_category_properties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `property_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` int(11) NOT NULL,
  `deleted_by` int(11) NOT NULL,
  `deleted_at` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='kategóriához tartozó tulajdonság';

-- Dumping data for table kecske_wcms.product_category_properties: 0 rows
/*!40000 ALTER TABLE `product_category_properties` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_category_properties` ENABLE KEYS */;

-- Dumping structure for tábla kecske_wcms.product_variants
CREATE TABLE IF NOT EXISTS `product_variants` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` int(11) NOT NULL,
  `purchase_price` int(11) NOT NULL,
  `selling_price` int(11) NOT NULL,
  `images` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='termékhez tartozó variánsok';

-- Dumping data for table kecske_wcms.product_variants: 0 rows
/*!40000 ALTER TABLE `product_variants` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_variants` ENABLE KEYS */;

-- Dumping structure for tábla kecske_wcms.product_variant_property_values
CREATE TABLE IF NOT EXISTS `product_variant_property_values` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `variant_id` int(11) NOT NULL,
  `property_id` int(11) NOT NULL,
  `property_value` varchar(50) NOT NULL COMMENT 'tulajdonság értéke',
  `created_by` int(11) NOT NULL,
  `created_at` int(11) NOT NULL,
  `deleted_by` int(11) NOT NULL,
  `deleted_at` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='variánsra vonatkozott tulajdonságok értékei';

-- Dumping data for table kecske_wcms.product_variant_property_values: 0 rows
/*!40000 ALTER TABLE `product_variant_property_values` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_variant_property_values` ENABLE KEYS */;

-- Dumping structure for tábla kecske_wcms.properties
CREATE TABLE IF NOT EXISTS `properties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` tinytext NOT NULL,
  `unit_id` int(11) NOT NULL COMMENT 'mértékegység id',
  `values` varchar(250) NOT NULL COMMENT '{''A'', ''A+''}',
  `created_by` int(11) NOT NULL,
  `created_at` int(11) NOT NULL,
  `deleted_by` int(11) NOT NULL,
  `deleted_at` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='kategória tulajdonságok';

-- Dumping data for table kecske_wcms.properties: 2 rows
/*!40000 ALTER TABLE `properties` DISABLE KEYS */;
INSERT INTO `properties` (`id`, `name`, `unit_id`, `values`, `created_by`, `created_at`, `deleted_by`, `deleted_at`) VALUES
    (1, 'Energiaosztály', 0, '\'A\', \'A+\'', 0, 0, 0, 0),
    (2, 'Fordulatszám', 1, '', 0, 0, 0, 0);
/*!40000 ALTER TABLE `properties` ENABLE KEYS */;

-- Dumping structure for tábla kecske_wcms.property_units
CREATE TABLE IF NOT EXISTS `property_units` (
  `id` int(11) NOT NULL,
  `name` tinytext NOT NULL,
  `unit` tinytext NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` int(11) NOT NULL,
  `deleted_by` int(11) NOT NULL,
  `deleted_at` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='mértékegységek';

-- Dumping data for table kecske_wcms.property_units: 0 rows
/*!40000 ALTER TABLE `property_units` DISABLE KEYS */;
/*!40000 ALTER TABLE `property_units` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;