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