 INSERT INTO `usergroup` (`id`, `groupcode`, `usergroup`, `badge`, `icon`) VALUES
   (1, 'ADM', 'Admin', 'ADMINISTRATOR', 'icon-admin'),
   (2, 'MAN', 'Manager', 'MANAGER', 'icon-manager'),
-  (3, 'PRO', 'Programmer', 'PROGRAMMER', 'icon-developer');+  (3, 'PRO', 'Programmer', 'PROGRAMMER', 'icon-developer');

  PRIMARY KEY (`id`),
  KEY `FK_TASKER_TASK_ID` (`task_id`),
  KEY `FK_TASKER_USER_ID` (`user_id`),
  CONSTRAINT `FK_TASKER_TASK_ID` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`),
  CONSTRAINT `FK_TASKER_USER_ID` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `activity` (

  KEY `FK_COMMENT_USER_ID` (`user_id`),
  KEY `FK_COMMENT_STATUS_ID` (`status_id`),
  CONSTRAINT `FK_COMMENT_STATUS_ID` FOREIGN KEY (`status_id`) REFERENCES `status` (`id`),
  CONSTRAINT `FK_COMMENT_TASK_ID` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `FK_COMMENT_USER_ID` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


