DROP TABLE IF EXISTS consignmentdoctypes;
DROP TABLE IF EXISTS packagetypes;
DROP TABLE IF EXISTS user_packhouse;
DROP TABLE IF EXISTS user_exporter;
DROP TABLE IF EXISTS packhouse_exporter;
DROP TABLE IF EXISTS user_zones;
DROP TABLE IF EXISTS reasonrejections;
DROP TABLE IF EXISTS rejections;
DROP TABLE IF EXISTS exporter_packhouse;
DROP TABLE IF EXISTS redflags;
DROP TABLE IF EXISTS packinglist_products;
DROP TABLE IF EXISTS packinglist_batch;
DROP TABLE IF EXISTS packinglist_others;
DROP TABLE IF EXISTS packinglist;
DROP TABLE IF EXISTS reception_attributes;
DROP TABLE IF EXISTS reception_documents;
DROP TABLE IF EXISTS reception_otherdocuments;
DROP TABLE IF EXISTS receptionform_qrcodes;
DROP TABLE IF EXISTS receptionform;
DROP TABLE IF EXISTS consignment_queries;
DROP TABLE IF EXISTS plannedconsignments_tpdetails;
DROP TABLE IF EXISTS plannedconsignments_documents;
DROP TABLE IF EXISTS plannedconsignments_otherdocuments;
DROP TABLE IF EXISTS order_crops;
DROP TABLE IF EXISTS orders;
DROP TABLE IF EXISTS plannedconsignments;
DROP TABLE IF EXISTS farmer_contacts;
DROP TABLE IF EXISTS farmer_farms;
DROP TABLE IF EXISTS farmer_produce;
DROP TABLE IF EXISTS farmers;
DROP TABLE IF EXISTS crops;
DROP TABLE IF EXISTS rejections;
DROP TABLE IF EXISTS consignmentrejections;
DROP TABLE IF EXISTS consignmentreasonrejections;
DROP TABLE IF EXISTS exithandlers;
DROP TABLE IF EXISTS exitpoints;
DROP TABLE IF EXISTS airlines;
DROP TABLE IF EXISTS modesoftransport;
DROP TABLE IF EXISTS qualityattributes;
DROP TABLE IF EXISTS productdoctypes;
DROP TABLE IF EXISTS clients;
DROP TABLE IF EXISTS countries;
DROP TABLE IF EXISTS zones;
DROP TABLE IF EXISTS packhouses;
DROP TABLE IF EXISTS role_permissions;
DROP TABLE IF EXISTS user_roles;
DROP TABLE IF EXISTS users;
DROP TABLE IF EXISTS roles;
DROP TABLE IF EXISTS exportcompanies;
DROP TABLE IF EXISTS villages;
DROP TABLE IF EXISTS parishes;
DROP TABLE IF EXISTS districts;
DROP TABLE IF EXISTS subcounties;








