USE [GeoDB]
GO
ALTER TABLE [dbo].[PlaceToService] DROP CONSTRAINT [FK_PlaceToService_Placeservice]
GO
ALTER TABLE [dbo].[PlaceToService] DROP CONSTRAINT [FK_PlaceToService_Place]
GO
ALTER TABLE [dbo].[PlaceToInformation] DROP CONSTRAINT [FK_PlaceToInformation_PlaceInformation]
GO
ALTER TABLE [dbo].[PlaceToInformation] DROP CONSTRAINT [FK_PlaceToInformation_Place]
GO
ALTER TABLE [dbo].[PlaceServiceDomain] DROP CONSTRAINT [FK_PlaceServiceDomain_Placeservice]
GO
ALTER TABLE [dbo].[PlaceServiceDomain] DROP CONSTRAINT [FK_PlaceServiceDomain_Domain]
GO
ALTER TABLE [dbo].[PlaceInformationDomain] DROP CONSTRAINT [FK_PlaceInformationDomain_PlaceInformation]
GO
ALTER TABLE [dbo].[PlaceInformationDomain] DROP CONSTRAINT [FK_PlaceInformationDomain_Domain]
GO
ALTER TABLE [dbo].[PlaceAlias] DROP CONSTRAINT [FK_PlaceAlias_Place]
GO
ALTER TABLE [dbo].[PlaceAlias] DROP CONSTRAINT [FK_PlaceAlias_Alias]
GO
/****** Object:  Table [dbo].[PlaceToService]    Script Date: 13.05.2013 18:08:13 ******/
DROP TABLE [dbo].[PlaceToService]
GO
/****** Object:  Table [dbo].[PlaceToInformation]    Script Date: 13.05.2013 18:08:13 ******/
DROP TABLE [dbo].[PlaceToInformation]
GO
/****** Object:  Table [dbo].[PlaceServiceDomain]    Script Date: 13.05.2013 18:08:13 ******/
DROP TABLE [dbo].[PlaceServiceDomain]
GO
/****** Object:  Table [dbo].[Placeservice]    Script Date: 13.05.2013 18:08:13 ******/
DROP TABLE [dbo].[Placeservice]
GO
/****** Object:  Table [dbo].[PlaceInformationDomain]    Script Date: 13.05.2013 18:08:13 ******/
DROP TABLE [dbo].[PlaceInformationDomain]
GO
/****** Object:  Table [dbo].[PlaceInformation]    Script Date: 13.05.2013 18:08:13 ******/
DROP TABLE [dbo].[PlaceInformation]
GO
/****** Object:  Table [dbo].[PlaceAlias]    Script Date: 13.05.2013 18:08:13 ******/
DROP TABLE [dbo].[PlaceAlias]
GO
/****** Object:  Table [dbo].[Place]    Script Date: 13.05.2013 18:08:13 ******/
DROP TABLE [dbo].[Place]
GO
/****** Object:  Table [dbo].[Domain]    Script Date: 13.05.2013 18:08:13 ******/
DROP TABLE [dbo].[Domain]
GO
/****** Object:  Table [dbo].[Alias]    Script Date: 13.05.2013 18:08:13 ******/
DROP TABLE [dbo].[Alias]
GO
/****** Object:  Table [dbo].[Alias]    Script Date: 13.05.2013 18:08:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Alias](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[alias] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Alias] PRIMARY KEY CLUSTERED 
(
	[id] 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
/****** Object:  Table [dbo].[Domain]    Script Date: 13.05.2013 18:08:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Domain](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[type] [bit] NOT NULL,
	[description] [xml] NULL,
	[writeToken] [nvarchar](max) NOT NULL,
	[readToken] [nvarchar](max) NOT NULL,
 CONSTRAINT [PK_Domain] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Place]    Script Date: 13.05.2013 18:08:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Place](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[plan] [geography] NOT NULL,
	[description] [xml] NULL,
 CONSTRAINT [PK_Place] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[PlaceAlias]    Script Date: 13.05.2013 18:08:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PlaceAlias](
	[pid] [int] NOT NULL,
	[aid] [int] NOT NULL,
 CONSTRAINT [PK_PlaceAlias] PRIMARY KEY CLUSTERED 
(
	[pid] ASC,
	[aid] 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
/****** Object:  Table [dbo].[PlaceInformation]    Script Date: 13.05.2013 18:08:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PlaceInformation](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[value] [xml] NOT NULL,
 CONSTRAINT [PK_PlaceInformation] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[PlaceInformationDomain]    Script Date: 13.05.2013 18:08:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PlaceInformationDomain](
	[iid] [int] NOT NULL,
	[did] [int] NOT NULL,
 CONSTRAINT [PK_PlaceInformationDomain] PRIMARY KEY CLUSTERED 
(
	[iid] ASC,
	[did] 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
/****** Object:  Table [dbo].[Placeservice]    Script Date: 13.05.2013 18:08:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Placeservice](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[description] [xml] NULL,
	[sap] [xml] NOT NULL,
 CONSTRAINT [PK_Placeservice] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[PlaceServiceDomain]    Script Date: 13.05.2013 18:08:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PlaceServiceDomain](
	[sid] [int] NOT NULL,
	[did] [int] NOT NULL,
 CONSTRAINT [PK_PlaceServiceDomain] PRIMARY KEY CLUSTERED 
(
	[sid] ASC,
	[did] 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
/****** Object:  Table [dbo].[PlaceToInformation]    Script Date: 13.05.2013 18:08:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PlaceToInformation](
	[pid] [int] NOT NULL,
	[iid] [int] NOT NULL,
 CONSTRAINT [PK_PlaceToInformation] PRIMARY KEY CLUSTERED 
(
	[pid] ASC,
	[iid] 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
/****** Object:  Table [dbo].[PlaceToService]    Script Date: 13.05.2013 18:08:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PlaceToService](
	[pid] [int] NOT NULL,
	[sid] [int] NOT NULL,
 CONSTRAINT [PK_PlaceToService] PRIMARY KEY CLUSTERED 
(
	[pid] ASC,
	[sid] 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].[PlaceAlias]  WITH CHECK ADD  CONSTRAINT [FK_PlaceAlias_Alias] FOREIGN KEY([aid])
REFERENCES [dbo].[Alias] ([id])
GO
ALTER TABLE [dbo].[PlaceAlias] CHECK CONSTRAINT [FK_PlaceAlias_Alias]
GO
ALTER TABLE [dbo].[PlaceAlias]  WITH CHECK ADD  CONSTRAINT [FK_PlaceAlias_Place] FOREIGN KEY([pid])
REFERENCES [dbo].[Place] ([id])
GO
ALTER TABLE [dbo].[PlaceAlias] CHECK CONSTRAINT [FK_PlaceAlias_Place]
GO
ALTER TABLE [dbo].[PlaceInformationDomain]  WITH CHECK ADD  CONSTRAINT [FK_PlaceInformationDomain_Domain] FOREIGN KEY([did])
REFERENCES [dbo].[Domain] ([id])
GO
ALTER TABLE [dbo].[PlaceInformationDomain] CHECK CONSTRAINT [FK_PlaceInformationDomain_Domain]
GO
ALTER TABLE [dbo].[PlaceInformationDomain]  WITH CHECK ADD  CONSTRAINT [FK_PlaceInformationDomain_PlaceInformation] FOREIGN KEY([iid])
REFERENCES [dbo].[PlaceInformation] ([id])
GO
ALTER TABLE [dbo].[PlaceInformationDomain] CHECK CONSTRAINT [FK_PlaceInformationDomain_PlaceInformation]
GO
ALTER TABLE [dbo].[PlaceServiceDomain]  WITH CHECK ADD  CONSTRAINT [FK_PlaceServiceDomain_Domain] FOREIGN KEY([did])
REFERENCES [dbo].[Domain] ([id])
GO
ALTER TABLE [dbo].[PlaceServiceDomain] CHECK CONSTRAINT [FK_PlaceServiceDomain_Domain]
GO
ALTER TABLE [dbo].[PlaceServiceDomain]  WITH CHECK ADD  CONSTRAINT [FK_PlaceServiceDomain_Placeservice] FOREIGN KEY([sid])
REFERENCES [dbo].[Placeservice] ([id])
GO
ALTER TABLE [dbo].[PlaceServiceDomain] CHECK CONSTRAINT [FK_PlaceServiceDomain_Placeservice]
GO
ALTER TABLE [dbo].[PlaceToInformation]  WITH CHECK ADD  CONSTRAINT [FK_PlaceToInformation_Place] FOREIGN KEY([pid])
REFERENCES [dbo].[Place] ([id])
GO
ALTER TABLE [dbo].[PlaceToInformation] CHECK CONSTRAINT [FK_PlaceToInformation_Place]
GO
ALTER TABLE [dbo].[PlaceToInformation]  WITH CHECK ADD  CONSTRAINT [FK_PlaceToInformation_PlaceInformation] FOREIGN KEY([iid])
REFERENCES [dbo].[PlaceInformation] ([id])
GO
ALTER TABLE [dbo].[PlaceToInformation] CHECK CONSTRAINT [FK_PlaceToInformation_PlaceInformation]
GO
ALTER TABLE [dbo].[PlaceToService]  WITH CHECK ADD  CONSTRAINT [FK_PlaceToService_Place] FOREIGN KEY([pid])
REFERENCES [dbo].[Place] ([id])
GO
ALTER TABLE [dbo].[PlaceToService] CHECK CONSTRAINT [FK_PlaceToService_Place]
GO
ALTER TABLE [dbo].[PlaceToService]  WITH CHECK ADD  CONSTRAINT [FK_PlaceToService_Placeservice] FOREIGN KEY([sid])
REFERENCES [dbo].[Placeservice] ([id])
GO
ALTER TABLE [dbo].[PlaceToService] CHECK CONSTRAINT [FK_PlaceToService_Placeservice]
GO