[elvystrac] r1807 - new DB dump

• From: elvys@xxxxxxxxxxxxxxxxxxxxxx
• To: elvystrac@xxxxxxxxxxxxx
• Date: Sun, 21 Feb 2010 12:10:10 +0100

Author: DavidK
Date: 2010-02-21 12:10:10 +0100 (Sun, 21 Feb 2010)
New Revision: 1807

Added:
   others/dbs/script/_dump/27v_migr22dev_webservernew.sql
Log:
new DB dump

Added: others/dbs/script/_dump/27v_migr22dev_webservernew.sql
===================================================================
--- others/dbs/script/_dump/27v_migr22dev_webservernew.sql                      
        (rev 0)
+++ others/dbs/script/_dump/27v_migr22dev_webservernew.sql      2010-02-21 
11:10:10 UTC (rev 1807)
@@ -0,0 +1,2578 @@
+-- phpMyAdmin SQL Dump
+-- version 3.2.3
+-- http://www.phpmyadmin.net
+--
+-- Počítač: localhost
+-- Vygenerováno: Neděle 21. února 2010, 12:08
+-- Verze MySQL: 5.1.40
+-- Verze PHP: 5.3.0
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+
+--
+-- Databáze: `webservernew`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `aspect_ratio`
+--
+
+CREATE TABLE IF NOT EXISTS `aspect_ratio` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `x_base` int(11) NOT NULL,
+  `y_base` int(11) NOT NULL,
+  `ratio` double NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
+
+--
+-- Vypisuji data pro tabulku `aspect_ratio`
+--
+
+INSERT INTO `aspect_ratio` (`id`, `x_base`, `y_base`, `ratio`) VALUES
+(1, 16, 9, 1.77778),
+(2, 4, 3, 1.33333),
+(3, 8, 5, 1.6),
+(4, 5, 4, 1.25);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `category`
+--
+
+CREATE TABLE IF NOT EXISTS `category` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `definition` int(11) NOT NULL,
+  `elvys_group` int(11) NOT NULL,
+  `planning` int(11) NOT NULL,
+  `cat_order` int(11) NOT NULL,
+  `disabled` tinyint(1) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `FK_Reference_35` (`elvys_group`),
+  KEY `FK_Reference_36` (`planning`),
+  KEY `FK_Reference_39` (`definition`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 ;
+
+--
+-- Vypisuji data pro tabulku `category`
+--
+
+INSERT INTO `category` (`id`, `definition`, `elvys_group`, `planning`, 
`cat_order`, `disabled`) VALUES
+(1, 3, 2, 1, 2, 0),
+(2, 2, 2, 2, 1, 0);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `category_definition`
+--
+
+CREATE TABLE IF NOT EXISTS `category_definition` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `layout` int(11) NOT NULL,
+  `name` varchar(100) COLLATE utf8_czech_ci NOT NULL,
+  `created` datetime NOT NULL,
+  `modified` datetime NOT NULL,
+  `disabled` tinyint(1) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `FK_Reference_40` (`layout`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=64 ;
+
+--
+-- Vypisuji data pro tabulku `category_definition`
+--
+
+INSERT INTO `category_definition` (`id`, `layout`, `name`, `created`, 
`modified`, `disabled`) VALUES
+(1, 1, 'kategorie pro layout 1', '2010-02-12 20:27:08', '2010-02-12 20:27:08', 
0),
+(2, 2, 'kategorie pro layout 2', '2010-02-12 20:27:08', '2010-02-12 20:27:08', 
0),
+(3, 3, 'kategorie pro layout 3', '2010-02-12 20:27:08', '2010-02-12 20:27:08', 
0),
+(4, 4, 'kategorie pro layout 4', '2010-02-12 20:27:08', '2010-02-12 20:27:08', 
1),
+(5, 5, 'kategorie pro layout 5', '2010-02-12 20:27:08', '2010-02-12 20:27:08', 
1),
+(6, 6, 'kategorie pro layout 6', '2010-02-12 20:27:08', '2010-02-12 20:27:08', 
1),
+(7, 7, 'kategorie pro layout 7', '2010-02-12 20:27:08', '2010-02-12 20:27:08', 
1),
+(8, 8, 'kategorie pro layout 8', '2010-02-12 20:27:08', '2010-02-12 20:27:08', 
1),
+(9, 9, 'kategorie pro layout 9', '2010-02-12 20:27:08', '2010-02-12 20:27:08', 
1),
+(10, 10, 'kategorie pro layout 10', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(11, 11, 'kategorie pro layout 11', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(12, 12, 'kategorie pro layout 12', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(13, 13, 'kategorie pro layout 13', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(14, 14, 'kategorie pro layout 14', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(15, 15, 'kategorie pro layout 15', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(16, 16, 'kategorie pro layout 16', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(17, 17, 'kategorie pro layout 17', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(18, 18, 'kategorie pro layout 18', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(19, 19, 'kategorie pro layout 19', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(20, 20, 'kategorie pro layout 20', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(21, 21, 'kategorie pro layout 21', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(22, 22, 'kategorie pro layout 22', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(23, 23, 'kategorie pro layout 23', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(24, 24, 'kategorie pro layout 24', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(25, 25, 'kategorie pro layout 25', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(26, 26, 'kategorie pro layout 26', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(27, 27, 'kategorie pro layout 27', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(28, 28, 'kategorie pro layout 28', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(29, 29, 'kategorie pro layout 29', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(30, 30, 'kategorie pro layout 30', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(31, 31, 'kategorie pro layout 31', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 1),
+(32, 32, 'kategorie pro layout 32', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 0),
+(33, 33, 'kategorie pro layout 33', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 0),
+(34, 34, 'kategorie pro layout 34', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 0),
+(35, 35, 'kategorie pro layout 35', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 0),
+(36, 36, 'kategorie pro layout 36', '2010-02-12 20:27:08', '2010-02-12 
20:27:08', 0);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `category_planning`
+--
+
+CREATE TABLE IF NOT EXISTS `category_planning` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `definition` int(11) NOT NULL,
+  `disabled` tinyint(1) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `FK_Reference_43` (`definition`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 ;
+
+--
+-- Vypisuji data pro tabulku `category_planning`
+--
+
+INSERT INTO `category_planning` (`id`, `definition`, `disabled`) VALUES
+(1, 3, 0),
+(2, 2, 0);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `company`
+--
+
+CREATE TABLE IF NOT EXISTS `company` (
+  `id` int(11) NOT NULL,
+  `name` varchar(100) NOT NULL,
+  `email` varchar(100) NOT NULL,
+  `human` varchar(100) NOT NULL,
+  `tel` varchar(20) NOT NULL,
+  `system` tinyint(1) NOT NULL,
+  `disabled` tinyint(1) NOT NULL,
+  `setting` int(11) NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `AK_Key_2` (`name`),
+  KEY `FK_Reference_21` (`setting`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Vypisuji data pro tabulku `company`
+--
+
+INSERT INTO `company` (`id`, `name`, `email`, `human`, `tel`, `system`, 
`disabled`, `setting`) VALUES
+(1, 'system', '-', '-', '-', 1, 0, 1),
+(2, 'Sun', 'sun@xxxxxxx', 'Pepa Vomacka', '771771771', 0, 0, 2),
+(4, 'Statutární město Přerov', 'posta@xxxxxxxxxxxx', 'kontakt_Přerov', '+420 
581 268 111', 0, 0, 4),
+(5, 'Magistrát města Olomouce', 'infocentrum@xxxxxxxxxx', 'kontakt_Olomouc', 
'585 513 111', 0, 0, 5);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `comp_permitted_type`
+--
+
+CREATE TABLE IF NOT EXISTS `comp_permitted_type` (
+  `company` int(11) NOT NULL,
+  `content` int(11) NOT NULL,
+  PRIMARY KEY (`company`,`content`),
+  KEY `FK_Reference_19` (`content`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Vypisuji data pro tabulku `comp_permitted_type`
+--
+
+INSERT INTO `comp_permitted_type` (`company`, `content`) VALUES
+(2, 1),
+(4, 1),
+(5, 1),
+(2, 2),
+(4, 2),
+(5, 2),
+(2, 3),
+(4, 3),
+(5, 3),
+(2, 4),
+(4, 4),
+(5, 4),
+(4, 5),
+(4, 6);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `comp_setting`
+--
+
+CREATE TABLE IF NOT EXISTS `comp_setting` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
+
+--
+-- Vypisuji data pro tabulku `comp_setting`
+--
+
+INSERT INTO `comp_setting` (`id`) VALUES
+(1),
+(2),
+(3),
+(4),
+(5);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `content_type`
+--
+
+CREATE TABLE IF NOT EXISTS `content_type` (
+  `id` int(11) NOT NULL,
+  `type` varchar(50) NOT NULL,
+  `plug` int(11) NOT NULL,
+  `file_type` int(11) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `FK_Reference_20` (`plug`),
+  KEY `FK_Reference_41` (`file_type`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Vypisuji data pro tabulku `content_type`
+--
+
+INSERT INTO `content_type` (`id`, `type`, `plug`, `file_type`) VALUES
+(1, 'document', 1, 1),
+(2, 'url', 2, NULL),
+(3, 'text', 3, NULL),
+(4, 'dynamic', 4, NULL),
+(5, 'video', 5, 2),
+(6, 'presentation', 6, 1);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `db_info`
+--
+
+CREATE TABLE IF NOT EXISTS `db_info` (
+  `version` int(11) NOT NULL,
+  `info` varchar(255) NOT NULL,
+  `release_date` datetime NOT NULL,
+  `update_date` datetime NOT NULL,
+  PRIMARY KEY (`version`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Vypisuji data pro tabulku `db_info`
+--
+
+INSERT INTO `db_info` (`version`, `info`, `release_date`, `update_date`) VALUES
+(27, '27- PDF presentations', '2010-02-18 00:00:00', '2010-02-18 21:17:56');
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `document`
+--
+
+CREATE TABLE IF NOT EXISTS `document` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `page_count` int(11) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=91 ;
+
+--
+-- Vypisuji data pro tabulku `document`
+--
+
+INSERT INTO `document` (`id`, `page_count`) VALUES
+(3, 15),
+(4, 2),
+(5, 4),
+(6, 13),
+(7, 13),
+(8, 13),
+(9, 1),
+(10, 1),
+(11, 6),
+(12, 1),
+(13, 1),
+(14, 1),
+(15, 1),
+(16, 1),
+(17, 1),
+(18, 8),
+(19, 510),
+(22, 4),
+(23, 5),
+(24, 5),
+(25, 1),
+(26, 1),
+(27, 5),
+(28, 1),
+(29, 1),
+(30, 1),
+(31, 1),
+(32, 1),
+(33, 1),
+(34, 6),
+(35, 2),
+(36, 2),
+(37, 9),
+(38, 6),
+(39, 2),
+(40, 510),
+(41, 1),
+(42, 6),
+(43, 9),
+(44, 9),
+(45, 6),
+(46, 9),
+(47, 9),
+(48, 6),
+(49, 6),
+(50, 9),
+(51, 67),
+(52, 9),
+(53, 6),
+(54, 2),
+(55, 6),
+(56, 9),
+(57, 6),
+(58, 2),
+(59, 2),
+(60, 6),
+(61, 67),
+(62, 2),
+(63, 6),
+(64, 9),
+(65, 9),
+(66, 9),
+(67, 2),
+(68, 2),
+(69, 2),
+(70, 9),
+(71, 9),
+(72, 2),
+(73, 6),
+(74, 384),
+(75, 2),
+(76, 67),
+(77, 384),
+(78, 6),
+(79, 2),
+(80, 6),
+(81, 6),
+(82, 6),
+(83, 9),
+(84, 2),
+(85, 6),
+(86, 2),
+(87, 1),
+(88, 1),
+(89, 3),
+(90, 1);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `document_content`
+--
+
+CREATE TABLE IF NOT EXISTS `document_content` (
+  `id` int(11) NOT NULL,
+  `page_list` varchar(255) NOT NULL,
+  `num_preview_page` varchar(255) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Vypisuji data pro tabulku `document_content`
+--
+
+INSERT INTO `document_content` (`id`, `page_list`, `num_preview_page`) VALUES
+(6, '1-5', '1'),
+(7, '1-5', '1'),
+(10, '1-1', '1'),
+(11, '1-4', '1'),
+(12, '1-1', '1'),
+(13, '1-1', '1'),
+(14, '1-5', '1'),
+(15, '1-5', '1'),
+(17, '1-1', '1'),
+(20, '1-1', '1'),
+(30, '1-1', '1'),
+(31, '1-1', '1'),
+(32, '1-1', '1'),
+(33, '1-1', '1'),
+(34, '1-5', '1'),
+(35, '1-5', '1'),
+(37, '1-1', '1'),
+(38, '1-1', '1'),
+(43, '1-1', '1'),
+(44, '1-4', '1'),
+(47, '1-1', '1'),
+(48, '1-1', '1'),
+(49, '1-1', '1'),
+(50, '1-1', '1'),
+(51, '1-1', '1'),
+(52, '1-1', '1'),
+(53, '1-3', '1'),
+(54, '1-1', '1'),
+(57, '1-6', '1'),
+(58, '1-2', '1'),
+(59, '1-2', '2'),
+(60, '1-1', '1'),
+(61, '1-1', '1');
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `dynamic_content`
+--
+
+CREATE TABLE IF NOT EXISTS `dynamic_content` (
+  `id` int(11) NOT NULL,
+  `t_order` varchar(50) DEFAULT NULL,
+  `bg_color` varchar(50) DEFAULT NULL,
+  `color` varchar(50) DEFAULT NULL,
+  `font` varchar(255) DEFAULT NULL,
+  `size` int(11) DEFAULT NULL,
+  `text` varchar(5000) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Vypisuji data pro tabulku `dynamic_content`
+--
+
+INSERT INTO `dynamic_content` (`id`, `t_order`, `bg_color`, `color`, `font`, 
`size`, `text`) VALUES
+(5, 'RightLeft', 'yellow', 'black', 'Arial', 80, 'úřední deska Magistrátu 
města Přerova'),
+(29, 'RightLeft', 'yellow', 'black', 'Arial', 80, 'zkušební provoz 
elektronické vývěsky jednotlivé dokumenty lze zvětšovat a dále v nich 
listovat'),
+(42, 'RightLeft', 'yellow', 'black', 'Arial', 80, 'REKLAMNÍ PLOCHA URČENÁ PRO 
VAŠI FIRMU tel: 608713605'),
+(65, 'RightLeft', 'yellow', 'black', 'Arial', 80, 
'fdsjalkfjdsalkjfljsalfjsajlkfjsaljfjdsaljlk sjflksaj lkfjdsak jfdslk jflkjs 
lfds\n\nfdsjalkfjdsalkjfljsalfjsajlkfjsaljfjdsaljlk sjflksaj lkfjdsak jfdslk 
jflkjs lfdsfdsjalkfjdsalkjfljsalfjsajlkfjsaljfjdsaljlk sjflksaj lkfjdsak jfdslk 
jflkjs lfdsfdsjalkfjdsalkjfljsalfjsajlkfjsaljfjdsaljlk sjflksaj lkfjdsak jfdslk 
jflkjs lfdsfdsjalkfjdsalkjfljsalfjsajlkfjsaljfjdsaljlk sjflksaj lkfjdsak jfdslk 
jflkjs lfdsfdsjalkfjdsalkjfljsalfjsajlkfjsaljfjdsaljlk sjflksaj lkfjdsak jfdslk 
jflkjs lfdsfdsjalkfjdsalkjfljsalfjsajlkfjsaljfjdsaljlk sjflksaj lkfjdsak jfdslk 
jflkjs lfdsfdsjalkfjdsalkjfljsalfjsajlkfjsaljfjdsaljlk sjflksaj lkfjdsak jfdslk 
jflkjs lfdsfdsjalkfjdsalkjfljsalfjsajlkfjsaljfjdsaljlk sjflksaj lkfjdsak jfdslk 
jflkjs lfdsfdsjalkfjdsalkjfljsalfjsajlkfjsaljfjdsaljlk sjflksaj lkfjdsak jfdslk 
jflkjs lfdsfdsjalkfjdsalkjfljsalfjsajlkfjsaljfjdsaljlk sjflksaj lkfjdsak jfdslk 
jflkjs lfdsfdsjalkfjdsalkjfljsalfjsajlkfjsaljfjdsaljlk sjflksaj l
 kfjdsak jfdslk jflkjs lfds');
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `elvys`
+--
+
+CREATE TABLE IF NOT EXISTS `elvys` (
+  `id` int(11) NOT NULL,
+  `company` int(11) NOT NULL,
+  `name` varchar(100) NOT NULL,
+  `setting` int(11) NOT NULL,
+  `city` varchar(50) NOT NULL,
+  `address` varchar(100) NOT NULL,
+  `active` tinyint(1) NOT NULL,
+  `img_date` datetime DEFAULT NULL,
+  `disabled` tinyint(1) NOT NULL,
+  `img` varchar(50) DEFAULT NULL,
+  `resolution` int(11) NOT NULL,
+  `elvys_group` int(11) NOT NULL,
+  `psc` varchar(10) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `FK_Reference_23` (`resolution`),
+  KEY `FK_Reference_3` (`company`),
+  KEY `FK_Reference_7` (`setting`),
+  KEY `FK_Reference_33` (`elvys_group`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Vypisuji data pro tabulku `elvys`
+--
+
+INSERT INTO `elvys` (`id`, `company`, `name`, `setting`, `city`, `address`, 
`active`, `img_date`, `disabled`, `img`, `resolution`, `elvys_group`, `psc`) 
VALUES
+(12, 4, 'Kiosek 12', 12, 'Přerov 2', 'Bratrská 34, 750 11 Přerov 2', 1, NULL, 
0, NULL, 2, 1, '110 00'),
+(13, 4, 'Kiosek 13', 13, 'Přerov - Popovice', 'Kovářská 11, 750 11 Přerov', 1, 
'2010-02-21 11:44:06', 0, '13.jpg', 2, 2, '110 00'),
+(14, 4, 'Kiosek 14', 14, 'Přerov - Vinary', 'Za Humny 7, 750 11 Přerov', 0, 
NULL, 0, NULL, 2, 3, '110 00');
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `elvys_group`
+--
+
+CREATE TABLE IF NOT EXISTS `elvys_group` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `name` varchar(100) COLLATE utf8_czech_ci NOT NULL,
+  `disabled` tinyint(1) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ;
+
+--
+-- Vypisuji data pro tabulku `elvys_group`
+--
+
+INSERT INTO `elvys_group` (`id`, `name`, `disabled`) VALUES
+(1, 'hejty', 0),
+(2, 'hejty', 0),
+(3, 'hejty', 0);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `elvys_setting`
+--
+
+CREATE TABLE IF NOT EXISTS `elvys_setting` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `night_mode` decimal(1,0) NOT NULL,
+  `night_start` varchar(5) DEFAULT NULL,
+  `night_end` varchar(5) DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
+
+--
+-- Vypisuji data pro tabulku `elvys_setting`
+--
+
+INSERT INTO `elvys_setting` (`id`, `night_mode`, `night_start`, `night_end`) 
VALUES
+(1, 0, NULL, NULL),
+(2, 0, NULL, NULL),
+(3, 0, NULL, NULL),
+(4, 0, NULL, NULL),
+(5, 0, NULL, NULL),
+(6, 0, NULL, NULL),
+(7, 0, NULL, NULL),
+(8, 0, NULL, NULL),
+(9, 0, NULL, NULL),
+(10, 0, NULL, NULL),
+(11, 0, NULL, NULL),
+(12, 0, NULL, NULL),
+(13, 0, NULL, NULL),
+(14, 0, NULL, NULL),
+(15, 0, NULL, NULL),
+(16, 0, NULL, NULL),
+(17, 0, NULL, NULL);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `file`
+--
+
+CREATE TABLE IF NOT EXISTS `file` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `file_type` int(11) NOT NULL,
+  `orig_name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `uniq_name` varchar(50) COLLATE utf8_czech_ci NOT NULL,
+  `description` varchar(1000) COLLATE utf8_czech_ci NOT NULL,
+  `hashcode` varchar(32) COLLATE utf8_czech_ci NOT NULL,
+  `comp_identifier` int(11) NOT NULL,
+  `user` int(11) NOT NULL,
+  `uploaded` datetime NOT NULL,
+  `disabled` tinyint(1) NOT NULL,
+  `size` int(11) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `FK_Reference_30` (`user`),
+  KEY `FK_Reference_38` (`file_type`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=92 ;
+
+--
+-- Vypisuji data pro tabulku `file`
+--
+
+INSERT INTO `file` (`id`, `file_type`, `orig_name`, `uniq_name`, 
`description`, `hashcode`, `comp_identifier`, `user`, `uploaded`, `disabled`, 
`size`) VALUES
+(3, 1, 'Mike Tyson - Wikipedia.pdf', '3.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, 
'2009-07-14 00:41:14', 0, 0),
+(4, 1, 'Výrobní objekt přerov.pdf', '4.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, 
'2009-07-14 08:01:53', 0, 0),
+(5, 1, 'Složka nabídka Areál SIGMA HOLIDAY.pdf', '5.pdf', '-', 
'_FAKE_HASH_CODE_', 4, 8, '2009-07-14 08:03:33', 0, 0),
+(6, 1, '737_2009.pdf', '6.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, '2009-07-14 
08:04:37', 0, 0),
+(7, 1, '739_2009.pdf', '7.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, '2009-07-14 
08:05:28', 0, 0),
+(8, 1, '741_2009.pdf', '8.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, '2009-07-14 
08:06:33', 0, 0),
+(9, 1, '757_2009.pdf', '9.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, '2009-07-14 
08:07:28', 0, 0),
+(10, 1, '760_2009.pdf', '10.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, '2009-07-14 
08:07:31', 0, 0),
+(11, 1, '767_2009.pdf', '11.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, '2009-07-14 
08:07:58', 0, 0),
+(12, 1, '768_2009.pdf', '12.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, '2009-07-14 
08:08:01', 0, 0),
+(13, 1, '773_2009.pdf', '13.pdf', 'fsa', '_FAKE_HASH_CODE_', 4, 8, '2009-07-14 
08:08:04', 0, 0),
+(14, 1, 'C:\\Users\\David\\Desktop\\399.pdf', '14.pdf', '-', 
'_FAKE_HASH_CODE_', 4, 8, '2009-08-09 16:28:06', 0, 0),
+(15, 1, '399.pdf', '15.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, '2009-08-09 
16:29:46', 1, 0),
+(16, 1, '399.pdf', '16.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, '2009-08-10 
21:36:10', 1, 0),
+(17, 1, '399.pdf', '17.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, '2009-08-10 
21:37:13', 1, 0),
+(18, 1, 'letak-supermarketu-billa-velky-33.pdf', '18.pdf', 'fsd', 
'_FAKE_HASH_CODE_', 4, 8, '2009-08-13 16:30:51', 0, 0),
+(19, 1, 'Pocket.Atlas.pdf', '19.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, 
'2009-08-27 16:11:44', 0, 0),
+(22, 1, 'SOA_infosheet.pdf', '22.pdf', 'ahoj', '_FAKE_HASH_CODE_', 4, 7, 
'2009-09-10 14:55:40', 0, 0),
+(23, 1, 'Olomouc 1 neupravené.pdf', '23.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, 
'2009-09-10 17:53:06', 0, 0),
+(24, 1, 'Olomouc 1.pdf', '24.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, '2009-09-10 
17:53:08', 0, 0),
+(25, 1, 'Olomouc neupravená.pdf', '25.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, 
'2009-09-10 17:53:10', 0, 0),
+(26, 1, 'Olomouc upravené.pdf', '26.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, 
'2009-09-10 17:53:13', 0, 0),
+(27, 1, 'Prokonzulta upravená.pdf', '27.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, 
'2009-09-10 17:53:15', 0, 0),
+(28, 1, '380.pdf', '28.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, '2009-09-10 
17:53:16', 0, 0),
+(29, 1, '399.pdf', '29.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, '2009-09-10 
17:53:18', 0, 0),
+(30, 1, 'Muži A.pdf', '30.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, '2009-10-17 
19:38:50', 0, 0),
+(31, 1, 'Přehled výsledků o víkendu10 a 11.pdf', '31.pdf', '-', 
'_FAKE_HASH_CODE_', 4, 8, '2009-10-17 19:38:52', 0, 0),
+(32, 1, 'Stadioun.pdf', '32.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, '2009-10-17 
19:38:54', 0, 0),
+(33, 1, 'Pronájem bytů.pdf', '33.pdf', '-', '_FAKE_HASH_CODE_', 4, 8, 
'2009-10-17 19:39:03', 0, 0),
+(34, 1, 'BPEL4WS-DesignGoals.pdf', '34.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 00:27:13', 0, 0),
+(35, 1, 'dresden_bibliothek.pdf', '35.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 00:52:21', 0, 0),
+(36, 1, 'dresden_bibliothek.pdf', '36.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 01:02:19', 0, 0),
+(37, 1, 'InfoQ_ The Seven Fallacies.pdf', '37.pdf', '-', '_FAKE_HASH_CODE_', 
4, 7, '2009-10-27 01:11:42', 0, 0),
+(38, 1, 'BPEL4WS-DesignGoals.pdf', '38.pdf', '-', '_FAKE_HASH_CODE_', 2, 3, 
'2009-10-27 01:13:31', 0, 0),
+(39, 1, 'dresden_bibliothek.pdf', '39.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 01:24:42', 0, 0),
+(40, 1, 'Pocket.Atlas.pdf', '40.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 08:52:57', 1, 0),
+(41, 1, 'Letecký snímek.pdf', '41.pdf', 'aaaaaa', '_FAKE_HASH_CODE_', 4, 8, 
'2009-10-27 09:06:33', 0, 0),
+(42, 1, 'BPEL4WS-DesignGoals.pdf', '42.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 21:23:18', 1, 0),
+(43, 1, 'InfoQ_ The Seven Fallacies.pdf', '43.pdf', '-', '_FAKE_HASH_CODE_', 
4, 7, '2009-10-27 21:33:39', 1, 0),
+(44, 1, 'InfoQ_ The Seven Fallacies.pdf', '44.pdf', '-', '_FAKE_HASH_CODE_', 
4, 7, '2009-10-27 21:41:24', 1, 0),
+(45, 1, 'BPEL4WS-DesignGoals.pdf', '45.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 21:51:05', 1, 0),
+(46, 1, 'InfoQ_ The Seven Fallacies.pdf', '46.pdf', '-', '_FAKE_HASH_CODE_', 
4, 7, '2009-10-27 21:52:51', 1, 0),
+(47, 1, 'InfoQ_ The Seven Fallacies.pdf', '47.pdf', '-', '_FAKE_HASH_CODE_', 
4, 7, '2009-10-27 21:54:59', 1, 0),
+(48, 1, 'BPEL4WS-DesignGoals.pdf', '48.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 22:05:47', 1, 0),
+(49, 1, 'BPEL4WS-DesignGoals.pdf', '49.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 22:08:59', 1, 0),
+(50, 1, 'InfoQ_ The Seven Fallacies.pdf', '50.pdf', '-', '_FAKE_HASH_CODE_', 
4, 7, '2009-10-27 22:09:34', 1, 0),
+(51, 1, 'jsf2-complete-tour.pdf', '51.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 22:10:46', 1, 0),
+(52, 1, 'InfoQ_ The Seven Fallacies.pdf', '52.pdf', '-', '_FAKE_HASH_CODE_', 
4, 7, '2009-10-27 22:11:52', 1, 0),
+(53, 1, 'BPEL4WS-DesignGoals.pdf', '53.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 22:15:21', 1, 0),
+(54, 1, 'dresden_bibliothek.pdf', '54.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 22:16:38', 1, 0),
+(55, 1, 'BPEL4WS-DesignGoals.pdf', '55.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 22:19:01', 1, 0),
+(56, 1, 'InfoQ_ The Seven Fallacies.pdf', '56.pdf', '-', '_FAKE_HASH_CODE_', 
4, 7, '2009-10-27 22:24:57', 1, 0),
+(57, 1, 'BPEL4WS-DesignGoals.pdf', '57.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 22:32:39', 1, 0),
+(58, 1, 'dresden_bibliothek.pdf', '58.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 22:34:28', 1, 0),
+(59, 1, 'dresden_bibliothek.pdf', '59.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 22:36:31', 1, 0),
+(60, 1, 'BPEL4WS-DesignGoals.pdf', '60.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 22:41:22', 1, 0),
+(61, 1, 'jsf2-complete-tour.pdf', '61.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-27 22:57:09', 1, 0),
+(62, 1, 'dresden_bibliothek.pdf', '62.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 07:02:34', 1, 0),
+(63, 1, 'BPEL4WS-DesignGoals.pdf', '63.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 07:28:07', 1, 0),
+(64, 1, 'InfoQ_ The Seven Fallacies.pdf', '64.pdf', '-', '_FAKE_HASH_CODE_', 
4, 7, '2009-10-28 07:34:41', 1, 0),
+(65, 1, 'InfoQ_ The Seven Fallacies.pdf', '65.pdf', '-', '_FAKE_HASH_CODE_', 
4, 7, '2009-10-28 07:38:32', 1, 0),
+(66, 1, 'InfoQ_ The Seven Fallacies.pdf', '66.pdf', '-', '_FAKE_HASH_CODE_', 
4, 7, '2009-10-28 07:44:28', 1, 0),
+(67, 1, 'dresden_bibliothek.pdf', '67.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 07:48:01', 1, 0),
+(68, 1, 'dresden_bibliothek.pdf', '68.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 07:49:09', 1, 0),
+(69, 1, 'dresden_bibliothek.pdf', '69.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 07:52:51', 1, 0),
+(70, 1, 'InfoQ_ The Seven Fallacies.pdf', '70.pdf', '-', '_FAKE_HASH_CODE_', 
4, 7, '2009-10-28 07:53:39', 1, 0),
+(71, 1, 'InfoQ_ The Seven Fallacies.pdf', '71.pdf', '-', '_FAKE_HASH_CODE_', 
4, 7, '2009-10-28 08:08:34', 1, 0),
+(72, 1, 'dresden_bibliothek.pdf', '72.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 08:09:59', 1, 0),
+(73, 1, 'BPEL4WS-DesignGoals.pdf', '73.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 08:49:05', 1, 0),
+(74, 1, 'hardcore.pdf', '74.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, '2009-10-28 
10:15:04', 1, 0),
+(75, 1, 'dresden_bibliothek.pdf', '75.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 11:11:53', 1, 0),
+(76, 1, 'jsf2-complete-tour.pdf', '76.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 11:12:02', 1, 0),
+(77, 1, 'hardcore – kopie    _ahooooj_.pdf', '77.pdf', '-', 
'_FAKE_HASH_CODE_', 4, 7, '2009-10-28 11:17:37', 1, 0),
+(78, 1, 'BPEL4WS-DesignGoals.pdf', '78.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 13:02:10', 1, 0),
+(79, 1, 'dresden_bibliothek.pdf', '79.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 13:07:52', 1, 0),
+(80, 1, 'BPEL4WS-DesignGoals.pdf', '80.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 13:07:53', 1, 0),
+(81, 1, 'BPEL4WS-DesignGoals.pdf', '81.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 13:19:06', 1, 0),
+(82, 1, 'BPEL4WS-DesignGoals.pdf', '82.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 13:19:39', 1, 0),
+(83, 1, 'InfoQ_ The Seven Fallacies.pdf', '83.pdf', '-', '_FAKE_HASH_CODE_', 
4, 7, '2009-10-28 13:19:59', 1, 0),
+(84, 1, 'dresden_bibliothek.pdf', '84.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 14:29:40', 1, 0),
+(85, 1, 'BPEL4WS-DesignGoals.pdf', '85.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 14:30:19', 1, 0),
+(86, 1, 'dresden_bibliothek.pdf', '86.pdf', '-', '_FAKE_HASH_CODE_', 4, 7, 
'2009-10-28 14:30:20', 1, 0),
+(87, 1, '20090520-jsf2-datasheet.pdf', '87.pdf', '-', '_FAKE_HASH_CODE_', 4, 
7, '2009-10-28 15:18:22', 0, 0),
+(88, 1, 'Plocha k pronájmu.pdf', '88.pdf', 'fdsa', '_FAKE_HASH_CODE_', 4, 8, 
'2009-11-03 11:45:54', 0, 0),
+(89, 1, 'Muži foto kojetín.pdf', '89.pdf', 'as', '_FAKE_HASH_CODE_', 4, 8, 
'2009-11-03 13:28:38', 0, 0),
+(90, 1, 'Přehled výsledků o víkendu.pdf', '90.pdf', '-', '_FAKE_HASH_CODE_', 
4, 8, '2009-11-03 13:38:41', 0, 0),
+(91, 2, 'Save Snookie from The Jersey Shore!.flv', '91.flv', 'poznamka', 
'9200310ea6a7466c4621d6a5562e1a58', 4, 10, '2010-02-19 16:11:15', 0, 7645260);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `file_frame_content`
+--
+
+CREATE TABLE IF NOT EXISTS `file_frame_content` (
+  `id` int(11) NOT NULL,
+  `file` int(11) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `FK_Reference_46` (`file`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
+
+--
+-- Vypisuji data pro tabulku `file_frame_content`
+--
+
+INSERT INTO `file_frame_content` (`id`, `file`) VALUES
+(11, 5),
+(44, 5),
+(6, 23),
+(15, 23),
+(7, 24),
+(14, 24),
+(35, 24),
+(13, 25),
+(12, 26),
+(34, 27),
+(10, 28),
+(17, 28),
+(20, 28),
+(31, 30),
+(32, 31),
+(37, 31),
+(30, 32),
+(47, 32),
+(33, 33),
+(43, 33),
+(57, 34),
+(59, 35),
+(58, 36),
+(38, 41),
+(60, 87),
+(48, 88),
+(49, 88),
+(50, 88),
+(51, 88),
+(52, 88),
+(61, 88),
+(53, 89),
+(62, 89),
+(54, 90);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `file_type`
+--
+
+CREATE TABLE IF NOT EXISTS `file_type` (
+  `id` int(11) NOT NULL,
+  `type` varchar(10) COLLATE utf8_czech_ci NOT NULL,
+  `suffixes` varchar(200) COLLATE utf8_czech_ci NOT NULL,
+  `icon` varchar(50) COLLATE utf8_czech_ci NOT NULL,
+  `storage_class` varchar(200) COLLATE utf8_czech_ci NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
+
+--
+-- Vypisuji data pro tabulku `file_type`
+--
+
+INSERT INTO `file_type` (`id`, `type`, `suffixes`, `icon`, `storage_class`) 
VALUES
+(1, 'document', 'pdf', '/images/documents/pdf.jpg', 
'elvys.server.bl.file.FileStorageManagerPdf'),
+(2, 'video', 'avi, mov, mpeg, mpg, wmv, flv', '/images/documents/video.gif', 
'elvys.server.bl.file.FileStorageManagerVideo');
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `frame_content`
+--
+
+CREATE TABLE IF NOT EXISTS `frame_content` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `type` int(11) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `FK_Reference_16` (`type`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=66 ;
+
+--
+-- Vypisuji data pro tabulku `frame_content`
+--
+
+INSERT INTO `frame_content` (`id`, `type`) VALUES
+(6, 1),
+(7, 1),
+(10, 1),
+(11, 1),
+(12, 1),
+(13, 1),
+(14, 1),
+(15, 1),
+(17, 1),
+(20, 1),
+(30, 1),
+(31, 1),
+(32, 1),
+(33, 1),
+(34, 1),
+(35, 1),
+(37, 1),
+(38, 1),
+(43, 1),
+(44, 1),
+(47, 1),
+(48, 1),
+(49, 1),
+(50, 1),
+(51, 1),
+(52, 1),
+(53, 1),
+(54, 1),
+(57, 1),
+(58, 1),
+(59, 1),
+(60, 1),
+(61, 1),
+(2, 3),
+(28, 3),
+(41, 3),
+(64, 3),
+(5, 4),
+(29, 4),
+(42, 4),
+(65, 4),
+(62, 6);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `label`
+--
+
+CREATE TABLE IF NOT EXISTS `label` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `label` varchar(20) COLLATE utf8_czech_ci NOT NULL,
+  `comp_identifier` int(11) NOT NULL,
+  `file_count` int(11) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
+
+--
+-- Vypisuji data pro tabulku `label`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `label_ref`
+--
+
+CREATE TABLE IF NOT EXISTS `label_ref` (
+  `file` int(11) NOT NULL,
+  `label` int(11) NOT NULL,
+  PRIMARY KEY (`file`,`label`),
+  KEY `FK_Reference_32` (`label`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
+
+--
+-- Vypisuji data pro tabulku `label_ref`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `layout`
+--
+
+CREATE TABLE IF NOT EXISTS `layout` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `sect_count` int(11) NOT NULL,
+  `company` int(11) NOT NULL,
+  `name` varchar(100) NOT NULL,
+  `aspect_ratio` int(11) NOT NULL,
+  `disabled` tinyint(1) NOT NULL,
+  `revision` int(11) NOT NULL,
+  `lastLockTime` datetime DEFAULT NULL,
+  `locked` tinyint(1) NOT NULL DEFAULT '0',
+  `lastLockUser` int(11) DEFAULT NULL,
+  `created` datetime NOT NULL,
+  `modified` datetime NOT NULL,
+  `modified_by` int(11) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `FK_Reference_22` (`aspect_ratio`),
+  KEY `FK_Reference_12` (`company`),
+  KEY `FK_Reference_28` (`lastLockUser`),
+  KEY `FK_Reference_47` (`modified_by`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ;
+
+--
+-- Vypisuji data pro tabulku `layout`
+--
+
+INSERT INTO `layout` (`id`, `sect_count`, `company`, `name`, `aspect_ratio`, 
`disabled`, `revision`, `lastLockTime`, `locked`, `lastLockUser`, `created`, 
`modified`, `modified_by`) VALUES
+(1, 8, 4, 'layout-prezentace', 1, 0, 1, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(2, 10, 4, 'layout', 1, 0, 2, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(3, 12, 4, 'Pro dv� firmy', 1, 0, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(4, 4, 4, 'layout', 1, 1, 1, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 
20:30:32', 5),
+(5, 8, 4, 'layout-prezentace-nove', 1, 1, 2, NULL, 0, NULL, '2010-02-12 
20:30:31', '2010-02-12 20:30:32', 5),
+(6, 2, 1, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 
20:30:32', 5),
+(7, 0, 1, 'layout4', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(8, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 
20:30:32', 5),
+(9, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 
20:30:32', 5),
+(10, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(11, 2, 2, 'Layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(12, 2, 2, 'Layout1', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(13, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(14, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(15, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(16, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(17, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(18, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(19, 3, 2, 'layout', 1, 1, 1, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(20, 5, 2, 'layout', 1, 1, 2, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(21, 8, 2, 'layout', 1, 1, 3, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(22, 8, 4, 'layout-prezentace', 1, 1, 2, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(23, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(24, 1, 2, 'layout', 1, 1, 1, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(25, 1, 2, 'layout11', 1, 1, 1, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(26, 1, 2, 'layout111', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(27, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(28, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(29, 3, 2, 'layout', 1, 1, 1, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(30, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(31, 3, 2, 'layout', 1, 1, 1, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(32, 3, 4, '�ulina', 1, 0, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(33, 8, 4, 'layout-prezentace', 1, 0, 2, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(34, 2, 4, 'layout', 1, 0, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(35, 2, 4, 'layout', 1, 0, 0, NULL, 0, NULL, '2010-02-12 20:30:31', 
'2010-02-12 20:30:32', 5),
+(36, 2, 4, 'layout-documentType', 1, 0, 0, NULL, 0, NULL, '2010-02-12 
20:30:31', '2010-02-12 20:30:32', 5);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `layout_position`
+--
+
+CREATE TABLE IF NOT EXISTS `layout_position` (
+  `layout` int(11) NOT NULL,
+  `position` int(11) NOT NULL,
+  `xpos` double NOT NULL,
+  `ypos` double NOT NULL,
+  `width` double NOT NULL,
+  `height` double NOT NULL,
+  PRIMARY KEY (`layout`,`position`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Vypisuji data pro tabulku `layout_position`
+--
+
+INSERT INTO `layout_position` (`layout`, `position`, `xpos`, `ypos`, `width`, 
`height`) VALUES
+(1, 1, 0.00286458333333333, 0.00972222222222222, 0.182552083333333, 
0.324074074074074),
+(1, 2, 0.00286458333333333, 0.338425925925926, 0.182552083333333, 
0.324074074074074),
+(1, 3, 0.00286458333333333, 0.66712962962963, 0.182552083333333, 
0.324074074074074),
+(1, 4, 0.2484375, 0.0273148148148148, 0.470833333333333, 0.0958333333333333),
+(1, 5, 0.770833333333333, 0.00648148148148148, 0.208333333333333, 
0.481481481481481),
+(1, 6, 0.770833333333333, 0.509259259259259, 0.208333333333333, 
0.481481481481481),
+(1, 7, 0.3484375, 0.160648148148148, 0.2734375, 0.759722222222222),
+(1, 8, 0.212239583333333, 0.926388888888889, 0.54375, 0.0648148148148148),
+(2, 1, 0.01625, 0, 0.17875, 0.462222222222222),
+(2, 2, 0.005625, 0.5, 0.195625, 0.492222222222222),
+(2, 3, 0.2275, 0, 0.17875, 0.462222222222222),
+(2, 4, 0.203125, 0.5, 0.195625, 0.492222222222222),
+(2, 5, 0.43875, 0.173333333333333, 0.1625, 0.173333333333333),
+(2, 6, 0.401875, 0.5, 0.195625, 0.492222222222222),
+(2, 7, 0.61875, 0.00666666666666667, 0.17875, 0.493333333333333),
+(2, 8, 0.6, 0.5, 0.195625, 0.492222222222222),
+(2, 9, 0.796875, 0.00555555555555556, 0.195625, 0.492222222222222),
+(2, 10, 0.796875, 0.5, 0.195625, 0.492222222222222),
+(3, 1, 0.00364583333333333, 0.50462962962963, 0.1953125, 0.492592592592593),
+(3, 2, 0.2, 0.50462962962963, 0.1953125, 0.492592592592593),
+(3, 3, 0.4, 0.50462962962963, 0.1953125, 0.492592592592593),
+(3, 4, 0.6, 0.50462962962963, 0.1953125, 0.492592592592593),
+(3, 5, 0.8, 0.50462962962963, 0.1953125, 0.492592592592593),
+(3, 6, 0.0151041666666667, 0.0305555555555556, 0.365104166666667, 
0.0805555555555556),
+(3, 7, 0.413541666666667, 0.0305555555555556, 0.5734375, 0.0805555555555556),
+(3, 8, 0.00364583333333333, 0.127777777777778, 0.1953125, 0.374074074074074),
+(3, 9, 0.2, 0.127777777777778, 0.1953125, 0.374074074074074),
+(3, 10, 0.4, 0.127777777777778, 0.1953125, 0.374074074074074),
+(3, 11, 0.6, 0.127777777777778, 0.1953125, 0.374074074074074),
+(3, 12, 0.8, 0.127777777777778, 0.1953125, 0.371296296296296),
+(4, 1, 0.16162109375, 0.201388888888889, 0.15966796875, 0.442708333333333),
+(4, 2, 0.39990234375, 0.213541666666667, 0.1181640625, 0.418402777777778),
+(4, 3, 0.6279296875, 0.196180555555556, 0.1533203125, 0.408854166666667),
+(4, 4, 0.861328125, 0.290798611111111, 0.1015625, 0.368055555555556),
+(5, 1, 0.00286458333333333, 0.00972222222222222, 0.182552083333333, 
0.324074074074074),
+(5, 2, 0.00286458333333333, 0.338425925925926, 0.182552083333333, 
0.324074074074074),
+(5, 3, 0.00286458333333333, 0.66712962962963, 0.182552083333333, 
0.324074074074074),
+(5, 4, 0.2484375, 0.0273148148148148, 0.470833333333333, 0.0958333333333333),
+(5, 5, 0.770833333333333, 0.00648148148148148, 0.208333333333333, 
0.481481481481481),
+(5, 6, 0.770833333333333, 0.509259259259259, 0.208333333333333, 
0.481481481481481),
+(5, 7, 0.3484375, 0.160648148148148, 0.2734375, 0.759722222222222),
+(5, 8, 0.212239583333333, 0.926388888888889, 0.54375, 0.0648148148148148),
+(6, 1, 0.43, 0.264444444444444, 0.158125, 0.352222222222222),
+(6, 2, 0.64625, 0.296666666666667, 0.121875, 0.335555555555556),
+(8, 1, 0.15625, 0.0833333333333333, 0.145, 0.32),
+(9, 1, 0.318125, 0.0855555555555556, 0.203125, 0.431111111111111),
+(10, 1, 0.3, 0.175555555555556, 0.195, 0.412222222222222),
+(10, 2, 0.598125, 0.264444444444444, 0.138125, 0.284444444444444),
+(11, 1, 0.3, 0.175555555555556, 0.195, 0.412222222222222),
+(11, 2, 0.598125, 0.264444444444444, 0.138125, 0.284444444444444),
+(12, 1, 0.3, 0.175555555555556, 0.195, 0.412222222222222),
+(12, 2, 0.598125, 0.264444444444444, 0.138125, 0.284444444444444),
+(13, 1, 0.393125, 0.166666666666667, 0.123125, 0.266666666666667),
+(14, 1, 0.41, 0.142222222222222, 0.188125, 0.424444444444444),
+(15, 1, 0.35, 0.14, 0.165, 0.405555555555556),
+(15, 2, 0.545, 0.38, 0.195, 0.424444444444444),
+(16, 1, 0.38125, 0.145555555555556, 0.2, 0.433333333333333),
+(16, 2, 0.655, 0.278888888888889, 0.17625, 0.456666666666667),
+(17, 1, 0.17625, 0.175555555555556, 0.256875, 0.421111111111111),
+(17, 2, 0.48, 0.19, 0.223125, 0.545555555555556),
+(18, 1, 0.448125, 0.121111111111111, 0.188125, 0.507777777777778),
+(18, 2, 0.69, 0.284444444444444, 0.128125, 0.338888888888889),
+(19, 1, 0.448125, 0.121111111111111, 0.188125, 0.507777777777778),
+(19, 2, 0.69, 0.284444444444444, 0.128125, 0.338888888888889),
+(19, 3, 0.16625, 0.184444444444444, 0.096875, 0.222222222222222),
+(20, 1, 0.448125, 0.121111111111111, 0.188125, 0.507777777777778),
+(20, 2, 0.69, 0.284444444444444, 0.128125, 0.338888888888889),
+(20, 3, 0.16625, 0.184444444444444, 0.096875, 0.222222222222222),
+(20, 4, 0.265, 0.531111111111111, 0.168125, 0.27),
+(20, 5, 0.063125, 0.527777777777778, 0.15, 0.273333333333333),
+(21, 1, 0.448125, 0.121111111111111, 0.188125, 0.507777777777778),
+(21, 2, 0.69, 0.284444444444444, 0.128125, 0.338888888888889),
+(21, 3, 0.16625, 0.184444444444444, 0.096875, 0.222222222222222),
+(21, 4, 0.265, 0.531111111111111, 0.168125, 0.27),
+(21, 5, 0.063125, 0.527777777777778, 0.15, 0.273333333333333),
+(21, 6, 0.623125, 0.691111111111111, 0.15, 0.308888888888889),
+(21, 7, 0.843125, 0.0711111111111111, 0.133125, 0.308888888888889),
+(21, 8, 0.853125, 0.566666666666667, 0.096875, 0.264444444444444),
+(22, 1, 0.00286458333333333, 0.00972222222222222, 0.182552083333333, 
0.324074074074074),
+(22, 2, 0.00286458333333333, 0.338888888888889, 0.182552083333333, 
0.324074074074074),
+(22, 3, 0.00286458333333333, 0.667592592592593, 0.182552083333333, 
0.324074074074074),
+(22, 4, 0.2484375, 0.0273148148148148, 0.470833333333333, 0.0958333333333333),
+(22, 5, 0.770833333333333, 0.00648148148148148, 0.208333333333333, 
0.481481481481481),
+(22, 6, 0.770833333333333, 0.509259259259259, 0.208333333333333, 
0.481481481481481),
+(22, 7, 0.265104166666667, 0.145833333333333, 0.275, 0.762962962962963),
+(22, 8, 0.212239583333333, 0.926851851851852, 0.54375, 0.0648148148148148),
+(23, 1, 0.31625, 0.184444444444444, 0.236875, 0.462222222222222),
+(24, 1, 0.101875, 0.09, 0.15375, 0.472222222222222),
+(25, 1, 0.555, 0.0866666666666667, 0.15375, 0.472222222222222),
+(26, 1, 0.555, 0.0866666666666667, 0.15375, 0.472222222222222),
+(27, 1, 0.455, 0.296666666666667, 0.173125, 0.454444444444444),
+(27, 2, 0.678125, 0.302222222222222, 0.136875, 0.33),
+(28, 1, 0.34125, 0.204444444444444, 0.21875, 0.401111111111111),
+(28, 2, 0.073125, 0.151111111111111, 0.18, 0.374444444444444),
+(29, 1, 0.34125, 0.204444444444444, 0.21875, 0.401111111111111),
+(29, 2, 0.073125, 0.151111111111111, 0.18, 0.374444444444444),
+(29, 3, 0.7, 0.323333333333333, 0.193125, 0.321111111111111),
+(30, 1, 0.098125, 0.181111111111111, 0.196875, 0.474444444444444),
+(31, 1, 0.488125, 0.3, 0.155, 0.46),
+(31, 2, 0.728125, 0.296666666666667, 0.21, 0.415555555555556),
+(31, 3, 0.26, 0.0566666666666667, 0.18625, 0.465555555555556),
+(32, 1, 0.06875, 0.0981481481481482, 0.181770833333333, 0.537962962962963),
+(32, 2, 0.403645833333333, 0.291666666666667, 0.130208333333333, 
0.537962962962963),
+(32, 3, 0.552083333333333, 0.15462962962963, 0.286979166666667, 
0.211111111111111),
+(33, 1, 0.003125, 0.01, 0.183125, 0.324444444444444),
+(33, 2, 0.003125, 0.338888888888889, 0.183125, 0.324444444444444),
+(33, 3, 0.003125, 0.667777777777778, 0.183125, 0.324444444444444),
+(33, 4, 0.24875, 0.0277777777777778, 0.47125, 0.0966666666666667),
+(33, 5, 0.77125, 0.00666666666666667, 0.20875, 0.482222222222222),
+(33, 6, 0.77125, 0.51, 0.20875, 0.482222222222222),
+(33, 7, 0.35, 0.163333333333333, 0.275, 0.763333333333333),
+(33, 8, 0.2125, 0.926666666666667, 0.54375, 0.0655555555555556),
+(34, 1, 0.2470703125, 0.166666666666667, 0.1767578125, 0.388888888888889),
+(34, 2, 0.55322265625, 0.192708333333333, 0.15966796875, 0.376736111111111),
+(35, 1, 0.721875, 0.163425925925926, 0.205208333333333, 0.614351851851852),
+(35, 2, 0.371875, 0.112962962962963, 0.241666666666667, 0.356481481481481),
+(36, 1, 0.7234375, 0.166203703703704, 0.206770833333333, 0.617592592592593),
+(36, 2, 0.3734375, 0.115740740740741, 0.243489583333333, 0.359259259259259);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `panel`
+--
+
+CREATE TABLE IF NOT EXISTS `panel` (
+  `planning` int(11) NOT NULL,
+  `order_num` int(11) NOT NULL,
+  PRIMARY KEY (`planning`,`order_num`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
+
+--
+-- Vypisuji data pro tabulku `panel`
+--
+
+INSERT INTO `panel` (`planning`, `order_num`) VALUES
+(1, 1),
+(2, 1),
+(2, 2),
+(2, 3);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `pdf_pres_content`
+--
+
+CREATE TABLE IF NOT EXISTS `pdf_pres_content` (
+  `id` int(11) NOT NULL,
+  `page_list` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `interval_rfrsh` int(11) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
+
+--
+-- Vypisuji data pro tabulku `pdf_pres_content`
+--
+
+INSERT INTO `pdf_pres_content` (`id`, `page_list`, `interval_rfrsh`) VALUES
+(62, '1-3', 8000);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `permitted_scheduling`
+--
+
+CREATE TABLE IF NOT EXISTS `permitted_scheduling` (
+  `layout` int(11) NOT NULL,
+  `position` int(11) NOT NULL,
+  `permitted_type` int(11) NOT NULL,
+  PRIMARY KEY (`layout`,`position`,`permitted_type`),
+  KEY `FK_Reference_15` (`permitted_type`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Vypisuji data pro tabulku `permitted_scheduling`
+--
+
+INSERT INTO `permitted_scheduling` (`layout`, `position`, `permitted_type`) 
VALUES
+(1, 1, 1),
+(1, 2, 1),
+(1, 3, 1),
+(1, 4, 1),
+(1, 5, 1),
+(1, 6, 1),
+(1, 7, 1),
+(1, 8, 1),
+(2, 1, 1),
+(2, 2, 1),
+(2, 3, 1),
+(2, 4, 1),
+(2, 5, 1),
+(2, 6, 1),
+(2, 7, 1),
+(2, 8, 1),
+(2, 9, 1),
+(2, 10, 1),
+(3, 1, 1),
+(3, 2, 1),
+(3, 3, 1),
+(3, 4, 1),
+(3, 5, 1),
+(3, 8, 1),
+(3, 9, 1),
+(3, 10, 1),
+(3, 11, 1),
+(3, 12, 1),
+(4, 1, 1),
+(4, 2, 1),
+(4, 3, 1),
+(4, 4, 1),
+(5, 1, 1),
+(5, 2, 1),
+(5, 3, 1),
+(5, 4, 1),
+(5, 5, 1),
+(5, 6, 1),
+(5, 7, 1),
+(5, 8, 1),
+(8, 1, 1),
+(9, 1, 1),
+(10, 1, 1),
+(10, 2, 1),
+(11, 1, 1),
+(11, 2, 1),
+(12, 1, 1),
+(12, 2, 1),
+(13, 1, 1),
+(14, 1, 1),
+(15, 1, 1),
+(15, 2, 1),
+(16, 1, 1),
+(16, 2, 1),
+(17, 1, 1),
+(17, 2, 1),
+(18, 1, 1),
+(18, 2, 1),
+(19, 1, 1),
+(19, 2, 1),
+(19, 3, 1),
+(20, 1, 1),
+(20, 2, 1),
+(20, 3, 1),
+(20, 4, 1),
+(20, 5, 1),
+(21, 1, 1),
+(21, 2, 1),
+(21, 3, 1),
+(21, 4, 1),
+(21, 5, 1),
+(21, 6, 1),
+(21, 7, 1),
+(21, 8, 1),
+(22, 1, 1),
+(22, 2, 1),
+(22, 3, 1),
+(22, 4, 1),
+(22, 5, 1),
+(22, 6, 1),
+(22, 7, 1),
+(22, 8, 1),
+(23, 1, 1),
+(24, 1, 1),
+(25, 1, 1),
+(26, 1, 1),
+(27, 1, 1),
+(27, 2, 1),
+(28, 1, 1),
+(28, 2, 1),
+(29, 1, 1),
+(29, 2, 1),
+(29, 3, 1),
+(30, 1, 1),
+(31, 1, 1),
+(31, 2, 1),
+(31, 3, 1),
+(32, 1, 1),
+(32, 2, 1),
+(33, 1, 1),
+(33, 2, 1),
+(33, 3, 1),
+(33, 4, 1),
+(33, 5, 1),
+(33, 6, 1),
+(33, 7, 1),
+(33, 8, 1),
+(34, 1, 1),
+(34, 2, 1),
+(35, 1, 1),
+(35, 2, 1),
+(36, 1, 1),
+(36, 2, 1),
+(1, 1, 2),
+(1, 2, 2),
+(1, 3, 2),
+(1, 4, 2),
+(1, 5, 2),
+(1, 6, 2),
+(1, 7, 2),
+(1, 8, 2),
+(2, 1, 2),
+(2, 2, 2),
+(2, 3, 2),
+(2, 4, 2),
+(2, 5, 2),
+(2, 6, 2),
+(2, 7, 2),
+(2, 8, 2),
+(2, 9, 2),
+(2, 10, 2),
+(3, 8, 2),
+(3, 9, 2),
+(3, 10, 2),
+(3, 11, 2),
+(3, 12, 2),
+(4, 1, 2),
+(4, 2, 2),
+(4, 3, 2),
+(4, 4, 2),
+(5, 1, 2),
+(5, 2, 2),
+(5, 3, 2),
+(5, 4, 2),
+(5, 5, 2),
+(5, 6, 2),
+(5, 7, 2),
+(5, 8, 2),
+(8, 1, 2),
+(9, 1, 2),
+(10, 1, 2),
+(10, 2, 2),
+(11, 1, 2),
+(11, 2, 2),
+(12, 1, 2),
+(12, 2, 2),
+(13, 1, 2),
+(14, 1, 2),
+(15, 1, 2),
+(15, 2, 2),
+(16, 1, 2),
+(16, 2, 2),
+(17, 1, 2),
+(17, 2, 2),
+(18, 1, 2),
+(18, 2, 2),
+(19, 1, 2),
+(19, 2, 2),
+(19, 3, 2),
+(20, 1, 2),
+(20, 2, 2),
+(20, 3, 2),
+(20, 4, 2),
+(20, 5, 2),
+(21, 1, 2),
+(21, 2, 2),
+(21, 3, 2),
+(21, 4, 2),
+(21, 5, 2),
+(21, 6, 2),
+(21, 7, 2),
+(21, 8, 2),
+(22, 1, 2),
+(22, 2, 2),
+(22, 3, 2),
+(22, 4, 2),
+(22, 5, 2),
+(22, 6, 2),
+(22, 7, 2),
+(22, 8, 2),
+(23, 1, 2),
+(24, 1, 2),
+(25, 1, 2),
+(26, 1, 2),
+(27, 1, 2),
+(27, 2, 2),
+(28, 1, 2),
+(28, 2, 2),
+(29, 1, 2),
+(29, 2, 2),
+(29, 3, 2),
+(30, 1, 2),
+(31, 1, 2),
+(31, 2, 2),
+(31, 3, 2),
+(32, 2, 2),
+(33, 1, 2),
+(33, 2, 2),
+(33, 3, 2),
+(33, 4, 2),
+(33, 5, 2),
+(33, 6, 2),
+(33, 8, 2),
+(34, 2, 2),
+(35, 1, 2),
+(36, 1, 2),
+(36, 2, 2),
+(1, 1, 3),
+(1, 2, 3),
+(1, 3, 3),
+(1, 4, 3),
+(1, 5, 3),
+(1, 6, 3),
+(1, 7, 3),
+(1, 8, 3),
+(2, 1, 3),
+(2, 2, 3),
+(2, 3, 3),
+(2, 4, 3),
+(2, 5, 3),
+(2, 6, 3),
+(2, 7, 3),
+(2, 8, 3),
+(2, 9, 3),
+(2, 10, 3),
+(3, 6, 3),
+(3, 7, 3),
+(3, 8, 3),
+(3, 9, 3),
+(3, 10, 3),
+(3, 11, 3),
+(3, 12, 3),
+(4, 1, 3),
+(4, 2, 3),
+(4, 3, 3),
+(4, 4, 3),
+(5, 1, 3),
+(5, 2, 3),
+(5, 3, 3),
+(5, 4, 3),
+(5, 5, 3),
+(5, 6, 3),
+(5, 7, 3),
+(5, 8, 3),
+(8, 1, 3),
+(9, 1, 3),
+(10, 1, 3),
+(10, 2, 3),
+(11, 1, 3),
+(11, 2, 3),
+(12, 1, 3),
+(12, 2, 3),
+(13, 1, 3),
+(14, 1, 3),
+(15, 1, 3),
+(15, 2, 3),
+(16, 1, 3),
+(16, 2, 3),
+(17, 1, 3),
+(17, 2, 3),
+(18, 1, 3),
+(18, 2, 3),
+(19, 1, 3),
+(19, 2, 3),
+(19, 3, 3),
+(20, 1, 3),
+(20, 2, 3),
+(20, 3, 3),
+(20, 4, 3),
+(20, 5, 3),
+(21, 1, 3),
+(21, 2, 3),
+(21, 3, 3),
+(21, 4, 3),
+(21, 5, 3),
+(21, 6, 3),
+(21, 7, 3),
+(21, 8, 3),
+(22, 1, 3),
+(22, 2, 3),
+(22, 3, 3),
+(22, 4, 3),
+(22, 5, 3),
+(22, 6, 3),
+(22, 7, 3),
+(22, 8, 3),
+(23, 1, 3),
+(24, 1, 3),
+(25, 1, 3),
+(26, 1, 3),
+(27, 1, 3),
+(27, 2, 3),
+(28, 1, 3),
+(28, 2, 3),
+(29, 1, 3),
+(29, 2, 3),
+(29, 3, 3),
+(30, 1, 3),
+(31, 1, 3),
+(31, 2, 3),
+(31, 3, 3),
+(32, 3, 3),
+(33, 1, 3),
+(33, 2, 3),
+(33, 3, 3),
+(33, 4, 3),
+(33, 5, 3),
+(33, 6, 3),
+(33, 8, 3),
+(35, 1, 3),
+(35, 2, 3),
+(36, 1, 3),
+(36, 2, 3),
+(1, 1, 4),
+(1, 2, 4),
+(1, 3, 4),
+(1, 4, 4),
+(1, 5, 4),
+(1, 6, 4),
+(1, 7, 4),
+(1, 8, 4),
+(2, 1, 4),
+(2, 2, 4),
+(2, 3, 4),
+(2, 4, 4),
+(2, 5, 4),
+(2, 6, 4),
+(2, 7, 4),
+(2, 8, 4),
+(2, 9, 4),
+(2, 10, 4),
+(3, 6, 4),
+(3, 7, 4),
+(3, 8, 4),
+(3, 9, 4),
+(3, 10, 4),
+(3, 11, 4),
+(3, 12, 4),
+(4, 1, 4),
+(4, 2, 4),
+(4, 3, 4),
+(4, 4, 4),
+(5, 1, 4),
+(5, 2, 4),
+(5, 3, 4),
+(5, 4, 4),
+(5, 5, 4),
+(5, 6, 4),
+(5, 7, 4),
+(5, 8, 4),
+(8, 1, 4),
+(9, 1, 4),
+(10, 1, 4),
+(10, 2, 4),
+(11, 1, 4),
+(11, 2, 4),
+(12, 1, 4),
+(12, 2, 4),
+(13, 1, 4),
+(14, 1, 4),
+(15, 1, 4),
+(15, 2, 4),
+(16, 1, 4),
+(16, 2, 4),
+(17, 1, 4),
+(17, 2, 4),
+(18, 1, 4),
+(18, 2, 4),
+(19, 1, 4),
+(19, 2, 4),
+(19, 3, 4),
+(20, 1, 4),
+(20, 2, 4),
+(20, 3, 4),
+(20, 4, 4),
+(20, 5, 4),
+(21, 1, 4),
+(21, 2, 4),
+(21, 3, 4),
+(21, 4, 4),
+(21, 5, 4),
+(21, 6, 4),
+(21, 7, 4),
+(21, 8, 4),
+(22, 1, 4),
+(22, 2, 4),
+(22, 3, 4),
+(22, 4, 4),
+(22, 5, 4),
+(22, 6, 4),
+(22, 7, 4),
+(22, 8, 4),
+(23, 1, 4),
+(24, 1, 4),
+(25, 1, 4),
+(26, 1, 4),
+(27, 1, 4),
+(27, 2, 4),
+(28, 1, 4),
+(28, 2, 4),
+(29, 1, 4),
+(29, 2, 4),
+(29, 3, 4),
+(30, 1, 4),
+(31, 1, 4),
+(31, 2, 4),
+(31, 3, 4),
+(32, 1, 4),
+(32, 3, 4),
+(33, 1, 4),
+(33, 2, 4),
+(33, 3, 4),
+(33, 4, 4),
+(33, 5, 4),
+(33, 6, 4),
+(33, 8, 4),
+(34, 1, 4),
+(35, 2, 4),
+(36, 1, 4),
+(36, 2, 4),
+(1, 1, 5),
+(1, 2, 5),
+(1, 3, 5),
+(1, 4, 5),
+(1, 5, 5),
+(1, 6, 5),
+(1, 7, 5),
+(1, 8, 5),
+(2, 1, 5),
+(2, 2, 5),
+(2, 3, 5),
+(2, 4, 5),
+(2, 5, 5),
+(2, 6, 5),
+(2, 7, 5),
+(2, 8, 5),
+(2, 9, 5),
+(2, 10, 5),
+(3, 8, 5),
+(3, 9, 5),
+(3, 10, 5),
+(3, 11, 5),
+(3, 12, 5),
+(4, 1, 5),
+(4, 2, 5),
+(4, 3, 5),
+(4, 4, 5),
+(5, 1, 5),
+(5, 2, 5),
+(5, 3, 5),
+(5, 4, 5),
+(5, 5, 5),
+(5, 6, 5),
+(5, 7, 5),
+(5, 8, 5),
+(22, 1, 5),
+(22, 2, 5),
+(22, 3, 5),
+(22, 4, 5),
+(22, 5, 5),
+(22, 6, 5),
+(22, 7, 5),
+(22, 8, 5),
+(33, 1, 5),
+(33, 2, 5),
+(33, 3, 5),
+(33, 4, 5),
+(33, 5, 5),
+(33, 6, 5),
+(33, 8, 5),
+(36, 1, 5),
+(36, 2, 5),
+(1, 1, 6),
+(1, 2, 6),
+(1, 3, 6),
+(1, 4, 6),
+(1, 5, 6),
+(1, 6, 6),
+(1, 7, 6),
+(1, 8, 6),
+(2, 1, 6),
+(2, 2, 6),
+(2, 3, 6),
+(2, 4, 6),
+(2, 5, 6),
+(2, 6, 6),
+(2, 7, 6),
+(2, 8, 6),
+(2, 9, 6),
+(2, 10, 6),
+(3, 8, 6),
+(3, 9, 6),
+(3, 10, 6),
+(3, 11, 6),
+(3, 12, 6),
+(4, 1, 6),
+(4, 2, 6),
+(4, 3, 6),
+(4, 4, 6),
+(5, 1, 6),
+(5, 2, 6),
+(5, 3, 6),
+(5, 4, 6),
+(5, 5, 6),
+(5, 6, 6),
+(5, 7, 6),
+(5, 8, 6),
+(22, 1, 6),
+(22, 2, 6),
+(22, 3, 6),
+(22, 4, 6),
+(22, 5, 6),
+(22, 6, 6),
+(22, 7, 6),
+(22, 8, 6),
+(33, 1, 6),
+(33, 2, 6),
+(33, 3, 6),
+(33, 4, 6),
+(33, 5, 6),
+(33, 6, 6),
+(33, 8, 6),
+(36, 1, 6),
+(36, 2, 6);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `resolution`
+--
+
+CREATE TABLE IF NOT EXISTS `resolution` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `res_x` int(11) NOT NULL,
+  `res_y` int(11) NOT NULL,
+  `aspect_ratio` int(11) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `FK_Reference_24` (`aspect_ratio`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;
+
+--
+-- Vypisuji data pro tabulku `resolution`
+--
+
+INSERT INTO `resolution` (`id`, `res_x`, `res_y`, `aspect_ratio`) VALUES
+(1, 1600, 900, 1),
+(2, 1920, 1080, 1),
+(3, 2048, 1152, 1),
+(4, 3840, 2160, 1),
+(5, 1024, 748, 2),
+(6, 1152, 864, 2),
+(7, 1400, 1050, 2),
+(8, 1440, 1080, 2),
+(9, 1600, 1200, 2),
+(10, 1792, 1344, 2),
+(11, 1856, 1392, 2),
+(12, 1920, 1440, 2),
+(13, 2048, 1536, 2),
+(14, 1280, 800, 3),
+(15, 1440, 900, 3),
+(16, 1680, 1050, 3),
+(17, 1920, 1200, 3),
+(18, 2560, 1600, 3),
+(19, 3840, 2400, 3),
+(20, 1280, 1024, 4),
+(21, 1800, 1440, 4),
+(22, 2560, 2048, 4);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `role`
+--
+
+CREATE TABLE IF NOT EXISTS `role` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `role` enum('superadmin','admin','user') NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
+
+--
+-- Vypisuji data pro tabulku `role`
+--
+
+INSERT INTO `role` (`id`, `role`) VALUES
+(1, 'user'),
+(2, 'admin'),
+(3, 'superadmin');
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `statistics`
+--
+
+CREATE TABLE IF NOT EXISTS `statistics` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `elvys` int(11) NOT NULL,
+  `layout` int(11) DEFAULT NULL,
+  `document` int(11) NOT NULL,
+  `action_start` datetime DEFAULT NULL,
+  `action_end` datetime DEFAULT NULL,
+  `action_type` enum('download','exhibit','detail','other') NOT NULL,
+  `mode_type` enum('day','night') NOT NULL,
+  `position` int(11) DEFAULT NULL,
+  `category` int(11) DEFAULT NULL,
+  `panel_order` int(11) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `FK_Reference_25` (`elvys`),
+  KEY `FK_Reference_26` (`layout`),
+  KEY `FK_Reference_27` (`document`),
+  KEY `FK_Reference_37` (`category`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=506 ;
+
+--
+-- Vypisuji data pro tabulku `statistics`
+--
+
+INSERT INTO `statistics` (`id`, `elvys`, `layout`, `document`, `action_start`, 
`action_end`, `action_type`, `mode_type`, `position`, `category`, 
`panel_order`) VALUES
+(1, 12, 3, 90, '2009-11-09 23:18:10', '2009-12-01 18:06:51', 'exhibit', 'day', 
1, 3, 1),
+(2, 12, 3, 88, '2009-11-09 23:18:10', '2009-12-01 18:06:51', 'exhibit', 'day', 
2, 3, 1),
+(3, 12, 3, 88, '2009-11-09 23:18:10', '2009-12-01 18:06:51', 'exhibit', 'day', 
3, 3, 1),
+(4, 12, 3, 88, '2009-11-09 23:18:10', '2009-12-01 18:06:51', 'exhibit', 'day', 
4, 3, 1),
+(5, 12, 3, 5, '2009-11-09 23:18:10', '2009-12-01 18:06:51', 'exhibit', 'day', 
5, 3, 1),
+(7, 12, 3, 89, '2009-11-09 23:18:12', '2009-12-01 18:06:51', 'exhibit', 'day', 
8, 3, 1),
+(8, 12, 3, 32, '2009-11-09 23:18:12', '2009-12-01 18:06:51', 'exhibit', 'day', 
9, 3, 1),
+(9, 12, 3, 33, '2009-11-09 23:18:12', '2009-12-01 18:06:51', 'exhibit', 'day', 
10, 3, 1),
+(10, 12, 3, 88, '2009-11-09 23:18:13', '2009-12-01 18:06:51', 'exhibit', 
'day', 11, 3, 1),
+(11, 12, 3, 88, '2009-11-09 23:18:13', '2009-12-01 18:06:51', 'exhibit', 
'day', 12, 3, 1),
+(12, 13, 2, 34, '2009-11-11 16:58:12', '2009-11-11 17:10:11', 'exhibit', 
'day', 1, 2, 1),
+(13, 13, 2, 32, '2009-11-11 16:58:12', '2009-11-11 17:10:11', 'exhibit', 
'day', 4, 2, 1),
+(15, 13, 2, 41, '2009-11-11 16:58:12', '2009-11-11 17:10:11', 'exhibit', 
'day', 7, 2, 1),
+(16, 13, 2, 32, '2009-11-11 16:58:22', '2009-11-11 16:58:25', 'detail', 'day', 
4, 2, 1),
+(17, 13, 2, 34, '2009-11-11 16:58:26', '2009-11-11 16:58:28', 'detail', 'day', 
1, 2, 1),
+(18, 13, 2, 34, '2009-11-11 17:08:16', '2009-11-11 17:14:59', 'exhibit', 
'day', 1, 2, 1),
+(19, 13, 2, 32, '2009-11-11 17:08:16', '2009-11-11 17:14:59', 'exhibit', 
'day', 4, 2, 1),
+(21, 13, 2, 41, '2009-11-11 17:08:17', '2009-11-11 17:14:59', 'exhibit', 
'day', 7, 2, 1),
+(22, 13, 2, 34, '2009-11-11 17:08:30', '2009-11-11 17:08:33', 'detail', 'day', 
1, 2, 1),
+(23, 13, 2, 34, '2009-11-11 17:13:11', '2009-11-11 18:13:08', 'exhibit', 
'day', 1, 2, 1),
+(24, 13, 2, 32, '2009-11-11 17:13:12', '2009-11-11 18:08:49', 'exhibit', 
'day', 4, 2, 1),
+(26, 13, 2, 41, '2009-11-11 17:13:12', '2009-11-11 18:08:00', 'exhibit', 
'day', 7, 2, 1),
+(27, 13, 2, 34, '2009-11-11 17:15:44', '2009-11-18 18:34:35', 'exhibit', 
'day', 1, 2, 1),
+(28, 13, 2, 32, '2009-11-11 17:15:44', '2009-11-11 18:08:49', 'exhibit', 
'day', 4, 2, 1),
+(30, 13, 2, 41, '2009-11-11 17:15:44', '2009-11-11 18:08:00', 'exhibit', 
'day', 7, 2, 1),
+(31, 13, 2, 41, '2009-11-11 17:15:51', '2009-11-11 17:15:53', 'detail', 'day', 
7, 2, 1),
+(32, 13, 2, 34, '2009-11-11 17:48:49', NULL, 'exhibit', 'day', 1, 2, 1),
+(33, 13, 2, 32, '2009-11-11 17:48:49', NULL, 'exhibit', 'day', 4, 2, 1),
+(35, 13, 2, 41, '2009-11-11 17:48:49', NULL, 'exhibit', 'day', 7, 2, 1),
+(36, 13, 2, 32, '2009-11-11 17:50:56', '2009-11-11 17:51:00', 'detail', 'day', 
4, 2, 1),
+(37, 13, 2, 34, '2009-11-11 17:57:18', '2009-11-11 17:57:22', 'detail', 'day', 
1, 2, 1),
+(38, 13, 2, 34, '2009-11-11 18:06:33', '2009-11-11 18:06:36', 'detail', 'day', 
1, 2, 1),
+(39, 13, 2, 34, '2009-11-11 18:47:09', NULL, 'exhibit', 'day', 1, 2, 1),
+(40, 12, 3, 90, '2009-11-15 13:42:42', NULL, 'exhibit', 'day', 1, 3, 1),
+(41, 12, 3, 88, '2009-11-15 13:42:44', NULL, 'exhibit', 'day', 2, 3, 1),
+(42, 12, 3, 88, '2009-11-15 13:42:44', NULL, 'exhibit', 'day', 3, 3, 1),
+(43, 12, 3, 88, '2009-11-15 13:42:44', NULL, 'exhibit', 'day', 4, 3, 1),
+(44, 12, 3, 5, '2009-11-15 13:42:44', NULL, 'exhibit', 'day', 5, 3, 1),
+(46, 12, 3, 89, '2009-11-15 13:42:48', NULL, 'exhibit', 'day', 8, 3, 1),
+(47, 12, 3, 32, '2009-11-15 13:42:48', NULL, 'exhibit', 'day', 9, 3, 1),
+(48, 12, 3, 33, '2009-11-15 13:42:49', NULL, 'exhibit', 'day', 10, 3, 1),
+(49, 12, 3, 88, '2009-11-15 13:42:51', NULL, 'exhibit', 'day', 11, 3, 1),
+(50, 12, 3, 88, '2009-11-15 13:42:51', NULL, 'exhibit', 'day', 12, 3, 1),
+(51, 12, 3, 90, '2009-11-17 18:14:03', NULL, 'exhibit', 'day', 1, 3, 1),
+(52, 12, 3, 88, '2009-11-17 18:14:03', NULL, 'exhibit', 'day', 2, 3, 1),
+(53, 12, 3, 88, '2009-11-17 18:14:03', NULL, 'exhibit', 'day', 3, 3, 1),
+(54, 12, 3, 88, '2009-11-17 18:14:03', NULL, 'exhibit', 'day', 4, 3, 1),
+(55, 12, 3, 5, '2009-11-17 18:14:03', NULL, 'exhibit', 'day', 5, 3, 1),
+(57, 12, 3, 89, '2009-11-17 18:14:05', NULL, 'exhibit', 'day', 8, 3, 1),
+(58, 12, 3, 32, '2009-11-17 18:14:05', NULL, 'exhibit', 'day', 9, 3, 1),
+(59, 12, 3, 33, '2009-11-17 18:14:06', NULL, 'exhibit', 'day', 10, 3, 1),
+(60, 12, 3, 88, '2009-11-17 18:14:06', NULL, 'exhibit', 'day', 11, 3, 1),
+(61, 12, 3, 88, '2009-11-17 18:14:06', NULL, 'exhibit', 'day', 12, 3, 1),
+(62, 12, 3, 89, '2009-11-17 18:14:53', '2009-11-17 18:15:22', 'detail', 'day', 
8, 3, 1),
+(63, 12, 3, 88, '2009-11-17 19:39:38', '2009-11-17 19:39:41', 'detail', 'day', 
11, 3, 1),
+(64, 12, 3, 88, '2009-11-17 19:39:55', '2009-11-17 19:40:01', 'detail', 'day', 
12, 3, 1),
+(65, 12, 3, 5, '2009-11-17 19:40:06', '2009-11-17 19:42:02', 'detail', 'day', 
5, 3, 1),
+(66, 12, 3, 32, '2009-11-18 07:20:38', '2009-11-18 07:20:40', 'detail', 'day', 
9, 3, 1),
+(67, 12, 3, 5, '2009-11-18 07:43:56', '2009-11-18 07:45:02', 'detail', 'day', 
5, 3, 1),
+(68, 12, 3, 88, '2009-11-18 10:51:11', '2009-11-18 10:51:14', 'detail', 'day', 
2, 3, 1),
+(69, 12, 3, 90, '2009-11-18 11:36:38', '2009-11-18 11:36:45', 'detail', 'day', 
1, 3, 1),
+(70, 12, 3, 32, '2009-11-18 11:55:47', '2009-11-18 11:56:00', 'detail', 'day', 
9, 3, 1),
+(71, 12, 3, 88, '2009-11-18 11:56:05', '2009-11-18 11:56:15', 'detail', 'day', 
11, 3, 1),
+(72, 12, 3, 88, '2009-11-18 13:41:53', '2009-11-18 13:41:56', 'detail', 'day', 
3, 3, 1),
+(73, 12, 3, 32, '2009-11-18 13:42:00', '2009-11-18 13:43:03', 'detail', 'day', 
9, 3, 1),
+(74, 12, 3, 89, '2009-11-18 14:02:52', '2009-11-18 14:04:02', 'detail', 'day', 
8, 3, 1),
+(75, 12, 3, 88, '2009-11-18 14:31:52', '2009-11-18 14:32:05', 'detail', 'day', 
12, 3, 1),
+(76, 12, 3, 33, '2009-11-18 14:50:17', '2009-11-18 14:50:32', 'detail', 'day', 
10, 3, 1),
+(77, 12, 3, 5, '2009-11-18 14:50:45', '2009-11-18 14:50:58', 'detail', 'day', 
5, 3, 1),
+(78, 12, 3, 5, '2009-11-18 14:50:59', '2009-11-18 14:52:04', 'detail', 'day', 
5, 3, 1),
+(79, 12, 3, 32, '2009-11-18 14:52:16', '2009-11-18 14:52:38', 'detail', 'day', 
9, 3, 1),
+(80, 12, 3, 32, '2009-11-18 14:54:12', '2009-11-18 14:54:32', 'detail', 'day', 
9, 3, 1),
+(81, 12, 3, 32, '2009-11-18 14:54:36', '2009-11-18 14:56:10', 'detail', 'day', 
9, 3, 1),
+(82, 12, 3, 33, '2009-11-18 15:19:55', '2009-11-18 15:19:58', 'detail', 'day', 
10, 3, 1),
+(83, 12, 3, 33, '2009-11-18 15:20:00', '2009-11-18 15:20:01', 'detail', 'day', 
10, 3, 1),
+(84, 12, 3, 32, '2009-11-18 15:20:03', '2009-11-18 15:20:07', 'detail', 'day', 
9, 3, 1),
+(85, 12, 3, 32, '2009-11-18 15:20:08', '2009-11-18 15:20:10', 'detail', 'day', 
9, 3, 1),
+(86, 12, 3, 5, '2009-11-18 15:20:19', '2009-11-18 15:20:27', 'detail', 'day', 
5, 3, 1),
+(87, 12, 3, 89, '2009-11-18 15:20:36', '2009-11-18 15:20:46', 'detail', 'day', 
8, 3, 1),
+(88, 12, 3, 32, '2009-11-18 16:30:04', '2009-11-18 16:30:12', 'detail', 'day', 
9, 3, 1),
+(89, 12, 3, 33, '2009-11-18 16:30:18', '2009-11-18 16:30:25', 'detail', 'day', 
10, 3, 1),
+(90, 12, 3, 88, '2009-11-18 16:30:29', '2009-11-18 16:31:48', 'detail', 'day', 
11, 3, 1),
+(91, 12, 3, 89, '2009-11-18 16:52:35', '2009-11-18 16:53:36', 'detail', 'day', 
8, 3, 1),
+(92, 12, 3, 88, '2009-11-18 18:35:34', '2009-11-18 18:36:42', 'detail', 'day', 
11, 3, 1),
+(93, 13, 1, 90, '2009-11-18 18:37:28', '2009-11-18 18:38:19', 'exhibit', 
'day', 1, 1, 1),
+(94, 13, 1, 90, '2009-11-18 18:37:33', '2009-11-18 18:38:04', 'detail', 'day', 
1, 1, 1),
+(95, 13, 1, 90, '2009-11-18 18:40:47', '2009-11-18 18:41:07', 'exhibit', 
'day', 1, 1, 1),
+(96, 13, 1, 90, '2009-11-18 18:41:46', '2009-11-26 21:48:42', 'exhibit', 
'day', 1, 1, 1),
+(97, 13, 1, 90, '2009-11-18 18:43:10', '2009-11-18 18:43:13', 'detail', 'day', 
1, 1, 1),
+(98, 13, 1, 90, '2009-11-18 18:43:14', '2009-11-18 18:43:16', 'detail', 'day', 
1, 1, 1),
+(99, 13, 1, 90, '2009-11-18 18:44:20', '2009-11-18 18:44:23', 'detail', 'day', 
1, 1, 1),
+(100, 13, 1, 90, '2009-11-18 18:44:24', '2009-11-18 18:44:25', 'detail', 
'day', 1, 1, 1),
+(101, 13, 1, 90, '2009-11-18 18:44:28', '2009-11-18 18:44:30', 'detail', 
'day', 1, 1, 1),
+(102, 12, 3, 88, '2009-11-18 19:12:34', '2009-11-18 19:12:34', 'detail', 
'day', 11, 3, 1),
+(103, 12, 3, 33, '2009-11-18 19:12:47', '2009-11-18 19:12:51', 'detail', 
'day', 10, 3, 1),
+(104, 12, 3, 89, '2009-11-18 21:15:36', '2009-11-18 21:15:44', 'detail', 
'day', 8, 3, 1),
+(105, 12, 3, 89, '2009-11-18 21:15:48', '2009-11-18 21:16:39', 'detail', 
'day', 8, 3, 1),
+(106, 12, 3, 90, '2009-11-18 21:16:42', '2009-11-18 21:17:02', 'detail', 
'day', 1, 3, 1),
+(107, 12, 3, 33, '2009-11-18 21:17:06', '2009-11-18 21:17:33', 'detail', 
'day', 10, 3, 1),
+(108, 12, 3, 32, '2009-11-18 21:17:40', '2009-11-18 21:17:44', 'detail', 
'day', 9, 3, 1),
+(109, 12, 3, 33, '2009-11-18 21:18:01', '2009-11-18 21:18:03', 'detail', 
'day', 10, 3, 1),
+(110, 12, 3, 5, '2009-11-18 21:18:11', '2009-11-18 21:19:43', 'detail', 'day', 
5, 3, 1),
+(111, 12, 3, 89, '2009-11-18 21:38:23', '2009-11-18 21:38:25', 'detail', 
'day', 8, 3, 1),
+(112, 12, 3, 32, '2009-11-18 21:38:27', '2009-11-18 21:38:29', 'detail', 
'day', 9, 3, 1),
+(113, 12, 3, 33, '2009-11-18 21:38:32', '2009-11-18 21:38:34', 'detail', 
'day', 10, 3, 1),
+(114, 12, 3, 32, '2009-11-18 22:56:07', '2009-11-18 22:56:15', 'detail', 
'day', 9, 3, 1),
+(115, 12, 3, 33, '2009-11-18 22:56:19', '2009-11-18 22:56:24', 'detail', 
'day', 10, 3, 1),
+(116, 12, 3, 88, '2009-11-18 22:56:30', '2009-11-18 22:56:35', 'detail', 
'day', 3, 3, 1),
+(117, 12, 3, 89, '2009-11-18 22:56:42', '2009-11-18 22:57:04', 'detail', 
'day', 8, 3, 1),
+(118, 12, 3, 32, '2009-11-19 01:43:16', '2009-11-19 01:44:25', 'detail', 
'day', 9, 3, 1),
+(119, 12, 3, 33, '2009-11-19 07:45:03', '2009-11-19 07:46:04', 'detail', 
'day', 10, 3, 1),
+(120, 12, 3, 33, '2009-11-19 07:46:45', '2009-11-19 07:46:56', 'detail', 
'day', 10, 3, 1),
+(121, 12, 3, 32, '2009-11-19 12:14:21', '2009-11-19 12:14:24', 'detail', 
'day', 9, 3, 1),
+(122, 12, 3, 33, '2009-11-19 12:14:28', '2009-11-19 12:14:31', 'detail', 
'day', 10, 3, 1),
+(123, 12, 3, 33, '2009-11-19 12:14:32', '2009-11-19 12:14:44', 'detail', 
'day', 10, 3, 1),
+(124, 12, 3, 90, '2009-11-19 12:14:48', '2009-11-19 12:14:52', 'detail', 
'day', 1, 3, 1),
+(125, 12, 3, 5, '2009-11-19 12:14:56', '2009-11-19 12:15:01', 'detail', 'day', 
5, 3, 1),
+(126, 12, 3, 5, '2009-11-19 12:15:01', '2009-11-19 12:15:03', 'detail', 'day', 
5, 3, 1),
+(127, 12, 3, 89, '2009-11-19 12:15:09', '2009-11-19 12:15:15', 'detail', 
'day', 8, 3, 1),
+(128, 12, 3, 5, '2009-11-19 12:15:17', '2009-11-19 12:15:18', 'detail', 'day', 
5, 3, 1),
+(129, 12, 3, 89, '2009-11-19 12:15:21', '2009-11-19 12:15:34', 'detail', 
'day', 8, 3, 1),
+(130, 12, 3, 89, '2009-11-19 12:15:35', '2009-11-19 12:15:38', 'detail', 
'day', 8, 3, 1),
+(131, 12, 3, 88, '2009-11-19 12:15:51', '2009-11-19 12:16:52', 'detail', 
'day', 4, 3, 1),
+(132, 12, 3, 90, '2009-11-19 12:43:11', '2009-11-19 12:43:16', 'detail', 
'day', 1, 3, 1),
+(133, 12, 3, 90, '2009-11-19 12:59:44', '2009-11-19 13:01:08', 'detail', 
'day', 1, 3, 1),
+(134, 12, 3, 90, '2009-11-19 13:01:09', '2009-11-19 13:02:10', 'detail', 
'day', 1, 3, 1),
+(135, 12, 3, 88, '2009-11-19 13:23:52', '2009-11-19 13:23:54', 'detail', 
'day', 11, 3, 1),
+(136, 12, 3, 33, '2009-11-19 13:24:04', '2009-11-19 13:25:05', 'detail', 
'day', 10, 3, 1),
+(137, 12, 3, 88, '2009-11-19 13:41:55', '2009-11-19 13:41:57', 'detail', 
'day', 4, 3, 1),
+(138, 12, 3, 88, '2009-11-19 13:41:59', '2009-11-19 13:42:01', 'detail', 
'day', 4, 3, 1),
+(139, 12, 3, 5, '2009-11-19 13:42:02', '2009-11-19 13:42:05', 'detail', 'day', 
5, 3, 1),
+(140, 12, 3, 89, '2009-11-19 13:42:16', '2009-11-19 13:42:22', 'detail', 
'day', 8, 3, 1),
+(141, 12, 3, 32, '2009-11-19 13:42:27', '2009-11-19 13:42:30', 'detail', 
'day', 9, 3, 1),
+(142, 12, 3, 90, '2009-11-19 13:42:33', '2009-11-19 13:42:38', 'detail', 
'day', 1, 3, 1),
+(143, 12, 3, 88, '2009-11-19 13:42:48', '2009-11-19 13:42:50', 'detail', 
'day', 2, 3, 1),
+(144, 12, 3, 5, '2009-11-19 13:42:55', '2009-11-19 13:42:57', 'detail', 'day', 
5, 3, 1),
+(145, 12, 3, 33, '2009-11-19 14:21:32', '2009-11-19 14:21:46', 'detail', 
'day', 10, 3, 1),
+(146, 12, 3, 32, '2009-11-19 14:21:50', '2009-11-19 14:22:18', 'detail', 
'day', 9, 3, 1),
+(147, 12, 3, 88, '2009-11-19 16:29:10', '2009-11-19 16:29:14', 'detail', 
'day', 11, 3, 1),
+(148, 12, 3, 89, '2009-11-19 16:29:18', '2009-11-19 16:29:25', 'detail', 
'day', 8, 3, 1),
+(149, 12, 3, 5, '2009-11-19 16:29:36', '2009-11-19 16:29:40', 'detail', 'day', 
5, 3, 1),
+(150, 12, 3, 33, '2009-11-19 17:17:38', '2009-11-19 17:18:26', 'detail', 
'day', 10, 3, 1),
+(151, 12, 3, 33, '2009-11-19 17:18:28', '2009-11-19 17:19:08', 'detail', 
'day', 10, 3, 1),
+(152, 12, 3, 89, '2009-11-19 17:19:23', '2009-11-19 17:19:51', 'detail', 
'day', 8, 3, 1),
+(153, 12, 3, 90, '2009-11-19 17:19:56', '2009-11-19 17:20:14', 'detail', 
'day', 1, 3, 1),
+(154, 12, 3, 88, '2009-11-19 17:20:28', '2009-11-19 17:21:39', 'detail', 
'day', 2, 3, 1),
+(155, 12, 3, 89, '2009-11-19 17:23:42', '2009-11-19 17:24:01', 'detail', 
'day', 8, 3, 1),
+(156, 12, 3, 32, '2009-11-19 17:24:17', '2009-11-19 17:24:24', 'detail', 
'day', 9, 3, 1),
+(157, 12, 3, 5, '2009-11-19 17:24:52', '2009-11-19 17:26:20', 'detail', 'day', 
5, 3, 1),
+(158, 12, 3, 88, '2009-11-20 07:38:39', '2009-11-20 07:39:41', 'detail', 
'day', 12, 3, 1),
+(159, 12, 3, 90, '2009-11-20 07:42:47', '2009-11-20 07:43:48', 'detail', 
'day', 1, 3, 1),
+(160, 12, 3, 88, '2009-11-20 07:46:45', '2009-11-20 07:46:56', 'detail', 
'day', 3, 3, 1),
+(161, 12, 3, 88, '2009-11-20 07:47:07', '2009-11-20 07:47:15', 'detail', 
'day', 4, 3, 1),
+(162, 12, 3, 89, '2009-11-20 07:47:29', '2009-11-20 07:47:37', 'detail', 
'day', 8, 3, 1),
+(163, 12, 3, 5, '2009-11-20 07:47:47', '2009-11-20 07:48:48', 'detail', 'day', 
5, 3, 1),
+(164, 12, 3, 88, '2009-11-20 11:14:06', '2009-11-20 11:14:07', 'detail', 
'day', 12, 3, 1),
+(165, 12, 3, 88, '2009-11-20 11:14:09', '2009-11-20 11:14:14', 'detail', 
'day', 12, 3, 1),
+(166, 12, 3, 89, '2009-11-20 11:54:27', '2009-11-20 11:55:28', 'detail', 
'day', 8, 3, 1),
+(167, 12, 3, 88, '2009-11-20 12:27:29', '2009-11-20 12:28:45', 'detail', 
'day', 12, 3, 1),
+(168, 12, 3, 88, '2009-11-20 14:43:28', '2009-11-20 14:44:33', 'detail', 
'day', 12, 3, 1),
+(169, 12, 3, 88, '2009-11-20 14:45:53', '2009-11-20 14:46:54', 'detail', 
'day', 12, 3, 1),
+(170, 12, 3, 88, '2009-11-20 16:07:41', '2009-11-20 16:08:43', 'detail', 
'day', 12, 3, 1),
+(171, 12, 3, 32, '2009-11-20 16:09:14', '2009-11-20 16:09:30', 'detail', 
'day', 9, 3, 1),
+(172, 12, 3, 88, '2009-11-20 19:30:44', '2009-11-20 19:30:46', 'detail', 
'day', 4, 3, 1),
+(173, 12, 3, 89, '2009-11-20 21:34:19', '2009-11-20 21:34:28', 'detail', 
'day', 8, 3, 1),
+(174, 12, 3, 5, '2009-11-20 23:35:15', '2009-11-20 23:36:16', 'detail', 'day', 
5, 3, 1),
+(175, 12, 3, 33, '2009-11-21 01:47:33', '2009-11-21 01:47:36', 'detail', 
'day', 10, 3, 1),
+(176, 12, 3, 32, '2009-11-21 01:47:40', '2009-11-21 01:47:44', 'detail', 
'day', 9, 3, 1),
+(177, 12, 3, 89, '2009-11-21 01:47:46', '2009-11-21 01:47:56', 'detail', 
'day', 8, 3, 1),
+(178, 12, 3, 90, '2009-11-21 01:47:59', '2009-11-21 01:48:12', 'detail', 
'day', 1, 3, 1),
+(179, 12, 3, 5, '2009-11-21 01:48:17', '2009-11-21 01:48:21', 'detail', 'day', 
5, 3, 1),
+(180, 12, 3, 88, '2009-11-21 01:48:25', '2009-11-21 01:48:30', 'detail', 
'day', 12, 3, 1),
+(181, 12, 3, 32, '2009-11-21 01:56:50', '2009-11-21 01:57:45', 'detail', 
'day', 9, 3, 1),
+(182, 12, 3, 33, '2009-11-21 01:57:54', '2009-11-21 01:58:57', 'detail', 
'day', 10, 3, 1),
+(183, 12, 3, 88, '2009-11-21 10:10:30', '2009-11-21 10:10:35', 'detail', 
'day', 3, 3, 1),
+(184, 12, 3, 33, '2009-11-21 14:55:17', '2009-11-21 14:55:20', 'detail', 
'day', 10, 3, 1),
+(185, 12, 3, 33, '2009-11-21 14:55:24', '2009-11-21 14:56:00', 'detail', 
'day', 10, 3, 1),
+(186, 12, 3, 88, '2009-11-21 15:07:05', '2009-11-21 15:08:06', 'detail', 
'day', 12, 3, 1),
+(187, 12, 3, 90, '2009-11-21 15:32:55', '2009-11-21 15:33:14', 'detail', 
'day', 1, 3, 1),
+(188, 12, 3, 89, '2009-11-21 15:33:16', '2009-11-21 15:33:26', 'detail', 
'day', 8, 3, 1),
+(189, 12, 3, 5, '2009-11-21 15:33:37', '2009-11-21 15:33:42', 'detail', 'day', 
5, 3, 1),
+(190, 12, 3, 90, '2009-11-21 15:33:48', '2009-11-21 15:33:53', 'detail', 
'day', 1, 3, 1),
+(191, 12, 3, 88, '2009-11-21 15:53:13', '2009-11-21 15:53:17', 'detail', 
'day', 4, 3, 1),
+(192, 12, 3, 88, '2009-11-21 16:04:14', '2009-11-21 16:04:24', 'detail', 
'day', 4, 3, 1),
+(193, 12, 3, 88, '2009-11-21 16:04:43', '2009-11-21 16:05:13', 'detail', 
'day', 2, 3, 1),
+(194, 12, 3, 88, '2009-11-21 18:27:08', '2009-11-21 18:28:18', 'detail', 
'day', 2, 3, 1),
+(195, 12, 3, 88, '2009-11-21 19:10:20', '2009-11-21 19:10:21', 'detail', 
'day', 4, 3, 1),
+(196, 12, 3, 5, '2009-11-21 19:10:22', '2009-11-21 19:11:23', 'detail', 'day', 
5, 3, 1),
+(197, 12, 3, 5, '2009-11-21 19:29:36', '2009-11-21 19:30:54', 'detail', 'day', 
5, 3, 1),
+(198, 12, 3, 88, '2009-11-21 21:15:20', '2009-11-21 21:15:21', 'detail', 
'day', 11, 3, 1),
+(199, 12, 3, 88, '2009-11-21 21:15:22', '2009-11-21 21:16:23', 'detail', 
'day', 11, 3, 1),
+(200, 12, 3, 32, '2009-11-21 22:20:15', '2009-11-21 22:20:17', 'detail', 
'day', 9, 3, 1),
+(201, 12, 3, 90, '2009-11-21 22:20:25', '2009-11-21 22:20:27', 'detail', 
'day', 1, 3, 1),
+(202, 12, 3, 5, '2009-11-21 22:44:04', '2009-11-21 22:44:08', 'detail', 'day', 
5, 3, 1),
+(203, 12, 3, 88, '2009-11-22 08:54:09', '2009-11-22 08:54:09', 'detail', 
'day', 12, 3, 1),
+(204, 12, 3, 32, '2009-11-22 08:56:48', '2009-11-22 08:58:20', 'detail', 
'day', 9, 3, 1),
+(205, 12, 3, 5, '2009-11-22 11:01:33', '2009-11-22 11:01:40', 'detail', 'day', 
5, 3, 1),
+(206, 12, 3, 5, '2009-11-22 11:58:44', '2009-11-22 11:59:54', 'detail', 'day', 
5, 3, 1),
+(207, 12, 3, 5, '2009-11-22 13:39:28', '2009-11-22 13:40:49', 'detail', 'day', 
5, 3, 1),
+(208, 12, 3, 5, '2009-11-22 14:06:05', '2009-11-22 14:07:11', 'detail', 'day', 
5, 3, 1),
+(209, 12, 3, 33, '2009-11-22 14:27:04', '2009-11-22 14:27:12', 'detail', 
'day', 10, 3, 1),
+(210, 12, 3, 33, '2009-11-22 14:27:13', '2009-11-22 14:27:15', 'detail', 
'day', 10, 3, 1),
+(211, 12, 3, 89, '2009-11-22 14:27:20', '2009-11-22 14:27:25', 'detail', 
'day', 8, 3, 1),
+(212, 12, 3, 89, '2009-11-22 15:28:29', '2009-11-22 15:28:30', 'detail', 
'day', 8, 3, 1),
+(213, 12, 3, 89, '2009-11-22 15:28:34', '2009-11-22 15:28:45', 'detail', 
'day', 8, 3, 1),
+(214, 12, 3, 89, '2009-11-22 15:28:48', '2009-11-22 15:29:03', 'detail', 
'day', 8, 3, 1),
+(215, 12, 3, 89, '2009-11-22 15:29:05', '2009-11-22 15:29:09', 'detail', 
'day', 8, 3, 1),
+(216, 12, 3, 89, '2009-11-22 15:29:10', '2009-11-22 15:29:17', 'detail', 
'day', 8, 3, 1),
+(217, 12, 3, 89, '2009-11-22 15:29:18', '2009-11-22 15:29:33', 'detail', 
'day', 8, 3, 1),
+(218, 12, 3, 89, '2009-11-22 15:29:49', '2009-11-22 15:30:20', 'detail', 
'day', 8, 3, 1),
+(219, 12, 3, 89, '2009-11-22 15:30:22', '2009-11-22 15:30:49', 'detail', 
'day', 8, 3, 1),
+(220, 12, 3, 89, '2009-11-22 15:30:50', '2009-11-22 15:30:50', 'detail', 
'day', 8, 3, 1),
+(221, 12, 3, 89, '2009-11-22 15:33:03', '2009-11-22 15:33:19', 'detail', 
'day', 8, 3, 1),
+(222, 12, 3, 33, '2009-11-22 16:03:57', '2009-11-22 16:04:06', 'detail', 
'day', 10, 3, 1),
+(223, 12, 3, 89, '2009-11-22 16:04:13', '2009-11-22 16:04:19', 'detail', 
'day', 8, 3, 1),
+(224, 12, 3, 89, '2009-11-22 19:50:13', '2009-11-22 19:50:17', 'detail', 
'day', 8, 3, 1),
+(225, 12, 3, 32, '2009-11-22 23:23:26', '2009-11-22 23:23:27', 'detail', 
'day', 9, 3, 1),
+(226, 12, 3, 32, '2009-11-22 23:23:28', '2009-11-22 23:24:46', 'detail', 
'day', 9, 3, 1),
+(227, 12, 3, 89, '2009-11-23 07:43:08', '2009-11-23 07:44:26', 'detail', 
'day', 8, 3, 1),
+(228, 12, 3, 32, '2009-11-23 08:20:14', '2009-11-23 08:20:25', 'detail', 
'day', 9, 3, 1),
+(229, 12, 3, 32, '2009-11-23 08:20:27', '2009-11-23 08:20:31', 'detail', 
'day', 9, 3, 1),
+(230, 12, 3, 89, '2009-11-23 09:10:55', '2009-11-23 09:11:15', 'detail', 
'day', 8, 3, 1),
+(231, 12, 3, 32, '2009-11-23 13:37:40', '2009-11-23 13:38:58', 'detail', 
'day', 9, 3, 1),
+(232, 12, 3, 32, '2009-11-23 14:47:13', '2009-11-23 14:47:14', 'detail', 
'day', 9, 3, 1),
+(233, 12, 3, 88, '2009-11-23 14:47:15', '2009-11-23 14:48:21', 'detail', 
'day', 11, 3, 1),
+(234, 12, 3, 33, '2009-11-23 14:55:52', '2009-11-23 14:56:05', 'detail', 
'day', 10, 3, 1),
+(235, 12, 3, 32, '2009-11-23 14:56:08', '2009-11-23 14:56:14', 'detail', 
'day', 9, 3, 1),
+(236, 12, 3, 88, '2009-11-23 14:56:20', '2009-11-23 14:56:22', 'detail', 
'day', 12, 3, 1),
+(237, 12, 3, 88, '2009-11-23 14:56:23', '2009-11-23 14:56:33', 'detail', 
'day', 12, 3, 1),
+(238, 12, 3, 89, '2009-11-23 14:56:36', '2009-11-23 14:56:49', 'detail', 
'day', 8, 3, 1),
+(239, 12, 3, 32, '2009-11-23 14:56:59', '2009-11-23 14:57:02', 'detail', 
'day', 9, 3, 1),
+(240, 12, 3, 33, '2009-11-23 15:23:26', '2009-11-23 15:23:34', 'detail', 
'day', 10, 3, 1),
+(241, 12, 3, 5, '2009-11-23 15:23:45', '2009-11-23 15:23:50', 'detail', 'day', 
5, 3, 1),
+(242, 12, 3, 33, '2009-11-23 15:24:08', '2009-11-23 15:24:18', 'detail', 
'day', 10, 3, 1),
+(243, 12, 3, 33, '2009-11-23 15:24:19', '2009-11-23 15:24:22', 'detail', 
'day', 10, 3, 1),
+(244, 12, 3, 32, '2009-11-23 15:24:26', '2009-11-23 15:24:39', 'detail', 
'day', 9, 3, 1),
+(245, 12, 3, 90, '2009-11-23 15:24:58', '2009-11-23 15:25:22', 'detail', 
'day', 1, 3, 1),
+(246, 12, 3, 90, '2009-11-23 15:25:25', '2009-11-23 15:25:35', 'detail', 
'day', 1, 3, 1),
+(247, 12, 3, 90, '2009-11-23 15:25:36', '2009-11-23 15:25:39', 'detail', 
'day', 1, 3, 1),
+(248, 12, 3, 90, '2009-11-23 15:25:40', '2009-11-23 15:25:41', 'detail', 
'day', 1, 3, 1),
+(249, 12, 3, 89, '2009-11-23 15:25:43', '2009-11-23 15:25:54', 'detail', 
'day', 8, 3, 1),
+(250, 12, 3, 89, '2009-11-23 15:25:54', '2009-11-23 15:26:12', 'detail', 
'day', 8, 3, 1),
+(251, 12, 3, 89, '2009-11-23 15:58:26', '2009-11-23 15:58:29', 'detail', 
'day', 8, 3, 1),
+(252, 12, 3, 32, '2009-11-23 15:58:37', '2009-11-23 15:58:43', 'detail', 
'day', 9, 3, 1),
+(253, 12, 3, 33, '2009-11-23 15:58:48', '2009-11-23 15:58:58', 'detail', 
'day', 10, 3, 1),
+(254, 12, 3, 33, '2009-11-23 17:17:01', '2009-11-23 17:17:05', 'detail', 
'day', 10, 3, 1),
+(255, 12, 3, 32, '2009-11-23 17:17:10', '2009-11-23 17:17:18', 'detail', 
'day', 9, 3, 1),
+(256, 12, 3, 5, '2009-11-23 18:10:28', '2009-11-23 18:10:32', 'detail', 'day', 
5, 3, 1),
+(257, 12, 3, 5, '2009-11-23 18:53:59', '2009-11-23 18:54:00', 'detail', 'day', 
5, 3, 1),
+(258, 12, 3, 5, '2009-11-23 18:54:01', '2009-11-23 18:55:06', 'detail', 'day', 
5, 3, 1),
+(259, 12, 3, 88, '2009-11-23 19:15:34', '2009-11-23 19:15:36', 'detail', 
'day', 2, 3, 1),
+(260, 12, 3, 88, '2009-11-23 19:15:39', '2009-11-23 19:15:39', 'detail', 
'day', 3, 3, 1),
+(261, 12, 3, 88, '2009-11-23 19:15:42', '2009-11-23 19:16:43', 'detail', 
'day', 3, 3, 1),
+(262, 12, 3, 88, '2009-11-24 01:38:27', '2009-11-24 01:40:23', 'detail', 
'day', 12, 3, 1),
+(263, 12, 3, 33, '2009-11-24 01:40:32', '2009-11-24 01:40:52', 'detail', 
'day', 10, 3, 1),
+(264, 12, 3, 32, '2009-11-24 01:40:55', '2009-11-24 01:41:56', 'detail', 
'day', 9, 3, 1),
+(265, 12, 3, 5, '2009-11-24 05:50:17', '2009-11-24 05:50:25', 'detail', 'day', 
5, 3, 1),
+(266, 12, 3, 88, '2009-11-24 07:19:29', '2009-11-24 07:19:32', 'detail', 
'day', 3, 3, 1),
+(267, 12, 3, 88, '2009-11-24 07:43:12', '2009-11-24 07:45:09', 'detail', 
'day', 11, 3, 1),
+(268, 12, 3, 88, '2009-11-24 07:46:24', '2009-11-24 07:46:31', 'detail', 
'day', 11, 3, 1),
+(269, 12, 3, 88, '2009-11-24 07:50:59', '2009-11-24 07:52:03', 'detail', 
'day', 2, 3, 1),
+(270, 12, 3, 88, '2009-11-24 08:00:08', '2009-11-24 08:01:11', 'detail', 
'day', 4, 3, 1),
+(271, 12, 3, 5, '2009-11-24 09:55:53', '2009-11-24 09:56:10', 'detail', 'day', 
5, 3, 1),
+(272, 12, 3, 5, '2009-11-24 10:17:51', '2009-11-24 10:19:25', 'detail', 'day', 
5, 3, 1),
+(273, 12, 3, 5, '2009-11-24 13:58:08', '2009-11-24 13:58:10', 'detail', 'day', 
5, 3, 1),
+(274, 12, 3, 88, '2009-11-24 13:58:15', '2009-11-24 13:58:18', 'detail', 
'day', 2, 3, 1),
+(275, 12, 3, 33, '2009-11-24 13:58:30', '2009-11-24 13:58:45', 'detail', 
'day', 10, 3, 1),
+(276, 12, 3, 89, '2009-11-24 13:58:49', '2009-11-24 13:58:56', 'detail', 
'day', 8, 3, 1),
+(277, 12, 3, 89, '2009-11-24 13:58:57', '2009-11-24 14:00:19', 'detail', 
'day', 8, 3, 1),
+(278, 12, 3, 33, '2009-11-24 14:07:32', '2009-11-24 14:07:38', 'detail', 
'day', 10, 3, 1),
+(279, 12, 3, 88, '2009-11-24 14:33:09', '2009-11-24 14:34:11', 'detail', 
'day', 11, 3, 1),
+(280, 12, 3, 88, '2009-11-24 14:54:45', '2009-11-24 14:54:49', 'detail', 
'day', 12, 3, 1),
+(281, 12, 3, 33, '2009-11-24 14:54:53', '2009-11-24 14:54:56', 'detail', 
'day', 10, 3, 1),
+(282, 12, 3, 33, '2009-11-24 14:54:58', '2009-11-24 14:55:00', 'detail', 
'day', 10, 3, 1),
+(283, 12, 3, 32, '2009-11-24 14:55:05', '2009-11-24 14:55:11', 'detail', 
'day', 9, 3, 1),
+(284, 12, 3, 89, '2009-11-24 14:55:18', '2009-11-24 14:55:26', 'detail', 
'day', 8, 3, 1),
+(285, 12, 3, 32, '2009-11-24 16:36:33', '2009-11-24 16:36:38', 'detail', 
'day', 9, 3, 1),
+(286, 12, 3, 33, '2009-11-24 16:36:42', '2009-11-24 16:36:46', 'detail', 
'day', 10, 3, 1),
+(287, 12, 3, 88, '2009-11-24 16:36:50', '2009-11-24 16:36:55', 'detail', 
'day', 11, 3, 1),
+(288, 12, 3, 88, '2009-11-24 16:37:00', '2009-11-24 16:37:04', 'detail', 
'day', 12, 3, 1),
+(289, 12, 3, 88, '2009-11-24 16:37:09', '2009-11-24 16:38:10', 'detail', 
'day', 12, 3, 1),
+(290, 12, 3, 33, '2009-11-24 17:07:10', '2009-11-24 17:07:15', 'detail', 
'day', 10, 3, 1),
+(291, 12, 3, 5, '2009-11-24 17:07:25', '2009-11-24 17:08:26', 'detail', 'day', 
5, 3, 1),
+(292, 12, 3, 88, '2009-11-24 17:21:36', '2009-11-24 17:21:49', 'detail', 
'day', 11, 3, 1),
+(293, 12, 3, 89, '2009-11-24 17:21:54', '2009-11-24 17:23:09', 'detail', 
'day', 8, 3, 1),
+(294, 12, 3, 89, '2009-11-24 17:31:13', '2009-11-24 17:31:16', 'detail', 
'day', 8, 3, 1),
+(295, 12, 3, 32, '2009-11-24 17:55:17', '2009-11-24 17:55:44', 'detail', 
'day', 9, 3, 1),
+(296, 12, 3, 32, '2009-11-24 18:04:29', '2009-11-24 18:05:30', 'detail', 
'day', 9, 3, 1),
+(297, 12, 3, 89, '2009-11-24 18:21:12', '2009-11-24 18:22:24', 'detail', 
'day', 8, 3, 1),
+(298, 12, 3, 88, '2009-11-24 18:39:59', '2009-11-24 18:40:01', 'detail', 
'day', 12, 3, 1),
+(299, 12, 3, 88, '2009-11-24 18:48:25', '2009-11-24 18:49:26', 'detail', 
'day', 4, 3, 1),
+(300, 12, 3, 88, '2009-11-24 19:39:42', '2009-11-24 19:40:48', 'detail', 
'day', 4, 3, 1),
+(301, 12, 3, 88, '2009-11-25 07:34:53', '2009-11-25 07:35:54', 'detail', 
'day', 3, 3, 1),
+(302, 12, 3, 90, '2009-11-25 07:36:46', '2009-11-25 07:37:07', 'detail', 
'day', 1, 3, 1),
+(303, 12, 3, 5, '2009-11-25 07:37:52', '2009-11-25 07:38:10', 'detail', 'day', 
5, 3, 1),
+(304, 12, 3, 88, '2009-11-25 12:50:43', '2009-11-25 12:51:55', 'detail', 
'day', 3, 3, 1),
+(305, 12, 3, 5, '2009-11-25 12:52:44', '2009-11-25 12:52:53', 'detail', 'day', 
5, 3, 1),
+(306, 12, 3, 88, '2009-11-25 12:52:55', '2009-11-25 12:53:03', 'detail', 
'day', 4, 3, 1),
+(307, 12, 3, 5, '2009-11-25 12:53:05', '2009-11-25 12:54:21', 'detail', 'day', 
5, 3, 1),
+(308, 12, 3, 5, '2009-11-25 13:15:45', '2009-11-25 13:17:32', 'detail', 'day', 
5, 3, 1),
+(309, 12, 3, 5, '2009-11-25 14:59:32', '2009-11-25 14:59:37', 'detail', 'day', 
5, 3, 1),
+(310, 12, 3, 33, '2009-11-25 14:59:46', '2009-11-25 14:59:50', 'detail', 
'day', 10, 3, 1),
+(311, 12, 3, 88, '2009-11-25 14:59:52', '2009-11-25 14:59:55', 'detail', 
'day', 3, 3, 1),
+(312, 12, 3, 88, '2009-11-25 14:59:57', '2009-11-25 15:00:04', 'detail', 
'day', 3, 3, 1),
+(313, 12, 3, 88, '2009-11-25 15:00:16', '2009-11-25 15:00:19', 'detail', 
'day', 4, 3, 1),
+(314, 12, 3, 33, '2009-11-25 15:00:25', '2009-11-25 15:00:30', 'detail', 
'day', 10, 3, 1),
+(315, 12, 3, 32, '2009-11-25 16:07:22', '2009-11-25 16:07:24', 'detail', 
'day', 9, 3, 1),
+(316, 12, 3, 88, '2009-11-25 16:07:27', '2009-11-25 16:07:29', 'detail', 
'day', 12, 3, 1),
+(317, 12, 3, 88, '2009-11-25 16:10:12', '2009-11-25 16:10:18', 'detail', 
'day', 11, 3, 1),
+(318, 12, 3, 88, '2009-11-25 16:10:22', '2009-11-25 16:10:24', 'detail', 
'day', 12, 3, 1),
+(319, 12, 3, 88, '2009-11-25 16:27:35', '2009-11-25 16:27:53', 'detail', 
'day', 12, 3, 1),
+(320, 12, 3, 88, '2009-11-25 16:28:02', '2009-11-25 16:28:21', 'detail', 
'day', 12, 3, 1),
+(321, 12, 3, 5, '2009-11-25 16:29:09', '2009-11-25 16:30:10', 'detail', 'day', 
5, 3, 1),
+(322, 12, 3, 5, '2009-11-25 16:34:51', '2009-11-25 16:37:36', 'detail', 'day', 
5, 3, 1),
+(323, 12, 3, 5, '2009-11-25 16:43:37', '2009-11-25 16:44:16', 'detail', 'day', 
5, 3, 1),
+(324, 12, 3, 89, '2009-11-25 17:06:18', '2009-11-25 17:06:21', 'detail', 
'day', 8, 3, 1),
+(325, 12, 3, 32, '2009-11-25 17:06:31', '2009-11-25 17:06:39', 'detail', 
'day', 9, 3, 1),
+(326, 12, 3, 89, '2009-11-25 19:19:02', '2009-11-25 19:19:02', 'detail', 
'day', 8, 3, 1),
+(327, 12, 3, 89, '2009-11-25 19:19:07', '2009-11-25 19:19:10', 'detail', 
'day', 8, 3, 1),
+(328, 12, 3, 89, '2009-11-25 19:19:14', '2009-11-25 19:19:18', 'detail', 
'day', 8, 3, 1),
+(329, 12, 3, 89, '2009-11-25 19:19:24', '2009-11-25 19:19:32', 'detail', 
'day', 8, 3, 1),
+(330, 12, 3, 88, '2009-11-25 19:19:51', '2009-11-25 19:19:58', 'detail', 
'day', 2, 3, 1),
+(331, 12, 3, 88, '2009-11-25 19:19:59', '2009-11-25 19:20:01', 'detail', 
'day', 2, 3, 1),
+(332, 12, 3, 89, '2009-11-25 19:20:07', '2009-11-25 19:20:52', 'detail', 
'day', 8, 3, 1),
+(333, 12, 3, 89, '2009-11-25 19:20:55', '2009-11-25 19:22:17', 'detail', 
'day', 8, 3, 1),
+(334, 12, 3, 32, '2009-11-25 21:33:24', '2009-11-25 21:33:27', 'detail', 
'day', 9, 3, 1),
+(335, 12, 3, 33, '2009-11-25 21:33:31', '2009-11-25 21:34:32', 'detail', 
'day', 10, 3, 1),
+(336, 12, 3, 88, '2009-11-26 02:47:39', '2009-11-26 02:47:43', 'detail', 
'day', 12, 3, 1),
+(337, 12, 3, 88, '2009-11-26 02:47:44', '2009-11-26 02:49:50', 'detail', 
'day', 12, 3, 1),
+(338, 12, 3, 88, '2009-11-26 07:43:57', '2009-11-26 07:43:58', 'detail', 
'day', 2, 3, 1),
+(339, 12, 3, 90, '2009-11-26 07:44:42', '2009-11-26 07:45:14', 'detail', 
'day', 1, 3, 1),
+(340, 12, 3, 89, '2009-11-26 07:45:48', '2009-11-26 07:45:53', 'detail', 
'day', 8, 3, 1),
+(341, 12, 3, 33, '2009-11-26 09:48:16', '2009-11-26 09:48:20', 'detail', 
'day', 10, 3, 1),
+(342, 12, 3, 5, '2009-11-26 12:17:24', '2009-11-26 12:17:28', 'detail', 'day', 
5, 3, 1),
+(343, 12, 3, 33, '2009-11-26 12:17:35', '2009-11-26 12:17:37', 'detail', 
'day', 10, 3, 1),
+(344, 12, 3, 88, '2009-11-26 14:32:29', '2009-11-26 14:32:32', 'detail', 
'day', 11, 3, 1),
+(345, 12, 3, 33, '2009-11-26 14:32:35', '2009-11-26 14:32:38', 'detail', 
'day', 10, 3, 1),
+(346, 12, 3, 89, '2009-11-26 14:42:49', '2009-11-26 14:43:12', 'detail', 
'day', 8, 3, 1),
+(347, 12, 3, 88, '2009-11-26 14:43:20', '2009-11-26 14:43:27', 'detail', 
'day', 12, 3, 1),
+(348, 12, 3, 88, '2009-11-26 15:26:31', '2009-11-26 15:26:35', 'detail', 
'day', 12, 3, 1),
+(349, 12, 3, 89, '2009-11-26 15:46:38', '2009-11-26 15:47:29', 'detail', 
'day', 8, 3, 1),
+(350, 12, 3, 32, '2009-11-26 15:47:36', '2009-11-26 15:47:46', 'detail', 
'day', 9, 3, 1),
+(351, 12, 3, 90, '2009-11-26 15:48:00', '2009-11-26 15:48:13', 'detail', 
'day', 1, 3, 1),
+(352, 12, 3, 88, '2009-11-26 15:48:35', '2009-11-26 15:48:43', 'detail', 
'day', 12, 3, 1),
+(353, 12, 3, 33, '2009-11-26 15:48:49', '2009-11-26 15:49:27', 'detail', 
'day', 10, 3, 1),
+(354, 12, 3, 88, '2009-11-26 17:25:46', '2009-11-26 17:25:51', 'detail', 
'day', 11, 3, 1),
+(355, 12, 3, 33, '2009-11-26 17:26:03', '2009-11-26 17:26:14', 'detail', 
'day', 10, 3, 1),
+(356, 12, 3, 32, '2009-11-26 17:26:18', '2009-11-26 17:26:20', 'detail', 
'day', 9, 3, 1),
+(357, 12, 3, 89, '2009-11-26 17:26:22', '2009-11-26 17:27:23', 'detail', 
'day', 8, 3, 1),
+(358, 12, 3, 88, '2009-11-26 17:39:25', '2009-11-26 17:40:50', 'detail', 
'day', 12, 3, 1),
+(359, 12, 3, 89, '2009-11-26 17:43:48', '2009-11-26 17:43:55', 'detail', 
'day', 8, 3, 1),
+(360, 12, 3, 89, '2009-11-26 17:43:58', '2009-11-26 17:44:00', 'detail', 
'day', 8, 3, 1),
+(361, 12, 3, 89, '2009-11-26 17:44:03', '2009-11-26 17:45:04', 'detail', 
'day', 8, 3, 1),
+(362, 12, 3, 89, '2009-11-26 17:50:45', '2009-11-26 17:51:46', 'detail', 
'day', 8, 3, 1),
+(363, 12, 3, 89, '2009-11-26 18:01:14', '2009-11-26 18:03:16', 'detail', 
'day', 8, 3, 1),
+(364, 12, 3, 89, '2009-11-26 18:44:03', '2009-11-26 18:45:04', 'detail', 
'day', 8, 3, 1),
+(365, 12, 3, 89, '2009-11-26 19:39:39', '2009-11-26 19:39:55', 'detail', 
'day', 8, 3, 1),
+(366, 12, 3, 33, '2009-11-26 19:40:12', '2009-11-26 19:40:22', 'detail', 
'day', 10, 3, 1),
+(367, 13, 1, 90, '2009-11-26 21:48:40', '2009-11-26 21:48:42', 'exhibit', 
'day', 1, 1, 1),
+(368, 12, 3, 90, '2009-11-26 23:33:17', '2009-11-26 23:35:12', 'detail', 
'day', 1, 3, 1),
+(369, 12, 3, 89, '2009-11-26 23:59:21', '2009-11-26 23:59:33', 'detail', 
'day', 8, 3, 1),
+(370, 12, 3, 88, '2009-11-27 07:02:44', '2009-11-27 07:04:10', 'detail', 
'day', 12, 3, 1),
+(371, 12, 3, 88, '2009-11-27 07:17:38', '2009-11-27 07:18:39', 'detail', 
'day', 12, 3, 1),
+(372, 12, 3, 88, '2009-11-27 07:36:51', '2009-11-27 07:37:17', 'detail', 
'day', 12, 3, 1),
+(373, 12, 3, 88, '2009-11-27 07:37:23', '2009-11-27 07:39:16', 'detail', 
'day', 12, 3, 1),
+(374, 12, 3, 89, '2009-11-27 07:39:25', '2009-11-27 07:40:22', 'detail', 
'day', 8, 3, 1),
+(375, 12, 3, 33, '2009-11-27 08:15:57', '2009-11-27 08:16:02', 'detail', 
'day', 10, 3, 1),
+(376, 12, 3, 33, '2009-11-27 08:16:10', '2009-11-27 08:17:12', 'detail', 
'day', 10, 3, 1),
+(377, 12, 3, 33, '2009-11-27 10:32:15', '2009-11-27 10:32:23', 'detail', 
'day', 10, 3, 1),
+(378, 12, 3, 33, '2009-11-27 10:32:24', '2009-11-27 10:33:37', 'detail', 
'day', 10, 3, 1),
+(379, 12, 3, 88, '2009-11-27 11:19:57', '2009-11-27 11:20:08', 'detail', 
'day', 11, 3, 1),
+(380, 12, 3, 33, '2009-11-27 11:20:24', '2009-11-27 11:20:38', 'detail', 
'day', 10, 3, 1),
+(381, 12, 3, 33, '2009-11-27 12:45:44', '2009-11-27 12:45:48', 'detail', 
'day', 10, 3, 1),
+(382, 12, 3, 88, '2009-11-27 12:45:54', '2009-11-27 12:46:58', 'detail', 
'day', 12, 3, 1),
+(383, 12, 3, 88, '2009-11-27 14:07:30', '2009-11-27 14:07:52', 'detail', 
'day', 11, 3, 1),
+(384, 12, 3, 33, '2009-11-27 14:08:02', '2009-11-27 14:09:46', 'detail', 
'day', 10, 3, 1),
+(385, 12, 3, 89, '2009-11-27 14:54:52', '2009-11-27 14:55:53', 'detail', 
'day', 8, 3, 1),
+(386, 12, 3, 89, '2009-11-27 14:56:16', '2009-11-27 14:57:17', 'detail', 
'day', 8, 3, 1),
+(387, 12, 3, 32, '2009-11-27 15:01:23', '2009-11-27 15:01:30', 'detail', 
'day', 9, 3, 1),
+(388, 12, 3, 5, '2009-11-27 17:33:15', '2009-11-27 17:34:41', 'detail', 'day', 
5, 3, 1),
+(389, 12, 3, 5, '2009-11-27 18:00:41', '2009-11-27 18:01:42', 'detail', 'day', 
5, 3, 1),
+(390, 12, 3, 5, '2009-11-27 18:12:41', '2009-11-27 18:14:08', 'detail', 'day', 
5, 3, 1),
+(391, 12, 3, 89, '2009-11-27 18:14:42', '2009-11-27 18:16:12', 'detail', 
'day', 8, 3, 1),
+(392, 12, 3, 89, '2009-11-27 18:18:10', '2009-11-27 18:18:23', 'detail', 
'day', 8, 3, 1),
+(393, 12, 3, 89, '2009-11-27 18:27:54', '2009-11-27 18:28:20', 'detail', 
'day', 8, 3, 1),
+(394, 12, 3, 33, '2009-11-27 18:28:26', '2009-11-27 18:28:29', 'detail', 
'day', 10, 3, 1),
+(395, 12, 3, 32, '2009-11-27 18:28:32', '2009-11-27 18:28:41', 'detail', 
'day', 9, 3, 1),
+(396, 12, 3, 88, '2009-11-27 18:31:37', '2009-11-27 18:31:39', 'detail', 
'day', 11, 3, 1),
+(397, 12, 3, 88, '2009-11-27 19:30:03', '2009-11-27 19:31:14', 'detail', 
'day', 12, 3, 1),
+(398, 12, 3, 88, '2009-11-27 22:13:15', '2009-11-27 22:14:35', 'detail', 
'day', 12, 3, 1),
+(399, 12, 3, 88, '2009-11-28 00:03:19', '2009-11-28 00:03:30', 'detail', 
'day', 12, 3, 1),
+(400, 12, 3, 32, '2009-11-28 00:03:39', '2009-11-28 00:04:02', 'detail', 
'day', 9, 3, 1),
+(401, 12, 3, 89, '2009-11-28 00:04:06', '2009-11-28 00:04:27', 'detail', 
'day', 8, 3, 1),
+(402, 12, 3, 33, '2009-11-28 00:05:24', '2009-11-28 00:05:38', 'detail', 
'day', 10, 3, 1),
+(403, 12, 3, 32, '2009-11-28 00:05:45', '2009-11-28 00:05:49', 'detail', 
'day', 9, 3, 1),
+(404, 12, 3, 90, '2009-11-28 00:25:37', '2009-11-28 00:25:50', 'detail', 
'day', 1, 3, 1),
+(405, 12, 3, 90, '2009-11-28 00:26:42', '2009-11-28 00:26:43', 'detail', 
'day', 1, 3, 1),
+(406, 12, 3, 88, '2009-11-28 00:32:22', '2009-11-28 00:33:23', 'detail', 
'day', 12, 3, 1),
+(407, 12, 3, 33, '2009-11-28 00:55:19', '2009-11-28 00:56:20', 'detail', 
'day', 10, 3, 1),
+(408, 12, 3, 5, '2009-11-28 09:55:08', '2009-11-28 09:55:41', 'detail', 'day', 
5, 3, 1),
+(409, 12, 3, 89, '2009-11-28 09:55:56', '2009-11-28 09:56:10', 'detail', 
'day', 8, 3, 1),
+(410, 12, 3, 33, '2009-11-28 09:56:15', '2009-11-28 09:57:23', 'detail', 
'day', 10, 3, 1),
+(411, 12, 3, 90, '2009-11-28 14:27:21', '2009-11-28 14:27:32', 'detail', 
'day', 1, 3, 1),
+(412, 12, 3, 88, '2009-11-28 15:00:36', '2009-11-28 15:01:57', 'detail', 
'day', 12, 3, 1),
+(413, 12, 3, 33, '2009-11-28 17:17:06', '2009-11-28 17:17:21', 'detail', 
'day', 10, 3, 1),
+(414, 12, 3, 90, '2009-11-28 17:17:26', '2009-11-28 17:18:27', 'detail', 
'day', 1, 3, 1),
+(415, 12, 3, 89, '2009-11-28 17:58:23', '2009-11-28 17:59:40', 'detail', 
'day', 8, 3, 1),
+(416, 12, 3, 32, '2009-11-28 18:01:25', '2009-11-28 18:01:33', 'detail', 
'day', 9, 3, 1),
+(417, 12, 3, 89, '2009-11-28 18:01:47', '2009-11-28 18:01:52', 'detail', 
'day', 8, 3, 1),
+(418, 12, 3, 88, '2009-11-28 18:11:56', '2009-11-28 18:11:59', 'detail', 
'day', 12, 3, 1),
+(419, 12, 3, 89, '2009-11-28 18:12:08', '2009-11-28 18:12:12', 'detail', 
'day', 8, 3, 1),
+(420, 12, 3, 89, '2009-11-28 18:12:14', '2009-11-28 18:12:36', 'detail', 
'day', 8, 3, 1),
+(421, 12, 3, 89, '2009-11-28 18:12:38', '2009-11-28 18:12:41', 'detail', 
'day', 8, 3, 1),
+(422, 12, 3, 32, '2009-11-28 18:13:00', '2009-11-28 18:13:18', 'detail', 
'day', 9, 3, 1),
+(423, 12, 3, 32, '2009-11-28 18:13:19', '2009-11-28 18:14:20', 'detail', 
'day', 9, 3, 1),
+(424, 12, 3, 89, '2009-11-28 18:48:43', '2009-11-28 18:49:02', 'detail', 
'day', 8, 3, 1),
+(425, 12, 3, 88, '2009-11-28 18:49:06', '2009-11-28 18:49:12', 'detail', 
'day', 12, 3, 1),
+(426, 12, 3, 88, '2009-11-28 18:49:15', '2009-11-28 18:49:19', 'detail', 
'day', 12, 3, 1),
+(427, 12, 3, 32, '2009-11-28 20:25:24', '2009-11-28 20:25:32', 'detail', 
'day', 9, 3, 1),
+(428, 12, 3, 33, '2009-11-28 20:25:46', '2009-11-28 20:25:58', 'detail', 
'day', 10, 3, 1),
+(429, 12, 3, 5, '2009-11-28 21:20:23', '2009-11-28 21:20:47', 'detail', 'day', 
5, 3, 1),
+(430, 12, 3, 33, '2009-11-28 21:20:56', '2009-11-28 21:21:01', 'detail', 
'day', 10, 3, 1),
+(431, 12, 3, 5, '2009-11-28 22:07:27', '2009-11-28 22:07:31', 'detail', 'day', 
5, 3, 1),
+(432, 12, 3, 89, '2009-11-28 23:14:49', '2009-11-28 23:15:11', 'detail', 
'day', 8, 3, 1),
+(433, 12, 3, 90, '2009-11-28 23:19:06', '2009-11-28 23:20:07', 'detail', 
'day', 1, 3, 1),
+(434, 12, 3, 89, '2009-11-28 23:42:06', '2009-11-28 23:42:10', 'detail', 
'day', 8, 3, 1),
+(435, 12, 3, 33, '2009-11-28 23:42:15', '2009-11-28 23:42:23', 'detail', 
'day', 10, 3, 1),
+(436, 12, 3, 33, '2009-11-28 23:42:23', '2009-11-28 23:42:25', 'detail', 
'day', 10, 3, 1),
+(437, 12, 3, 5, '2009-11-28 23:42:31', '2009-11-28 23:42:38', 'detail', 'day', 
5, 3, 1),
+(438, 12, 3, 32, '2009-11-28 23:42:43', '2009-11-28 23:43:44', 'detail', 
'day', 9, 3, 1),
+(439, 12, 3, 33, '2009-11-29 00:08:23', '2009-11-29 00:08:26', 'detail', 
'day', 10, 3, 1),
+(440, 12, 3, 89, '2009-11-29 00:08:38', '2009-11-29 00:09:39', 'detail', 
'day', 8, 3, 1),
+(441, 12, 3, 89, '2009-11-29 03:58:18', '2009-11-29 03:59:31', 'detail', 
'day', 8, 3, 1),
+(442, 12, 3, 89, '2009-11-29 04:50:32', '2009-11-29 04:52:02', 'detail', 
'day', 8, 3, 1),
+(443, 12, 3, 33, '2009-11-29 08:36:18', '2009-11-29 08:36:25', 'detail', 
'day', 10, 3, 1),
+(444, 12, 3, 32, '2009-11-29 08:36:30', '2009-11-29 08:37:33', 'detail', 
'day', 9, 3, 1),
+(445, 12, 3, 88, '2009-11-29 08:55:26', '2009-11-29 08:55:27', 'detail', 
'day', 12, 3, 1),
+(446, 12, 3, 88, '2009-11-29 08:55:37', '2009-11-29 08:55:37', 'detail', 
'day', 12, 3, 1),
+(447, 12, 3, 88, '2009-11-29 08:55:48', '2009-11-29 08:56:00', 'detail', 
'day', 11, 3, 1),
+(448, 12, 3, 88, '2009-11-29 08:56:00', '2009-11-29 08:57:01', 'detail', 
'day', 11, 3, 1),
+(449, 12, 3, 5, '2009-11-29 10:44:26', '2009-11-29 10:44:38', 'detail', 'day', 
5, 3, 1),
+(450, 12, 3, 5, '2009-11-29 10:44:43', '2009-11-29 10:44:48', 'detail', 'day', 
5, 3, 1),
+(451, 12, 3, 5, '2009-11-29 10:44:50', '2009-11-29 10:44:52', 'detail', 'day', 
5, 3, 1),
+(452, 12, 3, 5, '2009-11-29 10:44:54', '2009-11-29 10:44:56', 'detail', 'day', 
5, 3, 1),
+(453, 12, 3, 33, '2009-11-29 10:45:13', '2009-11-29 10:45:28', 'detail', 
'day', 10, 3, 1),
+(454, 12, 3, 88, '2009-11-29 11:39:59', '2009-11-29 11:39:59', 'detail', 
'day', 12, 3, 1),
+(455, 12, 3, 88, '2009-11-29 11:40:00', '2009-11-29 11:40:04', 'detail', 
'day', 12, 3, 1),
+(456, 12, 3, 33, '2009-11-29 11:40:07', '2009-11-29 11:40:17', 'detail', 
'day', 10, 3, 1),
+(457, 12, 3, 89, '2009-11-29 12:41:21', '2009-11-29 12:42:54', 'detail', 
'day', 8, 3, 1),
+(458, 12, 3, 89, '2009-11-29 14:06:53', '2009-11-29 14:08:42', 'detail', 
'day', 8, 3, 1),
+(459, 12, 3, 89, '2009-11-29 14:12:08', '2009-11-29 14:12:20', 'detail', 
'day', 8, 3, 1),
+(460, 12, 3, 89, '2009-11-29 14:12:23', '2009-11-29 14:12:28', 'detail', 
'day', 8, 3, 1),
+(461, 12, 3, 32, '2009-11-29 14:12:31', '2009-11-29 14:12:36', 'detail', 
'day', 9, 3, 1),
+(462, 12, 3, 33, '2009-11-29 14:12:39', '2009-11-29 14:12:45', 'detail', 
'day', 10, 3, 1),
+(463, 12, 3, 88, '2009-11-29 15:39:13', '2009-11-29 15:39:21', 'detail', 
'day', 12, 3, 1),
+(464, 12, 3, 33, '2009-11-29 15:39:31', '2009-11-29 15:39:51', 'detail', 
'day', 10, 3, 1),
+(465, 12, 3, 89, '2009-11-29 15:40:04', '2009-11-29 15:40:29', 'detail', 
'day', 8, 3, 1),
+(466, 12, 3, 33, '2009-11-29 15:40:34', '2009-11-29 15:40:42', 'detail', 
'day', 10, 3, 1),
+(467, 12, 3, 32, '2009-11-29 15:40:44', '2009-11-29 15:40:53', 'detail', 
'day', 9, 3, 1),
+(468, 12, 3, 32, '2009-11-29 17:37:25', '2009-11-29 17:37:33', 'detail', 
'day', 9, 3, 1),
+(469, 12, 3, 32, '2009-11-29 17:37:34', '2009-11-29 17:37:35', 'detail', 
'day', 9, 3, 1),
+(470, 12, 3, 32, '2009-11-29 17:37:42', '2009-11-29 17:38:29', 'detail', 
'day', 9, 3, 1),
+(471, 12, 3, 89, '2009-11-29 17:38:54', '2009-11-29 17:39:03', 'detail', 
'day', 8, 3, 1),
+(472, 12, 3, 89, '2009-11-29 17:39:05', '2009-11-29 17:40:06', 'detail', 
'day', 8, 3, 1),
+(473, 12, 3, 89, '2009-11-29 17:40:28', '2009-11-29 17:40:35', 'detail', 
'day', 8, 3, 1),
+(474, 12, 3, 88, '2009-11-29 17:40:54', '2009-11-29 17:40:57', 'detail', 
'day', 12, 3, 1),
+(475, 12, 3, 88, '2009-11-29 17:46:20', '2009-11-29 17:47:30', 'detail', 
'day', 12, 3, 1),
+(476, 12, 3, 89, '2009-11-29 17:54:01', '2009-11-29 17:54:13', 'detail', 
'day', 8, 3, 1),
+(477, 12, 3, 32, '2009-11-29 17:54:17', '2009-11-29 17:54:21', 'detail', 
'day', 9, 3, 1),
+(478, 12, 3, 33, '2009-11-29 17:54:24', '2009-11-29 17:54:35', 'detail', 
'day', 10, 3, 1),
+(479, 12, 3, 33, '2009-11-29 19:06:15', '2009-11-29 19:06:17', 'detail', 
'day', 10, 3, 1),
+(480, 12, 3, 89, '2009-11-29 19:47:21', '2009-11-29 19:47:37', 'detail', 
'day', 8, 3, 1),
+(481, 12, 3, 33, '2009-11-29 19:47:48', '2009-11-29 19:48:24', 'detail', 
'day', 10, 3, 1),
+(482, 12, 3, 32, '2009-11-29 19:48:31', '2009-11-29 19:48:41', 'detail', 
'day', 9, 3, 1),
+(483, 12, 3, 32, '2009-11-29 19:48:44', '2009-11-29 19:48:47', 'detail', 
'day', 9, 3, 1),
+(484, 12, 3, 90, '2009-11-29 19:48:50', '2009-11-29 19:48:55', 'detail', 
'day', 1, 3, 1),
+(485, 12, 3, 88, '2009-11-29 20:28:56', '2009-11-29 20:29:57', 'detail', 
'day', 12, 3, 1),
+(486, 12, 3, 88, '2009-11-30 05:27:02', '2009-11-30 05:27:07', 'detail', 
'day', 12, 3, 1),
+(487, 12, 3, 88, '2009-11-30 07:40:56', '2009-11-30 07:41:57', 'detail', 
'day', 12, 3, 1),
+(488, 12, 3, 88, '2009-11-30 09:28:35', '2009-11-30 09:28:41', 'detail', 
'day', 12, 3, 1),
+(489, 12, 3, 88, '2009-11-30 09:28:41', '2009-11-30 09:29:51', 'detail', 
'day', 12, 3, 1),
+(490, 12, 3, 88, '2009-11-30 09:34:36', '2009-11-30 09:35:11', 'detail', 
'day', 12, 3, 1),
+(491, 12, 3, 33, '2009-11-30 11:50:46', '2009-11-30 11:51:47', 'detail', 
'day', 10, 3, 1),
+(492, 12, 3, 90, '2009-12-01 18:06:33', '2009-12-01 18:06:51', 'exhibit', 
'day', 1, 3, 1),
+(493, 12, 3, 88, '2009-12-01 18:06:33', '2009-12-01 18:06:51', 'exhibit', 
'day', 2, 3, 1),
+(494, 12, 3, 88, '2009-12-01 18:06:35', '2009-12-01 18:06:51', 'exhibit', 
'day', 3, 3, 1),
+(495, 12, 3, 88, '2009-12-01 18:06:35', '2009-12-01 18:06:51', 'exhibit', 
'day', 4, 3, 1),
+(496, 12, 3, 5, '2009-12-01 18:06:35', '2009-12-01 18:06:51', 'exhibit', 
'day', 5, 3, 1),
+(497, 12, 3, 89, '2009-12-01 18:06:43', '2009-12-01 18:06:51', 'exhibit', 
'day', 8, 3, 1),
+(498, 12, 3, 32, '2009-12-01 18:06:44', '2009-12-01 18:06:51', 'exhibit', 
'day', 9, 3, 1),
+(499, 12, 3, 33, '2009-12-01 18:06:45', '2009-12-01 18:06:51', 'exhibit', 
'day', 10, 3, 1),
+(500, 12, 3, 88, '2009-12-01 18:06:47', '2009-12-01 18:06:51', 'exhibit', 
'day', 11, 3, 1),
+(501, 12, 3, 88, '2009-12-01 18:06:48', '2009-12-01 18:06:51', 'exhibit', 
'day', 12, 3, 1),
+(502, 13, 1, 39, '2009-12-02 13:39:02', '2009-12-02 13:39:02', 'download', 
'day', 0, 1, 1),
+(503, 13, 1, 39, '2009-12-02 13:39:02', '2009-12-02 13:39:10', 'exhibit', 
'day', 2, 1, 1),
+(504, 13, 1, 39, '2009-12-02 13:40:34', '2009-12-02 13:40:43', 'exhibit', 
'day', 2, 1, 1),
+(505, 13, 1, 39, '2009-12-02 13:41:43', '2009-12-02 13:42:54', 'exhibit', 
'day', 2, 1, 1);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `text_content`
+--
+
+CREATE TABLE IF NOT EXISTS `text_content` (
+  `id` int(11) NOT NULL,
+  `bg_color` varchar(50) DEFAULT NULL,
+  `color` varchar(50) DEFAULT NULL,
+  `font` varchar(255) DEFAULT NULL,
+  `size` int(11) DEFAULT NULL,
+  `text` varchar(5000) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Vypisuji data pro tabulku `text_content`
+--
+
+INSERT INTO `text_content` (`id`, `bg_color`, `color`, `font`, `size`, `text`) 
VALUES
+(2, 'yellow', 'black', 'Arial', 80, 'MAGISTRÁT MĚSTA PŘEROVA'),
+(28, 'yellow', 'black', 'Arial', 80, 'ELEKTRONICKÁ VÝVĚSKA'),
+(41, 'yellow', 'black', 'Arial', 80, 'TJ SLAVOJ KOJETÍN'),
+(64, 'yellow', 'black', 'Arial', 80, 
'<script>alert(''ahoj'');</script>\n<h1>fjdsfjal</h1>');
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `timeline`
+--
+
+CREATE TABLE IF NOT EXISTS `timeline` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `show_start` datetime NOT NULL,
+  `show_end` datetime NOT NULL,
+  `layout` int(11) NOT NULL,
+  `layout_pos` decimal(2,0) NOT NULL,
+  `content` int(11) NOT NULL,
+  `panel_planning` int(11) NOT NULL,
+  `panel_order_num` int(11) NOT NULL,
+  `modified` datetime NOT NULL,
+  `modified_by` int(11) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `FK_Reference_5` (`content`),
+  KEY `FK_Reference_10` (`layout`),
+  KEY `FK_Reference_42` (`panel_planning`,`panel_order_num`),
+  KEY `FK_Reference_45` (`modified_by`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=55 ;
+
+--
+-- Vypisuji data pro tabulku `timeline`
+--
+
+INSERT INTO `timeline` (`id`, `show_start`, `show_end`, `layout`, 
`layout_pos`, `content`, `panel_planning`, `panel_order_num`, `modified`, 
`modified_by`) VALUES
+(51, '2010-02-19 15:22:00', '2010-03-05 15:22:00', 3, 2, 61, 1, 1, '2010-02-19 
15:22:27', 10),
+(52, '2010-02-20 11:00:00', '2010-03-06 11:00:00', 2, 2, 62, 2, 1, '2010-02-20 
11:05:23', 10),
+(53, '2010-02-20 16:00:00', '2010-03-06 15:00:00', 2, 5, 64, 2, 1, '2010-02-20 
15:04:55', 10),
+(54, '2010-02-20 15:18:00', '2010-03-06 15:18:00', 2, 3, 65, 2, 1, '2010-02-20 
15:19:55', 10);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `type_plug`
+--
+
+CREATE TABLE IF NOT EXISTS `type_plug` (
+  `id` int(11) NOT NULL,
+  `componentClass` varchar(50) DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Vypisuji data pro tabulku `type_plug`
+--
+
+INSERT INTO `type_plug` (`id`, `componentClass`) VALUES
+(1, 'fake-class_document'),
+(2, 'fake-class_url'),
+(3, 'fake-class_text'),
+(4, 'fake-class_dynamic'),
+(5, 'fake-class_video'),
+(6, 'fake-class_presentation');
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `url_content`
+--
+
+CREATE TABLE IF NOT EXISTS `url_content` (
+  `id` int(11) NOT NULL,
+  `name` varchar(255) NOT NULL,
+  `url` varchar(500) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Vypisuji data pro tabulku `url_content`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `user`
+--
+
+CREATE TABLE IF NOT EXISTS `user` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `company` int(11) NOT NULL,
+  `role` int(11) NOT NULL,
+  `username` varchar(25) NOT NULL,
+  `realname` varchar(25) NOT NULL,
+  `surname` varchar(25) NOT NULL,
+  `password` varchar(40) NOT NULL,
+  `locale` varchar(5) NOT NULL,
+  `system` tinyint(1) NOT NULL,
+  `disabled` tinyint(1) NOT NULL,
+  `email` varchar(255) NOT NULL,
+  `phone` varchar(255) NOT NULL,
+  `lost_password` varchar(40) DEFAULT NULL,
+  `lost_passwd_time` datetime DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `AK_Key_2` (`username`),
+  KEY `FK_role` (`role`),
+  KEY `FK_company` (`company`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
+
+--
+-- Vypisuji data pro tabulku `user`
+--
+
+INSERT INTO `user` (`id`, `company`, `role`, `username`, `realname`, 
`surname`, `password`, `locale`, `system`, `disabled`, `email`, `phone`, 
`lost_password`, `lost_passwd_time`) VALUES
+(1, 2, 1, 'myuser', 'user', 'prijmeni', 
'81167130f06f9dc3db44584dfea7dcf457a1b418', 'cs', 0, 0, 'mejlmejl@xxxxxxxxx', 
'777 777 777', NULL, NULL),
+(2, 2, 2, 'myadmin', 'admin', 'prijmeni', 
'52708580703429d722d628ed9dd48b317b4f889a', 'cs', 0, 1, 'mejlmejl@xxxxxxxxx', 
'777 777 777', NULL, NULL),
+(3, 2, 2, 'a', 'admin', 'prijmeni', 
'41066767dd1e7832a750be70b1ef76d09713d4eb', 'cs', 0, 0, 'mejlmejl@xxxxxxxxx', 
'777 777 777', NULL, NULL),
+(5, 1, 3, 'sa', '-', '-', '416960793e3e5e4e7e4e1c78ed49421a3d63c274', 'cs', 1, 
0, 'mejlmejl@xxxxxxxxx', '777 777 777', NULL, NULL),
+(6, 2, 1, 'Ferda1', 'Ferda', 'Mravenec', 
'126816829888e6763af8016de41ce68252049ea6', 'cs', 0, 1, 'mejlmejl@xxxxxxxxx', 
'777 777 777', NULL, NULL),
+(7, 4, 2, 'horky', 'Jiří', 'Horký', 
'4949550821bcb749e1dcc805fd456b5674ba97a9', 'cs', 0, 0, 'mejlmejl@xxxxxxxxx', 
'777 777 777', NULL, NULL),
+(8, 4, 2, 'benda', 'Jaroslav', 'Benda', 
'97377730af2cc48787f64a915e21eb3c6c44a471', 'cs', 0, 0, 'mejlmejl@xxxxxxxxx', 
'777 777 777', NULL, NULL),
+(9, 4, 1, 'oulehla', 'Miloslav', 'Oulehla', 
'10912775e1e366f9c09887ee85328d71f9fdb59f', 'cs', 0, 0, 'mejlmejl@xxxxxxxxx', 
'777 777 777', NULL, NULL),
+(10, 4, 2, 'kusak', 'David', 'Kusák', 
'167486623e466863f3a12c8646184084e812376d', 'cs', 0, 0, 'mejlmejl@xxxxxxxxx', 
'777 777 777', NULL, NULL),
+(11, 4, 2, 'mizera', 'Jiří', 'Mizera', 
'5090671664088d6c4786bde0a9edd75397445d7f', 'cs', 0, 0, 'mejlmejl@xxxxxxxxx', 
'777 777 777', NULL, NULL),
+(12, 4, 2, 'viktorinova', 'Eva', 'Viktorinová', 
'6213576836a22a4b9f3f7b2c7e0d96f3ca368597', 'cs', 0, 0, 'mejlmejl@xxxxxxxxx', 
'777 777 777', NULL, NULL),
+(13, 4, 1, 'prerov_user', 'jmeno', 'prijmeni', 
'40231102a44e2909f6da059e3e8e910399773470', 'cs', 0, 0, 'mejlmejl@xxxxxxxxx', 
'777 777 777', NULL, NULL),
+(14, 4, 2, 'prerov_admin', 'jmeno', 'prijmeni', 
'58402977e1547be7c252f0de302e38e6f3bd6498', 'cs', 0, 0, 'mejlmejl@xxxxxxxxx', 
'777 777 777', NULL, NULL),
+(15, 5, 1, 'olomouc_user', 'jmeno', 'prijmeni', 
'11690596f712d071f2de0ed1cc32b9fe1e62bfe8', 'cs', 0, 0, 'mejlmejl@xxxxxxxxx', 
'777 777 777', NULL, NULL),
+(16, 5, 2, 'olomouc_admin', 'jmeno', 'prijmeni', 
'25061112ca06dc06d1a63f64293f90c5b07b8400', 'cs', 0, 0, 'mejlmejl@xxxxxxxxx', 
'777 777 777', NULL, NULL);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `video`
+--
+
+CREATE TABLE IF NOT EXISTS `video` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `length` int(11) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=92 ;
+
+--
+-- Vypisuji data pro tabulku `video`
+--
+
+INSERT INTO `video` (`id`, `length`) VALUES
+(91, 666666);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `video_content`
+--
+
+CREATE TABLE IF NOT EXISTS `video_content` (
+  `id` int(11) NOT NULL,
+  `start_pos_ms` int(11) NOT NULL,
+  `autostart` tinyint(1) NOT NULL,
+  `play_sound` tinyint(1) NOT NULL,
+  `brightness` int(11) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
+
+--
+-- Vypisuji data pro tabulku `video_content`
+--
+
+
+--
+-- Omezení pro exportované tabulky
+--
+
+--
+-- Omezení pro tabulku `category`
+--
+ALTER TABLE `category`
+  ADD CONSTRAINT `FK_Reference_35` FOREIGN KEY (`elvys_group`) REFERENCES 
`elvys_group` (`id`),
+  ADD CONSTRAINT `FK_Reference_36` FOREIGN KEY (`planning`) REFERENCES 
`category_planning` (`id`),
+  ADD CONSTRAINT `FK_Reference_39` FOREIGN KEY (`definition`) REFERENCES 
`category_definition` (`id`);
+
+--
+-- Omezení pro tabulku `category_definition`
+--
+ALTER TABLE `category_definition`
+  ADD CONSTRAINT `FK_Reference_40` FOREIGN KEY (`layout`) REFERENCES `layout` 
(`id`);
+
+--
+-- Omezení pro tabulku `category_planning`
+--
+ALTER TABLE `category_planning`
+  ADD CONSTRAINT `FK_Reference_43` FOREIGN KEY (`definition`) REFERENCES 
`category_definition` (`id`);
+
+--
+-- Omezení pro tabulku `company`
+--
+ALTER TABLE `company`
+  ADD CONSTRAINT `FK_Reference_21` FOREIGN KEY (`setting`) REFERENCES 
`comp_setting` (`id`);
+
+--
+-- Omezení pro tabulku `comp_permitted_type`
+--
+ALTER TABLE `comp_permitted_type`
+  ADD CONSTRAINT `FK_company_2` FOREIGN KEY (`company`) REFERENCES `company` 
(`id`),
+  ADD CONSTRAINT `FK_Reference_19` FOREIGN KEY (`content`) REFERENCES 
`content_type` (`id`);
+
+--
+-- Omezení pro tabulku `content_type`
+--
+ALTER TABLE `content_type`
+  ADD CONSTRAINT `FK_Reference_41` FOREIGN KEY (`file_type`) REFERENCES 
`file_type` (`id`),
+  ADD CONSTRAINT `FK_Reference_20` FOREIGN KEY (`plug`) REFERENCES `type_plug` 
(`id`);
+
+--
+-- Omezení pro tabulku `elvys`
+--
+ALTER TABLE `elvys`
+  ADD CONSTRAINT `FK_Reference_23` FOREIGN KEY (`resolution`) REFERENCES 
`resolution` (`id`),
+  ADD CONSTRAINT `FK_Reference_3` FOREIGN KEY (`company`) REFERENCES `company` 
(`id`),
+  ADD CONSTRAINT `FK_Reference_33` FOREIGN KEY (`elvys_group`) REFERENCES 
`elvys_group` (`id`),
+  ADD CONSTRAINT `FK_Reference_7` FOREIGN KEY (`setting`) REFERENCES 
`elvys_setting` (`id`);
+
+--
+-- Omezení pro tabulku `file`
+--
+ALTER TABLE `file`
+  ADD CONSTRAINT `FK_Reference_30` FOREIGN KEY (`user`) REFERENCES `user` 
(`id`),
+  ADD CONSTRAINT `FK_Reference_38` FOREIGN KEY (`file_type`) REFERENCES 
`file_type` (`id`);
+
+--
+-- Omezení pro tabulku `file_frame_content`
+--
+ALTER TABLE `file_frame_content`
+  ADD CONSTRAINT `FK_Reference_46` FOREIGN KEY (`file`) REFERENCES `file` 
(`id`);
+
+--
+-- Omezení pro tabulku `frame_content`
+--
+ALTER TABLE `frame_content`
+  ADD CONSTRAINT `FK_Reference_16` FOREIGN KEY (`type`) REFERENCES 
`content_type` (`id`);
+
+--
+-- Omezení pro tabulku `label_ref`
+--
+ALTER TABLE `label_ref`
+  ADD CONSTRAINT `FK_Reference_32` FOREIGN KEY (`label`) REFERENCES `label` 
(`id`),
+  ADD CONSTRAINT `FK_Reference_34` FOREIGN KEY (`file`) REFERENCES `file` 
(`id`);
+
+--
+-- Omezení pro tabulku `layout`
+--
+ALTER TABLE `layout`
+  ADD CONSTRAINT `FK_Reference_47` FOREIGN KEY (`modified_by`) REFERENCES 
`user` (`id`),
+  ADD CONSTRAINT `FK_Reference_12` FOREIGN KEY (`company`) REFERENCES 
`company` (`id`),
+  ADD CONSTRAINT `FK_Reference_22` FOREIGN KEY (`aspect_ratio`) REFERENCES 
`aspect_ratio` (`id`),
+  ADD CONSTRAINT `FK_Reference_28` FOREIGN KEY (`lastLockUser`) REFERENCES 
`user` (`id`);
+
+--
+-- Omezení pro tabulku `layout_position`
+--
+ALTER TABLE `layout_position`
+  ADD CONSTRAINT `FK_Reference_13` FOREIGN KEY (`layout`) REFERENCES `layout` 
(`id`);
+
+--
+-- Omezení pro tabulku `panel`
+--
+ALTER TABLE `panel`
+  ADD CONSTRAINT `FK_Reference_44` FOREIGN KEY (`planning`) REFERENCES 
`category_planning` (`id`);
+
+--
+-- Omezení pro tabulku `permitted_scheduling`
+--
+ALTER TABLE `permitted_scheduling`
+  ADD CONSTRAINT `FK_Reference_14` FOREIGN KEY (`layout`, `position`) 
REFERENCES `layout_position` (`layout`, `position`),
+  ADD CONSTRAINT `FK_Reference_15` FOREIGN KEY (`permitted_type`) REFERENCES 
`content_type` (`id`);
+
+--
+-- Omezení pro tabulku `resolution`
+--
+ALTER TABLE `resolution`
+  ADD CONSTRAINT `FK_Reference_24` FOREIGN KEY (`aspect_ratio`) REFERENCES 
`aspect_ratio` (`id`);
+
+--
+-- Omezení pro tabulku `statistics`
+--
+ALTER TABLE `statistics`
+  ADD CONSTRAINT `FK_Reference_37` FOREIGN KEY (`category`) REFERENCES 
`category_definition` (`id`),
+  ADD CONSTRAINT `FK_Reference_25` FOREIGN KEY (`elvys`) REFERENCES `elvys` 
(`id`),
+  ADD CONSTRAINT `FK_Reference_26` FOREIGN KEY (`layout`) REFERENCES `layout` 
(`id`),
+  ADD CONSTRAINT `FK_Reference_27` FOREIGN KEY (`document`) REFERENCES `file` 
(`id`);
+
+--
+-- Omezení pro tabulku `timeline`
+--
+ALTER TABLE `timeline`
+  ADD CONSTRAINT `FK_Reference_45` FOREIGN KEY (`modified_by`) REFERENCES 
`user` (`id`),
+  ADD CONSTRAINT `FK_Reference_10` FOREIGN KEY (`layout`) REFERENCES `layout` 
(`id`),
+  ADD CONSTRAINT `FK_Reference_42` FOREIGN KEY (`panel_planning`, 
`panel_order_num`) REFERENCES `panel` (`planning`, `order_num`),
+  ADD CONSTRAINT `FK_Reference_5` FOREIGN KEY (`content`) REFERENCES 
`frame_content` (`id`);
+
+--
+-- Omezení pro tabulku `user`
+--
+ALTER TABLE `user`
+  ADD CONSTRAINT `FK_company` FOREIGN KEY (`company`) REFERENCES `company` 
(`id`),
+  ADD CONSTRAINT `FK_role` FOREIGN KEY (`role`) REFERENCES `role` (`id`);

Other related posts:

• » [elvystrac] r1807 - new DB dump - elvys

1. Home
2. elvystrac
3. Archive
4. 02-2010

---

• » Previous by Date
• » Next by Date
• » Related Posts
• » View list details
• » Manage your subscription

---