 	[DateRegistered] [date] NOT NULL,
 	[DateRegisteredEnd] [date] NULL,
 	[ConsentBitmask] [smallint] NULL,
-	CONSTRAINT [PK_Patients] PRIMARY KEY NONCLUSTERED
-		(
-			[SK_PatientID] 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
-SET ANSI_PADDING OFF
-GO
-/****** Object:  Index [SK_PatientID]    Script Date: 06/03/2016 15:51:58 ******/
+ CONSTRAINT [PK_Patients] PRIMARY KEY NONCLUSTERED 
+(
+	[SK_PatientID] 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
+SET ANSI_PADDING OFF
+GO
+/****** Object:  Index [SK_PatientID]    Script Date: 29/03/2016 09:31:29 ******/
 CREATE CLUSTERED INDEX [SK_PatientID] ON [07T].[Patients]
 (
 	[SK_PatientID] ASC
 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
 GO
-/****** Object:  Table [GP].[ClinicalProblem]    Script Date: 06/03/2016 15:51:58 ******/
+/****** Object:  Table [GP].[ClinicalProblem]    Script Date: 29/03/2016 09:31:29 ******/
 SET ANSI_NULLS ON
 GO
 SET QUOTED_IDENTIFIER ON

	[ProblemStatus] [varchar](25) NOT NULL,
	[Significance] [varchar](25) NOT NULL,
	[Episode] [varchar](25) NOT NULL,
	CONSTRAINT [PK_ClinicalProblem] PRIMARY KEY CLUSTERED
		(
			[SK_ProblemID] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [GP].[MedicationIssue]    Script Date: 06/03/2016 15:51:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON

	[LocalAreaTeam] [varchar](100) NULL,
	[CommissioningCounty] [varchar](50) NOT NULL,
	[CommissioningCountry] [varchar](50) NOT NULL,
 CONSTRAINT [PK_Organisation] PRIMARY KEY CLUSTERED 
(
	[SK_ServiceProviderID] 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
