[phpBT-dev] CVS: phpbt/inc/db mysql.php,1.22,1.23

[Ulf E. <ulf...@us...>]

Update of /cvsroot/phpbt/phpbt/inc/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16589/phpbt/inc/db

Modified Files:
	mysql.php 
Log Message:
Added sort_order to TBL_COMPONENT and TBL_VERSION


Index: mysql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v
retrieving revision 1.22
retrieving revision 1.23
diff -u -r1.22 -r1.23
--- mysql.php	22 Aug 2005 19:58:25 -0000	1.22
+++ mysql.php	22 Aug 2005 20:21:42 -0000	1.23
@@ -174,12 +174,12 @@
 		'group by assigned_to, u.email',
 	'join-where' => 'where',
 	'admin-list-components' => 'select c.component_id, component_name, '.
-		'c.created_date, active, count(bug_id) as bug_count '.
+		'c.created_date, active, sort_order, count(bug_id) as bug_count '.
 		'from '.TBL_COMPONENT.' c left join '.TBL_BUG.' b using(component_id) '.
 		'where c.project_id = %s '.
 		'group by c.component_id, c.component_name, c.created_date, c.active',
 	'admin-list-versions' => 'select v.version_id, version_name, '.
-		'v.created_date, active, count(bug_id) as bug_count '.
+		'v.created_date, active, sort_order, count(bug_id) as bug_count '.
 		'from '.TBL_VERSION.' v left join '.TBL_BUG.' b using(version_id) '.
 		'where v.project_id = %s '.
 		'group by v.version_id, v.version_name, v.created_date, v.active',