?? create_tables.sql
字號:
SIBLING_COUNT INT NOT NULL,
PRIMARY KEY (HISTORY_ID, PUBLISH_TAG, STRUCTURE_ID, RESOURCE_PATH(255)),
INDEX PUBLISH_TAG_IDX (PUBLISH_TAG),
INDEX HISTORY_ID_IDX (HISTORY_ID)
);
CREATE TABLE CMS_PUBLISH_JOBS (
HISTORY_ID VARCHAR(36) BINARY NOT NULL,
PROJECT_ID VARCHAR(36) NOT NULL,
PROJECT_NAME VARCHAR(255) BINARY NOT NULL,
USER_ID VARCHAR(36) BINARY NOT NULL,
PUBLISH_LOCALE VARCHAR(16) BINARY NOT NULL,
PUBLISH_FLAGS INT NOT NULL,
PUBLISH_LIST LONGBLOB,
PUBLISH_REPORT LONGBLOB,
RESOURCE_COUNT INT NOT NULL,
ENQUEUE_TIME BIGINT NOT NULL,
START_TIME BIGINT NOT NULL,
FINISH_TIME BIGINT NOT NULL,
PRIMARY KEY (HISTORY_ID)
);
CREATE TABLE CMS_RESOURCE_LOCKS (
RESOURCE_PATH BLOB NOT NULL,
USER_ID VARCHAR(36) NOT NULL,
PROJECT_ID VARCHAR(36) NOT NULL,
LOCK_TYPE INT NOT NULL,
INDEX RESOURCE_LOCKS_IDX (RESOURCE_PATH(255))
);
CREATE TABLE CMS_STATICEXPORT_LINKS (
LINK_ID VARCHAR(36) BINARY NOT NULL,
LINK_RFS_PATH BLOB NOT NULL,
LINK_TYPE INT NOT NULL,
LINK_PARAMETER BLOB,
LINK_TIMESTAMP BIGINT,
PRIMARY KEY (LINK_ID),
INDEX LINK_RFS_PATH_IDX (LINK_RFS_PATH(255))
);
CREATE TABLE CMS_OFFLINE_STRUCTURE (
STRUCTURE_ID VARCHAR(36) BINARY NOT NULL,
RESOURCE_ID VARCHAR(36) BINARY NOT NULL,
PARENT_ID VARCHAR(36) BINARY NOT NULL,
RESOURCE_PATH BLOB NOT NULL,
STRUCTURE_STATE SMALLINT UNSIGNED NOT NULL,
DATE_RELEASED BIGINT NOT NULL,
DATE_EXPIRED BIGINT NOT NULL,
STRUCTURE_VERSION INT NOT NULL,
PRIMARY KEY (STRUCTURE_ID),
INDEX STRUCTURE_ID_RESOURCE_PATH_IDX (STRUCTURE_ID, RESOURCE_PATH(255)),
INDEX RESOURCE_PATH_RESOURCE_ID_IDX (RESOURCE_PATH(255), RESOURCE_ID),
INDEX STRUCTURE_ID_RESOURCE_ID_IDX (STRUCTURE_ID, RESOURCE_ID),
INDEX STRUCTURE_STATE_IDX (STRUCTURE_STATE),
INDEX PARENT_ID_IDX (PARENT_ID),
INDEX RESOURCE_PATH_IDX (RESOURCE_PATH(255)),
INDEX RESOURCE_ID_IDX (RESOURCE_ID)
);
CREATE TABLE CMS_ONLINE_STRUCTURE (
STRUCTURE_ID VARCHAR(36) BINARY NOT NULL,
RESOURCE_ID VARCHAR(36) BINARY NOT NULL,
PARENT_ID VARCHAR(36) BINARY NOT NULL,
RESOURCE_PATH BLOB NOT NULL,
STRUCTURE_STATE SMALLINT UNSIGNED NOT NULL,
DATE_RELEASED BIGINT NOT NULL,
DATE_EXPIRED BIGINT NOT NULL,
STRUCTURE_VERSION INT NOT NULL,
PRIMARY KEY (STRUCTURE_ID),
INDEX STRUCTURE_ID_RESOURCE_PATH_IDX (STRUCTURE_ID, RESOURCE_PATH(255)),
INDEX RESOURCE_PATH_RESOURCE_ID_IDX (RESOURCE_PATH(255), RESOURCE_ID),
INDEX STRUCTURE_ID_RESOURCE_ID_IDX (STRUCTURE_ID, RESOURCE_ID),
INDEX STRUCTURE_STATE_IDX (STRUCTURE_STATE),
INDEX PARENT_ID_IDX (PARENT_ID),
INDEX RESOURCE_PATH_IDX (RESOURCE_PATH(255)),
INDEX RESOURCE_ID_IDX (RESOURCE_ID)
);
CREATE TABLE CMS_HISTORY_STRUCTURE (
PUBLISH_TAG INT NOT NULL,
VERSION INT NOT NULL,
STRUCTURE_ID VARCHAR(36) BINARY NOT NULL,
RESOURCE_ID VARCHAR(36) BINARY NOT NULL,
PARENT_ID VARCHAR(36) BINARY NOT NULL,
RESOURCE_PATH BLOB NOT NULL,
STRUCTURE_STATE SMALLINT UNSIGNED NOT NULL,
DATE_RELEASED BIGINT NOT NULL,
DATE_EXPIRED BIGINT NOT NULL,
STRUCTURE_VERSION INT NOT NULL,
PRIMARY KEY (STRUCTURE_ID,PUBLISH_TAG,VERSION),
INDEX STRUCTURE_ID_IDX (STRUCTURE_ID),
INDEX RESOURCE_PATH_IDX (RESOURCE_PATH(255)),
INDEX PUBLISH_TAG_IDX (PUBLISH_TAG),
INDEX VERSION_IDX (VERSION)
);
CREATE TABLE CMS_OFFLINE_RESOURCES (
RESOURCE_ID VARCHAR(36) BINARY NOT NULL,
RESOURCE_TYPE INT NOT NULL,
RESOURCE_FLAGS INT NOT NULL,
RESOURCE_STATE SMALLINT UNSIGNED NOT NULL,
RESOURCE_SIZE INT NOT NULL,
DATE_CONTENT BIGINT NOT NULL,
SIBLING_COUNT INT NOT NULL,
DATE_CREATED BIGINT NOT NULL,
DATE_LASTMODIFIED BIGINT NOT NULL,
USER_CREATED VARCHAR(36) BINARY NOT NULL,
USER_LASTMODIFIED VARCHAR(36) BINARY NOT NULL,
PROJECT_LASTMODIFIED VARCHAR(36) NULL,
RESOURCE_VERSION INT NOT NULL,
PRIMARY KEY(RESOURCE_ID),
INDEX PROJECT_LASTMODIFIED_IDX (PROJECT_LASTMODIFIED),
INDEX PROJECT_LASTMODIFIED_RESOURCE_SIZE_IDX (PROJECT_LASTMODIFIED, RESOURCE_SIZE),
INDEX RESOURCE_SIZE_IDX (RESOURCE_SIZE),
INDEX DATE_LASTMODIFIED_IDX (DATE_LASTMODIFIED),
INDEX RESOURCE_TYPE_IDX (RESOURCE_TYPE)
);
CREATE TABLE CMS_ONLINE_RESOURCES (
RESOURCE_ID VARCHAR(36) BINARY NOT NULL,
RESOURCE_TYPE INT NOT NULL,
RESOURCE_FLAGS INT NOT NULL,
RESOURCE_STATE SMALLINT UNSIGNED NOT NULL,
RESOURCE_SIZE INT NOT NULL,
DATE_CONTENT BIGINT NOT NULL,
SIBLING_COUNT INT NOT NULL,
DATE_CREATED BIGINT NOT NULL,
DATE_LASTMODIFIED BIGINT NOT NULL,
USER_CREATED VARCHAR(36) BINARY NOT NULL,
USER_LASTMODIFIED VARCHAR(36) BINARY NOT NULL,
PROJECT_LASTMODIFIED VARCHAR(36) NULL,
RESOURCE_VERSION INT NOT NULL,
PRIMARY KEY(RESOURCE_ID),
INDEX PROJECT_LASTMODIFIED_IDX (PROJECT_LASTMODIFIED),
INDEX PROJECT_LASTMODIFIED_RESOURCE_SIZE_IDX (PROJECT_LASTMODIFIED, RESOURCE_SIZE),
INDEX RESOURCE_SIZE_IDX (RESOURCE_SIZE),
INDEX DATE_LASTMODIFIED_IDX (DATE_LASTMODIFIED),
INDEX RESOURCE_TYPE_IDX (RESOURCE_TYPE)
);
CREATE TABLE CMS_HISTORY_RESOURCES (
RESOURCE_ID VARCHAR(36) BINARY NOT NULL,
RESOURCE_TYPE INT NOT NULL,
RESOURCE_FLAGS INT NOT NULL,
RESOURCE_STATE SMALLINT UNSIGNED NOT NULL,
RESOURCE_SIZE INT NOT NULL,
DATE_CONTENT BIGINT NOT NULL,
SIBLING_COUNT INT NOT NULL,
DATE_CREATED BIGINT NOT NULL,
DATE_LASTMODIFIED BIGINT NOT NULL,
USER_CREATED VARCHAR(36) BINARY NOT NULL,
USER_LASTMODIFIED VARCHAR(36) BINARY NOT NULL,
PROJECT_LASTMODIFIED VARCHAR(36) NULL,
PUBLISH_TAG INT NOT NULL,
RESOURCE_VERSION INT NOT NULL,
PRIMARY KEY (RESOURCE_ID,PUBLISH_TAG),
INDEX RESOURCE_ID_IDX (RESOURCE_ID),
INDEX PUBLISH_TAG_IDX (PUBLISH_TAG)
);
CREATE TABLE CMS_OFFLINE_CONTENTS (
RESOURCE_ID VARCHAR(36) BINARY NOT NULL,
FILE_CONTENT LONGBLOB NOT NULL,
PRIMARY KEY(RESOURCE_ID)
);
CREATE TABLE CMS_CONTENTS (
RESOURCE_ID VARCHAR(36) BINARY NOT NULL,
FILE_CONTENT LONGBLOB NOT NULL,
PUBLISH_TAG_FROM INT,
PUBLISH_TAG_TO INT,
ONLINE_FLAG INT,
PRIMARY KEY (RESOURCE_ID, PUBLISH_TAG_FROM),
UNIQUE INDEX CONTENTS_IDX (RESOURCE_ID, PUBLISH_TAG_TO),
INDEX RESOURCE_ID_IDX (RESOURCE_ID),
INDEX PUBLISH_TAG_FROM_IDX (PUBLISH_TAG_FROM),
INDEX PUBLISH_TAG_TO_IDX (PUBLISH_TAG_TO),
INDEX ONLINE_IDX (RESOURCE_ID, ONLINE_FLAG)
);
CREATE TABLE CMS_ONLINE_RESOURCE_RELATIONS (
RELATION_SOURCE_ID VARCHAR(36) BINARY NOT NULL,
RELATION_SOURCE_PATH BLOB NOT NULL,
RELATION_TARGET_ID VARCHAR(36) BINARY NOT NULL,
RELATION_TARGET_PATH BLOB NOT NULL,
RELATION_TYPE INT NOT NULL,
INDEX SOURCE_ID_IDX (RELATION_SOURCE_ID),
INDEX SOURCE_PATH_IDX (RELATION_SOURCE_PATH(255)),
INDEX TARGET_ID_IDX (RELATION_TARGET_ID),
INDEX TARGET_PATH_IDX (RELATION_TARGET_PATH(255)),
INDEX TYPE_IDX (RELATION_TYPE)
);
CREATE TABLE CMS_OFFLINE_RESOURCE_RELATIONS (
RELATION_SOURCE_ID VARCHAR(36) BINARY NOT NULL,
RELATION_SOURCE_PATH BLOB NOT NULL,
RELATION_TARGET_ID VARCHAR(36) BINARY NOT NULL,
RELATION_TARGET_PATH BLOB NOT NULL,
RELATION_TYPE INT NOT NULL,
INDEX SOURCE_ID_IDX (RELATION_SOURCE_ID),
INDEX SOURCE_PATH_IDX (RELATION_SOURCE_PATH(255)),
INDEX TARGET_ID_IDX (RELATION_TARGET_ID),
INDEX TARGET_PATH_IDX (RELATION_TARGET_PATH(255)),
INDEX TYPE_IDX (RELATION_TYPE)
);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -