Difference between revisions of "Table differences between migrated and non-migrated databases"
From IMSMA Wiki
Line 26: | Line 26: | ||
| align="center" style="background:#f0f0f0;"|'''Table''' | | align="center" style="background:#f0f0f0;"|'''Table''' | ||
| align="center" style="background:#f0f0f0;"|'''Column''' | | align="center" style="background:#f0f0f0;"|'''Column''' | ||
+ | | align="center" style="background:#f0f0f0;"|'''Initial 5.x DB''' | ||
|- | |- | ||
− | | fieldreport||reportedby | + | | fieldreport||reportedby || text |
|- | |- | ||
− | | geopoint||pointdescription | + | | geopoint||pointdescription || tinytext |
|- | |- | ||
− | | hazreduc & hazreducinfoversion||qacomments | + | | hazreduc & hazreducinfoversion||qacomments || tinytext |
|- | |- | ||
− | | hazreduc & hazreducinfoversion||vistor | + | | hazreduc & hazreducinfoversion||vistor || tinytext |
|- | |- | ||
− | | impactsurvey & impactsurveyversion||minehistorycomments | + | | impactsurvey & impactsurveyversion||minehistorycomments || tinytext |
|} | |} |
Revision as of 18:09, 10 August 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 | Initial 5.x DB |
fieldreport | reportedby | text |
geopoint | pointdescription | tinytext |
hazreduc & hazreducinfoversion | qacomments | tinytext |
hazreduc & hazreducinfoversion | vistor | tinytext |
impactsurvey & impactsurveyversion | minehistorycomments | tinytext |