cvs: bugtracker /htdocs test.html /notes current_db_snapshot.sql

bcarlyon Thu Jul 10 00:39:20 2008 UTC Added files: /bugtracker/notes current_db_snapshot.sql Removed files: /bugtracker/htdocs test.html Log: Added a current snapshot of my database layout and data Added Files: notes/current_db_snapshot.sql

http://cvs.php.net/viewvc.cgi/bugtracker/notes/current_db_snapshot.sql?view=markup&rev=1.1 Index: bugtracker/notes/current_db_snapshot.sql +++ bugtracker/notes/current_db_snapshot.sql -- phpMyAdmin SQL Dump -- version 2.11.6 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 10, 2008 at 01:33 AM -- Server version: 5.1.24 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `gsoc_bugtracker` -- -- -------------------------------------------------------- -- -- Table structure for table `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, `ordering` int(2) NOT NULL DEFAULT '0', PRIMARY KEY (`account_type_id`), UNIQUE KEY `account_type_text` (`account_type_text`), UNIQUE KEY `ordering` (`ordering`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `account_type` -- INSERT INTO `account_type` (`account_type_id`, `account_type_text`, `ordering`) VALUES (1, 'Temp Account', 1), (2, 'User', 2); -- -------------------------------------------------------- -- -- Table structure for table `bug` -- CREATE TABLE IF NOT EXISTS `bug` ( `bug_id` int(11) NOT NULL AUTO_INCREMENT, `status` int(2) NOT NULL, `bug_type` int(2) NOT NULL, `reported_by` varchar(50) NOT NULL, `reported_on` datetime NOT NULL, `assigned_to` varchar(50) DEFAULT NULL, `assigned_on` datetime NOT NULL, `php_version` int(11) NOT NULL, `os_version` int(11) NOT NULL, `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `summary` varchar(100) NOT NULL, `password` varchar(32) DEFAULT NULL, PRIMARY KEY (`bug_id`), KEY `reported_by` (`reported_by`,`assigned_to`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `bug` -- INSERT INTO `bug` (`bug_id`, `status`, `bug_type`, `reported_by`, `reported_on`, `assigned_to`, `assigned_on`, `php_version`, `os_version`, `updated`, `summary`, `password`) VALUES (1, 0, 2, 'Tbarry', '2008-07-08 13:47:49', NULL, '0000-00-00 00:00:00', 2, 2, '2008-07-08 13:47:49', 'cake', '402acb1c3e3f37da6e1bb6cacadc315d'), (2, 0, 2, 'Tbarry', '2008-07-08 13:52:30', NULL, '0000-00-00 00:00:00', 2, 2, '2008-07-08 13:52:30', 'cake', 'a1b8585122e1ad60623d6a74d3eb3b6a'), (3, 0, 2, 'Tbarry', '2008-07-08 13:53:30', NULL, '0000-00-00 00:00:00', 2, 2, '2008-07-08 13:53:30', 'cake', 'bc13e533f78f5ab4ccbc8bdb0fa46709'); -- -------------------------------------------------------- -- -- Table structure for table `bug_comment` -- CREATE TABLE IF NOT EXISTS `bug_comment` ( `comment_id` int(11) NOT NULL AUTO_INCREMENT, `bug_id` int(11) NOT NULL, `comment` text NOT NULL, `comment_type` int(2) NOT NULL, `handle` varchar(20) NOT NULL, `added` datetime NOT NULL, `edited_by` varchar(20) NOT NULL, `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`comment_id`), KEY `bug_id` (`bug_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- 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, 'woo', 0, 'Tbarry', '2008-07-08 13:47:53', '', '2008-07-08 13:47:53'), (2, 1, 'test reprod', 0, 'Tbarry', '2008-07-08 13:47:53', '', '2008-07-08 13:47:53'), (3, 1, 'test expected', 0, 'Tbarry', '2008-07-08 13:47:53', '', '2008-07-08 13:47:53'), (4, 1, 'test actual', 0, 'Tbarry', '2008-07-08 13:47:53', '', '2008-07-08 13:47:53'), (5, 2, 'woo', 1, 'Tbarry', '2008-07-08 13:52:33', '', '2008-07-08 13:52:33'), (6, 2, 'test reprod', 2, 'Tbarry', '2008-07-08 13:52:33', '', '2008-07-08 13:52:33'), (7, 2, 'test expected', 0, 'Tbarry', '2008-07-08 13:52:33', '', '2008-07-08 13:52:33'), (8, 2, 'test actual', 4, 'Tbarry', '2008-07-08 13:52:33', '', '2008-07-08 13:52:33'), (9, 3, 'woo', 1, 'Tbarry', '2008-07-08 13:53:38', '', '2008-07-08 13:53:38'), (10, 3, 'test reprod', 2, 'Tbarry', '2008-07-08 13:53:38', '', '2008-07-08 13:53:38'), (11, 3, 'test expected', 3, 'Tbarry', '2008-07-08 13:53:38', '', '2008-07-08 13:53:38'), (12, 3, 'test actual', 4, 'Tbarry', '2008-07-08 13:53:38', '', '2008-07-08 13:53:38'); -- -------------------------------------------------------- -- -- Table structure for table `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, `ordering` int(2) NOT NULL DEFAULT '0', PRIMARY KEY (`bug_type_id`), UNIQUE KEY `bug_type_text` (`bug_type_text`), UNIQUE KEY `ordering` (`ordering`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `bug_type` -- INSERT INTO `bug_type` (`bug_type_id`, `bug_type_text`, `ordering`) VALUES (1, 'Doc', 1), (2, 'Core', 2); -- -------------------------------------------------------- -- -- Table structure for table `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, `ordering` int(2) NOT NULL DEFAULT '0', 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 ; -- -- Dumping data for table `comment_type` -- INSERT INTO `comment_type` (`comment_type_id`, `comment_type_text`, `ordering`) VALUES (1, 'description', 1), (2, 'reproduce', 2), (3, 'expected', 3), (4, 'actual', 4); -- -------------------------------------------------------- -- -- Table structure for table `configuration` -- CREATE TABLE IF NOT EXISTS `configuration` ( `conf_id` int(11) NOT NULL AUTO_INCREMENT, `conf_name` varchar(255) NOT NULL, `conf_data` varchar(255) NOT NULL, `update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`conf_id`), UNIQUE KEY `conf_name` (`conf_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `configuration` -- INSERT INTO `configuration` (`conf_id`, `conf_name`, `conf_data`, `update`) VALUES (1, 'mode', '0', '2008-06-04 12:36:33'); -- -------------------------------------------------------- -- -- Table structure for table `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, `ordering` int(2) NOT NULL DEFAULT '0', PRIMARY KEY (`os_version_id`), UNIQUE KEY `os_version_text` (`os_version_text`), UNIQUE KEY `ordering` (`ordering`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `os_version` -- INSERT INTO `os_version` (`os_version_id`, `os_version_text`, `ordering`) VALUES (1, 'Linux', 1), (2, 'W1nd0w5', 2); -- -------------------------------------------------------- -- -- Table structure for table `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, `ordering` int(2) NOT NULL DEFAULT '0', 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 ; -- -- Dumping data for table `php_version` -- INSERT INTO `php_version` (`php_version_id`, `php_version_text`, `ordering`) VALUES (1, '5.2.6', 1), (2, '4.4.8', 2), (3, '4CVS-2008-06-27 (snap)', 3), (4, '4CVS-2008-06-27 (CVS)', 4), (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); -- -------------------------------------------------------- -- -- Table structure for table `status` -- CREATE TABLE IF NOT EXISTS `status` ( `status_id` int(11) NOT NULL AUTO_INCREMENT, `status_text` varchar(255) NOT NULL, `ordering` int(2) NOT NULL DEFAULT '0', PRIMARY KEY (`status_id`), UNIQUE KEY `status_text` (`status_text`), UNIQUE KEY `ordering` (`ordering`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `status` -- INSERT INTO `status` (`status_id`, `status_text`, `ordering`) VALUES (1, 'Pending', 0), (2, 'Bogus', 1); -- -------------------------------------------------------- -- -- Table structure for table `temp_account` -- CREATE TABLE IF NOT EXISTS `temp_account` ( `handle` varchar(20) NOT NULL, `email` varchar(100) NOT NULL, `password` varchar(32) NOT NULL, `registered` datetime NOT NULL, `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`handle`), KEY `email` (`email`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `temp_account` -- INSERT INTO `temp_account` (`handle`, `email`, `password`, `registered`, `updated`) VALUES ('Tbarry', 'barry@barrycarlyon.co.uk', 'bc13e533f78f5ab4ccbc8bdb0fa46709', '2008-07-08 13:47:49', '2008-07-08 13:53:30'); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE IF NOT EXISTS `user` ( `handle` varchar(20) NOT NULL, `account_type` int(11) NOT NULL DEFAULT '1', `password` varchar(32) DEFAULT NULL, `email` varchar(100) NOT NULL, `registered` datetime NOT NULL, `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`handle`), KEY `email` (`email`,`handle`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `user` --