Difference between revisions of "Table differences between migrated and non-migrated databases"
From IMSMA Wiki
Line 1: | Line 1: | ||
+ | {{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. | If a database has been migrated from Legacy (at least from 2010) then some columns have been changed. | ||
{| class="wikitable" | {| class="wikitable" |
Revision as of 23:41, 8 August 2015
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 |
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 |
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 | qacomments |
hazreducinfoversion | qacomments |
hazreduc | vistor |
hazreducinfoversion | vistor |
impactsurvey | minehistorycomments |
impactsurveyversion | minehistorycomments |