asp.net+sql人才网站设计.rar

if exists (select * from sysobjects where id = OBJECT_ID('[Admin_Login]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Admin_Login] CREATE TABLE [Admin_Login] ( [id] [int] IDENTITY (1, 1) NOT NULL , [LoginName] [varchar] (50) NULL , [LoginPwd] [varchar] (50) NULL , [ManName] [varchar] (50) NULL , [LoginQQ] [int] NULL , [Purview] [int] NULL , [loginfrom] [varchar] (50) NULL , [dqjieshao] [text] NULL ) SET IDENTITY_INSERT [Admin_Login] ON INSERT [Admin_Login] ( [id] , [LoginName] , [LoginPwd] , [ManName] , [LoginQQ] , [Purview] , [loginfrom] ) VALUES ( 1 , 'admin' , '21232F297A57A5A743894A0E4A801FC3' , 'admin' , 6477347 , -1 , '所有地区' ) SET IDENTITY_INSERT [Admin_Login] OFF if exists (select * from sysobjects where id = OBJECT_ID('[Advertisement]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Advertisement] CREATE TABLE [Advertisement] ( [id] [int] IDENTITY (1, 1) NOT NULL , [ZoneID] [int] NULL , [ADType] [int] NULL , [ADTypeText] [varchar] (50) NULL , [ADName] [varchar] (50) NULL , [ImgUrl] [varchar] (50) NULL , [ImgWidth] [int] NULL , [ImgHeight] [int] NULL , [FlashWmode] [int] NULL , [ADIntro] [text] NULL , [LinkUrl] [varchar] (50) NULL , [LinkTarget] [int] NULL , [LinkAlt] [varchar] (50) NULL , [Priority] [int] NULL , [Views] [int] NULL , [Clicks] [int] NULL , [Passed] [varchar] (50) NULL ) if exists (select * from sysobjects where id = OBJECT_ID('[AdZone]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [AdZone] CREATE TABLE [AdZone] ( [id] [int] IDENTITY (1, 1) NOT NULL , [ChannelID] [varchar] (50) NULL , [ZoneName] [varchar] (50) NULL , [ZoneJsName] [varchar] (50) NULL , [ZoneIntro] [text] NULL , [ZoneType] [int] NULL , [ZoneTypeText] [varchar] (50) NULL , [ZoneSetting] [varchar] (50) NULL , [ZoneWidth] [int] NULL , [ZoneHeight] [int] NULL , [ZoneAction] [varchar] (50) NULL , [ShowType] [int] NULL , [ShowTypeText] [varchar] (50) NULL , [UpTime] [datetime] NULL ) if exists (select * from sysobjects where id = OBJECT_ID('[Article_Class]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Article_Class] CREATE TABLE [Article_Class] ( [id] [int] IDENTITY (1, 1) NOT NULL , [Article_Class_Name] [varchar] (50) NULL ) SET IDENTITY_INSERT [Article_Class] ON INSERT [Article_Class] ( [id] , [Article_Class_Name] ) VALUES ( 1 , '站内公告' ) INSERT [Article_Class] ( [id] , [Article_Class_Name] ) VALUES ( 2 , 'IT江湖' ) INSERT [Article_Class] ( [id] , [Article_Class_Name] ) VALUES ( 3 , 'IT业界' ) INSERT [Article_Class] ( [id] , [Article_Class_Name] ) VALUES ( 4 , '求职指南' ) SET IDENTITY_INSERT [Article_Class] OFF if exists (select * from sysobjects where id = OBJECT_ID('[Article_Content]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Article_Content] CREATE TABLE [Article_Content] ( [id] [int] IDENTITY (1, 1) NOT NULL , [Pid] [int] NULL , [Title] [varchar] (50) NULL , [Content] [text] NULL , [UserName] [varchar] (50) NULL , [AddTime] [datetime] NULL , [ArticleFrom] [varchar] (50) NULL , [ArticleFromName] [varchar] (50) NULL , [ArticleGet] [varchar] (50) NULL , [LookCount] [int] NULL , [AddHTMLUrl] [varchar] (50) NULL ) if exists (select * from sysobjects where id = OBJECT_ID('[Article_Content_GF]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Article_Content_GF] CREATE TABLE [Article_Content_GF] ( [id] [int] IDENTITY (1, 1) NOT NULL , [title] [varchar] (50) NULL , [newsurl] [text] NULL , [times] [datetime] NULL ) if exists (select * from sysobjects where id = OBJECT_ID('[Company_Basemeans]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Company_Basemeans] CREATE TABLE [Company_Basemeans] ( [id] [int] IDENTITY (1, 1) NOT NULL , [pname] [varchar] (50) NULL , [qyname] [varchar] (50) NULL , [qyname_en] [varchar] (50) NULL , [yyzz] [varchar] (50) NULL , [qytype] [varchar] (50) NULL , [qyhy] [varchar] (50) NULL , [qyfrom] [varchar] (50) NULL , [qyfromid] [varchar] (50) NULL , [qymoney] [varchar] (50) NULL , [qyimg] [varchar] (50) NULL , [qyfrdb] [varchar] (50) NULL , [qyrycount] [varchar] (50) NULL , [qycltime] [varchar] (50) NULL , [qyjj] [text] NULL , [qylxbm] [varchar] (50) NULL , [qylxr] [varchar] (50) NULL , [qylxrzw] [varchar] (50) NULL , [qylxmobile] [varchar] (50) NULL , [qyqq] [varchar] (50) NULL , [qyemail] [varchar] (50) NULL , [qycz] [varchar] (50) NULL , [qydizhi] [varchar] (50) NULL , [qyhttp] [varchar] (50) NULL , [qylookcount] [int] NULL , [isPast] [varchar] (50) NULL ) if exists (select * from sysobjects where id = OBJECT_ID('[Company_Login]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Company_Login] CREATE TABLE [Company_Login] ( [id] [int] IDENTITY (1, 1) NOT NULL , [qyname] [varchar] (50) NULL , [qypwd] [varchar] (50) NULL , [regtime] [datetime] NULL , [question] [varchar] (50) NULL , [answer] [varchar] (50) NULL , [isPast] [varchar] (50) NULL ) if exists (select * from sysobjects where id = OBJECT_ID('[FriendSite]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [FriendSite] CREATE TABLE [FriendSite] ( [id] [int] IDENTITY (1, 1) NOT NULL , [PageName] [varchar] (50) NULL , [PageUrl] [varchar] (50) NULL , [PageLogo] [varchar] (50) NULL , [UserEmail] [varchar] (50) NULL , [PageUserName] [varchar] (50) NULL , [PageBody] [text] NULL , [PageOk] [varchar] (50) NULL , [PageType] [varchar] (50) NULL ) SET IDENTITY_INSERT [FriendSite] ON INSERT [FriendSite] ( [id] , [PageName] , [PageUrl] , [PageLogo] , [UserEmail] , [PageUserName] , [PageBody] , [PageOk] , [PageType] ) VALUES ( 1 , 'it0745社区动力' , 'http://www.it0745.com/forum/index.php' , 'http://www.0745job.com/images/it0745.gif' , '[email protected]' , '戴臻' , '怀化专业的IT论坛' , '已通过审核' , '图片链接' ) SET IDENTITY_INSERT [FriendSite] OFF if exists (select * from sysobjects where id = OBJECT_ID('[FromTree]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [FromTree] CREATE TABLE [FromTree] ( [id] [int] IDENTITY (1, 1) NOT NULL , [Pid] [int] NULL , [Name] [varchar] (50) NULL ) SET IDENTITY_INSERT [FromTree] ON INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 1 , 0 , '湖南省' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 2 , 1 , '怀化市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 3 , 1 , '长沙市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 4 , 1 , '株洲市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 5 , 1 , '湘潭市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 6 , 1 , '张家界' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 7 , 1 , '郴州市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 8 , 1 , '永州市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 9 , 1 , '娄底市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 10 , 1 , '益阳市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 11 , 1 , '吉首市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 12 , 1 , '常德市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 13 , 1 , '衡阳市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 14 , 1 , '邵阳市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 15 , 1 , '岳阳市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 16 , 0 , '北京省' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 17 , 16 , '北京市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 18 , 16 , '天津市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 19 , 0 , '安徽省' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 20 , 19 , '合肥市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 21 , 0 , '江苏省' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 22 , 21 , '南京市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 23 , 0 , '福建省' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 24 , 23 , '福州市' ) INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 25 , 0 , '广东省' ) I