From d03fc9ae06765a6a22f4613992f7ffff59545e2c Mon Sep 17 00:00:00 2001 From: olivier Date: Mon, 6 Apr 2009 17:11:10 +0000 Subject: [PATCH] crem prototype import: do not import items with broken collection ref git-svn-id: http://svn.parisson.org/svn/crem@76 3bf09e05-f825-4182-b9bc-eedd7160adf0 --- trunk/import/prototype/scripts/crem-import.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/trunk/import/prototype/scripts/crem-import.sql b/trunk/import/prototype/scripts/crem-import.sql index 75c49cf..8cd853f 100644 --- a/trunk/import/prototype/scripts/crem-import.sql +++ b/trunk/import/prototype/scripts/crem-import.sql @@ -31,6 +31,8 @@ UPDATE telemeta_item SET etat=REPLACE(etat, ')', '_'); UPDATE telemeta_item SET etat=REPLACE(etat, '(', '_'); UPDATE telemeta_item SET file="items/test.wav"; +DELETE FROM telemeta_item WHERE collection_id NOT IN (SELECT id FROM telemeta_collection); + DELETE FROM telemeta_physicalformat; INSERT INTO telemeta_physicalformat (value) SELECT DISTINCT physical_format FROM telemeta_collection -- 2.39.5