topic Re: Urgent...!!! Need Alfresco Schema 2.1 script. in Alfresco Archive

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

sashikumar — Thu, 06 Sep 2007 13:37:03 GMT

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..ThanksSashi

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

mikeh — Thu, 06 Sep 2007 14:20:29 GMT

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

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

sashikumar — Fri, 07 Sep 2007 04:54:06 GMT

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

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

kevinr — Tue, 11 Sep 2007 14:29:42 GMT

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