From 6d42fb0e026cf397e886c68ae73e353b4411008c Mon Sep 17 00:00:00 2001 From: olivier Date: Thu, 24 May 2007 17:47:14 +0000 Subject: [PATCH] wipe ':' and '?' out of items IDs git-svn-id: http://svn.parisson.org/svn/crem@3 3bf09e05-f825-4182-b9bc-eedd7160adf0 --- scripts/import.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/scripts/import.sql b/scripts/import.sql index 78c2078..0bb05be 100644 --- a/scripts/import.sql +++ b/scripts/import.sql @@ -4,8 +4,6 @@ FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n'; UPDATE telemeta_collection SET id=REPLACE(id, '/', '--'); -UPDATE telemeta_item SET id=REPLACE(id, ":", "__"); - UPDATE telemeta_collection SET copied_from_id = NULL WHERE copied_from_id = ''; DELETE FROM telemeta_item; @@ -13,7 +11,9 @@ LOAD DATA INFILE '/tmp/crem_import/phono.txt' INTO TABLE telemeta_item FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n'; +UPDATE telemeta_item SET id=REPLACE(id, ":", "__"); UPDATE telemeta_item SET id=REPLACE(id, '/', '--'); +UPDATE telemeta_item SET id=REPLACE(id, '?', 'i'); UPDATE telemeta_item SET collection_id=REPLACE(collection_id, '/', '--'); UPDATE telemeta_item SET title='' WHERE title='N'; UPDATE telemeta_item SET etat=REPLACE(etat, ')', '_'); -- 2.39.5