Add a {project_release_file}.weight column

I'm punting the d.o-specific initialization of {project_release_file}.weight (to handle our profile stuff) to a separate patch against drupalorg_project (I'll still attach that here), but I wanted to get this much up for review. I've tested the DB update and the views stuff a bit, all seems to be fine. Any objections?

One more hunk for one of the default views. The other is going to be changed over at #11416: Please provide *.zip downloads. (and possibly #1006238: Add a weight limit for project_release_handler_field_files) so I don't think it's worth fixing that one in this issue.

Here's a totally untested patch for drupalorg_project to initialize the weight properly for our files.

I just took those subselects, turned them into COUNT(*) queries, and ran on the live DB. Looks right. ;)

mysql> SELECT COUNT(*) FROM project_release_file prf INNER JOIN project_release_nodes prn ON prf.nid = prn.nid INNER JOIN term_node tn ON prn.pid = tn.nid WHERE tn.tid = 96;
+----------+
| count(*) |
+----------+
|     5385 | 
+----------+
1 row in set (0.01 sec)

mysql> SELECT COUNT(*) FROM project_release_file prf INNER JOIN files f ON prf.fid = f.fid INNER JOIN project_release_nodes prn ON prf.nid = prn.nid INNER JOIN term_node tn ON prn.pid = tn.nid WHERE tn.tid = 96 and f.filename RLIKE '-core.tar';
+----------+
| count(*) |
+----------+
|     3052 | 
+----------+
1 row in set (0.06 sec)

mysql> SELECT COUNT(*) FROM project_release_file prf INNER JOIN files f ON prf.fid = f.fid INNER JOIN project_release_nodes prn ON prf.nid = prn.nid INNER JOIN term_node tn ON prn.pid = tn.nid WHERE tn.tid = 96 and f.filename RLIKE '-no-core.tar';
+----------+
| COUNT(*) |
+----------+
|     1526 | 
+----------+
1 row in set (0.12 sec)

#3 needs work, since you can't update {project_release_file} with a subselect that JOINs on the same table:

User warning: You can't specify target table 'prf' for update in FROM clause query: UPDATE project_release_file prf SET weight = 0 WHERE fid IN (SELECT prf.fid FROM project_release_file prf INNER JOIN files f ON prf.fid = f.fid INNER JOIN project_release_nodes prn ON prf.nid = prn.nid INNER JOIN term_node tn ON prn.pid = tn.nid WHERE tn.tid = 96 and f.filename RLIKE '-core.tar') in _db_query() (line 143 of .../includes/database.mysql.inc).

Originally in IRC, nnewton and I discussed running 1 query to find all the records we need to update, saving that in RAM in PHP, and then just updating all those records with other queries. So, that's what I'll do. I just have to wait until morning, since I really need sleep now.

A bit ugly, but this totally works. Ran very quickly on beta.d.o.

Given #1006238: Add a weight limit for project_release_handler_field_files I needed to slightly fix the weight logic in package-release-nodes.php for install profiles. I also folded the patch from #2 into this.

Committed #7 to HEAD of project. Still waiting on a review of #6 before I commit that to drupalorg_project. ;)

Moving to drupalorg.module's queue for now. Shut up, bot. ;) #6 (against drupalorg_project.install) still needs review...

Committed #6 to drupalorg HEAD, merged into bzr, deployed, and ran update.php (was nearly instantaneous).

It's working fine, e.g. the order of files here are correct:

http://drupal.org/node/945570

(first full profile with core, then the "no-core" profile with all the projects, and finally the profile-only release).