160 lines
8.5 KiB
XML
160 lines
8.5 KiB
XML
<?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>Knoks.PriceDB</Name>
|
|
<SchemaVersion>2.0</SchemaVersion>
|
|
<ProjectVersion>4.1</ProjectVersion>
|
|
<ProjectGuid>{a89709be-f3de-4ea1-9c56-0f85d3ef41c0}</ProjectGuid>
|
|
<DSP>Microsoft.Data.Tools.Schema.Sql.Sql130DatabaseSchemaProvider</DSP>
|
|
<OutputType>Database</OutputType>
|
|
<RootPath>
|
|
</RootPath>
|
|
<RootNamespace>Knoks.PriceDB</RootNamespace>
|
|
<AssemblyName>Knoks.PriceDB</AssemblyName>
|
|
<ModelCollation>1033, CI</ModelCollation>
|
|
<DefaultFileStructure>BySchemaAndSchemaType</DefaultFileStructure>
|
|
<DeployToDatabase>True</DeployToDatabase>
|
|
<TargetFrameworkVersion>v4.5</TargetFrameworkVersion>
|
|
<TargetLanguage>CS</TargetLanguage>
|
|
<AppDesignerFolder>Properties</AppDesignerFolder>
|
|
<SqlServerVerification>False</SqlServerVerification>
|
|
<IncludeCompositeObjects>True</IncludeCompositeObjects>
|
|
<TargetDatabaseSet>True</TargetDatabaseSet>
|
|
</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="Scripts" />
|
|
<Folder Include="Functions" />
|
|
<Folder Include="Stored Procedures" />
|
|
<Folder Include="Tables" />
|
|
<Folder Include="User Defined Types" />
|
|
</ItemGroup>
|
|
<ItemGroup>
|
|
<Build Include="Functions\fnc_CRT_EndIntervalDate.sql" />
|
|
<Build Include="Functions\fnc_CRT_RoundDate.sql" />
|
|
<Build Include="Functions\fnc_CRT_StartIntervalDate.sql" />
|
|
<Build Include="Stored Procedures\Charts_HistoricalData_Process.sql" />
|
|
<Build Include="Stored Procedures\CRT_Agg_All_Except1Minute.sql" />
|
|
<Build Include="Stored Procedures\CRT_BreakDownUnitDefinition.sql" />
|
|
<Build Include="Stored Procedures\CRT_UpdateTasks_LastRun.sql" />
|
|
<Build Include="Stored Procedures\GetData.sql" />
|
|
<Build Include="Stored Procedures\GetExchanges.sql" />
|
|
<Build Include="Stored Procedures\USP_ChartsTemplate_AddOrUpdate.sql" />
|
|
<Build Include="Stored Procedures\USP_ChartsTemplate_Delete.sql" />
|
|
<Build Include="Stored Procedures\USP_ChartsTemplate_GetChart.sql" />
|
|
<Build Include="Stored Procedures\USP_ChartsTemplate_GetChartList.sql" />
|
|
<Build Include="Stored Procedures\USP_CRT_Agg_1Minute.sql" />
|
|
<Build Include="Stored Procedures\USP_CRT_Agg_1Minute_2016_11_30.sql" />
|
|
<Build Include="Stored Procedures\USP_CRT_Agg_1Minute_OLD.sql" />
|
|
<Build Include="Stored Procedures\USP_CRT_GetData.sql" />
|
|
<Build Include="Stored Procedures\USP_CRT_GetData_LastBars.sql" />
|
|
<Build Include="Stored Procedures\USP_CRT_GetLiveData.sql" />
|
|
<Build Include="Stored Procedures\USP_CRT_LiveChartDataInit.sql" />
|
|
<Build Include="Stored Procedures\USP_CRT_LiveChartProcess.sql" />
|
|
<Build Include="Stored Procedures\USP_StudyTemplate_AddOrUpdate.sql" />
|
|
<Build Include="Stored Procedures\USP_StudyTemplate_Delete.sql" />
|
|
<Build Include="Stored Procedures\USP_StudyTemplate_GetNames.sql" />
|
|
<Build Include="Stored Procedures\USP_StudyTemplate_GetStudy.sql" />
|
|
<Build Include="Stored Procedures\USP_UTIL_CRT_ReAggDay.sql" />
|
|
<Build Include="Stored Procedures\USP_UTIL_CRT_Validation.sql" />
|
|
<Build Include="Stored Procedures\USP_UTIL_CRT_Validation_5min.sql" />
|
|
<Build Include="Stored Procedures\USP_UTIL_INIT_CRT_LastQuote.sql" />
|
|
<Build Include="Tables\ChartsTemplate.sql" />
|
|
<Build Include="Tables\CRT_Data_15Minutes.sql" />
|
|
<Build Include="Tables\CRT_Data_1Day.sql" />
|
|
<Build Include="Tables\CRT_Data_1Hour.sql" />
|
|
<Build Include="Tables\CRT_Data_1Minute.sql" />
|
|
<Build Include="Tables\CRT_Data_1Month.sql" />
|
|
<Build Include="Tables\CRT_Data_1Week.sql" />
|
|
<Build Include="Tables\CRT_Data_2Hours.sql" />
|
|
<Build Include="Tables\CRT_Data_30Minutes.sql" />
|
|
<Build Include="Tables\CRT_Data_4Hours.sql" />
|
|
<Build Include="Tables\CRT_Data_5Minutes.sql" />
|
|
<Build Include="Tables\CRT_Data_8Hours.sql" />
|
|
<Build Include="Tables\CRT_Data_LiveChart.sql" />
|
|
<Build Include="Tables\CRT_LastQuote.sql" />
|
|
<Build Include="Tables\CRT_Tasks.sql" />
|
|
<Build Include="Tables\Eli_Daily_Nov16.sql" />
|
|
<Build Include="Tables\Eli_Monthly_Nov16.sql" />
|
|
<Build Include="Tables\Eli_Weekly_Nov16.sql" />
|
|
<Build Include="Tables\ETF-Daily-Nov16.sql" />
|
|
<Build Include="Tables\Exchanges.sql" />
|
|
<Build Include="Tables\HistData.sql" />
|
|
<Build Include="Tables\MinIds.sql" />
|
|
<Build Include="Tables\StudyTemplate.sql" />
|
|
<Build Include="Tables\TMP_CRT_Data_1Month.sql" />
|
|
<Build Include="Tables\TMP_Data_15Minutes.sql" />
|
|
<Build Include="Tables\TMP_Data_1Day.sql" />
|
|
<Build Include="Tables\TMP_Data_1Hour.sql" />
|
|
<Build Include="Tables\TMP_Data_1Minute.sql" />
|
|
<Build Include="Tables\TMP_Data_1Month.sql" />
|
|
<Build Include="Tables\TMP_Data_1Week.sql" />
|
|
<Build Include="Tables\TMP_Data_30Minutes.sql" />
|
|
<Build Include="Tables\TMP_Data_4Hours.sql" />
|
|
<Build Include="Tables\TMP_Data_5Minutes.sql" />
|
|
<Build Include="Tables\YP_CRT_Data_15Minutes.sql" />
|
|
<Build Include="Tables\YP_CRT_Data_1Day.sql" />
|
|
<Build Include="Tables\YP_CRT_Data_1Hour.sql" />
|
|
<Build Include="Tables\YP_CRT_Data_1Minute.sql" />
|
|
<Build Include="Tables\YP_CRT_Data_1Month.sql" />
|
|
<Build Include="Tables\YP_CRT_Data_1Week.sql" />
|
|
<Build Include="Tables\YP_CRT_Data_2Hours.sql" />
|
|
<Build Include="Tables\YP_CRT_Data_30Minutes.sql" />
|
|
<Build Include="Tables\YP_CRT_Data_4Hours.sql" />
|
|
<Build Include="Tables\YP_CRT_Data_5Minutes.sql" />
|
|
<Build Include="Tables\YP_CRT_Data_8Hours.sql" />
|
|
<Build Include="Stored Procedures\Agg_1Minute.sql" />
|
|
<Build Include="User Defined Types\ReceivedRateList.sql" />
|
|
<Build Include="Tables\ActivePair.sql" />
|
|
<Build Include="Stored Procedures\GetActivePair.sql" />
|
|
<Build Include="Stored Procedures\Get1Hour.sql" />
|
|
<Build Include="Stored Procedures\Get1Day.sql" />
|
|
<Build Include="Stored Procedures\RecalcAggregations.sql" />
|
|
<Build Include="User Defined Types\LiveRateSearchItemsList.sql" />
|
|
<Build Include="Stored Procedures\KST_GetUpdatedLiveRates.sql" />
|
|
<Build Include="Stored Procedures\ExchangeStartValues.sql" />
|
|
</ItemGroup>
|
|
<ItemGroup>
|
|
<None Include="localdb.publish.xml" />
|
|
</ItemGroup>
|
|
<ItemGroup>
|
|
<PostDeploy Include="Scripts\01 LogicEntities.sql" />
|
|
</ItemGroup>
|
|
<ItemGroup>
|
|
<RefactorLog Include="Knoks.PriceDB.refactorlog" />
|
|
</ItemGroup>
|
|
</Project> |