From cfe03a71290047d34800058c4230140b9768010c Mon Sep 17 00:00:00 2001 From: Philipp Spitzer Date: Mon, 29 Jun 2020 21:59:11 +0200 Subject: [PATCH] Don't delete user 0. --- tests/testdb.md | 8 +++++++- tests/testdb.sql | 2 +- 2 files changed, 8 insertions(+), 2 deletions(-) diff --git a/tests/testdb.md b/tests/testdb.md index a0ce7d9..f3e923d 100644 --- 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 c303577..2dd2d77 100644 --- 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 */; -- -- 2.39.5