Add table structure some test data for wrinncache.

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

diff --git a/tests/testdb.sql b/tests/testdb.sql
index d65b5a24f89026862eb1f44793ff9ee3feb42202..d175a43e7783bd7b42e77246a1e187d359d1a397 100644 (file)
--- a/tests/testdb.sql
+++ b/tests/testdb.sql
@@ -179,6 +179,54 @@ INSERT INTO wrregion VALUES (28,'Nordtirol','nordtirol',838,ST_GeomFromText('MUL
 INSERT INTO wrregion VALUES (29,'Schwaz/Zillertal','schwaz-zillertal',NULL,ST_GeomFromText('MULTIPOLYGON(((11.539802290308542 47.50329408254429,11.955621004684453 47.076165617217384,12.131873381559837 47.32148996182304,11.876906350934279 47.56337111779702,11.876906350934279 47.56337111779702,11.539802290308542 47.50329408254429)))'));
 INSERT INTO wrregion VALUES (30,'Kitzbühel','kitzbühel',NULL,ST_GeomFromText('MULTIPOLYGON(((12.160963579684903 47.32148996182304,12.595605363435853 47.39799363674069,12.561381600935778 47.62337933402255,12.328660015935268 47.577225275421085,12.26021249093512 47.46166196806404,12.060003480309682 47.422312452960874,12.060003480309682 47.422312452960874,12.160963579684903 47.32148996182304)))'));
 INSERT INTO wrregion VALUES (31,'Kufstein','kufstein',NULL,ST_GeomFromText('MULTIPOLYGON(((11.900862984684332 47.56221643923346,12.052439029159842 47.42166358606527,12.249945362185095 47.46975968537188,12.335504768435284 47.63837063663293,11.900862984684332 47.56221643923346)))'));
+
+
+
+--
+-- Table structure for table `wrinncache`
+--
+
+DROP TABLE IF EXISTS wrinncache;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE wrinncache (
+  page_id int(11) NOT NULL,
+  page_title varchar(255) DEFAULT NULL,
+  position_latitude double DEFAULT NULL,
+  position_longitude double DEFAULT NULL,
+  position_elevation int(11) DEFAULT NULL,
+  operator varchar(255) DEFAULT NULL,
+  seats int(11) DEFAULT NULL,
+  overnight tinyint(1) DEFAULT NULL,
+  overnight_comment varchar(255) DEFAULT NULL,
+  smoker_area tinyint(1) DEFAULT NULL,
+  nonsmoker_area tinyint(1) DEFAULT NULL,
+  sled_rental tinyint(1) DEFAULT NULL,
+  sled_rental_comment varchar(255) DEFAULT NULL,
+  mobile_provider text,
+  homepage varchar(255) DEFAULT NULL,
+  email_list text,
+  phone_list text,
+  image varchar(255) DEFAULT NULL,
+  sledding_list text,
+  under_construction tinyint(1) DEFAULT NULL,
+  PRIMARY KEY (page_id)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `wrinncache`
+--
+
+INSERT INTO wrinncache VALUES (356,'Maria_Waldrast_(Klostergasthaus)',47.130667,11.406072,1638,NULL,NULL,1,'Ja',0,1,1,'Ja','Nein',NULL,'maria-waldrast@aon.at','+43-5273-6219; +43-664-4130879','Gasthaus_Maria_Waldrast_2011-01-09.jpg','[[Maria Waldrast]]',0);
+INSERT INTO wrinncache VALUES (357,'Krinnenalpe_(Gasthaus)',47.479777,10.588662,1530,'Martin Rief',NULL,1,'20 Personen',NULL,NULL,NULL,NULL,NULL,'http://www.krinnenalpe-tirol.at','info@krinnenalpe-tirol.at','+43-5675-8189; +43-676-5559000',NULL,'[[Krinnenalplifte]]',1);
+INSERT INTO wrinncache VALUES (358,'Larstig_Alm_(Gasthaus)',47.143333,11.001333,1777,'Fam. Ludwig Scheiber',NULL,0,NULL,0,1,1,'Ja','A1','Nein','Nein','+43-5255-5178; +43-5255-5590','Gasthaus_Larstig_Alm_2009-02-15.jpg','[[Horlachtal]]',0);
+INSERT INTO wrinncache VALUES (359,'Lehnberghaus_(Gasthaus)',47.328687,10.926552,1554,'Kai Oliver Hähnel',NULL,NULL,NULL,0,1,1,'Ja','A1','http://www.lehnberghaus.at','info@lehnberghaus.at','+43-676-7905262','Gasthaus_Lehnberghaus_01.jpg','[[Lehnberghaus]]',0);
+INSERT INTO wrinncache VALUES (360,'Liechtensteinhaus_(Gasthaus)',47.623313,15.833266,1370,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'A1; T-Mobile/Telering; Orange; Drei','http://www.liechtensteinhaus.at','LiechtensteinhausPolleres@aon.at','+43-2664-2343','Gasthaus_Liechtensteinhaus_01.jpg','[[Hirschenkogel]]',0);
+INSERT INTO wrinncache VALUES (361,'Lindauer_Hütte_(Gasthaus)',47.034436,9.835684,NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,'A1','http://members.aon.at/lindauerhuette','lindauerhuette@aon.at','+43-5559-582; +43-664-5033456','Gasthaus_Lindauer_Hütte_2012-02-18.jpg‎','[[Lindauer Hütte]]',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);
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;