source: trunk/sql/demo_database.sql

Last change on this file was 24, checked in by george, 16 years ago
  • Upraveno: Odkazy na seznamy pomocí ItemId namísto jmen tabulek.
  • Přidáno: Potvrzovací dialog při mazání položek.
File size: 137.0 KB
Line 
1-- phpMyAdmin SQL Dump
2-- version 3.0.1
3-- http://www.phpmyadmin.net
4--
5-- Počítač: localhost
6-- Vygenerováno: Pondělí 27. října 2008, 14:15
7-- Verze MySQL: 5.0.51
8-- Verze PHP: 5.2.6
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12--
13-- Databáze: `webis`
14--
15
16-- --------------------------------------------------------
17
18--
19-- Struktura tabulky `Area`
20--
21
22CREATE TABLE IF NOT EXISTS `Area` (
23 `Id` int(11) NOT NULL auto_increment,
24 `ItemId` int(11) NOT NULL,
25 `Author` int(11) NOT NULL,
26 `ValidTimeFrom` datetime default NULL,
27 `ValidTimeTo` datetime default NULL,
28 `CreationTime` datetime default NULL,
29 `DeletionTime` datetime default NULL,
30 `Name` varchar(255) collate utf8_czech_ci NOT NULL,
31 `NetworkIPAddress` varchar(255) collate utf8_czech_ci NOT NULL,
32 `IPAddressMask` varchar(255) collate utf8_czech_ci NOT NULL,
33 `DNSPrimary` varchar(255) collate utf8_czech_ci NOT NULL,
34 `DNSSecondary` varchar(255) collate utf8_czech_ci NOT NULL,
35 `DHCP` varchar(255) collate utf8_czech_ci NOT NULL,
36 `Domain` varchar(255) collate utf8_czech_ci NOT NULL,
37 `Workgroup` varchar(255) collate utf8_czech_ci NOT NULL,
38 `WINS` varchar(255) collate utf8_czech_ci NOT NULL,
39 `HostList` int(11) NOT NULL,
40 PRIMARY KEY (`Id`)
41) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ;
42
43--
44-- Vypisuji data pro tabulku `Area`
45--
46
47INSERT INTO `Area` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `NetworkIPAddress`, `IPAddressMask`, `DNSPrimary`, `DNSSecondary`, `DHCP`, `Domain`, `Workgroup`, `WINS`, `HostList`) VALUES
48(1, 4, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Bytovky dolní konec', '192.168.12.0', '255.255.255.0', '192.168.0.22', '46.33.1.2', '192.168.12.1', 'freenet.cz', 'FREENET', '192.168.0.23', 0),
49(2, 3, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Centrum Komořany', '192.168.10.0', '255.255.255.0', '192.168.0.22', '', '192.168.10.1', 'centrum.freenet.cz', 'CENTRUM', '192.168.0.23', 0),
50(3, 4, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Serverovna', '192.168.0.0', '255.255.255.0', '192.168.0.22', '44.55.22.34', '19ě.168.0.1', 'freenet.cz', 'FREENET', '192.168.0.23', 0),
51(4, 4, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Kůlna', '10.198.0.0', '255.255.0.0', '192.168.0.1', '129.168.0.22', '10.198.0.1', 'kulna.freenet.cz', 'KULNA', '192.168.0.23', 0),
52(5, 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-09 14:02:11', '2008-10-13 07:59:09', 'ss', 'ss', 'ss', '', '', '', '', '', '', 0),
53(6, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-09 14:04:59', NULL, 'kk', '', '', '', '', '', '', '', '', 0),
54(7, 2, 0, '2008-10-09 14:09:48', NULL, '2008-10-09 14:09:48', NULL, 'kk', 'sss', '', '', '', '', '', '', '', 0),
55(8, 2, 5, '2008-10-09 14:43:13', NULL, '2008-10-09 14:43:13', '2008-10-13 07:56:32', 'Ahoj', 'sss', '', '', '', '', '', '', '', 0),
56(9, 5, 5, '2008-10-19 20:00:47', NULL, '2008-10-19 20:00:47', NULL, 'Czfree', '10.0.0.0', '255.0.0.0', '', '', '', 'czf', 'czfree', '', 0);
57
58-- --------------------------------------------------------
59
60--
61-- Struktura tabulky `Asset`
62--
63
64CREATE TABLE IF NOT EXISTS `Asset` (
65 `Id` int(11) NOT NULL auto_increment,
66 `ItemId` int(11) NOT NULL,
67 `Author` int(11) NOT NULL,
68 `ValidTimeFrom` datetime default NULL,
69 `ValidTimeTo` datetime default NULL,
70 `CreationTime` datetime default NULL,
71 `DeletionTime` datetime default NULL,
72 `Name` varchar(255) collate utf8_czech_ci NOT NULL,
73 `TimeEnlistment` datetime NOT NULL,
74 `TimeElimination` datetime NOT NULL,
75 `Price` float NOT NULL,
76 `State` int(11) NOT NULL,
77 `SerialNumber` varchar(255) collate utf8_czech_ci NOT NULL,
78 `PurcheasedFrom` int(11) NOT NULL,
79 PRIMARY KEY (`Id`)
80) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=17 ;
81
82--
83-- Vypisuji data pro tabulku `Asset`
84--
85
86INSERT INTO `Asset` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `TimeEnlistment`, `TimeElimination`, `Price`, `State`, `SerialNumber`, `PurcheasedFrom`) VALUES
87(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Ovislink WL-1120AP', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 563, 2, 'WL1120AP111353', 2),
88(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Routerboard RB-433', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3200, 1, 'RB433-3366264', 9),
89(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Ovislink WL-5460AP', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 800, 3, 'WL5460A-4372-333362', 9),
90(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'StraightCore WRT-312', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1110, 0, 'SC-WRT312-112', 7),
91(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'UTP kabel 100 m', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 600, 2, '', 7),
92(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Anténa UNIMAX 12 dBi 2,4 GHz', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 600, 2, '4234234234', 7),
93(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'UTP kabel Belden CAT-5 305 m ', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1766, 1, '', 9),
94(8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Paměť DDR2 2 GB 800 MHz', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 734, 2, 'DDR2422622a', 9),
95(9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Všesměrová anténa Omni 10 dBi', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1043, 2, 'OMNI123533', 9),
96(10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Notebook Asus EEE PC 901', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 6232, 2, 'ASUSEEE901-2414aa53', 9),
97(11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '10x UTP konektory drát', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 30, 1, '', 9),
98(12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Edimax gigabit switch 8-port', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 750, 2, 'EDW8-423423-333', 9),
99(13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'VoIP adaptér Zyxel VO-112', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1342, 2, 'ZXS422Z33', 9),
100(14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'IP kamera Vivotek IP-224', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3744, 2, 'VOWW623335', 9),
101(15, 9, 5, '2008-10-14 07:20:25', NULL, '2008-10-14 07:20:25', '2008-10-16 12:24:44', 'Všesměrová anténa Omni 10 dBi', '2001-01-01 00:00:00', '2066-01-01 00:00:00', 1043, 2, 'OMNI123533', 9),
102(16, 9, 5, '2008-10-16 12:24:44', NULL, '2008-10-16 12:24:44', NULL, 'Všesměrová anténa Omni 10 dBi', '2001-01-01 00:00:00', '2066-01-01 00:00:00', 1050, 2, 'OMNI123533', 9);
103
104-- --------------------------------------------------------
105
106--
107-- Struktura tabulky `BankAccount`
108--
109
110CREATE TABLE IF NOT EXISTS `BankAccount` (
111 `Id` int(11) NOT NULL auto_increment,
112 `ItemId` int(11) NOT NULL,
113 `Author` int(11) NOT NULL,
114 `ValidTimeFrom` datetime default NULL,
115 `ValidTimeTo` datetime default NULL,
116 `CreationTime` datetime default NULL,
117 `DeletionTime` datetime default NULL,
118 `Name` varchar(255) collate utf8_czech_ci NOT NULL,
119 `BankName` varchar(255) collate utf8_czech_ci NOT NULL,
120 `Number` varchar(255) collate utf8_czech_ci NOT NULL,
121 `BankCode` varchar(255) collate utf8_czech_ci NOT NULL,
122 `Type` int(11) NOT NULL,
123 `User` int(11) NOT NULL,
124 PRIMARY KEY (`Id`)
125) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ;
126
127--
128-- Vypisuji data pro tabulku `BankAccount`
129--
130
131INSERT INTO `BankAccount` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `BankName`, `Number`, `BankCode`, `Type`, `User`) VALUES
132(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Hlavní účet', 'Poštovní spořitelna', '22653446', '0200', 1, 1),
133(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Vedlejší účet', 'Komerční banka', '5543332', '0400', 2, 2),
134(3, 3, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Pomocný - vedení zdarma', 'Mbank', '24522266', '0156', 1, 2);
135
136-- --------------------------------------------------------
137
138--
139-- Struktura tabulky `CableTV`
140--
141
142CREATE TABLE IF NOT EXISTS `CableTV` (
143 `Id` int(11) NOT NULL auto_increment,
144 `Name` varchar(16) character set utf8 collate utf8_czech_ci NOT NULL,
145 `Frequency` int(11) NOT NULL default '0',
146 `Norm` varchar(8) character set utf8 collate utf8_czech_ci NOT NULL,
147 `Homepage` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL,
148 `Language` varchar(32) character set utf8 collate utf8_czech_ci NOT NULL,
149 `ShortName` varchar(16) character set utf8 collate utf8_czech_ci NOT NULL,
150 `ItemId` int(11) NOT NULL,
151 `Author` int(11) NOT NULL,
152 `ValidTimeFrom` datetime default NULL,
153 `ValidTimeTo` datetime default NULL,
154 `CreationTime` datetime default NULL,
155 `DeletionTime` datetime default NULL,
156 PRIMARY KEY (`Id`)
157) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=25 ;
158
159--
160-- Vypisuji data pro tabulku `CableTV`
161--
162
163INSERT INTO `CableTV` (`Id`, `Name`, `Frequency`, `Norm`, `Homepage`, `Language`, `ShortName`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`) VALUES
164(1, 'STV 1', 49218, 'pal-bg', 'http://www.stv.sk/', 'slovensky', 'stv1', 1, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
165(2, 'Galaxie Sport', 230687, 'pal-bg', 'http://www.galaxie-sport.cz/', 'česky', 'galaxia_sport', 2, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
166(3, 'STV 2', 76650, 'pal-bg', 'http://www.stv.sk/', 'slovensky', 'stv2', 3, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
167(4, 'TVN', 150937, 'pal-bg', 'http://tvn.pl/', 'polsky', 'tvn', 4, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
168(5, 'CNN', 158718, 'pal-bg', 'http://www.cnn.com/', 'anglicky', 'cnn', 5, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
169(6, 'Nova', 175381, 'pal-dk', 'http://www.nova.cz/', 'česky', 'nova', 6, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
170(7, 'Prima', 190781, 'pal-dk', 'http://www.iprima.cz/', 'česky', 'prima', 7, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
171(8, 'JOJ', 198718, 'pal-bg', 'http://www.joj.sk/', 'slovensky', 'joj', 8, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
172(9, 'ČT2', 206937, 'pal-dk', 'http://www.ceskatelevize.cz/', 'česky', 'ct2', 9, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
173(10, 'Infokanál', 214843, 'pal-bg', '', 'česky', 'infokanal', 10, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
174(11, 'ČT1', 223125, 'pal-dk', 'http://www.ceskatelevize.cz/', 'česky', 'ct1', 11, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
175(12, 'Markíza', 58781, 'pal-bg', 'http://www.markiza.sk/', 'slovenky', 'markiza', 12, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
176(13, 'Discovery', 237781, 'pal-bg', 'http://www.discoverychannel.cz/', 'česky', 'discovery', 13, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
177(14, 'Eurosport', 470781, 'pal-bg', 'http://www.eurosport.cz/', 'česky', 'eurosport', 14, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
178(15, 'DSF', 486718, 'pal-bg', 'http://www.dsf.de/', 'německy', 'dsf', 15, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
179(16, 'VIVA 1', 502718, 'pal-bg', 'http://www.viva.tv/', 'německy', 'viva1', 16, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
180(17, 'VIVA 2', 518718, 'pal-bg', 'http://www.viva.tv/', 'německy', 'viva2', 17, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
181(18, 'MTV', 534718, 'pal-bg', 'http://www.mtv.tv/', 'německy', 'mtv', 18, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
182(19, 'ZDF', 550718, 'pal-bg', 'http://www.zdf.de/', 'německy', 'zdf', 19, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
183(20, 'Noe', 244781, 'pal-bg', 'http://www.tvnoe.cz/', 'česky', 'noe', 20, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
184(21, 'RTL', 166718, 'pal-bg', 'http://www.rtl.de/', 'německy', 'rtl', 21, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
185(22, 'NOVA Cinema', 252250, 'pal-bg', 'http://novacinema.nova.cz/', 'česky', 'nova_cinema', 22, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
186(23, 'ČT 24', 273250, 'pal-bg', 'http://www.ct24.cz/', 'česky', 'ct24', 23, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
187(24, 'ČT 4 Sport', 280250, 'pal-bg', 'http://www.ct24.cz/sport/', 'česky', 'ct4sport', 24, 5, NULL, NULL, '2008-10-21 16:05:26', NULL);
188
189-- --------------------------------------------------------
190
191--
192-- Struktura tabulky `dd`
193--
194
195CREATE 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--
214-- Struktura tabulky `FinanceTransaction`
215--
216
217CREATE TABLE IF NOT EXISTS `FinanceTransaction` (
218 `Id` int(11) NOT NULL auto_increment,
219 `ItemId` int(11) NOT NULL,
220 `Author` int(11) NOT NULL,
221 `ValidTimeFrom` datetime default NULL,
222 `ValidTimeTo` datetime default NULL,
223 `CreationTime` datetime default NULL,
224 `DeletionTime` datetime default NULL,
225 `Description` varchar(255) collate utf8_czech_ci NOT NULL,
226 `Amount` float NOT NULL,
227 `SourceSubject` int(11) NOT NULL,
228 `TargetSubject` int(11) NOT NULL,
229 `Time` datetime NOT NULL,
230 `Type` int(11) NOT NULL,
231 `InsertedByUser` int(11) NOT NULL,
232 `Document` int(11) NOT NULL,
233 PRIMARY KEY (`Id`)
234) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=32 ;
235
236--
237-- Vypisuji data pro tabulku `FinanceTransaction`
238--
239
240INSERT INTO `FinanceTransaction` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Description`, `Amount`, `SourceSubject`, `TargetSubject`, `Time`, `Type`, `InsertedByUser`, `Document`) VALUES
241(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 2 Mbit 2008/05', 360, 2, 11, '0000-00-00 00:00:00', 0, 1, 0),
242(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Zřízení přípojky', 4300, 10, 11, '0000-00-00 00:00:00', 1, 11, 0),
243(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 8 Mbit 2008/05', 750, 8, 11, '0000-00-00 00:00:00', 0, 11, 0),
244(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Vrácení přeplatku', 231, 11, 8, '0000-00-00 00:00:00', 0, 11, 0),
245(31, 2, 5, '2008-10-14 09:20:19', NULL, '2008-10-14 09:20:19', NULL, 'Zřízení přípojky', 4300, 10, 11, '1900-01-01 00:00:00', 1, 11, 4),
246(30, 2, 5, '2008-10-14 09:17:42', NULL, '2008-10-14 09:17:42', NULL, 'Zřízení přípojky', 4300, 10, 11, '1900-01-01 00:00:00', 1, 11, 0),
247(29, 2, 5, '2008-10-14 09:16:57', NULL, '2008-10-14 09:16:57', NULL, 'Zřízení přípojky', 4300, 10, 11, '1900-01-01 00:00:00', 1, 11, 0),
248(28, 3, 5, '2008-10-14 09:16:34', NULL, '2008-10-14 09:16:34', NULL, 'Internet 8 Mbit 2008/05', 750, 8, 11, '1900-01-01 00:00:00', 0, 11, 3),
249(27, 4, 5, '2008-10-14 09:16:00', NULL, '2008-10-14 09:16:00', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 2),
250(26, 4, 5, '2008-10-14 09:07:57', NULL, '2008-10-14 09:07:57', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 0),
251(25, 4, 5, '2008-10-14 09:05:45', NULL, '2008-10-14 09:05:45', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 0),
252(24, 4, 5, '2008-10-14 09:03:32', NULL, '2008-10-14 09:03:32', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 1),
253(23, 4, 5, '2008-10-14 09:02:31', NULL, '2008-10-14 09:02:31', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 0),
254(22, 4, 5, '2008-10-14 09:01:39', NULL, '2008-10-14 09:01:39', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 0);
255
256-- --------------------------------------------------------
257
258--
259-- Struktura tabulky `Host`
260--
261
262CREATE TABLE IF NOT EXISTS `Host` (
263 `Id` int(11) NOT NULL auto_increment,
264 `ItemId` int(11) NOT NULL,
265 `Author` int(11) NOT NULL,
266 `ValidTimeFrom` datetime default NULL,
267 `ValidTimeTo` datetime default NULL,
268 `CreationTime` datetime default NULL,
269 `DeletionTime` datetime default NULL,
270 `DomainName` varchar(225) character set latin1 NOT NULL,
271 `NetBIOSName` varchar(255) character set latin1 NOT NULL,
272 `LocalIPAddress` varchar(255) character set latin1 NOT NULL,
273 `PublicIPAddress` varchar(255) character set latin1 NOT NULL,
274 `LastOnlineDate` date NOT NULL,
275 `Type` int(11) NOT NULL,
276 `Interface` int(11) NOT NULL,
277 `ParentHost` int(11) NOT NULL,
278 `Member` int(11) NOT NULL,
279 `Area` int(11) NOT NULL,
280 `SubHostList` int(11) NOT NULL,
281 PRIMARY KEY (`Id`)
282) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=15 ;
283
284--
285-- Vypisuji data pro tabulku `Host`
286--
287
288INSERT INTO `Host` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `DomainName`, `NetBIOSName`, `LocalIPAddress`, `PublicIPAddress`, `LastOnlineDate`, `Type`, `Interface`, `ParentHost`, `Member`, `Area`, `SubHostList`) VALUES
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),
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),
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),
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),
293(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'muhehe', 'MUHEHE', '192.168.0.4', '', '0000-00-00', 1, 0, 1, 1, 2, 0),
294(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'jonny', 'JONNY', '192.168.0.6', '', '0000-00-00', 1, 0, 1, 1, 1, 0),
295(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-19 20:01:24', 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '0000-00-00', 6, 0, 0, 0, 0, 0),
296(8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'www', 'WWW', '192.168.0.7', '34.22.1.4', '0000-00-00', 5, 0, 0, 0, 0, 0),
297(9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'peklo', 'PEKLO', '192.168.66.66', '', '0000-00-00', 7, 0, 4, 2, 0, 0),
298(10, 1, 5, '2008-10-13 13:52:04', NULL, '2008-10-13 13:52:04', NULL, 'george', 'GEORGE', '192.168.0.23', '', '1900-01-01', 1, 0, 4, 1, 4, 0),
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),
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),
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);
303
304-- --------------------------------------------------------
305
306--
307-- Struktura tabulky `Interface`
308--
309
310CREATE TABLE IF NOT EXISTS `Interface` (
311 `Id` int(11) NOT NULL auto_increment,
312 `ItemId` int(11) NOT NULL,
313 `Author` int(11) NOT NULL,
314 `ValidTimeFrom` datetime default NULL,
315 `ValidTimeTo` datetime default NULL,
316 `CreationTime` datetime default NULL,
317 `DeletionTime` datetime default NULL,
318 `Name` varchar(255) collate utf8_czech_ci NOT NULL,
319 `Type` int(11) NOT NULL,
320 `Area` int(11) NOT NULL,
321 `Host` int(11) NOT NULL,
322 `MAC` varchar(255) collate utf8_czech_ci NOT NULL,
323 `ParentHost` int(11) NOT NULL,
324 PRIMARY KEY (`Id`)
325) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=9 ;
326
327--
328-- Vypisuji data pro tabulku `Interface`
329--
330
331INSERT INTO `Interface` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `Type`, `Area`, `Host`, `MAC`, `ParentHost`) VALUES
332(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-19 19:13:18', 'Kabel', 2, 0, 1, '00:00:00:00:00:00', 0),
333(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-19 19:13:33', 'eth0', 3, 0, 3, 'A5:00:00:11:CD:2F', 0),
334(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Bezdrát', 0, 0, 5, '00:00:00:A5:53:26', 0),
335(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-19 20:07:04', 'eth0', 2, 0, 6, '45:00:12:54:FE:C2', 0),
336(5, 1, 5, '2008-10-19 19:13:18', NULL, '2008-10-19 19:13:18', '2008-10-19 19:13:25', 'Kabel', 2, 0, 1, '00:00:00:00:00:00', 1),
337(6, 1, 5, '2008-10-19 19:13:25', NULL, '2008-10-19 19:13:25', NULL, 'Kabel', 2, 0, 1, '00:00:00:00:00:00', 2),
338(7, 2, 5, '2008-10-19 19:13:33', NULL, '2008-10-19 19:13:33', NULL, 'eth0', 3, 0, 3, 'A5:00:00:11:CD:2F', 8),
339(8, 4, 5, '2008-10-19 20:07:04', NULL, '2008-10-19 20:07:04', NULL, 'eth0', 2, 0, 6, '45:00:12:54:FE:C2', 4);
340
341-- --------------------------------------------------------
342
343--
344-- Struktura tabulky `Member`
345--
346
347CREATE TABLE IF NOT EXISTS `Member` (
348 `Id` int(11) NOT NULL auto_increment,
349 `ItemId` int(11) NOT NULL,
350 `Author` int(11) NOT NULL,
351 `ValidTimeFrom` datetime NOT NULL,
352 `ValidTimeTo` datetime NOT NULL,
353 `CreationTime` datetime NOT NULL,
354 `DeletionTime` datetime NOT NULL,
355 `Subject` int(11) NOT NULL,
356 `ResponsibleUser` int(11) NOT NULL,
357 `FamilyMemberCount` int(11) NOT NULL,
358 `MembershipDate` date NOT NULL,
359 `MemberState` int(11) NOT NULL,
360 `HostList` int(11) NOT NULL,
361 `Tariff` int(11) NOT NULL,
362 `UserList` int(11) NOT NULL,
363 `GPS` int(11) NOT NULL,
364 PRIMARY KEY (`Id`)
365) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=37 ;
366
367--
368-- Vypisuji data pro tabulku `Member`
369--
370
371INSERT INTO `Member` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Subject`, `ResponsibleUser`, `FamilyMemberCount`, `MembershipDate`, `MemberState`, `HostList`, `Tariff`, `UserList`, `GPS`) VALUES
372(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-21 10:11:56', 2, 1, 3, '0000-00-00', 2, 0, 3, 0, 0),
373(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-21 10:13:08', 3, 6, 2, '0000-00-00', 2, 0, 4, 0, 0),
374(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-21 10:18:03', 7, 8, 0, '0000-00-00', 2, 0, 2, 0, 0),
375(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-21 10:20:38', 8, 11, 0, '0000-00-00', 2, 0, 3, 0, 0),
376(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 10, 1, 2, '0000-00-00', 1, 0, 3, 0, 0),
377(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 12, 12, 1, '0000-00-00', 3, 0, 1, 0, 0),
378(7, 3, 5, '2008-10-21 10:18:03', '0000-00-00 00:00:00', '2008-10-21 10:18:03', '0000-00-00 00:00:00', 7, 8, 0, '1900-01-01', 2, 0, 2, 0, 0),
379(8, 4, 5, '2008-10-21 10:20:38', '0000-00-00 00:00:00', '2008-10-21 10:20:38', '2008-10-21 10:21:01', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 3),
380(9, 4, 5, '2008-10-21 10:21:01', '0000-00-00 00:00:00', '2008-10-21 10:21:01', '2008-10-21 10:22:36', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 4),
381(10, 4, 5, '2008-10-21 10:22:36', '0000-00-00 00:00:00', '2008-10-21 10:22:36', '2008-10-21 10:30:03', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 5),
382(11, 4, 5, '2008-10-21 10:30:03', '0000-00-00 00:00:00', '2008-10-21 10:30:03', '2008-10-21 10:35:47', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 6),
383(12, 4, 5, '2008-10-21 10:35:47', '0000-00-00 00:00:00', '2008-10-21 10:35:47', '2008-10-21 10:36:21', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 7),
384(13, 4, 5, '2008-10-21 10:36:21', '0000-00-00 00:00:00', '2008-10-21 10:36:21', '2008-10-21 10:36:36', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 8),
385(14, 4, 5, '2008-10-21 10:36:36', '0000-00-00 00:00:00', '2008-10-21 10:36:36', '2008-10-21 10:38:25', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 9),
386(15, 4, 5, '2008-10-21 10:38:25', '0000-00-00 00:00:00', '2008-10-21 10:38:25', '2008-10-21 10:39:52', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 10),
387(16, 4, 5, '2008-10-21 10:39:52', '0000-00-00 00:00:00', '2008-10-21 10:39:52', '2008-10-21 10:39:57', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 11),
388(17, 4, 5, '2008-10-21 10:39:57', '0000-00-00 00:00:00', '2008-10-21 10:39:57', '2008-10-21 11:40:16', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 12),
389(18, 4, 5, '2008-10-21 11:40:16', '0000-00-00 00:00:00', '2008-10-21 11:40:16', '2008-10-21 11:41:33', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 13),
390(19, 4, 5, '2008-10-21 11:41:33', '0000-00-00 00:00:00', '2008-10-21 11:41:33', '2008-10-21 11:41:42', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 14),
391(20, 4, 5, '2008-10-21 11:41:42', '0000-00-00 00:00:00', '2008-10-21 11:41:42', '2008-10-21 11:41:50', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 15),
392(21, 4, 5, '2008-10-21 11:41:50', '0000-00-00 00:00:00', '2008-10-21 11:41:50', '2008-10-21 11:41:54', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 16),
393(22, 4, 5, '2008-10-21 11:41:54', '0000-00-00 00:00:00', '2008-10-21 11:41:54', '2008-10-21 11:42:30', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 17),
394(23, 4, 5, '2008-10-21 11:42:30', '0000-00-00 00:00:00', '2008-10-21 11:42:30', '2008-10-21 11:42:36', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 18),
395(24, 4, 5, '2008-10-21 11:42:36', '0000-00-00 00:00:00', '2008-10-21 11:42:36', '2008-10-21 11:42:41', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 19),
396(25, 4, 5, '2008-10-21 11:42:41', '0000-00-00 00:00:00', '2008-10-21 11:42:41', '2008-10-21 11:47:30', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 20),
397(26, 4, 5, '2008-10-21 11:47:30', '0000-00-00 00:00:00', '2008-10-21 11:47:30', '2008-10-21 11:47:39', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 21),
398(27, 4, 5, '2008-10-21 11:47:39', '0000-00-00 00:00:00', '2008-10-21 11:47:39', '2008-10-21 11:49:23', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 22),
399(28, 4, 5, '2008-10-21 11:49:23', '0000-00-00 00:00:00', '2008-10-21 11:49:23', '2008-10-21 11:53:36', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 23),
400(29, 4, 5, '2008-10-21 11:53:36', '0000-00-00 00:00:00', '2008-10-21 11:53:36', '2008-10-21 11:53:42', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 24),
401(30, 4, 5, '2008-10-21 11:53:42', '0000-00-00 00:00:00', '2008-10-21 11:53:42', '2008-10-21 11:56:52', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 25),
402(31, 4, 5, '2008-10-21 11:56:52', '0000-00-00 00:00:00', '2008-10-21 11:56:52', '2008-10-21 12:04:01', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 26),
403(32, 4, 5, '2008-10-21 12:04:01', '0000-00-00 00:00:00', '2008-10-21 12:04:01', '2008-10-21 12:05:49', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 27),
404(33, 4, 5, '2008-10-21 12:05:49', '0000-00-00 00:00:00', '2008-10-21 12:05:49', '2008-10-21 12:07:48', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 28),
405(34, 4, 5, '2008-10-21 12:07:48', '0000-00-00 00:00:00', '2008-10-21 12:07:48', '0000-00-00 00:00:00', 8, 11, 6, '2000-01-01', 2, 0, 3, 0, 29),
406(35, 7, 28, '2008-10-21 15:53:47', '0000-00-00 00:00:00', '2008-10-21 15:53:47', '0000-00-00 00:00:00', 15, 1, 0, '1900-01-01', 2, 0, 2, 0, 30),
407(36, 8, 28, '2008-10-21 15:54:04', '0000-00-00 00:00:00', '2008-10-21 15:54:04', '0000-00-00 00:00:00', 0, 0, 0, '0000-00-00', 0, 0, 0, 0, 31);
408
409-- --------------------------------------------------------
410
411--
412-- Struktura tabulky `MemberReport`
413--
414
415CREATE TABLE IF NOT EXISTS `MemberReport` (
416 `Id` int(11) NOT NULL auto_increment,
417 `ItemId` int(11) NOT NULL,
418 `Author` int(11) NOT NULL,
419 `ValidTimeFrom` datetime NOT NULL,
420 `ValidTimeTo` datetime NOT NULL,
421 `CreationTime` datetime NOT NULL,
422 `DeletionTime` datetime NOT NULL,
423 `Member` int(11) NOT NULL,
424 `Text` varchar(255) collate utf8_czech_ci NOT NULL,
425 `Date` date NOT NULL,
426 `Type` int(11) NOT NULL,
427 `Creator` int(11) NOT NULL,
428 PRIMARY KEY (`Id`)
429) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=17 ;
430
431--
432-- Vypisuji data pro tabulku `MemberReport`
433--
434
435INSERT INTO `MemberReport` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Member`, `Text`, `Date`, `Type`, `Creator`) VALUES
436(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'Nefunguje mi internet', '0000-00-00', 1, 11),
437(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'Poslední dobu jede internet nějak pomalu. Podívejte se na to prosím.', '0000-00-00', 1, 7),
438(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'Uživatel se přestěhoval mimo dosah sítě', '0000-00-00', 3, 11),
439(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 4, 'Během bouřky spadl strom na vedení a roztrhl jej. Bylo nutno natáhnout kabel znova.', '0000-00-00', 3, 2),
440(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, 'Nefunguje odesílání pošty.', '0000-00-00', 1, 10),
441(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'Změna tarifu na Internet 2 Mbit', '0000-00-00', 2, 11),
442(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, 'Chce se stát správcem tamního úseku.', '0000-00-00', 3, 11),
443(16, 1, 5, '2008-10-13 07:22:24', '0000-00-00 00:00:00', '2008-10-13 07:22:24', '0000-00-00 00:00:00', 1, 'Nefunguje mi internet', '2008-10-01', 1, 11),
444(15, 1, 5, '2008-10-13 07:20:29', '0000-00-00 00:00:00', '2008-10-13 07:20:29', '0000-00-00 00:00:00', 1, 'Nefunguje mi internet, opravte to prosím', '1900-01-01', 0, 11);
445
446-- --------------------------------------------------------
447
448--
449-- Struktura tabulky `NewsGroup`
450--
451
452CREATE TABLE IF NOT EXISTS `NewsGroup` (
453 `Id` int(11) NOT NULL auto_increment,
454 `ItemId` int(11) NOT NULL,
455 `Author` int(11) NOT NULL,
456 `ValidTimeFrom` datetime default NULL,
457 `ValidTimeTo` datetime default NULL,
458 `CreationTime` datetime default NULL,
459 `DeletionTime` datetime default NULL,
460 `Name` varchar(255) collate utf8_czech_ci NOT NULL,
461 `NewsItems` int(11) NOT NULL,
462 PRIMARY KEY (`Id`)
463) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=9 ;
464
465--
466-- Vypisuji data pro tabulku `NewsGroup`
467--
468
469INSERT INTO `NewsGroup` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `NewsItems`) VALUES
470(1, 1, 28, '2008-10-21 14:51:50', NULL, '2008-10-21 14:51:50', NULL, 'Různé informace', 0),
471(2, 2, 28, '2008-10-21 14:52:11', NULL, '2008-10-21 14:52:11', NULL, 'Bazar', 0),
472(3, 3, 28, '2008-10-21 14:52:25', NULL, '2008-10-21 14:52:25', NULL, 'Dění v obci', 0),
473(4, 4, 28, '2008-10-21 14:52:39', NULL, '2008-10-21 14:52:39', NULL, 'Správa sítě - oznámení', 0),
474(5, 5, 28, '2008-10-21 14:52:53', NULL, '2008-10-21 14:52:53', NULL, 'Správa sítě - změny zařízení', 0),
475(6, 6, 28, '2008-10-21 14:53:07', NULL, '2008-10-21 14:53:07', NULL, 'Multimediální archív', 0),
476(7, 7, 28, '2008-10-21 14:53:51', NULL, '2008-10-21 14:53:51', NULL, 'Správa sítě - výpadky', 0),
477(8, 8, 28, '2008-10-21 14:58:03', NULL, '2008-10-21 14:58:03', NULL, 'Sport', 0);
478
479-- --------------------------------------------------------
480
481--
482-- Struktura tabulky `NewsItem`
483--
484
485CREATE TABLE IF NOT EXISTS `NewsItem` (
486 `Id` int(11) NOT NULL auto_increment,
487 `ItemId` int(11) NOT NULL,
488 `Author` int(11) NOT NULL,
489 `ValidTimeFrom` datetime default NULL,
490 `ValidTimeTo` datetime default NULL,
491 `CreationTime` datetime default NULL,
492 `DeletionTime` datetime default NULL,
493 `Title` varchar(255) collate utf8_czech_ci NOT NULL,
494 `Content` varchar(255) collate utf8_czech_ci NOT NULL,
495 `NewsGroup` int(11) NOT NULL,
496 `Enclosure` int(11) NOT NULL,
497 PRIMARY KEY (`Id`)
498) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ;
499
500--
501-- Vypisuji data pro tabulku `NewsItem`
502--
503
504INSERT INTO `NewsItem` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Title`, `Content`, `NewsGroup`, `Enclosure`) VALUES
505(1, 1, 28, '2008-10-21 14:57:33', NULL, '2008-10-21 14:57:33', NULL, 'Ukončovačka', '!!!POZOR!!! V sobotu 25.10.2008 \\UKONČOVACÍ AKCE\\ v kasíně. Rum + kofola 25Kč Vodka + fanta 25Kč Vodka + džus 25Kč', 1, 0),
506(2, 2, 28, '2008-10-21 14:58:16', NULL, '2008-10-21 14:58:16', NULL, 'Fotbalové utkání', 'dsdada', 8, 0),
507(3, 3, 28, '2008-10-21 15:57:44', NULL, '2008-10-21 15:57:44', NULL, 'Čistota', 'Na 1100 speciálně školených pracovníků je připraveno přesvědčit Vás o významu slova čistota.', 1, 0),
508(4, 4, 28, '2008-10-21 15:58:31', NULL, '2008-10-21 15:58:31', NULL, 'Hokej v 15:00(19.10)', 'Zitra v nedeli 19.10 v 15:00 hod. si p pridte zahrat jako kazdy tyden hokej .Dnes(sobota)jsme si byli zapinkat.tak pridte at je nas co nejvic Aktualni vysledky poctu lidi na hristi najdete na web kamere .Sportu zdar a hokeji zvlast', 8, 0),
509(5, 5, 28, '2008-10-21 15:59:35', NULL, '2008-10-21 15:59:35', NULL, 'Apokalipsa', 'Přírodní živel zničil celou síť.', 7, 0);
510
511-- --------------------------------------------------------
512
513--
514-- Struktura tabulky `Permission`
515--
516
517CREATE TABLE IF NOT EXISTS `Permission` (
518 `Id` int(11) NOT NULL auto_increment,
519 `ItemId` int(11) NOT NULL,
520 `Author` int(11) NOT NULL,
521 `ValidTimeFrom` datetime default NULL,
522 `ValidTimeTo` datetime default NULL,
523 `CreationTime` datetime default NULL,
524 `DeletionTime` datetime default NULL,
525 `List` int(11) NOT NULL,
526 `Item` int(11) NOT NULL,
527 `Right` int(11) NOT NULL,
528 `PermissionGroup` int(11) NOT NULL,
529 PRIMARY KEY (`Id`)
530) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=49 ;
531
532--
533-- Vypisuji data pro tabulku `Permission`
534--
535
536INSERT INTO `Permission` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `List`, `Item`, `Right`, `PermissionGroup`) VALUES
537(1, 1, 5, '2008-10-13 10:45:28', NULL, '2008-10-13 10:45:28', '2008-10-13 13:17:44', 1, 0, 0, 7),
538(2, 2, 5, '2008-10-13 10:47:10', NULL, '2008-10-13 10:47:10', NULL, 1, 0, 2, 2),
539(3, 3, 5, '2008-10-13 10:49:22', NULL, '2008-10-13 10:49:22', NULL, 2, 0, 2, 2),
540(4, 4, 5, '2008-10-13 11:08:44', NULL, '2008-10-13 11:08:44', NULL, 3, 0, 2, 2),
541(5, 5, 5, '2008-10-13 11:10:14', NULL, '2008-10-13 11:10:14', NULL, 4, 0, 2, 2),
542(6, 6, 0, '2008-10-13 12:43:44', NULL, '2008-10-13 12:43:44', '2008-10-13 13:17:41', 7, 0, 2, 2),
543(7, 7, 0, '2008-10-13 12:43:59', NULL, '2008-10-13 12:43:59', '2008-10-13 13:17:40', 7, 0, 2, 2),
544(8, 8, 0, '2008-10-13 12:45:14', NULL, '2008-10-13 12:45:14', '2008-10-13 13:17:38', 7, 0, 2, 2),
545(9, 9, 0, '2008-10-13 12:48:25', NULL, '2008-10-13 12:48:25', NULL, 7, 0, 2, 2),
546(10, 10, 0, '2008-10-13 12:50:52', NULL, '2008-10-13 12:50:52', '2008-10-13 13:17:35', 7, 0, 2, 2),
547(11, 11, 0, '2008-10-13 12:58:32', NULL, '2008-10-13 12:58:32', NULL, 8, 0, 2, 2),
548(12, 12, 5, '2008-10-13 13:00:34', NULL, '2008-10-13 13:00:34', NULL, 9, 0, 2, 2),
549(13, 9, 5, '2008-10-13 13:04:26', NULL, '2008-10-13 13:04:26', NULL, 7, 0, 2, 2),
550(14, 9, 5, '2008-10-13 13:19:17', NULL, '2008-10-13 13:19:17', '2008-10-13 13:19:27', 7, 0, 2, 2),
551(15, 13, 5, '2008-10-13 14:05:54', NULL, '2008-10-13 14:05:54', NULL, 8, 0, 1, 5),
552(16, 14, 5, '2008-10-13 14:06:21', NULL, '2008-10-13 14:06:21', NULL, 2, 0, 1, 5),
553(17, 15, 5, '2008-10-21 07:06:14', NULL, '2008-10-21 07:06:14', NULL, 1, 0, 2, 1),
554(18, 16, 5, '2008-10-21 08:10:57', NULL, '2008-10-21 08:10:57', NULL, 21, 0, 2, 1),
555(19, 17, 5, '2008-10-21 08:51:03', NULL, '2008-10-21 08:51:03', NULL, 7, 0, 0, 1),
556(20, 18, 5, '2008-10-21 12:44:55', NULL, '2008-10-21 12:44:55', '2008-10-21 13:14:45', 8, 0, 1, 1),
557(21, 19, 5, '2008-10-21 12:57:35', NULL, '2008-10-21 12:57:35', '2008-10-21 12:58:43', 3, 0, 0, 1),
558(22, 20, 5, '2008-10-21 12:57:54', NULL, '2008-10-21 12:57:54', '2008-10-21 12:58:23', 20, 0, 0, 1),
559(23, 21, 5, '2008-10-21 12:58:11', NULL, '2008-10-21 12:58:11', NULL, 14, 0, 2, 1),
560(24, 20, 5, '2008-10-21 12:58:23', NULL, '2008-10-21 12:58:23', '2008-10-21 13:11:11', 20, 0, 2, 1),
561(25, 19, 5, '2008-10-21 12:58:43', NULL, '2008-10-21 12:58:43', NULL, 3, 0, 2, 1),
562(26, 22, 5, '2008-10-21 12:58:54', NULL, '2008-10-21 12:58:54', NULL, 11, 0, 2, 1),
563(27, 23, 5, '2008-10-21 12:59:08', NULL, '2008-10-21 12:59:08', NULL, 19, 0, 2, 1),
564(28, 24, 5, '2008-10-21 12:59:15', NULL, '2008-10-21 12:59:15', NULL, 18, 0, 2, 1),
565(29, 20, 5, '2008-10-21 13:11:11', NULL, '2008-10-21 13:11:11', NULL, 20, 0, 1, 1),
566(30, 25, 5, '2008-10-21 13:14:20', NULL, '2008-10-21 13:14:20', NULL, 4, 0, 2, 1),
567(31, 18, 5, '2008-10-21 13:14:45', NULL, '2008-10-21 13:14:45', '2008-10-21 13:18:52', 8, 0, 0, 1),
568(32, 26, 5, '2008-10-21 13:18:17', NULL, '2008-10-21 13:18:17', '2008-10-21 13:18:39', 0, 0, 0, 1),
569(33, 26, 5, '2008-10-21 13:18:39', NULL, '2008-10-21 13:18:39', NULL, 5, 0, 1, 1),
570(34, 18, 5, '2008-10-21 13:18:52', NULL, '2008-10-21 13:18:52', NULL, 8, 0, 1, 1),
571(35, 27, 5, '2008-10-21 13:19:36', NULL, '2008-10-21 13:19:36', NULL, 13, 0, 2, 1),
572(36, 28, 5, '2008-10-21 13:48:35', NULL, '2008-10-21 13:48:35', NULL, 7, 0, 1, 5),
573(37, 29, 5, '2008-10-21 13:49:05', NULL, '2008-10-21 13:49:05', '2008-10-21 14:36:27', 21, 0, 1, 5),
574(38, 30, 5, '2008-10-21 13:49:48', NULL, '2008-10-21 13:49:48', NULL, 15, 0, 1, 1),
575(39, 29, 28, '2008-10-21 14:36:27', NULL, '2008-10-21 14:36:27', NULL, 21, 0, 0, 5),
576(40, 31, 28, '2008-10-21 14:45:36', NULL, '2008-10-21 14:45:36', NULL, 23, 0, 2, 1),
577(41, 32, 28, '2008-10-21 14:54:31', NULL, '2008-10-21 14:54:31', NULL, 22, 0, 2, 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);
585
586-- --------------------------------------------------------
587
588--
589-- Struktura tabulky `PermissionGroup`
590--
591
592CREATE TABLE IF NOT EXISTS `PermissionGroup` (
593 `Id` int(11) NOT NULL auto_increment,
594 `ItemId` int(11) NOT NULL,
595 `Author` int(11) NOT NULL,
596 `ValidTimeFrom` datetime default NULL,
597 `ValidTimeTo` datetime default NULL,
598 `CreationTime` datetime default NULL,
599 `DeletionTime` datetime default NULL,
600 `Name` varchar(255) collate utf8_czech_ci NOT NULL,
601 `PermissionList` int(11) NOT NULL,
602 `UserList` int(11) NOT NULL,
603 PRIMARY KEY (`Id`)
604) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;
605
606--
607-- Vypisuji data pro tabulku `PermissionGroup`
608--
609
610INSERT INTO `PermissionGroup` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `PermissionList`, `UserList`) VALUES
611(1, 1, 5, '2008-10-13 09:54:31', NULL, '2008-10-13 09:54:31', NULL, 'Administrátor', 0, 0),
612(2, 1, 5, '2008-10-13 09:55:09', NULL, '2008-10-13 09:55:09', NULL, 'Systémoví správci', 0, 0),
613(3, 2, 5, '2008-10-13 09:55:23', NULL, '2008-10-13 09:55:23', NULL, 'Správci sítě', 0, 0),
614(4, 3, 5, '2008-10-13 09:55:39', NULL, '2008-10-13 09:55:39', NULL, 'Klienti', 0, 0),
615(5, 3, 5, '2008-10-13 09:55:56', NULL, '2008-10-13 09:55:56', NULL, 'Zástupci subjektů', 0, 0),
616(6, 4, 5, '2008-10-13 09:56:13', NULL, '2008-10-13 09:56:13', NULL, 'Připojení uživatelé', 0, 0),
617(7, 5, 5, '2008-10-13 09:56:20', NULL, '2008-10-13 09:56:20', NULL, 'Ostatní', 0, 0);
618
619-- --------------------------------------------------------
620
621--
622-- Struktura tabulky `Subject`
623--
624
625CREATE TABLE IF NOT EXISTS `Subject` (
626 `Id` int(11) NOT NULL auto_increment,
627 `ItemId` int(11) NOT NULL,
628 `Author` int(11) NOT NULL,
629 `ValidTimeFrom` datetime default NULL,
630 `ValidTimeTo` datetime default NULL,
631 `CreationTime` datetime default NULL,
632 `DeletionTime` datetime default NULL,
633 `Name` varchar(255) collate utf8_czech_ci NOT NULL,
634 `AddressStreet` varchar(255) collate utf8_czech_ci NOT NULL,
635 `AddressTown` varchar(255) collate utf8_czech_ci NOT NULL,
636 `AddressZIP` varchar(255) collate utf8_czech_ci NOT NULL,
637 `IC` varchar(255) collate utf8_czech_ci NOT NULL,
638 `DIC` varchar(255) collate utf8_czech_ci NOT NULL,
639 `Notice` varchar(255) collate utf8_czech_ci NOT NULL,
640 `PurcheasedAsset` int(11) NOT NULL,
641 `UserList` int(11) NOT NULL,
642 `WWW` varchar(255) collate utf8_czech_ci NOT NULL,
643 `MemberList` int(11) NOT NULL,
644 PRIMARY KEY (`Id`)
645) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=22 ;
646
647--
648-- Vypisuji data pro tabulku `Subject`
649--
650
651INSERT INTO `Subject` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `AddressStreet`, `AddressTown`, `AddressZIP`, `IC`, `DIC`, `Notice`, `PurcheasedAsset`, `UserList`, `WWW`, `MemberList`) VALUES
652(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Ing. Karel Milosrdný', 'Na ústraní 302', 'Otrokovice', '45667', '', '', 'Dodavatel wifi techniky', 0, 0, '', 0),
653(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Poskytovatel', 'Těsná 23', 'Prachatice', '56678', '33445633', '', '', 0, 0, '', 0),
654(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Finanční úřad Brno', 'Brněnská 1', 'Brno', '44134', '45773325', 'CZ44337778', '', 0, 0, '', 0),
655(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'GTS Novera', 'U skládky 9', 'Kladno', '47353', '3216346365', '423432', 'Hlavní dodavatel internetu', 0, 0, 'http://www.gtsnovera.cz', 0),
656(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'České radiokomunikace', 'Na rozcestí 5', 'Ostrava', '12445', '23132312', 'CZ342342342', 'Záložní linka', 0, 0, '', 0),
657(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Lucie Dobrovolná', 'Čajkovského 3', 'Pardubice', '73322', '', '', 'Neplatí včas', 0, 0, '', 0),
658(8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Obecní úřad Nové Milošice', 'Nové Milošice 24', 'Nové Milošice', '44222', '31231312312', 'CZ31231231', '', 0, 0, '', 0),
659(9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SOFTCOM', 'Pod vodou 9', 'Praha', '42044', '2323324234234', 'CZ6565622', 'Prodej výpočetní techniky', 0, 0, 'http://www.softcom.cz/', 0),
660(10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Honza Procházka', 'Za bukem 3', 'Chvojkovice', '44332', '', '', '', 0, 0, '', 0),
661(11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Freenet s.r.o.', 'Bezdrátová 11', 'Nové síťovice', '434223', '43423423423', 'CZ42423423', 'Hlavní kontakt na tuto síť', 0, 0, '', 0),
662(12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Fantomas', 'Tajná 10', 'Pod vodou', '11223', '', '', '', 0, 0, '', 0),
663(13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0),
664(14, 13, 5, '2008-10-11 22:38:49', '0000-00-00 00:00:00', '2008-10-11 22:38:49', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, '', 0),
665(15, 13, 5, '2008-10-11 22:41:56', '0000-00-00 00:00:00', '2008-10-11 22:41:56', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, '', 0),
666(16, 13, 5, '2008-10-11 22:46:30', '0000-00-00 00:00:00', '2008-10-11 22:46:30', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0),
667(17, 13, 5, '2008-10-11 22:47:36', '0000-00-00 00:00:00', '2008-10-11 22:47:36', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0),
668(18, 13, 5, '2008-10-13 08:46:07', NULL, '2008-10-13 08:46:07', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0),
669(19, 14, 5, '2008-10-21 13:02:40', NULL, '2008-10-21 13:02:40', '2008-10-21 13:02:59', 'Alza', 'Pod vodou 12', 'Praha', '12012', '2312312', 'CZ34523423', '(please note if any errors come up you have not followed this guide properly also make sure your web server is on if you are running XAMPP start the top 2 \\APACHE\\ and \\MYSQL\\ tabs)', 0, 0, 'http://www.alza.cz/', 0),
670(20, 14, 5, '2008-10-21 13:02:59', NULL, '2008-10-21 13:02:59', NULL, 'Alza', 'Pod vodou 12', 'Praha', '12012', '2312312', 'CZ34523423', 'As the name of topic says i''m wondering will the ACE problems be fixed for windows (of any distro) users ? Because i didn''t see nothing that gives hope for the past few days .I know it is not a easy way to fix it but i have a strange feeling that for us a', 0, 0, 'http://www.alza.cz/', 0),
671(21, 15, 28, '2008-10-21 15:51:24', NULL, '2008-10-21 15:51:24', NULL, 'Kačer Skrblík', 'U trezoru', 'Kačerov', '123', '442342343', '55252345252', '', 0, 0, '', 0);
672
673-- --------------------------------------------------------
674
675--
676-- Struktura tabulky `SystemEnumerationState`
677--
678
679CREATE 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,
687 `Name` varchar(255) collate utf8_czech_ci 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
703CREATE 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
714INSERT 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
753CREATE 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
772INSERT 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
849CREATE 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
875INSERT 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
1063CREATE 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
1082INSERT 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
1382CREATE 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,
1392 PRIMARY KEY (`Id`)
1393) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ;
1394
1395--
1396-- Vypisuji data pro tabulku `SystemMenu`
1397--
1398
1399INSERT 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
1411CREATE 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
1433INSERT 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
1501CREATE 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
1520INSERT 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
1534CREATE 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
1556INSERT 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
1569CREATE 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
1591CREATE 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
1621INSERT 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
1662CREATE 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
1684INSERT 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 TracBrowser for help on using the repository browser.