Changeset 25032 in main


Ignore:
Timestamp:
04/12/22 21:42:17 (4 months ago)
Author:
GarthBraithwaite_STG
Message:

db - middle of restruct. Renamed nj to migration. Moved all data related to migration folder and below. Leaving only main scripts at the mysql level. Before removing collate.

Location:
trunk/db/src/main/scripts/mysql
Files:
2 added
27 deleted
3 edited
2 copied
1 moved

Legend:

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

    r25029 r25032  
     1/* General cleanup - adopter cleanup will likely have removed much of these */
    12
    2 /* REMOVE IPs: delete specific IP's and Views */
    3 delete from INDICATOR where SORT_ORDER = 999;
     3/* Use collate so that character set data can be compared.
     4        Get rid of cats and series that are not used in views or have any values.
     5*/
     6delete from DATASET_CATEGORY where NAME collate SQL_Latin1_General_CP1_CI_AS not in (select distinct DATASET_CATEGORY_NAME from INDICATOR_VIEW);
     7delete from DATASET_CATEGORY where NAME collate SQL_Latin1_General_CP1_CI_AS not in (select distinct DATASET_CATEGORY_NAME from DATASET_CATEGORY_VALUE);
     8
     9delete from DATASET_SERIES   where NAME collate SQL_Latin1_General_CP1_CI_AS not in (select distinct DATASET_SERIES_NAME   from INDICATOR_VIEW);
     10delete from DATASET_SERIES   where NAME collate SQL_Latin1_General_CP1_CI_AS not in (select distinct DATASET_SERIES_NAME   from DATASET_SERIES_VALUE);
     11
     12delete from DATASET_CATEGORY_VALUE where DATASET_CATEGORY_NAME is null or DATASET_CATEGORY_NAME collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from DATASET_CATEGORY);
     13delete from DATASET_SERIES_VALUE   where DATASET_SERIES_NAME   is null or DATASET_SERIES_NAME   collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from DATASET_SERIES);
     14
     15
     16/* REMOVE IPs that don't have any views */
     17delete from INDICATOR where NAME collate SQL_Latin1_General_CP1_CI_AS not in (select INDICATOR_NAME from INDICATOR_VIEW);
     18
    419
    520/* REMOVE ORPHANED IPVs: delete invalid or orphaned IV records */
    6 delete from INDICATOR_VIEW where SORT_ORDER = 99;
    7 delete from INDICATOR_VIEW where INDICATOR_NAME not in (select NAME from INDICATOR);
     21delete from INDICATOR_VIEW where INDICATOR_NAME collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from INDICATOR);
    822delete from INDICATOR_VIEW
    923where DATASET_CATEGORY_NAME is null
    10    or DATASET_CATEGORY_NAME not in (select NAME from DATASET_CATEGORY)
    11    or DATASET_SERIES_NAME   not in (select NAME from DATASET_SERIES)
     24   or DATASET_CATEGORY_NAME collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from DATASET_CATEGORY)
     25   or DATASET_SERIES_NAME   collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from DATASET_SERIES)
    1226;
     27
     28/* REMOVE IVs that don't have any IVVs */
     29delete from INDICATOR_VIEW
     30where NAME collate SQL_Latin1_General_CP1_CI_AS not in (select distinct INDICATOR_VIEW_NAME from INDICATOR_VIEW_VALUE)
     31;
     32
    1333
    1434/* REMOVE ORPHANED IVV:
     
    1939        after clearing out IVV records.  When ran update IV only deactivated 1 record.
    2040*/
    21 delete from INDICATOR_VIEW_VALUE where INDICATOR_VIEW_NAME not in (select NAME from INDICATOR_VIEW);
     41delete from INDICATOR_VIEW_VALUE
     42where INDICATOR_VIEW_NAME collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from INDICATOR_VIEW)
     43;
    2244
    2345delete from INDICATOR_VIEW_VALUE
    2446where DATASET_CATEGORY_NAME  is null
    25    or DATASET_CATEGORY_NAME  not in (select DATASET_CATEGORY_NAME from INDICATOR_VIEW where NAME = INDICATOR_VIEW_NAME)
    26    or DATASET_CATEGORY_VALUE not in (select VALUE from DATASET_CATEGORY_VALUE dcv where dcv.DATASET_CATEGORY_NAME = INDICATOR_VIEW_VALUE.DATASET_CATEGORY_NAME)
     47   or DATASET_CATEGORY_NAME  collate SQL_Latin1_General_CP1_CI_AS  != (select DATASET_CATEGORY_NAME from INDICATOR_VIEW where NAME = INDICATOR_VIEW_NAME)
     48   or DATASET_SERIES_NAME    collate SQL_Latin1_General_CP1_CI_AS  != (select DATASET_SERIES_NAME   from INDICATOR_VIEW where NAME = INDICATOR_VIEW_NAME)
     49   or DATASET_SERIES_VALUE   collate SQL_Latin1_General_CP1_CI_AS not in (select VALUE from DATASET_SERIES_VALUE dsv   where dsv.DATASET_SERIES_NAME   = INDICATOR_VIEW_VALUE.DATASET_SERIES_NAME)
     50   or DATASET_CATEGORY_VALUE collate SQL_Latin1_General_CP1_CI_AS not in (select VALUE from DATASET_CATEGORY_VALUE dcv where dcv.DATASET_CATEGORY_NAME = INDICATOR_VIEW_VALUE.DATASET_CATEGORY_NAME)
     51;
     52
     53
     54/* REMOVE ORPHANDED DATASOURCES: Clean up the datasource intersection records.
     55   NOTE: The DS to IP really isn't used.  DS to IPV are the key tables.
     56*/
     57delete from DATA_SOURCE_TO_INDICATOR where INDICATOR_NAME   collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from INDICATOR)   or INDICATOR_NAME is null;
     58delete from DATA_SOURCE_TO_INDICATOR where DATA_SOURCE_NAME collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from DATA_SOURCE) or DATA_SOURCE_NAME is null;
     59delete from DATA_SOURCE_TO_INDICATOR_VIEW where INDICATOR_VIEW_NAME collate SQL_Latin1_General_CP1_CI_AS not in (select distinct NAME from INDICATOR_VIEW) or INDICATOR_VIEW_NAME is null;
     60delete from DATA_SOURCE_TO_INDICATOR_VIEW where DATA_SOURCE_NAME    collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from DATA_SOURCE)    or DATA_SOURCE_NAME is null;
     61
     62/* unused DSs */
     63delete from DATA_SOURCE where
     64        NAME collate SQL_Latin1_General_CP1_CI_AS not in (select distinct DATA_SOURCE_NAME from DATA_SOURCE_TO_INDICATOR_VIEW)
     65        and
     66        NAME collate SQL_Latin1_General_CP1_CI_AS not in (select distinct DATA_SOURCE_NAME from DATA_SOURCE_TO_INDICATOR)
    2767;
    2868
    2969
    3070
    31 /* Did have code to REMOVE UNUSED DSC & DSS but these are not used with Kim's
    32         approach so leave all DSC and DSS data as is because those tables are
    33         dropped in the post migration cleanup.
    34 */
     71/* set the new v3 datasource.title column */
     72update DATA_SOURCE set TITLE = substr(TEXT, 1, 100);
    3573
    3674
    3775
    38 /* remove DS that are tagged for deletion */
    39 delete from DATA_SOURCE where SORT_ORDER = 999;
    4076
    41 /* set the new v3 datasource.title column */
    42 update DATA_SOURCE set TITLE = substr(TEXT, 1, 100);
    4377
    4478/* IMPORTANT NOTE: Can't do any orphaned DS to IVV cleanup here because the new
  • trunk/db/src/main/scripts/mysql/migrate/4_data-iv_dimensions.sql

    r25029 r25032  
    3939     limit 1
    4040        )
     41where CATEGORY_DIMENSION_NAME is null
    4142;
    4243update INDICATOR_VIEW set SERIES_DIMENSION_NAME =
     
    4849     limit 1
    4950        )
     51where SERIES_DIMENSION_NAME is null
    5052;
    51 update INDICATOR_VIEW set CONSTANT_DIMENSION_NAME = (select DIMENSION_NAME from TMP_IPV_CONSTANT_DIM_NAME where INDICATOR_VIEW_NAME = NAME);
     53update INDICATOR_VIEW set CONSTANT_DIMENSION_NAME =
     54        (select DIMENSION_NAME
     55         from TMP_IPV_CONSTANT_DIM_NAME
     56         where INDICATOR_VIEW_NAME = NAME
     57        )
     58where CONSTANT_DIMENSION_NAME is null
     59;
    5260
    5361
  • trunk/db/src/main/scripts/mysql/migrate/adopter_data-cleanup.sql

    r25029 r25032  
     1/* Adopter specific cleanup - very similar to the 0_data-cleanup.sql with much
     2        of the script replicated but is needed because of the ordering or how data
     3        are deleted.
     4*/
    15
    2 /* REMOVE UNUSED DSC & DSS: clean out unused DSC and DSS records and del orphaned value records */
    3 delete from DATASET_CATEGORY where NAME collate SQL_Latin1_General_CP1_CI_AS not in (select distinct DATASET_CATEGORY_NAME from INDICATOR_VIEW);
    4 
    5 delete from DATASET_CATEGORY where NAME collate SQL_Latin1_General_CP1_CI_AS not in (select distinct DATASET_CATEGORY_NAME from DATASET_CATEGORY_VALUE);
    6 
    7 delete from DATASET_SERIES   where NAME collate SQL_Latin1_General_CP1_CI_AS not in (select distinct DATASET_SERIES_NAME   from INDICATOR_VIEW);
    8 delete from DATASET_SERIES   where NAME collate  SQL_Latin1_General_CP1_CI_AS    in (select distinct DATASET_SERIES_NAME   from DATASET_SERIES_VALUE);
    9 
    10 delete from DATASET_CATEGORY_VALUE where DATASET_CATEGORY_NAME is null or DATASET_CATEGORY_NAME collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from DATASET_CATEGORY);
    11 delete from DATASET_SERIES_VALUE   where DATASET_SERIES_NAME   is null or DATASET_SERIES_NAME   collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from DATASET_SERIES);
     6/* REMOVE specific IPs, IVs (Kim is replacing the DS table)*/
     7delete from INDICATOR      where SORT_ORDER in (99, 999);
     8delete from INDICATOR_VIEW where SORT_ORDER in (99, 999);
    129
    1310
    14 /* REMOVE IPs: delete specific IP's and Views */
    15 delete from INDICATOR where (ACTIVE_FLAG is null) or (ACTIVE_FLAG != 'x');
    16 delete from INDICATOR where NAME collate SQL_Latin1_General_CP1_CI_AS not in (select INDICATOR_NAME from INDICATOR_VIEW);
     11/* NOT REMOVING UNUSED DSC & DSS: these orphaned records would allow for a
     12        little quicker update queries but since these tables do not exist in v3
     13        they will be removed at the end of processing.
     14*/
     15delete from DATASET_CATEGORY where NAME not in (select distinct DATASET_CATEGORY_NAME from INDICATOR_VIEW);
    1716
    18 /* MARIA, fill in this list if you have specfic value you want removed.
    19 delete from INDICATOR where NAME in ('', '');
    20 */
     17delete from DATASET_CATEGORY where NAME not in (select distinct DATASET_CATEGORY_NAME from DATASET_CATEGORY_VALUE);
     18
     19delete from DATASET_SERIES   where NAME not in (select distinct DATASET_SERIES_NAME   from INDICATOR_VIEW);
     20delete from DATASET_SERIES   where NAME not in (select distinct DATASET_SERIES_NAME   from DATASET_SERIES_VALUE);
     21
     22delete from DATASET_CATEGORY_VALUE where DATASET_CATEGORY_NAME is null or DATASET_CATEGORY_NAME not in (select NAME from DATASET_CATEGORY);
     23delete from DATASET_SERIES_VALUE   where DATASET_SERIES_NAME   is null or DATASET_SERIES_NAME   not in (select NAME from DATASET_SERIES);
    2124
    2225
    23 /* REMOVE ORPHANED IPVs: delete invalid or orphaned IV records */
    24 delete from INDICATOR_VIEW where INDICATOR_NAME collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from INDICATOR);
     26/* REMOVE ORPHANED IPs IVs: delete invalid or orphaned records */
    2527delete from INDICATOR_VIEW
    2628where DATASET_CATEGORY_NAME is null
    27    or DATASET_SERIES_NAME   is null
    28    or DATASET_CATEGORY_NAME collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from DATASET_CATEGORY)
    29    or DATASET_SERIES_NAME   collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from DATASET_SERIES)
    30 ;
    31 
    32 /* REMOVE INACTIVE VIEWS NO IVVs: inactive views that do not have any values.  */
    33 delete from INDICATOR_VIEW
    34 where NAME collate SQL_Latin1_General_CP1_CI_AS not in (select distinct INDICATOR_VIEW_NAME from INDICATOR_VIEW_VALUE)
    35   and (ACTIVE_FLAG is null or ACTIVE_FLAG != 'x')
     29   or DATASET_CATEGORY_NAME not in (select NAME from DATASET_CATEGORY)
     30   or DATASET_SERIES_NAME   not in (select NAME from DATASET_SERIES)
    3631;
    3732
     
    4540*/
    4641delete from INDICATOR_VIEW_VALUE
    47 where (ACTIVE_FLAG is null)
    48         or (ACTIVE_FLAG != 'x')
    49         or INDICATOR_VIEW_NAME collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from INDICATOR_VIEW)
     42where INDICATOR_VIEW_NAME not in (select NAME from INDICATOR_VIEW)
    5043;
    5144
    5245delete from INDICATOR_VIEW_VALUE
    53 where DATASET_SERIES_NAME    is null
    54    or DATASET_CATEGORY_NAME  is null
    55    or DATASET_CATEGORY_NAME  collate SQL_Latin1_General_CP1_CI_AS  != (select DATASET_CATEGORY_NAME from INDICATOR_VIEW where NAME = INDICATOR_VIEW_NAME)
    56    or DATASET_SERIES_NAME    collate SQL_Latin1_General_CP1_CI_AS  != (select DATASET_SERIES_NAME   from INDICATOR_VIEW where NAME = INDICATOR_VIEW_NAME)
    57    or DATASET_SERIES_VALUE   collate SQL_Latin1_General_CP1_CI_AS not in (select VALUE from DATASET_SERIES_VALUE dsv   where dsv.DATASET_SERIES_NAME   = INDICATOR_VIEW_VALUE.DATASET_SERIES_NAME)
    58    or DATASET_CATEGORY_VALUE collate SQL_Latin1_General_CP1_CI_AS not in (select VALUE from DATASET_CATEGORY_VALUE dcv where dcv.DATASET_CATEGORY_NAME = INDICATOR_VIEW_VALUE.DATASET_CATEGORY_NAME)
     46where DATASET_CATEGORY_NAME  is null
     47   or DATASET_CATEGORY_NAME   != (select DATASET_CATEGORY_NAME from INDICATOR_VIEW where NAME = INDICATOR_VIEW_NAME)
     48   or DATASET_SERIES_NAME     != (select DATASET_SERIES_NAME   from INDICATOR_VIEW where NAME = INDICATOR_VIEW_NAME)
     49   or DATASET_SERIES_VALUE   not in (select VALUE from DATASET_SERIES_VALUE dsv   where dsv.DATASET_SERIES_NAME   = INDICATOR_VIEW_VALUE.DATASET_SERIES_NAME)
     50   or DATASET_CATEGORY_VALUE not in (select VALUE from DATASET_CATEGORY_VALUE dcv where dcv.DATASET_CATEGORY_NAME = INDICATOR_VIEW_VALUE.DATASET_CATEGORY_NAME)
    5951;
    6052
     
    6355   NOTE: The DS to IP really isn't used.  DS to IPV are the key tables.
    6456*/
    65 delete from DATA_SOURCE_TO_INDICATOR where INDICATOR_NAME   collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from INDICATOR)   or INDICATOR_NAME is null;
    66 delete from DATA_SOURCE_TO_INDICATOR where DATA_SOURCE_NAME collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from DATA_SOURCE) or DATA_SOURCE_NAME is null;
    67 delete from DATA_SOURCE_TO_INDICATOR_VIEW where INDICATOR_VIEW_NAME collate SQL_Latin1_General_CP1_CI_AS not in (select distinct NAME from INDICATOR_VIEW) or INDICATOR_VIEW_NAME is null;
    68 delete from DATA_SOURCE_TO_INDICATOR_VIEW where DATA_SOURCE_NAME    collate SQL_Latin1_General_CP1_CI_AS not in (select NAME from DATA_SOURCE)    or DATA_SOURCE_NAME is null;
    69 
    70 /* unused DSs */
    71 delete from DATA_SOURCE where
    72         NAME collate SQL_Latin1_General_CP1_CI_AS not in (select distinct DATA_SOURCE_NAME from DATA_SOURCE_TO_INDICATOR_VIEW)
    73         and
    74         NAME collate SQL_Latin1_General_CP1_CI_AS not in (select distinct DATA_SOURCE_NAME from DATA_SOURCE_TO_INDICATOR)
    75 ;
    76 
    77 /* MARIA, fill in this list if you have specfic value you want removed.
    78 delete from DATA_SOURCE where NAME in
    79         ('', '')
    80 ;
    81 */
     57delete from DATA_SOURCE_TO_INDICATOR where INDICATOR_NAME   not in (select NAME from INDICATOR)   or INDICATOR_NAME is null;
     58delete from DATA_SOURCE_TO_INDICATOR where DATA_SOURCE_NAME not in (select NAME from DATA_SOURCE) or DATA_SOURCE_NAME is null;
     59delete from DATA_SOURCE_TO_INDICATOR_VIEW where INDICATOR_VIEW_NAME not in (select distinct NAME from INDICATOR_VIEW) or INDICATOR_VIEW_NAME is null;
     60delete from DATA_SOURCE_TO_INDICATOR_VIEW where DATA_SOURCE_NAME    not in (select NAME from DATA_SOURCE)    or DATA_SOURCE_NAME is null;
    8261
    8362/*------------------------------ END OF FILE ------------------------------*/
  • trunk/db/src/main/scripts/mysql/migrate/update.sql

    r25029 r25032  
    44
    55        0.1) Prior to handing off for migration the db to be migrated should have:
    6                 - Indicator and View records to be removed have sort order set to 999 and 99.
    7                 - Data source to indicator view sort orders set.
     6                - Indicator, View, and datasource records to be removed have sort order set to 999 and 99.
     7                - Data source to indicator view sort orders set as per Lois (if not
     8                        handled in Step 1.x). 
     9                - Any downsizing of text like IP DATA_NOTEs, TITLEs etc.
    810                - View Y titles cleaned up and as standardized as possible.
    911                - View Period titles cleaned up and as standardized as possible with
    1012                        values that match associated dimension title/values.
    11                 - All other items listed in Lois's doc.
    12         0.1) Adopter freezes 2.3 database.
    13         0.2) Export production 2.3 db (mysql files or .sql export)
     13                - Set all views desirable value.
     14        0.2) Create new multi use data sources (adhere to column sizes like TEXT etc.).
     15        0.3) Include items listed in Lois's doc that are not accounted for in Step 1.x.
     16        0.4) Adopter freezes 2.3 database.
     17        0.5) Export 2.3 db (mysql files or .sql export)
    1418
    1519        ----------- Step 1.x - Prep 2.3 Migration
    1620
    17         1.0) Import 2.3 db into development enviro
     21        1.0) Import 2.3 db into development enviro.
    1822        1.1) Create/add the new v3 tables.
    1923        1.2) Update tables - add/rename the new v3 columns.
     
    2125        1.3) Add/Edit standard validation data as needed (typically NM db table
    2226                export or mysql file, or edit table directly):
    23              - TOPIC, MEASURE, VALUE_TYPE, VALUE_ATTRIBUTE, ANCILLARY_VALUE, INDICATOR_SET
    24                  - INITIATIVE, INITIATIVE_TOPIC, INITIATIVE_TOPIC_OBJECTIVE, INITIATIV_TOPIC_OBJ_TO_INDICAT
    25 
    26         1.4) Create temp 2.3 to 3 mapping tables.
    27         1.5) Zip mysql db files and send to Kim (or do an export).
     27                - TOPIC, VALUE_ATTRIBUTE, ANCILLARY_VALUE, INITIATIVE, INITIATIVE_TOPIC,
     28                        INITIATIVE_TOPIC_OBJECTIVE, INITIATIV_TOPIC_OBJ_TO_INDICAT.
     29                - Likely other more specific validation tables like MEASURE, VALUE_TYPE,
     30                        DIMENSION etc. are created by Kim (see Step 2.x).
     31        1.4) Create temp 2.3 to 3 mapping tables (so Kim can populate in next section).
     32        1.5) Do initial orphaned record cleanup.
     33        1.6) Zip mysql db files and send to Kim (or do an export).
    2834
    2935        ----------- Step 2.x - Prep Data
     
    3137        2.0) Kim updates local enviro with zipped mysql files or imports .sql.
    3238        2.1) Kim populates/udpates validation tables:
    33                 DATA_SOURCE, MEASURE, DIMENSION, DIM_VALUE, VALUE_TYPE, TOPIC, etc.
     39                - MEASURE, DIMENSION, DIMENSION_VALUE, VALUE_TYPE, DATA_SOURCE,
     40                        DATA_SOURCE_TO_INDICATOR_VIEW (data source to indicator view sort
     41                        orders set as per Lois).
    3442        2.2) Kim populates temp mapping tables.
    35 3.2 Kim updates IV series for the constant
    36         2.3) Kim updates the IV "None" DS series to set single use constant type
    37                 view uses.  This is when an adopter wants a Male or Female only view
    38                 by county and a specific year.  The year is the constant with county
    39                 being the category.
    40         2.4) Kim zips entire mysql db and sends to Garth (or does an export).
     43                - TMP_SPLIT_IP, TMP_IP23NAME_IP3NAME, TMP_IPV_MEASURE, TMP_DS23NAME_DS3NAME,
     44                        TMP_DSC23_DIM, TMP_DSS23_DIM, TMP_IPV_CONSTANT_DIM_NAME.
     45        2.3) Kim updates the IV "None" DS series to set single use, "constant" type
     46                (not a constant but a single value series).  For example an adopter
     47                wants a view for Male and view for Female by county and a specific year. 
     48                The year is the constant with county being the category.
     49        2.4) Kim updates the associated INDICATOR_VIEW_VALUE "None" type DS series
     50                to set single use, "constant" type (not a constant but a single value
     51                series) but needs to have the specific SERIES VALUE set (Male=1, FM=2). 
    4152
    42 **** look at the 2.3 series being changed from none to something for the constant handling
    43 **** add temp tables to the create script to send to kim
    44 **** creating the IP and IPV name splits
     53        2.5) Kim zips entire mysql db and sends to Garth (or does an export).
    4554
    4655        ----------- Step 3.x - Migrate
    4756
    48         3.0) Import enhanced 2.3 db into development enviro
     57        3.0) Import prepped 2.3 db into development enviro
    4958        3.1) Cleanup
    5059                - delete orphaned IP and IPV and IPVV.
     
    100109                - Any other one offs that need to be entered by hand.
    101110*/
    102 use nj;
     111use migration;
    103112
    104 show table status from nj;
     113show table status from migration;
     114
    105115
    106116/* ---------------- Step 1.x - Prep 2.3 Migration */
     117        use migration;
     118
     119/* run adopter specific data cleanup - remove orphaned records */
     120        adopter_data-cleanup.sql       
     121
    107122/* Create the new v3 tables: */
    108         tab_c-dataset.sql
    109         tab_c-initiative.sql
    110         tab_c-misc_update_v3.sql
     123        ../tab_c-dataset.sql
     124        ../tab_c-initiative.sql
     125        tab_c-misc.sql
     126        tab_c-tmp.sql
    111127
    112128/* v2.3 to v3 table updates (add/rename columns): */
    113         update_tabs.sql
     129        tab_update.sql
     130
     131/* Add in any NM validation tables. */
     132        /* These can be mysql table files or .sql import etc. 
     133                Add as needed/wanted - examples are:
     134                - TOPIC, MEASURE, VALUE_TYPE, VALUE_ATTRIBUTE, ANCILLARY_VALUE, INDICATOR_SET
     135                - INITIATIVE, INITIATIVE_TOPIC, INITIATIVE_TOPIC_OBJECTIVE, INITIATIV_TOPIC_OBJ_TO_INDICAT
     136*/
     137
    114138
    115139/* ---------------- Step 2.x - Manual Migration Data Updates */
    116 /* Send to Kim, Integrate any validation data:
     140/* Kim will populate specific validation tables:
    117141        value_type
    118142        measure
Note: See TracChangeset for help on using the changeset viewer.