access_update.sql

一个真正的CMS系统,可以完全实现建站自动化,用.NET开发.

CREATE TABLE [bairong_Cache] ([CacheKey] text (200) NOT NULL ,[CacheValue] memo NOT NULL)
~

ALTER TABLE [bairong_Vote] ADD [VoteName] text (50) NOT NULL
~

ALTER TABLE [siteserver_Node] DROP COLUMN [CanInNavigationBar],[IsNewWindowToSelf]
~

ALTER TABLE [siteserver_BackgroundNode]
      DROP COLUMN [ChannelDisplayModeENName],
                  [ContentDisplayModeENName]
~

DROP TABLE [siteserver_BackupRestore]
~

ALTER TABLE [siteserver_Configuration] ADD [DatabaseVersion] text (50) NOT NULL
~

DROP TABLE [siteserver_DataListChannel]
~

DROP TABLE [siteserver_DataListContent]
~

DROP TABLE [siteserver_DataList]
~

DROP TABLE [siteserver_DisplayMode]
~

DROP TABLE [siteserver_Gather]
~

DROP TABLE [siteserver_GatherRule]
~

CREATE TABLE [siteserver_GatherRule] (
   [GatherRuleName] text (50) NOT NULL ,
   [PublishmentSystemID] integer NOT NULL ,
   [WebSiteUrl] text (200) NOT NULL ,
   [Description] memo NOT NULL ,
   [CookieString] memo NOT NULL ,
   [GatherUrlIsCollection] text (18) NOT NULL ,
   [GatherUrlCollection] memo NOT NULL ,
   [GatherUrlIsSerialize] text (18) NOT NULL ,
   [GatherUrlSerialize] text (200) NOT NULL ,
   [SerializeFrom] integer NOT NULL ,
   [SerializeTo] integer NOT NULL ,
   [SerializeInterval] integer NOT NULL ,
   [SerializeIsOrderByDesc] text (18) NOT NULL ,
   [SerializeIsAddZero] text (18) NOT NULL ,
   [NodeID] integer NOT NULL ,
   [Charset] text (50) NOT NULL ,
   [GatherNum] integer NOT NULL ,
   [IsSaveImage] text (18) NOT NULL ,
   [IsChecked] text (18) NOT NULL ,
   [IsOrderByDesc] text (18) NOT NULL ,
   [UrlInclude] text (200) NOT NULL ,
   [TitleInclude] text (255) NOT NULL ,
   [ContentExclude] memo NOT NULL ,
   [ContentHtmlClearCollection] text (255) NOT NULL ,
   [LastGatherDate] datetime NOT NULL ,
   [ListAreaStart] memo NOT NULL ,
   [ListAreaEnd] memo NOT NULL ,
   [ContentChannelStart] memo NOT NULL ,
   [ContentChannelEnd] memo NOT NULL ,
   [ContentTitleStart] memo NOT NULL ,
   [ContentTitleEnd] memo NOT NULL ,
   [ContentContentStart] memo NOT NULL ,
   [ContentContentEnd] memo NOT NULL ,
   [ContentAuthorStart] memo NOT NULL ,
   [ContentAuthorEnd] memo NOT NULL ,
   [ContentSourceStart] memo NOT NULL ,
   [ContentSourceEnd] memo NOT NULL ,
   [ContentNextPageStart] memo NOT NULL ,
   [ContentNextPageEnd] memo NOT NULL
)
~

DROP TABLE [siteserver_MenuDisplayWithNode]
~

ALTER TABLE siteserver_Roles ADD Description memo NOT NULL
~

CREATE TABLE [siteserver_SeoMeta] (
   [SeoMetaID] counter NOT NULL ,
   [PublishmentSystemID] integer NOT NULL ,
   [SeoMetaName] text (50) NOT NULL ,
   [IsDefault] text (18) NOT NULL ,
   [PageTitle] text (80) NOT NULL ,
   [Keywords] text (100) NOT NULL ,
   [Description] text (200) NOT NULL ,
   [Copyright] text (255) NOT NULL ,
   [Author] text (50) NOT NULL ,
   [Email] text (50) NOT NULL ,
   [Language] text (50) NOT NULL ,
   [Charset] text (50) NOT NULL ,
   [Distribution] text (50) NOT NULL ,
   [Rating] text (50) NOT NULL ,
   [Robots] text (50) NOT NULL ,
   [RevisitAfter] text (50) NOT NULL ,
   [Expires] text (50) NOT NULL
)
~
ALTER TABLE [siteserver_SeoMeta] ADD 
    CONSTRAINT [PK_siteserver_SeoMeta_SeoMetaID] primary key ([SeoMetaID])
~

CREATE TABLE [siteserver_SeoMetasInNodes] (
   [NodeID] integer NOT NULL ,
   [IsChannel] text (18) NOT NULL ,
   [SeoMetaID] integer NOT NULL ,
   [PublishmentSystemID] integer NOT NULL
)
~

ALTER TABLE [siteserver_Template]
      DROP COLUMN [AddDate],
                  [Description]
~

ALTER TABLE [siteserver_Tracker]
      DROP COLUMN [IsAnalysisArea],
                  [IsAnalysisBrowser],
                  [IsAnalysisCurrentVisitor],
                  [IsAnalysisDay],
                  [IsAnalysisHour],
                  [IsAnalysisMonth],
                  [IsAnalysisOperatingSystem],
                  [IsAnalysisPageUrl],
                  [IsAnalysisReferer],
                  [IsAnalysisYear]
~