-
Notifications
You must be signed in to change notification settings - Fork 0
/
POC.Database.sqlproj
114 lines (114 loc) · 5.93 KB
/
POC.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
103
104
105
106
107
108
109
110
111
112
113
114
<?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>POC.Database</Name>
<SchemaVersion>2.0</SchemaVersion>
<ProjectVersion>4.1</ProjectVersion>
<ProjectGuid>{19246df1-8f0e-46ce-9ea6-92b0955bf31f}</ProjectGuid>
<DSP>Microsoft.Data.Tools.Schema.Sql.Sql110DatabaseSchemaProvider</DSP>
<OutputType>Database</OutputType>
<RootPath>
</RootPath>
<RootNamespace>WebTimeSheetDatabase</RootNamespace>
<AssemblyName>WebTimeSheetDatabase</AssemblyName>
<ModelCollation>1033, CI</ModelCollation>
<DefaultFileStructure>BySchemaAndSchemaType</DefaultFileStructure>
<DeployToDatabase>True</DeployToDatabase>
<TargetFrameworkVersion>v4.6.1</TargetFrameworkVersion>
<TargetLanguage>CS</TargetLanguage>
<AppDesignerFolder>Properties</AppDesignerFolder>
<SqlServerVerification>False</SqlServerVerification>
<IncludeCompositeObjects>True</IncludeCompositeObjects>
<TargetDatabaseSet>True</TargetDatabaseSet>
<ValidateCasingOnIdentifiers>False</ValidateCasingOnIdentifiers>
</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\Stored Procedures" />
<Folder Include="dbo\Tables" />
<Folder Include="Scripts" />
<Folder Include="Scripts\Post-Deployment" />
</ItemGroup>
<ItemGroup>
<Build Include="dbo\Stored Procedures\ELMAH_GetErrorsXml.sql" />
<Build Include="dbo\Stored Procedures\ELMAH_GetErrorXml.sql" />
<Build Include="dbo\Stored Procedures\ELMAH_LogError.sql" />
<Build Include="dbo\Stored Procedures\GetDescriptionbyTimeSheetMasterID.sql" />
<Build Include="dbo\Stored Procedures\Usp_ChangeTimesheetStatus.sql" />
<Build Include="dbo\Stored Procedures\Usp_GetHoursbyTimeSheetMasterID.sql" />
<Build Include="dbo\Stored Procedures\Usp_GetTimeSheetbyFromDateandToDateTimeSheet.sql" />
<Build Include="dbo\Stored Procedures\Usp_GetTimeSheetMasterIDTimeSheet.sql" />
<Build Include="dbo\Stored Procedures\Usp_GetWeekTimeSheetDetailsByDateRange.sql" />
<Build Include="dbo\Tables\AssignedRoles.sql" />
<Build Include="dbo\Tables\AuditTB.sql" />
<Build Include="dbo\Tables\Department.sql" />
<Build Include="dbo\Tables\DescriptionTB.sql" />
<Build Include="dbo\Tables\Documents.sql" />
<Build Include="dbo\Tables\ELMAH_Error.sql" />
<Build Include="dbo\Tables\Expense.sql" />
<Build Include="dbo\Tables\ExpenseAuditTB.sql" />
<Build Include="dbo\Tables\Jobs.sql" />
<Build Include="dbo\Tables\Locations.sql" />
<Build Include="dbo\Tables\NotificationsTB.sql" />
<Build Include="dbo\Tables\ProjectMaster.sql" />
<Build Include="dbo\Tables\Registration.sql" />
<Build Include="dbo\Tables\Roles.sql" />
<Build Include="dbo\Tables\Task.sql" />
<Build Include="dbo\Tables\TimeSheetAuditTB.sql" />
<Build Include="dbo\Tables\TimeSheetDetails.sql" />
<Build Include="dbo\Tables\TimeSheetMaster.sql" />
<None Include="Scripts\Post-Deployment\dbo.Jobs.sql" />
<None Include="Scripts\Post-Deployment\dbo.Department.sql" />
<None Include="Scripts\Post-Deployment\dbo.Registration.sql" />
<None Include="Scripts\Post-Deployment\dbo.Roles.sql" />
<Build Include="dbo\Tables\AssignedProjects.sql" />
<Build Include="dbo\Tables\DocumentType.sql" />
<None Include="Scripts\Post-Deployment\dbo.DocumentTypes.sql" />
</ItemGroup>
<ItemGroup>
<PostDeploy Include="Scripts\Post-Deployment\POCDatabase.PostDeployment.sql">
<CopyToOutputDirectory>DoNotCopy</CopyToOutputDirectory>
</PostDeploy>
</ItemGroup>
<ItemGroup>
<None Include="POC.Database.jfm" />
<None Include="POC.Database.sqlproj.user" />
<None Include=".gitignore" />
<None Include="POC.Database.publish.xml" />
</ItemGroup>
</Project>