· 6 years ago · Aug 12, 2019, 04:48 AM
1USE [HobbyDB]
2GO
3/****** Object: Table [dbo].[AspNetRoleClaims] Script Date: 6/4/2018 10:18:03 PM ******/
4SET ANSI_NULLS ON
5GO
6SET QUOTED_IDENTIFIER ON
7GO
8IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AspNetRoleClaims]') AND type in (N'U'))
9BEGIN
10CREATE TABLE [dbo].[AspNetRoleClaims](
11 [Id] [int] IDENTITY(1,1) NOT NULL,
12 [ClaimType] [nvarchar](max) NULL,
13 [ClaimValue] [nvarchar](max) NULL,
14 [RoleId] [nvarchar](450) NOT NULL,
15 CONSTRAINT [PK_AspNetRoleClaims] PRIMARY KEY CLUSTERED
16(
17 [Id] ASC
18)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
19) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
20END
21GO
22/****** Object: Table [dbo].[AspNetRoles] Script Date: 6/4/2018 10:18:03 PM ******/
23SET ANSI_NULLS ON
24GO
25SET QUOTED_IDENTIFIER ON
26GO
27IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AspNetRoles]') AND type in (N'U'))
28BEGIN
29CREATE TABLE [dbo].[AspNetRoles](
30 [Id] [nvarchar](450) NOT NULL,
31 [ConcurrencyStamp] [nvarchar](max) NULL,
32 [Name] [nvarchar](256) NULL,
33 [NormalizedName] [nvarchar](256) NULL,
34 CONSTRAINT [PK_AspNetRoles] PRIMARY KEY CLUSTERED
35(
36 [Id] ASC
37)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
38) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
39END
40GO
41/****** Object: Table [dbo].[AspNetUserClaims] Script Date: 6/4/2018 10:18:03 PM ******/
42SET ANSI_NULLS ON
43GO
44SET QUOTED_IDENTIFIER ON
45GO
46IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AspNetUserClaims]') AND type in (N'U'))
47BEGIN
48CREATE TABLE [dbo].[AspNetUserClaims](
49 [Id] [int] IDENTITY(1,1) NOT NULL,
50 [ClaimType] [nvarchar](max) NULL,
51 [ClaimValue] [nvarchar](max) NULL,
52 [UserId] [nvarchar](450) NOT NULL,
53 CONSTRAINT [PK_AspNetUserClaims] PRIMARY KEY CLUSTERED
54(
55 [Id] ASC
56)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
57) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
58END
59GO
60/****** Object: Table [dbo].[AspNetUserLogins] Script Date: 6/4/2018 10:18:03 PM ******/
61SET ANSI_NULLS ON
62GO
63SET QUOTED_IDENTIFIER ON
64GO
65IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AspNetUserLogins]') AND type in (N'U'))
66BEGIN
67CREATE TABLE [dbo].[AspNetUserLogins](
68 [LoginProvider] [nvarchar](450) NOT NULL,
69 [ProviderKey] [nvarchar](450) NOT NULL,
70 [ProviderDisplayName] [nvarchar](max) NULL,
71 [UserId] [nvarchar](450) NOT NULL,
72 CONSTRAINT [PK_AspNetUserLogins] PRIMARY KEY CLUSTERED
73(
74 [LoginProvider] ASC,
75 [ProviderKey] ASC
76)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
77) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
78END
79GO
80/****** Object: Table [dbo].[AspNetUserRoles] Script Date: 6/4/2018 10:18:03 PM ******/
81SET ANSI_NULLS ON
82GO
83SET QUOTED_IDENTIFIER ON
84GO
85IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AspNetUserRoles]') AND type in (N'U'))
86BEGIN
87CREATE TABLE [dbo].[AspNetUserRoles](
88 [UserId] [nvarchar](450) NOT NULL,
89 [RoleId] [nvarchar](450) NOT NULL,
90 CONSTRAINT [PK_AspNetUserRoles] PRIMARY KEY CLUSTERED
91(
92 [UserId] ASC,
93 [RoleId] ASC
94)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
95) ON [PRIMARY]
96END
97GO
98/****** Object: Table [dbo].[AspNetUsers] Script Date: 6/4/2018 10:18:03 PM ******/
99SET ANSI_NULLS ON
100GO
101SET QUOTED_IDENTIFIER ON
102GO
103IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AspNetUsers]') AND type in (N'U'))
104BEGIN
105CREATE TABLE [dbo].[AspNetUsers](
106 [Id] [nvarchar](450) NOT NULL,
107 [AccessFailedCount] [int] NOT NULL,
108 [ConcurrencyStamp] [nvarchar](max) NULL,
109 [Email] [nvarchar](256) NULL,
110 [EmailConfirmed] [bit] NOT NULL,
111 [LockoutEnabled] [bit] NOT NULL,
112 [LockoutEnd] [datetimeoffset](7) NULL,
113 [NormalizedEmail] [nvarchar](256) NULL,
114 [NormalizedUserName] [nvarchar](256) NULL,
115 [PasswordHash] [nvarchar](max) NULL,
116 [PhoneNumber] [nvarchar](max) NULL,
117 [PhoneNumberConfirmed] [bit] NOT NULL,
118 [SecurityStamp] [nvarchar](max) NULL,
119 [TwoFactorEnabled] [bit] NOT NULL,
120 [UserName] [nvarchar](256) NULL,
121 CONSTRAINT [PK_AspNetUsers] PRIMARY KEY CLUSTERED
122(
123 [Id] ASC
124)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
125) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
126END
127GO
128/****** Object: Table [dbo].[AspNetUserTokens] Script Date: 6/4/2018 10:18:03 PM ******/
129SET ANSI_NULLS ON
130GO
131SET QUOTED_IDENTIFIER ON
132GO
133IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AspNetUserTokens]') AND type in (N'U'))
134BEGIN
135CREATE TABLE [dbo].[AspNetUserTokens](
136 [UserId] [nvarchar](450) NOT NULL,
137 [LoginProvider] [nvarchar](450) NOT NULL,
138 [Name] [nvarchar](450) NOT NULL,
139 [Value] [nvarchar](max) NULL,
140 CONSTRAINT [PK_AspNetUserTokens] PRIMARY KEY CLUSTERED
141(
142 [UserId] ASC,
143 [LoginProvider] ASC,
144 [Name] ASC
145)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
146) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
147END
148GO
149IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AspNetRoleClaims_AspNetRoles_RoleId]') AND parent_object_id = OBJECT_ID(N'[dbo].[AspNetRoleClaims]'))
150ALTER TABLE [dbo].[AspNetRoleClaims] WITH CHECK ADD CONSTRAINT [FK_AspNetRoleClaims_AspNetRoles_RoleId] FOREIGN KEY([RoleId])
151REFERENCES [dbo].[AspNetRoles] ([Id])
152ON DELETE CASCADE
153GO
154IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AspNetRoleClaims_AspNetRoles_RoleId]') AND parent_object_id = OBJECT_ID(N'[dbo].[AspNetRoleClaims]'))
155ALTER TABLE [dbo].[AspNetRoleClaims] CHECK CONSTRAINT [FK_AspNetRoleClaims_AspNetRoles_RoleId]
156GO
157IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AspNetUserClaims_AspNetUsers_UserId]') AND parent_object_id = OBJECT_ID(N'[dbo].[AspNetUserClaims]'))
158ALTER TABLE [dbo].[AspNetUserClaims] WITH CHECK ADD CONSTRAINT [FK_AspNetUserClaims_AspNetUsers_UserId] FOREIGN KEY([UserId])
159REFERENCES [dbo].[AspNetUsers] ([Id])
160ON DELETE CASCADE
161GO
162IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AspNetUserClaims_AspNetUsers_UserId]') AND parent_object_id = OBJECT_ID(N'[dbo].[AspNetUserClaims]'))
163ALTER TABLE [dbo].[AspNetUserClaims] CHECK CONSTRAINT [FK_AspNetUserClaims_AspNetUsers_UserId]
164GO
165IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AspNetUserLogins_AspNetUsers_UserId]') AND parent_object_id = OBJECT_ID(N'[dbo].[AspNetUserLogins]'))
166ALTER TABLE [dbo].[AspNetUserLogins] WITH CHECK ADD CONSTRAINT [FK_AspNetUserLogins_AspNetUsers_UserId] FOREIGN KEY([UserId])
167REFERENCES [dbo].[AspNetUsers] ([Id])
168ON DELETE CASCADE
169GO
170IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AspNetUserLogins_AspNetUsers_UserId]') AND parent_object_id = OBJECT_ID(N'[dbo].[AspNetUserLogins]'))
171ALTER TABLE [dbo].[AspNetUserLogins] CHECK CONSTRAINT [FK_AspNetUserLogins_AspNetUsers_UserId]
172GO
173IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AspNetUserRoles_AspNetRoles_RoleId]') AND parent_object_id = OBJECT_ID(N'[dbo].[AspNetUserRoles]'))
174ALTER TABLE [dbo].[AspNetUserRoles] WITH CHECK ADD CONSTRAINT [FK_AspNetUserRoles_AspNetRoles_RoleId] FOREIGN KEY([RoleId])
175REFERENCES [dbo].[AspNetRoles] ([Id])
176ON DELETE CASCADE
177GO
178IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AspNetUserRoles_AspNetRoles_RoleId]') AND parent_object_id = OBJECT_ID(N'[dbo].[AspNetUserRoles]'))
179ALTER TABLE [dbo].[AspNetUserRoles] CHECK CONSTRAINT [FK_AspNetUserRoles_AspNetRoles_RoleId]
180GO
181IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AspNetUserRoles_AspNetUsers_UserId]') AND parent_object_id = OBJECT_ID(N'[dbo].[AspNetUserRoles]'))
182ALTER TABLE [dbo].[AspNetUserRoles] WITH CHECK ADD CONSTRAINT [FK_AspNetUserRoles_AspNetUsers_UserId] FOREIGN KEY([UserId])
183REFERENCES [dbo].[AspNetUsers] ([Id])
184ON DELETE CASCADE
185GO
186IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AspNetUserRoles_AspNetUsers_UserId]') AND parent_object_id = OBJECT_ID(N'[dbo].[AspNetUserRoles]'))
187ALTER TABLE [dbo].[AspNetUserRoles] CHECK CONSTRAINT [FK_AspNetUserRoles_AspNetUsers_UserId]
188GO
189IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AspNetUserTokens_AspNetUsers_UserId]') AND parent_object_id = OBJECT_ID(N'[dbo].[AspNetUserTokens]'))
190ALTER TABLE [dbo].[AspNetUserTokens] WITH CHECK ADD CONSTRAINT [FK_AspNetUserTokens_AspNetUsers_UserId] FOREIGN KEY([UserId])
191REFERENCES [dbo].[AspNetUsers] ([Id])
192ON DELETE CASCADE
193GO
194IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AspNetUserTokens_AspNetUsers_UserId]') AND parent_object_id = OBJECT_ID(N'[dbo].[AspNetUserTokens]'))
195ALTER TABLE [dbo].[AspNetUserTokens] CHECK CONSTRAINT [FK_AspNetUserTokens_AspNetUsers_UserId]
196GO