cvs: bugtracker /notes gsoc_bugtracker.sql
| From: | Barry Carlyon | Date: | Wed, 13 Aug 2008 10:59:09 +0000 |
| Subject: | cvs: bugtracker /notes gsoc_bugtracker.sql | ||
| Groups: | php.webmaster | ||
| Request: | Send a blank email to php-webmaster+get-2388@lists.php.net to get a copy of this message | ||
bcarlyon Wed Aug 13 10:59:09 2008 UTC
Modified files:
/bugtracker/notes gsoc_bugtracker.sql
Log:
Updated the SQL file for install/testing
http://cvs.php.net/viewvc.cgi/bugtracker/notes/gsoc_bugtracker.sql?r1=1.1&r2=1.2&diff_format=u Index: bugtracker/notes/gsoc_bugtracker.sql diff -u bugtracker/notes/gsoc_bugtracker.sql:1.1 bugtracker/notes/gsoc_bugtracker.sql:1.2 --- bugtracker/notes/gsoc_bugtracker.sql:1.1 Fri Jul 18 08:31:39 2008 +++ bugtracker/notes/gsoc_bugtracker.sql Wed Aug 13 10:59:09 2008 @@ -3,17 +3,22 @@ -- http://www.phpmyadmin.net -- -- Host: localhost --- Generation Time: Jul 18, 2008 at 09:27 AM +-- Generation Time: Aug 13, 2008 at 11:57 AM -- Server version: 5.1.24 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; +-- phpMyAdmin SQL Dump +-- version 2.11.6 +-- http://www.phpmyadmin.net +-- +-- Host: localhost +-- Generation Time: Aug 13, 2008 at 11:57 AM +-- Server version: 5.1.24 +-- PHP Version: 5.2.6 -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; -/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!40101 SET NAMES utf8 */; +SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `gsoc_bugtracker` @@ -25,7 +30,6 @@ -- Table structure for table `account_type` -- -DROP TABLE IF EXISTS `account_type`; CREATE TABLE IF NOT EXISTS `account_type` ( `account_type_id` int(11) NOT NULL AUTO_INCREMENT, `account_type_text` varchar(255) NOT NULL, @@ -49,7 +53,6 @@ -- Table structure for table `bug` -- -DROP TABLE IF EXISTS `bug`; CREATE TABLE IF NOT EXISTS `bug` ( `bug_id` int(11) NOT NULL AUTO_INCREMENT, `status` int(2) NOT NULL, @@ -67,15 +70,12 @@ `password` varchar(32) DEFAULT NULL, PRIMARY KEY (`bug_id`), KEY `reported_by` (`reported_by`,`assigned_to`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `bug` -- -INSERT INTO `bug` (`bug_id`, `status`, `bug_type`, `reported_by`, `reported_on`, `assigned_to`, `assigned_on`, `closed_by`, `closed_on`, `php_version`, `os_version`, `updated`, `summary`, `password`) VALUES -(1, 3, 1, 'Tbarry_barrycarlyon', '2008-07-16 12:46:48', 'barrycarlyon', '2008-07-16 13:06:42', 'barrycarlyon', '2008-07-16 15:17:57', 0, 2, '2008-07-16 15:17:57', 'Javascript spaces title', 'a1b8585122e1ad60623d6a74d3eb3b6a'), -(2, 0, 1, 'Tbarry_barrycarlyon', '2008-07-17 10:26:38', NULL, '0000-00-00 00:00:00', NULL, '0000-00-00 00:00:00', 1, 2, '2008-07-17 10:26:38', 'cake', 'bc13e533f78f5ab4ccbc8bdb0fa46709'); -- -------------------------------------------------------- @@ -83,7 +83,6 @@ -- Table structure for table `bug_comment` -- -DROP TABLE IF EXISTS `bug_comment`; CREATE TABLE IF NOT EXISTS `bug_comment` ( `comment_id` int(11) NOT NULL AUTO_INCREMENT, `bug_id` int(11) NOT NULL, @@ -95,18 +94,12 @@ `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`comment_id`), KEY `bug_id` (`bug_id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `bug_comment` -- -INSERT INTO `bug_comment` (`comment_id`, `bug_id`, `comment`, `comment_type`, `handle`, `added`, `edited_by`, `updated`) VALUES -(1, 1, 'The javascript counter for characters left for summary aka title, breaks when a space is user and more characters are typed', 1, 'Tbarry_barrycarlyon', '2008-07-16 12:47:00', '', '2008-07-16 12:47:00'), -(2, 2, 'This is a description', 1, 'Tbarry_barrycarlyon', '2008-07-17 10:26:42', '', '2008-07-17 10:26:42'), -(3, 2, '<?php\r\n\r\n$world = ''yes there is one'';\r\n\r\necho $world;\r\n\r\n?>', 2, 'Tbarry_barrycarlyon', '2008-07-17 10:26:42', '', '2008-07-17 10:26:42'), -(4, 2, 'yes there is one', 3, 'Tbarry_barrycarlyon', '2008-07-17 10:26:42', '', '2008-07-17 10:26:42'), -(5, 2, 'yes there is none', 4, 'Tbarry_barrycarlyon', '2008-07-17 10:26:42', '', '2008-07-17 10:26:42'); -- -------------------------------------------------------- @@ -114,7 +107,6 @@ -- Table structure for table `bug_type` -- -DROP TABLE IF EXISTS `bug_type`; CREATE TABLE IF NOT EXISTS `bug_type` ( `bug_type_id` int(11) NOT NULL AUTO_INCREMENT, `bug_type_text` varchar(255) NOT NULL, @@ -138,7 +130,6 @@ -- Table structure for table `comment_type` -- -DROP TABLE IF EXISTS `comment_type`; CREATE TABLE IF NOT EXISTS `comment_type` ( `comment_type_id` int(11) NOT NULL AUTO_INCREMENT, `comment_type_text` varchar(255) NOT NULL, @@ -146,7 +137,7 @@ PRIMARY KEY (`comment_type_id`), UNIQUE KEY `comment_type_text` (`comment_type_text`), UNIQUE KEY `ordering` (`ordering`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -- Dumping data for table `comment_type` @@ -156,7 +147,8 @@ (1, 'description', 1), (2, 'reproduce', 2), (3, 'expected', 3), -(4, 'actual', 4); +(4, 'actual', 4), +(5, 'bug_comment', 5); -- -------------------------------------------------------- @@ -164,7 +156,6 @@ -- Table structure for table `configuration` -- -DROP TABLE IF EXISTS `configuration`; CREATE TABLE IF NOT EXISTS `configuration` ( `conf_id` int(11) NOT NULL AUTO_INCREMENT, `conf_name` varchar(255) NOT NULL, @@ -187,7 +178,6 @@ -- Table structure for table `os_version` -- -DROP TABLE IF EXISTS `os_version`; CREATE TABLE IF NOT EXISTS `os_version` ( `os_version_id` int(11) NOT NULL AUTO_INCREMENT, `os_version_text` varchar(255) NOT NULL, @@ -211,7 +201,6 @@ -- Table structure for table `php_version` -- -DROP TABLE IF EXISTS `php_version`; CREATE TABLE IF NOT EXISTS `php_version` ( `php_version_id` int(11) NOT NULL AUTO_INCREMENT, `php_version_text` varchar(255) NOT NULL, @@ -219,7 +208,7 @@ PRIMARY KEY (`php_version_id`), UNIQUE KEY `php_version_text` (`php_version_text`), UNIQUE KEY `ordering` (`ordering`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `php_version` @@ -233,7 +222,28 @@ (5, '5.2CVS-2008-06-27 (CVS)', 5), (6, '5.3CVS-2008-06-27 (snap)', 6), (7, '6CVS-2008-06-27 (snap)', 7), -(8, '6CVS-2008-06-27 (CVS)', 8); +(8, '6CVS-2008-06-27 (CVS)', 8), +(9, 'Irrelevant', 0); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `sessions` +-- + +CREATE TABLE IF NOT EXISTS `sessions` ( + `session_id` varchar(32) NOT NULL, + `ip_address` varchar(15) NOT NULL, + `last_page` varchar(255) NOT NULL, + `last_active` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `handle` varchar(255) NOT NULL, + PRIMARY KEY (`session_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `sessions` +-- + -- -------------------------------------------------------- @@ -241,7 +251,6 @@ -- Table structure for table `status` -- -DROP TABLE IF EXISTS `status`; CREATE TABLE IF NOT EXISTS `status` ( `status_id` int(11) NOT NULL AUTO_INCREMENT, `status_text` varchar(255) NOT NULL, @@ -267,7 +276,6 @@ -- Table structure for table `temp_account` -- -DROP TABLE IF EXISTS `temp_account`; CREATE TABLE IF NOT EXISTS `temp_account` ( `handle` varchar(20) NOT NULL, `email` varchar(100) NOT NULL, @@ -289,7 +297,6 @@ -- Table structure for table `user` -- -DROP TABLE IF EXISTS `user`; CREATE TABLE IF NOT EXISTS `user` ( `handle` varchar(20) NOT NULL, `account_type` int(11) NOT NULL DEFAULT '1', @@ -299,16 +306,12 @@ `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `website` varchar(255) NOT NULL, PRIMARY KEY (`handle`), - KEY `email` (`email`,`handle`) + KEY `email` (`email`,`handle`), + KEY `acc_type` (`handle`,`account_type`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `user` -- -INSERT INTO `user` (`handle`, `account_type`, `password`, `email`, `registered`, `updated`, `website`) VALUES -('barrycarlyon', 2, 'a1b8585122e1ad60623d6a74d3eb3b6a', 'barry@barrycarlyon.co.uk', '2008-07-16 12:51:56', '2008-07-16 12:53:43', 'http://barrycarlyon.co.uk/'); -/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; -/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; -/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
http://cvs.php.net/viewvc.cgi/bugtracker/notes/gsoc_bugtracker.sql?r1=1.1&r2=1.2&diff_format=u Index: bugtracker/notes/gsoc_bugtracker.sql diff -u bugtracker/notes/gsoc_bugtracker.sql:1.1 bugtracker/notes/gsoc_bugtracker.sql:1.2 --- bugtracker/notes/gsoc_bugtracker.sql:1.1 Fri Jul 18 08:31:39 2008 +++ bugtracker/notes/gsoc_bugtracker.sql Wed Aug 13 10:59:09 2008 @@ -3,17 +3,22 @@ -- http://www.phpmyadmin.net -- -- Host: localhost --- Generation Time: Jul 18, 2008 at 09:27 AM +-- Generation Time: Aug 13, 2008 at 11:57 AM -- Server version: 5.1.24 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; +-- phpMyAdmin SQL Dump +-- version 2.11.6 +-- http://www.phpmyadmin.net +-- +-- Host: localhost +-- Generation Time: Aug 13, 2008 at 11:57 AM +-- Server version: 5.1.24 +-- PHP Version: 5.2.6 -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; -/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!40101 SET NAMES utf8 */; +SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `gsoc_bugtracker` @@ -25,7 +30,6 @@ -- Table structure for table `account_type` -- -DROP TABLE IF EXISTS `account_type`; CREATE TABLE IF NOT EXISTS `account_type` ( `account_type_id` int(11) NOT NULL AUTO_INCREMENT, `account_type_text` varchar(255) NOT NULL, @@ -49,7 +53,6 @@ -- Table structure for table `bug` -- -DROP TABLE IF EXISTS `bug`; CREATE TABLE IF NOT EXISTS `bug` ( `bug_id` int(11) NOT NULL AUTO_INCREMENT, `status` int(2) NOT NULL, @@ -67,15 +70,12 @@ `password` varchar(32) DEFAULT NULL, PRIMARY KEY (`bug_id`), KEY `reported_by` (`reported_by`,`assigned_to`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `bug` -- -INSERT INTO `bug` (`bug_id`, `status`, `bug_type`, `reported_by`, `reported_on`, `assigned_to`, `assigned_on`, `closed_by`, `closed_on`, `php_version`, `os_version`, `updated`, `summary`, `password`) VALUES -(1, 3, 1, 'Tbarry_barrycarlyon', '2008-07-16 12:46:48', 'barrycarlyon', '2008-07-16 13:06:42', 'barrycarlyon', '2008-07-16 15:17:57', 0, 2, '2008-07-16 15:17:57', 'Javascript spaces title', 'a1b8585122e1ad60623d6a74d3eb3b6a'), -(2, 0, 1, 'Tbarry_barrycarlyon', '2008-07-17 10:26:38', NULL, '0000-00-00 00:00:00', NULL, '0000-00-00 00:00:00', 1, 2, '2008-07-17 10:26:38', 'cake', 'bc13e533f78f5ab4ccbc8bdb0fa46709'); -- -------------------------------------------------------- @@ -83,7 +83,6 @@ -- Table structure for table `bug_comment` -- -DROP TABLE IF EXISTS `bug_comment`; CREATE TABLE IF NOT EXISTS `bug_comment` ( `comment_id` int(11) NOT NULL AUTO_INCREMENT, `bug_id` int(11) NOT NULL, @@ -95,18 +94,12 @@ `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`comment_id`), KEY `bug_id` (`bug_id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `bug_comment` -- -INSERT INTO `bug_comment` (`comment_id`, `bug_id`, `comment`, `comment_type`, `handle`, `added`, `edited_by`, `updated`) VALUES -(1, 1, 'The javascript counter for characters left for summary aka title, breaks when a space is user and more characters are typed', 1, 'Tbarry_barrycarlyon', '2008-07-16 12:47:00', '', '2008-07-16 12:47:00'), -(2, 2, 'This is a description', 1, 'Tbarry_barrycarlyon', '2008-07-17 10:26:42', '', '2008-07-17 10:26:42'), -(3, 2, '<?php\r\n\r\n$world = ''yes there is one'';\r\n\r\necho $world;\r\n\r\n?>', 2, 'Tbarry_barrycarlyon', '2008-07-17 10:26:42', '', '2008-07-17 10:26:42'), -(4, 2, 'yes there is one', 3, 'Tbarry_barrycarlyon', '2008-07-17 10:26:42', '', '2008-07-17 10:26:42'), -(5, 2, 'yes there is none', 4, 'Tbarry_barrycarlyon', '2008-07-17 10:26:42', '', '2008-07-17 10:26:42'); -- -------------------------------------------------------- @@ -114,7 +107,6 @@ -- Table structure for table `bug_type` -- -DROP TABLE IF EXISTS `bug_type`; CREATE TABLE IF NOT EXISTS `bug_type` ( `bug_type_id` int(11) NOT NULL AUTO_INCREMENT, `bug_type_text` varchar(255) NOT NULL, @@ -138,7 +130,6 @@ -- Table structure for table `comment_type` -- -DROP TABLE IF EXISTS `comment_type`; CREATE TABLE IF NOT EXISTS `comment_type` ( `comment_type_id` int(11) NOT NULL AUTO_INCREMENT, `comment_type_text` varchar(255) NOT NULL, @@ -146,7 +137,7 @@ PRIMARY KEY (`comment_type_id`), UNIQUE KEY `comment_type_text` (`comment_type_text`), UNIQUE KEY `ordering` (`ordering`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -- Dumping data for table `comment_type` @@ -156,7 +147,8 @@ (1, 'description', 1), (2, 'reproduce', 2), (3, 'expected', 3), -(4, 'actual', 4); +(4, 'actual', 4), +(5, 'bug_comment', 5); -- -------------------------------------------------------- @@ -164,7 +156,6 @@ -- Table structure for table `configuration` -- -DROP TABLE IF EXISTS `configuration`; CREATE TABLE IF NOT EXISTS `configuration` ( `conf_id` int(11) NOT NULL AUTO_INCREMENT, `conf_name` varchar(255) NOT NULL, @@ -187,7 +178,6 @@ -- Table structure for table `os_version` -- -DROP TABLE IF EXISTS `os_version`; CREATE TABLE IF NOT EXISTS `os_version` ( `os_version_id` int(11) NOT NULL AUTO_INCREMENT, `os_version_text` varchar(255) NOT NULL, @@ -211,7 +201,6 @@ -- Table structure for table `php_version` -- -DROP TABLE IF EXISTS `php_version`; CREATE TABLE IF NOT EXISTS `php_version` ( `php_version_id` int(11) NOT NULL AUTO_INCREMENT, `php_version_text` varchar(255) NOT NULL, @@ -219,7 +208,7 @@ PRIMARY KEY (`php_version_id`), UNIQUE KEY `php_version_text` (`php_version_text`), UNIQUE KEY `ordering` (`ordering`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `php_version` @@ -233,7 +222,28 @@ (5, '5.2CVS-2008-06-27 (CVS)', 5), (6, '5.3CVS-2008-06-27 (snap)', 6), (7, '6CVS-2008-06-27 (snap)', 7), -(8, '6CVS-2008-06-27 (CVS)', 8); +(8, '6CVS-2008-06-27 (CVS)', 8), +(9, 'Irrelevant', 0); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `sessions` +-- + +CREATE TABLE IF NOT EXISTS `sessions` ( + `session_id` varchar(32) NOT NULL, + `ip_address` varchar(15) NOT NULL, + `last_page` varchar(255) NOT NULL, + `last_active` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `handle` varchar(255) NOT NULL, + PRIMARY KEY (`session_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `sessions` +-- + -- -------------------------------------------------------- @@ -241,7 +251,6 @@ -- Table structure for table `status` -- -DROP TABLE IF EXISTS `status`; CREATE TABLE IF NOT EXISTS `status` ( `status_id` int(11) NOT NULL AUTO_INCREMENT, `status_text` varchar(255) NOT NULL, @@ -267,7 +276,6 @@ -- Table structure for table `temp_account` -- -DROP TABLE IF EXISTS `temp_account`; CREATE TABLE IF NOT EXISTS `temp_account` ( `handle` varchar(20) NOT NULL, `email` varchar(100) NOT NULL, @@ -289,7 +297,6 @@ -- Table structure for table `user` -- -DROP TABLE IF EXISTS `user`; CREATE TABLE IF NOT EXISTS `user` ( `handle` varchar(20) NOT NULL, `account_type` int(11) NOT NULL DEFAULT '1', @@ -299,16 +306,12 @@ `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `website` varchar(255) NOT NULL, PRIMARY KEY (`handle`), - KEY `email` (`email`,`handle`) + KEY `email` (`email`,`handle`), + KEY `acc_type` (`handle`,`account_type`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `user` -- -INSERT INTO `user` (`handle`, `account_type`, `password`, `email`, `registered`, `updated`, `website`) VALUES -('barrycarlyon', 2, 'a1b8585122e1ad60623d6a74d3eb3b6a', 'barry@barrycarlyon.co.uk', '2008-07-16 12:51:56', '2008-07-16 12:53:43', 'http://barrycarlyon.co.uk/'); -/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; -/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; -/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;