scorecard-war/clean_db.sql

drop sequence PROVEEDORES_SEQ;
drop sequence USERS_SEQ;
drop sequence KPIS_SEQ;
drop sequence CATEGORYS_SEQ;
drop sequence AREAS_SEQ;
drop sequence EV_DETAIL_SEQ;
drop sequence USERPROVEEDOR_SEQ;
drop sequence NOTIFICATION_SEQ;
drop sequence FILE_SEQ;
drop sequence EVALUACION_SEQ;
drop sequence EVALUACION_PROVEEDOR_SEQ;
drop sequence EVALUACION_DET_COMMENTS_SEQ;
drop sequence SCORECARD_PROVIDER_SEQ;
drop sequence EVALUACION_DET_SEQ;
drop sequence SCORECARD_PROVIDER_MONTH_SEQ;
drop sequence PLAN_ACCION_SEQ;
drop sequence PLAN_ACCION_SEQ_DET;
drop sequence PROVEEDORES_AGENDA_SEQ;

DROP TABLE AUTHORITIES CASCADE CONSTRAINTS;
DROP TABLE ARCHIVOS CASCADE CONSTRAINTS;
drop table AREAS CASCADE CONSTRAINTS;
drop table categorias CASCADE CONSTRAINTS;
drop table file_item CASCADE CONSTRAINTS;
drop table kpi CASCADE CONSTRAINTS;
drop table log CASCADE CONSTRAINTS;
drop table notification_template CASCADE CONSTRAINTS;
drop table plan_accion_commentarios CASCADE CONSTRAINTS;
drop table plan_accion_det CASCADE CONSTRAINTS;
drop table plan_accion CASCADE CONSTRAINTS;
drop table proveedor_agenda CASCADE CONSTRAINTS;
drop table scorecard_provider_month CASCADE CONSTRAINTS;
drop table scorecard_provider CASCADE CONSTRAINTS;
DROP TABLE SCORECARD_PROVIDER_COMMENTS CASCADE CONSTRAINTS;
drop table proveedores CASCADE CONSTRAINTS;
drop table roles_permisos CASCADE CONSTRAINTS;
drop table users_roles CASCADE CONSTRAINTS;
drop table users_proveedores CASCADE CONSTRAINTS;
drop table users CASCADE CONSTRAINTS;
drop table evaluacion CASCADE CONSTRAINTS;
drop table evaluacion_det CASCADE CONSTRAINTS;
drop table evaluacion_det_commentarios CASCADE CONSTRAINTS;
drop table evaluacion_proveedor CASCADE CONSTRAINTS;

--drop procedure D_EVAL_GLOBAL_MONTH;
--drop procedure DASH_GLOBAL_BY_KPI;
--drop procedure DASH_GLOBAL_BY_KPI_MONTH;
--drop procedure DASHBOARD_GENERATESCOREYEAR;
--drop procedure GET_DETAIL_GLOBAL;
--drop procedure GET_DETAIL_GLOBAL_MONTH;
--drop procedure GET_DETAIL_MONTH;
--drop procedure GET_RESUME_LASTEST_MONTHS;
--drop procedure GET_RESUME_SCORE_AREA;
--drop procedure GET_SCOREPRO_CATEGORY_SCORES;
--drop procedure P_GET_ACTION_PLAN_STATUS;
--drop procedure P_GET_DETAIL_BY_PROVIDER;
--drop procedure P_GET_GLOBAL_AVG;
--drop procedure P_GET_PROGRESS_ACTION_PLAN;
--drop procedure P_GET_TREND_GLOBAL_MONTH;
--drop procedure PC_CREATE_UP_SCORECARD;