siteserver_schema.sql

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

/*
 *ER/Studio 7.0 SQL Code Generation
 * Company :      BaiRong Software
 * Project :      BaiRong SiteServer CMS 2007
 * Author :       BaiRong Software
 *
 * Date Created : Saturday, June 02, 2007 09:57:25
 * Target DBMS : Microsoft SQL Server 2000
 */

CREATE TABLE bairong_AuxiliaryTableCollection(
    TableENName                  varchar(50)    NOT NULL,
    TableCNName                  varchar(50)    DEFAULT '' NOT NULL,
    AttributeNum                 int            DEFAULT 0 NOT NULL,
    AuxiliaryTableType           varchar(50)    DEFAULT '' NOT NULL,
    IsCreatedInDB                varchar(18)    DEFAULT '' NOT NULL,
    IsChangedAfterCreatedInDB    varchar(18)    DEFAULT '' NOT NULL,
    Description                  ntext          DEFAULT '' NOT NULL,
    CONSTRAINT PK_bairong_AuxiliaryTableCollection PRIMARY KEY CLUSTERED (TableENName)
)
go



CREATE TABLE bairong_AuxiliaryTableMetadata(
    TableMetadataID         int              IDENTITY(1,1),
    AuxiliaryTableENName    varchar(50)      NOT NULL,
    AttributeName           varchar(50)      DEFAULT '' NOT NULL,
    DataType                varchar(50)      DEFAULT '' NOT NULL,
    DataLength              int              DEFAULT 0 NOT NULL,
    CanBeNull               varchar(18)      DEFAULT '' NOT NULL,
    DBDefaultValue          nvarchar(255)    DEFAULT '' NOT NULL,
    DisplayName             varchar(50)      DEFAULT '' NOT NULL,
    InputType               varchar(50)      DEFAULT '' NOT NULL,
    InputDefaultValue       nvarchar(255)    DEFAULT '' NOT NULL,
    Taxis                   int              DEFAULT 0 NOT NULL,
    IsSystem                varchar(18)      DEFAULT '' NOT NULL,
    Description             ntext            DEFAULT '' NOT NULL,
    CONSTRAINT PK_bairong_AuxiliaryTableMetadata PRIMARY KEY CLUSTERED (TableMetadataID)
)
go



CREATE TABLE bairong_Cache(
    CacheKey      varchar(200)    NOT NULL,
    CacheValue    ntext           DEFAULT '' NOT NULL,
    CONSTRAINT PK_bairong_Cache PRIMARY KEY NONCLUSTERED (CacheKey)
)
go



CREATE TABLE bairong_Count(
    CountID             int              IDENTITY(1,1),
    ApplicationName     varchar(50)      DEFAULT '' NOT NULL,
    RelatedTableName    nvarchar(255)    DEFAULT '' NOT NULL,
    RelatedIdentity     nvarchar(255)    DEFAULT '' NOT NULL,
    CountType           varchar(50)      DEFAULT '' NOT NULL,
    CountNum            int              DEFAULT 0 NOT NULL,
    CONSTRAINT PK_bairong_Count PRIMARY KEY CLUSTERED (CountID)
)
go



CREATE TABLE bairong_Set(
    SetID              int              IDENTITY(1,1),
    SetName            nvarchar(255)    DEFAULT '' NOT NULL,
    ApplicationName    varchar(50)      DEFAULT '' NOT NULL,
    UserName           nvarchar(255)    DEFAULT '' NOT NULL,
    Taxis              int              DEFAULT 0 NOT NULL,
    Description        ntext            DEFAULT '' NOT NULL,
    CONSTRAINT PK_bairong_Set PRIMARY KEY CLUSTERED (SetID)
)
go



CREATE TABLE bairong_TableMatch(
    TableMatchID               int             IDENTITY(1,1),
    ConnectionString           varchar(200)    DEFAULT '' NOT NULL,
    TableName                  varchar(200)    DEFAULT '' NOT NULL,
    ConnectionStringToMatch    varchar(200)    DEFAULT '' NOT NULL,
    TableNameToMatch           varchar(200)    DEFAULT '' NOT NULL,
    ColumnsMap                 ntext           DEFAULT '' NOT NULL,
    CONSTRAINT PK_bairong_TableMatch PRIMARY KEY CLUSTERED (TableMatchID)
)
go



CREATE TABLE bairong_Tag(
    TagID               int              IDENTITY(1,1),
    TagName             nvarchar(255)    DEFAULT '' NOT NULL,
    ApplicationName     varchar(50)      DEFAULT '' NOT NULL,
    UserName            nvarchar(255)    DEFAULT '' NOT NULL,
    RelatedTableName    nvarchar(255)    DEFAULT '' NOT NULL,
    RelatedIdentity     nvarchar(255)    DEFAULT '' NOT NULL,
    CONSTRAINT PK_bairong_Tag PRIMARY KEY CLUSTERED (TagID)
)
go



CREATE TABLE bairong_TrackBack(
    TrackBackID         int              IDENTITY(1,1),
    ApplicationName     varchar(50)      DEFAULT '' NOT NULL,
    RelatedTableName    nvarchar(255)    DEFAULT '' NOT NULL,
    RelatedIdentity     nvarchar(255)    DEFAULT '' NOT NULL,
    Title               nvarchar(255)    DEFAULT '' NOT NULL,
    Excerpt             ntext            DEFAULT '' NOT NULL,
    Url                 nvarchar(255)    DEFAULT '' NOT NULL,
    SiteName            nvarchar(255)    DEFAULT '' NOT NULL,
    AddDate             datetime         DEFAULT getdate() NOT NULL,
    CONSTRAINT PK_bairong_TrackBack PRIMARY KEY CLUSTERED (TrackBackID)
)
go



CREATE TABLE bairong_Vote(
    VoteID                          int              IDENTITY(1,1),
    VoteName                        nvarchar(50)     DEFAULT '' NOT NULL,
    RelatedIdentity                 nvarchar(255)    DEFAULT '' NOT NULL,
    Title                           text             DEFAULT '' NOT NULL,
    VoteType                        varchar(50)      DEFAULT '' NOT NULL,
    VoteItemType                    varchar(50)      DEFAULT '' NOT NULL,
    MaxVoteItemNum                  int              DEFAULT 0 NOT NULL,
    VoteRestrictType                varchar(50)      DEFAULT '' NOT NULL,
    AuxiliaryTableForVoteComment    varchar(50)      DEFAULT '' NOT NULL,
    AddDate                         datetime         DEFAULT getdate() NOT NULL,
    CONSTRAINT PK_bairong_Vote PRIMARY KEY CLUSTERED (VoteID)
)
go



CREATE TABLE bairong_VoteIPAddress(
    VoteIPAddressID    int            IDENTITY(1,1),
    VoteID             int            NOT NULL,
    IPAddress          varchar(50)    DEFAULT '' NOT NULL,
    AddDate            datetime       DEFAULT getdate() NOT NULL,
    CONSTRAINT PK_bairong_VoteIPAddress PRIMARY KEY CLUSTERED (VoteIPAddressID)
)
go



CREATE TABLE bairong_VoteItem(
    VoteItemID       int              IDENTITY(1,1),
    VoteID           int              NOT NULL,
    ItemTitle        nvarchar(255)    DEFAULT '' NOT NULL,
    ItemImageUrl     varchar(200)     DEFAULT '' NOT NULL,
    NavigationUrl    varchar(200)     DEFAULT '' NOT NULL,
    DisplayColor     varchar(50)      DEFAULT '' NOT NULL,
    VoteNum          int              DEFAULT 0 NOT NULL,
    CONSTRAINT PK_bairong_VoteItem PRIMARY KEY CLUSTERED (VoteItemID)
)
go



CREATE TABLE siteserver_Advertisement(
    AdvertisementName      varchar(50)     NOT NULL,
    PublishmentSystemID    int             DEFAULT 0 NOT NULL,
    AdvertisementType      varchar(50)     DEFAULT '' NOT NULL,
    NavigationUrl          varchar(200)    DEFAULT '' NOT NULL,
    IsDateLimited          varchar(18)     DEFAULT '' NOT NULL,
    StartDate              datetime        DEFAULT getdate() NOT NULL,
    EndDate                datetime        DEFAULT getdate() NOT NULL,
    AddDate                datetime        DEFAULT getdate() NOT NULL,
    Description            ntext           DEFAULT '' NOT NULL,
    CONSTRAINT PK_siteserver_Advertisement PRIMARY KEY CLUSTERED (AdvertisementName, PublishmentSystemID)
)
go



CREATE TABLE siteserver_AdvertisementFloat(
    AdvertisementName      varchar(50)      NOT NULL,
    PublishmentSystemID    int              DEFAULT 0 NOT NULL,
    IsCloseable            varchar(18)      DEFAULT '' NOT NULL,
    IsRightSide            varchar(18)      DEFAULT '' NOT NULL,
    OffsetBottom           int              DEFAULT 0 NOT NULL,
    OffsetLeft             int              DEFAULT 0 NOT NULL,
    OffsetRight            int              DEFAULT 0 NOT NULL,
    RollingType            varchar(50)      DEFAULT '' NOT NULL,
    MediaType              varchar(50)      DEFAULT '' NOT NULL,
    MediaUrl               varchar(200)     DEFAULT '' NOT NULL,
    Height                 int              DEFAULT 0 NOT NULL,
    Width                  int              DEFAULT 0 NOT NULL,
    Title                  nvarchar(255)    DEFAULT '' NOT NULL,
    Summary                nvarchar(255)    DEFAULT '' NOT NULL,
    ToolTip                nvarchar(255)    DEFAULT '' NOT NULL,
    Content                ntext            DEFAULT '' NOT NULL,
    CONSTRAINT PK_siteserver_AdvertisementFloat PRIMARY KEY CLUSTERED (AdvertisementName, PublishmentSystemID)
)
go



CREATE TABLE siteserver_AdvertisementGroup(
    GroupName              varchar(50)    NOT NULL,
    PublishmentSystemID    int            DEFAULT 0 NOT NULL,
    CONSTRAINT PK_siteserver_AdvertisementGroup PRIMARY KEY CLUSTERED (GroupName, PublishmentSystemID)
)
go



CREATE TABLE siteserver_AdvertisementGroupsInTemplates(
    GroupName              varchar(50)    NOT NULL,
    PublishmentSystemID    int            DEFAULT 0 NOT NULL,
    TemplateID             int            NOT NULL,
    CONSTRAINT PK_siteserver_AdvertisementGroupsInTemplates PRIMARY KEY CLUSTERED (GroupName, PublishmentSystemID, TemplateID)
)
go



CREATE TABLE siteserver_AdvertisementNewWindow(
    AdvertisementName      varchar(50)     NOT NULL,
    PublishmentSystemID    int             DEFAULT 0 NOT NULL,
    GeneratedFilePath      varchar(200)    DEFAULT '' NOT NULL,
    CONSTRAINT PK_siteserver_AdvertisementNewWindow PRIMARY KEY CLUSTERED (AdvertisementName, PublishmentSystemID)
)
go



CREATE TABLE siteserver_AdvertisementsInGroups(
    AdvertisementName      varchar(50)    NOT NULL,
    GroupName              varchar(50)    NOT NULL,
    PublishmentSystemID    int            DEFAULT 0 NOT NULL,
    Taxis                  int            DEFAULT 0 NOT NULL,
    CONSTRAINT PK_siteserver_AdvertisementsInGroups PRIMARY KEY CLUSTERED (AdvertisementName, GroupName, PublishmentSystemID)
)
go



CREATE TABLE siteserver_BackgroundNode(
    NodeID               int             NOT NULL,
    LinkUrl              varchar(200)    DEFAULT '' NOT NULL,
    LinkType             varchar(200)    DEFAULT '' NOT NULL,
    ChannelTemplateID    int             DEFAULT 0 NOT NULL,
    ContentTemplateID    int             DEFAULT 0 NOT NULL,
    CanAddChannel        varchar(18)     DEFAULT '' NOT NULL,
    CanAddContent        varchar(18)     DEFAULT '' NOT NULL,
    GeneratedFilePath    varchar(200)    DEFAULT '' NOT NULL,
    CanRemark            varchar(18)     DEFAULT '' NOT NULL,
    CONSTRAINT PK_siteserver_BackgroundNode PRIMARY KEY CLUSTERED (NodeID)
)
go



CREATE TABLE siteserver_Configuration(
    IsSystemDataSetup    varchar(18)     DEFAULT '' NOT NULL,
    ChannelDir           varchar(50)     DEFAULT '' NOT NULL,
    ContentDir           varchar(50)     DEFAULT '' NOT NULL,
    RootUrl              varchar(200)    DEFAULT '' NOT NULL,
    DatabaseVersion      varchar(50)     DEFAULT '' NOT NULL,
    SettingsXML          ntext           DEFAULT '' NOT NULL