Database Model plugin_tmp.xml


cms_backup_contents
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
BACKUP_ID VARCHAR(36) PK NN BINARY      
CONTENT_ID VARCHAR(36)   NN BINARY      
RESOURCE_ID VARCHAR(36)   NN BINARY      
FILE_CONTENT MEDIUMBLOB   NN        
PUBLISH_TAG INTEGER(11)            
VERSION_ID INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY BACKUP_ID
IDX1 Index RESOURCE_ID


cms_backup_projectresources
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
PUBLISH_TAG INTEGER(11) PK NN        
PROJECT_ID INTEGER(11) PK NN        
RESOURCE_PATH TEXT PK NN        
IndexName IndexType Columns
PRIMARY PRIMARY PUBLISH_TAG
PROJECT_ID
RESOURCE_PATH


cms_backup_projects
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
PROJECT_ID INTEGER(11)   NN        
PROJECT_NAME VARCHAR(64)   NN BINARY      
PROJECT_DESCRIPTION VARCHAR(255)   NN        
PROJECT_TYPE INTEGER(11)   NN        
USER_ID VARCHAR(36)   NN BINARY      
GROUP_ID VARCHAR(36)   NN BINARY      
MANAGERGROUP_ID VARCHAR(36)   NN BINARY      
TASK_ID INTEGER(11)   NN        
DATE_CREATED BIGINT(20)   NN        
PUBLISH_TAG INTEGER(11) PK NN        
PROJECT_PUBLISHDATE DATETIME            
PROJECT_PUBLISHED_BY VARCHAR(36)   NN BINARY      
PROJECT_PUBLISHED_BY_NAME VARCHAR(167)            
USER_NAME VARCHAR(167)            
GROUP_NAME VARCHAR(64)     BINARY      
MANAGERGROUP_NAME VARCHAR(64)     BINARY      
IndexName IndexType Columns
PRIMARY PRIMARY PUBLISH_TAG


cms_backup_properties
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
BACKUP_ID VARCHAR(36)   NN BINARY      
PROPERTY_ID VARCHAR(36) PK NN BINARY      
PROPERTYDEF_ID VARCHAR(36)   NN BINARY      
PROPERTY_MAPPING_ID VARCHAR(36)   NN BINARY      
PROPERTY_MAPPING_TYPE INTEGER(11)   NN        
PROPERTY_VALUE TEXT   NN        
PUBLISH_TAG INTEGER(11)            
VERSION_ID INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY PROPERTY_ID
IDX1 Index PROPERTYDEF_ID
PROPERTY_MAPPING_ID
PROPDEF_IDX Index PROPERTYDEF_ID
PROMAP_IDX Index PROPERTY_MAPPING_ID


cms_backup_propertydef
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
PROPERTYDEF_ID VARCHAR(36) PK NN BINARY      
PROPERTYDEF_NAME VARCHAR(128)   NN BINARY      
IndexName IndexType Columns
PRIMARY PRIMARY PROPERTYDEF_ID
IDX1 Index PROPERTYDEF_ID
IDX2 Index PROPERTYDEF_NAME


cms_backup_resources
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
BACKUP_ID VARCHAR(36) PK NN BINARY      
RESOURCE_ID VARCHAR(36)   NN BINARY      
RESOURCE_TYPE INTEGER(11)   NN        
RESOURCE_FLAGS INTEGER(11)   NN        
RESOURCE_STATE SMALLINT(5)   NN UNSIGNED      
RESOURCE_SIZE INTEGER(11)   NN        
SIBLING_COUNT INTEGER(11)   NN        
DATE_CREATED BIGINT(20)   NN        
DATE_LASTMODIFIED BIGINT(20)   NN        
USER_CREATED VARCHAR(36)   NN BINARY      
USER_LASTMODIFIED VARCHAR(36)   NN BINARY      
PROJECT_LASTMODIFIED SMALLINT(5)   NN UNSIGNED      
PUBLISH_TAG INTEGER(11)   NN        
VERSION_ID INTEGER(11)   NN        
USER_CREATED_NAME VARCHAR(64)   NN        
USER_LASTMODIFIED_NAME VARCHAR(64)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY BACKUP_ID
RESOURCE_RESOURCEID Index RESOURCE_ID
REESOURCE_TYPE Index RESOURCE_TYPE
IDX_PROJECT_LASTMODIFIED Index PROJECT_LASTMODIFIED
IDX1 Index PROJECT_LASTMODIFIED
RESOURCE_SIZE
IDX2 Index RESOURCE_SIZE
IDX3 Index DATE_LASTMODIFIED
IDX4 Index RESOURCE_TYPE


cms_backup_structure
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
BACKUP_ID VARCHAR(36) PK NN BINARY      
PUBLISH_TAG INTEGER(11)   NN        
VERSION_ID INTEGER(11)   NN        
STRUCTURE_ID VARCHAR(36)   NN BINARY      
RESOURCE_ID VARCHAR(36)   NN BINARY      
RESOURCE_PATH TEXT   NN        
STRUCTURE_STATE SMALLINT(5)   NN UNSIGNED      
DATE_RELEASED BIGINT(20)   NN        
DATE_EXPIRED BIGINT(20)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY BACKUP_ID
IDX1 Index STRUCTURE_ID
RESOURCE_PATH
IDX2 Index RESOURCE_PATH
RESOURCE_ID
IDX4 Index STRUCTURE_ID
RESOURCE_ID
IDX7 Index STRUCTURE_STATE
IDXA1 Index RESOURCE_ID
OFFPATH_IDX Index RESOURCE_PATH
IDX8 Index PUBLISH_TAG
IDX9 Index VERSION_ID


cms_groups
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
GROUP_ID VARCHAR(36) PK NN BINARY      
PARENT_GROUP_ID VARCHAR(36)   NN BINARY      
GROUP_NAME VARCHAR(64)   NN BINARY      
GROUP_DESCRIPTION VARCHAR(255)   NN        
GROUP_FLAGS INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY GROUP_ID
GROUP_NAME Index GROUP_NAME
GROUP_PARENTID Index PARENT_GROUP_ID


cms_groupusers
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
GROUP_ID VARCHAR(36)   NN BINARY      
USER_ID VARCHAR(36)   NN BINARY      
GROUPUSER_FLAGS INTEGER(11)   NN        
IndexName IndexType Columns
GROUP_ID Index GROUP_ID
USER_ID Index USER_ID


cms_module_backup_master
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
MASTER_ID VARCHAR(36) PK NN BINARY      
SUB_ID INTEGER(11)   NN        
USER_ID VARCHAR(36)   NN BINARY      
GROUP_ID VARCHAR(36)   NN BINARY      
PROJECT_ID INTEGER(11)   NN        
ACCESS_FLAGS INTEGER(11)   NN        
STATE INTEGER(11)   NN        
LOCKED_BY VARCHAR(36)   NN BINARY      
LASTMODIFIED_BY VARCHAR(36)   NN BINARY      
DATE_CREATED DATETIME   NN   0000-00-00 00:00:00    
DATE_LASTMODIFIED DATETIME   NN   0000-00-00 00:00:00    
PUBLICATION_DATE DATETIME            
PURGE_DATE DATETIME            
FLAGS INTEGER(11)   NN        
FEED_ID INTEGER(11)   NN        
FEED_REFERENCE INTEGER(11)   NN        
FEED_FILENAME VARCHAR(255)            
TITLE VARCHAR(255)            
DATA_BIG_0 TEXT            
DATA_BIG_1 TEXT            
DATA_BIG_2 TEXT            
DATA_BIG_3 TEXT            
DATA_BIG_4 TEXT            
DATA_BIG_5 TEXT            
DATA_BIG_6 TEXT            
DATA_BIG_7 TEXT            
DATA_BIG_8 TEXT            
DATA_BIG_9 TEXT            
DATA_MEDIUM_0 TEXT            
DATA_MEDIUM_1 TEXT            
DATA_MEDIUM_2 TEXT            
DATA_MEDIUM_3 TEXT            
DATA_MEDIUM_4 TEXT            
DATA_MEDIUM_5 TEXT            
DATA_MEDIUM_6 TEXT            
DATA_MEDIUM_7 TEXT            
DATA_MEDIUM_8 TEXT            
DATA_MEDIUM_9 TEXT            
DATA_SMALL_0 TEXT            
DATA_SMALL_1 TEXT            
DATA_SMALL_2 TEXT            
DATA_SMALL_3 TEXT            
DATA_SMALL_4 TEXT            
DATA_SMALL_5 TEXT            
DATA_SMALL_6 TEXT            
DATA_SMALL_7 TEXT            
DATA_SMALL_8 TEXT            
DATA_SMALL_9 TEXT            
DATA_SMALL_10 TEXT            
DATA_SMALL_11 TEXT            
DATA_SMALL_12 TEXT            
DATA_SMALL_13 TEXT            
DATA_SMALL_14 TEXT            
DATA_SMALL_15 TEXT            
DATA_SMALL_16 TEXT            
DATA_SMALL_17 TEXT            
DATA_SMALL_18 TEXT            
DATA_SMALL_19 TEXT            
DATA_SMALL_20 TEXT            
DATA_SMALL_21 TEXT            
DATA_SMALL_22 TEXT            
DATA_SMALL_23 TEXT            
DATA_SMALL_24 TEXT            
DATA_SMALL_25 TEXT            
DATA_SMALL_26 TEXT            
DATA_SMALL_27 TEXT            
DATA_SMALL_28 TEXT            
DATA_SMALL_29 TEXT            
DATA_SMALL_30 TEXT            
DATA_SMALL_31 TEXT            
DATA_SMALL_32 TEXT            
DATA_SMALL_33 TEXT            
DATA_SMALL_34 TEXT            
DATA_SMALL_35 TEXT            
DATA_SMALL_36 TEXT            
DATA_SMALL_37 TEXT            
DATA_SMALL_38 TEXT            
DATA_SMALL_39 TEXT            
DATA_INT_0 INTEGER(11)            
DATA_INT_1 INTEGER(11)            
DATA_INT_2 INTEGER(11)            
DATA_INT_3 INTEGER(11)            
DATA_INT_4 INTEGER(11)            
DATA_INT_5 INTEGER(11)            
DATA_INT_6 INTEGER(11)            
DATA_INT_7 INTEGER(11)            
DATA_INT_8 INTEGER(11)            
DATA_INT_9 INTEGER(11)            
DATA_REFERENCE_0 INTEGER(11)            
DATA_REFERENCE_1 INTEGER(11)            
DATA_REFERENCE_2 INTEGER(11)            
DATA_REFERENCE_3 INTEGER(11)            
DATA_REFERENCE_4 INTEGER(11)            
DATA_REFERENCE_5 INTEGER(11)            
DATA_REFERENCE_6 INTEGER(11)            
DATA_REFERENCE_7 INTEGER(11)            
DATA_REFERENCE_8 INTEGER(11)            
DATA_REFERENCE_9 INTEGER(11)            
DATA_DATE_0 DATETIME            
DATA_DATE_1 DATETIME            
DATA_DATE_2 DATETIME            
DATA_DATE_3 DATETIME            
DATA_DATE_4 DATETIME            
TAG_ID INTEGER(11) PK NN        
USER_NAME VARCHAR(167)            
GROUP_NAME VARCHAR(64)            
LASTMODIFIED_BY_NAME VARCHAR(167)            
IndexName IndexType Columns
PRIMARY PRIMARY MASTER_ID
TAG_ID


cms_module_backup_media
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
MEDIA_ID INTEGER(11) PK NN        
MASTER_ID VARCHAR(36)   NN BINARY      
MEDIA_POSITION INTEGER(11)   NN        
MEDIA_WIDTH INTEGER(11)   NN        
MEDIA_HEIGHT INTEGER(11)   NN        
MEDIA_SIZE INTEGER(11)   NN        
MEDIA_MIMETYPE VARCHAR(255)            
MEDIA_TYPE INTEGER(11)   NN        
MEDIA_TITLE VARCHAR(255)            
MEDIA_NAME VARCHAR(255)            
MEDIA_DESCRIPTION TEXT   NN        
MEDIA LONGBLOB   NN        
TAG_ID INTEGER(11) PK NN        
IndexName IndexType Columns
PRIMARY PRIMARY MEDIA_ID
TAG_ID
MASTER_ID Index MASTER_ID


cms_module_channel_rel
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
MASTER_ID VARCHAR(36) PK NN BINARY      
CHANNEL_ID VARCHAR(36) PK NN BINARY      
CHANNEL_NAME TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY CHANNEL_ID
MASTER_ID


cms_module_master
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
MASTER_ID VARCHAR(36) PK NN BINARY      
SUB_ID INTEGER(11)   NN        
USER_ID VARCHAR(36)   NN BINARY      
GROUP_ID VARCHAR(36)   NN BINARY      
PROJECT_ID INTEGER(11)   NN        
ACCESS_FLAGS INTEGER(11)   NN        
STATE INTEGER(11)   NN        
LOCKED_BY VARCHAR(36)   NN BINARY      
LASTMODIFIED_BY VARCHAR(36)   NN BINARY      
DATE_CREATED DATETIME   NN   0000-00-00 00:00:00    
DATE_LASTMODIFIED DATETIME   NN   0000-00-00 00:00:00    
PUBLICATION_DATE DATETIME            
PURGE_DATE DATETIME            
FLAGS INTEGER(11)   NN        
FEED_ID INTEGER(11)   NN        
FEED_REFERENCE INTEGER(11)   NN        
FEED_FILENAME VARCHAR(255)            
TITLE VARCHAR(255)            
DATA_BIG_0 TEXT            
DATA_BIG_1 TEXT            
DATA_BIG_2 TEXT            
DATA_BIG_3 TEXT            
DATA_BIG_4 TEXT            
DATA_BIG_5 TEXT            
DATA_BIG_6 TEXT            
DATA_BIG_7 TEXT            
DATA_BIG_8 TEXT            
DATA_BIG_9 TEXT            
DATA_MEDIUM_0 TEXT            
DATA_MEDIUM_1 TEXT            
DATA_MEDIUM_2 TEXT            
DATA_MEDIUM_3 TEXT            
DATA_MEDIUM_4 TEXT            
DATA_MEDIUM_5 TEXT            
DATA_MEDIUM_6 TEXT            
DATA_MEDIUM_7 TEXT            
DATA_MEDIUM_8 TEXT            
DATA_MEDIUM_9 TEXT            
DATA_SMALL_0 TEXT            
DATA_SMALL_1 TEXT            
DATA_SMALL_2 TEXT            
DATA_SMALL_3 TEXT            
DATA_SMALL_4 TEXT            
DATA_SMALL_5 TEXT            
DATA_SMALL_6 TEXT            
DATA_SMALL_7 TEXT            
DATA_SMALL_8 TEXT            
DATA_SMALL_9 TEXT            
DATA_SMALL_10 TEXT            
DATA_SMALL_11 TEXT            
DATA_SMALL_12 TEXT            
DATA_SMALL_13 TEXT            
DATA_SMALL_14 TEXT            
DATA_SMALL_15 TEXT            
DATA_SMALL_16 TEXT            
DATA_SMALL_17 TEXT            
DATA_SMALL_18 TEXT            
DATA_SMALL_19 TEXT            
DATA_SMALL_20 TEXT            
DATA_SMALL_21 TEXT            
DATA_SMALL_22 TEXT            
DATA_SMALL_23 TEXT            
DATA_SMALL_24 TEXT            
DATA_SMALL_25 TEXT            
DATA_SMALL_26 TEXT            
DATA_SMALL_27 TEXT            
DATA_SMALL_28 TEXT            
DATA_SMALL_29 TEXT            
DATA_SMALL_30 TEXT            
DATA_SMALL_31 TEXT            
DATA_SMALL_32 TEXT            
DATA_SMALL_33 TEXT            
DATA_SMALL_34 TEXT            
DATA_SMALL_35 TEXT            
DATA_SMALL_36 TEXT            
DATA_SMALL_37 TEXT            
DATA_SMALL_38 TEXT            
DATA_SMALL_39 TEXT            
DATA_INT_0 INTEGER(11)            
DATA_INT_1 INTEGER(11)            
DATA_INT_2 INTEGER(11)            
DATA_INT_3 INTEGER(11)            
DATA_INT_4 INTEGER(11)            
DATA_INT_5 INTEGER(11)            
DATA_INT_6 INTEGER(11)            
DATA_INT_7 INTEGER(11)            
DATA_INT_8 INTEGER(11)            
DATA_INT_9 INTEGER(11)            
DATA_REFERENCE_0 INTEGER(11)            
DATA_REFERENCE_1 INTEGER(11)            
DATA_REFERENCE_2 INTEGER(11)            
DATA_REFERENCE_3 INTEGER(11)            
DATA_REFERENCE_4 INTEGER(11)            
DATA_REFERENCE_5 INTEGER(11)            
DATA_REFERENCE_6 INTEGER(11)            
DATA_REFERENCE_7 INTEGER(11)            
DATA_REFERENCE_8 INTEGER(11)            
DATA_REFERENCE_9 INTEGER(11)            
DATA_DATE_0 DATETIME            
DATA_DATE_1 DATETIME            
DATA_DATE_2 DATETIME            
DATA_DATE_3 DATETIME            
DATA_DATE_4 DATETIME            
IndexName IndexType Columns
PRIMARY PRIMARY MASTER_ID
iSUB_ID Index SUB_ID


cms_module_media
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
MEDIA_ID INTEGER(11) PK NN        
MASTER_ID VARCHAR(36)   NN BINARY      
MEDIA_POSITION INTEGER(11)   NN        
MEDIA_WIDTH INTEGER(11)   NN        
MEDIA_HEIGHT INTEGER(11)   NN        
MEDIA_SIZE INTEGER(11)   NN        
MEDIA_MIMETYPE VARCHAR(255)            
MEDIA_TYPE INTEGER(11)   NN        
MEDIA_TITLE VARCHAR(255)            
MEDIA_NAME VARCHAR(255)            
MEDIA_DESCRIPTION TEXT   NN        
MEDIA LONGBLOB   NN        
IndexName IndexType Columns
PRIMARY PRIMARY MEDIA_ID
MASTER_ID Index MASTER_ID


cms_module_online_channel_rel
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
MASTER_ID VARCHAR(36) PK NN BINARY      
CHANNEL_ID VARCHAR(36) PK NN BINARY      
CHANNEL_NAME TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY CHANNEL_ID
MASTER_ID


cms_module_online_master
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
MASTER_ID VARCHAR(36) PK NN BINARY      
SUB_ID INTEGER(11)   NN        
USER_ID VARCHAR(36)   NN BINARY      
GROUP_ID VARCHAR(36)   NN BINARY      
PROJECT_ID INTEGER(11)   NN        
ACCESS_FLAGS INTEGER(11)   NN        
STATE INTEGER(11)   NN        
LOCKED_BY VARCHAR(36)   NN BINARY      
LASTMODIFIED_BY VARCHAR(36)   NN BINARY      
DATE_CREATED DATETIME   NN   0000-00-00 00:00:00    
DATE_LASTMODIFIED DATETIME   NN   0000-00-00 00:00:00    
PUBLICATION_DATE DATETIME            
PURGE_DATE DATETIME            
FLAGS INTEGER(11)            
FEED_ID INTEGER(11)            
FEED_REFERENCE INTEGER(11)            
FEED_FILENAME VARCHAR(255)            
TITLE VARCHAR(255)            
DATA_BIG_0 TEXT            
DATA_BIG_1 TEXT            
DATA_BIG_2 TEXT            
DATA_BIG_3 TEXT            
DATA_BIG_4 TEXT            
DATA_BIG_5 TEXT            
DATA_BIG_6 TEXT            
DATA_BIG_7 TEXT            
DATA_BIG_8 TEXT            
DATA_BIG_9 TEXT            
DATA_MEDIUM_0 TEXT            
DATA_MEDIUM_1 TEXT            
DATA_MEDIUM_2 TEXT            
DATA_MEDIUM_3 TEXT            
DATA_MEDIUM_4 TEXT            
DATA_MEDIUM_5 TEXT            
DATA_MEDIUM_6 TEXT            
DATA_MEDIUM_7 TEXT            
DATA_MEDIUM_8 TEXT            
DATA_MEDIUM_9 TEXT            
DATA_SMALL_0 TEXT            
DATA_SMALL_1 TEXT            
DATA_SMALL_2 TEXT            
DATA_SMALL_3 TEXT            
DATA_SMALL_4 TEXT            
DATA_SMALL_5 TEXT            
DATA_SMALL_6 TEXT            
DATA_SMALL_7 TEXT            
DATA_SMALL_8 TEXT            
DATA_SMALL_9 TEXT            
DATA_SMALL_10 TEXT            
DATA_SMALL_11 TEXT            
DATA_SMALL_12 TEXT            
DATA_SMALL_13 TEXT            
DATA_SMALL_14 TEXT            
DATA_SMALL_15 TEXT            
DATA_SMALL_16 TEXT            
DATA_SMALL_17 TEXT            
DATA_SMALL_18 TEXT            
DATA_SMALL_19 TEXT            
DATA_SMALL_20 TEXT            
DATA_SMALL_21 TEXT            
DATA_SMALL_22 TEXT            
DATA_SMALL_23 TEXT            
DATA_SMALL_24 TEXT            
DATA_SMALL_25 TEXT            
DATA_SMALL_26 TEXT            
DATA_SMALL_27 TEXT            
DATA_SMALL_28 TEXT            
DATA_SMALL_29 TEXT            
DATA_SMALL_30 TEXT            
DATA_SMALL_31 TEXT            
DATA_SMALL_32 TEXT            
DATA_SMALL_33 TEXT            
DATA_SMALL_34 TEXT            
DATA_SMALL_35 TEXT            
DATA_SMALL_36 TEXT            
DATA_SMALL_37 TEXT            
DATA_SMALL_38 TEXT            
DATA_SMALL_39 TEXT            
DATA_INT_0 INTEGER(11)            
DATA_INT_1 INTEGER(11)            
DATA_INT_2 INTEGER(11)            
DATA_INT_3 INTEGER(11)            
DATA_INT_4 INTEGER(11)            
DATA_INT_5 INTEGER(11)            
DATA_INT_6 INTEGER(11)            
DATA_INT_7 INTEGER(11)            
DATA_INT_8 INTEGER(11)            
DATA_INT_9 INTEGER(11)            
DATA_REFERENCE_0 INTEGER(11)            
DATA_REFERENCE_1 INTEGER(11)            
DATA_REFERENCE_2 INTEGER(11)            
DATA_REFERENCE_3 INTEGER(11)            
DATA_REFERENCE_4 INTEGER(11)            
DATA_REFERENCE_5 INTEGER(11)            
DATA_REFERENCE_6 INTEGER(11)            
DATA_REFERENCE_7 INTEGER(11)            
DATA_REFERENCE_8 INTEGER(11)            
DATA_REFERENCE_9 INTEGER(11)            
DATA_DATE_0 DATETIME            
DATA_DATE_1 DATETIME            
DATA_DATE_2 DATETIME            
DATA_DATE_3 DATETIME            
DATA_DATE_4 DATETIME            
IndexName IndexType Columns
PRIMARY PRIMARY MASTER_ID
iSUB_ID Index SUB_ID


cms_module_online_media
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
MEDIA_ID INTEGER(11) PK NN        
MASTER_ID VARCHAR(36)   NN BINARY      
MEDIA_POSITION INTEGER(11)   NN        
MEDIA_WIDTH INTEGER(11)   NN        
MEDIA_HEIGHT INTEGER(11)   NN        
MEDIA_SIZE INTEGER(11)   NN        
MEDIA_MIMETYPE VARCHAR(255)            
MEDIA_TYPE INTEGER(11)   NN        
MEDIA_TITLE VARCHAR(255)            
MEDIA_NAME VARCHAR(255)            
MEDIA_DESCRIPTION TEXT   NN        
MEDIA LONGBLOB   NN        
IndexName IndexType Columns
PRIMARY PRIMARY MEDIA_ID
MASTER_ID Index MASTER_ID


cms_offline_accesscontrol
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
RESOURCE_ID VARCHAR(36) PK NN BINARY      
PRINCIPAL_ID VARCHAR(36) PK NN BINARY      
ACCESS_ALLOWED INTEGER(11)            
ACCESS_DENIED INTEGER(11)            
ACCESS_FLAGS INTEGER(11)            
IndexName IndexType Columns
PRIMARY PRIMARY RESOURCE_ID
PRINCIPAL_ID
IDX0 Index PRINCIPAL_ID


cms_offline_contents
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
CONTENT_ID VARCHAR(36) PK NN BINARY      
RESOURCE_ID VARCHAR(36)   NN BINARY      
FILE_CONTENT MEDIUMBLOB   NN        
IndexName IndexType Columns
PRIMARY PRIMARY CONTENT_ID
IDX1 Index RESOURCE_ID


cms_offline_properties
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
PROPERTY_ID VARCHAR(36) PK NN BINARY      
PROPERTYDEF_ID VARCHAR(36)   NN BINARY      
PROPERTY_MAPPING_ID VARCHAR(36)   NN BINARY      
PROPERTY_MAPPING_TYPE INTEGER(11)   NN        
PROPERTY_VALUE TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY PROPERTY_ID
PROPDEF_IDX Index PROPERTYDEF_ID
PROMAP_IDX Index PROPERTY_MAPPING_ID
IDX1 Index PROPERTYDEF_ID
PROPERTY_MAPPING_ID


cms_offline_propertydef
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
PROPERTYDEF_ID VARCHAR(36) PK NN BINARY      
PROPERTYDEF_NAME VARCHAR(128)   NN BINARY      
IndexName IndexType Columns
PRIMARY PRIMARY PROPERTYDEF_ID
IDX1 Index PROPERTYDEF_ID
IDX2 Index PROPERTYDEF_NAME


cms_offline_resources
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
RESOURCE_ID VARCHAR(36) PK NN BINARY      
RESOURCE_TYPE INTEGER(11)   NN        
RESOURCE_FLAGS INTEGER(11)   NN        
RESOURCE_STATE SMALLINT(5)   NN UNSIGNED      
RESOURCE_SIZE INTEGER(11)   NN        
SIBLING_COUNT INTEGER(11)   NN        
DATE_CREATED BIGINT(20)   NN        
DATE_LASTMODIFIED BIGINT(20)   NN        
USER_CREATED VARCHAR(36)   NN BINARY      
USER_LASTMODIFIED VARCHAR(36)   NN BINARY      
PROJECT_LASTMODIFIED SMALLINT(5)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY RESOURCE_ID
RESOURCE_TYPE Index RESOURCE_TYPE
IDX_PROJECT_LASTMODIFIED Index PROJECT_LASTMODIFIED
IDX1 Index PROJECT_LASTMODIFIED
RESOURCE_SIZE
IDX2 Index RESOURCE_SIZE
IDX3 Index DATE_LASTMODIFIED
IDX4 Index RESOURCE_TYPE


cms_offline_structure
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
STRUCTURE_ID VARCHAR(36) PK NN BINARY      
RESOURCE_ID VARCHAR(36)   NN BINARY      
PARENT_ID VARCHAR(36)   NN BINARY      
RESOURCE_PATH TEXT   NN        
STRUCTURE_STATE SMALLINT(5)   NN UNSIGNED      
DATE_RELEASED BIGINT(20)   NN        
DATE_EXPIRED BIGINT(20)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY STRUCTURE_ID
IDX1 Index STRUCTURE_ID
RESOURCE_PATH
IDX2 Index RESOURCE_PATH
RESOURCE_ID
IDX4 Index STRUCTURE_ID
RESOURCE_ID
IDX7 Index STRUCTURE_STATE
IDX3 Index PARENT_ID
IDXA1 Index RESOURCE_ID
OFFPATH_IDX Index RESOURCE_PATH


cms_online_accesscontrol
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
RESOURCE_ID VARCHAR(36) PK NN BINARY      
PRINCIPAL_ID VARCHAR(36) PK NN BINARY      
ACCESS_ALLOWED INTEGER(11)            
ACCESS_DENIED INTEGER(11)            
ACCESS_FLAGS INTEGER(11)            
IndexName IndexType Columns
PRIMARY PRIMARY RESOURCE_ID
PRINCIPAL_ID
IDX0 Index PRINCIPAL_ID


cms_online_contents
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
CONTENT_ID VARCHAR(36) PK NN BINARY      
RESOURCE_ID VARCHAR(36)   NN BINARY      
FILE_CONTENT MEDIUMBLOB   NN        
IndexName IndexType Columns
PRIMARY PRIMARY CONTENT_ID
IDX1 Index RESOURCE_ID


cms_online_properties
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
PROPERTY_ID VARCHAR(36) PK NN BINARY      
PROPERTYDEF_ID VARCHAR(36)   NN BINARY      
PROPERTY_MAPPING_ID VARCHAR(36)   NN BINARY      
PROPERTY_MAPPING_TYPE INTEGER(11)   NN        
PROPERTY_VALUE TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY PROPERTY_ID
PROPDEF_IDX Index PROPERTYDEF_ID
PROMAP_IDX Index PROPERTY_MAPPING_ID
IDX1 Index PROPERTYDEF_ID
PROPERTY_MAPPING_ID


cms_online_propertydef
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
PROPERTYDEF_ID VARCHAR(36) PK NN BINARY      
PROPERTYDEF_NAME VARCHAR(128)   NN BINARY      
IndexName IndexType Columns
PRIMARY PRIMARY PROPERTYDEF_ID
IDX1 Index PROPERTYDEF_ID
IDX2 Index PROPERTYDEF_NAME


cms_online_resources
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
RESOURCE_ID VARCHAR(36) PK NN BINARY      
RESOURCE_TYPE INTEGER(11)   NN        
RESOURCE_FLAGS INTEGER(11)   NN        
RESOURCE_STATE SMALLINT(5)   NN UNSIGNED      
RESOURCE_SIZE INTEGER(11)   NN        
SIBLING_COUNT INTEGER(11)   NN        
DATE_CREATED BIGINT(20)   NN        
DATE_LASTMODIFIED BIGINT(20)   NN        
USER_CREATED VARCHAR(36)   NN BINARY      
USER_LASTMODIFIED VARCHAR(36)   NN BINARY      
PROJECT_LASTMODIFIED SMALLINT(5)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY RESOURCE_ID
RESOURCE_TYPE Index RESOURCE_TYPE
IDX_PROJECT_LASTMODIFIED Index PROJECT_LASTMODIFIED
IDX1 Index PROJECT_LASTMODIFIED
RESOURCE_SIZE
IDX2 Index RESOURCE_SIZE
IDX3 Index DATE_LASTMODIFIED
IDX4 Index RESOURCE_TYPE


cms_online_structure
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
STRUCTURE_ID VARCHAR(36) PK NN BINARY      
RESOURCE_ID VARCHAR(36)   NN BINARY      
PARENT_ID VARCHAR(36)   NN BINARY      
RESOURCE_PATH TEXT   NN        
STRUCTURE_STATE SMALLINT(5)   NN UNSIGNED      
DATE_RELEASED BIGINT(20)   NN        
DATE_EXPIRED BIGINT(20)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY STRUCTURE_ID
IDX1 Index STRUCTURE_ID
RESOURCE_PATH
IDX2 Index RESOURCE_PATH
RESOURCE_ID
IDX4 Index STRUCTURE_ID
RESOURCE_ID
IDX7 Index STRUCTURE_STATE
IDX3 Index PARENT_ID
IDXA1 Index RESOURCE_ID
OFFPATH_IDX Index RESOURCE_PATH


cms_projectresources
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
PROJECT_ID INTEGER(11) PK NN        
RESOURCE_PATH TEXT PK NN        
IndexName IndexType Columns
PRIMARY PRIMARY PROJECT_ID
RESOURCE_PATH
PROJECTRESOURCE_RESOURCEPATH Index RESOURCE_PATH


cms_projects
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
PROJECT_ID INTEGER(11) PK NN        
PROJECT_NAME VARCHAR(64)   NN BINARY      
PROJECT_DESCRIPTION VARCHAR(255)   NN        
PROJECT_FLAGS INTEGER(11)   NN        
PROJECT_TYPE INTEGER(11)   NN        
USER_ID VARCHAR(36)   NN BINARY      
GROUP_ID VARCHAR(36)   NN BINARY      
MANAGERGROUP_ID VARCHAR(36)   NN BINARY      
TASK_ID INTEGER(11)   NN        
DATE_CREATED BIGINT(20)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY PROJECT_ID
PROJECT_NAME_2 Index PROJECT_NAME
DATE_CREATED
PROJECT_NAME Index PROJECT_NAME
DATE_CREATED
PROJECT_FLAGS Index PROJECT_FLAGS
PROJECTS_GROUPID Index GROUP_ID
PROJECTS_MANAGERID Index MANAGERGROUP_ID
PROJECTS_USERID Index USER_ID
PROJECTS_TASKID Index TASK_ID


cms_publish_history
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
HISTORY_ID VARCHAR(36) PK NN BINARY      
PUBLISH_TAG INTEGER(11) PK NN        
STRUCTURE_ID VARCHAR(36) PK NN BINARY      
RESOURCE_ID VARCHAR(36) PK NN BINARY      
RESOURCE_PATH TEXT   NN        
RESOURCE_STATE INTEGER(11)   NN        
RESOURCE_TYPE INTEGER(11)   NN        
SIBLING_COUNT INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY HISTORY_ID
PUBLISH_TAG
STRUCTURE_ID
RESOURCE_ID


cms_staticexport_links
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
LINK_ID VARCHAR(36) PK NN BINARY      
LINK_RFS_PATH TEXT   NN        
LINK_TYPE INTEGER(11)   NN        
LINK_PARAMETER TEXT            
LINK_TIMESTAMP BIGINT(20)            
IndexName IndexType Columns
PRIMARY PRIMARY LINK_ID


cms_systemid
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
TABLE_KEY VARCHAR(255) PK NN        
ID INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY TABLE_KEY


cms_task
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
AUTOFINISH INTEGER(11)            
ENDTIME DATETIME            
ESCALATIONTYPEREF INTEGER(11)            
ID INTEGER(11) PK NN        
INITIATORUSERREF VARCHAR(36)     BINARY      
MILESTONEREF INTEGER(11)            
NAME VARCHAR(254)            
ORIGINALUSERREF VARCHAR(36)     BINARY      
AGENTUSERREF VARCHAR(36)     BINARY      
PARENT INTEGER(11)            
PERCENTAGE VARCHAR(50)            
PERMISSION VARCHAR(50)            
PRIORITYREF INTEGER(11)       2    
ROLEREF VARCHAR(36)     BINARY      
ROOT INTEGER(11)            
STARTTIME DATETIME            
STATE INTEGER(11)            
TASKTYPEREF INTEGER(11)            
TIMEOUT DATETIME            
WAKEUPTIME DATETIME            
HTMLLINK VARCHAR(254)            
ESTIMATETIME INTEGER(11)       86400    
IndexName IndexType Columns
PRIMARY PRIMARY ID


cms_tasklog
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
COMENT TEXT            
EXTERNALUSERNAME VARCHAR(254)            
ID INTEGER(11) PK NN        
STARTTIME DATETIME            
TASKREF INTEGER(11)            
USERREF VARCHAR(36)   NN BINARY      
TYPE INTEGER(18)            
IndexName IndexType Columns
PRIMARY PRIMARY ID


cms_taskpar
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
ID INTEGER(11) PK NN        
PARNAME VARCHAR(50)            
PARVALUE VARCHAR(50)            
REF INTEGER(11)            
IndexName IndexType Columns
PRIMARY PRIMARY ID


cms_tasktype
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
AUTOFINISH INTEGER(11)            
ESCALATIONTYPEREF INTEGER(11)            
HTMLLINK VARCHAR(254)            
ID INTEGER(11) PK NN        
NAME VARCHAR(50)            
PERMISSION VARCHAR(50)            
PRIORITYREF INTEGER(11)            
ROLEREF VARCHAR(36)     BINARY      
IndexName IndexType Columns
PRIMARY PRIMARY ID


cms_users
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
USER_ID VARCHAR(36) PK NN BINARY      
USER_NAME VARCHAR(64)   NN BINARY      
USER_PASSWORD VARCHAR(32)   NN BINARY      
USER_DESCRIPTION VARCHAR(255)   NN        
USER_FIRSTNAME VARCHAR(50)   NN        
USER_LASTNAME VARCHAR(50)   NN        
USER_EMAIL VARCHAR(100)   NN        
USER_LASTLOGIN BIGINT(20)   NN        
USER_FLAGS INTEGER(11)   NN        
USER_INFO BLOB            
USER_ADDRESS VARCHAR(100)   NN        
USER_TYPE INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY USER_ID
USER_NAME Index USER_NAME


cms_webusers
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
USER_ID VARCHAR(36) PK NN BINARY      
USER_MEMBER_ID VARCHAR(255)            
USER_SALUTATION VARCHAR(255)            
USER_TITLE VARCHAR(255)            
USER_PWD VARCHAR(255)            
USER_PWD_QUESTION VARCHAR(255)            
USER_PWD_ANSWER VARCHAR(255)            
USER_CITY VARCHAR(255)            
USER_POSTCODE VARCHAR(255)            
USER_STATE VARCHAR(255)            
USER_COUNTRY VARCHAR(255)            
USER_ADDRESS_TYPE INTEGER(11)            
USER_BIRTHDAY DATETIME            
USER_PHONE VARCHAR(255)            
USER_FAX VARCHAR(255)            
USER_MOBILE VARCHAR(255)            
USER_ACCEPT INTEGER(11)            
USER_RECOMMENDED_BY VARCHAR(255)            
USER_PROFESSION VARCHAR(255)            
USER_COMPANY VARCHAR(255)            
USER_DEPARTMENT VARCHAR(255)            
USER_POSITION VARCHAR(255)            
USER_ACCOUNT_NUMBER VARCHAR(255)            
USER_BANK_NUMBER VARCHAR(255)            
USER_BANK VARCHAR(255)            
USER_NEWSLETTER VARCHAR(255)            
USER_EXTRAINFO_1 VARCHAR(255)            
USER_EXTRAINFO_2 VARCHAR(255)            
USER_EXTRAINFO_3 VARCHAR(255)            
USER_EXTRAINFO_4 VARCHAR(255)            
USER_EXTRAINFO_5 VARCHAR(255)            
USER_EXTRAINFO_6 VARCHAR(255)            
USER_EXTRAINFO_7 VARCHAR(255)            
USER_EXTRAINFO_8 VARCHAR(255)            
USER_EXTRAINFO_9 VARCHAR(255)            
USER_EXTRAINFO_10 VARCHAR(255)            
USER_EXTRAINFO_11 VARCHAR(255)            
USER_EXTRAINFO_12 VARCHAR(255)            
USER_EXTRAINFO_13 VARCHAR(255)            
USER_EXTRAINFO_14 VARCHAR(255)            
USER_EXTRAINFO_15 VARCHAR(255)            
USER_EXTRAINFO_16 VARCHAR(255)            
USER_EXTRAINFO_17 VARCHAR(255)            
USER_EXTRAINFO_18 VARCHAR(255)            
USER_EXTRAINFO_19 TEXT            
USER_EXTRAINFO_20 TEXT            
USER_PICTURE MEDIUMBLOB            
USER_PICTURE_NAME VARCHAR(255)            
USER_ATTACHMENT MEDIUMBLOB            
USER_ATTACHMENT_NAME VARCHAR(255)            
USER_CREATE_DATE DATETIME            
USER_LASTCHANGE_BY VARCHAR(255)            
USER_LASTCHANGE_DATE DATETIME            
LOCKSTATE VARCHAR(255)            
IndexName IndexType Columns
PRIMARY PRIMARY USER_ID