-
Notifications
You must be signed in to change notification settings - Fork 0
/
SensateIoT.SmartEnergy.Dsmr.Database.sqlproj
102 lines (102 loc) · 6.08 KB
/
SensateIoT.SmartEnergy.Dsmr.Database.sqlproj
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
<?xml version="1.0" encoding="utf-8"?>
<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0">
<PropertyGroup>
<Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
<Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
<Name>SensateIoT.SmartEnergy.Dsmr.Database</Name>
<SchemaVersion>2.0</SchemaVersion>
<ProjectVersion>4.1</ProjectVersion>
<ProjectGuid>{bb3b7ef9-d3a7-4f6c-aa12-cf9c13a9660c}</ProjectGuid>
<DSP>Microsoft.Data.Tools.Schema.Sql.Sql130DatabaseSchemaProvider</DSP>
<OutputType>Database</OutputType>
<RootPath>
</RootPath>
<RootNamespace>SensateIoT.SmartEnergy.Dsmr.Database</RootNamespace>
<AssemblyName>SensateIoT.SmartEnergy.Dsmr.Database</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>
<DacVersion>1.7.0.0</DacVersion>
<DacApplicationName>Dsmr</DacApplicationName>
<DacApplicationName>DSMR</DacApplicationName>
<Recovery>SIMPLE</Recovery>
<PageVerify>CHECKSUM</PageVerify>
<TargetFrameworkProfile />
</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>false</DefineTrace>
<ErrorReport>prompt</ErrorReport>
<WarningLevel>4</WarningLevel>
<TreatTSqlWarningsAsErrors>True</TreatTSqlWarningsAsErrors>
</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>
<TreatTSqlWarningsAsErrors>True</TreatTSqlWarningsAsErrors>
<RunSqlCodeAnalysis>True</RunSqlCodeAnalysis>
<SqlCodeAnalysisRules>+!Microsoft.Rules.Data.SR0001;+!Microsoft.Rules.Data.SR0004;+!Microsoft.Rules.Data.SR0005;+!Microsoft.Rules.Data.SR0006;+!Microsoft.Rules.Data.SR0007;+!Microsoft.Rules.Data.SR0008;+!Microsoft.Rules.Data.SR0009;+!Microsoft.Rules.Data.SR0010;+!Microsoft.Rules.Data.SR0011;+!Microsoft.Rules.Data.SR0012;+!Microsoft.Rules.Data.SR0013;+!Microsoft.Rules.Data.SR0014;+!Microsoft.Rules.Data.SR0015;+!Microsoft.Rules.Data.SR0016</SqlCodeAnalysisRules>
</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="Security" />
<Folder Include="dbo\Tables" />
<Folder Include="dbo\Types" />
<Folder Include="dbo\Stored Procedures" />
<Folder Include="dbo\Views" />
</ItemGroup>
<ItemGroup>
<Build Include="dbo\Tables\DataPoints.sql" />
<Build Include="dbo\Tables\ProcessingHistory.sql" />
<Build Include="dbo\Types\DataPoint.sql" />
<Build Include="dbo\Stored Procedures\DsmrProcessor_BulkInsertDataPoints.sql" />
<Build Include="dbo\Stored Procedures\DsmrProcessor_FinalizeBatch.sql" />
<Build Include="dbo\Stored Procedures\DsmrProcessor_InsertDataPoint.sql" />
<Build Include="dbo\Stored Procedures\DsmrProcessor_InsertProcessingTimestamp.sql" />
<Build Include="dbo\Stored Procedures\DsmrProcessor_SelectLastProcessedBySensorId.sql" />
<Build Include="Security\db_processor.sql" />
<Build Include="dbo\Views\EnvironmentDataHourlyAverages.sql" />
<Build Include="dbo\Views\PowerDataHourlyAverages.sql" />
<Build Include="Security\db_dsmrapi.sql" />
<Build Include="dbo\Stored Procedures\DsmrApi_SelectDataPoints.sql" />
<Build Include="dbo\Stored Procedures\DsmrApi_SelectEnvironmentDailyAverages.sql" />
<Build Include="dbo\Stored Procedures\DsmrApi_SelectHourlyEnvironmentDataAverages.sql" />
<Build Include="dbo\Stored Procedures\DsmrApi_SelectHourlyPowerDataAverages.sql" />
<Build Include="dbo\Stored Procedures\DsmrApi_SelectLastData.sql" />
<Build Include="dbo\Stored Procedures\DsmrApi_SelectPowerDailyAverages.sql" />
<Build Include="dbo\Stored Procedures\DsmrApi_SelectWeeklyHigh.sql" />
<Build Include="dbo\Stored Procedures\DsmrApi_SelectPowerDataByHour.sql" />
<Build Include="dbo\Stored Procedures\DsmrApi_SelectEnergyDataBetween.sql" />
<Build Include="dbo\Stored Procedures\DsmrApi_ComputeDeviceCapabilities.sql" />
<Build Include="dbo\Stored Procedures\DsmrApi_SelectAverageEnergyDataPerHour.sql" />
<Build Include="DsmrApi_SelectAverageEnergyPerHour.sql" />
</ItemGroup>
</Project>