summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-09-23 12:41:06 +0200
committerYorhel <git@yorhel.nl>2022-09-28 09:35:55 +0200
commitfc923381de7dfed7de0969c35a5e010bd6055417 (patch)
tree93ddd42ae84a16ad083ca2128a20f5d69496475c /util
parent2c92964795a54b5e0de0b66b3c1c0bc6a4083555 (diff)
WIP add language-specific titles to releases
Diffstat (limited to 'util')
-rwxr-xr-xutil/dbdump.pl2
-rwxr-xr-xutil/devdump.pl2
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";