CREATE TABLE [Users] (
    [UserId] [uniqueidentifier] NOT NULL,
    [Username] [nvarchar](max) NOT NULL,
    [Email] [nvarchar](max) NOT NULL,
    [Password] [nvarchar](max) NOT NULL,
    [FirstName] [nvarchar](max),
    [LastName] [nvarchar](max),
    [Comment] [nvarchar](max),
    [IsApproved] [bit] NOT NULL,
    [PasswordFailuresSinceLastSuccess] [int] NOT NULL,
    [LastPasswordFailureDate] [datetime],
    [LastActivityDate] [datetime],
    [LastLockoutDate] [datetime],
    [LastLoginDate] [datetime],
    [ConfirmationToken] [nvarchar](max),
    [CreateDate] [datetime],
    [IsLockedOut] [bit] NOT NULL,
    [LastPasswordChangedDate] [datetime],
    [PasswordVerificationToken] [nvarchar](max),
    [PasswordVerificationTokenExpirationDate] [datetime],
    CONSTRAINT [PK_Users] PRIMARY KEY ([UserId])
)
CREATE TABLE [Roles] (
    [RoleId] [uniqueidentifier] NOT NULL,
    [RoleName] [nvarchar](max) NOT NULL,
    [Description] [nvarchar](max),
    CONSTRAINT [PK_Roles] PRIMARY KEY ([RoleId])
)
CREATE TABLE [Tweets] (
    [Id] [bigint] NOT NULL IDENTITY,
    [Message] [nvarchar](max) NOT NULL,
    [SenderId] [uniqueidentifier] NOT NULL,
    [IsFavourite] [bit] NOT NULL,
    [Sender_UserId] [uniqueidentifier],
    CONSTRAINT [PK_Tweets] PRIMARY KEY ([Id])
)
CREATE INDEX [IX_Sender_UserId] ON [Tweets]([Sender_UserId])
CREATE TABLE [RoleUsers] (
    [Role_RoleId] [uniqueidentifier] NOT NULL,
    [User_UserId] [uniqueidentifier] NOT NULL,
    CONSTRAINT [PK_RoleUsers] PRIMARY KEY ([Role_RoleId], [User_UserId])
)
CREATE INDEX [IX_Role_RoleId] ON [RoleUsers]([Role_RoleId])
CREATE INDEX [IX_User_UserId] ON [RoleUsers]([User_UserId])
CREATE TABLE [UserUsers] (
    [User_UserId] [uniqueidentifier] NOT NULL,
    [User_UserId1] [uniqueidentifier] NOT NULL,
    CONSTRAINT [PK_UserUsers] PRIMARY KEY ([User_UserId], [User_UserId1])
)
CREATE INDEX [IX_User_UserId] ON [UserUsers]([User_UserId])
CREATE INDEX [IX_User_UserId1] ON [UserUsers]([User_UserId1])
ALTER TABLE [Tweets] ADD CONSTRAINT [FK_Tweets_Users_Sender_UserId] FOREIGN KEY ([Sender_UserId]) REFERENCES [Users] ([UserId])
ALTER TABLE [RoleUsers] ADD CONSTRAINT [FK_RoleUsers_Roles_Role_RoleId] FOREIGN KEY ([Role_RoleId]) REFERENCES [Roles] ([RoleId]) ON DELETE CASCADE
ALTER TABLE [RoleUsers] ADD CONSTRAINT [FK_RoleUsers_Users_User_UserId] FOREIGN KEY ([User_UserId]) REFERENCES [Users] ([UserId]) ON DELETE CASCADE
ALTER TABLE [UserUsers] ADD CONSTRAINT [FK_UserUsers_Users_User_UserId] FOREIGN KEY ([User_UserId]) REFERENCES [Users] ([UserId])
ALTER TABLE [UserUsers] ADD CONSTRAINT [FK_UserUsers_Users_User_UserId1] FOREIGN KEY ([User_UserId1]) REFERENCES [Users] ([UserId])
CREATE TABLE [Lists] (
    [ID] [bigint] NOT NULL IDENTITY,
    [UserId] [uniqueidentifier] NOT NULL,
    [ListName] [nvarchar](max),
    CONSTRAINT [PK_Lists] PRIMARY KEY ([ID])
)
CREATE INDEX [IX_UserId] ON [Lists]([UserId])
ALTER TABLE [Lists] ADD CONSTRAINT [FK_Lists_Users_UserId] FOREIGN KEY ([UserId]) REFERENCES [Users] ([UserId]) ON DELETE CASCADE