sql

CREATE TABLE `accountActivity` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `activityTypeId` int(11) NOT NULL,
  `description` varchar(255) NOT NULL,
  `username` varchar(100) NOT NULL,
  `eventTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  KEY `fk_accountActivity_user1` (`username`),
  KEY `fk_accountActivity_activityType1` (`activityTypeId`),
  CONSTRAINT `fk_accountActivity_activityType1` FOREIGN KEY (`activityTypeId`) REFERENCES `activityType` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_accountActivity_user1` FOREIGN KEY (`username`) REFERENCES `user` (`userName`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1