drop.sql

DROP EXTENSION IF EXISTS pg_trgm CASCADE;
DROP EXTENSION IF EXISTS plpython3u CASCADE;
DROP EXTENSION IF EXISTS postgis CASCADE;
DROP EXTENSION IF EXISTS vector CASCADE;
DROP FUNCTION IF EXISTS answer_score_vectors(INT, BOOLEAN) CASCADE;
DROP FUNCTION IF EXISTS array_full(INT, FLOAT4) CASCADE;
DROP FUNCTION IF EXISTS array_full(INT, INT) CASCADE;
DROP FUNCTION IF EXISTS clamp(FLOAT, FLOAT, FLOAT) CASCADE;
DROP FUNCTION IF EXISTS compute_personality_vectors(INT[], INT[], INT[], INT[], INT[], INT[], SMALLINT) CASCADE;
DROP FUNCTION IF EXISTS insert_into_search_tables CASCADE;
DROP FUNCTION IF EXISTS trait_ratio(INT[], INT[], INT) CASCADE;
DROP FUNCTION IF EXISTS update_search_tables CASCADE;
DROP TABLE IF EXISTS answer CASCADE;
DROP TABLE IF EXISTS duo_session CASCADE;
DROP TABLE IF EXISTS ethnicity CASCADE;
DROP TABLE IF EXISTS frequency CASCADE;
DROP TABLE IF EXISTS gender CASCADE;
DROP TABLE IF EXISTS immediacy CASCADE;
DROP TABLE IF EXISTS location CASCADE;
DROP TABLE IF EXISTS looking_for CASCADE;
DROP TABLE IF EXISTS messaged CASCADE;
DROP TABLE IF EXISTS onboardee CASCADE;
DROP TABLE IF EXISTS onboardee_photo CASCADE;
DROP TABLE IF EXISTS onboardee_search_preference_gender CASCADE;
DROP TABLE IF EXISTS orientation CASCADE;
DROP TABLE IF EXISTS person CASCADE;
DROP TABLE IF EXISTS photo CASCADE;
DROP TABLE IF EXISTS question CASCADE;
DROP TABLE IF EXISTS question_order CASCADE;
DROP TABLE IF EXISTS relationship_status CASCADE;
DROP TABLE IF EXISTS religion CASCADE;
DROP TABLE IF EXISTS search_cache CASCADE;
DROP TABLE IF EXISTS search_for_quiz_prospects;
DROP TABLE IF EXISTS search_for_standard_prospects;
DROP TABLE IF EXISTS search_preference_age CASCADE;
DROP TABLE IF EXISTS search_preference_answer CASCADE;
DROP TABLE IF EXISTS search_preference_distance CASCADE;
DROP TABLE IF EXISTS search_preference_drinking CASCADE;
DROP TABLE IF EXISTS search_preference_drugs CASCADE;
DROP TABLE IF EXISTS search_preference_ethnicity CASCADE;
DROP TABLE IF EXISTS search_preference_exercise CASCADE;
DROP TABLE IF EXISTS search_preference_gender CASCADE;
DROP TABLE IF EXISTS search_preference_has_kids CASCADE;
DROP TABLE IF EXISTS search_preference_has_profile_picture CASCADE;
DROP TABLE IF EXISTS search_preference_height_cm CASCADE;
DROP TABLE IF EXISTS search_preference_long_distance CASCADE;
DROP TABLE IF EXISTS search_preference_looking_for CASCADE;
DROP TABLE IF EXISTS search_preference_messaged CASCADE;
DROP TABLE IF EXISTS search_preference_orientation CASCADE;
DROP TABLE IF EXISTS search_preference_relationship_status CASCADE;
DROP TABLE IF EXISTS search_preference_religion CASCADE;
DROP TABLE IF EXISTS search_preference_smoking CASCADE;
DROP TABLE IF EXISTS search_preference_star_sign CASCADE;
DROP TABLE IF EXISTS search_preference_wants_kids CASCADE;
DROP TABLE IF EXISTS star_sign CASCADE;
DROP TABLE IF EXISTS trait CASCADE;
DROP TABLE IF EXISTS trait_topic CASCADE;
DROP TABLE IF EXISTS unit CASCADE;
DROP TABLE IF EXISTS yes_no CASCADE;
DROP TABLE IF EXISTS yes_no_maybe CASCADE;
DROP TABLE IF EXISTS yes_no_optional CASCADE;
DROP TRIGGER IF EXISTS insert_or_update_search_tables ON person CASCADE;
DROP TYPE IF EXISTS answer_score_vectors CASCADE;
DROP TYPE IF EXISTS personality_vectors CASCADE;