changeset 6621 | 11c09415078b |
child 6622 | 27402fe6a94a |
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/misc/migration/3.10.5_Any.py Mon Oct 25 15:30:50 2010 +0200 @@ -0,0 +1,5 @@ + +sql('INSERT INTO cw_source_relation(eid_from, eid_to) ' + 'SELECT e.eid,s.cw_eid FROM entities as e, cw_CWSource as s ' + 'WHERE s.cw_name=e.source AND NOT EXISTS(SELECT 1 FROM cw_source_relation WHERE eid_from=e.eid AND eid_to=s.cw_eid)') +commit()