diff options
| -rw-r--r-- | projecttemplates/WebFormsRelyingParty/Admin/CreateDatabase.sql | 15 |
1 files changed, 0 insertions, 15 deletions
diff --git a/projecttemplates/WebFormsRelyingParty/Admin/CreateDatabase.sql b/projecttemplates/WebFormsRelyingParty/Admin/CreateDatabase.sql index 8f242c2..52ca669 100644 --- a/projecttemplates/WebFormsRelyingParty/Admin/CreateDatabase.sql +++ b/projecttemplates/WebFormsRelyingParty/Admin/CreateDatabase.sql @@ -1,4 +1,3 @@ -/****** Object: Table [dbo].[Consumer] Script Date: 11/11/2009 17:04:47 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON @@ -23,7 +22,6 @@ CREATE UNIQUE NONCLUSTERED INDEX [IX_Consumer] ON [dbo].[Consumer] [ConsumerKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -/****** Object: Table [dbo].[User] Script Date: 11/11/2009 17:04:47 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON @@ -40,7 +38,6 @@ CREATE TABLE [dbo].[User]( )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO -/****** Object: Table [dbo].[Role] Script Date: 11/11/2009 17:04:47 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON @@ -54,7 +51,6 @@ CREATE TABLE [dbo].[Role]( )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO -/****** Object: Table [dbo].[IssuedToken] Script Date: 11/11/2009 17:04:47 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON @@ -87,7 +83,6 @@ CREATE UNIQUE NONCLUSTERED INDEX [IX_IssuedToken] ON [dbo].[IssuedToken] [Token] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -/****** Object: Table [dbo].[UserRole] Script Date: 11/11/2009 17:04:47 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON @@ -102,7 +97,6 @@ CREATE TABLE [dbo].[UserRole]( )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO -/****** Object: Table [dbo].[AuthenticationToken] Script Date: 11/11/2009 17:04:47 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON @@ -118,7 +112,6 @@ CREATE TABLE [dbo].[AuthenticationToken]( )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO -/****** Object: StoredProcedure [dbo].[AddUser] Script Date: 11/11/2009 17:05:07 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON @@ -161,16 +154,12 @@ AS RETURN @userid GO -/****** Object: Default [DF_User_EmailAddressVerified] Script Date: 11/11/2009 17:04:47 ******/ ALTER TABLE [dbo].[User] ADD CONSTRAINT [DF_User_EmailAddressVerified] DEFAULT ((0)) FOR [EmailAddressVerified] GO -/****** Object: Default [DF_IssuedToken_CreatedOn] Script Date: 11/11/2009 17:04:47 ******/ ALTER TABLE [dbo].[IssuedToken] ADD CONSTRAINT [DF_IssuedToken_CreatedOn] DEFAULT (getdate()) FOR [CreatedOn] GO -/****** Object: Default [DF_IssuedToken_IsAccessToken] Script Date: 11/11/2009 17:04:47 ******/ ALTER TABLE [dbo].[IssuedToken] ADD CONSTRAINT [DF_IssuedToken_IsAccessToken] DEFAULT ((0)) FOR [IsAccessToken] GO -/****** Object: ForeignKey [FK_IssuedToken_Consumer] Script Date: 11/11/2009 17:04:47 ******/ ALTER TABLE [dbo].[IssuedToken] WITH CHECK ADD CONSTRAINT [FK_IssuedToken_Consumer] FOREIGN KEY([ConsumerId]) REFERENCES [dbo].[Consumer] ([ConsumerId]) ON UPDATE CASCADE @@ -178,7 +167,6 @@ ON DELETE CASCADE GO ALTER TABLE [dbo].[IssuedToken] CHECK CONSTRAINT [FK_IssuedToken_Consumer] GO -/****** Object: ForeignKey [FK_IssuedToken_User] Script Date: 11/11/2009 17:04:47 ******/ ALTER TABLE [dbo].[IssuedToken] WITH CHECK ADD CONSTRAINT [FK_IssuedToken_User] FOREIGN KEY([UserId]) REFERENCES [dbo].[User] ([Id]) ON UPDATE CASCADE @@ -186,7 +174,6 @@ ON DELETE CASCADE GO ALTER TABLE [dbo].[IssuedToken] CHECK CONSTRAINT [FK_IssuedToken_User] GO -/****** Object: ForeignKey [FK_UserRole_Role] Script Date: 11/11/2009 17:04:47 ******/ ALTER TABLE [dbo].[UserRole] WITH CHECK ADD CONSTRAINT [FK_UserRole_Role] FOREIGN KEY([RoleId]) REFERENCES [dbo].[Role] ([Id]) ON UPDATE CASCADE @@ -194,7 +181,6 @@ ON DELETE CASCADE GO ALTER TABLE [dbo].[UserRole] CHECK CONSTRAINT [FK_UserRole_Role] GO -/****** Object: ForeignKey [FK_UserRole_User] Script Date: 11/11/2009 17:04:47 ******/ ALTER TABLE [dbo].[UserRole] WITH CHECK ADD CONSTRAINT [FK_UserRole_User] FOREIGN KEY([UserId]) REFERENCES [dbo].[User] ([Id]) ON UPDATE CASCADE @@ -202,7 +188,6 @@ ON DELETE CASCADE GO ALTER TABLE [dbo].[UserRole] CHECK CONSTRAINT [FK_UserRole_User] GO -/****** Object: ForeignKey [FK_AuthenticationToken_User] Script Date: 11/11/2009 17:04:47 ******/ ALTER TABLE [dbo].[AuthenticationToken] WITH CHECK ADD CONSTRAINT [FK_AuthenticationToken_User] FOREIGN KEY([UserId]) REFERENCES [dbo].[User] ([Id]) ON UPDATE CASCADE |