[phpBT-dev] CVS: phpbt/schemas mysql.in,1.37,1.38

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

Update of /cvsroot/phpbt/phpbt/schemas
In directory sc8-pr-cvs1:/tmp/cvs-serv9290/schemas

Modified Files:
	mysql.in 
Log Message:
 * Project-level Administration
    - allows superadmin to delegate power to others.
    - admin may assign multiple users to have administrative power on a project.
 * new auth: have_perm_proj($proj_id); check_proj($proj);
 * added <select> to project-form
 * build_select(): in addition to 1-1 matching for selected, allow needle-in-haystack


Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.37
retrieving revision 1.38
diff -u -r1.37 -r1.38
--- mysql.in	2 Mar 2003 15:28:54 -0000	1.37
+++ mysql.in	7 Apr 2003 18:55:39 -0000	1.38
@@ -185,6 +185,11 @@
   KEY group_id (group_id)
 ) TYPE=MyISAM;
 
+CREATE TABLE TBL_PROJECT_PERM (
+  project_id int(11) NOT NULL default '0',
+  user_id int(11) NOT NULL default '0'
+) TYPE=MyISAM;
+
 CREATE TABLE TBL_RESOLUTION (
   resolution_id int(10) unsigned NOT NULL default '0',
   resolution_name varchar(30) NOT NULL default '',