diff options
author | Yorhel <git@yorhel.nl> | 2022-09-23 12:41:06 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2022-09-28 09:35:55 +0200 |
commit | fc923381de7dfed7de0969c35a5e010bd6055417 (patch) | |
tree | 93ddd42ae84a16ad083ca2128a20f5d69496475c /util | |
parent | 2c92964795a54b5e0de0b66b3c1c0bc6a4083555 (diff) |
WIP add language-specific titles to releases
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"; |