sql.properties

##
## DO NOT EDIT THIS FILE.
##
## To update the properties of this file, create a separate properties file
## named "sql.${user.name}.properties" with the properties to overwrite.
##

##
## General
##

    #
    # Set the create suffix to specify which database scripts to load.
    #
    database.create.suffix=
    #database.create.suffix=-bare

    #
    # Set the database name used by the SQL scripts.
    #
    database.name=lportal

    #
    # Set the database server types to build SQL scripts for.
    #
    database.types=hypersonic,mysql,postgresql
    #database.types=mysql

##
## DB2
##

    db2.arg.line=/c db2 -fcreate${database.create.suffix}/create${database.create.suffix}-db2.sql -td; -zlog/${db2.log}
    db2.executable=db2cmd
    db2.log=db2.log

##
## MariaDB
##

    mariadb.arg.line=-u ${mariadb.user} -p${mariadb.password}
    mariadb.executable=mysql
    mariadb.input=create${database.create.suffix}/create${database.create.suffix}-mysql.sql
    mariadb.log=mysql.log
    mariadb.password=
    mariadb.user=

##
## MySQL
##

    mysql.arg.line=-u ${mysql.user} -p${mysql.password}
    mysql.executable=mysql
    mysql.input=create${database.create.suffix}/create${database.create.suffix}-mysql.sql
    mysql.log=mysql.log
    mysql.password=
    mysql.user=

    #
    # Uncommment the following lines to use MySQL 5.5 instead of MySQL 5.6.
    #
    #mysql.executable=mysql55

##
## Oracle
##

    oracle.admin.password=password
    oracle.admin.user=system
    oracle.arg.line=${oracle.admin.user}/${oracle.admin.password} @create${database.create.suffix}/create${database.create.suffix}-oracle.sql ${oracle.lportal.user} ${oracle.lportal.password}
    oracle.export.arg.line=/c exp ${oracle.lportal.user}/${oracle.lportal.password} file=lportal.dmp owner=${oracle.lportal.user}
    oracle.export.executable=cmd
    oracle.log=oracle.log
    oracle.lportal.password=${database.name}
    oracle.lportal.user=${database.name}
    oracle.lsnrctl.executable=/opt/oracle/bin/lsnrctl
    oracle.sqlplus.executable=sqlplus

##
## PostgreSQL
##

    #
    # The user must have a trust relationship with the Postrgesql server. Set
    # the user's password by setting the environment variable PGPASSWORD.
    #
    postgresql.arg.line=${postgresql.host} ${postgresql.user} -f create${database.create.suffix}/create${database.create.suffix}-postgresql.sql
    postgresql.executable=psql
    postgresql.host=
    #postgresql.host=-h localhost
    postgresql.log=postgresql.log
    postgresql.user=
    #postgresql.user=-U username

##
## SQL Server
##

    sql-server.arg.line=-n -U sa -P -i create${database.create.suffix}/create${database.create.suffix}-sql-server.sql
    sql-server.executable=C:/Program Files/Microsoft SQL Server/80/Tools/Binn/osql.exe
    sql-server.log=sql-server.log

##
## Sybase
##

    sybase.arg.line=-U sa -P -i create${database.create.suffix}/create${database.create.suffix}-sybase.sql
    sybase.executable=C:/Sybase/OCS-15_0/bin/isql.exe
    sybase.log=sybase.log