Repository navigation
Expand file tree
/
Copy path40-clean-orphans.sql
More file actions
26 lines (23 loc) · 2.17 KB
/
Copy path40-clean-orphans.sql
File metadata and controls
26 lines (23 loc) · 2.17 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
BEGIN;
UPDATE movies c SET parent_id = NULL WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.parent_id);
DELETE FROM people_aliases c WHERE NOT EXISTS (SELECT * FROM people p WHERE p.id = c.person_id);
DELETE FROM people_links c WHERE NOT EXISTS (SELECT * FROM people p WHERE p.id = c.person_id);
DELETE FROM casts c WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.movie_id);
DELETE FROM movie_categories c WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.movie_id);
DELETE FROM movie_categories c WHERE NOT EXISTS (SELECT * FROM categories p WHERE p.id = c.category_id);
DELETE FROM category_names c WHERE NOT EXISTS (SELECT * FROM categories p WHERE p.id = c.category_id);
DELETE FROM movie_keywords c WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.movie_id);
DELETE FROM movie_keywords c WHERE NOT EXISTS (SELECT * FROM categories p WHERE p.id = c.category_id);
DELETE FROM trailers c WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.movie_id);
DELETE FROM movie_links c WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.movie_id);
DELETE FROM movie_aliases_iso c WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.movie_id);
DELETE FROM movie_languages c WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.movie_id);
DELETE FROM movie_countries c WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.movie_id);
DELETE FROM movie_references c WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.movie_id);
DELETE FROM movie_references c WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.movie_id);
DELETE FROM movie_references c WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.referenced_id);
DELETE FROM movie_abstracts_de c WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.movie_id);
DELETE FROM movie_abstracts_en c WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.movie_id);
DELETE FROM movie_abstracts_fr c WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.movie_id);
DELETE FROM movie_abstracts_es c WHERE NOT EXISTS (SELECT * FROM movies p WHERE p.id = c.movie_id);
COMMIT;