Database tables for contents and documents/files

[12年前 に Radityaputra Rahardjo によって更新されました。]

Hi guys,

I was wondering, to which table does Liferay portal stores our documents/files and web contents? I need to know because I need to index these files and contents from another web app which is using the Liferay portal repository. And do these tables have a date columns? I need this column to know the last modified date of the files/content. If there isn't a date column, is there any other way to get the last modified date of a file in the database?

Thanks.

[12年前 に Juhi Kumari によって更新されました。]

Hi Radityaputra,

Liferay portal stores documents library files in following tables
dlfileentry,dlfilerank,dlfileshortcut,dlfileversion,dlfolder
and for web contents
journalarticle,journalarticleimage,journalarticleresource,journalcontentsearch,journalfeed,journalstructure,journaltemplate

You can get modified date of web contents in journalarticle,journalfeed,journalstructure,journaltemplate tables
and for Document library file in dlfileentry,dlfileshortcut,dlfolder tables


Regards
Juhi

[6年前 に Cesar Ramírez によって更新されました。]

- Documents library files
DLFileEntry
DLFileRank
DLFileShortcut
DLFileVersion
DLFolder

- Web contents
JournalArticle
JournalArticleImage
JournalArticleResource
JournalContentSearch
JournalFeed
JournalStructure
JournalTemplate

[6年前 に Olaf Kock によって更新されました。]

Cesar Ramírez:

- Documents library files
...

This question has been sleeping peacefully since 2012 - are you sure that these match the version that the original question was asked for? And that the content is even in there?

In fact, just these days, there was yet another Database structure discussion. I'm standing by my word there: You shouldn't look at it. At all. Because when you know what's in there, you might be tempted to change it, and that will lead to disaster.

Use the API.