-----------------------------------------------------------------------------
– CONTENT_ENTITY
-----------------------------------------------------------------------------
CREATE TABLE CONTENT_ENTITY
(
ENTITY_UUID VARCHAR (36),
VERSION SMALLINT,
ENTITY_ID VARCHAR (255) NOT NULL,
ENTITY_PATH VARCHAR (4096) NOT NULL,
IN_COLLECTION VARCHAR (255),
RESOURCE_TYPE VARCHAR (99),
– DISPLAY_NAME VARCHAR (1024),
CREATED_TIME TIMESTAMP,
CREATED_BY VARCHAR (99),
MODIFIED_TIME TIMESTAMP,
MODIFIED_BY VARCHAR (99),
ACCESS_MODE VARCHAR (16),
HIDDEN BOOLEAN,
RELEASE_DATE DATETIME (0),
RETRACT_DATE DATETIME (0),
HAS_PRIORITY_SORT BOOLEAN,
PRIORITY_SORT_ORDER SMALLINT,
CHANGES VARCHAR (1024),
CONSTRAINT CONTENT_ENTITY_INDEX UNIQUE (ENTITY_ID)
);
-----------------------------------------------------------------------------
– CONTENT_ENTITY_VERSIONS
-----------------------------------------------------------------------------
CREATE TABLE CONTENT_ENTITY_VERSIONS
(
ENTITY_UUID VARCHAR (36) NOT NULL,
VERSION SMALLINT,
IN_COLLECTION VARCHAR (36),
RESOURCE_TYPE VARCHAR (99),
– DISPLAY_NAME VARCHAR (1024),
– CREATED_TIME TIMESTAMP,
– CREATED_BY VARCHAR (99),
MODIFIED_TIME TIMESTAMP,
MODIFIED_BY VARCHAR (99),
ACCESS_MODE VARCHAR (16),
HIDDEN BOOLEAN,
RELEASE_DATE DATETIME (0),
RETRACT_DATE DATETIME (0),
HAS_PRIORITY_SORT BOOLEAN,
PRIORITY_SORT_ORDER SMALLINT,
CHANGES VARCHAR (1024),
CONSTRAINT CONTENT_ENTITY_INDEX UNIQUE (ENTITY_ID)
);
-----------------------------------------------------------------------------
– CONTENT_ENTITY_GROUPS
-----------------------------------------------------------------------------
CREATE TABLE CONTENT_ENTITY_GROUPS
(
ENTITY_UUID VARCHAR (36),
VERSION SMALLINT,
GROUP_ID VARCHAR (99)
);
-----------------------------------------------------------------------------
– CONTENT_ENTITY_PROPERTIES
-----------------------------------------------------------------------------
CREATE TABLE CONTENT_ENTITY_PROPERTIES
(
ENTITY_UUID VARCHAR (36),
VERSION SMALLINT,
ORDER_IN_LIST TINYINT,
PROPERTY_ID VARCHAR (255),
PROPERTY_VALUE LONGVARCHAR
);
-----------------------------------------------------------------------------
– CONTENT_ENTITY_BODY_FILE
-----------------------------------------------------------------------------
CREATE TABLE CONTENT_ENTITY_BODY_FILE
(
ENTITY_UUID VARCHAR (36),
VERSION SMALLINT,
FILE_PATH VARCHAR (128)
);
-----------------------------------------------------------------------------
– CONTENT_ENTITY_BODY_BINARY
-----------------------------------------------------------------------------
CREATE TABLE CONTENT_ENTITY_BODY_BINARY
(
ENTITY_KEY BIGINT NOT NULL,
VERSION SMALLINT,
BODY BINARY
);