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 & hazardinfoversion || medicalfacilitylevel1 || varchar(50)|| text
+
| hazard || medicalfacilitylevel1 || varchar(50)|| text
 
|-
 
|-
−
| hazard & hazardinfoversion || medicalfacilitylevel2 || varchar(50)|| text
+
| hazard || medicalfacilitylevel2 || varchar(50)|| text
 
|-
 
|-
−
| hazreduc & hazreducinfoversion || medicalfacilitylevel1 || varchar(50)|| text
+
| hazreduc || medicalfacilitylevel1 || varchar(50)|| text
 
|-
 
|-
−
| hazreduc & hazreducinfoversion || medicalfacilitylevel2 || varchar(50)|| text
+
| hazreduc || medicalfacilitylevel2 || varchar(50)|| text
 
|-
 
|-
−
| hazreduc & hazreducinfoversion || teamid ||varchar(38) || varchar(50)
+
| hazreduc || teamid ||varchar(38) || varchar(50)
 
|-
 
|-
−
| hazreduc & hazreducinfoversion || teamlocation || varchar(50) || text
+
| hazreduc || teamlocation || varchar(50) || text
 
|-
 
|-
 
| translation || translation || varchar(250 )|| text
 
| translation || translation || varchar(250 )|| text
Line 27: Line 27:
 
| align="center" style="background:#f0f0f0;"|'''Column'''
 
| align="center" style="background:#f0f0f0;"|'''Column'''
 
| align="center" style="background:#f0f0f0;"|'''Initial 5.x DB'''
 
| align="center" style="background:#f0f0f0;"|'''Initial 5.x DB'''
 +
| align="center" style="background:#f0f0f0;"|'''Migrated 5.x DB'''
 +
| align="center" style="background:#f0f0f0;"|'''Initial 6.0 DB'''
 +
| align="center" style="background:#f0f0f0;"|'''Upgraded migrated DB'''
 
|-
 
|-
−
| fieldreport||reportedby || text
+
| fieldreport||reportedby || text || tinytext || text || text  
 
|-
 
|-
−
| geopoint||pointdescription || tinytext
+
| geopoint||pointdescription || tinytext || text || text || text
 
|-
 
|-
−
| hazreduc & hazreducinfoversion||qacomments || tinytext
+
| hazreduc ||qacomments || tinytext || text || text || text
 
|-
 
|-
−
| hazreduc & hazreducinfoversion||vistor || tinytext
+
| hazreduc ||vistor || tinytext || text || text || text
 
|-
 
|-
−
| impactsurvey & impactsurveyversion||minehistorycomments || tinytext
+
| impactsurvey ||minehistorycomments || tinytext || text || text || text
  
 
|}
 
|}
−
{{NavBox Hub}}
+
{{NavBox Data Dictionary}}
−
[[Category:NoPublic]]
+
 
 
[[Category:NAA]]
 
[[Category:NAA]]

Latest revision as of 17:48, 10 August 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 medicalfacilitylevel1 varchar(50) text
hazard medicalfacilitylevel2 varchar(50) text
hazreduc medicalfacilitylevel1 varchar(50) text
hazreduc medicalfacilitylevel2 varchar(50) text
hazreduc teamid varchar(38) varchar(50)
hazreduc 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 Initial 5.x DB Migrated 5.x DB Initial 6.0 DB Upgraded migrated DB
fieldreport reportedby text tinytext text text
geopoint pointdescription tinytext text text text
hazreduc qacomments tinytext text text text
hazreduc vistor tinytext text text text
impactsurvey minehistorycomments tinytext text text text
Item Data
DEFs
Geo data
Task
Auxiliary Data
Other
Enumeration categories  · Other tables  · Table differences between migrated and non-migrated databases
Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=Table_differences_between_migrated_and_non-migrated_databases&oldid=21685"