Don't delete user 0.

diff --git a/tests/testdb.md b/tests/testdb.md
index a0ce7d9e35870a3448b600d131246588f3371a73..f3e923d4e35618e5ffce2258f779921c4e198fe8 100644 (file)
--- a/tests/testdb.md
+++ b/tests/testdb.md
@@ -169,7 +169,7 @@ DELETE FROM `text` WHERE old_id NOT IN (SELECT rev_text_id FROM revision);
 
 Drop all entries from table `user`:
 ```{sql}
-DELETE FROM `user`;
+DELETE FROM `user` WHERE user_id != 0;
 ```
 
 
@@ -183,6 +183,12 @@ DELETE FROM wrregioncache;
 DELETE FROM wrregion;
 ```
 
+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);
+```
+
 
 Export data to SQL:
 

diff --git a/tests/testdb.sql b/tests/testdb.sql
index c3035779dc2d15e6acddac6b7808b7558a40aa80..2dd2d77434bc82224d2a54f9b12c2c1b28a0f336 100644 (file)
--- a/tests/testdb.sql
+++ b/tests/testdb.sql
@@ -330,9 +330,9 @@ 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 */;
 
 --