diff options
Diffstat (limited to 'projecttemplates/RelyingPartyDatabase')
48 files changed, 0 insertions, 1318 deletions
diff --git a/projecttemplates/RelyingPartyDatabase/.gitignore b/projecttemplates/RelyingPartyDatabase/.gitignore deleted file mode 100644 index 43b64c4..0000000 --- a/projecttemplates/RelyingPartyDatabase/.gitignore +++ /dev/null @@ -1,5 +0,0 @@ -sql/debug -sql/release -*.dbmdl -*.scmp -*.publish.xml diff --git a/projecttemplates/RelyingPartyDatabase/Permissions.sql b/projecttemplates/RelyingPartyDatabase/Permissions.sql deleted file mode 100644 index 5f28270..0000000 --- a/projecttemplates/RelyingPartyDatabase/Permissions.sql +++ /dev/null @@ -1 +0,0 @@ -
\ No newline at end of file diff --git a/projecttemplates/RelyingPartyDatabase/Properties/Database.sqlcmdvars b/projecttemplates/RelyingPartyDatabase/Properties/Database.sqlcmdvars deleted file mode 100644 index dbdd8c5..0000000 --- a/projecttemplates/RelyingPartyDatabase/Properties/Database.sqlcmdvars +++ /dev/null @@ -1,6 +0,0 @@ -<?xml version="1.0" encoding="utf-8"?> -<SqlCommandVariables xmlns="urn:Microsoft.VisualStudio.Data.Schema.Package.SqlCmdVars"> - <Version>1.0</Version> - <Properties> - </Properties> -</SqlCommandVariables>
\ No newline at end of file diff --git a/projecttemplates/RelyingPartyDatabase/Properties/Database.sqldeployment b/projecttemplates/RelyingPartyDatabase/Properties/Database.sqldeployment deleted file mode 100644 index a51546c..0000000 --- a/projecttemplates/RelyingPartyDatabase/Properties/Database.sqldeployment +++ /dev/null @@ -1,16 +0,0 @@ -<?xml version="1.0" encoding="utf-8"?> -<DeploymentConfigurationSettings xmlns="urn:Microsoft.VisualStudio.Data.Schema.Package.DeploymentConfigurationSettings"> - <Version>1.0</Version> - <Properties> - <AbortOnFirstError>False</AbortOnFirstError> - <AlwaysCreateNewDatabase>True</AlwaysCreateNewDatabase> - <BlockIncrementalDeploymentIfDataLoss>True</BlockIncrementalDeploymentIfDataLoss> - <CommentOutSetVarDeclarations>True</CommentOutSetVarDeclarations> - <DeployDatabaseProperties>True</DeployDatabaseProperties> - <DeploymentCollationPreference>UseSourceModelCollation</DeploymentCollationPreference> - <DoNotUseAlterAssemblyStatementsToUpdateCLRTypes>False</DoNotUseAlterAssemblyStatementsToUpdateCLRTypes> - <GenerateDropsIfNotInProject>False</GenerateDropsIfNotInProject> - <PerformDatabaseBackup>False</PerformDatabaseBackup> - <SingleUserMode>False</SingleUserMode> - </Properties> -</DeploymentConfigurationSettings>
\ No newline at end of file diff --git a/projecttemplates/RelyingPartyDatabase/Properties/Database.sqlpermissions b/projecttemplates/RelyingPartyDatabase/Properties/Database.sqlpermissions deleted file mode 100644 index 2b973b7..0000000 --- a/projecttemplates/RelyingPartyDatabase/Properties/Database.sqlpermissions +++ /dev/null @@ -1,44 +0,0 @@ -<?xml version="1.0" encoding="utf-8"?> -<Permissions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:Microsoft.VisualStudio.Data.Schema.Permissions" Version="1.0"> - <!-- The examples below are provided to illustrate how permissions - are defined in the project system for Databases, Objects, - and Columns. - - GRANT Database Permissions - - <PermissionStatement Action ="GRANT"> - <Permission>CREATE TABLE</Permission> - <Grantee>User1</Grantee> - </PermissionStatement> - - GRANT Object Permission - - <PermissionStatement Action ="GRANT"> - <Permission>SELECT</Permission> - <Grantee>User1</Grantee> - <Object Name ="Table1" Schema ="User1" Type ="OBJECT"/> - </PermissionStatement> - - DENY Object Permission - - <PermissionStatement Action ="DENY"> - <Permission>DELETE</Permission> - <Grantee>User1</Grantee> - <Object Name ="Table1" Schema ="User1" Type ="OBJECT"/> - </PermissionStatement> - - GRANT Object Column Permission - - <PermissionStatement Action ="GRANT"> - <Permission>SELECT</Permission> - <Grantee>User1</Grantee> - <Object Name ="Table1" Schema ="User1" Type ="OBJECT"> - <Columns Treatment ="INCLUDE"> - <Column Name=”Col1”/> - <Column Name=”Col2”/> - <Column Name=”…”/> - </Columns> - </Object> - </PermissionStatement> - --> -</Permissions>
\ No newline at end of file diff --git a/projecttemplates/RelyingPartyDatabase/Properties/Database.sqlsettings b/projecttemplates/RelyingPartyDatabase/Properties/Database.sqlsettings deleted file mode 100644 index f83aff5..0000000 --- a/projecttemplates/RelyingPartyDatabase/Properties/Database.sqlsettings +++ /dev/null @@ -1,47 +0,0 @@ -<?xml version="1.0" encoding="utf-8"?> -<CatalogProperties xmlns="urn:Microsoft.VisualStudio.Data.Schema.Package.CatalogProperties"> - <Version>1.0</Version> - <Properties> - <AllowSnapshotIsolation>False</AllowSnapshotIsolation> - <AnsiNullDefault>False</AnsiNullDefault> - <AnsiNulls>False</AnsiNulls> - <AnsiPadding>False</AnsiPadding> - <AnsiWarnings>False</AnsiWarnings> - <ArithAbort>False</ArithAbort> - <AutoClose>True</AutoClose> - <AutoCreateStatistics>True</AutoCreateStatistics> - <AutoShrink>False</AutoShrink> - <AutoUpdateStatistics>True</AutoUpdateStatistics> - <AutoUpdateStatisticsAsynchronously>False</AutoUpdateStatisticsAsynchronously> - <ChangeTrackingRetentionPeriod>2</ChangeTrackingRetentionPeriod> - <ChangeTrackingRetentionUnit>Days</ChangeTrackingRetentionUnit> - <CloseCursorOnCommitEnabled>False</CloseCursorOnCommitEnabled> - <CompatibilityMode>90</CompatibilityMode> - <ConcatNullYieldsNull>False</ConcatNullYieldsNull> - <DatabaseAccess>MULTI_USER</DatabaseAccess> - <DatabaseChaining>False</DatabaseChaining> - <DatabaseState>ONLINE</DatabaseState> - <DateCorrelationOptimizationOn>False</DateCorrelationOptimizationOn> - <DefaultCollation>SQL_Latin1_General_CP1_CI_AS</DefaultCollation> - <DefaultCursor>GLOBAL</DefaultCursor> - <DefaultFilegroup>PRIMARY</DefaultFilegroup> - <EnableFullTextSearch>True</EnableFullTextSearch> - <IsBrokerPriorityHonored>False</IsBrokerPriorityHonored> - <IsChangeTrackingAutoCleanupOn>True</IsChangeTrackingAutoCleanupOn> - <IsChangeTrackingOn>False</IsChangeTrackingOn> - <IsEncryptionOn>False</IsEncryptionOn> - <NumericRoundAbort>False</NumericRoundAbort> - <PageVerify>CHECKSUM</PageVerify> - <Parameterization>SIMPLE</Parameterization> - <QuotedIdentifier>False</QuotedIdentifier> - <ReadCommittedSnapshot>False</ReadCommittedSnapshot> - <Recovery>SIMPLE</Recovery> - <RecursiveTriggersEnabled>False</RecursiveTriggersEnabled> - <ServiceBrokerOption>DisableBroker</ServiceBrokerOption> - <SupplementalLoggingOn>False</SupplementalLoggingOn> - <TornPageDetection>False</TornPageDetection> - <Trustworthy>False</Trustworthy> - <UpdateOptions>READ_WRITE</UpdateOptions> - <VardecimalStorageFormatOn>True</VardecimalStorageFormatOn> - </Properties> -</CatalogProperties>
\ No newline at end of file diff --git a/projecttemplates/RelyingPartyDatabase/RelyingPartyDatabase.sqlproj b/projecttemplates/RelyingPartyDatabase/RelyingPartyDatabase.sqlproj deleted file mode 100644 index ea17196..0000000 --- a/projecttemplates/RelyingPartyDatabase/RelyingPartyDatabase.sqlproj +++ /dev/null @@ -1,317 +0,0 @@ -<?xml version="1.0" encoding="utf-8"?> -<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0"> - <Import Project="$([MSBuild]::GetDirectoryNameOfFileAbove($(MSBuildProjectDirectory), EnlistmentInfo.props))\EnlistmentInfo.props" Condition=" '$([MSBuild]::GetDirectoryNameOfFileAbove($(MSBuildProjectDirectory), EnlistmentInfo.props))' != '' " /> - <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" /> - <PropertyGroup> - <VisualStudioVersion Condition="'$(VisualStudioVersion)' == ''">10.0</VisualStudioVersion> - </PropertyGroup> - <PropertyGroup> - <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration> - <Name>RelyingPartyDatabase</Name> - <SchemaVersion>2.0</SchemaVersion> - <ProjectVersion>4.0</ProjectVersion> - <DSP>Microsoft.Data.Tools.Schema.Sql.Sql90DatabaseSchemaProvider</DSP> - <AppDesignerFolder>Properties</AppDesignerFolder> - <ShowWizard>True</ShowWizard> - <OutputType>Database</OutputType> - <RootPath> - </RootPath> - <IncludeSchemaNameInFileName>False</IncludeSchemaNameInFileName> - <ModelCollation>1033,CI</ModelCollation> - <DefaultFileStructure>BySchemaAndSchemaType</DefaultFileStructure> - <RootNamespace>RelyingPartyDatabase</RootNamespace> - <DefaultSchema>dbo</DefaultSchema> - <PreviousProjectVersion>4.0</PreviousProjectVersion> - <ValidateCasingOnIdentifiers>False</ValidateCasingOnIdentifiers> - <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform> - <ProjectGuid>{08a938b6-ebbd-4036-880e-ce7ba2d14510}</ProjectGuid> - <GenerateDatabaseFile>False</GenerateDatabaseFile> - <GenerateCreateScript>True</GenerateCreateScript> - <TargetFrameworkVersion>v4.5</TargetFrameworkVersion> - <SqlServerVerification>False</SqlServerVerification> - <TargetLanguage>CS</TargetLanguage> - <AllowSnapshotIsolation>False</AllowSnapshotIsolation> - <AnsiNullDefault>False</AnsiNullDefault> - <AnsiNulls>False</AnsiNulls> - <AnsiPadding>False</AnsiPadding> - <AnsiWarnings>False</AnsiWarnings> - <ArithAbort>False</ArithAbort> - <AutoClose>True</AutoClose> - <AutoCreateStatistics>True</AutoCreateStatistics> - <AutoShrink>False</AutoShrink> - <AutoUpdateStatistics>True</AutoUpdateStatistics> - <AutoUpdateStatisticsAsynchronously>False</AutoUpdateStatisticsAsynchronously> - <ChangeTrackingRetentionPeriod>2</ChangeTrackingRetentionPeriod> - <ChangeTrackingRetentionUnit>Days</ChangeTrackingRetentionUnit> - <CloseCursorOnCommitEnabled>False</CloseCursorOnCommitEnabled> - <CompatibilityMode>90</CompatibilityMode> - <ConcatNullYieldsNull>False</ConcatNullYieldsNull> - <DatabaseAccess>MULTI_USER</DatabaseAccess> - <DatabaseChaining>False</DatabaseChaining> - <DatabaseState>ONLINE</DatabaseState> - <DateCorrelationOptimizationOn>False</DateCorrelationOptimizationOn> - <DefaultCollation>SQL_Latin1_General_CP1_CI_AS</DefaultCollation> - <DefaultCursor>GLOBAL</DefaultCursor> - <DefaultFilegroup>PRIMARY</DefaultFilegroup> - <EnableFullTextSearch>True</EnableFullTextSearch> - <IsBrokerPriorityHonored>False</IsBrokerPriorityHonored> - <IsChangeTrackingAutoCleanupOn>True</IsChangeTrackingAutoCleanupOn> - <IsChangeTrackingOn>False</IsChangeTrackingOn> - <IsEncryptionOn>False</IsEncryptionOn> - <NumericRoundAbort>False</NumericRoundAbort> - <PageVerify>CHECKSUM</PageVerify> - <Parameterization>SIMPLE</Parameterization> - <QuotedIdentifier>False</QuotedIdentifier> - <ReadCommittedSnapshot>False</ReadCommittedSnapshot> - <Recovery>SIMPLE</Recovery> - <RecursiveTriggersEnabled>False</RecursiveTriggersEnabled> - <ServiceBrokerOption>DisableBroker</ServiceBrokerOption> - <SupplementalLoggingOn>False</SupplementalLoggingOn> - <TornPageDetection>False</TornPageDetection> - <Trustworthy>False</Trustworthy> - <UpdateOptions>READ_WRITE</UpdateOptions> - <VardecimalStorageFormatOn>True</VardecimalStorageFormatOn> - </PropertyGroup> - <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' "> - <OutputPath>.\sql\release\</OutputPath> - <BuildScriptName>$(MSBuildProjectName).sql</BuildScriptName> - <TargetDatabase>RelyingPartyDatabase</TargetDatabase> - <TreatTSqlWarningsAsErrors>False</TreatTSqlWarningsAsErrors> - <SuppressTSqlWarnings /> - </PropertyGroup> - <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' "> - <OutputPath>.\sql\debug\</OutputPath> - <BuildScriptName>$(MSBuildProjectName).sql</BuildScriptName> - <TargetDatabase>RelyingPartyDatabase</TargetDatabase> - <TreatTSqlWarningsAsErrors>False</TreatTSqlWarningsAsErrors> - <SuppressTSqlWarnings /> - </PropertyGroup> - <!--Import the settings--> - <Import Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" /> - <ItemGroup> - <Folder Include="Properties\" /> - <Folder Include="Schema Objects\" /> - <Folder Include="Schema Objects\Database Level Objects\" /> - <Folder Include="Schema Objects\Database Level Objects\Assemblies\" /> - <Folder Include="Schema Objects\Database Level Objects\Database Triggers\" /> - <Folder Include="Schema Objects\Database Level Objects\Security\" /> - <Folder Include="Schema Objects\Database Level Objects\Security\Asymmetric Keys\" /> - <Folder Include="Schema Objects\Database Level Objects\Security\Certificates\" /> - <Folder Include="Schema Objects\Database Level Objects\Security\Database Audit Specification\" /> - <Folder Include="Schema Objects\Database Level Objects\Security\Database Encryption Keys\" /> - <Folder Include="Schema Objects\Database Level Objects\Security\Master Keys\" /> - <Folder Include="Schema Objects\Database Level Objects\Security\Roles\" /> - <Folder Include="Schema Objects\Database Level Objects\Security\Roles\Application Roles\" /> - <Folder Include="Schema Objects\Database Level Objects\Security\Roles\Database Roles\" /> - <Folder Include="Schema Objects\Database Level Objects\Security\Schemas\" /> - <Folder Include="Schema Objects\Database Level Objects\Security\Signatures\" /> - <Folder Include="Schema Objects\Database Level Objects\Security\Symmetric Keys\" /> - <Folder Include="Schema Objects\Database Level Objects\Security\Users\" /> - <Folder Include="Schema Objects\Database Level Objects\Service Broker\" /> - <Folder Include="Schema Objects\Database Level Objects\Service Broker\Broker Priorities\" /> - <Folder Include="Schema Objects\Database Level Objects\Service Broker\Contracts\" /> - <Folder Include="Schema Objects\Database Level Objects\Service Broker\Event Notifications\" /> - <Folder Include="Schema Objects\Database Level Objects\Service Broker\Message Types\" /> - <Folder Include="Schema Objects\Database Level Objects\Service Broker\Queues\" /> - <Folder Include="Schema Objects\Database Level Objects\Service Broker\Remote Service Binding\" /> - <Folder Include="Schema Objects\Database Level Objects\Service Broker\Routes\" /> - <Folder Include="Schema Objects\Database Level Objects\Service Broker\Services\" /> - <Folder Include="Schema Objects\Database Level Objects\Storage\" /> - <Folder Include="Schema Objects\Database Level Objects\Storage\Filegroups\" /> - <Folder Include="Schema Objects\Database Level Objects\Storage\Files\" /> - <Folder Include="Schema Objects\Database Level Objects\Storage\Full Text Catalogs\" /> - <Folder Include="Schema Objects\Database Level Objects\Storage\Full Text Stoplists\" /> - <Folder Include="Schema Objects\Database Level Objects\Storage\Partition Functions\" /> - <Folder Include="Schema Objects\Database Level Objects\Storage\Partition Schemes\" /> - <Folder Include="Schema Objects\Schemas\" /> - <Folder Include="Schema Objects\Schemas\dbo\" /> - <Folder Include="Schema Objects\Schemas\dbo\Programmability\" /> - <Folder Include="Schema Objects\Schemas\dbo\Programmability\Defaults\" /> - <Folder Include="Schema Objects\Schemas\dbo\Programmability\Functions\" /> - <Folder Include="Schema Objects\Schemas\dbo\Programmability\Rules\" /> - <Folder Include="Schema Objects\Schemas\dbo\Programmability\Stored Procedures\" /> - <Folder Include="Schema Objects\Schemas\dbo\Programmability\Types\" /> - <Folder Include="Schema Objects\Schemas\dbo\Programmability\Types\User Defined Data Types\" /> - <Folder Include="Schema Objects\Schemas\dbo\Programmability\Types\User Defined Table Types\" /> - <Folder Include="Schema Objects\Schemas\dbo\Programmability\Types\User Defined Types CLR\" /> - <Folder Include="Schema Objects\Schemas\dbo\Programmability\Types\XML Schema Collections\" /> - <Folder Include="Schema Objects\Schemas\dbo\Synonyms\" /> - <Folder Include="Schema Objects\Schemas\dbo\Tables\" /> - <Folder Include="Schema Objects\Schemas\dbo\Tables\Constraints\" /> - <Folder Include="Schema Objects\Schemas\dbo\Tables\Indexes\" /> - <Folder Include="Schema Objects\Schemas\dbo\Tables\Keys\" /> - <Folder Include="Schema Objects\Schemas\dbo\Tables\Statistics\" /> - <Folder Include="Schema Objects\Schemas\dbo\Tables\Triggers\" /> - <Folder Include="Schema Objects\Schemas\dbo\Views\" /> - <Folder Include="Schema Objects\Schemas\dbo\Views\Indexes\" /> - <Folder Include="Schema Objects\Schemas\dbo\Views\Statistics\" /> - <Folder Include="Schema Objects\Schemas\dbo\Views\Triggers\" /> - <Folder Include="Scripts" /> - <Folder Include="Scripts\Pre-Deployment" /> - <Folder Include="Scripts\Post-Deployment" /> - <Folder Include="Data Generation Plans" /> - <Folder Include="Schema Comparisons" /> - </ItemGroup> - <ItemGroup> - <Build Include="Permissions.sql" /> - <Build Include="Schema Objects\Database Level Objects\Service Broker\Routes\AutoCreatedLocal.route.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Programmability\Stored Procedures\AddUser.proc.sql"> - <SubType>Code</SubType> - <AnsiNulls>On</AnsiNulls> - <QuotedIdentifier>On</QuotedIdentifier> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Programmability\Stored Procedures\ClearExpiredCryptoKeys.proc.sql"> - <SubType>Code</SubType> - <AnsiNulls>On</AnsiNulls> - <QuotedIdentifier>On</QuotedIdentifier> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Programmability\Stored Procedures\ClearExpiredNonces.proc.sql"> - <SubType>Code</SubType> - <AnsiNulls>On</AnsiNulls> - <QuotedIdentifier>On</QuotedIdentifier> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\AuthenticationToken.table.sql"> - <SubType>Code</SubType> - <AnsiNulls>On</AnsiNulls> - <QuotedIdentifier>On</QuotedIdentifier> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Constraints\DF_AuthenticationToken_CreatedOn.defconst.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Constraints\DF_AuthenticationToken_LastUsed.defconst.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Constraints\DF_AuthenticationToken_UsageCount.defconst.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Constraints\DF_Nonce_Issued.defconst.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Constraints\DF_User_CreatedOn.defconst.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Constraints\DF_User_EmailAddressVerified.defconst.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Indexes\IX_Nonce_Code.index.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Indexes\IX_Nonce_Expires.index.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Keys\FK_AuthenticationToken_User.fkey.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Keys\FK_UserRole_Role.fkey.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Keys\FK_UserRole_User.fkey.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Keys\PK_AuthenticationToken.pkey.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Keys\PK_Nonce.pkey.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Keys\PK_Role.pkey.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Keys\PK_User.pkey.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Keys\PK_UserRole.pkey.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Log.table.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Nonce.table.sql"> - <SubType>Code</SubType> - <AnsiNulls>On</AnsiNulls> - <QuotedIdentifier>On</QuotedIdentifier> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Role.table.sql"> - <SubType>Code</SubType> - <AnsiNulls>On</AnsiNulls> - <QuotedIdentifier>On</QuotedIdentifier> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\User.table.sql"> - <SubType>Code</SubType> - <AnsiNulls>On</AnsiNulls> - <QuotedIdentifier>On</QuotedIdentifier> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\UserRole.table.sql"> - <SubType>Code</SubType> - <AnsiNulls>On</AnsiNulls> - <QuotedIdentifier>On</QuotedIdentifier> - </Build> - </ItemGroup> - <ItemGroup> - <BuildContributorArgument Include="OutDir=$(OutDir)" /> - </ItemGroup> - <ItemGroup> - <None Include="Schema Comparisons\SchemaComparison1.scmp"> - <SubType>NotInBuild</SubType> - </None> - </ItemGroup> - <ItemGroup> - <Build Include="Schema Objects\Schemas\dbo\Tables\Constraints\DF_IssuedToken_CreatedOn_1.defconst.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Keys\FK_IssuedToken_Consumer_1.fkey.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Keys\FK_IssuedToken_User_1.fkey.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Indexes\IX_Consumer_1.index.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Keys\PK_IssuedToken_1.pkey.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Keys\PK_Consumer_1.pkey.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\ClientAuthorization.table.sql"> - <SubType>Code</SubType> - <AnsiNulls>On</AnsiNulls> - <QuotedIdentifier>On</QuotedIdentifier> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Client.table.sql"> - <SubType>Code</SubType> - <AnsiNulls>On</AnsiNulls> - <QuotedIdentifier>On</QuotedIdentifier> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Indexes\IX_CryptoKeys.index.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\Keys\PK_CryptoKeys.pkey.sql"> - <SubType>Code</SubType> - </Build> - <Build Include="Schema Objects\Schemas\dbo\Tables\CryptoKey.table.sql"> - <SubType>Code</SubType> - <AnsiNulls>On</AnsiNulls> - <QuotedIdentifier>On</QuotedIdentifier> - </Build> - </ItemGroup> - <ItemGroup> - </ItemGroup> - <ItemGroup> - <None Include="Debug.publish.xml" /> - <None Include="Release.publish.xml" /> - </ItemGroup> - <ItemGroup> - <PreDeploy Include="Scripts\Pre-Deployment\Script.PreDeployment.sql" /> - </ItemGroup> - <ItemGroup> - <PostDeploy Include="Scripts\Post-Deployment\Script.PostDeployment.sql" /> - </ItemGroup> - <Target Name="GetDeployScriptPath" - DependsOnTargets="Build" - Outputs="$(MSBuildProjectDirectory)$(OutDir)$(MSBuildProjectName)_Create.sql" /> - <Import Project="$([MSBuild]::GetDirectoryNameOfFileAbove($(MSBuildProjectDirectory), EnlistmentInfo.targets))\EnlistmentInfo.targets" Condition=" '$([MSBuild]::GetDirectoryNameOfFileAbove($(MSBuildProjectDirectory), EnlistmentInfo.targets))' != '' " /> -</Project>
\ No newline at end of file diff --git a/projecttemplates/RelyingPartyDatabase/Schema Comparisons/SchemaComparison1.scmp b/projecttemplates/RelyingPartyDatabase/Schema Comparisons/SchemaComparison1.scmp deleted file mode 100644 index b80761f..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Comparisons/SchemaComparison1.scmp +++ /dev/null @@ -1,329 +0,0 @@ -<?xml version="1.0" encoding="utf-8"?> -<SchemaComparison> - <Version>10</Version> - <SourceModelProvider> - <ConnectionBasedModelProvider> - <ConnectionString>Data Source=.\sqlexpress;Initial Catalog=RelyingPartyDatabase;Integrated Security=True;Password=</ConnectionString> - <DatabaseName>RelyingPartyDatabase</DatabaseName> - <DspFamilyName>sql</DspFamilyName> - <Name>[THINKAGAIN\sqlexpress.RelyingPartyDatabase]</Name> - </ConnectionBasedModelProvider> - </SourceModelProvider> - <TargetModelProvider> - <ProjectBasedModelProvider> - <ProjectGuid>{2b4261ac-25ac-4b8d-b459-1c42b6b1401d}</ProjectGuid> - <Name>RelyingPartyDatabase</Name> - </ProjectBasedModelProvider> - </TargetModelProvider> - <SchemaCompareSettingsService> - <SchemaCompareSettingsService> - <PropertyElementName> - <Name>Version</Name> - <Value>1</Value> - </PropertyElementName> - </SchemaCompareSettingsService> - <ConfigurationOptionsElement> - <PropertyElementName> - <Name>PlanGenerationType</Name> - <Value>SqlDeploymentOptions</Value> - </PropertyElementName> - <PropertyElementName> - <Name>DoNotUseAlterAssemblyStatementsToUpdateCLRTypes</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>DisableAndReenableDdlTriggers</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreDdlTriggerOrder</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreDdlTriggerState</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreObjectPlacementOnPartitionScheme</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreAuthorizer</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreDefaultSchema</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreRouteLifetime</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>OnlyCompareElementsInSource</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreStatisticsSample</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>CommentOutSetVarDeclarations</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>GenerateDeployStateChecks</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>DeployDatabaseProperties</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreComments</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreWhitespace</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreKeywordCasing</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreSemicolonBetweenStatements</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>BlockIncrementalDeploymentIfDataLoss</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>PerformDatabaseBackup</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SingleUserMode</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IncludeTransactionalScripts</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>EnforceMinimalDependencies</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>DeploymentCollationPreference</Name> - <Value>UseSourceModelCollation</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnorePartitionSchemes</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreWithNocheckOnCheckConstraints</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreWithNocheckOnForeignKeys</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreIdentitySeed</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreIncrement</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreFillFactor</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreIndexPadding</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreColumnCollation</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreLockHintsOnIndexes</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreTableOptions</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreIndexOptions</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreDmlTriggerOrder</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>ScriptDatabaseCollation</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreDmlTriggerState</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreAnsiNulls</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreQuotedIdentifiers</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreUserSettingsObjects</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>AbortOnFirstError</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreFilegroupPlacement</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreFullTextCatalogFilePath</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreFileAndLogFilePath</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreLoginSids</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreNotForReplication</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreFileSize</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>OverrideSevenSetOptions</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SetAnsiNulls</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SetAnsiPadding</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SetAnsiWarnings</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SetArithAbort</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SetConcatNullYieldsNull</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SetQuotedIdentifier</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SetNumericRoundAbort</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>UnmodifiableObjectWarnings</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>DropIndexesNotInSource</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>DropConstraintsNotInSource</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>CheckNewConstraints</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreColumnOrder</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnorePasswords</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreBodyDependencies</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SourceSqlCmdVariablesFile</Name> - <Value>C:\Users\andarno\git\dotnetopenid\projecttemplates\RelyingPartyDatabase\Properties\Database.sqlcmdvars</Value> - </PropertyElementName> - <PropertyElementName> - <Name>AlwaysCreateNewDatabase</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>GenerateDropsIfNotInProject</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>TargetDatabaseName</Name> - <Value>RelyingPartyDatabase</Value> - </PropertyElementName> - <PropertyElementName> - <Name>TargetConnectionString</Name> - <Value>Data Source=.\sqlexpress;Initial Catalog=RelyingPartyDatabase;Integrated Security=True;Pooling=False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>VerifyDeployment</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>TreatVerificationErrorsAsWarnings</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>BuildtimeContributorsMustExist</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlPermissionStatement</Name> - <Value>ExcludedType</Value> - </PropertyElementName> - <PropertyElementName> - <Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlFilegroup</Name> - <Value>ExcludedType</Value> - </PropertyElementName> - <PropertyElementName> - <Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlFile</Name> - <Value>ExcludedType</Value> - </PropertyElementName> - <PropertyElementName> - <Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlExtendedProperty</Name> - <Value>ExcludedType</Value> - </PropertyElementName> - </ConfigurationOptionsElement> - </SchemaCompareSettingsService> - <SchemaCompareViewSettings /> -</SchemaComparison>
\ No newline at end of file diff --git a/projecttemplates/RelyingPartyDatabase/Schema Comparisons/SchemaComparison1_20120225042555.scmp b/projecttemplates/RelyingPartyDatabase/Schema Comparisons/SchemaComparison1_20120225042555.scmp deleted file mode 100644 index b3160a4..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Comparisons/SchemaComparison1_20120225042555.scmp +++ /dev/null @@ -1,328 +0,0 @@ -<?xml version="1.0" encoding="utf-8"?> -<SchemaComparison> - <Version>1</Version> - <SourceModelProvider> - <ConnectionBasedModelProvider> - <ConnectionString>Data Source=.\sqlexpress;Initial Catalog=RelyingPartyDatabase;Integrated Security=True;Password=</ConnectionString> - <DatabaseName>RelyingPartyDatabase</DatabaseName> - <DspFamilyName>sql</DspFamilyName> - <Name>[THINKAGAIN\sqlexpress.RelyingPartyDatabase]</Name> - </ConnectionBasedModelProvider> - </SourceModelProvider> - <TargetModelProvider> - <ProjectBasedModelProvider> - <ProjectGuid>{2b4261ac-25ac-4b8d-b459-1c42b6b1401d}</ProjectGuid> - <Name>RelyingPartyDatabase</Name> - </ProjectBasedModelProvider> - </TargetModelProvider> - <SchemaCompareSettingsService> - <SchemaCompareSettingsService> - <PropertyElementName> - <Name>Version</Name> - <Value>1</Value> - </PropertyElementName> - </SchemaCompareSettingsService> - <ConfigurationOptionsElement> - <PropertyElementName> - <Name>PlanGenerationType</Name> - <Value>Sql90SchemaDeploymentOptions</Value> - </PropertyElementName> - <PropertyElementName> - <Name>DoNotUseAlterAssemblyStatementsToUpdateCLRTypes</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>DisableAndReenableDdlTriggers</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreDdlTriggerOrder</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreDdlTriggerState</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreObjectPlacementOnPartitionScheme</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreAuthorizer</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreDefaultSchema</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreRouteLifetime</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>OnlyCompareElementsInSource</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreStatisticsSample</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>CommentOutSetVarDeclarations</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>GenerateDeployStateChecks</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>DeployDatabaseProperties</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreComments</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreWhitespace</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreKeywordCasing</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreSemicolonBetweenStatements</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>BlockIncrementalDeploymentIfDataLoss</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>PerformDatabaseBackup</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SingleUserMode</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IncludeTransactionalScripts</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>EnforceMinimalDependencies</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>DeploymentCollationPreference</Name> - <Value>UseSourceModelCollation</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnorePartitionSchemes</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreWithNocheckOnCheckConstraints</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreWithNocheckOnForeignKeys</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreIdentitySeed</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreIncrement</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreFillFactor</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreIndexPadding</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreColumnCollation</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreLockHintsOnIndexes</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreTableOptions</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreIndexOptions</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreDmlTriggerOrder</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>ScriptDatabaseCollation</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreDmlTriggerState</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreAnsiNulls</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreQuotedIdentifiers</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreUserSettingsObjects</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>AbortOnFirstError</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreFilegroupPlacement</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreFullTextCatalogFilePath</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreFileAndLogFilePath</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreLoginSids</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreNotForReplication</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreFileSize</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>OverrideSevenSetOptions</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SetAnsiNulls</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SetAnsiPadding</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SetAnsiWarnings</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SetArithAbort</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SetConcatNullYieldsNull</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SetQuotedIdentifier</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SetNumericRoundAbort</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>UnmodifiableObjectWarnings</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>DropIndexesNotInSource</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>DropConstraintsNotInSource</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>CheckNewConstraints</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreColumnOrder</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnorePasswords</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>IgnoreBodyDependencies</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>SourceSqlCmdVariablesFile</Name> - <Value>C:\Users\andarno\git\dotnetopenid\projecttemplates\RelyingPartyDatabase\Properties\Database.sqlcmdvars</Value> - </PropertyElementName> - <PropertyElementName> - <Name>AlwaysCreateNewDatabase</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>GenerateDropsIfNotInProject</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>TargetDatabaseName</Name> - <Value>RelyingPartyDatabase</Value> - </PropertyElementName> - <PropertyElementName> - <Name>TargetConnectionString</Name> - <Value>Data Source=.\sqlexpress;Initial Catalog=RelyingPartyDatabase;Integrated Security=True;Pooling=False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>VerifyDeployment</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>TreatVerificationErrorsAsWarnings</Name> - <Value>False</Value> - </PropertyElementName> - <PropertyElementName> - <Name>BuildtimeContributorsMustExist</Name> - <Value>True</Value> - </PropertyElementName> - <PropertyElementName> - <Name>Microsoft.Data.Schema.Sql.SchemaModel.ISqlPermissionStatement</Name> - <Value>ExcludedType</Value> - </PropertyElementName> - <PropertyElementName> - <Name>Microsoft.Data.Schema.Sql.SchemaModel.ISqlFilegroup</Name> - <Value>ExcludedType</Value> - </PropertyElementName> - <PropertyElementName> - <Name>Microsoft.Data.Schema.Sql.SchemaModel.ISqlFile</Name> - <Value>ExcludedType</Value> - </PropertyElementName> - <PropertyElementName> - <Name>Microsoft.Data.Schema.Sql.SchemaModel.ISqlExtendedProperty</Name> - <Value>ExcludedType</Value> - </PropertyElementName> - </ConfigurationOptionsElement> - </SchemaCompareSettingsService> -</SchemaComparison>
\ No newline at end of file diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Database Level Objects/Service Broker/Routes/AutoCreatedLocal.route.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Database Level Objects/Service Broker/Routes/AutoCreatedLocal.route.sql deleted file mode 100644 index 4d731a7..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Database Level Objects/Service Broker/Routes/AutoCreatedLocal.route.sql +++ /dev/null @@ -1,4 +0,0 @@ -CREATE ROUTE [AutoCreatedLocal] - AUTHORIZATION [dbo] - WITH ADDRESS = N'LOCAL'; - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Programmability/Stored Procedures/AddUser.proc.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Programmability/Stored Procedures/AddUser.proc.sql deleted file mode 100644 index b22b231..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Programmability/Stored Procedures/AddUser.proc.sql +++ /dev/null @@ -1,37 +0,0 @@ -CREATE PROCEDURE [dbo].[AddUser] - ( - @firstName nvarchar(50), - @lastName nvarchar(50), - @openid nvarchar(255), - @role nvarchar(255) - ) -AS - DECLARE - @roleid int, - @userid int - - BEGIN TRANSACTION - - INSERT INTO [dbo].[User] (FirstName, LastName) VALUES (@firstName, @lastName) - SET @userid = (SELECT @@IDENTITY) - - IF (SELECT COUNT(*) FROM dbo.Role WHERE [Name] = @role) = 0 - BEGIN - INSERT INTO dbo.Role (Name) VALUES (@role) - SET @roleid = (SELECT @@IDENTITY) - END - ELSE - BEGIN - SET @roleid = (SELECT RoleId FROM dbo.Role WHERE [Name] = @role) - END - - INSERT INTO dbo.UserRole (UserId, RoleId) VALUES (@userId, @roleid) - - INSERT INTO dbo.AuthenticationToken - (UserId, OpenIdClaimedIdentifier, OpenIdFriendlyIdentifier) - VALUES - (@userid, @openid, @openid) - - COMMIT TRANSACTION - - RETURN @userid diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Programmability/Stored Procedures/ClearExpiredCryptoKeys.proc.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Programmability/Stored Procedures/ClearExpiredCryptoKeys.proc.sql deleted file mode 100644 index 777ba9b..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Programmability/Stored Procedures/ClearExpiredCryptoKeys.proc.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE PROCEDURE dbo.ClearExpiredCryptoKeys -AS - -DELETE FROM dbo.CryptoKey -WHERE [Expiration] < getutcdate() diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Programmability/Stored Procedures/ClearExpiredNonces.proc.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Programmability/Stored Procedures/ClearExpiredNonces.proc.sql deleted file mode 100644 index 3299c6c..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Programmability/Stored Procedures/ClearExpiredNonces.proc.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE PROCEDURE dbo.ClearExpiredNonces -AS - -DELETE FROM dbo.[Nonce] -WHERE [Expires] < getutcdate() diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/AuthenticationToken.table.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/AuthenticationToken.table.sql deleted file mode 100644 index 920e36e..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/AuthenticationToken.table.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE [dbo].[AuthenticationToken] ( - [AuthenticationTokenId] INT IDENTITY (1, 1) NOT NULL, - [UserId] INT NOT NULL, - [OpenIdClaimedIdentifier] NVARCHAR (250) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL, - [OpenIdFriendlyIdentifier] NVARCHAR (250) NULL, - [CreatedOn] DATETIME NOT NULL, - [LastUsed] DATETIME NOT NULL, - [UsageCount] INT NOT NULL -); - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Client.table.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Client.table.sql deleted file mode 100644 index 49f6c3f..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Client.table.sql +++ /dev/null @@ -1,13 +0,0 @@ -CREATE TABLE [dbo].[Client] ( - [ClientId] INT IDENTITY (1, 1) NOT NULL, - [ClientIdentifier] VARCHAR (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL, - [ClientSecret] VARCHAR (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL, - [Callback] VARCHAR (2048) NULL, - [ClientType] INT, - [Name] NVARCHAR (50) NOT NULL -); - - - - - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/ClientAuthorization.table.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/ClientAuthorization.table.sql deleted file mode 100644 index 3a31062..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/ClientAuthorization.table.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE [dbo].[ClientAuthorization] ( - [AuthorizationId] INT IDENTITY (1, 1) NOT NULL, - [ClientId] INT NOT NULL, - [UserId] INT NOT NULL, - [CreatedOn] DATETIME NOT NULL, - [ExpirationDate] DATETIME NULL, - [Scope] VARCHAR (2048) NULL -); - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_AuthenticationToken_CreatedOn.defconst.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_AuthenticationToken_CreatedOn.defconst.sql deleted file mode 100644 index df7c22e..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_AuthenticationToken_CreatedOn.defconst.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[AuthenticationToken] - ADD CONSTRAINT [DF_AuthenticationToken_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn]; - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_AuthenticationToken_LastUsed.defconst.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_AuthenticationToken_LastUsed.defconst.sql deleted file mode 100644 index 95f5490..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_AuthenticationToken_LastUsed.defconst.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[AuthenticationToken] - ADD CONSTRAINT [DF_AuthenticationToken_LastUsed] DEFAULT (getutcdate()) FOR [LastUsed]; - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_AuthenticationToken_UsageCount.defconst.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_AuthenticationToken_UsageCount.defconst.sql deleted file mode 100644 index f7a65df..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_AuthenticationToken_UsageCount.defconst.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[AuthenticationToken] - ADD CONSTRAINT [DF_AuthenticationToken_UsageCount] DEFAULT ((0)) FOR [UsageCount]; - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_IssuedToken_CreatedOn_1.defconst.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_IssuedToken_CreatedOn_1.defconst.sql deleted file mode 100644 index 3ba2b0b..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_IssuedToken_CreatedOn_1.defconst.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[ClientAuthorization] - ADD CONSTRAINT [DF_IssuedToken_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn]; - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_Nonce_Issued.defconst.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_Nonce_Issued.defconst.sql deleted file mode 100644 index 84b5e52..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_Nonce_Issued.defconst.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[Nonce] - ADD CONSTRAINT [DF_Nonce_Issued] DEFAULT (getutcdate()) FOR [Issued]; - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_User_CreatedOn.defconst.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_User_CreatedOn.defconst.sql deleted file mode 100644 index 101d2c2..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_User_CreatedOn.defconst.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[User] - ADD CONSTRAINT [DF_User_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn]; - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_User_EmailAddressVerified.defconst.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_User_EmailAddressVerified.defconst.sql deleted file mode 100644 index 04779be..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Constraints/DF_User_EmailAddressVerified.defconst.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[User] - ADD CONSTRAINT [DF_User_EmailAddressVerified] DEFAULT ((0)) FOR [EmailAddressVerified]; - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/CryptoKey.table.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/CryptoKey.table.sql deleted file mode 100644 index a5af46c..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/CryptoKey.table.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE [dbo].[CryptoKey] ( - [CryptoKeyId] INT IDENTITY (1, 1) NOT NULL, - [Bucket] VARCHAR (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL, - [Handle] VARCHAR (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL, - [Expiration] DATETIME NOT NULL, - [Secret] VARBINARY (4096) NOT NULL -); - - - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Indexes/IX_Consumer_1.index.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Indexes/IX_Consumer_1.index.sql deleted file mode 100644 index e5ad21b..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Indexes/IX_Consumer_1.index.sql +++ /dev/null @@ -1,4 +0,0 @@ -CREATE UNIQUE NONCLUSTERED INDEX [IX_Consumer] - ON [dbo].[Client]([ClientIdentifier] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ONLINE = OFF, MAXDOP = 0) - ON [PRIMARY]; - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Indexes/IX_CryptoKeys.index.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Indexes/IX_CryptoKeys.index.sql deleted file mode 100644 index bd8876e..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Indexes/IX_CryptoKeys.index.sql +++ /dev/null @@ -1,4 +0,0 @@ -CREATE UNIQUE NONCLUSTERED INDEX [IX_CryptoKeys] - ON [dbo].[CryptoKey]([Bucket] ASC, [Handle] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ONLINE = OFF, MAXDOP = 0) - ON [PRIMARY]; - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Indexes/IX_Nonce_Code.index.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Indexes/IX_Nonce_Code.index.sql deleted file mode 100644 index 5539512..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Indexes/IX_Nonce_Code.index.sql +++ /dev/null @@ -1,3 +0,0 @@ -CREATE UNIQUE NONCLUSTERED INDEX [IX_Nonce_Code] - ON [dbo].[Nonce]([Context] ASC, [Code] ASC, [Issued] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ONLINE = OFF, MAXDOP = 0); - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Indexes/IX_Nonce_Expires.index.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Indexes/IX_Nonce_Expires.index.sql deleted file mode 100644 index 23b7cc1..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Indexes/IX_Nonce_Expires.index.sql +++ /dev/null @@ -1,3 +0,0 @@ -CREATE NONCLUSTERED INDEX [IX_Nonce_Expires] - ON [dbo].[Nonce]([Expires] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ONLINE = OFF, MAXDOP = 0); - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/FK_AuthenticationToken_User.fkey.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/FK_AuthenticationToken_User.fkey.sql deleted file mode 100644 index 4428616..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/FK_AuthenticationToken_User.fkey.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[AuthenticationToken] - ADD CONSTRAINT [FK_AuthenticationToken_User] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User] ([UserId]) ON DELETE CASCADE ON UPDATE CASCADE; - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/FK_IssuedToken_Consumer_1.fkey.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/FK_IssuedToken_Consumer_1.fkey.sql deleted file mode 100644 index 062b9d7..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/FK_IssuedToken_Consumer_1.fkey.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[ClientAuthorization] - ADD CONSTRAINT [FK_IssuedToken_Consumer] FOREIGN KEY ([ClientId]) REFERENCES [dbo].[Client] ([ClientId]) ON DELETE CASCADE ON UPDATE CASCADE; - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/FK_IssuedToken_User_1.fkey.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/FK_IssuedToken_User_1.fkey.sql deleted file mode 100644 index e32b291..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/FK_IssuedToken_User_1.fkey.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[ClientAuthorization] - ADD CONSTRAINT [FK_IssuedToken_User] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User] ([UserId]) ON DELETE CASCADE ON UPDATE CASCADE; - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/FK_UserRole_Role.fkey.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/FK_UserRole_Role.fkey.sql deleted file mode 100644 index 859b6f6..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/FK_UserRole_Role.fkey.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[UserRole] - ADD CONSTRAINT [FK_UserRole_Role] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[Role] ([RoleId]) ON DELETE CASCADE ON UPDATE CASCADE; - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/FK_UserRole_User.fkey.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/FK_UserRole_User.fkey.sql deleted file mode 100644 index bd0a303..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/FK_UserRole_User.fkey.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[UserRole] - ADD CONSTRAINT [FK_UserRole_User] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User] ([UserId]) ON DELETE CASCADE ON UPDATE CASCADE; - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_AuthenticationToken.pkey.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_AuthenticationToken.pkey.sql deleted file mode 100644 index 21ed5f9..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_AuthenticationToken.pkey.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[AuthenticationToken] - ADD CONSTRAINT [PK_AuthenticationToken] PRIMARY KEY CLUSTERED ([AuthenticationTokenId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_Consumer_1.pkey.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_Consumer_1.pkey.sql deleted file mode 100644 index 04c039f..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_Consumer_1.pkey.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[Client] - ADD CONSTRAINT [PK_Consumer] PRIMARY KEY CLUSTERED ([ClientId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_CryptoKeys.pkey.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_CryptoKeys.pkey.sql deleted file mode 100644 index ebe7f67..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_CryptoKeys.pkey.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[CryptoKey] - ADD CONSTRAINT [PK_CryptoKeys] PRIMARY KEY CLUSTERED ([CryptoKeyId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_IssuedToken_1.pkey.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_IssuedToken_1.pkey.sql deleted file mode 100644 index dcd7edc..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_IssuedToken_1.pkey.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[ClientAuthorization] - ADD CONSTRAINT [PK_IssuedToken] PRIMARY KEY CLUSTERED ([AuthorizationId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_Nonce.pkey.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_Nonce.pkey.sql deleted file mode 100644 index d6faf9e..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_Nonce.pkey.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[Nonce] - ADD CONSTRAINT [PK_Nonce] PRIMARY KEY CLUSTERED ([NonceId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_Role.pkey.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_Role.pkey.sql deleted file mode 100644 index 62b87cd..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_Role.pkey.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[Role] - ADD CONSTRAINT [PK_Role] PRIMARY KEY CLUSTERED ([RoleId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_User.pkey.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_User.pkey.sql deleted file mode 100644 index d44081d..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_User.pkey.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[User] - ADD CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ([UserId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_UserRole.pkey.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_UserRole.pkey.sql deleted file mode 100644 index 77579c0..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Keys/PK_UserRole.pkey.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE [dbo].[UserRole] - ADD CONSTRAINT [PK_UserRole] PRIMARY KEY CLUSTERED ([UserId] ASC, [RoleId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF); - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Log.table.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Log.table.sql deleted file mode 100644 index 84fd97a..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Log.table.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE [dbo].[Log] ( - [Id] INT IDENTITY (1, 1) NOT NULL, - [Date] DATETIME NOT NULL, - [Thread] VARCHAR (255) NOT NULL, - [Level] VARCHAR (50) NOT NULL, - [Logger] VARCHAR (255) NOT NULL, - [Message] VARCHAR (4000) NOT NULL, - [Exception] VARCHAR (2000) NULL -) diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Nonce.table.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Nonce.table.sql deleted file mode 100644 index bd52d69..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Nonce.table.sql +++ /dev/null @@ -1,8 +0,0 @@ -CREATE TABLE [dbo].[Nonce] ( - [NonceId] INT IDENTITY (1, 1) NOT NULL, - [Context] VARCHAR (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL, - [Code] VARCHAR (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL, - [Issued] DATETIME NOT NULL, - [Expires] DATETIME NOT NULL -); - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Role.table.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Role.table.sql deleted file mode 100644 index eb7a33c..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Role.table.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE TABLE [dbo].[Role] ( - [RoleId] INT IDENTITY (1, 1) NOT NULL, - [Name] NVARCHAR (50) NOT NULL -); - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/User.table.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/User.table.sql deleted file mode 100644 index 2df39d6..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/User.table.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE [dbo].[User] ( - [UserId] INT IDENTITY (1, 1) NOT NULL, - [FirstName] NVARCHAR (50) NULL, - [LastName] NVARCHAR (50) NULL, - [EmailAddress] NVARCHAR (100) NULL, - [EmailAddressVerified] BIT NOT NULL, - [CreatedOn] DATETIME NOT NULL -); - diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/UserRole.table.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/UserRole.table.sql deleted file mode 100644 index fc69e2e..0000000 --- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/UserRole.table.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE TABLE [dbo].[UserRole] ( - [UserId] INT NOT NULL, - [RoleId] INT NOT NULL -); - diff --git a/projecttemplates/RelyingPartyDatabase/Scripts/Post-Deployment/Script.PostDeployment.sql b/projecttemplates/RelyingPartyDatabase/Scripts/Post-Deployment/Script.PostDeployment.sql deleted file mode 100644 index 37db4f5..0000000 --- a/projecttemplates/RelyingPartyDatabase/Scripts/Post-Deployment/Script.PostDeployment.sql +++ /dev/null @@ -1,11 +0,0 @@ -/* -Post-Deployment Script Template --------------------------------------------------------------------------------------- - This file contains SQL statements that will be appended to the build script. - Use SQLCMD syntax to include a file in the post-deployment script. - Example: :r .\myfile.sql - Use SQLCMD syntax to reference a variable in the post-deployment script. - Example: :setvar TableName MyTable - SELECT * FROM [$(TableName)] --------------------------------------------------------------------------------------- -*/
\ No newline at end of file diff --git a/projecttemplates/RelyingPartyDatabase/Scripts/Pre-Deployment/Script.PreDeployment.sql b/projecttemplates/RelyingPartyDatabase/Scripts/Pre-Deployment/Script.PreDeployment.sql deleted file mode 100644 index 0c9f8d6..0000000 --- a/projecttemplates/RelyingPartyDatabase/Scripts/Pre-Deployment/Script.PreDeployment.sql +++ /dev/null @@ -1,11 +0,0 @@ -/* - Pre-Deployment Script Template --------------------------------------------------------------------------------------- - This file contains SQL statements that will be executed before the build script. - Use SQLCMD syntax to include a file in the pre-deployment script. - Example: :r .\myfile.sql - Use SQLCMD syntax to reference a variable in the pre-deployment script. - Example: :setvar TableName MyTable - SELECT * FROM [$(TableName)] --------------------------------------------------------------------------------------- -*/
\ No newline at end of file |