disable autogenerating web content Ids

You can disable auto-generating ID’s with the following setting in portal-ext.properties:

journal.article.force.autogenerate.id=false

Use other database (beside liferay default) for portlet

Introduction: It is a common requirement, that sometimes we are asked to use entirely a different database for all our backend process rather than the one we have for liferay(the one we generally specify in portal-ext.properties).

Ingredients: prior knowledge of service builder, database with name "myDB" username-"root" password-"root", table "myUserTable"with columns "user_id" and "name"

Idea: The idea is to create something that is portlet specific.
Lets create the service builder and since in the <entity> we do have attribute as data-source, so this may help.
To specify the data-source's value we'll use ext-spring.xml..but HOW????

What to do?
1. Create a portlet (http://michi-path.blogspot.in/2012/03/create-new-portlet-in-liferay-ide.html).
2. create service-builder.
3. In Service.xml make the entry
    <entity name="User" table="myUserTable" local-service="true" remote-service="true" data-source="eportalDB">
        <!-- PK fields -->
        <column name="user_id" type="long" primary="true" />
        <!-- Audit fields -->
        <column name="name" type="String" />
     </entity>
 4. Do "ant build-service"
5. Go to docroot/WEB-INF/src/META-INF
create a file ext-spring.xml
6. add the following code in ext-spring.xml:
<?xml version="1.0"?>
<beans
    xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    default-destroy-method="destroy"
    default-init-method="afterPropertiesSet"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
    <bean id="eportalDB" lazy-init="true"  class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="org.postgresql.Driver" />
        <property name="url" value="jdbc:postgresql://localhost:5432/myDB?useUnicode=true"/>
        <property name="username" value="root" />
        <property name="password" value="root" />
    </bean>
    <bean id="liferayHibernateSessionFactory"   class="com.liferay.portal.spring.hibernate.PortletHibernateConfiguration">
         <property name="dataSource" ref="eportalDB" />
    </bean>
    <bean id="liferayTransactionManager"   class="org.springframework.orm.hibernate3.HibernateTransactionManager">
         <property name="dataSource" ref="eportalDB" />
         <property name="globalRollbackOnParticipationFailure" value="false" />
         <property name="sessionFactory" ref="liferayHibernateSessionFactory" />
    </bean>
    <bean id="liferaySessionFactory" class="com.liferay.portal.dao.orm.hibernate.SessionFactoryImpl">
         <property name="sessionFactoryImplementor" ref="liferayHibernateSessionFactory" />
    </bean>
</beans>
7. build-service and deploy

Discussion: In ext-spring.xml
liferayTransactionManager:- is for the DML operations.
if this is not added we wont be able to do operations like insert, update, delete

For only fetching the data from the table, the following code can be removed from the existing ext-spring.xml
<bean id="liferayTransactionManager"   class="org.springframework.orm.hibernate3.HibernateTransactionManager">
         <property name="dataSource" ref="eportalDB" />
         <property name="globalRollbackOnParticipationFailure" value="false" />
         <property name="sessionFactory" ref="liferayHibernateSessionFactory" />
    </bean>
    <bean id="liferaySessionFactory" class="com.liferay.portal.dao.orm.hibernate.SessionFactoryImpl">
         <property name="sessionFactoryImplementor" ref="liferayHibernateSessionFactory" />
    </bean>

UploadPortletRequest getFiles() cannot upload files with size less than 1kb

Introduction: While uploading a file in liferay we use the processAction() method of our MVC portlet class, wherein we use the following kind of code UploadPortletRequest uploadrequest = PortalUtil.getUploadPortletRequest(actionRequest);

File file =  uploadrequest.getFile("fileUpload");

where "fileUpload" is ofcourse in view.jsp

Problem: On upload if the file size was less than 1kb, there is no temporary file created(Whenever an upload operation is done a temporary file in the temp folder of the tomcat is created which is been referred for any operation performed to use the file.

Solution: use input stream instead of getFile(), as follows:-

UploadPortletRequest uploadrequest = PortalUtil.getUploadPortletRequest(actionRequest);
            InputStream[] inputStream = uploadrequest.getFilesAsStream("fileupload");
            for(InputStream fileObj:inputStream){
            File file = FileUtil.createTempFile(fileObj);

            } 


Export to .csv file - Name the file on export

Introduction: It seems easy to make a file downloadable, thats what I presumed when I was assigned this task myself. As soon as I started with this I got stuck on some minor things for which later actually I spent almost a day searching and hence at the end found the solution.


Problem: I was able to create a file even download it but issue was naming the file.
I had a table data that i needed to export to ".csv" format and name the file as "resultdata-randomNo.csv" using javascript
but the issue was when downloading it was in the format of  "xxx.part" and not csv. So I tried out the following way.

Here is the view.jsp
<script type="text/javascript">
function download(){ 

var array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;

        var str = '';

        for (var i = 0; i < array.length; i++) {
            var line = '';

            for (var index in array[i]) {
                line += array[i][index] + ',';
            }

            line.slice(0,line.Length-1); 

            str += line + '\r\n';

            }
var randomnumber= Math.floor(Math.random()* Math.pow(10,6) + Math.pow(10,5));
      var thisForm = document.createElement('form');
      thisForm.style.display = 'none';
      document.body.appendChild(thisForm);
      var fileName = document.createElement('input');
      fileName.type = 'hidden';
      fileName.name = 'fileName';
      fileName.value = 'resultdata-'+randomnumber;
      thisForm.appendChild(fileName);
      var dataTable = document.createElement('input');
      dataTable.type = 'hidden';
      dataTable.name = 'tableData';
      dataTable.value = str;
      thisForm.appendChild(dataTable);

      thisForm.method = 'POST';
      thisForm.action = "<%=renderResponse.encodeURL(renderRequest.getContextPath())%>/tabledata.jsp";
      thisForm.submit();
      document.body.removeChild(thisForm);
}
</script>

tabledata.jsp
<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%@page contentType="application/octet-stream"%>
<%
    String tableData = "No records found";
    String fileName = "datatable";
    if (request.getParameter("fileName") != null
            || request.getParameter("fileName") != "") {
        fileName = request.getParameter("fileName");
    }
    if (request.getParameter("tableData") != null
            || request.getParameter("tableData") != "") {
        tableData = request.getParameter("tableData");
    }
    response.setHeader("Content-Disposition", "attachment;filename=\""
            + fileName + ".csv\"");
    out.print(tableData);
%>

The code is self-explanatory.

Hope it answers your problem also.

LIferay Database Tables

Introduction
Liferay maintains all its data and content inside the tables but what tables? and which data is getting stored in which table? I always come across such type of questions.
for the same I thought of summing up all in all I got to know through my experience.

This will be for the Liferay 6.1

Summation

Schema for database 'lportal61' -->

lportal61

&nbsp

• account_
• address
• announcementsdelivery
• announcementsentry
• announcementsflag
• assetcategory
• assetcategoryproperty
• assetentries_assetcategories
• assetentries_assettags
• assetentry
• assetlink
• assettag
• assettagproperty
• assettagstats
• assetvocabulary
• blogsentry
• blogsstatsuser
• bookmarksentry
• bookmarksfolder
• browsertracker
• calevent
• classname_
• clustergroup
• company
• contact_
• counter
• country
• cyrususer
• cyrusvirtual
• ddlrecord
• ddlrecordset
• ddlrecordversion
• ddmcontent
• ddmstoragelink
• ddmstructure
• ddmstructurelink
• ddmtemplate
• dlcontent
• dlfileentry
• dlfileentrymetadata
• dlfileentrytype
• dlfileentrytypes_ddmstructures
• dlfileentrytypes_dlfolders
• dlfilerank
• dlfileshortcut
• dlfileversion
• dlfolder
• dlsync
• emailaddress
• expandocolumn
• expandorow
• expandotable
• expandovalue
• group_
• groups_orgs
• groups_permissions
• groups_roles
• groups_usergroups
• image
• journalarticle
• journalarticleimage
• journalarticleresource
• journalcontentsearch
• journalfeed
• journalstructure
• journaltemplate
• layout
• layoutbranch
• layoutprototype
• layoutrevision
• layoutset
• layoutsetbranch
• layoutsetprototype
• listtype
• lock_
• mbban
• mbcategory
• mbdiscussion
• mbmailinglist
• mbmessage
• mbstatsuser
• mbthread
• mbthreadflag
• mdraction
• mdrrule
• mdrrulegroup
• mdrrulegroupinstance
• membershiprequest
• organization_
• orggrouppermission
• orggrouprole
• orglabor
• passwordpolicy
• passwordpolicyrel
• passwordtracker
• permission_
• phone
• pluginsetting
• pollschoice
• pollsquestion
• pollsvote
• portalpreferences
• portlet
• portletitem
• portletpreferences
• quartz_blob_triggers
• quartz_calendars
• quartz_cron_triggers
• quartz_fired_triggers
• quartz_job_details
• quartz_locks
• quartz_paused_trigger_grps
• quartz_scheduler_state
• quartz_simple_triggers
• quartz_simprop_triggers
• quartz_triggers
• ratingsentry
• ratingsstats
• region
• release_
• repository
• repositoryentry
• resource_
• resourceaction
• resourceblock
• resourceblockpermission
• resourcecode
• resourcepermission
• resourcetypepermission
• role_
• roles_permissions
• scframeworkversi_scproductvers
• scframeworkversion
• sclicense
• sclicenses_scproductentries
• scproductentry
• scproductscreenshot
• scproductversion
• servicecomponent
• shard
• shoppingcart
• shoppingcategory
• shoppingcoupon
• shoppingitem
• shoppingitemfield
• shoppingitemprice
• shoppingorder
• shoppingorderitem
• socialactivity
• socialactivityachievement
• socialactivitycounter
• socialactivitylimit
• socialactivitysetting
• socialrelation
• socialrequest
• subscription
• team
• ticket
• user_
• usergroup
• usergroupgrouprole
• usergrouprole
• usergroups_teams
• useridmapper
• usernotificationevent
• users_groups
• users_orgs
• users_permissions
• users_roles
• users_teams
• users_usergroups
• usertracker
• usertrackerpath
• virtualhost
• webdavprops
• website
• wikinode
• wikipage
• wikipageresource
• workflowdefinitionlink
• workflowinstancelink

&nbsp

account_	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
accountId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
parentAccountId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
name	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
legalName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
legalId	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
legalType	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
sicCode	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
tickerSymbol	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
industry	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
type_	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
size_	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

account_

0

PRIMARY

1

accountId

A

1

(NULL)

(NULL)

BTREE

Back

&nbsp

address	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
addressId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
classNameId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
classPK	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
street1	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
street2	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
street3	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
city	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
zip	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
regionId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
countryId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
typeId	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
mailing	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references
primary_	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

address

0

PRIMARY

1

addressId

A

0

(NULL)

(NULL)

BTREE

address

1

IX_93D5AD4E

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

address

1

IX_ABD7DAC0

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

address

1

IX_ABD7DAC0

2

classNameId

A

0

(NULL)

(NULL)

YES

BTREE

address

1

IX_71CB1123

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

address

1

IX_71CB1123

2

classNameId

A

0

(NULL)

(NULL)

YES

BTREE

address

1

IX_71CB1123

3

classPK

A

0

(NULL)

(NULL)

YES

BTREE

address

1

IX_923BD178

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

address

1

IX_923BD178

2

classNameId

A

0

(NULL)

(NULL)

YES

BTREE

address

1

IX_923BD178

3

classPK

A

0

(NULL)

(NULL)

YES

BTREE

address

1

IX_923BD178

4

mailing

A

0

(NULL)

(NULL)

YES

BTREE

address

1

IX_9226DBB4

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

address

1

IX_9226DBB4

2

classNameId

A

0

(NULL)

(NULL)

YES

BTREE

address

1

IX_9226DBB4

3

classPK

A

0

(NULL)

(NULL)

YES

BTREE

address

1

IX_9226DBB4

4

primary_

A

0

(NULL)

(NULL)

YES

BTREE

address

1

IX_5BC8B0D4

1

userId

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

announcementsdelivery	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
deliveryId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
type_	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
email	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references
sms	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references
website	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

announcementsdelivery

0

PRIMARY

1

deliveryId

A

3

(NULL)

(NULL)

BTREE

announcementsdelivery

0

IX_BA4413D5

1

userId

A

3

(NULL)

(NULL)

YES

BTREE

announcementsdelivery

0

IX_BA4413D5

2

type_

A

3

(NULL)

(NULL)

YES

BTREE

announcementsdelivery

1

IX_6EDB9600

1

userId

A

3

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

announcementsentry	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
entryId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
classNameId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
classPK	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
title	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
content	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
url	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
type_	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
displayDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
expirationDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
priority	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
alert	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

announcementsentry

0

PRIMARY

1

entryId

A

0

(NULL)

(NULL)

BTREE

announcementsentry

1

IX_A6EF0B81

1

classNameId

A

0

(NULL)

(NULL)

YES

BTREE

announcementsentry

1

IX_A6EF0B81

2

classPK

A

0

(NULL)

(NULL)

YES

BTREE

announcementsentry

1

IX_14F06A6B

1

classNameId

A

0

(NULL)

(NULL)

YES

BTREE

announcementsentry

1

IX_14F06A6B

2

classPK

A

0

(NULL)

(NULL)

YES

BTREE

announcementsentry

1

IX_14F06A6B

3

alert

A

0

(NULL)

(NULL)

YES

BTREE

announcementsentry

1

IX_D49C2E66

1

userId

A

0

(NULL)

(NULL)

YES

BTREE

announcementsentry

1

IX_1AFBDE08

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

announcementsflag	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
flagId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
entryId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
value	int(11)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

announcementsflag

0

PRIMARY

1

flagId

A

0

(NULL)

(NULL)

BTREE

announcementsflag

0

IX_4539A99C

1

userId

A

0

(NULL)

(NULL)

YES

BTREE

announcementsflag

0

IX_4539A99C

2

entryId

A

0

(NULL)

(NULL)

YES

BTREE

announcementsflag

0

IX_4539A99C

3

value

A

0

(NULL)

(NULL)

YES

BTREE

announcementsflag

1

IX_9C7EB9F

1

entryId

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

assetcategory	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
categoryId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
parentCategoryId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
leftCategoryId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
rightCategoryId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
name	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
title	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
description	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
vocabularyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

assetcategory

0

PRIMARY

1

categoryId

A

0

(NULL)

(NULL)

BTREE

assetcategory

0

IX_BE4DF2BF

1

parentCategoryId

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

0

IX_BE4DF2BF

2

name

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

0

IX_BE4DF2BF

3

vocabularyId

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

0

IX_E8D019AA

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

0

IX_E8D019AA

2

groupId

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

1

IX_E639E2F6

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

1

IX_2008FACB

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

1

IX_2008FACB

2

vocabularyId

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

1

IX_D61ABE08

1

name

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

1

IX_D61ABE08

2

vocabularyId

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

1

IX_7BB1826B

1

parentCategoryId

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

1

IX_9DDD15EA

1

parentCategoryId

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

1

IX_9DDD15EA

2

name

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

1

IX_B185E980

1

parentCategoryId

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

1

IX_B185E980

2

vocabularyId

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

1

IX_4D37BB00

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

assetcategory

1

IX_287B1F89

1

vocabularyId

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

assetcategoryproperty	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
categoryPropertyId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
categoryId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
key_	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
value	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

assetcategoryproperty

0

PRIMARY

1

categoryPropertyId

A

0

(NULL)

(NULL)

BTREE

assetcategoryproperty

0

IX_DBD111AA

1

categoryId

A

0

(NULL)

(NULL)

YES

BTREE

assetcategoryproperty

0

IX_DBD111AA

2

key_

A

0

(NULL)

(NULL)

YES

BTREE

assetcategoryproperty

1

IX_99DA856

1

categoryId

A

0

(NULL)

(NULL)

YES

BTREE

assetcategoryproperty

1

IX_8654719F

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

assetcategoryproperty

1

IX_52340033

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

assetcategoryproperty

1

IX_52340033

2

key_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

assetentries_assetcategories	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
entryId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
categoryId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

assetentries_assetcategories

0

PRIMARY

1

entryId

A

0

(NULL)

(NULL)

BTREE

assetentries_assetcategories

0

PRIMARY

2

categoryId

A

0

(NULL)

(NULL)

BTREE

assetentries_assetcategories

1

IX_A188F560

1

categoryId

A

0

(NULL)

(NULL)

BTREE

assetentries_assetcategories

1

IX_E119938A

1

entryId

A

0

(NULL)

(NULL)

BTREE

Back

&nbsp

assetentries_assettags	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
entryId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
tagId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

assetentries_assettags

0

PRIMARY

1

entryId

A

0

(NULL)

(NULL)

BTREE

assetentries_assettags

0

PRIMARY

2

tagId

A

0

(NULL)

(NULL)

BTREE

assetentries_assettags

1

IX_2ED82CAD

1

entryId

A

0

(NULL)

(NULL)

BTREE

assetentries_assettags

1

IX_B2A61B55

1

tagId

A

0

(NULL)

(NULL)

BTREE

Back

&nbsp

assetentry	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
entryId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
classNameId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
classPK	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
classUuid	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
classTypeId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
visible	tinyint(4)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
startDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
endDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
publishDate	datetime	(NULL)	YES	MUL	(NULL)		select,insert,update,references
expirationDate	datetime	(NULL)	YES	MUL	(NULL)		select,insert,update,references
mimeType	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
title	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
description	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
summary	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
url	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
layoutUuid	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
height	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
width	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
priority	double	(NULL)	YES		(NULL)		select,insert,update,references
viewCount	int(11)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

assetentry

0

PRIMARY

1

entryId

A

22

(NULL)

(NULL)

BTREE

assetentry

0

IX_1E9D371D

1

classNameId

A

4

(NULL)

(NULL)

YES

BTREE

assetentry

0

IX_1E9D371D

2

classPK

A

22

(NULL)

(NULL)

YES

BTREE

assetentry

1

IX_FC1F9C7B

1

classUuid

A

22

(NULL)

(NULL)

YES

BTREE

assetentry

1

IX_7306C60

1

companyId

A

2

(NULL)

(NULL)

YES

BTREE

assetentry

1

IX_75D42FF9

1

expirationDate

A

2

(NULL)

(NULL)

YES

BTREE

assetentry

1

IX_1EBA6821

1

groupId

A

22

(NULL)

(NULL)

YES

BTREE

assetentry

1

IX_1EBA6821

2

classUuid

A

22

(NULL)

(NULL)

YES

BTREE

assetentry

1

IX_2E4E3885

1

publishDate

A

2

(NULL)

(NULL)

YES

BTREE

assetentry

1

IX_9029E15A

1

visible

A

2

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

assetlink	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
linkId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
entryId1	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
entryId2	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
type_	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
weight	int(11)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

assetlink

0

PRIMARY

1

linkId

A

0

(NULL)

(NULL)

BTREE

assetlink

0

IX_8F542794

1

entryId1

A

0

(NULL)

(NULL)

YES

BTREE

assetlink

0

IX_8F542794

2

entryId2

A

0

(NULL)

(NULL)

YES

BTREE

assetlink

0

IX_8F542794

3

type_

A

0

(NULL)

(NULL)

YES

BTREE

assetlink

1

IX_128516C8

1

entryId1

A

0

(NULL)

(NULL)

YES

BTREE

assetlink

1

IX_56E0AB21

1

entryId1

A

0

(NULL)

(NULL)

YES

BTREE

assetlink

1

IX_56E0AB21

2

entryId2

A

0

(NULL)

(NULL)

YES

BTREE

assetlink

1

IX_14D5A20D

1

entryId1

A

0

(NULL)

(NULL)

YES

BTREE

assetlink

1

IX_14D5A20D

2

type_

A

0

(NULL)

(NULL)

YES

BTREE

assetlink

1

IX_12851A89

1

entryId2

A

0

(NULL)

(NULL)

YES

BTREE

assetlink

1

IX_91F132C

1

entryId2

A

0

(NULL)

(NULL)

YES

BTREE

assetlink

1

IX_91F132C

2

type_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

assettag	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
tagId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
name	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
assetCount	int(11)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

assettag

0

PRIMARY

1

tagId

A

0

(NULL)

(NULL)

BTREE

assettag

1

IX_7C9E46BA

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

assettag

1

IX_D63322F9

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

assettag

1

IX_D63322F9

2

name

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

assettagproperty	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
tagPropertyId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
tagId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
key_	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
value	varchar(255)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

assettagproperty

0

PRIMARY

1

tagPropertyId

A

0

(NULL)

(NULL)

BTREE

assettagproperty

0

IX_2C944354

1

tagId

A

0

(NULL)

(NULL)

YES

BTREE

assettagproperty

0

IX_2C944354

2

key_

A

0

(NULL)

(NULL)

YES

BTREE

assettagproperty

1

IX_DFF1F063

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

assettagproperty

1

IX_13805BF7

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

assettagproperty

1

IX_13805BF7

2

key_

A

0

(NULL)

(NULL)

YES

BTREE

assettagproperty

1

IX_3269E180

1

tagId

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

assettagstats	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
tagStatsId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
tagId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
classNameId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
assetCount	int(11)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

assettagstats

0

PRIMARY

1

tagStatsId

A

0

(NULL)

(NULL)

BTREE

assettagstats

0

IX_56682CC4

1

tagId

A

0

(NULL)

(NULL)

YES

BTREE

assettagstats

0

IX_56682CC4

2

classNameId

A

0

(NULL)

(NULL)

YES

BTREE

assettagstats

1

IX_50702693

1

classNameId

A

0

(NULL)

(NULL)

YES

BTREE

assettagstats

1

IX_9464CA

1

tagId

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

assetvocabulary	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
vocabularyId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
name	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
title	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
description	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
settings_	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

assetvocabulary

0

PRIMARY

1

vocabularyId

A

1

(NULL)

(NULL)

BTREE

assetvocabulary

0

IX_C0AAD74D

1

groupId

A

1

(NULL)

(NULL)

YES

BTREE

assetvocabulary

0

IX_C0AAD74D

2

name

A

1

(NULL)

(NULL)

YES

BTREE

assetvocabulary

0

IX_1B2B8792

1

uuid_

A

1

(NULL)

(NULL)

YES

BTREE

assetvocabulary

0

IX_1B2B8792

2

groupId

A

1

(NULL)

(NULL)

YES

BTREE

assetvocabulary

1

IX_B22D908C

1

companyId

A

1

(NULL)

(NULL)

YES

BTREE

assetvocabulary

1

IX_B6B8CA0E

1

groupId

A

1

(NULL)

(NULL)

YES

BTREE

assetvocabulary

1

IX_55F58818

1

uuid_

A

1

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

blogsentry	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
entryId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
title	varchar(150)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
urlTitle	varchar(150)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
description	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
content	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
displayDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
allowPingbacks	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references
allowTrackbacks	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references
trackbacks	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
smallImage	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references
smallImageId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
smallImageURL	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
status	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
statusByUserId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
statusByUserName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
statusDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

blogsentry

0

PRIMARY

1

entryId

A

0

(NULL)

(NULL)

BTREE

blogsentry

0

IX_DB780A20

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

0

IX_DB780A20

2

urlTitle

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

0

IX_1B1040FD

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

0

IX_1B1040FD

2

groupId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_72EF6041

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_430D791F

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_430D791F

2

displayDate

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_BB0C2905

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_BB0C2905

2

displayDate

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_BB0C2905

3

status

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_EB2DCE27

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_EB2DCE27

2

status

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_8CACE77B

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_8CACE77B

2

userId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_A5F57B61

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_A5F57B61

2

userId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_A5F57B61

3

status

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_81A50303

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_621E19D

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_621E19D

2

displayDate

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_F0E73383

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_F0E73383

2

displayDate

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_F0E73383

3

status

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_1EFD8EE9

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_1EFD8EE9

2

status

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_FBDE0AA3

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_FBDE0AA3

2

userId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_FBDE0AA3

3

displayDate

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_DA04F689

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_DA04F689

2

userId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_DA04F689

3

displayDate

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_DA04F689

4

status

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_49E15A23

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_49E15A23

2

userId

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_49E15A23

3

status

A

0

(NULL)

(NULL)

YES

BTREE

blogsentry

1

IX_69157A4D

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

blogsstatsuser	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
statsUserId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
entryCount	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
lastPostDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
ratingsTotalEntries	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
ratingsTotalScore	double	(NULL)	YES		(NULL)		select,insert,update,references
ratingsAverageScore	double	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

blogsstatsuser

0

PRIMARY

1

statsUserId

A

0

(NULL)

(NULL)

BTREE

blogsstatsuser

0

IX_82254C25

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

blogsstatsuser

0

IX_82254C25

2

userId

A

0

(NULL)

(NULL)

YES

BTREE

blogsstatsuser

1

IX_90CDA39A

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

blogsstatsuser

1

IX_90CDA39A

2

entryCount

A

0

(NULL)

(NULL)

YES

BTREE

blogsstatsuser

1

IX_43840EEB

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

blogsstatsuser

1

IX_28C78D5C

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

blogsstatsuser

1

IX_28C78D5C

2

entryCount

A

0

(NULL)

(NULL)

YES

BTREE

blogsstatsuser

1

IX_BB51F1D9

1

userId

A

0

(NULL)

(NULL)

YES

BTREE

blogsstatsuser

1

IX_507BA031

1

userId

A

0

(NULL)

(NULL)

YES

BTREE

blogsstatsuser

1

IX_507BA031

2

lastPostDate

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

bookmarksentry	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
entryId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
resourceBlockId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
folderId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
name	varchar(255)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
url	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
description	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
visits	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
priority	int(11)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

bookmarksentry

0

PRIMARY

1

entryId

A

0

(NULL)

(NULL)

BTREE

bookmarksentry

0

IX_EAA02A91

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

bookmarksentry

0

IX_EAA02A91

2

groupId

A

0

(NULL)

(NULL)

YES

BTREE

bookmarksentry

1

IX_E52FF7EF

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

bookmarksentry

1

IX_5200100C

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

bookmarksentry

1

IX_5200100C

2

folderId

A

0

(NULL)

(NULL)

YES

BTREE

bookmarksentry

1

IX_E2E9F129

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

bookmarksentry

1

IX_E2E9F129

2

userId

A

0

(NULL)

(NULL)

YES

BTREE

bookmarksentry

1

IX_E848278F

1

resourceBlockId

A

0

(NULL)

(NULL)

YES

BTREE

bookmarksentry

1

IX_B670BA39

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

bookmarksfolder	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
folderId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
resourceBlockId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
parentFolderId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
name	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
description	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

bookmarksfolder

0

PRIMARY

1

folderId

A

0

(NULL)

(NULL)

BTREE

bookmarksfolder

0

IX_DC2F8927

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

bookmarksfolder

0

IX_DC2F8927

2

groupId

A

0

(NULL)

(NULL)

YES

BTREE

bookmarksfolder

1

IX_2ABA25D7

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

bookmarksfolder

1

IX_7F703619

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

bookmarksfolder

1

IX_967799C0

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

bookmarksfolder

1

IX_967799C0

2

parentFolderId

A

0

(NULL)

(NULL)

YES

BTREE

bookmarksfolder

1

IX_28A49BB9

1

resourceBlockId

A

0

(NULL)

(NULL)

YES

BTREE

bookmarksfolder

1

IX_451E7AE3

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

browsertracker	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
browserTrackerId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES	UNI	(NULL)		select,insert,update,references
browserKey	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

browsertracker

0

PRIMARY

1

browserTrackerId

A

0

(NULL)

(NULL)

BTREE

browsertracker

0

IX_E7B95510

1

userId

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

calevent	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
eventId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
title	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
description	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
location	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
startDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
endDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
durationHour	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
durationMinute	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
allDay	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references
timeZoneSensitive	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references
type_	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
repeating	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references
recurrence	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
remindBy	int(11)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
firstReminder	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
secondReminder	int(11)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

calevent

0

PRIMARY

1

eventId

A

0

(NULL)

(NULL)

BTREE

calevent

0

IX_5CCE79C8

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

calevent

0

IX_5CCE79C8

2

groupId

A

0

(NULL)

(NULL)

YES

BTREE

calevent

1

IX_D6FD9496

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

calevent

1

IX_12EE4898

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

calevent

1

IX_4FDDD2BF

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

calevent

1

IX_4FDDD2BF

2

repeating

A

0

(NULL)

(NULL)

YES

BTREE

calevent

1

IX_FCD7C63D

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

calevent

1

IX_FCD7C63D

2

type_

A

0

(NULL)

(NULL)

YES

BTREE

calevent

1

IX_FD93CBFA

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

calevent

1

IX_FD93CBFA

2

type_

A

0

(NULL)

(NULL)

YES

BTREE

calevent

1

IX_FD93CBFA

3

repeating

A

0

(NULL)

(NULL)

YES

BTREE

calevent

1

IX_F6006202

1

remindBy

A

0

(NULL)

(NULL)

YES

BTREE

calevent

1

IX_C1AD2122

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

classname_	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
classNameId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
value	varchar(200)	latin1_swedish_ci	YES	UNI	(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

classname_

0

PRIMARY

1

classNameId

A

156

(NULL)

(NULL)

BTREE

classname_

0

IX_B27A301F

1

value

A

156

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

clustergroup	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
clusterGroupId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
name	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
clusterNodeIds	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
wholeCluster	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

clustergroup

0

PRIMARY

1

clusterGroupId

A

0

(NULL)

(NULL)

BTREE

Back

&nbsp

company	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
companyId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
accountId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
webId	varchar(75)	latin1_swedish_ci	YES	UNI	(NULL)		select,insert,update,references
key_	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
mx	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
homeURL	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
logoId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
system	tinyint(4)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
maxUsers	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
active_	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

company

0

PRIMARY

1

companyId

A

1

(NULL)

(NULL)

BTREE

company

0

IX_EC00543C

1

webId

A

1

(NULL)

(NULL)

YES

BTREE

company

1

IX_38EFE3FD

1

logoId

A

1

(NULL)

(NULL)

YES

BTREE

company

1

IX_12566EC2

1

mx

A

1

(NULL)

(NULL)

YES

BTREE

company

1

IX_35E3E7C6

1

system

A

1

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

contact_	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
contactId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
accountId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
parentContactId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
firstName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
middleName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
lastName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
prefixId	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
suffixId	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
male	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references
birthday	datetime	(NULL)	YES		(NULL)		select,insert,update,references
smsSn	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
aimSn	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
facebookSn	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
icqSn	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
jabberSn	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
msnSn	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
mySpaceSn	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
skypeSn	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
twitterSn	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
ymSn	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
employeeStatusId	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
employeeNumber	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
jobTitle	varchar(100)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
jobClass	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
hoursOfOperation	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

contact_

0

PRIMARY

1

contactId

A

2

(NULL)

(NULL)

BTREE

contact_

1

IX_66D496A3

1

companyId

A

2

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

counter	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
name	varchar(75)	latin1_swedish_ci	NO	PRI	(NULL)		select,insert,update,references
currentId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

counter

0

PRIMARY

1

name

A

14

(NULL)

(NULL)

BTREE

Back

&nbsp

country	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
countryId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
name	varchar(75)	latin1_swedish_ci	YES	UNI	(NULL)		select,insert,update,references
a2	varchar(75)	latin1_swedish_ci	YES	UNI	(NULL)		select,insert,update,references
a3	varchar(75)	latin1_swedish_ci	YES	UNI	(NULL)		select,insert,update,references
number_	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
idd_	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
zipRequired	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references
active_	tinyint(4)	(NULL)	YES	MUL	(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

country

0

PRIMARY

1

countryId

A

227

(NULL)

(NULL)

BTREE

country

0

IX_717B97E1

1

a2

A

227

(NULL)

(NULL)

YES

BTREE

country

0

IX_717B9BA2

1

a3

A

227

(NULL)

(NULL)

YES

BTREE

country

0

IX_19DA007B

1

name

A

227

(NULL)

(NULL)

YES

BTREE

country

1

IX_25D734CD

1

active_

A

2

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

cyrususer	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
userId	varchar(75)	latin1_swedish_ci	NO	PRI	(NULL)		select,insert,update,references
password_	varchar(75)	latin1_swedish_ci	NO		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

cyrususer

0

PRIMARY

1

userId

A

0

(NULL)

(NULL)

BTREE

Back

&nbsp

cyrusvirtual	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
emailAddress	varchar(75)	latin1_swedish_ci	NO	PRI	(NULL)		select,insert,update,references
userId	varchar(75)	latin1_swedish_ci	NO		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

cyrusvirtual

0

PRIMARY

1

emailAddress

A

0

(NULL)

(NULL)

BTREE

Back

&nbsp

ddlrecord	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
recordId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
versionUserId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
versionUserName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
DDMStorageId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
recordSetId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
version	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
displayIndex	int(11)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

ddlrecord

0

PRIMARY

1

recordId

A

0

(NULL)

(NULL)

BTREE

ddlrecord

0

IX_B4328F39

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

ddlrecord

0

IX_B4328F39

2

groupId

A

0

(NULL)

(NULL)

YES

BTREE

ddlrecord

1

IX_87A6B599

1

recordSetId

A

0

(NULL)

(NULL)

YES

BTREE

ddlrecord

1

IX_AAC564D3

1

recordSetId

A

0

(NULL)

(NULL)

YES

BTREE

ddlrecord

1

IX_AAC564D3

2

userId

A

0

(NULL)

(NULL)

YES

BTREE

ddlrecord

1

IX_8BC2F891

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

ddlrecordset	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
recordSetId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
DDMStructureId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
recordSetKey	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
name	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
description	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
minDisplayRows	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
scope	int(11)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

ddlrecordset

0

PRIMARY

1

recordSetId

A

0

(NULL)

(NULL)

BTREE

ddlrecordset

0

IX_56DAB121

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

ddlrecordset

0

IX_56DAB121

2

recordSetKey

A

0

(NULL)

(NULL)

YES

BTREE

ddlrecordset

0

IX_270BA5E1

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

ddlrecordset

0

IX_270BA5E1

2

groupId

A

0

(NULL)

(NULL)

YES

BTREE

ddlrecordset

1

IX_4FA5969F

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

ddlrecordset

1

IX_561E44E9

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

ddlrecordversion	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
recordVersionId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
DDMStorageId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
recordSetId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
recordId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
version	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
displayIndex	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
status	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
statusByUserId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
statusByUserName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
statusDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

ddlrecordversion

0

PRIMARY

1

recordVersionId

A

0

(NULL)

(NULL)

BTREE

ddlrecordversion

0

IX_C79E347

1

recordId

A

0

(NULL)

(NULL)

YES

BTREE

ddlrecordversion

0

IX_C79E347

2

version

A

0

(NULL)

(NULL)

YES

BTREE

ddlrecordversion

1

IX_2F4DDFE1

1

recordId

A

0

(NULL)

(NULL)

YES

BTREE

ddlrecordversion

1

IX_762ADC7

1

recordId

A

0

(NULL)

(NULL)

YES

BTREE

ddlrecordversion

1

IX_762ADC7

2

status

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

ddmcontent	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
contentId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
name	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
description	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
xml	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

ddmcontent

0

PRIMARY

1

contentId

A

0

(NULL)

(NULL)

BTREE

ddmcontent

0

IX_EB9BDE28

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

ddmcontent

0

IX_EB9BDE28

2

groupId

A

0

(NULL)

(NULL)

YES

BTREE

ddmcontent

1

IX_E3BAF436

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

ddmcontent

1

IX_50BF1038

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

ddmcontent

1

IX_AE4B50C2

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

ddmstoragelink	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
storageLinkId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
classNameId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
classPK	bigint(20)	(NULL)	YES	UNI	(NULL)		select,insert,update,references
structureId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

ddmstoragelink

0

PRIMARY

1

storageLinkId

A

0

(NULL)

(NULL)

BTREE

ddmstoragelink

0

IX_702D1AD5

1

classPK

A

0

(NULL)

(NULL)

YES

BTREE

ddmstoragelink

1

IX_81776090

1

structureId

A

0

(NULL)

(NULL)

YES

BTREE

ddmstoragelink

1

IX_32A18526

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

ddmstructure	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
structureId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
classNameId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
structureKey	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
name	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
description	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
xsd	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
storageType	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
type_	int(11)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

ddmstructure

0

PRIMARY

1

structureId

A

28

(NULL)

(NULL)

BTREE

ddmstructure

0

IX_490E7A1E

1

groupId

A

5

(NULL)

(NULL)

YES

BTREE

ddmstructure

0

IX_490E7A1E

2

structureKey

A

28

(NULL)

(NULL)

YES

BTREE

ddmstructure

0

IX_85C7EBE2

1

uuid_

A

28

(NULL)

(NULL)

YES

BTREE

ddmstructure

0

IX_85C7EBE2

2

groupId

A

28

(NULL)

(NULL)

YES

BTREE

ddmstructure

1

IX_31817A62

1

classNameId

A

9

(NULL)

(NULL)

YES

BTREE

ddmstructure

1

IX_C8419FBE

1

groupId

A

5

(NULL)

(NULL)

YES

BTREE

ddmstructure

1

IX_E61809C8

1

uuid_

A

28

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

ddmstructurelink	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
structureLinkId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
classNameId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
classPK	bigint(20)	(NULL)	YES	UNI	(NULL)		select,insert,update,references
structureId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

ddmstructurelink

0

PRIMARY

1

structureLinkId

A

0

(NULL)

(NULL)

BTREE

ddmstructurelink

0

IX_C803899D

1

classPK

A

0

(NULL)

(NULL)

YES

BTREE

ddmstructurelink

1

IX_D43E4208

1

classNameId

A

0

(NULL)

(NULL)

YES

BTREE

ddmstructurelink

1

IX_17692B58

1

structureId

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

ddmtemplate	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
templateId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
structureId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
name	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
description	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
type_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
mode_	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
language	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
script	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

ddmtemplate

0

PRIMARY

1

templateId

A

0

(NULL)

(NULL)

BTREE

ddmtemplate

0

IX_1AA75CE3

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

ddmtemplate

0

IX_1AA75CE3

2

groupId

A

0

(NULL)

(NULL)

YES

BTREE

ddmtemplate

1

IX_DB24DDDD

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

ddmtemplate

1

IX_33BEF579

1

language

A

0

(NULL)

(NULL)

YES

BTREE

ddmtemplate

1

IX_C9757A51

1

structureId

A

0

(NULL)

(NULL)

YES

BTREE

ddmtemplate

1

IX_5BC0E264

1

structureId

A

0

(NULL)

(NULL)

YES

BTREE

ddmtemplate

1

IX_5BC0E264

2

type_

A

0

(NULL)

(NULL)

YES

BTREE

ddmtemplate

1

IX_5B019FE8

1

structureId

A

0

(NULL)

(NULL)

YES

BTREE

ddmtemplate

1

IX_5B019FE8

2

type_

A

0

(NULL)

(NULL)

YES

BTREE

ddmtemplate

1

IX_5B019FE8

3

mode_

A

0

(NULL)

(NULL)

YES

BTREE

ddmtemplate

1

IX_C4F283C8

1

type_

A

0

(NULL)

(NULL)

YES

BTREE

ddmtemplate

1

IX_F2A243A7

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

dlcontent	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
contentId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
repositoryId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
path_	varchar(255)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
version	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
data_	longblob	(NULL)	YES		(NULL)		select,insert,update,references
size_	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

dlcontent

0

PRIMARY

1

contentId

A

0

(NULL)

(NULL)

BTREE

dlcontent

0

IX_FDD1AAA8

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

dlcontent

0

IX_FDD1AAA8

2

repositoryId

A

0

(NULL)

(NULL)

YES

BTREE

dlcontent

0

IX_FDD1AAA8

3

path_

A

0

(NULL)

(NULL)

YES

BTREE

dlcontent

0

IX_FDD1AAA8

4

version

A

0

(NULL)

(NULL)

YES

BTREE

dlcontent

1

IX_6A83A66A

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

dlcontent

1

IX_6A83A66A

2

repositoryId

A

0

(NULL)

(NULL)

YES

BTREE

dlcontent

1

IX_EB531760

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

dlcontent

1

IX_EB531760

2

repositoryId

A

0

(NULL)

(NULL)

YES

BTREE

dlcontent

1

IX_EB531760

3

path_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

dlfileentry	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
fileEntryId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
versionUserId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
versionUserName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
repositoryId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
folderId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
name	varchar(255)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
extension	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
mimeType	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
title	varchar(255)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
description	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
extraSettings	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
fileEntryTypeId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
version	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
size_	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
readCount	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
smallImageId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
largeImageId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
custom1ImageId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
custom2ImageId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

dlfileentry

0

PRIMARY

1

fileEntryId

A

0

(NULL)

(NULL)

BTREE

dlfileentry

0

IX_5391712

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

0

IX_5391712

2

folderId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

0

IX_5391712

3

name

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

0

IX_ED5CA615

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

0

IX_ED5CA615

2

folderId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

0

IX_ED5CA615

3

title

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

0

IX_BC2E7E6A

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

0

IX_BC2E7E6A

2

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

1

IX_4CB1B2B4

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

1

IX_F4AF5636

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

1

IX_93CF8193

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

1

IX_93CF8193

2

folderId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

1

IX_29D0AF28

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

1

IX_29D0AF28

2

folderId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

1

IX_29D0AF28

3

fileEntryTypeId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

1

IX_43261870

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

1

IX_43261870

2

userId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

1

IX_D20C434D

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

1

IX_D20C434D

2

userId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

1

IX_D20C434D

3

folderId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentry

1

IX_64F0FE40

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

dlfileentrymetadata	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
fileEntryMetadataId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
DDMStorageId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
DDMStructureId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
fileEntryTypeId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
fileEntryId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
fileVersionId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

dlfileentrymetadata

0

PRIMARY

1

fileEntryMetadataId

A

0

(NULL)

(NULL)

BTREE

dlfileentrymetadata

0

IX_7332B44F

1

DDMStructureId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentrymetadata

0

IX_7332B44F

2

fileVersionId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentrymetadata

1

IX_4F40FE5E

1

fileEntryId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentrymetadata

1

IX_A44636C9

1

fileEntryId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentrymetadata

1

IX_A44636C9

2

fileVersionId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentrymetadata

1

IX_F8E90438

1

fileEntryTypeId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentrymetadata

1

IX_1FE9C04

1

fileVersionId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileentrymetadata

1

IX_D49AB5D1

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

dlfileentrytype	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
fileEntryTypeId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
name	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
description	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

dlfileentrytype

0

PRIMARY

1

fileEntryTypeId

A

5

(NULL)

(NULL)

BTREE

dlfileentrytype

0

IX_E9B6A85B

1

groupId

A

5

(NULL)

(NULL)

YES

BTREE

dlfileentrytype

0

IX_E9B6A85B

2

name

A

5

(NULL)

(NULL)

YES

BTREE

dlfileentrytype

0

IX_1399D844

1

uuid_

A

5

(NULL)

(NULL)

YES

BTREE

dlfileentrytype

0

IX_1399D844

2

groupId

A

5

(NULL)

(NULL)

YES

BTREE

dlfileentrytype

1

IX_4501FD9C

1

groupId

A

5

(NULL)

(NULL)

YES

BTREE

dlfileentrytype

1

IX_90724726

1

uuid_

A

5

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

dlfileentrytypes_ddmstructures	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
fileEntryTypeId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
structureId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

dlfileentrytypes_ddmstructures

0

PRIMARY

1

fileEntryTypeId

A

7

(NULL)

(NULL)

BTREE

dlfileentrytypes_ddmstructures

0

PRIMARY

2

structureId

A

7

(NULL)

(NULL)

BTREE

dlfileentrytypes_ddmstructures

1

IX_8373EC7C

1

fileEntryTypeId

A

7

(NULL)

(NULL)

BTREE

dlfileentrytypes_ddmstructures

1

IX_F147CF3F

1

structureId

A

7

(NULL)

(NULL)

BTREE

Back

&nbsp

dlfileentrytypes_dlfolders	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
fileEntryTypeId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
folderId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

dlfileentrytypes_dlfolders

0

PRIMARY

1

fileEntryTypeId

A

0

(NULL)

(NULL)

BTREE

dlfileentrytypes_dlfolders

0

PRIMARY

2

folderId

A

0

(NULL)

(NULL)

BTREE

dlfileentrytypes_dlfolders

1

IX_5BB6AD6C

1

fileEntryTypeId

A

0

(NULL)

(NULL)

BTREE

dlfileentrytypes_dlfolders

1

IX_6E00A2EC

1

folderId

A

0

(NULL)

(NULL)

BTREE

Back

&nbsp

dlfilerank	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
fileRankId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
fileEntryId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

dlfilerank

0

PRIMARY

1

fileRankId

A

0

(NULL)

(NULL)

BTREE

dlfilerank

0

IX_38F0315

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

dlfilerank

0

IX_38F0315

2

userId

A

0

(NULL)

(NULL)

YES

BTREE

dlfilerank

0

IX_38F0315

3

fileEntryId

A

0

(NULL)

(NULL)

YES

BTREE

dlfilerank

1

IX_A65A1F8B

1

fileEntryId

A

0

(NULL)

(NULL)

YES

BTREE

dlfilerank

1

IX_BAFB116E

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfilerank

1

IX_BAFB116E

2

userId

A

0

(NULL)

(NULL)

YES

BTREE

dlfilerank

1

IX_EED06670

1

userId

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

dlfileshortcut	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
fileShortcutId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
repositoryId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
folderId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
toFileEntryId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
status	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
statusByUserId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
statusByUserName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
statusDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

dlfileshortcut

0

PRIMARY

1

fileShortcutId

A

0

(NULL)

(NULL)

BTREE

dlfileshortcut

0

IX_FDB4A946

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

dlfileshortcut

0

IX_FDB4A946

2

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileshortcut

1

IX_B0051937

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileshortcut

1

IX_B0051937

2

folderId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileshortcut

1

IX_ECCE311D

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileshortcut

1

IX_ECCE311D

2

folderId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileshortcut

1

IX_ECCE311D

3

status

A

0

(NULL)

(NULL)

YES

BTREE

dlfileshortcut

1

IX_4B7247F6

1

toFileEntryId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileshortcut

1

IX_4831EBE4

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

dlfileversion	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
fileVersionId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
repositoryId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
folderId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
fileEntryId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
extension	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
mimeType	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
title	varchar(255)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
description	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
changeLog	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
extraSettings	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
fileEntryTypeId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
version	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
size_	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
status	int(11)	(NULL)	YES		(NULL)		select,insert,update,references
statusByUserId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
statusByUserName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
statusDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

dlfileversion

0

PRIMARY

1

fileVersionId

A

0

(NULL)

(NULL)

BTREE

dlfileversion

0

IX_E2815081

1

fileEntryId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileversion

0

IX_E2815081

2

version

A

0

(NULL)

(NULL)

YES

BTREE

dlfileversion

0

IX_C99B2650

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

dlfileversion

0

IX_C99B2650

2

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileversion

1

IX_C68DC967

1

fileEntryId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileversion

1

IX_D47BB14D

1

fileEntryId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileversion

1

IX_D47BB14D

2

status

A

0

(NULL)

(NULL)

YES

BTREE

dlfileversion

1

IX_DFD809D3

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileversion

1

IX_DFD809D3

2

folderId

A

0

(NULL)

(NULL)

YES

BTREE

dlfileversion

1

IX_DFD809D3

3

status

A

0

(NULL)

(NULL)

YES

BTREE

dlfileversion

1

IX_4BFABB9A

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

Back

&nbsp

dlfolder	&nbsp

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
uuid_	varchar(75)	latin1_swedish_ci	YES	MUL	(NULL)		select,insert,update,references
folderId	bigint(20)	(NULL)	NO	PRI	(NULL)		select,insert,update,references
groupId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
companyId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
userId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
userName	varchar(75)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
createDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
modifiedDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
repositoryId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
mountPoint	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references
parentFolderId	bigint(20)	(NULL)	YES	MUL	(NULL)		select,insert,update,references
name	varchar(100)	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
description	longtext	latin1_swedish_ci	YES		(NULL)		select,insert,update,references
lastPostDate	datetime	(NULL)	YES		(NULL)		select,insert,update,references
defaultFileEntryTypeId	bigint(20)	(NULL)	YES		(NULL)		select,insert,update,references
overrideFileEntryTypes	tinyint(4)	(NULL)	YES		(NULL)		select,insert,update,references

Indexes

Table

Non unique

Key name

Seq in index

Column name

Collation

Cardinality

Sub part

Packed

Null

Index type

Comment

Index comment

dlfolder

0

PRIMARY

1

folderId

A

0

(NULL)

(NULL)

BTREE

dlfolder

0

IX_902FD874

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfolder

0

IX_902FD874

2

parentFolderId

A

0

(NULL)

(NULL)

YES

BTREE

dlfolder

0

IX_902FD874

3

name

A

0

(NULL)

(NULL)

YES

BTREE

dlfolder

0

IX_3CC1DED2

1

uuid_

A

0

(NULL)

(NULL)

YES

BTREE

dlfolder

0

IX_3CC1DED2

2

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfolder

1

IX_A74DB14C

1

companyId

A

0

(NULL)

(NULL)

YES

BTREE

dlfolder

1

IX_F2EA1ACE

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfolder

1

IX_49C37475

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfolder

1

IX_49C37475

2

parentFolderId

A

0

(NULL)

(NULL)

YES

BTREE

dlfolder

1

IX_2A048EA0

1

groupId

A

0

(NULL)

(NULL)

YES

BTREE

dlfolder

1

IX_2A048EA0

2

parentFolderId

A

0

(NULL)

(NULL)

YES

BTREE

dlfolder

1

IX_2A048EA0

3

mountPoint

A

0

(NULL)

(NULL)

YES

BTREE

dlfolder

1

IX_51556082

1

parentFolderId

A

0

(NULL)

(NULL)

YES

BTREE

dlfolder

1

IX_51556082

2

name

A

0

(NULL)

(NULL)

YES

BTREE

dlfolder

1

IX_EE29C715

1

repositoryId

A

0

(NULL)

(NULL)

YES

BTREE

dlfolder</