siteserver_schema.sql

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

)
go



CREATE TABLE siteserver_ContentGroup(
    ContentGroupName       nvarchar(255)    NOT NULL,
    PublishmentSystemID    int              DEFAULT 0 NOT NULL,
    Description            ntext            DEFAULT '' NOT NULL,
    CONSTRAINT PK_siteserver_ContentGroup PRIMARY KEY CLUSTERED (ContentGroupName, PublishmentSystemID)
)
go



CREATE TABLE siteserver_ContentRemark(
    ContentRemarkID        int              IDENTITY(1,1),
    PublishmentSystemID    int              NOT NULL,
    NodeID                 int              NOT NULL,
    ContentID              int              DEFAULT 0 NOT NULL,
    AddUserName            nvarchar(255)    DEFAULT '' NOT NULL,
    Remark                 text             DEFAULT '' NOT NULL,
    Face                   varchar(50)      DEFAULT '' NOT NULL,
    AddDate                datetime         DEFAULT getdate() NOT NULL,
    IsChecked              varchar(18)      DEFAULT '' NOT NULL,
    CONSTRAINT PK_siteserver_ContentRemark PRIMARY KEY CLUSTERED (ContentRemarkID)
)
go



CREATE TABLE siteserver_ForegroundNode(
    NodeID                      int             NOT NULL,
    LinkUrl                     varchar(200)    DEFAULT '' NOT NULL,
    ForegroundAuxiliaryTable    varchar(50)     DEFAULT '' NOT NULL,
    ChannelTemplateID           int             DEFAULT 0 NOT NULL,
    GeneratedFilePath           varchar(200)    DEFAULT '' NOT NULL,
    SettingsXML                 ntext           DEFAULT '' NOT NULL,
    CONSTRAINT PK_siteserver_ForegroundNode PRIMARY KEY CLUSTERED (NodeID)
)
go



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)
)
go



CREATE TABLE siteserver_GatherRule(
    GatherRuleName                varchar(50)      NOT NULL,
    PublishmentSystemID           int              NOT NULL,
    WebSiteUrl                    varchar(200)     DEFAULT '' NOT NULL,
    Description                   ntext            DEFAULT '' NOT NULL,
    CookieString                  text             DEFAULT '' NOT NULL,
    GatherUrlIsCollection         varchar(18)      DEFAULT '' NOT NULL,
    GatherUrlCollection           text             DEFAULT '' NOT NULL,
    GatherUrlIsSerialize          varchar(18)      DEFAULT '' NOT NULL,
    GatherUrlSerialize            varchar(200)     DEFAULT '' NOT NULL,
    SerializeFrom                 int              DEFAULT 0 NOT NULL,
    SerializeTo                   int              DEFAULT 0 NOT NULL,
    SerializeInterval             int              DEFAULT 0 NOT NULL,
    SerializeIsOrderByDesc        varchar(18)      DEFAULT '' NOT NULL,
    SerializeIsAddZero            varchar(18)      DEFAULT 0 NOT NULL,
    NodeID                        int              DEFAULT 0 NOT NULL,
    Charset                       varchar(50)      DEFAULT '' NOT NULL,
    GatherNum                     int              DEFAULT 0 NOT NULL,
    IsSaveImage                   varchar(18)      DEFAULT '' NOT NULL,
    IsChecked                     varchar(18)      DEFAULT '' NOT NULL,
    IsOrderByDesc                 varchar(18)      DEFAULT '' NOT NULL,
    UrlInclude                    varchar(200)     DEFAULT '' NOT NULL,
    TitleInclude                  nvarchar(255)    DEFAULT '' NOT NULL,
    ContentExclude                ntext            DEFAULT '' NOT NULL,
    ContentHtmlClearCollection    varchar(255)     DEFAULT '' NOT NULL,
    LastGatherDate                datetime         DEFAULT getdate() NOT NULL,
    ListAreaStart                 ntext            DEFAULT '' NOT NULL,
    ListAreaEnd                   ntext            DEFAULT '' NOT NULL,
    ContentChannelStart           ntext            DEFAULT '' NOT NULL,
    ContentChannelEnd             ntext            DEFAULT '' NOT NULL,
    ContentTitleStart             ntext            DEFAULT '' NOT NULL,
    ContentTitleEnd               ntext            DEFAULT '' NOT NULL,
    ContentContentStart           ntext            DEFAULT '' NOT NULL,
    ContentContentEnd             ntext            DEFAULT '' NOT NULL,
    ContentAuthorStart            ntext            DEFAULT '' NOT NULL,
    ContentAuthorEnd              ntext            DEFAULT '' NOT NULL,
    ContentSourceStart            ntext            DEFAULT '' NOT NULL,
    ContentSourceEnd              ntext            DEFAULT '' NOT NULL,
    ContentNextPageStart          ntext            DEFAULT '' NOT NULL,
    ContentNextPageEnd            ntext            DEFAULT '' NOT NULL,
    CONSTRAINT PK_siteserver_GatherRule PRIMARY KEY CLUSTERED (GatherRuleName, PublishmentSystemID)
)
go



CREATE TABLE siteserver_GeneralPermissionsInRoles(
    RoleName              nvarchar(255)    NOT NULL,
    GeneralPermissions    text             DEFAULT '' NOT NULL,
    CONSTRAINT PK_siteserver_GeneralPermissionsInRoles PRIMARY KEY CLUSTERED (RoleName)
)
go



CREATE TABLE siteserver_Job(
    JobENName              varchar(50)     NOT NULL,
    JobCNName              varchar(50)     DEFAULT '' NOT NULL,
    Assembly               varchar(200)    DEFAULT '' NOT NULL,
    ClassName              varchar(200)    DEFAULT '' NOT NULL,
    Parameters             varchar(200)    DEFAULT '' NOT NULL,
    JobExecuteType         varchar(50)     DEFAULT '' NOT NULL,
    LastExecuteDateTime    datetime        DEFAULT getdate() NOT NULL,
    IntervalMinute         int             DEFAULT 0 NOT NULL,
    IsDisabled             varchar(18)     DEFAULT '' NOT NULL,
    AddDate                datetime        DEFAULT getdate() NOT NULL,
    Description            ntext           DEFAULT '' NOT NULL,
    CONSTRAINT PK_siteserver_Job PRIMARY KEY CLUSTERED (JobENName)
)
go



CREATE TABLE siteserver_LoadBalancingMachine(
    ComputerName           varchar(50)    NOT NULL,
    SharedDirectoryName    varchar(50)    DEFAULT '' NOT NULL,
    UserName               varchar(50)    DEFAULT '' NOT NULL,
    Password               varchar(50)    DEFAULT '' NOT NULL,
    DomainName             varchar(50)    DEFAULT '' NOT NULL,
    CONSTRAINT PK_siteserver_LoadBalancingMachine PRIMARY KEY CLUSTERED (ComputerName)
)
go



CREATE TABLE siteserver_Log(
    LogID          int            IDENTITY(1,1),
    LogUserName    varchar(50)    DEFAULT '' NOT NULL,
    LogIP          varchar(50)    DEFAULT '' NOT NULL,
    OS             varchar(50)    DEFAULT '' NOT NULL,
    IsSuccessed    varchar(18)    DEFAULT '' NOT NULL,
    LoginDate      datetime       DEFAULT getdate() NOT NULL,
    CONSTRAINT PK_siteserver_Log PRIMARY KEY CLUSTERED (LogID)
)
go



CREATE TABLE siteserver_MenuDisplay(
    MenuDisplayID          int             IDENTITY(1,1),
    PublishmentSystemID    int             NOT NULL,
    MenuDisplayName        varchar(50)     DEFAULT '' NOT NULL,
    Vertical               varchar(50)     DEFAULT '' NOT NULL,
    FontFamily             varchar(200)    DEFAULT '' NOT NULL,
    FontSize               int             DEFAULT 0 NOT NULL,
    FontWeight             varchar(50)     DEFAULT '' NOT NULL,
    FontStyle              varchar(50)     DEFAULT '' NOT NULL,
    MenuItemHAlign         varchar(50)     DEFAULT '' NOT NULL,
    MenuItemVAlign         varchar(50)     DEFAULT '' NOT NULL,
    FontColor              varchar(50)     DEFAULT '' NOT NULL,
    MenuItemBgColor        varchar(50)     DEFAULT '' NOT NULL,
    FontColorHilite        varchar(50)     DEFAULT '' NOT NULL,
    MenuHiliteBgColor      varchar(50)     DEFAULT '' NOT NULL,
    XPosition              varchar(50)     DEFAULT '' NOT NULL,
    YPosition              varchar(50)     DEFAULT '' NOT NULL,
    HideOnMouseOut         varchar(50)     DEFAULT '' NOT NULL,
    MenuWidth              int             DEFAULT 0 NOT NULL,
    MenuItemHeight         int             DEFAULT 0 NOT NULL,
    MenuItemPadding        int             DEFAULT 0 NOT NULL,
    MenuItemSpacing        int             DEFAULT 0 NOT NULL,
    MenuItemIndent         int             DEFAULT 0 NOT NULL,
    HideTimeout            int             DEFAULT 0 NOT NULL,
    MenuBgOpaque           varchar(50)     DEFAULT '' NOT NULL,
    MenuBorder             int             DEFAULT 0 NOT NULL,
    BGColor                varchar(50)     DEFAULT '' NOT NULL,
    MenuBorderBgColor      varchar(50)     DEFAULT '' NOT NULL,
    MenuLiteBgColor        varchar(50)     DEFAULT '' NOT NULL,
    ChildMenuIcon          varchar(200)    DEFAULT '' NOT NULL,
    AddDate                datetime        DEFAULT getdate() NOT NULL,
    IsDefault              varchar(18)     DEFAULT '' NOT NULL,
    Description            ntext           DEFAULT '' NOT NULL,
    CONSTRAINT PK_siteserver_MenuDisplay PRIMARY KEY CLUSTERED (MenuDisplayID)
)
go



CREATE TABLE siteserver_Node(
    NodeID                     int              IDENTITY(1,1),
    NodeName                   varchar(50)      DEFAULT '' NOT NULL,
    NodeType                   varchar(50)      DEFAULT '' NOT NULL,
    PublishmentSystemID        int              DEFAULT 0 NOT NULL,
    ParentID                   int              DEFAULT 0 NOT NULL,
    ParentsPath                varchar(50)      DEFAULT '' NOT NULL,
    ParentsCount               int              DEFAULT 0 NOT NULL,
    ChildrenCount              int              DEFAULT 0 NOT NULL,
    IsLastNode                 varchar(18)      DEFAULT '' NOT NULL,
    NodeIndexName              varchar(50)      DEFAULT '' NOT NULL,
    NodeGroupNameCollection    nvarchar(255)    DEFAULT '' NOT NULL,
    Taxis                      int              DEFAULT 0 NOT NULL,
    AddUserName                nvarchar(255)    DEFAULT '' NOT NULL,
    AddDate                    datetime         DEFAULT getdate() NOT NULL,
    ImageUrl                   varchar(200)     DEFAULT '' NOT NULL,
    Content                    ntext            DEFAULT '' NOT NULL,
    ContentNum                 int              DEFAULT 0 NOT NULL,
    CONSTRAINT PK_siteserver_Node PRIMARY KEY NONCLUSTERED (NodeID)
)
go



CREATE TABLE siteserver_NodeGroup(
    NodeGroupName          nvarchar(255)    NOT NULL,
    PublishmentSystemID    int              DEFAULT 0 NOT NULL,
    Description            ntext            DEFAULT '' NOT NULL,
    CONSTRAINT PK_siteserver_NodeGroup PRIMARY KEY CLUSTERED (NodeGroupName, PublishmentSystemID)
)
go



CREATE TABLE siteserver_PublishmentSystem(
    PublishmentSystemID         int             NOT NULL,
    PublishmentSystemName       nvarchar(50)    DEFAULT '' NOT NULL,
    AuxiliaryTableForChannel    varchar(50)     DEFAULT '' NOT NULL,
    AuxiliaryTableForContent    varchar(50)     DEFAULT '' NOT NULL,
    IsCheckContentUseLevel      varchar(18)     DEFAULT '' NOT NULL,
    CheckContentLevel           int             DEFAULT 0 NOT NULL,
    PublishmentSystemDir        varchar(50)     DEFAULT '' NOT NULL,
    PublishmentSystemUrl        varchar(200)    DEFAULT '' NOT NULL,
    IsHeadquarters              varchar(18)     DEFAULT '' NOT NULL,
    SettingsXML                 ntext           DEFAULT '' NOT NULL,
    CONSTRAINT PK_siteserver_PublishmentSystem PRIMARY KEY CLUSTERED (PublishmentSystemID)
)
go



CREATE TABLE siteserver_PublishmentSystemPermissionsInRoles(
    RoleName               nvarchar(255)    NOT NULL,
    PublishmentSystemID    int              NOT NULL,
    NodeIDCollection       text             DEFAULT '' NOT NULL,
    ChannelPermissions     text             DEFAULT '' NOT NULL,
    WebsitePermissions     text             DEFAULT '' NOT NULL,
    CONSTRAINT PK_siteserver_PublishmentSystemPermissionsInRoles PRIMARY KEY CLUSTERED (RoleName, PublishmentSystemID)
)
go