2013年新统计全国省市县以及邮政编码SQL数据脚本
USE [imei8com]GO/****** Object: Table [dbo].[Zone] Script Date: 03/12/2014 15:05:41 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[Zone]([ZoneId] [int] IDENTITY(1,1) NOT NULL,[ZoneName] [nvarchar](max) NULL,[ZoneDescription] [nvarchar](max) NULL,[IsDel] [int] NULL, CONSTRAINT [PK__Zone__0425A276] PRIMARY KEY CLUSTERED ([ZoneId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET IDENTITY_INSERT [dbo].[Zone] ONINSERT [dbo].[Zone] ([ZoneId], [ZoneName], [ZoneDescription], [IsDel]) VALUES (1, N'华北地区', N'北京市、天津市、河北省、山西省、内蒙古自治区', NULL)INSERT [dbo].[Zone] ([ZoneId], [ZoneName], [ZoneDescription], [IsDel]) VALUES (2, N'东北地区', N'辽宁省、吉林省、黑龙江省', NULL)INSERT [dbo].[Zone] ([ZoneId], [ZoneName], [ZoneDescription], [IsDel]) VALUES (3, N'华东地区', N'上海市、江苏省、浙江省、安徽省、福建省、江西省、山东省', NULL)INSERT [dbo].[Zone] ([ZoneId], [ZoneName], [ZoneDescription], [IsDel]) VALUES (4, N'中南地区', N'河南省、湖北省、湖南省、广东省、海南省、广西壮族自治区', NULL)INSERT [dbo].[Zone] ([ZoneId], [ZoneName], [ZoneDescription], [IsDel]) VALUES (5, N'西南地区', N'重庆市、四川省、贵州省、云南省、*自治区', NULL)INSERT [dbo].[Zone] ([ZoneId], [ZoneName], [ZoneDescription], [IsDel]) VALUES (6, N'西北地区', N'陕西省、甘肃省、青海省、宁夏回族自治区、**自治区', NULL)INSERT [dbo].[Zone] ([ZoneId], [ZoneName], [ZoneDescription], [IsDel]) VALUES (7, N'东南地区', N'江、浙、沪、福建、*', NULL)INSERT [dbo].[Zone] ([ZoneId], [ZoneName], [ZoneDescription], [IsDel]) VALUES (8, N'其他', N'香港,澳门', NULL)SET IDENTITY_INSERT [dbo].[Zone] OFF/****** Object: Table [dbo].[ProvinceModel] Script Date: 03/12/2014 15:05:41 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[ProvinceModel]([ProvinceId] [bigint] IDENTITY(1,1) NOT NULL,[ProvinceName] [nvarchar](50) NULL,[ZoneId] [int] NULL,[IsDel] [int] NULL, CONSTRAINT [PK_ProvinceModel] PRIMARY KEY CLUSTERED ([ProvinceId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET IDENTITY_INSERT [dbo].[ProvinceModel] ONINSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (1, N'北京市', 1, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (2, N'天津市', 1, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (3, N'河北省', 1, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (4, N'山西省', 1, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (5, N'内蒙古自治区', 1, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (6, N'辽宁省', 2, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (7, N'吉林省', 2, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (8, N'黑龙江省', 2, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (9, N'上海市', 7, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (10, N'江苏省', 7, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (11, N'浙江省', 7, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (12, N'安徽省', 3, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (13, N'福建省', 7, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (14, N'江西省', 3, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (15, N'山东省', 3, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (16, N'河南省', 4, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (17, N'湖北省', 4, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (18, N'湖南省', 4, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (19, N'广东省', 4, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (20, N'广西壮族自治区', 4, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (21, N'海南省', 4, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (22, N'重庆市', 5, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (23, N'四川省', 5, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (24, N'贵州省', 5, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (25, N'云南省', 5, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (26, N'*自治区', 5, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (27, N'陕西省', 6, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (28, N'甘肃省', 6, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (29, N'青海省', 6, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (30, N'宁夏回族自治区', 6, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (31, N'**自治区', 6, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (32, N'香港特别行政区', 8, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (33, N'澳门特别行政区', 8, NULL)INSERT [dbo].[ProvinceModel] ([ProvinceId], [ProvinceName], [ZoneId], [IsDel]) VALUES (34, N'*省', 7, NULL)SET IDENTITY_INSERT [dbo].[ProvinceModel] OFF/****** Object: Table [dbo].[DistrictModel] Script Date: 03/12/2014 15:05:41 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[DistrictModel]([DistrictModelId] [bigint] IDENTITY(1,1) NOT NULL,[DistrictName] [nvarchar](50) NULL,[CityID] [bigint] NULL,[IsDel] [int] NULL, CONSTRAINT [PK_DistrictModel] PRIMARY KEY CLUSTERED ([DistrictModelId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET IDENTITY_INSERT [dbo].[DistrictModel] ONINSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALUES (1, N'东城区', 1, NULL)INSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALUES (2, N'西城区', 1, NULL)INSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALUES (5, N'朝阳区', 1, NULL)INSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALUES (6, N'丰台区', 1, NULL)INSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALUES (7, N'石景山区', 1, NULL)INSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALUES (8, N'海淀区', 1, NULL)INSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALUES (9, N'门头沟区', 1, NULL)INSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALUES (10, N'房山区', 1, NULL)INSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALUES (11, N'通州区', 1, NULL)INSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALUES (12, N'顺义区', 1, NULL)INSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALUES (13, N'昌平区', 1, NULL)INSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALUES (14, N'大兴区', 1, NULL)INSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALUES (15, N'怀柔区', 1, NULL)INSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALUES (16, N'平谷区', 1, NULL)INSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALUES (17, N'密云县', 1, NULL)INSERT [dbo].[DistrictModel] ([DistrictModelId], [DistrictName], [CityID], [IsDel]) VALU
