set xact_abort on;
go

begin transaction;
go

alter table AnagKeyValue alter column
  valString nvarchar(250);
go

alter table AnagKeyValue add
  constraint DF_AnagKeyValue_valInt default ((0)) for valInt,
  constraint DF_AnagKeyValue_descrizione default ('-') for descrizione,
  constraint DF_AnagKeyValue_valFloat default ((0)) for valFloat,
  constraint DF_AnagKeyValue_valString default ('') for valString;
go

commit;
go


set xact_abort on;
go

begin transaction;
go

alter table Dipendenti add
  dataAssunzione date constraint DF_Dipendenti_dataAssunzione default ('1900-01-01'),
  dataCessazione date constraint DF_Dipendenti_dataCessazione default ('9999-12-31'),
  attivo bit constraint DF_Dipendenti_attivo default ((1));
go

update Dipendenti set dataAssunzione=('1900-01-01'),dataCessazione=('9999-12-31'),attivo=((1));
go

set ANSI_NULLS on;
go

-- =============================================
-- Author:		S.E. Locatelli
-- Create date: 2013-03-25
-- Description:	Recupero elenco dip attivi
-- =============================================
create PROCEDURE stp_Dip_getAttivi
AS
	SET NOCOUNT ON;
SELECT      *
FROM        Dipendenti
WHERE       (attivo = 1)
go

commit;
go


set xact_abort on;
go

begin transaction;
go

set ANSI_NULLS on;
go

/**********************************************************
* STORED stp_AKV_getByKey
*
* elenco valori da chiave x tab anagrafica key/val
*
* mod: S.E.L. 2013.03.25
*
**********************************************************/
create PROCEDURE stp_AKV_getByKey
(
	@nomeVar	NVARCHAR(50)
)
AS
	SET NOCOUNT ON;

SELECT   nomeVar
		,ISNULL(valInt,0) AS valInt
		,ISNULL(valFloat,0) AS valFloat
		,ISNULL(valString,'') AS valString
		,ISNULL(descrizione,'') AS descrizione
FROM AnagKeyValue
WHERE   nomeVar = @nomeVar
go

commit;
go

set xact_abort on
go

begin transaction
go

UPDATE dbo.AnagKeyValue SET 
  valFloat=0, valString=N''
  WHERE nomeVar=N'minutiRound'
UPDATE dbo.AnagKeyValue SET 
  valFloat=0, valString=N''
  WHERE nomeVar=N'minutiRoundDay'
UPDATE dbo.AnagKeyValue SET 
  valFloat=0, valString=N''
  WHERE nomeVar=N'minutiRoundExtraFascia'
INSERT INTO dbo.AnagKeyValue
  VALUES (N'appMode', 0, 0, N'runtime', N'modalità applicazione (runtime)')
INSERT INTO dbo.AnagKeyValue
  VALUES (N'installazione', 0, 0, N'ETS', N'nome installazione')
INSERT INTO dbo.AnagKeyValue
  VALUES (N'ETS', 10, 0, N'+FBqyG1V4kqbqYe/IO7KywpmR9YzujB0', N'licenze e codice auth applicativo')
go

commit transaction
go






-- registro versione...
INSERT INTO [dbo].[LogUpdateDb] ([Versione],[Data]) VALUES(320, GETDATE())
GO
SELECT * FROM LogUpdateDb ORDER BY Versione DESC