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('[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 , [dqtype] [int] NULL )
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 , '广东省' )
INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 27 , 25 , '广东市' )
INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 28 , 0 , '湖北省' )
INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 29 , 28 , '武汉市' )
INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 30 , 0 , '山东省' )
INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 31 , 30 , '济南市' )
INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 32 , 0 , '辽宁省' )
INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 33 , 32 , '大连市' )
INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 34 , 0 , '吉林省' )
INSERT [FromTree] ( [id] , [Pid] , [Name] ) VALUES ( 35 , 34 , '长春市' )
INSERT [FromTree] ( [id] , [Pid] , [Nam
湖南IT人才网
需积分: 0 32 浏览量
2007-11-16
02:53:42
上传
评论
收藏 1.01MB RAR 举报
湖南IT人才网 （399个子文件） 
Global.asax 1KB PageTop.ascx 3KB PageTop2.ascx 3KB PageFooter.ascx 2KB Default.aspx 55KB Default_Child.aspx 54KB Advertise_AddZone.aspx 29KB Admin_Index_Left.aspx 25KB Company_Lookzl.aspx 25KB Admin_Index_Left_Child.aspx 22KB Person_Lookzl.aspx 21KB Person_lookAll.aspx 21KB Advertise_AddAD.aspx 20KB PersonJob.aspx 19KB newsall.aspx 19KB Admin_Index_Right.aspx 17KB reg_Basemeans.aspx 17KB Companyzp.aspx 16KB addhunter.aspx 15KB issuejob.aspx 15KB reg_Basemeans.aspx 15KB FriendSiteReg.aspx 14KB GetPwd.aspx 14KB hunterindex.aspx 13KB Default.aspx 13KB Default.aspx 11KB Admin_Manage.aspx 11KB Default_search2.aspx 10KB hunterzl.aspx 10KB Default_search.aspx 10KB ADorMoney.aspx 10KB Admin_Article.aspx 10KB reg1.aspx 8KB Admin_searchCompany.aspx 8KB Hunter_Manage.aspx 8KB reg1.aspx 7KB search_Person.aspx 7KB search_Company.aspx 7KB FriendManage.aspx 6KB ConfigSet.aspx 6KB ConfigPage.aspx 6KB About.aspx 5KB search_Companyzl.aspx 5KB Admin_searchPerson.aspx 4KB search_Companyzl.aspx 4KB EditPwds.aspx 4KB LookNews.aspx 4KB WillJob.aspx 4KB search_Personzl.aspx 4KB issuejobManage.aspx 4KB reg.aspx 3KB reg.aspx 3KB receiveypapp_manage.aspx 3KB sendypapp_manage.aspx 3KB goldManage.aspx 3KB Default1.aspx 3KB search_Personzl2.aspx 3KB Admin_Login.aspx 3KB Advertise_PreviewZone.aspx 3KB SQLBackup.aspx 3KB EditPwds.aspx 3KB Default1.aspx 3KB WillJobManage.aspx 3KB favorite.aspx 3KB sendypapp2_manage.aspx 2KB sendypapp_manage.aspx 2KB favorite.aspx 2KB dqColumn.aspx 2KB Admin_Editshixian_Child.aspx 2KB regread.aspx 2KB ArticleColumn.aspx 2KB TradeColumn.aspx 2KB Admin_Index_Right_GFNews.aspx 1KB connector.aspx 967B upload.aspx 938B Admin_Index_Child.aspx 827B Admin_Index.aspx 802B Company_Lookzl_sendapp.aspx 497B Person_Lookzl_sendapp.aspx 495B Login_Out.aspx 479B Login_Out.aspx 478B RndNumber.aspx 476B Web.config 2KB css.css 15KB style.css 11KB fck_editor.css 8KB Admin_Style.css 6KB fck_dialog.css 2KB fck_editorarea.css 2KB fck_internal.css 2KB browser.css 2KB fck_dialog_common.css 2KB fck_showtableborders_gecko.css 1KB Admin_left.css 1KB fck_universalkey.css 1KB spellerStyle.css 888B MyITJob.dll 204KB FredCK.FCKeditorV2.dll 36KB
人才网系统使用说明.doc 31KB
title.gif 41KB共 399 条
- 1
- 2
- 3
- 4
评论0