Menu
▾
▴
phpbt-dev — Developer's mailing list and cvs commits
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(34) |
Aug
(215) |
Sep
(180) |
Oct
(135) |
Nov
(105) |
Dec
(81) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(76) |
Feb
(22) |
Mar
(154) |
Apr
(149) |
May
(128) |
Jun
(94) |
Jul
(14) |
Aug
(24) |
Sep
(77) |
Oct
(52) |
Nov
(22) |
Dec
(6) |
| 2003 |
Jan
(4) |
Feb
(10) |
Mar
(6) |
Apr
(29) |
May
(10) |
Jun
(37) |
Jul
(39) |
Aug
(13) |
Sep
(23) |
Oct
(3) |
Nov
(7) |
Dec
(2) |
| 2004 |
Jan
|
Feb
(10) |
Mar
(4) |
Apr
|
May
(35) |
Jun
(4) |
Jul
(17) |
Aug
(6) |
Sep
(14) |
Oct
(18) |
Nov
(2) |
Dec
(14) |
| 2005 |
Jan
(9) |
Feb
(30) |
Mar
(6) |
Apr
|
May
(38) |
Jun
(23) |
Jul
(21) |
Aug
(76) |
Sep
(50) |
Oct
(51) |
Nov
(13) |
Dec
|
|
From: Benjamin C. <bc...@us...> - 2001-09-19 14:19:36
|
Update of /cvsroot/phpbt/phpbt/docs/html In directory usw-pr-cvs1:/tmp/cvs-serv2883/html Log Message: Directory /cvsroot/phpbt/phpbt/docs/html added to the repository |
|
From: Benjamin C. <bc...@us...> - 2001-09-19 14:18:59
|
Update of /cvsroot/phpbt/phpbt/docs/sgml In directory usw-pr-cvs1:/tmp/cvs-serv2665/docs/sgml Log Message: Directory /cvsroot/phpbt/phpbt/docs/sgml added to the repository |
|
From: Benjamin C. <bc...@us...> - 2001-09-19 14:18:39
|
Update of /cvsroot/phpbt/phpbt/docs In directory usw-pr-cvs1:/tmp/cvs-serv2592/docs Log Message: Directory /cvsroot/phpbt/phpbt/docs added to the repository |
|
From: Benjamin C. <bc...@us...> - 2001-09-18 03:51:06
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv21253 Modified Files: CHANGELOG Log Message: Updated for 0.3.1 Index: CHANGELOG =================================================================== RCS file: /cvsroot/phpbt/phpbt/CHANGELOG,v retrieving revision 1.14 retrieving revision 1.15 diff -u -r1.14 -r1.15 --- CHANGELOG 2001/09/15 17:15:20 1.14 +++ CHANGELOG 2001/09/18 03:51:03 1.15 @@ -1,3 +1,8 @@ +-- 0.3.1 -- 17 Sep 2001 +: Fixed the perm and group checks. +: Fixed a bug when selecting an OS in the bug query. +: Included the latest options in the configure script. + -- 0.3.0 -- 15 Sep 2001 : Converted database schema to lower-case to ease DB portability. : Added postgres table creation schema. |
|
From: Benjamin C. <bc...@us...> - 2001-09-18 03:43:49
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv20358
Modified Files:
bug.php
Log Message:
I hate it when I leave debugging info in there :)
Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.43
retrieving revision 1.44
diff -u -r1.43 -r1.44
--- bug.php 2001/09/18 03:43:06 1.43
+++ bug.php 2001/09/18 03:43:45 1.44
@@ -506,7 +506,7 @@
function show_projects() {
global $me, $q, $t, $project, $STRING;
- $q->Debug=true;
+
// Show only active projects with at least one component
$q->query('select p.* from '.TBL_PROJECT.' p, '.TBL_COMPONENT
.' c where p.active and p.project_id = c.project_id group by p.project_id
|
|
From: Benjamin C. <bc...@us...> - 2001-09-18 03:43:08
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv20270
Modified Files:
bug.php
Log Message:
Grab only the project information
Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.42
retrieving revision 1.43
diff -u -r1.42 -r1.43
--- bug.php 2001/09/18 03:36:33 1.42
+++ bug.php 2001/09/18 03:43:06 1.43
@@ -506,9 +506,9 @@
function show_projects() {
global $me, $q, $t, $project, $STRING;
-
+ $q->Debug=true;
// Show only active projects with at least one component
- $q->query('select * from '.TBL_PROJECT.' p, '.TBL_COMPONENT
+ $q->query('select p.* from '.TBL_PROJECT.' p, '.TBL_COMPONENT
.' c where p.active and p.project_id = c.project_id group by p.project_id
order by project_name');
switch ($q->num_rows()) {
|
|
From: Benjamin C. <bc...@us...> - 2001-09-18 03:36:37
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv19301
Modified Files:
attachment.php bug.php include.php user.php
Log Message:
Correct the permission and group checks
Index: attachment.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/attachment.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- attachment.php 2001/09/03 17:59:11 1.8
+++ attachment.php 2001/09/18 03:36:33 1.9
@@ -153,7 +153,7 @@
del_attachment($_gv['del']);
}
} elseif (isset($HTTP_POST_FILES['attachment'])) {
- $perm->check('User');
+ $perm->check('Editbug');
add_attachment($_pv['bugid'], $_pv['description']);
} elseif (isset($_gv['attachid'])) {
if (list($filename, $mimetype) = grab_attachment($_gv['attachid'])) {
@@ -162,7 +162,7 @@
exit;
}
} else {
- $perm->check('User');
+ $perm->check('Editbug');
show_attachment_form($_gv['bugid']);
}
Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.41
retrieving revision 1.42
diff -u -r1.41 -r1.42
--- bug.php 2001/09/11 13:02:51 1.41
+++ bug.php 2001/09/18 03:36:33 1.42
@@ -544,7 +544,7 @@
switch($op) {
case 'history' : show_history($bugid); break;
case 'add' :
- $perm->check('User');
+ $perm->check('Editbug');
if ($project) show_form();
else show_projects();
break;
Index: include.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/include.php,v
retrieving revision 1.54
retrieving revision 1.55
diff -u -r1.54 -r1.55
--- include.php 2001/09/07 13:17:37 1.54
+++ include.php 2001/09/18 03:36:33 1.55
@@ -188,6 +188,17 @@
$t->set_file('content','badperm.html');
$t->pparse('main',array('content','wrap','main'));
}
+
+ function check_group($group) {
+ global $t;
+
+ if (!$this->check_auth('group', $group)) {
+ $t->set_file('content', 'badgroup.html');
+ $t->set_var('group', $group);
+ $t->pparse('main',array('content','wrap','main'));
+ exit();
+ }
+ }
}
class templateclass extends Template {
Index: user.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/user.php,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -r1.14 -r1.15
--- user.php 2001/09/01 15:44:20 1.14
+++ user.php 2001/09/18 03:36:33 1.15
@@ -82,7 +82,7 @@
}
$t->set_file('wrap', 'wrap.html');
-$perm->check('User');
+$perm->check_group('User');
if ($do) switch ($do) {
case 'changepassword' : change_password($_pv['pass1'], $_pv['pass2']); break;
|
|
From: Benjamin C. <bc...@us...> - 2001-09-18 03:36:37
|
Update of /cvsroot/phpbt/phpbt/templates/default
In directory usw-pr-cvs1:/tmp/cvs-serv19301/templates/default
Added Files:
badgroup.html
Log Message:
Correct the permission and group checks
--- NEW FILE: badgroup.html ---
<table border="0" width="640">
<tr>
<td align="center">
<br>
You must be a member of the {group} group to use this page.
<br>
<br>
</td>
</tr>
</table>
|
|
From: Benjamin C. <bc...@us...> - 2001-09-18 03:34:22
|
Update of /cvsroot/phpbt/phpbt/templates/default In directory usw-pr-cvs1:/tmp/cvs-serv19026/templates/default Modified Files: badperm.html Log Message: Slight formatting adjustment Index: badperm.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/templates/default/badperm.html,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- badperm.html 2001/08/08 04:27:33 1.2 +++ badperm.html 2001/09/18 03:34:18 1.3 @@ -1,7 +1,10 @@ <table border="0" width="640"> <tr> <td align="center"> + <br> You must first login before using this page. + <br> + <br> </td> </tr> </table> |
|
From: Benjamin C. <bc...@us...> - 2001-09-18 03:26:19
|
Update of /cvsroot/phpbt/phpbt/admin
In directory usw-pr-cvs1:/tmp/cvs-serv18210
Modified Files:
os.php project.php resolution.php severity.php status.php
user.php
Log Message:
Correct the perm checks for administrators
Index: os.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/os.php,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -r1.12 -r1.13
--- os.php 2001/09/03 17:20:16 1.12
+++ os.php 2001/09/18 03:26:15 1.13
@@ -114,7 +114,7 @@
$t->set_file('wrap','wrap.html');
-$perm->check('Administrator');
+$perm->check('Admin');
if ($op) switch($op) {
case 'add' : list_items(); break;
Index: project.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/project.php,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -r1.17 -r1.18
--- project.php 2001/09/11 12:58:46 1.17
+++ project.php 2001/09/18 03:26:15 1.18
@@ -312,7 +312,7 @@
$t->set_file('wrap','wrap.html');
-$perm->check('Administrator');
+$perm->check('Admin');
if (isset($_gv['op'])) {
switch($_gv['op']) {
Index: resolution.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/resolution.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -r1.13 -r1.14
--- resolution.php 2001/09/03 17:20:16 1.13
+++ resolution.php 2001/09/18 03:26:15 1.14
@@ -116,7 +116,7 @@
$t->set_file('wrap','wrap.html');
-$perm->check('Administrator');
+$perm->check('Admin');
if ($op) switch($op) {
case 'add' : list_items(); break;
Index: severity.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/severity.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- severity.php 2001/09/03 20:34:53 1.7
+++ severity.php 2001/09/18 03:26:15 1.8
@@ -121,7 +121,7 @@
$t->set_file('wrap','wrap.html');
-$perm->check('Administrator');
+$perm->check('Admin');
if ($op) switch($op) {
case 'add' : list_items(); break;
Index: status.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/status.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -r1.13 -r1.14
--- status.php 2001/09/03 17:20:16 1.13
+++ status.php 2001/09/18 03:26:15 1.14
@@ -115,7 +115,7 @@
$t->set_file('wrap','wrap.html');
-$perm->check('Administrator');
+$perm->check('Admin');
if ($op) switch($op) {
case 'add' : list_items(); break;
Index: user.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/user.php,v
retrieving revision 1.26
retrieving revision 1.27
diff -u -r1.26 -r1.27
--- user.php 2001/09/14 16:48:13 1.26
+++ user.php 2001/09/18 03:26:15 1.27
@@ -221,7 +221,7 @@
$t->set_file('wrap','wrap.html');
-$perm->check('Administrator');
+$perm->check('Admin');
if ($op) switch($op) {
case 'add' : list_items(); break;
|
|
From: Benjamin C. <bc...@us...> - 2001-09-16 15:12:48
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv32293
Modified Files:
configure
Log Message:
Actually set the severity color option and add the EMAIL_IS_LOGIN option
Index: configure
===================================================================
RCS file: /cvsroot/phpbt/phpbt/configure,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -r1.11 -r1.12
--- configure 2001/09/15 16:22:51 1.11
+++ configure 2001/09/16 15:12:44 1.12
@@ -24,6 +24,7 @@
MASK_EMAIL=0
HIDE_EMAIL=1
SEV_COLOR=1
+EMAIL_IS_LOGIN=1
administrivia() {
$DIALOG --backtitle "phpBT Configuration" \
@@ -154,12 +155,18 @@
else
OLD_SEV_COLOR=off
fi
+ if [ $EMAIL_IS_LOGIN -eq 1 ]; then
+ OLD_EMAIL_IS_LOGIN=on
+ else
+ OLD_EMAIL_IS_LOGIN=off
+ fi
NEW_ENCRYPTPASS=0
NEW_USE_JPGRAPH=0
NEW_MASK_EMAIL=0
NEW_HIDE_EMAIL=0
NEW_SEV_COLOR=0
+ NEW_EMAIL_IS_LOGIN=0
$DIALOG --backtitle "phpBT Configuration" \
--title "Optional Features" \
@@ -170,6 +177,7 @@
"MASK_EMAIL" "Replace @ with at and . with dot when showing emails" $OLD_MASK_EMAIL \
"HIDE_EMAIL" "Completely hide emails when not logged in" $OLD_HIDE_EMAIL \
"SEV_COLOR" "Color rows in bug list according to severity" $OLD_SEV_COLOR \
+ "EMAIL_IS_LOGIN" "Use the email address as user login" $OLD_EMAIL_IS_LOGIN \
2> $tempfile
retval=$?
@@ -189,6 +197,8 @@
NEW_HIDE_EMAIL=1;;
SEV_COLOR)
NEW_SEV_COLOR=1;;
+ EMAIL_IS_LOGIN)
+ NEW_EMAIL_IS_LOGIN=1;;
esac
done
@@ -197,6 +207,7 @@
MASK_EMAIL=${NEW_MASK_EMAIL:-0}
HIDE_EMAIL=${NEW_HIDE_EMAIL:-0}
SEV_COLOR=${NEW_SEV_COLOR:-0}
+ EMAIL_IS_LOGIN=${NEW_EMAIL_IS_LOGIN:-0}
fi
if [ $USE_JPGRAPH -eq 1 ]; then
@@ -242,6 +253,8 @@
echo "/USE_JPGRAPH/s/[[:digit:]]/$USE_JPGRAPH/" >> $tempfile
echo "/MASK_EMAIL/s/[[:digit:]]/$MASK_EMAIL/" >> $tempfile
echo "/HIDE_EMAIL/s/[[:digit:]]/$HIDE_EMAIL/" >> $tempfile
+ echo "/USE_SEVERITY_COLOR/s/[[:digit:]]/$SEV_COLOR/" >> $tempfile
+ echo "/EMAIL_IS_LOGIN/s/[[:digit:]]/$EMAIL_IS_LOGIN/" >> $tempfile
echo "/ADMINEMAIL/s|, '.*'|, '$ADMINEMAIL'|" >> $tempfile
echo "/INSTALLPATH/s|, '.*'|, '$INSTALLPATH'|" >> $tempfile
echo "/ATTACHMENT_PATH/s|, '.*'|, '$ATTACHMENT_PATH'|" >> $tempfile
|
|
From: Benjamin C. <bc...@us...> - 2001-09-15 23:13:52
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv19496
Modified Files:
query.php
Log Message:
Fixes bug #461898
bug.op_sys_id instead of bug.os_id
Index: query.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/query.php,v
retrieving revision 1.27
retrieving revision 1.28
diff -u -r1.27 -r1.28
--- query.php 2001/09/03 20:43:09 1.27
+++ query.php 2001/09/15 23:13:48 1.28
@@ -114,7 +114,7 @@
// Select boxes
if ($status) $flags[] = 'bug.status_id in ('.delimit_list(',',$status).')';
if ($resolution) $flags[] = 'bug.resolution_id in ('.delimit_list(',',$resolution).')';
- if ($os) $flags[] = 'bug.op_sys_id in ('.delimit_list(',',$os).')';
+ if ($os) $flags[] = 'bug.os_id in ('.delimit_list(',',$os).')';
if ($priority) $flags[] = 'bug.priority in ('.delimit_list(',',$priority).')';
if ($severity) $flags[] = 'bug.severity_id in ('.delimit_list(',',$severity).')';
if ($flags) $query[] = '('.delimit_list(' or ',$flags).')';
|
|
From: Ben C. <php...@be...> - 2001-09-15 19:05:28
|
Well, it's been about a month since the last release, so I figured it was a good time to kick out this one. I think it was (at least mostly) ready, but of course I'm sure there will be some reason to release 0.3.1. :) As for 0.4.0, I'm open to suggestions on feature enhancements. One that has been discussed here already is project groups, and I'd personally like to see that one implemented. Feel free to post suggestions here or make changes to the TODO file. Regarding that file, two goals I have for myself are getting the CC and bug submission by email features in there. Thanks again for all the help in making this a great bug tracker. |
|
From: Benjamin C. <bc...@us...> - 2001-09-15 18:45:01
|
Update of /cvsroot/phpbt/phpbt/schemas/old In directory usw-pr-cvs1:/tmp/cvs-serv6855/schemas/old Added Files: perms.sql table_rename.sql Log Message: Moving down --- NEW FILE: perms.sql --- create table auth_group (group_id int unsigned not null, group_name varchar(80) not null, created_by int unsigned not null, created_date bigint unsigned not null, last_modified_by int unsigned not null, last_modified_date bigint unsigned not null, primary key (group_id)); create table auth_perm (perm_id int unsigned not null, perm_name varchar(80) not null, created_by int unsigned not null, created_date bigint unsigned not null, last_modified_by int unsigned not null, last_modified_date bigint unsigned not null, primary key (perm_id)); create table user_group (user_id int unsigned not null, group_id int unsigned not null, created_by int unsigned not null, created_date bigint unsigned not null, primary key (user_id, group_id), key (group_id)); create table user_perm (user_id int unsigned not null, perm_id int unsigned not null, primary key (user_id, perm_id), key (perm_id)); create table group_perm (group_id int unsigned not null, perm_id int unsigned not null, created_by int unsigned not null, created_date bigint unsigned not null, primary key (group_id, perm_id), key (perm_id)); create table bug_group (bug_id int unsigned not null, group_id int unsigned not null, primary key (bug_id, group_id), key (group_id)); create table project_group (project_id int unsigned not null, group_id int unsigned not null, primary key (project_id, group_id), key (group_id)); # Start off with two user levels... insert into auth_group (group_id, group_name) values (1, 'Admin'); insert into auth_group (group_id, group_name) values (2, 'User'); insert into auth_group (group_id, group_name) values (3, 'Developer'); # ... and only two permissions (how quaint) insert into auth_perm (perm_id, perm_name) values (1, 'Admin'); insert into auth_perm (perm_id, perm_name) values (2, 'Editbug'); # Admins can do all the admin stuff and users can edit bugs insert into group_perm (group_id, perm_id) values (1, 1); insert into group_perm (group_id, perm_id) values (2, 2); # And user_id 1 is the admin and a user insert into user_group (user_id, group_id) values (1,0); insert into user_group select user_id, 2, created_by, created_date from auth_user; # You can use these queries to convert the post 0.2.x / pre 0.3.0 schema #alter table user rename auth_user; #alter table auth_user change user_level active tinyint unsigned not null; #alter table auth_user add login char(40) not null after user_id; #update auth_user set active = 1 where active > 0; #update auth_user set login = email; --- NEW FILE: table_rename.sql --- alter table attachment rename phpbt_attachment; alter table bug rename phpbt_bug; alter table bug_history rename phpbt_bug_history; alter table comment rename phpbt_comment; alter table component rename phpbt_component; alter table os rename phpbt_os; alter table project rename phpbt_project; alter table resolution rename phpbt_resolution; alter table saved_query rename phpbt_saved_query; alter table severity rename phpbt_severity; alter table status rename phpbt_status; alter table auth_user rename phpbt_auth_user; alter table version rename phpbt_version; alter table auth_group rename phpbt_auth_group; alter table auth_perm rename phpbt_auth_perm; alter table user_group rename phpbt_user_group; alter table user_perm rename phpbt_user_perm; alter table group_perm rename phpbt_group_perm; alter table bug_group rename phpbt_bug_group; alter table project_group rename phpbt_project_group; |
|
From: Benjamin C. <bc...@us...> - 2001-09-15 18:45:01
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv6855 Removed Files: perms.sql table_rename.sql Log Message: Moving down --- perms.sql DELETED --- --- table_rename.sql DELETED --- |
|
From: Benjamin C. <bc...@us...> - 2001-09-15 18:44:04
|
Update of /cvsroot/phpbt/phpbt/schemas/old In directory usw-pr-cvs1:/tmp/cvs-serv6741/schemas/old Log Message: Directory /cvsroot/phpbt/phpbt/schemas/old added to the repository |
|
From: Benjamin C. <bc...@us...> - 2001-09-15 17:17:12
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv25574 Modified Files: TODO Log Message: Updated for 0.3.0 Index: TODO =================================================================== RCS file: /cvsroot/phpbt/phpbt/TODO,v retrieving revision 1.6 retrieving revision 1.7 diff -u -r1.6 -r1.7 --- TODO 2001/08/13 13:34:49 1.6 +++ TODO 2001/09/15 17:17:10 1.7 @@ -1,11 +1,9 @@ Bugs: - Create bugs via email +- Add CCs to bugs -Personal Page: -- Choose columns to display in bug list - New Account: -- Allow the admin to control whether uses can create new accounts +- Allow the admin to control whether users can create new accounts Users: - User groups to be able to restrict user bug submissions to specific projects |
|
From: Benjamin C. <bc...@us...> - 2001-09-15 17:15:24
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv25258 Modified Files: CHANGELOG Log Message: Forgot one minor detail :) Index: CHANGELOG =================================================================== RCS file: /cvsroot/phpbt/phpbt/CHANGELOG,v retrieving revision 1.13 retrieving revision 1.14 diff -u -r1.13 -r1.14 --- CHANGELOG 2001/09/15 17:12:35 1.13 +++ CHANGELOG 2001/09/15 17:15:20 1.14 @@ -1,4 +1,4 @@ --- 0.3.0 -- +-- 0.3.0 -- 15 Sep 2001 : Converted database schema to lower-case to ease DB portability. : Added postgres table creation schema. : Added the option to color rows in the bug list according to severity. |
|
From: Benjamin C. <bc...@us...> - 2001-09-15 17:12:43
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv24662 Modified Files: CHANGELOG Log Message: Updated for 0.3.0 Index: CHANGELOG =================================================================== RCS file: /cvsroot/phpbt/phpbt/CHANGELOG,v retrieving revision 1.12 retrieving revision 1.13 diff -u -r1.12 -r1.13 --- CHANGELOG 2001/08/21 14:29:35 1.12 +++ CHANGELOG 2001/09/15 17:12:35 1.13 @@ -1,7 +1,16 @@ -- 0.3.0 -- : Converted database schema to lower-case to ease DB portability. +: Added postgres table creation schema. : Added the option to color rows in the bug list according to severity. : Changed the columns in the bug list to be dynamic and user-configurable. +: Improved the configure script and added the configure_db script. +: Changed the user - group - permission scheme. +: Improved project creation in the admin tools. +: Added French, Russian, Norwegian, Swedish, German and Portuguese translations. +: Added option for the login name to not be the email address. +: Added the option to use a table name prefix (like phpbt_) in the database. +: Charset was added to each language file, and that charset is included in mail + headers. -- 0.2.1 -- 14 Aug 2001 : Bugfix to the configure script |
|
From: Benjamin C. <bc...@us...> - 2001-09-15 17:02:37
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv22726 Removed Files: createdb_pg.sql Log Message: Deprecated --- createdb_pg.sql DELETED --- |
|
From: Benjamin C. <bc...@us...> - 2001-09-15 16:56:16
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv21859
Modified Files:
INSTALL
Log Message:
Updated for 0.3.0
Index: INSTALL
===================================================================
RCS file: /cvsroot/phpbt/phpbt/INSTALL,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- INSTALL 2001/08/25 03:36:04 1.7
+++ INSTALL 2001/09/15 16:56:12 1.8
@@ -3,25 +3,25 @@
1. Edit the database creation script, changing the info for the Admin user.
2. Run the database creation script (currently only MySQL) by running
"mysql -u <user> -p<password> < createdb.sql"
-3. Install PHPlib (http://sourceforge.net/projects/phplib/) if it's not already
+1. Install PHPlib (http://sourceforge.net/projects/phplib/) if it's not already
installed.
-4. Copy the directory tree from the tarball to a location suitable for serving
+2. Copy the directory tree from the tarball to a location suitable for serving
web pages.
-5. Run the configure script (somewhat experimental, but it should work)
+3. Run the configure script. This will change config.php (creating a backup)
+ and run configure_db which creates createdb.sql.
- -- or --
-
-5. Edit config.php as follows:
- a. Change the INSTALLPATH and INSTALLURL variables to point the right
- locations.
- b. Change the ADMINEMAIL constant to what you want
- c. Change the database login info in class dbclass.
- d. Change the ENCRYPTPASS constant to 1 if you want to have passwords stored
- encrypted in the database.
- e. Change the USE_JPGRAPH constant to 1 if you want to use the jpgraph class
- (http://www.aditus.nu/jpgraph/) to display the bug summary info. If you
- enable this you'll also need to edit the JPGRAPH_PATH constant, and
- you'll need to edit the jpgraph.php file from the jpgraph disribution.
-6. Browse on over to the installation, choose Admin tools, login with the info
+ -- or --
+
+3. Configure manually.
+ a. Edit the constants in config.php.
+ b. Edit the variables in configure_db and run it to get createdb.sql.
+4. If you want to use jpgraph (http://www.aditus.nu/jpgraph/)
+ to display the bug summary info, you will also need to edit
+ jpgraph.php from the jpgraph disribution.
+5. Edit createdb.sql, changing the admin info in the database insert. You can
+ search on the text ad...@ex... (around line 240).
+6. Use createdb.sql to create your database. With MySQL it can be done like
+ mysql -h <db host> -u <username> -p<yourpassword> < createdb.sql
+7. Browse on over to the installation, choose Admin tools, login with the info
you put in the database creation script, and create your first project.
-7. Start reporting bugs
+8. Start reporting bugs
|
|
From: Benjamin C. <bc...@us...> - 2001-09-15 16:22:55
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv15962
Modified Files:
configure configure_db
Log Message:
All together now
Index: configure
===================================================================
RCS file: /cvsroot/phpbt/phpbt/configure,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- configure 2001/09/15 15:49:42 1.10
+++ configure 2001/09/15 16:22:51 1.11
@@ -236,6 +236,7 @@
change_features
;;
Save)
+ # Change the constants in config.php, saving a backup
mv config.php config.php.bak
echo "/ENCRYPTPASS/s/[[:digit:]]/$ENCRYPTPASS/" > $tempfile
echo "/USE_JPGRAPH/s/[[:digit:]]/$USE_JPGRAPH/" >> $tempfile
@@ -253,8 +254,16 @@
echo "/DB_PASSWORD/s|, '.*'|, '$DB_PASS'|" >> $tempfile
echo "/TBL_PREFIX/s|, '.*'|, '$DB_TBL_PREFIX'|" >> $tempfile
sed -f $tempfile config.php.bak > config.php
+
+ # Change and run the configure_db script
+ cat configure_db | sed "
+ /TBL_PREFIX/s/'.*'/'$DB_TBL_PREFIX'/
+ /DB_TYPE/s/'.*'/'$DB_TYPE'/
+ " > configure_db
+ ./configure_db
+
$DIALOG --backtitle "phpBT Configuration" \
- --infobox "Your changes have been saved" 5 36
+ --msgbox "Your changes have been saved, and your database creation file is createdb.sql" 0 0
exit
;;
esac
Index: configure_db
===================================================================
RCS file: /cvsroot/phpbt/phpbt/configure_db,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- configure_db 2001/09/11 07:43:24 1.3
+++ configure_db 2001/09/15 16:22:51 1.4
@@ -4,7 +4,8 @@
# prefix for tablenames
#TBL_PREFIX="phpbt_"
-TBL_PREFIX=""
+TBL_PREFIX=''
+DB_TYPE='mysql'
#------------------------------------------------------------------------------
#parameters:
@@ -14,8 +15,9 @@
generate_sql() {
cat $1 | sed "
s/TBL_ATTACHMENT/${TBL_PREFIX}attachment/g
- s/TBL_BUG/${TBL_PREFIX}bug/g
+ s/TBL_BUG_GROUP/${TBL_PREFIX}bug_group/g
s/TBL_BUG_HISTORY/${TBL_PREFIX}bug_history/g
+ s/TBL_BUG/${TBL_PREFIX}bug/g
s/TBL_COMMENT/${TBL_PREFIX}comment/g
s/TBL_COMPONENT/${TBL_PREFIX}component/g
s/TBL_PROJECT/${TBL_PREFIX}project/g
@@ -31,7 +33,6 @@
s/TBL_USER_GROUP/${TBL_PREFIX}user_group/g
s/TBL_USER_PERM/${TBL_PREFIX}user_perm/g
s/TBL_GROUP_PERM/${TBL_PREFIX}group_perm/g
- s/TBL_BUG_GROUP/${TBL_PREFIX}bug_group/g
s/TBL_PROJECT_GROUP/${TBL_PREFIX}project_group/g
s/^#\ TEMPLATE:.*$/#/
s/^--\ TEMPLATE:.*$/--/
@@ -40,5 +41,4 @@
#------------------------------------------------------------------------------
-#generate_sql schemas/postgres.sql.in createdb.sql
-generate_sql schemas/mysql.sql.in createdb.sql
+generate_sql schemas/$DB_TYPE.in createdb.sql
|
|
From: Benjamin C. <bc...@us...> - 2001-09-15 16:22:17
|
Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv15860
Added Files:
mysql.in pgsql.in
Removed Files:
mysql.sql.in postgres.sql.in
Log Message:
Moving the schema templates
--- NEW FILE: mysql.in ---
# MySQL database creation script
# If you change the database name, make sure you change the DB_DATABASE
# constant in config.php. Make sure you edit the TBL_AUTH_USER insert below.
#
# TEMPLATE: This is a template for configure_db -- not for creating the database!
#
# $Id: mysql.in,v 1.1 2001/09/15 16:22:13 bcurtis Exp $
create database BugTracker;
use BugTracker;
CREATE TABLE active_sessions (
sid varchar(32) NOT NULL default '',
name varchar(32) NOT NULL default '',
val text,
changed varchar(14) NOT NULL default '',
PRIMARY KEY (name,sid),
KEY changed (changed)
) TYPE=ISAM PACK_KEYS=1;
CREATE TABLE TBL_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)
) TYPE=MyISAM;
CREATE TABLE TBL_AUTH_GROUP (
group_id int(10) unsigned NOT NULL default '0',
group_name varchar(80) 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 (group_id)
) TYPE=MyISAM;
CREATE TABLE TBL_AUTH_PERM (
perm_id int(10) unsigned NOT NULL default '0',
perm_name varchar(80) 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 (perm_id)
) TYPE=MyISAM;
CREATE TABLE TBL_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 KEY login (login)
) TYPE=MyISAM;
CREATE TABLE TBL_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)
) TYPE=MyISAM;
CREATE TABLE TBL_BUG_GROUP (
bug_id int(10) unsigned NOT NULL default '0',
group_id int(10) unsigned NOT NULL default '0',
PRIMARY KEY (bug_id,group_id),
KEY group_id (group_id)
) TYPE=MyISAM;
CREATE TABLE TBL_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'
) TYPE=MyISAM;
CREATE TABLE TBL_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)
) TYPE=MyISAM;
CREATE TABLE TBL_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)
) TYPE=MyISAM;
CREATE TABLE db_sequence (
seq_name varchar(127) NOT NULL default '',
nextid int(10) unsigned NOT NULL default '0',
PRIMARY KEY (seq_name)
) TYPE=ISAM PACK_KEYS=1;
CREATE TABLE TBL_GROUP_PERM (
group_id int(10) unsigned NOT NULL default '0',
perm_id int(10) unsigned NOT NULL default '0',
PRIMARY KEY (group_id,perm_id),
KEY perm_id (perm_id)
) TYPE=MyISAM;
CREATE TABLE TBL_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)
) TYPE=MyISAM;
CREATE TABLE TBL_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)
) TYPE=MyISAM;
CREATE TABLE TBL_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)
) TYPE=MyISAM;
CREATE TABLE TBL_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)
) TYPE=MyISAM;
CREATE TABLE TBL_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)
) TYPE=MyISAM;
CREATE TABLE TBL_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)
) TYPE=MyISAM;
CREATE TABLE TBL_USER_GROUP (
user_id int(10) unsigned NOT NULL default '0',
group_id 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',
PRIMARY KEY (user_id,group_id),
KEY group_id (group_id)
) TYPE=MyISAM;
CREATE TABLE TBL_USER_PERM (
user_id int(10) unsigned NOT NULL default '0',
perm_id 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',
PRIMARY KEY (user_id,perm_id),
KEY perm_id (perm_id)
) TYPE=MyISAM;
CREATE TABLE TBL_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)
) TYPE=MyISAM;
#
# -- Insert initial data --
#
INSERT INTO TBL_AUTH_USER
(user_id, login, first_name, last_name, email, password)
values (1, 'ad...@ex...', 'System', 'Admin', 'ad...@ex...',
'somepassword');
# Start off with three user levels...
INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (1, 'Admin');
INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (2, 'User');
INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (3, 'Developer');
# ... and only two permissions
INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin');
INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug');
# Admins can do all the admin stuff and users can edit bugs
INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1);
INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2);
# And user_id 1 is an admin and a user
INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 1);
INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 2);
INSERT INTO TBL_OS VALUES (1,'All',1,'');
INSERT INTO TBL_OS VALUES (2,'Windows 3.1',2,'/Mozilla.*\\(Win16.*\\)/');
INSERT INTO TBL_OS VALUES (3,'Windows 95',3,'/Mozilla.*\\(.*;.*; 32bit.*\\)/');
INSERT INTO TBL_OS VALUES (4,'Windows 98',4,'/Mozilla.*\\(Win98.*\\)/');
INSERT INTO TBL_OS VALUES (5,'Windows ME',5,'');
INSERT INTO TBL_OS VALUES (6,'Windows 2000',6,'/Mozilla.*Windows NT 5.*\\)/');
INSERT INTO TBL_OS VALUES (7,'Windows NT',7,'/Mozilla.*\\(Windows.*NT/');
INSERT INTO TBL_OS VALUES (8,'Mac System 7',8,'');
INSERT INTO TBL_OS VALUES (9,'Mac System 7.5',9,'');
INSERT INTO TBL_OS VALUES (10,'Mac System 7.6.1',10,'');
INSERT INTO TBL_OS VALUES (11,'Mac System 8.0',11,'');
INSERT INTO TBL_OS VALUES (12,'Mac System 8.5',12,'/Mozilla.*\\(.*;.*; 68K.*\\)/');
INSERT INTO TBL_OS VALUES (13,'Mac System 8.6',13,'/Mozilla.*\\(.*;.*; PPC.*\\)/');
INSERT INTO TBL_OS VALUES (14,'Mac System 9.0',14,'');
INSERT INTO TBL_OS VALUES (15,'Mac TBL_OS X',15,'');
INSERT INTO TBL_OS VALUES (16,'Linux',16,'/Mozilla.*\\(.*;.*; Linux.*\\)/');
INSERT INTO TBL_OS VALUES (17,'BSDI',17,'/Mozilla.*\\(.*;.*; BSD\\/OS.*\\)/');
INSERT INTO TBL_OS VALUES (18,'FreeBSD',18,'/Mozilla.*\\(.*;.*; FreeBSD.*\\)/');
INSERT INTO TBL_OS VALUES (19,'NetBSD',19,'');
INSERT INTO TBL_OS VALUES (20,'OpenBSD',20,'');
INSERT INTO TBL_OS VALUES (21,'AIX',21,'/Mozilla.*\\(.*;.*; AIX.*\\)/');
INSERT INTO TBL_OS VALUES (22,'BeOS',22,'');
INSERT INTO TBL_OS VALUES (23,'HP-UX',23,'/Mozilla.*\\(.*;.*; HP-UX.*\\)/');
INSERT INTO TBL_OS VALUES (24,'IRIX',24,'/Mozilla.*\\(.*;.*; IRIX.*\\)/');
INSERT INTO TBL_OS VALUES (25,'Neutrino',25,'');
INSERT INTO TBL_OS VALUES (26,'OpenVMS',26,'');
INSERT INTO TBL_OS VALUES (27,'OS/2',27,'');
INSERT INTO TBL_OS VALUES (28,'OSF/1',28,'/Mozilla.*\\(.*;.*; OSF.*\\)/');
INSERT INTO TBL_OS VALUES (29,'Solaris',29,'/Mozilla.*\\(.*;.*; SunOS 5.*\\)/');
INSERT INTO TBL_OS VALUES (30,'SunOS',30,'/Mozilla.*\\(.*;.*; SunOS.*\\)/');
INSERT INTO TBL_OS VALUES (31,'other',31,'');
INSERT INTO TBL_RESOLUTION VALUES (1,'Fixed','Bug was eliminated',1);
INSERT INTO TBL_RESOLUTION VALUES (2,'Not a bug','It\'s not a bug -- it\'s a feature!',2);
INSERT INTO TBL_RESOLUTION VALUES (3,'Won\'t Fix','This bug will stay',3);
INSERT INTO TBL_RESOLUTION VALUES (4,'Deferred','We\'ll get around to it later',4);
INSERT INTO TBL_RESOLUTION VALUES (5,'Works for me','Can\'t replicate the bug',5);
INSERT INTO TBL_RESOLUTION VALUES (6,'Duplicate','',6);
INSERT INTO TBL_SEVERITY VALUES (1,'Unassigned','Default bug creation',1,'#dadada');
INSERT INTO TBL_SEVERITY VALUES (2,'Idea','Ideas for further development',2,'#dad0d0');
INSERT INTO TBL_SEVERITY VALUES (3,'Feature Request','Requests for specific features',3,'#dacaca');
INSERT INTO TBL_SEVERITY VALUES (4,'Annoyance','Cosmetic problems or bugs not affecting performance',4,'#dac0c0');
INSERT INTO TBL_SEVERITY VALUES (5,'Content','Non-functional related bugs, such as text content',5,'#dababa');
INSERT INTO TBL_SEVERITY VALUES (6,'Significant','A bug affecting the intended performance of the product',6,'#dab0b0');
INSERT INTO TBL_SEVERITY VALUES (7,'Critical','A bug severe enough to prevent the release of the product',7,'#daaaaa');
INSERT INTO TBL_STATUS VALUES (1,'Unconfirmed','Reported but not confirmed',1);
INSERT INTO TBL_STATUS VALUES (2,'New','A new bug',2);
INSERT INTO TBL_STATUS VALUES (3,'Assigned','Assigned to a developer',3);
INSERT INTO TBL_STATUS VALUES (4,'Reopened','Closed but opened again for further inspection',4);
INSERT INTO TBL_STATUS VALUES (5,'Resolved','Set by engineer with a resolution',5);
INSERT INTO TBL_STATUS VALUES (6,'Verified','The resolution is confirmed by the reporter',6);
INSERT INTO TBL_STATUS VALUES (7,'Closed','The bug is officially squashed (QA)',7);
#
# -- Conversion from 0.2.x to 0.3.0 --
#
#INSERT INTO TBL_ATTACHMENT SELECT * FROM Attachment;
#INSERT INTO TBL_AUTH_USER SELECT UserID, Email, FirstName, LastName, Email, Password, if (UserLevel > 0, 1, 0), '', 0, CreatedDate, 0, CreatedDate FROM User;
#INSERT INTO TBL_BUG SELECT *, 0 FROM Bug;
#INSERT INTO TBL_BUG_HISTORY SELECT * FROM BugHistory;
#INSERT INTO TBL_COMMENT SELECT * FROM Comment;
#INSERT INTO TBL_COMPONENT SELECT * FROM Component;
#INSERT INTO TBL_OS SELECT * FROM OS;
#INSERT INTO TBL_PROJECT SELECT *, CreatedBy, CreatedDate FROM Project;
#INSERT INTO TBL_RESOLUTION SELECT * FROM Resolution;
#INSERT INTO TBL_SAVED_QUERY SELECT * FROM SavedQuery;
#INSERT INTO TBL_SEVERITY SELECT *, '' FROM Severity;
#UPDATE TBL_SEVERITY SET severity_color = '#dadada' WHERE severity_id = '1';
#UPDATE TBL_SEVERITY SET severity_color = '#dad0d0' WHERE severity_id = '2';
#UPDATE TBL_SEVERITY SET severity_color = '#dacaca' WHERE severity_id = '3';
#UPDATE TBL_SEVERITY SET severity_color = '#dac0c0' WHERE severity_id = '4';
#UPDATE TBL_SEVERITY SET severity_color = '#dababa' WHERE severity_id = '5';
#UPDATE TBL_SEVERITY SET severity_color = '#dab0b0' WHERE severity_id = '6';
#UPDATE TBL_SEVERITY SET severity_color = '#daaaaa' WHERE severity_id = '7';
#INSERT INTO TBL_STATUS SELECT * FROM Status;
#INSERT INTO TBL_VERSION SELECT *, CreatedBy, CreatedDate FROM Version;
# Start off with three user levels...
#INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (1, 'Admin');
#INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (2, 'User');
#INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (3, 'Developer');
# ... and only two permissions
#INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin');
#INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug');
# Admins can do all the admin stuff and users can edit bugs
#INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1);
#INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2);
# Move users into the new tables
#INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, group_id FROM User, TBL_AUTH_GROUP where UserLevel = 15 and group_name = 'Admin';
#INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, group_id FROM User, TBL_AUTH_GROUP where UserLevel = 3 and group_name = 'Developer';
#INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, 2 FROM User where UserLevel > 0;
--- NEW FILE: pgsql.in ---
BEGIN;
-- PostgreSQL database creation script
-- If you change the database name, make sure you change the DB_DATABASE
-- constant in config.php. Make sure you edit the TBL_AUTH_USER insert below.
--
-- TEMPLATE: This is a template for configure_db -- not for creating the database!
--
-- $Id: pgsql.in,v 1.1 2001/09/15 16:22:13 bcurtis Exp $
create database BugTracker;
use BugTracker;
CREATE TABLE active_sessions (
sid varchar(32) NOT NULL DEFAULT '',
name varchar(32) NOT NULL DEFAULT '',
val text,
changed varchar(14) NOT NULL DEFAULT '',
PRIMARY KEY (name,sid)
);
CREATE TABLE TBL_ATTACHMENT (
attachment_id INT4 NOT NULL DEFAULT '0',
bug_id INT4 NOT NULL DEFAULT '0',
file_name char(255) NOT NULL DEFAULT '',
description char(255) NOT NULL DEFAULT '',
file_size INT8 NOT NULL DEFAULT '0',
mime_type char(30) NOT NULL DEFAULT '',
created_by INT4 NOT NULL DEFAULT '0',
created_date INT8 NOT NULL DEFAULT '0',
PRIMARY KEY (attachment_id)
);
CREATE TABLE TBL_AUTH_GROUP (
group_id INT4 NOT NULL DEFAULT '0',
group_name varchar(80) NOT NULL DEFAULT '',
created_by INT4 NOT NULL DEFAULT '0',
created_date INT8 NOT NULL DEFAULT '0',
last_modified_by INT4 NOT NULL DEFAULT '0',
last_modified_date INT8 NOT NULL DEFAULT '0',
PRIMARY KEY (group_id)
);
CREATE TABLE TBL_AUTH_PERM (
perm_id INT4 NOT NULL DEFAULT '0',
perm_name varchar(80) NOT NULL DEFAULT '',
created_by INT4 NOT NULL DEFAULT '0',
created_date INT8 NOT NULL DEFAULT '0',
last_modified_by INT4 NOT NULL DEFAULT '0',
last_modified_date INT8 NOT NULL DEFAULT '0',
PRIMARY KEY (perm_id)
);
CREATE TABLE TBL_AUTH_USER (
user_id INT4 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 INT2 NOT NULL DEFAULT '1',
bug_list_fields char(255) NOT NULL DEFAULT '',
created_by INT4 NOT NULL DEFAULT '0',
created_date INT8 NOT NULL DEFAULT '0',
last_modified_by INT4 NOT NULL DEFAULT '0',
last_modified_date INT8 NOT NULL DEFAULT '0',
PRIMARY KEY (user_id)
);
CREATE TABLE TBL_BUG (
bug_id INT4 NOT NULL DEFAULT '0',
title varchar(100) NOT NULL DEFAULT '',
description TEXT DEFAULT '' NOT NULL,
url varchar(255) NOT NULL DEFAULT '',
severity_id INT2 NOT NULL DEFAULT '0',
priority INT2 NOT NULL DEFAULT '0',
status_id INT2 NOT NULL DEFAULT '0',
resolution_id INT2 NOT NULL DEFAULT '0',
assigned_to INT4 NOT NULL DEFAULT '0',
created_by INT4 NOT NULL DEFAULT '0',
created_date INT8 NOT NULL DEFAULT '0',
last_modified_by INT4 NOT NULL DEFAULT '0',
last_modified_date INT8 NOT NULL DEFAULT '0',
project_id INT4 NOT NULL DEFAULT '0',
version_id INT4 NOT NULL DEFAULT '0',
component_id INT4 NOT NULL DEFAULT '0',
os_id INT2 NOT NULL DEFAULT '0',
browser_string varchar(255) NOT NULL DEFAULT '',
close_date INT8 NOT NULL DEFAULT '0',
PRIMARY KEY (bug_id)
);
CREATE TABLE TBL_BUG_GROUP (
bug_id INT4 NOT NULL DEFAULT '0',
group_id INT4 NOT NULL DEFAULT '0',
PRIMARY KEY (bug_id,group_id)
);
CREATE TABLE TBL_BUG_HISTORY (
bug_id INT4 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 INT4 NOT NULL DEFAULT '0',
created_date INT8 NOT NULL DEFAULT '0'
);
CREATE TABLE TBL_COMMENT (
comment_id INT4 NOT NULL DEFAULT '0',
bug_id INT4 NOT NULL DEFAULT '0',
comment_text TEXT DEFAULT '' NOT NULL,
created_by INT4 NOT NULL DEFAULT '0',
created_date INT8 NOT NULL DEFAULT '0',
PRIMARY KEY (comment_id)
);
CREATE TABLE TBL_COMPONENT (
component_id INT4 NOT NULL DEFAULT '0',
project_id INT4 NOT NULL DEFAULT '0',
component_name varchar(30) NOT NULL DEFAULT '',
component_desc TEXT DEFAULT '' NOT NULL,
owner INT4 NOT NULL DEFAULT '0',
active INT2 NOT NULL DEFAULT '1',
created_by INT4 NOT NULL DEFAULT '0',
created_date INT8 NOT NULL DEFAULT '0',
last_modified_by INT4 NOT NULL DEFAULT '0',
last_modified_date INT8 NOT NULL DEFAULT '0',
PRIMARY KEY (component_id)
);
CREATE TABLE db_sequence (
seq_name varchar(127) NOT NULL DEFAULT '',
nextid INT4 NOT NULL DEFAULT '0',
PRIMARY KEY (seq_name)
);
CREATE TABLE TBL_GROUP_PERM (
group_id INT4 NOT NULL DEFAULT '0',
perm_id INT4 NOT NULL DEFAULT '0',
PRIMARY KEY (group_id,perm_id)
);
CREATE TABLE TBL_OS (
os_id INT4 NOT NULL DEFAULT '0',
os_name char(30) NOT NULL DEFAULT '',
sort_order INT2 NOT NULL DEFAULT '0',
regex char(40) NOT NULL DEFAULT '',
PRIMARY KEY (os_id)
);
CREATE TABLE TBL_PROJECT (
project_id INT4 NOT NULL DEFAULT '0',
project_name varchar(30) NOT NULL DEFAULT '',
project_desc TEXT DEFAULT '' NOT NULL,
active INT2 NOT NULL DEFAULT '1',
created_by INT4 NOT NULL DEFAULT '0',
created_date INT8 NOT NULL DEFAULT '0',
last_modified_by INT4 NOT NULL DEFAULT '0',
last_modified_date INT8 NOT NULL DEFAULT '0',
PRIMARY KEY (project_id)
);
CREATE TABLE TBL_RESOLUTION (
resolution_id INT4 NOT NULL DEFAULT '0',
resolution_name varchar(30) NOT NULL DEFAULT '',
resolution_desc TEXT DEFAULT '' NOT NULL,
sort_order INT2 NOT NULL DEFAULT '0',
PRIMARY KEY (resolution_id)
);
--
-- Sequences for table TBL_SAVED_QUERY
--
CREATE SEQUENCE tbl_saved_query_saved_query_;
CREATE TABLE TBL_SAVED_QUERY (
saved_query_id INT4 DEFAULT nextval('tbl_saved_query_saved_query_'),
user_id INT4 NOT NULL DEFAULT '0',
saved_query_name varchar(40) NOT NULL DEFAULT '',
saved_query_string TEXT DEFAULT '' NOT NULL,
PRIMARY KEY (saved_query_id,user_id)
);
CREATE TABLE TBL_SEVERITY (
severity_id INT4 NOT NULL DEFAULT '0',
severity_name varchar(30) NOT NULL DEFAULT '',
severity_desc TEXT DEFAULT '' NOT NULL,
sort_order INT2 NOT NULL DEFAULT '0',
severity_color varchar(10) NOT NULL DEFAULT '#FFFFFF',
PRIMARY KEY (severity_id)
);
CREATE TABLE TBL_STATUS (
status_id INT4 NOT NULL DEFAULT '0',
status_name varchar(30) NOT NULL DEFAULT '',
status_desc TEXT DEFAULT '' NOT NULL,
sort_order INT2 NOT NULL DEFAULT '0',
PRIMARY KEY (status_id)
);
CREATE TABLE TBL_USER_GROUP (
user_id INT4 NOT NULL DEFAULT '0',
group_id INT4 NOT NULL DEFAULT '0',
created_by INT4 NOT NULL DEFAULT '0',
created_date INT8 NOT NULL DEFAULT '0',
PRIMARY KEY (user_id,group_id)
);
CREATE TABLE TBL_USER_PERM (
user_id INT4 NOT NULL DEFAULT '0',
perm_id INT4 NOT NULL DEFAULT '0',
created_by INT4 NOT NULL DEFAULT '0',
created_date INT8 NOT NULL DEFAULT '0',
PRIMARY KEY (user_id,perm_id)
);
CREATE TABLE TBL_VERSION (
version_id INT4 NOT NULL DEFAULT '0',
project_id INT4 NOT NULL DEFAULT '0',
version_name char(10) NOT NULL DEFAULT '',
active INT2 NOT NULL DEFAULT '1',
created_by INT4 NOT NULL DEFAULT '0',
created_date INT8 NOT NULL DEFAULT '0',
last_modified_by INT4 NOT NULL DEFAULT '0',
last_modified_date INT8 NOT NULL DEFAULT '0',
PRIMARY KEY (version_id)
);
--
-- -- Insert initial data --
--
INSERT INTO TBL_AUTH_USER
(user_id, login, first_name, last_name, email, password)
values (1, 'ad...@ex...', 'System', 'Admin', 'ad...@ex...',
'somepassword');
-- Start off with three user levels...
INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (1, 'Admin');
INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (2, 'User');
INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (3, 'Developer');
-- ... and only two permissions
INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin');
INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug');
-- Admins can do all the admin stuff and users can edit bugs
INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1);
INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2);
-- And user_id 1 is an admin and a user
INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 1);
INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 2);
INSERT INTO TBL_OS VALUES (1,'All',1,'');
INSERT INTO TBL_OS VALUES (2,'Windows 3.1',2,'/Mozilla.*\\(Win16.*\\)/');
INSERT INTO TBL_OS VALUES (3,'Windows 95',3,'/Mozilla.*\\(.*;.*; 32bit.*\\)/');
INSERT INTO TBL_OS VALUES (4,'Windows 98',4,'/Mozilla.*\\(Win98.*\\)/');
INSERT INTO TBL_OS VALUES (5,'Windows ME',5,'');
INSERT INTO TBL_OS VALUES (6,'Windows 2000',6,'/Mozilla.*Windows NT 5.*\\)/');
INSERT INTO TBL_OS VALUES (7,'Windows NT',7,'/Mozilla.*\\(Windows.*NT/');
INSERT INTO TBL_OS VALUES (8,'Mac System 7',8,'');
INSERT INTO TBL_OS VALUES (9,'Mac System 7.5',9,'');
INSERT INTO TBL_OS VALUES (10,'Mac System 7.6.1',10,'');
INSERT INTO TBL_OS VALUES (11,'Mac System 8.0',11,'');
INSERT INTO TBL_OS VALUES (12,'Mac System 8.5',12,'/Mozilla.*\\(.*;.*; 68K.*\\)/');
INSERT INTO TBL_OS VALUES (13,'Mac System 8.6',13,'/Mozilla.*\\(.*;.*; PPC.*\\)/');
INSERT INTO TBL_OS VALUES (14,'Mac System 9.0',14,'');
INSERT INTO TBL_OS VALUES (15,'Mac TBL_OS X',15,'');
INSERT INTO TBL_OS VALUES (16,'Linux',16,'/Mozilla.*\\(.*;.*; Linux.*\\)/');
INSERT INTO TBL_OS VALUES (17,'BSDI',17,'/Mozilla.*\\(.*;.*; BSD\\/OS.*\\)/');
INSERT INTO TBL_OS VALUES (18,'FreeBSD',18,'/Mozilla.*\\(.*;.*; FreeBSD.*\\)/');
INSERT INTO TBL_OS VALUES (19,'NetBSD',19,'');
INSERT INTO TBL_OS VALUES (20,'OpenBSD',20,'');
INSERT INTO TBL_OS VALUES (21,'AIX',21,'/Mozilla.*\\(.*;.*; AIX.*\\)/');
INSERT INTO TBL_OS VALUES (22,'BeOS',22,'');
INSERT INTO TBL_OS VALUES (23,'HP-UX',23,'/Mozilla.*\\(.*;.*; HP-UX.*\\)/');
INSERT INTO TBL_OS VALUES (24,'IRIX',24,'/Mozilla.*\\(.*;.*; IRIX.*\\)/');
INSERT INTO TBL_OS VALUES (25,'Neutrino',25,'');
INSERT INTO TBL_OS VALUES (26,'OpenVMS',26,'');
INSERT INTO TBL_OS VALUES (27,'OS/2',27,'');
INSERT INTO TBL_OS VALUES (28,'OSF/1',28,'/Mozilla.*\\(.*;.*; OSF.*\\)/');
INSERT INTO TBL_OS VALUES (29,'Solaris',29,'/Mozilla.*\\(.*;.*; SunOS 5.*\\)/');
INSERT INTO TBL_OS VALUES (30,'SunOS',30,'/Mozilla.*\\(.*;.*; SunOS.*\\)/');
INSERT INTO TBL_OS VALUES (31,'other',31,'');
INSERT INTO TBL_RESOLUTION VALUES (1,'Fixed','Bug was eliminated',1);
INSERT INTO TBL_RESOLUTION VALUES (2,'Not a bug','It\'s not a bug -- it\'s a feature!',2);
INSERT INTO TBL_RESOLUTION VALUES (3,'Won\'t Fix','This bug will stay',3);
INSERT INTO TBL_RESOLUTION VALUES (4,'Deferred','We\'ll get around to it later',4);
INSERT INTO TBL_RESOLUTION VALUES (5,'Works for me','Can\'t replicate the bug',5);
INSERT INTO TBL_RESOLUTION VALUES (6,'Duplicate','',6);
INSERT INTO TBL_SEVERITY VALUES (1,'Unassigned','Default bug creation',1,'#dadada');
INSERT INTO TBL_SEVERITY VALUES (2,'Idea','Ideas for further development',2,'#dad0d0');
INSERT INTO TBL_SEVERITY VALUES (3,'Feature Request','Requests for specific features',3,'#dacaca');
INSERT INTO TBL_SEVERITY VALUES (4,'Annoyance','Cosmetic problems or bugs not affecting performance',4,'#dac0c0');
INSERT INTO TBL_SEVERITY VALUES (5,'Content','Non-functional related bugs, such as text content',5,'#dababa');
INSERT INTO TBL_SEVERITY VALUES (6,'Significant','A bug affecting the intended performance of the product',6,'#dab0b0');
INSERT INTO TBL_SEVERITY VALUES (7,'Critical','A bug severe enough to prevent the release of the product',7,'#daaaaa');
INSERT INTO TBL_STATUS VALUES (1,'Unconfirmed','Reported but not confirmed',1);
INSERT INTO TBL_STATUS VALUES (2,'New','A new bug',2);
INSERT INTO TBL_STATUS VALUES (3,'Assigned','Assigned to a developer',3);
INSERT INTO TBL_STATUS VALUES (4,'Reopened','Closed but opened again for further inspection',4);
INSERT INTO TBL_STATUS VALUES (5,'Resolved','Set by engineer with a resolution',5);
INSERT INTO TBL_STATUS VALUES (6,'Verified','The resolution is confirmed by the reporter',6);
INSERT INTO TBL_STATUS VALUES (7,'Closed','The bug is officially squashed (QA)',7);
--
-- -- Conversion from 0.2.x to 0.3.0 --
--
--INSERT INTO TBL_ATTACHMENT SELECT * FROM Attachment;
--INSERT INTO TBL_AUTH_USER SELECT UserID, Email, FirstName, LastName, Email, Password, if (UserLevel > 0, 1, 0), '', 0, CreatedDate, 0, CreatedDate FROM User;
--INSERT INTO TBL_BUG SELECT *, 0 FROM Bug;
--INSERT INTO TBL_BUG_HISTORY SELECT * FROM BugHistory;
--INSERT INTO TBL_COMMENT SELECT * FROM Comment;
--INSERT INTO TBL_COMPONENT SELECT * FROM Component;
--INSERT INTO TBL_OS SELECT * FROM OS;
--INSERT INTO TBL_PROJECT SELECT *, CreatedBy, CreatedDate FROM Project;
--INSERT INTO TBL_RESOLUTION SELECT * FROM Resolution;
--INSERT INTO TBL_SAVED_QUERY SELECT * FROM SavedQuery;
--INSERT INTO TBL_SEVERITY SELECT *, '' FROM Severity;
--UPDATE TBL_SEVERITY SET severity_color = '#dadada' WHERE severity_id = '1';
--UPDATE TBL_SEVERITY SET severity_color = '#dad0d0' WHERE severity_id = '2';
--UPDATE TBL_SEVERITY SET severity_color = '#dacaca' WHERE severity_id = '3';
--UPDATE TBL_SEVERITY SET severity_color = '#dac0c0' WHERE severity_id = '4';
--UPDATE TBL_SEVERITY SET severity_color = '#dababa' WHERE severity_id = '5';
--UPDATE TBL_SEVERITY SET severity_color = '#dab0b0' WHERE severity_id = '6';
--UPDATE TBL_SEVERITY SET severity_color = '#daaaaa' WHERE severity_id = '7';
--INSERT INTO TBL_STATUS SELECT * FROM Status;
--INSERT INTO TBL_VERSION SELECT *, CreatedBy, CreatedDate FROM Version;
-- Start off with three user levels...
--INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (1, 'Admin');
--INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (2, 'User');
--INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (3, 'Developer');
-- ... and only two permissions
--INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin');
--INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug');
-- Admins can do all the admin stuff and users can edit bugs
--INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1);
--INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2);
-- Move users into the new tables
--INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, group_id FROM User, TBL_AUTH_GROUP where UserLevel = 15 and group_name = 'Admin';
--INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, group_id FROM User, TBL_AUTH_GROUP where UserLevel = 3 and group_name = 'Developer';
--INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, 2 FROM User where UserLevel > 0;
--
-- Indexes for table TBL_GROUP_PERM
--
CREATE INDEX perm_id_TBL_GROUP_PERM_index ON TBL_GROUP_PERM (perm_id);
--
-- Indexes for table TBL_USER_GROUP
--
CREATE INDEX group_id_TBL_USER_GROUP_index ON TBL_USER_GROUP (group_id);
--
-- Indexes for table ACTIVE_SESSIONS
--
CREATE INDEX changed_active_sessions_index ON active_sessions (changed);
--
-- Indexes for table TBL_USER_PERM
--
CREATE INDEX perm_id_TBL_USER_PERM_index ON TBL_USER_PERM (perm_id);
--
-- Indexes for table TBL_BUG_GROUP
--
CREATE INDEX group_id_TBL_BUG_GROUP_index ON TBL_BUG_GROUP (group_id);
--
-- Sequences for table TBL_SAVED_QUERY
--
SELECT SETVAL('tbl_saved_query_saved_query_',(select case when max(saved_query_id)>0 then max(saved_query_id)+1 else 1 end from TBL_SAVED_QUERY));
COMMIT;
--- mysql.sql.in DELETED ---
--- postgres.sql.in DELETED ---
|
|
From: Benjamin C. <bc...@us...> - 2001-09-15 15:54:05
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv11541
Modified Files:
config.php
Log Message:
A little bit of clean-up
Index: config.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/config.php,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- config.php 2001/09/07 13:49:14 1.9
+++ config.php 2001/09/15 15:54:03 1.10
@@ -28,7 +28,7 @@
define ('PHPLIBPATH', ''); // If not in the include path
define ('JPGRAPH_PATH', ''); // If not in the include path
-//Database Config
+// Database Config
define ('DB_TYPE', 'mysql'); //using PHPlib file naming
define ('DB_HOST', 'localhost');
define ('DB_DATABASE', 'BugTracker');
@@ -54,10 +54,9 @@
define ('DATEFORMAT', 'm-d-Y');
define ('TIMEFORMAT', 'g:i A');
-//Database Table Config
-//you can change either the prefix of the table names or each table name individually
-//define ('TBL_PREFIX', 'phpbt_'); //the prefix for all tables
-define ('TBL_PREFIX', ''); //the prefix for all tables, leave empty to use the old style
+// Database Table Config
+// you can change either the prefix of the table names or each table name individually
+define ('TBL_PREFIX', ''); // the prefix for all tables, leave empty to use the old style
define ('TBL_ATTACHMENT', TBL_PREFIX.'attachment');
define ('TBL_AUTH_GROUP', TBL_PREFIX.'auth_group');
define ('TBL_AUTH_PERM', TBL_PREFIX.'auth_perm');
|
|
From: Benjamin C. <bc...@us...> - 2001-09-15 15:49:47
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv10875 Modified Files: configure Log Message: Getting there... Index: configure =================================================================== RCS file: /cvsroot/phpbt/phpbt/configure,v retrieving revision 1.9 retrieving revision 1.10 diff -u -r1.9 -r1.10 --- configure 2001/09/15 15:39:57 1.9 +++ configure 2001/09/15 15:49:42 1.10 @@ -83,8 +83,8 @@ $DIALOG --backtitle "phpBT Configuration" \ --title "Database Server Software (1 of 5)" \ --radiolist "Enter the type database server" 0 0 3 \ - MySQL '' on \ - Postgres '' off + mysql MySQL on \ + pgsql PostgreSQL off \ 2> $tempfile if [ $? -gt 0 ]; then return @@ -247,9 +247,11 @@ echo "/INSTALLURL/s|, '.*'|, '$INSTALLURL'|" >> $tempfile echo "/PHPLIBPATH/s|, '.*'|, '$PHPLIBPATH'|" >> $tempfile echo "/JPGRAPH_PATH/s|, '.*'|, '$JPGRAPH_PATH'|" >> $tempfile + echo "/DB_TYPE/s|, '.*'|, '$DB_TYPE'|" >> $tempfile echo "/DB_HOST/s|, '.*'|, '$DB_HOST'|" >> $tempfile echo "/DB_USER/s|, '.*'|, '$DB_USER'|" >> $tempfile echo "/DB_PASSWORD/s|, '.*'|, '$DB_PASS'|" >> $tempfile + echo "/TBL_PREFIX/s|, '.*'|, '$DB_TBL_PREFIX'|" >> $tempfile sed -f $tempfile config.php.bak > config.php $DIALOG --backtitle "phpBT Configuration" \ --infobox "Your changes have been saved" 5 36 |
2 messages has been excluded from this view by a project administrator.
