access_update.sql

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

CREATE TABLE [siteserver_GatherDatabaseRule](
    [GatherRuleName] text(50) NOT NULL,
    [PublishmentSystemID] integer NOT NULL ,
    [Description] memo NOT NULL,
    [DatabaseType] text(50) NOT NULL,
    [ConnectionString] text(255) NOT NULL,
    [RelatedTableName] text(255) NOT NULL,
    [RelatedIdentity] text(255) NOT NULL,
    [RelatedOrderBy] text(255) NOT NULL,
    [TableMatchID] integer NOT NULL,
    [NodeID] integer NOT NULL,
    [GatherNum] integer NOT NULL,
    [IsChecked] text(18) NOT NULL,
    [IsOrderByDesc] text(18) NOT NULL,
    [LastGatherDate] datetime NOT NULL,
    CONSTRAINT PK_siteserver_GatherDatabaseRule PRIMARY KEY (GatherRuleName, PublishmentSystemID)
)

~