jablonka.czprosek.czf

is

 Subversion Repositories:
[/] [trunk/] [demois.sql] - Diff between revs 5 and 7

Show entire file Ignore whitespace

Rev 5 Rev 7
Line 42... Line 42...
-- Dumping data for table `adresy` -- Dumping data for table `adresy`
-- --
   
LOCK TABLES `adresy` WRITE; LOCK TABLES `adresy` WRITE;
/*!40000 ALTER TABLE `adresy` DISABLE KEYS */; /*!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); 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),(127,0,'','','','','','','','','','','',0),(126,2,'','Šluknovskå','314/16','','10','','','','','','',0),(125,0,'','','','','','','','','','','',0),(124,0,'','Jabloneckå','714','','budník','','','','','','',0);
/*!40000 ALTER TABLE `adresy` ENABLE KEYS */; /*!40000 ALTER TABLE `adresy` ENABLE KEYS */;
UNLOCK TABLES; UNLOCK TABLES;
   
-- --
-- Table structure for table `cleni` -- Table structure for table `cleni`
Line 76... Line 76...
-- Dumping data for table `cleni` -- Dumping data for table `cleni`
-- --
   
LOCK TABLES `cleni` WRITE; LOCK TABLES `cleni` WRITE;
/*!40000 ALTER TABLE `cleni` DISABLE KEYS */; /*!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,''); INSERT 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');
/*!40000 ALTER TABLE `cleni` ENABLE KEYS */; /*!40000 ALTER TABLE `cleni` ENABLE KEYS */;
UNLOCK TABLES; UNLOCK TABLES;
   
-- --
-- Table structure for table `dodavatele` -- Table structure for table `dodavatele`
Line 119... Line 119...
-- Dumping data for table `ekonto` -- Dumping data for table `ekonto`
-- --
   
LOCK TABLES `ekonto` WRITE; LOCK TABLES `ekonto` WRITE;
/*!40000 ALTER TABLE `ekonto` DISABLE KEYS */; /*!40000 ALTER TABLE `ekonto` DISABLE KEYS */;
  INSERT INTO `ekonto` VALUES ('a5f74fba741d4b0802551546e16f3a45076b65a3',4,'2008-10-12'),('a5f74fba741d4b0802551546e16f3a45076b65a3',3,'2008-10-12'),('061ea003cc90191b1c9a6b4e68fcefc405a783cf',2,'2008-10-12');
/*!40000 ALTER TABLE `ekonto` ENABLE KEYS */; /*!40000 ALTER TABLE `ekonto` ENABLE KEYS */;
UNLOCK TABLES; UNLOCK TABLES;
   
-- --
-- Table structure for table `finance` -- Table structure for table `finance`
Line 146... Line 147...
-- Dumping data for table `finance` -- Dumping data for table `finance`
-- --
   
LOCK TABLES `finance` WRITE; LOCK TABLES `finance` WRITE;
/*!40000 ALTER TABLE `finance` DISABLE KEYS */; /*!40000 ALTER TABLE `finance` DISABLE KEYS */;
  INSERT 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);
/*!40000 ALTER TABLE `finance` ENABLE KEYS */; /*!40000 ALTER TABLE `finance` ENABLE KEYS */;
UNLOCK TABLES; UNLOCK TABLES;
   
-- --
-- Table structure for table `ipecka` -- Table structure for table `ipecka`
Line 171... Line 173...
-- Dumping data for table `ipecka` -- Dumping data for table `ipecka`
-- --
   
LOCK TABLES `ipecka` WRITE; LOCK TABLES `ipecka` WRITE;
/*!40000 ALTER TABLE `ipecka` DISABLE KEYS */; /*!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',''); 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',''),(4,2,126,'tonda','','10.33.4.55','');
/*!40000 ALTER TABLE `ipecka` ENABLE KEYS */; /*!40000 ALTER TABLE `ipecka` ENABLE KEYS */;
UNLOCK TABLES; UNLOCK TABLES;
   
-- --
-- Table structure for table `majetek` -- Table structure for table `majetek`
Line 245... Line 247...
-- Dumping data for table `platby` -- Dumping data for table `platby`
-- --
   
LOCK TABLES `platby` WRITE; LOCK TABLES `platby` WRITE;
/*!40000 ALTER TABLE `platby` DISABLE KEYS */; /*!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í ú&#269;etnictví','vedení ú&#269;etnictví'),(16,'telefonni poplatky',NULL),(17,'osobní vklad',NULL),(18,'p&#345;enos do p&#345;íštího roku',NULL); 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í ú&#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');
/*!40000 ALTER TABLE `platby` ENABLE KEYS */; /*!40000 ALTER TABLE `platby` ENABLE KEYS */;
UNLOCK TABLES; UNLOCK TABLES;
   
-- --
-- Table structure for table `pokladny` -- Table structure for table `pokladny`
Line 267... Line 269...
-- Dumping data for table `pokladny` -- Dumping data for table `pokladny`
-- --
   
LOCK TABLES `pokladny` WRITE; LOCK TABLES `pokladny` WRITE;
/*!40000 ALTER TABLE `pokladny` DISABLE KEYS */; /*!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'); INSERT 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');
/*!40000 ALTER TABLE `pokladny` ENABLE KEYS */; /*!40000 ALTER TABLE `pokladny` ENABLE KEYS */;
UNLOCK TABLES; UNLOCK TABLES;
   
-- --
-- Table structure for table `poplatky` -- Table structure for table `poplatky`
Line 337... Line 339...
-- Dumping data for table `ukony` -- Dumping data for table `ukony`
-- --
   
LOCK TABLES `ukony` WRITE; LOCK TABLES `ukony` WRITE;
/*!40000 ALTER TABLE `ukony` DISABLE KEYS */; /*!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); INSERT 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);
/*!40000 ALTER TABLE `ukony` ENABLE KEYS */; /*!40000 ALTER TABLE `ukony` ENABLE KEYS */;
UNLOCK TABLES; UNLOCK TABLES;
   
-- --
-- Table structure for table `zarizeni` -- Table structure for table `zarizeni`
Line 372... Line 374...
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
   
-- Dump completed on 2008-09-12 14:43:39 -- Dump completed on 2008-10-12 18:59:33
   

Powered by WebSVN 2.2.1