[elvystrac] r1757 - one developer DB dump added (for JM)
- From: elvys@xxxxxxxxxxxxxxxxxxxxxx
- To: elvystrac@xxxxxxxxxxxxx
- Date: Wed, 17 Feb 2010 12:42:09 +0100
Author: DavidK
Date: 2010-02-17 12:42:09 +0100 (Wed, 17 Feb 2010)
New Revision: 1757
Added:
others/dbs/script/_dump/24U1v_20100212_webservernew_migr_from_22prod.sql
Log:
one developer DB dump added (for JM)
Added: others/dbs/script/_dump/24U1v_20100212_webservernew_migr_from_22prod.sql
===================================================================
--- others/dbs/script/_dump/24U1v_20100212_webservernew_migr_from_22prod.sql
(rev 0)
+++ others/dbs/script/_dump/24U1v_20100212_webservernew_migr_from_22prod.sql
2010-02-17 11:42:09 UTC (rev 1757)
@@ -0,0 +1,2365 @@
+-- phpMyAdmin SQL Dump
+-- version 3.2.3
+-- http://www.phpmyadmin.net
+--
+-- Počítač: localhost
+-- Vygenerováno: Pátek 12. února 2010, 20:28
+-- 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=1 ;
+
+--
+-- Vypisuji data pro tabulku `category`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- 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=1 ;
+
+--
+-- Vypisuji data pro tabulku `category_planning`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- 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`),
+ 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);
+
+-- --------------------------------------------------------
+
+--
+-- 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);
+
+-- --------------------------------------------------------
+
+--
+-- 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
+(24, '24Upgrade1- Categories, Tabs, FileType', '2010-01-21 00:00:00',
'2010-02-12 20:28:08');
+
+-- --------------------------------------------------------
+
+--
+-- 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,
+ `document` int(11) NOT NULL,
+ `page_list` varchar(255) NOT NULL,
+ `num_preview_page` varchar(255) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `FK_Reference_11` (`document`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Vypisuji data pro tabulku `document_content`
+--
+
+INSERT INTO `document_content` (`id`, `document`, `page_list`,
`num_preview_page`) VALUES
+(6, 23, '1-5', '1'),
+(7, 24, '1-5', '1'),
+(10, 28, '1-1', '1'),
+(11, 5, '1-4', '1'),
+(12, 26, '1-1', '1'),
+(13, 25, '1-1', '1'),
+(14, 24, '1-5', '1'),
+(15, 23, '1-5', '1'),
+(17, 28, '1-1', '1'),
+(20, 28, '1-1', '1'),
+(30, 32, '1-1', '1'),
+(31, 30, '1-1', '1'),
+(32, 31, '1-1', '1'),
+(33, 33, '1-1', '1'),
+(34, 27, '1-5', '1'),
+(35, 24, '1-5', '1'),
+(37, 31, '1-1', '1'),
+(38, 41, '1-1', '1'),
+(43, 33, '1-1', '1'),
+(44, 5, '1-4', '1'),
+(47, 32, '1-1', '1'),
+(48, 88, '1-1', '1'),
+(49, 88, '1-1', '1'),
+(50, 88, '1-1', '1'),
+(51, 88, '1-1', '1'),
+(52, 88, '1-1', '1'),
+(53, 89, '1-3', '1'),
+(54, 90, '1-1', '1'),
+(57, 34, '1-6', '1'),
+(58, 36, '1-2', '1'),
+(59, 35, '1-2', '2'),
+(60, 87, '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');
+
+-- --------------------------------------------------------
+
+--
+-- 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,
+ 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`) VALUES
+(12, 4, 'Kiosek 12', 12, 'Přerov 2', 'Bratrská 34, 750 11 Přerov 2', 1, NULL,
0, NULL, 2, 1),
+(13, 4, 'Kiosek 13', 13, 'Přerov - Popovice', 'Kovářská 11, 750 11 Přerov', 1,
NULL, 0, NULL, 2, 2),
+(14, 4, 'Kiosek 14', 14, 'Přerov - Vinary', 'Za Humny 7, 750 11 Přerov', 0,
NULL, 0, NULL, 2, 3);
+
+-- --------------------------------------------------------
+
+--
+-- 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=91 ;
+
+--
+-- 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', '-', '_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', '-',
'_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', '-', '_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', '-', '_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', '-', '_FAKE_HASH_CODE_', 4, 8,
'2009-11-03 11:45:54', 0, 0),
+(89, 1, 'Muži foto kojetín.pdf', '89.pdf', '-', '_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);
+
+-- --------------------------------------------------------
+
+--
+-- 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=61 ;
+
+--
+-- 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),
+(2, 3),
+(28, 3),
+(41, 3),
+(5, 4),
+(29, 4),
+(42, 4);
+
+-- --------------------------------------------------------
+
+--
+-- 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,
+ PRIMARY KEY (`id`),
+ KEY `FK_Reference_22` (`aspect_ratio`),
+ KEY `FK_Reference_12` (`company`),
+ KEY `FK_Reference_28` (`lastLockUser`)
+) 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`) VALUES
+(1, 8, 4, 'layout-prezentace', 1, 0, 1, NULL, 0, NULL),
+(2, 10, 4, 'layout', 1, 0, 2, NULL, 0, NULL),
+(3, 12, 4, 'Pro dv� firmy', 1, 0, 0, NULL, 0, NULL),
+(4, 4, 4, 'layout', 1, 1, 1, NULL, 0, NULL),
+(5, 8, 4, 'layout-prezentace-nove', 1, 1, 2, NULL, 0, NULL),
+(6, 2, 1, 'layout', 1, 1, 0, NULL, 0, NULL),
+(7, 0, 1, 'layout4', 1, 1, 0, NULL, 0, NULL),
+(8, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL),
+(9, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL),
+(10, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL),
+(11, 2, 2, 'Layout', 1, 1, 0, NULL, 0, NULL),
+(12, 2, 2, 'Layout1', 1, 1, 0, NULL, 0, NULL),
+(13, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL),
+(14, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL),
+(15, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL),
+(16, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL),
+(17, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL),
+(18, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL),
+(19, 3, 2, 'layout', 1, 1, 1, NULL, 0, NULL),
+(20, 5, 2, 'layout', 1, 1, 2, NULL, 0, NULL),
+(21, 8, 2, 'layout', 1, 1, 3, NULL, 0, NULL),
+(22, 8, 4, 'layout-prezentace', 1, 1, 2, NULL, 0, NULL),
+(23, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL),
+(24, 1, 2, 'layout', 1, 1, 1, NULL, 0, NULL),
+(25, 1, 2, 'layout11', 1, 1, 1, NULL, 0, NULL),
+(26, 1, 2, 'layout111', 1, 1, 0, NULL, 0, NULL),
+(27, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL),
+(28, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL),
+(29, 3, 2, 'layout', 1, 1, 1, NULL, 0, NULL),
+(30, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL),
+(31, 3, 2, 'layout', 1, 1, 1, NULL, 0, NULL),
+(32, 3, 4, '�ulina', 1, 0, 0, NULL, 0, NULL),
+(33, 8, 4, 'layout-prezentace', 1, 0, 2, NULL, 0, NULL),
+(34, 2, 4, 'layout', 1, 0, 0, NULL, 0, NULL),
+(35, 2, 4, 'layout', 1, 0, 0, NULL, 0, NULL),
+(36, 2, 4, 'layout-documentType', 1, 0, 0, NULL, 0, NULL);
+
+-- --------------------------------------------------------
+
+--
+-- 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`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- 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);
+
+-- --------------------------------------------------------
+
+--
+-- 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');
+
+-- --------------------------------------------------------
+
+--
+-- 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,
+ PRIMARY KEY (`id`),
+ KEY `FK_Reference_5` (`content`),
+ KEY `FK_Reference_10` (`layout`),
+ KEY `FK_Reference_42` (`panel_planning`,`panel_order_num`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=51 ;
+
+--
+-- Vypisuji data pro tabulku `timeline`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `type_plug`
+--
+
+CREATE TABLE IF NOT EXISTS `type_plug` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `componentClass` varchar(50) DEFAULT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
+
+--
+-- 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');
+
+-- --------------------------------------------------------
+
+--
+-- 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,
+ PRIMARY KEY (`id`),
+ 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`) VALUES
+(1, 2, 1, 'myuser', 'user', 'prijmeni', 'pass', 'cs', 0, 0),
+(2, 2, 2, 'myadmin', 'admin', 'prijmeni', 'pass', 'cs', 0, 1),
+(3, 2, 2, 'a', 'admin', 'prijmeni', 'a', 'cs', 0, 0),
+(5, 1, 3, 'sa', '-', '-', 'pass', 'cs', 1, 0),
+(6, 2, 1, 'Ferda1', 'Ferda', 'Mravenec', 'pytlik', 'cs', 0, 1),
+(7, 4, 2, 'horky', 'Jiří', 'Horký', 'pass', 'cs', 0, 0),
+(8, 4, 2, 'benda', 'Jaroslav', 'Benda', 'pass', 'cs', 0, 0),
+(9, 4, 1, 'oulehla', 'Miloslav', 'Oulehla', '0714', 'cs', 0, 0),
+(10, 4, 2, 'kusak', 'David', 'Kusák', 'pass', 'cs', 0, 0),
+(11, 4, 2, 'mizera', 'Jiří', 'Mizera', 'pass', 'cs', 0, 0),
+(12, 4, 2, 'viktorinova', 'Eva', 'Viktorinová', 'pass', 'cs', 0, 0),
+(13, 4, 1, 'prerov_user', 'jmeno', 'prijmeni', 'pass', 'cs', 0, 0),
+(14, 4, 2, 'prerov_admin', 'jmeno', 'prijmeni', 'pass', 'cs', 0, 0),
+(15, 5, 1, 'olomouc_user', 'jmeno', 'prijmeni', 'pass', 'cs', 0, 0),
+(16, 5, 2, 'olomouc_admin', 'jmeno', 'prijmeni', 'pass', 'cs', 0, 0);
+
+-- --------------------------------------------------------
+
+--
+-- 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=1 ;
+
+--
+-- Vypisuji data pro tabulku `video`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `video_content`
+--
+
+CREATE TABLE IF NOT EXISTS `video_content` (
+ `id` int(11) NOT NULL,
+ `video` 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`),
+ KEY `FK_Reference_31` (`video`)
+) 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 `document_content`
+--
+ALTER TABLE `document_content`
+ ADD CONSTRAINT `FK_Reference_11` FOREIGN KEY (`document`) REFERENCES
`document` (`id`);
+
+--
+-- Omezení pro tabulku `elvys`
+--
+ALTER TABLE `elvys`
+ ADD CONSTRAINT `FK_Reference_33` FOREIGN KEY (`elvys_group`) REFERENCES
`elvys_group` (`id`),
+ 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_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 `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_28` FOREIGN KEY (`lastLockUser`) 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`);
+
+--
+-- 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_42` FOREIGN KEY (`panel_planning`,
`panel_order_num`) REFERENCES `panel` (`planning`, `order_num`),
+ ADD CONSTRAINT `FK_Reference_10` FOREIGN KEY (`layout`) REFERENCES `layout`
(`id`),
+ 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`);
+
+--
+-- Omezení pro tabulku `video_content`
+--
+ALTER TABLE `video_content`
+ ADD CONSTRAINT `FK_Reference_31` FOREIGN KEY (`video`) REFERENCES `video`
(`id`);
Other related posts:
- » [elvystrac] r1757 - one developer DB dump added (for JM) - elvys
