tce_db_config.php
Tags
Table of Contents
Constants
- K_DATABASE_HOST = ''
- database Host name (eg: localhost)
- K_DATABASE_NAME = ''
- database name (TCExam)
- K_DATABASE_PORT = ''
- database port (eg: 3306, 5432, 1521)
- K_DATABASE_TYPE = ''
- database type (MYSQL, POSTGRESQL, ORACLE)
- K_DATABASE_USER_NAME = ''
- database user name
- K_DATABASE_USER_PASSWORD = ''
- database user password
- K_TABLE_ANSWERS = \K_TABLE_PREFIX . 'answers'
- This table contains all answers relative to a specific questions.
- K_TABLE_GROUPS = \K_TABLE_PREFIX . 'user_groups'
- This table contains users' groups. Each user belongs to one of the groups defined in this table.
- K_TABLE_LOG_ANSWER = \K_TABLE_PREFIX . 'tests_logs_answers'
- This table contains the list of the selected alternative answers for each multiple-choice question.
- K_TABLE_MODULES = \K_TABLE_PREFIX . 'modules'
- Table for modules. A module is a container for subjects.
- K_TABLE_PREFIX = 'tce_'
- prefix for database tables names
- K_TABLE_QUESTIONS = \K_TABLE_PREFIX . 'questions'
- This table contains all questions relative to specific subjects.
- K_TABLE_SESSIONS = \K_TABLE_PREFIX . 'sessions'
- This table stores information about users' Web sessions.
- K_TABLE_SSLCERTS = \K_TABLE_PREFIX . 'sslcerts'
- This table contains the SSL certificates.
- K_TABLE_SUBJECT_SET = \K_TABLE_PREFIX . 'test_subjects'
- This table contains all tests subjects (topics, branch of studies).
- K_TABLE_SUBJECTS = \K_TABLE_PREFIX . 'subjects'
- This table contains all tests subjects (topics, branch of studies).
- K_TABLE_TEST_GROUPS = \K_TABLE_PREFIX . 'testgroups'
- This table contains the list of groups enabled for a selected test.
- K_TABLE_TEST_SSLCERTS = \K_TABLE_PREFIX . 'testsslcerts'
- This table contains the list of SSL certificates enabled for a selected test.
- K_TABLE_TEST_SUBJSET = \K_TABLE_PREFIX . 'test_subject_set'
- This table lists the type and quantity of the questions associated to each set of subjects selected for a particular test.
- K_TABLE_TEST_USER = \K_TABLE_PREFIX . 'tests_users'
- This table contains the list of tests generated for each user.
- K_TABLE_TESTS = \K_TABLE_PREFIX . 'tests'
- This table contains all tests data.
- K_TABLE_TESTS_LOGS = \K_TABLE_PREFIX . 'tests_logs'
- This table contains all questions and user answers relative to a specific test for a specific user.
- K_TABLE_TESTUSER_STAT = \K_TABLE_PREFIX . 'testuser_stat'
- This table counts the number of generated tests.
- K_TABLE_USERGROUP = \K_TABLE_PREFIX . 'usrgroups'
- This table contains the list of groups to whom each user belongs.
- K_TABLE_USERS = \K_TABLE_PREFIX . 'users'
- This table contains all registered users' data, including system administrators and a special 'anonymous' user.
Constants
K_DATABASE_HOST
database Host name (eg: localhost)
public mixed K_DATABASE_HOST =
''K_DATABASE_NAME
database name (TCExam)
public mixed K_DATABASE_NAME =
''K_DATABASE_PORT
database port (eg: 3306, 5432, 1521)
public mixed K_DATABASE_PORT =
''
NOTE: For MYSQL database type, set this constant to NULL to be able to use the MySQL socket path defined by the mysqli.default_socket PHP value. For example, in Apache: php_value mysqli.default_socket "/path/to/mysql.sock"
K_DATABASE_TYPE
database type (MYSQL, POSTGRESQL, ORACLE)
public mixed K_DATABASE_TYPE =
''K_DATABASE_USER_NAME
database user name
public mixed K_DATABASE_USER_NAME =
''K_DATABASE_USER_PASSWORD
database user password
public mixed K_DATABASE_USER_PASSWORD =
''K_TABLE_ANSWERS
This table contains all answers relative to a specific questions.
public mixed K_TABLE_ANSWERS =
\K_TABLE_PREFIX .
'answers'K_TABLE_GROUPS
This table contains users' groups. Each user belongs to one of the groups defined in this table.
public mixed K_TABLE_GROUPS =
\K_TABLE_PREFIX
. 'user_groups'K_TABLE_LOG_ANSWER
This table contains the list of the selected alternative answers for each multiple-choice question.
public mixed K_TABLE_LOG_ANSWER =
\K_TABLE_PREFIX .
'tests_logs_answers'K_TABLE_MODULES
Table for modules. A module is a container for subjects.
public mixed K_TABLE_MODULES =
\K_TABLE_PREFIX .
'modules'K_TABLE_PREFIX
prefix for database tables names
public mixed K_TABLE_PREFIX =
'tce_'K_TABLE_QUESTIONS
This table contains all questions relative to specific subjects.
public mixed K_TABLE_QUESTIONS =
\K_TABLE_PREFIX .
'questions'K_TABLE_SESSIONS
This table stores information about users' Web sessions.
public mixed K_TABLE_SESSIONS =
\K_TABLE_PREFIX .
'sessions'K_TABLE_SSLCERTS
This table contains the SSL certificates.
public mixed K_TABLE_SSLCERTS =
\K_TABLE_PREFIX .
'sslcerts'K_TABLE_SUBJECT_SET
This table contains all tests subjects (topics, branch of studies).
public mixed K_TABLE_SUBJECT_SET =
\K_TABLE_PREFIX .
'test_subjects'K_TABLE_SUBJECTS
This table contains all tests subjects (topics, branch of studies).
public mixed K_TABLE_SUBJECTS =
\K_TABLE_PREFIX .
'subjects'K_TABLE_TEST_GROUPS
This table contains the list of groups enabled for a selected test.
public mixed K_TABLE_TEST_GROUPS =
\K_TABLE_PREFIX .
'testgroups'K_TABLE_TEST_SSLCERTS
This table contains the list of SSL certificates enabled for a selected test.
public mixed K_TABLE_TEST_SSLCERTS =
\K_TABLE_PREFIX .
'testsslcerts'K_TABLE_TEST_SUBJSET
This table lists the type and quantity of the questions associated to each set of subjects selected for a particular test.
public mixed K_TABLE_TEST_SUBJSET =
\K_TABLE_PREFIX .
'test_subject_set'K_TABLE_TEST_USER
This table contains the list of tests generated for each user.
public mixed K_TABLE_TEST_USER =
\K_TABLE_PREFIX .
'tests_users'K_TABLE_TESTS
This table contains all tests data.
public mixed K_TABLE_TESTS = \K_TABLE_PREFIX .
'tests'K_TABLE_TESTS_LOGS
This table contains all questions and user answers relative to a specific test for a specific user.
public mixed K_TABLE_TESTS_LOGS =
\K_TABLE_PREFIX .
'tests_logs'K_TABLE_TESTUSER_STAT
This table counts the number of generated tests.
public mixed K_TABLE_TESTUSER_STAT =
\K_TABLE_PREFIX .
'testuser_stat'K_TABLE_USERGROUP
This table contains the list of groups to whom each user belongs.
public mixed K_TABLE_USERGROUP =
\K_TABLE_PREFIX .
'usrgroups'K_TABLE_USERS
This table contains all registered users' data, including system administrators and a special 'anonymous' user.
public mixed K_TABLE_USERS = \K_TABLE_PREFIX .
'users'