stubbfel/geodb
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
Files
master
geodb/sql/create/createDB-20130513.sql
stubbfel c8ecabeb75 add create.sql
2013-05-13 18:13:01 +02:00

263 lines
19 KiB
Transact-SQL
Raw Permalink Blame History

This file contains invisible Unicode characters
This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
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
Reference in New Issue View Git Blame Copy Permalink