From: philipp <philipp@7aebc617-e5e2-0310-91dc-80fb5f6d2477>
Date: Wed, 1 Nov 2017 22:07:42 +0000 (+0000)
Subject: Add table wrregioncache to test data.
X-Git-Url: https://git.toastfreeware.priv.at/philipp/winterrodeln/wradmin.git/commitdiff_plain/4279d514b0ba8c1ecb86f7aa032daabc88b652e3

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 f310196..2a598b2 100644
--- 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);
+
+
+
+--
+-- 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 */;