 
 GO
 
-IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BirthdateSubscription]') AND type in (N'U'))
-
-BEGIN
-
-CREATE TABLE [dbo].[BirthdateSubscription](
+IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DataSubscription]') AND type in (N'U'))
+
+BEGIN
+
+CREATE TABLE [dbo].[DataSubscription](
 
 	[SubscriptionId] [uniqueidentifier] NOT NULL,
 
-	[AgeYears] [int] NULL,
-
-	[PriorDays] [int] NOT NULL,
-
- CONSTRAINT [PK_BirthdateSubscription] PRIMARY KEY CLUSTERED 
+ CONSTRAINT [PK_DataSubscription] PRIMARY KEY CLUSTERED 
 
 (
 


GO

ALTER TABLE [dbo].[BirthdateSubscription] CHECK CONSTRAINT [FK_BirthdateSubscription_Subscription]

GO

/****** Object:  ForeignKey [FK_DataSubscription_Subscription]    Script Date: 02/13/2011 17:59:04 ******/

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_DataSubscription_Subscription]') AND parent_object_id = OBJECT_ID(N'[dbo].[DataSubscription]'))

ALTER TABLE [dbo].[DataSubscription]  WITH CHECK ADD  CONSTRAINT [FK_DataSubscription_Subscription] FOREIGN KEY([SubscriptionId])

REFERENCES [dbo].[Subscription] ([SubscriptionId])



GO

/****** Object:  Default [DF_EventNotification_EventNotificationId]    Script Date: 02/13/2011 17:59:04 ******/

IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_EventNotification_EventNotificationId]') AND parent_object_id = OBJECT_ID(N'[dbo].[EventNotification]'))
