diff options
author | Yorhel <git@yorhel.nl> | 2019-08-21 20:28:04 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-08-21 20:28:04 +0200 |
commit | 7e7d9dd2d34dcc2ca95e7fb8a1d941b796b0b531 (patch) | |
tree | 9640d3de063559bc7cba263a556f98b9f2006799 /util | |
parent | 0e5d1bec9717d2f9344e7681465f21ff93706484 (diff) |
dbdump.pl: Make sure to include chars_vns relations with rid = NULL
Diffstat (limited to 'util')
-rwxr-xr-x | util/dbdump.pl | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/util/dbdump.pl b/util/dbdump.pl index acb5907a..d513c989 100755 --- a/util/dbdump.pl +++ b/util/dbdump.pl @@ -48,7 +48,7 @@ my %tables = ( chars_traits => { where => 'id IN(SELECT id FROM chars WHERE NOT hidden) AND tid IN(SELECT id FROM traits WHERE state = 2)' }, chars_vns => { where => 'id IN(SELECT id FROM chars WHERE NOT hidden)' .' AND vid IN(SELECT id FROM vn WHERE NOT hidden)' - .' AND rid IN(SELECT id FROM releases WHERE NOT hidden)' + .' AND (rid IS NULL OR rid IN(SELECT id FROM releases WHERE NOT hidden))' , order => 'id, vid, rid' }, docs => { where => 'NOT hidden' }, producers => { where => 'NOT hidden' }, |