Difference between revisions of "Table differences between migrated and non-migrated databases"

From IMSMA Wiki
Jump to: navigation, search
Line 7: Line 7:
 
| align="center" style="background:#f0f0f0;"|'''Migrated DB'''
 
| align="center" style="background:#f0f0f0;"|'''Migrated DB'''
 
|-
 
|-
−
| hazard||medicalfacilitylevel1||varchar(50)||text
+
| hazard & hazardinfoversion || medicalfacilitylevel1 || varchar(50)|| text
 
|-
 
|-
−
| hazardinfoversion||medicalfacilitylevel1||varchar(50)||text
+
| hazard & hazardinfoversion || medicalfacilitylevel2 || varchar(50)|| text
 
|-
 
|-
−
| hazard||medicalfacilitylevel2||varchar(50)||text
+
| hazreduc & hazreducinfoversion || medicalfacilitylevel1 || varchar(50)|| text
 
|-
 
|-
−
| hazardinfoversion||medicalfacilitylevel2||varchar(50)||text
+
| hazreduc & hazreducinfoversion || medicalfacilitylevel2 || varchar(50)|| text
 
|-
 
|-
−
| hazreduc||medicalfacilitylevel1||varchar(50)||text
+
| hazreduc & hazreducinfoversion || teamid ||varchar(38) || varchar(50)
 
|-
 
|-
−
| hazreducinfoversion||medicalfacilitylevel1||varchar(50)||text
+
| hazreduc & hazreducinfoversion || teamlocation || varchar(50) || text
 
|-
 
|-
−
| hazreduc||medicalfacilitylevel2||varchar(50)||text
+
| translation || translation || varchar(250 )|| text
−
|-
 
−
| hazreducinfoversion||medicalfacilitylevel2||varchar(50)||text
 
−
|-
 
−
| hazreduc||teamid||varchar(38)||varchar(50)
 
−
|-
 
−
| hazreducinfoversion||teamid||varchar(38)||varchar(50)
 
−
|-
 
−
| hazreduc||teamlocation||varchar(50)||text
 
−
|-
 
−
| hazreducinfoversion||teamlocation||varchar(50)||text
 
−
|-
 
−
| translation||translation||varchar(250)||text
 
 
|}
 
|}
  
Line 43: Line 31:
 
| geopoint||pointdescription
 
| geopoint||pointdescription
 
|-
 
|-
−
| hazreduc||qacomments
+
| hazreduc & hazreducinfoversion||qacomments
 
|-
 
|-
−
| hazreducinfoversion||qacomments
+
| hazreduc & hazreducinfoversion||vistor
 
|-
 
|-
−
| hazreduc||vistor
+
| impactsurvey & impactsurveyversion||minehistorycomments
−
|-
+
 
−
| hazreducinfoversion||vistor
 
−
|-
 
−
| impactsurvey||minehistorycomments
 
−
|-
 
−
| impactsurveyversion||minehistorycomments
 
 
|}
 
|}
 
{{NavBox Hub}}
 
{{NavBox Hub}}
 
[[Category:NoPublic]]
 
[[Category:NoPublic]]
 
[[Category:NAA]]
 
[[Category:NAA]]

Revision as of 18:50, 10 April 2016

Warning.jpg Depending on if a database is originally created with 5.x or 6.0 there are also differences in Foreign keys' CASCADE on delete.

If a database has been migrated from Legacy (at least from 2010) then some columns have been changed.

Table Column Initial 6.0 DB Migrated DB
hazard & hazardinfoversion medicalfacilitylevel1 varchar(50) text
hazard & hazardinfoversion medicalfacilitylevel2 varchar(50) text
hazreduc & hazreducinfoversion medicalfacilitylevel1 varchar(50) text
hazreduc & hazreducinfoversion medicalfacilitylevel2 varchar(50) text
hazreduc & hazreducinfoversion teamid varchar(38) varchar(50)
hazreduc & hazreducinfoversion teamlocation varchar(50) text
translation translation varchar(250 ) text

I can see in the migration scripts that previously also the following columns were different.

Table Column
fieldreport reportedby
geopoint pointdescription
hazreduc & hazreducinfoversion qacomments
hazreduc & hazreducinfoversion vistor
impactsurvey & impactsurveyversion minehistorycomments
Hub
Technical
Versions
Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=Table_differences_between_migrated_and_non-migrated_databases&oldid=21191"