##

## GUS Configuration

##

## @version $Revision: 11821 $ $Date: 2013-04-07 15:41:45 -0400 (Sun, 07 Apr 2013) $

##

### GUS End User Configuration

# RDBMS Connection Strings

## dbVendor is the RDBMS Vendor. Postgres or Oracle

## dbiDsn is for Perl ( dbi:Oracle:NAME_OF_DATABASE )

## jdbcDsn is for Java ( eg jdbc:oracle:thin:@HOSTNAME:PORT:NAME_OF_DATABASE )

## NAME_OF_DATABASE can be the full service name or a valid alias

dbVendor=Postgres

dbiDsn=DBI:Pg:dbname=@DB_NAME@;host=@DB_HOST@;port=@DB_PORT@

jdbcDsn=jdbc:postgresql://@DB_HOST@:@DB_PORT@/@DB_NAME@

# Your login and Password to the RDBMS

databaseLogin=@DB_USER@

databasePassword=@DB_PASSWORD@

# Username, group, and project info from the relevant Core tables

# All rows written by you will be tagged with this information

userName=@DB_USER@

group=NIAGADS

project=NIAGADS

# override "tablespace=" attribute of <table> entities in gus_schema.xml

tablespace=GUS

# Path to Perl Executable

perl=/usr/bin/perl

# Path to MD5 Executable

md5sum=/usr/bin/md5sum

################################################################################

### Warning: Do not change items below here unless you know what you're doing

################################################################################

# GUS 4.0 candidate schemata

gusSchemas=Core,DoTS,SRes,Study,Platform,Model,Results

coreSchemaName=CORE

sequenceStart=1

### Comma-delimited list of housekeeping columns. In order as they should appear in the tables

housekeepingColumns=MODIFICATION_DATE,USER_READ,USER_WRITE,GROUP_READ,GROUP_WRITE,OTHER_READ,OTHER_WRITE,ROW_USER_ID,ROW_GROUP_ID,ROW_PROJECT_ID,ROW_ALG_INVOCATION_ID

housekeepingColumnsVer=MODIFICATION_DATE,USER_READ,USER_WRITE,GROUP_READ,GROUP_WRITE,OTHER_READ,OTHER_WRITE,ROW_USER_ID,ROW_GROUP_ID,ROW_PROJECT_ID,ROW_ALG_INVOCATION_ID,VERSION_ALG_INVOCATION_ID,VERSION_DATE,VERSION_TRANSACTION_ID

### type,length,precision,nullable

hkspec.MODIFICATION_DATE=DATE,0,0,false

hkspec.USER_READ=NUMBER,1,0,false

hkspec.USER_WRITE=NUMBER,1,0,false

hkspec.GROUP_READ=NUMBER,1,0,false

hkspec.GROUP_WRITE=NUMBER,1,0,false

hkspec.OTHER_READ=NUMBER,1,0,false

hkspec.OTHER_WRITE=NUMBER,1,0,false

hkspec.ROW_USER_ID=NUMBER,12,0,false

hkspec.ROW_GROUP_ID=NUMBER,4,0,false

hkspec.ROW_PROJECT_ID=NUMBER,4,0,false

hkspec.ROW_ALG_INVOCATION_ID=NUMBER,12,0,false

hkspec.VERSION_ALG_INVOCATION_ID=NUMBER,12,0,true

hkspec.VERSION_DATE=DATE,0,0,true

hkspec.VERSION_TRANSACTION_ID=NUMBER,12,0,true