Add wrregioncache to test table export.

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

diff --git a/tests/testdb.txt b/tests/testdb.txt
index d9e64f006765b0293cab21a8fe74d2deb9905e79..24ba2d276241216ab5f52d5f90c81009313f685b 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;
@@ -12,7 +12,8 @@ select * from wrregion;
 select * from wrsledruncache;
 select * from wrsledruncache where page_id = 926 or page_id in (select page_id from wrreport);
 delete from wrsledruncache where page_id != 926 and page_id not in (select page_id from wrreport);
+delete from wrregioncache where page_id != 926 and page_id not in (select page_id from wrreport);
 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 wrregioncache --skip-add-locks --skip-disable-keys --hex-blob > testdb.sql