-- 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 6
- /trunk/demois.sql
is |
Subversion Repositories: |
[/] [trunk/] [demois.sql] - Blame information for rev 6
Powered by WebSVN 2.2.1