# File and URL's      D:/home/
# --------------------------------------------------------
# URL of the directory dbman resides in. No Trailing Slash Please.
    $db_dir_url     = "/damieng/www/images";
# URL of dbman.
    $db_script_url  = "/damieng/www/images/db.pl";
# Full Path and File name of the database file.
    $db_file_name   = "/damieng/cgi-bin/default.db";
# Full path and file name of the counter file.
    $db_id_file_name = "/damieng/cgi-bin/default.count";
# Full path and file name of the authorization directory.
    $auth_dir       = "/damieng/cgi-bin/auth";
# Full path and file name of the password file.
    $auth_pw_file   = "/damieng/cgi-bin/default.pass";
# Full path and file name of the log file.
    $auth_log_file  = "/damieng/cgi-bin/default.log";
# Full path and file name of the html routines.
    require           "/damieng/cgi-bin/html.pl";

# Database Definition
# --------------------------------------------------------
# Definition of your database. Format is
#       field_name => ['position', 'field_type', 'form-length', 'maxlength', 'not_null', 'default', 'valid_expr']

%db_def = (
            recno          => [0, 'numer',     -1,     8,  1,  '',          ''],
            ProName       => [1, 'alpha',     40,  255,  1,  '',          ''],
            ProDesc         => [2,  'alpha', '40x4',  500,  1,  '',          ''],
            FieldApp        => [3, 'alpha',      40,   60,  1,  '',          ''],
            Dateofreg        => [4, 'date',      12,   15,  1,  &get_date,   ''],
            Comments    => [5, 'alpha',      60,  255,  1,  '',          ''],
            Preview    => [6, 'alpha',      60,  60,  1,  '',          ''],
						Filename      => [7, 'alpha',  60,  60,  1,  '',          '']
        );

# The column name for the database key. Can be any column, but it must be unique!
# You can't have two records with the same key value!
    $db_key         = 'recno';
# Track the key? Should DBMan keep a counter of the next key to use? This isn't
# neccessary if you can guarantee that your entry in the key field will be unique 
# (i.e. a userid).
    $db_key_track   = 1;
# Database delimeter.
    $db_delim       = '|';
# Use file locking (1 = Yes, 0 = No). Should be used, but won't work on Win95.
    $db_use_flock   = 1;
# Auto generate the html forms (1 = Yes, 0 = No).
    $db_auto_generate =  0;
# Display Benchmarking Information (1 = Yes, 0 = No).
    $db_benchmark   = 0;
# Display Debugging Information (1 = Yes, 0 = No).
    $db_debug       = 1;

# Select fields. Field name => 'comma seperated list of drop down options'.
    %db_select_fields   = (
                        Category => 'General,Configuration Management,Project Management,Process Improvement,Standards,Testing & Quality Assurance',
                        Type     => 'Web,Newsgroup,Mailing List,FTP,Gopher'
                    );

# Radio fields. Field name => comma seperated list of radio buttons.
    %db_radio_fields    = ( Validated => 'Yes,No' );

# Checkbox fields. Field name => Checkbox value.
    %db_checkbox_fields = ( Popular => 'Yes' );

# Default maximum number of hits returned in a search.
    $db_max_hits    = 10;
# Bold search results (1 = Yes, 0 = No).
    $db_bold        = 1;
# Regular and title fonts used in auto_generatrion and html.pl.
    $font       = 'font face="verdana,arial,helvetica" size="2"';
    $font_title = 'font face="verdana,arial,helvetica" size="4"';

# Authorization Options
# --------------------------------------------------------
# No Authentication? (1 = "there is no authentication", 0 = "there is authentication")
# If you choose no authentication, then set the permissions of what
# people can do with: @auth_default_permissions below.
    $auth_no_authentication = 0;

# The amount of time in seconds that user files are kept in the
# auth directory before the program removes them. 2-6 hours is
# probably a good value.
    $auth_time          = 21600;      # 6 hours (in seconds)

# Enable (1) or disable (0) logging.
    $auth_logging       = 1;

# Allow a default user? This means you can specify a user via the URL
# and skip the logon process. Use this to allow people to search without
# logging on, but require log in if they want to add/modify/remove etc.
# (1 = "yes", 0 = "no")
    $auth_allow_default = 0;

# Default permissions used if there is no authentication, or for a default
# user. (View, Add, Delete, Modify, Admin), 1 = enable, 0 = disable.
    @auth_default_permissions = (1,1,1,1,0);

# Allow people to sign up for their own userid/passwords? They will
# recieve default permissions.
    $auth_signup        = 1;

# Permissions a new signup should get.
    @auth_signup_permissions = (1,1,1,1,0);

# Registered users: can modify/delete _only_ own records. For this to make
# sense you should set default off or to 1,0,0,0.
    $auth_modify_own    = 0;

# Registered users: can view _only_ own records. For this to make sense
# you should turn off default permissions.
    $auth_view_own      = 0;

# Auth user field. This is the field position in the database used for storing
# the userid who owns the record. Set to -1 if not used.
    $auth_user_field    = 9;



# ===========================================================================
# Build up some variables from your definitions. Internal use only.
foreach (sort { $db_def{$a}[0] <=> $db_def{$b}[0] } keys %db_def) {
    push (@db_cols, $_);
    $db_sort{$_}            = $db_def{$_}[1];
    $db_form_len{$_}        = $db_def{$_}[2];
    $db_lengths{$_}         = $db_def{$_}[3];
    $db_not_null{$_}        = $db_def{$_}[4];
    $db_defaults{$_}        = $db_def{$_}[5];
    $db_valid_types{$_}     = $db_def{$_}[6];
    ($_ eq $db_key)       and $db_key_pos = $db_def{$_}[0];
}
1;