sql_update.sql

来自「一个真正的CMS系统,可以完全实现建站自动化,用.NET开发.」· SQL 代码 · 共 23 行

-- Create siteserver_GatherDatabaseRule

IF NOT EXISTS (SELECT Name FROM sysobjects WHERE Name = N'siteserver_GatherDatabaseRule')
CREATE TABLE siteserver_GatherDatabaseRule(
    GatherRuleName         varchar(50)     NOT NULL,
    PublishmentSystemID    int             NOT NULL,
    Description            ntext           DEFAULT '' NOT NULL,
    DatabaseType           varchar(50)     DEFAULT '' NOT NULL,
    ConnectionString       varchar(255)    DEFAULT '' NOT NULL,
    RelatedTableName       varchar(255)    DEFAULT '' NOT NULL,
    RelatedIdentity        varchar(255)    DEFAULT '' NOT NULL,
    RelatedOrderBy         varchar(255)    DEFAULT '' NOT NULL,
    TableMatchID           int             DEFAULT 0 NOT NULL,
    NodeID                 int             DEFAULT 0 NOT NULL,
    GatherNum              int             DEFAULT 0 NOT NULL,
    IsChecked              varchar(18)     DEFAULT '' NOT NULL,
    IsOrderByDesc          varchar(18)     DEFAULT '' NOT NULL,
    LastGatherDate         datetime        DEFAULT getdate() NOT NULL,
    CONSTRAINT PK_siteserver_GatherDatabaseRule PRIMARY KEY CLUSTERED (GatherRuleName, PublishmentSystemID), 
    CONSTRAINT FK_siteserver_GatherDatabaseRule_Node FOREIGN KEY (PublishmentSystemID)
    REFERENCES siteserver_Node(NodeID) ON DELETE CASCADE ON UPDATE CASCADE
)
GO