creatdata.sql

最好用的站点内容管理系统 全部源代码都有

if exists (select * from sysobjects where id = object_id(N'[FK_nt_Collect_RuleRender_nt_Collect_Rule]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [nt_Collect_RuleApply] DROP CONSTRAINT FK_nt_Collect_RuleRender_nt_Collect_Rule
;

if exists (select * from sysobjects where id = object_id(N'[FK_nt_Collect_RuleRender_nt_Collect_Site]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [nt_Collect_RuleApply] DROP CONSTRAINT FK_nt_Collect_RuleRender_nt_Collect_Site
;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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