Conversations

sp_rename 'conv.ConversationMessages', 'Messages';
GO

sp_RENAME 'conv.Messages.ThreadId' , 'ConversationId', 'COLUMN'
GO

sp_rename 'conv.ConversationThreadRecipients', 'ConversationParticipants';
GO

sp_rename 'conv.ConversationParticipants.ThreadId', 'ConversationId', 'COLUMN';
GO

sp_rename 'conv.ConversationThreads', 'Conversations';
GO

sp_rename 'conv.Conversations.RecipientOrganizationId', 'OrganizationId', 'COLUMN';
GO

sp_rename 'conv.Conversations.RecipientsHash', 'ParticipantsHash', 'COLUMN';
GO

DELETE FROM conv.Messages WHERE CreatedByUserId IS NULL