private void createCmdbuildStructure() {
   Log.CMDBUILD.info("Creating CMDBuild structure");
   final List<String> sqlFiles =
       Arrays.asList( //
           baseSqlPath + "01_system_functions_base.sql", //
           baseSqlPath + "02_system_functions_class.sql", //
           baseSqlPath + "03_system_functions_attribute.sql", //
           baseSqlPath + "04_system_functions_domain.sql", //
           baseSqlPath + "05_base_tables.sql", //
           baseSqlPath + "06_system_views_base.sql", //
           baseSqlPath + "07_support_tables.sql", //
           baseSqlPath + "08_user_tables.sql", //
           baseSqlPath + "09_system_views_extras.sql", //
           baseSqlPath + "10_system_functions_extras.sql", //
           baseSqlPath + "11_workflow.sql", //
           baseSqlPath + "12_tecnoteca_extras.sql", //
           baseSqlPath + "13_bim.sql");
   for (final String file : sqlFiles) {
     Log.CMDBUILD.info("applying '{}'", file);
     final String content = FileUtils.getContents(file);
     new JdbcTemplate(systemDataSource()).execute(content);
   }
 }
 private void createSharkTables() {
   Log.CMDBUILD.info("Creating shark tables");
   new JdbcTemplate(sharkDataSource())
       .execute(FileUtils.getContents(sharkSqlPath + "02_shark_emptydb.sql"));
 }
 private void restoreSampleDB() {
   Log.CMDBUILD.info("Restoring demo structure");
   final String filename = sampleSqlPath + configuration.getDatabaseType() + "_schema.sql";
   final String sql = FileUtils.getContents(filename);
   new JdbcTemplate(systemDataSource()).execute(sql);
 }