alter table av_families drop primary key;
alter table av_families add column id int unsigned primary key auto_increment;
alter table av_families_nameid_list drop primary key;
alter table av_families_nameid_list add column id int unsigned primary key auto_increment;
alter table av_names drop primary key;
alter table av_names add column id int unsigned primary key auto_increment;
alter table av_results drop primary key;
alter table av_results add column id int unsigned primary key auto_increment;
alter table malware_callouts drop primary key;
alter table malware_callouts add column id int unsigned primary key auto_increment;
alter table malware_callouts_dark_comet drop primary key;
alter table malware_callouts_dark_comet add column id int unsigned primary key auto_increment;
alter table malware_callouts_false_positives drop primary key;
alter table malware_callouts_false_positives add column id int unsigned primary key auto_increment;
alter table malware_callouts_indexchanges_test drop primary key;
alter table malware_callouts_indexchanges_test add column id int unsigned primary key auto_increment;
alter table malware_callouts_live_pcaps drop primary key;
alter table malware_callouts_live_pcaps add column id int unsigned primary key auto_increment;
alter table malware_callouts_live_tests drop primary key;
alter table malware_callouts_live_tests add column id int unsigned primary key auto_increment;
alter table malware_callouts_test drop primary key;
alter table malware_callouts_test add column id int unsigned primary key auto_increment;
alter table malware_families drop primary key;
alter table malware_families add column id int unsigned primary key auto_increment;
alter table malware_hash drop primary key;
alter table malware_hash add column id int unsigned primary key auto_increment;
alter table malware_pendora_host drop primary key;
alter table malware_pendora_host add column id int unsigned primary key auto_increment;
alter table malware_pendora_ip drop primary key;
alter table malware_pendora_ip add column id int unsigned primary key auto_increment;
alter table malware_upatre_decrypter drop primary key;
alter table malware_upatre_decrypter add column id int unsigned primary key auto_increment;
alter table malware_yara drop primary key;
alter table malware_yara add column id int unsigned primary key auto_increment;
alter table malware_yara_runtime drop primary key;
alter table malware_yara_runtime add column id int unsigned primary key auto_increment;
alter table md5_cve drop primary key;
alter table md5_cve add column id int unsigned primary key auto_increment;
alter table mop_list drop primary key;
alter table mop_list add column id int unsigned primary key auto_increment;
alter table mop_type_version drop primary key;
alter table mop_type_version add column id int unsigned primary key auto_increment;
alter table tags_md5s drop primary key;
alter table tags_md5s add column id int unsigned primary key auto_increment;
alter table tags_user_added drop primary key;
alter table tags_user_added add column id int unsigned primary key auto_increment;
alter table upatre_payload_families drop primary key;
alter table upatre_payload_families add column id int unsigned primary key auto_increment;
alter table url_list_phish_tt2 drop primary key;
alter table url_list_phish_tt2 add column id int unsigned primary key auto_increment;
alter table url_list_tt2 drop primary key;
alter table url_list_tt2 add column id int unsigned primary key auto_increment;
alter table vt_reports drop primary key;
alter table vt_reports add column id int unsigned primary key auto_increment;
alter table vt_reports_empty drop primary key;
alter table vt_reports_empty add column id int unsigned primary key auto_increment;
alter table weekly_stats_cache drop primary key;
alter table weekly_stats_cache add column id int unsigned primary key auto_increment;
alter table weekly_top_malware_cache drop primary key;
alter table weekly_top_malware_cache add column id int unsigned primary key auto_increment;
alter table yara_malware_families drop primary key;
alter table yara_malware_families add column id int unsigned primary key auto_increment;