How does alfresco design it's database schema ?

[zengqingyi12]

Hi, Can someone tell me how does alfresco design it's database schema, which makes us can dynamic add new fields into database, and can search for them?
Any comments will be appreciated.
Thanks in advance !

[jm_pascal]

Don't touch or modify alfresco database  :wink:

Alfresco database change a little bit during his evolution…

SIDE-Labs has developped a module which permits to use SQL on a real DB design to extract meta data from Alfresco. More information can be found on this wiki :
http://wiki.bluexml.com/index.php/Alfresco_SQL_views

[zengqingyi12]

I don't want to touch it, I just want to know how alfresco do that?

[jm_pascal]

:?  :?  :?  :?
I write too fast  sorry…  :lol:

[zengqingyi12]

Thanks very much for offering me such a good reference !!1