📄 sql_update.sql

📁 一个真正的CMS系统,可以完全实现建站自动化,用.NET开发.
💻 SQL
字号:
-- Create bairong_Cache

IF NOT EXISTS (SELECT Name FROM sysobjects WHERE Name = N'bairong_Cache')
CREATE TABLE [dbo].[bairong_Cache] (
   [CacheKey] [varchar] (200) NOT NULL ,
   [CacheValue] [ntext] NOT NULL DEFAULT ('')
)
GO


-- Create bairong_Count
IF NOT EXISTS (SELECT Name FROM sysobjects WHERE Name = N'bairong_Count')
CREATE TABLE [dbo].[bairong_Count] (
   [CountID] [int] IDENTITY (1, 1) NOT NULL ,
   [ApplicationName] [varchar] (50) NOT NULL DEFAULT ('') ,
   [RelatedTableName] [nvarchar] (255) NOT NULL DEFAULT ('') ,
   [RelatedIdentity] [nvarchar] (255) NOT NULL DEFAULT ('') ,
   [CountType] [varchar] (50) NOT NULL DEFAULT ('') ,
   [CountNum] [int] NOT NULL DEFAULT (0)
)
GO


-- Add Column bairong_Vote
IF NOT EXISTS (SELECT Name FROM syscolumns WHERE Name = N'VoteName' and id = object_id(N'bairong_Vote'))
ALTER TABLE bairong_Vote ADD VoteName NVARCHAR (50) NOT NULL DEFAULT ''
GO


-- Drop Column siteserver_Node
IF EXISTS (SELECT Name FROM syscolumns WHERE Name = N'CanInNavigationBar')
      ALTER TABLE [dbo].[siteserver_Node] ALTER COLUMN [CanInNavigationBar] DROP DEFAULT
GO
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'DF__siteserve__IsNew__2AA05119')
      ALTER TABLE [dbo].[siteserver_Node] DROP CONSTRAINT [DF__siteserve__IsNew__2AA05119]
GO
IF EXISTS (SELECT Name FROM syscolumns WHERE Name = N'CanInNavigationBar' and id = object_id(N'siteserver_Node')) AND EXISTS (SELECT Name FROM syscolumns WHERE Name = N'IsNewWindowToSelf' and id = object_id(N'siteserver_Node'))
ALTER TABLE [dbo].[siteserver_Node] DROP COLUMN [CanInNavigationBar],[IsNewWindowToSelf]
GO


-- Drop Column siteserver_BackgroundNode
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'DF__siteserve__Chann__5E8A0973')
      ALTER TABLE [dbo].[siteserver_BackgroundNode] DROP CONSTRAINT [DF__siteserve__Chann__5E8A0973]
GO
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'DF__siteserve__Conte__5F7E2DAC')
      ALTER TABLE [dbo].[siteserver_BackgroundNode] DROP CONSTRAINT [DF__siteserve__Conte__5F7E2DAC]
GO
IF EXISTS (SELECT Name FROM syscolumns WHERE Name = N'ChannelDisplayModeENName' and id = object_id(N'siteserver_BackgroundNode')) AND EXISTS (SELECT Name FROM syscolumns WHERE Name = N'ContentDisplayModeENName' and id = object_id(N'siteserver_BackgroundNode'))
ALTER TABLE [dbo].[siteserver_BackgroundNode]
      DROP COLUMN [ChannelDisplayModeENName],
                  [ContentDisplayModeENName]
GO


-- Drop Table siteserver_BackupRestore
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'siteserver_BackupRestore')
DROP TABLE [dbo].[siteserver_BackupRestore]
GO


-- Add Column siteserver_Configuration
IF NOT EXISTS (SELECT Name FROM syscolumns WHERE Name = N'DatabaseVersion' and id = object_id(N'siteserver_Configuration'))
ALTER TABLE siteserver_Configuration ADD DatabaseVersion VARCHAR (50)  NOT NULL DEFAULT ''
GO


-- Drop Table siteserver_DataListChannel
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'siteserver_DataListChannel')
DROP TABLE [dbo].[siteserver_DataListChannel]
GO


-- Drop Table siteserver_DataListContent
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'siteserver_DataListContent')
DROP TABLE [dbo].[siteserver_DataListContent]
GO


-- Drop Table siteserver_DataList
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'siteserver_DataList')
DROP TABLE [dbo].[siteserver_DataList]
GO


-- Drop Table siteserver_DisplayMode
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'siteserver_DisplayMode')
DROP TABLE [dbo].[siteserver_DisplayMode]
GO


-- Drop Table siteserver_Gather
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'siteserver_Gather')
DROP TABLE [dbo].[siteserver_Gather]
GO


-- Alter Table siteserver_GatherRule
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'siteserver_GatherRule')
DROP TABLE [dbo].[siteserver_GatherRule]
GO

CREATE TABLE [dbo].[siteserver_GatherRule] (
   [GatherRuleName] [varchar] (50) NOT NULL ,
   [PublishmentSystemID] [int] NOT NULL ,
   [WebSiteUrl] [varchar] (200) NOT NULL CONSTRAINT [DF__siteserve__WebSi__114A936A] DEFAULT ('') ,
   [Description] [ntext] NOT NULL CONSTRAINT [DF__siteserve__Descr__123EB7A3] DEFAULT ('') ,
   [CookieString] [text] NOT NULL CONSTRAINT [DF__siteserve__Cooki__1332DBDC] DEFAULT ('') ,
   [GatherUrlIsCollection] [varchar] (18) NOT NULL CONSTRAINT [DF__siteserve__Gathe__14270015] DEFAULT ('') ,
   [GatherUrlCollection] [text] NOT NULL CONSTRAINT [DF__siteserve__Gathe__151B244E] DEFAULT ('') ,
   [GatherUrlIsSerialize] [varchar] (18) NOT NULL CONSTRAINT [DF__siteserve__Gathe__160F4887] DEFAULT ('') ,
   [GatherUrlSerialize] [varchar] (200) NOT NULL CONSTRAINT [DF__siteserve__Gathe__17036CC0] DEFAULT ('') ,
   [SerializeFrom] [int] NOT NULL CONSTRAINT [DF__siteserve__Seria__17F790F9] DEFAULT (0) ,
   [SerializeTo] [int] NOT NULL CONSTRAINT [DF__siteserve__Seria__18EBB532] DEFAULT (0) ,
   [SerializeInterval] [int] NOT NULL CONSTRAINT [DF__siteserve__Seria__19DFD96B] DEFAULT (0) ,
   [SerializeIsOrderByDesc] [varchar] (18) NOT NULL CONSTRAINT [DF__siteserve__Seria__1AD3FDA4] DEFAULT ('') ,
   [SerializeIsAddZero] [varchar] (18) NOT NULL CONSTRAINT [DF__siteserve__Seria__1BC821DD] DEFAULT (0) ,
   [NodeID] [int] NOT NULL CONSTRAINT [DF__siteserve__NodeI__1CBC4616] DEFAULT (0) ,
   [Charset] [varchar] (50) NOT NULL CONSTRAINT [DF__siteserve__Chars__1DB06A4F] DEFAULT ('') ,
   [GatherNum] [int] NOT NULL CONSTRAINT [DF__siteserve__Gathe__1EA48E88] DEFAULT (0) ,
   [IsSaveImage] [varchar] (18) NOT NULL CONSTRAINT [DF__siteserve__IsSav__1F98B2C1] DEFAULT ('') ,
   [IsChecked] [varchar] (18) NOT NULL CONSTRAINT [DF__siteserve__IsChe__208CD6FA] DEFAULT ('') ,
   [IsOrderByDesc] [varchar] (18) NOT NULL CONSTRAINT [DF__siteserve__IsOrd__2180FB33] DEFAULT ('') ,
   [UrlInclude] [varchar] (200) NOT NULL CONSTRAINT [DF__siteserve__UrlIn__22751F6C] DEFAULT ('') ,
   [TitleInclude] [nvarchar] (255) NOT NULL CONSTRAINT [DF__siteserve__Title__236943A5] DEFAULT ('') ,
   [ContentExclude] [ntext] NOT NULL CONSTRAINT [DF__siteserve__Conte__245D67DE] DEFAULT ('') ,
   [ContentHtmlClearCollection] [varchar] (255) NOT NULL CONSTRAINT [DF__siteserve__Conte__25518C17] DEFAULT ('') ,
   [LastGatherDate] [datetime] NOT NULL CONSTRAINT [DF__siteserve__LastG__2645B050] DEFAULT (getdate()) ,
   [ListAreaStart] [ntext] NOT NULL CONSTRAINT [DF__siteserve__ListA__2739D489] DEFAULT ('') ,
   [ListAreaEnd] [ntext] NOT NULL CONSTRAINT [DF__siteserve__ListA__282DF8C2] DEFAULT ('') ,
   [ContentChannelStart] [ntext] NOT NULL CONSTRAINT [DF__siteserve__Conte__29221CFB] DEFAULT ('') ,
   [ContentChannelEnd] [ntext] NOT NULL CONSTRAINT [DF__siteserve__Conte__2A164134] DEFAULT ('') ,
   [ContentTitleStart] [ntext] NOT NULL CONSTRAINT [DF__siteserve__Conte__2B0A656D] DEFAULT ('') ,
   [ContentTitleEnd] [ntext] NOT NULL CONSTRAINT [DF__siteserve__Conte__2BFE89A6] DEFAULT ('') ,
   [ContentContentStart] [ntext] NOT NULL CONSTRAINT [DF__siteserve__Conte__2CF2ADDF] DEFAULT ('') ,
   [ContentContentEnd] [ntext] NOT NULL CONSTRAINT [DF__siteserve__Conte__2DE6D218] DEFAULT ('') ,
   [ContentAuthorStart] [ntext] NOT NULL CONSTRAINT [DF__siteserve__Conte__2EDAF651] DEFAULT ('') ,
   [ContentAuthorEnd] [ntext] NOT NULL CONSTRAINT [DF__siteserve__Conte__2FCF1A8A] DEFAULT ('') ,
   [ContentSourceStart] [ntext] NOT NULL CONSTRAINT [DF__siteserve__Conte__30C33EC3] DEFAULT ('') ,
   [ContentSourceEnd] [ntext] NOT NULL CONSTRAINT [DF__siteserve__Conte__31B762FC] DEFAULT ('') ,
   [ContentNextPageStart] [ntext] NOT NULL CONSTRAINT [DF__siteserve__Conte__32AB8735] DEFAULT ('') ,
   [ContentNextPageEnd] [ntext] NOT NULL CONSTRAINT [DF__siteserve__Conte__339FAB6E] DEFAULT ('')
)
GO


-- Drop Table siteserver_MenuDisplayWithNode
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'siteserver_MenuDisplayWithNode')
DROP TABLE [dbo].[siteserver_MenuDisplayWithNode]
GO


-- Add Column siteserver_Roles
IF NOT EXISTS (SELECT Name FROM syscolumns WHERE Name = N'Description' and id = object_id(N'siteserver_Roles'))
ALTER TABLE siteserver_Roles ADD Description NTEXT NOT NULL DEFAULT ''
GO


-- Create Table siteserver_SeoMeta
IF NOT EXISTS (SELECT Name FROM sysobjects WHERE Name = N'siteserver_SeoMeta')
CREATE TABLE [dbo].[siteserver_SeoMeta] (
   [SeoMetaID] [int] IDENTITY (1, 1) NOT NULL ,
   [PublishmentSystemID] [int] NOT NULL ,
   [SeoMetaName] [varchar] (50) NOT NULL CONSTRAINT [DF__siteserve__SeoMe__1D7B6025] DEFAULT ('') ,
   [IsDefault] [varchar] (18) NOT NULL CONSTRAINT [DF__siteserve__IsDef__1E6F845E] DEFAULT ('') ,
   [PageTitle] [nvarchar] (80) NOT NULL CONSTRAINT [DF__siteserve__PageT__1F63A897] DEFAULT ('') ,
   [Keywords] [nvarchar] (100) NOT NULL CONSTRAINT [DF__siteserve__Keywo__2057CCD0] DEFAULT ('') ,
   [Description] [nvarchar] (200) NOT NULL CONSTRAINT [DF__siteserve__Descr__214BF109] DEFAULT ('') ,
   [Copyright] [nvarchar] (255) NOT NULL CONSTRAINT [DF__siteserve__Copyr__22401542] DEFAULT ('') ,
   [Author] [nvarchar] (50) NOT NULL CONSTRAINT [DF__siteserve__Autho__2334397B] DEFAULT ('') ,
   [Email] [nvarchar] (50) NOT NULL CONSTRAINT [DF__siteserve__Email__24285DB4] DEFAULT ('') ,
   [Language] [varchar] (50) NOT NULL CONSTRAINT [DF__siteserve__Langu__251C81ED] DEFAULT ('') ,
   [Charset] [varchar] (50) NOT NULL CONSTRAINT [DF__siteserve__Chars__2610A626] DEFAULT ('') ,
   [Distribution] [varchar] (50) NOT NULL CONSTRAINT [DF__siteserve__Distr__2704CA5F] DEFAULT ('') ,
   [Rating] [varchar] (50) NOT NULL CONSTRAINT [DF__siteserve__Ratin__27F8EE98] DEFAULT ('') ,
   [Robots] [varchar] (50) NOT NULL CONSTRAINT [DF__siteserve__Robot__28ED12D1] DEFAULT ('') ,
   [RevisitAfter] [varchar] (50) NOT NULL CONSTRAINT [DF__siteserve__Revis__29E1370A] DEFAULT ('') ,
   [Expires] [varchar] (50) NOT NULL CONSTRAINT [DF__siteserve__Expir__2AD55B43] DEFAULT ('')
)
GO


-- Create Table siteserver_SeoMetasInNodes
IF NOT EXISTS (SELECT Name FROM sysobjects WHERE Name = N'siteserver_SeoMetasInNodes')
CREATE TABLE [dbo].[siteserver_SeoMetasInNodes] (
   [NodeID] [int] NOT NULL ,
   [IsChannel] [varchar] (18) NOT NULL CONSTRAINT [DF__siteserve__IsCha__2DB1C7EE] DEFAULT ('') ,
   [SeoMetaID] [int] NOT NULL ,
   [PublishmentSystemID] [int] NOT NULL
)
GO


-- Drop Column siteserver_Template
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'DF__siteserve__AddDa__54968AE5')
      ALTER TABLE [dbo].[siteserver_Template] DROP CONSTRAINT [DF__siteserve__AddDa__54968AE5]
GO
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'DF__siteserve__Descr__567ED357')
      ALTER TABLE [dbo].[siteserver_Template] DROP CONSTRAINT [DF__siteserve__Descr__567ED357]
GO
IF EXISTS (SELECT Name FROM syscolumns WHERE Name = N'AddDate' and id = object_id(N'siteserver_Template')) AND EXISTS (SELECT Name FROM syscolumns WHERE Name = N'Description' and id = object_id(N'siteserver_Template'))
ALTER TABLE [dbo].[siteserver_Template]
      DROP COLUMN [AddDate],
                  [Description]
GO


-- Drop Column siteserver_Tracker
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'DF__siteserve__IsAna__60FC61CA')
      ALTER TABLE [dbo].[siteserver_Tracker] DROP CONSTRAINT [DF__siteserve__IsAna__60FC61CA]
GO
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'DF__siteserve__IsAna__62E4AA3C')
      ALTER TABLE [dbo].[siteserver_Tracker] DROP CONSTRAINT [DF__siteserve__IsAna__62E4AA3C]
GO
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'DF__siteserve__IsAna__63D8CE75')
      ALTER TABLE [dbo].[siteserver_Tracker] DROP CONSTRAINT [DF__siteserve__IsAna__63D8CE75]
GO
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'DF__siteserve__IsAna__5D2BD0E6')
      ALTER TABLE [dbo].[siteserver_Tracker] DROP CONSTRAINT [DF__siteserve__IsAna__5D2BD0E6]
GO
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'DF__siteserve__IsAna__5E1FF51F')
      ALTER TABLE [dbo].[siteserver_Tracker] DROP CONSTRAINT [DF__siteserve__IsAna__5E1FF51F]
GO
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'DF__siteserve__IsAna__5C37ACAD')
      ALTER TABLE [dbo].[siteserver_Tracker] DROP CONSTRAINT [DF__siteserve__IsAna__5C37ACAD]
GO
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'DF__siteserve__IsAna__61F08603')
      ALTER TABLE [dbo].[siteserver_Tracker] DROP CONSTRAINT [DF__siteserve__IsAna__61F08603]
GO
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'DF__siteserve__IsAna__60083D91')
      ALTER TABLE [dbo].[siteserver_Tracker] DROP CONSTRAINT [DF__siteserve__IsAna__60083D91]
GO
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'DF__siteserve__IsAna__5F141958')
      ALTER TABLE [dbo].[siteserver_Tracker] DROP CONSTRAINT [DF__siteserve__IsAna__5F141958]
GO
IF EXISTS (SELECT Name FROM sysobjects WHERE Name = N'DF__siteserve__IsAna__5B438874')
      ALTER TABLE [dbo].[siteserver_Tracker] DROP CONSTRAINT [DF__siteserve__IsAna__5B438874]
GO
IF EXISTS (SELECT Name FROM syscolumns WHERE Name = N'IsAnalysisArea' and id = object_id(N'siteserver_Tracker'))
ALTER TABLE [dbo].[siteserver_Tracker]
      DROP COLUMN [IsAnalysisArea],
                  [IsAnalysisBrowser],
                  [IsAnalysisCurrentVisitor],
                  [IsAnalysisDay],
                  [IsAnalysisHour],
                  [IsAnalysisMonth],
                  [IsAnalysisOperatingSystem],
                  [IsAnalysisPageUrl],
                  [IsAnalysisReferer],
                  [IsAnalysisYear]
GO
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -