create table MIntranet.dbo.Messaging (ID bigint IDENTITY (1, 1) NOT NULL,  
                              MessageType integer, 
                              byUserID  varchar(50), 
                              ToUserID  varchar(50), 
                              ToDepartment varchar(50), 
                              MsgBody  text, 
                              MsgDate datetime, 
                              FileData Image, 
                              FileType varchar(15)  
                              )
        GO

      CREATE INDEX [by_Primary] ON MIntranet.dbo.Messaging ([ID])  
        GO

      CREATE INDEX [by_From] ON MIntranet.dbo.Messaging (MessageType,byUserID) 
        GO

      CREATE INDEX [by_To] ON MIntranet.dbo.Messaging (MessageType,ToUserID)  
        GO

      CREATE INDEX [by_Dept] ON MIntranet.dbo.Messaging (MessageType,ToDepartment) 
        GO




USE [MIntranet] 
GO

CREATE TABLE [dbo].[MessagesRead](
	[UserID] [varchar](50) NOT NULL,
	[LastWOMSID] [bigint] NULL,
	[LastChatID] [bigint] NULL,
	[LastNewsID] [bigint] NULL
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [byUserID] ON [dbo].[MessagesRead] 
(
	[UserID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO