jablonka.czprosek.czf

is

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

 

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 */;
477simandlINSERT 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),(127,0,'','','','','','','','','','','',0),(126,2,'','Šluknovskå','314/16','','10','','','','','','',0),(125,0,'','','','','','','','','','','',0),(124,0,'','Jabloneckå','714','','budník','','','','','','',0);
482simandl/*!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 */;
817simandlINSERT INTO `cleni` VALUES (1,'SĂ­ma','Petr','Simandl','','','','simandl@nomail.cz','','pokusnĂŠ konto',1,1,2,1,'1033'),(0,'','jablonka.cz','','','','','','','',1,1,2,1,''),(2,'tonik','tonda','opraveny','','\'\'','555','','','tonda<script type=\\\"text/javascript\\\">alert(\\\"Welcome to the free world.\\\")</script>',1,1,2,1,'11002');
822simandl/*!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 */;
1247simandlINSERT INTO `ekonto` VALUES ('a5f74fba741d4b0802551546e16f3a45076b65a3',4,'2008-10-12'),('a5f74fba741d4b0802551546e16f3a45076b65a3',3,'2008-10-12'),('061ea003cc90191b1c9a6b4e68fcefc405a783cf',2,'2008-10-12');
1252simandl/*!40000 ALTER TABLE `ekonto` ENABLE KEYS */;
126UNLOCK TABLES;
127 
128--
129-- Table structure for table `finance`
130--
131 
132DROP TABLE IF EXISTS `finance`;
133CREATE TABLE `finance` (
134 `id` int(11) NOT NULL default '0',
135 `clen` int(11) NOT NULL default '0',
136 `platba` int(11) NOT NULL default '0',
137 `hodnota` tinytext NOT NULL,
138 `datum` date NOT NULL default '0000-00-00',
139 `komentar` text NOT NULL,
140 `dodavatel` int(11) default '0',
141 `uctenka` int(11) default NULL,
142 `pokladna` int(11) default '0',
143 PRIMARY KEY (`id`)
144) ENGINE=MyISAM DEFAULT CHARSET=utf8;
145 
146--
147-- Dumping data for table `finance`
148--
149 
150LOCK TABLES `finance` WRITE;
151/*!40000 ALTER TABLE `finance` DISABLE KEYS */;
1527simandlINSERT INTO `finance` VALUES (1,1,1,'1200','2007-09-12','',0,0,3),(2,0,9,'-393.00','2008-10-11','30x UTP 0.5m patch kabel \r\n ',0,0,3),(3,0,19,'101,00','2008-10-06','pøesun z rb.cz na fio.cz bÏ&#65533;ný\r\njablonka.cz\r\nBezhotovostní pøíjem',0,0,3),(4,0,19,'101,00','2008-10-06','pøesun z rb.cz na fio.cz bÏ&#65533;ný\r\njablonka.cz\r\nBezhotovostní pøíjem',0,0,3);
1532simandl/*!40000 ALTER TABLE `finance` ENABLE KEYS */;
154UNLOCK TABLES;
155 
156--
157-- Table structure for table `ipecka`
158--
159 
160DROP TABLE IF EXISTS `ipecka`;
161CREATE TABLE `ipecka` (
162 `id` int(11) NOT NULL default '0',
163 `clen` int(11) NOT NULL default '0',
164 `adresa` int(11) NOT NULL default '0',
165 `dns` tinytext NOT NULL,
166 `mac` tinytext NOT NULL,
167 `ip` tinytext NOT NULL,
168 `komentar` text NOT NULL,
169 PRIMARY KEY (`id`)
170) ENGINE=MyISAM DEFAULT CHARSET=utf8;
171 
172--
173-- Dumping data for table `ipecka`
174--
175 
176LOCK TABLES `ipecka` WRITE;
177/*!40000 ALTER TABLE `ipecka` DISABLE KEYS */;
1787simandlINSERT 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',''),(4,2,126,'tonda','','10.33.4.55','');
1792simandl/*!40000 ALTER TABLE `ipecka` ENABLE KEYS */;
180UNLOCK TABLES;
181 
182--
183-- Table structure for table `majetek`
184--
185 
186DROP TABLE IF EXISTS `majetek`;
187CREATE TABLE `majetek` (
188 `id` int(11) NOT NULL default '0',
189 `clen` int(11) default NULL,
190 `adresa` int(11) default NULL,
191 `zarizeni` int(11) default NULL,
192 `finance` int(11) default NULL,
193 `spotreba` double default NULL,
194 `soucast` int(11) default NULL,
195 `scislo` tinytext,
196 `komentar` text,
197 `mac` tinytext,
198 PRIMARY KEY (`id`)
199) ENGINE=MyISAM DEFAULT CHARSET=utf8;
200 
201--
202-- Dumping data for table `majetek`
203--
204 
205LOCK TABLES `majetek` WRITE;
206/*!40000 ALTER TABLE `majetek` DISABLE KEYS */;
207INSERT INTO `majetek` VALUES (2,0,124,7,0,0,0,'','',''),(1,0,0,1,0,50,0,'nevim','nejaky router se spotrebou 50W','');
208/*!40000 ALTER TABLE `majetek` ENABLE KEYS */;
209UNLOCK TABLES;
210 
211--
212-- Table structure for table `objekty`
213--
214 
215DROP TABLE IF EXISTS `objekty`;
216CREATE TABLE `objekty` (
217 `id` int(11) NOT NULL default '0',
218 `nazev` tinytext,
219 `definice` longtext,
220 `komentar` text,
221 PRIMARY KEY (`id`)
222) ENGINE=MyISAM DEFAULT CHARSET=utf8;
223 
224--
225-- Dumping data for table `objekty`
226--
227 
228LOCK TABLES `objekty` WRITE;
229/*!40000 ALTER TABLE `objekty` DISABLE KEYS */;
230INSERT 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.');
231/*!40000 ALTER TABLE `objekty` ENABLE KEYS */;
232UNLOCK TABLES;
233 
234--
235-- Table structure for table `platby`
236--
237 
238DROP TABLE IF EXISTS `platby`;
239CREATE TABLE `platby` (
240 `id` int(11) NOT NULL default '0',
241 `nazev` tinytext NOT NULL,
242 `popis` text,
243 PRIMARY KEY (`id`)
244) ENGINE=MyISAM DEFAULT CHARSET=utf8;
245 
246--
247-- Dumping data for table `platby`
248--
249 
250LOCK TABLES `platby` WRITE;
251/*!40000 ALTER TABLE `platby` DISABLE KEYS */;
2527simandlINSERT 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),(19,'presun','presun mezi konty a/nebo pokladnami');
2532simandl/*!40000 ALTER TABLE `platby` ENABLE KEYS */;
254UNLOCK TABLES;
255 
256--
257-- Table structure for table `pokladny`
258--
259 
260DROP TABLE IF EXISTS `pokladny`;
261CREATE TABLE `pokladny` (
262 `id` int(11) NOT NULL default '0',
263 `nazev` tinytext NOT NULL,
264 `komentar` text,
265 PRIMARY KEY (`id`)
266) ENGINE=MyISAM DEFAULT CHARSET=utf8;
267 
268--
269-- Dumping data for table `pokladny`
270--
271 
272LOCK TABLES `pokladny` WRITE;
273/*!40000 ALTER TABLE `pokladny` DISABLE KEYS */;
2747simandlINSERT INTO `pokladny` VALUES (0,'???',NULL),(1,'simandl','Pokladna Petra Simandla'),(2,'sinda','Pokladna Petra Šindýlka'),(3,'eBanka','konto v eBance 2118436001/2400'),(4,'fio.cz','konto v zalozne fio.cz');
2752simandl/*!40000 ALTER TABLE `pokladny` ENABLE KEYS */;
276UNLOCK TABLES;
277 
278--
279-- Table structure for table `poplatky`
280--
281 
282DROP TABLE IF EXISTS `poplatky`;
283CREATE TABLE `poplatky` (
284 `id` tinyint(4) NOT NULL default '0',
285 `type` text NOT NULL
286) ENGINE=MyISAM DEFAULT CHARSET=utf8;
287 
288--
289-- Dumping data for table `poplatky`
290--
291 
292LOCK TABLES `poplatky` WRITE;
293/*!40000 ALTER TABLE `poplatky` DISABLE KEYS */;
294INSERT INTO `poplatky` VALUES (0,'internet'),(1,'elektrina'),(2,'opravy'),(3,'vstupni prispevek'),(4,'jine');
295/*!40000 ALTER TABLE `poplatky` ENABLE KEYS */;
296UNLOCK TABLES;
297 
298--
299-- Table structure for table `udalosti`
300--
301 
302DROP TABLE IF EXISTS `udalosti`;
303CREATE TABLE `udalosti` (
304 `id` int(11) NOT NULL default '0',
305 `nazev` tinytext NOT NULL,
306 `komentar` text,
307 PRIMARY KEY (`id`)
308) ENGINE=MyISAM DEFAULT CHARSET=utf8;
309 
310--
311-- Dumping data for table `udalosti`
312--
313 
314LOCK TABLES `udalosti` WRITE;
315/*!40000 ALTER TABLE `udalosti` DISABLE KEYS */;
316INSERT 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);
317/*!40000 ALTER TABLE `udalosti` ENABLE KEYS */;
318UNLOCK TABLES;
319 
320--
321-- Table structure for table `ukony`
322--
323 
324DROP TABLE IF EXISTS `ukony`;
325CREATE TABLE `ukony` (
326 `id` int(11) NOT NULL default '0',
327 `clen` int(11) NOT NULL default '0',
328 `udalost` int(11) NOT NULL default '0',
329 `predmet` int(11) NOT NULL default '0',
330 `datum` date NOT NULL default '0000-00-00',
331 `komentar` text NOT NULL,
332 `adresa` int(11) default NULL,
333 `finance` int(11) default NULL,
334 `majetek` int(11) default NULL,
335 PRIMARY KEY (`id`)
336) ENGINE=MyISAM DEFAULT CHARSET=utf8;
337 
338--
339-- Dumping data for table `ukony`
340--
341 
342LOCK TABLES `ukony` WRITE;
343/*!40000 ALTER TABLE `ukony` DISABLE KEYS */;
3447simandlINSERT INTO `ukony` VALUES (7,2,1,0,'2008-09-12','',126,0,0),(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);
3452simandl/*!40000 ALTER TABLE `ukony` ENABLE KEYS */;
346UNLOCK TABLES;
347 
348--
349-- Table structure for table `zarizeni`
350--
351 
352DROP TABLE IF EXISTS `zarizeni`;
353CREATE TABLE `zarizeni` (
354 `id` int(11) NOT NULL default '0',
355 `nazev` tinytext NOT NULL,
356 `komentar` text,
357 PRIMARY KEY (`id`)
358) ENGINE=MyISAM DEFAULT CHARSET=utf8;
359 
360--
361-- Dumping data for table `zarizeni`
362--
363 
364LOCK TABLES `zarizeni` WRITE;
365/*!40000 ALTER TABLE `zarizeni` DISABLE KEYS */;
366INSERT 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');
367/*!40000 ALTER TABLE `zarizeni` ENABLE KEYS */;
368UNLOCK TABLES;
369/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
370 
371/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
372/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
373/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
374/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
375/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
376/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
377/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
378 
3797simandl-- Dump completed on 2008-10-12 18:59:33

Powered by WebSVN 2.2.1