[phpBT-dev] CVS: phpbt CHANGELOG,1.22,1.23 bug.php,1.52,1.53 dbchanges.sql,1.12,1.13

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv23830

Modified Files:
	CHANGELOG bug.php dbchanges.sql 
Log Message:
Added on option for choosing whether bugs can be changed only by the bug reporter, bug owner, managers, or admins.

Index: CHANGELOG
===================================================================
RCS file: /cvsroot/phpbt/phpbt/CHANGELOG,v
retrieving revision 1.22
retrieving revision 1.23
diff -u -r1.22 -r1.23
--- CHANGELOG	2001/10/30 04:04:46	1.22
+++ CHANGELOG	2001/11/03 14:25:30	1.23
@@ -1,6 +1,8 @@
 -- 0.5.0 -- 
 : Fixed a bug with the bug history update.
 : Added web-based installation.
+: Added on option for choosing whether bugs can be changed only by the bug
+  reporter, bug owner, managers, or admins. 
 
 -- 0.4.0 -- 18 Oct 2001
 : Improved the CSS file to make choosing different color schemes easier.

Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.52
retrieving revision 1.53
diff -u -r1.52 -r1.53
--- bug.php	2001/10/30 14:23:12	1.52
+++ bug.php	2001/11/03 14:25:30	1.53
@@ -239,7 +239,7 @@
   }
 
   if (!($u == $buginfo['assigned_to'] or $u == $buginfo['created_by'] or
-    $perm->have_perm('Manager'))) {
+    $perm->have_perm('Manager')) and STRICT_UPDATING) {
       show_bug($bugid,array('status' => $STRING['bugbadperm']));
       return;
   }

Index: dbchanges.sql
===================================================================
RCS file: /cvsroot/phpbt/phpbt/dbchanges.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -r1.12 -r1.13
--- dbchanges.sql	2001/09/04 03:46:14	1.12
+++ dbchanges.sql	2001/11/03 14:25:31	1.13
@@ -1,181 +1 @@
-drop table if exists attachment;
-CREATE TABLE attachment (
-  attachment_id int(10) unsigned NOT NULL default '0',
-  bug_id int(10) unsigned NOT NULL default '0',
-  file_name char(255) NOT NULL default '',
-  description char(255) NOT NULL default '',
-  file_size bigint(20) unsigned NOT NULL default '0',
-  mime_type char(30) NOT NULL default '',
-  created_by int(10) unsigned NOT NULL default '0',
-  created_date bigint(20) unsigned NOT NULL default '0',
-  PRIMARY KEY  (attachment_id)
-);
-insert into attachment select * from Attachment;
-
-drop table if exists bug;
-CREATE TABLE bug (
-  bug_id int(10) unsigned NOT NULL default '0',
-  title varchar(100) NOT NULL default '',
-  description text NOT NULL,
-  url varchar(255) NOT NULL default '',
-  severity_id tinyint(3) unsigned NOT NULL default '0',
-  priority tinyint(3) unsigned NOT NULL default '0',
-  status_id tinyint(3) unsigned NOT NULL default '0',
-  resolution_id tinyint(3) unsigned NOT NULL default '0',
-  assigned_to int(10) unsigned NOT NULL default '0',
-  created_by int(10) unsigned NOT NULL default '0',
-  created_date bigint(20) unsigned NOT NULL default '0',
-  last_modified_by int(10) unsigned NOT NULL default '0',
-  last_modified_date bigint(20) unsigned NOT NULL default '0',
-  project_id int(10) unsigned NOT NULL default '0',
-  version_id int(10) unsigned NOT NULL default '0',
-  component_id int(10) unsigned NOT NULL default '0',
-  os_id tinyint(3) unsigned NOT NULL default '0',
-  browser_string varchar(255) NOT NULL default '',
-	close_date bigint(20) unsigned NOT NULL default '0',
-  PRIMARY KEY  (bug_id)
-);
-insert into bug select *, 0 from Bug;
-
-drop table if exists bug_history;
-CREATE TABLE bug_history (
-  bug_id int(10) unsigned NOT NULL default '0',
-  changed_field char(20) NOT NULL default '',
-  old_value char(255) NOT NULL default '',
-  new_value char(255) NOT NULL default '',
-  created_by int(10) unsigned NOT NULL default '0',
-  created_date bigint(20) unsigned NOT NULL default '0'
-);
-insert into bug_history select * from BugHistory;
-
-drop table if exists comment;
-CREATE TABLE comment (
-  comment_id int(10) unsigned NOT NULL default '0',
-  bug_id int(10) unsigned NOT NULL default '0',
-  comment_text text NOT NULL,
-  created_by int(10) unsigned NOT NULL default '0',
-  created_date bigint(20) unsigned NOT NULL default '0',
-  PRIMARY KEY  (comment_id)
-);
-insert into comment select * from Comment;
-
-drop table if exists component;
-CREATE TABLE component (
-  component_id int(10) unsigned NOT NULL default '0',
-  project_id int(10) unsigned NOT NULL default '0',
-  component_name varchar(30) NOT NULL default '',
-  component_desc text NOT NULL,
-  owner int(10) unsigned NOT NULL default '0',
-  active tinyint(1) NOT NULL default '1',
-  created_by int(10) unsigned NOT NULL default '0',
-  created_date bigint(20) unsigned NOT NULL default '0',
-  last_modified_by int(10) unsigned NOT NULL default '0',
-  last_modified_date bigint(20) unsigned NOT NULL default '0',
-  PRIMARY KEY  (component_id)
-);
-insert into component select * from Component;
-
-drop table if exists os;
-CREATE TABLE os (
-  os_id int(10) unsigned NOT NULL default '0',
-  os_name char(30) NOT NULL default '',
-  sort_order tinyint(3) unsigned NOT NULL default '0',
-  regex char(40) NOT NULL default '',
-  PRIMARY KEY  (os_id)
-);
-insert into os select * from OS;
-
-drop table if exists project;
-CREATE TABLE project (
-  project_id int(10) unsigned NOT NULL default '0',
-  project_name varchar(30) NOT NULL default '',
-  project_desc text NOT NULL,
-  active tinyint(1) NOT NULL default '1',
-  created_by int(10) unsigned NOT NULL default '0',
-  created_date bigint(20) unsigned NOT NULL default '0',
-  last_modified_by int(10) unsigned NOT NULL default '0',
-  last_modified_date bigint(20) unsigned NOT NULL default '0',
-  PRIMARY KEY  (project_id)
-);
-insert into project select *, CreatedBy, CreatedDate from Project;
-
-drop table if exists resolution;
-CREATE TABLE resolution (
-  resolution_id int(10) unsigned NOT NULL default '0',
-  resolution_name varchar(30) NOT NULL default '',
-  resolution_desc text NOT NULL,
-  sort_order tinyint(3) unsigned NOT NULL default '0',
-  PRIMARY KEY  (resolution_id)
-);
-insert into resolution select * from Resolution;
-
-drop table if exists saved_query;
-CREATE TABLE saved_query (
-  saved_query_id int(10) unsigned NOT NULL auto_increment,
-  user_id int(10) unsigned NOT NULL default '0',
-  saved_query_name varchar(40) NOT NULL default '',
-  saved_query_string text NOT NULL,
-  PRIMARY KEY  (saved_query_id,user_id)
-);
-insert into saved_query select * from SavedQuery;
-
-drop table if exists severity;
-CREATE TABLE severity (
-  severity_id int(10) unsigned NOT NULL default '0',
-  severity_name varchar(30) NOT NULL default '',
-  severity_desc text NOT NULL,
-  sort_order tinyint(3) unsigned NOT NULL default '0',
-  severity_color varchar(10) NOT NULL default '#FFFFFF',
-  PRIMARY KEY  (severity_id)
-);
-insert into severity select *, null from Severity;
-update severity set severity_color = '#dadada' where severity_id = '1';
-update severity set severity_color = '#dad0d0' where severity_id = '2';
-update severity set severity_color = '#dacaca' where severity_id = '3';
-update severity set severity_color = '#dac0c0' where severity_id = '4';
-update severity set severity_color = '#dababa' where severity_id = '5';
-update severity set severity_color = '#dab0b0' where severity_id = '6';
-update severity set severity_color = '#daaaaa' where severity_id = '7';
-
-drop table if exists status;
-CREATE TABLE status (
-  status_id int(10) unsigned NOT NULL default '0',
-  status_name varchar(30) NOT NULL default '',
-  status_desc text NOT NULL,
-  sort_order tinyint(3) unsigned NOT NULL default '0',
-  PRIMARY KEY  (status_id)
-);
-insert into status select * from Status;
-
-drop table if exists auth_user;
-CREATE TABLE auth_user (
-  user_id int(10) unsigned NOT NULL default '0',
-	login char(40) NOT NULL default '',
-  first_name char(40) NOT NULL default '',
-  last_name char(40) NOT NULL default '',
-  email char(60) NOT NULL default '',
-  password char(40) NOT NULL default '',
-  active tinyint(3) unsigned NOT NULL default '1',
-	bug_list_fields char(255) NOT NULL default '',
-  created_by int(10) unsigned NOT NULL default '0',
-  created_date bigint(20) unsigned NOT NULL default '0',
-  last_modified_by int(10) unsigned NOT NULL default '0',
-  last_modified_date bigint(20) unsigned NOT NULL default '0',
-  PRIMARY KEY  (user_id),
-	UNIQUE login (login)
-);
-insert into auth_user select UserID, Email, FirstName, LastName, Email, Password, if (UserLevel > 0, 1, 0), '', 0, CreatedDate, 0, CreatedDate from User;
-
-drop table if exists version;
-CREATE TABLE version (
-  version_id int(10) unsigned NOT NULL default '0',
-  project_id int(10) unsigned NOT NULL default '0',
-  version_name char(10) NOT NULL default '',
-  active tinyint(1) NOT NULL default '1',
-  created_by int(10) unsigned NOT NULL default '0',
-  created_date bigint(20) unsigned NOT NULL default '0',
-  last_modified_by int(10) unsigned NOT NULL default '0',
-  last_modified_date bigint(20) unsigned NOT NULL default '0',
-  PRIMARY KEY  (version_id)
-);
-insert into version select *, CreatedBy, CreatedDate from Version;
+insert into TBL_CONFIGURATION (varname, varvalue, description, vartype) values ('STRICT_UPDATING', '0', 'Only the bug reporter, bug owner, managers, and admins can change a bug', 'bool');