Database tables for contents and documents/files

[jaka_prana]

Hi guys,

I was wondering, to which table does Alfresco WCM 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 WCM repository. And do these tables have a date columns? I need this column to know the last modified date of the files/content.

Thanks.

[pawel_rzeszowsk]

Hello jaka_prana,
Alfresco doesn't store content in relational database. Alfresco uses it's own propetriary file system to store it. You can take a look in the folder ALFRESCO_INSTALATION\alf_data\contentstore. It is the place when after default installation content files are stored.
Best Regards,
Pawel Rzeszowski.

[mrogers]

The content store is irrelevant.

However the database implementation is private to Alfresco.

There's various APIs available to list files and modification dates.

[imed]

hey i m just new with alfresco please is there a way to store a database schema and it's content in the repository of alfresco

[sara]

Hello,
I have three question:
1.Do the versions of the file is stored in the file system?(alf_data\contentstore)
2.How can I find a specially content versions?
3.How can I get back up from versions of the contents?
Thanks

[mrogers]

Could you have a go at rewording
"specially content versions"
"How can I get back up from versions of the contents?"

1.Do the versions of the file is stored in the file system?(alf_data\contentstore)
Database and File system.   The implemention should not concern you,

You probably need to use the version service.

[sara]

Could you have a go at rewording
"specially content versions"
"How can I get back up from versions of the contents?"

1.Do the versions of the file is stored in the file system?(alf_data\contentstore)
Database and File system.   The implemention should not concern you,

You probably need to use the version service.

Thanks for your reply
1.In which directory do versions of folders store?
2.How can I find the version of a specified folder ?
3.How can I back up  from versions of folders? I want to move our alfresco in another computer I should be able to back up from current and restore in new one,I did it but there is no versions of folder in new system, that's why I made these question?
thanks in advance