environment "$OMNIDEX_GLOBAL_CONFIGURATION"

/* ===================== DATABASE: $GLOBAL_CONFIGURATION =========== */

database       "$OMNIDEX_GLOBAL_CONFIGURATION"
  type         flatfile
  indexprefix  "idx/OMNIDEX"


/* --------------------- TABLE: $LISTS -------------------------------------- */

table          "$LISTS"
  type         tdf
  physical     "{$OMNIDEX_LANG/lists/*.txt},
                {$OMNIDEX_LANG/lists/*.tdf}"

column "$LIST"        datatype CHARACTER(32)
column "$REPLACEMENT" datatype C STRING(4094)
column "$COMMENTS"    datatype C STRING(255)


/* --------------------- TABLE: $STOPWORDS ---------------------------------- */

table          "$STOPWORDS"
  type         tdf
  physical     "{$OMNIDEX_LANG/stopwords/*.txt},
                {$OMNIDEX_LANG/stopwords/*.tdf}"

column "$LIST"        datatype CHARACTER(32)
column "$WORD"        datatype C STRING(127)
column "$COMMENTS"    datatype C STRING(255)


/* --------------------- TABLE: $SYNONYMS ----------------------------------- */

table          "$SYNONYMS"
  type         tdf
  physical     "{$OMNIDEX_LANG/synonyms/*.txt},
                {$OMNIDEX_LANG/synonyms/*.tdf}"

column "$LIST"        datatype CHARACTER(32)
column "$WORD"        datatype C STRING(127)
column "$REPLACEMENT" datatype C STRING(4094)
column "$COMMENTS"    datatype C STRING(255)


/* --------------------- TABLE: $PHONETIC ----------------------------------- */

table          "$PHONETIC"
  type         tdf
  physical     "{$OMNIDEX_LANG/phonetic/*.txt},
                {$OMNIDEX_LANG/phonetic/*.tdf}"

column "$LIST"        datatype CHARACTER(32)
column "$WORD"        datatype C STRING(127)
column "$TYPE"        datatype CHARACTER(8)
column "$SOUNDEX"     datatype CHARACTER(64)
column "$METAPHONE1"  datatype CHARACTER(64)
column "$METAPHONE2"  datatype CHARACTER(64)
column "$COMMENTS"    datatype C STRING(255)


/* --------------------- TABLE: $INCLUDED_TAGS ------------------------------ */

table          "$INCLUDED_TAGS"
  type         tdf
  physical     "{$OMNIDEX_LANG/included_tags/*.txt},
                {$OMNIDEX_LANG/included_tags/*.tdf}"

column "$LIST"        datatype CHARACTER(32)
column "$TAG"         datatype C STRING(255)
column "$COMMENTS"    datatype C STRING(255)


/* --------------------- TABLE: $EXCLUDED_TAGS ------------------------------ */

table          "$EXCLUDED_TAGS"
  type         tdf
  physical     "{$OMNIDEX_LANG/excluded_tags/*.txt},
                {$OMNIDEX_LANG/excluded_tags/*.tdf}"

column "$LIST"        datatype CHARACTER(32)
column "$TAG"         datatype C STRING(255)
column "$COMMENTS"    datatype C STRING(255)



/* --------------------- TABLE: $MESSAGES ---------------------------------- */

table          "$MESSAGES"
  type         tdf
  physical     "{$OMNIDEX_LANG/messages/*.txt},
                {$OMNIDEX_LANG/messages/*.tdf}"

column "$ERROR"        datatype INTEGER
column "$MESSAGE"      datatype C STRING(255)


/* --------------------- TABLE: $SQL_LOG ----------------------------------- */

table          "$SQL_LOG"
  type         tdf
  physical     "logs/sqllog.txt"

column "$PROCESS_ID"  datatype CHARACTER(16)
column "$TIMESTAMP"   datatype CHARACTER(32)
column "$START_SEQ"   datatype INTEGER
column "$END_SEQ"     datatype INTEGER
column "$TYPE"        datatype CHARACTER(4)
column "$EOF"         datatype CHARACTER(1)
column "$INSTANCE"    datatype INTEGER     
column "$CURSOR"      datatype INTEGER     
column "$ROWS"        datatype INTEGER     
column "$CPU"         datatype FLOAT
column "$ELAPSED"     datatype FLOAT
column "$ERROR"       datatype INTEGER
column "$STATEMENT"   datatype C STRING(65535)


/* --------------------- TABLE: $CONTROL ----------------------------------- */

table          "$CONTROL"     
  physical     "logs/monctl.dat"

column "$ID"          datatype CHARACTER(16)
column "$TIMESTAMP"   datatype INTEGER
column "$HOST"        datatype CHARACTER(32)
column "$AVAIL_ENV"   datatype INTEGER
column "$NUM_ENV"     datatype INTEGER
column "$AVAIL_CONN"  datatype INTEGER
column "$NUM_CONN"    datatype INTEGER
column "$AVAIL_QUERY" datatype INTEGER
column "$NUM_QUERY"   datatype INTEGER
column "$AVAIL_LONG"  datatype INTEGER
column "$NUM_LONG"    datatype INTEGER
column "$LOW_QUERY"   datatype INTEGER
column "$LOW_ELAPSED" datatype DOUBLE


/* --------------------- TABLE: $ACTIVE_ENVIRONMENTS ----------------------- */

table          "$ENVIRONMENTS"
  physical     "logs/monenv.dat"
  autofilter   "$number > 0"

column "$NUMBER"      datatype INTEGER
column "$HOST"        datatype CHARACTER(32)
column "$ENVIRONMENT" datatype C STRING(255)
column "$ACTIVITY"    datatype C DATETIME(4)  

/* --------------------- TABLE: $QUERY_STATISTICS -------------------------- */

table          "$QUERY_STATISTICS"   
  physical     "logs/monstats.dat"
  autofilter   "$number > 0"

column "$NUMBER"      datatype INTEGER
column "$DATESTAMP"   datatype C DATETIME(4)
column "$DAY_OF_WEEK" datatype TINYINT
column "$HOUR"        datatype TINYINT
column "$RESERVED"    datatype CHARACTER(2)
column "$LT_10_MS"    datatype INTEGER
column "$LT_100_MS"   datatype INTEGER
column "$LT_1_SEC"    datatype INTEGER
column "$LT_10_SEC"   datatype INTEGER
column "$LT_100_SEC"  datatype INTEGER
column "$LT_1000_SEC" datatype INTEGER
column "$GE_1000_SEC" datatype INTEGER
column "$TOTAL"       datatype INTEGER as "$LT_10_MS+$LT_100_MS+$LT_1_SEC+$LT_10_SEC+$LT_100_SEC+$LT_1000_SEC+$GE_1000_SEC" 

/* --------------------- TABLE: $CONNECTIONS ------------------------------- */

table          "$CONNECTIONS" 
  physical     "logs/monconn.dat"
  autofilter   "$pid > 0"

column "$HOST"        datatype CHARACTER(32)
column "$OWNER"       datatype CHARACTER(32)
column "$ENVIRONMENT" datatype C STRING(255)
column "$STATE"       datatype CHARACTER(32)
column "$PID"         datatype INTEGER
column "$INSTANCE"    datatype INTEGER
column "$CURSOR"      datatype INTEGER
column "$ACTIVITY"    datatype C DATETIME(4)

/* --------------------- TABLE: $QUERIES ----------------------------------- */

table          "$QUERIES"     
  physical     "logs/monquery.dat"
  autofilter   "$pid > 0"

column "$HOST"        datatype CHARACTER(32)
column "$OWNER"       datatype CHARACTER(32)
column "$ENVIRONMENT" datatype C STRING(255)
column "$STATE"       datatype CHARACTER(32)
column "$PID"         datatype INTEGER
column "$INSTANCE"    datatype INTEGER
column "$CURSOR"      datatype INTEGER
column "$RETRIEVED"   datatype INTEGER
column "$TIMESTAMP"   datatype C DATETIME(4)
column "$ACTIVITY"    datatype C DATETIME(4)
column "$CPU"         datatype DOUBLE
column "$ELAPSED"     datatype DOUBLE

/* --------------------- TABLE: $LONG_QUERIES ------------------------------ */

table          "$LONG_QUERIES"     
  physical     "logs/monqlong.dat"
  autofilter   "$pid > 0"

column "$HOST"        datatype CHARACTER(32)
column "$OWNER"       datatype CHARACTER(32)
column "$PID"         datatype INTEGER
column "$TIMESTAMP"   datatype C DATETIME(4)
column "$RETRIEVED"   datatype INTEGER
column "$RESERVED"    datatype UNSIGNED INTEGER
column "$CPU"         datatype DOUBLE
column "$ELAPSED"     datatype DOUBLE
column "$ENVIRONMENT" datatype C STRING(255)
column "$STATEMENT"   datatype C STRING(65535)


