BiTel

-- #BLOCK#
CREATE TEMPORARY TABLE user_dispatch_reference_temp (mid int(3) unsigned DEFAULT '0', module varchar(30) NOT NULL DEFAULT '', title varchar(100) NOT NULL DEFAU
LT '', class_name varchar(200) NOT NULL DEFAULT '', web_action varchar(200) NOT NULL DEFAULT '');
INSERT INTO `user_dispatch_reference_temp` VALUES (mid, module, title, class_name, web_action ) VALUES( $mid, "ipn", "пЮЯЯШКЙЮ РПЮТХЙЮ IPN", "bitel.billing.ser
ver.ipn.bean.DispatchTrafficIpn", "DispatchTrafficIpn");
INSERT INTO user_dispatch_reference (mid, module, title, class_name, web_action) SELECT t.mid, t.module, t.title, t.class_name, t.web_action FROM user_dispatch
_reference_temp as t LEFT OUTER JOIN user_dispatch_reference as r on r.mid=t.mid AND r.module=t.module AND r.title=t.title AND r.class_name=t.class_name AND r.
web_action=t.web_action WHERE r.mid IS NULL;
-- #ENDB#