工作易人才招聘系统 v2.5B1210版

 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] [text] NULL , [loginfrom] [varchar] (50) NULL , [dqjieshao] [text] NULL , [email] [varchar] (100) NULL ) SET IDENTITY_INSERT [Admin_Login] ON INSERT [Admin_Login] ( [id] , [LoginName] , [LoginPwd] , [ManName] , [LoginQQ] , [Purview] , [loginfrom] , [email] ) VALUES ( 1 , 'admin' , '21232F297A57A5A743894A0E4A801FC3' , 'admin' , 66477347 , '-1,01,04_1,05,09,13,16_1,17,18,19,20,21,25,28' , '所有地区' , 'csbqq66@qq.com' ) 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] (255) NULL , [ImgWidth] [int] NULL , [ImgHeight] [int] NULL , [FlashWmode] [int] NULL , [ADIntro] [text] NULL , [LinkUrl] [varchar] (255) NULL , [LinkTarget] [int] NULL , [LinkAlt] [varchar] (50) NULL , [Priority] [int] NULL , [Views] [int] NULL , [Clicks] [int] NULL , [Passed] [varchar] (50) NULL ) SET IDENTITY_INSERT [Advertisement] ON INSERT [Advertisement] ( [id] , [ZoneID] , [ADType] , [ADTypeText] , [ADName] , [ImgUrl] , [ImgWidth] , [ImgHeight] , [FlashWmode] , [ADIntro] , [LinkUrl] , [LinkTarget] , [Priority] , [Views] , [Clicks] , [Passed] ) VALUES ( 1 , 1 , 1 , '图片' , '工作易人才招聘系统随屏移动广告' , '/AD/UploadAdPic/20090610145328.gif' , 0 , 0 , 0 , '工作易人才招聘系统随屏移动广告' , 'http://www.hnitjob.cn/about.aspx' , 1 , 1 , 0 , 0 , '×' ) INSERT [Advertisement] ( [id] , [ZoneID] , [ADType] , [ADTypeText] , [ADName] , [ImgUrl] , [ImgWidth] , [ImgHeight] , [FlashWmode] , [ADIntro] , [LinkUrl] , [LinkTarget] , [Priority] , [Views] , [Clicks] , [Passed] ) VALUES ( 2 , 2 , 1 , '图片' , 'PHPChina广告' , '/AD/UploadAdPic/20080718010802.gif' , 0 , 0 , 0 , '' , 'http://www.phpchina.com/activity2008/' , 1 , 1 , 0 , 0 , '×' ) INSERT [Advertisement] ( [id] , [ZoneID] , [ADType] , [ADTypeText] , [ADName] , [ImgUrl] , [ImgWidth] , [ImgHeight] , [FlashWmode] , [ADIntro] , [LinkUrl] , [LinkTarget] , [Priority] , [Views] , [Clicks] , [Passed] ) VALUES ( 3 , 2 , 1 , '图片' , 'PHPChina（XML+PHP应用广告）' , '/AD/UploadAdPic/20080416164338.jpg' , 90 , 80 , 0 , '' , 'http://www.phpchina.com/study/17/phpstudy.html' , 1 , 1 , 0 , 0 , '×' ) INSERT [Advertisement] ( [id] , [ZoneID] , [ADType] , [ADTypeText] , [ADName] , [ImgUrl] , [ImgWidth] , [ImgHeight] , [FlashWmode] , [ADIntro] , [LinkUrl] , [LinkTarget] , [Priority] , [Views] , [Clicks] , [Passed] ) VALUES ( 4 , 4 , 1 , '图片' , '价值千元.NET人才系统火热出售中！' , '/AD/UploadAdPic/20090610145328.gif' , 0 , 0 , 0 , '价值千元.NET人才系统火热出售中！' , 'www.hnitjob.cn/about.aspx' , 1 , 1 , 0 , 0 , '×' ) SET IDENTITY_INSERT [Advertisement] OFF 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 ) SET IDENTITY_INSERT [AdZone] ON INSERT [AdZone] ( [id] , [ChannelID] , [ZoneName] , [ZoneJsName] , [ZoneIntro] , [ZoneType] , [ZoneTypeText] , [ZoneSetting] , [ZoneWidth] , [ZoneHeight] , [ZoneAction] , [ShowType] , [ShowTypeText] , [UpTime] ) VALUES ( 1 , '2' , '【怀化市】随屏移动广告' , '200804/1.JS' , '随屏移动广告' , 3 , '随屏移动' , '15,200,0.015' , 120 , 230 , '√' , 1 , '随机' , '2009-07-12 00:00:00.000' ) INSERT [AdZone] ( [id] , [ChannelID] , [ZoneName] , [ZoneJsName] , [ZoneIntro] , [ZoneType] , [ZoneTypeText] , [ZoneSetting] , [ZoneWidth] , [ZoneHeight] , [ZoneAction] , [ShowType] , [ShowTypeText] , [UpTime] ) VALUES ( 2 , '2' , '【怀化市】PHPChina广告' , '200804/Pause_2.js' , 'PHPChina广告' , 1 , '矩形横幅' , '' , 992 , 80 , '×' , 3 , '循环' , '2009-06-30 00:00:00.000' ) INSERT [AdZone] ( [id] , [ChannelID] , [ZoneName] , [ZoneJsName] , [ZoneIntro] , [ZoneType] , [ZoneTypeText] , [ZoneSetting] , [ZoneWidth] , [ZoneHeight] , [ZoneAction] , [ShowType] , [ShowTypeText] , [UpTime] ) VALUES ( 3 , '2' , '【怀化市】漂浮移动' , '200907/1.JS' , '' , 5 , '漂浮移动' , '1,100,100' , 120 , 230 , '√' , 1 , '随机' , '2009-07-16 00:00:00.000' ) SET IDENTITY_INSERT [AdZone] OFF 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 , [pid] [int] NULL , [Article_Class_Name] [varchar] (50) NULL ) SET IDENTITY_INSERT [Article_Class] ON INSERT [Article_Class] ( [id] , [pid] , [Article_Class_Name] ) VALUES ( 1 , 0 , '站内公告' ) INSERT [Article_Class] ( [id] , [pid] , [Article_Class_Name] ) VALUES ( 2 , 0 , 'IT江湖' ) INSERT [Article_Class] ( [id] , [pid] , [Article_Class_Name] ) VALUES ( 3 , 0 , 'IT业界' ) INSERT [Article_Class] ( [id] , [pid] , [Article_Class_Name] ) VALUES ( 4 , 0 , '求职指南' ) INSERT [Article_Class] ( [id] , [pid] , [Article_Class_Name] ) VALUES ( 5 , 0 , '其他新闻' ) INSERT [Article_Class] ( [id] , [pid] , [Article_Class_Name] ) VALUES ( 6 , 0 , '编程艺术' ) SET IDENTITY_INSERT [Article_Class] OFF if exists (select * from sysobjects where id = OBJECT_ID('[marqueeFont]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [marqueeFont] CREATE TABLE [marqueeFont] ( [id] [int] IDENTITY (1, 1) NOT NULL , [content] [text] NULL ) if exists (select * from sysobjects where id = OBJECT_ID('[PageAbout]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [PageAbout] CREATE TABLE [PageAbout] ( [id] [int] IDENTITY (1, 1) NOT NULL , [aboutme] [text] NULL , [statement] [text] NULL , [service] [text] NULL , [pagemap] [text] NULL , [Contace] [text] NULL ) SET IDENTITY_INSERT [PageAbout] ON INSERT [PageAbout] ( [id] ) VALUES ( 1 ) SET IDENTITY_INSERT [PageAbout] 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] (100) NULL, [TitleColor] [varchar] (10) NULL, [Content] [text] NULL, [UserName] [varchar] (50) NULL, [AddTime] [datetime] NULL, [ArticleFrom] [varchar] (50) NULL, [ArticleFromName] [varchar] (50) NULL, [ArticleGet] [varchar] (200) NULL, [LookCount] [int] NULL, [AddHTMLUrl] [varchar] (50) NULL, [orders] [int] NULL, [marquee] [int] NULL) SET IDENTITY_INSERT [Article_Content] ON INSERT [Article_Content] ([id],[Pid],[Title],[Content],[UserName],[AddTime],[ArticleFrom],[ArticleFromName],[ArticleGet],[LookCount],[AddHTMLUrl],[orders],[marquee]) VALUES ( 4500,4,'思卓全程品牌顾问(北京)有限公司招聘实习生（文案、设计）','  任职要求1、本科及以上学历，广告、设计等相关专业2、热爱广告，对广告、创意有一定的见解3、诚实正直，具备团队合作精神，踏实、敬业。（�