-----------------------------------------------------------------------------
  DATE: 08/02/103      TIME: 18:49                                  PAGE:  1
  FILE DEFINITION FOR FILE: USER (# 203)
-----------------------------------------------------------------------------
  DRIVER NAME               : DATAFLEX
  FILE ROOT NAME            : USER
  USER DISPLAY NAME         : USER (Basics)
  DATAFLEX FILE NAME        : USER
-----------------------------------------------------------------------------
  RECORD LENGTH             : 1024      ( USED: 992 )
  MAX NUMBER OF RECORDS     : 500000    ( USED: 4 )
  FILE COMPRESSION          : NONE
  RE-USE DELETED SPACE      : YES
  LOCKING TYPE              : FILE
  HEADER INTEGRITY CHECKING : YES
  TRANSACTION TYPE          : CLIENT ATOMIC
  RECORD IDENTITY INDEX     : 0 ( 0 , 0 )
  FILE LOGIN PARAMETER      : 
  SYSTEM FILE               : NO 
-----------------------------------------------------------------------------

NUM  FIELD NAME       TYPE SIZE  OFFST IX   RELATES TO FILE.FIELD
---  ---------------  ---- ----- ----- --   ---------------------------------
  1  USER_ID          NUM   10.0     1  1   
  2  CREATED          DAT      6     6      
  3  LAST_LOGIN_DATE  DAT      6     9      
  4  LAST_LOGIN_TIME  ASC      8    12      
  5  LAST_LOGIN_IP    ASC     18    20      
  6  TIME_IN_MIN      NUM   12.0    38      
  7  NUM_VISITS       NUM    4.0    44      
  8  LOGIN_ID         ASC     35    46  2   
  9  PASSWORD         ASC     12    81  2   
 10  PASSCHECK        ASC     12    93      
 11  EMAIL            ASC    128   105  3   
 12  DEFAULTSKIN      ASC      8   233      
 13  DEFAULTCSSFILE   ASC    120   241      
 14  FIRSTNAME        ASC     50   361      
 15  MIDDLENAME       ASC     20   411      
 16  LASTNAME         ASC     50   431      
 17  COMPANY          ASC     80   481      
 18  EMAIL_ADDRESS    ASC    128   561      
 19  URL_COMPANY      ASC    150   689      
 20  URL_PERSONAL     ASC    150   839      
 21  RIGHTS           NUM    4.0   989      
 22  EMAILLIST        ASC      1   991      
 23  AUTO_LOGIN       ASC      1   992      


INDEX# FIELDS          DES U/C    LENGTH LEVELS SEGMENTS MODE
------ --------------- --- ---    ------ ------ -------- -------
  1    USER_ID         NO  NO       5      3       1     ON-LINE

  2    LOGIN_ID        NO  NO       47     6       2     ON-LINE
       PASSWORD        NO  NO 

  3    EMAIL           NO  YES      133    12      2     ON-LINE
       USER_ID         NO  NO 

  4    LOGIN_ID        NO  NO       35     5       1     ON-LINE

