DROP TABLE plant_status_history;
DROP TABLE application_settings;
DROP TABLE journal_attachments;
DROP TABLE journal_entry_tags;
DROP TABLE journal_entries;
DROP TABLE entity_image_history;

ALTER TABLE locations DROP COLUMN image_id;
ALTER TABLE plants DROP COLUMN image_id;
ALTER TABLE species DROP COLUMN image_id;
ALTER TABLE gardens DROP COLUMN image_id;
DROP TABLE images;

DROP TABLE species_tags;
DROP TABLE plant_tags;
DROP TABLE task_tags;
DROP TABLE tags;
DROP TABLE task_priorities;
DROP TABLE task_template_opt_outs;
DROP TABLE tasks;
DROP TABLE plant_locations;
DROP TABLE plants;
DROP TABLE locations;
DROP TABLE species_task_templates;
DROP TABLE care_instructions;
DROP TABLE species;
DROP TABLE species_categories;
DROP TABLE garden_role_permission_overrides;
DROP TABLE garden_invites;
DROP TABLE garden_members;

ALTER TABLE users DROP CONSTRAINT users_application_role_fkey;
DROP TABLE role_permissions;
DROP TABLE roles;
DROP TABLE gardens;
DROP TABLE user_email_changes;
DROP TABLE tokens;
DROP TABLE sessions;
DROP TABLE users;

DROP TYPE task_template_origin;
DROP TYPE task_trigger_type;
DROP TYPE care_instruction_status;
DROP TYPE plant_status;
DROP TYPE plant_lifecycle;
DROP TYPE soil_reaction;
DROP TYPE soil_condition;
DROP TYPE sun_exposure;
DROP EXTENSION citext;