Typo and manual on cascade delete for pseudo FK.

[platal.git] / upgrade / 1.1.14 / 02_delete_unlinked_rows.sql

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 (file)
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;