 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
--- Dumping data for table `useractivityrelation`
---
-
-LOCK TABLES `useractivityrelation` WRITE;
-/*!40000 ALTER TABLE `useractivityrelation` DISABLE KEYS */;
-INSERT INTO `useractivityrelation` VALUES (0,'host'),(1,'applied'),(2,'selected'),(3,'present'),(4,'absent');
-/*!40000 ALTER TABLE `useractivityrelation` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `usergroup`
---
-
-DROP TABLE IF EXISTS `usergroup`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `usergroup` (
+-- Dumping data for table `UserActivityRelation`
+--
+
+LOCK TABLES `UserActivityRelation` WRITE;
+/*!40000 ALTER TABLE `UserActivityRelation` DISABLE KEYS */;
+INSERT INTO `UserActivityRelation` VALUES (0,'host'),(1,'applied'),(2,'selected'),(3,'present'),(4,'absent');
+/*!40000 ALTER TABLE `UserActivityRelation` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `UserGroup`
+--
+
+DROP TABLE IF EXISTS `UserGroup`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `UserGroup` (
   `GroupId` int(32) NOT NULL,
   `GroupName` varchar(32) NOT NULL,
   PRIMARY KEY (`GroupId`)

UNLOCK TABLES;

--
-- Table structure for table `image`
--

DROP TABLE IF EXISTS `image`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `image` (
  `ImageId` int(32) NOT NULL AUTO_INCREMENT,
  `ImageAbsolutePath` varchar(128) NOT NULL,
  `ImageURL` varchar(64) NOT NULL,

  PRIMARY KEY (`ActivityImageRelationTableId`),
  KEY `FK_ActivityId` (`ActivityId`),
  KEY `FK_ImageId` (`ImageId`),
  CONSTRAINT `FK_ActivityId` FOREIGN KEY (`ActivityId`) REFERENCES `Activity` (`ActivityId`),
  CONSTRAINT `FK_ImageId` FOREIGN KEY (`ImageId`) REFERENCES `Image` (`ImageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

