...
- portal_sql is the name of your repository,
- sql_code is the name of the directory where the packager will look for new/modified .sql files to package, this directory is reference in the deployPackager.properties in your DaticalDB project
- the sub-directories represent the different kinds of SQL scripts to package. The process order for a commit is the following: ddl, view, function, function, procedure, package, packagebody, trigger, sql_direct and finally data_dml. More details cane be found at Placing SQL Scripts in the SCM Repository/wiki/spaces/DDD/pages/269812097.
metadata.properties
In each directory under the top level one (sql_code in this example), you can create configuration file named metadata, where you can pass some additional directives to the packager (like additional label or context).
...