/****** 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