星期三人才系统 v2.2

if exists (select * from sysobjects where id = OBJECT_ID('[rc_admin]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [rc_admin] CREATE TABLE [rc_admin] ( [id] [int] NOT NULL, [name] [varchar] (20) NULL, [pwd] [varchar] (20) NULL, [ip] [varchar] (50) NULL, [fabu_date] [datetime] NULL, [type] [varchar] (50) NULL DEFAULT ('管理员|操作员')) ALTER TABLE [rc_admin] WITH NOCHECK ADD CONSTRAINT [PK_rc_admin] PRIMARY KEY NONCLUSTERED ( [id] ) INSERT [rc_admin] ([id],[name],[pwd],[ip],[fabu_date],[type]) VALUES ( 1,'admin','admin','127.0.0.1','2009-3-23 0:00:00','管理员') if exists (select * from sysobjects where id = OBJECT_ID('[rc_diqv]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [rc_diqv] CREATE TABLE [rc_diqv] ( [id] [int] NOT NULL, [name] [varchar] (50) NULL, [pr] [int] NULL DEFAULT (0), [isshow] [int] NULL) ALTER TABLE [rc_diqv] WITH NOCHECK ADD CONSTRAINT [PK_rc_diqv] PRIMARY KEY NONCLUSTERED ( [id] ) INSERT [rc_diqv] ([id],[name],[pr],[isshow]) VALUES ( 0,'清苑',3,0) INSERT [rc_diqv] ([id],[name],[pr],[isshow]) VALUES ( 1,'保定',10,1) INSERT [rc_diqv] ([id],[name],[pr],[isshow]) VALUES ( 2,'满城',2,1) if exists (select * from sysobjects where id = OBJECT_ID('[rc_eml_job]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [rc_eml_job] CREATE TABLE [rc_eml_job] ( [id] [int] NOT NULL, [title] [varchar] (300) NULL, [body] [text] NULL, [type] [varchar] (50) NULL, [state] [varchar] (50) NULL, [chulidate] [datetime] NULL, [beizhu] [text] NULL, [fabudate] [datetime] NULL) ALTER TABLE [rc_eml_job] WITH NOCHECK ADD CONSTRAINT [PK_rc_eml_job] PRIMARY KEY NONCLUSTERED ( [id] ) if exists (select * from sysobjects where id = OBJECT_ID('[rc_eml_site]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [rc_eml_site] CREATE TABLE [rc_eml_site] ( [id] [int] NOT NULL, [gr_title] [varchar] (200) NULL, [gr_body] [text] NULL, [qy_title] [varchar] (200) NULL, [qy_body] [text] NULL) ALTER TABLE [rc_eml_site] WITH NOCHECK ADD CONSTRAINT [PK_rc_eml_site] PRIMARY KEY NONCLUSTERED ( [id] ) INSERT [rc_eml_site] ([id],[gr_title],[gr_body],[qy_title],[qy_body]) VALUES ( 1,'欢迎使用***人才网!','****人才网是,**地区最大的人才网站.这里有最多的人才信息,帮助您找到好人才!','欢迎使用***人才网!','****人才网是,**地区最大的人才网站.这里有最多的人才信息,帮助您找到好人才!') if exists (select * from sysobjects where id = OBJECT_ID('[rc_flash]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [rc_flash] CREATE TABLE [rc_flash] ( [id] [int] NOT NULL, [name] [varchar] (100) NULL, [flashPic] [varchar] (200) NULL, [toUrl] [varchar] (200) NULL, [pr] [int] NULL, [isshow] [varchar] (50) NULL) ALTER TABLE [rc_flash] WITH NOCHECK ADD CONSTRAINT [PK_rc_flash] PRIMARY KEY NONCLUSTERED ( [id] ) INSERT [rc_flash] ([id],[name],[flashPic],[toUrl],[pr],[isshow]) VALUES ( 1,'动漫清美','http://localhost:9778/xiaocui_rc/createhtml/20091108041259.jpg','http://www.qingmeicg.com/web/info/infolist_class1.htm?gclid=CMTYho_4-p0CFdMtpAodompWrw',0,'显示') if exists (select * from sysobjects where id = OBJECT_ID('[rc_guanggao_tupian]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [rc_guanggao_tupian] CREATE TABLE [rc_guanggao_tupian] ( [id] [int] NOT NULL, [name] [varchar] (300) NULL, [tupianurl] [varchar] (500) NULL, [url] [varchar] (500) NULL, [pr] [int] NULL, [type] [varchar] (50) NULL, [ksdate] [datetime] NULL, [jsdate] [datetime] NULL) ALTER TABLE [rc_guanggao_tupian] WITH NOCHECK ADD CONSTRAINT [PK_rc_guanggao_tupian] PRIMARY KEY NONCLUSTERED ( [id] ) INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type],[ksdate],[jsdate]) VALUES ( 1,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组2','2009-12-8 0:00:00','2010-12-9 0:00:00') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type],[ksdate],[jsdate]) VALUES ( 3,'广告图片3','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1','2009-12-8 0:00:00','2010-12-9 0:00:00') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type],[ksdate],[jsdate]) VALUES ( 4,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1','2009-12-8 0:00:00','2010-12-9 0:00:00') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type],[ksdate],[jsdate]) VALUES ( 5,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1','2009-12-8 0:00:00','2010-12-9 0:00:00') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type],[ksdate],[jsdate]) VALUES ( 6,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1','2009-12-8 0:00:00','2010-12-9 0:00:00') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type],[ksdate],[jsdate]) VALUES ( 7,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1','2009-12-8 0:00:00','2010-12-9 0:00:00') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type],[ksdate],[jsdate]) VALUES ( 8,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1','2009-12-8 0:00:00','2010-12-9 0:00:00') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type],[ksdate],[jsdate]) VALUES ( 9,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1','2009-12-8 0:00:00','2010-12-9 0:00:00') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type],[ksdate],[jsdate]) VALUES ( 10,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1','2009-12-8 0:00:00','2010-12-9 0:00:00') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type],[ksdate],[jsdate]) VALUES ( 11,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1','2009-12-8 0:00:00','2010-12-9 0:00:00') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type],[ksdate],[jsdate]) VALUES ( 12,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1','2009-12-8 0:00:00','2010-12-9 0:00:00') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type],[ksdate],[jsdate]) VALUES ( 13,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1','2009-12-8 0:00:00','2010-12-9 0:00:00') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type],[ksdate],[jsdate]) VALUES ( 14,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1','2009-12-8 0:00:00','2010-12-9 0:00:00') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type],[ksdate],[jsdate]) VALUES ( 15,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1','2009-12-8 0:00:00','2010-12-9 0:00:00') if exists (select * from sysobjects where id = OBJECT_ID('[rc_hangye]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [rc_hangye] CREATE TABLE [rc_hangye] ( [id] [int] NOT NULL, [name] [varchar] (100) NULL, [pr] [int] NULL DEFAULT (0), [isshow] [int] NULL) ALTER TABLE [rc_hangye] WITH NOCHECK ADD CONSTRAINT [PK_rc_hangye] PRIMARY KEY NONCLUSTERED ( [id] ) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 1,'计算机',0,1) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 2,'互联网/电子商务',0,1) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 3,'电子/微电子技术',0,1) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 4,'通讯/电信业',0,1) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 5,'快速消费品/食品/饮料/日化/烟酒等',0,1) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 6,'纺织品业/服饰鞋帽/家纺用品/皮具等',0,1) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 7,'家电业',0,1) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 8,'家具/工艺品',0,1) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 9,'木材加工及木/竹/藤/棕/草制品业',0,1) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 10,'橡胶/塑料/非金属矿物制品业',0,1) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 11,'金属制