Regenerate test data with MariaDB 10.3.

[philipp/winterrodeln/wrfeed.git] / tests / testdb.txt

diff --git a/tests/testdb.txt b/tests/testdb.txt
index d9e64f006765b0293cab21a8fe74d2deb9905e79..375fdfcfd2ded12d282510ab2df55328d4f6e535 100644 (file)
--- a/tests/testdb.txt
+++ b/tests/testdb.txt
@@ -3,7 +3,7 @@ How I crated the testdb.sql
 Work on a copy of the philipp_winterrodeln_wiki database:
 
 select * from philipp_winterrodeln_wiki.wrreport order by id desc limit 10;
-delete from wrreport where id < 19587;
+delete from wrreport where id < 19587 or id > 19596;
 select * from wrreport;
 update wrreport set author_ip = null, delete_person_ip = null;
 update wrreport set author_username = null where author_userid is null;
@@ -15,4 +15,4 @@ delete from wrsledruncache where page_id != 926 and page_id not in (select page_
 select * from wrsledruncache;
 
 
-mysqldump philipp_winterrodeln_wiki --skip-extended-insert --tables wrreport wrsledruncache wrregion --skip-add-locks --skip-disable-keys --skip-quote-names --hex-blob > testdb.sql
+mysqldump philipp_winterrodeln_wiki --skip-extended-insert --tables wrreport wrsledruncache wrregion --skip-add-locks --skip-disable-keys --hex-blob > testdb.sql