/*
Navicat SQL Server Data Transfer
Source Server : 127.0.0.1
Source Server Version : 105000
Source Host : 127.0.0.1:1433
Source Database : GSD
Source Schema : dbo
Target Server Type : SQL Server
Target Server Version : 105000
File Encoding : 65001
Date: 2017-04-14 22:24:00
*/
-- ----------------------------
-- Table structure for [dbo].[Mobile]
-- ----------------------------
DROP TABLE [dbo].[Mobile]
GO
CREATE TABLE [dbo].[Mobile] (
[ID] int NOT NULL IDENTITY(1,1) ,
[Mobile] nvarchar(50) NULL ,
[Province] nvarchar(50) NULL ,
[City] nvarchar(50) NULL ,
[Corp] nvarchar(50) NULL ,
[AreaCode] nvarchar(50) NULL ,
[PostCode] nvarchar(50) NULL
)
GO
DBCC CHECKIDENT(N'[dbo].[Mobile]', RESEED, 360569)
GO
-- ----------------------------
-- Records of Mobile
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Mobile] ON
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'1', N'1300000', N'山东', N'济南', N'中国联通', N'0531', N'250000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'2', N'1300001', N'江苏', N'常州', N'中国联通', N'0519', N'213000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'3', N'1300002', N'安徽', N'巢湖', N'中国联通', N'0565', N'238000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'4', N'1300003', N'四川', N'宜宾', N'中国联通', N'0831', N'644000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'5', N'1300004', N'四川', N'自贡', N'中国联通', N'0813', N'643000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'6', N'1300005', N'陕西', N'西安', N'中国联通', N'029', N'710000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'7', N'1300006', N'江苏', N'南京', N'中国联通', N'025', N'210000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'8', N'1300007', N'陕西', N'西安', N'中国联通', N'029', N'710000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'9', N'1300008', N'湖北', N'武汉', N'中国联通', N'027', N'430000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'10', N'1300009', N'陕西', N'西安', N'中国联通', N'029', N'710000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'11', N'1300010', N'北京', N'北京', N'中国联通', N'010', N'100000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'12', N'1300011', N'北京', N'北京', N'中国联通', N'010', N'100000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'13', N'1300012', N'天津', N'天津', N'中国联通', N'022', N'300000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'14', N'1300013', N'天津', N'天津', N'中国联通', N'022', N'300000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'15', N'1300014', N'天津', N'天津', N'中国联通', N'022', N'300000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'16', N'1300015', N'山东', N'淄博', N'中国联通', N'0533', N'255000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'17', N'1300016', N'山东', N'烟台', N'中国联通', N'0535', N'264000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'18', N'1300017', N'山东', N'济南', N'中国联通', N'0531', N'250000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'19', N'1300018', N'天津', N'天津', N'中国联通', N'022', N'300000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'20', N'1300019', N'天津', N'天津', N'中国联通', N'022', N'300000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'21', N'1300020', N'上海', N'上海', N'中国联通', N'021', N'200000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'22', N'1300021', N'上海', N'上海', N'中国联通', N'021', N'200000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'23', N'1300022', N'上海', N'上海', N'中国联通', N'021', N'200000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'24', N'1300023', N'上海', N'上海', N'中国联通', N'021', N'200000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'25', N'1300024', N'上海', N'上海', N'中国联通', N'021', N'200000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'26', N'1300025', N'江苏', N'南京', N'中国联通', N'025', N'210000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'27', N'1300026', N'江苏', N'南京', N'中国联通', N'025', N'210000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'28', N'1300027', N'山东', N'烟台', N'中国联通', N'0535', N'264000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'29', N'1300028', N'江苏', N'南京', N'中国联通', N'025', N'210000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'30', N'1300029', N'江苏', N'南京', N'中国联通', N'025', N'210000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'31', N'1300030', N'江苏', N'南京', N'中国联通', N'025', N'210000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'32', N'1300031', N'江苏', N'南京', N'中国联通', N'025', N'210000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'33', N'1300032', N'江苏', N'南京', N'中国联通', N'025', N'210000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'34', N'1300033', N'江苏', N'无锡', N'中国联通', N'0510', N'214000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'35', N'1300034', N'江苏', N'无锡', N'中国联通', N'0510', N'214000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'36', N'1300035', N'江苏', N'无锡', N'中国联通', N'0510', N'214000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'37', N'1300036', N'江苏', N'无锡', N'中国联通', N'0510', N'214000');
GO
INSERT INTO [dbo].[Mobile] ([ID], [Mobile], [Province], [City], [Corp], [AreaCode], [PostCode]) VALUES (N'38', N'1300037', N'江苏', N'无锡', N'中�
