Open main menu
Changes
Table differences between migrated and non-migrated databases
254 bytes added
,
18:48, 10 August 2016
no edit summary
{{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;"|'''Migrated DB'''
|-
|
translation
hazard
||
translation
medicalfacilitylevel1
||varchar(
250
50
)||text
|-
| hazard
||
medicalfacilitylevel1
medicalfacilitylevel2
||varchar(50)||text
|-
|
hazardinfoversion
hazreduc
||medicalfacilitylevel1||varchar(50)||text
|-
|
hazard
hazreduc
||medicalfacilitylevel2||varchar(50)||text
|-
|
hazardinfoversion
hazreduc
||
medicalfacilitylevel2
teamid
||varchar(
50
38
)||
text
varchar(50)
|-
| hazreduc
||
medicalfacilitylevel1
teamlocation
||varchar(50)||text
|-
|
hazreducinfoversion
translation
||
medicalfacilitylevel1
translation
||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
250
)||text
|}
| 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'''
|-
|
geopoint
fieldreport
||
pointdescription
reportedby || text || tinytext || text || text
|-
|
impactsurvey
geopoint
||
minehistorycomments
pointdescription || tinytext || text || text || text
|-
| hazreduc||qacomments
|| tinytext || text || text || text
|-
|
fieldreport
hazreduc
||
reportedby
vistor || tinytext || text || text || text
|-
|
hazreduc
impactsurvey
||
vistor
minehistorycomments || tinytext || text || text || text
|}
{{NavBox
Hub
Data Dictionary
}}
[[Category:NoPublic]]
[[Category:NAA]]
← Older edit
Alnaucler
NoPublic,
bureaucrat
,
administrator
6,632
edits