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

Last change on this file since 19902 was 19902, checked in by GarthBraithwaite_STG, 2 years ago

view, db - removed old INDICATOR_VIEW_VALUE_QUERY table. MOved topic specific css to Topic.css. Conent options to use a grid. Updated jquery.scrollBlockListItems.js to work better. Added cp ip requst link to the com qf. Summary if show map then don't show chart as per Lois request. Removed the old IE shortcut icon head link.

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;
42drop table if exists INDICATOR_VIEW_VALUE_QUERY;
43
44drop table if exists TMP_DATASET_RECORD;
45drop table if exists TMP_INDICATOR_VIEW_DATASET;
46
47alter table DATASET_RECORD drop column NAME;
48
49
50drop table if exists SURVEY_RESPONSE;
51
52drop table if exists INDICATOR_VIEW_QUERY_VALUE;
53/*------------------------------ END OF FILE ------------------------------*/
54
Note: See TracBrowser for help on using the repository browser.