Changeset 25037 in main


Ignore:
Timestamp:
04/13/22 12:27:35 (4 months ago)
Author:
GarthBraithwaite_STG
Message:

db - updated couple of caught workbench errors - untested split script.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/db/src/main/scripts/mysql/migrate/2_data-ip_ipv_split.sql

    r25036 r25037  
    109109        PERIOD_TITLE, Y_TITLE,
    110110        DATASET_SERIES_NAME, DATASET_CATEGORY_NAME,
    111         PERIOD_DIMENSION_NAME, SERIES_DIMENSION_NAME, CATEGORY_DIMENSION_NAME, CONSTANT_DIMENSION_NAME
    112         MAP_DIMENSION_NAME,
     111        SERIES_DIMENSION_NAME, CATEGORY_DIMENSION_NAME, CONSTANT_DIMENSION_NAME,
     112        MAP_DIMENSION_NAME, PERIOD_DIMENSION_NAME,
    113113        CHART_NAME, CHART_NARRATIVE, CHART_TITLE_OVERRIDE,
    114114        MAP_NAME, MAP_NARRATIVE, MAP_TITLE_OVERRIDE,
    115115        VALUE_TYPE_NAME, MEASURE_NAME, MEASURE_TITLE_OVERRIDE,
    116116        TARGET_VALUE,
    117         DATA_NOTE, NUMERATOR_OVERRIDE, DENOMINATOR_OVERRIDE
     117        DATA_NOTE, NUMERATOR_OVERRIDE, DENOMINATOR_OVERRIDE,
    118118        EXTERNAL_DATAVIZ_TYPE, EXTERNAL_DATAVIZ_TITLE, EXTERNAL_DATAVIZ_VALUE, EXTERNAL_DATAVIZ_NARRATIVE,
    119119        EXTERNAL_CONTENT_URL, EXTERNAL_CONTENT_SELECTOR, EXTERNAL_CONTENT_DEST_SELECTOR,
    120120        VIEW_TEMPLATE_NAME,
    121121        NOTE, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE, MODIFIED_DESCRIPTION
    122 }
     122)
    123123select t.NEW_IPV_NAME, t.NEW_IP_NAME,
     124        DESCRIPTION, TITLE, SUB_TITLE,
     125        PERIOD_TITLE, Y_TITLE,
     126        DATASET_SERIES_NAME, DATASET_CATEGORY_NAME,
     127        SERIES_DIMENSION_NAME, CATEGORY_DIMENSION_NAME, CONSTANT_DIMENSION_NAME,
     128        MAP_DIMENSION_NAME, PERIOD_DIMENSION_NAME,
     129        CHART_NAME, CHART_NARRATIVE, CHART_TITLE_OVERRIDE,
     130        MAP_NAME, MAP_NARRATIVE, MAP_TITLE_OVERRIDE,
     131        VALUE_TYPE_NAME, MEASURE_NAME, MEASURE_TITLE_OVERRIDE,
     132        TARGET_VALUE,
     133        DATA_NOTE, NUMERATOR_OVERRIDE, DENOMINATOR_OVERRIDE,
     134        EXTERNAL_DATAVIZ_TYPE, EXTERNAL_DATAVIZ_TITLE, EXTERNAL_DATAVIZ_VALUE, EXTERNAL_DATAVIZ_NARRATIVE,
     135        EXTERNAL_CONTENT_URL, EXTERNAL_CONTENT_SELECTOR, EXTERNAL_CONTENT_DEST_SELECTOR,
     136        VIEW_TEMPLATE_NAME,
     137        NOTE, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE, MODIFIED_DESCRIPTION
    124138from INDICATOR_VIEW iv, TMP_SPLIT_IP_IPV t
    125139where iv.NAME = t.SOURCE_IPV_NAME
Note: See TracChangeset for help on using the changeset viewer.