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: Ben C. <php...@be...> - 2005-06-04 22:03:01
|
I may have answered your questions in my last email, but just in case... I don't want to add anything that would cause database changes at this point, but any other patch would be fine. Ulf Erikson wrote: > * Benjamin Curtis [2005-05-14 12:54]: > >>I think the only reason the patches haven't been applied is that the >>time just slipped by me. To correct that, I've added you as a developer >>to the project so you can add your patches yourself. :) Changes should >>be applied to the HEAD. > > > What a dirty trick! ;-) It is soo much easier to complain than to fix it > myself.. but I will try to look at it, next week or so. > > Could you at least give a hint on what patches are okay to add now and > what can better wait until after 1.0? > > >>I don't have a desire to add any more features before 1.0, I just want >>work out any remaining bugs left over from the RCs. > > > Sounds wise. I guess this means that it is too late for changes to > things such as the database structure, the main queries and the > translatable strings, etc.? That would disqualify most of my patches for > now.. Another thing, some of my changes are for MySQL only. Who can help > with similar changes for the other database types? (do you normally > commit changes for one type only and add the others later? or do you > wait until changes for all types can be done at once?) > > Do you have a list of blocking bugs for 1.0? Why was RC5 named RC5 and > not 1.0? Are those issues addressed now? What is needed for RC6 and/or > 1.0? How can I best help reach there? > |
|
From: Ben C. <php...@be...> - 2005-06-04 22:00:43
|
A new release, RC6, has been made at the sourceforge site. I haven't announced it via sourceforge to give the list members a chance to bang on it first. :) As far as a TODO is concerned, all I care about before releasing 1.0 final is getting everyone agreed that it runs on PHP5. It would also be nice to update the docs and close some bugs, but that shouldn't hold us up. I'd like to release 1.0 by July 4th. Ulf Erikson wrote: > * Benjamin Curtis [2005-05-31 02:12]: > >> Yeah, I can take a look at it. To be perfectly honest, though, my >> installation has been running just fine with PHP 5.0.3 and MySQL 4.1 >> with the antiquated PEAR code. :) So, I won't see any change, even with >> an upgrade to the PEAR stuff. > > > Hey! Since when are you running php5 and mysql 4.1? And how come you > didn't tell me that things already worked before I start to hunt for > possible problems ;-) > > Anyway, I think you are using your system wide Pear install since there > doesn't seem to be any PEAR_PATH in use for the Spreadsheet. > > * Benjamin Curtis [2005-05-31 02:13]: > >> You know, maybe we should just ditch the included PEAR code and depend >> on it being available on the system. It would make life easier for us, >> at the expense of some users who don't have PEAR and can't easily >> install it. > > > That's perfectly okay with me. With instructions on where to download it > and how to install it localy (by repeating the PEAR_PATH trick for > people who cannot install it globaly) that wouldn't a problem. > > Now, with php5 and mysql 4.1 working, (untested) updates for postgres > and oracle in cvs, and logging of the install and update progress in > cvs; How about bundling a new cvs "snapshot" and ask people to test > things? I doubt a lot of people pull code from cvs to test.. > > Do you have ToDo list for the release? I'll see how much of my feature > patches I can include (priorities in a table, (re)editable queries, > bookmarks, and so on), but maybe you prefer help in some other area > first? I see that the documentation is a bit behind, for instance. > ev |
|
From: Benjamin C. <bc...@us...> - 2005-06-04 21:48:36
|
Update of /cvsroot/phpbt/phpbt In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14125 Modified Files: INSTALL UPGRADING config-dist.php config.php include.php install.php Log Message: Updated upgrade and install stuff Index: INSTALL =================================================================== RCS file: /cvsroot/phpbt/phpbt/INSTALL,v retrieving revision 1.14 retrieving revision 1.15 diff -u -r1.14 -r1.15 --- INSTALL 28 Feb 2002 18:55:41 -0000 1.14 +++ INSTALL 4 Jun 2005 21:48:26 -0000 1.15 @@ -1,5 +1,9 @@ Ok, here's the quick and dirty install instructions: +Required: You must have PEAR and PEAR DB installed. If PEAR is not in the +include path, edit install.php in the test_database function, supplying the full +path to PEAR for the PEAR_PATH constant. + Optional: Install JpGraph (http://www.aditus.nu/jpgraph/) if you wish to use it. 1. Copy the directory tree from the tarball to a location suitable for serving @@ -7,7 +11,7 @@ 2. With your web browser, go the location where you installed the package. You will be presented with a web page that will help you configure and - install the application. + install the application. 3. After completing the installation, login and start reporting bugs. Index: UPGRADING =================================================================== RCS file: /cvsroot/phpbt/phpbt/UPGRADING,v retrieving revision 1.13 retrieving revision 1.14 diff -u -r1.13 -r1.14 --- UPGRADING 25 Oct 2004 12:06:54 -0000 1.13 +++ UPGRADING 4 Jun 2005 21:48:26 -0000 1.14 @@ -1,8 +1,12 @@ +First, backup your database! This upgrade should go smoothly, but +if it doesn't, it's better to be safe than sorry. + Upgrading from 0.9.1 to 1.0 --------------------------- -First, backup your database! This upgrade should go smoothly, but -if it doesn't, it's better to be safe than sorry. +PEAR and PEAR DB have been removed from the distribution, so they must either +be available in the include path (system-wide install of PEAR) or their location +should be specified in the PEAR_PATH constant definition in config-dist.php Following the steps below will upgrade your installation of phpBT. @@ -14,3 +18,19 @@ 3. After running that script your installation has been upgraded. 4. Either copy the files from the new installation over the old one, or point your users to the new location. + +Upgrading from 1.0 RCx to 1.0 RC6 +--------------------------------- + +PEAR and PEAR DB have been removed as of RC 6, so they must either be available +in the include path (system-wide install of PEAR) or their location should be +specified in the PEAR_PATH constant definition in config-dist.php. + +Using the directory where you unpacked the new set of files... +1. Edit config-dist.php, changing the database settings to match those from + your old config.php (DB_* and TBL_PREFIX constants). Save + config-dist.php as config.php. +2. Either copy the files from the new installation over the old one, or + point your users to the new location. + +There is no need to run the upgrade script. The upgrade is complete. Index: config-dist.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/config-dist.php,v retrieving revision 1.29 retrieving revision 1.30 diff -u -r1.29 -r1.30 --- config-dist.php 4 Jun 2005 19:07:38 -0000 1.29 +++ config-dist.php 4 Jun 2005 21:48:26 -0000 1.30 @@ -62,10 +62,11 @@ define ('TBL_PROJECT_GROUP', TBL_PREFIX.'project_group'); define ('TBL_PROJECT_PERM', TBL_PREFIX.'project_perm'); define ('TBL_DATABASE', TBL_PREFIX.'database_server'); -define ('TBL_SITE', TBL_PREFIX.'site'); +define ('TBL_SITE', TBL_PREFIX.'site'); define ('ONEDAY', 86400); +define('PEAR_PATH', '{PEAR_PATH}'); // Set this to '/some/path/' to not use system-wide PEAR require_once (dirname(__FILE__).'/inc/auth.php'); ?> Index: config.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/config.php,v retrieving revision 1.41 retrieving revision 1.42 diff -u -r1.41 -r1.42 --- config.php 4 Jun 2005 19:02:43 -0000 1.41 +++ config.php 4 Jun 2005 21:48:26 -0000 1.42 @@ -66,6 +66,7 @@ define ('ONEDAY', 86400); +define('PEAR_PATH', ''); // Set this to '/some/path/' to not use system-wide PEAR require_once (dirname(__FILE__).'/inc/auth.php'); ?> Index: include.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/include.php,v retrieving revision 1.132 retrieving revision 1.133 diff -u -r1.132 -r1.133 --- include.php 4 Jun 2005 19:02:43 -0000 1.132 +++ include.php 4 Jun 2005 21:48:26 -0000 1.133 @@ -40,7 +40,6 @@ include ('inc/functions.php'); // PEAR::DB -define('PEAR_PATH', ''); // Set this to '/some/path/' to not use system-wide PEAR require_once(PEAR_PATH.'DB.php'); $dsn = array( 'phptype' => DB_TYPE, Index: install.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/install.php,v retrieving revision 1.45 retrieving revision 1.46 diff -u -r1.45 -r1.46 --- install.php 31 May 2005 18:49:39 -0000 1.45 +++ install.php 4 Jun 2005 21:48:26 -0000 1.46 @@ -154,6 +154,8 @@ $patterns[] = '{'.$key.'}'; $replacements[] = $val; } + $patterns[] = '{PEAR_PATH}'; + $replacements[] = PEAR_PATH; $contents = join('', file('config-dist.php')); return str_replace($patterns, $replacements, $contents); @@ -161,7 +163,7 @@ } function test_database(&$params, $testonly = false) { // PEAR::DB - define('PEAR_PATH', 'inc/pear/'); // Set this to '' to use system-wide PEAR + define('PEAR_PATH', ''); // Set this to '/some/path' to not use system-wide PEAR require_once(PEAR_PATH.'DB.php'); $dsn = array( 'phptype' => $params['db_type'], |
|
From: Benjamin C. <bc...@us...> - 2005-06-04 19:07:48
|
Update of /cvsroot/phpbt/phpbt In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv20039 Modified Files: config-dist.php Log Message: A little bit of cleanup Index: config-dist.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/config-dist.php,v retrieving revision 1.28 retrieving revision 1.29 diff -u -r1.28 -r1.29 --- config-dist.php 25 Oct 2004 12:06:57 -0000 1.28 +++ config-dist.php 4 Jun 2005 19:07:38 -0000 1.29 @@ -65,8 +65,7 @@ define ('TBL_SITE', TBL_PREFIX.'site'); define ('ONEDAY', 86400); -define ('PHPBT_VERSION', '1.0'); -require_once ('./inc/auth.php'); +require_once (dirname(__FILE__).'/inc/auth.php'); ?> |
|
From: Benjamin C. <bc...@us...> - 2005-06-04 19:05:09
|
Update of /cvsroot/phpbt/phpbt/inc/pear/DB In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv18382/inc/pear/DB Removed Files: common.php dbase.php fbsql.php ibase.php ifx.php msql.php mssql.php mysql.php mysqli.php oci8.php odbc.php pgsql.php sqlite.php storage.php sybase.php Log Message: Removing pear --- common.php DELETED --- --- dbase.php DELETED --- --- fbsql.php DELETED --- --- ibase.php DELETED --- --- ifx.php DELETED --- --- msql.php DELETED --- --- mssql.php DELETED --- --- mysql.php DELETED --- --- mysqli.php DELETED --- --- oci8.php DELETED --- --- odbc.php DELETED --- --- pgsql.php DELETED --- --- sqlite.php DELETED --- --- storage.php DELETED --- --- sybase.php DELETED --- |
|
From: Benjamin C. <bc...@us...> - 2005-06-04 19:05:05
|
Update of /cvsroot/phpbt/phpbt/inc/pear In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv18382/inc/pear Removed Files: DB.php PEAR.php Log Message: Removing pear --- DB.php DELETED --- --- PEAR.php DELETED --- |
|
From: Benjamin C. <bc...@us...> - 2005-06-04 19:02:53
|
Update of /cvsroot/phpbt/phpbt In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17283 Modified Files: config.php include.php Log Message: Cleaning up a bit Index: config.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/config.php,v retrieving revision 1.40 retrieving revision 1.41 diff -u -r1.40 -r1.41 --- config.php 25 Oct 2004 12:06:57 -0000 1.40 +++ config.php 4 Jun 2005 19:02:43 -0000 1.41 @@ -1,8 +1,7 @@ <?php - // config.php - Set up configuration options // ------------------------------------------------------------------------ -// Copyright (c) 2001 - 2003 The phpBugTracker Group +// Copyright (c) 2001 - 2004 The phpBugTracker Group // ------------------------------------------------------------------------ // This file is part of phpBugTracker // @@ -22,23 +21,18 @@ // ------------------------------------------------------------------------ // $Id$ -define ('PHPLIB_PATH', ''); // If PHPlib is not in your include path - // Database Config -define ('DB_TYPE', 'mysql'); // using PHPlib file naming -define ('DB_HOST', 'localhost'); -define ('DB_DATABASE', 'BugTracker'); -define ('DB_USER', 'root'); -define ('DB_PASSWORD', ''); - -// Smarty templates location (leave blank if Smarty is in include path) -// If not blank, make sure the trailing slash is present. -define ('SMARTY_PATH', ''); +define ('DB_TYPE', 'mysql'); // using PEAR::DB naming (mysql, pgsql, etc.) +define ('DB_HOST', 'localhost'); // hostname of database server +define ('DB_DATABASE', 'bug_tracker'); // database name +define ('DB_USER', ''); // username for database connection +define ('DB_PASSWORD', ''); // password for database connection // Database Table Config // you can change either the prefix of the table names or each table name individually define ('CUR_DB_VERSION', 4); // the version of the database define ('TBL_PREFIX', ''); // the prefix for all tables, leave empty to use the old style + define ('TBL_ACTIVE_SESSIONS', TBL_PREFIX.'active_sessions'); define ('TBL_DB_SEQUENCE', TBL_PREFIX.'db_sequence'); define ('TBL_ATTACHMENT', TBL_PREFIX.'attachment'); @@ -67,11 +61,11 @@ define ('TBL_VERSION', TBL_PREFIX.'version'); define ('TBL_PROJECT_GROUP', TBL_PREFIX.'project_group'); define ('TBL_PROJECT_PERM', TBL_PREFIX.'project_perm'); -define ('TBL_DATABASE', TBL_PREFIX.'database_server'); +define ('TBL_DATABASE', TBL_PREFIX.'database_server'); define ('TBL_SITE', TBL_PREFIX.'site'); define ('ONEDAY', 86400); -require_once ('inc/auth.php'); +require_once (dirname(__FILE__).'/inc/auth.php'); ?> Index: include.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/include.php,v retrieving revision 1.131 retrieving revision 1.132 diff -u -r1.131 -r1.132 --- include.php 4 Jun 2005 18:55:45 -0000 1.131 +++ include.php 4 Jun 2005 19:02:43 -0000 1.132 @@ -22,6 +22,7 @@ // ------------------------------------------------------------------------ // $Id$ +define('PHPBT_VERSION', '1.0rc6'); ini_set("magic_quotes_runtime", 0); ini_set("magic_quotes_sybase", 0); @ini_set("session.save_handler", "files"); |
|
From: Benjamin C. <bc...@us...> - 2005-06-04 18:57:08
|
Update of /cvsroot/phpbt/phpbt/inc In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14126/inc Modified Files: auth.php Log Message: Query quoting Index: auth.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/auth.php,v retrieving revision 1.20 retrieving revision 1.21 diff -u -r1.20 -r1.21 --- auth.php 22 Jan 2005 16:30:26 -0000 1.20 +++ auth.php 4 Jun 2005 18:56:55 -0000 1.21 @@ -74,7 +74,7 @@ $_SESSION['db_fields'] = @unserialize($u['bug_list_fields']); // Grab group assignments and permissions based on groups - $rs = $db->query("select u.group_id, group_name from ".TBL_USER_GROUP." u, ".TBL_AUTH_GROUP." a where user_id = {$u['user_id']} and u.group_id = a.group_id"); + $rs = $db->query("select u.group_id, group_name from ".TBL_USER_GROUP." u, ".TBL_AUTH_GROUP." a where user_id = ".$db->quote($u['user_id'])." and u.group_id = a.group_id"); while (list($groupid, $groupname) = $rs->fetchRow(DB_FETCHMODE_ORDERED)) { $_SESSION['group_ids'][] = $groupid; $_SESSION['group'][$groupname] = true; |
|
From: Benjamin C. <bc...@us...> - 2005-06-04 18:56:05
|
Update of /cvsroot/phpbt/phpbt In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv13433 Modified Files: include.php Log Message: Default to the system-wide PEAR installation Index: include.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/include.php,v retrieving revision 1.130 retrieving revision 1.131 diff -u -r1.130 -r1.131 --- include.php 15 Feb 2005 13:34:19 -0000 1.130 +++ include.php 4 Jun 2005 18:55:45 -0000 1.131 @@ -39,7 +39,7 @@ include ('inc/functions.php'); // PEAR::DB -define('PEAR_PATH', 'inc/pear/'); // Set this to '' to use system-wide PEAR +define('PEAR_PATH', ''); // Set this to '/some/path/' to not use system-wide PEAR require_once(PEAR_PATH.'DB.php'); $dsn = array( 'phptype' => DB_TYPE, |
|
From: Ulf E. <ulf...@fa...> - 2005-05-31 19:02:06
|
* Benjamin Curtis [2005-05-31 02:12]: > Yeah, I can take a look at it. To be perfectly honest, though, my > installation has been running just fine with PHP 5.0.3 and MySQL 4.1 > with the antiquated PEAR code. :) So, I won't see any change, even with > an upgrade to the PEAR stuff. Hey! Since when are you running php5 and mysql 4.1? And how come you didn't tell me that things already worked before I start to hunt for possible problems ;-) Anyway, I think you are using your system wide Pear install since there doesn't seem to be any PEAR_PATH in use for the Spreadsheet. * Benjamin Curtis [2005-05-31 02:13]: > You know, maybe we should just ditch the included PEAR code and depend > on it being available on the system. It would make life easier for us, > at the expense of some users who don't have PEAR and can't easily > install it. That's perfectly okay with me. With instructions on where to download it and how to install it localy (by repeating the PEAR_PATH trick for people who cannot install it globaly) that wouldn't a problem. Now, with php5 and mysql 4.1 working, (untested) updates for postgres and oracle in cvs, and logging of the install and update progress in cvs; How about bundling a new cvs "snapshot" and ask people to test things? I doubt a lot of people pull code from cvs to test.. Do you have ToDo list for the release? I'll see how much of my feature patches I can include (priorities in a table, (re)editable queries, bookmarks, and so on), but maybe you prefer help in some other area first? I see that the documentation is a bit behind, for instance. |
|
From: Ulf E. <ulf...@us...> - 2005-05-31 18:50:31
|
Update of /cvsroot/phpbt/phpbt/templates/default In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv819/templates/default Modified Files: upgrade.html upgrade-finished.html Log Message: Logging of the upgrade process Index: upgrade.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/templates/default/upgrade.html,v retrieving revision 1.11 retrieving revision 1.12 diff -u -r1.11 -r1.12 --- upgrade.html 25 Oct 2004 12:07:04 -0000 1.11 +++ upgrade.html 31 May 2005 18:50:18 -0000 1.12 @@ -6,7 +6,7 @@ <div align="center"> <br> <br> - <?php echo printf(translate('This script will upgrade your database from version %s to version %s of phpBugTracker.'), '0.9.x', '1.0'); ?> + <?php printf(translate('This script will upgrade your database from version %s to version %s of phpBugTracker.'), '0.9.x', '1.0'); ?> <br> <br> <a href="<?php echo $HTTP_SERVER_VARS['PHP_SELF']; ?>?doit=1"><?php echo translate('Do it!'); ?></a> Index: upgrade-finished.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/templates/default/upgrade-finished.html,v retrieving revision 1.4 retrieving revision 1.5 diff -u -r1.4 -r1.5 --- upgrade-finished.html 25 Oct 2004 12:07:04 -0000 1.4 +++ upgrade-finished.html 31 May 2005 18:50:19 -0000 1.5 @@ -1,15 +1,24 @@ <html> <head> - <title><?php echo translate("Upgade phpBugTracker"); ?></title> + <title><?php echo translate("Upgrade phpBugTracker"); ?></title> + <style>.error { font-weight: bold; color: #ff0000; } </style> </head> <body> - <div align="center"> - <br> - <br> - <?php echo translate("Your database has been updated."); ?> - <br> - <br> - <a href="index.php"><?php echo translate("phpBugTracker home"); ?></a> - </div> + <h3>Upgrade phpBugTracker</h3> + <p> + <?php echo $comment_text; ?> + </p> + <?php if ($num_errors > 0) { ?> + <hr> + <h4>Error log</h4> + <p> + <?php echo $log_text; ?> + </p> + <hr> + <?php } ?> + <p> + <?php echo translate("Your database has been updated."); ?> + </p> + <a href="index.php"><?php echo translate("phpBugTracker home"); ?></a> </body> </html> |
|
From: Ulf E. <ulf...@us...> - 2005-05-31 18:50:28
|
Update of /cvsroot/phpbt/phpbt In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv819 Modified Files: upgrade.php Log Message: Logging of the upgrade process Index: upgrade.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/upgrade.php,v retrieving revision 1.39 retrieving revision 1.40 diff -u -r1.39 -r1.40 --- upgrade.php 30 May 2005 19:59:35 -0000 1.39 +++ upgrade.php 31 May 2005 18:50:18 -0000 1.40 @@ -23,89 +23,168 @@ // $Id$ define ('NO_AUTH', 1); +define ('RAWERROR', true); +define ('THEME', 'default'); $upgrading = true; @include 'include.php'; +$comment_text = ""; +$log_text = ""; +$num_errors = 0; + +// Handle a database error +function handle_upgrade_error(&$obj) { + global $log_text; + + $log_text .= "<div class=\"error\">"; + $log_text .= htmlentities($obj->message).'<br>'.htmlentities($obj->userinfo); + $log_text .= "</div>\n"; +} + +function log_query($str) { + global $db, $log_text, $num_errors; + + $log_text .= "SQL: " . $str . "<br>\n"; + $result = $db->query($str); + if (DB::isError($result)) { + $num_errors = $num_errors + 1; + } + $log_text .= "<br>\n"; +} + function upgrade() { - global $db; + global $db, $comment_text, $log_text, $num_errors; + + $thisvers = 0; + + $tmp_log = "Using the following information from config.php:<br>\n"; + $tmp_log .= "DB_TYPE: '".DB_TYPE."'<br>\n"; + $tmp_log .= "DB_HOST: '".DB_HOST."'<br>\n"; + $tmp_log .= "DB_DATABASE: '".DB_DATABASE."'<br>\n"; + $tmp_log .= "DB_USER: '".DB_USER."'<br>\n"; + $tmp_log .= "DB_PASSWORD: '".DB_PASSWORD."'<br>\n"; + $tmp_log .= "<br>\n"; + + $db->setErrorHandling(PEAR_ERROR_CALLBACK, "handle_upgrade_error"); + + $query = 'select count(*) from '.TBL_CONFIGURATION; + $tmp_log .= "SQL: ".$query."<br>\n"; + $count = $db->getOne($query); + if (DB::isError($count)) { + $tmp_log .= $log_text; + $log_text = ""; + $count = 0; + } + + $tmp_log .= "<p>count = ".$count."</p>\n"; + + if ($count > 30) { + $query = 'select varvalue from '.TBL_CONFIGURATION.' where varname = \'DB_VERSION\''; + $tmp_log .= "SQL: ".$query."<br>\n"; + $thisvers = $db->getOne($query); + if (DB::isError($thisvers)) { + $tmp_log .= $log_text; + $log_text = ""; + $thisvers = 0; + } + } + + $tmp_log .= "<p>DB_VERSION = ".$thisvers."</p>\n"; + + $comment_text .= "Current DB version = $thisvers<br>\n"; + $comment_text .= "Upgrading to version = ".CUR_DB_VERSION."<br>\n"; + $comment_text .= "<br>\n"; + + $log_text = $tmp_log; - $thisvers = $db->getOne('select varvalue from '.TBL_CONFIGURATION.' where varname = \'DB_VERSION\''); if ($thisvers == CUR_DB_VERSION) $upgraded = 1; - if (!$upgraded or DB::isError($thisvers)) { + if (!$upgraded) { switch(DB_TYPE) { case 'pgsql' : - $db->query("create table ".TBL_PROJECT_PERM." ( project_id INT4 NOT NULL DEFAULT '0', user_id INT4 NOT NULL DEFAULT '0' )"); + log_query("create table ".TBL_PROJECT_PERM." ( project_id INT4 NOT NULL DEFAULT '0', user_id INT4 NOT NULL DEFAULT '0' )"); if ($thisvers < 2) { - $db->query("alter table ".TBL_AUTH_GROUP." ADD assignable INT2"); - $db->query("alter table ".TBL_AUTH_GROUP." alter assignable set DEFAULT 0"); - $db->query("update ".TBL_AUTH_GROUP." set assignable = 0"); - $db->query("alter table ".TBL_AUTH_GROUP." alter assignable set NOT NULL"); + log_query("alter table ".TBL_AUTH_GROUP." ADD assignable INT2"); + log_query("alter table ".TBL_AUTH_GROUP." alter assignable set DEFAULT 0"); + log_query("update ".TBL_AUTH_GROUP." set assignable = 0"); + log_query("alter table ".TBL_AUTH_GROUP." alter assignable set NOT NULL"); } if ($thisvers < 3) { - $db->query("ALTER TABLE ".TBL_USER_PREF." ADD def_results INT4"); - $db->query("ALTER TABLE ".TBL_USER_PREF." alter def_results set DEFAULT 20"); - $db->query("update ".TBL_USER_PREF." set def_results = 20"); - $db->query("ALTER TABLE ".TBL_USER_PREF." alter def_results set NOT NULL"); + log_query("ALTER TABLE ".TBL_USER_PREF." ADD def_results INT4"); + log_query("ALTER TABLE ".TBL_USER_PREF." alter def_results set DEFAULT 20"); + log_query("update ".TBL_USER_PREF." set def_results = 20"); + log_query("ALTER TABLE ".TBL_USER_PREF." alter def_results set NOT NULL"); } if ($thisvers < 4) { - $db->query('ALTER TABLE '.TBL_STATUS.' ADD bug_open INT2'); - $db->query("ALTER TABLE ".TBL_STATUS." alter bug_open set DEFAULT 1"); - $db->query("update ".TBL_STATUS." set bug_open = 1"); - $db->query("ALTER TABLE ".TBL_STATUS." alter bug_open set NOT NULL"); + log_query('ALTER TABLE '.TBL_STATUS.' ADD bug_open INT2'); + log_query("ALTER TABLE ".TBL_STATUS." alter bug_open set DEFAULT 1"); + log_query("update ".TBL_STATUS." set bug_open = 1"); + log_query("ALTER TABLE ".TBL_STATUS." alter bug_open set NOT NULL"); } break; case 'mysqli' : case 'mysql' : - $db->query("create table if not exists ".TBL_PROJECT_PERM." ( project_id int(11) NOT NULL default '0', user_id int(11) NOT NULL default '0' )"); + log_query("create table if not exists ".TBL_PROJECT_PERM." ( project_id int(11) NOT NULL default '0', user_id int(11) NOT NULL default '0' )"); if ($thisvers < 2) { - $db->query("alter table ".TBL_AUTH_GROUP." ADD assignable TINYINT DEFAULT 0 NOT NULL AFTER locked"); + log_query("alter table ".TBL_AUTH_GROUP." ADD assignable TINYINT DEFAULT 0 NOT NULL AFTER locked"); } if ($thisvers < 3) { - $db->query("ALTER TABLE ".TBL_USER_PREF." ADD def_results INT DEFAULT '20' NOT NULL"); + log_query("ALTER TABLE ".TBL_USER_PREF." ADD def_results INT DEFAULT '20' NOT NULL"); } if ($thisvers < 4) { - $db->query('ALTER TABLE '.TBL_STATUS.' ADD bug_open TINYINT DEFAULT \'1\' NOT NULL'); + log_query('ALTER TABLE '.TBL_STATUS.' ADD bug_open TINYINT DEFAULT \'1\' NOT NULL'); } break; case 'oci8' : - echo "Oracle is not supported in version 1.0"; + if (true) { + $comment_text .= "<div class=\"error\">Oracle is not supported in version 1.0</div>"; - echo "<p>An attempt to restore Oracle support has been made (by copy-paste-and-edit), but it is completely UNTESTED! Proceed At Your Own Risk...</p>"; - echo "<p>Don't forget to report your success (or failure) story to <a href=\"mailto:php...@li...\">php...@li...</a> if you do proceed. We have interest in detailed error reports and patches from people who use Oracle.</p>"; - exit; + $comment_text .= "<p>An attempt to restore Oracle support has been made (by copy-paste-and-edit), but it is completely UNTESTED! Proceed At Your Own Risk...</p>"; + $comment_text .= "<p>Don't forget to report your success (or failure) story to <a href=\"mailto:php...@li...\">php...@li...</a> if you do proceed. We have interest in detailed error reports and patches from people who use Oracle.</p>"; + include 'templates/default/upgrade-finished.html'; + exit; + } - $db->query("create table ".TBL_PROJECT_PERM." ( project_id number(10) default '0' NOT NULL, user_id number(10) default '0' NOT NULL )"); + log_query("create table ".TBL_PROJECT_PERM." ( project_id number(10) default '0' NOT NULL, user_id number(10) default '0' NOT NULL )"); if ($thisvers < 2) { - $db->query("alter table ".TBL_AUTH_GROUP." ADD (assignable number(1) default '0' NOT NULL)"); + log_query("alter table ".TBL_AUTH_GROUP." ADD (assignable number(1) default '0' NOT NULL)"); } if ($thisvers < 3) { - $db->query("ALTER TABLE ".TBL_USER_PREF." ADD (def_results number(10) default '20' NOT NULL)"); + log_query("ALTER TABLE ".TBL_USER_PREF." ADD (def_results number(10) default '20' NOT NULL)"); } if ($thisvers < 4) { - $db->query("ALTER TABLE ".TBL_STATUS." ADD (bug_open number(1) default '1' NOT NULL)"); + log_query("ALTER TABLE ".TBL_STATUS." ADD (bug_open number(1) default '1' NOT NULL)"); } break; } /** Database-independent changes */ if ($thisvers < 2) { - $db->query("DELETE FROM ".TBL_CONFIGURATION." WHERE varname = 'GROUP_ASSIGN_TO'"); - $db->query("UPDATE ".TBL_AUTH_GROUP." SET assignable = 1 WHERE group_id = 3"); - $db->query("INSERT INTO ".TBL_CONFIGURATION." VALUES ('EMAIL_DISABLED', '0', 'Whether to disable all mail sent from the system', 'bool');"); + log_query("DELETE FROM ".TBL_CONFIGURATION." WHERE varname = 'GROUP_ASSIGN_TO'"); + log_query("UPDATE ".TBL_AUTH_GROUP." SET assignable = 1 WHERE group_id = 3"); + log_query("INSERT INTO ".TBL_CONFIGURATION." VALUES ('EMAIL_DISABLED', '0', 'Whether to disable all mail sent from the system', 'bool');"); /* add db-version attribute */ - $db->query("INSERT INTO ".TBL_CONFIGURATION." VALUES ('DB_VERSION', '".CUR_DB_VERSION."', 'Database Version <b>Warning:</b> Changing this might make things go horribly wrong.', 'string')"); + log_query("INSERT INTO ".TBL_CONFIGURATION." VALUES ('DB_VERSION', '".(int)CUR_DB_VERSION."', 'Database Version <b>Warning:</b> Changing this might make things go horribly wrong.', 'string')"); } if ($thisvers < 4) { - $db->query('DELETE FROM '.TBL_CONFIGURATION.' WHERE varname = \'BUG_CLOSED\''); - echo 'You must set your Statuses to either open or closed. Default settings should be modified so that "resolved", "closed", and "verified" are shown as being closed, and all other statuses are set to open.'; - $db->query("INSERT INTO ".TBL_AUTH_PERM." (perm_id, perm_name) VALUES (3, 'EditAssignment')"); + log_query('DELETE FROM '.TBL_CONFIGURATION.' WHERE varname = \'BUG_CLOSED\''); + $comment_text .= "You must set your Statuses to either open or closed. Default settings should be modified so that \"resolved\", \"closed\", and \"verified\" are shown as being closed, and all other statuses are set to open.<br><br>\n"; + log_query("INSERT INTO ".TBL_AUTH_PERM." (perm_id, perm_name) VALUES (3, 'EditAssignment')"); } /* update to current DB_VERSION */ - $db->query("UPDATE ".TBL_CONFIGURATION." SET varvalue = '".CUR_DB_VERSION."' WHERE varname = 'DB_VERSION'"); - + log_query("UPDATE ".TBL_CONFIGURATION." SET varvalue = '".CUR_DB_VERSION."' WHERE varname = 'DB_VERSION'"); + if ($num_errors == 0) { + $comment_text .= "Success!<br>\n"; + } + else { + $comment_text .= "Done, but with ".$num_errors." error(s)<br>\n"; + } } + else { + $comment_text .= "Nothing to do...<br>\n"; + } + include 'templates/default/upgrade-finished.html'; } |
|
From: Ulf E. <ulf...@us...> - 2005-05-31 18:49:49
|
Update of /cvsroot/phpbt/phpbt In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv406 Modified Files: install.php Log Message: Logging of the install process Index: install.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/install.php,v retrieving revision 1.44 retrieving revision 1.45 diff -u -r1.44 -r1.45 --- install.php 30 May 2005 20:02:19 -0000 1.44 +++ install.php 31 May 2005 18:49:39 -0000 1.45 @@ -25,6 +25,30 @@ include_once('inc/functions.php'); define('THEME', 'default'); +define('RAWERROR', true); + +$log_text = ""; +$num_errors = 0; + +// Handle a database error +function handle_install_error(&$obj) { + global $log_text; + + $log_text .= "<div class=\"error\">"; + $log_text .= htmlentities($obj->message).'<br>'.htmlentities($obj->userinfo); + $log_text .= "</div>\n"; +} + +function log_query($str) { + global $db, $log_text, $num_errors; + + $log_text .= "SQL: " . $str . "<br>\n"; + $result = $db->query($str); + if (DB::isError($result)) { + $num_errors = $num_errors + 1; + } + $log_text .= "<br>\n"; +} // Template class class template { @@ -164,10 +188,13 @@ function create_tables() { global $_POST, $tables; + global $db, $log_text, $num_errors; $db = test_database($_POST); $db->setOption('optimize', 'portability'); + $db->setErrorHandling(PEAR_ERROR_CALLBACK, "handle_install_error"); + $q_temp_ary = file('schemas/'.$_POST['db_type'].'.in'); $queries = preg_replace(array_keys($tables), array_values($tables), $q_temp_ary); @@ -179,14 +206,16 @@ if ($_POST['db_type'] == 'oci8' ) { $do_query = substr($do_query, 0, -1); } - $db->query(stripslashes($do_query)); + log_query(stripslashes($do_query)); $do_query = ''; } /*!! BAD! Must figure out how to get db_version from config-dist.php... */ $query = preg_replace(array_keys($tables), array_values($tables), 'INSERT INTO TBL_CONFIGURATION (varname,varvalue,description,vartype) VALUES (\'DB_VERSION\', './*!!!*/4/*!!!*/.', \'Database Version <b>Warning:</b> Changing this might make things go horribly wrong, so don\\\'t change it.\', \'mixed\')'); - $res = $db->query($query); - if (DB::isError($res)) { - echo 'DB_VERSION not set!'; + log_query($query); + + if ($num_errors > 0) { + include('templates/default/install-failure.html'); + exit; } } |
|
From: Ulf E. <ulf...@us...> - 2005-05-31 18:49:49
|
Update of /cvsroot/phpbt/phpbt/templates/default In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv406/templates/default Added Files: install-failure.html Log Message: Logging of the install process --- NEW FILE: install-failure.html --- <html> <head> <title><?php echo translate("phpBugTracker Installation"); ?></title> <link rel="StyleSheet" href="styles/default.css" type="text/css"> </head> <body bgcolor="#ffffff" link="#006699" vlink="#006699" alink="#006699"> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td width="200" valign="top"><br><img src="logo.jpg"></td> <td valign="top"> <div class="banner"><?php echo translate("phpBugTracker Installation"); ?></div> <br> <?php echo "Installation ended with ".$num_errors." error(s)"; ?> <hr> <h4>Error log</h4> <?php echo $log_text; ?> <hr> <br> Please feel welcome to subscribe the phpbt-users mailing list by visiting the mailing list <a href="http://lists.sourceforge.net/lists/listinfo/phpbt-users" target="_new">web page.</a> <hr size="1" width="300"> </td> </tr> </table> </body> </html> |
|
From: Benjamin C. <php...@be...> - 2005-05-31 00:05:21
|
You know, maybe we should just ditch the included PEAR code and depend on it being available on the system. It would make life easier for us, at the expense of some users who don't have PEAR and can't easily install it. Ulf Erikson wrote: > Benjamin, > > Will you please take a look at updating the spreadsheet component? I > have never used it.. (anyway, it looks to me as if you never used a > PEAR_PATH for it. why?) Now, there is a report that says that you need > an OLE component as well for newer versions (and you probably need a > newer version for php5): > http://sourceforge.net/forum/message.php?msg_id=2989428 > > > ------------------------------------------------------- > This SF.Net email is sponsored by Yahoo. > Introducing Yahoo! Search Developer Network - Create apps using Yahoo! > Search APIs Find out how you can build Yahoo! directly into your own > Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005 > _______________________________________________ > phpbt-dev mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpbt-dev |
|
From: Benjamin C. <php...@be...> - 2005-05-31 00:03:59
|
Yeah, I can take a look at it. To be perfectly honest, though, my installation has been running just fine with PHP 5.0.3 and MySQL 4.1 with the antiquated PEAR code. :) So, I won't see any change, even with an upgrade to the PEAR stuff. Ulf Erikson wrote: > Benjamin, > > Will you please take a look at updating the spreadsheet component? I > have never used it.. (anyway, it looks to me as if you never used a > PEAR_PATH for it. why?) Now, there is a report that says that you need > an OLE component as well for newer versions (and you probably need a > newer version for php5): > http://sourceforge.net/forum/message.php?msg_id=2989428 > |
|
From: Ulf E. <ulf...@fa...> - 2005-05-30 20:39:09
|
Benjamin, Will you please take a look at updating the spreadsheet component? I have never used it.. (anyway, it looks to me as if you never used a PEAR_PATH for it. why?) Now, there is a report that says that you need an OLE component as well for newer versions (and you probably need a newer version for php5): http://sourceforge.net/forum/message.php?msg_id=2989428 |
|
From: Ulf E. <ulf...@fa...> - 2005-05-30 20:38:57
|
* Benjamin Curtis [2005-03-10 14:31]: > A popup or an iframe could be used to log the queries, to keep it > separate from the main output. Hmm.. I get the idea that you must have the frame content in a separate file. Can one assume that there is a tmp directory for use? Or would it be better to just dump the log at the end of the page? (and maybe only do so when there are errors?) |
|
From: Ulf E. <ulf...@us...> - 2005-05-30 20:20:33
|
Update of /cvsroot/phpbt/phpbt/templates/default In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv8067/templates/default Modified Files: install-dbfailure.html Log Message: Fix for the 'Close window' link. Index: install-dbfailure.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/templates/default/install-dbfailure.html,v retrieving revision 1.3 retrieving revision 1.4 diff -u -r1.3 -r1.4 --- install-dbfailure.html 24 May 2005 20:50:58 -0000 1.3 +++ install-dbfailure.html 30 May 2005 20:20:22 -0000 1.4 @@ -16,7 +16,7 @@ <?php echo $db->message.'<br>'.$db->userinfo."\n"; if ($testonly) { - echo '<br><br><a href="javascript:window.close()"><?php echo translate("Close window"); ?></a>'; + echo '<br><br><a href="javascript:window.close()">'.translate("Close window").'</a>'; } ?> </div> |
|
From: Ulf E. <ulf...@us...> - 2005-05-30 20:02:29
|
Update of /cvsroot/phpbt/phpbt In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv454 Modified Files: install.php Log Message: Check for get_magic_quotes_gpc() before install. Index: install.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/install.php,v retrieving revision 1.43 retrieving revision 1.44 diff -u -r1.43 -r1.44 --- install.php 30 May 2005 19:32:26 -0000 1.43 +++ install.php 30 May 2005 20:02:19 -0000 1.44 @@ -270,7 +270,14 @@ case 'dbtest' : test_database($_GET, true); break; } } else { - show_front(); + if (!get_magic_quotes_gpc()) { + echo "<p>magic_quotes_gpc is OFF!</p>"; + echo "<p>You must have magic_quotes_gpc set to On either in php.ini or in "; + echo ".htaccess (see <a href=\"http://www.php.net/manual/en/configuration.php\">http://www.php.net/manual/en/configuration.php</a> for more info).</p>"; + } + else { + show_front(); + } } // Any whitespace below the end tag will disrupt config.php ?> \ No newline at end of file |
|
From: Ulf E. <ulf...@us...> - 2005-05-30 19:59:44
|
Update of /cvsroot/phpbt/phpbt/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv30944/schemas Modified Files: oci8.in Log Message: Updated Oracle support. Index: oci8.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v retrieving revision 1.26 retrieving revision 1.27 diff -u -r1.26 -r1.27 --- oci8.in 25 May 2005 18:04:48 -0000 1.26 +++ oci8.in 30 May 2005 19:59:35 -0000 1.27 @@ -20,11 +20,11 @@ group_id number(10) default '0' NOT NULL, group_name varchar2(80) default '' NOT NULL, locked number(1) default '0' NOT NULL, - assignable number(1) default '0' NOT NULL, created_by number(10) default '0' NOT NULL, created_date number(20) default '0' NOT NULL, last_modified_by number(10) default '0' NOT NULL, last_modified_date number(20) default '0' NOT NULL, + assignable number(1) default '0' NOT NULL, PRIMARY KEY (group_id) ) ; @@ -225,6 +225,7 @@ status_name varchar2(30) default '' NOT NULL, status_desc varchar2(4000) NOT NULL , sort_order number(3) default '0' NOT NULL, + bug_open number(1) default '1' NOT NULL, PRIMARY KEY (status_id) ) ; |
|
From: Ulf E. <ulf...@us...> - 2005-05-30 19:59:44
|
Update of /cvsroot/phpbt/phpbt In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv30944 Modified Files: upgrade.php Log Message: Updated Oracle support. Index: upgrade.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/upgrade.php,v retrieving revision 1.38 retrieving revision 1.39 diff -u -r1.38 -r1.39 --- upgrade.php 30 May 2005 19:32:27 -0000 1.38 +++ upgrade.php 30 May 2005 19:59:35 -0000 1.39 @@ -69,10 +69,21 @@ break; case 'oci8' : echo "Oracle is not supported in version 1.0"; + + echo "<p>An attempt to restore Oracle support has been made (by copy-paste-and-edit), but it is completely UNTESTED! Proceed At Your Own Risk...</p>"; + echo "<p>Don't forget to report your success (or failure) story to <a href=\"mailto:php...@li...\">php...@li...</a> if you do proceed. We have interest in detailed error reports and patches from people who use Oracle.</p>"; exit; + $db->query("create table ".TBL_PROJECT_PERM." ( project_id number(10) default '0' NOT NULL, user_id number(10) default '0' NOT NULL )"); - //! TBL_AUTH_GROUP - //! TBL_USER_PERM.def_results (see mysql) + if ($thisvers < 2) { + $db->query("alter table ".TBL_AUTH_GROUP." ADD (assignable number(1) default '0' NOT NULL)"); + } + if ($thisvers < 3) { + $db->query("ALTER TABLE ".TBL_USER_PREF." ADD (def_results number(10) default '20' NOT NULL)"); + } + if ($thisvers < 4) { + $db->query("ALTER TABLE ".TBL_STATUS." ADD (bug_open number(1) default '1' NOT NULL)"); + } break; } |
|
From: Ulf E. <ulf...@us...> - 2005-05-30 19:59:44
|
Update of /cvsroot/phpbt/phpbt/inc/db In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv30944/inc/db Modified Files: oci8.php Log Message: Updated Oracle support. Index: oci8.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v retrieving revision 1.17 retrieving revision 1.18 diff -u -r1.17 -r1.18 --- oci8.php 25 May 2005 18:04:48 -0000 1.17 +++ oci8.php 30 May 2005 19:59:35 -0000 1.18 @@ -43,7 +43,7 @@ 'where s.site_id = b.site_id(+) group by s.site_id, site_name, '. 'sort_order order by %s %s', 'admin-list-statuses' => 'select s.status_id, status_name, status_desc, '. - 'sort_order, count(bug_id) as bug_count '. + 'sort_order, bug_open, count(bug_id) as bug_count '. 'from '.TBL_STATUS.' s, '.TBL_BUG.' b '. 'where s.status_id = b.status_id(+) '. 'group by s.status_id, status_name, status_desc, sort_order '. @@ -115,12 +115,12 @@ 'where p.project_id = pg.project_id(+) and active = 1 '. 'and (pg.project_id is null or pg.group_id in (%s)) '. 'group by p.project_id, p.project_name order by project_name', - 'include-template-owner' => "SELECT sum(decode( s.status_id, ".BUG_UNCONFIRMED.", 1, ".BUG_PROMOTED.", 1, ".BUG_ASSIGNED.", 1, ".BUG_REOPENED.", 1, 0 )), ". - "sum(decode( s.status_id, ".BUG_UNCONFIRMED.", 0, ".BUG_PROMOTED.", 0, ".BUG_ASSIGNED.", 0, ".BUG_REOPENED.", 0, 1 )) ". + 'include-template-owner' => SELECT sum(decode( s.status_id in (".OPEN_BUG_STATUSES.") , 1, 1, 0 )), ". + "sum(decode( s.status_id not in (".OPEN_BUG_STATUSES.") , 1, 1, 0 )), ". 'from '.TBL_BUG.' b, '.TBL_STATUS.' s '. 'where b.status_id = s.status_id (+) and b.assigned_to = %s', - 'include-template-reporter' => "SELECT sum(decode( s.status_id, ".BUG_UNCONFIRMED.", 1, ".BUG_PROMOTED.", 1, ".BUG_ASSIGNED.", 1, ".BUG_REOPENED.", 1, 0 )), ". - "sum(decode( s.status_id, ".BUG_UNCONFIRMED.", 0, ".BUG_PROMOTED.", 0, ".BUG_ASSIGNED.", 0, ".BUG_REOPENED.", 0, 1 )) ". + 'include-template-reporter' => SELECT sum(decode( s.status_id in (".OPEN_BUG_STATUSES.") , 1, 1, 0 )) , ". + "sum(decode( s.status_id not in (".OPEN_BUG_STATUSES.") , 1, 1, 0 )) ". 'from '.TBL_BUG.' b, ' . TBL_STATUS.' s '. 'where b.status_id = s.status_id (+) and b.created_by = %s', 'index-projsummary-1' => 'select b.project_id, p.project_name as "Project", '. |
|
From: Ulf E. <ulf...@us...> - 2005-05-30 19:35:21
|
Update of /cvsroot/phpbt/phpbt/inc/db In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16446/inc/db Modified Files: pgsql.php Log Message: Updated Postgres support. Index: pgsql.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v retrieving revision 1.25 retrieving revision 1.26 diff -u -r1.25 -r1.26 --- pgsql.php 25 Oct 2004 12:07:01 -0000 1.25 +++ pgsql.php 30 May 2005 19:35:13 -0000 1.26 @@ -37,7 +37,7 @@ 'group by d.database_id, database_name, sort_order '. 'order by %s %s', 'admin-list-statuses' => 'select s.status_id, status_name, status_desc, '. - 'sort_order, count(bug_id) as bug_count '. + 'sort_order, bug_open, count(bug_id) as bug_count '. 'from '.TBL_STATUS.' s left join '. TBL_BUG.' using (status_id) '. 'group by s.status_id, status_name, status_desc, sort_order '. 'order by %s %s', @@ -99,6 +99,7 @@ 'left join '.TBL_RESOLUTION.' r on b.resolution_id = r.resolution_id, '. TBL_SEVERITY.' sv, '.TBL_STATUS.' st, '.TBL_SITE. ' site '. 'where bug_id = %s and b.project_id not in (%s) '. + 'and b.site_id = site.site_id '. 'and b.severity_id = sv.severity_id and b.status_id = st.status_id', 'functions-bug-cc' => 'select b.user_id, login '. 'from '.TBL_BUG_CC.' b left join '. TBL_AUTH_USER.' using(user_id) '. |
|
From: Ulf E. <ulf...@us...> - 2005-05-30 19:32:37
|
Update of /cvsroot/phpbt/phpbt/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15033/schemas Added Files: mysqli.in Log Message: Added MySQL-i support. --- NEW FILE: mysqli.in --- # MySQL database creation template # This is a template for install.php -- not for creating the database! # # $Id: mysqli.in,v 1.1 2005/05/30 19:32:27 ulferikson Exp $ 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 '', locked tinyint(1) unsigned NOT NULL default '0', assignable tinyint(1) 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', 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 text 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', database_id tinyint(3) unsigned NOT NULL default '0', site_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', closed_in_version_id int(10) unsigned NOT NULL default '0', to_be_closed_in_version_id int(10) unsigned NOT NULL default '0', PRIMARY KEY (bug_id) ) TYPE=MyISAM; CREATE TABLE TBL_BUG_CC ( bug_id int(10) unsigned NOT NULL default '0', user_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 (bug_id,user_id) ) TYPE=MyISAM; CREATE TABLE TBL_BUG_DEPENDENCY ( bug_id int(10) unsigned NOT NULL default '0', depends_on int(10) unsigned NOT NULL default '0', PRIMARY KEY (bug_id,depends_on) ) 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 varchar(30) NOT NULL default '', old_value varchar(255) NOT NULL default '', new_value varchar(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_BUG_VOTE ( user_id int(10) unsigned NOT NULL default '0', bug_id int(10) unsigned NOT NULL default '0', created_date bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (user_id, bug_id), KEY bug_id (bug_id) ) 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 TBL_CONFIGURATION ( varname char(40) NOT NULL default '', varvalue char(255) NOT NULL default '', description char(255) NOT NULL default '', vartype char(20) NOT NULL default '', PRIMARY KEY (varname) ) TYPE=MyISAM; 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_PROJECT_GROUP ( project_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 (project_id,group_id), KEY group_id (group_id) ) TYPE=MyISAM; CREATE TABLE TBL_PROJECT_PERM ( project_id int(11) NOT NULL default '0', user_id int(11) NOT NULL default '0' ) TYPE=MyISAM; CREATE TABLE TBL_RESOLUTION ( resolution_id int(10) unsigned NOT NULL default '0', resolution_name varchar(30) NOT NULL default '', 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 default '0', 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', bug_open tinyint(1) unsigned NOT NULL default '1', 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_USER_PREF ( user_id int(11) NOT NULL default '0', email_notices tinyint(1) NOT NULL default '1', saved_queries tinyint(1) NOT NULL default '1', def_results int(11) NOT NULL default '20', PRIMARY KEY (user_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(30) 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; CREATE TABLE TBL_DATABASE ( database_id tinyint(3) unsigned NOT NULL default '0', database_name varchar(40) NOT NULL default '', sort_order tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (database_id) ) TYPE=MyISAM; CREATE TABLE TBL_SITE ( site_id tinyint(3) unsigned NOT NULL default '0', site_name varchar(50) NOT NULL default '', sort_order tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (site_id) ) TYPE=MyISAM; # # -- Insert initial data -- # INSERT INTO TBL_AUTH_USER (user_id, login, first_name, last_name, email, password) values (1, 'OPTION_ADMIN_EMAIL', 'System', 'Admin', 'OPTION_ADMIN_EMAIL', 'OPTION_ADMIN_PASS'); create table TBL_AUTH_USER_seq (id int unsigned auto_increment not null primary key); insert into TBL_AUTH_USER_seq values (1); # Start off with three user levels... INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (1, 'Admin', 1); INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (2, 'User', 1); INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked, assignable) VALUES (3, 'Developer', 1, 1); create table TBL_AUTH_GROUP_seq (id int unsigned auto_increment not null primary key); insert into TBL_AUTH_GROUP_seq values (3); # ... 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'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (3, 'EditAssignment'); # 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); # Add user's prefs as default values for all users defined so far (only admin) INSERT INTO TBL_USER_PREF (user_id) SELECT USER_ID FROM TBL_AUTH_USER; INSERT INTO TBL_CONFIGURATION VALUES ('INSTALL_URL','OPTION_INSTALL_URL','The base URL of the phpBugTracker installation','string'); INSERT INTO TBL_CONFIGURATION VALUES ('JPGRAPH_PATH','','If not in the include path. This is the file path on the web server, not a URL.','string'); INSERT INTO TBL_CONFIGURATION VALUES ('CVS_WEB','http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpbt/phpbt/','Location of your cvs web interface (see format_comments() in bug.php)','string'); INSERT INTO TBL_CONFIGURATION VALUES ('ADMIN_EMAIL','OPTION_PHPBT_EMAIL','The email address used in correspondence from the bug tracker','string'); INSERT INTO TBL_CONFIGURATION VALUES ('ENCRYPT_PASS','OPTION_ENCRYPT_PASS','Whether to store passwords encrypted. <b>Warning:</b> Changing this after users have been created will result in their being unable to login.','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('USE_JPGRAPH','','Whether to show some reports as images','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('MASK_EMAIL','1','Should email addresses have . changed to ''dot'' and @ change to ''at''?','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('STRICT_UPDATING', '0', 'Only the bug reporter, bug owner, managers, and admins can change a bug', 'bool'); INSERT INTO TBL_CONFIGURATION VALUES ('NEW_ACCOUNTS_DISABLED', '0', 'Only admins can create new user accounts - newaccount.php is disabled', 'bool'); INSERT INTO TBL_CONFIGURATION VALUES ('RECALL_LOGIN', '0', 'Enable use of cookies to store username between logins', 'bool'); INSERT INTO TBL_CONFIGURATION VALUES ('SHOW_PROJECT_SUMMARIES', '1', 'Itemize bug stats by project on the home page', 'bool'); INSERT INTO TBL_CONFIGURATION VALUES ('FORCE_LOGIN', '0', 'Force users to login before being able to use the bug tracker', 'bool'); INSERT INTO TBL_CONFIGURATION VALUES ('PROMOTE_VOTES', 5, 'The number of votes required to promote a bug from Unconfirmed to New (Set to 0 to disable promotions by voting)', 'string'); INSERT INTO TBL_CONFIGURATION VALUES ('MAX_USER_VOTES', 5, 'The maximum number of votes a user can cast across all bugs (Set to 0 to have no limit)', 'string'); INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string'); INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','multi'); INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_MAX_SIZE','2097152','Maximum size (in bytes) of an attachment. This will not override the settings in php.ini if php.ini has a lower limit.','string'); INSERT INTO TBL_CONFIGURATION VALUES ('DATE_FORMAT','m-d-Y','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string'); INSERT INTO TBL_CONFIGURATION VALUES ('TIME_FORMAT','g:i A','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string'); INSERT INTO TBL_CONFIGURATION VALUES ('LANGUAGE','en','The language file to use for warning and error messages','multi'); INSERT INTO TBL_CONFIGURATION VALUES ('STYLE', 'default', 'The CSS file to use (color scheme)', 'multi'); INSERT INTO TBL_CONFIGURATION VALUES ('SEND_MIME_EMAIL', '1', 'Whether to use MIME quoted-printable encoded emails or not', 'bool'); INSERT INTO TBL_CONFIGURATION VALUES ('BUG_UNCONFIRMED','1','The status to assign a bug when it is first submitted.','multi'); INSERT INTO TBL_CONFIGURATION VALUES ('BUG_PROMOTED','2','The status to assign a bug when it is promoted (if enabled).','multi'); INSERT INTO TBL_CONFIGURATION VALUES ('BUG_ASSIGNED','3','The status to assign a bug when it is assigned.','multi'); INSERT INTO TBL_CONFIGURATION VALUES ('BUG_REOPENED','4','The status to assign a bug when it is reopened.','multi'); INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_DISABLED', '0', 'Whether to disable all mail sent from the system', 'bool'); 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,''); create table TBL_OS_seq (id int unsigned auto_increment not null primary key); insert into TBL_OS_seq values (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); create table TBL_RESOLUTION_seq (id int unsigned auto_increment not null primary key); insert into TBL_RESOLUTION_seq values (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'); create table TBL_SEVERITY_seq (id int unsigned auto_increment not null primary key); insert into TBL_SEVERITY_seq values (7); INSERT INTO TBL_STATUS VALUES (1,'Unconfirmed','Reported but not confirmed',1, 1); INSERT INTO TBL_STATUS VALUES (2,'New','A new bug',2,1); INSERT INTO TBL_STATUS VALUES (3,'Assigned','Assigned to a developer',3,1); INSERT INTO TBL_STATUS VALUES (4,'Reopened','Closed but opened again for further inspection',4,1); INSERT INTO TBL_STATUS VALUES (5,'Resolved','Set by engineer with a resolution',5,0); INSERT INTO TBL_STATUS VALUES (6,'Verified','The resolution is confirmed by the reporter',6,0); INSERT INTO TBL_STATUS VALUES (7,'Closed','The bug is officially squashed (QA)',7,0); create table TBL_STATUS_seq (id int unsigned auto_increment not null primary key); insert into TBL_STATUS_seq values (7); INSERT INTO TBL_DATABASE VALUES (1,'Oracle 8.1.7',1); INSERT INTO TBL_DATABASE VALUES (2,'MySQL 3.23.49',2); INSERT INTO TBL_DATABASE VALUES (3,'PostgreSQL 7.1.3',3); create table TBL_DATABASE_seq (id int unsigned auto_increment not null primary key); insert into TBL_DATABASE_seq values (3); # Examples only INSERT INTO TBL_SITE VALUES (0,'All',1); INSERT INTO TBL_SITE VALUES (1,'Production - location 1',2); INSERT INTO TBL_SITE VALUES (2,'Production - location 2',3); INSERT INTO TBL_SITE VALUES (3,'Test site - location 1',4); INSERT INTO TBL_SITE VALUES (4,'Test site - location 2',5); create table TBL_SITE_seq (id int unsigned auto_increment not null primary key); insert into TBL_SITE_seq values (4); #-- Sequences for the tables with no initial entries create table TBL_BUG_seq (id int unsigned auto_increment not null primary key); insert into TBL_BUG_seq values(1); create table TBL_COMMENT_seq (id int unsigned auto_increment not null primary key); insert into TBL_COMMENT_seq values(1); create table TBL_COMPONENT_seq (id int unsigned auto_increment not null primary key); insert into TBL_COMPONENT_seq values(1); create table TBL_PROJECT_seq (id int unsigned auto_increment not null primary key); insert into TBL_PROJECT_seq values(1); create table TBL_VERSION_seq (id int unsigned auto_increment not null primary key); insert into TBL_VERSION_seq values(1); |
2 messages has been excluded from this view by a project administrator.
