From a51af47718b955704bbbb889e9c9262629a1e18a Mon Sep 17 00:00:00 2001
From: Philipp Spitzer <philipp@spitzer.priv.at>
Date: Mon, 29 Jun 2020 22:00:24 +0200
Subject: [PATCH] Add table wrreportcache to testdb.sql.

---
 tests/testdb.md  |  3 ++-
 tests/testdb.sql | 27 +++++++++++++++++++++++++++
 2 files changed, 29 insertions(+), 1 deletion(-)

diff --git a/tests/testdb.md b/tests/testdb.md
index f3e923d..f7756f5 100644
--- a/tests/testdb.md
+++ b/tests/testdb.md
@@ -13,7 +13,6 @@ wrintermapsreporthistory,
 wrintermapssledrun,
 wrmappathcache,
 wrmappointcache,
-wrreportcache,
 
 account_credentials,
 account_requests,
@@ -95,6 +94,7 @@ wrinncache
 wrregion
 wrregioncache
 wrreport
+wrreportcache,
 wrsledruncache
 ```
 
@@ -176,6 +176,7 @@ DELETE FROM `user` WHERE user_id != 0;
 Drop entries from Winterrodeln related tables:
 
 ```{sql}
+DELETE FROM wrreportcache;
 DELETE FROM wrreport;
 DELETE FROM wrsledruncache;
 DELETE FROM wrinncache;
diff --git a/tests/testdb.sql b/tests/testdb.sql
index 2dd2d77..b9ac2cb 100644
--- a/tests/testdb.sql
+++ b/tests/testdb.sql
@@ -545,6 +545,33 @@ INSERT INTO `wrreport` VALUES (19595,5,'Birgitzer Alm (vom Adelshof)','2017-03-2
 INSERT INTO `wrreport` VALUES (19596,1417,'Grindelwald - First','2017-03-28','16:00:00','2017-03-30 01:24:49','2017-04-08 01:24:49',2,'Die Strecke First-Schreckfeld ist gut befahrbar. Trotz warmer Temperaturen/Sonne. Die Station Schreckfeld kann jedoch nicht mehr direkt angefahren werden. Hier muss man fussgaengig einen kleinen Aufstieg (Bruecke) begehen. Abfahrt nach Bort nicht mehr moeglich. Schnee fehlt.','alemannenrodel',NULL,328,'Alemannenrodel',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
 /*!40000 ALTER TABLE `wrreport` ENABLE KEYS */;
 
+--
+-- Table structure for table `wrreportcache`
+--
+
+DROP TABLE IF EXISTS `wrreportcache`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `wrreportcache` (
+  `page_id` int(11) NOT NULL,
+  `page_title` varchar(255) DEFAULT NULL,
+  `report_id` int(11) DEFAULT NULL,
+  `date_report` date DEFAULT NULL,
+  `condition` int(11) DEFAULT NULL,
+  `description` mediumtext DEFAULT NULL,
+  `author_name` varchar(30) DEFAULT NULL,
+  `author_username` varchar(30) DEFAULT NULL,
+  PRIMARY KEY (`page_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `wrreportcache`
+--
+
+/*!40000 ALTER TABLE `wrreportcache` DISABLE KEYS */;
+/*!40000 ALTER TABLE `wrreportcache` ENABLE KEYS */;
+
 --
 -- Table structure for table `wrsledruncache`
 --
-- 
2.39.5