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