Urgent...!!! Need Alfresco Schema 2.1 script.

[sashikumar]

Hi,

Where i can get the alfresco schema 2.1 sql script for mysql 5.0.

urgently needed where are the  scripts to have full 2.1 alfresco?? i.e. including schema changes.

Pls guide me..


Thanks
Sashi

[mikeh]

Do you mean db_setup.sql?

create database alfresco;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;‍‍‍

Thanks,
Mike

[sashikumar]

Hi,
Thanks for the reply,

We need actual script for alfresco 2.1 schema sql file ie creating the table \indexes\constraints etc …


Thanks
Sashi

[kevinr]

There is nothing else you need to run. From the first release of Alfresco the server has created the schema automatically when it is first started against an empty database - the same thing happens today. We use the features of the Hibernate library to do this. Also our schema is "auto updating" when you upgrade between server versions.

Thanks,

Kevin