- Timestamp:
- Oct 27, 2008, 5:10:59 PM (16 years ago)
- File:
-
- 1 edited
-
sql/demo_database.sql (modified) (8 diffs)
Legend:
- Unmodified
- Added
- Removed
-
sql/demo_database.sql
r18 r24 1 1 -- phpMyAdmin SQL Dump 2 -- version 2.11.9.22 -- version 3.0.1 3 3 -- http://www.phpmyadmin.net 4 4 -- 5 5 -- Počítač: localhost 6 -- Vygenerováno: Úterý 21. října 2008, 16:146 -- Vygenerováno: Pondělí 27. října 2008, 14:15 7 7 -- Verze MySQL: 5.0.51 8 8 -- Verze PHP: 5.2.6 … … 190 190 191 191 -- 192 -- Struktura tabulky `dd` 193 -- 194 195 CREATE TABLE IF NOT EXISTS `dd` ( 196 `Id` int(11) NOT NULL auto_increment, 197 `ItemId` int(11) NOT NULL, 198 `Author` int(11) NOT NULL, 199 `ValidTimeFrom` datetime default NULL, 200 `ValidTimeTo` datetime default NULL, 201 `CreationTime` datetime default NULL, 202 `DeletionTime` datetime default NULL, 203 PRIMARY KEY (`Id`) 204 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ; 205 206 -- 207 -- Vypisuji data pro tabulku `dd` 208 -- 209 210 211 -- -------------------------------------------------------- 212 213 -- 192 214 -- Struktura tabulky `FinanceTransaction` 193 215 -- … … 258 280 `SubHostList` int(11) NOT NULL, 259 281 PRIMARY KEY (`Id`) 260 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 4;282 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=15 ; 261 283 262 284 -- … … 266 288 INSERT INTO `Host` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `DomainName`, `NetBIOSName`, `LocalIPAddress`, `PublicIPAddress`, `LastOnlineDate`, `Type`, `Interface`, `ParentHost`, `Member`, `Area`, `SubHostList`) VALUES 267 289 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'george', 'GEORGE', '192.168.0.23', '', '0000-00-00', 1, 0, 4, 0, 0, 0), 268 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'stroj', 'STROJ', '192.168.1.44', '33.66.44.77', '0000-00-00', 5, 0, 0, 0, 0, 0),290 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:05:42', 'stroj', 'STROJ', '192.168.1.44', '33.66.44.77', '0000-00-00', 5, 0, 0, 0, 0, 0), 269 291 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'telefon', 'TELEFON', '192.168.1.45', '', '0000-00-00', 2, 0, 4, 1, 2, 0), 270 292 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'router-inet', 'ROUTER-INET', '192.168.0.2', '77.33.55.12', '0000-00-00', 4, 0, 1, 1, 4, 0), … … 277 299 (11, 7, 5, '2008-10-19 20:01:24', NULL, '2008-10-19 20:01:24', '2008-10-19 20:03:14', 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '1900-01-01', 6, 0, 4, 2, 5, 0), 278 300 (12, 7, 5, '2008-10-19 20:03:14', NULL, '2008-10-19 20:03:14', '2008-10-19 20:03:19', 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '1900-01-01', 6, 0, 4, 2, 5, 0), 279 (13, 7, 5, '2008-10-19 20:03:19', NULL, '2008-10-19 20:03:19', NULL, 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '1900-01-01', 6, 0, 4, 2, 2, 0); 301 (13, 7, 5, '2008-10-19 20:03:19', NULL, '2008-10-19 20:03:19', NULL, 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '1900-01-01', 6, 0, 4, 2, 2, 0), 302 (14, 2, 28, '2008-10-22 08:05:42', NULL, '2008-10-22 08:05:42', NULL, 'stroj', 'STROJ', '192.168.1.44', '33.66.44.77', '1900-01-01', 5, 0, 4, 4, 3, 0); 280 303 281 304 -- -------------------------------------------------------- … … 505 528 `PermissionGroup` int(11) NOT NULL, 506 529 PRIMARY KEY (`Id`) 507 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 3;530 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=49 ; 508 531 509 532 -- … … 553 576 (40, 31, 28, '2008-10-21 14:45:36', NULL, '2008-10-21 14:45:36', NULL, 23, 0, 2, 1), 554 577 (41, 32, 28, '2008-10-21 14:54:31', NULL, '2008-10-21 14:54:31', NULL, 22, 0, 2, 1), 555 (42, 33, 28, '2008-10-21 16:09:19', NULL, '2008-10-21 16:09:19', NULL, 24, 0, 1, 1); 578 (42, 33, 28, '2008-10-21 16:09:19', NULL, '2008-10-21 16:09:19', NULL, 24, 0, 1, 1), 579 (43, 34, 28, '2008-10-22 07:13:27', NULL, '2008-10-22 07:13:27', NULL, 12, 0, 2, 1), 580 (44, 35, 28, '2008-10-22 07:43:39', NULL, '2008-10-22 07:43:39', NULL, 2, 0, 2, 1), 581 (45, 36, 5, '2008-10-22 11:50:06', NULL, '2008-10-22 11:50:06', NULL, 6, 0, 2, 1), 582 (46, 37, 5, '2008-10-22 11:50:30', NULL, '2008-10-22 11:50:30', NULL, 10, 0, 2, 1), 583 (47, 38, 5, '2008-10-27 14:04:48', NULL, '2008-10-27 14:04:48', NULL, 28, 0, 2, 1), 584 (48, 39, 5, '2008-10-27 14:14:03', NULL, '2008-10-27 14:14:03', NULL, 33, 0, 2, 1); 556 585 557 586 -- -------------------------------------------------------- … … 645 674 646 675 -- 647 -- Struktura tabulky `SystemFile` 648 -- 649 650 CREATE TABLE IF NOT EXISTS `SystemFile` ( 651 `Id` int(11) NOT NULL auto_increment, 676 -- Struktura tabulky `SystemEnumerationState` 677 -- 678 679 CREATE TABLE IF NOT EXISTS `SystemEnumerationState` ( 680 `Id` int(11) NOT NULL auto_increment, 681 `ItemId` int(11) NOT NULL, 682 `Author` int(11) NOT NULL, 683 `ValidTimeFrom` datetime default NULL, 684 `ValidTimeTo` datetime default NULL, 685 `CreationTime` datetime default NULL, 686 `DeletionTime` datetime default NULL, 652 687 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 653 `Content` mediumblob NOT NULL, 688 `ParentParameter` int(11) NOT NULL, 689 PRIMARY KEY (`Id`) 690 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ; 691 692 -- 693 -- Vypisuji data pro tabulku `SystemEnumerationState` 694 -- 695 696 697 -- -------------------------------------------------------- 698 699 -- 700 -- Struktura tabulky `SystemGPS` 701 -- 702 703 CREATE TABLE IF NOT EXISTS `SystemGPS` ( 704 `Id` int(11) NOT NULL auto_increment, 705 `Longitude` double NOT NULL, 706 `Latitude` double NOT NULL, 707 PRIMARY KEY (`Id`) 708 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=32 ; 709 710 -- 711 -- Vypisuji data pro tabulku `SystemGPS` 712 -- 713 714 INSERT INTO `SystemGPS` (`Id`, `Longitude`, `Latitude`) VALUES 715 (1, 0, 0), 716 (2, 0, 1.0341666666667), 717 (3, 0, 12.067777777778), 718 (4, 5.1019444444444, 12.067777777778), 719 (5, 5.0516666666667, 12.117777777778), 720 (6, 5.0516666666667, -11.882222222222), 721 (7, 5.0516666666667, -11.085555555556), 722 (8, 5.0516666666667, -11.084444444444), 723 (9, 5.0516666666667, -11.083611111111), 724 (10, 5.0516666666667, -11.083611111111), 725 (11, 5.0516666666667, 11.084722222222), 726 (12, 5.0516666666667, 11.084444444444), 727 (13, 5.0519444444444, 11.084166666667), 728 (14, 5.0522222222222, 11.084166666667), 729 (15, 5.0519444444444, 11.084166666667), 730 (16, 5.0516666666667, 11.084444444444), 731 (17, 5.0516666666667, 11.084166666667), 732 (18, 5.0516666666667, 11.084166666667), 733 (19, 5.0516666666667, 11.083888888889), 734 (20, 5.0516666666667, 11.089444444444), 735 (21, 5.0516666666667, 11.089444444444), 736 (22, 5.0516666666667, 11.089166666667), 737 (23, 5.0516666666667, 11.089166666667), 738 (24, 5.0516666666667, 11.089166666667), 739 (25, 5.0516666666667, 11.089444444444), 740 (26, 5.0516666666667, 11.089444444444), 741 (27, 18.080528888889, 49.257925555556), 742 (28, 18.077825, 49.258213611111), 743 (29, 18.077825, 49.258213611111), 744 (30, 0, 0), 745 (31, 0, 0); 746 747 -- -------------------------------------------------------- 748 749 -- 750 -- Struktura tabulky `SystemList` 751 -- 752 753 CREATE TABLE IF NOT EXISTS `SystemList` ( 754 `Id` int(11) NOT NULL auto_increment, 755 `ItemId` int(11) NOT NULL, 756 `Author` int(11) NOT NULL, 757 `ValidTimeFrom` datetime default NULL, 758 `ValidTimeTo` datetime default NULL, 759 `CreationTime` datetime default NULL, 760 `DeletionTime` datetime default NULL, 761 `TableName` varchar(255) collate utf8_czech_ci NOT NULL, 762 `Title` varchar(255) collate utf8_czech_ci NOT NULL, 763 `Items` varchar(255) collate utf8_czech_ci NOT NULL, 764 `Menu` int(11) NOT NULL, 765 PRIMARY KEY (`Id`) 766 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=84 ; 767 768 -- 769 -- Vypisuji data pro tabulku `SystemList` 770 -- 771 772 INSERT INTO `SystemList` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `TableName`, `Title`, `Items`, `Menu`) VALUES 773 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:19:21', 'User', 'Uživatelé', '', 0), 774 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:07', 'Host', 'Zařízení', '', 0), 775 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:19:30', 'Subject', 'Finanční subjekty', '', 0), 776 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:12', 'Member', 'Členové sítě', '', 0), 777 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:19:35', 'Area', 'Oblasti', '', 0), 778 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:16', 'Interface', 'Rozhraní zařízení', '', 0), 779 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:19:41', 'Asset', 'Majetek', '', 0), 780 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:20', 'Tariff', 'Tarify', '', 0), 781 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:19:46', 'MemberReport', 'Hlášení členů', '', 0), 782 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:19:58', 'BankAccount', 'Bankovní účty', '', 0), 783 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:25', 'SystemType', 'Definice typů', '', 0), 784 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:28', 'FinanceTransaction', 'Platební operace', '', 0), 785 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:11:18', 'SystemList', 'Definice tabulek', '', 0), 786 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:33', 'SystemListItem', 'Definice položek formulářů', '', 0), 787 (15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:39', 'UserOnline', 'Přihlášení uživatelé', '', 0), 788 (16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:48', 'History', 'Historie záznamů', '', 0), 789 (34, 20, 5, '2008-10-13 12:12:05', NULL, '2008-10-22 08:15:01', '2008-10-21 08:20:54', 'SystemLog', 'Deník změn', '', 0), 790 (26, 17, 5, '2008-10-12 18:38:17', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-13 12:16:59', 'Test', 'Testovací tabulka', '', 0), 791 (33, 19, 5, '2008-10-13 10:19:34', NULL, '2008-10-22 08:15:01', '2008-10-21 08:20:58', 'Permission', 'Oprávnění', '', 0), 792 (32, 18, 5, '2008-10-13 09:53:03', NULL, '2008-10-22 08:15:01', '2008-10-21 08:21:03', 'PermissionGroup', 'Skupiny oprávnění', '', 0), 793 (35, 21, 5, '2008-10-21 07:46:53', NULL, '2008-10-22 08:15:01', '2008-10-21 08:06:34', 'Menu', 'Nabídka', '', 0), 794 (36, 21, 5, '2008-10-21 08:06:34', NULL, '2008-10-22 08:15:01', '2008-10-21 08:07:02', 'dd', 'Nabídka', '', 0), 795 (37, 21, 5, '2008-10-21 08:07:02', NULL, '2008-10-22 08:15:01', '2008-10-21 08:07:20', 'dd', 'Nabídka', '', 0), 796 (38, 21, 5, '2008-10-21 08:07:20', NULL, '2008-10-22 08:15:01', '2008-10-21 08:10:18', 'Menu', 'Nabídka', '', 0), 797 (39, 21, 5, '2008-10-21 08:10:18', NULL, '2008-10-22 08:15:01', '2008-10-21 08:10:28', 'Menuf', 'Nabídka', '', 0), 798 (40, 21, 5, '2008-10-21 08:10:28', NULL, '2008-10-22 08:15:01', '2008-10-21 08:10:38', 'Menu', 'Nabídka', '', 0), 799 (41, 21, 5, '2008-10-21 08:10:38', NULL, '2008-10-22 08:15:01', '2008-10-21 08:21:07', 'SystemMenu', 'Nabídka', '', 0), 800 (42, 13, 5, '2008-10-21 08:11:18', NULL, '2008-10-22 08:15:01', '2008-10-21 08:19:13', 'SystemList', 'Definice seznamů', '', 0), 801 (43, 13, 5, '2008-10-21 08:19:13', NULL, '2008-10-22 08:15:01', NULL, 'SystemList', 'Definice seznamů', '', 1), 802 (44, 1, 5, '2008-10-21 08:19:21', NULL, '2008-10-22 08:15:01', '2008-10-21 08:55:47', 'User', 'Uživatelé', '', 1), 803 (45, 3, 5, '2008-10-21 08:19:30', NULL, '2008-10-22 08:15:01', NULL, 'Subject', 'Finanční subjekty', '', 2), 804 (46, 5, 5, '2008-10-21 08:19:35', NULL, '2008-10-22 08:15:01', NULL, 'Area', 'Oblasti', '', 2), 805 (47, 7, 5, '2008-10-21 08:19:41', NULL, '2008-10-22 08:15:01', NULL, 'Asset', 'Majetek', '', 2), 806 (48, 9, 5, '2008-10-21 08:19:46', NULL, '2008-10-22 08:15:01', '2008-10-21 08:56:03', 'MemberReport', 'Hlášení členů', '', 1), 807 (49, 10, 5, '2008-10-21 08:19:58', NULL, '2008-10-22 08:15:01', NULL, 'BankAccount', 'Bankovní účty', '', 2), 808 (50, 2, 5, '2008-10-21 08:20:07', NULL, '2008-10-22 08:15:01', NULL, 'Host', 'Zařízení', '', 2), 809 (51, 4, 5, '2008-10-21 08:20:12', NULL, '2008-10-22 08:15:01', NULL, 'Member', 'Členové sítě', '', 2), 810 (52, 6, 5, '2008-10-21 08:20:16', NULL, '2008-10-22 08:15:01', NULL, 'Interface', 'Rozhraní zařízení', '', 2), 811 (53, 8, 5, '2008-10-21 08:20:20', NULL, '2008-10-22 08:15:01', NULL, 'Tariff', 'Tarify', '', 2), 812 (54, 11, 5, '2008-10-21 08:20:25', NULL, '2008-10-22 08:15:01', NULL, 'SystemType', 'Definice typů', '', 1), 813 (55, 12, 5, '2008-10-21 08:20:28', NULL, '2008-10-22 08:15:01', NULL, 'FinanceTransaction', 'Platební operace', '', 2), 814 (56, 14, 5, '2008-10-21 08:20:33', NULL, '2008-10-22 08:15:01', '2008-10-21 13:20:18', 'SystemListItem', 'Definice položek formulářů', '', 1), 815 (57, 15, 5, '2008-10-21 08:20:39', NULL, '2008-10-22 08:15:01', '2008-10-21 08:56:29', 'UserOnline', 'Přihlášení uživatelé', '', 1), 816 (58, 16, 5, '2008-10-21 08:20:48', NULL, '2008-10-22 08:15:01', '2008-10-21 08:38:31', 'History', 'Historie záznamů', '', 2), 817 (59, 20, 5, '2008-10-21 08:20:54', NULL, '2008-10-22 08:15:01', NULL, 'SystemLog', 'Deník změn', '', 1), 818 (60, 19, 5, '2008-10-21 08:20:58', NULL, '2008-10-22 08:15:01', '2008-10-21 08:56:11', 'Permission', 'Oprávnění', '', 1), 819 (61, 18, 5, '2008-10-21 08:21:03', NULL, '2008-10-22 08:15:01', '2008-10-21 08:56:22', 'PermissionGroup', 'Skupiny oprávnění', '', 1), 820 (62, 21, 5, '2008-10-21 08:21:07', NULL, '2008-10-22 08:15:01', NULL, 'SystemMenu', 'Nabídka', '', 1), 821 (63, 1, 5, '2008-10-21 08:55:47', NULL, '2008-10-22 08:15:01', NULL, 'User', 'Uživatelé', '', 3), 822 (64, 9, 5, '2008-10-21 08:56:03', NULL, '2008-10-22 08:15:01', NULL, 'MemberReport', 'Hlášení členů', '', 2), 823 (65, 19, 5, '2008-10-21 08:56:11', NULL, '2008-10-22 08:15:01', '2008-10-21 13:19:58', 'Permission', 'Oprávnění', '', 3), 824 (66, 18, 5, '2008-10-21 08:56:22', NULL, '2008-10-22 08:15:01', NULL, 'PermissionGroup', 'Skupiny oprávnění', '', 3), 825 (67, 15, 5, '2008-10-21 08:56:29', NULL, '2008-10-22 08:15:01', NULL, 'UserOnline', 'Přihlášení uživatelé', '', 3), 826 (68, 19, 5, '2008-10-21 13:19:58', NULL, '2008-10-22 08:15:01', NULL, 'Permission', 'Oprávnění', '', 0), 827 (69, 14, 5, '2008-10-21 13:20:18', NULL, '2008-10-22 08:15:01', NULL, 'SystemListItem', 'Definice položek formulářů', '', 0), 828 (70, 22, 28, '2008-10-21 14:38:25', NULL, '2008-10-22 08:15:01', '2008-10-21 14:38:44', 'NewsItem', 'Aktuality', '', 0), 829 (71, 22, 28, '2008-10-21 14:38:44', NULL, '2008-10-22 08:15:01', '2008-10-21 14:39:54', 'NewsItem', 'Aktuality', '', 4), 830 (72, 23, 28, '2008-10-21 14:39:36', NULL, '2008-10-22 08:15:01', NULL, 'NewsGroup', 'Skupiny aktualit', '', 4), 831 (73, 22, 28, '2008-10-21 14:39:54', NULL, '2008-10-22 08:15:01', NULL, 'NewsItem', 'Aktuality', '', 0), 832 (74, 24, 28, '2008-10-21 16:06:09', NULL, '2008-10-22 08:15:01', NULL, 'CableTV', 'Kabelová televize', '', 4), 833 (75, 25, 5, '2008-10-22 12:49:17', NULL, '2008-10-22 12:49:17', '2008-10-22 12:50:21', 'Test', 'test', '', 0), 834 (76, 26, 5, '2008-10-22 12:50:58', NULL, '2008-10-22 12:50:58', '2008-10-27 13:52:40', 'test', 'test', '', 0), 835 (77, 27, 5, '2008-10-22 12:52:24', NULL, '2008-10-22 12:52:24', '2008-10-27 13:52:34', 'test', 'test', '', 0), 836 (78, 28, 5, '2008-10-27 10:35:54', NULL, '2008-10-27 10:35:54', NULL, 'SystemTypeParameter', 'Parametr typu', '', 0), 837 (79, 29, 5, '2008-10-27 11:03:03', NULL, '2008-10-27 11:03:03', '2008-10-27 13:55:21', 'SystemTypeParameter', 'Parametr typu', '', 0), 838 (80, 30, 5, '2008-10-27 12:05:17', NULL, '2008-10-27 12:05:17', '2008-10-27 12:18:24', 'SystemTypeParameter', 'Parametr typu', '', 0), 839 (81, 31, 5, '2008-10-27 12:11:07', NULL, '2008-10-27 12:11:07', '2008-10-27 12:18:22', 'SystemTypeParameter', 'Parametr typu', '', 0), 840 (82, 32, 5, '2008-10-27 13:55:28', NULL, '2008-10-27 13:55:28', '2008-10-27 13:55:49', 'dd', 'dd', '', 0), 841 (83, 33, 5, '2008-10-27 14:10:43', NULL, '2008-10-27 14:10:43', NULL, 'SystemEnumerationState', 'Stavy výčtů', '', 0); 842 843 -- -------------------------------------------------------- 844 845 -- 846 -- Struktura tabulky `SystemListItem` 847 -- 848 849 CREATE TABLE IF NOT EXISTS `SystemListItem` ( 850 `Id` int(11) NOT NULL auto_increment, 851 `ItemId` int(11) NOT NULL, 852 `Author` int(11) NOT NULL, 853 `ValidTimeFrom` datetime default NULL, 854 `ValidTimeTo` datetime default NULL, 855 `CreationTime` datetime default NULL, 856 `DeletionTime` datetime default NULL, 857 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 858 `TextBefore` varchar(255) collate utf8_czech_ci NOT NULL, 859 `TextAfter` varchar(255) collate utf8_czech_ci NOT NULL, 860 `Type` varchar(255) collate utf8_czech_ci NOT NULL, 861 `Help` varchar(255) collate utf8_czech_ci NOT NULL, 862 `Default` varchar(255) collate utf8_czech_ci NOT NULL, 863 `Required` tinyint(1) NOT NULL default '1', 864 `Editable` tinyint(1) NOT NULL default '1', 865 `VisibleInList` tinyint(1) NOT NULL default '0', 866 `VisibleInPointer` tinyint(1) NOT NULL default '0', 867 `List` int(11) NOT NULL, 868 PRIMARY KEY (`Id`) 869 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=196 ; 870 871 -- 872 -- Vypisuji data pro tabulku `SystemListItem` 873 -- 874 875 INSERT INTO `SystemListItem` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `TextBefore`, `TextAfter`, `Type`, `Help`, `Default`, `Required`, `Editable`, `VisibleInList`, `VisibleInPointer`, `List`) VALUES 876 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'FirstName', 'Jméno', '', '3', 'Zadejte jméno', '', 1, 1, 1, 1, 1), 877 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'SecondName', 'Příjmení', '', '3', 'Zadejte příjmení', '', 1, 1, 1, 1, 1), 878 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Email', 'E-mail', '', '3', 'Zadejte emailovou adresu', '', 1, 1, 1, 0, 1), 879 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ICQ', 'ICQ', '', '1', 'Zadejte kontaktní číslo textového komunikačního programu ICQ.', '', 0, 1, 0, 0, 1), 880 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Sex', 'Pohlaví', '', '5', 'Vyberte pohlaví osoby', '', 0, 1, 0, 0, 1), 881 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'BirthDay', 'Datum narození', '', '2', 'Vyberte datum narození', '', 0, 1, 0, 0, 1), 882 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'DomainName', 'Doménové jméno', '', '3', 'Zadejte jméno počítače v doméně', '', 1, 1, 1, 1, 2), 883 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'NetBIOSName', 'NetBIOSové jméno', '', '3', 'Zadejte jméno počítače v rámci protokolů NetBIOS a sdílení souborů', '', 0, 1, 0, 0, 2), 884 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'LocalIPAddress', 'Místní IP adresa', '', '3', 'Zadejte síťovou adresu používanou v rámci místní sítě', '', 1, 1, 1, 0, 2), 885 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'PublicIPAddress', 'Veřejná IP adresa', '', '3', 'Zadejte síťovou adresu používanou v rámci Internetu', '', 0, 1, 1, 0, 2), 886 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'LastOnlineDate', 'Naposledy online', '', '2', 'Čas posledního úspěšného měření dostupnosti počítače', '', 0, 0, 0, 0, 2), 887 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Jméno', '', '3', 'Jméno subjektu', '', 1, 1, 1, 1, 3), 888 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'AddressStreet', 'Ulice', '', '3', 'Ulice', '', 1, 1, 1, 0, 3), 889 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'AddressTown', 'Město', '', '3', 'Město', '', 1, 1, 1, 0, 3), 890 (15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'AddressZIP', 'PSČ', '', '3', '', '', 1, 1, 1, 0, 3), 891 (16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'IC', 'IČ', '', '3', 'Identifikační číslo subjektu', '', 0, 1, 0, 0, 3), 892 (17, 17, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'DIC', 'DIČ', '', '3', 'Daňové identifikační číslo', '', 0, 1, 0, 0, 3), 893 (18, 18, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', '2008-10-21 10:01:03', 'MapPositionX', 'Horizontálně pozice', '', '1', 'Vodorovná pozice na mapě', '', 0, 1, 0, 0, 4), 894 (19, 19, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', '2008-10-21 10:00:27', 'MapPositionY', 'Vertikální pozice', '', '1', 'Svislá pozice na mapě', '', 0, 1, 0, 0, 4), 895 (20, 20, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MembershipDate', 'Začátek členství', '', '2', 'Datum přípojení do sítě', '', 0, 1, 0, 0, 4), 896 (21, 21, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'FamilyMemberCount', 'Osob v rodině', '', '1', 'Počet osob v připojené domácnosti', '', 0, 1, 0, 0, 4), 897 (22, 22, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ResponsibleUser', 'Zodpovědný uživatel', '', '37', '', '', 1, 1, 1, 1, 4), 898 (23, 23, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Subject', 'Subjekt', '', '33', '', '', 1, 1, 0, 0, 4), 899 (24, 24, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Type', 'Druh', '', '7', '', '1', 0, 1, 1, 0, 2), 900 (25, 25, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Phone', 'Telefón', '', '3', '', '', 0, 1, 0, 0, 1), 901 (26, 26, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Notice', 'Poznámka', '', '3', '', '', 0, 1, 0, 0, 3), 902 (27, 27, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MemberState', 'Stav připojení', '', '6', '', '', 1, 1, 1, 0, 4), 903 (28, 28, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'HostList', 'Registrované zařízení', '', '23', '', '', 0, 1, 0, 0, 4), 904 (29, 29, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 5), 905 (30, 30, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'NetworkIPAddress', 'Adresa sítě', '', '3', '', '', 1, 1, 1, 0, 5), 906 (31, 31, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'IPAddressMask', 'Maska sítě', '', '3', '', '', 1, 1, 1, 0, 5), 907 (32, 32, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'DNSPrimary', 'Primární DNS server', '', '3', '', '', 0, 1, 0, 0, 5), 908 (33, 33, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'DNSSecondary', 'Sukundární DNS server', '', '3', '', '', 0, 1, 0, 0, 5), 909 (34, 34, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'DHCP', 'DHCP server', '', '3', '', '', 0, 1, 0, 0, 5), 910 (35, 35, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Domain', 'Doména', '', '3', '', '', 0, 1, 0, 0, 5), 911 (36, 36, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Workgroup', 'Pracovní skupina', '', '3', '', '', 0, 1, 0, 0, 5), 912 (37, 37, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'WINS', 'WINS server', '', '3', '', '', 0, 1, 0, 0, 5), 913 (38, 38, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 6), 914 (39, 39, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Type', 'Typ', '', '8', '', '', 1, 1, 1, 0, 6), 915 (40, 40, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Host', 'Zařízení', '', '31', 'Vyberte zařízení, ke kterému patří toto rozhraní.', '', 1, 1, 1, 0, 6), 916 (41, 41, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ParentHost', 'Připojeno k bodu', '', '31', '', '', 1, 1, 1, 0, 6), 917 (42, 42, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Interface', 'Rozhraní', '', '24', '', '', 0, 1, 0, 0, 2), 918 (43, 43, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MAC', 'Fyzická adresa', '', '3', 'Zadejte fyzickou adresu síťové karty též nazývanou MAC adresa.', '', 1, 1, 0, 0, 6), 919 (44, 44, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ParentHost', 'Nadřazený uzel', '', '31', '', '', 0, 1, 0, 0, 2), 920 (45, 45, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'SubHostList', 'Připojené zařízení', '', '38', 'Seznam podřízených zařízení ve virtuálním stromu propojení.', '', 0, 1, 0, 0, 2), 921 (46, 46, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 7), 922 (47, 47, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TimeEnlistment', 'Čas zařazení', '', '2', '', '', 1, 1, 0, 0, 7), 923 (48, 48, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TimeElimination', 'Čas vyřazení', '', '2', '', '', 0, 1, 0, 0, 7), 924 (49, 49, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Price', 'Pořizovací cena', '', '1', '', '', 1, 1, 1, 0, 7), 925 (50, 50, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'State', 'Stav', '', '9', '', '', 1, 1, 1, 0, 7), 926 (51, 51, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'SerialNumber', 'Sériové číslo', '', '3', '', '', 0, 1, 0, 0, 7), 927 (52, 52, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'PurcheasedFrom', 'Zakoupeno od', '', '33', '', '', 0, 1, 0, 0, 7), 928 (53, 53, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'PurcheasedAsset', 'Nakoupené zboží', '', '21', '', '', 0, 1, 0, 0, 3), 929 (54, 54, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Member', 'Člen', '', '32', '', '', 0, 1, 0, 0, 1), 930 (113, 113, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', '2008-10-21 10:17:25', 'ValidFromTime', 'Platnost od', '', '2', '', '', 1, 1, 0, 0, 4), 931 (57, 57, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Price', 'Cena', '', '1', '', '', 1, 1, 1, 0, 8), 932 (56, 56, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 8), 933 (58, 58, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MinUploadSpeed', 'Minimální odchozí rychlost', '', '1', '', '', 1, 1, 0, 0, 8), 934 (59, 59, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MaxUploadSpeed', 'Maximální odchozí rychlost', '', '1', '', '', 1, 1, 1, 0, 8), 935 (60, 60, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MinDownloadSpeed', 'Minimální příchozí rychlost', '', '1', '', '', 1, 1, 0, 0, 8), 936 (61, 61, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MaxDownloadSpeed', 'Max příchozí rychlost', '', '1', '', '', 1, 1, 1, 0, 8), 937 (62, 62, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'UserName', 'Uživatelské jméno', '', '3', '', '', 1, 1, 0, 0, 1), 938 (63, 63, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Password', 'Heslo', '', '15', '', '', 1, 1, 0, 0, 1), 939 (64, 64, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Member', 'Členové', '', '26', '', '', 0, 1, 0, 0, 8), 940 (65, 65, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Tariff', 'Tarif', '', '36', '', '', 1, 1, 1, 0, 4), 941 (66, 66, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Member', 'Vlastník', '', '32', '', '', 0, 1, 0, 0, 2), 942 (67, 67, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'WWW', 'Internetové stránky', '', '18', '', '', 0, 1, 0, 0, 3), 943 (68, 68, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Text', 'Text zprávy', '', '3', '', '', 1, 1, 1, 1, 9), 944 (69, 69, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Date', 'Datum', '', '2', '', '', 1, 1, 1, 0, 9), 945 (70, 70, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Member', 'Člen', '', '32', '', '', 1, 1, 1, 0, 9), 946 (71, 71, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Type', 'Typ zprávy', '', '10', '', '', 1, 1, 1, 0, 9), 947 (72, 72, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ReportList', 'Záznamy', '', '27', '', '', 0, 1, 0, 0, 4), 948 (73, 73, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Creator', 'Vložil', '', '37', '', '', 1, 1, 0, 0, 9), 949 (74, 74, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 10), 950 (75, 75, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'BankName', 'Jméno banky', '', '3', '', '', 1, 1, 0, 0, 10), 951 (76, 76, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Number', 'Identifikační číslo', '', '3', '', '', 1, 1, 1, 0, 10), 952 (77, 77, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'BankCode', 'Kód banky', '', '3', '', '', 1, 1, 1, 0, 10), 953 (78, 78, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'User', 'Registroval', '', '37', '', '', 0, 1, 0, 0, 10), 954 (79, 79, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Type', 'Typ', '', '11', '', '', 1, 1, 1, 0, 10), 955 (80, 80, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MemberList', 'Členství', '', '25', '', '', 0, 1, 0, 0, 3), 956 (81, 81, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Systémové jméno typu', '', '3', 'Jméno by mělo obsahovat pouze velké a malé písmena. V podsložece types projektu jsou umístěny výkonné soubory pro jednotlivé typy.', 'Name', 1, 1, 1, 1, 11), 957 (82, 82, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ParentType', 'Rodičovský typ', '', '35', '', '', 1, 1, 1, 0, 11), 958 (83, 83, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Parameters', 'Parametry typu', '', '3', '', 'Parametry zadávejte jako řetězce oddělené symblem "|".', 0, 1, 0, 0, 11), 959 (84, 84, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'System', 'Systémový', '', '4', '', '0', 1, 1, 0, 0, 11), 960 (88, 88, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Description', 'Popis', '', '3', '', '', 1, 1, 1, 0, 11), 961 (89, 89, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Description', 'Popis', '', '3', '', '', 1, 1, 1, 0, 12), 962 (90, 90, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Amount', 'Částka', '', '16', '', '', 1, 1, 1, 0, 12), 963 (91, 91, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Time', 'Čas', '', '2', '', '', 1, 1, 1, 0, 12), 964 (92, 92, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'SourceSubject', 'Zdrojový subjekt', '', '33', '', '', 1, 1, 1, 0, 12), 965 (93, 93, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TargetSubject', 'Cílový subjekt', '', '33', '', '', 1, 1, 1, 0, 12), 966 (94, 94, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', '2008-10-19 20:08:36', 'Type', 'Type', '', '15', '', '', 1, 1, 0, 0, 12), 967 (95, 95, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'InsertedByUser', 'Vložil', '', '37', '', '', 0, 0, 0, 0, 12), 968 (96, 96, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'DbDataType', 'Datový typ v databázi', '', '3', '', '', 1, 1, 0, 0, 11), 969 (97, 97, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TableName', 'Jméno tabulky', '', '3', 'Zadejte jméno tabulky v databázi, která bude použita pro uchování informací.', '', 1, 1, 1, 0, 13), 970 (98, 98, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Title', 'Název seznamu', '', '3', 'Zadejte nadpis seznamu.', '', 1, 1, 1, 1, 13), 971 (99, 99, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', '2008-10-21 08:53:27', 'VisibleInMenu', 'Viditelné v menu', '', '4', 'Zobrazovat tuto tabulku v hlavním menu', '', 1, 1, 0, 0, 13), 972 (100, 100, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Items', 'Položky', '', '28', 'Definujte potřebné položky pro seznam.', '', 1, 1, 0, 0, 13), 973 (101, 101, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Jméno sloupce', '', '3', 'Jméno sloupce tabulky v databázi', '', 1, 1, 1, 0, 14), 974 (102, 102, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TextBefore', 'Text před hodnotou', '', '3', 'Oznčení položky umístěné před zobrazenou hodnotou.', '', 1, 1, 1, 1, 14), 975 (103, 103, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TextAfter', 'Text za hodnotou', '', '3', 'Tento text většinou obsahuje jednotky použité veličiny.', '', 1, 1, 0, 0, 14), 976 (104, 104, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Type', 'Type', '', '35', 'Typ dat položky', '', 1, 1, 1, 0, 14), 977 (105, 105, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Help', 'Nápověda', '', '3', 'Textová nápověda zobrazovaná jako pomůcka při editaci hodnoty.', '', 1, 1, 0, 0, 14), 978 (106, 106, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Required', 'Požadováno', '', '4', 'Určuje zda je nutné danou položku vyplnit.', '', 1, 1, 0, 0, 14), 979 (107, 107, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Editable', 'Editovatelné', '', '4', 'Určuje zda je možné danou položku ručně editovat nebo zda je měněna automaticky systémem.', '', 1, 1, 0, 0, 14), 980 (108, 108, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'VisibleInList', 'Viditelné v seznamu', '', '4', 'Určuje viditelnost této položky v seznamu', '', 1, 1, 0, 0, 14), 981 (109, 109, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'VisibleInPointer', 'Viditelné v odkazech', '', '4', 'Určuje viditelnost této položky v názvech odkazů na tuto položku', '', 1, 1, 0, 0, 14), 982 (110, 110, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Area', 'Umístění', '', '30', 'Vyberte oblast, do které toto zařízení patří.', '', 0, 1, 0, 0, 2), 983 (111, 111, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'HostList', 'Seznam zařízení', '', '22', '', '', 0, 1, 0, 0, 5), 984 (112, 112, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'UserList', 'Uživatelů', '', '29', '', '', 0, 1, 0, 0, 4), 985 (114, 114, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', '2008-10-21 10:17:36', 'ValidToTime', 'Platnost do', '', '2', '', '', 1, 1, 0, 0, 4), 986 (115, 115, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'User', 'Uživatel', '', '37', '', '', 1, 0, 1, 1, 15), 987 (116, 116, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', '2008-10-22 08:40:51', 'LoginTime', 'Čas přihlášení', '', '2', '', '', 0, 0, 0, 0, 15), 988 (117, 117, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ActivityTime', 'Naposledy aktivní', '', '2', '', '', 0, 0, 0, 0, 15), 989 (118, 118, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'SessionId', 'Identifikace spojení', '', '3', '', '', 0, 0, 0, 0, 15), 990 (119, 119, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'IpAddress', 'IP adresa', '', '3', '', '', 0, 0, 0, 0, 15), 991 (120, 120, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'HostName', 'Jméno počítače', '', '3', '', '', 0, 0, 1, 0, 15), 992 (121, 121, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Locked', 'Zamčeno', '', '4', '', '', 0, 0, 0, 0, 1), 993 (122, 122, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'RegistrationTime', 'Čas registrace', '', '2', '', '', 0, 0, 0, 0, 1), 994 (123, 123, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'LastLoginTime', 'Čas posledního přihlášení', '', '2', '', '', 0, 0, 0, 0, 1), 995 (124, 124, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'LastIpAddress', 'Poslední IP adresa', '', '3', '', '', 0, 0, 0, 0, 1), 996 (125, 125, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Author', 'Autor', '', '37', '', '', 1, 0, 0, 0, 16), 997 (126, 126, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TimeCreation', 'Čas vytvoření', '', '2', '', '', 1, 0, 0, 0, 16), 998 (127, 127, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TimeValidFrom', 'Platnost od', '', '2', '', '', 1, 1, 0, 0, 16), 999 (128, 128, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TimeValidTo', 'Platnost do', '', '2', '', '', 1, 1, 0, 0, 16), 1000 (129, 129, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ListId', 'Odkazovaná tabulka', '', '34', '', '', 1, 1, 0, 0, 16), 1001 (130, 130, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'PermanentId', 'Trvalá identifikace', '', '1', '', '', 1, 1, 0, 0, 16), 1002 (133, 132, 5, '2008-10-12 17:48:27', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'List', 'Rodičovský seznam', '', '34', '', '', 1, 0, 0, 0, 14), 1003 (142, 133, 5, '2008-10-12 18:39:09', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 26), 1004 (143, 134, 5, '2008-10-13 09:54:15', NULL, '2008-10-22 08:15:09', NULL, 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 18), 1005 (144, 135, 5, '2008-10-13 10:04:22', NULL, '2008-10-22 08:15:09', NULL, 'PermissionGroup', 'Oprávnění', '', '39', '', '', 1, 1, 0, 0, 1), 1006 (145, 136, 5, '2008-10-13 10:20:19', NULL, '2008-10-22 08:15:09', NULL, 'List', 'Seznam', '', '34', '', '', 1, 1, 1, 0, 19), 1007 (146, 137, 5, '2008-10-13 10:24:59', NULL, '2008-10-22 08:15:09', NULL, 'Item', 'Položka', '', '1', '', '', 0, 1, 1, 0, 19), 1008 (147, 138, 5, '2008-10-13 10:26:06', NULL, '2008-10-22 08:15:09', NULL, 'Right', 'Práva', '', '14', 'Žádné|Čtení|Čtení i zápis', '', 1, 1, 1, 1, 19), 1009 (148, 139, 5, '2008-10-13 10:39:16', NULL, '2008-10-22 08:15:09', NULL, 'PermissionGroup', 'Rodičovská skupina', '', '39', '', '', 0, 1, 0, 0, 19), 1010 (149, 140, 5, '2008-10-13 10:41:38', NULL, '2008-10-22 08:15:09', NULL, 'PermissionList', 'Oprávnění', '', '41', '', '', 0, 1, 0, 0, 18), 1011 (150, 138, 5, '2008-10-13 10:43:38', NULL, '2008-10-22 08:15:09', NULL, 'Right', 'Práva', '', '42', 'Žádné|Čtení|Čtení i zápis', '', 1, 1, 1, 1, 19), 1012 (151, 141, 5, '2008-10-13 12:06:35', NULL, '2008-10-22 08:15:09', NULL, 'UserList', 'Zařazení uživatelé', '', '43', '', '', 0, 0, 0, 0, 18), 1013 (152, 142, 5, '2008-10-13 12:13:06', NULL, '2008-10-22 08:15:09', '2008-10-21 08:53:00', 'System', 'Systémový', '', '4', '', '', 0, 0, 0, 0, 13), 1014 (153, 143, 5, '2008-10-13 12:14:34', NULL, '2008-10-22 08:15:09', NULL, 'User', 'Uživatel', '', '37', '', '', 0, 0, 1, 1, 20), 1015 (154, 144, 5, '2008-10-13 12:15:22', NULL, '2008-10-22 08:15:09', NULL, 'List', 'Seznam', '', '34', '', '', 0, 0, 1, 0, 20), 1016 (155, 145, 5, '2008-10-13 12:15:40', NULL, '2008-10-22 08:15:09', NULL, 'Item', 'Položka', '', '1', '', '', 0, 0, 1, 0, 20), 1017 (156, 146, 5, '2008-10-13 12:17:36', NULL, '2008-10-22 08:15:09', NULL, 'Action', 'Akce', '', '44', '', '', 0, 0, 1, 0, 20), 1018 (157, 147, 5, '2008-10-14 06:53:58', NULL, '2008-10-22 08:15:09', NULL, 'CreationTime', 'Čas vytvoření', '', '2', '', '', 0, 0, 1, 0, 20), 1019 (158, 147, 5, '2008-10-14 07:21:08', NULL, '2008-10-22 08:15:09', '2008-10-19 19:19:25', 'CreationTime', 'Čas vytvoření', '', '46', '', '', 0, 0, 1, 0, 20), 1020 (159, 148, 5, '2008-10-14 07:51:52', NULL, '2008-10-22 08:15:09', '2008-10-19 20:09:33', 'Document', 'Doklad', '', '47', '', '', 0, 1, 0, 0, 12), 1021 (160, 147, 5, '2008-10-19 19:19:25', NULL, '2008-10-22 08:15:09', NULL, 'CreationTime', 'Čas vytvoření', '', '45', '', '', 0, 0, 1, 0, 20), 1022 (161, 94, 5, '2008-10-19 20:08:36', NULL, '2008-10-22 08:15:09', NULL, 'Type', 'Type', '', '17', '', '', 1, 1, 0, 0, 12), 1023 (162, 148, 5, '2008-10-19 20:09:33', NULL, '2008-10-22 08:15:09', NULL, 'Document', 'Doklad', '', '46', '', '', 0, 1, 0, 0, 12), 1024 (163, 149, 5, '2008-10-21 07:47:49', NULL, '2008-10-22 08:15:09', NULL, 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 21), 1025 (164, 150, 5, '2008-10-21 07:48:56', NULL, '2008-10-22 08:15:09', '2008-10-21 07:52:52', 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 21), 1026 (165, 151, 5, '2008-10-21 07:51:35', NULL, '2008-10-22 08:15:09', '2008-10-21 07:53:04', 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 21), 1027 (166, 152, 5, '2008-10-21 08:14:17', NULL, '2008-10-22 08:15:09', NULL, 'Menu', 'Menu', '', '47', '', '', 1, 1, 0, 0, 13), 1028 (167, 153, 5, '2008-10-21 08:23:20', NULL, '2008-10-22 08:15:09', NULL, 'SystemListItems', 'Položky menu', '', '48', '', '', 0, 0, 0, 0, 21), 1029 (168, 18, 5, '2008-10-21 10:01:03', NULL, '2008-10-22 08:15:09', NULL, 'GPS', 'GPS pozice', '', '49', 'Pozice na mapě', '', 0, 1, 0, 0, 4), 1030 (169, 154, 28, '2008-10-21 14:40:20', NULL, '2008-10-22 08:15:09', NULL, 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 23), 1031 (170, 155, 28, '2008-10-21 14:41:01', NULL, '2008-10-22 08:15:09', NULL, 'Title', 'Titulek', '', '3', '', '', 1, 1, 1, 1, 22), 1032 (171, 156, 28, '2008-10-21 14:42:05', NULL, '2008-10-22 08:15:09', NULL, 'Content', 'Obsah sdělení', '', '3', '', '', 1, 1, 0, 0, 22), 1033 (172, 157, 28, '2008-10-21 14:43:30', NULL, '2008-10-22 08:15:09', '2008-10-21 15:55:29', 'NewsGroup', 'Skupina', '', '50', '', '', 1, 1, 1, 0, 22), 1034 (173, 158, 28, '2008-10-21 14:43:57', NULL, '2008-10-22 08:15:09', NULL, 'Enclosure', 'Příloha', '', '46', '', '', 0, 1, 0, 0, 22), 1035 (174, 159, 28, '2008-10-21 14:49:29', NULL, '2008-10-22 08:15:09', NULL, 'NewsItems', 'Aktuality', '', '51', '', '', 0, 0, 0, 0, 23), 1036 (175, 160, 28, '2008-10-21 15:54:56', NULL, '2008-10-22 08:15:09', '2008-10-21 15:56:41', 'Group', 'Skupina', '', '50', '', '', 1, 1, 0, 0, 22), 1037 (176, 160, 28, '2008-10-21 15:56:41', NULL, '2008-10-22 08:15:09', NULL, 'NewsGroup', 'Skupina', '', '50', '', '', 1, 1, 0, 0, 22), 1038 (177, 161, 28, '2008-10-21 16:06:44', NULL, '2008-10-22 08:15:09', NULL, 'Name', 'Jméno kanálu', '', '3', '', '', 1, 1, 1, 1, 24), 1039 (178, 162, 28, '2008-10-21 16:07:14', NULL, '2008-10-22 08:15:09', NULL, 'Frequency', 'Frekvence', '', '1', '', '', 1, 1, 1, 0, 24), 1040 (179, 163, 28, '2008-10-21 16:07:55', NULL, '2008-10-22 08:15:09', NULL, 'Norm', 'Norma', '', '3', '', '', 1, 1, 1, 0, 24), 1041 (180, 164, 28, '2008-10-21 16:08:16', NULL, '2008-10-22 08:15:09', '2008-10-21 16:09:55', 'Homepage', 'Webové stránky', '', '3', '', '', 0, 1, 0, 0, 24), 1042 (181, 165, 28, '2008-10-21 16:08:34', NULL, '2008-10-22 08:15:09', NULL, 'Language', 'Jazyk', '', '3', '', '', 0, 1, 1, 0, 24), 1043 (182, 166, 28, '2008-10-21 16:08:55', NULL, '2008-10-22 08:15:09', NULL, 'ShortName', 'Zkratka', '', '3', '', '', 1, 1, 0, 0, 24), 1044 (183, 164, 28, '2008-10-21 16:09:55', NULL, '2008-10-22 08:15:09', NULL, 'Homepage', 'Webové stránky', '', '18', '', '', 0, 1, 0, 0, 24), 1045 (185, 116, 28, '2008-10-22 08:40:51', NULL, '2008-10-22 08:40:51', '2008-10-22 08:43:30', 'LoginTime', 'Čas přihlášení', '', '45', '', '', 0, 0, 0, 0, 15), 1046 (186, 116, 5, '2008-10-22 08:43:30', NULL, '2008-10-22 08:43:30', NULL, 'LoginTime', 'Čas přihlášení', '', '45', '', '', 0, 0, 0, 0, 15), 1047 (187, 167, 5, '2008-10-27 13:56:31', NULL, '2008-10-27 13:56:31', NULL, 'Name', 'Jméno parameteru', '', '3', '', '', 1, 1, 1, 1, 28), 1048 (188, 168, 5, '2008-10-27 13:57:19', NULL, '2008-10-27 13:57:19', NULL, 'Type', 'Typ', '', '35', '', '', 1, 1, 1, 0, 28), 1049 (189, 169, 5, '2008-10-27 14:01:06', NULL, '2008-10-27 14:01:06', '2008-10-27 14:01:45', 'Type', 'Typ', '', '35', '', '', 1, 1, 0, 0, 28), 1050 (190, 170, 5, '2008-10-27 14:02:10', NULL, '2008-10-27 14:02:10', NULL, 'ParentType', 'Rodičovský typ', '', '35', '', '', 1, 1, 0, 0, 28), 1051 (191, 171, 5, '2008-10-27 14:03:32', NULL, '2008-10-27 14:03:32', NULL, 'ParameterList', 'Seznam parametrů', '', '52', '', '', 1, 1, 0, 0, 11), 1052 (192, 172, 5, '2008-10-27 14:08:15', NULL, '2008-10-27 14:08:15', '2008-10-27 14:08:44', 'Description', 'Popis', '', '3', '', '', 1, 1, 0, 0, 28), 1053 (193, 172, 5, '2008-10-27 14:08:44', NULL, '2008-10-27 14:08:44', NULL, 'Description', 'Popis', '', '3', '', '', 1, 1, 1, 0, 28), 1054 (194, 173, 5, '2008-10-27 14:12:09', NULL, '2008-10-27 14:12:09', NULL, 'Name', 'Název', '', '3', '', '', 1, 1, 1, 1, 33), 1055 (195, 174, 5, '2008-10-27 14:13:05', NULL, '2008-10-27 14:13:05', NULL, 'ParentParameter', 'Rodičovský parameter', '', '52', '', '', 1, 1, 0, 0, 33); 1056 1057 -- -------------------------------------------------------- 1058 1059 -- 1060 -- Struktura tabulky `SystemLog` 1061 -- 1062 1063 CREATE TABLE IF NOT EXISTS `SystemLog` ( 1064 `Id` int(11) NOT NULL auto_increment, 1065 `ItemId` int(11) NOT NULL, 1066 `Author` int(11) NOT NULL, 1067 `ValidTimeFrom` datetime default NULL, 1068 `ValidTimeTo` datetime default NULL, 1069 `CreationTime` datetime default NULL, 1070 `DeletionTime` datetime default NULL, 1071 `User` int(11) NOT NULL, 1072 `List` int(11) NOT NULL, 1073 `Item` int(11) NOT NULL, 1074 `Action` int(11) NOT NULL, 1075 PRIMARY KEY (`Id`) 1076 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=293 ; 1077 1078 -- 1079 -- Vypisuji data pro tabulku `SystemLog` 1080 -- 1081 1082 INSERT INTO `SystemLog` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `User`, `List`, `Item`, `Action`) VALUES 1083 (1, 1, 5, '2008-10-13 12:21:11', NULL, '2008-10-13 12:21:11', NULL, 8, 34, 0, 0), 1084 (2, 2, 5, '2008-10-13 12:24:46', NULL, '2008-10-13 12:24:46', NULL, 13, 15, 12, 0), 1085 (3, 3, 0, '2008-10-13 12:50:52', NULL, '2008-10-13 12:50:52', NULL, 5, 0, 10, 0), 1086 (4, 4, 0, '2008-10-13 12:58:32', NULL, '2008-10-13 12:58:32', NULL, 5, 0, 11, 0), 1087 (5, 5, 5, '2008-10-13 13:00:34', NULL, '2008-10-13 13:00:34', NULL, 5, 33, 12, 0), 1088 (6, 6, 5, '2008-10-13 13:04:26', NULL, '2008-10-13 13:04:26', NULL, 5, 33, 13, 0), 1089 (7, 7, 5, '2008-10-13 13:17:35', NULL, '2008-10-13 13:17:35', NULL, 5, 33, 10, 0), 1090 (8, 8, 5, '2008-10-13 13:17:38', NULL, '2008-10-13 13:17:38', NULL, 5, 33, 8, 0), 1091 (9, 9, 5, '2008-10-13 13:17:40', NULL, '2008-10-13 13:17:40', NULL, 5, 33, 7, 0), 1092 (10, 10, 5, '2008-10-13 13:17:41', NULL, '2008-10-13 13:17:41', NULL, 5, 33, 6, 0), 1093 (11, 11, 5, '2008-10-13 13:17:44', NULL, '2008-10-13 13:17:44', NULL, 5, 33, 1, 0), 1094 (12, 12, 5, '2008-10-13 13:19:17', NULL, '2008-10-13 13:19:17', NULL, 5, 33, 14, 1), 1095 (13, 13, 5, '2008-10-13 13:19:27', NULL, '2008-10-13 13:19:27', NULL, 5, 33, 14, 2), 1096 (14, 14, 5, '2008-10-13 13:39:08', NULL, '2008-10-13 13:39:08', NULL, 5, 11, 45, 1), 1097 (15, 15, 5, '2008-10-13 13:52:04', NULL, '2008-10-13 13:52:04', NULL, 5, 2, 10, 1), 1098 (16, 16, 5, '2008-10-13 13:57:30', NULL, '2008-10-13 13:57:30', NULL, 5, 1, 21, 1), 1099 (17, 17, 5, '2008-10-13 14:05:54', NULL, '2008-10-13 14:05:54', NULL, 5, 33, 15, 0), 1100 (18, 18, 5, '2008-10-13 14:06:21', NULL, '2008-10-13 14:06:21', NULL, 5, 33, 16, 0), 1101 (19, 19, 5, '2008-10-14 06:53:58', NULL, '2008-10-14 06:53:58', NULL, 5, 14, 157, 0), 1102 (20, 20, 5, '2008-10-14 07:02:50', NULL, '2008-10-14 07:02:50', NULL, 5, 11, 46, 0), 1103 (21, 21, 5, '2008-10-14 07:20:25', NULL, '2008-10-14 07:20:25', NULL, 5, 7, 15, 1), 1104 (22, 22, 5, '2008-10-14 07:21:08', NULL, '2008-10-14 07:21:08', NULL, 5, 14, 158, 1), 1105 (23, 23, 5, '2008-10-14 07:48:07', NULL, '2008-10-14 07:48:07', NULL, 5, 11, 47, 0), 1106 (24, 24, 5, '2008-10-14 07:51:52', NULL, '2008-10-14 07:51:52', NULL, 5, 14, 159, 0), 1107 (25, 25, 5, '2008-10-14 07:52:23', NULL, '2008-10-14 07:52:23', NULL, 5, 12, 5, 1), 1108 (26, 26, 5, '2008-10-14 07:53:02', NULL, '2008-10-14 07:53:02', NULL, 5, 12, 6, 1), 1109 (27, 27, 5, '2008-10-14 07:56:06', NULL, '2008-10-14 07:56:06', NULL, 5, 12, 7, 1), 1110 (28, 28, 5, '2008-10-14 07:58:11', NULL, '2008-10-14 07:58:11', NULL, 5, 12, 8, 1), 1111 (29, 29, 5, '2008-10-14 08:34:22', NULL, '2008-10-14 08:34:22', NULL, 5, 12, 9, 1), 1112 (30, 30, 5, '2008-10-14 08:35:57', NULL, '2008-10-14 08:35:57', NULL, 5, 12, 10, 1), 1113 (31, 31, 5, '2008-10-14 08:36:48', NULL, '2008-10-14 08:36:48', NULL, 5, 12, 11, 1), 1114 (32, 32, 5, '2008-10-14 08:48:28', NULL, '2008-10-14 08:48:28', NULL, 5, 12, 12, 1), 1115 (33, 33, 5, '2008-10-14 08:48:41', NULL, '2008-10-14 08:48:41', NULL, 5, 12, 13, 1), 1116 (34, 34, 5, '2008-10-14 08:50:50', NULL, '2008-10-14 08:50:50', NULL, 5, 12, 14, 1), 1117 (35, 35, 5, '2008-10-14 08:52:23', NULL, '2008-10-14 08:52:23', NULL, 5, 12, 15, 1), 1118 (36, 36, 5, '2008-10-14 08:53:04', NULL, '2008-10-14 08:53:04', NULL, 5, 12, 16, 1), 1119 (37, 37, 5, '2008-10-14 08:53:22', NULL, '2008-10-14 08:53:22', NULL, 5, 12, 17, 1), 1120 (38, 38, 5, '2008-10-14 08:53:38', NULL, '2008-10-14 08:53:38', NULL, 5, 12, 18, 1), 1121 (39, 39, 5, '2008-10-14 08:53:54', NULL, '2008-10-14 08:53:54', NULL, 5, 12, 19, 1), 1122 (40, 40, 5, '2008-10-14 08:56:11', NULL, '2008-10-14 08:56:11', NULL, 5, 12, 20, 1), 1123 (41, 41, 5, '2008-10-14 09:00:22', NULL, '2008-10-14 09:00:22', NULL, 5, 12, 21, 1), 1124 (42, 42, 5, '2008-10-14 09:01:39', NULL, '2008-10-14 09:01:39', NULL, 5, 12, 22, 1), 1125 (43, 43, 5, '2008-10-14 09:02:31', NULL, '2008-10-14 09:02:31', NULL, 5, 12, 23, 1), 1126 (44, 44, 5, '2008-10-14 09:03:32', NULL, '2008-10-14 09:03:32', NULL, 5, 12, 24, 1), 1127 (45, 45, 5, '2008-10-14 09:05:45', NULL, '2008-10-14 09:05:45', NULL, 5, 12, 25, 1), 1128 (46, 46, 5, '2008-10-14 09:07:57', NULL, '2008-10-14 09:07:57', NULL, 5, 12, 26, 1), 1129 (47, 47, 5, '2008-10-14 09:16:00', NULL, '2008-10-14 09:16:00', NULL, 5, 12, 27, 1), 1130 (48, 48, 5, '2008-10-14 09:16:34', NULL, '2008-10-14 09:16:34', NULL, 5, 12, 28, 1), 1131 (49, 49, 5, '2008-10-14 09:16:57', NULL, '2008-10-14 09:16:57', NULL, 5, 12, 29, 1), 1132 (50, 50, 5, '2008-10-14 09:17:42', NULL, '2008-10-14 09:17:42', NULL, 5, 12, 30, 1), 1133 (51, 51, 5, '2008-10-14 09:20:19', NULL, '2008-10-14 09:20:19', NULL, 5, 12, 31, 1), 1134 (52, 52, 5, '2008-10-14 09:47:32', NULL, '2008-10-14 09:47:32', NULL, 5, 1, 22, 1), 1135 (53, 53, 5, '2008-10-14 09:57:36', NULL, '2008-10-14 09:57:36', NULL, 5, 1, 23, 1), 1136 (54, 54, 5, '2008-10-14 09:57:54', NULL, '2008-10-14 09:57:54', NULL, 5, 1, 24, 1), 1137 (55, 55, 5, '2008-10-15 15:53:45', NULL, '2008-10-15 15:53:45', NULL, 5, 1, 25, 1), 1138 (56, 56, 5, '2008-10-15 15:55:21', NULL, '2008-10-15 15:55:21', NULL, 5, 1, 26, 1), 1139 (57, 57, 5, '2008-10-15 16:00:07', NULL, '2008-10-15 16:00:07', NULL, 5, 1, 27, 1), 1140 (58, 58, 5, '2008-10-16 12:24:44', NULL, '2008-10-16 12:24:44', NULL, 5, 7, 16, 1), 1141 (59, 59, 5, '2008-10-19 19:13:18', NULL, '2008-10-19 19:13:18', NULL, 5, 6, 5, 1), 1142 (60, 60, 5, '2008-10-19 19:13:25', NULL, '2008-10-19 19:13:25', NULL, 5, 6, 6, 1), 1143 (61, 61, 5, '2008-10-19 19:13:33', NULL, '2008-10-19 19:13:33', NULL, 5, 6, 7, 1), 1144 (62, 62, 5, '2008-10-19 19:19:25', NULL, '2008-10-19 19:19:25', NULL, 5, 14, 160, 1), 1145 (63, 63, 5, '2008-10-19 20:00:47', NULL, '2008-10-19 20:00:47', NULL, 5, 5, 9, 0), 1146 (64, 64, 5, '2008-10-19 20:01:24', NULL, '2008-10-19 20:01:24', NULL, 5, 2, 11, 1), 1147 (65, 65, 5, '2008-10-19 20:03:14', NULL, '2008-10-19 20:03:14', NULL, 5, 2, 12, 1), 1148 (66, 66, 5, '2008-10-19 20:03:20', NULL, '2008-10-19 20:03:20', NULL, 5, 2, 13, 1), 1149 (67, 67, 5, '2008-10-19 20:07:04', NULL, '2008-10-19 20:07:04', NULL, 5, 6, 8, 1), 1150 (68, 68, 5, '2008-10-19 20:08:36', NULL, '2008-10-19 20:08:36', NULL, 5, 14, 161, 1), 1151 (69, 69, 5, '2008-10-19 20:09:33', NULL, '2008-10-19 20:09:33', NULL, 5, 14, 162, 1), 1152 (70, 70, 5, '2008-10-19 20:09:37', NULL, '2008-10-19 20:09:37', NULL, 5, 12, 3, 2), 1153 (71, 71, 5, '2008-10-21 07:06:14', NULL, '2008-10-21 07:06:14', NULL, 5, 33, 17, 0), 1154 (72, 72, 5, '2008-10-21 07:06:35', NULL, '2008-10-21 07:06:35', NULL, 5, 1, 28, 1), 1155 (73, 73, 5, '2008-10-21 07:46:53', NULL, '2008-10-21 07:46:53', NULL, 5, 13, 35, 0), 1156 (74, 74, 5, '2008-10-21 07:47:49', NULL, '2008-10-21 07:47:49', NULL, 5, 14, 163, 0), 1157 (75, 75, 5, '2008-10-21 07:48:56', NULL, '2008-10-21 07:48:56', NULL, 5, 14, 164, 0), 1158 (76, 76, 5, '2008-10-21 07:51:35', NULL, '2008-10-21 07:51:35', NULL, 5, 14, 165, 0), 1159 (77, 77, 5, '2008-10-21 07:52:52', NULL, '2008-10-21 07:52:52', NULL, 5, 14, 150, 2), 1160 (78, 78, 5, '2008-10-21 07:53:04', NULL, '2008-10-21 07:53:04', NULL, 5, 14, 151, 2), 1161 (79, 79, 5, '2008-10-21 08:06:34', NULL, '2008-10-21 08:06:34', NULL, 5, 13, 36, 1), 1162 (80, 80, 5, '2008-10-21 08:07:02', NULL, '2008-10-21 08:07:02', NULL, 5, 13, 37, 1), 1163 (81, 81, 5, '2008-10-21 08:07:20', NULL, '2008-10-21 08:07:20', NULL, 5, 13, 38, 1), 1164 (82, 82, 5, '2008-10-21 08:10:18', NULL, '2008-10-21 08:10:18', NULL, 5, 13, 39, 1), 1165 (83, 83, 5, '2008-10-21 08:10:28', NULL, '2008-10-21 08:10:28', NULL, 5, 13, 40, 1), 1166 (84, 84, 5, '2008-10-21 08:10:38', NULL, '2008-10-21 08:10:38', NULL, 5, 13, 41, 1), 1167 (85, 85, 5, '2008-10-21 08:10:57', NULL, '2008-10-21 08:10:57', NULL, 5, 33, 18, 0), 1168 (86, 86, 5, '2008-10-21 08:11:18', NULL, '2008-10-21 08:11:18', NULL, 5, 13, 42, 1), 1169 (87, 87, 5, '2008-10-21 08:13:34', NULL, '2008-10-21 08:13:34', NULL, 5, 11, 48, 0), 1170 (88, 88, 5, '2008-10-21 08:14:17', NULL, '2008-10-21 08:14:17', NULL, 5, 14, 166, 0), 1171 (89, 89, 5, '2008-10-21 08:14:39', NULL, '2008-10-21 08:14:39', NULL, 5, 41, 1, 0), 1172 (90, 90, 5, '2008-10-21 08:14:59', NULL, '2008-10-21 08:14:59', NULL, 5, 41, 2, 0), 1173 (91, 91, 5, '2008-10-21 08:17:28', NULL, '2008-10-21 08:17:28', NULL, 5, 11, 0, 1), 1174 (92, 92, 5, '2008-10-21 08:18:00', NULL, '2008-10-21 08:18:00', NULL, 5, 11, 49, 1), 1175 (93, 93, 5, '2008-10-21 08:19:02', NULL, '2008-10-21 08:19:02', NULL, 5, 11, 50, 1), 1176 (94, 94, 5, '2008-10-21 08:19:13', NULL, '2008-10-21 08:19:13', NULL, 5, 42, 43, 1), 1177 (95, 95, 5, '2008-10-21 08:19:21', NULL, '2008-10-21 08:19:21', NULL, 5, 43, 44, 1), 1178 (96, 96, 5, '2008-10-21 08:19:30', NULL, '2008-10-21 08:19:30', NULL, 5, 43, 45, 1), 1179 (97, 97, 5, '2008-10-21 08:19:35', NULL, '2008-10-21 08:19:35', NULL, 5, 43, 46, 1), 1180 (98, 98, 5, '2008-10-21 08:19:41', NULL, '2008-10-21 08:19:41', NULL, 5, 43, 47, 1), 1181 (99, 99, 5, '2008-10-21 08:19:46', NULL, '2008-10-21 08:19:46', NULL, 5, 43, 48, 1), 1182 (100, 100, 5, '2008-10-21 08:19:58', NULL, '2008-10-21 08:19:58', NULL, 5, 43, 49, 1), 1183 (101, 101, 5, '2008-10-21 08:20:07', NULL, '2008-10-21 08:20:07', NULL, 5, 43, 50, 1), 1184 (102, 102, 5, '2008-10-21 08:20:12', NULL, '2008-10-21 08:20:12', NULL, 5, 43, 51, 1), 1185 (103, 103, 5, '2008-10-21 08:20:16', NULL, '2008-10-21 08:20:16', NULL, 5, 43, 52, 1), 1186 (104, 104, 5, '2008-10-21 08:20:20', NULL, '2008-10-21 08:20:20', NULL, 5, 43, 53, 1), 1187 (105, 105, 5, '2008-10-21 08:20:25', NULL, '2008-10-21 08:20:25', NULL, 5, 43, 54, 1), 1188 (106, 106, 5, '2008-10-21 08:20:28', NULL, '2008-10-21 08:20:28', NULL, 5, 43, 55, 1), 1189 (107, 107, 5, '2008-10-21 08:20:33', NULL, '2008-10-21 08:20:33', NULL, 5, 43, 56, 1), 1190 (108, 108, 5, '2008-10-21 08:20:39', NULL, '2008-10-21 08:20:39', NULL, 5, 43, 57, 1), 1191 (109, 109, 5, '2008-10-21 08:20:48', NULL, '2008-10-21 08:20:48', NULL, 5, 43, 58, 1), 1192 (110, 110, 5, '2008-10-21 08:20:54', NULL, '2008-10-21 08:20:54', NULL, 5, 43, 59, 1), 1193 (111, 111, 5, '2008-10-21 08:20:58', NULL, '2008-10-21 08:20:58', NULL, 5, 43, 60, 1), 1194 (112, 112, 5, '2008-10-21 08:21:03', NULL, '2008-10-21 08:21:03', NULL, 5, 43, 61, 1), 1195 (113, 113, 5, '2008-10-21 08:21:07', NULL, '2008-10-21 08:21:07', NULL, 5, 43, 62, 1), 1196 (114, 114, 5, '2008-10-21 08:22:44', NULL, '2008-10-21 08:22:44', NULL, 5, 54, 51, 0), 1197 (115, 115, 5, '2008-10-21 08:23:20', NULL, '2008-10-21 08:23:20', NULL, 5, 56, 167, 0), 1198 (116, 116, 5, '2008-10-21 08:24:13', NULL, '2008-10-21 08:24:13', NULL, 5, 54, 52, 1), 1199 (117, 117, 5, '2008-10-21 08:38:31', NULL, '2008-10-21 08:38:31', NULL, 5, 43, 16, 2), 1200 (118, 118, 5, '2008-10-21 08:51:03', NULL, '2008-10-21 08:51:03', NULL, 5, 60, 19, 0), 1201 (119, 119, 5, '2008-10-21 08:53:00', NULL, '2008-10-21 08:53:00', NULL, 5, 56, 142, 2), 1202 (120, 120, 5, '2008-10-21 08:53:27', NULL, '2008-10-21 08:53:27', NULL, 5, 56, 99, 2), 1203 (121, 121, 5, '2008-10-21 08:55:36', NULL, '2008-10-21 08:55:36', NULL, 5, 62, 3, 0), 1204 (122, 122, 5, '2008-10-21 08:55:47', NULL, '2008-10-21 08:55:47', NULL, 5, 43, 63, 1), 1205 (123, 123, 5, '2008-10-21 08:56:03', NULL, '2008-10-21 08:56:03', NULL, 5, 43, 64, 1), 1206 (124, 124, 5, '2008-10-21 08:56:11', NULL, '2008-10-21 08:56:11', NULL, 5, 43, 65, 1), 1207 (125, 125, 5, '2008-10-21 08:56:22', NULL, '2008-10-21 08:56:22', NULL, 5, 43, 66, 1), 1208 (126, 126, 5, '2008-10-21 08:56:29', NULL, '2008-10-21 08:56:29', NULL, 5, 43, 67, 1), 1209 (127, 127, 5, '2008-10-21 09:06:54', NULL, '2008-10-21 09:06:54', NULL, 5, 63, 29, 1), 1210 (128, 128, 5, '2008-10-21 09:58:14', NULL, '2008-10-21 09:58:14', NULL, 5, 54, 53, 0), 1211 (129, 129, 5, '2008-10-21 10:00:27', NULL, '2008-10-21 10:00:27', NULL, 5, 56, 19, 2), 1212 (130, 130, 5, '2008-10-21 10:01:03', NULL, '2008-10-21 10:01:03', NULL, 5, 56, 168, 1), 1213 (131, 131, 5, '2008-10-21 10:11:56', NULL, '2008-10-21 10:11:56', NULL, 5, 51, 0, 1), 1214 (132, 132, 5, '2008-10-21 10:13:08', NULL, '2008-10-21 10:13:08', NULL, 5, 51, 0, 1), 1215 (133, 133, 5, '2008-10-21 10:17:25', NULL, '2008-10-21 10:17:25', NULL, 5, 56, 113, 2), 1216 (134, 134, 5, '2008-10-21 10:17:36', NULL, '2008-10-21 10:17:36', NULL, 5, 56, 114, 2), 1217 (135, 135, 5, '2008-10-21 10:18:03', NULL, '2008-10-21 10:18:03', NULL, 5, 51, 7, 1), 1218 (136, 136, 5, '2008-10-21 10:20:38', NULL, '2008-10-21 10:20:38', NULL, 5, 51, 8, 1), 1219 (137, 137, 5, '2008-10-21 10:21:01', NULL, '2008-10-21 10:21:01', NULL, 5, 51, 9, 1), 1220 (138, 138, 5, '2008-10-21 10:22:36', NULL, '2008-10-21 10:22:36', NULL, 5, 51, 10, 1), 1221 (139, 139, 5, '2008-10-21 10:30:03', NULL, '2008-10-21 10:30:03', NULL, 5, 51, 11, 1), 1222 (140, 140, 5, '2008-10-21 10:35:47', NULL, '2008-10-21 10:35:47', NULL, 5, 51, 12, 1), 1223 (141, 141, 5, '2008-10-21 10:36:21', NULL, '2008-10-21 10:36:21', NULL, 5, 51, 13, 1), 1224 (142, 142, 5, '2008-10-21 10:36:36', NULL, '2008-10-21 10:36:36', NULL, 5, 51, 14, 1), 1225 (143, 143, 5, '2008-10-21 10:38:25', NULL, '2008-10-21 10:38:25', NULL, 5, 51, 15, 1), 1226 (144, 144, 5, '2008-10-21 10:39:52', NULL, '2008-10-21 10:39:52', NULL, 5, 51, 16, 1), 1227 (145, 145, 5, '2008-10-21 10:39:57', NULL, '2008-10-21 10:39:57', NULL, 5, 51, 17, 1), 1228 (146, 146, 5, '2008-10-21 11:40:16', NULL, '2008-10-21 11:40:16', NULL, 5, 51, 18, 1), 1229 (147, 147, 5, '2008-10-21 11:41:33', NULL, '2008-10-21 11:41:33', NULL, 5, 51, 19, 1), 1230 (148, 148, 5, '2008-10-21 11:41:42', NULL, '2008-10-21 11:41:42', NULL, 5, 51, 20, 1), 1231 (149, 149, 5, '2008-10-21 11:41:50', NULL, '2008-10-21 11:41:50', NULL, 5, 51, 21, 1), 1232 (150, 150, 5, '2008-10-21 11:41:54', NULL, '2008-10-21 11:41:54', NULL, 5, 51, 22, 1), 1233 (151, 151, 5, '2008-10-21 11:42:30', NULL, '2008-10-21 11:42:30', NULL, 5, 51, 23, 1), 1234 (152, 152, 5, '2008-10-21 11:42:36', NULL, '2008-10-21 11:42:36', NULL, 5, 51, 24, 1), 1235 (153, 153, 5, '2008-10-21 11:42:41', NULL, '2008-10-21 11:42:41', NULL, 5, 51, 25, 1), 1236 (154, 154, 5, '2008-10-21 11:47:30', NULL, '2008-10-21 11:47:30', NULL, 5, 51, 26, 1), 1237 (155, 155, 5, '2008-10-21 11:47:39', NULL, '2008-10-21 11:47:39', NULL, 5, 51, 27, 1), 1238 (156, 156, 5, '2008-10-21 11:49:23', NULL, '2008-10-21 11:49:23', NULL, 5, 51, 28, 1), 1239 (157, 157, 5, '2008-10-21 11:53:36', NULL, '2008-10-21 11:53:36', NULL, 5, 51, 29, 1), 1240 (158, 158, 5, '2008-10-21 11:53:42', NULL, '2008-10-21 11:53:42', NULL, 5, 51, 30, 1), 1241 (159, 159, 5, '2008-10-21 11:56:52', NULL, '2008-10-21 11:56:52', NULL, 5, 51, 31, 1), 1242 (160, 160, 5, '2008-10-21 12:04:01', NULL, '2008-10-21 12:04:01', NULL, 5, 51, 32, 1), 1243 (161, 161, 5, '2008-10-21 12:05:49', NULL, '2008-10-21 12:05:49', NULL, 5, 51, 33, 1), 1244 (162, 162, 5, '2008-10-21 12:07:48', NULL, '2008-10-21 12:07:48', NULL, 5, 51, 34, 1), 1245 (163, 163, 5, '2008-10-21 12:44:55', NULL, '2008-10-21 12:44:55', NULL, 5, 65, 20, 0), 1246 (164, 164, 5, '2008-10-21 12:56:43', NULL, '2008-10-21 12:56:43', NULL, 5, 63, 30, 1), 1247 (165, 165, 5, '2008-10-21 12:57:35', NULL, '2008-10-21 12:57:35', NULL, 5, 65, 21, 0), 1248 (166, 166, 5, '2008-10-21 12:57:54', NULL, '2008-10-21 12:57:54', NULL, 5, 65, 22, 0), 1249 (167, 167, 5, '2008-10-21 12:58:11', NULL, '2008-10-21 12:58:11', NULL, 5, 65, 23, 0), 1250 (168, 168, 5, '2008-10-21 12:58:23', NULL, '2008-10-21 12:58:23', NULL, 5, 65, 24, 1), 1251 (169, 169, 5, '2008-10-21 12:58:43', NULL, '2008-10-21 12:58:43', NULL, 5, 65, 25, 1), 1252 (170, 170, 5, '2008-10-21 12:58:54', NULL, '2008-10-21 12:58:54', NULL, 5, 65, 26, 0), 1253 (171, 171, 5, '2008-10-21 12:59:08', NULL, '2008-10-21 12:59:08', NULL, 5, 65, 27, 0), 1254 (172, 172, 5, '2008-10-21 12:59:15', NULL, '2008-10-21 12:59:15', NULL, 5, 65, 28, 0), 1255 (173, 173, 5, '2008-10-21 13:02:40', NULL, '2008-10-21 13:02:40', NULL, 5, 45, 19, 0), 1256 (174, 174, 5, '2008-10-21 13:02:59', NULL, '2008-10-21 13:02:59', NULL, 5, 45, 20, 1), 1257 (175, 175, 5, '2008-10-21 13:11:11', NULL, '2008-10-21 13:11:11', NULL, 5, 65, 29, 1), 1258 (176, 176, 5, '2008-10-21 13:13:52', NULL, '2008-10-21 13:13:52', NULL, 5, 63, 31, 0), 1259 (177, 177, 5, '2008-10-21 13:14:20', NULL, '2008-10-21 13:14:20', NULL, 5, 65, 30, 0), 1260 (178, 178, 5, '2008-10-21 13:14:45', NULL, '2008-10-21 13:14:45', NULL, 5, 65, 31, 1), 1261 (179, 179, 5, '2008-10-21 13:18:17', NULL, '2008-10-21 13:18:17', NULL, 5, 65, 32, 0), 1262 (180, 180, 5, '2008-10-21 13:18:39', NULL, '2008-10-21 13:18:39', NULL, 5, 65, 33, 1), 1263 (181, 181, 5, '2008-10-21 13:18:52', NULL, '2008-10-21 13:18:52', NULL, 5, 65, 34, 1), 1264 (182, 182, 5, '2008-10-21 13:19:36', NULL, '2008-10-21 13:19:36', NULL, 5, 65, 35, 0), 1265 (183, 183, 5, '2008-10-21 13:19:58', NULL, '2008-10-21 13:19:58', NULL, 5, 43, 68, 1), 1266 (184, 184, 5, '2008-10-21 13:20:18', NULL, '2008-10-21 13:20:18', NULL, 5, 43, 69, 1), 1267 (185, 185, 5, '2008-10-21 13:33:00', NULL, '2008-10-21 13:33:00', NULL, 5, 63, 32, 1), 1268 (186, 186, 5, '2008-10-21 13:45:09', NULL, '2008-10-21 13:45:09', NULL, 5, 63, 33, 1), 1269 (187, 187, 5, '2008-10-21 13:45:28', NULL, '2008-10-21 13:45:28', NULL, 5, 63, 34, 1), 1270 (188, 188, 5, '2008-10-21 13:48:35', NULL, '2008-10-21 13:48:35', NULL, 5, 68, 36, 0), 1271 (189, 189, 5, '2008-10-21 13:49:05', NULL, '2008-10-21 13:49:05', NULL, 5, 68, 37, 0), 1272 (190, 190, 5, '2008-10-21 13:49:48', NULL, '2008-10-21 13:49:48', NULL, 5, 68, 38, 0), 1273 (191, 191, 5, '2008-10-21 14:16:35', NULL, '2008-10-21 14:16:35', NULL, 5, 63, 35, 1), 1274 (192, 192, 28, '2008-10-21 14:36:27', NULL, '2008-10-21 14:36:27', NULL, 28, 68, 39, 1), 1275 (193, 193, 28, '2008-10-21 14:38:25', NULL, '2008-10-21 14:38:25', NULL, 28, 43, 70, 0), 1276 (194, 194, 28, '2008-10-21 14:38:33', NULL, '2008-10-21 14:38:33', NULL, 28, 62, 4, 0), 1277 (195, 195, 28, '2008-10-21 14:38:44', NULL, '2008-10-21 14:38:44', NULL, 28, 43, 71, 1), 1278 (196, 196, 28, '2008-10-21 14:39:36', NULL, '2008-10-21 14:39:36', NULL, 28, 43, 72, 0), 1279 (197, 197, 28, '2008-10-21 14:39:54', NULL, '2008-10-21 14:39:54', NULL, 28, 43, 73, 1), 1280 (198, 198, 28, '2008-10-21 14:40:20', NULL, '2008-10-21 14:40:20', NULL, 28, 69, 169, 0), 1281 (199, 199, 28, '2008-10-21 14:41:01', NULL, '2008-10-21 14:41:01', NULL, 28, 69, 170, 0), 1282 (200, 200, 28, '2008-10-21 14:42:05', NULL, '2008-10-21 14:42:05', NULL, 28, 69, 171, 0), 1283 (201, 201, 28, '2008-10-21 14:42:57', NULL, '2008-10-21 14:42:57', NULL, 28, 54, 54, 0), 1284 (202, 202, 28, '2008-10-21 14:43:30', NULL, '2008-10-21 14:43:30', NULL, 28, 69, 172, 0), 1285 (203, 203, 28, '2008-10-21 14:43:57', NULL, '2008-10-21 14:43:57', NULL, 28, 69, 173, 0), 1286 (204, 204, 28, '2008-10-21 14:45:16', NULL, '2008-10-21 14:45:16', NULL, 28, 54, 55, 0), 1287 (205, 205, 28, '2008-10-21 14:45:36', NULL, '2008-10-21 14:45:36', NULL, 28, 68, 40, 0), 1288 (206, 206, 28, '2008-10-21 14:49:29', NULL, '2008-10-21 14:49:29', NULL, 28, 69, 174, 0), 1289 (207, 207, 28, '2008-10-21 14:49:50', NULL, '2008-10-21 14:49:50', NULL, 28, 72, 0, 0), 1290 (208, 208, 28, '2008-10-21 14:51:50', NULL, '2008-10-21 14:51:50', NULL, 28, 72, 1, 0), 1291 (209, 209, 28, '2008-10-21 14:52:11', NULL, '2008-10-21 14:52:11', NULL, 28, 72, 2, 0), 1292 (210, 210, 28, '2008-10-21 14:52:25', NULL, '2008-10-21 14:52:25', NULL, 28, 72, 3, 0), 1293 (211, 211, 28, '2008-10-21 14:52:39', NULL, '2008-10-21 14:52:39', NULL, 28, 72, 4, 0), 1294 (212, 212, 28, '2008-10-21 14:52:53', NULL, '2008-10-21 14:52:53', NULL, 28, 72, 5, 0), 1295 (213, 213, 28, '2008-10-21 14:53:07', NULL, '2008-10-21 14:53:07', NULL, 28, 72, 6, 0), 1296 (214, 214, 28, '2008-10-21 14:53:51', NULL, '2008-10-21 14:53:51', NULL, 28, 72, 7, 0), 1297 (215, 215, 28, '2008-10-21 14:54:31', NULL, '2008-10-21 14:54:31', NULL, 28, 68, 41, 0), 1298 (216, 216, 28, '2008-10-21 14:57:33', NULL, '2008-10-21 14:57:33', NULL, 28, 73, 1, 0), 1299 (217, 217, 28, '2008-10-21 14:58:03', NULL, '2008-10-21 14:58:03', NULL, 28, 72, 8, 0), 1300 (218, 218, 28, '2008-10-21 14:58:16', NULL, '2008-10-21 14:58:16', NULL, 28, 73, 2, 0), 1301 (219, 219, 28, '2008-10-21 15:51:24', NULL, '2008-10-21 15:51:24', NULL, 28, 45, 21, 0), 1302 (220, 220, 28, '2008-10-21 15:53:47', NULL, '2008-10-21 15:53:47', NULL, 28, 51, 35, 0), 1303 (221, 221, 28, '2008-10-21 15:54:04', NULL, '2008-10-21 15:54:04', NULL, 28, 51, 36, 0), 1304 (222, 222, 28, '2008-10-21 15:54:56', NULL, '2008-10-21 15:54:56', NULL, 28, 69, 175, 0), 1305 (223, 223, 28, '2008-10-21 15:55:29', NULL, '2008-10-21 15:55:29', NULL, 28, 69, 157, 2), 1306 (224, 224, 28, '2008-10-21 15:56:12', NULL, '2008-10-21 15:56:12', NULL, 28, 54, 56, 1), 1307 (225, 225, 28, '2008-10-21 15:56:41', NULL, '2008-10-21 15:56:41', NULL, 28, 69, 176, 1), 1308 (226, 226, 28, '2008-10-21 15:57:44', NULL, '2008-10-21 15:57:44', NULL, 28, 73, 3, 0), 1309 (227, 227, 28, '2008-10-21 15:58:31', NULL, '2008-10-21 15:58:31', NULL, 28, 73, 4, 0), 1310 (228, 228, 28, '2008-10-21 15:59:35', NULL, '2008-10-21 15:59:35', NULL, 28, 73, 5, 0), 1311 (229, 229, 28, '2008-10-21 16:06:09', NULL, '2008-10-21 16:06:09', NULL, 28, 43, 74, 0), 1312 (230, 230, 28, '2008-10-21 16:06:44', NULL, '2008-10-21 16:06:44', NULL, 28, 69, 177, 0), 1313 (231, 231, 28, '2008-10-21 16:07:14', NULL, '2008-10-21 16:07:14', NULL, 28, 69, 178, 0), 1314 (232, 232, 28, '2008-10-21 16:07:55', NULL, '2008-10-21 16:07:55', NULL, 28, 69, 179, 0), 1315 (233, 233, 28, '2008-10-21 16:08:16', NULL, '2008-10-21 16:08:16', NULL, 28, 69, 180, 0), 1316 (234, 234, 28, '2008-10-21 16:08:34', NULL, '2008-10-21 16:08:34', NULL, 28, 69, 181, 0), 1317 (235, 235, 28, '2008-10-21 16:08:55', NULL, '2008-10-21 16:08:55', NULL, 28, 69, 182, 0), 1318 (236, 236, 28, '2008-10-21 16:09:19', NULL, '2008-10-21 16:09:19', NULL, 28, 68, 42, 0), 1319 (237, 237, 28, '2008-10-21 16:09:55', NULL, '2008-10-21 16:09:55', NULL, 28, 69, 183, 1), 1320 (238, 238, 28, '2008-10-22 07:13:27', NULL, '2008-10-22 07:13:27', NULL, 28, 68, 43, 0), 1321 (239, 239, 28, '2008-10-22 07:43:39', NULL, '2008-10-22 07:43:39', NULL, 28, 68, 44, 0), 1322 (240, 240, 28, '2008-10-22 08:05:42', NULL, '2008-10-22 08:05:42', NULL, 28, 50, 14, 1), 1323 (241, 241, 28, '2008-10-22 08:09:18', NULL, '2008-10-22 08:09:18', NULL, 28, 69, 184, 1), 1324 (242, 242, 28, '2008-10-22 08:40:51', NULL, '2008-10-22 08:40:51', NULL, 28, 69, 185, 1), 1325 (243, 243, 5, '2008-10-22 08:43:30', NULL, '2008-10-22 08:43:30', NULL, 28, 69, 186, 1), 1326 (244, 244, 5, '2008-10-22 11:50:06', NULL, '2008-10-22 11:50:06', NULL, 28, 68, 45, 0), 1327 (245, 245, 5, '2008-10-22 11:50:30', NULL, '2008-10-22 11:50:30', NULL, 28, 68, 46, 0), 1328 (246, 246, 5, '2008-10-22 12:49:17', NULL, '2008-10-22 12:49:17', NULL, 28, 43, 75, 0), 1329 (247, 247, 5, '2008-10-22 12:50:21', NULL, '2008-10-22 12:50:21', NULL, 28, 43, 25, 2), 1330 (248, 248, 5, '2008-10-22 12:50:58', NULL, '2008-10-22 12:50:58', NULL, 28, 43, 76, 0), 1331 (249, 249, 5, '2008-10-22 12:52:24', NULL, '2008-10-22 12:52:24', NULL, 28, 43, 77, 0), 1332 (250, 250, 5, '2008-10-27 11:03:03', NULL, '2008-10-27 11:03:03', NULL, 28, 43, 79, 0), 1333 (251, 251, 5, '2008-10-27 12:05:17', NULL, '2008-10-27 12:05:17', NULL, 28, 43, 80, 0), 1334 (252, 252, 5, '2008-10-27 12:11:07', NULL, '2008-10-27 12:11:07', NULL, 28, 43, 81, 0), 1335 (253, 253, 5, '2008-10-27 12:15:20', NULL, '2008-10-27 12:15:20', NULL, 28, 43, 31, 2), 1336 (254, 254, 5, '2008-10-27 12:16:48', NULL, '2008-10-27 12:16:48', NULL, 28, 43, 31, 2), 1337 (255, 255, 5, '2008-10-27 12:18:17', NULL, '2008-10-27 12:18:17', NULL, 28, 43, 31, 2), 1338 (256, 256, 5, '2008-10-27 12:18:22', NULL, '2008-10-27 12:18:22', NULL, 28, 43, 31, 2), 1339 (257, 257, 5, '2008-10-27 12:18:24', NULL, '2008-10-27 12:18:24', NULL, 28, 43, 30, 2), 1340 (258, 258, 5, '2008-10-27 12:18:26', NULL, '2008-10-27 12:18:26', NULL, 28, 43, 23, 2), 1341 (259, 259, 5, '2008-10-27 12:25:08', NULL, '2008-10-27 12:25:08', NULL, 28, 43, 23, 2), 1342 (260, 260, 5, '2008-10-27 13:52:30', NULL, '2008-10-27 13:52:30', NULL, 28, 43, 27, 2), 1343 (261, 261, 5, '2008-10-27 13:52:34', NULL, '2008-10-27 13:52:34', NULL, 28, 43, 27, 2), 1344 (262, 262, 5, '2008-10-27 13:52:37', NULL, '2008-10-27 13:52:37', NULL, 28, 43, 26, 2), 1345 (263, 263, 5, '2008-10-27 13:52:40', NULL, '2008-10-27 13:52:40', NULL, 28, 43, 26, 2), 1346 (264, 264, 5, '2008-10-27 13:52:48', NULL, '2008-10-27 13:52:48', NULL, 28, 43, 29, 2), 1347 (265, 265, 5, '2008-10-27 13:55:21', NULL, '2008-10-27 13:55:21', NULL, 28, 43, 29, 2), 1348 (266, 266, 5, '2008-10-27 13:55:28', NULL, '2008-10-27 13:55:28', NULL, 28, 43, 82, 0), 1349 (267, 267, 5, '2008-10-27 13:55:38', NULL, '2008-10-27 13:55:38', NULL, 28, 43, 32, 2), 1350 (268, 268, 5, '2008-10-27 13:55:49', NULL, '2008-10-27 13:55:49', NULL, 28, 43, 32, 2), 1351 (269, 269, 5, '2008-10-27 13:56:31', NULL, '2008-10-27 13:56:31', NULL, 28, 69, 187, 0), 1352 (270, 270, 5, '2008-10-27 13:57:19', NULL, '2008-10-27 13:57:19', NULL, 28, 69, 188, 0), 1353 (271, 271, 5, '2008-10-27 13:59:51', NULL, '2008-10-27 13:59:51', NULL, 28, 54, 57, 0), 1354 (272, 272, 5, '2008-10-27 14:00:37', NULL, '2008-10-27 14:00:37', NULL, 28, 54, 58, 1), 1355 (273, 273, 5, '2008-10-27 14:01:06', NULL, '2008-10-27 14:01:06', NULL, 28, 69, 189, 0), 1356 (274, 274, 5, '2008-10-27 14:01:45', NULL, '2008-10-27 14:01:45', NULL, 28, 69, 169, 2), 1357 (275, 275, 5, '2008-10-27 14:02:10', NULL, '2008-10-27 14:02:10', NULL, 28, 69, 190, 0), 1358 (276, 276, 5, '2008-10-27 14:02:53', NULL, '2008-10-27 14:02:53', NULL, 28, 54, 59, 1), 1359 (277, 277, 5, '2008-10-27 14:03:32', NULL, '2008-10-27 14:03:32', NULL, 28, 69, 191, 0), 1360 (278, 278, 5, '2008-10-27 14:04:48', NULL, '2008-10-27 14:04:48', NULL, 28, 68, 47, 0), 1361 (279, 279, 5, '2008-10-27 14:05:45', NULL, '2008-10-27 14:05:45', NULL, 28, 78, 1, 0), 1362 (280, 280, 5, '2008-10-27 14:08:15', NULL, '2008-10-27 14:08:15', NULL, 28, 69, 192, 0), 1363 (281, 281, 5, '2008-10-27 14:08:30', NULL, '2008-10-27 14:08:30', NULL, 28, 78, 2, 1), 1364 (282, 282, 5, '2008-10-27 14:08:44', NULL, '2008-10-27 14:08:44', NULL, 28, 69, 193, 1), 1365 (283, 283, 5, '2008-10-27 14:09:20', NULL, '2008-10-27 14:09:20', NULL, 28, 78, 3, 0), 1366 (284, 284, 5, '2008-10-27 14:09:27', NULL, '2008-10-27 14:09:27', NULL, 28, 78, 2, 2), 1367 (285, 285, 5, '2008-10-27 14:09:51', NULL, '2008-10-27 14:09:51', NULL, 28, 78, 4, 0), 1368 (286, 286, 5, '2008-10-27 14:10:12', NULL, '2008-10-27 14:10:12', NULL, 28, 78, 5, 0), 1369 (287, 287, 5, '2008-10-27 14:10:43', NULL, '2008-10-27 14:10:43', NULL, 28, 43, 83, 0), 1370 (288, 288, 5, '2008-10-27 14:11:38', NULL, '2008-10-27 14:11:38', NULL, 28, 54, 60, 0), 1371 (289, 289, 5, '2008-10-27 14:12:09', NULL, '2008-10-27 14:12:09', NULL, 28, 69, 194, 0), 1372 (290, 290, 5, '2008-10-27 14:13:05', NULL, '2008-10-27 14:13:05', NULL, 28, 69, 195, 0), 1373 (291, 291, 5, '2008-10-27 14:14:03', NULL, '2008-10-27 14:14:03', NULL, 28, 68, 48, 0), 1374 (292, 292, 5, '2008-10-27 14:14:41', NULL, '2008-10-27 14:14:41', NULL, 28, 78, 6, 0); 1375 1376 -- -------------------------------------------------------- 1377 1378 -- 1379 -- Struktura tabulky `SystemMenu` 1380 -- 1381 1382 CREATE TABLE IF NOT EXISTS `SystemMenu` ( 1383 `Id` int(11) NOT NULL auto_increment, 1384 `ItemId` int(11) NOT NULL, 1385 `Author` int(11) NOT NULL, 1386 `ValidTimeFrom` datetime default NULL, 1387 `ValidTimeTo` datetime default NULL, 1388 `CreationTime` datetime default NULL, 1389 `DeletionTime` datetime default NULL, 1390 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 1391 `SystemListItems` int(11) NOT NULL, 654 1392 PRIMARY KEY (`Id`) 655 1393 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ; 656 1394 657 1395 -- 658 -- Vypisuji data pro tabulku `SystemFile` 659 -- 660 1396 -- Vypisuji data pro tabulku `SystemMenu` 1397 -- 1398 1399 INSERT INTO `SystemMenu` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `SystemListItems`) VALUES 1400 (1, 1, 5, '2008-10-21 08:14:39', NULL, '2008-10-21 08:14:39', NULL, 'Systém', 0), 1401 (2, 2, 5, '2008-10-21 08:14:59', NULL, '2008-10-21 08:14:59', NULL, 'Evidence sítě', 0), 1402 (3, 3, 5, '2008-10-21 08:55:36', NULL, '2008-10-21 08:55:36', NULL, 'Řízení přístupu', 0), 1403 (4, 4, 28, '2008-10-21 14:38:33', NULL, '2008-10-21 14:38:33', NULL, 'Webové stránky', 0); 1404 1405 -- -------------------------------------------------------- 1406 1407 -- 1408 -- Struktura tabulky `SystemType` 1409 -- 1410 1411 CREATE TABLE IF NOT EXISTS `SystemType` ( 1412 `Id` int(11) NOT NULL auto_increment, 1413 `ItemId` int(11) NOT NULL, 1414 `Author` int(11) NOT NULL, 1415 `ValidTimeFrom` datetime default NULL, 1416 `ValidTimeTo` datetime default NULL, 1417 `CreationTime` datetime default NULL, 1418 `DeletionTime` datetime default NULL, 1419 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 1420 `Description` varchar(255) collate utf8_czech_ci NOT NULL, 1421 `ParentType` int(255) NOT NULL, 1422 `Parameters` varchar(255) collate utf8_czech_ci NOT NULL, 1423 `System` tinyint(1) NOT NULL default '0', 1424 `DbDataType` varchar(255) collate utf8_czech_ci NOT NULL, 1425 `ParameterList` int(11) NOT NULL, 1426 PRIMARY KEY (`Id`) 1427 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=61 ; 1428 1429 -- 1430 -- Vypisuji data pro tabulku `SystemType` 1431 -- 1432 1433 INSERT INTO `SystemType` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `Description`, `ParentType`, `Parameters`, `System`, `DbDataType`, `ParameterList`) VALUES 1434 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Integer', 'Číslo', 0, '', 1, 'INT', 0), 1435 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Date', 'Datum', 0, '', 1, 'DATE', 0), 1436 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'String', 'Řetězec', 0, '', 1, 'VARCHAR(255)', 0), 1437 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Boolean', 'Logická hodnota', 0, '', 1, 'BOOL', 0), 1438 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Sex', 'Pohlaví', 14, 'Muž|Žena', 0, 'INT', 0), 1439 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MemberState', 'Stav člena', 14, 'Neznámý stav|Zájemce o připojení|Připojen|Trvale odpojen', 0, 'INT', 0), 1440 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'HostType', 'Typ zařízení', 14, 'Nezařazeno|Osobní počítač|VoIP zařízení|IPTV zařízení|Směrovač|Server|Tiskárna/Skener/Kopírka|Jiné', 0, 'INT', 0), 1441 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'InterfaceType', 'Typ rozhraní', 14, 'Jiný|Ethernet 10 Mbit/s|Ethernet 100 Mbit/s|Ethernet 1 Gbit/s|Wifi 2,4 GHz 802.11b 11 Mbit/s|Wifi 2,4 GHz 802.11g 54 Mbit/s|Wifi 5 GHz 802.11a 54 Mbit/s|Optika 100 Mbit/s|Optika 1 Gbit/s', 0, 'INT', 0), 1442 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'AssetState', 'Stav majetku', 14, 'Neznámý|Na skladě|Používáno|V reklamaci|Vyřazeno', 0, 'INT', 0), 1443 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MemberReportType', 'Typ hlášení člena', 14, 'Jiné|Hlášení závady|Požadavek na změnu|Poznámka správce', 0, 'INT', 0), 1444 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'BankAccountType', 'Typ účtu', 14, 'Neurčeno|Běžný účet|Spořící účet', 0, 'INT', 0), 1445 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerOneToOne', 'Ukazatel na jednu položku', 0, '', 1, 'INT', 0), 1446 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerOneToMany', 'Ukazatel na více položek', 0, '', 1, 'INT', 0), 1447 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Enumeration', 'Výčet', 0, '', 0, 'INT', 0), 1448 (15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Password', 'Heslo', 0, '', 1, 'INT', 0), 1449 (16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Float', 'Desetinné číslo', 0, '', 1, 'FLOAT', 0), 1450 (17, 17, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'FinanceTransactionType', 'Typ finanční transakce', 14, 'Bankovní převod|Osobní platba', 0, 'INT', 0), 1451 (18, 18, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Hyperlink', 'Internetový odkaz', 0, '', 0, 'VARCHAR(255)', 0), 1452 (19, 19, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'IPv4Address', 'IP adresa v4', 0, '', 0, 'VARCHAR(16)', 0), 1453 (20, 20, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Hidden', 'Skrytá položka formuláře', 0, '', 1, 'VARCHAR(255)', 0), 1454 (21, 21, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:01:23', NULL, 'PointerToAssetPurcheasedFrom', '', 13, 'Asset|PurcheasedFrom', 0, 'INT', 0), 1455 (22, 22, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:02:00', NULL, 'PointerToHostArea', '', 13, 'Host|Area', 0, 'INT', 0), 1456 (23, 23, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:04:28', NULL, 'PointerToHostMember', '', 13, 'Host|Member', 0, 'INT', 0), 1457 (24, 24, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:05:47', NULL, 'PointerToInterfaceHost', '', 13, 'Interface|Host', 0, 'INT', 0), 1458 (25, 25, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:07:15', NULL, 'PointerToMemberSubject', '', 13, 'Member|Subject', 0, 'INT', 0), 1459 (26, 26, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:07:15', NULL, 'PointerToMemberTariff', '', 13, 'Member|Tariff', 0, 'INT', 0), 1460 (27, 27, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerToMemberReportMember', '', 13, 'MemberReport|Member ', 0, 'INT', 0), 1461 (28, 28, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerToSystemListItemList', '', 13, 'SystemListItem|List', 0, 'INT', 0), 1462 (29, 29, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:09:55', NULL, 'PointerToUserMember', '', 13, 'User|Member', 0, 'INT', 0), 1463 (30, 30, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:09:55', NULL, 'PointerToArea', '', 12, 'Area', 0, 'INT', 0), 1464 (31, 31, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerOneToHost', '', 12, 'Host', 0, 'INT', 0), 1465 (32, 32, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerToMember', '', 12, 'Member', 0, 'INT', 0), 1466 (33, 33, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:11:14', NULL, 'PointerToSubject', '', 12, 'Subject', 0, 'INT', 0), 1467 (34, 34, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:12:37', NULL, 'PointerToSystemList', '', 12, 'SystemList', 0, 'INT', 0), 1468 (35, 35, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerToSystemType', '', 12, 'SystemType', 0, 'INT', 0), 1469 (36, 36, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:13:41', NULL, 'PointerToTariff', '', 12, 'Tariff', 0, 'INT', 0), 1470 (37, 37, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:13:41', NULL, 'PointerToUser', '', 12, 'User', 0, 'INT', 0), 1471 (38, 38, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerToHostParentHost', '', 13, 'Host|ParentHost', 0, 'INT', 0), 1472 (39, 39, 5, '2008-10-13 10:03:19', NULL, '2008-10-13 10:03:19', NULL, 'PointerToPermissionGroup', 'Ukazatel na skupinu oprávnění', 12, 'PermissionGroup', 0, 'INT', 0), 1473 (40, 40, 5, '2008-10-13 10:33:20', NULL, '2008-10-13 10:33:20', NULL, 'MySQLDataTypes', 'Databázový datový typ ', 14, 'INT|VARCHAR(255)|TEXT|FLOAT|DOUBLE|TIME|DATE|DATETIME|', 1, 'INT', 0), 1474 (41, 41, 5, '2008-10-13 10:40:38', NULL, '2008-10-13 10:40:38', NULL, 'PointerToPermissionPermissionGroup', 'Definovaná oprávnění', 13, 'Permission|PermissionGroup', 0, 'INT', 0), 1475 (42, 42, 5, '2008-10-13 10:43:25', NULL, '2008-10-13 10:43:25', NULL, 'PermissionRights', 'Typ oprávnění', 14, 'Žádné|Čtení|Čtení i zápis', 0, 'INT', 0), 1476 (43, 43, 5, '2008-10-13 12:05:14', NULL, '2008-10-13 12:05:14', NULL, 'PointerToUserPermissionGroup', 'Uživatelé s oprávněním', 13, 'User|PermissionGroup', 0, 'INT', 0), 1477 (44, 44, 5, '2008-10-13 12:16:46', NULL, '2008-10-13 12:16:46', NULL, 'ActionType', 'Typ akce', 14, 'Přidáno|Upraveno|Odebráno', 0, 'INT', 0), 1478 (45, 31, 5, '2008-10-13 13:39:08', NULL, '2008-10-13 13:39:08', NULL, 'PointerToHost', '', 12, 'Host', 0, 'INT', 0), 1479 (46, 45, 5, '2008-10-14 07:02:50', NULL, '2008-10-14 07:02:50', NULL, 'DateTime', 'Datum a čas', 0, '', 1, 'DATETIME', 0), 1480 (47, 46, 5, '2008-10-14 07:48:07', NULL, '2008-10-14 07:48:07', NULL, 'File', 'Soubor', 0, '', 1, 'INT', 0), 1481 (48, 47, 5, '2008-10-21 08:13:34', NULL, '2008-10-21 08:13:34', '2008-10-21 08:18:00', 'PointerToMenu', 'Ukazatel na menu', 12, '', 0, 'INT', 0), 1482 (49, 47, 5, '2008-10-21 08:18:00', NULL, '2008-10-21 08:18:00', '2008-10-21 08:19:02', 'PointerToMenu', 'Ukazatel na menu', 12, 'Menu', 0, 'INT', 0), 1483 (50, 47, 5, '2008-10-21 08:19:02', NULL, '2008-10-21 08:19:02', NULL, 'PointerToMenu', 'Ukazatel na menu', 12, 'SystemMenu', 0, 'INT', 0), 1484 (51, 48, 5, '2008-10-21 08:22:44', NULL, '2008-10-21 08:22:44', '2008-10-21 08:24:13', 'PointerToSystemListMenu', 'Položky menu', 13, 'SystemList:Menu', 0, 'INT', 0), 1485 (52, 48, 5, '2008-10-21 08:24:13', NULL, '2008-10-21 08:24:13', NULL, 'PointerToSystemListMenu', 'Položky menu', 13, 'SystemList|Menu', 0, 'INT', 0), 1486 (53, 49, 5, '2008-10-21 09:58:14', NULL, '2008-10-21 09:58:14', NULL, 'GPS', 'Zemská souřadnice', 0, '', 1, 'INT', 0), 1487 (54, 50, 28, '2008-10-21 14:42:57', NULL, '2008-10-21 14:42:57', NULL, 'PointerToNewsGroup', 'Ukazatel na skupinu aktualit', 12, 'NewsGroup', 0, 'INT', 0), 1488 (55, 51, 28, '2008-10-21 14:45:16', NULL, '2008-10-21 14:45:16', '2008-10-21 15:56:12', 'PointerToNewsItemGroup', 'Aktuality', 13, 'NewsItem|Group', 0, 'INT', 0), 1489 (56, 51, 28, '2008-10-21 15:56:12', NULL, '2008-10-21 15:56:12', NULL, 'PointerToNewsItemGroup', 'Aktuality', 13, 'NewsItem|NewsGroup', 0, 'INT', 0), 1490 (57, 52, 5, '2008-10-27 13:59:51', NULL, '2008-10-27 13:59:51', '2008-10-27 14:00:37', 'PointerToSystemTypeParameter', 'Ukazatel na seznam paramtrů', 13, '', 0, 'INT', 0), 1491 (58, 52, 5, '2008-10-27 14:00:37', NULL, '2008-10-27 14:00:37', '2008-10-27 14:02:53', 'PointerToSystemTypeParameter', 'Ukazatel na seznam paramtrů', 13, 'SystemTypeParameter|Type', 0, 'INT', 0), 1492 (59, 52, 5, '2008-10-27 14:02:53', NULL, '2008-10-27 14:02:53', NULL, 'PointerToSystemTypeParameter', 'Ukazatel na seznam paramtrů', 13, 'SystemTypeParameter|ParentType', 0, 'INT', 0), 1493 (60, 53, 5, '2008-10-27 14:11:38', NULL, '2008-10-27 14:11:38', NULL, 'PointerToSystemEnumerationState', 'Seznam stavů výčtu', 13, 'SystemEnumerationState|ParentType', 0, 'INT', 0); 1494 1495 -- -------------------------------------------------------- 1496 1497 -- 1498 -- Struktura tabulky `SystemTypeParameter` 1499 -- 1500 1501 CREATE TABLE IF NOT EXISTS `SystemTypeParameter` ( 1502 `Id` int(11) NOT NULL auto_increment, 1503 `ItemId` int(11) NOT NULL, 1504 `Author` int(11) NOT NULL, 1505 `ValidTimeFrom` datetime default NULL, 1506 `ValidTimeTo` datetime default NULL, 1507 `CreationTime` datetime default NULL, 1508 `DeletionTime` datetime default NULL, 1509 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 1510 `Type` int(11) NOT NULL, 1511 `ParentType` int(11) NOT NULL, 1512 `Description` varchar(255) collate utf8_czech_ci NOT NULL, 1513 PRIMARY KEY (`Id`) 1514 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=7 ; 1515 1516 -- 1517 -- Vypisuji data pro tabulku `SystemTypeParameter` 1518 -- 1519 1520 INSERT INTO `SystemTypeParameter` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `Type`, `ParentType`, `Description`) VALUES 1521 (1, 1, 5, '2008-10-27 14:05:45', NULL, '2008-10-27 14:05:45', '2008-10-27 14:08:30', 'List', 34, 12, ''), 1522 (2, 1, 5, '2008-10-27 14:08:30', NULL, '2008-10-27 14:08:30', NULL, 'List', 34, 12, 'Seznam'), 1523 (3, 2, 5, '2008-10-27 14:09:20', NULL, '2008-10-27 14:09:20', '2008-10-27 14:09:27', 'ColumnId', 1, 12, 'Identifikace sloupce'), 1524 (4, 3, 5, '2008-10-27 14:09:51', NULL, '2008-10-27 14:09:51', NULL, 'List', 34, 13, 'Seznam'), 1525 (5, 4, 5, '2008-10-27 14:10:12', NULL, '2008-10-27 14:10:12', NULL, 'Column', 1, 13, 'Identifikace sloupce'), 1526 (6, 5, 5, '2008-10-27 14:14:41', NULL, '2008-10-27 14:14:41', NULL, 'StateList', 53, 14, 'Seznam stavů'); 1527 1528 -- -------------------------------------------------------- 1529 1530 -- 1531 -- Struktura tabulky `Tariff` 1532 -- 1533 1534 CREATE TABLE IF NOT EXISTS `Tariff` ( 1535 `Id` int(11) NOT NULL auto_increment, 1536 `ItemId` int(11) NOT NULL, 1537 `Author` int(11) NOT NULL, 1538 `ValidTimeFrom` datetime default NULL, 1539 `ValidTimeTo` datetime default NULL, 1540 `CreationTime` datetime default NULL, 1541 `DeletionTime` datetime default NULL, 1542 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 1543 `Price` float NOT NULL, 1544 `MinUploadSpeed` int(11) NOT NULL, 1545 `MaxUploadSpeed` int(11) NOT NULL, 1546 `MinDownloadSpeed` int(11) NOT NULL, 1547 `MaxDownloadSpeed` int(11) NOT NULL, 1548 `MemberList` int(11) NOT NULL, 1549 PRIMARY KEY (`Id`) 1550 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ; 1551 1552 -- 1553 -- Vypisuji data pro tabulku `Tariff` 1554 -- 1555 1556 INSERT INTO `Tariff` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `Price`, `MinUploadSpeed`, `MaxUploadSpeed`, `MinDownloadSpeed`, `MaxDownloadSpeed`, `MemberList`) VALUES 1557 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 512 kbit', 190, 31, 512, 31, 512, 0), 1558 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 1 Mbit', 260, 62, 1024, 62, 1024, 0), 1559 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 2 Mbit', 360, 124, 2048, 124, 2048, 0), 1560 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 4 Mbit', 520, 249, 4096, 249, 4096, 0), 1561 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 8 Mbit', 750, 497, 8192, 497, 8192, 0); 1562 1563 -- -------------------------------------------------------- 1564 1565 -- 1566 -- Struktura tabulky `test` 1567 -- 1568 1569 CREATE TABLE IF NOT EXISTS `test` ( 1570 `Id` int(11) NOT NULL auto_increment, 1571 `ItemId` int(11) NOT NULL, 1572 `Author` int(11) NOT NULL, 1573 `ValidTimeFrom` datetime default NULL, 1574 `ValidTimeTo` datetime default NULL, 1575 `CreationTime` datetime default NULL, 1576 `DeletionTime` datetime default NULL, 1577 PRIMARY KEY (`Id`) 1578 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ; 1579 1580 -- 1581 -- Vypisuji data pro tabulku `test` 1582 -- 1583 1584 1585 -- -------------------------------------------------------- 1586 1587 -- 1588 -- Struktura tabulky `User` 1589 -- 1590 1591 CREATE TABLE IF NOT EXISTS `User` ( 1592 `Id` int(11) NOT NULL auto_increment, 1593 `ItemId` int(11) NOT NULL, 1594 `Author` int(11) NOT NULL, 1595 `ValidTimeFrom` datetime default NULL, 1596 `ValidTimeTo` datetime default NULL, 1597 `CreationTime` datetime default NULL, 1598 `DeletionTime` datetime default NULL, 1599 `UserName` varchar(255) collate utf8_czech_ci NOT NULL, 1600 `Password` varchar(255) collate utf8_czech_ci NOT NULL, 1601 `FirstName` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL, 1602 `SecondName` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL, 1603 `Email` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL, 1604 `ICQ` int(11) NOT NULL, 1605 `Sex` int(11) NOT NULL default '0', 1606 `BirthDay` date NOT NULL, 1607 `Phone` varchar(255) collate utf8_czech_ci NOT NULL, 1608 `Member` int(11) NOT NULL, 1609 `RegistrationTime` datetime NOT NULL, 1610 `LastLoginTime` datetime NOT NULL, 1611 `Locked` tinyint(1) NOT NULL, 1612 `LastIpAddress` varchar(255) collate utf8_czech_ci NOT NULL, 1613 `PermissionGroup` int(11) NOT NULL, 1614 PRIMARY KEY (`Id`) 1615 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=36 ; 1616 1617 -- 1618 -- Vypisuji data pro tabulku `User` 1619 -- 1620 1621 INSERT INTO `User` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `UserName`, `Password`, `FirstName`, `SecondName`, `Email`, `ICQ`, `Sex`, `BirthDay`, `Phone`, `Member`, `RegistrationTime`, `LastLoginTime`, `Locked`, `LastIpAddress`, `PermissionGroup`) VALUES 1622 (1, 1, 5, NULL, NULL, '2008-10-13 07:50:41', NULL, '', 'fdsfsdfsd', 'Alfons', 'Much', 'mucha@all.cz', 89, 0, '0000-00-00', '', 7, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0), 1623 (35, 2, 5, '2008-10-21 14:16:35', NULL, '2008-10-21 14:16:35', NULL, 'petr', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', 'Petr', 'Hrubý', 'hrubos@nevim.cz', 23, 0, '1900-01-01', '123456789', 0, '1900-01-01 00:00:00', '2008-10-21 16:10:26', 0, '', 5), 1624 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ferda', '123', 'Ferda', 'Mravenec', 'ferda@mraveniste.cz', 1, 0, '0000-00-00', '', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0), 1625 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '0000-00-00', '', 6, '0000-00-00 00:00:00', '2008-10-25 20:56:10', 0, '', 0), 1626 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '0000-00-00', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0), 1627 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Petr', 'Slovák', 'slovak@zdarma.cz', 34, 0, '0000-00-00', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0), 1628 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Alena', 'Kocourková', 'alena.kocourkova@centrum.cz', 32, 1, '0000-00-00', '223344556', 7, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0), 1629 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Jonny', 'Hurikán', 'storm@atlas.cz', 16, 0, '0000-00-00', '224556778', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0), 1630 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Smrťák', 'Krutý', 'smrt@peklo.cz', 111222333, 0, '0000-00-00', '', 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0), 1631 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-21 12:56:43', '', '', 'Karel', 'Nejedlý', 'starosta@obec-milosice.cz', 0, 0, '0000-00-00', '443666333', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0), 1632 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'fantomas', 'dsds', 'Fantomas', 'Tajemný', 'fantom@fantom.com', 0, 0, '0000-00-00', '', 12, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0), 1633 (13, 1, 5, '2008-10-13 10:06:57', NULL, '2008-10-13 10:06:57', NULL, '', 'fdsfsdfsd', 'Alfons', 'Much', 'mucha@all.cz', 89, 0, '1900-01-01', '', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 6), 1634 (14, 5, 5, '2008-10-13 10:07:33', NULL, '2008-10-13 10:07:33', NULL, 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '1900-01-01', '', 6, '1900-01-01 00:00:00', '2008-10-13 00:00:00', 0, '', 2), 1635 (15, 2, 5, '2008-10-13 10:07:44', NULL, '2008-10-13 10:07:44', '2008-10-21 13:33:00', '', '', 'Petr', 'Hrubý', 'hrubos@nevim.cz', 23, 0, '1900-01-01', '123456789', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 5), 1636 (16, 6, 5, '2008-10-13 10:07:58', NULL, '2008-10-13 10:07:58', '2008-10-15 15:53:45', '', '', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '1900-01-01', '', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 6), 1637 (17, 10, 5, '2008-10-13 12:03:27', NULL, '2008-10-13 12:03:27', NULL, '', '', 'Smrťák', 'Krutý', 'smrt@peklo.cz', 111222333, 0, '1900-01-01', '', 5, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 6), 1638 (18, 9, 5, '2008-10-13 12:03:50', NULL, '2008-10-13 12:03:50', NULL, '', '', 'Jonny', 'Hurikán', 'storm@atlas.cz', 16, 0, '1988-04-05', '224556778', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 5), 1639 (19, 7, 5, '2008-10-13 12:04:01', NULL, '2008-10-13 12:04:01', NULL, '', '', 'Petr', 'Slovák', 'slovak@zdarma.cz', 34, 0, '1900-01-01', '', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 5), 1640 (20, 4, 5, '2008-10-13 12:04:10', NULL, '2008-10-13 12:04:10', NULL, 'ferda', '123', 'Ferda', 'Mravenec', 'ferda@mraveniste.cz', 1, 0, '1900-01-01', '', 2, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 5), 1641 (21, 8, 5, '2008-10-13 13:57:30', NULL, '2008-10-13 13:57:30', NULL, 'alenka', 'dsdasas', 'Alena', 'Kocourková', 'alena.kocourkova@centrum.cz', 324545454, 1, '2004-10-09', '223344556', 1, '1915-01-01 00:00:00', '1900-01-01 00:00:00', 0, '192.168.0.1', 6), 1642 (22, 5, 5, '2008-10-14 09:47:32', NULL, '2008-10-14 09:47:32', NULL, 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '1900-01-01', '', 6, '1900-01-01 00:00:00', '2008-10-13 00:00:00', 0, '', 2), 1643 (23, 5, 5, '2008-10-14 09:57:36', NULL, '2008-10-14 09:57:36', NULL, 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '1900-01-01', '', 6, '1900-01-01 00:00:00', '2008-10-13 00:00:00', 0, '', 3), 1644 (24, 5, 5, '2008-10-14 09:57:54', NULL, '2008-10-14 09:57:54', '2008-10-21 07:06:35', 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '1900-01-01', '', 6, '1900-01-01 00:00:00', '2008-10-13 00:00:00', 0, '', 2), 1645 (25, 6, 5, '2008-10-15 15:53:45', NULL, '2008-10-15 15:53:45', '2008-10-15 15:55:21', '', '', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '1900-01-01', '999', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 6), 1646 (26, 6, 5, '2008-10-15 15:55:21', NULL, '2008-10-15 15:55:21', '2008-10-15 16:00:07', '', '', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '1900-01-01', '999', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 6), 1647 (27, 6, 5, '2008-10-15 16:00:07', NULL, '2008-10-15 16:00:07', '2008-10-21 09:06:54', '', '', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '1900-01-01', '999', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 6), 1648 (28, 5, 5, '2008-10-21 07:06:35', NULL, '2008-10-21 07:06:35', NULL, 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '1900-01-01', '', 6, '1900-01-01 00:00:00', '2008-10-13 00:00:00', 0, '', 1), 1649 (29, 6, 5, '2008-10-21 09:06:54', NULL, '2008-10-21 09:06:54', NULL, 'joda', 'muhehe', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '1900-01-01', '999', 4, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 3), 1650 (30, 11, 5, '2008-10-21 12:56:43', NULL, '2008-10-21 12:56:43', NULL, '', '', 'Karel', 'Nejedlý', 'starosta@obec-milosice.cz', 0, 0, '1900-01-01', '443666333', 5, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 5), 1651 (31, 13, 5, '2008-10-21 13:13:52', NULL, '2008-10-21 13:13:52', NULL, 'ježek', 'dsds', 'Sony', '', 'sony@megadrive.com', 2222, 0, '1904-01-01', '', 3, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 1, '', 4), 1652 (32, 2, 5, '2008-10-21 13:33:00', NULL, '2008-10-21 13:33:00', '2008-10-21 13:45:09', 'petr', 'hruboš', 'Petr', 'Hrubý', 'hrubos@nevim.cz', 23, 0, '1900-01-01', '123456789', 0, '1900-01-01 00:00:00', '2008-10-21 13:56:39', 0, '', 5), 1653 (33, 2, 5, '2008-10-21 13:45:09', NULL, '2008-10-21 13:45:09', '2008-10-21 13:45:28', 'petr', 'c6bd4c44228e4c1a18248ba51c744ce7d36db324', 'Petr', 'Hrubý', 'hrubos@nevim.cz', 23, 0, '1900-01-01', '123456789', 0, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 5), 1654 (34, 2, 5, '2008-10-21 13:45:28', NULL, '2008-10-21 13:45:28', '2008-10-21 14:16:35', 'petr', 'c6bd4c44228e4c1a18248ba51c744ce7d36db324', 'Petr', 'Hrubý', 'hrubos@nevim.cz', 23, 0, '1900-01-01', '123456789', 0, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 5); 1655 1656 -- -------------------------------------------------------- 1657 1658 -- 1659 -- Struktura tabulky `UserOnline` 1660 -- 1661 1662 CREATE TABLE IF NOT EXISTS `UserOnline` ( 1663 `User` int(11) NOT NULL, 1664 `LoginTime` datetime NOT NULL, 1665 `ActivityTime` datetime NOT NULL, 1666 `SessionId` varchar(255) collate utf8_czech_ci NOT NULL, 1667 `IpAddress` varchar(16) collate utf8_czech_ci NOT NULL, 1668 `HostName` varchar(255) collate utf8_czech_ci NOT NULL, 1669 `Id` int(11) NOT NULL auto_increment, 1670 `ItemId` int(11) NOT NULL, 1671 `Author` int(11) NOT NULL, 1672 `ValidTimeFrom` datetime default NULL, 1673 `ValidTimeTo` datetime default NULL, 1674 `CreationTime` datetime default NULL, 1675 `DeletionTime` datetime default NULL, 1676 PRIMARY KEY (`Id`), 1677 KEY `User` (`User`) 1678 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=37 ; 1679 1680 -- 1681 -- Vypisuji data pro tabulku `UserOnline` 1682 -- 1683 1684 INSERT INTO `UserOnline` (`User`, `LoginTime`, `ActivityTime`, `SessionId`, `IpAddress`, `HostName`, `Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`) VALUES 1685 (5, '2008-10-25 20:56:03', '2008-10-27 14:15:02', 'koaodnvsoi9lehrih06mc3sev2', '192.168.0.23', '192.168.0.23', 36, 5, 0, NULL, NULL, NULL, NULL);
Note:
See TracChangeset
for help on using the changeset viewer.
