Egalware/C.TRACK
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
develop
C.TRACK/DB/DB_STRUC_DATA_2018.09.05.sql
T
Samuele E. Locatelli 4b6d2ef6a0 Aggiunta script creazione iniziale DB
2018-09-05 16:00:33 +02:00

2505 lines
198 KiB
Transact-SQL
Raw Permalink Blame History

USE [master]
GO
/****** Object: Database [C_TRACK] Script Date: 05/09/2018 15:49:28 ******/
-- CREATE DATABASE [C_TRACK]
-- CONTAINMENT = NONE
-- ON PRIMARY
-- ( NAME = N'C_TRACK', FILENAME = N'G:\SQL2016Data\C_TRACK.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
-- LOG ON
-- ( NAME = N'C_TRACK_log', FILENAME = N'F:\SQL2016Log\C_TRACK_log.ldf' , SIZE = 73728KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
-- GO
ALTER DATABASE [C_TRACK] SET COMPATIBILITY_LEVEL = 110
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [C_TRACK].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [C_TRACK] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [C_TRACK] SET ANSI_NULLS OFF
GO
ALTER DATABASE [C_TRACK] SET ANSI_PADDING OFF
GO
ALTER DATABASE [C_TRACK] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [C_TRACK] SET ARITHABORT OFF
GO
ALTER DATABASE [C_TRACK] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [C_TRACK] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [C_TRACK] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [C_TRACK] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [C_TRACK] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [C_TRACK] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [C_TRACK] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [C_TRACK] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [C_TRACK] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [C_TRACK] SET DISABLE_BROKER
GO
ALTER DATABASE [C_TRACK] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [C_TRACK] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [C_TRACK] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [C_TRACK] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [C_TRACK] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [C_TRACK] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [C_TRACK] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [C_TRACK] SET RECOVERY FULL
GO
ALTER DATABASE [C_TRACK] SET MULTI_USER
GO
ALTER DATABASE [C_TRACK] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [C_TRACK] SET DB_CHAINING OFF
GO
ALTER DATABASE [C_TRACK] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [C_TRACK] SET TARGET_RECOVERY_TIME = 60 SECONDS
GO
EXEC sys.sp_db_vardecimal_storage_format N'C_TRACK', N'ON'
GO
USE [C_TRACK]
GO
/****** Object: Table [dbo].[AnagDevices] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AnagDevices](
[IdxDevice] [int] IDENTITY(1,1) NOT NULL,
[DeviceSecret] [nvarchar](500) NOT NULL,
[USER_NAME] [nvarchar](50) NOT NULL,
[DeviceName] [nvarchar](50) NOT NULL,
[Description] [nvarchar](500) NULL,
[dataOraEnabled] [datetime] NOT NULL,
[dataOraLastSeen] [datetime] NOT NULL,
[lastIPv4] [nvarchar](15) NULL,
[UsrName] AS ([USER_NAME]),
CONSTRAINT [PK_AnagDevices] PRIMARY KEY CLUSTERED
(
[IdxDevice] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[AnagEventi] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AnagEventi](
[CodEvento] [nvarchar](50) NOT NULL,
[CodTipoEvento] [nvarchar](50) NULL,
[DescrEvento] [nvarchar](50) NULL,
[Action] [nvarchar](50) NULL,
CONSTRAINT [PK_Eventi_1] PRIMARY KEY CLUSTERED
(
[CodEvento] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[AnagFamStati] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AnagFamStati](
[FamStato] [nvarchar](50) NOT NULL,
[DescrFam] [nvarchar](50) NULL,
CONSTRAINT [PK_AnagFamStati] PRIMARY KEY CLUSTERED
(
[FamStato] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[AnagFasi] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AnagFasi](
[CodFase] [nvarchar](50) NOT NULL,
[DescrFase] [nvarchar](50) NOT NULL,
[CloseTask] [bit] NOT NULL,
[TimeRec] [bit] NOT NULL,
CONSTRAINT [PK_AnagFasi] PRIMARY KEY CLUSTERED
(
[CodFase] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[AnagOpr] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AnagOpr](
[CodOpr] [nvarchar](50) NOT NULL,
[Cognome] [nvarchar](50) NULL,
[Nome] [nvarchar](50) NULL,
CONSTRAINT [PK_AnagOpr] PRIMARY KEY CLUSTERED
(
[CodOpr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[AnagPost] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AnagPost](
[CodPost] [nvarchar](50) NOT NULL,
[Descrizione] [nvarchar](50) NOT NULL,
[PreselFasi] [nvarchar](50) NOT NULL,
[CodOpr] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_AnagPost] PRIMARY KEY CLUSTERED
(
[CodPost] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[AnagStati] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AnagStati](
[CodStato] [nvarchar](50) NOT NULL,
[FamStato] [nvarchar](50) NOT NULL,
[DescrStato] [nvarchar](50) NULL,
[PrioritaStato] [int] NULL,
CONSTRAINT [PK_AnagStati] PRIMARY KEY CLUSTERED
(
[CodStato] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[AnagTipoEventi] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AnagTipoEventi](
[CodTipoEvento] [nvarchar](50) NOT NULL,
[DescrTipoEv] [nvarchar](50) NULL,
CONSTRAINT [PK_AnagTipoEventi] PRIMARY KEY CLUSTERED
(
[CodTipoEvento] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Config] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Config](
[chiave] [nvarchar](50) NOT NULL,
[valore] [nvarchar](250) NULL,
[note] [nvarchar](250) NULL,
CONSTRAINT [PK_Config] PRIMARY KEY CLUSTERED
(
[chiave] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 95) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[DIRITTI] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DIRITTI](
[USER_NAME] [nvarchar](50) NOT NULL,
[COD_CDC] [nvarchar](50) NOT NULL,
[COD_MODULO] [nvarchar](31) NOT NULL,
[COD_FUNZIONE] [nvarchar](31) NOT NULL,
[VALUE] [varchar](255) NULL,
CONSTRAINT [PK_DIRITTI] PRIMARY KEY CLUSTERED
(
[USER_NAME] ASC,
[COD_CDC] ASC,
[COD_MODULO] ASC,
[COD_FUNZIONE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[FUNZIONE] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FUNZIONE](
[COD_FUNZIONE] [nvarchar](31) NOT NULL,
[DESCRIZIONE] [nvarchar](500) NULL,
CONSTRAINT [PK_FUNZIONE] PRIMARY KEY CLUSTERED
(
[COD_FUNZIONE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Lingue] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Lingue](
[Lingua] [nvarchar](3) NOT NULL,
[DescrizioneLingua] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Lingue] PRIMARY KEY CLUSTERED
(
[Lingua] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[MODULO] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MODULO](
[COD_MODULO] [nvarchar](31) NOT NULL,
[DESCRIZIONE] [varchar](200) NULL,
CONSTRAINT [PK_MODULO] PRIMARY KEY CLUSTERED
(
[COD_MODULO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Permessi] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Permessi](
[COD_PERMESSO] [varchar](50) NOT NULL,
[URL] [varchar](250) NOT NULL,
[GRUPPO] [int] NULL,
[NUMERO] [int] NULL,
[NOME] [varchar](50) NULL,
[DESCRIZIONE] [varchar](50) NULL,
CONSTRAINT [PK_Permessi] PRIMARY KEY CLUSTERED
(
[COD_PERMESSO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Permessi2Funzione] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Permessi2Funzione](
[COD_PERMESSO] [varchar](50) NOT NULL,
[COD_FUNZIONE] [nvarchar](31) NOT NULL,
[READWRITE] [char](1) NULL,
CONSTRAINT [PK_Permessi2Funzione] PRIMARY KEY CLUSTERED
(
[COD_PERMESSO] ASC,
[COD_FUNZIONE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[TaskList] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaskList](
[NumTask] [nvarchar](50) NOT NULL,
[CodArt] [nvarchar](50) NOT NULL,
[QtaRic] [int] NOT NULL,
[Prior] [int] NOT NULL,
[Concluso] [bit] NOT NULL,
[DataIns] [datetime] NOT NULL,
CONSTRAINT [PK_TaskList] PRIMARY KEY CLUSTERED
(
[NumTask] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[TaskRec] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaskRec](
[IdxRec] [int] IDENTITY(1,1) NOT NULL,
[CodOpr] [nvarchar](50) NOT NULL,
[CodPost] [nvarchar](50) NOT NULL,
[NumTask] [nvarchar](50) NOT NULL,
[CodFase] [nvarchar](50) NOT NULL,
[DtStart] [datetime] NOT NULL,
[DtEnd] [datetime] NULL,
[QtaEv] [int] NOT NULL,
CONSTRAINT [PK_TaskRec] PRIMARY KEY CLUSTERED
(
[IdxRec] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[TraEv2Stati] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TraEv2Stati](
[CodMappa] [nvarchar](20) NOT NULL,
[CodObj] [nvarchar](50) NOT NULL,
[CodStato] [nvarchar](50) NOT NULL,
[CodEvento] [nvarchar](50) NOT NULL,
[NextCodStato] [nvarchar](50) NULL,
[CmdPlugin] [nvarchar](50) NULL,
[text2show] [nvarchar](500) NULL,
[descrComando] [nvarchar](250) NULL,
CONSTRAINT [PK_TraEv2Stati] PRIMARY KEY CLUSTERED
(
[CodMappa] ASC,
[CodObj] ASC,
[CodStato] ASC,
[CodEvento] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Utenti] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Utenti](
[USER_NAME] [nvarchar](50) NOT NULL,
[cognome] [nvarchar](250) NOT NULL,
[nome] [nvarchar](250) NOT NULL,
[email] [nvarchar](250) NOT NULL,
[authKey] [nvarchar](250) NOT NULL,
[numAuth] [int] NOT NULL,
[attivo] [bit] NOT NULL,
[CodGruppo] [nvarchar](50) NOT NULL,
[resetAuthKeyReq] [bit] NOT NULL,
CONSTRAINT [PK_Utenti] PRIMARY KEY CLUSTERED
(
[USER_NAME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Vocabolario] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Vocabolario](
[Lingua] [nvarchar](3) NOT NULL,
[Lemma] [nvarchar](50) NOT NULL,
[Traduzione] [nvarchar](500) NOT NULL,
CONSTRAINT [PK_Vocabolario] PRIMARY KEY CLUSTERED
(
[Lingua] ASC,
[Lemma] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: View [dbo].[v_TaskRecCount] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_TaskRecCount]
AS
SELECT NumTask, ISNULL(COUNT(IdxRec), 0) AS NumRec
FROM dbo.TaskRec
GROUP BY NumTask
GO
/****** Object: View [dbo].[v_TaskList] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_TaskList]
AS
SELECT dbo.TaskList.NumTask
,dbo.TaskList.CodArt
,dbo.TaskList.QtaRic
,dbo.TaskList.Prior
,dbo.TaskList.Concluso
,dbo.TaskList.DataIns
,ISNULL(dbo.v_TaskRecCount.NumRec, 0) AS NumRec
,1 + CASE
WHEN ISNULL(dbo.v_TaskRecCount.NumRec, 0) = 0
THEN (0)
ELSE (1)
END + CASE
WHEN [Concluso] = (1)
THEN (1)
ELSE (0)
END AS CurrStatus
FROM dbo.TaskList
LEFT OUTER JOIN dbo.v_TaskRecCount ON dbo.TaskList.NumTask = dbo.v_TaskRecCount.NumTask
GO
/****** Object: View [dbo].[v_AnagPost] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_AnagPost]
AS
SELECT dbo.AnagPost.CodPost, dbo.AnagPost.Descrizione, dbo.AnagPost.PreselFasi, dbo.AnagPost.CodOpr, ISNULL(dbo.AnagOpr.Cognome, N'') + ' ' + ISNULL(dbo.AnagOpr.Nome, N'') AS Operatore
FROM dbo.AnagPost LEFT OUTER JOIN
dbo.AnagOpr ON dbo.AnagPost.CodOpr = dbo.AnagOpr.CodOpr
GO
/****** Object: View [dbo].[v_TaskRec] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_TaskRec]
AS
SELECT TR.NumTask, TL.CodArt, TL.QtaRic, TR.IdxRec, TR.CodOpr, AO.Cognome + ' ' + AO.Nome AS NomeOpr, TR.CodPost, AP.Descrizione, TR.CodFase, AF.DescrFase, TR.DtStart, TR.DtEnd, TR.QtaEv, CAST(DATEDIFF(SECOND, TR.DtStart,
TR.DtEnd) AS DECIMAL(18, 6)) / 60 AS DurataMin, CAST(DATEDIFF(SECOND, TR.DtStart, TR.DtEnd) AS DECIMAL(18, 6)) / 60 / CASE WHEN TR.QtaEv < 1 THEN 1 ELSE TR.QtaEv END AS TCiclo
FROM dbo.TaskRec AS TR INNER JOIN
dbo.TaskList AS TL ON TR.NumTask = TL.NumTask LEFT OUTER JOIN
dbo.AnagFasi AS AF ON TR.CodFase = AF.CodFase LEFT OUTER JOIN
dbo.AnagPost AS AP ON TR.CodPost = AP.CodPost LEFT OUTER JOIN
dbo.AnagOpr AS AO ON TR.CodOpr = AO.CodOpr
GO
SET IDENTITY_INSERT [dbo].[AnagDevices] ON
INSERT [dbo].[AnagDevices] ([IdxDevice], [DeviceSecret], [USER_NAME], [DeviceName], [Description], [dataOraEnabled], [dataOraLastSeen], [lastIPv4]) VALUES (1, N'CF1XET2pxy9USBLCCYh0sc9gIZSoI7Qag6UxAp9MB+4/H1/+Al9kGs+Y5w9IPd6ZluQOxey+U6SuhNwLUyn6FVWuUB1SMmIZVwI/IWJZMbE=', N'samuele@steamware.net', N'WRK-W10-01.steamware.local.net', N'::1', CAST(N'2018-08-31T21:49:27.117' AS DateTime), CAST(N'2018-09-05T12:34:04.353' AS DateTime), N'Mozilla/5.0 (Wi')
SET IDENTITY_INSERT [dbo].[AnagDevices] OFF
INSERT [dbo].[AnagEventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (N'04', N'BC', N'Inizio Lavoro', N'act')
INSERT [dbo].[AnagEventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (N'05', N'BC', N'Fine Lavoro', N'act')
INSERT [dbo].[AnagEventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (N'06', N'BC', N'Spedito', N'act')
INSERT [dbo].[AnagEventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (N'07', N'BC', N'Invio email', N'act')
INSERT [dbo].[AnagEventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (N'CLOSE', N'BC', N'CHIUSURA di una fase', N'act')
INSERT [dbo].[AnagEventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (N'CMD_DEL', N'BC', N'Barcode - DELETE', N'act')
INSERT [dbo].[AnagEventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (N'ko', N'BC', N'Barcode - reset', N'ko')
INSERT [dbo].[AnagEventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (N'ok', N'BC', N'Barcode - conferma', N'ok')
INSERT [dbo].[AnagEventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (N'resCOM', N'BC', N'Reset COMMESSA', N'act')
INSERT [dbo].[AnagEventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (N'resOP', N'BC', N'Reset OPERATORE', N'act')
INSERT [dbo].[AnagFamStati] ([FamStato], [DescrFam]) VALUES (N'BC', N'Gestione Barcode')
INSERT [dbo].[AnagFamStati] ([FamStato], [DescrFam]) VALUES (N'ES_comm', N'Commesse E.S.')
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'CLOSE', N'CHIUSURA FASE CORRENTE', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'COLL.01', N'COLLAUDO ELETTRICO', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'COLL.02', N'COLLAUDO VISIVO', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'COLL.03', N'COLLAUDO MANUALE', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'COLL.04', N'RIPARAZIONE', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'COLL.05', N'IMBALLO', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'COLL.06', N'FINE COMMESSA', 1, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'MAG.01', N'PREPARAZIONE MATERIALI', 0, 0)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'MAG.02', N'TAGLIO CAVI', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'MAG.03', N'TAGLIO GUAINE', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'MAG.04', N'IDENTIFICAZIONE', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'MAG.05', N'COLLAUDO', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'MAG.06', N'VARIE', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'PROD.01', N'PREPARAZIONE CAVO', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'PROD.02', N'AGGRAFFATURA', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'PROD.03', N'SALDATURA E FINITURE', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'PROD.04', N'INSERIMENTI E FINITURE', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'PROD.05', N'CHIUSURA CALOTTE', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'PROD.06', N'AVVITATURA MORSETTI', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'PROD.07', N'ASSEMBLAGGI', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'PROD.08', N'IDENTIFICAZIONE', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'PROD.09', N'COLLAUDO', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'PROD.10', N'RIPARAZIONI', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'TAGL.01', N'TAGLIO', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'TAGL.02', N'TAGLIO+AGGRAFFATURA UN LATO', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'TAGL.03', N'TAGLIO+AGGRAFFATURA DUE LATI', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'TAGL.04', N'TAGLIO+SGUAINATURA', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'TAGL.05', N'TAGLIO TUBETTI E CALZE', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'TAGL.06', N'TAGLIO MANUALE', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'TAGL.07', N'VARIE', 0, 1)
INSERT [dbo].[AnagFasi] ([CodFase], [DescrFase], [CloseTask], [TimeRec]) VALUES (N'UFF.01', N'CREAZIONE COMMESSA', 0, 0)
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.01', N'Elettronica', N'Scalvina')
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.02', N'Cognome 02', N'Nome 02')
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.03', N'Cognome 03', N'Nome 03')
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.04', N'Cognome 04', N'Nome 04')
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.05', N'Cognome 05', N'Nome 05')
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.06', N'Cognome 06', N'Nome 06')
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.07', N'Cognome 07', N'Nome 07')
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.08', N'Cognome 08', N'Nome 08')
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.09', N'Cognome 09', N'Nome 09')
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.10', N'Cognome 10', N'Nome 10')
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.11', N'Cognome 11', N'Nome 11')
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.12', N'Cognome 12', N'Nome 12')
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.13', N'Cognome 13', N'Nome 13')
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.14', N'Cognome 14', N'Nome 14')
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.15', N'Cognome 15', N'Nome 15')
INSERT [dbo].[AnagOpr] ([CodOpr], [Cognome], [Nome]) VALUES (N'OPR.16', N'Cognome 16', N'Nome 16')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.COLL_01', N'Postazione Collaudo 01', N'COLL', N'OPR.03')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.MAG_01', N'Postazione Magazzino 01', N'MAG', N'')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.PROD_01', N'Postazione Produzione 01', N'PROD', N'OPR.03')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.PROD_02', N'Postazione Produzione 02', N'PROD', N'')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.PROD_03', N'Postazione Produzione 03', N'PROD', N'')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.PROD_04', N'Postazione Produzione 04', N'PROD', N'')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.PROD_05', N'Postazione Produzione 05', N'PROD', N'')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.PROD_06', N'Postazione Produzione 06', N'PROD', N'')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.PROD_07', N'Postazione Produzione 07', N'PROD', N'')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.PROD_08', N'Postazione Produzione 08', N'PROD', N'')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.PROD_09', N'Postazione Produzione 09', N'PROD', N'')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.PROD_10', N'Postazione Produzione 10', N'PROD', N'')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.PROD_11', N'Postazione Produzione 11', N'PROD', N'')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.TAGL_01', N'Postazione Taglio 01', N'TAGL', N'')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.TAGL_02', N'Postazione Taglio 02', N'TAGL', N'OPR.03')
INSERT [dbo].[AnagPost] ([CodPost], [Descrizione], [PreselFasi], [CodOpr]) VALUES (N'POST.UFF_01', N'Postazione UFFICIO 01', N'UFF', N'')
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato], [PrioritaStato]) VALUES (N'*', N'BC', N'99 - Undef', 99)
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato], [PrioritaStato]) VALUES (N'01', N'ES_comm', N'1 - Ricevuto', 1)
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato], [PrioritaStato]) VALUES (N'02', N'ES_comm', N'2 - Accettato', 2)
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato], [PrioritaStato]) VALUES (N'03', N'ES_comm', N'3 - Schedulata', 3)
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato], [PrioritaStato]) VALUES (N'04', N'ES_comm', N'4 - In lavoraz.', 4)
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato], [PrioritaStato]) VALUES (N'05', N'ES_comm', N'5 - Pronto Sped.', 5)
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato], [PrioritaStato]) VALUES (N'06', N'ES_comm', N'6 - Spedito', 6)
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato], [PrioritaStato]) VALUES (N'07', N'ES_comm', N'7 - Fatturato', 7)
INSERT [dbo].[AnagTipoEventi] ([CodTipoEvento], [DescrTipoEv]) VALUES (N'BC', N'Barcode')
INSERT [dbo].[AnagTipoEventi] ([CodTipoEvento], [DescrTipoEv]) VALUES (N'HI', N'Human Input')
INSERT [dbo].[AnagTipoEventi] ([CodTipoEvento], [DescrTipoEv]) VALUES (N'ND', N'Non definito')
INSERT [dbo].[AnagTipoEventi] ([CodTipoEvento], [DescrTipoEv]) VALUES (N'SW', N'Interfaccia SW')
INSERT [dbo].[Config] ([chiave], [valore], [note]) VALUES (N'regExp_AddNew', N'CMD_ADD', N'CMD OK/ADD')
INSERT [dbo].[Config] ([chiave], [valore], [note]) VALUES (N'regExp_CodArt', N'S\d+.\d+', N'Regola x riconoscimento ARTICOLI')
INSERT [dbo].[Config] ([chiave], [valore], [note]) VALUES (N'regExp_DEL', N'CMD_DEL', N'CMD DELete')
INSERT [dbo].[Config] ([chiave], [valore], [note]) VALUES (N'regExp_KO', N'CMD_KO', N'CMD RESET / KO')
INSERT [dbo].[Config] ([chiave], [valore], [note]) VALUES (N'regExp_NumTask', N'\d{13}', N'Regola x riconoscimento COMMESSE')
INSERT [dbo].[Config] ([chiave], [valore], [note]) VALUES (N'regExp_QtaRic', N'\d+', N'Regola x riconoscimento QTA')
INSERT [dbo].[DIRITTI] ([USER_NAME], [COD_CDC], [COD_MODULO], [COD_FUNZIONE], [VALUE]) VALUES (N'samuele@steamware.net', N'X999', N'C.TRACK', N'CT_admin', N'0')
INSERT [dbo].[DIRITTI] ([USER_NAME], [COD_CDC], [COD_MODULO], [COD_FUNZIONE], [VALUE]) VALUES (N'samuele@steamware.net', N'X999', N'C.TRACK', N'CT_user', N'0')
INSERT [dbo].[DIRITTI] ([USER_NAME], [COD_CDC], [COD_MODULO], [COD_FUNZIONE], [VALUE]) VALUES (N'samuele@steamware.net', N'X999', N'C.TRACK', N'CT_userStart', N'0')
INSERT [dbo].[FUNZIONE] ([COD_FUNZIONE], [DESCRIZIONE]) VALUES (N'CT_admin', N'Utente Admin C.TRACK')
INSERT [dbo].[FUNZIONE] ([COD_FUNZIONE], [DESCRIZIONE]) VALUES (N'CT_user', N'Utente standard C.TRACK')
INSERT [dbo].[FUNZIONE] ([COD_FUNZIONE], [DESCRIZIONE]) VALUES (N'CT_userStart', N'Utente con permessi AVVIO commesse C.TRACK')
INSERT [dbo].[Lingue] ([Lingua], [DescrizioneLingua]) VALUES (N'EN', N'English')
INSERT [dbo].[Lingue] ([Lingua], [DescrizioneLingua]) VALUES (N'IT', N'Italian')
INSERT [dbo].[MODULO] ([COD_MODULO], [DESCRIZIONE]) VALUES (N'C.TRACK', N'TRACKING COMMESSE')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'ANAG', N'menu', 1, 0, N'menu', N'menuIcon')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'ANAG_update', N'update', 1, 7, N'UpdateAnagrafiche', N'UpdateAnagraficheIcon')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'ANAG_VOCAB', N'vocabolario', 1, 1, N'Vocabolario', N'VocabolarioIcon')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'GC', N'menu', 2, 0, N'GestComm', N'GestCommIcon')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'GC_barcode', N'barcode', 999, 7, N'BarcodeInput', N'BarcodeInputIcon')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'GC_places', N'postazioni', 999, 1, N'PostazioniList', N'PostazioniListIcon')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'GC_task', N'task', 999, 2, N'TaskList', N'TaskListIcon')
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'ANAG', N'CT_admin', N'S')
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'ANAG_update', N'CT_admin', N'S')
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'ANAG_VOCAB', N'CT_admin', N'S')
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'GC', N'CT_user', N'S')
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'GC_barcode', N'CT_user', N'S')
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'GC_places', N'CT_user', N'N')
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'GC_task', N'CT_admin', N'S')
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'GC_task', N'CT_user', N'N')
INSERT [dbo].[TaskList] ([NumTask], [CodArt], [QtaRic], [Prior], [Concluso], [DataIns]) VALUES (N'2018089600001', N'S035.0337', 10, 100, 1, CAST(N'2018-09-04T09:49:07.850' AS DateTime))
INSERT [dbo].[TaskList] ([NumTask], [CodArt], [QtaRic], [Prior], [Concluso], [DataIns]) VALUES (N'2018089600002', N'S035.0336', 15, 100, 1, CAST(N'2018-09-04T09:49:26.260' AS DateTime))
INSERT [dbo].[TaskList] ([NumTask], [CodArt], [QtaRic], [Prior], [Concluso], [DataIns]) VALUES (N'2018089600003', N'S035.0336', 50, 100, 0, CAST(N'2018-09-04T09:52:15.437' AS DateTime))
INSERT [dbo].[TaskList] ([NumTask], [CodArt], [QtaRic], [Prior], [Concluso], [DataIns]) VALUES (N'2018089600004', N'S035.0337', 20, 100, 0, CAST(N'2018-09-04T09:53:02.470' AS DateTime))
INSERT [dbo].[TaskList] ([NumTask], [CodArt], [QtaRic], [Prior], [Concluso], [DataIns]) VALUES (N'2018089600005', N'S035.0335', 11, 100, 0, CAST(N'2018-09-03T14:49:14.933' AS DateTime))
SET IDENTITY_INSERT [dbo].[TaskRec] ON
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (4, N'OPR.03', N'POST.TAGL_02', N'2018089600001', N'TAGL.01', CAST(N'2018-09-04T12:58:07.550' AS DateTime), CAST(N'2018-09-04T15:20:12.040' AS DateTime), 2)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (6, N'OPR.03', N'POST.TAGL_02', N'2018089600001', N'TAGL.01', CAST(N'2018-09-04T15:27:03.170' AS DateTime), CAST(N'2018-09-04T15:27:12.600' AS DateTime), 1)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (11, N'OPR.03', N'POST.TAGL_02', N'2018089600001', N'TAGL.04', CAST(N'2018-09-04T15:28:32.850' AS DateTime), CAST(N'2018-09-04T15:28:43.220' AS DateTime), 5)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (12, N'OPR.03', N'POST.TAGL_02', N'2018089600001', N'TAGL.04', CAST(N'2018-09-04T15:28:46.897' AS DateTime), CAST(N'2018-09-04T15:28:48.563' AS DateTime), 5)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (13, N'OPR.03', N'POST.TAGL_02', N'2018089600001', N'TAGL.02', CAST(N'2018-09-04T15:28:50.263' AS DateTime), CAST(N'2018-09-04T15:28:51.677' AS DateTime), 10)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (14, N'OPR.03', N'POST.PROD_01', N'2018089600001', N'PROD.01', CAST(N'2018-09-04T18:47:01.240' AS DateTime), CAST(N'2018-09-04T18:47:03.997' AS DateTime), 10)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (15, N'OPR.03', N'POST.PROD_01', N'2018089600001', N'PROD.07', CAST(N'2018-09-04T18:47:07.530' AS DateTime), CAST(N'2018-09-04T18:47:09.010' AS DateTime), 10)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (16, N'OPR.03', N'POST.COLL_01', N'2018089600001', N'COLL.01', CAST(N'2018-09-04T18:48:45.250' AS DateTime), CAST(N'2018-09-04T18:48:47.137' AS DateTime), 10)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (17, N'OPR.03', N'POST.COLL_01', N'2018089600001', N'COLL.05', CAST(N'2018-09-04T18:48:51.043' AS DateTime), CAST(N'2018-09-04T19:09:58.993' AS DateTime), 10)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (18, N'OPR.03', N'POST.COLL_01', N'2018089600001', N'COLL.04', CAST(N'2018-09-04T19:19:17.907' AS DateTime), CAST(N'2018-09-04T19:19:34.593' AS DateTime), 1)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (19, N'OPR.03', N'POST.COLL_01', N'2018089600001', N'COLL.06', CAST(N'2018-09-04T19:19:48.473' AS DateTime), CAST(N'2018-09-04T19:19:49.473' AS DateTime), 10)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (20, N'OPR.03', N'POST.COLL_01', N'2018089600001', N'COLL.06', CAST(N'2018-09-05T08:57:19.527' AS DateTime), CAST(N'2018-09-05T08:57:20.527' AS DateTime), 0)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (21, N'OPR.03', N'POST.TAGL_02', N'2018089600002', N'TAGL.03', CAST(N'2018-09-05T10:00:30.287' AS DateTime), CAST(N'2018-09-05T10:06:34.780' AS DateTime), 15)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (22, N'OPR.03', N'POST.PROD_01', N'2018089600002', N'PROD.01', CAST(N'2018-09-05T10:01:55.340' AS DateTime), CAST(N'2018-09-05T10:03:57.427' AS DateTime), 15)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (23, N'OPR.03', N'POST.PROD_01', N'2018089600002', N'PROD.02', CAST(N'2018-09-05T10:03:57.427' AS DateTime), CAST(N'2018-09-05T10:04:57.427' AS DateTime), 15)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (24, N'OPR.03', N'POST.PROD_01', N'2018089600002', N'PROD.06', CAST(N'2018-09-05T10:04:59.427' AS DateTime), CAST(N'2018-09-05T10:05:57.427' AS DateTime), 15)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (25, N'OPR.03', N'POST.PROD_01', N'2018089600002', N'PROD.05', CAST(N'2018-09-05T10:05:59.427' AS DateTime), CAST(N'2018-09-05T10:06:29.427' AS DateTime), 15)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (26, N'OPR.03', N'POST.COLL_01', N'2018089600002', N'COLL.01', CAST(N'2018-09-05T12:03:31.880' AS DateTime), CAST(N'2018-09-05T12:06:31.880' AS DateTime), 15)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (27, N'OPR.03', N'POST.COLL_01', N'2018089600002', N'COLL.04', CAST(N'2018-09-05T12:07:31.880' AS DateTime), CAST(N'2018-09-05T12:09:31.880' AS DateTime), 5)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (28, N'OPR.03', N'POST.COLL_01', N'2018089600002', N'COLL.06', CAST(N'2018-09-05T13:04:17.343' AS DateTime), CAST(N'2018-09-05T13:04:18.343' AS DateTime), 15)
INSERT [dbo].[TaskRec] ([IdxRec], [CodOpr], [CodPost], [NumTask], [CodFase], [DtStart], [DtEnd], [QtaEv]) VALUES (29, N'OPR.03', N'POST.TAGL_02', N'2018089600003', N'TAGL.03', CAST(N'2018-09-05T13:04:41.583' AS DateTime), CAST(N'2018-09-05T13:10:58.023' AS DateTime), 50)
SET IDENTITY_INSERT [dbo].[TaskRec] OFF
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_BC', N'BC', N'*', N'04', N'*', N'04', N'WorkStart', N'Inizio Lavorazione')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_BC', N'BC', N'*', N'05', N'*', N'05', N'WorkDone', N'Fine lavorazione')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_BC', N'BC', N'*', N'06', N'*', N'06', N'Sent', N'Spedito')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_BC', N'BC', N'*', N'ko', N'*', N'ko', N'Annulla', N'Annulla comandi')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_BC', N'BC', N'*', N'ok', N'*', N'ok', N'Conferma', N'Conferma')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_BC', N'BC', N'*', N'resCOM', N'*', N'resCOM', N'resCOM', N'Rimozione commessa impostata')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_BC', N'BC', N'*', N'resOP', N'*', N'resOP', N'resOP', N'Rimuove Operatore da sessione e da postazione corrente')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_BC', N'BC', N'05', N'07', N'*', N'07', N'sendMail', N'Invia Email')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_Stati', N'D', N'01', N'04', N'04', NULL, NULL, N'cambio da stato 1 a 4 (inizio lav)')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_Stati', N'D', N'02', N'04', N'04', NULL, NULL, N'cambio da stato 2 a 4 (inizio lav)')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_Stati', N'D', N'03', N'04', N'04', NULL, NULL, N'cambio da stato 3 a 4 (inizio lav)')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_Stati', N'D', N'04', N'05', N'05', NULL, NULL, N'cambio da stato 4 a 5 (fine lav)')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_Stati', N'D', N'05', N'06', N'06', NULL, NULL, N'cambio da stato 5 a 6 (spedito)')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_Stati', N'U', N'01', N'04', N'04', NULL, NULL, N'cambio da stato 1 a 4 (inizio lav)')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_Stati', N'U', N'02', N'04', N'04', NULL, NULL, N'cambio da stato 2 a 4 (inizio lav)')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_Stati', N'U', N'03', N'04', N'04', NULL, NULL, N'cambio da stato 3 a 4 (inizio lav)')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_Stati', N'U', N'04', N'05', N'05', NULL, NULL, N'cambio da stato 4 a 5 (fine lav)')
INSERT [dbo].[TraEv2Stati] ([CodMappa], [CodObj], [CodStato], [CodEvento], [NextCodStato], [CmdPlugin], [text2show], [descrComando]) VALUES (N'E_Stati', N'U', N'05', N'06', N'06', NULL, NULL, N'cambio da stato 5 a 6 (spedito)')
INSERT [dbo].[Utenti] ([USER_NAME], [cognome], [nome], [email], [authKey], [numAuth], [attivo], [CodGruppo], [resetAuthKeyReq]) VALUES (N'samuele@steamware.net', N'Locatelli', N'Samuele Emilio', N'samuele@steamware.net', N'myAuthKey', 1995, 1, N'IT', 1)
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'Annulla', N'Annulla')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'ComandoSconosciuto', N'Comando sconosciuto')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'Conferma', N'Conferma')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'confermaAccettaObjXps', N'Sei sicuro di voler accettare il DDT? non potrai annullare')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'confermaAddEmail', N'Confermi di voler AGGIUNGERE la richiesta notifica email a merce pronta?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'confermaDel', N'Sei sicuro di voler continuare con l''eliminazione del record?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'confermaFatturaObjXps', N'Sei sicuro di voler indicare come fatturato il DDT indicato?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'confermaOkCambioStati', N'Sei sicuro di vole procedere con il cambiamento dello stato?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'confermaOkDueDate', N'Sei sicuro di voler procedere impostando la data di consegna per tutti i colli?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'ConfermaOpr', N'Conferma Operatore')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'ConfermaPost', N'Conferma Postazione')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'confermaRemEmail', N'Confermi di voler RIMUOVERE la notifica email?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'confermaReopenTask', N'Sicuro di voler riaprire la commessa?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'confermaSbloccoPost', N'Sicuro di voler sbloccare postazione rimuovendo utente?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'confermaStampa', N'Sei sicuro di vole procedere con la stampa?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'FreePost', N'Libera Postazione')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'GestComm', N'Gestione Commessa')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'GestCommIcon', N'fa fa-tags')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'GestCommLong', N'Area gestione dati commessa')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'menu', N'MENU')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'menuIcon', N'fa fa-refresh')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'PregoInserireBarcode', N'Prego Inserire Barcode')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'RemoveOpr', N'Rimuove Operatore da sessione')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'resCOM', N'Rimuove Comemssa impostata')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'ReservePost', N'Imposta Operatore + Postazione')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'resOP', N'Rimuove Operatore da sessione')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'sendMail', N'invia e-mail')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'Sent', N'Spedito')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'setVal', N'Imposta Valore')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'UpdateAnagrafiche', N'Clienti')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'UpdateAnagraficheIcon', N'fa fa-wrench')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'UpdateAnagraficheLong', N'Clienti')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'Vocabolario', N'Dictionary')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'VocabolarioIcon', N'fa fa-keyboard-o')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'WorkDone', N'End Work')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'EN', N'WorkStart', N'Start Work')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'Annulla', N'Annulla')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'ComandoSconosciuto', N'Comando sconosciuto')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'Conferma', N'Conferma')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'confermaAccettaObjXps', N'Sei sicuro di voler accettare il DDT? non potrai annullare')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'confermaAddEmail', N'Confermi di voler AGGIUNGERE la richiesta notifica email a merce pronta?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'confermaDel', N'Sei sicuro di voler continuare con l''eliminazione del record?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'confermaFatturaObjXps', N'Sei sicuro di voler indicare come fatturato il DDT indicato?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'confermaOkCambioStati', N'Sei sicuro di vole procedere con il cambiamento dello stato?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'confermaOkDueDate', N'Sei sicuro di voler procedere impostando la data di consegna per tutti i colli?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'ConfermaOpr', N'Conferma Operatore')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'ConfermaPost', N'Conferma Postazione')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'confermaRemEmail', N'Confermi di voler RIMUOVERE la notifica email?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'confermaReopenTask', N'Sicuro di voler riaprire la commessa?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'confermaSbloccoPost', N'Sicuro di voler sbloccare postazione rimuovendo utente?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'confermaStampa', N'Sei sicuro di vole procedere con la stampa?')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'FreePost', N'Libera Postazione')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'GestComm', N'Gestione Commessa')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'GestCommIcon', N'fa fa-tags')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'GestCommLong', N'Area gestione dati commessa')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'menu', N'MENU')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'menuIcon', N'fa fa-refresh')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'PregoInserireBarcode', N'Prego Inserire Barcode')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'RemoveOpr', N'Rimuove Operatore da sessione')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'resCOM', N'Rimuove Comemssa impostata')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'ReservePost', N'Imposta Operatore + Postazione')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'resOP', N'Rimuove Operatore da sessione')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'sendMail', N'invia e-mail')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'Sent', N'Spedito')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'setVal', N'Imposta Valore')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'UpdateAnagrafiche', N'Clienti')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'UpdateAnagraficheIcon', N'fa fa-wrench')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'UpdateAnagraficheLong', N'Clienti')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'Vocabolario', N'Vocabolario')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'VocabolarioIcon', N'fa fa-keyboard-o')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'WorkDone', N'Completata Lavorazione')
INSERT [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (N'IT', N'WorkStart', N'Inizio Lavorazione')
ALTER TABLE [dbo].[AnagFasi] ADD CONSTRAINT [DF_AnagFasi_DescrFase] DEFAULT ('') FOR [DescrFase]
GO
ALTER TABLE [dbo].[AnagFasi] ADD CONSTRAINT [DF_AnagFasi_CloseTask] DEFAULT ((0)) FOR [CloseTask]
GO
ALTER TABLE [dbo].[AnagFasi] ADD CONSTRAINT [DF_AnagFasi_TimeRec] DEFAULT ((1)) FOR [TimeRec]
GO
ALTER TABLE [dbo].[AnagOpr] ADD CONSTRAINT [DF_AnagOpr_CodOpr] DEFAULT ('OPR.01') FOR [CodOpr]
GO
ALTER TABLE [dbo].[AnagPost] ADD CONSTRAINT [DF_AnagPost_Descrizione] DEFAULT ('') FOR [Descrizione]
GO
ALTER TABLE [dbo].[AnagPost] ADD CONSTRAINT [DF_AnagPost_Descrizione1] DEFAULT ('') FOR [PreselFasi]
GO
ALTER TABLE [dbo].[AnagPost] ADD CONSTRAINT [DF_AnagPost_CodOpr] DEFAULT ('') FOR [CodOpr]
GO
ALTER TABLE [dbo].[TaskList] ADD CONSTRAINT [DF_TaskList_CodArt] DEFAULT ('') FOR [CodArt]
GO
ALTER TABLE [dbo].[TaskList] ADD CONSTRAINT [DF_ListTask_Quantita] DEFAULT ((0)) FOR [QtaRic]
GO
ALTER TABLE [dbo].[TaskList] ADD CONSTRAINT [DF_TaskList_Prior] DEFAULT ((100)) FOR [Prior]
GO
ALTER TABLE [dbo].[TaskList] ADD CONSTRAINT [DF_TaskList_Chiuso] DEFAULT ((0)) FOR [Concluso]
GO
ALTER TABLE [dbo].[TaskList] ADD CONSTRAINT [DF_TaskList_DataIns] DEFAULT (getdate()) FOR [DataIns]
GO
ALTER TABLE [dbo].[TaskRec] ADD CONSTRAINT [DF_TaskRec_DtStart] DEFAULT (getdate()) FOR [DtStart]
GO
ALTER TABLE [dbo].[TaskRec] ADD CONSTRAINT [DF_TaskRec_QtaEv] DEFAULT ((0)) FOR [QtaEv]
GO
ALTER TABLE [dbo].[Utenti] ADD CONSTRAINT [DF_Utenti_Cognome] DEFAULT ('') FOR [cognome]
GO
ALTER TABLE [dbo].[Utenti] ADD CONSTRAINT [DF_Utenti_nome] DEFAULT ('') FOR [nome]
GO
ALTER TABLE [dbo].[Utenti] ADD CONSTRAINT [DF_Utenti_email] DEFAULT ('@') FOR [email]
GO
ALTER TABLE [dbo].[Utenti] ADD CONSTRAINT [DF_Utenti_authKey] DEFAULT ('') FOR [authKey]
GO
ALTER TABLE [dbo].[Utenti] ADD CONSTRAINT [DF_Utenti_numAuth] DEFAULT ((0)) FOR [numAuth]
GO
ALTER TABLE [dbo].[Utenti] ADD CONSTRAINT [DF_Utenti_attivo] DEFAULT ((1)) FOR [attivo]
GO
ALTER TABLE [dbo].[Utenti] ADD CONSTRAINT [DF_Utenti_CodGruppo] DEFAULT ('') FOR [CodGruppo]
GO
ALTER TABLE [dbo].[Utenti] ADD CONSTRAINT [DF_Utenti_resetReq] DEFAULT ((0)) FOR [resetAuthKeyReq]
GO
ALTER TABLE [dbo].[AnagDevices] WITH CHECK ADD CONSTRAINT [FK_AnagDevices_Utenti] FOREIGN KEY([USER_NAME])
REFERENCES [dbo].[Utenti] ([USER_NAME])
GO
ALTER TABLE [dbo].[AnagDevices] CHECK CONSTRAINT [FK_AnagDevices_Utenti]
GO
ALTER TABLE [dbo].[AnagEventi] WITH CHECK ADD CONSTRAINT [FK_AnagEventi_TipoEventi] FOREIGN KEY([CodTipoEvento])
REFERENCES [dbo].[AnagTipoEventi] ([CodTipoEvento])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[AnagEventi] CHECK CONSTRAINT [FK_AnagEventi_TipoEventi]
GO
ALTER TABLE [dbo].[AnagStati] WITH CHECK ADD CONSTRAINT [FK_AnagStati_AnagFamStati] FOREIGN KEY([FamStato])
REFERENCES [dbo].[AnagFamStati] ([FamStato])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[AnagStati] CHECK CONSTRAINT [FK_AnagStati_AnagFamStati]
GO
ALTER TABLE [dbo].[DIRITTI] WITH CHECK ADD CONSTRAINT [FK_DIRITTI_FUNZIONE] FOREIGN KEY([COD_FUNZIONE])
REFERENCES [dbo].[FUNZIONE] ([COD_FUNZIONE])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[DIRITTI] CHECK CONSTRAINT [FK_DIRITTI_FUNZIONE]
GO
ALTER TABLE [dbo].[DIRITTI] WITH CHECK ADD CONSTRAINT [FK_DIRITTI_MODULO] FOREIGN KEY([COD_MODULO])
REFERENCES [dbo].[MODULO] ([COD_MODULO])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[DIRITTI] CHECK CONSTRAINT [FK_DIRITTI_MODULO]
GO
ALTER TABLE [dbo].[DIRITTI] WITH CHECK ADD CONSTRAINT [FK_DIRITTI_Utenti] FOREIGN KEY([USER_NAME])
REFERENCES [dbo].[Utenti] ([USER_NAME])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[DIRITTI] CHECK CONSTRAINT [FK_DIRITTI_Utenti]
GO
ALTER TABLE [dbo].[Permessi2Funzione] WITH NOCHECK ADD CONSTRAINT [FK_Permessi2Funzione_FUNZIONE] FOREIGN KEY([COD_FUNZIONE])
REFERENCES [dbo].[FUNZIONE] ([COD_FUNZIONE])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Permessi2Funzione] CHECK CONSTRAINT [FK_Permessi2Funzione_FUNZIONE]
GO
ALTER TABLE [dbo].[Permessi2Funzione] WITH CHECK ADD CONSTRAINT [FK_Permessi2Funzione_Permessi] FOREIGN KEY([COD_PERMESSO])
REFERENCES [dbo].[Permessi] ([COD_PERMESSO])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Permessi2Funzione] CHECK CONSTRAINT [FK_Permessi2Funzione_Permessi]
GO
ALTER TABLE [dbo].[TaskRec] WITH CHECK ADD CONSTRAINT [FK_TaskRec_AnagFasi] FOREIGN KEY([CodFase])
REFERENCES [dbo].[AnagFasi] ([CodFase])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[TaskRec] CHECK CONSTRAINT [FK_TaskRec_AnagFasi]
GO
ALTER TABLE [dbo].[TaskRec] WITH CHECK ADD CONSTRAINT [FK_TaskRec_AnagOpr] FOREIGN KEY([CodOpr])
REFERENCES [dbo].[AnagOpr] ([CodOpr])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[TaskRec] CHECK CONSTRAINT [FK_TaskRec_AnagOpr]
GO
ALTER TABLE [dbo].[TaskRec] WITH CHECK ADD CONSTRAINT [FK_TaskRec_AnagPost] FOREIGN KEY([CodPost])
REFERENCES [dbo].[AnagPost] ([CodPost])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[TaskRec] CHECK CONSTRAINT [FK_TaskRec_AnagPost]
GO
ALTER TABLE [dbo].[TaskRec] WITH CHECK ADD CONSTRAINT [FK_TaskRec_TaskList] FOREIGN KEY([NumTask])
REFERENCES [dbo].[TaskList] ([NumTask])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[TaskRec] CHECK CONSTRAINT [FK_TaskRec_TaskList]
GO
ALTER TABLE [dbo].[Vocabolario] WITH CHECK ADD CONSTRAINT [FK_Vocabolario_Lingue] FOREIGN KEY([Lingua])
REFERENCES [dbo].[Lingue] ([Lingua])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Vocabolario] CHECK CONSTRAINT [FK_Vocabolario_Lingue]
GO
/****** Object: StoredProcedure [dbo].[stp_AD_GetBySecret] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.22
-- Description: recupero device da device secret
-- =============================================
create PROCEDURE [dbo].[stp_AD_GetBySecret]
(
@DeviceSecret nvarchar(500)
)
AS
SET NOCOUNT ON;
SELECT *
FROM AnagDevices
WHERE (DeviceSecret = @DeviceSecret)
GO
/****** Object: StoredProcedure [dbo].[stp_AD_GetByUserSecret] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.22
-- Description: recupero device da user + device secret
-- =============================================
CREATE PROCEDURE [dbo].[stp_AD_GetByUserSecret]
(
@email nvarchar(50),
@DeviceSecret nvarchar(500)
)
AS
SET NOCOUNT ON;
SELECT *
FROM AnagDevices
WHERE (USER_NAME = @email) AND (DeviceSecret = @DeviceSecret)
GO
/****** Object: StoredProcedure [dbo].[stp_AD_updateIP] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.22
-- Description: update IP e user agent da idx
-- =============================================
create PROCEDURE [dbo].[stp_AD_updateIP]
(
@IdxDevice INT,
@lastSeen DATETIME,
@Description NVARCHAR(500),
@lastIPv4 NVARCHAR(15)
)
AS
SET NOCOUNT ON;
UPDATE AnagDevices
SET dataOraLastSeen = @lastSeen
, Description = @Description
, lastIPv4 = @lastIPv4
WHERE IdxDevice = @IdxDevice
GO
/****** Object: StoredProcedure [dbo].[stp_AE_getByKey] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware S.E.L.
-- Create date: 2018.09.03
-- Description: Ricerca evento per codice
-- =============================================
CREATE PROCEDURE [dbo].[stp_AE_getByKey]
(
@CodEvento NVARCHAR(50) = ''
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SET @CodEvento = ISNULL(@CodEvento, '')
SELECT DISTINCT AnagEventi.*
FROM AnagEventi
INNER JOIN TraEv2Stati ON AnagEventi.CodEvento = TraEv2Stati.CodEvento
WHERE (TraEv2Stati.CodEvento = @CodEvento)
END
GO
/****** Object: StoredProcedure [dbo].[stp_AF_GetByKey] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware S.E.L.
-- Create date: 2018.09.04
-- Description: Recupera fasi da KEY
-- =============================================
create PROCEDURE [dbo].[stp_AF_GetByKey]
(
@CodFase NVARCHAR(50) = ''
)
AS
BEGIN
-- cerco singola fase
SELECT *
FROM AnagFasi
WHERE CodFase = @CodFase
END
GO
/****** Object: StoredProcedure [dbo].[stp_AF_GetByPost] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware S.E.L.
-- Create date: 2018.09.04
-- Description: Recupera fasi DATA POSTAZIONE
-- =============================================
CREATE PROCEDURE [dbo].[stp_AF_GetByPost]
(
@CodPost NVARCHAR(50) = ''
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SET @CodPost = ISNULL(@CodPost, '')
DECLARE @numRec INT = 0
-- CONTO SE HA Fasi attive... da chiudere!
SELECT @numRec = COUNT(*)
FROM v_TaskRec
WHERE CodPost = @CodPost
AND (DtEnd IS NULL)
-- SE la postazione HA UNA FASE ATTIVA --> mostro CHIUDI
SET @numRec = ISNULL(@numRec, 0)
IF(@numRec > 0)
BEGIN
SELECT AF.*
FROM AnagFasi AF
WHERE CodFase = 'CLOSE'
--SELECT 'CLOSE' AS CodFase, 'Chiudi Fase' as DescrFase, 0 as CloseTask, 1 AS TimeRec
END
ELSE
BEGIN
-- ALTRIMENTI TUTTE le fasi possibili
SELECT AF.*
FROM AnagFasi AF
INNER JOIN AnagPost AP on AF.CodFase LIKE AP.PreselFasi+'%'
WHERE AP.CodPost = @CodPost
END
END
GO
/****** Object: StoredProcedure [dbo].[stp_AO_GetByKey] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware S.E.L.
-- Create date: 2018.09.03
-- Description: Recupera operatore da KEY
-- =============================================
CREATE PROCEDURE [dbo].[stp_AO_GetByKey]
(
@CodOpr NVARCHAR(50) = ''
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SET @CodOpr = ISNULL(@CodOpr, '')
SELECT *
FROM AnagOpr
WHERE CodOpr = @CodOpr
END
GO
/****** Object: StoredProcedure [dbo].[stp_AP_GetByKey] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware S.E.L.
-- Create date: 2018.09.03
-- Description: Recupera postsazione da KEY
-- =============================================
CREATE PROCEDURE [dbo].[stp_AP_GetByKey]
(
@CodPost NVARCHAR(50) = ''
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SET @CodPost = ISNULL(@CodPost, '')
SELECT *
FROM v_AnagPost
WHERE CodPost = @CodPost
END
GO
/****** Object: StoredProcedure [dbo].[stp_AP_resetOpr] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2018.09.04
-- Description: reset operatore su OGNI postazione
-- =============================================
create PROCEDURE [dbo].[stp_AP_resetOpr]
(
@CodOpr NVARCHAR(50)
)
AS
SET NOCOUNT ON;
UPDATE AnagPost
SET CodOpr = ''
WHERE CodOpr = @CodOpr
GO
/****** Object: StoredProcedure [dbo].[stp_AP_setOpr] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2018.09.03
-- Description: update opr su postazione (anche vuoto...)
-- =============================================
CREATE PROCEDURE [dbo].[stp_AP_setOpr]
(
@CodPost NVARCHAR(50),
@CodOpr NVARCHAR(50)
)
AS
SET NOCOUNT ON;
UPDATE AnagPost
SET CodOpr = ISNULL(@CodOpr,'')
WHERE CodPost = @CodPost
GO
/****** Object: StoredProcedure [dbo].[stp_Diritti_GetByUserModulo] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[stp_Diritti_GetByUserModulo]
(
@USER_NAME nvarchar(50),
@COD_MODULO nvarchar(31)
)
AS
SET NOCOUNT ON;
SELECT USER_NAME, COD_CDC, COD_MODULO, COD_FUNZIONE, VALUE FROM dbo.DIRITTI
where USER_NAME=@USER_NAME and COD_MODULO = @COD_MODULO
GO
/****** Object: StoredProcedure [dbo].[stp_insNewLemma] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*************************************
* STORED PROCEDURE stp_insNewLemma
*
* elimina record anagrafica classe prodotto
*
* mod : 14/05/2012
* aut : S.E. Locatelli
**************************************/
CREATE PROCEDURE [dbo].[stp_insNewLemma]
(
@lemma NVARCHAR(50),
@traduzione NVARCHAR(500)
)
AS
-- elimino se c'era già...
DELETE
FROM Vocabolario
WHERE lemma = @lemma
-- inserisco x tutte le lingue attive...
INSERT INTO Vocabolario
SELECT lingua, @lemma, @traduzione
FROM Lingue
SELECT *
FROM Vocabolario
WHERE lemma = @lemma
RETURN
GO
/****** Object: StoredProcedure [dbo].[stp_TE2S_GetByMappa] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware S.E.L.
-- Create date: 2018.09.03
-- Description: Recupera comandi variazione da tab data mappa
-- =============================================
CREATE PROCEDURE [dbo].[stp_TE2S_GetByMappa]
(
@CodMappa NVARCHAR(50) = ''
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SET @CodMappa = ISNULL(@CodMappa, '')
SELECT *
FROM dbo.TraEv2Stati
WHERE CodMappa = @CodMappa
END
GO
/****** Object: StoredProcedure [dbo].[stp_TL_deleteQuery] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware - SEL
-- Create date: 2018.08.03
-- Description: elimina commessa
-- =============================================
CREATE PROCEDURE [dbo].[stp_TL_deleteQuery]
(
@Original_NumTask NVARCHAR(50)
)
AS
BEGIN
SET NOCOUNT ON;
-- cerco records child
DECLARE @trovati INT = 0
SELECT @trovati = COUNT(*)
FROM TaskRec
WHERE NumTask = @Original_NumTask
-- SE NON HO RECORD child...
IF(@trovati = 0)
BEGIN
DELETE
FROM TaskList
WHERE NumTask = @Original_NumTask
END
END
GO
/****** Object: StoredProcedure [dbo].[stp_TL_GetByFilt] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[stp_TL_GetByFilt]
(
@CurrStatus INT
,@CodArt NVARCHAR(50) = ''
,@NumTask NVARCHAR(50) = ''
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SET @CodArt = ISNULL(@CodArt, '')
SET @NumTask = ISNULL(@NumTask, '')
SELECT *
FROM v_TaskList
WHERE CurrStatus = CASE WHEN @CurrStatus = 0 THEN CurrStatus ELSE @CurrStatus END
AND CodArt = CASE WHEN @CodArt = '' THEN CodArt ELSE @CodArt END
AND NumTask = CASE WHEN @NumTask = '' THEN NumTask ELSE @NumTask END
ORDER BY DataIns DESC, NumTask DESC
END
GO
/****** Object: StoredProcedure [dbo].[stp_TL_GetByKey] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steawmare SEL
-- Create date: 2018.09.05
-- Description: Riga TL da key
-- =============================================
create PROCEDURE [dbo].[stp_TL_GetByKey]
(
@NumTask NVARCHAR(50) = ''
)
AS
BEGIN
SET NOCOUNT ON;
SET @NumTask = ISNULL(@NumTask, '')
SELECT *
FROM v_TaskList
WHERE NumTask = @NumTask
END
GO
/****** Object: StoredProcedure [dbo].[stp_TL_GetLastNumDD] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware, S.E.L.
-- Create date: 2018.09.03
-- Description: restituisce elenco TASK creati/avviati/modificati nell'ultimo periodo
-- =============================================
CREATE PROCEDURE [dbo].[stp_TL_GetLastNumDD]
(
@LastDD INT
)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @adesso DATETIME
SET @adesso = GETDATE()
SELECT *
FROM v_TaskList
WHERE DataIns BETWEEN DATEADD(DD, -@LastDD , @adesso) AND @adesso
END
GO
/****** Object: StoredProcedure [dbo].[stp_TL_insertQuery] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware - SEL
-- Create date: 2018.08.03
-- Description: UPSERT valore commessa
-- =============================================
CREATE PROCEDURE [dbo].[stp_TL_insertQuery]
(
@NumTask NVARCHAR(50),
@CodArt NVARCHAR(50),
@QtaRic INT
)
AS
BEGIN
SET NOCOUNT ON;
MERGE TaskList AS target
USING (SELECT @NumTask, @CodArt, @QtaRic, GETDATE()) AS source (NumTask, CodArt, QtaRic, DataIns)
ON (target.NumTask = source.NumTask)
WHEN MATCHED THEN
UPDATE SET QtaRic = source.QtaRic
WHEN NOT MATCHED THEN
INSERT (NumTask, CodArt, QtaRic, DataIns)
VALUES (source.NumTask, source.CodArt, source.QtaRic, source.DataIns);
--INSERT INTO TaskList(NumTask, CodArt, QtaRic, DataIns)
--VALUES (@NumTask, @CodArt, @QtaRic, GETDATE())
END
GO
/****** Object: StoredProcedure [dbo].[stp_TL_updateClose] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware - SEL
-- Create date: 2018.08.04
-- Description: CHIUDO la commessa
-- =============================================
CREATE PROCEDURE [dbo].[stp_TL_updateClose]
(
@NumTask NVARCHAR(50),
@Concluso BIT
)
AS
BEGIN
SET NOCOUNT ON;
BEGIN tran
-- chiudo ultima REC se c'è...
UPDATE TaskRec
SET DtEnd = DATEADD(SECOND, 1, DtStart)
WHERE NumTask = @NumTask
AND DtEnd IS NULL
-- chiudo TL
UPDATE TaskList
SET Concluso = @Concluso
WHERE NumTask = @NumTask
COMMIT tran
END
GO
/****** Object: StoredProcedure [dbo].[stp_TR_closePending] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware S.E.L.
-- Create date: 2018.09.05
-- Description: CHIUSURA FORZATA dei Task Attivi (NON conclusi)
-- =============================================
create PROCEDURE [dbo].[stp_TR_closePending]
AS
BEGIN
SET NOCOUNT ON;
UPDATE TaskRec
SET DtEnd = GETDATE()
WHERE DtEnd IS NULL
END
GO
/****** Object: StoredProcedure [dbo].[stp_TR_GetAttive] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware S.E.L.
-- Create date: 2018.09.04
-- Description: Recupera elenco Task Attivi (NON conclusi)
-- =============================================
CREATE PROCEDURE [dbo].[stp_TR_GetAttive]
AS
BEGIN
SET NOCOUNT ON;
SELECT *
FROM v_TaskRec
WHERE DtEnd IS NULL
ORDER BY DtStart DESC, DtEnd DESC, CodPost
END
GO
/****** Object: StoredProcedure [dbo].[stp_TR_GetByNumTask] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware S.E.L.
-- Create date: 2018.09.04
-- Description: Recupera elenco Task Record x TaskNum
-- =============================================
CREATE PROCEDURE [dbo].[stp_TR_GetByNumTask]
(
@NumTask NVARCHAR(50) = ''
)
AS
BEGIN
SET NOCOUNT ON;
SET @NumTask = ISNULL(@NumTask, '')
SELECT *
FROM v_TaskRec
WHERE NumTask = @NumTask
ORDER BY DtStart DESC, DtEnd DESC, CodPost
END
GO
/****** Object: StoredProcedure [dbo].[stp_TR_GetByOpr] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware S.E.L.
-- Create date: 2018.09.04
-- Description: Recupera elenco Task Record x TaskNum
-- =============================================
CREATE PROCEDURE [dbo].[stp_TR_GetByOpr]
(
@CodOpr NVARCHAR(50) = ''
)
AS
BEGIN
SET NOCOUNT ON;
SET @CodOpr = ISNULL(@CodOpr, '')
SELECT *
FROM v_TaskRec
WHERE CodOpr = @CodOpr
ORDER BY DtStart DESC, DtEnd DESC, CodPost
END
GO
/****** Object: StoredProcedure [dbo].[stp_TR_GetByPost] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware S.E.L.
-- Create date: 2018.09.04
-- Description: Recupera elenco Task Record x Postazione
-- =============================================
CREATE PROCEDURE [dbo].[stp_TR_GetByPost]
(
@CodPost NVARCHAR(50) = ''
,@showAll BIT = 1 -- 1 = tutti, 0 = solo APERTI
)
AS
BEGIN
SET NOCOUNT ON;
SET @CodPost = ISNULL(@CodPost, '')
SELECT *
FROM v_TaskRec
WHERE CodPost = @CodPost
AND ((DtEnd IS NULL) OR @showAll = 1)
ORDER BY DtStart DESC, DtEnd DESC, CodPost
END
GO
/****** Object: StoredProcedure [dbo].[stp_TR_insertQuery] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware S.E.L.
-- Create date: 2018.09.04
-- Description: Creo una nuova registrazione
-- =============================================
CREATE PROCEDURE [dbo].[stp_TR_insertQuery]
(
@CodOpr NVARCHAR(50),
@CodPost NVARCHAR(50),
@NumTask NVARCHAR(50),
@CodFase NVARCHAR(50),
@DtStart DATETIME
)
AS
BEGIN
BEGIN tran
SET NOCOUNT ON;
SET @CodOpr = ISNULL(@CodOpr, '')
;WITH cteEv AS
(
SELECT NumTask, ISNULL(SUM(QtaEv),0) AS QtaEv
FROM TaskRec
WHERE NumTask = @NumTask
AND CodPost = @CodPost
AND CodFase = @CodFase
GROUP BY NumTask
)
, cteReq AS
(
SELECT (TL.QtaRic - ISNULL(TR.QtaEv,0)) AS QtaRic
FROM TaskList TL
LEFT OUTER JOIN cteEv TR ON TL.NumTask = TR.NumTask
WHERE TL.NumTask = @NumTask
)
-- inserisco REC
INSERT INTO TaskRec (CodOpr,CodPost,NumTask,CodFase,DtStart,QtaEv)
SELECT @CodOpr,@CodPost,@NumTask,@CodFase,@DtStart, QtaRic
FROM cteReq
COMMIT tran
END
GO
/****** Object: StoredProcedure [dbo].[stp_TR_updateQuery] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Steamware S.E.L.
-- Create date: 2018.09.04
-- Description: Update registrazione
-- =============================================
create PROCEDURE [dbo].[stp_TR_updateQuery]
(
@IdxRec INT,
@DtEnd DATETIME,
@QtaEv INT
)
AS
BEGIN
SET NOCOUNT ON;
UPDATE TaskRec
SET DtEnd = @DtEnd
,QtaEv = @QtaEv
WHERE IdxRec = @IdxRec
END
GO
/****** Object: StoredProcedure [dbo].[stp_Utenti_confirmResetAK] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.23
-- Description: Procedura registrazione NUOVA AuthKey utente con num usi
-- =============================================
create PROCEDURE [dbo].[stp_Utenti_confirmResetAK]
(
@email NVARCHAR(250),
@numAut INT = 1,
@authKey NVARCHAR(250)
)
AS
SET NOCOUNT ON;
UPDATE Utenti
SET numAuth = @numAut
, authKey = @authKey
, resetAuthKeyReq = 0
WHERE (email = @email)
GO
/****** Object: StoredProcedure [dbo].[stp_Utenti_DeleteQuery] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.23
-- Description: elimina utente
-- =============================================
CREATE PROCEDURE [dbo].[stp_Utenti_DeleteQuery]
(
@Original_USER_NAME nvarchar(50)
)
AS
SET NOCOUNT OFF;
DELETE FROM [dbo].[Utenti] WHERE ([USER_NAME] = @Original_USER_NAME)
GO
/****** Object: StoredProcedure [dbo].[stp_Utenti_getByEmail] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.22
-- Description: recupero utente da email
-- =============================================
CREATE PROCEDURE [dbo].[stp_Utenti_getByEmail]
(
@email nvarchar(250)
)
AS
SET NOCOUNT ON;
SELECT USER_NAME, cognome, nome, email, authKey, numAuth, attivo, CodGruppo, resetAuthKeyReq
FROM Utenti
WHERE (email = @email)
GO
/****** Object: StoredProcedure [dbo].[stp_Utenti_getByEmailAK] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.22
-- Description: recupero utente da email + auth key
-- =============================================
create PROCEDURE [dbo].[stp_Utenti_getByEmailAK]
(
@email NVARCHAR(250),
@authKey NVARCHAR(250)
)
AS
SET NOCOUNT ON;
SELECT *
FROM Utenti
WHERE (email = @email)
AND (authKey = @authKey)
GO
/****** Object: StoredProcedure [dbo].[stp_Utenti_getResetReq] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.23
-- Description: recupero utenti che han richiesto reset
-- =============================================
create PROCEDURE [dbo].[stp_Utenti_getResetReq]
AS
SET NOCOUNT ON;
SELECT *
FROM Utenti
WHERE resetAuthKeyReq = 1
GO
/****** Object: StoredProcedure [dbo].[stp_Utenti_InsertQuery] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.23
-- Description: inserisce NUOVO utente
-- =============================================
CREATE PROCEDURE [dbo].[stp_Utenti_InsertQuery]
(
@email nvarchar(250),
@cognome nvarchar(250),
@nome nvarchar(250),
@authKey nvarchar(250),
@numAuth int,
@CodGruppo nvarchar(50)
)
AS
SET NOCOUNT OFF;
INSERT INTO Utenti
(USER_NAME, cognome, nome, email, authKey, numAuth, attivo, CodGruppo, resetAuthKeyReq)
VALUES (@email,@cognome,@nome,@email,@authKey,@numAuth, 1,@CodGruppo, 0);
SELECT *
FROM Utenti WHERE (USER_NAME = @email)
GO
/****** Object: StoredProcedure [dbo].[stp_Utenti_recordAuthKeyUse] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.22
-- Description: Procedura registrazione utilizzo AuthKey utente (-1)
-- =============================================
create PROCEDURE [dbo].[stp_Utenti_recordAuthKeyUse]
(
@email nvarchar(250)
)
AS
SET NOCOUNT ON;
UPDATE Utenti
SET numAuth = numAuth - 1
WHERE (email = @email)
GO
/****** Object: StoredProcedure [dbo].[stp_Utenti_rejectResetAK] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.23
-- Description: Procedura con cui rifiuta reset AuthKey utente
-- =============================================
create PROCEDURE [dbo].[stp_Utenti_rejectResetAK]
(
@email NVARCHAR(250)
)
AS
SET NOCOUNT ON;
UPDATE Utenti
SET resetAuthKeyReq = 0
WHERE (email = @email)
GO
/****** Object: StoredProcedure [dbo].[stp_Utenti_reqAuthKeyReset] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.22
-- Description: Procedura registrazione richiesta reset AuthKey utente
-- =============================================
CREATE PROCEDURE [dbo].[stp_Utenti_reqAuthKeyReset]
(
@email nvarchar(250)
)
AS
SET NOCOUNT ON;
UPDATE Utenti
SET resetAuthKeyReq = 1
WHERE (email = @email)
GO
/****** Object: StoredProcedure [dbo].[stp_Utenti_ResetKeyAndDevices] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.23
-- Description: cambia AuthKey utente e disabilita relativi devices
-- =============================================
CREATE PROCEDURE [dbo].[stp_Utenti_ResetKeyAndDevices]
(
@NewAuthKey NVARCHAR(250)
, @Original_USER_NAME NVARCHAR(250)
)
AS
SET NOCOUNT OFF;
BEGIN TRAN
DELETE FROM AnagDevices
WHERE ([USER_NAME] = @Original_USER_NAME)
UPDATE Utenti
SET AuthKey = @NewAuthKey
, numAuth = 1
, resetAuthKeyReq = 0
WHERE ([USER_NAME] = @Original_USER_NAME)
COMMIT TRAN
RETURN
GO
/****** Object: StoredProcedure [dbo].[stp_Utenti_ToggleAttivo] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.23
-- Description: disabilita utente e relativi devices
-- =============================================
CREATE PROCEDURE [dbo].[stp_Utenti_ToggleAttivo]
(
@NewAuthKey NVARCHAR(250)
, @Original_USER_NAME NVARCHAR(250)
)
AS
SET NOCOUNT OFF;
BEGIN TRAN
DECLARE @attivo BIT
SELECT @attivo = attivo
FROM Utenti
WHERE ([USER_NAME] = @Original_USER_NAME)
--UPDATE Utenti
--SET attivo = 1 - @attivo
--WHERE ([USER_NAME] = @Original_USER_NAME);
-- se è disattivo elimino devices...
IF(@attivo = 1)
BEGIN
DELETE FROM AnagDevices
WHERE ([USER_NAME] = @Original_USER_NAME);
UPDATE Utenti
SET attivo = 0
, numAuth = 0
WHERE ([USER_NAME] = @Original_USER_NAME);
END
-- altrimenti genero NUOVA chiave auth...
ELSE
BEGIN
UPDATE Utenti
SET AuthKey = @NewAuthKey
, attivo = 1
, numAuth = 1
WHERE ([USER_NAME] = @Original_USER_NAME);
END
COMMIT TRAN
RETURN
GO
/****** Object: StoredProcedure [dbo].[stp_Utenti_UpdateNumAuth] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.23
-- Description: update Num Auth utente
-- =============================================
create PROCEDURE [dbo].[stp_Utenti_UpdateNumAuth]
(
@deltaNumAuth INT
, @Original_USER_NAME NVARCHAR(250)
)
AS
SET NOCOUNT OFF;
UPDATE Utenti
SET numAuth = CASE WHEN numAuth + @deltaNumAuth < 0 THEN 0 ELSE numAuth + @deltaNumAuth END
WHERE ([USER_NAME] = @Original_USER_NAME);
SELECT *
FROM Utenti WHERE([USER_NAME] = @Original_USER_NAME) ;
RETURN
GO
/****** Object: StoredProcedure [dbo].[stp_Utenti_UpdateQuery] Script Date: 05/09/2018 15:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: S.E. Locatelli
-- Create date: 2014.09.23
-- Description: update campi utente
-- =============================================
CREATE PROCEDURE [dbo].[stp_Utenti_UpdateQuery]
(
@email NVARCHAR(250)
, @cognome NVARCHAR(250)
, @nome NVARCHAR(250)
, @authKey NVARCHAR(250)
, @numAuth INT
, @CodGruppo NVARCHAR(50)
, @Original_USER_NAME NVARCHAR(250)
)
AS
SET NOCOUNT OFF;
UPDATE [dbo].[Utenti]
SET [USER_NAME] = @email
, [cognome] = @cognome
, [nome] = @nome
, [email] = @email
, [authKey] = CASE WHEN @authKey = '' THEN authKey ELSE @authKey END
, [numAuth] = @numAuth
, [CodGruppo] = @CodGruppo
WHERE ([USER_NAME] = @Original_USER_NAME);
SELECT *
FROM Utenti WHERE([USER_NAME] = @Original_USER_NAME) ;
RETURN
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'descrive il significato dell''evento, tra dipo conferma/annulla/azione' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AnagEventi', @level2type=N'COLUMN',@level2name=N'Action'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Codice fase con nome tipo GRUPPO.NUM' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AnagFasi', @level2type=N'COLUMN',@level2name=N'CodFase'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'indica se si deve registrare un tempo (periodo inizio/fine) per fase o solo fatta (es magazziniere se preleva amteriale)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AnagFasi'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Codice di "preselezione" delel fasi ammesse' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AnagPost', @level2type=N'COLUMN',@level2name=N'PreselFasi'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Codice fase con nome tipo GRUPPO.NUM' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TaskRec', @level2type=N'COLUMN',@level2name=N'CodFase'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'eventuale comando da eseguire' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TraEv2Stati'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'numero di impieghi della authKey' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Utenti', @level2type=N'COLUMN',@level2name=N'numAuth'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'indica che c''è attiva una richeista di reset della Auth Key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Utenti', @level2type=N'COLUMN',@level2name=N'resetAuthKeyReq'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
Begin PaneConfigurations =
Begin PaneConfiguration = 0
NumPanes = 4
Configuration = "(H (1[40] 4[20] 2[20] 3) )"
End
Begin PaneConfiguration = 1
NumPanes = 3
Configuration = "(H (1 [50] 4 [25] 3))"
End
Begin PaneConfiguration = 2
NumPanes = 3
Configuration = "(H (1 [50] 2 [25] 3))"
End
Begin PaneConfiguration = 3
NumPanes = 3
Configuration = "(H (4 [30] 2 [40] 3))"
End
Begin PaneConfiguration = 4
NumPanes = 2
Configuration = "(H (1 [56] 3))"
End
Begin PaneConfiguration = 5
NumPanes = 2
Configuration = "(H (2 [66] 3))"
End
Begin PaneConfiguration = 6
NumPanes = 2
Configuration = "(H (4 [50] 3))"
End
Begin PaneConfiguration = 7
NumPanes = 1
Configuration = "(V (3))"
End
Begin PaneConfiguration = 8
NumPanes = 3
Configuration = "(H (1[56] 4[18] 2) )"
End
Begin PaneConfiguration = 9
NumPanes = 2
Configuration = "(H (1 [75] 4))"
End
Begin PaneConfiguration = 10
NumPanes = 2
Configuration = "(H (1[66] 2) )"
End
Begin PaneConfiguration = 11
NumPanes = 2
Configuration = "(H (4 [60] 2))"
End
Begin PaneConfiguration = 12
NumPanes = 1
Configuration = "(H (1) )"
End
Begin PaneConfiguration = 13
NumPanes = 1
Configuration = "(V (4))"
End
Begin PaneConfiguration = 14
NumPanes = 1
Configuration = "(V (2))"
End
ActivePaneConfig = 0
End
Begin DiagramPane =
Begin Origin =
Top = 0
Left = 0
End
Begin Tables =
Begin Table = "AnagPost"
Begin Extent =
Top = 7
Left = 48
Bottom = 170
Right = 242
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "AnagOpr"
Begin Extent =
Top = 16
Left = 392
Bottom = 157
Right = 586
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 9
Width = 284
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
End
End
Begin CriteriaPane =
Begin ColumnWidths = 11
Column = 1440
Alias = 900
Table = 1170
Output = 720
Append = 1400
NewValue = 1170
SortType = 1350
SortOrder = 1410
GroupBy = 1350
Filter = 1350
Or = 1350
Or = 1350
Or = 1350
End
End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_AnagPost'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_AnagPost'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
Begin PaneConfigurations =
Begin PaneConfiguration = 0
NumPanes = 4
Configuration = "(H (1[40] 4[20] 2[20] 3) )"
End
Begin PaneConfiguration = 1
NumPanes = 3
Configuration = "(H (1 [50] 4 [25] 3))"
End
Begin PaneConfiguration = 2
NumPanes = 3
Configuration = "(H (1 [50] 2 [25] 3))"
End
Begin PaneConfiguration = 3
NumPanes = 3
Configuration = "(H (4 [30] 2 [40] 3))"
End
Begin PaneConfiguration = 4
NumPanes = 2
Configuration = "(H (1 [56] 3))"
End
Begin PaneConfiguration = 5
NumPanes = 2
Configuration = "(H (2 [66] 3))"
End
Begin PaneConfiguration = 6
NumPanes = 2
Configuration = "(H (4 [50] 3))"
End
Begin PaneConfiguration = 7
NumPanes = 1
Configuration = "(V (3))"
End
Begin PaneConfiguration = 8
NumPanes = 3
Configuration = "(H (1[56] 4[18] 2) )"
End
Begin PaneConfiguration = 9
NumPanes = 2
Configuration = "(H (1 [75] 4))"
End
Begin PaneConfiguration = 10
NumPanes = 2
Configuration = "(H (1[66] 2) )"
End
Begin PaneConfiguration = 11
NumPanes = 2
Configuration = "(H (4 [60] 2))"
End
Begin PaneConfiguration = 12
NumPanes = 1
Configuration = "(H (1) )"
End
Begin PaneConfiguration = 13
NumPanes = 1
Configuration = "(V (4))"
End
Begin PaneConfiguration = 14
NumPanes = 1
Configuration = "(V (2))"
End
ActivePaneConfig = 0
End
Begin DiagramPane =
Begin Origin =
Top = 0
Left = 0
End
Begin Tables =
Begin Table = "v_TaskRecCount"
Begin Extent =
Top = 38
Left = 319
Bottom = 157
Right = 513
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "TaskList"
Begin Extent =
Top = 38
Left = 43
Bottom = 299
Right = 237
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 10
Width = 284
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
End
End
Begin CriteriaPane =
Begin ColumnWidths = 11
Column = 1440
Alias = 900
Table = 1176
Output = 720
Append = 1400
NewValue = 1170
SortType = 1356
SortOrder = 1416
GroupBy = 1356
Filter = 1356
Or = 1350
Or = 1350
Or = 1350
End
End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_TaskList'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_TaskList'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
Begin PaneConfigurations =
Begin PaneConfiguration = 0
NumPanes = 4
Configuration = "(H (1[40] 4[20] 2[20] 3) )"
End
Begin PaneConfiguration = 1
NumPanes = 3
Configuration = "(H (1 [50] 4 [25] 3))"
End
Begin PaneConfiguration = 2
NumPanes = 3
Configuration = "(H (1 [50] 2 [25] 3))"
End
Begin PaneConfiguration = 3
NumPanes = 3
Configuration = "(H (4 [30] 2 [40] 3))"
End
Begin PaneConfiguration = 4
NumPanes = 2
Configuration = "(H (1 [56] 3))"
End
Begin PaneConfiguration = 5
NumPanes = 2
Configuration = "(H (2 [66] 3))"
End
Begin PaneConfiguration = 6
NumPanes = 2
Configuration = "(H (4 [50] 3))"
End
Begin PaneConfiguration = 7
NumPanes = 1
Configuration = "(V (3))"
End
Begin PaneConfiguration = 8
NumPanes = 3
Configuration = "(H (1[56] 4[18] 2) )"
End
Begin PaneConfiguration = 9
NumPanes = 2
Configuration = "(H (1 [75] 4))"
End
Begin PaneConfiguration = 10
NumPanes = 2
Configuration = "(H (1[66] 2) )"
End
Begin PaneConfiguration = 11
NumPanes = 2
Configuration = "(H (4 [60] 2))"
End
Begin PaneConfiguration = 12
NumPanes = 1
Configuration = "(H (1) )"
End
Begin PaneConfiguration = 13
NumPanes = 1
Configuration = "(V (4))"
End
Begin PaneConfiguration = 14
NumPanes = 1
Configuration = "(V (2))"
End
ActivePaneConfig = 0
End
Begin DiagramPane =
Begin Origin =
Top = 0
Left = 0
End
Begin Tables =
Begin Table = "TR"
Begin Extent =
Top = 19
Left = 382
Bottom = 323
Right = 576
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "TL"
Begin Extent =
Top = 204
Left = 32
Bottom = 367
Right = 226
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "AF"
Begin Extent =
Top = 118
Left = 974
Bottom = 281
Right = 1168
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "AP"
Begin Extent =
Top = 4
Left = 666
Bottom = 167
Right = 860
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "AO"
Begin Extent =
Top = 11
Left = 41
Bottom = 152
Right = 235
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 9
Width = 284
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
End
End
Begin CriteriaPane =
Begin ColumnWidths = 11
Column = 1440
Alias = 900
Table = 1176
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_TaskRec'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'Output = 720
Append = 1400
NewValue = 1170
SortType = 1356
SortOrder = 1416
GroupBy = 1350
Filter = 1356
Or = 1350
Or = 1350
Or = 1350
End
End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_TaskRec'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_TaskRec'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
Begin PaneConfigurations =
Begin PaneConfiguration = 0
NumPanes = 4
Configuration = "(H (1[40] 4[20] 2[20] 3) )"
End
Begin PaneConfiguration = 1
NumPanes = 3
Configuration = "(H (1 [50] 4 [25] 3))"
End
Begin PaneConfiguration = 2
NumPanes = 3
Configuration = "(H (1 [50] 2 [25] 3))"
End
Begin PaneConfiguration = 3
NumPanes = 3
Configuration = "(H (4 [30] 2 [40] 3))"
End
Begin PaneConfiguration = 4
NumPanes = 2
Configuration = "(H (1 [56] 3))"
End
Begin PaneConfiguration = 5
NumPanes = 2
Configuration = "(H (2 [66] 3))"
End
Begin PaneConfiguration = 6
NumPanes = 2
Configuration = "(H (4 [50] 3))"
End
Begin PaneConfiguration = 7
NumPanes = 1
Configuration = "(V (3))"
End
Begin PaneConfiguration = 8
NumPanes = 3
Configuration = "(H (1[56] 4[18] 2) )"
End
Begin PaneConfiguration = 9
NumPanes = 2
Configuration = "(H (1 [75] 4))"
End
Begin PaneConfiguration = 10
NumPanes = 2
Configuration = "(H (1[66] 2) )"
End
Begin PaneConfiguration = 11
NumPanes = 2
Configuration = "(H (4 [60] 2))"
End
Begin PaneConfiguration = 12
NumPanes = 1
Configuration = "(H (1) )"
End
Begin PaneConfiguration = 13
NumPanes = 1
Configuration = "(V (4))"
End
Begin PaneConfiguration = 14
NumPanes = 1
Configuration = "(V (2))"
End
ActivePaneConfig = 0
End
Begin DiagramPane =
Begin Origin =
Top = 0
Left = 0
End
Begin Tables =
Begin Table = "TaskRec"
Begin Extent =
Top = 7
Left = 48
Bottom = 262
Right = 242
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 9
Width = 284
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
Width = 1200
End
End
Begin CriteriaPane =
Begin ColumnWidths = 12
Column = 1440
Alias = 900
Table = 1176
Output = 720
Append = 1400
NewValue = 1170
SortType = 1356
SortOrder = 1416
GroupBy = 1350
Filter = 1356
Or = 1350
Or = 1350
Or = 1350
End
End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_TaskRecCount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_TaskRecCount'
GO
USE [master]
GO
ALTER DATABASE [C_TRACK] SET READ_WRITE
GO
Reference in New Issue View Git Blame Copy Permalink