IF OBJECT_ID('dbo.Messages', 'U') IS NOT NULL
DROP TABLE dbo.Messages
GO
CREATE TABLE dbo.Messages
(
   Id        INT    NOT NULL   PRIMARY KEY, -- primary key column
   Username      [NVARCHAR](50)  NOT NULL,
   MessageType   [NVARCHAR](50)  NOT NULL,
   Recepient     [NVARCHAR](50)  NOT NULL,
   RecepientType [NVARCHAR](50)  NOT NULL,
   Payload       [NVARCHAR](255),
   Stamp         datetime
);
GO