creatdata.sql

来自「这也是关于论坛的一个源代码」· SQL 代码 · 共 2,031 行 · 第 1/5 页

use [DO_NET_CMS]
;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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