813 lines
32 KiB
XML
813 lines
32 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>GimDB</Name>
|
|
<SchemaVersion>2.0</SchemaVersion>
|
|
<ProjectVersion>4.1</ProjectVersion>
|
|
<ProjectGuid>{a3141577-5116-4ffb-8c3e-557644ca98e0}</ProjectGuid>
|
|
<DSP>Microsoft.Data.Tools.Schema.Sql.Sql110DatabaseSchemaProvider</DSP>
|
|
<OutputType>Database</OutputType>
|
|
<RootPath>
|
|
</RootPath>
|
|
<RootNamespace>GimDB</RootNamespace>
|
|
<AssemblyName>GimDB</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>
|
|
<DefaultCollation>Latin1_General_CI_AS</DefaultCollation>
|
|
<AnsiNulls>False</AnsiNulls>
|
|
<QuotedIdentifier>False</QuotedIdentifier>
|
|
<Containment>None</Containment>
|
|
<IsNestedTriggersOn>True</IsNestedTriggersOn>
|
|
<IsTransformNoiseWordsOn>False</IsTransformNoiseWordsOn>
|
|
<TwoDigitYearCutoff>2049</TwoDigitYearCutoff>
|
|
<NonTransactedFileStreamAccess>OFF</NonTransactedFileStreamAccess>
|
|
<TargetRecoveryTimePeriod>0</TargetRecoveryTimePeriod>
|
|
<TargetRecoveryTimeUnit>SECONDS</TargetRecoveryTimeUnit>
|
|
<IsChangeTrackingOn>False</IsChangeTrackingOn>
|
|
<IsChangeTrackingAutoCleanupOn>True</IsChangeTrackingAutoCleanupOn>
|
|
<ChangeTrackingRetentionPeriod>2</ChangeTrackingRetentionPeriod>
|
|
<ChangeTrackingRetentionUnit>Days</ChangeTrackingRetentionUnit>
|
|
<IsEncryptionOn>False</IsEncryptionOn>
|
|
<IsBrokerPriorityHonored>False</IsBrokerPriorityHonored>
|
|
<Trustworthy>False</Trustworthy>
|
|
<AutoUpdateStatisticsAsynchronously>False</AutoUpdateStatisticsAsynchronously>
|
|
<PageVerify>CHECKSUM</PageVerify>
|
|
<ServiceBrokerOption>DisableBroker</ServiceBrokerOption>
|
|
<DateCorrelationOptimizationOn>False</DateCorrelationOptimizationOn>
|
|
<Parameterization>SIMPLE</Parameterization>
|
|
<AllowSnapshotIsolation>False</AllowSnapshotIsolation>
|
|
<ReadCommittedSnapshot>False</ReadCommittedSnapshot>
|
|
<VardecimalStorageFormatOn>True</VardecimalStorageFormatOn>
|
|
<SupplementalLoggingOn>False</SupplementalLoggingOn>
|
|
<CompatibilityMode>90</CompatibilityMode>
|
|
<AnsiNullDefault>False</AnsiNullDefault>
|
|
<AnsiPadding>False</AnsiPadding>
|
|
<AnsiWarnings>False</AnsiWarnings>
|
|
<ArithAbort>False</ArithAbort>
|
|
<ConcatNullYieldsNull>False</ConcatNullYieldsNull>
|
|
<NumericRoundAbort>False</NumericRoundAbort>
|
|
<RecursiveTriggersEnabled>False</RecursiveTriggersEnabled>
|
|
<DatabaseChaining>False</DatabaseChaining>
|
|
<DatabaseState>ONLINE</DatabaseState>
|
|
<CloseCursorOnCommitEnabled>False</CloseCursorOnCommitEnabled>
|
|
<DefaultCursor>GLOBAL</DefaultCursor>
|
|
<AutoClose>False</AutoClose>
|
|
<AutoCreateStatistics>True</AutoCreateStatistics>
|
|
<AutoShrink>False</AutoShrink>
|
|
<AutoUpdateStatistics>True</AutoUpdateStatistics>
|
|
<TornPageDetection>False</TornPageDetection>
|
|
<DatabaseAccess>MULTI_USER</DatabaseAccess>
|
|
<Recovery>SIMPLE</Recovery>
|
|
<EnableFullTextSearch>False</EnableFullTextSearch>
|
|
<DefaultFilegroup>PRIMARY</DefaultFilegroup>
|
|
<CreateProjectFromDatabaseCompleted>True</CreateProjectFromDatabaseCompleted>
|
|
</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' ">
|
|
<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\" />
|
|
<Folder Include="dbo\Views\" />
|
|
<Folder Include="dwh\" />
|
|
<Folder Include="dwh\Views\" />
|
|
<Folder Include="export\" />
|
|
<Folder Include="export\Views\" />
|
|
<Folder Include="Security\" />
|
|
<Folder Include="dbo\Functions\" />
|
|
<Folder Include="dbo\Stored Procedures\" />
|
|
<Folder Include="voc\" />
|
|
<Folder Include="voc\Stored Procedures\" />
|
|
<Folder Include="som_ita\" />
|
|
<Folder Include="som_ita\Tables\" />
|
|
<Folder Include="import\" />
|
|
<Folder Include="import\Stored Procedures\" />
|
|
</ItemGroup>
|
|
<ItemGroup>
|
|
<Build Include="dbo\Tables\AnagTipoGuasto.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\InterventiMtz.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagFrequenze.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagLocazioni.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagItems.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\tmp_importaMacchine.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\CDC.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagEventi.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\FUNZIONE.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagStati.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\Lingue.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\Tra_Ev2Stati.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\MODULO.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\UTENTE.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\Vocabolario.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagPeriodi.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\DIRITTI.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\CalendFesteFerie.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagTipoRisorsa.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\FiltroImpianti.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\FiltroMacchine.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\FiltroStati.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagCausali.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagrOperMtz.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\InterventoOpMtz.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\Permessi.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\Permessi2Funzione.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\LogUpdateDb.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\ImpiegoRisorse.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagAmbitoGuasto.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagClasseTurno.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagImpianti.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagTurni.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagSemafori.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\OreAperturaSettTurni.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\OreChiusuraSett.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagPriorita.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\OreAperturaSett.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\ListValues.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\Macchine2FamMacchine.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\MtzProgrammata.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagFamMacchine.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\MtzProgPending.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selFreq.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_reportSemestraleFix.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dwh\Views\VDWH_ElencoInterventi.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_mtzProgExp.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dwh\Views\VDWH_AnagStati.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dwh\Views\VDWH_DettaglioInterv_OLD.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dwh\Views\VDWH_IntervOperatori.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selStato.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_vocabolario.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selPeriodiTrad.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_interventiErogati.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_datiMTBFMTTR.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selUtentiAll.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selUtentiShort.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selUtentiShortAD.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selFam.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_mtzProgPendingExp.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selOperMtz.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selPrior.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selAmbiti.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selCausaliMacchine.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selTipoGuasto.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_intervExp.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selAnTipoRis.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selSemafori.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_risorseImpiegate.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="export\Views\v_allData.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dwh\Views\VDWH_ImpiegoRisorse.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selImpianti.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selMacchine.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_macchine.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selListVal.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_selFamMacc.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_elencoImpiantiMacchine.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_elencoIntervFilt.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Functions\f_fixCR.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Functions\f_padLeft.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Functions\rightDivision.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Functions\f_dateOnly.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Functions\f_diffOreLavorative.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_MtzProg_delete.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\spt_AD_delete.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_vscm_getByConditio.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_vscm_getByConditioAndCurr.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_vie_getByPeriodoSearch.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\sp_updateIntervento.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\sp_updateInterventoFull.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\sp_elencoIntMTBF_MTTR.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\clonaDirittiUser.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\clonaDirittiUserModulo.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_insNewLemma.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="voc\Stored Procedures\stp_getByLingua.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="voc\Stored Procedures\stp_getByLinguaLemmaLike.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="voc\Stored Procedures\stp_insNewLemma.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="voc\Stored Procedures\stp_updateQuery.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="voc\Stored Procedures\stp_upsertLemma.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="voc\Stored Procedures\stp_voUpdateLemmiReport.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_ATR_insert.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_ATR_delete.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_ATR_update.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\sp_caricaUpdateMAcchine.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_ImpRis_delete.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_ImpRis_update.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_ImpRis_insert.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\sp_IndiciAndShrink.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_elencoIntByIntervDate.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_elencoIntByIntervDateUserFilt.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_elencoIntByIntervDateUserFilt_fermaPrev.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_elencoIntMTBF_MTTR_fermaPrev.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\sp_insRichiesta.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\sp_setPresaInCarico.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_ImpRis_getByNumMtz.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\sp_procStatEv.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_elencoIntByIntervDateUserFiltExtended.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_oreEquivalenti.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\sp_clonaImpianto.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_listValues_getValidValuesTrad.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_listValues_getValidValuesFilt.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\sp_spostaMacchina.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_listValues_getValidValues.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\sp_clonaMacchina.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_listValues_getDistTable.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_MtzProg_duplica.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_listValues_getByTable.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_MtzProg_update.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_MtzProg_getByKey.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_MtzProg_insert.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="Security\dwh.sql" />
|
|
<Build Include="Security\export.sql" />
|
|
<Build Include="Security\voc.sql" />
|
|
<Build Include="dbo\Tables\MovMagRic.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\MagRic.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="som_ita\Tables\tmp_ImportRic_A.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="som_ita\Tables\tmp_ImportRic_B.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="Security\som_ita.sql" />
|
|
<Build Include="dbo\Views\v_StatoMag.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_movMagPend.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_StatoMag_update.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_StatoMag_insert.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_StatoMag_delete.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_AnLoc_updateQuery.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_AnLoc_insertQuery.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_AnLoc_deleteQuery.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="Security\RoleMemberships.sql" />
|
|
<Build Include="dbo\Tables\Tag2Macc.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\Tag2Item.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\SinonimiTag.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Tables\AnagTags.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Views\v_MovMagExpl.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_StatoMag_getByIdxMacchina.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_StatoMag_getByDescr.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_SinTag_UpdateQuery.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_MovMag_update.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_MovMag_insert.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_MovMag_getByNumInt.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_MovMag_delete.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_AnTag_updateQuery.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_AnTag_insertQuery.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_AnTag_getByKey.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_AnTag_deleteQuery.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_AnTag_avail4Item.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_AnItems_getByTag.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_AM_getByTag.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="Security\steamware.sql" />
|
|
<Build Include="Security\import.sql" />
|
|
<Build Include="import\Stored Procedures\stp_importMagRic_step3.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="import\Stored Procedures\stp_importMagRic_step2.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="import\Stored Procedures\stp_importMagRic_step1.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_VSM_avail4Tag.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_T2M_getByTag.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_T2M_deleteByTag.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_T2I_getByTag.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
<Build Include="dbo\Stored Procedures\stp_T2I_getByIdxItem.sql">
|
|
<AnsiNulls>On</AnsiNulls>
|
|
<QuotedIdentifier>On</QuotedIdentifier>
|
|
</Build>
|
|
</ItemGroup>
|
|
<ItemGroup>
|
|
<None Include="LiveDb2File.scmp" />
|
|
<None Include="GIM_GIM_SomIta_01.dcmp" />
|
|
</ItemGroup>
|
|
</Project> |