DROP TYPE debversion CASCADE;
DROP FUNCTION ddtplanguagemaxversion(text);
DROP FUNCTION dsa_kill_all_idle_transactions();
DROP AGGREGATE array_accum(anyelement);
DROP PROCEDURAL LANGUAGE plperl;
DROP PROCEDURAL LANGUAGE plpgsql;
DROP TYPE bugs_severity CASCADE;
DROP TYPE ddtprecordtype CASCADE;
DROP TYPE dehs_status CASCADE;
DROP TYPE lintian_tagtype CASCADE;
DROP TYPE release CASCADE;
DROP VIEW active_dds;
DROP VIEW all_bugs;
DROP VIEW all_packages;
DROP VIEW all_packages_distrelcomparch;
DROP VIEW all_sources;
DROP VIEW bugs_count;
DROP VIEW upload_history_nmus;
DROP VIEW bapase;
DROP VIEW bugs_rt_affects_stable;
DROP VIEW bugs_rt_affects_testing;
DROP VIEW bugs_rt_affects_testing_and_unstable;
DROP VIEW bugs_rt_affects_unstable;
DROP VIEW really_active_dds;
DROP TABLE carnivore_keys;
DROP TABLE carnivore_login;
DROP TABLE archived_bugs;
DROP TABLE bugs;
DROP TABLE packages;
DROP TABLE ubuntu_packages;
DROP TABLE packages_distrelcomparch;
DROP TABLE ubuntu_packages_distrelcomparch;
DROP TABLE sources;
DROP TABLE ubuntu_sources;
DROP TABLE archived_bugs_fixed_in;
DROP TABLE archived_bugs_found_in;
DROP TABLE archived_bugs_merged_with;
DROP TABLE archived_bugs_packages;
DROP TABLE archived_bugs_tags;
DROP TABLE bugs_merged_with;
DROP TABLE migrations;
DROP TABLE orphaned_packages;
DROP TABLE popcon_src;
DROP TABLE upload_history;
DROP TABLE bugs_fixed_in;
DROP TABLE bugs_found_in;
DROP TABLE bugs_packages;
DROP TABLE bugs_tags;
DROP TABLE packages_summary;
DROP TABLE bugs_usertags;
DROP TABLE carnivore_emails;
DROP TABLE carnivore_names;
DROP TABLE ddtp;
DROP TABLE debtags;
DROP TABLE dehs;
DROP TABLE ldap;
DROP TABLE lintian;
DROP TABLE new_packages;
DROP TABLE new_sources;
DROP TABLE popcon;
DROP TABLE popcon_src_average;
DROP TABLE screenshots;
DROP TABLE ubuntu_bugs;
DROP TABLE ubuntu_bugs_duplicates;
DROP TABLE ubuntu_bugs_subscribers;
DROP TABLE ubuntu_bugs_tags;
DROP TABLE ubuntu_bugs_tasks;
DROP TABLE ubuntu_packages_summary;
DROP TABLE ubuntu_popcon;
DROP TABLE ubuntu_popcon_src;
DROP TABLE ubuntu_popcon_src_average;
DROP TABLE ubuntu_uploaders;
DROP TABLE upload_history_architecture;
DROP TABLE upload_history_closes;
DROP TABLE uploaders;