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

Last change on this file since 19336 was 19336, checked in by GarthBraithwaite_STG, 3 years ago

db - added proxy flag column, removed ds record name column as it is not used.

File size: 1.8 KB
Line 
1/* End, non specific updates */
2
3/* table and column drops */ 
4use ibisph;
5
6update USER set ID = 'admin', PASSWORD = 'admin' where ID='garth';
7insert into ROLE_TO_USER (USER_ID, ROLE_NAME) values ('admin', 'Admin');
8
9
10alter table INDICATOR drop column HEALTHY_PEOPLE_OBJECTIVE_NAME;
11alter table INDICATOR drop column MORE_RESOURCES_TITLE;
12alter table INDICATOR drop column DATA_ISSUES;
13
14/* data-cleanup.sql sets the IV TITLE = SUB_TITLE minus trailing comma */
15alter table INDICATOR_VIEW drop column SUB_TITLE;
16
17alter table INDICATOR_VIEW drop column PERIOD_TITLE;
18alter table INDICATOR_VIEW drop column Y_TITLE;
19alter table INDICATOR_VIEW drop column DATASET_SERIES_NAME;
20alter table INDICATOR_VIEW drop column DATASET_CATEGORY_NAME;
21alter table INDICATOR_VIEW drop column VALUE_TYPE_NAME;
22alter table INDICATOR_VIEW drop column TARGET_VALUE;
23
24alter table INDICATOR_VIEW drop column SERIES_DIMENSION_NAME;
25alter table INDICATOR_VIEW drop column CATEGORY_DIMENSION_NAME;
26
27
28drop table if exists CATEGORIZED_INDEX;
29drop table if exists DATA_SOURCE_TO_INDICATOR;
30drop table if exists DATA_SOURCE_TO_INDICATOR_VIEW;
31
32drop table if exists DATASET_SERIES;
33drop table if exists DATASET_SERIES_VALUE;
34drop table if exists DATASET_CATEGORY;
35drop table if exists DATASET_CATEGORY_VALUE;
36drop table if exists TITLE;
37
38drop table if exists HEALTHY_PEOPLE_OBJECTIVE;
39drop table if exists HEALTHY_PEOPLE_OBJ_FOCUS_AREA;
40
41drop table if exists INDICATOR_VIEW_VALUE;
42
43drop table if exists TMP_DATASET_RECORD;
44drop table if exists TMP_INDICATOR_VIEW_DATASET;
45
46alter table DATASET_RECORD drop column NAME;
47
48
49drop table if exists SURVEY_RESPONSE;
50
51drop table if exists INDICATOR_VIEW_QUERY_VALUE;
52/*------------------------------ END OF FILE ------------------------------*/
53
Note: See TracBrowser for help on using the repository browser.