|
is |
Subversion Repositories: |
Compare with Previous - Blame - Download
-- MySQL dump 10.11---- Host: localhost Database: demois-- -------------------------------------------------------- Server version 5.0.45/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Table structure for table `adresy`--DROP TABLE IF EXISTS `adresy`;CREATE TABLE `adresy` (`id` int(11) NOT NULL default '0',`clen` int(11) NOT NULL default '0',`mesto` tinytext NOT NULL,`ulice` tinytext NOT NULL,`cp` tinytext NOT NULL,`psc` tinytext NOT NULL,`byt` tinytext NOT NULL,`komentar` text NOT NULL,`sirka` tinytext,`delka` tinytext,`vyska` tinytext,`otoceni` tinytext,`naklon` tinytext,`objekt` int(11) default NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;---- Dumping data for table `adresy`--LOCK TABLES `adresy` WRITE;/*!40000 ALTER TABLE `adresy` DISABLE KEYS */;INSERT 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);/*!40000 ALTER TABLE `adresy` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `cleni`--DROP TABLE IF EXISTS `cleni`;CREATE TABLE `cleni` (`id` int(11) NOT NULL default '0',`prezdivka` tinytext NOT NULL,`jmeno` tinytext NOT NULL,`prijmeni` tinytext NOT NULL,`narozen` tinytext NOT NULL,`domu` tinytext NOT NULL,`mobil` tinytext NOT NULL,`email` tinytext NOT NULL,`icq` tinytext NOT NULL,`komentar` text NOT NULL,`active` tinyint(4) NOT NULL default '0',`finance` tinyint(4) NOT NULL default '0',`energy` tinyint(4) NOT NULL default '0',`internet` tinyint(4) NOT NULL default '0',`vs` tinytext,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;---- Dumping data for table `cleni`--LOCK TABLES `cleni` WRITE;/*!40000 ALTER TABLE `cleni` DISABLE KEYS */;INSERT 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,'');/*!40000 ALTER TABLE `cleni` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `dodavatele`--DROP TABLE IF EXISTS `dodavatele`;CREATE TABLE `dodavatele` (`id` int(11) NOT NULL default '0',`nazev` tinytext NOT NULL,`komentar` text,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;---- Dumping data for table `dodavatele`--LOCK TABLES `dodavatele` WRITE;/*!40000 ALTER TABLE `dodavatele` DISABLE KEYS */;INSERT 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');/*!40000 ALTER TABLE `dodavatele` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `ekonto`--DROP TABLE IF EXISTS `ekonto`;CREATE TABLE `ekonto` (`value` text NOT NULL,`id` int(11) NOT NULL default '-1',`datum` date default NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;---- Dumping data for table `ekonto`--LOCK TABLES `ekonto` WRITE;/*!40000 ALTER TABLE `ekonto` DISABLE KEYS */;/*!40000 ALTER TABLE `ekonto` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `finance`--DROP TABLE IF EXISTS `finance`;CREATE TABLE `finance` (`id` int(11) NOT NULL default '0',`clen` int(11) NOT NULL default '0',`platba` int(11) NOT NULL default '0',`hodnota` tinytext NOT NULL,`datum` date NOT NULL default '0000-00-00',`komentar` text NOT NULL,`dodavatel` int(11) default '0',`uctenka` int(11) default NULL,`pokladna` int(11) default '0',PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;---- Dumping data for table `finance`--LOCK TABLES `finance` WRITE;/*!40000 ALTER TABLE `finance` DISABLE KEYS */;/*!40000 ALTER TABLE `finance` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `ipecka`--DROP TABLE IF EXISTS `ipecka`;CREATE TABLE `ipecka` (`id` int(11) NOT NULL default '0',`clen` int(11) NOT NULL default '0',`adresa` int(11) NOT NULL default '0',`dns` tinytext NOT NULL,`mac` tinytext NOT NULL,`ip` tinytext NOT NULL,`komentar` text NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;---- Dumping data for table `ipecka`--LOCK TABLES `ipecka` WRITE;/*!40000 ALTER TABLE `ipecka` DISABLE KEYS */;INSERT 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','');/*!40000 ALTER TABLE `ipecka` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `majetek`--DROP TABLE IF EXISTS `majetek`;CREATE TABLE `majetek` (`id` int(11) NOT NULL default '0',`clen` int(11) default NULL,`adresa` int(11) default NULL,`zarizeni` int(11) default NULL,`finance` int(11) default NULL,`spotreba` double default NULL,`soucast` int(11) default NULL,`scislo` tinytext,`komentar` text,`mac` tinytext,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;---- Dumping data for table `majetek`--LOCK TABLES `majetek` WRITE;/*!40000 ALTER TABLE `majetek` DISABLE KEYS */;INSERT INTO `majetek` VALUES (2,0,124,7,0,0,0,'','',''),(1,0,0,1,0,50,0,'nevim','nejaky router se spotrebou 50W','');/*!40000 ALTER TABLE `majetek` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `objekty`--DROP TABLE IF EXISTS `objekty`;CREATE TABLE `objekty` (`id` int(11) NOT NULL default '0',`nazev` tinytext,`definice` longtext,`komentar` text,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;---- Dumping data for table `objekty`--LOCK TABLES `objekty` WRITE;/*!40000 ALTER TABLE `objekty` DISABLE KEYS */;INSERT 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>\n14.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>\n14.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.');/*!40000 ALTER TABLE `objekty` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `platby`--DROP TABLE IF EXISTS `platby`;CREATE TABLE `platby` (`id` int(11) NOT NULL default '0',`nazev` tinytext NOT NULL,`popis` text,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;---- Dumping data for table `platby`--LOCK TABLES `platby` WRITE;/*!40000 ALTER TABLE `platby` DISABLE KEYS */;INSERT 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Ă ĂşčetnictvĂ','vedenĂ ĂşčetnictvĂ'),(16,'telefonni poplatky',NULL),(17,'osobnĂ vklad',NULL),(18,'přenos do přĂštĂho roku',NULL);/*!40000 ALTER TABLE `platby` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `pokladny`--DROP TABLE IF EXISTS `pokladny`;CREATE TABLE `pokladny` (`id` int(11) NOT NULL default '0',`nazev` tinytext NOT NULL,`komentar` text,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;---- Dumping data for table `pokladny`--LOCK TABLES `pokladny` WRITE;/*!40000 ALTER TABLE `pokladny` DISABLE KEYS */;INSERT INTO `pokladny` VALUES (0,'???',NULL),(1,'simandl','Pokladna Petra Simandla'),(2,'sinda','Pokladna Petra Ĺ indĂ˝lka'),(3,'eBanka','konto v eBance 2118436001/2400');/*!40000 ALTER TABLE `pokladny` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `poplatky`--DROP TABLE IF EXISTS `poplatky`;CREATE TABLE `poplatky` (`id` tinyint(4) NOT NULL default '0',`type` text NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;---- Dumping data for table `poplatky`--LOCK TABLES `poplatky` WRITE;/*!40000 ALTER TABLE `poplatky` DISABLE KEYS */;INSERT INTO `poplatky` VALUES (0,'internet'),(1,'elektrina'),(2,'opravy'),(3,'vstupni prispevek'),(4,'jine');/*!40000 ALTER TABLE `poplatky` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `udalosti`--DROP TABLE IF EXISTS `udalosti`;CREATE TABLE `udalosti` (`id` int(11) NOT NULL default '0',`nazev` tinytext NOT NULL,`komentar` text,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;---- Dumping data for table `udalosti`--LOCK TABLES `udalosti` WRITE;/*!40000 ALTER TABLE `udalosti` DISABLE KEYS */;INSERT 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);/*!40000 ALTER TABLE `udalosti` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `ukony`--DROP TABLE IF EXISTS `ukony`;CREATE TABLE `ukony` (`id` int(11) NOT NULL default '0',`clen` int(11) NOT NULL default '0',`udalost` int(11) NOT NULL default '0',`predmet` int(11) NOT NULL default '0',`datum` date NOT NULL default '0000-00-00',`komentar` text NOT NULL,`adresa` int(11) default NULL,`finance` int(11) default NULL,`majetek` int(11) default NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;---- Dumping data for table `ukony`--LOCK TABLES `ukony` WRITE;/*!40000 ALTER TABLE `ukony` DISABLE KEYS */;INSERT 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);/*!40000 ALTER TABLE `ukony` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `zarizeni`--DROP TABLE IF EXISTS `zarizeni`;CREATE TABLE `zarizeni` (`id` int(11) NOT NULL default '0',`nazev` tinytext NOT NULL,`komentar` text,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;---- Dumping data for table `zarizeni`--LOCK TABLES `zarizeni` WRITE;/*!40000 ALTER TABLE `zarizeni` DISABLE KEYS */;INSERT 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');/*!40000 ALTER TABLE `zarizeni` ENABLE KEYS */;UNLOCK TABLES;/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;-- Dump completed on 2008-09-12 14:43:39