Add table user_groups to testdb.sql.

diff --git a/tests/testdb.md b/tests/testdb.md
index 7e71c988c2c3b5e14cd479eae1e17cce6fd51111..681e224d0e12ed9595e655cf118ec2c6135ad824 100644 (file)
--- a/tests/testdb.md
+++ b/tests/testdb.md
@@ -70,7 +70,6 @@ transcache,
 updatelog,
 uploadstash,
 user_former_groups,
 updatelog,
 uploadstash,
 user_former_groups,

-user_groups,

 user_newtalk,
 user_openid,
 user_properties,
 user_newtalk,
 user_openid,
 user_properties,


@@ -90,6 +89,7 @@ page
 revision
 text
 user
 revision
 text
 user

+user_groups

 wrinncache
 wrregion
 wrregioncache
 wrinncache
 wrregion
 wrregioncache


@@ -167,8 +167,9 @@ Only keep relevant data in table `text`:
 DELETE FROM `text` WHERE old_id NOT IN (SELECT rev_text_id FROM revision);
 ```
 
 DELETE FROM `text` WHERE old_id NOT IN (SELECT rev_text_id FROM revision);
 ```
 

-Drop all entries from table `user`:
+Drop all entries from table `user` and `user_groups`:

 ```{sql}
 ```{sql}

+DELETE FROM `user_groups`;

 DELETE FROM `user` WHERE user_id != 0;
 ```
 
 DELETE FROM `user` WHERE user_id != 0;
 ```
 


@@ -189,6 +190,9 @@ Insert previously deleted values:
 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 (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_groups` VALUES (504,'beauftragte',NULL);
+INSERT INTO `user_groups` VALUES (504,'sysop',NULL);
+

 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 (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);

diff --git a/tests/testdb.sql b/tests/testdb.sql
index b9ac2cb59975804927486c3eb84c8419a82f0177..8c45773e8b45225ab462e4317fb4b8eaba536e99 100644 (file)
--- a/tests/testdb.sql
+++ b/tests/testdb.sql
@@ -335,6 +335,32 @@ INSERT INTO `user` VALUES (504,'Johndoe','John Doe',':pbkdf2:sha512:30000:64:hvq
 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 */;
 
 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`
 --
 --
 -- Table structure for table `wrinncache`
 --