View source for Table differences between migrated and non-migrated databases

{{Warning | 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.
{| class="wikitable"
| align="center" style="background:#f0f0f0;"|'''Table'''
| align="center" style="background:#f0f0f0;"|'''Column'''
| align="center" style="background:#f0f0f0;"|'''Initial 6.0 DB'''
| align="center" style="background:#f0f0f0;"|'''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.
{| class="wikitable"
| align="center" style="background:#f0f0f0;"|'''Table'''
| align="center" style="background:#f0f0f0;"|'''Column'''
| 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 || 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 

|}
{{NavBox Data Dictionary}}

[[Category:NAA]]