Difference between revisions of "Table differences between migrated and non-migrated databases"
From IMSMA Wiki
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|| | + | | hazard & hazardinfoversion || medicalfacilitylevel2 || varchar(50)|| text |
|- | |- | ||
− | | | + | | hazreduc & hazreducinfoversion || medicalfacilitylevel1 || varchar(50)|| text |
|- | |- | ||
− | | | + | | hazreduc & hazreducinfoversion || medicalfacilitylevel2 || varchar(50)|| text |
|- | |- | ||
− | | hazreduc|| | + | | hazreduc & hazreducinfoversion || teamid ||varchar(38) || varchar(50) |
|- | |- | ||
− | | hazreducinfoversion|| | + | | hazreduc & hazreducinfoversion || teamlocation || varchar(50) || text |
|- | |- | ||
− | + | | translation || translation || varchar(250 )|| text | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | | translation||translation||varchar(250)||text | ||
|} | |} | ||
Line 43: | Line 31: | ||
| geopoint||pointdescription | | geopoint||pointdescription | ||
|- | |- | ||
− | | hazreduc||qacomments | + | | hazreduc & hazreducinfoversion||qacomments |
|- | |- | ||
− | | hazreducinfoversion|| | + | | hazreduc & hazreducinfoversion||vistor |
|- | |- | ||
− | + | | impactsurvey & impactsurveyversion||minehistorycomments | |
− | + | ||
− | |||
− | |||
− | | impactsurvey||minehistorycomments | ||
− | |||
− | |||
|} | |} | ||
{{NavBox Hub}} | {{NavBox Hub}} | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
[[Category:NAA]] | [[Category:NAA]] |
Revision as of 18:50, 10 April 2016
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 |