-- phpMyAdmin SQL Dump
-- version 2.9.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generatie Tijd: 05 Jun 2007 om 16:16
-- Server versie: 5.0.40
-- PHP Versie: 5.2.1-pl3-gentoo
--
-- Database: `test`
--

-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `tag_groups`
--

CREATE TABLE `tag_groups` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `type` enum('BASIC','TECHNIC','IMAGE','CATEGORY') NOT NULL,
  `priority` int(11) NOT NULL,
  `language` char(3) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`,`type`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=224 ;

-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `tag_heads`
--

CREATE TABLE `tag_heads` (
  `id` int(11) NOT NULL auto_increment,
  `tag_group_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `quantity` varchar(10) NOT NULL,
  `description` text NOT NULL,
  `priority` int(11) NOT NULL,
  `language` char(3) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `tag_group_id` (`tag_group_id`,`name`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1294 ;

-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `tag_value_pe_product`
--

CREATE TABLE `tag_value_pe_product` (
  `product_id` int(11) NOT NULL,
  `tag_value_id` bigint(20) NOT NULL,
  PRIMARY KEY  (`product_id`,`tag_value_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `tag_values`
--

CREATE TABLE `tag_values` (
  `id` bigint(20) NOT NULL auto_increment,
  `tag_id` int(11) NOT NULL,
  `value` varchar(255) NOT NULL,
  `language` char(3) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `tag_id` (`tag_id`,`value`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2248 ;

-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `tags`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `test`.`tags` AS select `tv`.`id` AS `id`,`th`.`name` AS `name`,`tv`.`value` AS `value`,`th`.`quantity` AS `quantity`,`th`.`priority` AS `tag_priority`,`tv`.`language` AS `language`,`th`.`tag_group_id` AS `group_id`,`tg`.`name` AS `group_name`,`tg`.`type` AS `group_type`,`tg`.`priority` AS `group_priority` from ((`test`.`tag_values` `tv` join `test`.`tag_heads` `th`) join `test`.`tag_groups` `tg`) where ((`tv`.`tag_id` = `th`.`id`) and (`tv`.`language` = `th`.`language`) and (`th`.`tag_group_id` = `tg`.`id`) and (`th`.`language` = `tg`.`language`));