Project

General

Profile

RE: rake aborted! » redmine_scc.sql

database schema structure - Rafi Greenberg, 2010-07-21 18:29

 
-- phpMyAdmin SQL Dump
-- version 2.11.9.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 21, 2010 at 09:24 AM
-- Server version: 5.0.77
-- PHP Version: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 */;

--
-- Database: `redmine_scc`
--

-- --------------------------------------------------------

--
-- Table structure for table `attachments`
--

CREATE TABLE IF NOT EXISTS `attachments` (
`id` int(11) NOT NULL auto_increment,
`container_id` int(11) NOT NULL default '0',
`container_type` varchar(30) NOT NULL default '',
`filename` varchar(255) NOT NULL default '',
`disk_filename` varchar(255) NOT NULL default '',
`filesize` int(11) NOT NULL default '0',
`content_type` varchar(255) default '',
`digest` varchar(40) NOT NULL default '',
`downloads` int(11) NOT NULL default '0',
`author_id` int(11) NOT NULL default '0',
`created_on` datetime default NULL,
`description` varchar(255) default NULL,
PRIMARY KEY (`id`),
KEY `index_attachments_on_container_id_and_container_type` (`container_id`,`container_type`),
KEY `index_attachments_on_author_id` (`author_id`),
KEY `index_attachments_on_created_on` (`created_on`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=508 ;

-- --------------------------------------------------------

--
-- Table structure for table `auth_sources`
--

CREATE TABLE IF NOT EXISTS `auth_sources` (
`id` int(11) NOT NULL auto_increment,
`type` varchar(30) NOT NULL default '',
`name` varchar(60) NOT NULL default '',
`host` varchar(60) default NULL,
`port` int(11) default NULL,
`account` varchar(255) default NULL,
`account_password` varchar(60) default NULL,
`base_dn` varchar(255) default NULL,
`attr_login` varchar(30) default NULL,
`attr_firstname` varchar(30) default NULL,
`attr_lastname` varchar(30) default NULL,
`attr_mail` varchar(30) default NULL,
`onthefly_register` tinyint(1) NOT NULL default '0',
`tls` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index_auth_sources_on_id_and_type` (`id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `boards`
--

CREATE TABLE IF NOT EXISTS `boards` (
`id` int(11) NOT NULL auto_increment,
`project_id` int(11) NOT NULL,
`name` varchar(255) NOT NULL default '',
`description` varchar(255) default NULL,
`position` int(11) default '1',
`topics_count` int(11) NOT NULL default '0',
`messages_count` int(11) NOT NULL default '0',
`last_message_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `boards_project_id` (`project_id`),
KEY `index_boards_on_last_message_id` (`last_message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Table structure for table `changes`
--

CREATE TABLE IF NOT EXISTS `changes` (
`id` int(11) NOT NULL auto_increment,
`changeset_id` int(11) NOT NULL,
`action` varchar(1) NOT NULL default '',
`path` varchar(255) NOT NULL default '',
`from_path` varchar(255) default NULL,
`from_revision` varchar(255) default NULL,
`revision` varchar(255) default NULL,
`branch` varchar(255) default NULL,
PRIMARY KEY (`id`),
KEY `changesets_changeset_id` (`changeset_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=275853 ;

-- --------------------------------------------------------

--
-- Table structure for table `changesets`
--

CREATE TABLE IF NOT EXISTS `changesets` (
`id` int(11) NOT NULL auto_increment,
`repository_id` int(11) NOT NULL,
`revision` varchar(255) NOT NULL,
`committer` varchar(255) default NULL,
`committed_on` datetime NOT NULL,
`comments` text,
`commit_date` date default NULL,
`scmid` varchar(255) default NULL,
`user_id` int(11) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `changesets_repos_rev` (`repository_id`,`revision`),
KEY `index_changesets_on_user_id` (`user_id`),
KEY `index_changesets_on_repository_id` (`repository_id`),
KEY `index_changesets_on_committed_on` (`committed_on`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9554 ;

-- --------------------------------------------------------

--
-- Table structure for table `changesets_issues`
--

CREATE TABLE IF NOT EXISTS `changesets_issues` (
`changeset_id` int(11) NOT NULL,
`issue_id` int(11) NOT NULL,
UNIQUE KEY `changesets_issues_ids` (`changeset_id`,`issue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
`id` int(11) NOT NULL auto_increment,
`commented_type` varchar(30) NOT NULL default '',
`commented_id` int(11) NOT NULL default '0',
`author_id` int(11) NOT NULL default '0',
`comments` text,
`created_on` datetime NOT NULL,
`updated_on` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_comments_on_commented_id_and_commented_type` (`commented_id`,`commented_type`),
KEY `index_comments_on_author_id` (`author_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `custom_fields`
--

CREATE TABLE IF NOT EXISTS `custom_fields` (
`id` int(11) NOT NULL auto_increment,
`type` varchar(30) NOT NULL default '',
`name` varchar(50) NOT NULL,
`field_format` varchar(30) NOT NULL default '',
`possible_values` text,
`regexp` varchar(255) default '',
`min_length` int(11) NOT NULL default '0',
`max_length` int(11) NOT NULL default '0',
`is_required` tinyint(1) NOT NULL default '0',
`is_for_all` tinyint(1) NOT NULL default '0',
`is_filter` tinyint(1) NOT NULL default '0',
`position` int(11) default '1',
`searchable` tinyint(1) default '0',
`default_value` text,
`editable` tinyint(1) default '1',
PRIMARY KEY (`id`),
KEY `index_custom_fields_on_id_and_type` (`id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- --------------------------------------------------------

--
-- Table structure for table `custom_fields_projects`
--

CREATE TABLE IF NOT EXISTS `custom_fields_projects` (
`custom_field_id` int(11) NOT NULL default '0',
`project_id` int(11) NOT NULL default '0',
KEY `index_custom_fields_projects_on_custom_field_id_and_project_id` (`custom_field_id`,`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `custom_fields_trackers`
--

CREATE TABLE IF NOT EXISTS `custom_fields_trackers` (
`custom_field_id` int(11) NOT NULL default '0',
`tracker_id` int(11) NOT NULL default '0',
KEY `index_custom_fields_trackers_on_custom_field_id_and_tracker_id` (`custom_field_id`,`tracker_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `custom_values`
--

CREATE TABLE IF NOT EXISTS `custom_values` (
`id` int(11) NOT NULL auto_increment,
`customized_type` varchar(30) NOT NULL default '',
`customized_id` int(11) NOT NULL default '0',
`custom_field_id` int(11) NOT NULL default '0',
`value` text,
PRIMARY KEY (`id`),
KEY `custom_values_customized` (`customized_type`,`customized_id`),
KEY `index_custom_values_on_custom_field_id` (`custom_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=909 ;

-- --------------------------------------------------------

--
-- Table structure for table `documents`
--

CREATE TABLE IF NOT EXISTS `documents` (
`id` int(11) NOT NULL auto_increment,
`project_id` int(11) NOT NULL default '0',
`category_id` int(11) NOT NULL default '0',
`title` varchar(60) NOT NULL default '',
`description` text,
`created_on` datetime default NULL,
PRIMARY KEY (`id`),
KEY `documents_project_id` (`project_id`),
KEY `index_documents_on_category_id` (`category_id`),
KEY `index_documents_on_created_on` (`created_on`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;

-- --------------------------------------------------------

--
-- Table structure for table `enabled_modules`
--

CREATE TABLE IF NOT EXISTS `enabled_modules` (
`id` int(11) NOT NULL auto_increment,
`project_id` int(11) default NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `enabled_modules_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=549 ;

-- --------------------------------------------------------

--
-- Table structure for table `enumerations`
--

CREATE TABLE IF NOT EXISTS `enumerations` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`position` int(11) default '1',
`is_default` tinyint(1) NOT NULL default '0',
`type` varchar(255) default NULL,
`active` tinyint(1) NOT NULL default '1',
`project_id` int(11) default NULL,
`parent_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `index_enumerations_on_project_id` (`project_id`),
KEY `index_enumerations_on_id_and_type` (`id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

-- --------------------------------------------------------

--
-- Table structure for table `groups_users`
--

CREATE TABLE IF NOT EXISTS `groups_users` (
`group_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
UNIQUE KEY `groups_users_ids` (`group_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hudson_builds`
--

CREATE TABLE IF NOT EXISTS `hudson_builds` (
`id` int(11) NOT NULL auto_increment,
`hudson_job_id` int(11) default NULL,
`result` varchar(255) default NULL,
`finished_at` datetime default NULL,
`building` varchar(255) default NULL,
`error` varchar(255) default NULL,
`caused_by` int(11) default NULL,
`number` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=151 ;

-- --------------------------------------------------------

--
-- Table structure for table `hudson_build_artifacts`
--

CREATE TABLE IF NOT EXISTS `hudson_build_artifacts` (
`id` int(11) NOT NULL auto_increment,
`hudson_build_id` int(11) default NULL,
`display_path` text,
`file_name` text,
`relative_path` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=57 ;

-- --------------------------------------------------------

--
-- Table structure for table `hudson_build_changesets`
--

CREATE TABLE IF NOT EXISTS `hudson_build_changesets` (
`id` int(11) NOT NULL auto_increment,
`hudson_build_id` int(11) default NULL,
`repository_id` int(11) default NULL,
`revision` varchar(255) default NULL,
`error` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=353 ;

-- --------------------------------------------------------

--
-- Table structure for table `hudson_build_test_results`
--

CREATE TABLE IF NOT EXISTS `hudson_build_test_results` (
`id` int(11) NOT NULL auto_increment,
`hudson_build_id` int(11) default NULL,
`fail_count` int(11) default NULL,
`skip_count` int(11) default NULL,
`total_count` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `hudson_health_reports`
--

CREATE TABLE IF NOT EXISTS `hudson_health_reports` (
`id` int(11) NOT NULL auto_increment,
`hudson_job_id` int(11) default NULL,
`description` text,
`score` int(11) default NULL,
`url` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--
-- Table structure for table `hudson_jobs`
--

CREATE TABLE IF NOT EXISTS `hudson_jobs` (
`id` int(11) NOT NULL auto_increment,
`project_id` int(11) default NULL,
`hudson_id` int(11) default NULL,
`name` varchar(255) default NULL,
`latest_build_number` varchar(255) default NULL,
`created_at` datetime default NULL,
`updated_at` datetime default NULL,
`description` text,
`state` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--
-- Table structure for table `hudson_job_settings`
--

CREATE TABLE IF NOT EXISTS `hudson_job_settings` (
`id` int(11) NOT NULL auto_increment,
`hudson_job_id` int(11) default NULL,
`build_rotate` tinyint(1) default '0',
`build_rotator_days_to_keep` int(11) default '-1',
`build_rotator_num_to_keep` int(11) default '-1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--
-- Table structure for table `hudson_settings`
--

CREATE TABLE IF NOT EXISTS `hudson_settings` (
`id` int(11) NOT NULL auto_increment,
`project_id` int(11) default NULL,
`url` varchar(255) default NULL,
`job_filter` varchar(255) default NULL,
`show_compact` tinyint(1) default '0',
`auth_user` varchar(255) default '',
`auth_password` varchar(255) default '',
`get_build_details` tinyint(1) default '1',
`look_and_feel` varchar(255) default 'Hudson',
`url_for_plugin` varchar(255) default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Table structure for table `hudson_settings_health_reports`
--

CREATE TABLE IF NOT EXISTS `hudson_settings_health_reports` (
`id` int(11) NOT NULL auto_increment,
`hudson_settings_id` int(11) default NULL,
`keyword` varchar(255) default NULL,
`url_format` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `issues`
--

CREATE TABLE IF NOT EXISTS `issues` (
`id` int(11) NOT NULL auto_increment,
`tracker_id` int(11) NOT NULL default '0',
`project_id` int(11) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`description` text,
`due_date` date default NULL,
`category_id` int(11) default NULL,
`status_id` int(11) NOT NULL default '0',
`assigned_to_id` int(11) default NULL,
`priority_id` int(11) NOT NULL default '0',
`fixed_version_id` int(11) default NULL,
`author_id` int(11) NOT NULL default '0',
`lock_version` int(11) NOT NULL default '0',
`created_on` datetime default NULL,
`updated_on` datetime default NULL,
`start_date` date default NULL,
`done_ratio` int(11) NOT NULL default '0',
`estimated_hours` float default NULL,
PRIMARY KEY (`id`),
KEY `issues_project_id` (`project_id`),
KEY `index_issues_on_status_id` (`status_id`),
KEY `index_issues_on_category_id` (`category_id`),
KEY `index_issues_on_assigned_to_id` (`assigned_to_id`),
KEY `index_issues_on_fixed_version_id` (`fixed_version_id`),
KEY `index_issues_on_tracker_id` (`tracker_id`),
KEY `index_issues_on_priority_id` (`priority_id`),
KEY `index_issues_on_author_id` (`author_id`),
KEY `index_issues_on_created_on` (`created_on`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1008 ;

-- --------------------------------------------------------

--
-- Table structure for table `issue_categories`
--

CREATE TABLE IF NOT EXISTS `issue_categories` (
`id` int(11) NOT NULL auto_increment,
`project_id` int(11) NOT NULL default '0',
`name` varchar(30) NOT NULL default '',
`assigned_to_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `issue_categories_project_id` (`project_id`),
KEY `index_issue_categories_on_assigned_to_id` (`assigned_to_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=54 ;

-- --------------------------------------------------------

--
-- Table structure for table `issue_relations`
--

CREATE TABLE IF NOT EXISTS `issue_relations` (
`id` int(11) NOT NULL auto_increment,
`issue_from_id` int(11) NOT NULL,
`issue_to_id` int(11) NOT NULL,
`relation_type` varchar(255) NOT NULL default '',
`delay` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `index_issue_relations_on_issue_from_id` (`issue_from_id`),
KEY `index_issue_relations_on_issue_to_id` (`issue_to_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `issue_statuses`
--

CREATE TABLE IF NOT EXISTS `issue_statuses` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`is_closed` tinyint(1) NOT NULL default '0',
`is_default` tinyint(1) NOT NULL default '0',
`position` int(11) default '1',
`default_done_ratio` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `index_issue_statuses_on_position` (`position`),
KEY `index_issue_statuses_on_is_closed` (`is_closed`),
KEY `index_issue_statuses_on_is_default` (`is_default`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

--
-- Table structure for table `journals`
--

CREATE TABLE IF NOT EXISTS `journals` (
`id` int(11) NOT NULL auto_increment,
`journalized_id` int(11) NOT NULL default '0',
`journalized_type` varchar(30) NOT NULL default '',
`user_id` int(11) NOT NULL default '0',
`notes` text,
`created_on` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `journals_journalized_id` (`journalized_id`,`journalized_type`),
KEY `index_journals_on_user_id` (`user_id`),
KEY `index_journals_on_journalized_id` (`journalized_id`),
KEY `index_journals_on_created_on` (`created_on`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1231 ;

-- --------------------------------------------------------

--
-- Table structure for table `journal_details`
--

CREATE TABLE IF NOT EXISTS `journal_details` (
`id` int(11) NOT NULL auto_increment,
`journal_id` int(11) NOT NULL default '0',
`property` varchar(30) NOT NULL default '',
`prop_key` varchar(30) NOT NULL default '',
`old_value` varchar(255) default NULL,
`value` varchar(255) default NULL,
PRIMARY KEY (`id`),
KEY `journal_details_journal_id` (`journal_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1728 ;

-- --------------------------------------------------------

--
-- Table structure for table `license_keys`
--

CREATE TABLE IF NOT EXISTS `license_keys` (
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`org` varchar(30) NOT NULL,
`customer_code` varchar(19) default NULL,
`registration_key` varchar(40) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=62 ;

-- --------------------------------------------------------

--
-- Table structure for table `members`
--

CREATE TABLE IF NOT EXISTS `members` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`project_id` int(11) NOT NULL default '0',
`created_on` datetime default NULL,
`mail_notification` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index_members_on_user_id` (`user_id`),
KEY `index_members_on_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=263 ;

-- --------------------------------------------------------

--
-- Table structure for table `member_roles`
--

CREATE TABLE IF NOT EXISTS `member_roles` (
`id` int(11) NOT NULL auto_increment,
`member_id` int(11) NOT NULL,
`role_id` int(11) NOT NULL,
`inherited_from` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `index_member_roles_on_member_id` (`member_id`),
KEY `index_member_roles_on_role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=263 ;

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
`id` int(11) NOT NULL auto_increment,
`board_id` int(11) NOT NULL,
`parent_id` int(11) default NULL,
`subject` varchar(255) NOT NULL default '',
`content` text,
`author_id` int(11) default NULL,
`replies_count` int(11) NOT NULL default '0',
`last_reply_id` int(11) default NULL,
`created_on` datetime NOT NULL,
`updated_on` datetime NOT NULL,
`locked` tinyint(1) default '0',
`sticky` int(11) default '0',
PRIMARY KEY (`id`),
KEY `messages_board_id` (`board_id`),
KEY `messages_parent_id` (`parent_id`),
KEY `index_messages_on_last_reply_id` (`last_reply_id`),
KEY `index_messages_on_author_id` (`author_id`),
KEY `index_messages_on_created_on` (`created_on`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
`id` int(11) NOT NULL auto_increment,
`project_id` int(11) default NULL,
`title` varchar(60) NOT NULL default '',
`summary` varchar(255) default '',
`description` text,
`author_id` int(11) NOT NULL default '0',
`created_on` datetime default NULL,
`comments_count` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `news_project_id` (`project_id`),
KEY `index_news_on_author_id` (`author_id`),
KEY `index_news_on_created_on` (`created_on`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Table structure for table `open_id_authentication_associations`
--

CREATE TABLE IF NOT EXISTS `open_id_authentication_associations` (
`id` int(11) NOT NULL auto_increment,
`issued` int(11) default NULL,
`lifetime` int(11) default NULL,
`handle` varchar(255) default NULL,
`assoc_type` varchar(255) default NULL,
`server_url` blob,
`secret` blob,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `open_id_authentication_nonces`
--

CREATE TABLE IF NOT EXISTS `open_id_authentication_nonces` (
`id` int(11) NOT NULL auto_increment,
`timestamp` int(11) NOT NULL,
`server_url` varchar(255) default NULL,
`salt` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `plugin_schema_info`
--

CREATE TABLE IF NOT EXISTS `plugin_schema_info` (
`plugin_name` varchar(255) default NULL,
`version` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `projects`
--

CREATE TABLE IF NOT EXISTS `projects` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL,
`description` text,
`homepage` varchar(255) default '',
`is_public` tinyint(1) NOT NULL default '1',
`parent_id` int(11) default NULL,
`created_on` datetime default NULL,
`updated_on` datetime default NULL,
`identifier` varchar(20) default NULL,
`status` int(11) NOT NULL default '1',
`lft` int(11) default NULL,
`rgt` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `index_projects_on_lft` (`lft`),
KEY `index_projects_on_rgt` (`rgt`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;

-- --------------------------------------------------------

--
-- Table structure for table `projects_trackers`
--

CREATE TABLE IF NOT EXISTS `projects_trackers` (
`project_id` int(11) NOT NULL default '0',
`tracker_id` int(11) NOT NULL default '0',
UNIQUE KEY `projects_trackers_unique` (`project_id`,`tracker_id`),
KEY `projects_trackers_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `queries`
--

CREATE TABLE IF NOT EXISTS `queries` (
`id` int(11) NOT NULL auto_increment,
`project_id` int(11) default NULL,
`name` varchar(255) NOT NULL default '',
`filters` text,
`user_id` int(11) NOT NULL default '0',
`is_public` tinyint(1) NOT NULL default '0',
`column_names` text,
`sort_criteria` text,
`group_by` varchar(255) default NULL,
PRIMARY KEY (`id`),
KEY `index_queries_on_project_id` (`project_id`),
KEY `index_queries_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `repositories`
--

CREATE TABLE IF NOT EXISTS `repositories` (
`id` int(11) NOT NULL auto_increment,
`project_id` int(11) NOT NULL default '0',
`url` varchar(255) NOT NULL default '',
`login` varchar(60) default '',
`password` varchar(60) default '',
`root_url` varchar(255) default '',
`type` varchar(255) default NULL,
`checkout_settings` text,
PRIMARY KEY (`id`),
KEY `index_repositories_on_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE IF NOT EXISTS `roles` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`position` int(11) default '1',
`assignable` tinyint(1) default '1',
`builtin` int(11) NOT NULL default '0',
`permissions` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

--
-- Table structure for table `schema_migrations`
--

CREATE TABLE IF NOT EXISTS `schema_migrations` (
`version` varchar(255) NOT NULL,
UNIQUE KEY `unique_schema_migrations` (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`value` text,
`updated_on` datetime default NULL,
PRIMARY KEY (`id`),
KEY `index_settings_on_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;

-- --------------------------------------------------------

--
-- Table structure for table `time_entries`
--

CREATE TABLE IF NOT EXISTS `time_entries` (
`id` int(11) NOT NULL auto_increment,
`project_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`issue_id` int(11) default NULL,
`hours` float NOT NULL,
`comments` varchar(255) default NULL,
`activity_id` int(11) NOT NULL,
`spent_on` date NOT NULL,
`tyear` int(11) NOT NULL,
`tmonth` int(11) NOT NULL,
`tweek` int(11) NOT NULL,
`created_on` datetime NOT NULL,
`updated_on` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `time_entries_project_id` (`project_id`),
KEY `time_entries_issue_id` (`issue_id`),
KEY `index_time_entries_on_activity_id` (`activity_id`),
KEY `index_time_entries_on_user_id` (`user_id`),
KEY `index_time_entries_on_created_on` (`created_on`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;

-- --------------------------------------------------------

--
-- Table structure for table `tokens`
--

CREATE TABLE IF NOT EXISTS `tokens` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`action` varchar(30) NOT NULL default '',
`value` varchar(40) NOT NULL default '',
`created_on` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_tokens_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=181 ;

-- --------------------------------------------------------

--
-- Table structure for table `trackers`
--

CREATE TABLE IF NOT EXISTS `trackers` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`is_in_chlog` tinyint(1) NOT NULL default '0',
`position` int(11) default '1',
`is_in_roadmap` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL auto_increment,
`login` varchar(30) NOT NULL default '',
`hashed_password` varchar(40) NOT NULL default '',
`firstname` varchar(30) NOT NULL default '',
`lastname` varchar(30) NOT NULL default '',
`mail` varchar(60) NOT NULL default '',
`mail_notification` tinyint(1) NOT NULL default '1',
`admin` tinyint(1) NOT NULL default '0',
`status` int(11) NOT NULL default '1',
`last_login_on` datetime default NULL,
`language` varchar(5) default '',
`auth_source_id` int(11) default NULL,
`created_on` datetime default NULL,
`updated_on` datetime default NULL,
`type` varchar(255) default NULL,
`identity_url` varchar(255) default NULL,
PRIMARY KEY (`id`),
KEY `index_users_on_id_and_type` (`id`,`type`),
KEY `index_users_on_auth_source_id` (`auth_source_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=83 ;

-- --------------------------------------------------------

--
-- Table structure for table `user_preferences`
--

CREATE TABLE IF NOT EXISTS `user_preferences` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`others` text,
`hide_mail` tinyint(1) default '0',
`time_zone` varchar(255) default NULL,
PRIMARY KEY (`id`),
KEY `index_user_preferences_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 ;

-- --------------------------------------------------------

--
-- Table structure for table `versions`
--

CREATE TABLE IF NOT EXISTS `versions` (
`id` int(11) NOT NULL auto_increment,
`project_id` int(11) NOT NULL default '0',
`name` varchar(255) default '',
`description` varchar(255) default '',
`effective_date` date default NULL,
`created_on` datetime default NULL,
`updated_on` datetime default NULL,
`wiki_page_title` varchar(255) default NULL,
`status` varchar(255) default 'open',
`sharing` varchar(255) NOT NULL default 'none',
PRIMARY KEY (`id`),
KEY `versions_project_id` (`project_id`),
KEY `index_versions_on_sharing` (`sharing`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=93 ;

-- --------------------------------------------------------

--
-- Table structure for table `watchers`
--

CREATE TABLE IF NOT EXISTS `watchers` (
`id` int(11) NOT NULL auto_increment,
`watchable_type` varchar(255) NOT NULL default '',
`watchable_id` int(11) NOT NULL default '0',
`user_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `watchers_user_id_type` (`user_id`,`watchable_type`),
KEY `index_watchers_on_user_id` (`user_id`),
KEY `index_watchers_on_watchable_id_and_watchable_type` (`watchable_id`,`watchable_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=91 ;

-- --------------------------------------------------------

--
-- Table structure for table `wikis`
--

CREATE TABLE IF NOT EXISTS `wikis` (
`id` int(11) NOT NULL auto_increment,
`project_id` int(11) NOT NULL,
`start_page` varchar(255) NOT NULL,
`status` int(11) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `wikis_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

-- --------------------------------------------------------

--
-- Table structure for table `wiki_contents`
--

CREATE TABLE IF NOT EXISTS `wiki_contents` (
`id` int(11) NOT NULL auto_increment,
`page_id` int(11) NOT NULL,
`author_id` int(11) default NULL,
`text` longtext,
`comments` varchar(255) default '',
`updated_on` datetime NOT NULL,
`version` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `wiki_contents_page_id` (`page_id`),
KEY `index_wiki_contents_on_author_id` (`author_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=74 ;

-- --------------------------------------------------------

--
-- Table structure for table `wiki_content_versions`
--

CREATE TABLE IF NOT EXISTS `wiki_content_versions` (
`id` int(11) NOT NULL auto_increment,
`wiki_content_id` int(11) NOT NULL,
`page_id` int(11) NOT NULL,
`author_id` int(11) default NULL,
`data` longblob,
`compression` varchar(6) default '',
`comments` varchar(255) default '',
`updated_on` datetime NOT NULL,
`version` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `wiki_content_versions_wcid` (`wiki_content_id`),
KEY `index_wiki_content_versions_on_updated_on` (`updated_on`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=319 ;

-- --------------------------------------------------------

--
-- Table structure for table `wiki_pages`
--

CREATE TABLE IF NOT EXISTS `wiki_pages` (
`id` int(11) NOT NULL auto_increment,
`wiki_id` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`created_on` datetime NOT NULL,
`protected` tinyint(1) NOT NULL default '0',
`parent_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `wiki_pages_wiki_id_title` (`wiki_id`,`title`),
KEY `index_wiki_pages_on_wiki_id` (`wiki_id`),
KEY `index_wiki_pages_on_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=74 ;

-- --------------------------------------------------------

--
-- Table structure for table `wiki_redirects`
--

CREATE TABLE IF NOT EXISTS `wiki_redirects` (
`id` int(11) NOT NULL auto_increment,
`wiki_id` int(11) NOT NULL,
`title` varchar(255) default NULL,
`redirects_to` varchar(255) default NULL,
`created_on` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `wiki_redirects_wiki_id_title` (`wiki_id`,`title`),
KEY `index_wiki_redirects_on_wiki_id` (`wiki_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `workflows`
--

CREATE TABLE IF NOT EXISTS `workflows` (
`id` int(11) NOT NULL auto_increment,
`tracker_id` int(11) NOT NULL default '0',
`old_status_id` int(11) NOT NULL default '0',
`new_status_id` int(11) NOT NULL default '0',
`role_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `wkfs_role_tracker_old_status` (`role_id`,`tracker_id`,`old_status_id`),
KEY `index_workflows_on_old_status_id` (`old_status_id`),
KEY `index_workflows_on_role_id` (`role_id`),
KEY `index_workflows_on_new_status_id` (`new_status_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=321 ;
(2-2/2)