summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorAndrew Arnott <andrewarnott@gmail.com>2009-11-11 17:07:06 -0800
committerAndrew Arnott <andrewarnott@gmail.com>2009-11-11 17:07:06 -0800
commitf89ed52983a9ee7cfa348720f5de4d9df4d9cec1 (patch)
tree3b46e2abc4666d1dba6e9f8c84cb88f2138bc776
parent48c379710dc3a044a5a1e9ea897255c4cc1ea69b (diff)
downloadDotNetOpenAuth-f89ed52983a9ee7cfa348720f5de4d9df4d9cec1.zip
DotNetOpenAuth-f89ed52983a9ee7cfa348720f5de4d9df4d9cec1.tar.gz
DotNetOpenAuth-f89ed52983a9ee7cfa348720f5de4d9df4d9cec1.tar.bz2
Removed descriptive comments to reduce diff noise in future commits.
-rw-r--r--projecttemplates/WebFormsRelyingParty/Admin/CreateDatabase.sql15
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