123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687 |
- INSERT INTO `permissions` (`name`) VALUES
- ('*'),
- ('project.read'),
- ('project.update'),
- ('project.create'),
- ('project.delete'),
- ('issue.read'),
- ('issue.update'),
- ('issue.create'),
- ('issue.delete'),
- ('user.read'),
- ('user.update'),
- ('user.create'),
- ('user.delete'),
- ('message.read'),
- ('message.update'),
- ('message.create'),
- ('message.delete'),
- ('priority.read'),
- ('priority.update'),
- ('priority.create'),
- ('priority.delete'),
- ('session.read'),
- ('session.update'),
- ('session.create'),
- ('session.delete'),
- ('issue.role.read'),
- ('issue.role.update'),
- ('issue.role.create'),
- ('issue.role.delete'),
- ('project.role.read'),
- ('project.role.update'),
- ('project.role.create'),
- ('project.role.delete'),
- ('email.read'),
- ('email.update'),
- ('email.create'),
- ('email.delete');
- INSERT INTO `issue_roles` (`name`) VALUES
- ('Developer'),
- ('Tester'),
- ('Contact');
- INSERT INTO `r_issue_role_permission` (`r_id`,`per_id`) VALUES
- (issue_role('Developer'),permission('issue.read')),
- (issue_role('Developer'),permission('issue.update')),
- (issue_role('Tester'),permission('issue.read')),
- (issue_role('Tester'),permission('issue.update')),
- (issue_role('Contact'),permission('issue.read'));
- INSERT INTO `project_roles` (`name`) VALUES
- ('Project Manager'),
- ('Developer'),
- ('Tester');
- INSERT INTO `r_project_role_permission` (`r_id`,`per_id`) VALUES
- (project_role('Project Manager'),permission('issue.read')),
- (project_role('Project Manager'),permission('issue.create')),
- (project_role('Project Manager'),permission('issue.delete')),
- (project_role('Project Manager'),permission('project.read')),
- (project_role('Project Manager'),permission('project.update')),
- (project_role('Project Manager'),permission('project.delete')),
- (project_role('Developer'),permission('issue.create')),
- (project_role('Developer'),permission('project.read')),
- (project_role('Tester'),permission('project.read'));
- INSERT INTO `priorities` (`name`) VALUES
- ('Critical'),
- ('High'),
- ('Medium'),
- ('Low');
- INSERT INTO `settings` (`name`, `value`) VALUES
- ('issue.default.priority', '4'),
- ('issue.default.status', '1'),
- ('project.default.status', '1'),
- ('admin.email', 'bugs@localhost'),
- ('url.host', 'localhost'),
- ('url.base', '/bugs/');
- INSERT INTO `statuses` (`id`, `name`, `open`) VALUES
- (1, 'New', 1),
- (2, 'In Progress', 1),
- (3, 'On Hold', 1),
- (4, 'Completed', 0),
- (5, 'Cancelled', 0);
|