Add table wrregioncache to test data.

git-svn-id: http://www.winterrodeln.org/svn/wradmin/trunk@2733 7aebc617-e5e2-0310-91dc-80fb5f6d2477

diff --git a/tests/testdb.sql b/tests/testdb.sql
index f310196e7ff6483148eb46fd52b649107ecf090f..2a598b283aec027125eec050cac10d624104b1ae 100644 (file)
--- a/tests/testdb.sql
+++ b/tests/testdb.sql
@@ -508,6 +508,59 @@ INSERT INTO wrinncache VALUES (361,'Lindauer_Hütte_(Gasthaus)',47.034436,9.8356
 INSERT INTO wrinncache VALUES (362,'Meißner_Haus_(Gasthaus)',47.208367,11.488682,1720,'Sven Deppe',NULL,1,'65 Schlafplätze',0,1,NULL,NULL,NULL,'http://www.meissner-haus.at/','info@meissner-haus.at','+43-512-377697','Gasthaus_Meißner_Haus_02.jpg','[[Meißner Haus]]',0);
 INSERT INTO wrinncache VALUES (363,'Milderaun_Alm_(Gasthaus)',47.08768,11.257011,1675,'Milderaunalm OG',NULL,NULL,NULL,NULL,NULL,1,'Ja',NULL,'Nein','dez.testarossa@a1.net','+43-699-10036813','Gasthaus_Milderaun_Alm_01.jpg','[[Milderaun]]; [[Milderaun (kürzer)]]',1);
 INSERT INTO wrinncache VALUES (364,'Moonlight-Bar',47.495677136,12.197686555,720,'Gabi Schroll',NULL,0,NULL,1,1,0,NULL,'bob; T-Mobile A; orange AT; 3 AT','http://www.moonlightbar-soell.com/','schroll.gabi@aon.at','+43-664-4036006','Moonlight-Bar 2016-01-18.jpg','[[Söll - Hexenritt]]; [[Söll - Mondrodelbahn]]',0);
 INSERT INTO wrinncache VALUES (362,'Meißner_Haus_(Gasthaus)',47.208367,11.488682,1720,'Sven Deppe',NULL,1,'65 Schlafplätze',0,1,NULL,NULL,NULL,'http://www.meissner-haus.at/','info@meissner-haus.at','+43-512-377697','Gasthaus_Meißner_Haus_02.jpg','[[Meißner Haus]]',0);
 INSERT INTO wrinncache VALUES (363,'Milderaun_Alm_(Gasthaus)',47.08768,11.257011,1675,'Milderaunalm OG',NULL,NULL,NULL,NULL,NULL,1,'Ja',NULL,'Nein','dez.testarossa@a1.net','+43-699-10036813','Gasthaus_Milderaun_Alm_01.jpg','[[Milderaun]]; [[Milderaun (kürzer)]]',1);
 INSERT INTO wrinncache VALUES (364,'Moonlight-Bar',47.495677136,12.197686555,720,'Gabi Schroll',NULL,0,NULL,1,1,0,NULL,'bob; T-Mobile A; orange AT; 3 AT','http://www.moonlightbar-soell.com/','schroll.gabi@aon.at','+43-664-4036006','Moonlight-Bar 2016-01-18.jpg','[[Söll - Hexenritt]]; [[Söll - Mondrodelbahn]]',0);

+
+
+
+--
+-- Table structure for table `wrregioncache`
+--
+
+DROP TABLE IF EXISTS wrregioncache;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE wrregioncache (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  region_id int(11) DEFAULT NULL,
+  page_id int(11) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY region_id (region_id),
+  CONSTRAINT wrregioncache_ibfk_1 FOREIGN KEY (region_id) REFERENCES wrregion (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=49147 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `wrregioncache`
+--
+INSERT INTO wrregioncache VALUES (48522,4,5);
+INSERT INTO wrregioncache VALUES (48523,5,5);
+INSERT INTO wrregioncache VALUES (48524,27,5);
+INSERT INTO wrregioncache VALUES (48525,28,5);
+INSERT INTO wrregioncache VALUES (48537,4,228);
+INSERT INTO wrregioncache VALUES (48538,25,228);
+INSERT INTO wrregioncache VALUES (48539,28,228);
+INSERT INTO wrregioncache VALUES (48565,2,237);
+INSERT INTO wrregioncache VALUES (48566,3,237);
+INSERT INTO wrregioncache VALUES (48567,4,237);
+INSERT INTO wrregioncache VALUES (48568,9,237);
+INSERT INTO wrregioncache VALUES (48569,28,237);
+INSERT INTO wrregioncache VALUES (48615,2,251);
+INSERT INTO wrregioncache VALUES (48616,3,251);
+INSERT INTO wrregioncache VALUES (48617,4,251);
+INSERT INTO wrregioncache VALUES (48618,9,251);
+INSERT INTO wrregioncache VALUES (48619,28,251);
+INSERT INTO wrregioncache VALUES (48718,10,283);
+INSERT INTO wrregioncache VALUES (48846,4,761);
+INSERT INTO wrregioncache VALUES (48847,5,761);
+INSERT INTO wrregioncache VALUES (48848,27,761);
+INSERT INTO wrregioncache VALUES (48849,28,761);
+INSERT INTO wrregioncache VALUES (48854,4,793);
+INSERT INTO wrregioncache VALUES (48855,12,793);
+INSERT INTO wrregioncache VALUES (48891,4,926);
+INSERT INTO wrregioncache VALUES (48892,12,926);
+INSERT INTO wrregioncache VALUES (48893,26,926);
+INSERT INTO wrregioncache VALUES (49023,22,1417);
+INSERT INTO wrregioncache VALUES (49124,4,1804);
+INSERT INTO wrregioncache VALUES (49125,12,1804);

 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;