-- 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','\n\n\npanelak\nSketchUp Pro]]>\nSketchUp\n\n \n 14.49530789565253,50.12418698362534,296.5980816807133\n \n\n1\n\n 327.109\n 62.504\n 50.1231533800244\n 14.49746599195971\n 547.7968641804115\n\n \n Tour\n \n Camera\n 1\n \n 327.109\n 62.504\n 50.1231533800244\n 14.49746599195971\n 547.7968641804115\n \n \n \n \n \n \n \n Model\n \n \n Geometry\n #FrontColor\n \n \n absolute\n \n \n \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 \n \n \n \n \n absolute\n \n \n \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 \n \n \n \n \n absolute\n \n \n \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 \n \n \n \n \n absolute\n \n \n \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 \n \n \n \n \n absolute\n \n \n \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 \n \n \n \n \n absolute\n \n \n \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 \n \n \n \n \n \n \n \n Geometry\n #Edges\n \n \n absolute\n \n 14.49410417772403,50.12492104184106,296.5980816807133\n 14.49422705986362,50.12499391071253,296.5980816807133\n \n \n \n absolute\n \n 14.49422705986362,50.12499391071253,296.5980816807133\n 14.49661586438945,50.12332887129011,296.5980816807133\n \n \n \n absolute\n \n 14.49661586438945,50.12332887129011,296.5980816807133\n 14.49649298284888,50.12325600492746,296.5980816807133\n \n \n \n absolute\n \n 14.49649298284888,50.12325600492746,296.5980816807133\n 14.49410417772403,50.12492104184106,296.5980816807133\n \n \n \n absolute\n \n 14.49410417772403,50.12492104184106,326.2880817109971\n 14.49422705986362,50.12499391071253,326.2880817109971\n \n \n \n absolute\n \n 14.49422705986362,50.12499391071253,326.2880817109971\n 14.49661586438945,50.12332887129011,326.2880817109971\n \n \n \n absolute\n \n 14.49661586438945,50.12332887129011,326.2880817109971\n 14.49649298284888,50.12325600492746,326.2880817109971\n \n \n \n absolute\n \n 14.49649298284888,50.12325600492746,326.2880817109971\n 14.49410417772403,50.12492104184106,326.2880817109971\n \n \n \n absolute\n \n 14.49422705986362,50.12499391071253,296.5980816807133\n 14.49422705986362,50.12499391071253,326.2880817109971\n \n \n \n absolute\n \n 14.49410417772403,50.12492104184106,296.5980816807133\n 14.49410417772403,50.12492104184106,326.2880817109971\n \n \n \n absolute\n \n 14.49661586438945,50.12332887129011,296.5980816807133\n 14.49661586438945,50.12332887129011,326.2880817109971\n \n \n \n absolute\n \n 14.49649298284888,50.12325600492746,296.5980816807133\n 14.49649298284888,50.12325600492746,326.2880817109971\n \n \n \n \n \n\n\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 WebSVN - is - Blame - Rev 5 - /trunk/demois.sql
  jablonka.czprosek.czf

is

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

 

Line No. Rev Author Line

Powered by WebSVN 2.2.1