Egalware/XPS
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
develop
XPS/XPS_data/MDB_Data/SP_DB_init.sql
T
Samuele Locatelli 5d99b976a3 spostamento XPS_data
2017-01-31 14:34:55 +01:00

4890 lines
484 KiB
Transact-SQL
Raw Permalink Blame History

/****** Object: ForeignKey [FK_AnagObj_AnagFamStati] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AnagObj_AnagFamStati]') AND parent_object_id = OBJECT_ID(N'[dbo].[AnagObj]'))
ALTER TABLE [dbo].[AnagObj] DROP CONSTRAINT [FK_AnagObj_AnagFamStati]
GO
/****** Object: ForeignKey [FK_AnagStati_AnagFamStati] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AnagStati_AnagFamStati]') AND parent_object_id = OBJECT_ID(N'[dbo].[AnagStati]'))
ALTER TABLE [dbo].[AnagStati] DROP CONSTRAINT [FK_AnagStati_AnagFamStati]
GO
/****** Object: ForeignKey [FK_Eventi_TipoEventi] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Eventi_TipoEventi]') AND parent_object_id = OBJECT_ID(N'[dbo].[Eventi]'))
ALTER TABLE [dbo].[Eventi] DROP CONSTRAINT [FK_Eventi_TipoEventi]
GO
/****** Object: ForeignKey [FK_Fasi2Obj_AnafFasiObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Fasi2Obj_AnafFasiObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[Fasi2Obj]'))
ALTER TABLE [dbo].[Fasi2Obj] DROP CONSTRAINT [FK_Fasi2Obj_AnafFasiObj]
GO
/****** Object: ForeignKey [FK_Fasi2Obj_AnagObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Fasi2Obj_AnagObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[Fasi2Obj]'))
ALTER TABLE [dbo].[Fasi2Obj] DROP CONSTRAINT [FK_Fasi2Obj_AnagObj]
GO
/****** Object: ForeignKey [FK_Filtro2Funzione_AnagFiltri] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Filtro2Funzione_AnagFiltri]') AND parent_object_id = OBJECT_ID(N'[dbo].[Filtro2Funzione]'))
ALTER TABLE [dbo].[Filtro2Funzione] DROP CONSTRAINT [FK_Filtro2Funzione_AnagFiltri]
GO
/****** Object: ForeignKey [FK_Filtro2Stati_AnagFiltri] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Filtro2Stati_AnagFiltri]') AND parent_object_id = OBJECT_ID(N'[dbo].[Filtro2Stati]'))
ALTER TABLE [dbo].[Filtro2Stati] DROP CONSTRAINT [FK_Filtro2Stati_AnagFiltri]
GO
/****** Object: ForeignKey [FK_Filtro2Stati_AnagStati] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Filtro2Stati_AnagStati]') AND parent_object_id = OBJECT_ID(N'[dbo].[Filtro2Stati]'))
ALTER TABLE [dbo].[Filtro2Stati] DROP CONSTRAINT [FK_Filtro2Stati_AnagStati]
GO
/****** Object: ForeignKey [FK_FasiObj_ObjList] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_FasiObj_ObjList]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstFasiObj]'))
ALTER TABLE [dbo].[IstFasiObj] DROP CONSTRAINT [FK_FasiObj_ObjList]
GO
/****** Object: ForeignKey [FK_IstObj_AnagClienti] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_IstObj_AnagClienti]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstObj]'))
ALTER TABLE [dbo].[IstObj] DROP CONSTRAINT [FK_IstObj_AnagClienti]
GO
/****** Object: ForeignKey [FK_IstObj_UM] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_IstObj_UM]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstObj]'))
ALTER TABLE [dbo].[IstObj] DROP CONSTRAINT [FK_IstObj_UM]
GO
/****** Object: ForeignKey [FK_ObjList_AnagStati] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ObjList_AnagStati]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstObj]'))
ALTER TABLE [dbo].[IstObj] DROP CONSTRAINT [FK_ObjList_AnagStati]
GO
/****** Object: ForeignKey [FK_TrackObj_AnagObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TrackObj_AnagObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstObj]'))
ALTER TABLE [dbo].[IstObj] DROP CONSTRAINT [FK_TrackObj_AnagObj]
GO
/****** Object: ForeignKey [FK_WBS2Fasi_FasiObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_WBS2Fasi_FasiObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstWbsFasi]'))
ALTER TABLE [dbo].[IstWbsFasi] DROP CONSTRAINT [FK_WBS2Fasi_FasiObj]
GO
/****** Object: ForeignKey [FK_LogStatoIstObj_IstObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_LogStatoIstObj_IstObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogStatoIstObj]'))
ALTER TABLE [dbo].[LogStatoIstObj] DROP CONSTRAINT [FK_LogStatoIstObj_IstObj]
GO
/****** Object: ForeignKey [FK_Note_ObjList] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Note_ObjList]') AND parent_object_id = OBJECT_ID(N'[dbo].[Note]'))
ALTER TABLE [dbo].[Note] DROP CONSTRAINT [FK_Note_ObjList]
GO
/****** Object: ForeignKey [FK_Object2Set_AnagSet] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Object2Set_AnagSet]') AND parent_object_id = OBJECT_ID(N'[dbo].[Object2Set]'))
ALTER TABLE [dbo].[Object2Set] DROP CONSTRAINT [FK_Object2Set_AnagSet]
GO
/****** Object: ForeignKey [FK_ObjectSet_AnagTipoObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ObjectSet_AnagTipoObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[Object2Set]'))
ALTER TABLE [dbo].[Object2Set] DROP CONSTRAINT [FK_ObjectSet_AnagTipoObj]
GO
/****** Object: ForeignKey [FK_Permessi2Funzione_Permessi] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Permessi2Funzione_Permessi]') AND parent_object_id = OBJECT_ID(N'[dbo].[Permessi2Funzione]'))
ALTER TABLE [dbo].[Permessi2Funzione] DROP CONSTRAINT [FK_Permessi2Funzione_Permessi]
GO
/****** Object: ForeignKey [FK_Risorse2TT_AnagRisorse] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Risorse2TT_AnagRisorse]') AND parent_object_id = OBJECT_ID(N'[dbo].[Risorse2TT]'))
ALTER TABLE [dbo].[Risorse2TT] DROP CONSTRAINT [FK_Risorse2TT_AnagRisorse]
GO
/****** Object: ForeignKey [FK_Risorse2TT_TimeTrack] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Risorse2TT_TimeTrack]') AND parent_object_id = OBJECT_ID(N'[dbo].[Risorse2TT]'))
ALTER TABLE [dbo].[Risorse2TT] DROP CONSTRAINT [FK_Risorse2TT_TimeTrack]
GO
/****** Object: ForeignKey [FK_Risorse2TT_UmMisure] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Risorse2TT_UmMisure]') AND parent_object_id = OBJECT_ID(N'[dbo].[Risorse2TT]'))
ALTER TABLE [dbo].[Risorse2TT] DROP CONSTRAINT [FK_Risorse2TT_UmMisure]
GO
/****** Object: ForeignKey [FK_Fasi_Oggetti] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Fasi_Oggetti]') AND parent_object_id = OBJECT_ID(N'[dbo].[Step]'))
ALTER TABLE [dbo].[Step] DROP CONSTRAINT [FK_Fasi_Oggetti]
GO
/****** Object: ForeignKey [FK_FasiObj_TrackObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_FasiObj_TrackObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[Step4Obj]'))
ALTER TABLE [dbo].[Step4Obj] DROP CONSTRAINT [FK_FasiObj_TrackObj]
GO
/****** Object: ForeignKey [FK_TimeTrack_FasiObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TimeTrack_FasiObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[TimeTrack]'))
ALTER TABLE [dbo].[TimeTrack] DROP CONSTRAINT [FK_TimeTrack_FasiObj]
GO
/****** Object: ForeignKey [FK_TraEv2Stati_AnagObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TraEv2Stati_AnagObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[TraEv2Stati]'))
ALTER TABLE [dbo].[TraEv2Stati] DROP CONSTRAINT [FK_TraEv2Stati_AnagObj]
GO
/****** Object: ForeignKey [FK_TraEv2Stati_AnagStati] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TraEv2Stati_AnagStati]') AND parent_object_id = OBJECT_ID(N'[dbo].[TraEv2Stati]'))
ALTER TABLE [dbo].[TraEv2Stati] DROP CONSTRAINT [FK_TraEv2Stati_AnagStati]
GO
/****** Object: ForeignKey [FK_TransizioneEventiStati_AnagMappe] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TransizioneEventiStati_AnagMappe]') AND parent_object_id = OBJECT_ID(N'[dbo].[TraEv2Stati]'))
ALTER TABLE [dbo].[TraEv2Stati] DROP CONSTRAINT [FK_TransizioneEventiStati_AnagMappe]
GO
/****** Object: ForeignKey [FK_TransizioneEventiStati_Eventi] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TransizioneEventiStati_Eventi]') AND parent_object_id = OBJECT_ID(N'[dbo].[TraEv2Stati]'))
ALTER TABLE [dbo].[TraEv2Stati] DROP CONSTRAINT [FK_TransizioneEventiStati_Eventi]
GO
/****** Object: ForeignKey [FK_Tratt2Obj_AnagTrattamenti] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Tratt2Obj_AnagTrattamenti]') AND parent_object_id = OBJECT_ID(N'[dbo].[Tratt2Obj]'))
ALTER TABLE [dbo].[Tratt2Obj] DROP CONSTRAINT [FK_Tratt2Obj_AnagTrattamenti]
GO
/****** Object: ForeignKey [FK_Tratt2Obj_IstObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Tratt2Obj_IstObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[Tratt2Obj]'))
ALTER TABLE [dbo].[Tratt2Obj] DROP CONSTRAINT [FK_Tratt2Obj_IstObj]
GO
/****** Object: ForeignKey [FK_Wbs2Links_AnagLink] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Wbs2Links_AnagLink]') AND parent_object_id = OBJECT_ID(N'[dbo].[WbsFasi2Links]'))
ALTER TABLE [dbo].[WbsFasi2Links] DROP CONSTRAINT [FK_Wbs2Links_AnagLink]
GO
/****** Object: ForeignKey [FK_Wbs2Links_Fasi2Obj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Wbs2Links_Fasi2Obj]') AND parent_object_id = OBJECT_ID(N'[dbo].[WbsFasi2Links]'))
ALTER TABLE [dbo].[WbsFasi2Links] DROP CONSTRAINT [FK_Wbs2Links_Fasi2Obj]
GO
/****** Object: StoredProcedure [dbo].[sp_schedaIdent] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_schedaIdent]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_schedaIdent]
GO
/****** Object: StoredProcedure [dbo].[sp_creaSetObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_creaSetObj]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_creaSetObj]
GO
/****** Object: StoredProcedure [dbo].[sp_updateAncestorState] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_updateAncestorState]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_updateAncestorState]
GO
/****** Object: View [dbo].[v_righe] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_righe]'))
DROP VIEW [dbo].[v_righe]
GO
/****** Object: View [dbo].[v_commesse] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_commesse]'))
DROP VIEW [dbo].[v_commesse]
GO
/****** Object: View [dbo].[v_selTipoEvento] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_selTipoEvento]'))
DROP VIEW [dbo].[v_selTipoEvento]
GO
/****** Object: View [dbo].[v_selAnagLav] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_selAnagLav]'))
DROP VIEW [dbo].[v_selAnagLav]
GO
/****** Object: View [dbo].[v_statoStartFam] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_statoStartFam]'))
DROP VIEW [dbo].[v_statoStartFam]
GO
/****** Object: View [dbo].[v_selStati] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_selStati]'))
DROP VIEW [dbo].[v_selStati]
GO
/****** Object: View [dbo].[v_selFiltri] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_selFiltri]'))
DROP VIEW [dbo].[v_selFiltri]
GO
/****** Object: View [dbo].[v_logStati] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_logStati]'))
DROP VIEW [dbo].[v_logStati]
GO
/****** Object: StoredProcedure [dbo].[sp_contaNonSched] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_contaNonSched]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_contaNonSched]
GO
/****** Object: View [dbo].[v_ULP_DDT] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_ULP_DDT]'))
DROP VIEW [dbo].[v_ULP_DDT]
GO
/****** Object: View [dbo].[v_righeDDT] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_righeDDT]'))
DROP VIEW [dbo].[v_righeDDT]
GO
/****** Object: View [dbo].[v_dateEsecuzione] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_dateEsecuzione]'))
DROP VIEW [dbo].[v_dateEsecuzione]
GO
/****** Object: View [dbo].[v_ULP_DDT4Row] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_ULP_DDT4Row]'))
DROP VIEW [dbo].[v_ULP_DDT4Row]
GO
/****** Object: StoredProcedure [dbo].[sp_clonaObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_clonaObj]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_clonaObj]
GO
/****** Object: StoredProcedure [dbo].[sp_clonaRowObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_clonaRowObj]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_clonaRowObj]
GO
/****** Object: View [dbo].[v_selSetObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_selSetObj]'))
DROP VIEW [dbo].[v_selSetObj]
GO
/****** Object: View [dbo].[v_schedaIdent] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_schedaIdent]'))
DROP VIEW [dbo].[v_schedaIdent]
GO
/****** Object: View [dbo].[v_ULP] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_ULP]'))
DROP VIEW [dbo].[v_ULP]
GO
/****** Object: View [dbo].[v_selClienti] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_selClienti]'))
DROP VIEW [dbo].[v_selClienti]
GO
/****** Object: View [dbo].[v_selTipoMappa] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_selTipoMappa]'))
DROP VIEW [dbo].[v_selTipoMappa]
GO
/****** Object: Table [dbo].[IstWbsFasi] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[IstWbsFasi]') AND type in (N'U'))
DROP TABLE [dbo].[IstWbsFasi]
GO
/****** Object: Table [dbo].[Filtro2Stati] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Filtro2Stati]') AND type in (N'U'))
DROP TABLE [dbo].[Filtro2Stati]
GO
/****** Object: Table [dbo].[Filtro2Funzione] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Filtro2Funzione]') AND type in (N'U'))
DROP TABLE [dbo].[Filtro2Funzione]
GO
/****** Object: Table [dbo].[Note] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Note]') AND type in (N'U'))
DROP TABLE [dbo].[Note]
GO
/****** Object: Table [dbo].[LogStatoIstObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LogStatoIstObj]') AND type in (N'U'))
DROP TABLE [dbo].[LogStatoIstObj]
GO
/****** Object: Table [dbo].[Step4Obj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Step4Obj]') AND type in (N'U'))
DROP TABLE [dbo].[Step4Obj]
GO
/****** Object: Table [dbo].[Permessi2Funzione] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Permessi2Funzione]') AND type in (N'U'))
DROP TABLE [dbo].[Permessi2Funzione]
GO
/****** Object: Table [dbo].[Step] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Step]') AND type in (N'U'))
DROP TABLE [dbo].[Step]
GO
/****** Object: Table [dbo].[Object2Set] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Object2Set]') AND type in (N'U'))
DROP TABLE [dbo].[Object2Set]
GO
/****** Object: Table [dbo].[WbsFasi2Links] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WbsFasi2Links]') AND type in (N'U'))
DROP TABLE [dbo].[WbsFasi2Links]
GO
/****** Object: Table [dbo].[Fasi2Obj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Fasi2Obj]') AND type in (N'U'))
DROP TABLE [dbo].[Fasi2Obj]
GO
/****** Object: Table [dbo].[Tratt2Obj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Tratt2Obj]') AND type in (N'U'))
DROP TABLE [dbo].[Tratt2Obj]
GO
/****** Object: Table [dbo].[TraEv2Stati] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TraEv2Stati]') AND type in (N'U'))
DROP TABLE [dbo].[TraEv2Stati]
GO
/****** Object: Table [dbo].[Eventi] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Eventi]') AND type in (N'U'))
DROP TABLE [dbo].[Eventi]
GO
/****** Object: Table [dbo].[Risorse2TT] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Risorse2TT]') AND type in (N'U'))
DROP TABLE [dbo].[Risorse2TT]
GO
/****** Object: Table [dbo].[TimeTrack] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TimeTrack]') AND type in (N'U'))
DROP TABLE [dbo].[TimeTrack]
GO
/****** Object: Table [dbo].[IstFasiObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[IstFasiObj]') AND type in (N'U'))
DROP TABLE [dbo].[IstFasiObj]
GO
/****** Object: Table [dbo].[IstObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[IstObj]') AND type in (N'U'))
DROP TABLE [dbo].[IstObj]
GO
/****** Object: Table [dbo].[AnagStati] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagStati]') AND type in (N'U'))
DROP TABLE [dbo].[AnagStati]
GO
/****** Object: Table [dbo].[AnagObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagObj]') AND type in (N'U'))
DROP TABLE [dbo].[AnagObj]
GO
/****** Object: Table [dbo].[TipoEventi] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TipoEventi]') AND type in (N'U'))
DROP TABLE [dbo].[TipoEventi]
GO
/****** Object: StoredProcedure [dbo].[sp_clonaStati] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_clonaStati]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_clonaStati]
GO
/****** Object: Table [dbo].[AnagLav] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagLav]') AND type in (N'U'))
DROP TABLE [dbo].[AnagLav]
GO
/****** Object: UserDefinedFunction [dbo].[DateOnly] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DateOnly]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[DateOnly]
GO
/****** Object: Table [dbo].[AnagFamStati] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagFamStati]') AND type in (N'U'))
DROP TABLE [dbo].[AnagFamStati]
GO
/****** Object: Table [dbo].[AnagFiltri] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagFiltri]') AND type in (N'U'))
DROP TABLE [dbo].[AnagFiltri]
GO
/****** Object: Table [dbo].[AnagFasiObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagFasiObj]') AND type in (N'U'))
DROP TABLE [dbo].[AnagFasiObj]
GO
/****** Object: Table [dbo].[UM] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UM]') AND type in (N'U'))
DROP TABLE [dbo].[UM]
GO
/****** Object: UserDefinedFunction [dbo].[f_padLeft] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[f_padLeft]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[f_padLeft]
GO
/****** Object: Table [dbo].[Permessi] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Permessi]') AND type in (N'U'))
DROP TABLE [dbo].[Permessi]
GO
/****** Object: StoredProcedure [dbo].[sp_delRow] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_delRow]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_delRow]
GO
/****** Object: StoredProcedure [dbo].[sp_rec4Day] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_rec4Day]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_rec4Day]
GO
/****** Object: StoredProcedure [dbo].[sp_clonaTransizEventi] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_clonaTransizEventi]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_clonaTransizEventi]
GO
/****** Object: StoredProcedure [dbo].[sp_delObj] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_delObj]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_delObj]
GO
/****** Object: Table [dbo].[AnagSet] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagSet]') AND type in (N'U'))
DROP TABLE [dbo].[AnagSet]
GO
/****** Object: Table [dbo].[AnagTrattamenti] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagTrattamenti]') AND type in (N'U'))
DROP TABLE [dbo].[AnagTrattamenti]
GO
/****** Object: Table [dbo].[AnagClienti] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagClienti]') AND type in (N'U'))
DROP TABLE [dbo].[AnagClienti]
GO
/****** Object: Table [dbo].[AnagMappe] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagMappe]') AND type in (N'U'))
DROP TABLE [dbo].[AnagMappe]
GO
/****** Object: Table [dbo].[AnagRisorse] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagRisorse]') AND type in (N'U'))
DROP TABLE [dbo].[AnagRisorse]
GO
/****** Object: Table [dbo].[AnagLink] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagLink]') AND type in (N'U'))
DROP TABLE [dbo].[AnagLink]
GO
/****** Object: Default [DF_AnagTipoObj_isLogical] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_AnagTipoObj_isLogical]') AND parent_object_id = OBJECT_ID(N'[dbo].[AnagObj]'))
Begin
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_AnagTipoObj_isLogical]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[AnagObj] DROP CONSTRAINT [DF_AnagTipoObj_isLogical]
END
End
GO
/****** Object: Default [DF_ObjectSet_MinOcc] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_ObjectSet_MinOcc]') AND parent_object_id = OBJECT_ID(N'[dbo].[Object2Set]'))
Begin
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ObjectSet_MinOcc]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Object2Set] DROP CONSTRAINT [DF_ObjectSet_MinOcc]
END
End
GO
/****** Object: Default [DF_ObjectSet_MaxOcc] Script Date: 11/21/2008 15:51:46 ******/
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_ObjectSet_MaxOcc]') AND parent_object_id = OBJECT_ID(N'[dbo].[Object2Set]'))
Begin
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ObjectSet_MaxOcc]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Object2Set] DROP CONSTRAINT [DF_ObjectSet_MaxOcc]
END
End
GO
/****** Object: Role [steamware] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'steamware')
BEGIN
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'steamware' AND type = 'R')
CREATE ROLE [steamware]
END
GO
/****** Object: Table [dbo].[AnagLink] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagLink]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AnagLink](
[LinkType] [int] NOT NULL,
[DescrLink] [nchar](10) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_AnagLink] PRIMARY KEY CLUSTERED
(
[LinkType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
INSERT [dbo].[AnagLink] ([LinkType], [DescrLink]) VALUES (1, N'StartAfter')
INSERT [dbo].[AnagLink] ([LinkType], [DescrLink]) VALUES (2, N'SameEnd ')
INSERT [dbo].[AnagLink] ([LinkType], [DescrLink]) VALUES (3, N'SameStart ')
/****** Object: Table [dbo].[AnagRisorse] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagRisorse]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AnagRisorse](
[CodRisorsa] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[DescrRisorsa] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_AnagRisorse] PRIMARY KEY CLUSTERED
(
[CodRisorsa] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
/****** Object: Table [dbo].[AnagMappe] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagMappe]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AnagMappe](
[CodMappa] [nvarchar](20) COLLATE Latin1_General_CI_AS NOT NULL,
[DescrMappa] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_AnagMappe] PRIMARY KEY CLUSTERED
(
[CodMappa] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
INSERT [dbo].[AnagMappe] ([CodMappa], [DescrMappa]) VALUES (N'E_BC', N'Mappa Equa per Barcode')
INSERT [dbo].[AnagMappe] ([CodMappa], [DescrMappa]) VALUES (N'E_Proc', N'Mappa Equa per processo')
INSERT [dbo].[AnagMappe] ([CodMappa], [DescrMappa]) VALUES (N'E_Stati', N'Mappa Equa Stati')
INSERT [dbo].[AnagMappe] ([CodMappa], [DescrMappa]) VALUES (N'E_Step', N'Mappa Equa Step')
/****** Object: Table [dbo].[AnagClienti] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagClienti]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AnagClienti](
[CodCliente] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[RagioneSociale] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_AnagClienti] PRIMARY KEY CLUSTERED
(
[CodCliente] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
INSERT [dbo].[AnagClienti] ([CodCliente], [RagioneSociale]) VALUES (N'ACME', N'ACME spa di willcoyote')
INSERT [dbo].[AnagClienti] ([CodCliente], [RagioneSociale]) VALUES (N'PERSICO', N'Persico SpA')
INSERT [dbo].[AnagClienti] ([CodCliente], [RagioneSociale]) VALUES (N'SMI', N'SMI s.r.l.')
/****** Object: Table [dbo].[AnagTrattamenti] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagTrattamenti]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AnagTrattamenti](
[CodTrattamento] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[DescrTrattamento] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_AnagTrattamenti] PRIMARY KEY CLUSTERED
(
[CodTrattamento] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
INSERT [dbo].[AnagTrattamenti] ([CodTrattamento], [DescrTrattamento]) VALUES (N'Brun', N'Brunitura')
INSERT [dbo].[AnagTrattamenti] ([CodTrattamento], [DescrTrattamento]) VALUES (N'Fosfo', N'Fosfatazione')
INSERT [dbo].[AnagTrattamenti] ([CodTrattamento], [DescrTrattamento]) VALUES (N'Teflon', N'Teflonatura')
/****** Object: Table [dbo].[AnagSet] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagSet]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AnagSet](
[IdxSet] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[DescrSet] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_AnagSet] PRIMARY KEY CLUSTERED
(
[IdxSet] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
INSERT [dbo].[AnagSet] ([IdxSet], [DescrSet]) VALUES (N'EQUA', N'EQUA - gestione commesse')
/****** Object: StoredProcedure [dbo].[sp_delObj] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_delObj]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'/*************************************
* STORED PROCEDURE sp_delObj
* elimina un set di dati di una commessa
*
* modif.: S.E.L.
* il: 2008.10.23
**************************************/
CREATE PROCEDURE [dbo].[sp_delObj]
(
@Original_Cod VARCHAR(50)
)
AS
DELETE FROM IstObj
WHERE (IdxObj LIKE REPLACE(@Original_Cod,''D'',''%''))
RETURN
'
END
GO
/****** Object: StoredProcedure [dbo].[sp_clonaTransizEventi] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_clonaTransizEventi]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'/*************************************
* STORED PROCEDURE sp_clonaTransizEventi
* clona le transizioni di evento tra 2 tipi di oggetto
*
* modif.: S.E.L.
* il: 2008.10.10
**************************************/
CREATE PROCEDURE [dbo].[sp_clonaTransizEventi]
(
@CodMappa VARCHAR(50),
@CodEvento VARCHAR(50),
@IdxTipoObjFrom INT,
@IdxTipoObjTo INT
)
AS
/* svuoto precedenti transizioni... */
DELETE FROM TransizioneEventiStati
WHERE (IdxTipoObj = @IdxTipoObjTo) AND (CodMappa = @CodMappa) AND (CodEvento = @CodEvento)
/* clono */
INSERT INTO TransizioneEventiStati
(CodMappa, CodStato, IdxTipoObj, CodEvento, NextCodStato)
SELECT CodMappa, CodStato, @IdxTipoObjTo AS IdxTipoObj, CodEvento, NextCodStato
FROM TransizioneEventiStati AS TransizioneEventiStati_1
WHERE (IdxTipoObj = @IdxTipoObjFrom) AND (CodMappa = @CodMappa) AND (CodEvento = @CodEvento)
RETURN
'
END
GO
/****** Object: StoredProcedure [dbo].[sp_rec4Day] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_rec4Day]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_rec4Day]
(
@dayCod VARCHAR(6)
)
AS
SELECT COUNT(IdxObj) AS rec4Day
FROM IstObj
WHERE (IdxObj LIKE @dayCod + N''%'') AND (livello=1)
RETURN
'
END
GO
/****** Object: StoredProcedure [dbo].[sp_delRow] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_delRow]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'/*************************************
* STORED PROCEDURE sp_delRow
* elimina un set di dati a partire dalla riga di una commessa
*
* modif.: S.E.L.
* il: 2008.10.23
**************************************/
CREATE PROCEDURE [dbo].[sp_delRow]
(
@Original_Cod VARCHAR(50)
)
AS
-- cancello ULP child
DELETE FROM IstObj
WHERE (IdxObjMamma = @Original_Cod)
-- cancello riga...
DELETE FROM IstObj
WHERE (IdxObj = @Original_Cod)
RETURN
'
END
GO
/****** Object: Table [dbo].[Permessi] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Permessi]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Permessi](
[COD_PERMESSO] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[URL] [varchar](250) COLLATE Latin1_General_CI_AS NOT NULL,
[GRUPPO] [int] NULL,
[NUMERO] [int] NULL,
[NOME] [varchar](50) COLLATE Latin1_General_CI_AS NULL,
[DESCRIZIONE] [varchar](50) COLLATE Latin1_General_CI_AS 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)
)
END
GO
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'ANAG', N'menu.aspx', 1, 0, N'SetupApp', N'SetupAppLong')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'ANAG_eventi', N'AnagraficaEventi.aspx', 1, 5, N'AnagraficaEventi', N'AnagraficaEventiLong')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'ANAG_Mappe', N'AnagraficaMappe.aspx', 1, 2, N'AnagraficaMappe', N'AnagraficaMappeLong')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'ANAG_ObjSet', N'AnagraficaObjSet.aspx', 1, 6, N'ObjSet', N'ObjSetLong')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'ANAG_Stati', N'AnagraficaStati.aspx', 1, 4, N'AnagraficaStati', N'AnagraficaStatiLong')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'ANAG_TipoObj', N'AnagraficaTipoObj.aspx', 1, 3, N'AnagraficaTipoObj', N'AnagraficaTipoObjLong')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'ANAG_VOCAB', N'vocabolario.aspx', 1, 1, N'Vocabolario', N'Vocabolario')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'GC', N'menu.aspx', 2, 0, N'GestComm', N'GestCommLong')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'GC_barcode', N'barcode.aspx', 2, 3, N'BarcodeInput', N'BarcodeInputLong')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'GC_det', N'detComm.aspx', 999, 1, N'dettComm', N'dettCommLong')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'GC_elencoBarcode', N'elencoBarcode.aspx', 2, 4, N'ElencoBarcodeAmmessi', N'ElencoBarcodeAmmessiLong')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'GC_elencoDir', N'elencoComm.aspx', 2, 2, N'ElencoCommDir', N'ElencoCommDirLong')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'GC_elencoMag', N'elencoCommMag.aspx', 2, 2, N'ElencoCommMag', N'ElencoCommMagLong')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'GC_elencoProd', N'elencoCommProd.aspx', 2, 2, N'ElencoCommProd', N'ElencoCommProdLong')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'GC_elencoSegr', N'elencoCommSegr.aspx', 2, 2, N'ElencoCommSegr', N'ElencoCommSegrLong')
INSERT [dbo].[Permessi] ([COD_PERMESSO], [URL], [GRUPPO], [NUMERO], [NOME], [DESCRIZIONE]) VALUES (N'GC_scadenziario', N'scadenziarioCommesse.aspx', 2, 5, N'ScadenziarioComm', N'ScadenziarioCommLong')
/****** Object: UserDefinedFunction [dbo].[f_padLeft] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[f_padLeft]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
BEGIN
execute dbo.sp_executesql @statement = N'create FUNCTION [dbo].[f_padLeft] (@string VARCHAR(255), @desired_length INTEGER, @pad_character CHAR(1))
RETURNS VARCHAR(255) AS
BEGIN
-- Prefix the required number of spaces to bulk up the string and then replace the spaces with the desired character
RETURN CASE
WHEN LEN(@string) < @desired_length
THEN REPLACE(SPACE(@desired_length - LEN(@string)), '' '', @pad_character) + @string
ELSE @string
END
END
'
END
GO
/****** Object: Table [dbo].[UM] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UM]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[UM](
[UM] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[DescrUM] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[FattoreSI] [float] NULL,
CONSTRAINT [PK_UmMisure] PRIMARY KEY CLUSTERED
(
[UM] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
/****** Object: Table [dbo].[AnagFasiObj] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagFasiObj]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AnagFasiObj](
[CodFase] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[DescrFase] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_AnafFasiObj_1] PRIMARY KEY CLUSTERED
(
[CodFase] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
INSERT [dbo].[AnagFasiObj] ([CodFase], [DescrFase]) VALUES (N'A_Acc', N'Fase di accettazione materiale')
INSERT [dbo].[AnagFasiObj] ([CodFase], [DescrFase]) VALUES (N'B_Elab', N'Fase di elaborazione')
INSERT [dbo].[AnagFasiObj] ([CodFase], [DescrFase]) VALUES (N'C_Mag', N'Fase di stoccaggio in magazzino pre lavorazione')
INSERT [dbo].[AnagFasiObj] ([CodFase], [DescrFase]) VALUES (N'D_Lav', N'Fase di lavorazione')
INSERT [dbo].[AnagFasiObj] ([CodFase], [DescrFase]) VALUES (N'E_Spe', N'Fase di spedizione')
/****** Object: Table [dbo].[AnagFiltri] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagFiltri]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AnagFiltri](
[CodFiltro] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[DescrFiltro] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_AnagFiltri] PRIMARY KEY CLUSTERED
(
[CodFiltro] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
INSERT [dbo].[AnagFiltri] ([CodFiltro], [DescrFiltro]) VALUES (N'Dir', N'Direzione')
INSERT [dbo].[AnagFiltri] ([CodFiltro], [DescrFiltro]) VALUES (N'Mag_IN', N'Magazzino - accettazione')
INSERT [dbo].[AnagFiltri] ([CodFiltro], [DescrFiltro]) VALUES (N'Mag_OUT', N'Magazzino - spedizione')
INSERT [dbo].[AnagFiltri] ([CodFiltro], [DescrFiltro]) VALUES (N'Prod', N'Produzione')
INSERT [dbo].[AnagFiltri] ([CodFiltro], [DescrFiltro]) VALUES (N'Segr_All', N'1 - Segreteria - visualizza tutto')
INSERT [dbo].[AnagFiltri] ([CodFiltro], [DescrFiltro]) VALUES (N'Segr_DocIn', N'2 - Da registrare (schedulato)')
INSERT [dbo].[AnagFiltri] ([CodFiltro], [DescrFiltro]) VALUES (N'Segr_DocOut', N'3 - Emissione Documenti')
INSERT [dbo].[AnagFiltri] ([CodFiltro], [DescrFiltro]) VALUES (N'Segr_Fatturare', N'4 - Da Fatturare')
/****** Object: Table [dbo].[AnagFamStati] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagFamStati]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AnagFamStati](
[FamStato] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[DescrFam] [nvarchar](50) COLLATE Latin1_General_CI_AS 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)
)
END
GO
INSERT [dbo].[AnagFamStati] ([FamStato], [DescrFam]) VALUES (N'BC', N'Gestione Barcode')
INSERT [dbo].[AnagFamStati] ([FamStato], [DescrFam]) VALUES (N'EQUA_comm', N'Commesse EQUA')
/****** Object: UserDefinedFunction [dbo].[DateOnly] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DateOnly]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
BEGIN
execute dbo.sp_executesql @statement = N'CREATE function [dbo].[DateOnly] (@DateTime DateTime)
-- Returns @DateTime at midnight; i.e., it removes the time portion of a DateTime value.
returns datetime
as
begin
return dateadd(dd,0, datediff(dd,0,@DateTime))
end
'
END
GO
/****** Object: Table [dbo].[AnagLav] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagLav]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AnagLav](
[IdxLav] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[DescrLav] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_AnagLav] PRIMARY KEY CLUSTERED
(
[IdxLav] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
INSERT [dbo].[AnagLav] ([IdxLav], [DescrLav]) VALUES (N'Brun', N'Brunitura')
INSERT [dbo].[AnagLav] ([IdxLav], [DescrLav]) VALUES (N'Fosf', N'Fosfatazione')
INSERT [dbo].[AnagLav] ([IdxLav], [DescrLav]) VALUES (N'Fosf_Tefl', N'Fosfatazione+Teflon')
INSERT [dbo].[AnagLav] ([IdxLav], [DescrLav]) VALUES (N'Sabb', N'Sabbiatura')
/****** Object: StoredProcedure [dbo].[sp_clonaStati] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_clonaStati]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'/*************************************
* STORED PROCEDURE sp_clonaStati
* clona gli stati tra 2 tipi di oggetto
*
* modif.: S.E.L.
* il: 2008.10.10
**************************************/
CREATE PROCEDURE [dbo].[sp_clonaStati]
(
@CodMappa VARCHAR(50),
@IdxTipoObjFrom INT,
@IdxTipoObjTo INT
)
AS
/* svuoto precedenti stati... */
DELETE FROM Stati
WHERE (IdxTipoObj = @IdxTipoObjTo) AND (CodMappa = @CodMappa)
/* clono */
INSERT INTO Stati
(IdxTipoObj, CodMappa, CodStato, DescrStato, PlugIn, Valore, IdxUM)
SELECT @IdxTipoObjTo AS Expr1, CodMappa, CodStato, DescrStato, PlugIn, Valore, IdxUM
FROM Stati AS Stati_1
WHERE (IdxTipoObj = @IdxTipoObjFrom) AND (CodMappa = @CodMappa)
RETURN
'
END
GO
/****** Object: Table [dbo].[TipoEventi] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TipoEventi]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[TipoEventi](
[CodTipoEvento] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[DescrTipoEv] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_TipoEventi] PRIMARY KEY CLUSTERED
(
[CodTipoEvento] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
INSERT [dbo].[TipoEventi] ([CodTipoEvento], [DescrTipoEv]) VALUES (N'BC', N'Barcode')
INSERT [dbo].[TipoEventi] ([CodTipoEvento], [DescrTipoEv]) VALUES (N'HI', N'Human Input')
INSERT [dbo].[TipoEventi] ([CodTipoEvento], [DescrTipoEv]) VALUES (N'ND', N'Non definito')
INSERT [dbo].[TipoEventi] ([CodTipoEvento], [DescrTipoEv]) VALUES (N'SW', N'Interfaccia SW')
/****** Object: Table [dbo].[AnagObj] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagObj]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AnagObj](
[CodObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[DescrObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[FamStato] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[Concreto] [bit] NULL,
CONSTRAINT [PK_Oggetti] PRIMARY KEY CLUSTERED
(
[CodObj] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'AnagObj', N'COLUMN',N'Concreto'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'se l''oggetto sia di tipo fisico (esiste qualcosa di concreto e individuato... es un documento, un box,...)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AnagObj', @level2type=N'COLUMN',@level2name=N'Concreto'
GO
INSERT [dbo].[AnagObj] ([CodObj], [DescrObj], [FamStato], [Concreto]) VALUES (N'BC', N'Barcode', NULL, 0)
INSERT [dbo].[AnagObj] ([CodObj], [DescrObj], [FamStato], [Concreto]) VALUES (N'D', N'Ordine / ddt', N'EQUA_comm', 1)
INSERT [dbo].[AnagObj] ([CodObj], [DescrObj], [FamStato], [Concreto]) VALUES (N'R', N'Riga ordine / ddt', N'EQUA_comm', 0)
INSERT [dbo].[AnagObj] ([CodObj], [DescrObj], [FamStato], [Concreto]) VALUES (N'U', N'ULP (unità logistica di prodotto)', N'EQUA_comm', 1)
/****** Object: Table [dbo].[AnagStati] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AnagStati]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AnagStati](
[CodStato] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[FamStato] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[DescrStato] [nvarchar](50) COLLATE Latin1_General_CI_AS 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)
)
END
GO
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato]) VALUES (N'*', N'BC', N'99 - Undef')
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato]) VALUES (N'01', N'EQUA_comm', N'1 - Ricevuto')
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato]) VALUES (N'02', N'EQUA_comm', N'2 - Accettato')
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato]) VALUES (N'03', N'EQUA_comm', N'3 - Schedulata la lavorazione')
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato]) VALUES (N'04', N'EQUA_comm', N'4 - In lavorazione')
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato]) VALUES (N'05', N'EQUA_comm', N'5 - Pronto a spedire')
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato]) VALUES (N'06', N'EQUA_comm', N'6 - Spedito')
INSERT [dbo].[AnagStati] ([CodStato], [FamStato], [DescrStato]) VALUES (N'07', N'EQUA_comm', N'7 - Fatturato')
/****** Object: Table [dbo].[IstObj] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[IstObj]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[IstObj](
[IdxObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[CodCliente] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[CodStato] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[Posizione] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[Livello] [int] NULL,
[Rev] [int] NULL,
[CodObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[Nome] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[DataRif] [datetime] NULL,
[IdxObjMamma] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[Note] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[ExtKey] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[DueDate] [datetime] NULL,
[LeadTime] [float] NULL,
[LeadTimeUM] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[UserCreaz] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[DataCreaz] [datetime] NULL,
[UserMod] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[DataMod] [datetime] NULL,
[Qta] [int] NULL,
[Peso] [float] NULL,
CONSTRAINT [PK_TrackObj] PRIMARY KEY CLUSTERED
(
[IdxObj] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102401D', N'PERSICO', N'07', N'1', 1, 0, N'D', N'457/08', CAST(0x00009B3100000000 AS DateTime), NULL, N'stampo da trattare', N'Fosf', NULL, NULL, NULL, N'Administrator', CAST(0x00009B3F00C02E0D AS DateTime), N'Administrator', CAST(0x00009B5200B58DE7 AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102401R01', N'PERSICO', N'07', N'1', 2, 0, N'R', N'457/08', CAST(0x00009B3100000000 AS DateTime), N'08102401D', N'stampo da trattare', N'Fosf', NULL, NULL, NULL, N'Administrator', CAST(0x00009B3F00C02E0D AS DateTime), N'Administrator', CAST(0x00009B5200B58DE7 AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102401U01', N'PERSICO', N'07', N'1', 3, 0, N'U', N'457/08', CAST(0x00009B3100000000 AS DateTime), N'08102401R01', N'stampo da trattare', N'Fosf', CAST(0x00009B45009450C0 AS DateTime), NULL, NULL, N'Administrator', CAST(0x00009B3F00C02E0D AS DateTime), N'Administrator', CAST(0x00009B5200B58DE7 AS DateTime), 1, 245)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102401U02', N'PERSICO', N'07', N'2', 3, 0, N'U', N'457/08', CAST(0x00009B3100000000 AS DateTime), N'08102401R01', N'staffe', N'Fosf', CAST(0x00009B4500E6B680 AS DateTime), NULL, NULL, N'Administrator', CAST(0x00009B3F00C02E0D AS DateTime), N'Administrator', CAST(0x00009B5200B58DE7 AS DateTime), 5, 35)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102401U03', N'PERSICO', N'07', N'3', 3, 0, N'U', N'457/08', CAST(0x00009B3100000000 AS DateTime), N'08102401R01', N'staffe piccole', N'Fosf', CAST(0x00009B46009450C0 AS DateTime), NULL, NULL, N'Administrator', CAST(0x00009B3F00C02E0D AS DateTime), N'Administrator', CAST(0x00009B5200B58DE7 AS DateTime), 6, 12)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102402D', N'SMI', N'05', N'1', 1, 0, N'D', N'123 / 08', CAST(0x00009B2200000000 AS DateTime), NULL, N'trattamento ghiere', N'Brun', NULL, NULL, NULL, N'Administrator', CAST(0x00009B3F00FB1846 AS DateTime), N'Administrator', CAST(0x00009B5200B31A46 AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102402R01', N'SMI', N'05', N'1', 2, 0, N'R', N'123 / 08', CAST(0x00009B2200000000 AS DateTime), N'08102402D', N'trattamento n° 200 ghiere in acciaio', N'Brun', NULL, NULL, NULL, N'Administrator', CAST(0x00009B3F00FB1846 AS DateTime), N'Administrator', CAST(0x00009B5200B31A46 AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102402U01', N'SMI', N'06', N'1', 3, 0, N'U', N'123 / 08', CAST(0x00009B2200000000 AS DateTime), N'08102402R01', N'ghiere diam 15', N'Brun', CAST(0x00009B43009450C0 AS DateTime), NULL, NULL, N'Administrator', CAST(0x00009B3F00FB1846 AS DateTime), N'Administrator', CAST(0x00009B5200B77F8F AS DateTime), 150, 6)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102402U02', N'SMI', N'05', N'2', 3, 0, N'U', N'123 / 08', CAST(0x00009B2200000000 AS DateTime), N'08102402R01', N'ghiere diam 20', N'Brun', CAST(0x00009B47009450C0 AS DateTime), NULL, NULL, N'Administrator', CAST(0x00009B3F00FB1846 AS DateTime), N'Administrator', CAST(0x00009B5200B5BE11 AS DateTime), 150, 7.5)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102801D', N'ACME', N'05', N'1', 1, 0, N'D', N'123', CAST(0x00009B4300000000 AS DateTime), NULL, N'Commessa Mickey', N'Brun', NULL, NULL, NULL, N'equa', CAST(0x00009B4301088AD5 AS DateTime), N'Administrator', CAST(0x00009B5200B314E2 AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102801R01', N'ACME', N'05', N'1', 2, 0, N'R', N'123', CAST(0x00009B4300000000 AS DateTime), N'08102801D', N'Commessa Mickey
Stampi e cazzilli.', N'Brun', NULL, NULL, NULL, N'equa', CAST(0x00009B4301088AD5 AS DateTime), N'Administrator', CAST(0x00009B5200B314E2 AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102801R02', N'ACME', N'05', N'2', 2, 0, N'R', N'123', CAST(0x00009B4300000000 AS DateTime), N'08102801D', N'viti, brugole e bulloni', N'Brun', NULL, NULL, NULL, N'equa', CAST(0x00009B4301088AD5 AS DateTime), N'Administrator', CAST(0x00009B5200B314E2 AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102801U01', N'ACME', N'05', N'1', 3, 0, N'U', N'123', CAST(0x00009B4300000000 AS DateTime), N'08102801R01', N'Stampi', N'Brun', CAST(0x00009B47009450C0 AS DateTime), NULL, NULL, N'equa', CAST(0x00009B4301088AD5 AS DateTime), N'Administrator', CAST(0x00009B5200B600A7 AS DateTime), 2, 56)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102801U02', N'ACME', N'05', N'2', 3, 0, N'U', N'123', CAST(0x00009B4300000000 AS DateTime), N'08102801R01', N'cazzilli', N'Brun', CAST(0x00009B4700E6B680 AS DateTime), NULL, NULL, N'equa', CAST(0x00009B4301088AD5 AS DateTime), N'Administrator', CAST(0x00009B5200B60A48 AS DateTime), 6, 12)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102801U03', N'ACME', N'05', N'3', 3, 0, N'U', N'123', CAST(0x00009B4300000000 AS DateTime), N'08102801R02', N'viti', N'Brun', CAST(0x00009B4800E6B680 AS DateTime), NULL, NULL, N'equa', CAST(0x00009B4301088AD5 AS DateTime), N'Administrator', CAST(0x00009B5200B60FF3 AS DateTime), 500, 5)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102801U04', N'ACME', N'05', N'4', 3, 0, N'U', N'123', CAST(0x00009B4300000000 AS DateTime), N'08102801R02', N'brugole', N'Brun', CAST(0x00009B4900E6B680 AS DateTime), NULL, NULL, N'equa', CAST(0x00009B4301088AD5 AS DateTime), N'Administrator', CAST(0x00009B5200B61B40 AS DateTime), 480, 4)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102801U05', N'ACME', N'05', N'6', 3, 0, N'U', N'123', CAST(0x00009B4300000000 AS DateTime), N'08102801R02', N'bulloni', N'Brun', CAST(0x00009B49009450C0 AS DateTime), NULL, NULL, N'equa', CAST(0x00009B4301088AD5 AS DateTime), N'Administrator', CAST(0x00009B5200B63566 AS DateTime), 500, 3)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102802D', N'PERSICO', N'06', N'1', 1, 0, N'D', N'4450 / 08', CAST(0x00009B3600000000 AS DateTime), NULL, N'stampo da trattare', N'Fosf', NULL, NULL, NULL, N'Administrator', CAST(0x00009B4301163069 AS DateTime), N'Administrator', CAST(0x00009B5200B7670C AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102802R01', N'PERSICO', N'06', N'1', 2, 0, N'R', N'4450 / 08', CAST(0x00009B3600000000 AS DateTime), N'08102802D', N'stampo cod 3240X, 2 conchiglie + staffe', N'Fosf', NULL, NULL, NULL, N'Administrator', CAST(0x00009B4301163069 AS DateTime), N'Administrator', CAST(0x00009B5200B7670C AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102802U01', N'PERSICO', N'06', N'1', 3, 0, N'U', N'4450 / 08', CAST(0x00009B3600000000 AS DateTime), N'08102802R01', N'stampo 3240X', N'Fosf', CAST(0x00009B4A009450C0 AS DateTime), NULL, NULL, N'Administrator', CAST(0x00009B4301163069 AS DateTime), N'Administrator', CAST(0x00009B5200B7670C AS DateTime), 2, 124)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08102802U02', N'PERSICO', N'06', N'2', 3, 0, N'U', N'4450 / 08', CAST(0x00009B3600000000 AS DateTime), N'08102802R01', N'staffe dello stampo', N'Fosf', CAST(0x00009B4A00E6B680 AS DateTime), NULL, NULL, N'Administrator', CAST(0x00009B4301163069 AS DateTime), N'Administrator', CAST(0x00009B5200B7670C AS DateTime), 10, 5)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08103001D', N'SMI', N'05', N'1', 1, 0, N'D', N'456/08', CAST(0x00009B3E00000000 AS DateTime), NULL, N'test samuele x develop', N'Fosf', NULL, NULL, NULL, N'Administrator', CAST(0x00009B4500DF31BE AS DateTime), N'Administrator', CAST(0x00009B5200B30D89 AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08103001R01', N'SMI', N'05', N'1', 2, 0, N'R', N'456/08', CAST(0x00009B3E00000000 AS DateTime), N'08103001D', N'test samuele x develop', N'Fosf', NULL, NULL, NULL, N'Administrator', CAST(0x00009B4500DF31BE AS DateTime), N'Administrator', CAST(0x00009B5200B30D89 AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08103001R02', N'SMI', N'05', N'2', 2, 0, N'R', N'456/08', CAST(0x00009B3E00000000 AS DateTime), N'08103001D', N'test samuele x develop', N'Fosf', NULL, NULL, NULL, N'Administrator', CAST(0x00009B4500DF31BE AS DateTime), N'Administrator', CAST(0x00009B5200B30D89 AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08103001U01', N'SMI', N'05', N'1', 3, 0, N'U', N'456/08', CAST(0x00009B3E00000000 AS DateTime), N'08103001R01', N'obj 1', N'Fosf', CAST(0x00009B48009450C0 AS DateTime), NULL, NULL, N'Administrator', CAST(0x00009B4500DF31BE AS DateTime), N'Administrator', CAST(0x00009B5200B6AB75 AS DateTime), 2, 5)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08103001U02', N'SMI', N'05', N'2', 3, 0, N'U', N'456/08', CAST(0x00009B3E00000000 AS DateTime), N'08103001R01', N'obj 2', N'Fosf', CAST(0x00009B4800E6B680 AS DateTime), NULL, NULL, N'Administrator', CAST(0x00009B4500DF31BE AS DateTime), N'Administrator', CAST(0x00009B5200B6AF3F AS DateTime), 5, 10)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08103001U03', N'SMI', N'05', N'3', 3, 0, N'U', N'456/08', CAST(0x00009B3E00000000 AS DateTime), N'08103001R02', N'obj 3', N'Fosf', CAST(0x00009B4900E6B680 AS DateTime), NULL, NULL, N'Administrator', CAST(0x00009B4500DF31BE AS DateTime), N'Administrator', CAST(0x00009B5200B6B32C AS DateTime), 6, 3)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08103001U04', N'SMI', N'05', N'4', 3, 0, N'U', N'456/08', CAST(0x00009B3E00000000 AS DateTime), N'08103001R02', N'obj 4', N'Fosf', CAST(0x00009B49009450C0 AS DateTime), NULL, NULL, N'Administrator', CAST(0x00009B4500DF31BE AS DateTime), N'Administrator', CAST(0x00009B5200B6B802 AS DateTime), 2, 6)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08103101D', N'ACME', N'05', N'1', 1, 0, N'D', N'2345 /08', CAST(0x00009B3E00000000 AS DateTime), NULL, N'materiale vario', N'Fosf', NULL, NULL, NULL, N'equa', CAST(0x00009B4600C7EF06 AS DateTime), N'Administrator', CAST(0x00009B5200B335FB AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08103101R01', N'ACME', N'05', N'1', 2, 0, N'R', N'2345 /08', CAST(0x00009B3E00000000 AS DateTime), N'08103101D', N'materiale vario', N'Fosf', NULL, NULL, NULL, N'equa', CAST(0x00009B4600C7EF06 AS DateTime), N'Administrator', CAST(0x00009B5200B335FB AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08103101U01', N'ACME', N'05', N'1', 3, 0, N'U', N'2345 /08', CAST(0x00009B3E00000000 AS DateTime), N'08103101R01', N'cassone legno', N'Fosf', CAST(0x00009B5300E6B680 AS DateTime), NULL, NULL, N'equa', CAST(0x00009B4600C7EF06 AS DateTime), N'Administrator', CAST(0x00009B5200B6DA9E AS DateTime), NULL, 100)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08103101U02', N'ACME', N'05', N'2', 3, 0, N'U', N'2345 /08', CAST(0x00009B3E00000000 AS DateTime), N'08103101R01', N'bancale', N'Fosf', CAST(0x00009B5400E6B680 AS DateTime), NULL, NULL, N'equa', CAST(0x00009B4600C7EF06 AS DateTime), N'Administrator', CAST(0x00009B5200B6DF63 AS DateTime), NULL, 100)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08103101U03', N'ACME', N'05', N'3', 3, 0, N'U', N'2345 /08', CAST(0x00009B3E00000000 AS DateTime), N'08103101R01', N'bancale', N'Fosf', CAST(0x00009B54009450C0 AS DateTime), NULL, NULL, N'equa', CAST(0x00009B4600C7EF06 AS DateTime), N'Administrator', CAST(0x00009B5200B6E50C AS DateTime), NULL, 100)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08110401D', N'ACME', N'07', N'1', 1, 0, N'D', N'4567/08', CAST(0x00009B4B00000000 AS DateTime), NULL, N'test nuove voci lavorazioni', N'Fosf_Tefl', NULL, NULL, NULL, N'Administrator', CAST(0x00009B4A00AFAE86 AS DateTime), N'Administrator', CAST(0x00009B5200B7590C AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08110401R01', N'ACME', N'07', N'1', 2, 0, N'R', N'4567/08', CAST(0x00009B4B00000000 AS DateTime), N'08110401D', N'test nuove voci lavorazioni', N'Fosf_Tefl', NULL, NULL, NULL, N'Administrator', CAST(0x00009B4A00AFAE86 AS DateTime), N'Administrator', CAST(0x00009B5200B7590C AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08110401U01', N'ACME', N'07', N'1', 3, 0, N'U', N'4567/08', CAST(0x00009B4B00000000 AS DateTime), N'08110401R01', N'test nuove voci lavorazioni', N'Fosf_Tefl', CAST(0x00009B5000E6B680 AS DateTime), NULL, NULL, N'Administrator', CAST(0x00009B4A00AFAE86 AS DateTime), N'Administrator', CAST(0x00009B5200B7590C AS DateTime), 3, 12)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08110402D', N'ACME', N'04', N'1', 1, 0, N'D', N'4567/08', CAST(0x00009B4B00000000 AS DateTime), NULL, N'test sabbiatura', N'Sabb', NULL, NULL, NULL, N'Administrator', CAST(0x00009B4A00BBA993 AS DateTime), N'Administrator', CAST(0x00009B5200B748D9 AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08110402R01', N'ACME', N'04', N'1', 2, 0, N'R', N'4567/08', CAST(0x00009B4B00000000 AS DateTime), N'08110402D', N'test sabbiatura', N'Sabb', NULL, NULL, NULL, N'Administrator', CAST(0x00009B4A00BBA993 AS DateTime), N'Administrator', CAST(0x00009B5200B748D9 AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08110402U01', N'ACME', N'04', N'1', 3, 0, N'U', N'4567/08', CAST(0x00009B4B00000000 AS DateTime), N'08110402R01', N'scatola 1', N'Sabb', CAST(0x00009B50009450C0 AS DateTime), NULL, NULL, N'Administrator', CAST(0x00009B4A00BBA993 AS DateTime), N'Administrator', CAST(0x00009B5200B7AE37 AS DateTime), 50, 10)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08110402U02', N'ACME', N'05', N'2', 3, 0, N'U', N'4567/08', CAST(0x00009B4B00000000 AS DateTime), N'08110402R01', N'scatola 1', N'Sabb', CAST(0x00009B5000E6B680 AS DateTime), NULL, NULL, N'Administrator', CAST(0x00009B4A00BBA993 AS DateTime), N'Administrator', CAST(0x00009B5200B7B82B AS DateTime), 50, 10)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08110701D', N'PERSICO', N'03', N'1', 1, 0, N'D', N'5556/08', CAST(0x00009B4A00000000 AS DateTime), NULL, N'test con eeepc', N'Fosf_Tefl', NULL, NULL, NULL, N'equa', CAST(0x00009B4D010A38CE AS DateTime), N'Administrator', CAST(0x00009B5200B741E9 AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08110701R01', N'PERSICO', N'03', N'1', 2, 0, N'R', N'5556/08', CAST(0x00009B4A00000000 AS DateTime), N'08110701D', N'riga DDT', N'Fosf_Tefl', NULL, NULL, NULL, N'equa', CAST(0x00009B4D010A38CE AS DateTime), N'Administrator', CAST(0x00009B5200B741E9 AS DateTime), NULL, NULL)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08110701U01', N'PERSICO', N'03', N'1', 3, 0, N'U', N'5556/08', CAST(0x00009B4A00000000 AS DateTime), N'08110701R01', N'stampi inferiori', N'Fosf_Tefl', CAST(0x00009B52009450C0 AS DateTime), NULL, NULL, N'equa', CAST(0x00009B4D010A38CE AS DateTime), N'Administrator', CAST(0x00009B5200B741E9 AS DateTime), 5, 25)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08110701U02', N'PERSICO', N'03', N'2', 3, 0, N'U', N'5556/08', CAST(0x00009B4A00000000 AS DateTime), N'08110701R01', N'stampi superiori', N'Fosf_Tefl', CAST(0x00009B5100E6B680 AS DateTime), NULL, NULL, N'equa', CAST(0x00009B4D010A38CE AS DateTime), N'Administrator', CAST(0x00009B5200B741E9 AS DateTime), 5, 30)
INSERT [dbo].[IstObj] ([IdxObj], [CodCliente], [CodStato], [Posizione], [Livello], [Rev], [CodObj], [Nome], [DataRif], [IdxObjMamma], [Note], [ExtKey], [DueDate], [LeadTime], [LeadTimeUM], [UserCreaz], [DataCreaz], [UserMod], [DataMod], [Qta], [Peso]) VALUES (N'08110701U03', N'PERSICO', N'03', N'3', 3, 0, N'U', N'5556/08', CAST(0x00009B4A00000000 AS DateTime), N'08110701R01', N'staffe', N'Fosf_Tefl', CAST(0x00009B52009450C0 AS DateTime), NULL, NULL, N'equa', CAST(0x00009B4D010A38CE AS DateTime), N'Administrator', CAST(0x00009B5200B741E9 AS DateTime), 10, 5)
/****** Object: Table [dbo].[IstFasiObj] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[IstFasiObj]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[IstFasiObj](
[IdxObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[CodFase] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[WBS] [int] NOT NULL,
[Complete] [float] NULL,
[DueDate] [datetime] NULL,
[LeadTime] [float] NULL,
[LeadTimeUM] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_FasiObj_1] PRIMARY KEY CLUSTERED
(
[IdxObj] ASC,
[CodFase] ASC,
[WBS] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
/****** Object: Table [dbo].[TimeTrack] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TimeTrack]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[TimeTrack](
[IdxTT] [int] NOT NULL,
[IdxObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[CodFase] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[WBS] [int] NOT NULL,
[isPrev] [bit] NULL,
[DataInizio] [datetime] NULL,
[DataFine] [datetime] NULL,
CONSTRAINT [PK_TimeTrack] PRIMARY KEY CLUSTERED
(
[IdxTT] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'TimeTrack', N'COLUMN',N'isPrev'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'se real è un vero record, altrimenti è previsionale...' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TimeTrack', @level2type=N'COLUMN',@level2name=N'isPrev'
GO
/****** Object: Table [dbo].[Risorse2TT] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Risorse2TT]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Risorse2TT](
[CodRisorsa] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[IdxTT] [int] NOT NULL,
[Data] [datetime] NULL,
[QtaUm] [int] NULL,
[UmMisura] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_Risorse2TT] PRIMARY KEY CLUSTERED
(
[CodRisorsa] ASC,
[IdxTT] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
/****** Object: Table [dbo].[Eventi] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Eventi]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Eventi](
[CodEvento] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[CodTipoEvento] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[DescrEvento] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[Action] [nvarchar](50) COLLATE Latin1_General_CI_AS 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)
)
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Eventi', N'COLUMN',N'Action'))
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'Eventi', @level2type=N'COLUMN',@level2name=N'Action'
GO
INSERT [dbo].[Eventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (N'04', N'BC', N'Inizio Lavoro', N'act')
INSERT [dbo].[Eventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (N'05', N'BC', N'Fine Lavoro', N'act')
INSERT [dbo].[Eventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (N'06', N'BC', N'Spedito', N'act')
INSERT [dbo].[Eventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (N'ko', N'BC', N'Barcode - reset', N'ko')
INSERT [dbo].[Eventi] ([CodEvento], [CodTipoEvento], [DescrEvento], [Action]) VALUES (N'ok', N'BC', N'Barcode - conferma', N'ok')
/****** Object: Table [dbo].[TraEv2Stati] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TraEv2Stati]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[TraEv2Stati](
[CodMappa] [nvarchar](20) COLLATE Latin1_General_CI_AS NOT NULL,
[CodObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[CodStato] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[CodEvento] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[NextCodStato] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[CmdPlugin] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[text2show] [nvarchar](500) COLLATE Latin1_General_CI_AS NULL,
[descrComando] [nvarchar](250) COLLATE Latin1_General_CI_AS 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)
)
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'TraEv2Stati', NULL,NULL))
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
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_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'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)')
/****** Object: Table [dbo].[Tratt2Obj] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Tratt2Obj]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Tratt2Obj](
[IdxObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[CodTrattamento] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[Note] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_Tratt2Obj] PRIMARY KEY CLUSTERED
(
[IdxObj] ASC,
[CodTrattamento] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
/****** Object: Table [dbo].[Fasi2Obj] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Fasi2Obj]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Fasi2Obj](
[CodObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[WBS] [int] NOT NULL,
[CodFase] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
CONSTRAINT [PK_Fasi2Obj_1] PRIMARY KEY CLUSTERED
(
[CodObj] ASC,
[WBS] ASC,
[CodFase] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
INSERT [dbo].[Fasi2Obj] ([CodObj], [WBS], [CodFase]) VALUES (N'D', 1, N'A_Acc')
INSERT [dbo].[Fasi2Obj] ([CodObj], [WBS], [CodFase]) VALUES (N'D', 2, N'B_Elab')
INSERT [dbo].[Fasi2Obj] ([CodObj], [WBS], [CodFase]) VALUES (N'D', 3, N'E_Spe')
INSERT [dbo].[Fasi2Obj] ([CodObj], [WBS], [CodFase]) VALUES (N'R', 1, N'B_Elab')
INSERT [dbo].[Fasi2Obj] ([CodObj], [WBS], [CodFase]) VALUES (N'R', 2, N'E_Spe')
INSERT [dbo].[Fasi2Obj] ([CodObj], [WBS], [CodFase]) VALUES (N'U', 1, N'C_Mag')
INSERT [dbo].[Fasi2Obj] ([CodObj], [WBS], [CodFase]) VALUES (N'U', 2, N'D_Lav')
INSERT [dbo].[Fasi2Obj] ([CodObj], [WBS], [CodFase]) VALUES (N'U', 3, N'B_Elab')
INSERT [dbo].[Fasi2Obj] ([CodObj], [WBS], [CodFase]) VALUES (N'U', 4, N'E_Spe')
/****** Object: Table [dbo].[WbsFasi2Links] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WbsFasi2Links]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[WbsFasi2Links](
[IdxLink] [int] IDENTITY(1,1) NOT NULL,
[CodObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[CodFase] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[WBS] [int] NOT NULL,
[WBS_to] [int] NOT NULL,
[LinkType] [int] NOT NULL,
CONSTRAINT [PK_Wbs2Links] PRIMARY KEY CLUSTERED
(
[IdxLink] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
/****** Object: Table [dbo].[Object2Set] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Object2Set]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Object2Set](
[IdxSet] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[CodObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[Qta] [int] NULL,
[UserQtyReq] [bit] NULL,
[Posizione] [nvarchar](250) COLLATE Latin1_General_CI_AS NULL,
[TimeTrackEnab] [bit] NULL,
[ProcReq] [bit] NULL,
[ExtView] [bit] NULL,
CONSTRAINT [PK_ObjectSet] PRIMARY KEY CLUSTERED
(
[IdxSet] ASC,
[CodObj] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Object2Set', N'COLUMN',N'Qta'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'num minimo di occorrenze, se 0 è facoltativo' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Object2Set', @level2type=N'COLUMN',@level2name=N'Qta'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Object2Set', N'COLUMN',N'UserQtyReq'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'num max di occorrenze, se >1 è "n" generico' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Object2Set', @level2type=N'COLUMN',@level2name=N'UserQtyReq'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Object2Set', N'COLUMN',N'Posizione'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'contiene la posizione relativa x oggetti da creare gerarchicamente... se uno conterrà A. ed un secondo A.B. significa che B è figlio di A da creare e registrare' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Object2Set', @level2type=N'COLUMN',@level2name=N'Posizione'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Object2Set', N'COLUMN',N'ProcReq'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'abilitato per processing interno (warning,...)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Object2Set', @level2type=N'COLUMN',@level2name=N'ProcReq'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Object2Set', N'COLUMN',N'ExtView'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'abilitato alla visualizzazione esterna' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Object2Set', @level2type=N'COLUMN',@level2name=N'ExtView'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Object2Set', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Contiene dei set di oggetti da "impacchetare insieme" con indicazione obbligatorio/facoltativo e numerosità' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Object2Set'
GO
INSERT [dbo].[Object2Set] ([IdxSet], [CodObj], [Qta], [UserQtyReq], [Posizione], [TimeTrackEnab], [ProcReq], [ExtView]) VALUES (N'EQUA', N'D', 1, 0, N'#.', 1, NULL, 1)
INSERT [dbo].[Object2Set] ([IdxSet], [CodObj], [Qta], [UserQtyReq], [Posizione], [TimeTrackEnab], [ProcReq], [ExtView]) VALUES (N'EQUA', N'R', 1, 1, N'#.#.', 1, NULL, NULL)
INSERT [dbo].[Object2Set] ([IdxSet], [CodObj], [Qta], [UserQtyReq], [Posizione], [TimeTrackEnab], [ProcReq], [ExtView]) VALUES (N'EQUA', N'U', 1, 1, N'#.#.#.', 1, NULL, NULL)
/****** Object: Table [dbo].[Step] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Step]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Step](
[IdxTipoObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[IdxStep] [int] NOT NULL,
[DescrStep] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_Fasi] PRIMARY KEY CLUSTERED
(
[IdxTipoObj] ASC,
[IdxStep] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
INSERT [dbo].[Step] ([IdxTipoObj], [IdxStep], [DescrStep]) VALUES (N'D', 0, N'-- selezionare --')
INSERT [dbo].[Step] ([IdxTipoObj], [IdxStep], [DescrStep]) VALUES (N'D', 1, N'Step1')
INSERT [dbo].[Step] ([IdxTipoObj], [IdxStep], [DescrStep]) VALUES (N'D', 2, N'step 2')
INSERT [dbo].[Step] ([IdxTipoObj], [IdxStep], [DescrStep]) VALUES (N'D', 3, N'step 3')
INSERT [dbo].[Step] ([IdxTipoObj], [IdxStep], [DescrStep]) VALUES (N'R', 0, N'-- selezionare --')
INSERT [dbo].[Step] ([IdxTipoObj], [IdxStep], [DescrStep]) VALUES (N'R', 1, N'1-step')
INSERT [dbo].[Step] ([IdxTipoObj], [IdxStep], [DescrStep]) VALUES (N'R', 2, N'2-step')
INSERT [dbo].[Step] ([IdxTipoObj], [IdxStep], [DescrStep]) VALUES (N'R', 3, N'3-step')
/****** Object: Table [dbo].[Permessi2Funzione] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Permessi2Funzione]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Permessi2Funzione](
[COD_PERMESSO] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[COD_FUNZIONE] [nvarchar](31) COLLATE Latin1_General_CI_AS NOT NULL,
[READWRITE] [char](1) COLLATE Latin1_General_CI_AS 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)
)
END
GO
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'ANAG', N'XPS_admin', NULL)
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'ANAG_eventi', N'XPS_admin', NULL)
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'ANAG_Mappe', N'XPS_admin', NULL)
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'ANAG_ObjSet', N'XPS_admin', NULL)
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'ANAG_Stati', N'XPS_admin', NULL)
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'ANAG_TipoObj', N'XPS_admin', NULL)
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'ANAG_VOCAB', N'XPS_Admin', NULL)
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'GC', N'XPS_user', NULL)
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'GC_barcode', N'XPS_user', NULL)
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'GC_det', N'XPS_user', NULL)
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'GC_elencoBarcode', N'XPS_user', NULL)
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'GC_elencoDir', N'XPS_dir', NULL)
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'GC_elencoMag', N'XPS_mag', NULL)
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'GC_elencoProd', N'XPS_prod', NULL)
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'GC_elencoSegr', N'XPS_segr', NULL)
INSERT [dbo].[Permessi2Funzione] ([COD_PERMESSO], [COD_FUNZIONE], [READWRITE]) VALUES (N'GC_scadenziario', N'XPS_user', NULL)
/****** Object: Table [dbo].[Step4Obj] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Step4Obj]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Step4Obj](
[IdxObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[IdxStep] [int] NOT NULL,
[IdxStato] [int] NULL,
[StartDatePrev] [datetime] NULL,
[DueDatePrev] [datetime] NULL,
[StartDateReal] [datetime] NULL,
[DueDateReal] [datetime] NULL,
[RatioCompl] [float] NULL,
CONSTRAINT [PK_FasiObj] PRIMARY KEY CLUSTERED
(
[IdxObj] ASC,
[IdxStep] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Step4Obj', N'COLUMN',N'IdxStato'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'-1 = pianificato, 0 = in esecuzione, 1 = completato' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Step4Obj', @level2type=N'COLUMN',@level2name=N'IdxStato'
GO
/****** Object: Table [dbo].[LogStatoIstObj] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LogStatoIstObj]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[LogStatoIstObj](
[IdxObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[DataOra] [datetime] NOT NULL,
[CodStato] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[Username] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_LogStatoIstObj] PRIMARY KEY CLUSTERED
(
[IdxObj] ASC,
[DataOra] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401D', CAST(0x00009B5200B4CC39 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401D', CAST(0x00009B5200B4EFDA AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401D', CAST(0x00009B5200B5390C AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401D', CAST(0x00009B5200B5838F AS DateTime), N'06', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401D', CAST(0x00009B5200B58DE6 AS DateTime), N'07', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401R01', CAST(0x00009B5200B4CC39 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401R01', CAST(0x00009B5200B4EFDA AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401R01', CAST(0x00009B5200B53908 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401R01', CAST(0x00009B5200B5838F AS DateTime), N'06', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401R01', CAST(0x00009B5200B58DE6 AS DateTime), N'07', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401U01', CAST(0x00009B5200B4CC39 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401U01', CAST(0x00009B5200B4E45A AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401U01', CAST(0x00009B5200B51ACB AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401U01', CAST(0x00009B5200B5730E AS DateTime), N'06', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401U01', CAST(0x00009B5200B58DE6 AS DateTime), N'07', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401U02', CAST(0x00009B5200B4CC39 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401U02', CAST(0x00009B5200B4EA0F AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401U02', CAST(0x00009B5200B53338 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401U02', CAST(0x00009B5200B57815 AS DateTime), N'06', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401U02', CAST(0x00009B5200B58DE6 AS DateTime), N'07', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401U03', CAST(0x00009B5200B4CC39 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401U03', CAST(0x00009B5200B4EFDA AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401U03', CAST(0x00009B5200B53908 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401U03', CAST(0x00009B5200B5838A AS DateTime), N'06', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102401U03', CAST(0x00009B5200B58DE6 AS DateTime), N'07', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102402D', CAST(0x00009B5200B31A46 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102402D', CAST(0x00009B5200B5A538 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102402D', CAST(0x00009B5200B5BE10 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102402R01', CAST(0x00009B5200B31A46 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102402R01', CAST(0x00009B5200B5A538 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102402R01', CAST(0x00009B5200B5BE10 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102402U01', CAST(0x00009B5200B31A46 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102402U01', CAST(0x00009B5200B59FB3 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102402U01', CAST(0x00009B5200B5AA51 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102402U01', CAST(0x00009B5200B77F8C AS DateTime), N'06', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102402U02', CAST(0x00009B5200B31A46 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102402U02', CAST(0x00009B5200B5A538 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102402U02', CAST(0x00009B5200B5BE10 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801D', CAST(0x00009B5200B314E2 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801D', CAST(0x00009B5200B5F265 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801D', CAST(0x00009B5200B63562 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801R01', CAST(0x00009B5200B314E2 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801R01', CAST(0x00009B5200B5CA8D AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801R01', CAST(0x00009B5200B60A4A AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801R02', CAST(0x00009B5200B314E2 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801R02', CAST(0x00009B5200B5F265 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801R02', CAST(0x00009B5200B63562 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801U01', CAST(0x00009B5200B314E2 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801U01', CAST(0x00009B5200B5C710 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801U01', CAST(0x00009B5200B600A5 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801U02', CAST(0x00009B5200B314E2 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801U02', CAST(0x00009B5200B5CA8D AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801U02', CAST(0x00009B5200B60A4A AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801U03', CAST(0x00009B5200B314E2 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801U03', CAST(0x00009B5200B5CE7F AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801U03', CAST(0x00009B5200B60FF6 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801U04', CAST(0x00009B5200B314E2 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801U04', CAST(0x00009B5200B5D8C0 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801U04', CAST(0x00009B5200B61B42 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801U05', CAST(0x00009B5200B314E2 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801U05', CAST(0x00009B5200B5F265 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102801U05', CAST(0x00009B5200B63562 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802D', CAST(0x00009B5200B311F5 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802D', CAST(0x00009B5200B64B60 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802D', CAST(0x00009B5200B65BA7 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802D', CAST(0x00009B5200B76709 AS DateTime), N'06', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802R01', CAST(0x00009B5200B311F5 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802R01', CAST(0x00009B5200B64B60 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802R01', CAST(0x00009B5200B65BA7 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802R01', CAST(0x00009B5200B76709 AS DateTime), N'06', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802U01', CAST(0x00009B5200B311F5 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802U01', CAST(0x00009B5200B63F7C AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802U01', CAST(0x00009B5200B65415 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802U01', CAST(0x00009B5200B76709 AS DateTime), N'06', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802U02', CAST(0x00009B5200B311F5 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802U02', CAST(0x00009B5200B64B60 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802U02', CAST(0x00009B5200B65BA7 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08102802U02', CAST(0x00009B5200B76709 AS DateTime), N'06', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001D', CAST(0x00009B5200B30D93 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001D', CAST(0x00009B5200B68458 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001D', CAST(0x00009B5200B6B803 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001R01', CAST(0x00009B5200B30D93 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001R01', CAST(0x00009B5200B66B5F AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001R01', CAST(0x00009B5200B6AF3F AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001R02', CAST(0x00009B5200B30D93 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001R02', CAST(0x00009B5200B68453 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001R02', CAST(0x00009B5200B6B803 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001U01', CAST(0x00009B5200B30D93 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001U01', CAST(0x00009B5200B667A9 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001U01', CAST(0x00009B5200B6AB72 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001U02', CAST(0x00009B5200B30D93 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001U02', CAST(0x00009B5200B66B5F AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001U02', CAST(0x00009B5200B6AF3F AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001U03', CAST(0x00009B5200B30D93 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001U03', CAST(0x00009B5200B66F2E AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001U03', CAST(0x00009B5200B6B32A AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001U04', CAST(0x00009B5200B30D93 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001U04', CAST(0x00009B5200B68453 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103001U04', CAST(0x00009B5200B6B803 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103101D', CAST(0x00009B5200B335FB AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103101D', CAST(0x00009B5200B6D59B AS DateTime), N'04', N'Administrator')
GO
print 'Processed 100 total records'
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103101D', CAST(0x00009B5200B6E50C AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103101R01', CAST(0x00009B5200B335FB AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103101R01', CAST(0x00009B5200B6D597 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103101R01', CAST(0x00009B5200B6E50C AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103101U01', CAST(0x00009B5200B335FB AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103101U01', CAST(0x00009B5200B6C24A AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103101U01', CAST(0x00009B5200B6DA9D AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103101U02', CAST(0x00009B5200B335FB AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103101U02', CAST(0x00009B5200B6C6A9 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103101U02', CAST(0x00009B5200B6DF63 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103101U03', CAST(0x00009B5200B335FB AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103101U03', CAST(0x00009B5200B6D597 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08103101U03', CAST(0x00009B5200B6E50C AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110401D', CAST(0x00009B5200B33D47 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110401D', CAST(0x00009B5200B708B1 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110401D', CAST(0x00009B5200B71622 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110401D', CAST(0x00009B5200B71E79 AS DateTime), N'06', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110401D', CAST(0x00009B5200B7590C AS DateTime), N'07', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110401R01', CAST(0x00009B5200B33D47 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110401R01', CAST(0x00009B5200B708B1 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110401R01', CAST(0x00009B5200B71622 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110401R01', CAST(0x00009B5200B71E79 AS DateTime), N'06', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110401R01', CAST(0x00009B5200B7590C AS DateTime), N'07', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110401U01', CAST(0x00009B5200B33D47 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110401U01', CAST(0x00009B5200B708B1 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110401U01', CAST(0x00009B5200B71622 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110401U01', CAST(0x00009B5200B71E79 AS DateTime), N'06', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110401U01', CAST(0x00009B5200B7590C AS DateTime), N'07', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402D', CAST(0x00009B5200B34FCA AS DateTime), N'01', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402D', CAST(0x00009B5200B7380C AS DateTime), N'02', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402D', CAST(0x00009B5200B748D8 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402D', CAST(0x00009B5200B7B3CA AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402R01', CAST(0x00009B5200B34FCA AS DateTime), N'01', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402R01', CAST(0x00009B5200B7380C AS DateTime), N'02', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402R01', CAST(0x00009B5200B748D8 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402R01', CAST(0x00009B5200B7B3CA AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402U01', CAST(0x00009B5200B34FCA AS DateTime), N'01', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402U01', CAST(0x00009B5200B7380C AS DateTime), N'02', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402U01', CAST(0x00009B5200B748D8 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402U01', CAST(0x00009B5200B7AE39 AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402U02', CAST(0x00009B5200B34FCA AS DateTime), N'01', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402U02', CAST(0x00009B5200B7380C AS DateTime), N'02', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402U02', CAST(0x00009B5200B748D8 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402U02', CAST(0x00009B5200B7B3CA AS DateTime), N'04', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110402U02', CAST(0x00009B5200B7B829 AS DateTime), N'05', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110701D', CAST(0x00009B5200B347D5 AS DateTime), N'01', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110701D', CAST(0x00009B5200B7359A AS DateTime), N'02', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110701D', CAST(0x00009B5200B741E8 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110701R01', CAST(0x00009B5200B347D5 AS DateTime), N'01', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110701R01', CAST(0x00009B5200B7359A AS DateTime), N'02', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110701R01', CAST(0x00009B5200B741E8 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110701U01', CAST(0x00009B5200B347D5 AS DateTime), N'01', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110701U01', CAST(0x00009B5200B7359A AS DateTime), N'02', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110701U01', CAST(0x00009B5200B741E8 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110701U02', CAST(0x00009B5200B347D5 AS DateTime), N'01', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110701U02', CAST(0x00009B5200B7359A AS DateTime), N'02', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110701U02', CAST(0x00009B5200B741E8 AS DateTime), N'03', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110701U03', CAST(0x00009B5200B347D5 AS DateTime), N'01', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110701U03', CAST(0x00009B5200B7359A AS DateTime), N'02', N'Administrator')
INSERT [dbo].[LogStatoIstObj] ([IdxObj], [DataOra], [CodStato], [Username]) VALUES (N'08110701U03', CAST(0x00009B5200B741E8 AS DateTime), N'03', N'Administrator')
/****** Object: Table [dbo].[Note] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Note]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Note](
[NumNota] [int] NOT NULL,
[IdxObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[CodFase] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[UserNota] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[Data] [datetime] NULL,
[ExtView] [bit] NULL,
[Nota] [nvarchar](500) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_Note] PRIMARY KEY CLUSTERED
(
[NumNota] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
/****** Object: Table [dbo].[Filtro2Funzione] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Filtro2Funzione]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Filtro2Funzione](
[CodFiltro] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[COD_FUNZIONE] [nvarchar](31) COLLATE Latin1_General_CI_AS NOT NULL,
CONSTRAINT [PK_Filtro2Funzione] PRIMARY KEY CLUSTERED
(
[CodFiltro] ASC,
[COD_FUNZIONE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
INSERT [dbo].[Filtro2Funzione] ([CodFiltro], [COD_FUNZIONE]) VALUES (N'Dir', N'XPS_dir')
INSERT [dbo].[Filtro2Funzione] ([CodFiltro], [COD_FUNZIONE]) VALUES (N'Mag_IN', N'XPS_mag')
INSERT [dbo].[Filtro2Funzione] ([CodFiltro], [COD_FUNZIONE]) VALUES (N'Mag_OUT', N'XPS_mag')
INSERT [dbo].[Filtro2Funzione] ([CodFiltro], [COD_FUNZIONE]) VALUES (N'Prod', N'XPS_prod')
INSERT [dbo].[Filtro2Funzione] ([CodFiltro], [COD_FUNZIONE]) VALUES (N'Segr_All', N'XPS_segr')
INSERT [dbo].[Filtro2Funzione] ([CodFiltro], [COD_FUNZIONE]) VALUES (N'Segr_DocIn', N'XPS_segr')
INSERT [dbo].[Filtro2Funzione] ([CodFiltro], [COD_FUNZIONE]) VALUES (N'Segr_DocOut', N'XPS_segr')
INSERT [dbo].[Filtro2Funzione] ([CodFiltro], [COD_FUNZIONE]) VALUES (N'Segr_Fatturare', N'XPS_segr')
/****** Object: Table [dbo].[Filtro2Stati] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Filtro2Stati]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Filtro2Stati](
[CodFiltro] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[CodStato] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
CONSTRAINT [PK_Filtro2Stati] PRIMARY KEY CLUSTERED
(
[CodFiltro] ASC,
[CodStato] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Dir', N'01')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Dir', N'02')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Dir', N'03')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Dir', N'04')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Dir', N'05')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Dir', N'06')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Dir', N'07')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Mag_IN', N'01')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Mag_IN', N'02')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Mag_OUT', N'05')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Prod', N'02')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Prod', N'03')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Prod', N'04')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Segr_All', N'01')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Segr_All', N'02')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Segr_All', N'03')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Segr_All', N'04')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Segr_All', N'05')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Segr_All', N'06')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Segr_All', N'07')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Segr_DocIn', N'03')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Segr_DocOut', N'05')
INSERT [dbo].[Filtro2Stati] ([CodFiltro], [CodStato]) VALUES (N'Segr_Fatturare', N'06')
/****** Object: Table [dbo].[IstWbsFasi] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[IstWbsFasi]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[IstWbsFasi](
[IdxW2F] [int] NOT NULL,
[IdxObj] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[CodFase] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[WBS] [int] NOT NULL,
[WBS_to] [int] NOT NULL,
[LinkType] [int] NOT NULL,
CONSTRAINT [PK_WBS2Fasi] PRIMARY KEY CLUSTERED
(
[IdxW2F] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
/****** Object: View [dbo].[v_selTipoMappa] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_selTipoMappa]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_selTipoMappa]
AS
SELECT CodMappa AS value, DescrMappa AS label
FROM dbo.AnagMappe
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_selTipoMappa', NULL,NULL))
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 = "AnagMappe"
Begin Extent =
Top = 6
Left = 38
Bottom = 84
Right = 189
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 9
Width = 284
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
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_selTipoMappa'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_selTipoMappa', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_selTipoMappa'
GO
/****** Object: View [dbo].[v_selClienti] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_selClienti]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_selClienti]
AS
SELECT TOP (100) PERCENT CodCliente AS value, RagioneSociale AS label
FROM dbo.AnagClienti
ORDER BY label
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_selClienti', NULL,NULL))
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 = "AnagClienti"
Begin Extent =
Top = 6
Left = 38
Bottom = 84
Right = 190
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
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_selClienti'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_selClienti', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_selClienti'
GO
/****** Object: View [dbo].[v_ULP_DDT] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_ULP_DDT]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_ULP_DDT]
AS
SELECT IstObj_1.IdxObjMamma, COUNT(dbo.IstObj.IdxObj) AS NumRighe, SUM(dbo.IstObj.Peso) AS TotPeso, SUM(dbo.IstObj.Qta) AS TotQta, MAX(dbo.IstObj.DueDate)
AS DueDate, MIN(dbo.IstObj.CodStato) AS minStato, MAX(dbo.IstObj.CodStato) AS maxStato
FROM dbo.IstObj INNER JOIN
dbo.IstObj AS IstObj_1 ON dbo.IstObj.IdxObjMamma = IstObj_1.IdxObj
WHERE (dbo.IstObj.Livello = 3)
GROUP BY IstObj_1.IdxObjMamma
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_ULP_DDT', NULL,NULL))
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[41] 4[20] 2[12] 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 = "IstObj"
Begin Extent =
Top = 6
Left = 38
Bottom = 297
Right = 205
End
DisplayFlags = 280
TopColumn = 4
End
Begin Table = "IstObj_1"
Begin Extent =
Top = 43
Left = 397
Bottom = 267
Right = 564
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 9
Width = 284
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
End
End
Begin CriteriaPane =
Begin ColumnWidths = 12
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_ULP_DDT'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_ULP_DDT', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_ULP_DDT'
GO
/****** Object: View [dbo].[v_ULP] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_ULP]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_ULP]
AS
SELECT TOP (100) PERCENT dbo.IstObj.IdxObj AS Cod, dbo.AnagStati.DescrStato AS Stato, ISNULL(dbo.AnagClienti.CodCliente, N''-'') AS CodCliente,
ISNULL(dbo.AnagClienti.RagioneSociale, N''-'') AS Cliente, ISNULL(dbo.IstObj.ExtKey, N''-'') AS CodCli, ISNULL(dbo.IstObj.Note, N''-'') AS descrizione,
dbo.IstObj.Nome AS DDT, dbo.IstObj.DataRif AS DataDDT, dbo.IstObj.DataCreaz AS DataArrivo, dbo.IstObj.Posizione, ISNULL(dbo.IstObj.Qta, 0) AS Qta,
ISNULL(dbo.IstObj.Peso, 0) AS Peso, dbo.IstObj.DueDate AS DataPrevista, dbo.IstObj.IdxObjMamma, dbo.IstObj.CodStato
FROM dbo.IstObj LEFT OUTER JOIN
dbo.AnagClienti ON dbo.IstObj.CodCliente = dbo.AnagClienti.CodCliente LEFT OUTER JOIN
dbo.AnagStati ON dbo.IstObj.CodStato = dbo.AnagStati.CodStato LEFT OUTER JOIN
dbo.v_ULP_DDT ON dbo.IstObj.IdxObj = dbo.v_ULP_DDT.IdxObjMamma
WHERE (NOT (dbo.IstObj.IdxObjMamma IS NULL)) AND (dbo.IstObj.Livello = 3)
ORDER BY DataArrivo DESC
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_ULP', NULL,NULL))
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 = "IstObj"
Begin Extent =
Top = 21
Left = 481
Bottom = 338
Right = 632
End
DisplayFlags = 280
TopColumn = 2
End
Begin Table = "AnagClienti"
Begin Extent =
Top = 32
Left = 224
Bottom = 110
Right = 376
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "AnagStati"
Begin Extent =
Top = 170
Left = 205
Bottom = 263
Right = 356
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "v_ULP_DDT"
Begin Extent =
Top = 89
Left = 687
Bottom = 167
Right = 838
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 16
Width = 284
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
End
End
Begin CriteriaPane =
Begin ColumnWidths = 11
Column = 1440
Alias = 900
Table = 1170
Output = 720
Append = 1400
NewValue = 1170
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_ULP'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane2' , N'SCHEMA',N'dbo', N'VIEW',N'v_ULP', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N' 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_ULP'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_ULP', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_ULP'
GO
/****** Object: View [dbo].[v_schedaIdent] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_schedaIdent]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_schedaIdent]
AS
SELECT dbo.IstObj.IdxObj, dbo.AnagClienti.RagioneSociale AS Cliente, dbo.IstObj.Nome AS DDT, GETDATE() AS DDT_del, dbo.IstObj.DataCreaz AS DataArrivo,
dbo.IstObj.ExtKey AS CodProdotto, dbo.v_ULP_DDT.DueDate AS ConsegnaPrevista, dbo.v_ULP_DDT.TotPeso AS Peso, 1 AS Brunitura, 0 AS Fosfatazione,
0 AS MercePronta, 1 AS Ciclo_F1, 0 AS Ciclo_F2, 0 AS Ciclo_M, 1 AS Ciclo_X2, 0 AS Ciclo_Olio, 0 AS Ciclo_FinSecco
FROM dbo.IstObj INNER JOIN
dbo.AnagClienti ON dbo.IstObj.CodCliente = dbo.AnagClienti.CodCliente LEFT OUTER JOIN
dbo.v_ULP_DDT ON dbo.IstObj.IdxObj = dbo.v_ULP_DDT.IdxObjMamma
WHERE (dbo.IstObj.Livello = 1)
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_schedaIdent', NULL,NULL))
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[33] 4[28] 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 = "IstObj"
Begin Extent =
Top = 3
Left = 491
Bottom = 299
Right = 642
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "AnagClienti"
Begin Extent =
Top = 6
Left = 227
Bottom = 84
Right = 379
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "v_ULP_DDT"
Begin Extent =
Top = 18
Left = 823
Bottom = 187
Right = 974
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 18
Width = 284
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
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_schedaIdent'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_schedaIdent', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_schedaIdent'
GO
/****** Object: View [dbo].[v_selSetObj] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_selSetObj]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_selSetObj]
AS
SELECT TOP (100) PERCENT IdxSet AS value, DescrSet AS label
FROM dbo.AnagSet
ORDER BY label
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_selSetObj', NULL,NULL))
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 = "AnagSet"
Begin Extent =
Top = 6
Left = 38
Bottom = 84
Right = 189
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
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_selSetObj'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_selSetObj', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_selSetObj'
GO
/****** Object: StoredProcedure [dbo].[sp_clonaRowObj] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_clonaRowObj]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'/*************************************
* STORED PROCEDURE sp_clonaRowObj
* clona una riga e i relativi ULP
*
* modif.: S.E.L.
* il: 2008.10.23
**************************************/
CREATE PROCEDURE [dbo].[sp_clonaRowObj]
(
@IdxObj_orig VARCHAR(50)
)
AS
DECLARE @IdxObj_dest VARCHAR(50)
DECLARE @IdxObjMamma VARCHAR(50)
DECLARE @numShift INT
DECLARE @delta INT
BEGIN TRAN
-- calcolo codMamma...
SET @IdxObjMamma = (SELECT IdxObjMamma FROM IstObj WHERE (IdxObj=@IdxObj_orig))
-- quante righe ho da usare "come shift"?!?
SET @numShift = (SELECT COUNT(IdxObj) FROM IstObj WHERE (IdxObjMamma LIKE LEFT(@IdxObjMamma,8)+''%'') AND Livello = 2)
-- calcolo nuovo idx x riga...
SET @IdxObj_dest = LEFT(@IdxObj_orig,9) + dbo.f_padLeft(@numShift + CAST(RIGHT(@IdxObj_orig,2) AS INT),2,''0'')
-- clono la singola riga...
INSERT INTO IstObj
(IdxObj, CodCliente, CodStato, Posizione, Livello, Rev, CodObj, Nome, DataRif, IdxObjMamma, Note, ExtKey, DueDate, LeadTime, LeadTimeUM, UserCreaz, DataCreaz,
UserMod, DataMod)
SELECT @IdxObj_dest AS IdxObj, CodCliente, CodStato, 1 + @numShift, Livello, Rev, CodObj, Nome, DataRif, IdxObjMamma, Note, ExtKey, DueDate, LeadTime, LeadTimeUM, UserCreaz,
DataCreaz, UserMod, DataMod
FROM IstObj AS IstObj_1
WHERE (IdxObj = @IdxObj_orig)
-- quante righe ho da usare "come shift"?!?
SET @delta = (SELECT MIN(Posizione) FROM IstObj WHERE (IdxObjMamma = @IdxObj_orig))
SET @numShift = (SELECT COUNT(IdxObj) FROM IstObj WHERE (IdxObjMamma LIKE LEFT(@IdxObjMamma,8)+''%'') AND Livello = 3) - @delta + 1
-- clono i singoli ULP
INSERT INTO IstObj
(IdxObj, CodCliente, CodStato, Posizione, Livello, Rev, CodObj, Nome, DataRif, IdxObjMamma, Note, ExtKey, DueDate, LeadTime, LeadTimeUM, UserCreaz, DataCreaz,
UserMod, DataMod, Qta, Peso)
SELECT LEFT(IdxObj,9) + dbo.f_padLeft(@numShift + CAST(RIGHT(IdxObj,2) AS INT),2,''0'') AS IdxObj, CodCliente, CodStato, Posizione + @numShift, Livello, Rev, CodObj, Nome, DataRif, @IdxObj_dest, Note, ExtKey, DueDate, LeadTime, LeadTimeUM, UserCreaz,
DataCreaz, UserMod, DataMod, Qta, Peso
FROM IstObj AS IstObj_1
WHERE (IdxObjMamma = @IdxObj_orig)
COMMIT TRAN
RETURN
'
END
GO
/****** Object: StoredProcedure [dbo].[sp_clonaObj] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_clonaObj]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'/*************************************
* STORED PROCEDURE sp_clonaObj
* clona un obj (ULP)
*
* modif.: S.E.L.
* il: 2008.10.23
**************************************/
CREATE PROCEDURE [dbo].[sp_clonaObj]
(
@IdxObj_orig VARCHAR(50)
)
AS
DECLARE @IdxObj_dest VARCHAR(50)
DECLARE @IdxObjMamma VARCHAR(50)
DECLARE @numShift INT
BEGIN TRAN
-- calcolo codMamma...
SET @IdxObjMamma = (SELECT IdxObjMamma FROM IstObj WHERE (IdxObj=@IdxObj_orig))
-- quante righe ho da usare "come shift"?!?
SET @numShift = (SELECT COUNT(IdxObj) FROM IstObj WHERE (IdxObjMamma LIKE LEFT(@IdxObjMamma,8)+''%'') AND Livello = 3)
-- calcolo nuovo idx x riga...
SET @IdxObj_dest = LEFT(@IdxObj_orig,9) + dbo.f_padLeft(@numShift + 1 , 2, ''0'')
-- clono la singola riga...
INSERT INTO IstObj
(IdxObj, CodCliente, CodStato, Posizione, Livello, Rev, CodObj, Nome, DataRif, IdxObjMamma, Note, ExtKey, DueDate, LeadTime, LeadTimeUM, UserCreaz, DataCreaz,
UserMod, DataMod, Qta, Peso)
SELECT @IdxObj_dest AS IdxObj, CodCliente, CodStato, @numShift + 1, Livello, Rev, CodObj, Nome, DataRif, IdxObjMamma, Note, ExtKey, DueDate, LeadTime, LeadTimeUM, UserCreaz,
DataCreaz, UserMod, DataMod, Qta, Peso
FROM IstObj AS IstObj_1
WHERE (IdxObj = @IdxObj_orig)
COMMIT TRAN
RETURN
'
END
GO
/****** Object: View [dbo].[v_ULP_DDT4Row] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_ULP_DDT4Row]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_ULP_DDT4Row]
AS
SELECT IdxObjMamma, COUNT(IdxObj) AS NumRighe, SUM(Peso) AS TotPeso, SUM(Qta) AS TotQta, MAX(DueDate) AS DueDate, MIN(CodStato) AS minStato, MAX(CodStato)
AS maxStato
FROM dbo.IstObj
WHERE (Livello = 3)
GROUP BY IdxObjMamma
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_ULP_DDT4Row', NULL,NULL))
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[41] 4[20] 2[10] 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 = "IstObj"
Begin Extent =
Top = 6
Left = 38
Bottom = 344
Right = 205
End
DisplayFlags = 280
TopColumn = 2
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 9
Width = 284
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
End
End
Begin CriteriaPane =
Begin ColumnWidths = 12
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_ULP_DDT4Row'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_ULP_DDT4Row', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_ULP_DDT4Row'
GO
/****** Object: View [dbo].[v_dateEsecuzione] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_dateEsecuzione]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_dateEsecuzione]
AS
SELECT DISTINCT TOP (100) PERCENT dbo.DateOnly(DueDate) AS Data
FROM dbo.IstObj
WHERE (NOT (DueDate IS NULL))
ORDER BY Data
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_dateEsecuzione', NULL,NULL))
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 = "IstObj"
Begin Extent =
Top = 6
Left = 38
Bottom = 309
Right = 189
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 9
Width = 284
Width = 1665
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
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_dateEsecuzione'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_dateEsecuzione', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_dateEsecuzione'
GO
/****** Object: View [dbo].[v_righeDDT] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_righeDDT]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_righeDDT]
AS
SELECT IdxObjMamma, COUNT(IdxObj) AS NumRighe, MAX(DueDate) AS DueDate
FROM dbo.IstObj
WHERE (Livello = 2)
GROUP BY IdxObjMamma
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_righeDDT', NULL,NULL))
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 = "IstObj"
Begin Extent =
Top = 6
Left = 38
Bottom = 286
Right = 189
End
DisplayFlags = 280
TopColumn = 6
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 9
Width = 284
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
End
End
Begin CriteriaPane =
Begin ColumnWidths = 12
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_righeDDT'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_righeDDT', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_righeDDT'
GO
/****** Object: StoredProcedure [dbo].[sp_contaNonSched] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_contaNonSched]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'/*************************************
* STORED PROCEDURE sp_contaNonSched
* conta quanti siano non schedulati (se >0 non si può avanzare di stato...)
*
* modif.: S.E.L.
* il: 2008.11.11
**************************************/
CREATE PROCEDURE [dbo].[sp_contaNonSched]
(
@codComune as VARCHAR(50)
)
AS
SELECT COUNT(*) AS quanti
FROM IstObj
WHERE (IdxObj LIKE @codComune) AND (Livello = 3) AND (DueDate IS NULL)
RETURN
'
END
GO
/****** Object: Trigger [trgStateUpd] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[trgStateUpd]'))
EXEC dbo.sp_executesql @statement = N'CREATE TRIGGER [dbo].[trgStateUpd]
ON [dbo].[IstObj]
FOR UPDATE
AS
IF UPDATE (CodStato)
DECLARE @dataMod DATETIME
SET @dataMod = GETDATE()
/* verifico che non sia già esistente il record (esempio cambio stato multiplo...) */
SELECT l.IdxObj
FROM LogStatoIstObj AS l INNER JOIN
inserted AS i ON l.IdxObj = i.IdxObj AND l.CodStato = i.CodStato
if(@@ROWCOUNT = 0)
begin
INSERT INTO LogStatoIstObj
(IdxObj, DataOra, Username, CodStato)
SELECT DISTINCT i.IdxObj, @dataMod, i.UserMod, i.CodStato
FROM inserted AS i
end
else
begin
UPDATE LogStatoIstObj
SET DataOra = @dataMod
FROM LogStatoIstObj AS l INNER JOIN inserted AS i ON l.IdxObj = i.IdxObj AND l.CodStato = i.CodStato
end'
GO
/****** Object: View [dbo].[v_logStati] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_logStati]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_logStati]
AS
SELECT dbo.IstObj.IdxObj, dbo.IstObj.CodCliente, dbo.IstObj.Nome, dbo.IstObj.DataRif, dbo.IstObj.Note, dbo.IstObj.ExtKey, dbo.LogStatoIstObj.DataOra,
dbo.AnagStati.DescrStato
FROM dbo.LogStatoIstObj INNER JOIN
dbo.IstObj ON dbo.LogStatoIstObj.IdxObj = dbo.IstObj.IdxObj INNER JOIN
dbo.AnagStati ON dbo.LogStatoIstObj.CodStato = dbo.AnagStati.CodStato
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_logStati', NULL,NULL))
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[41] 4[20] 2[12] 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 = "AnagStati"
Begin Extent =
Top = 49
Left = 672
Bottom = 142
Right = 823
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "IstObj"
Begin Extent =
Top = 9
Left = 144
Bottom = 285
Right = 295
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "LogStatoIstObj"
Begin Extent =
Top = 6
Left = 416
Bottom = 114
Right = 567
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 9
Width = 284
Width = 1500
Width = 1200
Width = 870
Width = 1500
Width = 1500
Width = 600
Width = 1665
Width = 1500
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_logStati'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_logStati', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_logStati'
GO
/****** Object: View [dbo].[v_selFiltri] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_selFiltri]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_selFiltri]
AS
SELECT TOP (100) PERCENT dbo.AnagFiltri.CodFiltro AS value, dbo.AnagFiltri.DescrFiltro AS label, dbo.Filtro2Funzione.COD_FUNZIONE AS conditio
FROM dbo.AnagFiltri INNER JOIN
dbo.Filtro2Funzione ON dbo.AnagFiltri.CodFiltro = dbo.Filtro2Funzione.CodFiltro
ORDER BY label
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_selFiltri', NULL,NULL))
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 = "AnagFiltri"
Begin Extent =
Top = 44
Left = 70
Bottom = 122
Right = 221
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "Filtro2Funzione"
Begin Extent =
Top = 37
Left = 280
Bottom = 115
Right = 439
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 9
Width = 284
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
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_selFiltri'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_selFiltri', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_selFiltri'
GO
/****** Object: View [dbo].[v_selStati] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_selStati]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_selStati]
AS
SELECT CodStato AS value, DescrStato AS label, FamStato AS conditio
FROM dbo.AnagStati
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_selStati', NULL,NULL))
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[41] 4[20] 2[7] 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 = "AnagStati"
Begin Extent =
Top = 6
Left = 38
Bottom = 99
Right = 189
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 9
Width = 284
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
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_selStati'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_selStati', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_selStati'
GO
/****** Object: View [dbo].[v_statoStartFam] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_statoStartFam]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_statoStartFam]
AS
SELECT FamStato, MIN(CodStato) AS CodStato
FROM dbo.AnagStati
GROUP BY FamStato
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_statoStartFam', NULL,NULL))
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 = "AnagStati"
Begin Extent =
Top = 6
Left = 38
Bottom = 99
Right = 205
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
End
Begin CriteriaPane =
Begin ColumnWidths = 12
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_statoStartFam'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_statoStartFam', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_statoStartFam'
GO
/****** Object: View [dbo].[v_selAnagLav] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_selAnagLav]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_selAnagLav]
AS
SELECT IdxLav AS value, DescrLav AS label
FROM dbo.AnagLav
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_selAnagLav', NULL,NULL))
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 = "AnagLav"
Begin Extent =
Top = 6
Left = 38
Bottom = 84
Right = 189
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
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_selAnagLav'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_selAnagLav', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_selAnagLav'
GO
/****** Object: View [dbo].[v_selTipoEvento] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_selTipoEvento]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_selTipoEvento]
AS
SELECT CodTipoEvento AS value, DescrTipoEv AS label
FROM dbo.TipoEventi
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_selTipoEvento', NULL,NULL))
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 = "TipoEventi"
Begin Extent =
Top = 6
Left = 38
Bottom = 84
Right = 189
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
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_selTipoEvento'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_selTipoEvento', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_selTipoEvento'
GO
/****** Object: View [dbo].[v_commesse] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_commesse]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_commesse]
AS
SELECT TOP (100) PERCENT dbo.IstObj.IdxObj AS Cod, AnagStati_1.DescrStato AS Stato, ISNULL(dbo.AnagClienti.CodCliente, N''-'') AS CodCliente,
ISNULL(dbo.AnagClienti.RagioneSociale, N''-'') AS Cliente, ISNULL(dbo.IstObj.ExtKey, N''-'') AS CodCli, ISNULL(dbo.IstObj.Note, N''-'') AS descrizione,
dbo.IstObj.Nome AS DDT, dbo.IstObj.DataRif AS DataDDT, dbo.IstObj.DataCreaz AS DataArrivo, dbo.IstObj.Posizione, ISNULL(dbo.v_ULP_DDT.TotQta, 0) AS Qta,
ISNULL(dbo.v_ULP_DDT.TotPeso, 0) AS Peso, ISNULL(dbo.v_righeDDT.NumRighe, 0) AS Righe, ISNULL(dbo.v_ULP_DDT.NumRighe, 0) AS Colli,
dbo.v_ULP_DDT.DueDate AS DataPrevista, dbo.IstObj.ExtKey AS Ciclo, dbo.IstObj.CodStato, dbo.AnagStati.DescrStato AS minStato,
AnagStati_2.DescrStato AS maxStato, dbo.v_ULP_DDT.minStato AS minCodStato, dbo.v_ULP_DDT.maxStato AS maxCodStato
FROM dbo.AnagStati INNER JOIN
dbo.v_ULP_DDT ON dbo.AnagStati.CodStato = dbo.v_ULP_DDT.minStato INNER JOIN
dbo.AnagStati AS AnagStati_2 ON dbo.v_ULP_DDT.maxStato = AnagStati_2.CodStato RIGHT OUTER JOIN
dbo.IstObj LEFT OUTER JOIN
dbo.AnagClienti ON dbo.IstObj.CodCliente = dbo.AnagClienti.CodCliente LEFT OUTER JOIN
dbo.AnagStati AS AnagStati_1 ON dbo.IstObj.CodStato = AnagStati_1.CodStato LEFT OUTER JOIN
dbo.v_righeDDT ON dbo.IstObj.IdxObj = dbo.v_righeDDT.IdxObjMamma ON dbo.v_ULP_DDT.IdxObjMamma = dbo.IstObj.IdxObj
WHERE (dbo.IstObj.IdxObjMamma IS NULL) AND (dbo.IstObj.Livello = 1)
ORDER BY DataArrivo DESC
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_commesse', NULL,NULL))
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[36] 4[33] 2[12] 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 = "AnagStati"
Begin Extent =
Top = 6
Left = 791
Bottom = 99
Right = 942
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "v_ULP_DDT"
Begin Extent =
Top = 23
Left = 602
Bottom = 129
Right = 753
End
DisplayFlags = 280
TopColumn = 3
End
Begin Table = "AnagStati_2"
Begin Extent =
Top = 153
Left = 806
Bottom = 246
Right = 957
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "IstObj"
Begin Extent =
Top = 11
Left = 305
Bottom = 336
Right = 456
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "AnagClienti"
Begin Extent =
Top = 164
Left = 43
Bottom = 242
Right = 195
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "AnagStati_1"
Begin Extent =
Top = 173
Left = 569
Bottom = 266
Right = 720
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "v_righeDDT"
Begin Extent =
Top = 23
Left = 35
Bottom = 133
Right = 186
End
Di' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_commesse'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane2' , N'SCHEMA',N'dbo', N'VIEW',N'v_commesse', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'splayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 20
Width = 284
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
End
End
Begin CriteriaPane =
Begin ColumnWidths = 11
Column = 3555
Alias = 1125
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_commesse'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_commesse', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_commesse'
GO
/****** Object: View [dbo].[v_righe] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_righe]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[v_righe]
AS
SELECT TOP (100) PERCENT dbo.IstObj.IdxObj AS Cod, AnagStati_1.DescrStato AS Stato, ISNULL(dbo.AnagClienti.CodCliente, N''-'') AS CodCliente,
ISNULL(dbo.AnagClienti.RagioneSociale, N''-'') AS Cliente, ISNULL(dbo.IstObj.ExtKey, N''-'') AS CodCli, ISNULL(dbo.IstObj.Note, N''-'') AS descrizione,
dbo.IstObj.Nome AS DDT, dbo.IstObj.DataRif AS DataDDT, dbo.IstObj.DataCreaz AS DataArrivo, dbo.IstObj.Posizione, dbo.v_ULP_DDT4Row.TotQta AS Qta,
dbo.v_ULP_DDT4Row.TotPeso AS Peso, ISNULL(dbo.v_ULP_DDT4Row.NumRighe, 0) AS Colli, dbo.v_ULP_DDT4Row.DueDate AS DataPrevista,
dbo.IstObj.IdxObjMamma, dbo.IstObj.CodStato, dbo.AnagStati.DescrStato AS minStato, AnagStati_2.DescrStato AS maxStato
FROM dbo.AnagStati INNER JOIN
dbo.v_ULP_DDT4Row ON dbo.AnagStati.CodStato = dbo.v_ULP_DDT4Row.minStato INNER JOIN
dbo.AnagStati AS AnagStati_2 ON dbo.v_ULP_DDT4Row.maxStato = AnagStati_2.CodStato RIGHT OUTER JOIN
dbo.IstObj LEFT OUTER JOIN
dbo.AnagClienti ON dbo.IstObj.CodCliente = dbo.AnagClienti.CodCliente LEFT OUTER JOIN
dbo.AnagStati AS AnagStati_1 ON dbo.IstObj.CodStato = AnagStati_1.CodStato ON dbo.v_ULP_DDT4Row.IdxObjMamma = dbo.IstObj.IdxObj
WHERE (NOT (dbo.IstObj.IdxObjMamma IS NULL)) AND (dbo.IstObj.Livello = 2)
ORDER BY DataArrivo DESC
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'v_righe', NULL,NULL))
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 = "IstObj"
Begin Extent =
Top = 22
Left = 375
Bottom = 341
Right = 526
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "AnagClienti"
Begin Extent =
Top = 36
Left = 99
Bottom = 114
Right = 251
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "AnagStati_1"
Begin Extent =
Top = 146
Left = 101
Bottom = 254
Right = 252
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "v_ULP_DDT4Row"
Begin Extent =
Top = 15
Left = 711
Bottom = 220
Right = 862
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "AnagStati"
Begin Extent =
Top = 6
Left = 900
Bottom = 99
Right = 1051
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "AnagStati_2"
Begin Extent =
Top = 6
Left = 1089
Bottom = 99
Right = 1240
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 17
Width = 284
Width = 2175
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_righe'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane2' , N'SCHEMA',N'dbo', N'VIEW',N'v_righe', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1860
Width = 1500
Width = 1500
End
End
Begin CriteriaPane =
Begin ColumnWidths = 11
Column = 1440
Alias = 990
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_righe'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'v_righe', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_righe'
GO
/****** Object: StoredProcedure [dbo].[sp_updateAncestorState] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_updateAncestorState]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'/*************************************
* STORED PROCEDURE sp_updateAncestorState
* aggiorna lo stato degli ancestor (madri e figlie) data la parte di codice comune a madri e figlie e lo stato corrente degli oggetti leaf (ULP)
*
* modif.: S.E.L.
* il: 2008.11.06
**************************************/
CREATE PROCEDURE [dbo].[sp_updateAncestorState]
(
@idxObjCommon VARCHAR(50)
)
AS
UPDATE IstObj
SET CodStato = v_ULP_DDT4Row.minStato
FROM IstObj INNER JOIN
v_ULP_DDT4Row ON IstObj.IdxObj = v_ULP_DDT4Row.IdxObjMamma AND IstObj.CodStato <> v_ULP_DDT4Row.minStato
WHERE (IstObj.IdxObj LIKE @idxObjCommon)
UPDATE IstObj
SET CodStato = v_ULP_DDT.minStato
FROM IstObj INNER JOIN
v_ULP_DDT ON IstObj.IdxObj = v_ULP_DDT.IdxObjMamma AND IstObj.CodStato <> v_ULP_DDT.minStato
WHERE (IstObj.IdxObj LIKE @idxObjCommon)
RETURN
'
END
GO
/****** Object: StoredProcedure [dbo].[sp_creaSetObj] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_creaSetObj]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'/*************************************
* STORED PROCEDURE sp_creaSetObj
* crea un set iniziale di valori da tracciare x la commessa
*
* modif.: S.E.L.
* il: 2008.10.17
**************************************/
CREATE PROCEDURE [dbo].[sp_creaSetObj]
(
@IdxObj VARCHAR(50),
@CodSet VARCHAR(50),
@CodCliente VARCHAR(50),
@NumDDT VARCHAR(50),
@dataDDT as DATETIME,
@Nome VARCHAR(50),
@UserName VARCHAR(50),
@note VARCHAR(50)
)
AS
DECLARE @livello VARCHAR(50)
DECLARE @IdxObjMamma VARCHAR(50)
DECLARE @numRow INT
DECLARE @adesso DATETIME
DECLARE @depth INT
BEGIN tran
/* creazione oggetti in qta minima */
SET @adesso = GETDATE()
SET @depth = 1
-- parto da obj top #.
SET @livello = ''#.''
INSERT INTO IstObj(IdxObj, Livello,ExtKey , DataRif, Rev,CodObj, Posizione,Nome ,UserCreaz,DataCreaz,UserMod,DataMod,CodStato,Note,CodCliente)
SELECT @IdxObj + Object2Set.CodObj AS idx, @depth, @Nome, @dataDDT, 0, Object2Set.CodObj, 1, @NumDDT AS Expr4,
@UserName AS Expr5, @adesso AS Expr6, @UserName AS Expr7, @adesso AS Expr8, V_statoStartFam.CodStato,@note,@CodCliente
FROM AnagFamStati INNER JOIN
AnagObj ON AnagFamStati.FamStato = AnagObj.FamStato INNER JOIN
Object2Set ON AnagObj.CodObj = Object2Set.CodObj INNER JOIN
V_statoStartFam ON AnagFamStati.FamStato = V_statoStartFam.FamStato
WHERE (Object2Set.Posizione = @livello)
-- salvo idx mamma...
SET @IdxObjMamma = (SELECT IdxObj FROM IstObj WHERE DataCreaz=@adesso AND Livello=@depth)
-- ora creo gli obj dei livelli successivi... aggiungo "#." al livello e conto se ce ne solo con ciclo while...
SET @livello = @livello + ''#.''
SET @numRow = (SELECT count(IdxSet)
FROM Object2Set
WHERE (Posizione = @livello))
WHILE(@numRow > 0)
BEGIN
SET @depth = @depth +1
-- inserisco valori child
INSERT INTO IstObj(IdxObj, Livello, ExtKey, DataRif, Rev,CodObj, Posizione, Nome,UserCreaz,DataCreaz,UserMod,DataMod,CodStato,Note,CodCliente, IdxObjMamma)
SELECT @IdxObj + Object2Set.CodObj +''01'' AS idx, @depth, @Nome, @dataDDT, 0, Object2Set.CodObj, 1, @NumDDT ,
@UserName AS Expr5, @adesso, @UserName AS Expr7, @adesso AS Expr8, v_statoStartFam.CodStato,@note,@CodCliente, @IdxObjMamma
FROM AnagFamStati INNER JOIN
AnagObj ON AnagFamStati.FamStato = AnagObj.FamStato INNER JOIN
Object2Set ON AnagObj.CodObj = Object2Set.CodObj INNER JOIN
v_statoStartFam ON AnagFamStati.FamStato = v_statoStartFam.FamStato
WHERE (Object2Set.Posizione = @livello)
-- salvo idx mamma...
SET @IdxObjMamma = (SELECT IdxObj FROM IstObj WHERE DataCreaz=@adesso AND Livello=@depth)
-- aggiorno conteggio...
SET @livello = @livello + ''#.''
SET @numRow = (SELECT count(IdxSet)
FROM Object2Set
WHERE (Posizione = @livello))
END
/* creazione fasi std per ogni oggetto creato */
COMMIT tran
RETURN null
'
END
GO
/****** Object: StoredProcedure [dbo].[sp_schedaIdent] Script Date: 11/21/2008 15:51:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_schedaIdent]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'/*************************************
* STORED PROCEDURE sp_schedaIdent
* restituisce i dati x stampare 1 scheda di identificazione
*
* modif.: S.E.L.
* il: 2008.10.24
**************************************/
CREATE PROCEDURE [dbo].[sp_schedaIdent]
(
@IdxObj VARCHAR(50)
)
AS
/*
SELECT dbo.IstObj.IdxObj, dbo.AnagClienti.RagioneSociale AS Cliente, dbo.IstObj.Nome AS DDT, GETDATE() AS DDT_del, dbo.IstObj.DataCreaz AS DataArrivo,
dbo.IstObj.ExtKey AS CodProdotto, dbo.v_ULP_DDT.DueDate AS ConsegnaPrevista, dbo.v_ULP_DDT.TotPeso AS Peso, ''n'' AS Brunitura, ''o'' AS Fosfatazione,
''o'' AS MercePronta, ''n'' AS Ciclo_F1, ''o'' AS Ciclo_F2, ''o'' AS Ciclo_M, ''n'' AS Ciclo_X2, ''o'' AS Ciclo_Olio, ''o'' AS Ciclo_FinSecco
FROM dbo.IstObj INNER JOIN
dbo.AnagClienti ON dbo.IstObj.CodCliente = dbo.AnagClienti.CodCliente LEFT OUTER JOIN
dbo.v_ULP_DDT ON dbo.IstObj.IdxObj = dbo.v_ULP_DDT.IdxObjMamma
WHERE (dbo.IstObj.Livello = 3) AND
dbo.IstObj.IdxObj=@IdxObj
*/
SELECT Cod AS IdxObj, Cliente, DDT, DataDDT AS DDT_del, DataArrivo, descrizione AS CodProdotto, DataPrevista AS ConsegnaPrevista, Peso,
CASE CodCli WHEN ''Fosf'' THEN ''X'' ELSE '' '' END AS FosfManganese, CASE CodCli WHEN ''Brun'' THEN ''X'' ELSE '' '' END AS Brunitura,
CASE CodCli WHEN ''Fosf_Tefl'' THEN ''X'' ELSE '' '' END AS FosfTeflon, CASE CodCli WHEN ''Sabb'' THEN ''X'' ELSE '' '' END AS Sabbiatura, '' '' AS F1, '' '' AS F2,
'' '' AS FosfZinco, '' '' AS Teflon, '' '' AS FosfPreVern, '' '' AS PzRoto, '' '' AS Zinchlorex, '' '' AS PeekVicote, CodCli
FROM v_ULP
WHERE (Cod = @IdxObj)
RETURN
'
END
GO
/****** Object: Default [DF_AnagTipoObj_isLogical] Script Date: 11/21/2008 15:51:46 ******/
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_AnagTipoObj_isLogical]') AND parent_object_id = OBJECT_ID(N'[dbo].[AnagObj]'))
Begin
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_AnagTipoObj_isLogical]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[AnagObj] ADD CONSTRAINT [DF_AnagTipoObj_isLogical] DEFAULT ((0)) FOR [Concreto]
END
End
GO
/****** Object: Default [DF_ObjectSet_MinOcc] Script Date: 11/21/2008 15:51:46 ******/
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_ObjectSet_MinOcc]') AND parent_object_id = OBJECT_ID(N'[dbo].[Object2Set]'))
Begin
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ObjectSet_MinOcc]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Object2Set] ADD CONSTRAINT [DF_ObjectSet_MinOcc] DEFAULT ((1)) FOR [Qta]
END
End
GO
/****** Object: Default [DF_ObjectSet_MaxOcc] Script Date: 11/21/2008 15:51:46 ******/
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_ObjectSet_MaxOcc]') AND parent_object_id = OBJECT_ID(N'[dbo].[Object2Set]'))
Begin
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ObjectSet_MaxOcc]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Object2Set] ADD CONSTRAINT [DF_ObjectSet_MaxOcc] DEFAULT ((0)) FOR [UserQtyReq]
END
End
GO
/****** Object: ForeignKey [FK_AnagObj_AnagFamStati] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AnagObj_AnagFamStati]') AND parent_object_id = OBJECT_ID(N'[dbo].[AnagObj]'))
ALTER TABLE [dbo].[AnagObj] WITH CHECK ADD CONSTRAINT [FK_AnagObj_AnagFamStati] FOREIGN KEY([FamStato])
REFERENCES [dbo].[AnagFamStati] ([FamStato])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AnagObj_AnagFamStati]') AND parent_object_id = OBJECT_ID(N'[dbo].[AnagObj]'))
ALTER TABLE [dbo].[AnagObj] CHECK CONSTRAINT [FK_AnagObj_AnagFamStati]
GO
/****** Object: ForeignKey [FK_AnagStati_AnagFamStati] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AnagStati_AnagFamStati]') AND parent_object_id = OBJECT_ID(N'[dbo].[AnagStati]'))
ALTER TABLE [dbo].[AnagStati] WITH CHECK ADD CONSTRAINT [FK_AnagStati_AnagFamStati] FOREIGN KEY([FamStato])
REFERENCES [dbo].[AnagFamStati] ([FamStato])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_AnagStati_AnagFamStati]') AND parent_object_id = OBJECT_ID(N'[dbo].[AnagStati]'))
ALTER TABLE [dbo].[AnagStati] CHECK CONSTRAINT [FK_AnagStati_AnagFamStati]
GO
/****** Object: ForeignKey [FK_Eventi_TipoEventi] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Eventi_TipoEventi]') AND parent_object_id = OBJECT_ID(N'[dbo].[Eventi]'))
ALTER TABLE [dbo].[Eventi] WITH CHECK ADD CONSTRAINT [FK_Eventi_TipoEventi] FOREIGN KEY([CodTipoEvento])
REFERENCES [dbo].[TipoEventi] ([CodTipoEvento])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Eventi_TipoEventi]') AND parent_object_id = OBJECT_ID(N'[dbo].[Eventi]'))
ALTER TABLE [dbo].[Eventi] CHECK CONSTRAINT [FK_Eventi_TipoEventi]
GO
/****** Object: ForeignKey [FK_Fasi2Obj_AnafFasiObj] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Fasi2Obj_AnafFasiObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[Fasi2Obj]'))
ALTER TABLE [dbo].[Fasi2Obj] WITH CHECK ADD CONSTRAINT [FK_Fasi2Obj_AnafFasiObj] FOREIGN KEY([CodFase])
REFERENCES [dbo].[AnagFasiObj] ([CodFase])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Fasi2Obj_AnafFasiObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[Fasi2Obj]'))
ALTER TABLE [dbo].[Fasi2Obj] CHECK CONSTRAINT [FK_Fasi2Obj_AnafFasiObj]
GO
/****** Object: ForeignKey [FK_Fasi2Obj_AnagObj] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Fasi2Obj_AnagObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[Fasi2Obj]'))
ALTER TABLE [dbo].[Fasi2Obj] WITH CHECK ADD CONSTRAINT [FK_Fasi2Obj_AnagObj] FOREIGN KEY([CodObj])
REFERENCES [dbo].[AnagObj] ([CodObj])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Fasi2Obj_AnagObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[Fasi2Obj]'))
ALTER TABLE [dbo].[Fasi2Obj] CHECK CONSTRAINT [FK_Fasi2Obj_AnagObj]
GO
/****** Object: ForeignKey [FK_Filtro2Funzione_AnagFiltri] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Filtro2Funzione_AnagFiltri]') AND parent_object_id = OBJECT_ID(N'[dbo].[Filtro2Funzione]'))
ALTER TABLE [dbo].[Filtro2Funzione] WITH CHECK ADD CONSTRAINT [FK_Filtro2Funzione_AnagFiltri] FOREIGN KEY([CodFiltro])
REFERENCES [dbo].[AnagFiltri] ([CodFiltro])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Filtro2Funzione_AnagFiltri]') AND parent_object_id = OBJECT_ID(N'[dbo].[Filtro2Funzione]'))
ALTER TABLE [dbo].[Filtro2Funzione] CHECK CONSTRAINT [FK_Filtro2Funzione_AnagFiltri]
GO
/****** Object: ForeignKey [FK_Filtro2Stati_AnagFiltri] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Filtro2Stati_AnagFiltri]') AND parent_object_id = OBJECT_ID(N'[dbo].[Filtro2Stati]'))
ALTER TABLE [dbo].[Filtro2Stati] WITH CHECK ADD CONSTRAINT [FK_Filtro2Stati_AnagFiltri] FOREIGN KEY([CodFiltro])
REFERENCES [dbo].[AnagFiltri] ([CodFiltro])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Filtro2Stati_AnagFiltri]') AND parent_object_id = OBJECT_ID(N'[dbo].[Filtro2Stati]'))
ALTER TABLE [dbo].[Filtro2Stati] CHECK CONSTRAINT [FK_Filtro2Stati_AnagFiltri]
GO
/****** Object: ForeignKey [FK_Filtro2Stati_AnagStati] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Filtro2Stati_AnagStati]') AND parent_object_id = OBJECT_ID(N'[dbo].[Filtro2Stati]'))
ALTER TABLE [dbo].[Filtro2Stati] WITH CHECK ADD CONSTRAINT [FK_Filtro2Stati_AnagStati] FOREIGN KEY([CodStato])
REFERENCES [dbo].[AnagStati] ([CodStato])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Filtro2Stati_AnagStati]') AND parent_object_id = OBJECT_ID(N'[dbo].[Filtro2Stati]'))
ALTER TABLE [dbo].[Filtro2Stati] CHECK CONSTRAINT [FK_Filtro2Stati_AnagStati]
GO
/****** Object: ForeignKey [FK_FasiObj_ObjList] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_FasiObj_ObjList]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstFasiObj]'))
ALTER TABLE [dbo].[IstFasiObj] WITH CHECK ADD CONSTRAINT [FK_FasiObj_ObjList] FOREIGN KEY([IdxObj])
REFERENCES [dbo].[IstObj] ([IdxObj])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_FasiObj_ObjList]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstFasiObj]'))
ALTER TABLE [dbo].[IstFasiObj] CHECK CONSTRAINT [FK_FasiObj_ObjList]
GO
/****** Object: ForeignKey [FK_IstObj_AnagClienti] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_IstObj_AnagClienti]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstObj]'))
ALTER TABLE [dbo].[IstObj] WITH CHECK ADD CONSTRAINT [FK_IstObj_AnagClienti] FOREIGN KEY([CodCliente])
REFERENCES [dbo].[AnagClienti] ([CodCliente])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_IstObj_AnagClienti]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstObj]'))
ALTER TABLE [dbo].[IstObj] CHECK CONSTRAINT [FK_IstObj_AnagClienti]
GO
/****** Object: ForeignKey [FK_IstObj_UM] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_IstObj_UM]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstObj]'))
ALTER TABLE [dbo].[IstObj] WITH CHECK ADD CONSTRAINT [FK_IstObj_UM] FOREIGN KEY([LeadTimeUM])
REFERENCES [dbo].[UM] ([UM])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_IstObj_UM]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstObj]'))
ALTER TABLE [dbo].[IstObj] CHECK CONSTRAINT [FK_IstObj_UM]
GO
/****** Object: ForeignKey [FK_ObjList_AnagStati] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ObjList_AnagStati]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstObj]'))
ALTER TABLE [dbo].[IstObj] WITH CHECK ADD CONSTRAINT [FK_ObjList_AnagStati] FOREIGN KEY([CodStato])
REFERENCES [dbo].[AnagStati] ([CodStato])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ObjList_AnagStati]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstObj]'))
ALTER TABLE [dbo].[IstObj] CHECK CONSTRAINT [FK_ObjList_AnagStati]
GO
/****** Object: ForeignKey [FK_TrackObj_AnagObj] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TrackObj_AnagObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstObj]'))
ALTER TABLE [dbo].[IstObj] WITH CHECK ADD CONSTRAINT [FK_TrackObj_AnagObj] FOREIGN KEY([CodObj])
REFERENCES [dbo].[AnagObj] ([CodObj])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TrackObj_AnagObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstObj]'))
ALTER TABLE [dbo].[IstObj] CHECK CONSTRAINT [FK_TrackObj_AnagObj]
GO
/****** Object: ForeignKey [FK_WBS2Fasi_FasiObj] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_WBS2Fasi_FasiObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstWbsFasi]'))
ALTER TABLE [dbo].[IstWbsFasi] WITH CHECK ADD CONSTRAINT [FK_WBS2Fasi_FasiObj] FOREIGN KEY([IdxObj], [CodFase], [WBS])
REFERENCES [dbo].[IstFasiObj] ([IdxObj], [CodFase], [WBS])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_WBS2Fasi_FasiObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[IstWbsFasi]'))
ALTER TABLE [dbo].[IstWbsFasi] CHECK CONSTRAINT [FK_WBS2Fasi_FasiObj]
GO
/****** Object: ForeignKey [FK_LogStatoIstObj_IstObj] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_LogStatoIstObj_IstObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogStatoIstObj]'))
ALTER TABLE [dbo].[LogStatoIstObj] WITH CHECK ADD CONSTRAINT [FK_LogStatoIstObj_IstObj] FOREIGN KEY([IdxObj])
REFERENCES [dbo].[IstObj] ([IdxObj])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_LogStatoIstObj_IstObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogStatoIstObj]'))
ALTER TABLE [dbo].[LogStatoIstObj] CHECK CONSTRAINT [FK_LogStatoIstObj_IstObj]
GO
/****** Object: ForeignKey [FK_Note_ObjList] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Note_ObjList]') AND parent_object_id = OBJECT_ID(N'[dbo].[Note]'))
ALTER TABLE [dbo].[Note] WITH CHECK ADD CONSTRAINT [FK_Note_ObjList] FOREIGN KEY([IdxObj])
REFERENCES [dbo].[IstObj] ([IdxObj])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Note_ObjList]') AND parent_object_id = OBJECT_ID(N'[dbo].[Note]'))
ALTER TABLE [dbo].[Note] CHECK CONSTRAINT [FK_Note_ObjList]
GO
/****** Object: ForeignKey [FK_Object2Set_AnagSet] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Object2Set_AnagSet]') AND parent_object_id = OBJECT_ID(N'[dbo].[Object2Set]'))
ALTER TABLE [dbo].[Object2Set] WITH CHECK ADD CONSTRAINT [FK_Object2Set_AnagSet] FOREIGN KEY([IdxSet])
REFERENCES [dbo].[AnagSet] ([IdxSet])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Object2Set_AnagSet]') AND parent_object_id = OBJECT_ID(N'[dbo].[Object2Set]'))
ALTER TABLE [dbo].[Object2Set] CHECK CONSTRAINT [FK_Object2Set_AnagSet]
GO
/****** Object: ForeignKey [FK_ObjectSet_AnagTipoObj] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ObjectSet_AnagTipoObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[Object2Set]'))
ALTER TABLE [dbo].[Object2Set] WITH CHECK ADD CONSTRAINT [FK_ObjectSet_AnagTipoObj] FOREIGN KEY([CodObj])
REFERENCES [dbo].[AnagObj] ([CodObj])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ObjectSet_AnagTipoObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[Object2Set]'))
ALTER TABLE [dbo].[Object2Set] CHECK CONSTRAINT [FK_ObjectSet_AnagTipoObj]
GO
/****** Object: ForeignKey [FK_Permessi2Funzione_Permessi] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Permessi2Funzione_Permessi]') AND parent_object_id = OBJECT_ID(N'[dbo].[Permessi2Funzione]'))
ALTER TABLE [dbo].[Permessi2Funzione] WITH CHECK ADD CONSTRAINT [FK_Permessi2Funzione_Permessi] FOREIGN KEY([COD_PERMESSO])
REFERENCES [dbo].[Permessi] ([COD_PERMESSO])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Permessi2Funzione_Permessi]') AND parent_object_id = OBJECT_ID(N'[dbo].[Permessi2Funzione]'))
ALTER TABLE [dbo].[Permessi2Funzione] CHECK CONSTRAINT [FK_Permessi2Funzione_Permessi]
GO
/****** Object: ForeignKey [FK_Risorse2TT_AnagRisorse] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Risorse2TT_AnagRisorse]') AND parent_object_id = OBJECT_ID(N'[dbo].[Risorse2TT]'))
ALTER TABLE [dbo].[Risorse2TT] WITH CHECK ADD CONSTRAINT [FK_Risorse2TT_AnagRisorse] FOREIGN KEY([CodRisorsa])
REFERENCES [dbo].[AnagRisorse] ([CodRisorsa])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Risorse2TT_AnagRisorse]') AND parent_object_id = OBJECT_ID(N'[dbo].[Risorse2TT]'))
ALTER TABLE [dbo].[Risorse2TT] CHECK CONSTRAINT [FK_Risorse2TT_AnagRisorse]
GO
/****** Object: ForeignKey [FK_Risorse2TT_TimeTrack] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Risorse2TT_TimeTrack]') AND parent_object_id = OBJECT_ID(N'[dbo].[Risorse2TT]'))
ALTER TABLE [dbo].[Risorse2TT] WITH CHECK ADD CONSTRAINT [FK_Risorse2TT_TimeTrack] FOREIGN KEY([IdxTT])
REFERENCES [dbo].[TimeTrack] ([IdxTT])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Risorse2TT_TimeTrack]') AND parent_object_id = OBJECT_ID(N'[dbo].[Risorse2TT]'))
ALTER TABLE [dbo].[Risorse2TT] CHECK CONSTRAINT [FK_Risorse2TT_TimeTrack]
GO
/****** Object: ForeignKey [FK_Risorse2TT_UmMisure] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Risorse2TT_UmMisure]') AND parent_object_id = OBJECT_ID(N'[dbo].[Risorse2TT]'))
ALTER TABLE [dbo].[Risorse2TT] WITH CHECK ADD CONSTRAINT [FK_Risorse2TT_UmMisure] FOREIGN KEY([UmMisura])
REFERENCES [dbo].[UM] ([UM])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Risorse2TT_UmMisure]') AND parent_object_id = OBJECT_ID(N'[dbo].[Risorse2TT]'))
ALTER TABLE [dbo].[Risorse2TT] CHECK CONSTRAINT [FK_Risorse2TT_UmMisure]
GO
/****** Object: ForeignKey [FK_Fasi_Oggetti] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Fasi_Oggetti]') AND parent_object_id = OBJECT_ID(N'[dbo].[Step]'))
ALTER TABLE [dbo].[Step] WITH CHECK ADD CONSTRAINT [FK_Fasi_Oggetti] FOREIGN KEY([IdxTipoObj])
REFERENCES [dbo].[AnagObj] ([CodObj])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Fasi_Oggetti]') AND parent_object_id = OBJECT_ID(N'[dbo].[Step]'))
ALTER TABLE [dbo].[Step] CHECK CONSTRAINT [FK_Fasi_Oggetti]
GO
/****** Object: ForeignKey [FK_FasiObj_TrackObj] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_FasiObj_TrackObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[Step4Obj]'))
ALTER TABLE [dbo].[Step4Obj] WITH CHECK ADD CONSTRAINT [FK_FasiObj_TrackObj] FOREIGN KEY([IdxObj])
REFERENCES [dbo].[IstObj] ([IdxObj])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_FasiObj_TrackObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[Step4Obj]'))
ALTER TABLE [dbo].[Step4Obj] CHECK CONSTRAINT [FK_FasiObj_TrackObj]
GO
/****** Object: ForeignKey [FK_TimeTrack_FasiObj] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TimeTrack_FasiObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[TimeTrack]'))
ALTER TABLE [dbo].[TimeTrack] WITH CHECK ADD CONSTRAINT [FK_TimeTrack_FasiObj] FOREIGN KEY([IdxObj], [CodFase], [WBS])
REFERENCES [dbo].[IstFasiObj] ([IdxObj], [CodFase], [WBS])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TimeTrack_FasiObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[TimeTrack]'))
ALTER TABLE [dbo].[TimeTrack] CHECK CONSTRAINT [FK_TimeTrack_FasiObj]
GO
/****** Object: ForeignKey [FK_TraEv2Stati_AnagObj] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TraEv2Stati_AnagObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[TraEv2Stati]'))
ALTER TABLE [dbo].[TraEv2Stati] WITH CHECK ADD CONSTRAINT [FK_TraEv2Stati_AnagObj] FOREIGN KEY([CodObj])
REFERENCES [dbo].[AnagObj] ([CodObj])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TraEv2Stati_AnagObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[TraEv2Stati]'))
ALTER TABLE [dbo].[TraEv2Stati] CHECK CONSTRAINT [FK_TraEv2Stati_AnagObj]
GO
/****** Object: ForeignKey [FK_TraEv2Stati_AnagStati] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TraEv2Stati_AnagStati]') AND parent_object_id = OBJECT_ID(N'[dbo].[TraEv2Stati]'))
ALTER TABLE [dbo].[TraEv2Stati] WITH CHECK ADD CONSTRAINT [FK_TraEv2Stati_AnagStati] FOREIGN KEY([CodStato])
REFERENCES [dbo].[AnagStati] ([CodStato])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TraEv2Stati_AnagStati]') AND parent_object_id = OBJECT_ID(N'[dbo].[TraEv2Stati]'))
ALTER TABLE [dbo].[TraEv2Stati] CHECK CONSTRAINT [FK_TraEv2Stati_AnagStati]
GO
/****** Object: ForeignKey [FK_TransizioneEventiStati_AnagMappe] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TransizioneEventiStati_AnagMappe]') AND parent_object_id = OBJECT_ID(N'[dbo].[TraEv2Stati]'))
ALTER TABLE [dbo].[TraEv2Stati] WITH CHECK ADD CONSTRAINT [FK_TransizioneEventiStati_AnagMappe] FOREIGN KEY([CodMappa])
REFERENCES [dbo].[AnagMappe] ([CodMappa])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TransizioneEventiStati_AnagMappe]') AND parent_object_id = OBJECT_ID(N'[dbo].[TraEv2Stati]'))
ALTER TABLE [dbo].[TraEv2Stati] CHECK CONSTRAINT [FK_TransizioneEventiStati_AnagMappe]
GO
/****** Object: ForeignKey [FK_TransizioneEventiStati_Eventi] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TransizioneEventiStati_Eventi]') AND parent_object_id = OBJECT_ID(N'[dbo].[TraEv2Stati]'))
ALTER TABLE [dbo].[TraEv2Stati] WITH CHECK ADD CONSTRAINT [FK_TransizioneEventiStati_Eventi] FOREIGN KEY([CodEvento])
REFERENCES [dbo].[Eventi] ([CodEvento])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TransizioneEventiStati_Eventi]') AND parent_object_id = OBJECT_ID(N'[dbo].[TraEv2Stati]'))
ALTER TABLE [dbo].[TraEv2Stati] CHECK CONSTRAINT [FK_TransizioneEventiStati_Eventi]
GO
/****** Object: ForeignKey [FK_Tratt2Obj_AnagTrattamenti] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Tratt2Obj_AnagTrattamenti]') AND parent_object_id = OBJECT_ID(N'[dbo].[Tratt2Obj]'))
ALTER TABLE [dbo].[Tratt2Obj] WITH CHECK ADD CONSTRAINT [FK_Tratt2Obj_AnagTrattamenti] FOREIGN KEY([CodTrattamento])
REFERENCES [dbo].[AnagTrattamenti] ([CodTrattamento])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Tratt2Obj_AnagTrattamenti]') AND parent_object_id = OBJECT_ID(N'[dbo].[Tratt2Obj]'))
ALTER TABLE [dbo].[Tratt2Obj] CHECK CONSTRAINT [FK_Tratt2Obj_AnagTrattamenti]
GO
/****** Object: ForeignKey [FK_Tratt2Obj_IstObj] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Tratt2Obj_IstObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[Tratt2Obj]'))
ALTER TABLE [dbo].[Tratt2Obj] WITH CHECK ADD CONSTRAINT [FK_Tratt2Obj_IstObj] FOREIGN KEY([IdxObj])
REFERENCES [dbo].[IstObj] ([IdxObj])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Tratt2Obj_IstObj]') AND parent_object_id = OBJECT_ID(N'[dbo].[Tratt2Obj]'))
ALTER TABLE [dbo].[Tratt2Obj] CHECK CONSTRAINT [FK_Tratt2Obj_IstObj]
GO
/****** Object: ForeignKey [FK_Wbs2Links_AnagLink] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Wbs2Links_AnagLink]') AND parent_object_id = OBJECT_ID(N'[dbo].[WbsFasi2Links]'))
ALTER TABLE [dbo].[WbsFasi2Links] WITH CHECK ADD CONSTRAINT [FK_Wbs2Links_AnagLink] FOREIGN KEY([LinkType])
REFERENCES [dbo].[AnagLink] ([LinkType])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Wbs2Links_AnagLink]') AND parent_object_id = OBJECT_ID(N'[dbo].[WbsFasi2Links]'))
ALTER TABLE [dbo].[WbsFasi2Links] CHECK CONSTRAINT [FK_Wbs2Links_AnagLink]
GO
/****** Object: ForeignKey [FK_Wbs2Links_Fasi2Obj] Script Date: 11/21/2008 15:51:46 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Wbs2Links_Fasi2Obj]') AND parent_object_id = OBJECT_ID(N'[dbo].[WbsFasi2Links]'))
ALTER TABLE [dbo].[WbsFasi2Links] WITH CHECK ADD CONSTRAINT [FK_Wbs2Links_Fasi2Obj] FOREIGN KEY([CodObj], [WBS], [CodFase])
REFERENCES [dbo].[Fasi2Obj] ([CodObj], [WBS], [CodFase])
ON UPDATE CASCADE
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Wbs2Links_Fasi2Obj]') AND parent_object_id = OBJECT_ID(N'[dbo].[WbsFasi2Links]'))
ALTER TABLE [dbo].[WbsFasi2Links] CHECK CONSTRAINT [FK_Wbs2Links_Fasi2Obj]
GO
Reference in New Issue View Git Blame Copy Permalink