<?xml version="1.0" encoding="utf-8"?>
<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0">
  <Sdk Name="Microsoft.Build.Sql" Version="0.1.3-preview" />
  <PropertyGroup>
    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
    <Name>FutureNHS.Data.FutureNHS</Name>
    <SchemaVersion>2.0</SchemaVersion>
    <ProjectVersion>4.1</ProjectVersion>
    <ProjectGuid>{9497f274-3bb1-4194-8dc3-35594d0fd0ea}</ProjectGuid>
    <DSP>Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider</DSP>
    <OutputType>Database</OutputType>
    <RootPath />
    <RootNamespace>FutureNHS.Data.FutureNHS</RootNamespace>
    <AssemblyName>FutureNHS.Data.FutureNHS</AssemblyName>
    <ModelCollation>1033, CI</ModelCollation>
    <DefaultFileStructure>BySchemaAndSchemaType</DefaultFileStructure>
    <DeployToDatabase>True</DeployToDatabase>
    <TargetFrameworkVersion>v4.7.2</TargetFrameworkVersion>
    <TargetLanguage>CS</TargetLanguage>
    <AppDesignerFolder>Properties</AppDesignerFolder>
    <SqlServerVerification>False</SqlServerVerification>
    <IncludeCompositeObjects>True</IncludeCompositeObjects>
    <TargetDatabaseSet>True</TargetDatabaseSet>
    <RootNamespace>FutureNHS.Data.FutureNHS</RootNamespace>
    <TargetFrameworkVersion>v4.8</TargetFrameworkVersion>
  </PropertyGroup>
  <Import Condition="'$(NetCoreBuild)' == 'true'" Project="$(NETCoreTargetsPath)\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
  <Import Condition="'$(NetCoreBuild)' != 'true' AND '$(SQLDBExtensionsRefPath)' != ''" Project="$(SQLDBExtensionsRefPath)\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
  <Import Condition="'$(NetCoreBuild)' != 'true' AND '$(SQLDBExtensionsRefPath)' == ''" Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
  <ItemGroup>
    <Folder Include="Data" />
    <Folder Include="dbo" />
    <Folder Include="dbo\Stored Procedures" />
    <Folder Include="dbo\Tables" />
  </ItemGroup>
  <ItemGroup>
    <PostDeploy Include="Data\SeedData.sql" />
    <Build Include="dbo\Tables\Activity.sql" />
    <Build Include="dbo\Tables\BannedEmail.sql" />
    <Build Include="dbo\Tables\BannedWord.sql" />
    <Build Include="dbo\Tables\Category.sql" />
    <Build Include="dbo\Tables\File.sql" />
    <Build Include="dbo\Tables\FileStatus.sql" />
    <Build Include="dbo\Tables\Folder.sql" />
    <Build Include="dbo\Tables\GlobalPermissionForRole.sql" />
    <Build Include="dbo\Tables\Group.sql" />
    <Build Include="dbo\Tables\PlatformInvite.sql" />
    <Build Include="dbo\Tables\GroupInvites.sql" />
    <Build Include="dbo\Tables\GroupNotification.sql" />
    <Build Include="dbo\Tables\GroupPermissionForRole.sql" />
    <Build Include="dbo\Tables\GroupUser.sql" />
    <Build Include="dbo\Tables\Language.sql" />
    <Build Include="dbo\Tables\LocaleResourceKey.sql" />
    <Build Include="dbo\Tables\LocaleStringResource.sql" />
    <Build Include="dbo\Tables\MembershipRole.sql" />
    <Build Include="dbo\Tables\MembershipUser.sql" />
    <Build Include="dbo\Tables\MembershipUsersInRoles.sql" />
    <Build Include="dbo\Tables\Permission.sql" />
    <Build Include="dbo\Tables\Poll.sql" />
    <Build Include="dbo\Tables\PollAnswer.sql" />
    <Build Include="dbo\Tables\PollVote.sql" />
    <Build Include="dbo\Tables\Section.sql" />
    <Build Include="dbo\Tables\Settings.sql" />
    <Build Include="dbo\Tables\SystemPage.sql" />
    <Build Include="dbo\Tables\Discussion.sql" />
    <Build Include="dbo\Tables\Entity_Tag.sql" />
    <Build Include="dbo\Tables\DiscussionNotification.sql" />
    <Build Include="dbo\Tables\Tag.sql" />
    <Build Include="dbo\Tables\UploadedFile.sql" />
    <Build Include="dbo\Stored Procedures\sp_msforeachtable.sql" />
    <Build Include="dbo\Stored Procedures\usp_delete_folder.sql" />
    <Build Include="dbo\Tables\Image.sql" />
    <Build Include="dbo\Tables\GroupSite.sql" />
    <Build Include="dbo\Tables\Entity.sql" />
    <Build Include="dbo\Tables\Comment.sql" />
    <Build Include="dbo\Tables\Entity_Like.sql" />
    <Build Include="dbo\Tables\Entity_Favourite.sql" />
    <Build Include="dbo\Tables\Identity.sql" />
  </ItemGroup>
  <ItemGroup>
    <None Include="FutureNHS.Data.FutureNHS.publish.xml">
      <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
    </None>
    <None Include="FutureNHS.Data.FutureNHS-automated.publish.xml">
      <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
    </None>
  </ItemGroup>
  <ItemGroup>
    <PackageReference Condition="'$(NetCoreBuild)' == 'true'" Include="Microsoft.NETFramework.ReferenceAssemblies" Version="1.0.0" PrivateAssets="All" />
    <SqlCmdVariable Include="RunAutomatedScripts">
      <DefaultValue>false</DefaultValue>
      <Value>$(SqlCmdVar__1)</Value>
    </SqlCmdVariable>
  </ItemGroup>
  <Target Name="AfterClean">
    <Delete Files="Publish.sql" />
  </Target>
</Project>