https://connect.hyland.com/t5/nuxeo-forum/how-to-run-sql-script-when-nuxeo-instance-starts/m-p/315124#M2125 <P>Hi, we want to run sql script when our nuxeo instance starts. This script should create tables in database if this not exists. We do not want to use schemas contributions because we do not want to manage those rows tables as documents types.</P> <P>We want to do something equals to nxp_logs because we will use those tables for stats</P> Thu, 31 Oct 2013 13:40:56 GMT geekonspace 2013-10-31T13:40:56Z https://connect.hyland.com/t5/nuxeo-forum/how-to-run-sql-script-when-nuxeo-instance-starts/m-p/315124#M2125 <P>Hi, we want to run sql script when our nuxeo instance starts. This script should create tables in database if this not exists. We do not want to use schemas contributions because we do not want to manage those rows tables as documents types.</P> <P>We want to do something equals to nxp_logs because we will use those tables for stats</P> Thu, 31 Oct 2013 13:40:56 GMT https://connect.hyland.com/t5/nuxeo-forum/how-to-run-sql-script-when-nuxeo-instance-starts/m-p/315124#M2125 geekonspace 2013-10-31T13:40:56Z https://connect.hyland.com/t5/nuxeo-forum/how-to-run-sql-script-when-nuxeo-instance-starts/m-p/315125#M2126 <P>Hello,</P> <P>You can configure VCS to do so. The documentation is here :</P> <P><A href="http://doc.nuxeo.com/display/ADMINDOC/VCS+Configuration">http://doc.nuxeo.com/display/ADMINDOC/VCS+Configuration</A></P> <P>You have to specify a script in the sqlInitFile tag (See database creation option). This scripts holds some commands to pass to the backend given some condictions. As stated in the doc, you'll find some samples here <A href="https://github.com/nuxeo/nuxeo-core/tree/master/nuxeo-core-storage-sql/nuxeo-core-storage-sql/src/main/resources/nuxeovcs">https://github.com/nuxeo/nuxeo-core/tree/master/nuxeo-core-storage-sql/nuxeo-core-storage-sql/src/main/resources/nuxeovcs</A></P> Mon, 04 Nov 2013 10:14:40 GMT https://connect.hyland.com/t5/nuxeo-forum/how-to-run-sql-script-when-nuxeo-instance-starts/m-p/315125#M2126 Damien_Metzler 2013-11-04T10:14:40Z