Author: DavidK Date: 2010-02-17 12:42:26 +0100 (Wed, 17 Feb 2010) New Revision: 1758 Added: others/dbs/script/_dump/25v_migr22dev_webservernew.sql Log: one developer DB dump added (for JM) Added: others/dbs/script/_dump/25v_migr22dev_webservernew.sql =================================================================== --- others/dbs/script/_dump/25v_migr22dev_webservernew.sql (rev 0) +++ others/dbs/script/_dump/25v_migr22dev_webservernew.sql 2010-02-17 11:42:26 UTC (rev 1758) @@ -0,0 +1,2720 @@ +-- phpMyAdmin SQL Dump +-- version 3.2.3 +-- http://www.phpmyadmin.net +-- +-- Počítač: localhost +-- Vygenerováno: Pondělí 15. února 2010, 10:32 +-- 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=4 ; + +-- +-- Vypisuji data pro tabulku `category` +-- + +INSERT INTO `category` (`id`, `definition`, `elvys_group`, `planning`, `cat_order`, `disabled`) VALUES +(2, 1, 2, 2, 1, 0), +(3, 34, 2, 3, 2, 0); + +-- -------------------------------------------------------- + +-- +-- Struktura tabulky `category_definition` +-- + +CREATE TABLE IF NOT EXISTS `category_definition` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `layout` int(11) NOT NULL, + `name` varchar(100) COLLATE utf8_czech_ci NOT NULL, + `created` datetime NOT NULL, + `modified` datetime NOT NULL, + `disabled` tinyint(1) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `FK_Reference_40` (`layout`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=65 ; + +-- +-- 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), +(64, 3, 'meine kategorie', '2010-02-13 14:16:14', '2010-02-13 14:16:14', 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=4 ; + +-- +-- Vypisuji data pro tabulku `category_planning` +-- + +INSERT INTO `category_planning` (`id`, `definition`, `disabled`) VALUES +(1, 64, 1), +(2, 1, 0), +(3, 34, 0); + +-- -------------------------------------------------------- + +-- +-- Struktura tabulky `company` +-- + +CREATE TABLE IF NOT EXISTS `company` ( + `id` int(11) NOT NULL, + `name` varchar(100) NOT NULL, + `email` varchar(100) NOT NULL, + `human` varchar(100) NOT NULL, + `tel` varchar(20) NOT NULL, + `system` tinyint(1) NOT NULL, + `disabled` tinyint(1) NOT NULL, + `setting` int(11) NOT NULL, + PRIMARY KEY (`id`), + KEY `FK_Reference_21` (`setting`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Vypisuji data pro tabulku `company` +-- + +INSERT INTO `company` (`id`, `name`, `email`, `human`, `tel`, `system`, `disabled`, `setting`) VALUES +(1, 'system', '-', '-', '-', 1, 0, 1), +(2, 'Sun', 'sun@xxxxxxx', 'Pepa Vomacka', '771771771', 0, 0, 2), +(4, 'Statutární město Přerov', 'posta@xxxxxxxxxxxx', 'kontakt_Přerov', '+420 581 268 111', 0, 0, 4), +(5, 'Magistrát města Olomouce', 'infocentrum@xxxxxxxxxx', 'kontakt_Olomouc', '585 513 111', 0, 0, 5); + +-- -------------------------------------------------------- + +-- +-- Struktura tabulky `comp_permitted_type` +-- + +CREATE TABLE IF NOT EXISTS `comp_permitted_type` ( + `company` int(11) NOT NULL, + `content` int(11) NOT NULL, + PRIMARY KEY (`company`,`content`), + KEY `FK_Reference_19` (`content`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Vypisuji data pro tabulku `comp_permitted_type` +-- + +INSERT INTO `comp_permitted_type` (`company`, `content`) VALUES +(2, 1), +(4, 1), +(5, 1), +(2, 2), +(4, 2), +(5, 2), +(2, 3), +(4, 3), +(5, 3), +(2, 4), +(4, 4), +(5, 4), +(4, 5); + +-- -------------------------------------------------------- + +-- +-- 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 +(25, '25- file_frame_content, layout:modified, timeline:modified(+mod_by)', '2010-02-05 00:00:00', '2010-02-12 20:30:30'); + +-- -------------------------------------------------------- + +-- +-- Struktura tabulky `document` +-- + +CREATE TABLE IF NOT EXISTS `document` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `page_count` int(11) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=91 ; + +-- +-- Vypisuji data pro tabulku `document` +-- + +INSERT INTO `document` (`id`, `page_count`) VALUES +(3, 15), +(4, 2), +(5, 4), +(6, 13), +(7, 13), +(8, 13), +(9, 1), +(10, 1), +(11, 6), +(12, 1), +(13, 1), +(14, 1), +(15, 1), +(16, 1), +(17, 1), +(18, 8), +(19, 510), +(22, 4), +(23, 5), +(24, 5), +(25, 1), +(26, 1), +(27, 5), +(28, 1), +(29, 1), +(30, 1), +(31, 1), +(32, 1), +(33, 1), +(34, 6), +(35, 2), +(36, 2), +(37, 9), +(38, 6), +(39, 2), +(40, 510), +(41, 1), +(42, 6), +(43, 9), +(44, 9), +(45, 6), +(46, 9), +(47, 9), +(48, 6), +(49, 6), +(50, 9), +(51, 67), +(52, 9), +(53, 6), +(54, 2), +(55, 6), +(56, 9), +(57, 6), +(58, 2), +(59, 2), +(60, 6), +(61, 67), +(62, 2), +(63, 6), +(64, 9), +(65, 9), +(66, 9), +(67, 2), +(68, 2), +(69, 2), +(70, 9), +(71, 9), +(72, 2), +(73, 6), +(74, 384), +(75, 2), +(76, 67), +(77, 384), +(78, 6), +(79, 2), +(80, 6), +(81, 6), +(82, 6), +(83, 9), +(84, 2), +(85, 6), +(86, 2), +(87, 1), +(88, 1), +(89, 3), +(90, 1); + +-- -------------------------------------------------------- + +-- +-- Struktura tabulky `document_content` +-- + +CREATE TABLE IF NOT EXISTS `document_content` ( + `id` int(11) NOT NULL, + `page_list` varchar(255) NOT NULL, + `num_preview_page` varchar(255) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Vypisuji data pro tabulku `document_content` +-- + +INSERT INTO `document_content` (`id`, `page_list`, `num_preview_page`) VALUES +(6, '1-5', '1'), +(7, '1-5', '1'), +(10, '1-1', '1'), +(11, '1-4', '1'), +(12, '1-1', '1'), +(13, '1-1', '1'), +(14, '1-5', '1'), +(15, '1-5', '1'), +(17, '1-1', '1'), +(20, '1-1', '1'), +(30, '1-1', '1'), +(31, '1-1', '1'), +(32, '1-1', '1'), +(33, '1-1', '1'), +(34, '1-5', '1'), +(35, '1-5', '1'), +(37, '1-1', '1'), +(38, '1-1', '1'), +(43, '1-1', '1'), +(44, '1-4', '1'), +(47, '1-1', '1'), +(48, '1-1', '1'), +(49, '1-1', '1'), +(50, '1-1', '1'), +(51, '1-1', '1'), +(52, '1-1', '1'), +(53, '1-3', '1'), +(54, '1-1', '1'), +(57, '1-6', '1'), +(58, '1-2', '1'), +(59, '1-2', '2'), +(60, '1-1', '1'), +(64, '1-9', '1'), +(66, '1-2', '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', 0, NULL, 0, NULL, 2, 1), +(13, 4, 'Kiosek 13', 13, 'Přerov - Popovice', 'Kovářská 11, 750 11 Přerov', 0, 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_frame_content` +-- + +CREATE TABLE IF NOT EXISTS `file_frame_content` ( + `id` int(11) NOT NULL, + `file` int(11) NOT NULL, + PRIMARY KEY (`id`), + KEY `FK_Reference_46` (`file`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; + +-- +-- Vypisuji data pro tabulku `file_frame_content` +-- + +INSERT INTO `file_frame_content` (`id`, `file`) VALUES +(11, 5), +(44, 5), +(6, 23), +(15, 23), +(7, 24), +(14, 24), +(35, 24), +(13, 25), +(12, 26), +(34, 27), +(10, 28), +(17, 28), +(20, 28), +(31, 30), +(32, 31), +(37, 31), +(30, 32), +(47, 32), +(33, 33), +(43, 33), +(57, 34), +(59, 35), +(58, 36), +(66, 36), +(64, 37), +(38, 41), +(60, 87), +(48, 88), +(49, 88), +(50, 88), +(51, 88), +(52, 88), +(53, 89), +(54, 90); + +-- -------------------------------------------------------- + +-- +-- Struktura tabulky `file_type` +-- + +CREATE TABLE IF NOT EXISTS `file_type` ( + `id` int(11) NOT NULL, + `type` varchar(10) COLLATE utf8_czech_ci NOT NULL, + `suffixes` varchar(200) COLLATE utf8_czech_ci NOT NULL, + `icon` varchar(50) COLLATE utf8_czech_ci NOT NULL, + `storage_class` varchar(200) COLLATE utf8_czech_ci NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; + +-- +-- Vypisuji data pro tabulku `file_type` +-- + +INSERT INTO `file_type` (`id`, `type`, `suffixes`, `icon`, `storage_class`) VALUES +(1, 'document', 'pdf', '/images/documents/pdf.jpg', 'elvys.server.bl.file.FileStorageManagerPdf'), +(2, 'video', 'avi, mov, mpeg, mpg, wmv, flv', '/images/documents/video.gif', 'elvys.server.bl.file.FileStorageManagerVideo'); + +-- -------------------------------------------------------- + +-- +-- Struktura tabulky `frame_content` +-- + +CREATE TABLE IF NOT EXISTS `frame_content` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `type` int(11) NOT NULL, + PRIMARY KEY (`id`), + KEY `FK_Reference_16` (`type`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=67 ; + +-- +-- 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), +(64, 1), +(66, 1), +(63, 2), +(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, + `created` datetime NOT NULL, + `modified` datetime NOT NULL, + `modified_by` int(11) NOT NULL, + PRIMARY KEY (`id`), + KEY `FK_Reference_22` (`aspect_ratio`), + KEY `FK_Reference_12` (`company`), + KEY `FK_Reference_28` (`lastLockUser`), + KEY `FK_Reference_47` (`modified_by`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=42 ; + +-- +-- Vypisuji data pro tabulku `layout` +-- + +INSERT INTO `layout` (`id`, `sect_count`, `company`, `name`, `aspect_ratio`, `disabled`, `revision`, `lastLockTime`, `locked`, `lastLockUser`, `created`, `modified`, `modified_by`) VALUES +(1, 8, 4, 'layout-prezentace', 1, 0, 1, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-14 14:52:53', 10), +(2, 10, 4, 'layout', 1, 0, 2, '2010-02-14 20:00:07', 1, 10, '2010-02-12 20:30:31', '2010-02-14 20:00:07', 10), +(3, 12, 4, 'Pro dv? firmy', 1, 0, 0, '2010-02-14 09:11:16', 1, 10, '2010-02-12 20:30:31', '2010-02-14 09:11:16', 10), +(4, 4, 4, 'layout', 1, 1, 1, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(5, 8, 4, 'layout-prezentace-nove', 1, 1, 2, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(6, 2, 1, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(7, 0, 1, 'layout4', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(8, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(9, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(10, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(11, 2, 2, 'Layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(12, 2, 2, 'Layout1', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(13, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(14, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(15, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(16, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(17, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(18, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(19, 3, 2, 'layout', 1, 1, 1, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(20, 5, 2, 'layout', 1, 1, 2, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(21, 8, 2, 'layout', 1, 1, 3, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(22, 8, 4, 'layout-prezentace', 1, 1, 2, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(23, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(24, 1, 2, 'layout', 1, 1, 1, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(25, 1, 2, 'layout11', 1, 1, 1, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(26, 1, 2, 'layout111', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(27, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(28, 2, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(29, 3, 2, 'layout', 1, 1, 1, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(30, 1, 2, 'layout', 1, 1, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(31, 3, 2, 'layout', 1, 1, 1, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(32, 3, 4, '?ulina', 1, 0, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-14 16:39:46', 10), +(33, 8, 4, 'layout-prezentace', 1, 0, 2, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-12 20:30:32', 5), +(34, 2, 4, 'layout', 1, 0, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-14 00:19:22', 10), +(35, 2, 4, 'layout', 1, 0, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-14 09:07:54', 10), +(36, 2, 4, 'layout-documentType', 1, 0, 0, NULL, 0, NULL, '2010-02-12 20:30:31', '2010-02-14 16:58:51', 10), +(37, 2, 4, 'layoutek-upraveny', 1, 0, 0, NULL, 0, NULL, '2010-02-14 00:19:17', '2010-02-14 09:47:53', 10), +(38, 8, 4, 'layout-prezentace-upraven', 1, 0, 1, NULL, 0, NULL, '2010-02-14 14:52:52', '2010-02-14 15:23:03', 10), +(39, 8, 4, 'layout-prezentace-upraven-2', 1, 0, 1, NULL, 0, NULL, '2010-02-14 15:23:03', '2010-02-14 15:23:23', 10), +(40, 10, 4, 'layout-upraveny!!!', 1, 0, 2, NULL, 0, NULL, '2010-02-14 15:44:55', '2010-02-14 15:48:11', 10), +(41, 10, 4, 'dsafsafsafsdfsd fsjflksaj fsjdf jsdlk jflksajflk sja lkfsj lkfsajflk', 1, 0, 2, NULL, 0, NULL, '2010-02-14 20:01:43', '2010-02-14 20:01:46', 10); + +-- -------------------------------------------------------- + +-- +-- 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), +(37, 1, 0.00537109375, 0.015625, 0.36865234375, 0.605902777777778), +(37, 2, 0.49853515625, 0.214409722222222, 0.40380859375, 0.709201388888889), +(38, 1, 0.00286458333333333, 0.00972222222222222, 0.182552083333333, 0.324074074074074), +(38, 2, 0.00286458333333333, 0.338888888888889, 0.182552083333333, 0.324074074074074), +(38, 3, 0.00286458333333333, 0.667592592592593, 0.182552083333333, 0.324074074074074), +(38, 4, 0.2484375, 0.0273148148148148, 0.470833333333333, 0.0958333333333333), +(38, 5, 0.770833333333333, 0.00833333333333333, 0.2078125, 0.481018518518519), +(38, 6, 0.775520833333333, 0.513888888888889, 0.2078125, 0.481018518518519), +(38, 7, 0.36640625, 0.172222222222222, 0.181770833333333, 0.368981481481481), +(38, 8, 0.2125, 0.920833333333333, 0.543229166666667, 0.0657407407407407), +(39, 1, 0.003125, 0.01, 0.183125, 0.324444444444444), +(39, 2, 0.003125, 0.34, 0.183125, 0.324444444444444), +(39, 3, 0.003125, 0.667777777777778, 0.183125, 0.324444444444444), +(39, 4, 0.24875, 0.0277777777777778, 0.47125, 0.0966666666666667), +(39, 5, 0.77125, 0.00888888888888889, 0.208125, 0.481111111111111), +(39, 6, 0.775625, 0.514444444444444, 0.208125, 0.481111111111111), +(39, 7, 0.196875, 0.184444444444444, 0.501875, 0.617777777777778), +(39, 8, 0.2125, 0.921111111111111, 0.54375, 0.0666666666666667), +(40, 1, 0.0166015625, 0, 0.17919921875, 0.462673611111111), +(40, 2, 0.005859375, 0.5, 0.19580078125, 0.493055555555556), +(40, 3, 0.2275390625, 0, 0.17919921875, 0.462673611111111), +(40, 4, 0.203125, 0.5, 0.19580078125, 0.493055555555556), +(40, 5, 0.421875, 0.0364583333333333, 0.16357421875, 0.175347222222222), +(40, 6, 0.40185546875, 0.501736111111111, 0.19677734375, 0.493055555555556), +(40, 7, 0.603515625, 0, 0.18017578125, 0.495659722222222), +(40, 8, 0.61865234375, 0.53125, 0.16845703125, 0.430555555555556), +(40, 9, 0.796875, 0.00607638888888889, 0.19580078125, 0.493055555555556), +(40, 10, 0.796875, 0.5, 0.19580078125, 0.493055555555556), +(41, 1, 0.0166015625, 0, 0.17919921875, 0.462673611111111), +(41, 2, 0.005859375, 0.5, 0.19580078125, 0.493055555555556), +(41, 3, 0.2275390625, 0, 0.17919921875, 0.462673611111111), +(41, 4, 0.203125, 0.5, 0.19580078125, 0.493055555555556), +(41, 5, 0.43896484375, 0.173611111111111, 0.16259765625, 0.173611111111111), +(41, 6, 0.40234375, 0.5, 0.19580078125, 0.493055555555556), +(41, 7, 0.619140625, 0.00694444444444444, 0.17919921875, 0.493923611111111), +(41, 8, 0.60009765625, 0.5, 0.19580078125, 0.493055555555556), +(41, 9, 0.796875, 0.00607638888888889, 0.19580078125, 0.493055555555556), +(41, 10, 0.796875, 0.5, 0.19580078125, 0.493055555555556); + +-- -------------------------------------------------------- + +-- +-- Struktura tabulky `panel` +-- + +CREATE TABLE IF NOT EXISTS `panel` ( + `planning` int(11) NOT NULL, + `order_num` int(11) NOT NULL, + PRIMARY KEY (`planning`,`order_num`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; + +-- +-- Vypisuji data pro tabulku `panel` +-- + +INSERT INTO `panel` (`planning`, `order_num`) VALUES +(1, 1), +(2, 1), +(3, 1); + +-- -------------------------------------------------------- + +-- +-- 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), +(37, 1, 1), +(37, 2, 1), +(38, 1, 1), +(38, 2, 1), +(38, 3, 1), +(38, 4, 1), +(38, 5, 1), +(38, 6, 1), +(38, 7, 1), +(38, 8, 1), +(39, 1, 1), +(39, 2, 1), +(39, 3, 1), +(39, 4, 1), +(39, 5, 1), +(39, 6, 1), +(39, 7, 1), +(39, 8, 1), +(40, 1, 1), +(40, 2, 1), +(40, 3, 1), +(40, 4, 1), +(40, 5, 1), +(40, 6, 1), +(40, 7, 1), +(40, 8, 1), +(40, 9, 1), +(40, 10, 1), +(41, 1, 1), +(41, 2, 1), +(41, 3, 1), +(41, 4, 1), +(41, 5, 1), +(41, 6, 1), +(41, 7, 1), +(41, 8, 1), +(41, 9, 1), +(41, 10, 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), +(37, 2, 2), +(38, 1, 2), +(38, 2, 2), +(38, 3, 2), +(38, 4, 2), +(38, 5, 2), +(38, 6, 2), +(38, 7, 2), +(38, 8, 2), +(39, 1, 2), +(39, 2, 2), +(39, 3, 2), +(39, 4, 2), +(39, 5, 2), +(39, 6, 2), +(39, 7, 2), +(39, 8, 2), +(40, 1, 2), +(40, 2, 2), +(40, 3, 2), +(40, 4, 2), +(40, 5, 2), +(40, 6, 2), +(40, 7, 2), +(40, 8, 2), +(40, 9, 2), +(40, 10, 2), +(41, 1, 2), +(41, 2, 2), +(41, 3, 2), +(41, 4, 2), +(41, 5, 2), +(41, 6, 2), +(41, 7, 2), +(41, 8, 2), +(41, 9, 2), +(41, 10, 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), +(38, 1, 3), +(38, 2, 3), +(38, 3, 3), +(38, 4, 3), +(38, 5, 3), +(38, 6, 3), +(38, 7, 3), +(38, 8, 3), +(39, 1, 3), +(39, 2, 3), +(39, 3, 3), +(39, 4, 3), +(39, 5, 3), +(39, 6, 3), +(39, 7, 3), +(39, 8, 3), +(40, 1, 3), +(40, 2, 3), +(40, 3, 3), +(40, 4, 3), +(40, 5, 3), +(40, 6, 3), +(40, 7, 3), +(40, 8, 3), +(40, 9, 3), +(40, 10, 3), +(41, 1, 3), +(41, 2, 3), +(41, 3, 3), +(41, 4, 3), +(41, 5, 3), +(41, 6, 3), +(41, 7, 3), +(41, 8, 3), +(41, 9, 3), +(41, 10, 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), +(37, 1, 4), +(38, 1, 4), +(38, 2, 4), +(38, 3, 4), +(38, 4, 4), +(38, 5, 4), +(38, 6, 4), +(38, 7, 4), +(38, 8, 4), +(39, 1, 4), +(39, 2, 4), +(39, 3, 4), +(39, 4, 4), +(39, 5, 4), +(39, 6, 4), +(39, 7, 4), +(39, 8, 4), +(40, 1, 4), +(40, 2, 4), +(40, 3, 4), +(40, 4, 4), +(40, 5, 4), +(40, 6, 4), +(40, 7, 4), +(40, 8, 4), +(40, 9, 4), +(40, 10, 4), +(41, 1, 4), +(41, 2, 4), +(41, 3, 4), +(41, 4, 4), +(41, 5, 4), +(41, 6, 4), +(41, 7, 4), +(41, 8, 4), +(41, 9, 4), +(41, 10, 4), +(1, 1, 5), +(1, 2, 5), +(1, 3, 5), +(1, 4, 5), +(1, 5, 5), +(1, 6, 5), +(1, 7, 5), +(1, 8, 5), +(2, 1, 5), +(2, 2, 5), +(2, 3, 5), +(2, 4, 5), +(2, 5, 5), +(2, 6, 5), +(2, 7, 5), +(2, 8, 5), +(2, 9, 5), +(2, 10, 5), +(3, 8, 5), +(3, 9, 5), +(3, 10, 5), +(3, 11, 5), +(3, 12, 5), +(4, 1, 5), +(4, 2, 5), +(4, 3, 5), +(4, 4, 5), +(5, 1, 5), +(5, 2, 5), +(5, 3, 5), +(5, 4, 5), +(5, 5, 5), +(5, 6, 5), +(5, 7, 5), +(5, 8, 5), +(22, 1, 5), +(22, 2, 5), +(22, 3, 5), +(22, 4, 5), +(22, 5, 5), +(22, 6, 5), +(22, 7, 5), +(22, 8, 5), +(33, 1, 5), +(33, 2, 5), +(33, 3, 5), +(33, 4, 5), +(33, 5, 5), +(33, 6, 5), +(33, 8, 5), +(36, 1, 5), +(36, 2, 5), +(38, 1, 5), +(38, 2, 5), +(38, 3, 5), +(38, 4, 5), +(38, 5, 5), +(38, 6, 5), +(38, 7, 5), +(38, 8, 5), +(39, 1, 5), +(39, 2, 5), +(39, 3, 5), +(39, 4, 5), +(39, 5, 5), +(39, 6, 5), +(39, 7, 5), +(39, 8, 5), +(40, 1, 5), +(40, 2, 5), +(40, 3, 5), +(40, 4, 5), +(40, 5, 5), +(40, 6, 5), +(40, 7, 5), +(40, 8, 5), +(40, 9, 5), +(40, 10, 5), +(41, 1, 5), +(41, 2, 5), +(41, 3, 5), +(41, 4, 5), +(41, 5, 5), +(41, 6, 5), +(41, 7, 5), +(41, 8, 5), +(41, 9, 5), +(41, 10, 5); + +-- -------------------------------------------------------- + +-- +-- 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, + `modified` datetime NOT NULL, + `modified_by` int(11) NOT NULL, + PRIMARY KEY (`id`), + KEY `FK_Reference_5` (`content`), + KEY `FK_Reference_10` (`layout`), + KEY `FK_Reference_42` (`panel_planning`,`panel_order_num`), + KEY `FK_Reference_45` (`modified_by`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=54 ; + +-- +-- Vypisuji data pro tabulku `timeline` +-- + +INSERT INTO `timeline` (`id`, `show_start`, `show_end`, `layout`, `layout_pos`, `content`, `panel_planning`, `panel_order_num`, `modified`, `modified_by`) VALUES +(51, '2010-02-13 17:16:00', '2010-02-27 17:16:00', 1, 1, 63, 2, 1, '2010-02-13 17:16:44', 10), +(52, '2010-02-13 18:03:00', '2010-02-27 18:03:00', 1, 2, 64, 2, 1, '2010-02-13 18:03:17', 10), +(53, '2010-02-13 23:00:00', '2010-02-27 18:47:00', 1, 3, 66, 2, 1, '2010-02-13 18:51:20', 7); + +-- -------------------------------------------------------- + +-- +-- Struktura tabulky `type_plug` +-- + +CREATE TABLE IF NOT EXISTS `type_plug` ( + `id` int(11) NOT NULL, + `componentClass` varchar(50) DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Vypisuji data pro tabulku `type_plug` +-- + +INSERT INTO `type_plug` (`id`, `componentClass`) VALUES +(1, 'fake-class_document'), +(2, 'fake-class_url'), +(3, 'fake-class_text'), +(4, 'fake-class_dynamic'), +(5, 'fake-class_video'); + +-- -------------------------------------------------------- + +-- +-- 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` +-- + +INSERT INTO `url_content` (`id`, `name`, `url`) VALUES +(63, 'fsa', 'dfsa'); + +-- -------------------------------------------------------- + +-- +-- 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, + `start_pos_ms` int(11) NOT NULL, + `autostart` tinyint(1) NOT NULL, + `play_sound` tinyint(1) NOT NULL, + `brightness` int(11) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; + +-- +-- Vypisuji data pro tabulku `video_content` +-- + + +-- +-- Omezení pro exportované tabulky +-- + +-- +-- Omezení pro tabulku `category` +-- +ALTER TABLE `category` + ADD CONSTRAINT `FK_Reference_35` FOREIGN KEY (`elvys_group`) REFERENCES `elvys_group` (`id`), + ADD CONSTRAINT `FK_Reference_36` FOREIGN KEY (`planning`) REFERENCES `category_planning` (`id`), + ADD CONSTRAINT `FK_Reference_39` FOREIGN KEY (`definition`) REFERENCES `category_definition` (`id`); + +-- +-- Omezení pro tabulku `category_definition` +-- +ALTER TABLE `category_definition` + ADD CONSTRAINT `FK_Reference_40` FOREIGN KEY (`layout`) REFERENCES `layout` (`id`); + +-- +-- Omezení pro tabulku `category_planning` +-- +ALTER TABLE `category_planning` + ADD CONSTRAINT `FK_Reference_43` FOREIGN KEY (`definition`) REFERENCES `category_definition` (`id`); + +-- +-- Omezení pro tabulku `company` +-- +ALTER TABLE `company` + ADD CONSTRAINT `FK_Reference_21` FOREIGN KEY (`setting`) REFERENCES `comp_setting` (`id`); + +-- +-- Omezení pro tabulku `comp_permitted_type` +-- +ALTER TABLE `comp_permitted_type` + ADD CONSTRAINT `FK_company_2` FOREIGN KEY (`company`) REFERENCES `company` (`id`), + ADD CONSTRAINT `FK_Reference_19` FOREIGN KEY (`content`) REFERENCES `content_type` (`id`); + +-- +-- Omezení pro tabulku `content_type` +-- +ALTER TABLE `content_type` + ADD CONSTRAINT `FK_Reference_20` FOREIGN KEY (`plug`) REFERENCES `type_plug` (`id`), + ADD CONSTRAINT `FK_Reference_41` FOREIGN KEY (`file_type`) REFERENCES `file_type` (`id`); + +-- +-- Omezení pro tabulku `elvys` +-- +ALTER TABLE `elvys` + ADD CONSTRAINT `FK_Reference_23` FOREIGN KEY (`resolution`) REFERENCES `resolution` (`id`), + ADD CONSTRAINT `FK_Reference_3` FOREIGN KEY (`company`) REFERENCES `company` (`id`), + ADD CONSTRAINT `FK_Reference_33` FOREIGN KEY (`elvys_group`) REFERENCES `elvys_group` (`id`), + ADD CONSTRAINT `FK_Reference_7` FOREIGN KEY (`setting`) REFERENCES `elvys_setting` (`id`); + +-- +-- Omezení pro tabulku `file` +-- +ALTER TABLE `file` + ADD CONSTRAINT `FK_Reference_30` FOREIGN KEY (`user`) REFERENCES `user` (`id`), + ADD CONSTRAINT `FK_Reference_38` FOREIGN KEY (`file_type`) REFERENCES `file_type` (`id`); + +-- +-- Omezení pro tabulku `file_frame_content` +-- +ALTER TABLE `file_frame_content` + ADD CONSTRAINT `FK_Reference_46` FOREIGN KEY (`file`) REFERENCES `file` (`id`); + +-- +-- Omezení pro tabulku `frame_content` +-- +ALTER TABLE `frame_content` + ADD CONSTRAINT `FK_Reference_16` FOREIGN KEY (`type`) REFERENCES `content_type` (`id`); + +-- +-- Omezení pro tabulku `label_ref` +-- +ALTER TABLE `label_ref` + ADD CONSTRAINT `FK_Reference_32` FOREIGN KEY (`label`) REFERENCES `label` (`id`), + ADD CONSTRAINT `FK_Reference_34` FOREIGN KEY (`file`) REFERENCES `file` (`id`); + +-- +-- Omezení pro tabulku `layout` +-- +ALTER TABLE `layout` + ADD CONSTRAINT `FK_Reference_12` FOREIGN KEY (`company`) REFERENCES `company` (`id`), + ADD CONSTRAINT `FK_Reference_22` FOREIGN KEY (`aspect_ratio`) REFERENCES `aspect_ratio` (`id`), + ADD CONSTRAINT `FK_Reference_28` FOREIGN KEY (`lastLockUser`) REFERENCES `user` (`id`), + ADD CONSTRAINT `FK_Reference_47` FOREIGN KEY (`modified_by`) REFERENCES `user` (`id`); + +-- +-- Omezení pro tabulku `layout_position` +-- +ALTER TABLE `layout_position` + ADD CONSTRAINT `FK_Reference_13` FOREIGN KEY (`layout`) REFERENCES `layout` (`id`); + +-- +-- Omezení pro tabulku `panel` +-- +ALTER TABLE `panel` + ADD CONSTRAINT `FK_Reference_44` FOREIGN KEY (`planning`) REFERENCES `category_planning` (`id`); + +-- +-- Omezení pro tabulku `permitted_scheduling` +-- +ALTER TABLE `permitted_scheduling` + ADD CONSTRAINT `FK_Reference_14` FOREIGN KEY (`layout`, `position`) REFERENCES `layout_position` (`layout`, `position`), + ADD CONSTRAINT `FK_Reference_15` FOREIGN KEY (`permitted_type`) REFERENCES `content_type` (`id`); + +-- +-- Omezení pro tabulku `resolution` +-- +ALTER TABLE `resolution` + ADD CONSTRAINT `FK_Reference_24` FOREIGN KEY (`aspect_ratio`) REFERENCES `aspect_ratio` (`id`); + +-- +-- Omezení pro tabulku `statistics` +-- +ALTER TABLE `statistics` + ADD CONSTRAINT `FK_Reference_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`), + ADD CONSTRAINT `FK_Reference_37` FOREIGN KEY (`category`) REFERENCES `category_definition` (`id`); + +-- +-- Omezení pro tabulku `timeline` +-- +ALTER TABLE `timeline` + ADD CONSTRAINT `FK_Reference_10` FOREIGN KEY (`layout`) REFERENCES `layout` (`id`), + ADD CONSTRAINT `FK_Reference_42` FOREIGN KEY (`panel_planning`, `panel_order_num`) REFERENCES `panel` (`planning`, `order_num`), + ADD CONSTRAINT `FK_Reference_45` FOREIGN KEY (`modified_by`) REFERENCES `user` (`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`);