diff options
Diffstat (limited to 'util')
| -rwxr-xr-x | util/dbdump.pl | 2 | ||||
| -rwxr-xr-x | util/devdump.pl | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/util/dbdump.pl b/util/dbdump.pl index 01c1ba98..fb51bc41 100755 --- a/util/dbdump.pl +++ b/util/dbdump.pl @@ -70,10 +70,10 @@ my %tables = ( producers_relations => { where => 'id IN(SELECT id FROM producers WHERE NOT hidden)' }, quotes => { where => 'vid IN(SELECT id FROM vn WHERE NOT hidden)' }, releases => { where => 'NOT hidden' }, - releases_lang => { where => 'id IN(SELECT id FROM releases WHERE NOT hidden)' }, releases_media => { where => 'id IN(SELECT id FROM releases WHERE NOT hidden)' }, releases_platforms => { where => 'id IN(SELECT id FROM releases WHERE NOT hidden)' }, releases_producers => { where => 'id IN(SELECT id FROM releases WHERE NOT hidden) AND pid IN(SELECT id FROM producers WHERE NOT hidden)' }, + releases_titles => { where => 'id IN(SELECT id FROM releases WHERE NOT hidden)' }, releases_vn => { where => 'id IN(SELECT id FROM releases WHERE NOT hidden) AND vid IN(SELECT id FROM vn WHERE NOT hidden)' }, rlists => { where => 'EXISTS(SELECT 1 FROM releases r' .' JOIN releases_vn rv ON rv.id = r.id' diff --git a/util/devdump.pl b/util/devdump.pl index 43dff1ec..ae19a6e8 100755 --- a/util/devdump.pl +++ b/util/devdump.pl @@ -171,7 +171,7 @@ sub copy_entry { copy ulist_vns_labels => "SELECT vid, uid, 7 AS lbl FROM ($votes) x", {uid => 'user'}; # Releases - copy_entry [qw/releases releases_lang releases_media releases_platforms releases_producers releases_vn/], $releases; + copy_entry [qw/releases releases_media releases_platforms releases_producers releases_titles releases_vn/], $releases; print "\\i sql/tableattrs.sql\n"; print "\\i sql/triggers.sql\n"; |