rm_tables.sql

DROP TABLE sessions CASCADE;
DROP TABLE common CASCADE;
DROP TABLE aprsdb_errs CASCADE;
DROP TABLE location CASCADE;
DROP TABLE map_entry CASCADE;
DROP TABLE uncompressed CASCADE;
DROP TABLE compressed CASCADE;
DROP TABLE object CASCADE;
DROP TABLE mic_e CASCADE;
DROP TABLE message CASCADE;
DROP TABLE status CASCADE;
DROP TABLE wx CASCADE;
DROP TABLE thirdparty CASCADE;
DROP TABLE telemetry_message CASCADE;
DROP TABLE digis CASCADE;
DROP TABLE routes CASCADE;
DROP TABLE paths CASCADE;
DROP VIEW IF EXISTS rf_digi_counts;
DROP VIEW IF EXISTS wide3;
DROP VIEW IF EXISTS first_hops;
DROP VIEW IF EXISTS link_stats;
DROP VIEW IF EXISTS tx_igate_positions;
DROP VIEW IF EXISTS tx_igate_counts;
DROP VIEW IF EXISTS links_last_10;
DROP VIEW IF EXISTS links_last_60;
DROP VIEW IF EXISTS heard_digi;
DROP VIEW IF EXISTS heard_non_digi;
DROP INDEX location_idx;
DROP INDEX digi_spatial_idx;