From c5a460bfa721cea54598c09311719dd83e8ed288 Mon Sep 17 00:00:00 2001 From: philipp Date: Tue, 24 Oct 2017 21:17:14 +0000 Subject: [PATCH] Add table structure some test data for wrinncache. git-svn-id: http://www.winterrodeln.org/svn/wradmin/trunk@2720 7aebc617-e5e2-0310-91dc-80fb5f6d2477 --- tests/testdb.sql | 48 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 48 insertions(+) diff --git a/tests/testdb.sql b/tests/testdb.sql index d65b5a2..d175a43 100644 --- 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 */; -- 2.39.5