ALTER TABLE `valuelistentry2object` ADD COLUMN `RatingTypeOid` BIGINT(19) NULL DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `ratingtype` (
  `Oid` bigint(19) NOT NULL AUTO_INCREMENT,
  `Tid` int(10) DEFAULT NULL,
  `IsActive` tinyint(4) DEFAULT NULL,
  `Notice` varchar(1024) DEFAULT NULL,
  `InsTs` datetime DEFAULT NULL,
  `InsUser` varchar(256) DEFAULT NULL,
  `Version` bigint(19) DEFAULT NULL,
  `UdpUser` varchar(256) DEFAULT NULL,
  `SystemEntryID` int(10) DEFAULT NULL,
  `DisplayName` varchar(1024) DEFAULT NULL,
  `RatingId` int(10) DEFAULT NULL,
  `Position` int(10) DEFAULT NULL,
  PRIMARY KEY (`Oid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `rating` (
  `Oid` bigint(19) NOT NULL AUTO_INCREMENT,
  `Tid` int(10) DEFAULT NULL,
  `IsActive` tinyint(4) DEFAULT NULL,
  `Notice` varchar(1024) DEFAULT NULL,
  `InsTs` datetime DEFAULT NULL,
  `InsUser` varchar(256) DEFAULT NULL,
  `Version` bigint(19) DEFAULT NULL,
  `UdpUser` varchar(256) DEFAULT NULL,
  `SystemEntryID` int(10) DEFAULT NULL,
  `StartDate` datetime DEFAULT NULL,
  `DisplayName` varchar(1024) DEFAULT NULL,
  `RatingId` int(10) DEFAULT NULL,
  `RTFNotice` MEDIUMTEXT NULL DEFAULT NULL,
  `SupportConceptOid` bigint(19) DEFAULT NULL,
  PRIMARY KEY (`Oid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `goalrating` (
	`Oid` bigint(19) NOT NULL AUTO_INCREMENT,
  `Tid` int(10) DEFAULT NULL,
  `IsActive` tinyint(4) DEFAULT NULL,
  `Notice` varchar(1024) DEFAULT NULL,
  `InsTs` datetime DEFAULT NULL,
  `InsUser` varchar(256) DEFAULT NULL,
  `Version` bigint(19) DEFAULT NULL,
  `UdpUser` varchar(256) DEFAULT NULL,
  `SystemEntryID` int(10) DEFAULT NULL,
	`RatingOid` bigint(19) DEFAULT NULL,
	`ValueListEntryOid` bigint(19) DEFAULT NULL,
	`RatingTypeOid` bigint(19) DEFAULT NULL,
	PRIMARY KEY(`Oid`),
	KEY `GOALRATING_RATING_FK` (`RatingOid`),
	CONSTRAINT `FK_GOALRATING_RATING` FOREIGN KEY (`RatingOid`) REFERENCES `rating` (`Oid`) ON DELETE NO ACTION ON UPDATE NO ACTION
)ENGINE=InnoDB DEFAULT CHARSET=latin1;