升级脚本.sql

CallSun 人才招聘求职系统 V2.20

-- 修改所有的存储过程
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_ApplyForAJob]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_ApplyForAJob]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_ChangePassword]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_ChangePassword]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_CompanyApplyReply]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_CompanyApplyReply]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_CompanyCheckLogin]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_CompanyCheckLogin]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_CompanyRegistration]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_CompanyRegistration]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_InterviewUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_InterviewUpdate]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_InvitePerson]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_InvitePerson]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_InvitePersonUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_InvitePersonUpdate]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_Pagination]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_Pagination]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_Pagination2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_Pagination2]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_PaginationCount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_PaginationCount]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_PersonCheckLogin]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_PersonCheckLogin]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_PersonRegistration]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_PersonRegistration]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_UpdateUserJifen]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_UpdateUserJifen]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ai_AdInfoClass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ai_AdInfoClass]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ai_adinfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ai_adinfo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ai_complaintmessage]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ai_complaintmessage]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ai_leavemessage]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ai_leavemessage]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_meetingplace]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mp_meetingplace]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_scene]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mp_scene]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_showposition]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mp_showposition]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_showposition_order]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mp_showposition_order]
GO

-- 修改有变动的表结构

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rc_com_apply]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [j_title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_realname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_sex] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_photo] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_people] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_polity] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_marry] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_experience] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_wage] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_graduation] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_education] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_professionname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_profession] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_language] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_language_level] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_place] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_telephone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_email] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_qq] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_address] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_code] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_prefer_jobclass1] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_prefer_jobtitle1] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_prefer_jobclass2] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_com_apply] ALTER COLUMN [ca_prefer_jobtitle2] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
end
else
begin
CREATE TABLE [dbo].[rc_com_apply] (
	[ca_id] [int] IDENTITY (1, 1) NOT NULL ,
	[u_id_com] [int] NOT NULL ,
	[u_id_per] [int] NOT NULL ,
	[j_id] [int] NOT NULL ,
	[ca_state] [int] NOT NULL ,
	[j_title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_realname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_sex] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_photo] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_people] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_polity] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_update] [datetime] NULL ,
	[ca_birthday] [datetime] NULL ,
	[ca_marry] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_experience] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_wage] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_graduation] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_education] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_professionname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_profession] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_language] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_language_level] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_place] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_telephone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_email] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_qq] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_address] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_code] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_prefer_jobclass1] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_prefer_jobtitle1] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_prefer_jobclass2] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_prefer_jobtitle2] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_introduce] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_training] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_skill] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_award] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ca_applydate] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
end
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rc_company]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN	[c_name] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_mainclass] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_subclass] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_type] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_license] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_money] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_scope] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_legalman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_location] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_address] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_linkAddress] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_code] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_telephone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_fax] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_email] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_website] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_photo] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_company] ALTER COLUMN [c_otherphoto] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
end
else
begin
CREATE TABLE [dbo].[rc_company] (
	[c_id] [int] IDENTITY (1, 1) NOT NULL ,
	[u_id] [int] NOT NULL ,
	[cc_mainclassid] [int] NOT NULL ,
	[cc_subclassid] [int] NULL ,
	[c_name] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[c_mainclass] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_subclass] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_type] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_birthday] [datetime] NULL ,
	[c_license] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[c_money] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_scope] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_legalman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_location] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_address] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_linkAddress] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_code] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_telephone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_fax] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_email] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_website] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_introduce] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[c_product] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[c_state] [int] NOT NULL ,
	[c_memo] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[c_photo] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_countview] [int] NULL ,
	[c_update] [datetime] NULL ,
	[c_lastjobdate] [datetime] NULL ,
	[c_tid] [int] NULL ,
	[c_otherphoto] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_resumeview] [int] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
end
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rc_job]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
  ALTER TABLE [dbo].[rc_job] ALTER COLUMN [j_title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL
  ALTER TABLE [dbo].[rc_job] ALTER COLUMN [j_jobmainclass] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_job] ALTER COLUMN [j_jobsubclass] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_job] ALTER COLUMN [j_age] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_job] ALTER COLUMN [j_sex] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_job] ALTER COLUMN [j_workarea] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_job] ALTER COLUMN [j_city] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_job] ALTER COLUMN [j_education] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_job] ALTER COLUMN [j_worktype] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_job] ALTER COLUMN [j_object] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_job] ALTER COLUMN [j_area] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL 
end
else
begin
CREATE TABLE [dbo].[rc_job] (
	[j_id] [int] IDENTITY (1, 1) NOT NULL ,
	[u_id] [int] NOT NULL ,
	[j_date] [datetime] NOT NULL ,
	[j_title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[j_countneed] [int] NOT NULL ,
	[j_expired] [datetime] NULL ,
	[j_jobmainclass] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[j_jobsubclass] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[j_age] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[j_sex] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[j_workarea] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[j_city] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[j_education] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[j_worktype] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[j_object] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[j_memo] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[j_countapply] [int] NOT NULL ,
	[j_state] [int] NOT NULL ,
	[j_area] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
end
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rc_message]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
  ALTER TABLE [dbo].[rc_message] ALTER COLUMN [m_sendname] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_message] ALTER COLUMN [m_title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
end
else
begin
CREATE TABLE [dbo].[rc_message] (
	[m_id] [int] IDENTITY (1, 1) NOT NULL ,
	[u_id_send] [int] NOT NULL ,
	[u_id_recv] [int] NOT NULL ,
	[m_sendname] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[m_date] [datetime] NULL ,
	[m_state] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
end
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rc_person]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_idcode] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_realname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_sex] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_photo] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_people] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_polity] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_marry] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_health] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_workplace] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_worktype] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_experience] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_wage] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_graduation] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_education] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_professionname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_profession] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_language] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_language_level] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_liveplace] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_place] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_telephone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_email] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_mobile] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_qq] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_address] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_code] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_prefer_jobclass1] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_prefer_jobtitle1] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_prefer_jobclass2] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
  ALTER TABLE [dbo].[rc_person] ALTER COLUMN [p_prefer_jobtitle2] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL

  ALTER TABLE [dbo].[rc_person] ADD
    [p_countview] [int] NULL ,
    [p_state] [int] NULL ,
    [p_update] [datetime] NULL ,
    [p_expire] [datetime] NULL ,
    [p_settings] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL
end
else
begin
CREATE TABLE [dbo].[rc_person] (
	[p_id] [int] IDENTITY (1, 1) NOT NULL ,
	[u_id] [int] NOT NULL ,
	[p_idcode] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[p_realname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[p_sex] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[p_photo] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[p_people] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[p_polity] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[p_birthday] [datetime] NULL ,
	[p_height] [int] NULL ,