notofication-producer-upload

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

#TIPO DE NOTIFICACAO NOVO
INSERT INTO notification.NotificationType
(Id, Description, `Type`)
VALUES(19, 'Usuário verificado criou um material', 'VerifiedUserUploadMaterial');
#TABELA NOVA
CREATE TABLE `notification`.`VerifiedUserUploadMaterialNotification` (
 `NotificationId` int(11) NOT NULL,
 `SubjectId` int(11) NOT NULL,
 `MaterialId` int(11) NOT NULL,
 `Count` int(11) NOT NULL DEFAULT '1',
 `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`NotificationId`),
 KEY `ProducerUploadMaterialNotification_Subject_FK` (`SubjectId`),
 KEY `ProducerUploadMaterialNotification_Material_FK` (`MaterialId`),
 KEY `IX_ProducerUploadMaterialNotification_CreatedDate` (`CreatedDate`),
 CONSTRAINT `ProducerUploadMaterialNotification_Material_FK` FOREIGN KEY (`MaterialId`) REFERENCES `dbo`.`Material` (`Id`),
 CONSTRAINT `ProducerUploadMaterialNotification_Notitication_FK` FOREIGN KEY (`NotificationId`) REFERENCES `Notification` (`Id`),
 CONSTRAINT `ProducerUploadMaterialNotification_Subject_FK` FOREIGN KEY (`SubjectId`) REFERENCES `dbo`.`Subject` (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;