Alfresco Database storage

[itsmanish]

Hi,
    I installed alfresco on my machine using MySql database,
    I want to know where the documents I upload in alfresco is going to be   stored.
    Is it store in encripted format or in which tables it is stored ?

[dbaran]

Hello,

The Alfresco repository uses database and the filesystem to store respectively data about document and the document itself.
So, your upload documents can be found in the content store directory set by the dir.root property (defined by default as alf_data directory somewhere in tomcat installation, see Repository configuration wiki page to change it)
All uploaded documents are renamed using unique id of the node in the database (uid.bin), but content is not encrypted.

David

[itsmanish]

Hi David,
Thanks for the information I got the uploaded file in alf_data dir

I want to know some more things like :-
1. In which database table this unique id of the node is stored. Database would have information about this unique Id.
2. In which table matadata information of document is stored.
3. alf_data dir has content store folder and it has sub folders named numbers like 2007, 15,7 etc How I can know that in which folder which uploaded file is stored.

[dbaran]

Hi,

1. In which database table this unique id of the node is stored. Database would have information about this unique Id.

Check 'uuid' column in 'alf_node' table, where type_qname = '{http://www.alfresco.org/model/content/1.0}content'

2. In which table matadata information of document is stored.

In 'alf_node_properties' table

3. alf_data dir has content store folder and it has sub folders named numbers like 2007, 15,7 etc How I can know that in which folder which uploaded file is stored.

Sorry, I've no idea about that… :?

David

[itsmanish]

Ok no probs anyway thanks for info

[frederick]

Here is a short comment on the file structure:

http://forums.alfresco.com/viewtopic.php?t=6393

Note that at the time the content is stored, a new GUID is generated for the "***.bin" filename.
This GUID is not related to the GUID of the node owning the content (but the node does keep track of the contentUrl).