topic Database manual install in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/database-manual-install/m-p/215218#M168348 <HTML><HEAD></HEAD><BODY><SPAN>I think in the past&nbsp; mysql/db_setup.sql&nbsp; had the code that created all the tables.&nbsp; It seems that only the database is created now.&nbsp; Where do I find the sql statement to create the tables manually?&nbsp; </SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><BR /><SPAN>-bash-3.2# cat /opt/Alfresco/extras/databases/mysql/db_setup.sql</SPAN><BR /><SPAN>create database alfresco default character set utf8;</SPAN><BR /><SPAN>grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;</SPAN><BR /><SPAN>grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;-bash-3.2#</SPAN></BODY></HTML> Fri, 31 Jul 2009 06:31:56 GMT newmember 2009-07-31T06:31:56Z Database manual install https://connect.hyland.com/t5/alfresco-archive/database-manual-install/m-p/215218#M168348 I think in the past&nbsp; mysql/db_setup.sql&nbsp; had the code that created all the tables.&nbsp; It seems that only the database is created now.&nbsp; Where do I find the sql statement to create the tables manually?&nbsp; Thanks-bash-3.2# cat /opt/Alfresco/extras/databases/mysql/db_setup.sqlcreate database alfresco defaul Fri, 31 Jul 2009 06:31:56 GMT https://connect.hyland.com/t5/alfresco-archive/database-manual-install/m-p/215218#M168348 newmember 2009-07-31T06:31:56Z Re: Database manual install https://connect.hyland.com/t5/alfresco-archive/database-manual-install/m-p/215219#M168349 <HTML><HEAD></HEAD><BODY><SPAN>No, that's all the db_setup sql has ever done.</SPAN><BR /><BR /><SPAN>The database scripts are in WEB-INF/classes/alfresco/dbscripts</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Mike</SPAN></BODY></HTML> Fri, 31 Jul 2009 07:39:18 GMT https://connect.hyland.com/t5/alfresco-archive/database-manual-install/m-p/215219#M168349 mikeh 2009-07-31T07:39:18Z