| 1 | 2 | simandl | -- 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 | | | |
| 22 | | | DROP TABLE IF EXISTS `adresy`; |
| 23 | | | CREATE 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 | | | |
| 45 | | | LOCK TABLES `adresy` WRITE; |
| 46 | | | /*!40000 ALTER TABLE `adresy` DISABLE KEYS */; |
| 47 | | | 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); |
| 48 | | | /*!40000 ALTER TABLE `adresy` ENABLE KEYS */; |
| 49 | | | UNLOCK TABLES; |
| 50 | | | |
| 51 | | | -- |
| 52 | | | -- Table structure for table `cleni` |
| 53 | | | -- |
| 54 | | | |
| 55 | | | DROP TABLE IF EXISTS `cleni`; |
| 56 | | | CREATE 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 | | | |
| 79 | | | LOCK TABLES `cleni` WRITE; |
| 80 | | | /*!40000 ALTER TABLE `cleni` DISABLE KEYS */; |
| 81 | | | 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,''); |
| 82 | | | /*!40000 ALTER TABLE `cleni` ENABLE KEYS */; |
| 83 | | | UNLOCK TABLES; |
| 84 | | | |
| 85 | | | -- |
| 86 | | | -- Table structure for table `dodavatele` |
| 87 | | | -- |
| 88 | | | |
| 89 | | | DROP TABLE IF EXISTS `dodavatele`; |
| 90 | | | CREATE 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 | | | |
| 101 | | | LOCK TABLES `dodavatele` WRITE; |
| 102 | | | /*!40000 ALTER TABLE `dodavatele` DISABLE KEYS */; |
| 103 | | | 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'); |
| 104 | | | /*!40000 ALTER TABLE `dodavatele` ENABLE KEYS */; |
| 105 | | | UNLOCK TABLES; |
| 106 | | | |
| 107 | | | -- |
| 108 | | | -- Table structure for table `ekonto` |
| 109 | | | -- |
| 110 | | | |
| 111 | | | DROP TABLE IF EXISTS `ekonto`; |
| 112 | | | CREATE 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 | | | |
| 122 | | | LOCK TABLES `ekonto` WRITE; |
| 123 | | | /*!40000 ALTER TABLE `ekonto` DISABLE KEYS */; |
| 124 | | | /*!40000 ALTER TABLE `ekonto` ENABLE KEYS */; |
| 125 | | | UNLOCK TABLES; |
| 126 | | | |
| 127 | | | -- |
| 128 | | | -- Table structure for table `finance` |
| 129 | | | -- |
| 130 | | | |
| 131 | | | DROP TABLE IF EXISTS `finance`; |
| 132 | | | CREATE 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 | | | |
| 149 | | | LOCK TABLES `finance` WRITE; |
| 150 | | | /*!40000 ALTER TABLE `finance` DISABLE KEYS */; |
| 151 | | | /*!40000 ALTER TABLE `finance` ENABLE KEYS */; |
| 152 | | | UNLOCK TABLES; |
| 153 | | | |
| 154 | | | -- |
| 155 | | | -- Table structure for table `ipecka` |
| 156 | | | -- |
| 157 | | | |
| 158 | | | DROP TABLE IF EXISTS `ipecka`; |
| 159 | | | CREATE 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 | | | |
| 174 | | | LOCK TABLES `ipecka` WRITE; |
| 175 | | | /*!40000 ALTER TABLE `ipecka` DISABLE KEYS */; |
| 176 | | | 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',''); |
| 177 | | | /*!40000 ALTER TABLE `ipecka` ENABLE KEYS */; |
| 178 | | | UNLOCK TABLES; |
| 179 | | | |
| 180 | | | -- |
| 181 | | | -- Table structure for table `majetek` |
| 182 | | | -- |
| 183 | | | |
| 184 | | | DROP TABLE IF EXISTS `majetek`; |
| 185 | | | CREATE 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 | | | |
| 203 | | | LOCK TABLES `majetek` WRITE; |
| 204 | | | /*!40000 ALTER TABLE `majetek` DISABLE KEYS */; |
| 205 | | | INSERT 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 */; |
| 207 | | | UNLOCK TABLES; |
| 208 | | | |
| 209 | | | -- |
| 210 | | | -- Table structure for table `objekty` |
| 211 | | | -- |
| 212 | | | |
| 213 | | | DROP TABLE IF EXISTS `objekty`; |
| 214 | | | CREATE 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 | | | |
| 226 | | | LOCK TABLES `objekty` WRITE; |
| 227 | | | /*!40000 ALTER TABLE `objekty` DISABLE KEYS */; |
| 228 | | | 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>\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 */; |
| 230 | | | UNLOCK TABLES; |
| 231 | | | |
| 232 | | | -- |
| 233 | | | -- Table structure for table `platby` |
| 234 | | | -- |
| 235 | | | |
| 236 | | | DROP TABLE IF EXISTS `platby`; |
| 237 | | | CREATE 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 | | | |
| 248 | | | LOCK TABLES `platby` WRITE; |
| 249 | | | /*!40000 ALTER TABLE `platby` DISABLE KEYS */; |
| 250 | | | 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); |
| 251 | | | /*!40000 ALTER TABLE `platby` ENABLE KEYS */; |
| 252 | | | UNLOCK TABLES; |
| 253 | | | |
| 254 | | | -- |
| 255 | | | -- Table structure for table `pokladny` |
| 256 | | | -- |
| 257 | | | |
| 258 | | | DROP TABLE IF EXISTS `pokladny`; |
| 259 | | | CREATE 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 | | | |
| 270 | | | LOCK TABLES `pokladny` WRITE; |
| 271 | | | /*!40000 ALTER TABLE `pokladny` DISABLE KEYS */; |
| 272 | | | INSERT 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 */; |
| 274 | | | UNLOCK TABLES; |
| 275 | | | |
| 276 | | | -- |
| 277 | | | -- Table structure for table `poplatky` |
| 278 | | | -- |
| 279 | | | |
| 280 | | | DROP TABLE IF EXISTS `poplatky`; |
| 281 | | | CREATE 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 | | | |
| 290 | | | LOCK TABLES `poplatky` WRITE; |
| 291 | | | /*!40000 ALTER TABLE `poplatky` DISABLE KEYS */; |
| 292 | | | INSERT INTO `poplatky` VALUES (0,'internet'),(1,'elektrina'),(2,'opravy'),(3,'vstupni prispevek'),(4,'jine'); |
| 293 | | | /*!40000 ALTER TABLE `poplatky` ENABLE KEYS */; |
| 294 | | | UNLOCK TABLES; |
| 295 | | | |
| 296 | | | -- |
| 297 | | | -- Table structure for table `udalosti` |
| 298 | | | -- |
| 299 | | | |
| 300 | | | DROP TABLE IF EXISTS `udalosti`; |
| 301 | | | CREATE 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 | | | |
| 312 | | | LOCK TABLES `udalosti` WRITE; |
| 313 | | | /*!40000 ALTER TABLE `udalosti` DISABLE KEYS */; |
| 314 | | | 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); |
| 315 | | | /*!40000 ALTER TABLE `udalosti` ENABLE KEYS */; |
| 316 | | | UNLOCK TABLES; |
| 317 | | | |
| 318 | | | -- |
| 319 | | | -- Table structure for table `ukony` |
| 320 | | | -- |
| 321 | | | |
| 322 | | | DROP TABLE IF EXISTS `ukony`; |
| 323 | | | CREATE 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 | | | |
| 340 | | | LOCK TABLES `ukony` WRITE; |
| 341 | | | /*!40000 ALTER TABLE `ukony` DISABLE KEYS */; |
| 342 | | | 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); |
| 343 | | | /*!40000 ALTER TABLE `ukony` ENABLE KEYS */; |
| 344 | | | UNLOCK TABLES; |
| 345 | | | |
| 346 | | | -- |
| 347 | | | -- Table structure for table `zarizeni` |
| 348 | | | -- |
| 349 | | | |
| 350 | | | DROP TABLE IF EXISTS `zarizeni`; |
| 351 | | | CREATE 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 | | | |
| 362 | | | LOCK TABLES `zarizeni` WRITE; |
| 363 | | | /*!40000 ALTER TABLE `zarizeni` DISABLE KEYS */; |
| 364 | | | 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'); |
| 365 | | | /*!40000 ALTER TABLE `zarizeni` ENABLE KEYS */; |
| 366 | | | UNLOCK 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 |