jablonka.czprosek.czf

is

 Subversion Repositories:
[/] [trunk/] [demois.sql] - Blame information for rev 5

 

Line No. Rev Author Line
12simandl-- MySQL dump 10.11
2--
3-- Host: localhost Database: demois
4-- ------------------------------------------------------
5-- Server version 5.0.45
6 
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17 
18--
19-- Table structure for table `adresy`
20--
21 
22DROP TABLE IF EXISTS `adresy`;
23CREATE TABLE `adresy` (
24 `id` int(11) NOT NULL default '0',
25 `clen` int(11) NOT NULL default '0',
26 `mesto` tinytext NOT NULL,
27 `ulice` tinytext NOT NULL,
28 `cp` tinytext NOT NULL,
29 `psc` tinytext NOT NULL,
30 `byt` tinytext NOT NULL,
31 `komentar` text NOT NULL,
32 `sirka` tinytext,
33 `delka` tinytext,
34 `vyska` tinytext,
35 `otoceni` tinytext,
36 `naklon` tinytext,
37 `objekt` int(11) default NULL,
38 PRIMARY KEY (`id`)
39) ENGINE=MyISAM DEFAULT CHARSET=utf8;
40 
41--
42-- Dumping data for table `adresy`
43--
44 
45LOCK TABLES `adresy` WRITE;
46/*!40000 ALTER TABLE `adresy` DISABLE KEYS */;
47INSERT INTO `adresy` VALUES (1,1,'Praha','JabloneckĂĄ','410/46','19000','25','',NULL,NULL,NULL,NULL,NULL,NULL),(123,1,'UtĂ­n','UtĂ­n','33','','','',NULL,NULL,NULL,NULL,NULL,NULL),(125,0,'','','','','','','','','','','',0),(124,0,'','JabloneckĂĄ','714','','budnĂ­k','','','','','','',0);
48/*!40000 ALTER TABLE `adresy` ENABLE KEYS */;
49UNLOCK TABLES;
50 
51--
52-- Table structure for table `cleni`
53--
54 
55DROP TABLE IF EXISTS `cleni`;
56CREATE TABLE `cleni` (
57 `id` int(11) NOT NULL default '0',
58 `prezdivka` tinytext NOT NULL,
59 `jmeno` tinytext NOT NULL,
60 `prijmeni` tinytext NOT NULL,
61 `narozen` tinytext NOT NULL,
62 `domu` tinytext NOT NULL,
63 `mobil` tinytext NOT NULL,
64 `email` tinytext NOT NULL,
65 `icq` tinytext NOT NULL,
66 `komentar` text NOT NULL,
67 `active` tinyint(4) NOT NULL default '0',
68 `finance` tinyint(4) NOT NULL default '0',
69 `energy` tinyint(4) NOT NULL default '0',
70 `internet` tinyint(4) NOT NULL default '0',
71 `vs` tinytext,
72 PRIMARY KEY (`id`)
73) ENGINE=MyISAM DEFAULT CHARSET=utf8;
74 
75--
76-- Dumping data for table `cleni`
77--
78 
79LOCK TABLES `cleni` WRITE;
80/*!40000 ALTER TABLE `cleni` DISABLE KEYS */;
81INSERT INTO `cleni` VALUES (1,'Síma','Petr','Simandl','','','','simandl@nomail.cz','','pokusnÊ konto',1,1,2,1,'1033'),(0,'','jablonka.cz','','','','','info@jablonka.cz','','Toto je univerzålní uživatel zastupující o.s. jablonka.cz',1,0,0,0,'');
82/*!40000 ALTER TABLE `cleni` ENABLE KEYS */;
83UNLOCK TABLES;
84 
85--
86-- Table structure for table `dodavatele`
87--
88 
89DROP TABLE IF EXISTS `dodavatele`;
90CREATE TABLE `dodavatele` (
91 `id` int(11) NOT NULL default '0',
92 `nazev` tinytext NOT NULL,
93 `komentar` text,
94 PRIMARY KEY (`id`)
95) ENGINE=MyISAM DEFAULT CHARSET=utf8;
96 
97--
98-- Dumping data for table `dodavatele`
99--
100 
101LOCK TABLES `dodavatele` WRITE;
102/*!40000 ALTER TABLE `dodavatele` DISABLE KEYS */;
103INSERT INTO `dodavatele` VALUES (1,'Alzasoft',NULL),(2,'I4',NULL),(3,'OBI',NULL),(4,'InWIFI',NULL),(5,'KVElektro',NULL),(0,'???',NULL),(6,'Jiøí Hojer',NULL),(7,'anntena.cz',NULL),(8,'Compo','Våclavskå pasåž'),(9,'boxed.cz',NULL),(10,'Antenex',NULL),(11,'Mironet',NULL),(12,'ha-loo.ha-vel.cz',NULL),(13,'Lica',NULL),(14,'I4WIFI','nåstupce I4 a InWIFI'),(15,'OFA','ofacom.cz'),(16,'BelStewartNet','Bel Stewart Net, s.r.o.\nNa Bojiťti 2\n120 00 Praha 2'),(17,'RLC','RLC Praha a.s.\nVodnickå 335/31\n149 00 Praha 4'),(18,'Jirí Škoch - DAMP',NULL),(19,'ipmedia','www.ipmedia.cz'),(20,'gmshop','www.gmshop.cz');
104/*!40000 ALTER TABLE `dodavatele` ENABLE KEYS */;
105UNLOCK TABLES;
106 
107--
108-- Table structure for table `ekonto`
109--
110 
111DROP TABLE IF EXISTS `ekonto`;
112CREATE TABLE `ekonto` (
113 `value` text NOT NULL,
114 `id` int(11) NOT NULL default '-1',
115 `datum` date default NULL
116) ENGINE=MyISAM DEFAULT CHARSET=utf8;
117 
118--
119-- Dumping data for table `ekonto`
120--
121 
122LOCK TABLES `ekonto` WRITE;
123/*!40000 ALTER TABLE `ekonto` DISABLE KEYS */;
124/*!40000 ALTER TABLE `ekonto` ENABLE KEYS */;
125UNLOCK TABLES;
126 
127--
128-- Table structure for table `finance`
129--
130 
131DROP TABLE IF EXISTS `finance`;
132CREATE TABLE `finance` (
133 `id` int(11) NOT NULL default '0',
134 `clen` int(11) NOT NULL default '0',
135 `platba` int(11) NOT NULL default '0',
136 `hodnota` tinytext NOT NULL,
137 `datum` date NOT NULL default '0000-00-00',
138 `komentar` text NOT NULL,
139 `dodavatel` int(11) default '0',
140 `uctenka` int(11) default NULL,
141 `pokladna` int(11) default '0',
142 PRIMARY KEY (`id`)
143) ENGINE=MyISAM DEFAULT CHARSET=utf8;
144 
145--
146-- Dumping data for table `finance`
147--
148 
149LOCK TABLES `finance` WRITE;
150/*!40000 ALTER TABLE `finance` DISABLE KEYS */;
151/*!40000 ALTER TABLE `finance` ENABLE KEYS */;
152UNLOCK TABLES;
153 
154--
155-- Table structure for table `ipecka`
156--
157 
158DROP TABLE IF EXISTS `ipecka`;
159CREATE TABLE `ipecka` (
160 `id` int(11) NOT NULL default '0',
161 `clen` int(11) NOT NULL default '0',
162 `adresa` int(11) NOT NULL default '0',
163 `dns` tinytext NOT NULL,
164 `mac` tinytext NOT NULL,
165 `ip` tinytext NOT NULL,
166 `komentar` text NOT NULL,
167 PRIMARY KEY (`id`)
168) ENGINE=MyISAM DEFAULT CHARSET=utf8;
169 
170--
171-- Dumping data for table `ipecka`
172--
173 
174LOCK TABLES `ipecka` WRITE;
175/*!40000 ALTER TABLE `ipecka` DISABLE KEYS */;
176INSERT INTO `ipecka` VALUES (1,1,1,'sima','','10.33.6.10',''),(2,1,123,'utin','','10.33.6.11',''),(3,0,124,'jablonecka','','10.33.6.2','');
177/*!40000 ALTER TABLE `ipecka` ENABLE KEYS */;
178UNLOCK TABLES;
179 
180--
181-- Table structure for table `majetek`
182--
183 
184DROP TABLE IF EXISTS `majetek`;
185CREATE TABLE `majetek` (
186 `id` int(11) NOT NULL default '0',
187 `clen` int(11) default NULL,
188 `adresa` int(11) default NULL,
189 `zarizeni` int(11) default NULL,
190 `finance` int(11) default NULL,
191 `spotreba` double default NULL,
192 `soucast` int(11) default NULL,
193 `scislo` tinytext,
194 `komentar` text,
195 `mac` tinytext,
196 PRIMARY KEY (`id`)
197) ENGINE=MyISAM DEFAULT CHARSET=utf8;
198 
199--
200-- Dumping data for table `majetek`
201--
202 
203LOCK TABLES `majetek` WRITE;
204/*!40000 ALTER TABLE `majetek` DISABLE KEYS */;
205INSERT INTO `majetek` VALUES (2,0,124,7,0,0,0,'','',''),(1,0,0,1,0,50,0,'nevim','nejaky router se spotrebou 50W','');
206/*!40000 ALTER TABLE `majetek` ENABLE KEYS */;
207UNLOCK TABLES;
208 
209--
210-- Table structure for table `objekty`
211--
212 
213DROP TABLE IF EXISTS `objekty`;
214CREATE TABLE `objekty` (
215 `id` int(11) NOT NULL default '0',
216 `nazev` tinytext,
217 `definice` longtext,
218 `komentar` text,
219 PRIMARY KEY (`id`)
220) ENGINE=MyISAM DEFAULT CHARSET=utf8;
221 
222--
223-- Dumping data for table `objekty`
224--
225 
226LOCK TABLES `objekty` WRITE;
227/*!40000 ALTER TABLE `objekty` DISABLE KEYS */;
228INSERT INTO `objekty` VALUES (1,'panelak jablonecka','<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<kml xmlns=\"http://earth.google.com/kml/2.0\">\n<Document>\n<name>panelak</name>\n<description><![CDATA[Created with <a href=\"http://www.sketchup.com\">SketchUp Pro</a>]]></description>\n<DocumentSource>SketchUp</DocumentSource>\n<DocumentOrigin>\n <coordinates>\n 14.49530789565253,50.12418698362534,296.5980816807133\n </coordinates>\n</DocumentOrigin>\n<visibility>1</visibility>\n<LookAt>\n <heading>327.109</heading>\n <tilt>62.504</tilt>\n <latitude>50.1231533800244</latitude>\n <longitude>14.49746599195971</longitude>\n <range>547.7968641804115</range>\n</LookAt>\n <Folder>\n <name>Tour</name>\n <Folder>\n <name>Camera</name>\n <visibility>1</visibility>\n <LookAt>\n <heading>327.109</heading>\n <tilt>62.504</tilt>\n <latitude>50.1231533800244</latitude>\n <longitude>14.49746599195971</longitude>\n <range>547.7968641804115</range>\n </LookAt>\n </Folder>\n </Folder>\n <Style id=\"Edges\">\n <LineStyle>\n <color>ff000000</color>\n </LineStyle>\n </Style>\n <Style id=\"FrontColor\">\n <LineStyle>\n <color>ff000000</color>\n </LineStyle>\n <PolyStyle>\n <outline>0</outline>\n <fill>1</fill>\n <color>ffffffff</color>\n </PolyStyle>\n </Style>\n <Style id=\"BackColor\">\n <LineStyle>\n <color>ff000000</color>\n </LineStyle>\n <PolyStyle>\n <outline>0</outline>\n <fill>1</fill>\n <color>ffccb0ab</color>\n </PolyStyle>\n </Style>\n <Folder>\n <name>Model</name>\n <Placemark>\n <Style><IconStyle><Icon><href>root://icons/palette-3.png</href><x>160</x><y>160</y><w>32</w><h>32</h></Icon></IconStyle></Style>\n <name>Geometry</name>\n <styleUrl>#FrontColor</styleUrl>\n <GeometryCollection>\n <Polygon>\n <altitudeMode>absolute</altitudeMode>\n <outerBoundaryIs>\n <LinearRing>\n <coordinates>\n 14.49410417772403,50.12492104184106,296.5980816807133\n 14.49422705986362,50.12499391071253,296.5980816807133\n 14.49661586438945,50.12332887129011,296.5980816807133\n 14.49649298284888,50.12325600492746,296.5980816807133\n 14.49410417772403,50.12492104184106,296.5980816807133\n </coordinates>\n </LinearRing>\n </outerBoundaryIs>\n </Polygon>\n <Polygon>\n <altitudeMode>absolute</altitudeMode>\n <outerBoundaryIs>\n <LinearRing>\n <coordinates>\n 14.49422705986362,50.12499391071253,326.2880817109971\n 14.49410417772403,50.12492104184106,326.2880817109971\n 14.49649298284888,50.12325600492746,326.2880817109971\n 14.49661586438945,50.12332887129011,326.2880817109971\n 14.49422705986362,50.12499391071253,326.2880817109971\n </coordinates>\n </LinearRing>\n </outerBoundaryIs>\n </Polygon>\n <Polygon>\n <altitudeMode>absolute</altitudeMode>\n <outerBoundaryIs>\n <LinearRing>\n <coordinates>\n 14.49422705986362,50.12499391071253,296.5980816807133\n 14.49410417772403,50.12492104184106,296.5980816807133\n 14.49410417772403,50.12492104184106,326.2880817109971\n 14.49422705986362,50.12499391071253,326.2880817109971\n 14.49422705986362,50.12499391071253,296.5980816807133\n </coordinates>\n </LinearRing>\n </outerBoundaryIs>\n </Polygon>\n <Polygon>\n <altitudeMode>absolute</altitudeMode>\n <outerBoundaryIs>\n <LinearRing>\n <coordinates>\n 14.49661586438945,50.12332887129011,296.5980816807133\n 14.49422705986362,50.12499391071253,296.5980816807133\n 14.49422705986362,50.12499391071253,326.2880817109971\n 14.49661586438945,50.12332887129011,326.2880817109971\n 14.49661586438945,50.12332887129011,296.5980816807133\n </coordinates>\n </LinearRing>\n </outerBoundaryIs>\n </Polygon>\n <Polygon>\n <altitudeMode>absolute</altitudeMode>\n <outerBoundaryIs>\n <LinearRing>\n <coordinates>\n 14.49649298284888,50.12325600492746,296.5980816807133\n 14.49661586438945,50.12332887129011,296.5980816807133\n 14.49661586438945,50.12332887129011,326.2880817109971\n 14.49649298284888,50.12325600492746,326.2880817109971\n 14.49649298284888,50.12325600492746,296.5980816807133\n </coordinates>\n </LinearRing>\n </outerBoundaryIs>\n </Polygon>\n <Polygon>\n <altitudeMode>absolute</altitudeMode>\n <outerBoundaryIs>\n <LinearRing>\n <coordinates>\n 14.49410417772403,50.12492104184106,296.5980816807133\n 14.49649298284888,50.12325600492746,296.5980816807133\n 14.49649298284888,50.12325600492746,326.2880817109971\n 14.49410417772403,50.12492104184106,326.2880817109971\n 14.49410417772403,50.12492104184106,296.5980816807133\n </coordinates>\n </LinearRing>\n </outerBoundaryIs>\n </Polygon>\n </GeometryCollection>\n </Placemark>\n <Placemark>\n <Style><IconStyle><Icon><href>root://icons/palette-3.png</href><x>160</x><y>160</y><w>32</w><h>32</h></Icon></IconStyle></Style>\n <name>Geometry</name>\n <styleUrl>#Edges</styleUrl>\n <GeometryCollection>\n <LineString>\n <altitudeMode>absolute</altitudeMode>\n <coordinates>\n 14.49410417772403,50.12492104184106,296.5980816807133\n 14.49422705986362,50.12499391071253,296.5980816807133\n </coordinates>\n </LineString>\n <LineString>\n <altitudeMode>absolute</altitudeMode>\n <coordinates>\n 14.49422705986362,50.12499391071253,296.5980816807133\n 14.49661586438945,50.12332887129011,296.5980816807133\n </coordinates>\n </LineString>\n <LineString>\n <altitudeMode>absolute</altitudeMode>\n <coordinates>\n 14.49661586438945,50.12332887129011,296.5980816807133\n 14.49649298284888,50.12325600492746,296.5980816807133\n </coordinates>\n </LineString>\n <LineString>\n <altitudeMode>absolute</altitudeMode>\n <coordinates>\n 14.49649298284888,50.12325600492746,296.5980816807133\n 14.49410417772403,50.12492104184106,296.5980816807133\n </coordinates>\n </LineString>\n <LineString>\n <altitudeMode>absolute</altitudeMode>\n <coordinates>\n 14.49410417772403,50.12492104184106,326.2880817109971\n 14.49422705986362,50.12499391071253,326.2880817109971\n </coordinates>\n </LineString>\n <LineString>\n <altitudeMode>absolute</altitudeMode>\n <coordinates>\n 14.49422705986362,50.12499391071253,326.2880817109971\n 14.49661586438945,50.12332887129011,326.2880817109971\n </coordinates>\n </LineString>\n <LineString>\n <altitudeMode>absolute</altitudeMode>\n <coordinates>\n 14.49661586438945,50.12332887129011,326.2880817109971\n 14.49649298284888,50.12325600492746,326.2880817109971\n </coordinates>\n </LineString>\n <LineString>\n <altitudeMode>absolute</altitudeMode>\n <coordinates>\n 14.49649298284888,50.12325600492746,326.2880817109971\n 14.49410417772403,50.12492104184106,326.2880817109971\n </coordinates>\n </LineString>\n <LineString>\n <altitudeMode>absolute</altitudeMode>\n <coordinates>\n 14.49422705986362,50.12499391071253,296.5980816807133\n 14.49422705986362,50.12499391071253,326.2880817109971\n </coordinates>\n </LineString>\n <LineString>\n <altitudeMode>absolute</altitudeMode>\n <coordinates>\n 14.49410417772403,50.12492104184106,296.5980816807133\n 14.49410417772403,50.12492104184106,326.2880817109971\n </coordinates>\n </LineString>\n <LineString>\n <altitudeMode>absolute</altitudeMode>\n <coordinates>\n 14.49661586438945,50.12332887129011,296.5980816807133\n 14.49661586438945,50.12332887129011,326.2880817109971\n </coordinates>\n </LineString>\n <LineString>\n <altitudeMode>absolute</altitudeMode>\n <coordinates>\n 14.49649298284888,50.12325600492746,296.5980816807133\n 14.49649298284888,50.12325600492746,326.2880817109971\n </coordinates>\n </LineString>\n </GeometryCollection>\n </Placemark>\n </Folder>\n</Document>\n</kml>\n','Tohle jsem vytvoril pomoci sketchup a googlemap a byl to dost porod. Uvidime ale co jak bude nakonec pouzitelny. V podstate to sem davam jen proto aby tu neco bylo.');
229/*!40000 ALTER TABLE `objekty` ENABLE KEYS */;
230UNLOCK TABLES;
231 
232--
233-- Table structure for table `platby`
234--
235 
236DROP TABLE IF EXISTS `platby`;
237CREATE TABLE `platby` (
238 `id` int(11) NOT NULL default '0',
239 `nazev` tinytext NOT NULL,
240 `popis` text,
241 PRIMARY KEY (`id`)
242) ENGINE=MyISAM DEFAULT CHARSET=utf8;
243 
244--
245-- Dumping data for table `platby`
246--
247 
248LOCK TABLES `platby` WRITE;
249/*!40000 ALTER TABLE `platby` DISABLE KEYS */;
250INSERT INTO `platby` VALUES (1,'vstupní pøíspÏvek',''),(2,'èlenský pøíspÏvek',''),(3,'elektøina',''),(4,'domÊna',''),(5,'konektivita casablanca',''),(6,'konektivita upc',''),(7,'pøenos z pøedchozího roku','asi jen do doby kdy dodelam online prenosy'),(13,'konektivita connection','konektivita connection'),(9,'materiål','vše pro stavbu sítÏ'),(10,'ebanka poplatky','ebanka poplatky'),(11,'ebanka úroky','ebanka úroky'),(12,'dary','sponzorskÊ dary'),(14,'nåjem',NULL),(15,'vedení ú&#269;etnictví','vedení ú&#269;etnictví'),(16,'telefonni poplatky',NULL),(17,'osobní vklad',NULL),(18,'p&#345;enos do p&#345;íštího roku',NULL);
251/*!40000 ALTER TABLE `platby` ENABLE KEYS */;
252UNLOCK TABLES;
253 
254--
255-- Table structure for table `pokladny`
256--
257 
258DROP TABLE IF EXISTS `pokladny`;
259CREATE TABLE `pokladny` (
260 `id` int(11) NOT NULL default '0',
261 `nazev` tinytext NOT NULL,
262 `komentar` text,
263 PRIMARY KEY (`id`)
264) ENGINE=MyISAM DEFAULT CHARSET=utf8;
265 
266--
267-- Dumping data for table `pokladny`
268--
269 
270LOCK TABLES `pokladny` WRITE;
271/*!40000 ALTER TABLE `pokladny` DISABLE KEYS */;
272INSERT INTO `pokladny` VALUES (0,'???',NULL),(1,'simandl','Pokladna Petra Simandla'),(2,'sinda','Pokladna Petra Šindýlka'),(3,'eBanka','konto v eBance 2118436001/2400');
273/*!40000 ALTER TABLE `pokladny` ENABLE KEYS */;
274UNLOCK TABLES;
275 
276--
277-- Table structure for table `poplatky`
278--
279 
280DROP TABLE IF EXISTS `poplatky`;
281CREATE TABLE `poplatky` (
282 `id` tinyint(4) NOT NULL default '0',
283 `type` text NOT NULL
284) ENGINE=MyISAM DEFAULT CHARSET=utf8;
285 
286--
287-- Dumping data for table `poplatky`
288--
289 
290LOCK TABLES `poplatky` WRITE;
291/*!40000 ALTER TABLE `poplatky` DISABLE KEYS */;
292INSERT INTO `poplatky` VALUES (0,'internet'),(1,'elektrina'),(2,'opravy'),(3,'vstupni prispevek'),(4,'jine');
293/*!40000 ALTER TABLE `poplatky` ENABLE KEYS */;
294UNLOCK TABLES;
295 
296--
297-- Table structure for table `udalosti`
298--
299 
300DROP TABLE IF EXISTS `udalosti`;
301CREATE TABLE `udalosti` (
302 `id` int(11) NOT NULL default '0',
303 `nazev` tinytext NOT NULL,
304 `komentar` text,
305 PRIMARY KEY (`id`)
306) ENGINE=MyISAM DEFAULT CHARSET=utf8;
307 
308--
309-- Dumping data for table `udalosti`
310--
311 
312LOCK TABLES `udalosti` WRITE;
313/*!40000 ALTER TABLE `udalosti` DISABLE KEYS */;
314INSERT INTO `udalosti` VALUES (1,'podåní pøihlåšky',''),(2,'pøijetí do sdružení',''),(3,'pozastavení èlenství',''),(4,'ukonèení èlenství',''),(5,'zaèåtek napåjení switche',''),(6,'ukonèení napåjení switche',''),(7,'zahåjení odbÏru konektivity',''),(8,'ukonèení odbÏru konektivity',''),(9,'nåkup',NULL),(10,'prodej',NULL),(11,'porucha',NULL),(12,'reklamace',NULL),(13,'krådež',NULL),(14,'likvidace - vyhození/znièení',NULL),(15,'likvidace - rozebråní na díly',NULL),(16,'sestavení z dostupných dílÚ',NULL),(17,'zahåjení odbÏru elektøiny',NULL),(18,'ukonèení odbÏru elektøiny',NULL),(19,'umístÏní',NULL),(20,'zåpÚjèka',NULL),(21,'vråcení zåpÚjèky',NULL),(22,'pøipojení k síti',NULL),(23,'odpojení od sítÏ',NULL),(24,'zaèåtek napåjení routeru',NULL),(25,'ukonèení napåjení routeru',NULL),(26,'pøipojení voip',NULL),(27,'odpojení voip',NULL);
315/*!40000 ALTER TABLE `udalosti` ENABLE KEYS */;
316UNLOCK TABLES;
317 
318--
319-- Table structure for table `ukony`
320--
321 
322DROP TABLE IF EXISTS `ukony`;
323CREATE TABLE `ukony` (
324 `id` int(11) NOT NULL default '0',
325 `clen` int(11) NOT NULL default '0',
326 `udalost` int(11) NOT NULL default '0',
327 `predmet` int(11) NOT NULL default '0',
328 `datum` date NOT NULL default '0000-00-00',
329 `komentar` text NOT NULL,
330 `adresa` int(11) default NULL,
331 `finance` int(11) default NULL,
332 `majetek` int(11) default NULL,
333 PRIMARY KEY (`id`)
334) ENGINE=MyISAM DEFAULT CHARSET=utf8;
335 
336--
337-- Dumping data for table `ukony`
338--
339 
340LOCK TABLES `ukony` WRITE;
341/*!40000 ALTER TABLE `ukony` DISABLE KEYS */;
342INSERT INTO `ukony` VALUES (6,0,17,0,'2007-09-12','',124,0,1),(5,0,17,0,'2007-09-12','',124,0,2),(4,1,7,1,'2008-09-12','',1,0,0),(3,1,7,2,'2008-09-12','',1,0,0),(2,1,22,0,'2008-09-12','',1,0,0),(1,1,1,0,'2008-09-12','',1,0,0);
343/*!40000 ALTER TABLE `ukony` ENABLE KEYS */;
344UNLOCK TABLES;
345 
346--
347-- Table structure for table `zarizeni`
348--
349 
350DROP TABLE IF EXISTS `zarizeni`;
351CREATE TABLE `zarizeni` (
352 `id` int(11) NOT NULL default '0',
353 `nazev` tinytext NOT NULL,
354 `komentar` text,
355 PRIMARY KEY (`id`)
356) ENGINE=MyISAM DEFAULT CHARSET=utf8;
357 
358--
359-- Dumping data for table `zarizeni`
360--
361 
362LOCK TABLES `zarizeni` WRITE;
363/*!40000 ALTER TABLE `zarizeni` DISABLE KEYS */;
364INSERT INTO `zarizeni` VALUES (1,'router','Poèítaè'),(2,'16p switch','16p switch'),(3,'8p switch','8p switch'),(4,'5p switch','5p switch'),(5,'UPS','Zåložní zdroj'),(6,'hwAP','hwAP'),(7,'ElektromÏr','Pro tyto body lze poèítat spotøebu elektrickÊ energie'),(8,'wifi karta',NULL),(9,'napåjecí zdroj',NULL),(10,'PCI karta','obecnå karta do poèítaèe'),(11,'antÊna',NULL),(12,'24p switch',NULL),(13,'Mediakonvertor','Optika'),(14,'MiniGBIC','MiniGBIC'),(15,'USB karta','USB karta');
365/*!40000 ALTER TABLE `zarizeni` ENABLE KEYS */;
366UNLOCK TABLES;
367/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
368 
369/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
370/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
371/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
372/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
373/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
374/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
375/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
376 
377-- Dump completed on 2008-09-12 14:43:39

Powered by WebSVN 2.2.1