upd_dev_collection.php 622 Bytes
Newer Older
1
2
3
4
5
6
7
8
9
10
<?php

if(!defined('INSTALLER_RUN')) die('Patch update file access violation.');

class upd_0094 extends installer_patch_update {

	public function onBeforeSQL() {
		global $inst;

		// Remove any duplicate mail_forwardings prior to adding unique key
11
		//$inst->db->query("DELETE FROM mail_forwarding WHERE forwarding_id NOT IN (SELECT MIN(forwarding_id) FROM mail_forwarding GROUP BY source)");
12
13
14

		// Remove any duplicate mail_transports prior to adding unique key
		$inst->db->query("DELETE FROM mail_transport WHERE transport_id NOT IN (SELECT MIN(transport_id) FROM mail_transport GROUP BY domain, server_id)");
15
16
17
	}

}