下载行政区划mysql表设计_行政区划数据数据库的设计(脚本)

/*************************************************************

Author:   LzmTW(水如烟)

Create date: 20060921

Description: 行政区划数据数据库生成脚本,适用于SQLServer2005

***************************************************************/

USE [master]

GO

/****** 对象:  Database [RegionalCodeWorks]    脚本日期: 09/21/2006 20:38:21 ******/

IF EXISTS (SELECT name FROM sys.databases WHERE name = N'RegionalCodeWorks')

DROP DATABASE RegionalCodeWorks

GO

CREATE DATABASE RegionalCodeWorks

GO

EXEC dbo.sp_dbcmptlevel @dbname=N'RegionalCodeWorks', @new_cmptlevel=90

GO

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))

begin

EXEC [RegionalCodeWorks].[dbo].[sp_fulltext_database] @action = 'disable'

end

GO

ALTER DATABASE [RegionalCodeWorks] SET ANSI_NULL_DEFAULT OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET ANSI_NULLS OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET ANSI_PADDING OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET ANSI_WARNINGS OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET ARITHABORT OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET AUTO_CLOSE OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET AUTO_CREATE_STATISTICS ON

GO

ALTER DATABASE [RegionalCodeWorks] SET AUTO_SHRINK OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET AUTO_UPDATE_STATISTICS ON

GO

ALTER DATABASE [RegionalCodeWorks] SET CURSOR_CLOSE_ON_COMMIT OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET CURSOR_DEFAULT  GLOBAL

GO

ALTER DATABASE [RegionalCodeWorks] SET CONCAT_NULL_YIELDS_NULL OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET NUMERIC_ROUNDABORT OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET QUOTED_IDENTIFIER OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET RECURSIVE_TRIGGERS OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET  ENABLE_BROKER

GO

ALTER DATABASE [RegionalCodeWorks] SET AUTO_UPDATE_STATISTICS_ASYNC OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET DATE_CORRELATION_OPTIMIZATION OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET TRUSTWORTHY OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET ALLOW_SNAPSHOT_ISOLATION OFF

GO

ALTER DATABASE [RegionalCodeWorks] SET PARAMETERIZATION SIMPLE

GO

ALTER DATABASE [RegionalCodeWorks] SET  READ_WRITE

GO

ALTER DATABASE [RegionalCodeWorks] SET RECOVERY SIMPLE

GO

ALTER DATABASE [RegionalCodeWorks] SET  MULTI_USER

GO

ALTER DATABASE [RegionalCodeWorks] SET PAGE_VERIFY CHECKSUM

GO

ALTER DATABASE [RegionalCodeWorks] SET DB_CHAINING OFF

USE [RegionalCodeWorks]

GO

/****** 对象:  Schema [Program]    脚本日期: 09/21/2006 20:38:24 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'Program')

EXEC sys.sp_executesql N'CREATE SCHEMA [Program] AUTHORIZATION [dbo]'

GO

/****** 对象:  Schema [FUNCTION]    脚本日期: 09/21/2006 20:38:24 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'FUNCTION')

EXEC sys.sp_executesql N'CREATE SCHEMA [FUNCTION] AUTHORIZATION [dbo]'

GO

/****** 对象:  Schema [Edit]    脚本日期: 09/21/2006 20:38:24 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'Edit')

EXEC sys.sp_executesql N'CREATE SCHEMA [Edit] AUTHORIZATION [dbo]'

GO

/****** 对象:  Schema [Base]    脚本日期: 09/21/2006 20:38:24 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'Base')

EXEC sys.sp_executesql N'CREATE SCHEMA [Base] AUTHORIZATION [dbo]'

GO

/****** 对象:  Schema [Action]    脚本日期: 09/21/2006 20:38:24 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'Action')

EXEC sys.sp_executesql N'CREATE SCHEMA [Action] AUTHORIZATION [dbo]'

GO

/****** 对象:  Table [Base].[行政区级别]    脚本日期: 09/21/2006 20:38:24 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Base].[行政区级别]') AND type in (N'U'))

BEGIN

CREATE TABLE [Base].[行政区级别](

[级别ID] [smallint] IDENTITY(0,1) NOT NULL,

[级别] [nchar](10) NOT NULL,

CONSTRAINT [PK_行政区级别] PRIMARY KEY CLUSTERED

(

[级别ID] ASC

)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY],

CONSTRAINT [IX_行政区级别] UNIQUE NONCLUSTERED

(

[级别] ASC

)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

END

GO

/****** 对象:  Default [Base].[RegionalDateDefault]    脚本日期: 09/21/2006 20:38:24 ******/

IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Base].[RegionalDateDefault]') AND OBJECTPROPERTY(id, N'IsDefault') = 1)

EXEC dbo.sp_executesql N'/****** 对象:  Default [Salary].[SalaryDateDefault]    脚本日期: 09/17/2006 14:44:13 ******/

--USE EmployeeWorks

CREATE DEFAULT [Base].[RegionalDateDefault] AS N''Current'''

GO

/****** 对象:  Rule [Base].[RegionalCodeRule]    脚本日期: 09/21/2006 20:38:24 ******/

IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Base].[RegionalCodeRule]') AND OBJECTPROPERTY(id, N'IsRule') = 1)

EXEC dbo.sp_executesql N'

CREATE RULE [Base].[RegionalCodeRule]

AS

@value LIKE ''[1-9][0-9][0-9][0-9][0-9][0-9]''

'

GO

/****** 对象:  Table [Base].[行政区类型]    脚本日期: 09/21/2006 20:38:24 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Base].[行政区类型]') AND type in (N'U'))

BEGIN