264970 - Add columns to t_version for major, minor, subver, and build

Status: RESOLVED DUPLICATE of bug 255803

(addons.mozilla.org Graveyard :: Developer Pages, defect)

Description

[alanjstr]

There are several bugs that relate to the sorting of versions being incorrect. 
I suggest that we correct this by having columns for major, minor, subver, and
build, like we do for t_applications.  This would be more correct than Date
Updated because someone can add/edit an older version.

This will not only require a db change, but some php to change when inserting
the record and querying.

Comment 1

[Wolf [:wolf]]

(1) This is much too large to block 260157. As it requires altering an SQL query
in showlist.php which has already been proven to be quite good at returning
unexpected results when touched. As well as breaking alot of code that is in the
process of being stablized, for 1.0.
(2) This bug is a dupe of 255803 - that bug states the problem, this bug claims
to have a solution, they're the same bug though.
(3) Bug 262153 should not be blocked by this, as other parts of update handle
multiple item filtering just fine.

*** This bug has been marked as a duplicate of 255803 ***