Hi,
I also got this error when doing a clean install with an
empty DB but I never
bothered to track it down in details since I assumed it was
my fault.
It turned out that It was caused by me trying to shortcut
the installation
process. I made the mistake of assuming that that it would
be enough to
1. Install a clean 0.9.8 DB
2. Run the upgrade to 0.9.9 DB SQL script to get a clean
0.9.9 DB
However, this will not work since it misses some index
changes that is only
done in the PHP "migration/update" scripts that
must be run even on an empty
0.9.8 DB. I also assume that a number of other important
settings will be
wrong one of them that will cause the "filters class
missing".
Included in this mail is an empty "clean" 0.9.9 DB
SQL dump that can be used
for a clean install. It's basically the result of doing all
the proper steps
to get a DB starting with the 0.9.8 script
Perhaps including this script as the starting point for a
clean 0.9.9 install
would be helpful since it would be easier for a new user to
get up and
running.
Rgds
Johan
On Friday 29 December 2006 07:35, KukHyun Lee wrote:
> hi.
> when trying to install 0.9.9-current in SVN, I'm
getting an error.
>
> Fatal error: Undefined class name 'filters'
> in /flyspray/includes/class.tpl.php(111) : eval()'d
code on line 2
>
> Also browsing this page (http://bugs.flyspray.
org/user/1),
>
> Project Group Notice: Undefined index: project_group in
>
/var/www/vhosts/flyspray.org/subdomains/bugs/htdocs/includes
/class.tpl.php(
>111)
>
> eval()'d code on line 53
> Notice: Undefined index: in
> /var/www/vhosts/flyspray.org/subdomains/bugs/htdocs/
> includes/class.tpl.php(111) : eval()'d code on line 53
>
> I think I found a bug.
>
> ---
> Regards,
> Kuk-Hyun LEE
--
Aditus Consulting is a Swedish company with registered
address:
Emagatan 16, SE-128 46 Stockholm, Sweden.
VAT No: SE661128485901
-- phpMyAdmin SQL Dump
-- version 2.6.1-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 30, 2006 at 10:53 AM
-- Server version: 5.0.18
-- PHP Version: 4.4.0
--
-- Database: `dev_flyspray`
--
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_admin_requests`
--
DROP TABLE IF EXISTS `flyspray_admin_requests`;
CREATE TABLE `flyspray_admin_requests` (
`request_id` mediumint(5) NOT NULL auto_increment,
`project_id` mediumint(5) NOT NULL default '0',
`task_id` mediumint(5) NOT NULL default '0',
`submitted_by` mediumint(5) NOT NULL default '0',
`request_type` mediumint(2) NOT NULL default '0',
`reason_given` text NOT NULL,
`time_submitted` int(11) NOT NULL default '0',
`resolved_by` mediumint(5) NOT NULL default '0',
`time_resolved` int(11) NOT NULL default '0',
`deny_reason` varchar(255) NOT NULL default '',
PRIMARY KEY (`request_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Pending
requests for admins and PMs to attend to' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `flyspray_admin_requests`
--
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_assigned`
--
DROP TABLE IF EXISTS `flyspray_assigned`;
CREATE TABLE `flyspray_assigned` (
`assigned_id` mediumint(10) NOT NULL auto_increment,
`task_id` mediumint(10) NOT NULL default '0',
`user_id` mediumint(5) NOT NULL default '0',
PRIMARY KEY (`assigned_id`),
UNIQUE KEY `task_user` (`task_id`,`user_id`),
KEY `task_id` (`task_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Who is
assigned what task' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `flyspray_assigned`
--
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_attachments`
--
DROP TABLE IF EXISTS `flyspray_attachments`;
CREATE TABLE `flyspray_attachments` (
`attachment_id` mediumint(5) NOT NULL auto_increment,
`task_id` mediumint(10) NOT NULL default '0',
`comment_id` mediumint(10) NOT NULL default '0',
`orig_name` varchar(100) NOT NULL default '',
`file_name` varchar(30) NOT NULL default '',
`file_desc` varchar(100) NOT NULL default '',
`file_type` varchar(50) NOT NULL default '',
`file_size` mediumint(20) NOT NULL default '0',
`added_by` mediumint(3) NOT NULL default '0',
`date_added` int(11) NOT NULL default '0',
PRIMARY KEY (`attachment_id`),
KEY `task_id` (`task_id`,`comment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='List the
names and locations of files attached to tasks'
AUTO_INCREMENT=1 ;
--
-- Dumping data for table `flyspray_attachments`
--
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_cache`
--
DROP TABLE IF EXISTS `flyspray_cache`;
CREATE TABLE `flyspray_cache` (
`id` smallint(6) NOT NULL auto_increment,
`type` varchar(4) NOT NULL default '',
`content` text NOT NULL,
`topic` varchar(30) NOT NULL default '',
`last_updated` int(11) NOT NULL default '0',
`project_id` int(11) NOT NULL default '0',
`max_items` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `type`
(`type`,`topic`,`project_id`,`max_items`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table to
cache RSS/atom feeds' AUTO_INCREMENT=2 ;
--
-- Dumping data for table `flyspray_cache`
--
INSERT INTO `flyspray_cache` VALUES (1, 'msg',
'a:14:{i:0;a:3:{i:0;s:14:"document_start";i:1;a:0:
{}i:2;i:0;}i:1;a:3:{i:0;s:6:"p_open";i:1;a:0:{}i:2
;i:0;}i:2;a:3:{i:0;s:5:"cdata";i:1;a:1:{i:0;s:164:
"Welcome to your first Flyspray project! We hope that
Flyspray provides you with many hours of increased
productivity. If you have any issues, please read <a
href=";}i:2;i:1;}i:3;a:3:{i:0;s:18:"doublequoteclo
sing";i:1;a:0:{}i:2;i:165;}i:4;a:3:{i:0;s:12:"exte
rnallink";i:1;a:2:{i:0;s:35:"http
://flyspray.rocks.cc/manual/toc";i:1;N;}i:2;i:166;}
i:5;a:3:{i:0;s:18:"doublequoteopening";i:1;a:0:{}i
:2;i:201;}i:6;a:3:{i:0;s:5:"cdata";i:1;a:1:{i:0;s:
35:">the documentation</a> and <a
href=";}i:2;i:202;}i:7;a:3:{i:0;s:18:"doublequotec
losing";i:1;a:0:{}i:2;i:237;}i:8;a:3:{i:0;s:12:"ex
ternallink";i:1;a:2:{i:0;s:28:"http://flys
pray.rocks.cc/faq";i:1;N;}i:2;i:238;}i:9;a:3:{i:0;s
:18:"doublequoteopening";i:1;a:0:{}i:2;i:266;}i:10
;a:3:{i:0;s:5:"cdata";i:1;a:1:{i:0;s:139:">
;Frequently Asked Questions</a>. <br /><br
/>You can customise this message by clicking the
<b>Manage Project</b> link in the menu
above...";}i:2;i:267;}i:11;a:3:{i:0;s:5:"cdata&quo
t;;i:1;a:1:{i:0;s:1:"
";}i:2;i:406;}i:12;a:3:{i:0;s:7:"p_close";i:1
;a:0:{}i:2;i:406;}i:13;a:3:{i:0;s:12:"document_end"
;;i:1;a:0:{}i:2;i:406;}}', '1', 1166826697, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_comments`
--
DROP TABLE IF EXISTS `flyspray_comments`;
CREATE TABLE `flyspray_comments` (
`comment_id` mediumint(10) NOT NULL auto_increment,
`task_id` mediumint(10) NOT NULL default '0',
`date_added` int(11) NOT NULL default '0',
`user_id` mediumint(3) NOT NULL default '0',
`comment_text` longtext NOT NULL,
`last_edited_time` int(11) NOT NULL default '0',
PRIMARY KEY (`comment_id`),
KEY `task_id` (`task_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `flyspray_comments`
--
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_dependencies`
--
DROP TABLE IF EXISTS `flyspray_dependencies`;
CREATE TABLE `flyspray_dependencies` (
`depend_id` mediumint(10) NOT NULL auto_increment,
`task_id` mediumint(10) NOT NULL default '0',
`dep_task_id` mediumint(10) NOT NULL default '0',
PRIMARY KEY (`depend_id`),
UNIQUE KEY `task_id` (`task_id`,`dep_task_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Task
dependencies' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `flyspray_dependencies`
--
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_groups`
--
DROP TABLE IF EXISTS `flyspray_groups`;
CREATE TABLE `flyspray_groups` (
`group_id` mediumint(3) NOT NULL auto_increment,
`group_name` varchar(20) NOT NULL default '',
`group_desc` varchar(150) NOT NULL default '',
`project_id` mediumint(3) NOT NULL default '0',
`is_admin` mediumint(1) NOT NULL default '0',
`manage_project` mediumint(1) NOT NULL default '0',
`view_tasks` mediumint(1) NOT NULL default '0',
`open_new_tasks` mediumint(1) NOT NULL default '0',
`modify_own_tasks` mediumint(1) NOT NULL default '0',
`modify_all_tasks` mediumint(1) NOT NULL default '0',
`view_comments` mediumint(1) NOT NULL default '0',
`add_comments` mediumint(1) NOT NULL default '0',
`edit_comments` mediumint(1) NOT NULL default '0',
`edit_own_comments` mediumint(1) NOT NULL default '0',
`delete_comments` mediumint(1) NOT NULL default '0',
`create_attachments` mediumint(1) NOT NULL default '0',
`delete_attachments` mediumint(1) NOT NULL default '0',
`view_history` mediumint(1) NOT NULL default '0',
`close_own_tasks` mediumint(1) NOT NULL default '0',
`close_other_tasks` mediumint(1) NOT NULL default '0',
`assign_to_self` mediumint(1) NOT NULL default '0',
`assign_others_to_self` mediumint(1) NOT NULL default '0',
`add_to_assignees` int(1) NOT NULL default '0',
`view_reports` mediumint(1) NOT NULL default '0',
`add_votes` int(1) NOT NULL default '0',
`edit_assignments` tinyint(1) NOT NULL default '0',
`group_open` mediumint(1) NOT NULL default '0',
PRIMARY KEY (`group_id`),
UNIQUE KEY `group_name` (`group_name`,`project_id`),
KEY `belongs_to_project` (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='User Groups
for the Flyspray bug killer' AUTO_INCREMENT=7 ;
--
-- Dumping data for table `flyspray_groups`
--
INSERT INTO `flyspray_groups` VALUES (1, 'Admin', 'Members
have unlimited access to all functionality.', 0, 1, 1, 1, 1,
1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1);
INSERT INTO `flyspray_groups` VALUES (2, 'Developers',
'Global Developers for all projects', 0, 0, 1, 1, 1, 1, 1,
1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `flyspray_groups` VALUES (3, 'Reporters', 'Open
new tasks / add comments in all projects', 0, 0, 0, 1, 1, 0,
0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1);
INSERT INTO `flyspray_groups` VALUES (4, 'Basic', 'Members
can login, relying upon Project permissions only', 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
1);
INSERT INTO `flyspray_groups` VALUES (5, 'Disabled', 'Users
whose accounts are disabled.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `flyspray_groups` VALUES (6, 'Project Managers',
'Permission to do anything related to the Default Project.',
1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_history`
--
DROP TABLE IF EXISTS `flyspray_history`;
CREATE TABLE `flyspray_history` (
`history_id` mediumint(10) NOT NULL auto_increment,
`task_id` mediumint(10) NOT NULL default '0',
`user_id` mediumint(3) NOT NULL default '0',
`event_date` int(11) NOT NULL default '0',
`event_type` mediumint(2) NOT NULL default '0',
`field_changed` varchar(50) NOT NULL,
`old_value` text NOT NULL,
`new_value` text NOT NULL,
PRIMARY KEY (`history_id`),
KEY `idx_task_id` (`task_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `flyspray_history`
--
INSERT INTO `flyspray_history` VALUES (1, 1, 1, 1130024797,
1, '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_list_category`
--
DROP TABLE IF EXISTS `flyspray_list_category`;
CREATE TABLE `flyspray_list_category` (
`category_id` mediumint(3) NOT NULL auto_increment,
`project_id` mediumint(3) NOT NULL default '0',
`category_name` varchar(30) NOT NULL default '',
`list_position` mediumint(3) NOT NULL default '0',
`show_in_list` mediumint(1) NOT NULL default '0',
`category_owner` mediumint(3) NOT NULL default '0',
`parent_id` mediumint(3) NOT NULL default '0',
`lft` int(10) unsigned NOT NULL default '0',
`rgt` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`category_id`),
KEY `project_id` (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `flyspray_list_category`
--
INSERT INTO `flyspray_list_category` VALUES (1, 1, 'Backend
/ Core', 1, 1, 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_list_os`
--
DROP TABLE IF EXISTS `flyspray_list_os`;
CREATE TABLE `flyspray_list_os` (
`os_id` mediumint(3) NOT NULL auto_increment,
`project_id` mediumint(3) NOT NULL default '0',
`os_name` varchar(20) NOT NULL default '',
`list_position` mediumint(3) NOT NULL default '0',
`show_in_list` mediumint(1) NOT NULL default '0',
PRIMARY KEY (`os_id`),
KEY `project_id` (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Operating
system list for the Flyspray bug killer' AUTO_INCREMENT=5 ;
--
-- Dumping data for table `flyspray_list_os`
--
INSERT INTO `flyspray_list_os` VALUES (1, 1, 'All', 1, 1);
INSERT INTO `flyspray_list_os` VALUES (2, 1, 'Windows', 2,
1);
INSERT INTO `flyspray_list_os` VALUES (3, 1, 'Linux', 3, 1);
INSERT INTO `flyspray_list_os` VALUES (4, 1, 'Mac OS', 4,
1);
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_list_resolution`
--
DROP TABLE IF EXISTS `flyspray_list_resolution`;
CREATE TABLE `flyspray_list_resolution` (
`resolution_id` mediumint(3) NOT NULL auto_increment,
`resolution_name` varchar(30) NOT NULL default '',
`list_position` mediumint(3) NOT NULL default '0',
`show_in_list` mediumint(1) NOT NULL default '0',
`project_id` mediumint(3) NOT NULL default '0',
PRIMARY KEY (`resolution_id`),
KEY `project_id` (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `flyspray_list_resolution`
--
INSERT INTO `flyspray_list_resolution` VALUES (1, 'Not a
bug', 1, 1, 0);
INSERT INTO `flyspray_list_resolution` VALUES (2, 'Won''t
fix', 2, 1, 0);
INSERT INTO `flyspray_list_resolution` VALUES (3, 'Won''t
implement', 3, 1, 0);
INSERT INTO `flyspray_list_resolution` VALUES (4, 'Works for
me', 4, 1, 0);
INSERT INTO `flyspray_list_resolution` VALUES (5,
'Duplicate', 5, 1, 0);
INSERT INTO `flyspray_list_resolution` VALUES (6,
'Deferred', 6, 1, 0);
INSERT INTO `flyspray_list_resolution` VALUES (7, 'Fixed',
7, 1, 0);
INSERT INTO `flyspray_list_resolution` VALUES (8,
'Implemented', 8, 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_list_status`
--
DROP TABLE IF EXISTS `flyspray_list_status`;
CREATE TABLE `flyspray_list_status` (
`status_id` mediumint(3) NOT NULL auto_increment,
`status_name` varchar(20) NOT NULL default '',
`list_position` mediumint(3) NOT NULL default '0',
`show_in_list` mediumint(1) NOT NULL default '0',
`project_id` mediumint(3) NOT NULL default '0',
PRIMARY KEY (`status_id`),
KEY `project_id` (`project_id`),
KEY `project_id_2` (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='List of
statuses for Flyspray the bug killer.' AUTO_INCREMENT=8 ;
--
-- Dumping data for table `flyspray_list_status`
--
INSERT INTO `flyspray_list_status` VALUES (1, 'Unconfirmed',
1, 1, 0);
INSERT INTO `flyspray_list_status` VALUES (2, 'New', 2, 1,
0);
INSERT INTO `flyspray_list_status` VALUES (3, 'Assigned', 3,
1, 0);
INSERT INTO `flyspray_list_status` VALUES (4, 'Researching',
4, 1, 0);
INSERT INTO `flyspray_list_status` VALUES (5, 'Waiting on
Customer', 5, 1, 0);
INSERT INTO `flyspray_list_status` VALUES (6, 'Requires
testing', 6, 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_list_tasktype`
--
DROP TABLE IF EXISTS `flyspray_list_tasktype`;
CREATE TABLE `flyspray_list_tasktype` (
`tasktype_id` mediumint(3) NOT NULL auto_increment,
`tasktype_name` varchar(20) NOT NULL default '',
`list_position` mediumint(3) NOT NULL default '0',
`show_in_list` mediumint(1) NOT NULL default '0',
`project_id` mediumint(3) NOT NULL default '0',
PRIMARY KEY (`tasktype_id`),
KEY `project_id` (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='List of task
types for Flyspray the bug killer.' AUTO_INCREMENT=3 ;
--
-- Dumping data for table `flyspray_list_tasktype`
--
INSERT INTO `flyspray_list_tasktype` VALUES (1, 'Bug
Report', 1, 1, 0);
INSERT INTO `flyspray_list_tasktype` VALUES (2, 'Feature
Request', 2, 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_list_version`
--
DROP TABLE IF EXISTS `flyspray_list_version`;
CREATE TABLE `flyspray_list_version` (
`version_id` mediumint(3) NOT NULL auto_increment,
`project_id` mediumint(3) NOT NULL default '0',
`version_name` varchar(20) NOT NULL default '',
`list_position` mediumint(3) NOT NULL default '0',
`show_in_list` mediumint(1) NOT NULL default '0',
`version_tense` mediumint(1) NOT NULL default '0',
PRIMARY KEY (`version_id`),
KEY `project_id` (`project_id`,`version_tense`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `flyspray_list_version`
--
INSERT INTO `flyspray_list_version` VALUES (1, 1,
'Development', 1, 1, 2);
-- --------------------------------------------------------
--
-- Table structure for table
`flyspray_notification_messages`
--
DROP TABLE IF EXISTS `flyspray_notification_messages`;
CREATE TABLE `flyspray_notification_messages` (
`message_id` mediumint(10) NOT NULL auto_increment,
`message_subject` varchar(100) NOT NULL,
`message_body` longtext NOT NULL,
`time_created` int(11) NOT NULL default '0',
PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Notification
body and subject' AUTO_INCREMENT=2 ;
--
-- Dumping data for table `flyspray_notification_messages`
--
-- --------------------------------------------------------
--
-- Table structure for table
`flyspray_notification_recipients`
--
DROP TABLE IF EXISTS `flyspray_notification_recipients`;
CREATE TABLE `flyspray_notification_recipients` (
`recipient_id` mediumint(10) NOT NULL auto_increment,
`message_id` mediumint(10) NOT NULL default '0',
`notify_method` char(1) NOT NULL default '',
`notify_address` varchar(100) NOT NULL default '',
PRIMARY KEY (`recipient_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Notification
recipient list' AUTO_INCREMENT=2 ;
--
-- Dumping data for table `flyspray_notification_recipients`
--
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_notifications`
--
DROP TABLE IF EXISTS `flyspray_notifications`;
CREATE TABLE `flyspray_notifications` (
`notify_id` mediumint(10) NOT NULL auto_increment,
`task_id` mediumint(10) NOT NULL default '0',
`user_id` mediumint(5) NOT NULL default '0',
PRIMARY KEY (`notify_id`),
UNIQUE KEY `task_id` (`task_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Extra task
notifications are stored here' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `flyspray_notifications`
--
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_prefs`
--
DROP TABLE IF EXISTS `flyspray_prefs`;
CREATE TABLE `flyspray_prefs` (
`pref_id` mediumint(1) NOT NULL auto_increment,
`pref_name` varchar(20) NOT NULL default '',
`pref_value` varchar(250) NOT NULL default '',
`pref_desc` varchar(100) NOT NULL default '',
PRIMARY KEY (`pref_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Application
preferences are set here' AUTO_INCREMENT=27 ;
--
-- Dumping data for table `flyspray_prefs`
--
INSERT INTO `flyspray_prefs` VALUES (1, 'fs_ver', '0.9.8',
'Current Flyspray version');
INSERT INTO `flyspray_prefs` VALUES (2, 'jabber_server', '',
'Jabber server');
INSERT INTO `flyspray_prefs` VALUES (3, 'jabber_port',
'5222', 'Jabber server port');
INSERT INTO `flyspray_prefs` VALUES (4, 'jabber_username',
'', 'Jabber username');
INSERT INTO `flyspray_prefs` VALUES (5, 'jabber_password',
'', 'Jabber password');
INSERT INTO `flyspray_prefs` VALUES (6, 'anon_group', '4',
'Group for anonymous registrations');
INSERT INTO `flyspray_prefs` VALUES (8, 'user_notify', '1',
'Force task notifications as');
INSERT INTO `flyspray_prefs` VALUES (9, 'admin_email',
'flyspray example.com', 'Reply email address for
notifications');
INSERT INTO `flyspray_prefs` VALUES (11, 'lang_code', 'en',
'Language');
INSERT INTO `flyspray_prefs` VALUES (12, 'spam_proof', '1',
'Use confirmation codes for user registrations');
INSERT INTO `flyspray_prefs` VALUES (13, 'default_project',
'1', 'Default project id');
INSERT INTO `flyspray_prefs` VALUES (14, 'dateformat',
'%Y-%m-%d', 'Default date format for new users and guests
used in the task list');
INSERT INTO `flyspray_prefs` VALUES (15,
'dateformat_extended', '%A, %d %B %Y, %H:%M %GMT', 'Default
date format for new users and guests used in task details');
INSERT INTO `flyspray_prefs` VALUES (16, 'anon_reg', '1',
'Allow new user registrations');
INSERT INTO `flyspray_prefs` VALUES (17, 'global_theme',
'Bluey', 'Theme to use when viewing all projects');
INSERT INTO `flyspray_prefs` VALUES (18, 'visible_columns',
'id project category tasktype severity summary status
progress', 'Columns visible when viewing all projects');
INSERT INTO `flyspray_prefs` VALUES (19, 'smtp_server', '',
'Remote mail server');
INSERT INTO `flyspray_prefs` VALUES (20, 'smtp_user', '',
'Username to access the remote mail server');
INSERT INTO `flyspray_prefs` VALUES (21, 'smtp_pass', '',
'Password to access the remote mail server');
INSERT INTO `flyspray_prefs` VALUES (22, 'cache_feeds', '0',
'0 = do not cache feeds, 1 = cache feeds on disk, 2 = cache
feeds in DB');
INSERT INTO `flyspray_prefs` VALUES (23,
'last_update_check', '1166826844', 'Time when the last
update check was done.');
INSERT INTO `flyspray_prefs` VALUES (24, 'jabber_ssl', '0',
'Whether or not to use SSL for Jabber connections');
INSERT INTO `flyspray_prefs` VALUES (25,
'notify_registration', '0', 'Whether or not admins get an
email on a new user registration');
INSERT INTO `flyspray_prefs` VALUES (26, 'page_title',
'Flyspray:: ', 'The title of the whole page');
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_projects`
--
DROP TABLE IF EXISTS `flyspray_projects`;
CREATE TABLE `flyspray_projects` (
`project_id` mediumint(3) NOT NULL auto_increment,
`project_title` varchar(100) NOT NULL default '',
`theme_style` varchar(20) NOT NULL default '0',
`default_cat_owner` mediumint(3) NOT NULL default '0',
`intro_message` text NOT NULL,
`project_is_active` mediumint(1) NOT NULL default '0',
`visible_columns` varchar(255) NOT NULL default '',
`others_view` mediumint(1) NOT NULL default '0',
`anon_open` mediumint(1) NOT NULL default '0',
`notify_email` longtext NOT NULL,
`notify_jabber` longtext NOT NULL,
`notify_reply` text NOT NULL,
`notify_types` varchar(100) NOT NULL default '0',
`feed_img_url` text NOT NULL,
`feed_description` text NOT NULL,
`notify_subject` varchar(100) NOT NULL,
`lang_code` varchar(10) NOT NULL,
`comment_closed` mediumint(1) NOT NULL default '0',
`auto_assign` mediumint(1) NOT NULL default '0',
`last_updated` int(11) NOT NULL default '0',
`default_task` text NOT NULL,
`default_entry` enum('index','roadmap','toplevel') NOT
NULL default 'index',
PRIMARY KEY (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Details on
multiple Flyspray projects' AUTO_INCREMENT=2 ;
--
-- Dumping data for table `flyspray_projects`
--
INSERT INTO `flyspray_projects` VALUES (1, 'Default
Project', 'Bluey', 0, 'Welcome to your first Flyspray
project! We hope that Flyspray provides you with many hours
of increased productivity. If you have any issues, please
read <a href="http
://flyspray.rocks.cc/manual/toc">the
documentation</a> and <a href="http
://flyspray.rocks.cc/faq">Frequently Asked
Questions</a>. <br /><br />You can
customise this message by clicking the <b>Manage
Project</b> link in the menu above...', 1, 'id
category tasktype severity summary status progress', 1, 0,
'', '', '', '0', '', '', '', '', 0, 0, 0, '', 'index');
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_registrations`
--
DROP TABLE IF EXISTS `flyspray_registrations`;
CREATE TABLE `flyspray_registrations` (
`reg_id` mediumint(10) NOT NULL auto_increment,
`reg_time` int(11) NOT NULL default '0',
`confirm_code` varchar(20) NOT NULL default '',
`user_name` varchar(32) NOT NULL,
`real_name` varchar(100) NOT NULL default '',
`email_address` varchar(100) NOT NULL default '',
`jabber_id` varchar(100) NOT NULL default '',
`notify_type` mediumint(1) NOT NULL default '0',
`magic_url` varchar(40) NOT NULL default '',
`time_zone` smallint(6) NOT NULL default '0',
PRIMARY KEY (`reg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Storage for
new user registration confirmation codes' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `flyspray_registrations`
--
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_related`
--
DROP TABLE IF EXISTS `flyspray_related`;
CREATE TABLE `flyspray_related` (
`related_id` mediumint(10) NOT NULL auto_increment,
`this_task` mediumint(10) NOT NULL default '0',
`related_task` mediumint(10) NOT NULL default '0',
`is_duplicate` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`related_id`),
UNIQUE KEY `this_task`
(`this_task`,`related_task`,`is_duplicate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Related task
entries' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `flyspray_related`
--
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_reminders`
--
DROP TABLE IF EXISTS `flyspray_reminders`;
CREATE TABLE `flyspray_reminders` (
`reminder_id` mediumint(10) NOT NULL auto_increment,
`task_id` mediumint(10) NOT NULL default '0',
`to_user_id` mediumint(3) NOT NULL default '0',
`from_user_id` mediumint(3) NOT NULL default '0',
`start_time` int(11) NOT NULL default '0',
`how_often` mediumint(12) NOT NULL default '0',
`last_sent` int(11) NOT NULL default '0',
`reminder_message` longtext NOT NULL,
PRIMARY KEY (`reminder_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Scheduled
reminders about tasks' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `flyspray_reminders`
--
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_searches`
--
DROP TABLE IF EXISTS `flyspray_searches`;
CREATE TABLE `flyspray_searches` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`search_string` text NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Saves custom
searches' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `flyspray_searches`
--
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_tasks`
--
DROP TABLE IF EXISTS `flyspray_tasks`;
CREATE TABLE `flyspray_tasks` (
`task_id` mediumint(10) NOT NULL auto_increment,
`project_id` mediumint(3) NOT NULL default '0',
`task_type` mediumint(3) NOT NULL default '0',
`date_opened` int(11) NOT NULL default '0',
`opened_by` mediumint(3) NOT NULL default '0',
`is_closed` mediumint(1) NOT NULL default '0',
`date_closed` int(11) NOT NULL default '0',
`closed_by` mediumint(3) NOT NULL default '0',
`closure_comment` text NOT NULL,
`item_summary` varchar(100) NOT NULL default '',
`detailed_desc` text NOT NULL,
`item_status` mediumint(3) NOT NULL default '0',
`resolution_reason` mediumint(3) NOT NULL default '1',
`product_category` mediumint(3) NOT NULL default '0',
`product_version` mediumint(3) NOT NULL default '0',
`closedby_version` mediumint(3) NOT NULL default '0',
`operating_system` mediumint(3) NOT NULL default '0',
`task_severity` mediumint(3) NOT NULL default '0',
`task_priority` mediumint(3) NOT NULL default '0',
`last_edited_by` mediumint(3) NOT NULL default '0',
`last_edited_time` int(11) NOT NULL default '0',
`percent_complete` mediumint(3) NOT NULL default '0',
`mark_private` mediumint(1) NOT NULL default '0',
`due_date` int(11) NOT NULL default '0',
`anon_email` varchar(100) NOT NULL default '',
`task_token` varchar(32) NOT NULL default '0',
PRIMARY KEY (`task_id`),
KEY `attached_to_project` (`project_id`),
KEY `task_severity` (`task_severity`),
KEY `task_type` (`task_type`),
KEY `product_category` (`product_category`),
KEY `item_status` (`item_status`),
KEY `is_closed` (`is_closed`),
KEY `closedby_version` (`closedby_version`),
KEY `due_date` (`due_date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Bugs and
feature requests for the Flyspray bug killer'
AUTO_INCREMENT=2 ;
--
-- Dumping data for table `flyspray_tasks`
--
INSERT INTO `flyspray_tasks` VALUES (1, 1, 1, 1130024797, 1,
0, 0, 1, ' ', 'Sample Task', 'This isn''t a real task. You
should close it and start opening some real tasks.', 2, 1,
1, 1, 0, 1, 1, 2, 0, 0, 0, 0, 0, '', '0');
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_users`
--
DROP TABLE IF EXISTS `flyspray_users`;
CREATE TABLE `flyspray_users` (
`user_id` mediumint(3) NOT NULL auto_increment,
`user_name` varchar(32) NOT NULL,
`user_pass` varchar(40) default NULL,
`real_name` varchar(100) NOT NULL default '',
`jabber_id` varchar(100) NOT NULL default '',
`email_address` varchar(100) NOT NULL default '',
`notify_type` mediumint(1) NOT NULL default '0',
`notify_own` smallint(6) NOT NULL default '0',
`account_enabled` mediumint(1) NOT NULL default '0',
`dateformat` varchar(30) NOT NULL default '',
`dateformat_extended` varchar(30) NOT NULL default '',
`magic_url` varchar(40) NOT NULL default '',
`last_search` longtext NOT NULL,
`tasks_perpage` mediumint(3) NOT NULL default '0',
`register_date` int(11) NOT NULL default '0',
`time_zone` smallint(6) NOT NULL default '0',
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_name` (`user_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Users for
the Flyspray bug killer' AUTO_INCREMENT=2 ;
--
-- Dumping data for table `flyspray_users`
--
INSERT INTO `flyspray_users` VALUES (1, 'super',
'1b3231655cebb7a1f783eddf27d254ca', 'Mr Super User',
'superexample.com', 'superexample.com', 0, 0, 1, '',
'', '',
'a:28:{s:6:"string";N;s:4:"type";N;s:3:&
quot;sev";N;s:3:"pri";N;s:3:"due";N
;s:3:"dev";N;s:3:"cat";N;s:6:"statu
s";N;s:5:"order";N;s:4:"sort";N;s:7
:"percent";N;s:11:"changedfrom";N;s:10:&
quot;closedfrom";N;s:6:"opened";N;s:6:"c
losed";N;s:18:"search_in_comments";N;s:14:&qu
ot;search_for_all";N;s:8:"reported";N;s:12:&q
uot;only_primary";N;s:12:"only_watched";N;s:8
:"closedto";N;s:9:"changedto";N;s:11:&qu
ot;duedatefrom";N;s:9:"duedateto";N;s:10:&quo
t;openedfrom";N;s:8:"openedto";N;s:14:"h
as_attachment";N;s:10:"did_search";N;}', 25,
0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_users_in_groups`
--
DROP TABLE IF EXISTS `flyspray_users_in_groups`;
CREATE TABLE `flyspray_users_in_groups` (
`record_id` mediumint(5) NOT NULL auto_increment,
`user_id` mediumint(5) NOT NULL default '0',
`group_id` mediumint(3) NOT NULL default '0',
PRIMARY KEY (`record_id`),
UNIQUE KEY `group_id` (`group_id`,`user_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Which users
are in which groups' AUTO_INCREMENT=2 ;
--
-- Dumping data for table `flyspray_users_in_groups`
--
INSERT INTO `flyspray_users_in_groups` VALUES (1, 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `flyspray_votes`
--
DROP TABLE IF EXISTS `flyspray_votes`;
CREATE TABLE `flyspray_votes` (
`vote_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`task_id` int(11) NOT NULL,
`date_time` int(11) NOT NULL default '0',
PRIMARY KEY (`vote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Tallies
votes for tasks' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `flyspray_votes`
--
_______________________________________________
flyspray mailing list
flyspraylists.rocks.cc
http://lists.rocks.cc/listinfo.cgi/flyspray-rocks.cc
|