Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE [dbo].[Users] (
- [Id] INT IDENTITY (1, 1) NOT NULL,
- [Email] NVARCHAR (MAX) NULL,
- [Password] NVARCHAR (MAX) NULL,
- [RoleId] INT NOT NULL,
- CONSTRAINT [PK_dbo.Users] PRIMARY KEY CLUSTERED ([Id] ASC),
- CONSTRAINT [FK_dbo.Users_dbo.Roles_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[Roles] ([Id]) ON DELETE CASCADE
- );
- GO
- CREATE NONCLUSTERED INDEX [IX_RoleId]
- ON [dbo].[Users]([RoleId] ASC);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement