source: main/trunk/db/src/main/scripts/mysql/update_cleanup.sql @ 19336

/* End, non specific updates */

/* table and column drops */ 
use ibisph;

update USER set ID = 'admin', PASSWORD = 'admin' where ID='garth';
insert into ROLE_TO_USER (USER_ID, ROLE_NAME) values ('admin', 'Admin');


alter table INDICATOR drop column HEALTHY_PEOPLE_OBJECTIVE_NAME;
alter table INDICATOR drop column MORE_RESOURCES_TITLE;
alter table INDICATOR drop column DATA_ISSUES;

/* data-cleanup.sql sets the IV TITLE = SUB_TITLE minus trailing comma */
alter table INDICATOR_VIEW drop column SUB_TITLE;

alter table INDICATOR_VIEW drop column PERIOD_TITLE;
alter table INDICATOR_VIEW drop column Y_TITLE;
alter table INDICATOR_VIEW drop column DATASET_SERIES_NAME;
alter table INDICATOR_VIEW drop column DATASET_CATEGORY_NAME;
alter table INDICATOR_VIEW drop column VALUE_TYPE_NAME;
alter table INDICATOR_VIEW drop column TARGET_VALUE;

alter table INDICATOR_VIEW drop column SERIES_DIMENSION_NAME;
alter table INDICATOR_VIEW drop column CATEGORY_DIMENSION_NAME;


drop table if exists CATEGORIZED_INDEX;
drop table if exists DATA_SOURCE_TO_INDICATOR;
drop table if exists DATA_SOURCE_TO_INDICATOR_VIEW;

drop table if exists DATASET_SERIES;
drop table if exists DATASET_SERIES_VALUE;
drop table if exists DATASET_CATEGORY;
drop table if exists DATASET_CATEGORY_VALUE;
drop table if exists TITLE;

drop table if exists HEALTHY_PEOPLE_OBJECTIVE;
drop table if exists HEALTHY_PEOPLE_OBJ_FOCUS_AREA;

drop table if exists INDICATOR_VIEW_VALUE;

drop table if exists TMP_DATASET_RECORD;
drop table if exists TMP_INDICATOR_VIEW_DATASET;

alter table DATASET_RECORD drop column NAME;


drop table if exists SURVEY_RESPONSE;

drop table if exists INDICATOR_VIEW_QUERY_VALUE;
/*------------------------------ END OF FILE ------------------------------*/