canmove, Confirmed users
2,850
edits
Litmus:Design: Difference between revisions
→Design
ChrisCooper (talk | contribs) (→Design) |
ChrisCooper (talk | contribs) (→Design) |
||
| Line 17: | Line 17: | ||
# Update database schema to allow for more complex testcase relationships ([https://bugzilla.mozilla.org/show_bug.cgi?id=323768 bug 323768]). This will require the following schema changes: | # Update database schema to allow for more complex testcase relationships ([https://bugzilla.mozilla.org/show_bug.cgi?id=323768 bug 323768]). This will require the following schema changes: | ||
* normalize platforms table | |||
** create platform_products join table | |||
** drop product ref from platforms table | |||
** update test_results with new platform info | |||
* normalize opsys table | |||
** update test_results with new opsys info | |||
* normalize subgroups table | |||
** create subgroup_testgroups join table | |||
** drop testgroup ref from subgroups table | |||
* normalize testcases (tests) table | |||
** rename table from tests to testcases (not critical, but I've wanted to do this for ages, for clarity's sake) | |||
** replace status_id with simple boolean enabled | |||
** drop test_status_lookup table | |||
* normalize test_results table | |||
** create test_subgroups table | |||
** drop subgroup ref from tests table | |||
** add product ref to tests table | |||
= Test Case Management = | = Test Case Management = | ||