návrh schémy

-- Adminer 3.6.2 MySQL dump

SET NAMES utf8;
SET foreign_key_checks = 0;
SET time_zone = 'SYSTEM';
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT '#',
  `priority` int(255) NOT NULL DEFAULT '1024',
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `label` varchar(255) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `label` (`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


DROP TABLE IF EXISTS `category_item`;
CREATE TABLE `category_item` (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT '#',
  `category_id` int(255) NOT NULL,
  `priority` int(255) NOT NULL DEFAULT '1024',
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `label` varchar(255) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `category_id_label` (`category_id`,`label`),
  CONSTRAINT `category_item_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


DROP TABLE IF EXISTS `category_item_duration`;
CREATE TABLE `category_item_duration` (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT '#',
  `category_item_id` int(255) NOT NULL,
  `priority` int(255) NOT NULL DEFAULT '1024',
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `label` varchar(255) COLLATE utf8_bin NOT NULL,
  `price` double NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `category_item_id_label` (`category_item_id`,`label`),
  CONSTRAINT `category_item_duration_ibfk_1` FOREIGN KEY (`category_item_id`) REFERENCES `category_item` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


-- 2012-12-31 01:55:42