GO
CREATE TABLE [dbo].[ZL_User](
[UserID] [int] IDENTITY(1,1) NOT NULL,
[UserName] [nvarchar](255) NOT NULL,
[UserPwd] [nvarchar](200) NOT NULL,
[PayPassWord] [nvarchar](200) NULL,
[GroupID] [int] NOT NULL,
[Email] [nvarchar](50) NOT NULL,
[Question] [nvarchar](255) NOT NULL,
[Answer] [nvarchar](255) NOT NULL,
[RegTime] [datetime] NULL,
[LoginTimes] [int] NULL,
[LastLoginTime] [datetime] NULL,
[LastLoginIP] [nvarchar](50) NULL,
[LastPwdChangeTime] [datetime] NULL,
[LastLockTime] [datetime] NULL,
[Status] [int] NULL,
[CheckNum] [nvarchar](50) NULL,
[Purse] [money] NULL,
[SilverCoin] [money] NULL,
[UserExp] [money] NULL,
[UserPoint] [money] NULL,
[DummyPurse] [money] NULL,
[boffExp] [int] NULL,
[ConsumeExp] [int] NULL,
[GuestScore] [int] NULL,
[DeadLine] [datetime] NULL,
[JoinTime] [datetime] NULL,
[Permissions] [ntext] NULL,
[SiteID] [int] NULL,
[Remark] [ntext] NULL,
[CompanyName] [nvarchar](255) NULL,
[CompanyDescribe] [nvarchar](500) NULL,
[NHouseID] [int] NULL,
[IsConfirm] [int] NULL,
[VIP] [int] NULL,
[salt] [nvarchar](500) NULL,
[State] [varchar](50) NULL,
[CerificateLogo] [nvarchar](100) NULL,
[ApproveType] [varchar](50) NULL,
[RegisterIP] [varchar](50) NULL,
[CerificateDeadLine] [datetime] NULL,
[RebatesBalance] [money] NULL,
[PageId] [int] NULL,
[SiteRebateBalance] [money] NULL,
[UserCreit] [int] NULL,
[UpdateTime] [datetime] NULL,
[RoomID] [int] NULL,
[ParentUserID] [varchar](4000) NULL,
[IsAdd2K3] [int] NULL,
[IsCloud] [int] NULL,
[seturl] [ntext] NULL,
[StructureID] [nvarchar](255) NULL,
[UserRole] [nvarchar](255) NULL,
[WorkNum] [nvarchar](255) NULL,
[MailSize] [int] NULL,
[LastActiveTime] [datetime] NULL,
[ZnPassword] [nvarchar](100) NULL,
[HoneyName] [nvarchar](100) NULL,
[RegUrl] [nvarchar](4000) NULL,
CONSTRAINT [PK_ZL_User] PRIMARY KEY NONCLUSTERED
([UserID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'UserID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'UserName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'UserPwd'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员组' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'GroupID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Email' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'Email'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员提示问题' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'Question'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员提示问题答案' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'Answer'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'注册时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'RegTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录次数' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'LoginTimes'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近登录时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'LastLoginTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后登录IP' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'LastLoginIP'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上次修改密码的时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'LastPwdChangeTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上次被锁定的时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'LastLockTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户状态。0－－正常，1－－锁定，2－－未通过邮件验证，4－－未通过管理员认证' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'Status'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'验证码。用于邮件验证' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'CheckNum'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员积分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'UserExp'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'卖家积分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'boffExp'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'消费积分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'ConsumeExp'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'钱包' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'Purse'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效期截止时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'DeadLine'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'点券' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'UserPoint'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'加入会员组时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'JoinTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'抢车位虚拟币' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'DummyPurse'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'权限。当该字段为空，使用GroupID的用户组ID。' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'Permissions'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'子站ID' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'SiteID'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'Remark'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'证书认证状态(-----[未认证] -----[证书审核中]-----[认证通过])' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'State'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'证书地址' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'CerificateLogo'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'认证类型(国际认证，三包认证.)' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'ApproveType'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'商铺认证有效期截止时间' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'CerificateDeadLine'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'黄页ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_User', @level2type=N'COLUMN',@level2name=N'PageId'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'返利余额' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_User', @level2type=N'COLUMN', @level2name=N'RebatesBalance'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'分站返利金额' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_User', @level2type=N'COLUMN',@level2name=N'SiteRebateBalance'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'用户信誉值' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_User', @level2type=N'COLUMN',@level2name=N'UserCreit'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'打卡时间,修改时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_User', @level2type=N'COLUMN',@level2name=N'UpdateTime'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'组织结构ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_User', @level2type=N'COLUMN',@level2name=N'StructureID'

SET IDENTITY_INSERT [ZL_User] ON
INSERT [ZL_User] ([UserID],[UserName],[UserPwd],[GroupID],[Email],[Question],[Answer],[RegTime],[LoginTimes],[LastLoginTime],[LastLoginIP],[LastPwdChangeTime],[LastLockTime],[Status],[CheckNum],[Purse],[SilverCoin],[UserExp],[UserPoint],[DummyPurse],[boffExp],[ConsumeExp],[GuestScore],[DeadLine],[JoinTime],[SiteID],[IsConfirm],[VIP],[salt],[State],[CerificateDeadLine],[PageId],[SiteRebateBalance],[UserCreit],[RoomID],[IsCloud],[UserRole],[MailSize],[LastActiveTime],[HoneyName],[RegUrl]) VALUES ( 1,N'admin',N'7fef6171469e80d32c0559f88b377245',1,N'web@z01.com',N'admin',N's3Ewld5Z',N'2017/4/10 16:29:48',5,N'2017/4/11 13:58:22',N'::1',N'2017/4/10 16:29:48',N'2017/4/10 16:29:48',0,N'wmDeVz',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,N'2017/4/10 16:29:48',N'2017/4/10 16:29:48',1,0,0,N'/Images/userface/noface.png',N'0',N'2017/4/10 16:29:48',0,0.0000,0,1,0,N',1,',0,N'2017/4/11 14:18:22',N'admin',N'/Install/Default.aspx')
INSERT [ZL_User] ([UserID],[UserName],[UserPwd],[GroupID],[Email],[Question],[Answer],[RegTime],[LoginTimes],[LastLoginTime],[LastLoginIP],[LastPwdChangeTime],[LastLockTime],[Status],[CheckNum],[Purse],[SilverCoin],[UserExp],[UserPoint],[DummyPurse],[boffExp],[ConsumeExp],[GuestScore],[DeadLine],[JoinTime],[SiteID],[IsConfirm],[VIP],[salt],[State],[CerificateDeadLine],[PageId],[SiteRebateBalance],[UserCreit],[RoomID],[IsCloud],[MailSize],[LastActiveTime],[HoneyName],[RegUrl]) VALUES ( 2,N'demo',N'e10adc3949ba59abbe56e057f20f883e',1,N'7tBWqKKB@random.com',N'USDY1J02Dx',N'n610Mv',N'2017/4/10 17:29:47',0,N'2017/4/10 17:29:47',N'::1',N'2017/4/10 17:29:47',N'2017/4/10 17:29:47',0,N'70lds2m0hb',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,N'2017/4/10 17:29:47',N'2017/4/10 17:29:47',0,0,0,N'/Images/userface/noface.png',N'0',N'2017/4/10 17:29:47',0,0.0000,0,1,0,0,N'2017/4/10 17:29:47',N'demo',N'/Admin/User/AddUser.aspx')
INSERT [ZL_User] ([UserID],[UserName],[UserPwd],[GroupID],[Email],[Question],[Answer],[RegTime],[LoginTimes],[LastLoginTime],[LastLoginIP],[LastPwdChangeTime],[LastLockTime],[Status],[CheckNum],[Purse],[SilverCoin],[UserExp],[UserPoint],[DummyPurse],[boffExp],[ConsumeExp],[GuestScore],[DeadLine],[JoinTime],[SiteID],[IsConfirm],[VIP],[salt],[State],[CerificateDeadLine],[PageId],[SiteRebateBalance],[UserCreit],[RoomID],[IsCloud],[MailSize],[LastActiveTime],[HoneyName],[RegUrl]) VALUES ( 3,N'金狮蓝蒂',N'e10adc3949ba59abbe56e057f20f883e',1,N'wM57coF0@random.com',N'3ii6DObAZu',N'nXKx1t',N'2017/4/10 17:30:28',0,N'2017/4/10 17:30:28',N'::1',N'2017/4/10 17:30:28',N'2017/4/10 17:30:28',0,N'2rfeqxq71u',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,N'2017/4/10 17:30:28',N'2017/4/10 17:30:28',0,0,0,N'/Images/userface/noface.png',N'0',N'2017/4/10 17:30:28',0,0.0000,0,1,0,0,N'2017/4/10 18:29:55',N'金狮蓝蒂',N'/Admin/User/AddUser.aspx')
INSERT [ZL_User] ([UserID],[UserName],[UserPwd],[GroupID],[Email],[Question],[Answer],[RegTime],[LoginTimes],[LastLoginTime],[LastLoginIP],[LastPwdChangeTime],[LastLockTime],[Status],[CheckNum],[Purse],[SilverCoin],[UserExp],[UserPoint],[DummyPurse],[boffExp],[ConsumeExp],[GuestScore],[DeadLine],[JoinTime],[SiteID],[IsConfirm],[VIP],[salt],[State],[CerificateDeadLine],[PageId],[SiteRebateBalance],[UserCreit],[RoomID],[IsCloud],[MailSize],[LastActiveTime],[HoneyName],[RegUrl]) VALUES ( 4,N'炭香园自助烧烤',N'e10adc3949ba59abbe56e057f20f883e',1,N'qHjaPycw@random.com',N'PXEyeiWNE4',N'kZwDSQ',N'2017/4/10 17:35:01',0,N'2017/4/10 17:35:01',N'::1',N'2017/4/10 17:35:01',N'2017/4/10 17:35:01',0,N'pf1qi89k1d',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,N'2017/4/10 17:35:01',N'2017/4/10 17:35:01',0,0,0,N'/Images/userface/noface.png',N'0',N'2017/4/10 17:35:01',0,0.0000,0,1,0,0,N'2017/4/10 17:35:01',N'炭香园自助烧烤',N'/Admin/User/AddUser.aspx')
INSERT [ZL_User] ([UserID],[UserName],[UserPwd],[GroupID],[Email],[Question],[Answer],[RegTime],[LoginTimes],[LastLoginTime],[LastLoginIP],[LastPwdChangeTime],[LastLockTime],[Status],[CheckNum],[Purse],[SilverCoin],[UserExp],[UserPoint],[DummyPurse],[boffExp],[ConsumeExp],[GuestScore],[DeadLine],[JoinTime],[SiteID],[IsConfirm],[VIP],[salt],[State],[CerificateDeadLine],[PageId],[SiteRebateBalance],[UserCreit],[RoomID],[ParentUserID],[IsCloud],[MailSize],[LastActiveTime],[HoneyName],[RegUrl]) VALUES ( 5,N'爱上木数码',N'e10adc3949ba59abbe56e057f20f883e',1,N'MpqqdGJk@random.com',N'Uow2FyGvlo',N'EQta4S',N'2017/4/10 18:36:31',0,N'2017/4/10 18:36:31',N'::1',N'2017/4/10 18:36:31',N'2017/4/10 18:36:31',0,N'lcougskrce',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,N'2017/4/10 18:36:31',N'2017/4/10 18:36:31',0,0,0,N'/UploadFiles/Images/SingleF/20170410183721r9ke.jpg',N'0',N'2017/4/10 18:36:31',0,0.0000,0,1,N'0',0,0,N'2017/4/11 11:29:04',N'爱上木数码',N'/Admin/User/AddUser.aspx')
INSERT [ZL_User] ([UserID],[UserName],[UserPwd],[GroupID],[Email],[Question],[Answer],[RegTime],[LoginTimes],[LastLoginTime],[LastLoginIP],[LastPwdChangeTime],[LastLockTime],[Status],[CheckNum],[Purse],[SilverCoin],[UserExp],[UserPoint],[DummyPurse],[boffExp],[ConsumeExp],[GuestScore],[DeadLine],[JoinTime],[SiteID],[IsConfirm],[VIP],[salt],[State],[CerificateDeadLine],[PageId],[SiteRebateBalance],[UserCreit],[RoomID],[ParentUserID],[IsCloud],[MailSize],[LastActiveTime],[HoneyName],[RegUrl]) VALUES ( 6,N'达芙妮鞋店',N'e10adc3949ba59abbe56e057f20f883e',1,N'4wLzC6VQ@random.com',N'8RWudhrhEC',N'1SgTB5',N'2017/4/10 18:38:14',0,N'2017/4/10 18:38:14',N'::1',N'2017/4/10 18:38:14',N'2017/4/10 18:38:14',0,N'p5t5xhezmv',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,N'2017/4/10 18:38:14',N'2017/4/10 18:38:14',0,0,0,N'/UploadFiles/Images/SingleF/201704101838227qRW.jpg',N'0',N'2017/4/10 18:38:14',0,0.0000,0,1,N'0',0,0,N'2017/4/10 18:38:14',N'达芙妮鞋店',N'/Admin/User/AddUser.aspx')
INSERT [ZL_User] ([UserID],[UserName],[UserPwd],[GroupID],[Email],[Question],[Answer],[RegTime],[LoginTimes],[LastLoginTime],[LastLoginIP],[LastPwdChangeTime],[LastLockTime],[Status],[CheckNum],[Purse],[SilverCoin],[UserExp],[UserPoint],[DummyPurse],[boffExp],[ConsumeExp],[GuestScore],[DeadLine],[JoinTime],[SiteID],[IsConfirm],[VIP],[salt],[State],[CerificateDeadLine],[PageId],[SiteRebateBalance],[UserCreit],[RoomID],[ParentUserID],[IsCloud],[MailSize],[LastActiveTime],[HoneyName],[RegUrl]) VALUES ( 7,N'梵蒂冈超市',N'e10adc3949ba59abbe56e057f20f883e',1,N'cakPXKUS@random.com',N'Mi7cfqnT6z',N'ygQqGp',N'2017/4/10 18:38:47',0,N'2017/4/10 18:38:47',N'::1',N'2017/4/10 18:38:47',N'2017/4/10 18:38:47',0,N'9qg2dg7tk6',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,N'2017/4/10 18:38:47',N'2017/4/10 18:38:47',0,0,0,N'/UploadFiles/Images/SingleF/20170410183855uWtz.jpg',N'0',N'2017/4/10 18:38:47',0,0.0000,0,1,N'0',0,0,N'2017/4/10 18:38:47',N'梵蒂冈超市',N'/Admin/User/AddUser.aspx')
INSERT [ZL_User] ([UserID],[UserName],[UserPwd],[GroupID],[Email],[Question],[Answer],[RegTime],[LoginTimes],[LastLoginTime],[LastLoginIP],[LastPwdChangeTime],[LastLockTime],[Status],[CheckNum],[Purse],[SilverCoin],[UserExp],[UserPoint],[DummyPurse],[boffExp],[ConsumeExp],[GuestScore],[DeadLine],[JoinTime],[SiteID],[IsConfirm],[VIP],[salt],[State],[CerificateDeadLine],[PageId],[SiteRebateBalance],[UserCreit],[RoomID],[ParentUserID],[IsCloud],[MailSize],[LastActiveTime],[HoneyName],[RegUrl]) VALUES ( 8,N'瑞士军刀',N'e10adc3949ba59abbe56e057f20f883e',1,N'bvktj8sj@random.com',N'cID7frw378',N'G8v3TT',N'2017/4/10 18:39:14',0,N'2017/4/10 18:39:14',N'::1',N'2017/4/10 18:39:14',N'2017/4/10 18:39:14',0,N'ibmarrog33',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,N'2017/4/10 18:39:14',N'2017/4/10 18:39:14',0,0,0,N'/UploadFiles/Images/SingleF/201704101839368KrP.jpg',N'0',N'2017/4/10 18:39:14',0,0.0000,0,1,N'0',0,0,N'2017/4/10 18:39:14',N'瑞士军刀',N'/Admin/User/AddUser.aspx')
INSERT [ZL_User] ([UserID],[UserName],[UserPwd],[GroupID],[Email],[Question],[Answer],[RegTime],[LoginTimes],[LastLoginTime],[LastLoginIP],[LastPwdChangeTime],[LastLockTime],[Status],[CheckNum],[Purse],[SilverCoin],[UserExp],[UserPoint],[DummyPurse],[boffExp],[ConsumeExp],[GuestScore],[DeadLine],[JoinTime],[SiteID],[IsConfirm],[VIP],[salt],[State],[CerificateDeadLine],[PageId],[SiteRebateBalance],[UserCreit],[RoomID],[ParentUserID],[IsCloud],[MailSize],[LastActiveTime],[HoneyName],[RegUrl]) VALUES ( 9,N'百斯盾',N'e10adc3949ba59abbe56e057f20f883e',1,N'ZDKFUQ4O@random.com',N'blkOPHupqk',N'R2IUJB',N'2017/4/10 18:39:57',3,N'2017/4/11 15:48:22',N'::1',N'2017/4/10 18:39:57',N'2017/4/10 18:39:57',0,N'g3ubkp6bae',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,N'2017/4/10 18:39:57',N'2017/4/10 18:39:57',0,0,0,N'/UploadFiles/Images/SingleF/20170410184016b6hd.jpg',N'0',N'2017/4/10 18:39:57',0,0.0000,0,1,N'0',0,0,N'2017/4/11 18:09:52',N'百斯盾',N'/Admin/User/AddUser.aspx')
INSERT [ZL_User] ([UserID],[UserName],[UserPwd],[GroupID],[Email],[Question],[Answer],[RegTime],[LoginTimes],[LastLoginTime],[LastLoginIP],[LastPwdChangeTime],[LastLockTime],[Status],[CheckNum],[Purse],[SilverCoin],[UserExp],[UserPoint],[DummyPurse],[boffExp],[ConsumeExp],[GuestScore],[DeadLine],[JoinTime],[SiteID],[IsConfirm],[VIP],[salt],[State],[CerificateDeadLine],[PageId],[SiteRebateBalance],[UserCreit],[RoomID],[ParentUserID],[IsCloud],[MailSize],[LastActiveTime],[HoneyName],[RegUrl]) VALUES ( 10,N'艾玛',N'e10adc3949ba59abbe56e057f20f883e',1,N'4oF7FxG7@random.com',N'i32DvJxBHc',N'gTZRTa',N'2017/4/10 18:44:31',0,N'2017/4/10 18:44:31',N'::1',N'2017/4/10 18:44:31',N'2017/4/10 18:44:31',0,N'jkeqvsrfij',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,N'2017/4/10 18:44:31',N'2017/4/10 18:44:31',0,0,0,N'/UploadFiles/Images/SingleF/20170410184441VHsL.jpg',N'0',N'2017/4/10 18:44:31',0,0.0000,0,1,N'0',0,0,N'2017/4/10 18:44:31',N'艾玛',N'/Admin/User/AddUser.aspx')
INSERT [ZL_User] ([UserID],[UserName],[UserPwd],[GroupID],[Email],[Question],[Answer],[RegTime],[LoginTimes],[LastLoginTime],[LastLoginIP],[LastPwdChangeTime],[LastLockTime],[Status],[CheckNum],[Purse],[SilverCoin],[UserExp],[UserPoint],[DummyPurse],[boffExp],[ConsumeExp],[GuestScore],[DeadLine],[JoinTime],[SiteID],[IsConfirm],[VIP],[salt],[State],[CerificateDeadLine],[PageId],[SiteRebateBalance],[UserCreit],[RoomID],[ParentUserID],[IsCloud],[MailSize],[LastActiveTime],[HoneyName],[RegUrl]) VALUES ( 11,N'键昌家园',N'e10adc3949ba59abbe56e057f20f883e',1,N'Mjb2XgpH@random.com',N'XyQsJrsea2',N'oli1oc',N'2017/4/10 18:45:14',0,N'2017/4/10 18:45:14',N'::1',N'2017/4/10 18:45:14',N'2017/4/10 18:45:14',0,N'bcx37q34md',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,N'2017/4/10 18:45:14',N'2017/4/10 18:45:14',0,0,0,N'/UploadFiles/Images/SingleF/20170410184524H7uz.jpg',N'0',N'2017/4/10 18:45:14',0,0.0000,0,1,N'0',0,0,N'2017/4/10 18:45:14',N'键昌家园',N'/Admin/User/AddUser.aspx')
INSERT [ZL_User] ([UserID],[UserName],[UserPwd],[GroupID],[Email],[Question],[Answer],[RegTime],[LoginTimes],[LastLoginTime],[LastLoginIP],[LastPwdChangeTime],[LastLockTime],[Status],[CheckNum],[Purse],[SilverCoin],[UserExp],[UserPoint],[DummyPurse],[boffExp],[ConsumeExp],[GuestScore],[DeadLine],[JoinTime],[SiteID],[IsConfirm],[VIP],[salt],[State],[CerificateDeadLine],[PageId],[SiteRebateBalance],[UserCreit],[RoomID],[ParentUserID],[IsCloud],[MailSize],[LastActiveTime],[HoneyName],[RegUrl]) VALUES ( 12,N'沃尔玛',N'e10adc3949ba59abbe56e057f20f883e',1,N'HBGzrVM3@random.com',N'NP3tW4kVFa',N'XFdiAR',N'2017/4/10 18:45:56',0,N'2017/4/10 18:45:56',N'::1',N'2017/4/10 18:45:56',N'2017/4/10 18:45:56',0,N'goq554n134',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,N'2017/4/10 18:45:56',N'2017/4/10 18:45:56',0,0,0,N'/UploadFiles/Images/SingleF/20170410184609eGiB.jpg',N'0',N'2017/4/10 18:45:56',0,0.0000,0,1,N'0',0,0,N'2017/4/10 18:45:56',N'沃尔玛',N'/Admin/User/AddUser.aspx')
INSERT [ZL_User] ([UserID],[UserName],[UserPwd],[GroupID],[Email],[Question],[Answer],[RegTime],[LoginTimes],[LastLoginTime],[LastLoginIP],[LastPwdChangeTime],[LastLockTime],[Status],[CheckNum],[Purse],[SilverCoin],[UserExp],[UserPoint],[DummyPurse],[boffExp],[ConsumeExp],[GuestScore],[DeadLine],[JoinTime],[SiteID],[IsConfirm],[VIP],[salt],[State],[CerificateDeadLine],[PageId],[SiteRebateBalance],[UserCreit],[RoomID],[ParentUserID],[IsCloud],[MailSize],[LastActiveTime],[HoneyName],[RegUrl]) VALUES ( 13,N'夏威夷果农',N'e10adc3949ba59abbe56e057f20f883e',1,N'tUoKwpih@random.com',N'HVCLLwlu0y',N'KEtgbD',N'2017/4/10 18:46:30',0,N'2017/4/10 18:46:30',N'::1',N'2017/4/10 18:46:30',N'2017/4/10 18:46:30',0,N'32xlq7oa86',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,N'2017/4/10 18:46:30',N'2017/4/10 18:46:30',0,0,0,N'/UploadFiles/Images/SingleF/20170410184647C46j.jpg',N'0',N'2017/4/10 18:46:30',0,0.0000,0,1,N'0',0,0,N'2017/4/10 18:46:30',N'夏威夷果农',N'/Admin/User/AddUser.aspx')
INSERT [ZL_User] ([UserID],[UserName],[UserPwd],[GroupID],[Email],[Question],[Answer],[RegTime],[LoginTimes],[LastLoginTime],[LastLoginIP],[LastPwdChangeTime],[LastLockTime],[Status],[CheckNum],[Purse],[SilverCoin],[UserExp],[UserPoint],[DummyPurse],[boffExp],[ConsumeExp],[GuestScore],[DeadLine],[JoinTime],[SiteID],[IsConfirm],[VIP],[salt],[State],[CerificateDeadLine],[PageId],[SiteRebateBalance],[UserCreit],[RoomID],[ParentUserID],[IsCloud],[MailSize],[LastActiveTime],[HoneyName],[RegUrl]) VALUES ( 14,N'旧金山海归',N'e10adc3949ba59abbe56e057f20f883e',1,N'C6Vj1QLt@random.com',N'9C5GGLAESp',N'U9NTws',N'2017/4/10 18:47:07',1,N'2017/4/11 11:45:33',N'::1',N'2017/4/10 18:47:07',N'2017/4/10 18:47:07',0,N'68ndxexnpu',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,N'2017/4/10 18:47:07',N'2017/4/10 18:47:07',0,0,0,N'/UploadFiles/Images/SingleF/20170410184718WltP.jpg',N'0',N'2017/4/10 18:47:07',0,0.0000,0,1,N'0',0,0,N'2017/4/11 11:59:04',N'旧金山海归',N'/Admin/User/AddUser.aspx')
INSERT [ZL_User] ([UserID],[UserName],[UserPwd],[GroupID],[Email],[Question],[Answer],[RegTime],[LoginTimes],[LastLoginTime],[LastLoginIP],[LastPwdChangeTime],[LastLockTime],[Status],[CheckNum],[Purse],[SilverCoin],[UserExp],[UserPoint],[DummyPurse],[boffExp],[ConsumeExp],[GuestScore],[DeadLine],[JoinTime],[SiteID],[IsConfirm],[VIP],[salt],[State],[CerificateDeadLine],[PageId],[SiteRebateBalance],[UserCreit],[RoomID],[ParentUserID],[IsCloud],[MailSize],[LastActiveTime],[HoneyName],[RegUrl]) VALUES ( 15,N'农家乐',N'e10adc3949ba59abbe56e057f20f883e',1,N'dtiyhFea@random.com',N'0aSC293Jgq',N'OjG7o7',N'2017/4/10 18:47:42',0,N'2017/4/10 18:47:42',N'::1',N'2017/4/10 18:47:42',N'2017/4/10 18:47:42',0,N'zmsynchp8f',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,N'2017/4/10 18:47:42',N'2017/4/10 18:47:42',0,0,0,N'/UploadFiles/Images/SingleF/20170410184752m9E4.jpg',N'0',N'2017/4/10 18:47:42',0,0.0000,0,1,N'0',0,0,N'2017/4/10 18:37:52',N'农家乐',N'/Admin/User/AddUser.aspx')
SET IDENTITY_INSERT [ZL_User] OFF