Server : ApacheSystem : Linux host44.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64 User : vapecompany ( 2719) PHP Version : 7.4.33 Disable Function : NONE Directory : /var/softaculous/traq/ |
Upload File : |
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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: `traq373`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]attachments`
--
CREATE TABLE `[[dbprefix]]attachments` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`contents` longtext COLLATE utf8_unicode_ci NOT NULL,
`type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`size` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
`ticket_id` bigint(20) NOT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]components`
--
CREATE TABLE `[[dbprefix]]components` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`project_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]custom_fields`
--
CREATE TABLE `[[dbprefix]]custom_fields` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL DEFAULT 'text',
`values` longtext,
`multiple` tinyint(1) NOT NULL DEFAULT '0',
`default_value` varchar(255) DEFAULT NULL,
`regex` varchar(255) DEFAULT NULL,
`min_length` int(11) DEFAULT NULL,
`max_length` int(11) DEFAULT NULL,
`is_required` tinyint(1) NOT NULL DEFAULT '0',
`project_id` int(11) NOT NULL,
`ticket_type_ids` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]custom_field_values`
--
CREATE TABLE `[[dbprefix]]custom_field_values` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`custom_field_id` bigint(20) NOT NULL,
`ticket_id` bigint(20) NOT NULL,
`value` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]milestones`
--
CREATE TABLE `[[dbprefix]]milestones` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`codename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`info` longtext COLLATE utf8_unicode_ci NOT NULL,
`changelog` longtext COLLATE utf8_unicode_ci,
`due` datetime DEFAULT NULL,
`completed_on` datetime DEFAULT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`is_locked` smallint(6) NOT NULL DEFAULT '0',
`project_id` bigint(20) NOT NULL,
`displayorder` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]permissions`
--
CREATE TABLE `[[dbprefix]]permissions` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`project_id` bigint(20) NOT NULL DEFAULT '0',
`type` varchar(255) DEFAULT NULL,
`type_id` bigint(20) NOT NULL DEFAULT '0',
`action` varchar(255) NOT NULL DEFAULT '',
`value` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=108 ;
--
-- Dumping data for table `[[dbprefix]]permissions`
--
INSERT INTO `[[dbprefix]]permissions` VALUES
(1, 0, 'usergroup', 0, 'view', 1),
(2, 0, 'usergroup', 0, 'project_settings', 0),
(3, 0, 'usergroup', 0, 'delete_timeline_events', 0),
(4, 0, 'usergroup', 0, 'view_tickets', 1),
(5, 0, 'usergroup', 0, 'create_tickets', 1),
(6, 0, 'usergroup', 0, 'update_tickets', 1),
(7, 0, 'usergroup', 0, 'delete_tickets', 0),
(8, 0, 'usergroup', 0, 'move_tickets', 0),
(9, 0, 'usergroup', 0, 'comment_on_tickets', 1),
(10, 0, 'usergroup', 0, 'edit_ticket_description', 0),
(11, 0, 'usergroup', 0, 'vote_on_tickets', 1),
(12, 0, 'usergroup', 0, 'add_attachments', 1),
(13, 0, 'usergroup', 0, 'view_attachments', 1),
(14, 0, 'usergroup', 0, 'delete_attachments', 0),
(15, 0, 'usergroup', 0, 'perform_mass_actions', 0),
(16, 0, 'usergroup', 0, 'ticket_properties_set_assigned_to', 0),
(17, 0, 'usergroup', 0, 'ticket_properties_set_milestone', 0),
(18, 0, 'usergroup', 0, 'ticket_properties_set_version', 0),
(19, 0, 'usergroup', 0, 'ticket_properties_set_component', 0),
(20, 0, 'usergroup', 0, 'ticket_properties_set_severity', 0),
(21, 0, 'usergroup', 0, 'ticket_properties_set_priority', 0),
(22, 0, 'usergroup', 0, 'ticket_properties_set_status', 0),
(23, 0, 'usergroup', 0, 'ticket_properties_set_tasks', 0),
(24, 0, 'usergroup', 0, 'ticket_properties_set_related_tickets', 0),
(25, 0, 'usergroup', 0, 'ticket_properties_set_time_proposed', 0),
(26, 0, 'usergroup', 0, 'ticket_properties_set_time_worked', 0),
(27, 0, 'usergroup', 0, 'ticket_properties_change_type', 0),
(28, 0, 'usergroup', 0, 'ticket_properties_change_assigned_to', 0),
(29, 0, 'usergroup', 0, 'ticket_properties_change_milestone', 0),
(30, 0, 'usergroup', 0, 'ticket_properties_change_version', 0),
(31, 0, 'usergroup', 0, 'ticket_properties_change_component', 1),
(32, 0, 'usergroup', 0, 'ticket_properties_change_severity', 0),
(33, 0, 'usergroup', 0, 'ticket_properties_change_priority', 0),
(34, 0, 'usergroup', 0, 'ticket_properties_change_status', 0),
(35, 0, 'usergroup', 0, 'ticket_properties_change_summary', 0),
(36, 0, 'usergroup', 0, 'ticket_properties_change_tasks', 0),
(37, 0, 'usergroup', 0, 'ticket_properties_change_related_tickets', 0),
(38, 0, 'usergroup', 0, 'ticket_properties_change_time_proposed', 0),
(39, 0, 'usergroup', 0, 'ticket_properties_change_time_worked', 0),
(40, 0, 'usergroup', 0, 'ticket_properties_complete_tasks', 0),
(41, 0, 'usergroup', 0, 'edit_ticket_history', 0),
(42, 0, 'usergroup', 0, 'delete_ticket_history', 0),
(43, 0, 'usergroup', 0, 'create_wiki_page', 0),
(44, 0, 'usergroup', 0, 'edit_wiki_page', 0),
(45, 0, 'usergroup', 0, 'delete_wiki_page', 0),
(46, 0, 'usergroup', 3, 'create_tickets', 0),
(47, 0, 'usergroup', 3, 'comment_on_tickets', 0),
(48, 0, 'usergroup', 3, 'update_tickets', 0),
(49, 0, 'usergroup', 3, 'vote_on_tickets', 0),
(50, 0, 'usergroup', 3, 'add_attachments', 0),
(51, 0, 'role', 0, 'view', 1),
(52, 0, 'role', 0, 'project_settings', 0),
(53, 0, 'role', 0, 'delete_timeline_events', 0),
(54, 0, 'role', 0, 'view_tickets', 1),
(55, 0, 'role', 0, 'create_tickets', 1),
(56, 0, 'role', 0, 'update_tickets', 1),
(57, 0, 'role', 0, 'delete_tickets', 0),
(58, 0, 'role', 0, 'move_tickets', 0),
(59, 0, 'role', 0, 'comment_on_tickets', 1),
(60, 0, 'role', 0, 'edit_ticket_description', 0),
(61, 0, 'role', 0, 'vote_on_tickets', 1),
(62, 0, 'role', 0, 'add_attachments', 1),
(63, 0, 'role', 0, 'view_attachments', 1),
(64, 0, 'role', 0, 'delete_attachments', 0),
(65, 0, 'role', 0, 'perform_mass_actions', 0),
(66, 0, 'role', 0, 'ticket_properties_set_assigned_to', 1),
(67, 0, 'role', 0, 'ticket_properties_set_milestone', 1),
(68, 0, 'role', 0, 'ticket_properties_set_version', 1),
(69, 0, 'role', 0, 'ticket_properties_set_component', 1),
(70, 0, 'role', 0, 'ticket_properties_set_severity', 1),
(71, 0, 'role', 0, 'ticket_properties_set_priority', 1),
(72, 0, 'role', 0, 'ticket_properties_set_status', 1),
(73, 0, 'role', 0, 'ticket_properties_set_tasks', 1),
(74, 0, 'role', 0, 'ticket_properties_set_related_tickets', 1),
(75, 0, 'role', 0, 'ticket_properties_set_time_proposed', 1),
(76, 0, 'role', 0, 'ticket_properties_set_time_worked', 1),
(77, 0, 'role', 0, 'ticket_properties_change_type', 1),
(78, 0, 'role', 0, 'ticket_properties_change_assigned_to', 1),
(79, 0, 'role', 0, 'ticket_properties_change_milestone', 1),
(80, 0, 'role', 0, 'ticket_properties_change_version', 1),
(81, 0, 'role', 0, 'ticket_properties_change_component', 1),
(82, 0, 'role', 0, 'ticket_properties_change_severity', 1),
(83, 0, 'role', 0, 'ticket_properties_change_priority', 1),
(84, 0, 'role', 0, 'ticket_properties_change_status', 1),
(85, 0, 'role', 0, 'ticket_properties_change_summary', 1),
(86, 0, 'role', 0, 'ticket_properties_change_tasks', 1),
(87, 0, 'role', 0, 'ticket_properties_change_related_tickets', 1),
(88, 0, 'role', 0, 'ticket_properties_change_time_proposed', 1),
(89, 0, 'role', 0, 'ticket_properties_change_time_worked', 1),
(90, 0, 'role', 0, 'ticket_properties_complete_tasks', 1),
(91, 0, 'role', 0, 'edit_ticket_history', 0),
(92, 0, 'role', 0, 'delete_ticket_history', 0),
(93, 0, 'role', 0, 'create_wiki_page', 0),
(94, 0, 'role', 0, 'edit_wiki_page', 0),
(95, 0, 'role', 0, 'delete_wiki_page', 0),
(96, 0, 'role', 1, 'project_settings', 1),
(97, 0, 'role', 1, 'delete_timeline_events', 1),
(98, 0, 'role', 1, 'delete_tickets', 1),
(99, 0, 'role', 1, 'move_tickets', 1),
(100, 0, 'role', 1, 'edit_ticket_description', 1),
(101, 0, 'role', 1, 'delete_attachments', 1),
(102, 0, 'role', 1, 'edit_ticket_history', 1),
(103, 0, 'role', 1, 'delete_ticket_history', 1),
(104, 0, 'role', 1, 'perform_mass_actions', 1),
(105, 0, 'role', 1, 'create_wiki_page', 1),
(106, 0, 'role', 1, 'edit_wiki_page', 1),
(107, 0, 'role', 1, 'delete_wiki_page', 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]plugins`
--
CREATE TABLE `[[dbprefix]]plugins` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`file` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`enabled` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]plugins`
--
INSERT INTO `[[dbprefix]]plugins` VALUES
(1, 'markdown', 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]priorities`
--
CREATE TABLE `[[dbprefix]]priorities` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
--
-- Dumping data for table `[[dbprefix]]priorities`
--
INSERT INTO `[[dbprefix]]priorities` VALUES
(1, 'Highest'),
(2, 'High'),
(3, 'Normal'),
(4, 'Low'),
(5, 'Lowest');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]projects`
--
CREATE TABLE `[[dbprefix]]projects` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`codename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`info` longtext COLLATE utf8_unicode_ci NOT NULL,
`next_tid` bigint(20) NOT NULL DEFAULT '1',
`enable_wiki` tinyint(1) NOT NULL DEFAULT '0',
`default_ticket_type_id` int(11) DEFAULT NULL,
`default_ticket_sorting` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'priority.asc',
`displayorder` bigint(20) NOT NULL DEFAULT '0',
`private_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]project_roles`
--
CREATE TABLE `[[dbprefix]]project_roles` (
`id` int(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`assignable` varchar(255) NOT NULL DEFAULT '1',
`project_id` bigint(20) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `[[dbprefix]]project_roles`
--
INSERT INTO `[[dbprefix]]project_roles` VALUES
(1, 'Manager', '1', 0),
(2, 'Developer', '1', 0),
(3, 'Tester', '0', 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]repositories`
--
CREATE TABLE `[[dbprefix]]repositories` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`project_id` bigint(20) NOT NULL,
`slug` varchar(255) NOT NULL DEFAULT '',
`type` varchar(255) NOT NULL,
`location` varchar(255) DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`extra` text,
`is_default` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]repo_changes`
--
CREATE TABLE `[[dbprefix]]repo_changes` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`changeset_id` bigint(20) NOT NULL,
`action` varchar(1) NOT NULL DEFAULT '',
`path` text NOT NULL,
`from_path` text,
`revision` varchar(255) DEFAULT NULL,
`branch` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]repo_changesets`
--
CREATE TABLE `[[dbprefix]]repo_changesets` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`repository_id` bigint(20) NOT NULL,
`revision` varchar(255) NOT NULL DEFAULT '',
`commiter` varchar(255) DEFAULT '',
`committed_on` datetime NOT NULL,
`comment` text,
`user_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]repo_changeset_parents`
--
CREATE TABLE `[[dbprefix]]repo_changeset_parents` (
`changeset_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` bigint(20) NOT NULL,
PRIMARY KEY (`changeset_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]settings`
--
CREATE TABLE `[[dbprefix]]settings` (
`setting` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`value` longtext COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`setting`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]settings`
--
INSERT INTO `[[dbprefix]]settings` VALUES
('allow_registration', '1'),
('anonymous_user_id', '2'),
('check_for_update', '1'),
('date_format', 'd/m/Y'),
('date_time_format', 'g:iA d/m/Y'),
('db_version', '30703'),
('email_validation', '0'),
('locale', 'enus'),
('notification_from_email', 'noreply@[[domhost]]'),
('site_name', ''),
('site_url', ''),
('theme', 'default'),
('ticket_creation_delay', '30'),
('ticket_history_sorting', 'oldest_first'),
('tickets_per_page', '25'),
('timeline_day_format', 'l, jS F Y'),
('timeline_days_per_page', '7'),
('timeline_time_format', 'h:iA'),
('title', '[[site_name]]');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]severities`
--
CREATE TABLE `[[dbprefix]]severities` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;
--
-- Dumping data for table `[[dbprefix]]severities`
--
INSERT INTO `[[dbprefix]]severities` VALUES
(1, 'Blocker'),
(2, 'Critical'),
(3, 'Major'),
(4, 'Normal'),
(5, 'Minor'),
(6, 'Trivial');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]statuses`
--
CREATE TABLE `[[dbprefix]]statuses` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`status` smallint(6) NOT NULL,
`changelog` smallint(6) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
--
-- Dumping data for table `[[dbprefix]]statuses`
--
INSERT INTO `[[dbprefix]]statuses` VALUES
(1, 'New', 1, 0),
(2, 'Accepted', 1, 0),
(3, 'Closed', 0, 1),
(4, 'Completed', 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]subscriptions`
--
CREATE TABLE `[[dbprefix]]subscriptions` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`user_id` bigint(20) NOT NULL,
`project_id` bigint(20) NOT NULL,
`object_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]tickets`
--
CREATE TABLE `[[dbprefix]]tickets` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`ticket_id` bigint(20) NOT NULL,
`summary` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`body` longtext COLLATE utf8_unicode_ci NOT NULL,
`user_id` bigint(20) NOT NULL,
`project_id` bigint(20) NOT NULL,
`milestone_id` bigint(20) NOT NULL DEFAULT '0',
`version_id` bigint(20) NOT NULL,
`component_id` bigint(20) NOT NULL,
`type_id` bigint(20) NOT NULL,
`status_id` bigint(20) NOT NULL DEFAULT '1',
`priority_id` bigint(20) NOT NULL DEFAULT '3',
`severity_id` bigint(20) NOT NULL,
`assigned_to_id` bigint(20) NOT NULL,
`is_closed` bigint(20) NOT NULL DEFAULT '0',
`is_private` smallint(6) NOT NULL DEFAULT '0',
`votes` bigint(20) DEFAULT '0',
`tasks` longtext COLLATE utf8_unicode_ci,
`extra` longtext COLLATE utf8_unicode_ci NOT NULL,
`time_proposed` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`time_worked` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]ticket_history`
--
CREATE TABLE `[[dbprefix]]ticket_history` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL,
`ticket_id` bigint(20) NOT NULL,
`changes` longtext COLLATE utf8_unicode_ci NOT NULL,
`comment` longtext COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]ticket_relationships`
--
CREATE TABLE `[[dbprefix]]ticket_relationships` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`ticket_id` bigint(20) NOT NULL,
`related_ticket_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]timeline`
--
CREATE TABLE `[[dbprefix]]timeline` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`project_id` bigint(20) NOT NULL,
`owner_id` bigint(20) NOT NULL,
`action` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`data` longtext COLLATE utf8_unicode_ci,
`user_id` bigint(20) NOT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]types`
--
CREATE TABLE `[[dbprefix]]types` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`bullet` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`changelog` smallint(6) NOT NULL DEFAULT '1',
`template` longtext COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
--
-- Dumping data for table `[[dbprefix]]types`
--
INSERT INTO `[[dbprefix]]types` VALUES
(1, 'Defect', '-', 1, ''),
(2, 'Feature Request', '+', 1, ''),
(3, 'Enhancement', '*', 1, ''),
(4, 'Task', '*', 1, '');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]usergroups`
--
CREATE TABLE `[[dbprefix]]usergroups` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`is_admin` smallint(6) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
--
-- Dumping data for table `[[dbprefix]]usergroups`
--
INSERT INTO `[[dbprefix]]usergroups` VALUES
(1, 'Administrators', 1),
(2, 'Members', 0),
(3, 'Guests', 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]users`
--
CREATE TABLE `[[dbprefix]]users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`password_ver` varchar(25) COLLATE utf8_unicode_ci DEFAULT 'crypt',
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`group_id` bigint(20) NOT NULL DEFAULT '2',
`locale` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`options` text COLLATE utf8_unicode_ci,
`login_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`api_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
--
-- Dumping data for table `[[dbprefix]]users`
--
INSERT INTO `[[dbprefix]]users` VALUES
(1, '[[admin_username]]', '[[admin_pass]]', 'crypt', '[[admin_realname]]', '[[admin_email]]', 1, NULL, NULL, '[[login_hash]]', NULL, '[[regtime]]'),
(2, 'Anonymous', '$2a$10$fbc4f19411ab0d9e6b265uW9zaNA1fNNSTKESsR37/HTRmK.Mc0eO', 'crypt', 'Anonymous', 'anonymous0.76101700 [[timestamp]]@[[domhost]]', 3, 'enUS', '{"watch_created_tickets":null}', '1cd3ec71cfa1bf978929cafa60554107d4a17bd9', NULL, '[[regtime]]');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]user_roles`
--
CREATE TABLE `[[dbprefix]]user_roles` (
`id` int(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(20) DEFAULT NULL,
`project_id` int(20) DEFAULT NULL,
`project_role_id` int(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]wiki`
--
CREATE TABLE `[[dbprefix]]wiki` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`project_id` bigint(20) NOT NULL,
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`main` smallint(6) NOT NULL DEFAULT '0',
`revision_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]wiki_revisions`
--
CREATE TABLE `[[dbprefix]]wiki_revisions` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`wiki_page_id` bigint(20) NOT NULL,
`revision` bigint(20) NOT NULL DEFAULT '1',
`content` text NOT NULL,
`user_id` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/*!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 */;