[PATCH] migrations: Fix 0010 reversion

[Stephen Finucane]

The syntax previously used was not compatible with MySQL. Replace with
a simpler, more broadly supported version using JOINs.

Signed-off-by: Stephen Finucane <stephen.finucane at intel.com>
---
 .../0010_migrate_data_from_submission_to_patch.py  |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/patchwork/migrations/0010_migrate_data_from_submission_to_patch.py b/patchwork/migrations/0010_migrate_data_from_submission_to_patch.py
index 1d4b6e1..00669dd 100644
--- a/patchwork/migrations/0010_migrate_data_from_submission_to_patch.py
+++ b/patchwork/migrations/0010_migrate_data_from_submission_to_patch.py
@@ -19,12 +19,12 @@ class Migration(migrations.Migration):
                        archived, hash
                 FROM patchwork_submission
                 '''],
-            ['''UPDATE patchwork_submission SET
+            ['''UPDATE patchwork_submission t1
+                INNER JOIN patchwork_patch t2 ON t1.id = t2.submission_ptr_id
+                SET
                   diff=diff2, commit_ref=commit_ref2, pull_url=pull_url2,
                   delegate_id=delegate2_id, state_id=state2_id,
                   archived=archived2, hash=hash2
-                FROM patchwork_patch WHERE
-                  patchwork_submission.id = patchwork_patch.submission_ptr_id
                 ''']
         ),
     ]
-- 
1.7.4.1