Add table user_groups to testdb.sql.

[philipp/winterrodeln/wradmin.git] / tests / testdb.sql

diff --git a/tests/testdb.sql b/tests/testdb.sql
index c3035779dc2d15e6acddac6b7808b7558a40aa80..8c45773e8b45225ab462e4317fb4b8eaba536e99 100644 (file)
--- a/tests/testdb.sql
+++ b/tests/testdb.sql
@@ -330,11 +330,37 @@ CREATE TABLE `user` (
 --
 
 /*!40000 ALTER TABLE `user` DISABLE KEYS */;
-INSERT INTO `user` VALUES (0,'Anonymous','','','','\0\0\0\0\0\0\0\0\0\0\0\0\0\0','','20080922211544','\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0','\0\0\0\0\0\0\0\0\0\0\0\0\0\0',NULL,'\0\0\0\0\0\0\0\0\0\0\0\0\0\0','\0\0\0\0\0\0\0\0\0\0\0\0\0\0',NULL,NULL);
 INSERT INTO `user` VALUES (2,'RedirectBot','','','','20080925192203','','20120902200108','ea19a572ecaf2a6d5934b153e52c3ab9','20120902200103',NULL,'20120902200103','20080925192203',1,NULL);
 INSERT INTO `user` VALUES (504,'Johndoe','John Doe',':pbkdf2:sha512:30000:64:hvqT9kNNazXmOigsCc4ewQ==:hytd5I3h38y7jVmqXrv6IKD1zzJYp8ZrUyodInP49VbtKWfQAOYvhmbVFCdl7JK/suPmFLKbe309/jlta2Gk4A==','',NULL,'john.doe@example.com','20191129090658','f0a018e0cf3384411373d83b212128f0',NULL,'bdb23486b4efcab13063fabacc109bae','20191206090650','20191129090650',0,NULL);
+INSERT INTO `user` VALUES (539,'Anonymous','','','','\0\0\0\0\0\0\0\0\0\0\0\0\0\0','','20080922211544','\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0','\0\0\0\0\0\0\0\0\0\0\0\0\0\0',NULL,'\0\0\0\0\0\0\0\0\0\0\0\0\0\0','\0\0\0\0\0\0\0\0\0\0\0\0\0\0',NULL,NULL);
 /*!40000 ALTER TABLE `user` ENABLE KEYS */;
 
+--
+-- Table structure for table `user_groups`
+--
+
+DROP TABLE IF EXISTS `user_groups`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `user_groups` (
+  `ug_user` int(10) unsigned NOT NULL DEFAULT 0,
+  `ug_group` varbinary(255) NOT NULL DEFAULT '',
+  `ug_expiry` varbinary(14) DEFAULT NULL,
+  PRIMARY KEY (`ug_user`,`ug_group`),
+  KEY `ug_group` (`ug_group`),
+  KEY `ug_expiry` (`ug_expiry`)
+) ENGINE=InnoDB DEFAULT CHARSET=binary;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `user_groups`
+--
+
+/*!40000 ALTER TABLE `user_groups` DISABLE KEYS */;
+INSERT INTO `user_groups` VALUES (504,'beauftragte',NULL);
+INSERT INTO `user_groups` VALUES (504,'sysop',NULL);
+/*!40000 ALTER TABLE `user_groups` ENABLE KEYS */;
+
 --
 -- Table structure for table `wrinncache`
 --
@@ -545,6 +571,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`
 --