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