Sunday, 10 February 2013

File upload using serveResource() (AJAX call)

Objective : More oftenly we come across such requirements, when we need to do upload file using AJAX.(i.e. page must not be refreshed after upload).

Problem : we cannot directly upload by giving the <portlet:resourceURL> in jsp and then uploading in action class in serveResource() method, because UploadPortletRequest does not perform as is expected.

Introduction : For the same I found the solution of using ajaxfileupload.js
link : http://www.phpletter.com/DOWNLOAD/

Description :

in your jsp:

<portlet:resourceURL id="uploadMe" var="uploadMe" />



<form method="post" enctype="multipart/form-data" name="form" id=" ">
        <div class="popup_row2">
        <p><liferay-ui:message key="select_csv_file_to_upload_using_the_browse_button_then_click_upload" /></p>
           <div class="popup_row2_browse popup_add_bottomBtns" id="uploadFileDiv"> 
              <input type="file" name="fileToUpload" id="fileToUpload" value="Browse" class="input" required="required"/>
          </div>          
       </div>
       <div class="popup_row3">
        <p><liferay-ui:message key="csv_file_uploaded_successfully" /></p>
           <input type="button" name="upload" id="upload" value="Upload"  class="noText_shadow" onclick="uploadFileMe()" />
       </div>
 </form>

 js functiom:


function uploadFileMe(){
$.ajaxFileUpload
(
{
url:'<%=uploadMe%>',
secureuri : false,
fileElementId : 'fileToUpload',
dataType : 'json',
data : {
name : 'logan',
id : 'id'
},
success : function(data, status) {
if (typeof (data.error) != 'undefined') {
if (data.error != '') {
//alert(data.error);
} else {
//alert(data.msg);
}
}
},
error : function(data, status, e) {
//alert(e);
}
});
}

 in your action class:


public void serveResource(ResourceRequest resourceRequest,
ResourceResponse resourceResponse) throws PortletException, IOException {

try {
UploadPortletRequest uploadrequest = PortalUtil
.getUploadPortletRequest(resourceRequest);
InputStream inputStream = uploadrequest
.getFileAsStream("fileToUpload");
if(Validator.isNotNull(inputStream)){
File file = FileUtil.createTempFile(inputStream);
String uploadString = getFileAsString(file);

if (Validator.isNotNull(uploadString)) {

resourceResponse.getWriter().write( "validated_successfully");


LOGGER.info("VALIDATED_SUCCESSFULLY");
}else{
resourceResponse.getWriter().write( "failed");

LOGGER.info("VALIDATION_FAILED");
}
}
} catch (Exception e) {

LOGGER.error( "Error in adding modem");
}
}

public String getFileAsString(File file) {
FileInputStream fis = null;
BufferedInputStream bis = null;
DataInputStream dis = null;
StringBuffer sb = new StringBuffer();
try {
fis = new FileInputStream(file);
bis = new BufferedInputStream(fis);
dis = new DataInputStream(bis);

while (dis.available() != 0) {
sb.append(dis.readLine() + "\n");
}
fis.close();
bis.close();
dis.close();

} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return sb.toString();
}



Conclusion: File can now be uploaded and validated on ajax call without refreshing the page.

Posted by at 8 comments:

Monday, 17 December 2012

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
Posted by at No comments:

Tuesday, 11 December 2012

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>

Posted by at No comments:

Monday, 10 December 2012

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);
            } 
Posted by at No comments:

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.


Posted by at No comments:

Wednesday, 31 October 2012

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
&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</
Posted by at 3 comments:
Subscribe to: Posts (Atom)