These directory contains the oracle and postgis sql scripts to set up the csw database.
Please refer the csw documentation for installation instructions. 
Order of execution:
create_database.sql
create_searchTables.sql
create_normal_index.sql
create_spatial_index.sql