Tables structrs

CREATE TABLE `useraccount` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(255) DEFAULT NULL,
  `Password` varchar(255) DEFAULT NULL,
  `LastLoginDate` date DEFAULT NULL,
  `Status` varchar(25) DEFAULT 'Active',
  `Name` varchar(100) DEFAULT NULL,
  `CreatedBy` int(11) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;


INSERT INTO `useraccount` (`Id`,`UserName`,`Password`,`LastLoginDate`,`Status`,`Name`,`CreatedBy`,`CreatedDate`) VALUES
 (2,'admin2','+1nc99v5/wQ=','2015-07-17','Active','JIBIN MATHEW',1,now());

 CREATE TABLE `activitylog` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `UserId` int(11) DEFAULT NULL,
  `Priority` int(11) DEFAULT NULL,
  `Activity` varchar(255) DEFAULT NULL,
  `Description` varchar(555) DEFAULT NULL,
  `ActionId` int(11) DEFAULT NULL,
  `LogTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Id`),
  KEY `LogUsermapping` (`UserId`),
  CONSTRAINT `LogUsermapping` FOREIGN KEY (`UserId`) REFERENCES `useraccount` (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;