cs_schema.sql

本系统是在asp版《在线文件管理器》的基础上设计制作

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_ProductPermissions_ApplicationType]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_ProductPermissions] DROP CONSTRAINT FK_cs_ProductPermissions_ApplicationType
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_SCHEDULE_TYPE_CD]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_ServiceSchedule] DROP CONSTRAINT FK_SCHEDULE_TYPE_CD
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_SERVICE_TYPE_CODE]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_Services] DROP CONSTRAINT FK_SERVICE_TYPE_CODE
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_Links_cs_LinkCategories]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_Links] DROP CONSTRAINT FK_cs_Links_cs_LinkCategories
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_nntp_Posts_cs_Posts]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_nntp_Posts] DROP CONSTRAINT FK_cs_nntp_Posts_cs_Posts
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_PostEditNotes_cs_Posts]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_PostEditNotes] DROP CONSTRAINT FK_cs_PostEditNotes_cs_Posts
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_PostMetadata_cs_Posts]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_PostMetadata] DROP CONSTRAINT FK_cs_PostMetadata_cs_Posts
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_SearchBarrel_cs_Posts]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_SearchBarrel] DROP CONSTRAINT FK_cs_SearchBarrel_cs_Posts
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_blog_Posts_cs_Posts]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_weblog_Posts] DROP CONSTRAINT FK_blog_Posts_cs_Posts
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_SectionPermissions_SectionID]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_SectionPermissions] DROP CONSTRAINT FK_cs_SectionPermissions_SectionID
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_SERVICE_ID]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_ServiceSchedule] DROP CONSTRAINT FK_SERVICE_ID
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_ProductPermission_SettingsID]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_ProductPermissions] DROP CONSTRAINT FK_cs_ProductPermission_SettingsID
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_PostRating_cs_Threads]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_PostRating] DROP CONSTRAINT FK_cs_PostRating_cs_Threads
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_Posts_cs_Threads]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_Posts] DROP CONSTRAINT FK_cs_Posts_cs_Threads
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_SearchBarrel_cs_Threads]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_SearchBarrel] DROP CONSTRAINT FK_cs_SearchBarrel_cs_Threads
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_ThreadsRead_cs_Threads]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_ThreadsRead] DROP CONSTRAINT FK_cs_ThreadsRead_cs_Threads
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_TrackedThreads_cs_Threads]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_TrackedThreads] DROP CONSTRAINT FK_cs_TrackedThreads_cs_Threads
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_Referrals_cs_Urls]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_Referrals] DROP CONSTRAINT FK_cs_Referrals_cs_Urls
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_PostRating_cs_UserProfile]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_PostRating] DROP CONSTRAINT FK_cs_PostRating_cs_UserProfile
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_UserAvatar_cs_UserProfile]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_UserAvatar] DROP CONSTRAINT FK_cs_UserAvatar_cs_UserProfile
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_cs_Users]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[cs_UserProfile] DROP CONSTRAINT FK_cs_Users
GO

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

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetAnonymousUserID]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[GetAnonymousUserID]
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO