 INSERT INTO `role` (`id`, `role_name`, `description`) VALUES (7, 'tester', 'tester.desc');
 INSERT INTO `role` (`id`, `role_name`, `description`) VALUES (8, 'admin', 'admin.desc');
 INSERT INTO `role` (`id`, `role_name`, `description`) VALUES (9, 'leader', 'leader.desc');
+/*Add user rights*/
 INSERT INTO `user_right` (`id`, `description`) VALUES (1, 'testplan.execute');
 INSERT INTO `user_right` (`id`, `description`) VALUES (2, 'testplan.create.build');
 INSERT INTO `user_right` (`id`, `description`) VALUES (3, 'testplan.metrics');

INSERT INTO `vm_setting` (`id`, `setting`, `bool_val`, `int_val`, `long_val`, `string_val`) VALUES (2, 'version.mid', 0, 0, '0', NULL);
INSERT INTO `vm_setting` (`id`, `setting`, `bool_val`, `int_val`, `long_val`, `string_val`) VALUES (3, 'version.low', 0, 1, '0', NULL);
INSERT INTO `vm_setting` (`id`, `setting`, `bool_val`, `int_val`, `long_val`, `string_val`) VALUES (7, 'version.postfix', 0, 0, '0', 'Alpha');

INSERT INTO `role_has_right` (`role_id`, `right_id`) VALUES (9, 8);
INSERT INTO `role_has_right` (`role_id`, `right_id`) VALUES (9, 9);
INSERT INTO `role_has_right` (`role_id`, `right_id`) VALUES (9, 12);
/*Add assignment types*/
INSERT INTO `assigment_type` (`id`, `fk_table`, `description`) VALUES (1, 'test_plan_has_test', 'testcase.execution');
INSERT INTO `assigment_type` (`id`, `fk_table`, `description`) VALUES (2, 'test_case', 'testcase.review');
/*Add assignment statuses*/
INSERT INTO `assignment_status` (`id`, `name`, `description`) VALUES (1, 'assignment.status.open', 'assignment.status.open.desc');
INSERT INTO `assignment_status` (`id`, `name`, `description`) VALUES (2, 'assignment.status.closed', 'assignment.status.closed.desc');
INSERT INTO `assignment_status` (`id`, `name`, `description`) VALUES (3, 'assignment.status.completed', 'assignment.status.completed.desc');
INSERT INTO `assignment_status` (`id`, `name`, `description`) VALUES (4, 'assignment.status..todo.urgent', 'assignment.status.todo.urgent.desc');
INSERT INTO `assignment_status` (`id`, `name`, `description`) VALUES (5, 'assignment.status.todo', 'assignment.status.todo.desc');
/*Add requirement types*/
INSERT INTO `requirement_type` (`id`, `name`, `description`) VALUES (1, 'HW', 'Hardware');
INSERT INTO `requirement_type` (`id`, `name`, `description`) VALUES (2, 'SW', 'Software');
INSERT INTO `requirement_type` (`id`, `name`, `description`) VALUES (3, 'Labeling', 'Labeling requirements');
INSERT INTO `requirement_type` (`id`, `name`, `description`) VALUES (4, 'Standards', 'Testing related to applicable standards');
/*Add requirement statuses*/
INSERT INTO `requirement_status` (`id`, `status`) VALUES (1, 'general.open');
INSERT INTO `requirement_status` (`id`, `status`) VALUES (2, 'general.approved');
INSERT INTO `requirement_status` (`id`, `status`) VALUES (3, 'general.obsolete');
INSERT INTO `requirement_status` (`id`, `status`) VALUES (4, 'general.rejected');
/*Add Spec levels*/
INSERT INTO `spec_level` (`id`, `name`, `description`) VALUES (1, 'User Need', 'Higher level of requirements.');
INSERT INTO `spec_level` (`id`, `name`, `description`) VALUES (2, 'Requirements', 'Detailed version of the User Needs. Usually the lowest level of requirement for non-software projects.');
INSERT INTO `spec_level` (`id`, `name`, `description`) VALUES (3, 'System Design', 'Systems design is the phase where system engineers analyze and understand the business of the proposed system by studying the user requirements document.');
INSERT INTO `spec_level` (`id`, `name`, `description`) VALUES (4, 'Architecture Design', 'List of modules, brief functionality of each module, their interface relationships, dependencies, database tables, architecture diagrams, technology details etc.');
INSERT INTO `spec_level` (`id`, `name`, `description`) VALUES (5, 'Module Design', 'The designed system is broken up into smaller units or modules and each of them is explained so that the programmer can start coding directly.');
/*Add settings*/
INSERT INTO `vm_setting` (`id`, `setting`, `bool_val`, `int_val`, `long_val`, `string_val`) VALUES (4, 'password.aging', 0, 90, '0', NULL);
INSERT INTO `vm_setting` (`id`, `setting`, `bool_val`, `int_val`, `long_val`, `string_val`) VALUES (5, 'password.attempts', 0, 3, '0', NULL);
INSERT INTO `vm_setting` (`id`, `setting`, `bool_val`, `int_val`, `long_val`, `string_val`) VALUES (6, 'password.unusable_period', 0, 365, '0', NULL);
