[phpBT-dev] CVS: phpbt/inc/db mysql.php,1.15,1.16 oci8.php,1.13,1.14 pgsql.php,1.22,1.23

[Ken T. <ke...@us...>]

Update of /cvsroot/phpbt/phpbt/inc/db
In directory sc8-pr-cvs1:/tmp/cvs-serv13800/inc/db

Modified Files:
	mysql.php oci8.php pgsql.php 
Log Message:
 * new database update model
    - database schema is versioned
 * new assignable-group declaration
    - each group has an assignable flag
    - configurable by admin/group.php
    - updated build_select's owner section


Index: mysql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -r1.15 -r1.16
--- mysql.php	30 Sep 2002 18:02:06 -0000	1.15
+++ mysql.php	19 Apr 2003 18:12:40 -0000	1.16
@@ -1,7 +1,7 @@
 <?php
 $QUERY = array(
 	'admin-list-groups' => 'select ag.group_id, group_name, locked, '.
-		'count(ug.group_id) as count '.
+		'count(ug.group_id) as count, assignable '.
 		'from '.TBL_AUTH_GROUP.' ag '.
 		'left join '.TBL_USER_GROUP.' ug using (group_id) '.
 		'left join '.TBL_AUTH_USER.' using (user_id) '.

Index: oci8.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -r1.13 -r1.14
--- oci8.php	30 Sep 2002 18:02:06 -0000	1.13
+++ oci8.php	19 Apr 2003 18:12:41 -0000	1.14
@@ -2,7 +2,7 @@
 
 $QUERY = array(
 	'admin-list-groups' => 'select ag.group_id, ag.group_name, ag.locked, '.
-		'count(ug.group_id) as count '.
+		'count(ug.group_id) as count, asssignable '.
 		'from '.TBL_AUTH_GROUP.' ag, '.TBL_USER_GROUP.' ug,'.TBL_AUTH_USER.' au '.
 		'where ag.group_id = ug.group_id(+) and ug.user_id = au.user_id(+) '.
 		'group by ag.group_id, ag.group_name, ag.locked '.

Index: pgsql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v
retrieving revision 1.22
retrieving revision 1.23
diff -u -r1.22 -r1.23
--- pgsql.php	17 Dec 2002 13:27:21 -0000	1.22
+++ pgsql.php	19 Apr 2003 18:12:41 -0000	1.23
@@ -2,7 +2,7 @@
 
 $QUERY = array(
 	'admin-list-groups' => 'select ag.group_id, group_name, locked, '.
-		'count(ug.group_id) as count '.
+		'count(ug.group_id) as count, assignable '.
 		'from '.TBL_AUTH_GROUP.' ag '.
 		'left join '.TBL_USER_GROUP.' ug using (group_id) '.
 		'left join '.TBL_AUTH_USER.' using (user_id) '.