X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F1.1.14%2F02_delete_unlinked_rows.sql;fp=upgrade%2F1.1.14%2F02_delete_unlinked_rows.sql;h=4d878c0d156eac66c9eb89d3425f98e834f7ce3a;hb=5f801551699f37f60b17a124ee6530216bf3c048;hp=0000000000000000000000000000000000000000;hpb=26eeea122998363afb47e36dd254f728e8073ca4;p=platal.git

diff --git a/upgrade/1.1.14/02_delete_unlinked_rows.sql b/upgrade/1.1.14/02_delete_unlinked_rows.sql
new file mode 100644
index 0000000..4d878c0
--- /dev/null
+++ b/upgrade/1.1.14/02_delete_unlinked_rows.sql
@@ -0,0 +1,7 @@
+DELETE * FROM profile_addresses WHERE pid = 44872 AND jobid = 0 AND groupid = 0 AND type = 'home' AND id = 0;
+DELETE * FROM profile_addresses WHERE pid = 16669 AND jobid = 0 AND groupid = 0 AND type = 'job' AND id = 0;
+DELETE * FROM profile_addresses WHERE pid = 44872 AND jobid = 0 AND groupid = 0 AND type = 'job' AND id = 0;
+DELETE * FROM profile_phones WHERE pid = 16669 AND link_type = 'pro' AND link_id = 0 AND tel_id = 0;
+DELETE * FROM profile_phones WHERE pid = 44872 AND link_type = 'pro' AND link_id = 0 AND tel_id = 0;
+DELETE * FROM profile_phones WHERE pid = 44872 AND link_type = 'user' AND link_id = 0 AND tel_id = 0;
+DELETE * FROM profile_phones WHERE pid = 44872 AND link_type = 'user' AND link_id = 0 AND tel_id = 1;