SuperWhere Table

USE [MyPage_V1]
GO

/****** Object: Table [dbo].[WhereV2016] Script Date: 6/9/2016 9:28:42 πμ ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WhereV2016](
[CodUserLogin] [int] NOT NULL,
[WhereNumber] [int] NOT NULL,
[DaysBeforeStart] [int] NOT NULL,
[DaysBeforeEnd] [int] NOT NULL,
[EkdosiHm_APO] [datetime] NOT NULL,
[EkdosiHm_EOS] [datetime] NOT NULL,
[EkdosiApoMetafora] [datetime] NOT NULL,
[ParSiraCod] [int] NOT NULL,
[ParTyposCod] [int] NOT NULL,
[PelCod] [int] NOT NULL,
[XristisCod] [int] NOT NULL,
[PelLogistZoneCod] [int] NOT NULL,
[IdosLogarTyposCod] [int] NOT NULL,
[IdosLogarCod] [int] NOT NULL,
[PosoLogarTyposCod] [int] NOT NULL,
[PosoLogarCod] [int] NOT NULL,
[IdosTyposCod] [int] NOT NULL,
[IdosCod] [int] NOT NULL,
[IdosPartidaCod] [int] NOT NULL,
[ParPosoTyposCod] [int] NOT NULL,
[ParPosoPosoMin] [money] NOT NULL,
[ParPosoPosoMax] [money] NOT NULL,
[ParIdosPartidaApothikiCod] [int] NOT NULL,
[ParIdosPartidaApothikiTyposCod] [int] NOT NULL,
[ParIdosPartidaPosoMin] [money] NOT NULL,
[ParIdosPartidaPosoMax] [money] NOT NULL,
[ParIdosPartidaPosotitaMin] [money] NOT NULL,
[ParIdosPartidaPosotitaMax] [money] NOT NULL,
[FPACod] [int] NOT NULL,
[FPAKathestosCod] [int] NOT NULL,
[PelHm_Apo] [datetime] NOT NULL,
[PelHm_Eos] [datetime] NOT NULL,
[PosotitaTop] [int] NOT NULL,
[PosoTop] [int] NOT NULL,
[PelDataTyposCod] [int] NOT NULL,
[PelDataCheckTyposCod] [int] NOT NULL,
[PelDataCheckEpilogi] [bit] NOT NULL,
[PelDataClientTyposCod] [int] NOT NULL,
[PelDataClientCod] [int] NOT NULL,
[PelDataDDGroupTyposCod] [int] NOT NULL,
[PelDataDDTyposCod] [int] NOT NULL,
[PelDataEMailTyposCod] [int] NOT NULL,
[PelDataFileTyposCod] [int] NOT NULL,
[PelDataHmTyposCod] [int] NOT NULL,
[PelDataHmMin] [datetime] NOT NULL,
[PelDataHmMax] [datetime] NOT NULL,
[PelDataMonadaTyposCod] [int] NOT NULL,
[PelDataMonadaMin] [money] NOT NULL,
[PelDataMonadaMax] [money] NOT NULL,
[PelDataPhoneTyposCod] [int] NOT NULL,
[PelDataPhoneTxt] [nvarchar](250) NOT NULL,
[PelDataPhotoTyposCod] [int] NOT NULL,
[PelDataPosoTyposCod] [int] NOT NULL,
[PelDataPosoMin] [money] NOT NULL,
[PelDataPosoMax] [money] NOT NULL,
[PelDataPromTyposCod] [int] NOT NULL,
[PelDataPromCod] [int] NOT NULL,
[PelDataServiceTyposCod] [int] NOT NULL,
[PelDataServiceCod] [int] NOT NULL,
[PelDataTextTyposCod] [int] NOT NULL,
[PelDataWWWTyposCod] [int] NOT NULL,
[ParPelDataTyposCod] [int] NOT NULL,
[ParPelDataCheckTyposCod] [int] NOT NULL,
[ParPelDataCheckEpilogi] [bit] NOT NULL,
[ParPelDataClientTyposCod] [int] NOT NULL,
[ParPelDataClientCod] [int] NOT NULL,
[ParPelDataDDGroupTyposCod] [int] NOT NULL,
[ParPelDataDDTyposCod] [int] NOT NULL,
[ParPelDataEMailTyposCod] [int] NOT NULL,
[ParPelDataFileTyposCod] [int] NOT NULL,
[ParPelDataHmTyposCod] [int] NOT NULL,
[ParPelDataHmMin] [datetime] NOT NULL,
[ParPelDataHmMax] [datetime] NOT NULL,
[ParPelDataMonadaTyposCod] [int] NOT NULL,
[ParPelDataMonadaMin] [money] NOT NULL,
[ParPelDataMonadaMax] [money] NOT NULL,
[ParPelDataPhoneTyposCod] [int] NOT NULL,
[ParPelDataPhoneTxt] [nvarchar](250) NOT NULL,
[ParPelDataPhotoTyposCod] [int] NOT NULL,
[ParPelDataPosoTyposCod] [int] NOT NULL,
[ParPelDataPosoMin] [money] NOT NULL,
[ParPelDataPosoMax] [money] NOT NULL,
[ParPelDataPromTyposCod] [int] NOT NULL,
[ParPelDataPromCod] [int] NOT NULL,
[ParPelDataServiceTyposCod] [int] NOT NULL,
[ParPelDataServiceCod] [int] NOT NULL,
[ParPelDataTextTyposCod] [int] NOT NULL,
[ParPelDataWWWTyposCod] [int] NOT NULL,
[IdosPartidaDataTyposCod] [int] NOT NULL,
[IdosPartidaDataCheckTyposCod] [int] NOT NULL,
[IdosPartidaDataCheckEpilogi] [bit] NOT NULL,
[IdosPartidaDataClientTyposCod] [int] NOT NULL,
[IdosPartidaDataClientCod] [int] NOT NULL,
[IdosPartidaDataDDGroupTyposCod] [int] NOT NULL,
[IdosPartidaDataDDTyposCod] [int] NOT NULL,
[IdosPartidaDataEMailTyposCod] [int] NOT NULL,
[IdosPartidaDataFileTyposCod] [int] NOT NULL,
[IdosPartidaDataHmTyposCod] [int] NOT NULL,
[IdosPartidaDataHmMin] [datetime] NOT NULL,
[IdosPartidaDataHmMax] [datetime] NOT NULL,
[IdosPartidaDataMonadaTyposCod] [int] NOT NULL,
[IdosPartidaDataMonadaMin] [money] NOT NULL,
[IdosPartidaDataMonadaMax] [money] NOT NULL,
[IdosPartidaDataPhoneTyposCod] [int] NOT NULL,
[IdosPartidaDataPhoneTxt] [nvarchar](250) NOT NULL,
[IdosPartidaDataPhotoTyposCod] [int] NOT NULL,
[IdosPartidaDataPosoTyposCod] [int] NOT NULL,
[IdosPartidaDataPosoMin] [money] NOT NULL,
[IdosPartidaDataPosoMax] [money] NOT NULL,
[IdosPartidaDataPromTyposCod] [int] NOT NULL,
[IdosPartidaDataPromCod] [int] NOT NULL,
[IdosPartidaDataServiceTyposCod] [int] NOT NULL,
[IdosPartidaDataServiceCod] [int] NOT NULL,
[IdosPartidaDataTextTyposCod] [int] NOT NULL,
[IdosPartidaDataWWWTyposCod] [int] NOT NULL,
[ParIdosPartidaDataTyposCod] [int] NOT NULL,
[ParIdosPartidaDataCheckTyposCod] [int] NOT NULL,
[ParIdosPartidaDataCheckEpilogi] [bit] NOT NULL,
[ParIdosPartidaDataClientTyposCod] [int] NOT NULL,
[ParIdosPartidaDataClientCod] [int] NOT NULL,
[ParIdosPartidaDataDDGroupTyposCod] [int] NOT NULL,
[ParIdosPartidaDataDDTyposCod] [int] NOT NULL,
[ParIdosPartidaDataEMailTyposCod] [int] NOT NULL,
[ParIdosPartidaDataFileTyposCod] [int] NOT NULL,
[ParIdosPartidaDataHmTyposCod] [int] NOT NULL,
[ParIdosPartidaDataHmMin] [datetime] NOT NULL,
[ParIdosPartidaDataHmMax] [datetime] NOT NULL,
[ParIdosPartidaDataMonadaTyposCod] [int] NOT NULL,
[ParIdosPartidaDataMonadaMin] [money] NOT NULL,
[ParIdosPartidaDataMonadaMax] [money] NOT NULL,
[ParIdosPartidaDataPhoneTyposCod] [int] NOT NULL,
[ParIdosPartidaDataPhoneTxt] [nvarchar](250) NOT NULL,
[ParIdosPartidaDataPhotoTyposCod] [int] NOT NULL,
[ParIdosPartidaDataPosoTyposCod] [int] NOT NULL,
[ParIdosPartidaDataPosoMin] [money] NOT NULL,
[ParIdosPartidaDataPosoMax] [money] NOT NULL,
[ParIdosPartidaDataPromTyposCod] [int] NOT NULL,
[ParIdosPartidaDataPromCod] [int] NOT NULL,
[ParIdosPartidaDataServiceTyposCod] [int] NOT NULL,
[ParIdosPartidaDataServiceCod] [int] NOT NULL,
[ParIdosPartidaDataTextTyposCod] [int] NOT NULL,
[ParIdosPartidaDataWWWTyposCod] [int] NOT NULL,
CONSTRAINT [PK_WhereV2016] PRIMARY KEY CLUSTERED
(
[CodUserLogin] ASC,
[WhereNumber] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_WhereNumber] DEFAULT ((0)) FOR [WhereNumber]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_DaysBeforeStart] DEFAULT ((-99999)) FOR [DaysBeforeStart]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_DaysBeforeEnd] DEFAULT ((99999)) FOR [DaysBeforeEnd]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_EkdosiHm_APO] DEFAULT ('1/1/1900') FOR [EkdosiHm_APO]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_EkdosiHm_EOS] DEFAULT ('1/1/2999') FOR [EkdosiHm_EOS]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_EkdosiApoMetafora] DEFAULT ('1/1/2016') FOR [EkdosiApoMetafora]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParSiraCod] DEFAULT ((0)) FOR [ParSiraCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParTyposCod] DEFAULT ((0)) FOR [ParTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelCod] DEFAULT ((0)) FOR [PelCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_XristisCod] DEFAULT ((0)) FOR [XristisCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelLogistZoneCod] DEFAULT ((0)) FOR [PelLogistZoneCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosLogarTyposCod] DEFAULT ((0)) FOR [IdosLogarTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosLogarCod] DEFAULT ((0)) FOR [IdosLogarCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PosoLogarTyposCod] DEFAULT ((0)) FOR [PosoLogarTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PosoLogarCod] DEFAULT ((0)) FOR [PosoLogarCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosTyposCod] DEFAULT ((0)) FOR [IdosTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosCod] DEFAULT ((0)) FOR [IdosCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaCod] DEFAULT ((0)) FOR [IdosPartidaCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPosoTyposCod] DEFAULT ((0)) FOR [ParPosoTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPosoPosoMin] DEFAULT ((-99999999)) FOR [ParPosoPosoMin]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPosoPosoMax] DEFAULT ((99999999)) FOR [ParPosoPosoMax]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaApothikiCod] DEFAULT ((0)) FOR [ParIdosPartidaApothikiCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaApothikiTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaApothikiTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaPosoMin] DEFAULT ((-99999999)) FOR [ParIdosPartidaPosoMin]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaPosoMax] DEFAULT ((99999999)) FOR [ParIdosPartidaPosoMax]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaPosotitaMin] DEFAULT ((-99999999)) FOR [ParIdosPartidaPosotitaMin]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaPosotitaMax] DEFAULT ((99999999)) FOR [ParIdosPartidaPosotitaMax]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_FPACod] DEFAULT ((0)) FOR [FPACod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_FPAKathestosCod] DEFAULT ((0)) FOR [FPAKathestosCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelHm_Apo] DEFAULT ('1/1/1900') FOR [PelHm_Apo]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelHm_Eos] DEFAULT ('1/1/2999') FOR [PelHm_Eos]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PosotitaTop] DEFAULT ((0)) FOR [PosotitaTop]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PosoTop] DEFAULT ((0)) FOR [PosoTop]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataTyposCod] DEFAULT ((0)) FOR [PelDataTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataCheckCod] DEFAULT ((0)) FOR [PelDataCheckTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataCheck] DEFAULT ((0)) FOR [PelDataCheckEpilogi]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataClientTyposCod] DEFAULT ((0)) FOR [PelDataClientTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataClient] DEFAULT ((0)) FOR [PelDataClientCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataDDGroupTyposCod] DEFAULT ((0)) FOR [PelDataDDGroupTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataDDTyposCod] DEFAULT ((0)) FOR [PelDataDDTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataEMailTyposCod] DEFAULT ((0)) FOR [PelDataEMailTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataFileTyposCod] DEFAULT ((0)) FOR [PelDataFileTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataHmTyposCod] DEFAULT ((0)) FOR [PelDataHmTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataHmApo] DEFAULT ('1/1/1900') FOR [PelDataHmMin]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataHmEos] DEFAULT ('1/1/2999') FOR [PelDataHmMax]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataMonadaTyposCod] DEFAULT ((0)) FOR [PelDataMonadaTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataMonadaMin] DEFAULT ((0)) FOR [PelDataMonadaMin]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataMonadaMax] DEFAULT ((0)) FOR [PelDataMonadaMax]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataPhoneTyposCod] DEFAULT ((0)) FOR [PelDataPhoneTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataPhoneTxt] DEFAULT ('') FOR [PelDataPhoneTxt]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataPhotoTyposCod] DEFAULT ((0)) FOR [PelDataPhotoTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataPosoTyposCod] DEFAULT ((0)) FOR [PelDataPosoTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataPosoMin] DEFAULT ((0)) FOR [PelDataPosoMin]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataPosoMax] DEFAULT ((0)) FOR [PelDataPosoMax]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataPromTyposCod] DEFAULT ((0)) FOR [PelDataPromTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataProm] DEFAULT ((0)) FOR [PelDataPromCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataServiceTyposCod] DEFAULT ((0)) FOR [PelDataServiceTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataService] DEFAULT ((0)) FOR [PelDataServiceCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataTextTyposCod] DEFAULT ((0)) FOR [PelDataTextTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_PelDataWWWTyposCod] DEFAULT ((0)) FOR [PelDataWWWTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataTyposCod] DEFAULT ((0)) FOR [ParPelDataTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataCheckCod] DEFAULT ((0)) FOR [ParPelDataCheckTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataCheck] DEFAULT ((0)) FOR [ParPelDataCheckEpilogi]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataClientTyposCod] DEFAULT ((0)) FOR [ParPelDataClientTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataClient] DEFAULT ((0)) FOR [ParPelDataClientCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataDDGroupTyposCod] DEFAULT ((0)) FOR [ParPelDataDDGroupTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataDDTyposCod] DEFAULT ((0)) FOR [ParPelDataDDTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataEMailTyposCod] DEFAULT ((0)) FOR [ParPelDataEMailTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataFileTyposCod] DEFAULT ((0)) FOR [ParPelDataFileTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataHmTyposCod] DEFAULT ((0)) FOR [ParPelDataHmTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataHmApo] DEFAULT ('1/1/1900') FOR [ParPelDataHmMin]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataHmEos] DEFAULT ('1/1/2999') FOR [ParPelDataHmMax]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataMonadaTyposCod] DEFAULT ((0)) FOR [ParPelDataMonadaTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataMonadaMin] DEFAULT ((0)) FOR [ParPelDataMonadaMin]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataMonadaMax] DEFAULT ((0)) FOR [ParPelDataMonadaMax]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataPhoneTyposCod] DEFAULT ((0)) FOR [ParPelDataPhoneTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataPhoneTxt] DEFAULT ('') FOR [ParPelDataPhoneTxt]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataPhotoTyposCod] DEFAULT ((0)) FOR [ParPelDataPhotoTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataPosoTyposCod] DEFAULT ((0)) FOR [ParPelDataPosoTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataPosoMin] DEFAULT ((0)) FOR [ParPelDataPosoMin]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataPosoMax] DEFAULT ((0)) FOR [ParPelDataPosoMax]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataPromTyposCod] DEFAULT ((0)) FOR [ParPelDataPromTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataProm] DEFAULT ((0)) FOR [ParPelDataPromCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataServiceTyposCod] DEFAULT ((0)) FOR [ParPelDataServiceTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataService] DEFAULT ((0)) FOR [ParPelDataServiceCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataTextTyposCod] DEFAULT ((0)) FOR [ParPelDataTextTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParPelDataWWWTyposCod] DEFAULT ((0)) FOR [ParPelDataWWWTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataTyposCod] DEFAULT ((0)) FOR [IdosPartidaDataTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataCheckCod] DEFAULT ((0)) FOR [IdosPartidaDataCheckTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataCheck] DEFAULT ((0)) FOR [IdosPartidaDataCheckEpilogi]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataClientTyposCod] DEFAULT ((0)) FOR [IdosPartidaDataClientTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataClient] DEFAULT ((0)) FOR [IdosPartidaDataClientCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataDDGroupTyposCod] DEFAULT ((0)) FOR [IdosPartidaDataDDGroupTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataDDTyposCod] DEFAULT ((0)) FOR [IdosPartidaDataDDTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataEMailTyposCod] DEFAULT ((0)) FOR [IdosPartidaDataEMailTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataFileTyposCod] DEFAULT ((0)) FOR [IdosPartidaDataFileTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataHmTyposCod] DEFAULT ((0)) FOR [IdosPartidaDataHmTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataHmApo] DEFAULT ('1/1/1900') FOR [IdosPartidaDataHmMin]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataHmEos] DEFAULT ('1/1/2999') FOR [IdosPartidaDataHmMax]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataMonadaTyposCod] DEFAULT ((0)) FOR [IdosPartidaDataMonadaTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataMonadaMin] DEFAULT ((0)) FOR [IdosPartidaDataMonadaMin]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataMonadaMax] DEFAULT ((0)) FOR [IdosPartidaDataMonadaMax]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataPhoneTyposCod] DEFAULT ((0)) FOR [IdosPartidaDataPhoneTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataPhoneTxt] DEFAULT ('') FOR [IdosPartidaDataPhoneTxt]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataPhotoTyposCod] DEFAULT ((0)) FOR [IdosPartidaDataPhotoTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataPosoTyposCod] DEFAULT ((0)) FOR [IdosPartidaDataPosoTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataPosoMin] DEFAULT ((0)) FOR [IdosPartidaDataPosoMin]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataPosoMax] DEFAULT ((0)) FOR [IdosPartidaDataPosoMax]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataPromTyposCod] DEFAULT ((0)) FOR [IdosPartidaDataPromTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataProm] DEFAULT ((0)) FOR [IdosPartidaDataPromCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataServiceTyposCod] DEFAULT ((0)) FOR [IdosPartidaDataServiceTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataService] DEFAULT ((0)) FOR [IdosPartidaDataServiceCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataTextTyposCod] DEFAULT ((0)) FOR [IdosPartidaDataTextTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_IdosPartidaDataWWWTyposCod] DEFAULT ((0)) FOR [IdosPartidaDataWWWTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaDataTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataCheckCod] DEFAULT ((0)) FOR [ParIdosPartidaDataCheckTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataCheck] DEFAULT ((0)) FOR [ParIdosPartidaDataCheckEpilogi]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataClientTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaDataClientTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataClient] DEFAULT ((0)) FOR [ParIdosPartidaDataClientCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataDDGroupTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaDataDDGroupTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataDDTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaDataDDTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataEMailTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaDataEMailTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataFileTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaDataFileTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataHmTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaDataHmTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataHmApo] DEFAULT ('1/1/1900') FOR [ParIdosPartidaDataHmMin]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataHmEos] DEFAULT ('1/1/2999') FOR [ParIdosPartidaDataHmMax]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataMonadaTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaDataMonadaTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataMonadaMin] DEFAULT ((0)) FOR [ParIdosPartidaDataMonadaMin]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataMonadaMax] DEFAULT ((0)) FOR [ParIdosPartidaDataMonadaMax]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataPhoneTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaDataPhoneTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataPhoneTxt] DEFAULT ('') FOR [ParIdosPartidaDataPhoneTxt]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataPhotoTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaDataPhotoTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataPosoTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaDataPosoTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataPosoMin] DEFAULT ((0)) FOR [ParIdosPartidaDataPosoMin]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataPosoMax] DEFAULT ((0)) FOR [ParIdosPartidaDataPosoMax]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataPromTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaDataPromTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataProm] DEFAULT ((0)) FOR [ParIdosPartidaDataPromCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataServiceTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaDataServiceTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataService] DEFAULT ((0)) FOR [ParIdosPartidaDataServiceCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataTextTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaDataTextTyposCod]
GO

ALTER TABLE [dbo].[WhereV2016] ADD CONSTRAINT [DF_WhereV2016_ParIdosPartidaDataWWWTyposCod] DEFAULT ((0)) FOR [ParIdosPartidaDataWWWTyposCod]
GO