USE [City]
GO
/****** Object: Table [dbo].[H_Province] Script Date: 07/19/2012 13:00:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[H_Province](
[id] [int] NOT NULL,
[code] [nvarchar](6) NOT NULL,
[name] [nvarchar](40) NULL,
CONSTRAINT [PK_province] PRIMARY KEY CLUSTERED
(
[code] 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
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (1, N'110000', N'北京市')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (2, N'120000', N'天津市')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (3, N'130000', N'河北省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (4, N'140000', N'山西省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (5, N'150000', N'内蒙古')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (6, N'210000', N'辽宁省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (7, N'220000', N'吉林省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (8, N'230000', N'黑龙江')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (9, N'310000', N'上海市')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (10, N'320000', N'江苏省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (11, N'330000', N'浙江省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (12, N'340000', N'安徽省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (13, N'350000', N'福建省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (14, N'360000', N'江西省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (15, N'370000', N'山东省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (16, N'410000', N'河南省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (17, N'420000', N'湖北省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (18, N'430000', N'湖南省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (19, N'440000', N'广东省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (20, N'450000', N'广 西')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (21, N'460000', N'海南省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (22, N'500000', N'重庆市')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (23, N'510000', N'四川省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (24, N'520000', N'贵州省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (25, N'530000', N'云南省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (26, N'540000', N'西 藏')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (27, N'610000', N'陕西省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (28, N'620000', N'甘肃省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (29, N'630000', N'青海省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (30, N'640000', N'宁 夏')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (31, N'650000', N'新 疆')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (32, N'710000', N'台湾省')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (33, N'810000', N'香 港')
INSERT [dbo].[H_Province] ([id], [code], [name]) VALUES (34, N'820000', N'澳 门')
/****** Object: Table [dbo].[H_City] Script Date: 07/19/2012 13:00:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[H_City](
[id] [int] NOT NULL,
[code] [nvarchar](6) NOT NULL,
[name] [nvarchar](50) NULL,
[provinceId] [nvarchar](6) NULL,
CONSTRAINT [PK_city] PRIMARY KEY CLUSTERED
(
[code] 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
INSERT [dbo].[H_City] ([id], [code], [name], [provinceId]) VALUES (1, N'110100', N'北京市', N'110000')
INSERT [dbo].[H_City] ([id], [code], [name], [provinceId]) VALUES (2, N'120100', N'天津市', N'120000')
INSERT [dbo].[H_City] ([id], [code], �
评论10
最新资源