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: Patrick M. <mo...@us...> - 2001-09-11 07:43:26
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv3255
Modified Files:
configure_db
Log Message:
modified template-note removing for PostgreSQL
Index: configure_db
===================================================================
RCS file: /cvsroot/phpbt/phpbt/configure_db,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- configure_db 2001/09/11 03:02:13 1.2
+++ configure_db 2001/09/11 07:43:24 1.3
@@ -33,7 +33,8 @@
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:.*$/#/
+ s/^--\ TEMPLATE:.*$/--/
" > $2
}
|
|
From: Benjamin C. <bc...@us...> - 2001-09-11 04:23:07
|
Update of /cvsroot/phpbt/phpbt/admin
In directory usw-pr-cvs1:/tmp/cvs-serv7849
Modified Files:
project.php
Log Message:
Moving all the project admin to project.php -- currently broken
Index: project.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/project.php,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -r1.15 -r1.16
--- project.php 2001/09/03 17:20:16 1.15
+++ project.php 2001/09/11 04:23:03 1.16
@@ -25,80 +25,34 @@
define('INCLUDE_PATH', '../');
include INCLUDE_PATH.'include.php';
-function do_form($projectid = 0) {
- global $q, $me, $name, $description, $active, $version, $u, $STRING, $now;
+function show_version($versionid = 0, $error = '') {
+ global $q, $t, $_pv, $STRING;
- // Validation
- if (!$name = htmlspecialchars(trim($name)))
- $error = $STRING['givename'];
- elseif (!$description = htmlspecialchars(trim($description)))
- $error = $STRING['givedesc'];
- elseif (!projectid and !$version = htmlspecialchars(trim($version)))
- $error = $STRING['giveversion'];
- if ($error) { show_form($projectid, $error); return; }
-
- if (!$active) $active = 0;
- if (!$projectid) {
- $projectid = $q->nextid(TBL_PROJECT);
- $q->query("insert into ".TBL_PROJECT." (project_id, project_name, project_desc, active, created_by, created_date)"
- ." values ($projectid , '$name', '$description', $active, $u, $now)");
- $q->query("insert into ".TBL_VERSION." (version_id, project_id, version_name, active, created_by, created_date)"
- ." values (".$q->nextid(TBL_VERSION).", $projectid, '$version', $active, $u, $now)");
- $location = "component.php?op=add&projectid=$projectid";
- } else {
- $q->query("update ".TBL_PROJECT." set project_name = '$name', project_desc = '$description', active = $active where project_id = $projectid");
- $location = "$me?";
- }
- header("Location: $location");
-}
-
-function show_form($projectid = 0, $error = '') {
- global $q, $me, $t, $name, $description, $active, $version, $TITLE;
-
- $t->set_file('content','projectform.html');
- $t->set_block('content','box','details');
- $t->set_block('content','vfield','verfield');
- if ($projectid && !$error) {
- $row = $q->grab("select * from ".TBL_PROJECT." where project_id = $projectid");
- $t->set_var(array(
- 'projectid' => $row['project_id'],
- 'name' => $row['project_name'],
- 'description' => $row['project_desc'],
- 'active' => $row['active'] ? 'checked' : '',
- 'createdby' => $row['created_by'],
- 'createddate' => $row['created_date'],
- 'TITLE' => $TITLE['editproject']
- ));
- } else {
- $t->set_var(array(
- 'error' => $error,
- 'projectid' => $projectid,
- 'name' => $name,
- 'description' => $description,
- 'active' => (isset($active) and !$active) ? '' : 'checked',
- 'createdby' => $createdby,
- 'createddate' => $createddate,
- 'TITLE' => $projectid ? $TITLE['editproject'] : $TITLE['addproject']
- ));
- }
- if ($projectid) {
- $t->set_var('verfield','');
- list_components($projectid);
- list_versions($projectid);
- $t->parse('details','box',true);
+ foreach ($_pv as $k => $v) $$k = $v;
+
+ $t->set_file('content','versionform.html');
+ if ($versionid && !$error) {
+ $row = $q->grab("select v.*, p.project_name as project_name"
+ ." from ".TBL_VERSION." v left join ".TBL_PROJECT." p using(project_id)"
+ ." where version_id = '$versionid'");
+ $t->set_var(array(
+ 'versionid' => $row['version_id'],
+ 'vf_version' => $row['version_name'],
+ 'vf_active' => $row['active'] ? 'checked' : '',
+ 'vf_action' => $STRING['edit']));
} else {
$t->set_var(array(
- 'details' => '',
- 'version' => $version
- ));
- $t->parse('verfield','vfield',true);
+ 'vf_error' => $error,
+ 'versionid' => $versionid,
+ 'vf_version' => $vf_version,
+ 'vf_active' => isset($vf_active) && !$vf_active ? '' : ' checked',
+ 'vf_action' => $versionid ? $STRING['edit'] : $STRING['addnew']));
}
}
function list_versions($projectid) {
global $q, $t, $STRING;
- $t->set_block('box','verrow','verrows');
$q->query("select * from ".TBL_VERSION." where project_id = $projectid");
if (!$q->num_rows()) {
$t->set_var('verrows',"<tr><td colspan='2' align='center'>{$STRING['noversions']}</td></tr>");
@@ -117,11 +71,38 @@
}
}
+function show_component($componentid = 0, $error = '') {
+ global $q, $t, $_pv, $STRING;
+
+ foreach ($_pv as $k => $v) $$k = $v;
+
+ $t->set_file('content','componentform.html');
+ if ($componentid && !$error) {
+ $row = $q->grab('select c.*, p.project_name as project_name
+ from '.TBL_COMPONENT.' c left join '.TBL_PROJECT." p using (project_id)
+ where component_id = '$componentid'");
+ $t->set_var(array(
+ 'componentid' => $row['component_id'],
+ 'cf_name' => $row['component_name'],
+ 'cf_description' => $row['component_desc'],
+ 'cf_owner' => build_select('owner', $row['owner']),
+ 'cf_active' => $row['active'] ? 'checked' : '',
+ 'cf_action' => $STRING['edit']));
+ } else {
+ $t->set_var(array(
+ 'cf_error' => $error,
+ 'componentid' => $componentid,
+ 'cf_name' => $cf_name,
+ 'cf_description' => $cf_description,
+ 'cf_owner' => build_select('owner', $cf_owner),
+ 'cf_active' => (isset($cf_active) and !$cf_active) ? '' : 'checked',
+ 'cf_action' => $componentid ? $STRING['edit'] : $STRING['addnew']));
+ }
+}
function list_components($projectid) {
global $q, $t, $STRING;
- $t->set_block('box','row','rows');
$q->query("select * from ".TBL_COMPONENT." where project_id = $projectid");
if (!$q->num_rows()) {
$t->set_var('rows',"<tr><td colspan='2' align='center'>{$STRING['nocomponents']}</td></tr>");
@@ -144,8 +125,78 @@
$t->parse('rows','row',true);
}
}
+
+function save_project($projectid = 0) {
+ global $q, $me, $u, $STRING, $now, $_pv;
+
+ // Validation
+ if (!$_pv['name'] = htmlspecialchars(trim($_pv['name']))) {
+ $error = $STRING['givename'];
+ } elseif (!$_pv['description'] = htmlspecialchars(trim($_pv['description']))) {
+ $error = $STRING['givedesc'];
+ } elseif (!$_pv['projectid'] and
+ !$_pv['version'] = htmlspecialchars(trim($_pv['version']))) {
+ $error = $STRING['giveversion'];
+ }
+ if ($error) { show_form($projectid, $error); return; }
+
+ foreach ($_pv as $k => $v) $$k = $v;
+ if (!$active) $active = 0;
+ if (!$projectid) {
+ $projectid = $q->nextid(TBL_PROJECT);
+ $q->query('insert into '.TBL_PROJECT
+ ." (project_id, project_name, project_desc, active, created_by, created_date)
+ values ($projectid , '$name', '$description', $active, $u, $now)");
+ $q->query('insert into '.TBL_VERSION
+ ." (version_id, project_id, version_name, active, created_by, created_date)
+ values (".$q->nextid(TBL_VERSION).", $projectid, '$version', $active, $u, $now)");
+ } else {
+ $q->query('update '.TBL_PROJECT
+ ." set project_name = '$name', project_desc = '$description',
+ active = $active where project_id = $projectid");
+ }
+ header("Location: $me?op=edit&id=$projectid");
+}
+
+function show_project($projectid = 0, $error = '') {
+ global $q, $me, $t, $name, $description, $active, $version, $TITLE, $_gv;
+
+ if ($projectid && !$error) {
+ $row = $q->grab('select * from '.TBL_PROJECT
+ ." where project_id = $projectid");
+ $t->set_var(array(
+ 'projectid' => $row['project_id'],
+ 'name' => $row['project_name'],
+ 'description' => $row['project_desc'],
+ 'active' => $row['active'] ? 'checked' : '',
+ 'TITLE' => $TITLE['editproject']
+ ));
+ } else {
+ $t->set_var(array(
+ 'error' => $error,
+ 'projectid' => $projectid,
+ 'name' => stripslashes($name),
+ 'description' => stripslashes($description),
+ 'version' => stripslashes($version),
+ 'active' => (isset($active) and !$active) ? '' : 'checked',
+ 'TITLE' => $projectid ? $TITLE['editproject'] : $TITLE['addproject']
+ ));
+ }
+
+ if ($projectid) {
+ $t->set_file('content','project-edit.html');
+ $t->set_block('content', 'verrow', 'verrows');
+ $t->set_block('content', 'row', 'rows');
+ list_components($projectid);
+ list_versions($projectid);
+ } else {
+ $t->set_file('content','project-add.html');
+ }
+ show_version($_gv['versionid']);
+ show_component($_gv['componentid']);
+}
-function list_items() {
+function list_projects() {
global $me, $q, $t, $selrange, $order, $sort, $STRING, $TITLE, $page;
$t->set_file('content','projectlist.html');
@@ -201,12 +252,18 @@
$perm->check('Administrator');
-if (isset($_gv['op'])) switch($_gv['op']) {
- case 'add' : show_form(); break;
- case 'edit' : show_form($_gv['id']); break;
-} elseif(isset($_pv['submit'])) {
- do_form($_pv['id']);
-} else list_items();
+if (isset($_gv['op'])) {
+ switch($_gv['op']) {
+ case 'add' : show_project(); break;
+ case 'edit' : show_project($_gv['id']); break;
+ }
+} elseif (isset($_pv['do'])) {
+ switch($_pv['do']) {
+ case 'project' : save_project($_pv['id']); break;
+ case 'version' : save_version(); break;
+ case 'component' : save_component(); break;
+ }
+} else list_projects();
$t->pparse('main',array('content','wrap','main'));
|
|
From: Benjamin C. <bc...@us...> - 2001-09-11 04:23:06
|
Update of /cvsroot/phpbt/phpbt/admin/templates/default
In directory usw-pr-cvs1:/tmp/cvs-serv7849/templates/default
Added Files:
project-add.html project-edit.html
Removed Files:
projectform.html
Log Message:
Moving all the project admin to project.php -- currently broken
--- NEW FILE: project-add.html ---
<form action="project.php" method="post">
<input type="hidden" name="id" value="{projectid}">
<table border='0'>
<tr>
<td colspan="2"><font color="#ff0000">{error}</td>
</tr>
<tr>
<td align="right" valign="top">Name:</td>
<td><input type="text" size="30" maxlength="30" name="name" value="{name}"></td>
</tr>
<tr>
<td align="right" valign="top">Version:</td>
<td><input type="text" name="version" value="{version}"></td>
</tr>
<tr>
<td align="right" valign="top">Description:</td>
<td><textarea name="description" cols=40 rows=5 wrap=virtual>{description}</textarea></td>
</tr>
<tr>
<td align="right" valign="top">Active:</td>
<td align="left" valign="top"><input type="checkbox" name="active" value="1" {active}></td>
</tr>
</table>
<input type='submit' name='submit' value='Submit'>
</form>
--- NEW FILE: project-edit.html ---
<form action="project.php" method="post">
<input type="hidden" name="id" value="{projectid}">
<input type="hidden" name="do" value="project">
<table border='0'>
<tr>
<td colspan="2"><font color="#ff0000">{error}</td>
</tr>
<tr>
<td align="right" valign="top">Name:</td>
<td><input type="text" size="30" maxlength="30" name="name" value="{name}"></td>
</tr>
<tr>
<td align="right" valign="top">Description:</td>
<td><textarea name="description" cols=40 rows=5 wrap=virtual>{description}</textarea></td>
</tr>
<tr>
<td align="right" valign="top">Active:</td>
<td align="left" valign="top"><input type="checkbox" name="active" value="1" {active}></td>
</tr>
</table>
<input type='submit' name='submit' value='Submit'>
</form>
<br>
<table border="0">
<tr>
<td width="320" valign="top">
<b>{vf_action} Version</b>
<hr width="320" size="1" align="center">
<table border="0">
<form action="{me}" method="post">
<input type="hidden" name="do" value="version">
<input type="hidden" name="versionid" value="{versionid}">
<input type="hidden" name="projectid" value="{projectid}">
<tr>
<td width="200">Version:</td>
<td width="120">Active:</td>
</tr>
<tr>
<td><input type="text" name="vf_version" value="{vf_version}"></td>
<td><input type="checkbox" name="vf_active" value="1" {vf_active}></td>
</tr>
</form>
</table>
</td>
<td width="320" valign="top">
<b>{cf_action} Component</b>
<hr width="320" size="1" align="center">
<table border="0">
<form action="{me}" method="post">
<input type="hidden" name="do" value="component">
<input type="hidden" name="componentid" value="{componentid}">
<input type="hidden" name="projectid" value="{projectid}">
<tr>
<td width="200">Component:</td>
<td width="120">Active:</td>
</tr>
<tr>
<td><input type="text" name="cf_name" value="{cf_name}"></td>
<td><input type="checkbox" name="cf_active" value="1" {cf_active}></td>
</tr>
<tr>
<td colspan="2">
Description:
<br>
<textarea name="cf_description" cols="40">{cf_description}</textarea>
</td>
</tr>
<tr>
<td colspan="2">
Owner:
<br>
<select name="cf_owner"><option value="0">None</option>{cf_owner}</select>
</td>
</tr>
</form>
</table>
</td>
</tr>
<tr>
<td width="320" align="right">
<input type="submit" value="{vf_action} Version">
</td>
<td width="320" align="right">
<input type="submit" value="{cf_action} Component">
</td>
</tr>
<tr>
<td width="320" valign="top">
<br>
<b>Versions of {name}</b>
<hr width="320" size="1" align="center">
<table border="0">
<tr bgcolor="#eeeeee">
<th width="160">Version</th>
<th width="100">Created</th>
<th width="60">Active</th>
</tr>
<!-- BEGIN verrow -->
<tr bgcolor="{bgcolor}">
<td><a href="{me}?op=edit&id={projectid}&versionid={verid}">{vername}</a></td>
<td align="center">{verdate}</td>
<td align="center">{veractive}</td>
</tr>
<!-- END verrow -->
</table>
</td>
<td width="320" valign="top">
<br>
<b>Components of {name}</b>
<hr width="320" size="1" align="center">
<table border="0">
<tr bgcolor="#eeeeee">
<th width="160">Component</th>
<th width="100">Created</th>
<th width="60">Active</th>
</tr>
<!-- BEGIN row -->
<tr bgcolor="{bgcolor}">
<td><a href="{me}?op=edit&id={projectid}&componentid={compid}">{compname}</a></td>
<td align="center">{compdate}</td>
<td align="center">{compactive}</td>
</tr>
<!-- END row -->
</table>
</td>
</tr>
</table>
--- projectform.html DELETED ---
|
|
From: Ben C. <php...@be...> - 2001-09-11 03:04:17
|
Javier, could you try the configure_db script on the new schemas/postgres.sql.in and see if it looks ok? I think getting this ready is the last major thing to do before releasing. |
|
From: Benjamin C. <bc...@us...> - 2001-09-11 03:02:18
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv31864 Modified Files: configure_db Log Message: Moved postgres database creation to schemas dir Index: configure_db =================================================================== RCS file: /cvsroot/phpbt/phpbt/configure_db,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- configure_db 2001/09/07 13:15:37 1.1 +++ configure_db 2001/09/11 03:02:13 1.2 @@ -39,6 +39,5 @@ #------------------------------------------------------------------------------ -#generate_sql createdb.sql.in createdb.sql -#generate_sql createdb_pg.sql.in createdb_pg.sql -generate_sql createdb.sql.in createdb.sql.out +#generate_sql schemas/postgres.sql.in createdb.sql +generate_sql schemas/mysql.sql.in createdb.sql |
|
From: Benjamin C. <bc...@us...> - 2001-09-11 03:02:18
|
Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv31864/schemas
Added Files:
postgres.sql.in
Log Message:
Moved postgres database creation to schemas dir
--- NEW FILE: postgres.sql.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: postgres.sql.in,v 1.1 2001/09/11 03:02: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;
|
|
From: Benjamin C. <bc...@us...> - 2001-09-11 03:01:25
|
Update of /cvsroot/phpbt/phpbt/schemas In directory usw-pr-cvs1:/tmp/cvs-serv31189/schemas Modified Files: mysql.sql.in Log Message: Minor tweak to comments Index: mysql.sql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.sql.in,v retrieving revision 1.3 retrieving revision 1.4 diff -u -r1.3 -r1.4 --- mysql.sql.in 2001/09/07 16:43:10 1.3 +++ mysql.sql.in 2001/09/11 03:01:21 1.4 @@ -1,4 +1,4 @@ -# MySQL database creation script template +# 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. # |
|
From: Benjamin C. <bc...@us...> - 2001-09-11 02:52:31
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv24719 Removed Files: createdb.sql Log Message: Deprecated --- createdb.sql DELETED --- |
|
From: Benjamin C. <bc...@us...> - 2001-09-08 15:59:56
|
Update of /cvsroot/phpbt/phpbt/templates/default
In directory usw-pr-cvs1:/tmp/cvs-serv7343/templates/default
Modified Files:
bugdisplay.html
Log Message:
Fixed bug with resolution and status updates
Index: bugdisplay.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/bugdisplay.html,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- bugdisplay.html 2001/08/30 13:49:08 1.5
+++ bugdisplay.html 2001/09/08 15:59:53 1.6
@@ -104,7 +104,7 @@
<!-- END arow -->
<!-- BEGIN rrow -->
<input type="radio" name="outcome" value="resolve">
- Resolve bug, changing resolution to <select name="bugresolution">{bugresolution}</select><br>
+ Resolve bug, changing resolution to <select name="resolution_id">{bugresolution}</select><br>
<input type="radio" name="outcome" value="dupe">
Resolve bug, mark it as a duplicate of bug #<input type="text" name="dupenum" size="5"><br>
<input type="radio" name="outcome" value="reassign">
|
|
From: Benjamin C. <bc...@us...> - 2001-09-08 15:59:56
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv7343
Modified Files:
bug.php
Log Message:
Fixed bug with resolution and status updates
Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.39
retrieving revision 1.40
diff -u -r1.39 -r1.40
--- bug.php 2001/09/08 14:34:52 1.39
+++ bug.php 2001/09/08 15:59:53 1.40
@@ -256,7 +256,7 @@
$q->query("insert into ".TBL_COMMENT." (comment_id, bug_id, comment_text, created_by, created_date)"
." values (".$q->nextid(TBL_COMMENT).", $bugid, 'This bug is a duplicate of bug #$dupenum', $u, $now)");
$statusfield = 'Duplicate';
- $bugresolution = $q->grab_field("select resolution_id from ".TBL_RESOLUTION." where resolution_name = 'Duplicate'");
+ $resolution_id = $q->grab_field("select resolution_id from ".TBL_RESOLUTION." where resolution_name = 'Duplicate'");
$statusfield = 'Resolved';
break;
case 'resolve' :
@@ -266,7 +266,7 @@
case 'reopen' :
$changeresolution = true;
$statusfield = 'Reopened';
- $bugresolution = 0;
+ $resolution_id = 0;
break;
case 'verify' :
$statusfield = 'Verified';
@@ -276,17 +276,19 @@
break;
}
if ($statusfield) {
- $status = $q->grab_field("select status_id from ".TBL_STATUS." where status_name = '$statusfield'");
- $changedfields['status'] = $status;
+ $status_id = $q->grab_field("select status_id from ".TBL_STATUS." where status_name = '$statusfield'");
+ $changedfields['status_id'] = $status_id;
}
-
+ if ($changeresolution) {
+ $changedfields['resolution_id'] = $resolution_id;
+ }
if ($comments) {
$comments = htmlspecialchars($comments);
$q->query("insert into ".TBL_COMMENT." (comment_id, bug_id, comment_text, created_by, created_date)"
." values (".$q->nextid(TBL_COMMENT).", $bugid, '$comments', $u, $now)");
}
- $q->query("update ".TBL_BUG." set title = '$title', url = '$url', severity_id = $severity_id, priority = $priority, ".($status ? "status_id = $status, " : ''). ($changeresolution ? "resolution_id = $bugresolution, " : ''). ($assignedto ? "assigned_to = $assignedto, " : '')." project_id = $project_id, version_id = $version_id, component_id = $component_id, os_id = $os_id, last_modified_by = $u, last_modified_date = $now where bug_id = $bugid");
+ $q->query("update ".TBL_BUG." set title = '$title', url = '$url', severity_id = $severity_id, priority = $priority, ".($status_id ? "status_id = $status_id, " : ''). ($changeresolution ? "resolution_id = $resolution_id, " : ''). ($assignedto ? "assigned_to = $assignedto, " : '')." project_id = $project_id, version_id = $version_id, component_id = $component_id, os_id = $os_id, last_modified_by = $u, last_modified_date = $now where bug_id = $bugid");
if ($changedfields or $comments) {
do_changedfields($u, $buginfo, $changedfields, $comments);
|
|
From: Benjamin C. <bc...@us...> - 2001-09-08 14:34:56
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv20859
Modified Files:
bug.php
Log Message:
Fixed a bug in the change notification
Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.38
retrieving revision 1.39
diff -u -r1.38 -r1.39
--- bug.php 2001/09/03 17:59:11 1.38
+++ bug.php 2001/09/08 14:34:52 1.39
@@ -105,13 +105,13 @@
.' (bug_id, changed_field, old_value, new_value, created_by, created_date)'
." values ({$buginfo['bug_id']}, '$field', '$oldvalue', '$newvalue', $u, $now)");
$t->set_var(array(
- $field => stripslashes($newvalue),
- $field.'Stat' => '!'
+ $field.'_id' => stripslashes($newvalue),
+ $field.'_id_stat' => '!'
));
} else {
$t->set_var(array(
- $field => stripslashes($oldvalue),
- $field.'Stat' => ' '
+ $field.'_id' => stripslashes($oldvalue),
+ $field.'_id_stat' => ' '
));
}
}
|
|
From: Benjamin C. <bc...@us...> - 2001-09-07 16:43:13
|
Update of /cvsroot/phpbt/phpbt/schemas In directory usw-pr-cvs1:/tmp/cvs-serv28655/schemas Modified Files: mysql.sql.in Log Message: Conversion stuff Index: mysql.sql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.sql.in,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- mysql.sql.in 2001/09/07 16:14:31 1.2 +++ mysql.sql.in 2001/09/07 16:43:10 1.3 @@ -225,7 +225,10 @@ PRIMARY KEY (version_id) ) TYPE=MyISAM; -# Populate database with some initial data +# +# -- 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...', @@ -303,4 +306,47 @@ 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; |
|
From: Benjamin C. <bc...@us...> - 2001-09-07 16:14:34
|
Update of /cvsroot/phpbt/phpbt/schemas In directory usw-pr-cvs1:/tmp/cvs-serv14282/schemas Modified Files: mysql.sql.in Log Message: Add the colors for severity Index: mysql.sql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.sql.in,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- mysql.sql.in 2001/09/07 13:50:06 1.1 +++ mysql.sql.in 2001/09/07 16:14:31 1.2 @@ -288,13 +288,13 @@ 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); -INSERT INTO TBL_SEVERITY VALUES (2,'Idea','Ideas for further development',2); -INSERT INTO TBL_SEVERITY VALUES (3,'Feature Request','Requests for specific features',3); -INSERT INTO TBL_SEVERITY VALUES (4,'Annoyance','Cosmetic problems or bugs not affecting performance',4); -INSERT INTO TBL_SEVERITY VALUES (5,'Content','Non-functional related bugs, such as text content',5); -INSERT INTO TBL_SEVERITY VALUES (6,'Significant','A bug affecting the intended performance of the product',6); -INSERT INTO TBL_SEVERITY VALUES (7,'Critical','A bug severe enough to prevent the release of the product',7); +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); |
|
From: Patrick M. <mo...@us...> - 2001-09-07 13:55:52
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv12640 Removed Files: createdb.sql.in Log Message: moved to schemas/ --- createdb.sql.in DELETED --- |
|
From: Ben C. <php...@be...> - 2001-09-07 13:51:53
|
Ok, you now have schemas/mysql.sql.in to play with. On Fri, Sep 07, 2001 at 03:26:44PM +0200, Patrick Mairif wrote: > On Fri, 7 Sep 2001, Ben Curtis wrote: > > This is a great idea. Let me move the schema files into a subdir to get > > started on this. I agree the sed script should be separate from the > > configure script. Once I move the schema files, could you create the > > shell script in the next few days so we could include it in this > > release? > > as you can see, I allready began with the script. just move the schema > files, I will modify the script than. > > -- > http://home.nikocity.de/mairif > http://www.caravan-network.de > > > _______________________________________________ > phpbt-dev mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpbt-dev |
|
From: Benjamin C. <bc...@us...> - 2001-09-07 13:50:11
|
Update of /cvsroot/phpbt/phpbt/schemas In directory usw-pr-cvs1:/tmp/cvs-serv9985/schemas Added Files: mysql.sql.in Log Message: MySQL db schema template --- NEW FILE: mysql.sql.in --- # MySQL database creation script template # 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.sql.in,v 1.1 2001/09/07 13:50:06 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; # Populate database with some 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); INSERT INTO TBL_SEVERITY VALUES (2,'Idea','Ideas for further development',2); INSERT INTO TBL_SEVERITY VALUES (3,'Feature Request','Requests for specific features',3); INSERT INTO TBL_SEVERITY VALUES (4,'Annoyance','Cosmetic problems or bugs not affecting performance',4); INSERT INTO TBL_SEVERITY VALUES (5,'Content','Non-functional related bugs, such as text content',5); INSERT INTO TBL_SEVERITY VALUES (6,'Significant','A bug affecting the intended performance of the product',6); INSERT INTO TBL_SEVERITY VALUES (7,'Critical','A bug severe enough to prevent the release of the product',7); 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); |
|
From: Benjamin C. <bc...@us...> - 2001-09-07 13:49:35
|
Update of /cvsroot/phpbt/phpbt/schemas In directory usw-pr-cvs1:/tmp/cvs-serv9718/schemas Log Message: Directory /cvsroot/phpbt/phpbt/schemas added to the repository |
|
From: Benjamin C. <bc...@us...> - 2001-09-07 13:49:18
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv9618
Modified Files:
config.php
Log Message:
While doing the new schema file I decided to alphabetize this list. :)
Index: config.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/config.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- config.php 2001/09/03 15:04:49 1.8
+++ config.php 2001/09/07 13:49:14 1.9
@@ -59,24 +59,24 @@
//define ('TBL_PREFIX', 'phpbt_'); //the prefix for all tables
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');
+define ('TBL_AUTH_USER', TBL_PREFIX.'auth_user');
define ('TBL_BUG', TBL_PREFIX.'bug');
+define ('TBL_BUG_GROUP', TBL_PREFIX.'bug_group');
define ('TBL_BUG_HISTORY', TBL_PREFIX.'bug_history');
define ('TBL_COMMENT', TBL_PREFIX.'comment');
define ('TBL_COMPONENT', TBL_PREFIX.'component');
+define ('TBL_GROUP_PERM', TBL_PREFIX.'group_perm');
+define ('TBL_OS', TBL_PREFIX.'os');
define ('TBL_PROJECT', TBL_PREFIX.'project');
define ('TBL_RESOLUTION', TBL_PREFIX.'resolution');
define ('TBL_SAVED_QUERY', TBL_PREFIX.'saved_query');
define ('TBL_SEVERITY', TBL_PREFIX.'severity');
define ('TBL_STATUS', TBL_PREFIX.'status');
-define ('TBL_AUTH_USER', TBL_PREFIX.'auth_user');
-define ('TBL_VERSION', TBL_PREFIX.'version');
-define ('TBL_OS', TBL_PREFIX.'os');
-define ('TBL_AUTH_GROUP', TBL_PREFIX.'auth_group');
-define ('TBL_AUTH_PERM', TBL_PREFIX.'auth_perm');
define ('TBL_USER_GROUP', TBL_PREFIX.'user_group');
define ('TBL_USER_PERM', TBL_PREFIX.'user_perm');
-define ('TBL_GROUP_PERM', TBL_PREFIX.'group_perm');
-define ('TBL_BUG_GROUP', TBL_PREFIX.'bug_group');
+define ('TBL_VERSION', TBL_PREFIX.'version');
define ('TBL_PROJECT_GROUP', TBL_PREFIX.'project_group');
require_once (PHPLIBPATH.'db_'.DB_TYPE.'.inc');
|
|
From: Patrick M. <mai...@st...> - 2001-09-07 13:26:49
|
On Fri, 7 Sep 2001, Ben Curtis wrote: > This is a great idea. Let me move the schema files into a subdir to get > started on this. I agree the sed script should be separate from the > configure script. Once I move the schema files, could you create the > shell script in the next few days so we could include it in this > release? as you can see, I allready began with the script. just move the schema files, I will modify the script than. -- http://home.nikocity.de/mairif http://www.caravan-network.de |
|
From: Patrick M. <mai...@st...> - 2001-09-07 13:23:59
|
On Fri, 7 Sep 2001, Ben Curtis wrote: > Yup, I've been thinking about it, but I'm torn between spending my time on this coding or documenting. It's one of those important but not urgent things that keeps getting put off. perhaps I use it as a starting point to understand phpbt in depth. but I won't promise sth.! :) > It seems that phpdoc is more suited for documenting classes, no? I'm not familiar with sth. I'm not familiar with it, too. I always wanted to take a look at... I think sourceforge has some documentation manager, perhaps it is usefull for our purpose!? -- http://home.nikocity.de/mairif http://www.caravan-network.de |
|
From: Benjamin C. <bc...@us...> - 2001-09-07 13:17:41
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv26953
Modified Files:
include.php
Log Message:
Take perm out since Auth::unauth does it :)
Index: include.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/include.php,v
retrieving revision 1.53
retrieving revision 1.54
diff -u -r1.53 -r1.54
--- include.php 2001/09/05 17:19:20 1.53
+++ include.php 2001/09/07 13:17:37 1.54
@@ -141,7 +141,6 @@
function unauth($nobody = false) {
Auth::unauth($nobody);
$this->auth['group'] = '';
- $this->auth['perm'] = '';
$this->auth['db_fields'] = '';
}
}
|
|
From: Ben C. <php...@be...> - 2001-09-07 13:16:16
|
This is a great idea. Let me move the schema files into a subdir to get started on this. I agree the sed script should be separate from the configure script. Once I move the schema files, could you create the shell script in the next few days so we could include it in this release?
On Fri, Sep 07, 2001 at 01:57:41PM +0200, Patrick Mairif wrote:
> now, that it's possible to tell phpbt to use other tablenames createdb.sql
> still creates hard coded names. to make this part dynamic we need some
> kind of template for createdb.sql, for example createdb.sql.template,
> which contains entries like
>
> DROP TABLE IF EXISTS TBL_OS;
> CREATE TABLE TBL_OS (
>
> Those enrtries like TBL_OS have to be replaced by real tablenames.
> Therefor I could create a shell-script like the following
>
> PREFIX="phpbt_"
>
> cat createdb.sql.template | sed "
> s/TBL_OS/${PREFIX}os/g
> s/TBL_BUG/${PREFIX}bug/g
> " > createdb.sql
>
> this script can be modified to use an argument as prefix and can be used
> in configure.
>
> it could be a function, but I would like to have a script independent
> from configure to create the createdb.sql.
>
> what do you think?
>
> Should this go in this release or the next?
>
> --
> http://home.nikocity.de/mairif
> http://www.caravan-network.de
>
>
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpbt-dev
|
|
From: Patrick M. <mo...@us...> - 2001-09-07 13:15:40
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv25668
Added Files:
configure_db createdb.sql.in
Log Message:
first try of an sql-template-system for dynamic table-names
createdb.sql.in is NOT functional, it's only an partially modified createdb.sql for demonstration purposes!
--- NEW FILE: configure_db ---
#!/bin/bash
# Script to generate database-creation-scripts
# $Id: configure_db,v 1.1 2001/09/07 13:15:37 mohni Exp $
# prefix for tablenames
#TBL_PREFIX="phpbt_"
TBL_PREFIX=""
#------------------------------------------------------------------------------
#parameters:
# $TBL_PREFIX prefix for tablenames
# $1 filename for input
# $2 filename for output
generate_sql() {
cat $1 | sed "
s/TBL_ATTACHMENT/${TBL_PREFIX}attachment/g
s/TBL_BUG/${TBL_PREFIX}bug/g
s/TBL_BUG_HISTORY/${TBL_PREFIX}bug_history/g
s/TBL_COMMENT/${TBL_PREFIX}comment/g
s/TBL_COMPONENT/${TBL_PREFIX}component/g
s/TBL_PROJECT/${TBL_PREFIX}project/g
s/TBL_RESOLUTION/${TBL_PREFIX}resolution/g
s/TBL_SAVED_QUERY/${TBL_PREFIX}saved_query/g
s/TBL_SEVERITY/${TBL_PREFIX}severity/g
s/TBL_STATUS/${TBL_PREFIX}status/g
s/TBL_AUTH_USER/${TBL_PREFIX}auth_user/g
s/TBL_VERSION/${TBL_PREFIX}version/g
s/TBL_OS/${TBL_PREFIX}os/g
s/TBL_AUTH_GROUP/${TBL_PREFIX}auth_group/g
s/TBL_AUTH_PERM/${TBL_PREFIX}auth_perm/g
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:.*$//
" > $2
}
#------------------------------------------------------------------------------
#generate_sql createdb.sql.in createdb.sql
#generate_sql createdb_pg.sql.in createdb_pg.sql
generate_sql createdb.sql.in createdb.sql.out
--- NEW FILE: createdb.sql.in ---
# Database creation script (MySQL)
# If you change the database name, make sure you change it in dbclass in
# include.php. Make sure you edit the User insert below.
#
# TEMPLATE: This is a template for configure_db. Don't use it directly to create your database!
create database BugTracker;
use BugTracker;
#
# Table structure for table 'db_sequence'
#
DROP TABLE IF EXISTS db_sequence;
CREATE TABLE db_sequence (
seq_name varchar(127) DEFAULT '' NOT NULL,
nextid int(10) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (seq_name)
);
#
# Table structure for table 'User'
#
DROP TABLE IF EXISTS TBL_AUTH_USER;
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 login (login)
);
# -- EDIT THIS --
#insert into TBL_AUTH_USER values (1, 'System', 'Admin', 'ro...@yo...', 'somepassword', 15, unix_timestamp(now()));
insert into db_sequence values ('User', 1);
#
# Table structure for table 'Bug'
#
DROP TABLE IF EXISTS TBL_BUG;
CREATE TABLE TBL_BUG (
BugID int(10) unsigned DEFAULT '0' NOT NULL,
Title varchar(30) DEFAULT '' NOT NULL,
Description text DEFAULT '' NOT NULL,
URL varchar(255) DEFAULT '' NOT NULL,
Severity tinyint(3) unsigned DEFAULT '0' NOT NULL,
Priority tinyint(3) unsigned DEFAULT '0' NOT NULL,
Status tinyint(3) unsigned DEFAULT '0' NOT NULL,
Resolution tinyint(3) unsigned DEFAULT '0' NOT NULL,
AssignedTo int(10) unsigned DEFAULT '0' NOT NULL,
CreatedBy int(10) unsigned DEFAULT '0' NOT NULL,
CreatedDate bigint(20) unsigned DEFAULT '0' NOT NULL,
LastModifiedBy int(10) unsigned DEFAULT '0' NOT NULL,
LastModifiedDate bigint(20) unsigned DEFAULT '0' NOT NULL,
Project int(10) unsigned DEFAULT '0' NOT NULL,
Version varchar(5) DEFAULT '' NOT NULL,
Component int(10) unsigned DEFAULT '0' NOT NULL,
OS tinyint(3) unsigned DEFAULT '0' NOT NULL,
BrowserString varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (BugID)
);
#
# Table structure for table 'Comment'
#
DROP TABLE IF EXISTS TBL_COMMENT;
CREATE TABLE TBL_COMMENT (
CommentID int(10) unsigned DEFAULT '0' NOT NULL,
BugID int(10) unsigned DEFAULT '0' NOT NULL,
Text text DEFAULT '' NOT NULL,
CreatedBy int(10) unsigned DEFAULT '0' NOT NULL,
CreatedDate bigint(20) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (CommentID)
);
#
# Table structure for table 'Component'
#
DROP TABLE IF EXISTS TBL_COMPONENT;
CREATE TABLE TBL_COMPONENT (
ComponentID int(10) unsigned DEFAULT '0' NOT NULL,
ProjectID int(10) unsigned DEFAULT '0' NOT NULL,
Name varchar(30) DEFAULT '' NOT NULL,
Description text DEFAULT '' NOT NULL,
Owner int(10) unsigned DEFAULT '0' NOT NULL,
Active char(1) binary DEFAULT '1' NOT NULL,
CreatedBy int(10) unsigned DEFAULT '0' NOT NULL,
CreatedDate bigint(20) unsigned DEFAULT '0' NOT NULL,
LastModifiedBy int(10) unsigned DEFAULT '0' NOT NULL,
LastModifiedDate bigint(20) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (ComponentID)
);
#
# Table structure for table 'OS'
#
DROP TABLE IF EXISTS TBL_OS;
CREATE TABLE TBL_OS (
OSID int(10) unsigned DEFAULT '0' NOT NULL,
Name char(30) DEFAULT '' NOT NULL,
SortOrder tinyint(3) unsigned DEFAULT '0' NOT NULL,
Regex char(40) DEFAULT '' NOT NULL,
PRIMARY KEY (OSID)
);
#
# Dumping data for table 'OS'
#
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 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 db_sequence values ('OS', 31);
#
# Table structure for table 'Project'
#
DROP TABLE IF EXISTS Project;
CREATE TABLE Project (
ProjectID int(10) unsigned DEFAULT '0' NOT NULL,
Name varchar(30) DEFAULT '' NOT NULL,
Description text DEFAULT '' NOT NULL,
Active char(1) binary DEFAULT '1' NOT NULL,
CreatedBy int(10) unsigned DEFAULT '0' NOT NULL,
CreatedDate bigint(20) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (ProjectID)
);
#
# Table structure for table 'Resolution'
#
DROP TABLE IF EXISTS Resolution;
CREATE TABLE Resolution (
ResolutionID int(10) unsigned DEFAULT '0' NOT NULL,
Name varchar(30) DEFAULT '' NOT NULL,
Description text DEFAULT '' NOT NULL,
SortOrder tinyint(3) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (ResolutionID)
);
#
# Dumping data for table 'Resolution'
#
INSERT INTO Resolution VALUES (1,'Fixed','Bug was eliminated',1);
INSERT INTO Resolution VALUES (2,'Not a bug','It\'s not a bug -- it\'s a feature!',2);
INSERT INTO Resolution VALUES (3,'Won\'t Fix','This bug will stay',3);
INSERT INTO Resolution VALUES (4,'Deferred','We\'ll get around to it later',4);
INSERT INTO Resolution VALUES (5,'Works for me','Can\'t replicate the bug',5);
INSERT INTO Resolution VALUES (6,'Duplicate','',6);
insert into db_sequence values ('Resolution', 6);
#
# Table structure for table 'SavedQuery'
#
DROP TABLE IF EXISTS SavedQuery;
CREATE TABLE SavedQuery (
SavedQueryID int(10) unsigned NOT NULL auto_increment,
UserID int(10) unsigned DEFAULT '0' NOT NULL,
SavedQueryName varchar(40) NOT NULL,
SavedQueryString text NOT NULL,
PRIMARY KEY (SavedQueryID, UserID)
);
#
# Table structure for table 'Severity'
#
DROP TABLE IF EXISTS Severity;
CREATE TABLE Severity (
SeverityID int(10) unsigned DEFAULT '0' NOT NULL,
Name varchar(30) DEFAULT '' NOT NULL,
Description text DEFAULT '' NOT NULL,
SortOrder tinyint(3) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (SeverityID)
);
#
# Dumping data for table 'Severity'
#
INSERT INTO Severity VALUES (1,'Unassigned','Default bug creation',1);
INSERT INTO Severity VALUES (2,'Idea','Ideas for further development',2);
INSERT INTO Severity VALUES (3,'Feature Request','Requests for specific features',3);
INSERT INTO Severity VALUES (4,'Annoyance','Cosmetic problems or bugs not affecting performance',4);
INSERT INTO Severity VALUES (5,'Content','Non-functional related bugs, such as text content',5);
INSERT INTO Severity VALUES (6,'Significant','A bug affecting the intended performance of the product',6);
INSERT INTO Severity VALUES (7,'Critical','A bug severe enough to prevent the release of the product',7);
insert into db_sequence values ('Severity', 7);
#
# Table structure for table 'Status'
#
DROP TABLE IF EXISTS Status;
CREATE TABLE Status (
StatusID int(10) unsigned DEFAULT '0' NOT NULL,
Name varchar(30) DEFAULT '' NOT NULL,
Description text DEFAULT '' NOT NULL,
SortOrder tinyint(3) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (StatusID)
);
#
# Dumping data for table 'Status'
#
INSERT INTO Status VALUES (1,'Unconfirmed','Reported but not confirmed',1);
INSERT INTO Status VALUES (2,'New','A new bug',2);
INSERT INTO Status VALUES (3,'Assigned','Assigned to a developer',3);
INSERT INTO Status VALUES (4,'Reopened','Closed but opened again for further inspection',4);
INSERT INTO Status VALUES (5,'Resolved','Set by engineer with a resolution',5);
INSERT INTO Status VALUES (6,'Verified','The resolution is confirmed by the reporter',6);
INSERT INTO Status VALUES (7,'Closed','The bug is officially squashed (QA)',7);
insert into db_sequence values ('Status', 7);
#
# Table structure for table 'Version'
#
DROP TABLE IF EXISTS Version;
CREATE TABLE Version (
VersionID int(10) unsigned DEFAULT '0' NOT NULL,
ProjectID int(10) unsigned DEFAULT '0' NOT NULL,
Name char(10) DEFAULT '' NOT NULL,
Active char(1) binary DEFAULT '' NOT NULL,
CreatedBy int(10) unsigned DEFAULT '0' NOT NULL,
CreatedDate bigint(20) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (VersionID)
);
#
# Table structure for table 'active_sessions'
#
DROP TABLE IF EXISTS active_sessions;
CREATE TABLE active_sessions (
sid varchar(32) DEFAULT '' NOT NULL,
name varchar(32) DEFAULT '' NOT NULL,
val text,
changed varchar(14) DEFAULT '' NOT NULL,
PRIMARY KEY (name,sid),
KEY changed (changed)
);
CREATE TABLE BugHistory (
BugID int(10) unsigned NOT NULL default '0',
ChangedField char(20) NOT NULL default '',
OldValue char(255) NOT NULL default '',
NewValue char(255) NOT NULL default '',
CreatedBy int(10) unsigned NOT NULL default '0',
CreatedDate bigint(20) unsigned NOT NULL default '0'
);
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)
);
|
|
From: Ben C. <php...@be...> - 2001-09-07 13:13:07
|
Yup, I've been thinking about it, but I'm torn between spending my time on this coding or documenting. It's one of those important but not urgent things that keeps getting put off. It seems that phpdoc is more suited for documenting classes, no? I'm not familiar with sth. On Fri, Sep 07, 2001 at 01:10:11PM +0200, Patrick Mairif wrote: > Hi, > > has anyone thought about writing a documentation? I would suggest a > users-guide, a database-documentation and one for the code. maybe the last > one could be automatically generated by phpdoc or sth. > > What do you think? I think it would be an important thing. > > -- > http://home.nikocity.de/mairif > http://www.caravan-network.de > > > _______________________________________________ > phpbt-dev mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpbt-dev |
|
From: Ben C. <php...@be...> - 2001-09-07 13:11:22
|
Ok, ok, I'll get the schema current. :) On Fri, Sep 07, 2001 at 10:32:25AM +0200, Javier Sixto wrote: > I have tested, and i works good for me ... no major bug find. > I'm ok whith Patrick, table schema must be updated .. :-) > > Patrick Mairif wrote: > > >On Thu, 6 Sep 2001, Ben Curtis wrote: > > > >>So, since all is quiet, I guess testing went well for everybody and we are > >>ready for release? :) > >> > > > > > >Sorry, I had no time to test sth., but I noticed that createdb.sql is > >still not up to date! > > > > > > > _______________________________________________ > phpbt-dev mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpbt-dev |
2 messages has been excluded from this view by a project administrator.
