LsPbMT3f

1-- Contact FK
2IF COL_LENGTH('Contact', 'UserLoginId') IS NOT NULL
3AND EXISTS (SELECT * 
4  FROM sys.foreign_keys 
5  WHERE object_id = OBJECT_ID(N'dbo.FK_Contact_UserLogin')
6  AND parent_object_id = OBJECT_ID(N'dbo.Contact')
7)
8BEGIN
9    ALTER TABLE Contact DROP CONSTRAINT FK_Contact_UserLogin   
10END
11
12-- ConversationParticipant FK
13IF COL_LENGTH('ConversationParticipant', 'ParticipantId') IS NOT NULL
14AND EXISTS (SELECT * 
15  FROM sys.foreign_keys 
16  WHERE object_id = OBJECT_ID(N'dbo.FK562933DFB39EB7C')
17  AND parent_object_id = OBJECT_ID(N'dbo.ConversationParticipant')
18)
19BEGIN
20    ALTER TABLE ConversationParticipant DROP CONSTRAINT FK562933DFB39EB7C   
21END
22
23-- Indexes
24CREATE NONCLUSTERED INDEX [IDX_ContentRestriction_Users_UserId] ON ContentRestriction_Users (UserId ASC)
25CREATE NONCLUSTERED INDEX [IDX_Conversation_OwnerUserLoginId] ON Conversation (OwnerUserLoginId ASC)
26CREATE NONCLUSTERED INDEX [IDX_ConversationMessage_SenderUserLoginId] ON ConversationMessage (SenderUserLoginId ASC)
27CREATE NONCLUSTERED INDEX [IDX_DashboardUserNotification_UserLoginId] ON DashboardUserNotification (UserLoginId ASC)
28CREATE NONCLUSTERED INDEX [IDX_NewsItem_UserId] ON NewsItem (UserId ASC)