drop table freguesias;
drop table concelhos;
drop table distritos;
drop table listas;
drop table votacoes;
drop table participacoes;
drop table partidos;

drop TABLE XOCORRENCIAS;
drop TABLE XUCS;
drop TABLE XTIPOSAULA;
drop TABLE XDSD;
drop TABLE XDOCENTES;

drop TABLE yOCORRENCIAS;
drop TABLE yUCS;
drop TABLE yTIPOSAULA;
drop TABLE yDSD;
drop TABLE yDOCENTES;


DROP TABLE Xlics;
DROP TABLE Xcands;
DROP TABLE Xalus;
DROP TABLE Xanos;

DROP TABLE Ylics;
DROP TABLE Ycands;
DROP TABLE Yalus;
DROP TABLE Yanos;

DROP TABLE Zlics;
DROP TABLE Zcands;
DROP TABLE Zalus;
DROP TABLE Zanos;

drop table rl_activities cascade constraints;
drop table rl_uses cascade constraints;
drop table rl_facilities cascade constraints;
drop table rl_roomtypes cascade constraints;
drop table rl_districts cascade constraints;
drop table rl_municipalities cascade constraints;
drop table rl_regions cascade constraints;

drop table facilities;
/
drop table activities;
/
drop type activity_tab FORCE;
/
drop type facility_tab FORCE;
/
drop type activity_t;
/
drop type facility_t;
/
drop table municipalities;
/
drop type municipality_t;
/
drop table districts;
/
drop type district_t;
/
drop table regions;
/
drop type region_t;
/
drop table roomtypes;
/
drop type roomtype_t;
/