18 lines
320 B
SQL
18 lines
320 B
SQL
PRAGMA foreign_keys = ON;
|
|
|
|
INSERT INTO movie_name_alias (
|
|
movie_id,
|
|
alias,
|
|
normalized_alias,
|
|
source
|
|
)
|
|
SELECT
|
|
id,
|
|
'Kittina Ivory',
|
|
'kittinaivory',
|
|
'manual'
|
|
FROM movie
|
|
WHERE id = 'kittina-clairette_7801'
|
|
AND name = 'Kittina Clairette'
|
|
ON CONFLICT (movie_id, normalized_alias) DO NOTHING;
|