text: USE eve;
  
  DROP TABLE IF EXISTS `dentity`;
  DROP TABLE IF EXISTS `dlocation`;
  DROP VIEW IF EXISTS `vamarrbestsell`;
  DROP VIEW IF EXISTS `vamarrbestbuy`;
  DROP VIEW IF EXISTS `vjitabestsell`;
  DROP VIEW IF EXISTS `vjitabestbuy`;
  DROP TABLE IF EXISTS `mersinkfaucet`;
  DROP TABLE IF EXISTS `merregstat`;
  DROP TABLE IF EXISTS `merproddestmine`;
  DROP TABLE IF EXISTS `mermoneysupply`;
  DROP TABLE IF EXISTS `meriskvolume`;
  DROP TABLE IF EXISTS `insuranceprice`;
  DROP TABLE IF EXISTS `charorder`;
  DROP TABLE IF EXISTS `marketorder`;
  DROP TABLE IF EXISTS `marketstat`;
  DROP TABLE IF EXISTS `markethistory`;
  DROP TABLE IF EXISTS `contractitem`;
  DROP TABLE IF EXISTS `contract`;
  DROP TABLE IF EXISTS `corpcontractitem`;
  DROP TABLE IF EXISTS `corpcontract`;
  DROP TABLE IF EXISTS `contractavailability`;
  DROP TABLE IF EXISTS `contractstatus`;
  DROP TABLE IF EXISTS `contracttype`;
  DROP TABLE IF EXISTS `walletbalance`;
  DROP TABLE IF EXISTS `wallettransaction`;
  DROP TABLE IF EXISTS `walletjournal`;
  DROP TABLE IF EXISTS `apireq`;
  DROP TABLE IF EXISTS `tasklog`;
  DROP TABLE IF EXISTS `dirtstructauth`;
  DROP TABLE IF EXISTS `dirtapiauth`;
  DROP TABLE IF EXISTS `doctrine`;
  DROP TABLE IF EXISTS `dirtlistitem`;
  DROP TABLE IF EXISTS `dirtlist`;
  DROP TABLE IF EXISTS `dirtuser`;
  DROP TABLE IF EXISTS `kvstore`;
  DROP TABLE IF EXISTS `property`;
  DROP TABLE IF EXISTS `structure`;
  DROP TABLE IF EXISTS `character`;
  DROP TABLE IF EXISTS `corporation`;
  DROP TABLE IF EXISTS `alliance`;
  DROP TABLE IF EXISTS `marketgroup`;
  DROP TABLE IF EXISTS `invtype`;
  DROP TABLE IF EXISTS `station`;
  DROP TABLE IF EXISTS `solarsystem`;
  DROP TABLE IF EXISTS `constellation`;
  DROP TABLE IF EXISTS `region`;
  