cmsPRO/updates/1.50/ver_1.582_sql.txt

ALTER TABLE pp_users_privileges ADD INDEX(id_user);
DELETE FROM pp_users_privileges WHERE id_user_id NOT IN ( SELECT id FROM pp_users );
ALTER TABLE pp_users_privileges ADD FOREIGN KEY (id_user) REFERENCES pp_users(id) ON DELETE CASCADE ON UPDATE CASCADE;