demo-content.sql 986 B

123456789101112131415161718
  1. /* Demo content should be imported immediately after the database.sql file */
  2. SET NAMES utf8;
  3. INSERT INTO `user` (`username`, `email`, `name`, `password`, `salt`, `role`,`created_date`) VALUES
  4. ('demo', 'demo@demo', 'Demo User', NULL, NULL, 'user', NOW()),
  5. (NULL, NULL, 'Demo Group', NULL, NULL, 'group', NOW());
  6. INSERT INTO `user_group`(`user_id`,`group_id`,`manager`) VALUES (1,3,0), (2,3,0);
  7. INSERT INTO `sprint` (`id`, `name`, `start_date`, `end_date`) VALUES
  8. (1, 'First Sprint', DATE_SUB(CURDATE(), INTERVAL 1 DAY), DATE_ADD(DATE_SUB(CURDATE(), INTERVAL 2 DAY), INTERVAL 2 WEEK));
  9. INSERT INTO `issue` (`status`, `type_id`, `name`, `description`, `parent_id`, `author_id`, `owner_id`, `hours_total`, `hours_remaining`, `created_date`, `sprint_id`) VALUES
  10. (1, 2, 'A Big Project', 'This is a project. Projects group tasks and bugs, and can go into sprints.', NULL, 2, 2, NULL, NULL, NOW(), 1),
  11. (1, 1, 'A Simple Task', 'This is a sample task.', 1, 1, 2, 2, 2, NOW(), NULL);