📄 mssql.sql

📁 找了很久才找到到源代码
💻 SQL
字号:
CREATE TABLE CMS_MODULE_ONLINE_MASTER (
    MASTER_ID NVARCHAR(36) NOT NULL,
    SUB_ID BIGINT NOT NULL,
    USER_ID NVARCHAR(36) NOT NULL,
    GROUP_ID NVARCHAR(36) NOT NULL,
    PROJECT_ID BIGINT NOT NULL,
    ACCESS_FLAGS BIGINT NOT NULL,
    STATE BIGINT NOT NULL,
    LOCKED_BY NVARCHAR(36) NOT NULL,
    LASTMODIFIED_BY NVARCHAR(36) NOT NULL,
    DATE_CREATED DATETIME NOT NULL,
    DATE_LASTMODIFIED DATETIME NOT NULL,
    PUBLICATION_DATE DATETIME,
    PURGE_DATE DATETIME,
    FLAGS BIGINT,
    FEED_ID BIGINT,
    FEED_REFERENCE BIGINT,
    FEED_FILENAME NVARCHAR(255),
    TITLE NVARCHAR(255),
    DATA_BIG_0 NVARCHAR(4000),
    DATA_BIG_1 NVARCHAR(4000),
    DATA_BIG_2 NVARCHAR(4000),
    DATA_BIG_3 NVARCHAR(4000),
    DATA_BIG_4 NVARCHAR(4000),
    DATA_BIG_5 NVARCHAR(4000),
    DATA_BIG_6 NVARCHAR(4000),
    DATA_BIG_7 NVARCHAR(4000),
    DATA_BIG_8 NVARCHAR(4000),
    DATA_BIG_9 NVARCHAR(4000),
    DATA_MEDIUM_0 NVARCHAR(2000),
    DATA_MEDIUM_1 NVARCHAR(2000),
    DATA_MEDIUM_2 NVARCHAR(2000),
    DATA_MEDIUM_3 NVARCHAR(2000),
    DATA_MEDIUM_4 NVARCHAR(2000),
    DATA_MEDIUM_5 NVARCHAR(2000),
    DATA_MEDIUM_6 NVARCHAR(2000),
    DATA_MEDIUM_7 NVARCHAR(2000),
    DATA_MEDIUM_8 NVARCHAR(2000),
    DATA_MEDIUM_9 NVARCHAR(2000),
    DATA_SMALL_0 NVARCHAR(500),
    DATA_SMALL_1 NVARCHAR(500),
    DATA_SMALL_2 NVARCHAR(500),
    DATA_SMALL_3 NVARCHAR(500),
    DATA_SMALL_4 NVARCHAR(500),
    DATA_SMALL_5 NVARCHAR(500),
    DATA_SMALL_6 NVARCHAR(500),
    DATA_SMALL_7 NVARCHAR(500),
    DATA_SMALL_8 NVARCHAR(500),
    DATA_SMALL_9 NVARCHAR(500),
    DATA_SMALL_10 NVARCHAR(500),
    DATA_SMALL_11 NVARCHAR(500),
    DATA_SMALL_12 NVARCHAR(500),
    DATA_SMALL_13 NVARCHAR(500),
    DATA_SMALL_14 NVARCHAR(500),
    DATA_SMALL_15 NVARCHAR(500),
    DATA_SMALL_16 NVARCHAR(500),
    DATA_SMALL_17 NVARCHAR(500),
    DATA_SMALL_18 NVARCHAR(500),
    DATA_SMALL_19 NVARCHAR(500),
    DATA_SMALL_20 NVARCHAR(500),
    DATA_SMALL_21 NVARCHAR(500),
    DATA_SMALL_22 NVARCHAR(500),
    DATA_SMALL_23 NVARCHAR(500),
    DATA_SMALL_24 NVARCHAR(500),
    DATA_SMALL_25 NVARCHAR(500),
    DATA_SMALL_26 NVARCHAR(500),
    DATA_SMALL_27 NVARCHAR(500),
    DATA_SMALL_28 NVARCHAR(500),
    DATA_SMALL_29 NVARCHAR(500),
    DATA_SMALL_30 NVARCHAR(500),
    DATA_SMALL_31 NVARCHAR(500),
    DATA_SMALL_32 NVARCHAR(500),
    DATA_SMALL_33 NVARCHAR(500),
    DATA_SMALL_34 NVARCHAR(500),
    DATA_SMALL_35 NVARCHAR(500),
    DATA_SMALL_36 NVARCHAR(500),
    DATA_SMALL_37 NVARCHAR(500),
    DATA_SMALL_38 NVARCHAR(500),
    DATA_SMALL_39 NVARCHAR(500),
    DATA_INT_0 BIGINT,
    DATA_INT_1 BIGINT,
    DATA_INT_2 BIGINT,
    DATA_INT_3 BIGINT,
    DATA_INT_4 BIGINT,
    DATA_INT_5 BIGINT,
    DATA_INT_6 BIGINT,
    DATA_INT_7 BIGINT,
    DATA_INT_8 BIGINT,
    DATA_INT_9 BIGINT,
    DATA_REFERENCE_0 BIGINT,
    DATA_REFERENCE_1 BIGINT,
    DATA_REFERENCE_2 BIGINT,
    DATA_REFERENCE_3 BIGINT,
    DATA_REFERENCE_4 BIGINT,
    DATA_REFERENCE_5 BIGINT,
    DATA_REFERENCE_6 BIGINT,
    DATA_REFERENCE_7 BIGINT,
    DATA_REFERENCE_8 BIGINT,
    DATA_REFERENCE_9 BIGINT,
    DATA_DATE_0 DATETIME,
    DATA_DATE_1 DATETIME,
    DATA_DATE_2 DATETIME,
    DATA_DATE_3 DATETIME,
    DATA_DATE_4 DATETIME,
    PRIMARY KEY(MASTER_ID)
);
                                         
CREATE TABLE CMS_MODULE_ONLINE_CHANNEL_REL (
    MASTER_ID NVARCHAR(36) NOT NULL,
    CHANNEL_ID NVARCHAR(36) NOT NULL,
    CHANNEL_NAME NVARCHAR(1024) NOT NULL,
    PRIMARY KEY(CHANNEL_ID, MASTER_ID)
);

CREATE TABLE CMS_MODULE_ONLINE_MEDIA (
    MEDIA_ID BIGINT NOT NULL,
    MASTER_ID NVARCHAR(36) NOT NULL,
    MEDIA_POSITION BIGINT NOT NULL,
    MEDIA_WIDTH BIGINT NOT NULL,
    MEDIA_HEIGHT BIGINT NOT NULL,
    MEDIA_SIZE BIGINT NOT NULL,
    MEDIA_MIMETYPE NVARCHAR(255),
    MEDIA_TYPE BIGINT NOT NULL,
    MEDIA_TITLE NVARCHAR(255),
    MEDIA_NAME NVARCHAR(255),
    MEDIA_DESCRIPTION NVARCHAR(500) NOT NULL,
    MEDIA IMAGE NOT NULL,
    PRIMARY KEY(MEDIA_ID)
);
                                         
CREATE TABLE CMS_MODULE_MASTER (
    MASTER_ID NVARCHAR(36) NOT NULL,
    SUB_ID BIGINT NOT NULL,
    USER_ID NVARCHAR(36) NOT NULL,
    GROUP_ID NVARCHAR(36) NOT NULL,
    PROJECT_ID BIGINT NOT NULL,
    ACCESS_FLAGS BIGINT NOT NULL,
    STATE BIGINT NOT NULL,
    LOCKED_BY NVARCHAR(36) NOT NULL,
    LASTMODIFIED_BY NVARCHAR(36) NOT NULL,
    DATE_CREATED DATETIME NOT NULL,
    DATE_LASTMODIFIED DATETIME NOT NULL,
    PUBLICATION_DATE DATETIME,
    PURGE_DATE DATETIME,
    FLAGS BIGINT,
    FEED_ID BIGINT,
    FEED_REFERENCE BIGINT,
    FEED_FILENAME NVARCHAR(255),
    TITLE NVARCHAR(255),
    DATA_BIG_0 NVARCHAR(4000),
    DATA_BIG_1 NVARCHAR(4000),
    DATA_BIG_2 NVARCHAR(4000),
    DATA_BIG_3 NVARCHAR(4000),
    DATA_BIG_4 NVARCHAR(4000),
    DATA_BIG_5 NVARCHAR(4000),
    DATA_BIG_6 NVARCHAR(4000),
    DATA_BIG_7 NVARCHAR(4000),
    DATA_BIG_8 NVARCHAR(4000),
    DATA_BIG_9 NVARCHAR(4000),
    DATA_MEDIUM_0 NVARCHAR(2000),
    DATA_MEDIUM_1 NVARCHAR(2000),
    DATA_MEDIUM_2 NVARCHAR(2000),
    DATA_MEDIUM_3 NVARCHAR(2000),
    DATA_MEDIUM_4 NVARCHAR(2000),
    DATA_MEDIUM_5 NVARCHAR(2000),
    DATA_MEDIUM_6 NVARCHAR(2000),
    DATA_MEDIUM_7 NVARCHAR(2000),
    DATA_MEDIUM_8 NVARCHAR(2000),
    DATA_MEDIUM_9 NVARCHAR(2000),
    DATA_SMALL_0 NVARCHAR(500),
    DATA_SMALL_1 NVARCHAR(500),
    DATA_SMALL_2 NVARCHAR(500),
    DATA_SMALL_3 NVARCHAR(500),
    DATA_SMALL_4 NVARCHAR(500),
    DATA_SMALL_5 NVARCHAR(500),
    DATA_SMALL_6 NVARCHAR(500),
    DATA_SMALL_7 NVARCHAR(500),
    DATA_SMALL_8 NVARCHAR(500),
    DATA_SMALL_9 NVARCHAR(500),
    DATA_SMALL_10 NVARCHAR(500),
    DATA_SMALL_11 NVARCHAR(500),
    DATA_SMALL_12 NVARCHAR(500),
    DATA_SMALL_13 NVARCHAR(500),
    DATA_SMALL_14 NVARCHAR(500),
    DATA_SMALL_15 NVARCHAR(500),
    DATA_SMALL_16 NVARCHAR(500),
    DATA_SMALL_17 NVARCHAR(500),
    DATA_SMALL_18 NVARCHAR(500),
    DATA_SMALL_19 NVARCHAR(500),
    DATA_SMALL_20 NVARCHAR(500),
    DATA_SMALL_21 NVARCHAR(500),
    DATA_SMALL_22 NVARCHAR(500),
    DATA_SMALL_23 NVARCHAR(500),
    DATA_SMALL_24 NVARCHAR(500),
    DATA_SMALL_25 NVARCHAR(500),
    DATA_SMALL_26 NVARCHAR(500),
    DATA_SMALL_27 NVARCHAR(500),
    DATA_SMALL_28 NVARCHAR(500),
    DATA_SMALL_29 NVARCHAR(500),
    DATA_SMALL_30 NVARCHAR(500),
    DATA_SMALL_31 NVARCHAR(500),
    DATA_SMALL_32 NVARCHAR(500),
    DATA_SMALL_33 NVARCHAR(500),
    DATA_SMALL_34 NVARCHAR(500),
    DATA_SMALL_35 NVARCHAR(500),
    DATA_SMALL_36 NVARCHAR(500),
    DATA_SMALL_37 NVARCHAR(500),
    DATA_SMALL_38 NVARCHAR(500),
    DATA_SMALL_39 NVARCHAR(500),
    DATA_INT_0 BIGINT,
    DATA_INT_1 BIGINT,
    DATA_INT_2 BIGINT,
    DATA_INT_3 BIGINT,
    DATA_INT_4 BIGINT,
    DATA_INT_5 BIGINT,
    DATA_INT_6 BIGINT,
    DATA_INT_7 BIGINT,
    DATA_INT_8 BIGINT,
    DATA_INT_9 BIGINT,
    DATA_REFERENCE_0 BIGINT,
    DATA_REFERENCE_1 BIGINT,
    DATA_REFERENCE_2 BIGINT,
    DATA_REFERENCE_3 BIGINT,
    DATA_REFERENCE_4 BIGINT,
    DATA_REFERENCE_5 BIGINT,
    DATA_REFERENCE_6 BIGINT,
    DATA_REFERENCE_7 BIGINT,
    DATA_REFERENCE_8 BIGINT,
    DATA_REFERENCE_9 BIGINT,
    DATA_DATE_0 DATETIME,
    DATA_DATE_1 DATETIME,
    DATA_DATE_2 DATETIME,
    DATA_DATE_3 DATETIME,
    DATA_DATE_4 DATETIME,
    PRIMARY KEY(MASTER_ID)
);

CREATE TABLE CMS_MODULE_CHANNEL_REL (
    MASTER_ID NVARCHAR(36) NOT NULL,
    CHANNEL_ID NVARCHAR(36) NOT NULL,
    CHANNEL_NAME NVARCHAR(1024) NOT NULL,
    PRIMARY KEY(CHANNEL_ID, MASTER_ID)
);


CREATE TABLE CMS_MODULE_MEDIA (
    MEDIA_ID BIGINT NOT NULL,
    MASTER_ID NVARCHAR(36) NOT NULL,
    MEDIA_POSITION BIGINT NOT NULL,
    MEDIA_WIDTH BIGINT NOT NULL,
    MEDIA_HEIGHT BIGINT NOT NULL,
    MEDIA_SIZE BIGINT NOT NULL,
    MEDIA_MIMETYPE NVARCHAR(255),
    MEDIA_TYPE BIGINT NOT NULL,
    MEDIA_TITLE NVARCHAR(255),
    MEDIA_NAME NVARCHAR(255),
    MEDIA_DESCRIPTION NVARCHAR(500) NOT NULL,
    MEDIA IMAGE NOT NULL,
    PRIMARY KEY(MEDIA_ID)
);

CREATE TABLE CMS_MODULE_BACKUP_MASTER (
    MASTER_ID NVARCHAR(36) NOT NULL,
    SUB_ID BIGINT NOT NULL,
    USER_ID NVARCHAR(36) NOT NULL,
    GROUP_ID NVARCHAR(36) NOT NULL,
    PROJECT_ID BIGINT NOT NULL,
    ACCESS_FLAGS BIGINT NOT NULL,
    STATE BIGINT NOT NULL,
    LOCKED_BY NVARCHAR(36) NOT NULL,
    LASTMODIFIED_BY NVARCHAR(36) NOT NULL,
    DATE_CREATED DATETIME NOT NULL,
    DATE_LASTMODIFIED DATETIME NOT NULL,
    PUBLICATION_DATE DATETIME,
    PURGE_DATE DATETIME,
    FLAGS BIGINT,
    FEED_ID BIGINT,
    FEED_REFERENCE BIGINT,
    FEED_FILENAME NVARCHAR(255),
    TITLE NVARCHAR(255),
    DATA_BIG_0 NVARCHAR(4000),
    DATA_BIG_1 NVARCHAR(4000),
    DATA_BIG_2 NVARCHAR(4000),
    DATA_BIG_3 NVARCHAR(4000),
    DATA_BIG_4 NVARCHAR(4000),
    DATA_BIG_5 NVARCHAR(4000),
    DATA_BIG_6 NVARCHAR(4000),
    DATA_BIG_7 NVARCHAR(4000),
    DATA_BIG_8 NVARCHAR(4000),
    DATA_BIG_9 NVARCHAR(4000),
    DATA_MEDIUM_0 NVARCHAR(2000),
    DATA_MEDIUM_1 NVARCHAR(2000),
    DATA_MEDIUM_2 NVARCHAR(2000),
    DATA_MEDIUM_3 NVARCHAR(2000),
    DATA_MEDIUM_4 NVARCHAR(2000),
    DATA_MEDIUM_5 NVARCHAR(2000),
    DATA_MEDIUM_6 NVARCHAR(2000),
    DATA_MEDIUM_7 NVARCHAR(2000),
    DATA_MEDIUM_8 NVARCHAR(2000),
    DATA_MEDIUM_9 NVARCHAR(2000),
    DATA_SMALL_0 NVARCHAR(500),
    DATA_SMALL_1 NVARCHAR(500),
    DATA_SMALL_2 NVARCHAR(500),
    DATA_SMALL_3 NVARCHAR(500),
    DATA_SMALL_4 NVARCHAR(500),
    DATA_SMALL_5 NVARCHAR(500),
    DATA_SMALL_6 NVARCHAR(500),
    DATA_SMALL_7 NVARCHAR(500),
    DATA_SMALL_8 NVARCHAR(500),
    DATA_SMALL_9 NVARCHAR(500),
    DATA_SMALL_10 NVARCHAR(500),
    DATA_SMALL_11 NVARCHAR(500),
    DATA_SMALL_12 NVARCHAR(500),
    DATA_SMALL_13 NVARCHAR(500),
    DATA_SMALL_14 NVARCHAR(500),
    DATA_SMALL_15 NVARCHAR(500),
    DATA_SMALL_16 NVARCHAR(500),
    DATA_SMALL_17 NVARCHAR(500),
    DATA_SMALL_18 NVARCHAR(500),
    DATA_SMALL_19 NVARCHAR(500),
    DATA_SMALL_20 NVARCHAR(500),
    DATA_SMALL_21 NVARCHAR(500),
    DATA_SMALL_22 NVARCHAR(500),
    DATA_SMALL_23 NVARCHAR(500),
    DATA_SMALL_24 NVARCHAR(500),
    DATA_SMALL_25 NVARCHAR(500),
    DATA_SMALL_26 NVARCHAR(500),
    DATA_SMALL_27 NVARCHAR(500),
    DATA_SMALL_28 NVARCHAR(500),
    DATA_SMALL_29 NVARCHAR(500),
    DATA_SMALL_30 NVARCHAR(500),
    DATA_SMALL_31 NVARCHAR(500),
    DATA_SMALL_32 NVARCHAR(500),
    DATA_SMALL_33 NVARCHAR(500),
    DATA_SMALL_34 NVARCHAR(500),
    DATA_SMALL_35 NVARCHAR(500),
    DATA_SMALL_36 NVARCHAR(500),
    DATA_SMALL_37 NVARCHAR(500),
    DATA_SMALL_38 NVARCHAR(500),
    DATA_SMALL_39 NVARCHAR(500),
    DATA_INT_0 BIGINT,
    DATA_INT_1 BIGINT,
    DATA_INT_2 BIGINT,
    DATA_INT_3 BIGINT,
    DATA_INT_4 BIGINT,
    DATA_INT_5 BIGINT,
    DATA_INT_6 BIGINT,
    DATA_INT_7 BIGINT,
    DATA_INT_8 BIGINT,
    DATA_INT_9 BIGINT,
    DATA_REFERENCE_0 BIGINT,
    DATA_REFERENCE_1 BIGINT,
    DATA_REFERENCE_2 BIGINT,
    DATA_REFERENCE_3 BIGINT,
    DATA_REFERENCE_4 BIGINT,
    DATA_REFERENCE_5 BIGINT,
    DATA_REFERENCE_6 BIGINT,
    DATA_REFERENCE_7 BIGINT,
    DATA_REFERENCE_8 BIGINT,
    DATA_REFERENCE_9 BIGINT,
    DATA_DATE_0 DATETIME,
    DATA_DATE_1 DATETIME,
    DATA_DATE_2 DATETIME,
    DATA_DATE_3 DATETIME,
    DATA_DATE_4 DATETIME,
    VERSION_ID BIGINT NOT NULL,
    USER_NAME VARCHAR(167),
    GROUP_NAME VARCHAR(64),
    LASTMODIFIED_BY_NAME VARCHAR(167),
    PRIMARY KEY(MASTER_ID, TAG_ID)
);

CREATE TABLE CMS_MODULE_BACKUP_MEDIA (
    MEDIA_ID BIGINT NOT NULL,
    MASTER_ID NVARCHAR(36) NOT NULL,
    MEDIA_POSITION BIGINT NOT NULL,
    MEDIA_WIDTH BIGINT NOT NULL,
    MEDIA_HEIGHT BIGINT NOT NULL,
    MEDIA_SIZE BIGINT NOT NULL,
    MEDIA_MIMETYPE NVARCHAR(255),
    MEDIA_TYPE BIGINT NOT NULL,
    MEDIA_TITLE NVARCHAR(255),
    MEDIA_NAME NVARCHAR(255),
    MEDIA_DESCRIPTION NVARCHAR(500) NOT NULL,
    MEDIA IMAGE NOT NULL,
    TAG_ID BIGINT NOT NULL,
    PRIMARY KEY(MEDIA_ID, TAG_ID)
);

CREATE NONCLUSTERED INDEX MASTER_SUBID 
    ON CMS_MODULE_MASTER
    (SUB_ID);
    
CREATE NONCLUSTERED INDEX ONLINEMASTER_SUBID 
    ON CMS_MODULE_ONLINE_MASTER
    (SUB_ID);
  
CREATE NONCLUSTERED INDEX ONLINEMEDIA_MASTERID 
    ON CMS_MODULE_ONLINE_MEDIA
    (MASTER_ID);

CREATE NONCLUSTERED INDEX MEDIA_MASTERID 
    ON CMS_MODULE_MEDIA
    (MASTER_ID);
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -