Changes

Table differences between migrated and non-migrated databases

1,552 bytes added, 21:24, 1 August 2015

Created page with "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;"|'''Tabl..."

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'''
|-
| translation||translation||varchar(250)||text
|-
| hazard||medicalfacilitylevel1||varchar(50)||text
|-
| hazardinfoversion||medicalfacilitylevel1||varchar(50)||text
|-
| hazard||medicalfacilitylevel2||varchar(50)||text
|-
| hazardinfoversion||medicalfacilitylevel2||varchar(50)||text
|-
| hazreduc||medicalfacilitylevel1||varchar(50)||text
|-
| hazreducinfoversion||medicalfacilitylevel1||varchar(50)||text
|-
| hazreduc||medicalfacilitylevel2||varchar(50)||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
|}

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'''
|-
| geopoint||pointdescription
|-
| impactsurvey||minehistorycomments
|-
| hazreduc||qacomments
|-
| fieldreport||reportedby
|-
| hazreduc||vistor

|}
{{NavBox Hub}}
[[Category:NoPublic]]
[[Category:NAA]]

• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits