
START TRANSACTION;

INSERT INTO `application` VALUES (1, 'Test Application', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');

INSERT INTO `project` VALUES (1, 'testproject', 'Some description', 'logourl', 'false', 'false');
INSERT INTO `project` VALUES (2, 'workitemproject', 'A project to test workitems', 'logourl', 'false', 'false');
INSERT INTO `project` VALUES (3, 'anotherworkitemproject', 'Another project to test workitems', 'logourl', 'false', 'false');

INSERT INTO `release` VALUES (1, 2, 1186402227, 'some release', 'test release', '32');
INSERT INTO `release_file` VALUES (1, 1, 'test.exe', 'win32');

INSERT INTO `user` VALUES (2, 'test_none', 'test', 'test_none@origo.inf.ethz.ch', '', 'false');
INSERT INTO `user` VALUES (3, 'test_admin', 'test', 'test_admin@origo.inf.ethz.ch', '', 'false');
INSERT INTO `user` VALUES (4, 'test_project_owner', 'test', 'test_project_owner@origo.inf.ethz.ch', '', 'false');
INSERT INTO `user` VALUES (5, 'test_workitem', 'test', 'test_workitem@origo.inf.ethz.ch', '', 'false');
INSERT INTO `user` VALUES (6, 'test_disabled', 'test', 'test_disabled@origo.inf.ethz.ch', '', 'true');
INSERT INTO `user` VALUES (7, 'test_project_member', 'test', 'test_project_member@origo.inf.ethz.ch', '', 'false');
INSERT INTO `user` VALUES (8, 'test_project_bookmarker', 'test', 'test_project_bookmarker@origo.inf.ethz.ch', '', 'false');
INSERT INTO `user` VALUES (9, 'test_issue_reporter', 'test', 'test_issue_reporter@origo.inf.ethz.ch', '', 'false');

INSERT INTO `user_association` VALUES (2, 2);
INSERT INTO `user_association` VALUES (3, 1);
INSERT INTO `user_association` VALUES (4, 2);
INSERT INTO `user_association` VALUES (5, 2);
INSERT INTO `user_association` VALUES (6, 5);
INSERT INTO `user_association` VALUES (7, 2);

INSERT INTO `user_project_association` VALUES (1, 3, 4);
INSERT INTO `user_project_association` VALUES (2, 3, 5);
INSERT INTO `user_project_association` VALUES (1, 4, 7);
INSERT INTO `user_project_association` VALUES (3, 3, 5);

INSERT INTO `project_bookmark` VALUES (1, 8);

INSERT INTO `issue` VALUES (1, 1, 1, "Title Issue One for Project 1", 0);
INSERT INTO `issue` VALUES (2, 1, 2, "Title Issue Two for Project 1", 0);
INSERT INTO `issue` VALUES (3, 2, 1, "Title Issue One for Project 2", 0);
INSERT INTO `issue` VALUES (4, 1, 3, "Title Issue Three for Project 1", 0);

INSERT INTO `tag_text` VALUES (1, "status::open");
INSERT INTO `tag_text` VALUES (2, "status::closed");

INSERT INTO `issue_revision` VALUES (1, 1, 1086255528, 4, "issue 1");
INSERT INTO `issue_revision` VALUES (2, 2, 1086255530, 4, "issue 2");	
INSERT INTO `issue_revision` VALUES (3, 2, 1086255631, 3, "issue 2 reply");
INSERT INTO `issue_revision` VALUES (4, 3, 1034591834, 4, "issue 1");
INSERT INTO `issue_revision` VALUES (5, 4, 1034591835, 9, "issue 3");

INSERT INTO `issue_tag_association` VALUES (1, 2);
INSERT INTO `issue_tag_association` VALUES (4, 1);
INSERT INTO `issue_tag_association` VALUES (3, 1);
INSERT INTO `issue_tag_association` VALUES (5, 1);

INSERT INTO `user_workitem_subscription` VALUES (2, 1, 3, 1, 1);
INSERT INTO `user_workitem_subscription` VALUES (5, 2, 1, 1, 1);
INSERT INTO `user_workitem_subscription` VALUES (5, 2, 2, 1, 1);
INSERT INTO `user_workitem_subscription` VALUES (5, 2, 3, 1, 1);
INSERT INTO `user_workitem_subscription` VALUES (5, 2, 4, 1, 1);
INSERT INTO `user_workitem_subscription` VALUES (5, 2, 5, 1, 1);
INSERT INTO `user_workitem_subscription` VALUES (5, 2, 6, 1, 1);
INSERT INTO `user_workitem_subscription` VALUES (5, 3, 4, 1, 1);
 
INSERT INTO `user_information` ( `user_id` , `first_name` , `last_name` , `gender` , `icon` , `languages` , `registration_date` , `last_login`, `birthday` , `timezone` , `signature` , `message` , `homepage` , `blog` , `ohloh_profile` , `icq` , `aim` , `jabber` , `yahoo` , `msn` , `skype` , `sip` ) VALUES ( '2', 'test', 'user', 'male', '', 'english', '123456', '0', '1982-02-11', 'CET+1', 'orico - code with the flow', 'my message is: well I just dont know', 'origo.ethz.ch', 'origo.ethz.ch/blog', 'my_profile', '123', 'my_aim', 'my_jabber', 'my_yahoo', 'my_msn', 'my_skype', 'my_sip');
INSERT INTO `user_information` (`user_id`, `first_name`, `last_name`) VALUES ('3' , 'admin', 'admin');
INSERT INTO `user_information` (`user_id`, `first_name`, `last_name`) VALUES ('4' , 'project', 'owner');
INSERT INTO `user_information` (`user_id`, `first_name`, `last_name`) VALUES ('5' , 'work', 'item');
INSERT INTO `user_information` (`user_id`, `first_name`, `last_name`) VALUES ('6' , 'disabled', 'disabled');
INSERT INTO `user_information` (`user_id`, `first_name`, `last_name`) VALUES ('7' , 'project', 'member');
INSERT INTO `user_information` (`user_id`, `first_name`, `last_name`) VALUES ('8' , 'project', 'bookmarker');
INSERT INTO `user_information` (`user_id`, `first_name`, `last_name`) VALUES ('9' , 'issue', 'reporter');

INSERT INTO `workitem` VALUES (2, 2, 1186255528, 2, 5);
INSERT INTO `workitem` VALUES (3, 3, 1186255560, 2, 5);
INSERT INTO `workitem` VALUES (4, 4, 1186255560, 2, 5);
INSERT INTO `workitem` VALUES (5, 5, 1186255580, 2, 5);
INSERT INTO `workitem` VALUES (6, 4, 1186255525, 3, 5);

INSERT INTO `workitem_blog` VALUES (5, 'some Blog title', 'blog diff', 22, 21);

INSERT INTO `workitem_commit` VALUES (3, 33, 'some commit log', 'some diff');

INSERT INTO `workitem_release` VALUES (2, 1);

INSERT INTO `workitem_wiki` VALUES (4, 'Some wikiworkitem', 'some diff', 12, 11, 0);
INSERT INTO `workitem_wiki` VALUES (6, 'Another wikiworkitem', 'some diff', 12, 11, 0);

INSERT INTO `community` (`community_id`, `name`, `description`, `logo`) VALUES (1, 'test-community', 'This is a description for the test community.', 'no');


COMMIT;

