aboutsummaryrefslogtreecommitdiffstats
path: root/tests/functions_user/fixtures
diff options
context:
space:
mode:
authorJoas Schilling <nickvergessen@gmx.de>2014-09-22 01:42:36 +0200
committerJoas Schilling <nickvergessen@gmx.de>2014-09-22 01:42:36 +0200
commitd7c12ccd6067a74ca24fe9cec872c29b94ce13b2 (patch)
treedb6a60378c1a0594a19f5fb3cdf65ebffbb4d64c /tests/functions_user/fixtures
parent74854ac65d6d98a30cc34cbbcf6fdddb0c8f7cf0 (diff)
downloadforums-d7c12ccd6067a74ca24fe9cec872c29b94ce13b2.tar
forums-d7c12ccd6067a74ca24fe9cec872c29b94ce13b2.tar.gz
forums-d7c12ccd6067a74ca24fe9cec872c29b94ce13b2.tar.bz2
forums-d7c12ccd6067a74ca24fe9cec872c29b94ce13b2.tar.xz
forums-d7c12ccd6067a74ca24fe9cec872c29b94ce13b2.zip
[ticket/10729] Add tests for some special tables with unique conditions
PHPBB3-10729
Diffstat (limited to 'tests/functions_user/fixtures')
-rw-r--r--tests/functions_user/fixtures/delete_user.xml157
1 files changed, 156 insertions, 1 deletions
diff --git a/tests/functions_user/fixtures/delete_user.xml b/tests/functions_user/fixtures/delete_user.xml
index 36e634229f..8efa05f467 100644
--- a/tests/functions_user/fixtures/delete_user.xml
+++ b/tests/functions_user/fixtures/delete_user.xml
@@ -6,24 +6,64 @@
<column>topic_id</column>
<column>in_message</column>
<column>poster_id</column>
+ <column>is_orphan</column>
<column>attach_comment</column>
<row>
<value>1</value>
<value>1</value>
<value>1</value>
- <value>1</value>
+ <value>0</value>
<value>2</value>
+ <value>0</value>
<value></value>
</row>
<row>
<value>2</value>
<value>2</value>
<value>2</value>
+ <value>0</value>
<value>1</value>
+ <value>0</value>
+ <value></value>
+ </row>
+ <row>
+ <value>3</value>
+ <value>0</value>
+ <value>0</value>
+ <value>0</value>
+ <value>2</value>
<value>1</value>
<value></value>
</row>
</table>
+ <table name="phpbb_banlist">
+ <column>ban_id</column>
+ <column>ban_userid</column>
+ <column>ban_email</column>
+ <column>ban_reason</column>
+ <column>ban_give_reason</column>
+ <row>
+ <value>1</value>
+ <value>2</value>
+ <value></value>
+ <value></value>
+ <value></value>
+ </row>
+ <row>
+ <value>2</value>
+ <value>3</value>
+ <value></value>
+ <value></value>
+ <value></value>
+ </row>
+ <row>
+ <value>3</value>
+ <value>0</value>
+ <value></value>
+ <value></value>
+ <value></value>
+ </row>
+ </table>
<table name="phpbb_forums">
<column>forum_id</column>
<column>forum_last_poster_id</column>
@@ -69,6 +109,41 @@
<value></value>
</row>
</table>
+ <table name="phpbb_log">
+ <column>log_id</column>
+ <column>user_id</column>
+ <column>reportee_id</column>
+ <column>log_operation</column>
+ <column>log_data</column>
+ <row>
+ <value>1</value>
+ <value>1</value>
+ <value>2</value>
+ <value></value>
+ <value></value>
+ </row>
+ <row>
+ <value>2</value>
+ <value>2</value>
+ <value>1</value>
+ <value></value>
+ <value></value>
+ </row>
+ <row>
+ <value>3</value>
+ <value>1</value>
+ <value>1</value>
+ <value></value>
+ <value></value>
+ </row>
+ <row>
+ <value>4</value>
+ <value>2</value>
+ <value>2</value>
+ <value></value>
+ <value></value>
+ </row>
+ </table>
<table name="phpbb_posts">
<column>post_id</column>
<column>poster_id</column>
@@ -129,6 +204,55 @@
<value>1</value>
</row>
</table>
+ <table name="phpbb_privmsgs">
+ <column>msg_id</column>
+ <column>author_id</column>
+ <column>message_edit_user</column>
+ <column>message_text</column>
+ <column>to_address</column>
+ <column>bcc_address</column>
+ <row>
+ <value>1</value>
+ <value>3</value>
+ <value>3</value>
+ <value></value>
+ <value></value>
+ <value></value>
+ </row>
+ <row>
+ <value>2</value>
+ <value>2</value>
+ <value>2</value>
+ <value></value>
+ <value></value>
+ <value></value>
+ </row>
+ </table>
+ <table name="phpbb_privmsgs_to">
+ <column>msg_id</column>
+ <column>user_id</column>
+ <column>author_id</column>
+ <row>
+ <value>1</value>
+ <value>3</value>
+ <value>3</value>
+ </row>
+ <row>
+ <value>1</value>
+ <value>2</value>
+ <value>3</value>
+ </row>
+ <row>
+ <value>2</value>
+ <value>3</value>
+ <value>2</value>
+ </row>
+ <row>
+ <value>2</value>
+ <value>2</value>
+ <value>2</value>
+ </row>
+ </table>
<table name="phpbb_reports">
<column>report_id</column>
<column>post_id</column>
@@ -159,6 +283,21 @@
<value>Remove Report</value>
</row>
</table>
+ <table name="phpbb_sessions">
+ <column>session_id</column>
+ <column>session_user_id</column>
+ <column>session_page</column>
+ <row>
+ <value>12345678901234567890123456789012</value>
+ <value>2</value>
+ <value></value>
+ </row>
+ <row>
+ <value>12345678901234567890123456789013</value>
+ <value>3</value>
+ <value></value>
+ </row>
+ </table>
<table name="phpbb_topics">
<column>topic_id</column>
<column>forum_id</column>
@@ -241,4 +380,20 @@
<value>2</value>
</row>
</table>
+ <table name="phpbb_zebra">
+ <column>user_id</column>
+ <column>zebra_id</column>
+ <row>
+ <value>1</value>
+ <value>2</value>
+ </row>
+ <row>
+ <value>1</value>
+ <value>3</value>
+ </row>
+ <row>
+ <value>2</value>
+ <value>1</value>
+ </row>
+ </table>
</dataset>