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 |
