| [vhffs-dev] [2296] compat: remove mail localpart with no child ( the mailing list removal function forgot to remove the localpart entry if necessary ) |
[ Thread Index |
Date Index
| More vhffs.org/vhffs-dev Archives
]
- To: vhffs-dev@xxxxxxxxx
- Subject: [vhffs-dev] [2296] compat: remove mail localpart with no child ( the mailing list removal function forgot to remove the localpart entry if necessary )
- From: subversion@xxxxxxxxxxxxx
- Date: Sun, 07 Feb 2016 01:27:22 +0100
Revision: 2296
Author: gradator
Date: 2016-02-07 01:27:21 +0100 (Sun, 07 Feb 2016)
Log Message:
-----------
compat: remove mail localpart with no child (the mailing list removal function forgot to remove the localpart entry if necessary)
Added Paths:
-----------
trunk/vhffs-compat/from-4.5-to-4.6.sql
Added: trunk/vhffs-compat/from-4.5-to-4.6.sql
===================================================================
--- trunk/vhffs-compat/from-4.5-to-4.6.sql (rev 0)
+++ trunk/vhffs-compat/from-4.5-to-4.6.sql 2016-02-07 00:27:21 UTC (rev 2296)
@@ -0,0 +1,2 @@
+-- Remove mail localpart with no child (the mailing list removal function forgot to remove the localpart entry if necessary)
+DELETE FROM vhffs_mx_localpart WHERE localpart_id NOT IN ( SELECT localpart_id FROM vhffs_mx_box UNION SELECT localpart_id FROM vhffs_mx_redirect UNION SELECT localpart_id FROM vhffs_mx_ml );