text: ﻿<?xml version="1.0" encoding="utf-8"?>
  <Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0">
    <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />
    <PropertyGroup>
      <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
      <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
      <Name>FrontDeskDatabase</Name>
      <SchemaVersion>2.0</SchemaVersion>
      <ProjectVersion>4.1</ProjectVersion>
      <ProjectGuid>{357c4652-34cf-421f-a4b2-0a387acb4742}</ProjectGuid>
      <DSP>Microsoft.Data.Tools.Schema.Sql.Sql120DatabaseSchemaProvider</DSP>
      <OutputType>Database</OutputType>
      <RootPath>
      </RootPath>
      <RootNamespace>FrontDeskDatabase</RootNamespace>
      <AssemblyName>FrontDeskDatabase</AssemblyName>
      <ModelCollation>1033,CI</ModelCollation>
      <DefaultFileStructure>BySchemaAndSchemaType</DefaultFileStructure>
      <DeployToDatabase>True</DeployToDatabase>
      <TargetFrameworkVersion>v4.5.2</TargetFrameworkVersion>
      <TargetLanguage>CS</TargetLanguage>
      <AppDesignerFolder>Properties</AppDesignerFolder>
      <SqlServerVerification>False</SqlServerVerification>
      <IncludeCompositeObjects>True</IncludeCompositeObjects>
      <TargetDatabaseSet>True</TargetDatabaseSet>
      <DefaultCollation>SQL_Latin1_General_CP1_CI_AS</DefaultCollation>
      <DefaultFilegroup>PRIMARY</DefaultFilegroup>
    </PropertyGroup>
    <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
      <OutputPath>bin\Release\</OutputPath>
      <BuildScriptName>$(MSBuildProjectName).sql</BuildScriptName>
      <TreatWarningsAsErrors>False</TreatWarningsAsErrors>
      <DebugType>pdbonly</DebugType>
      <Optimize>true</Optimize>
      <DefineDebug>false</DefineDebug>
      <DefineTrace>true</DefineTrace>
      <ErrorReport>prompt</ErrorReport>
      <WarningLevel>4</WarningLevel>
    </PropertyGroup>
    <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
      <OutputPath>bin\Debug\</OutputPath>
      <BuildScriptName>$(MSBuildProjectName).sql</BuildScriptName>
      <TreatWarningsAsErrors>false</TreatWarningsAsErrors>
      <DebugSymbols>true</DebugSymbols>
      <DebugType>full</DebugType>
      <Optimize>false</Optimize>
      <DefineDebug>true</DefineDebug>
      <DefineTrace>true</DefineTrace>
      <ErrorReport>prompt</ErrorReport>
      <WarningLevel>4</WarningLevel>
    </PropertyGroup>
    <PropertyGroup>
      <VisualStudioVersion Condition="'$(VisualStudioVersion)' == ''">11.0</VisualStudioVersion>
      <!-- Default to the v11.0 targets path if the targets file for the current VS version is not found -->
      <SSDTExists Condition="Exists('$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets')">True</SSDTExists>
      <VisualStudioVersion Condition="'$(SSDTExists)' == ''">11.0</VisualStudioVersion>
    </PropertyGroup>
    <Import Condition="'$(SQLDBExtensionsRefPath)' != ''" Project="$(SQLDBExtensionsRefPath)\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
    <Import Condition="'$(SQLDBExtensionsRefPath)' == ''" Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
    <ItemGroup>
      <Folder Include="Properties" />
      <Folder Include="dbo\" />
      <Folder Include="dbo\Tables\" />
    </ItemGroup>
    <ItemGroup>
      <Build Include="dbo\Tables\Appointments.sql" />
      <Build Include="dbo\Tables\AppointmentTypes.sql" />
      <Build Include="dbo\Tables\Clients.sql" />
      <Build Include="dbo\Tables\Patients.sql" />
      <Build Include="dbo\Tables\Doctors.sql" />
      <Build Include="dbo\Tables\Rooms.sql" />
      <Build Include="dbo\Tables\Schedules.sql" />
      <Build Include="dbo\Tables\__MigrationHistory.sql" />
    </ItemGroup>
  </Project>