-
Notifications
You must be signed in to change notification settings - Fork 82
/
UserUserRole.sql
29 lines (26 loc) · 1.09 KB
/
UserUserRole.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
--------------------------------------------------------------------------------
-- Membership Database Schema
-- https://github.com/membership/membership.db
--
-- Copyright © 2016 Membership Database contributors.
--
-- This source code is licensed under the MIT license found in the
-- LICENSE.txt file in the root directory of this source tree.
--------------------------------------------------------------------------------
CREATE TABLE [dbo].[UserUserRole]
(
[UserId] UNIQUEIDENTIFIER NOT NULL,
[RoleId] UNIQUEIDENTIFIER NOT NULL,
-- Keys
CONSTRAINT [PK_UserUserRole_UserId_RoleId] PRIMARY KEY CLUSTERED ([UserId] ASC, [RoleId] ASC),
CONSTRAINT [FK_UserUserRole_User] FOREIGN KEY ([UserID])
REFERENCES [dbo].[User] ([Id]) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT [FK_UserUserRole_UserRole] FOREIGN KEY ([RoleId])
REFERENCES [dbo].[UserRole] ([Id]) ON DELETE CASCADE ON UPDATE CASCADE
);
GO
CREATE NONCLUSTERED INDEX [IX_UserUserRole_UserId]
ON [dbo].[UserUserRole] ([UserId] ASC);
GO
CREATE NONCLUSTERED INDEX [IX_UserUserRole_RoleId]
ON [dbo].[UserUserRole] ([RoleId] ASC);