Dokeos Database Structure

From Dokeos

1 Introduction
2 Main Dokeos Database
3 Scorm Database
- 3.1 scorm_main
- 3.2 scorm_sco_data
4 Tracking Database
5 User Database
- 5.1 personal_agenda
- 5.2 user_course_category
6 Course Databases

Introduction

A default Dokeos installation uses several databases. 4 general databases (main, scorm, tracking and user) and one database per course. There is however an option to have only one database, but we must admit that the current implementation of this is not ideal (but it works)

For each database, all tables are listed. For each table a short description, the table structure and a list of its fields is given. For all fields a short description is given. In some descriptions we refer to other fields in the database. These references have following format: database_name.table_name#field_name

Main Dokeos Database

class

Description

This table holds some information about the several classes of users defined in your Dokeos portal.

Table structure

CREATE TABLE `class` (
 `id` mediumint(8) unsigned NOT NULL auto_increment,
 `code` varchar(40) default ,
 `name` text NOT NULL,
 PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Fields

id: A unique identifier for the class
code: A code for the class
name: A name for the class

class_user

Description

Link between a user and the classes he/she is subscribed to.

Table structure

CREATE TABLE `class_user` (
 `class_id` mediumint(8) unsigned NOT NULL default '0',
 `user_id` int(10) unsigned NOT NULL default '0',
 PRIMARY KEY  (`class_id`,`user_id`)
) TYPE=MyISAM;

Fields

class_id: The id of the class (refering to dokeos_main.class#id)
user_id: The id of the user (refering to dokeos_main.user#user_id)

course

Description

This table holds all course related information

Table structure

CREATE TABLE `course` (
 `code` varchar(40) NOT NULL default ,
 `directory` varchar(40) default NULL,
 `db_name` varchar(40) default NULL,
 `course_language` varchar(20) default NULL,
 `title` varchar(250) default NULL,
 `description` text,
 `category_code` varchar(40) default NULL,
 `visibility` tinyint(4) default '0',
 `show_score` int(11) NOT NULL default '1',
 `tutor_name` varchar(200) default NULL,
 `visual_code` varchar(40) default NULL,
 `department_name` varchar(30) default NULL,
 `department_url` varchar(180) default NULL,
 `disk_quota` int(10) unsigned default NULL,
 `last_visit` datetime default NULL,
 `last_edit` datetime default NULL,
 `creation_date` datetime default NULL,
 `expiration_date` datetime default NULL,
 `target_course_code` varchar(40) default NULL,
 `subscribe` tinyint(4) NOT NULL default '1',
 `unsubscribe` tinyint(4) NOT NULL default '1',
 PRIMARY KEY  (`code`)
) TYPE=MyISAM;

Fields

code: A unique code for the course
directory: The directory name for the course
db_name: The database name for the course
course_language: The course language
title: The course title
description: A description of the course
category_code: The code of the category in which this course is placed
visibility: The course visibility
show_score:
tutor_name: Name of the teacher
visual_code: Visual code of this course (can be different from code)
department_name: Name of the course department
department_url: URL of the course department
disk_quota: Quota for this course
last_visit:
last_edit:
creation_date: Date of course creation
expiration_date:
target_course_code:
subscribe: Is subscription allowed?
unsubscribe: Is unsubscription allowed?

admin

Description

This table defines the users who are platform administrators

Table structure

CREATE TABLE `admin` (
  `user_id` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `user_id` (`user_id`)
) TYPE=MyISAM

Fields

user_id: The user id (see dokeos_main.user#user_id)

course_category

Description

All courses in your Dokeos portal can be organized in categories. This table holds the category information.

Table structure

CREATE TABLE `course_category` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default ,
  `code` varchar(40) NOT NULL default ,
  `parent_id` varchar(40) default NULL,
  `tree_pos` int(10) unsigned default NULL,
  `children_count` smallint(6) default NULL,
  `auth_course_child` enum('TRUE','FALSE') default 'TRUE',
  `auth_cat_child` enum('TRUE','FALSE') default 'TRUE',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `code` (`code`),
  KEY `parent_id` (`parent_id`),
  KEY `tree_pos` (`tree_pos`)
) TYPE=MyISAM

Fields

id: A unique identifier
name: A name
code: A code
parent_id: The id of the parent category (categories are organized in a tree structure)
tree_pos: The position on which this category is displayed
children_count: The number of children of this category
auth_course_child:
auth_cat_child:

course_module

Description

Each course has some modules (documents, links, ...). This table holds some information about those modules.

Table structure

CREATE TABLE `course_module` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default ,
  `link` varchar(255) NOT NULL default ,
  `image` varchar(100) default NULL,
  `row` int(10) unsigned NOT NULL default '0',
  `column` int(10) unsigned NOT NULL default '0',
  `position` varchar(20) NOT NULL default 'basic',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id: A unique identifier
name: The modules name (e.g. TOOL_LINK, TOOL_BB_FORUM, ...)
link: The URL to the module
image: An image for the module
row:
column:
position:

course_rel_class

It is possible to subscribe all users from a certain class into a course. This table holds the link between that class and the course

Description

Table structure

CREATE TABLE `course_rel_class` (
  `course_code` char(40) NOT NULL default ,
  `class_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`course_code`,`class_id`)
) TYPE=MyISAM

Fields

course_code: The course code (see dokeos_main.course#code)
class_id: The class' identifier (see dokeos_main.class#id)

course_rel_user

Description

This table holds some information about the subscription of users into courses.

Table structure

CREATE TABLE `course_rel_user` (
  `course_code` varchar(40) NOT NULL default ,
  `user_id` int(10) unsigned NOT NULL default '0',
  `status` tinyint(4) NOT NULL default '5',
  `role` varchar(60) default NULL,
  `group_id` int(11) NOT NULL default '0',
  `tutor_id` int(10) unsigned NOT NULL default '0',
  `sort` int(11) default NULL,
  `user_course_cat` int(11) default '0',
  PRIMARY KEY  (`course_code`,`user_id`)
) TYPE=MyISAM

Fields

course_code: The course code (see dokeos_main.course#code)
user_id: The user id (see dokeos_main.user#user_id)
status: The users status in this course (possible values are 5 = student, 1 = teacher)
role: A course admin can define a role for all users in a course
group_id:
tutor_id:
sort: A user can sort his courses on the portal homepage. Thies field holds this display order.
user_course_cat: A user can define his own course categories. This field holds the id of the category. (see dokeos_user.user_course_category#id)

language

Description

Dokeos is a multilingual application. This table holds information about all available languages.

Table structure

CREATE TABLE `language` (
  `id` tinyint(3) unsigned NOT NULL auto_increment,
  `original_name` varchar(255) default NULL,
  `english_name` varchar(255) default NULL,
  `isocode` varchar(10) default NULL,
  `dokeos_folder` varchar(250) default NULL,
  `available` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id: A unique identifier
original_name: The original name of the language
english_name: The english name of the language
isocode: The language isocode
dokeos_folder: The dokeos folder in which the language files can be found
available: Is this language available? (platform admins can change this through the platform administration area)

session

Description

It is possible to use the Dokeos database to store all session information (by default PHP uses files and so does Dokeos). You can activate this option in ~claroline/inc/conf/claro_main.conf.php. The table described here is used to store this session information.

Table structure

CREATE TABLE `session` (
  `sess_id` varchar(32) NOT NULL default ,
  `sess_name` varchar(10) NOT NULL default ,
  `sess_time` int(11) NOT NULL default '0',
  `sess_start` int(11) NOT NULL default '0',
  `sess_value` text NOT NULL,
  PRIMARY KEY  (`sess_id`)
) TYPE=MyISAM

Fields

sess_id:
sess_name:
sess_time:
sess_start:
sess_value:

settings_current

Description

Table structure

CREATE TABLE `settings_current` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `variable` varchar(255) default NULL,
  `subkey` varchar(255) default NULL,
  `type` varchar(255) default NULL,
  `category` varchar(255) default NULL,
  `selected_value` varchar(255) default NULL,
  `title` varchar(255) NOT NULL default ,
  `comment` varchar(255) default NULL,
  `scope` varchar(50) default NULL,
  `subkeytext` varchar(255) default NULL,
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM

Fields

id:
variable:
subkey:
type:
category:
selected_value:
title:
comment:
scope:
subkeytext:

settings_options

Description

Table structure

CREATE TABLE `settings_options` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `variable` varchar(255) default NULL,
  `value` varchar(255) default NULL,
  `display_text` varchar(255) NOT NULL default ,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM

Fields

id:
variable:
value:
display_text:

sys_announcement

Description

Platform administrators can place announcements on the portals homepage. This table contains those so-called system announcements.

Table structure

CREATE TABLE `sys_announcement` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `date_start` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_end` datetime NOT NULL default '0000-00-00 00:00:00',
  `visible_teacher` enum('true','false') NOT NULL default 'false',
  `visible_student` enum('true','false') NOT NULL default 'false',
  `visible_guest` enum('true','false') NOT NULL default 'false',
  `title` varchar(250) NOT NULL default ,
  `content` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id: A unique identifier
date_start: The date and time on which this announcement should become visible
date_end: The date and time on which this announcement should become invisible
visible_teacher: Is this announcement available for teachers?
visible_student: Is this announcement available for teachers?
visible_guest: Is this announcement available for teachers?
title: The announcements title
content: The content of the announcement

user

Description

This table holds all user information.

Table structure

CREATE TABLE `user` (
  `user_id` int(10) unsigned NOT NULL auto_increment,
  `lastname` varchar(60) default NULL,
  `firstname` varchar(60) default NULL,
  `username` varchar(20) NOT NULL default ,
  `password` varchar(50) NOT NULL default ,
  `auth_source` varchar(50) default 'claroline',
  `email` varchar(100) default NULL,
  `status` tinyint(4) NOT NULL default '5',
  `official_code` varchar(40) default NULL,
  `phone` varchar(30) default NULL,
  `picture_uri` varchar(250) default NULL,
  `creator_id` int(10) unsigned default NULL,
  `competences` text,
  `diplomas` text,
  `openarea` text,
  `teach` text,
  `productions` varchar(250) default NULL,
  `chatcall_user_id` int(10) unsigned NOT NULL default '0',
  `chatcall_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `chatcall_text` varchar(50) NOT NULL default ,
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `username` (`username`)
) TYPE=MyISAM

Fields

user_id: A unique identifier
lastname: Last name
firstname: First name
username: username
password: password (this can be md5-encrypted or plain-text, depending on the Dokeos config settings)
auth_source: the authentication source (e.g. 'claroline','ldap',...)
email: email
status: The users status (5 = student, 1 = course admin)
official_code: Official code
phone: phone number
picture_uri: A picture
creator_id: The user_id of the user who created this user
competences:
diplomas:
openarea:
teach:
productions:
chatcall_user_id:
chatcall_date:
chatcall_text:

Scorm Database

scorm_main

Description

Table structure

CREATE TABLE `scorm_main` (
  `contentId` int(5) unsigned NOT NULL auto_increment,
  `contentTitle` varchar(100) default NULL,
  `dokeosCourse` varchar(100) default NULL,
  PRIMARY KEY  (`contentId`)
) TYPE=MyISAM

Fields

contentId:
contentTitle:
dokeosCourse:

scorm_sco_data

Description

Table structure

CREATE TABLE `scorm_sco_data` (
  `contentId` int(5) default NULL,
  `scoId` int(5) NOT NULL auto_increment,
  `scoIdentifier` varchar(100) default NULL,
  `scoTitle` varchar(100) default NULL,
  `status` varchar(100) default NULL,
  `studentId` int(10) default NULL,
  `score` int(10) default NULL,
  `time` varchar(20) default NULL,
  KEY `scoId` (`scoId`)
) TYPE=MyISAM

Fields

contentId:
scoId:
scoIdentifier:
scoTitle:
status:
studentId:
score:
time:

Tracking Database

track_c_browsers

Description

Table structure

CREATE TABLE `track_c_browsers` (
  `id` int(11) NOT NULL auto_increment,
  `browser` varchar(255) NOT NULL default ,
  `counter` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
browser:
counter:

track_c_countries

Description

Table structure

CREATE TABLE `track_c_countries` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(40) NOT NULL default ,
  `country` varchar(50) NOT NULL default ,
  `counter` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
code:
country:
counter:

track_c_os

Description

Table structure

CREATE TABLE `track_c_os` (
  `id` int(11) NOT NULL auto_increment,
  `os` varchar(255) NOT NULL default ,
  `counter` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
os:
counter:

track_c_providers

Description

Table structure

CREATE TABLE `track_c_providers` (
  `id` int(11) NOT NULL auto_increment,
  `provider` varchar(255) NOT NULL default ,
  `counter` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
provider:
counter:

track_c_referers

Description

Table structure

CREATE TABLE `track_c_referers` (
  `id` int(11) NOT NULL auto_increment,
  `referer` varchar(255) NOT NULL default ,
  `counter` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
referer:
counter:

track_e_access

Description

Table structure

CREATE TABLE `track_e_access` (
  `access_id` int(11) NOT NULL auto_increment,
  `access_user_id` int(10) unsigned default NULL,
  `access_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `access_cours_code` varchar(40) NOT NULL default '0',
  `access_tool` varchar(30) default NULL,
  PRIMARY KEY  (`access_id`),
  KEY `access_user_id` (`access_user_id`),
  KEY `access_cours_code` (`access_cours_code`)
) TYPE=MyISAM

Fields

access_id:
access_user_id:
access_date:
access_cours_code:
access_tool:

track_e_default

Description

Table structure

CREATE TABLE `track_e_default` (
  `default_id` int(11) NOT NULL auto_increment,
  `default_user_id` int(10) unsigned NOT NULL default '0',
  `default_cours_code` varchar(40) NOT NULL default ,
  `default_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `default_event_type` varchar(20) NOT NULL default ,
  `default_value_type` varchar(20) NOT NULL default ,
  `default_value` tinytext NOT NULL,
  PRIMARY KEY  (`default_id`)
) TYPE=MyISAM

Fields

default_id:
default_user_id:
default_cours_code:
default_date:
default_event_type:
default_value_type:
default_value:

track_e_downloads

Description

Table structure

CREATE TABLE `track_e_downloads` (
  `down_id` int(11) NOT NULL auto_increment,
  `down_user_id` int(10) unsigned default NULL,
  `down_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `down_cours_id` varchar(20) NOT NULL default '0',
  `down_doc_path` varchar(255) NOT NULL default '0',
  PRIMARY KEY  (`down_id`)
) TYPE=MyISAM

Fields

down_id:
down_user_id:
down_date:
down_cours_id:
down_doc_path:

track_e_exercices

Description

Table structure

CREATE TABLE `track_e_exercices` (
  `exe_id` int(11) NOT NULL auto_increment,
  `exe_user_id` int(10) unsigned default NULL,
  `exe_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `exe_cours_id` varchar(40) NOT NULL default ,
  `exe_exo_id` mediumint(8) unsigned NOT NULL default '0',
  `exe_result` smallint(6) NOT NULL default '0',
  `exe_weighting` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`exe_id`)
) TYPE=MyISAM

Fields

exe_id:
exe_user_id:
exe_date:
exe_cours_id:
exe_exo_id:
exe_result:
exe_weighting:

track_e_hotpotatoes

Description

Table structure

CREATE TABLE `track_e_hotpotatoes` (
  `exe_name` varchar(255) NOT NULL default ,
  `exe_user_id` int(10) unsigned default NULL,
  `exe_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `exe_cours_id` varchar(40) NOT NULL default ,
  `exe_result` smallint(6) NOT NULL default '0',
  `exe_weighting` smallint(6) NOT NULL default '0'
) TYPE=MyISAM

Fields

exe_name:
exe_user_id:
exe_date:
exe_cours_id:
exe_result:
exe_weighting:

track_e_lastaccess

Description

Table structure

CREATE TABLE `track_e_lastaccess` (
  `access_id` int(11) NOT NULL auto_increment,
  `access_user_id` int(10) unsigned default NULL,
  `access_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `access_cours_code` varchar(40) NOT NULL default '0',
  `access_tool` varchar(30) default NULL,
  PRIMARY KEY  (`access_id`),
  KEY `access_user_id` (`access_user_id`),
  KEY `access_cours_code` (`access_cours_code`)
) TYPE=MyISAM

Fields

access_id:
access_user_id:
access_date:
access_cours_code:
access_tool:

track_e_links

Description

Table structure

CREATE TABLE `track_e_links` (
  `links_id` int(11) NOT NULL auto_increment,
  `links_user_id` int(10) unsigned default NULL,
  `links_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `links_cours_id` varchar(20) NOT NULL default '0',
  `links_link_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`links_id`)
) TYPE=MyISAM

Fields

links_id:
links_user_id:
links_date:
links_cours_id:
links_link_id:

track_e_login

Description

Table structure

CREATE TABLE `track_e_login` (
  `login_id` int(11) NOT NULL auto_increment,
  `login_user_id` int(10) unsigned NOT NULL default '0',
  `login_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `login_ip` varchar(39) NOT NULL default ,
  PRIMARY KEY  (`login_id`),
  KEY `login_user_id` (`login_user_id`)
) TYPE=MyISAM

Fields

login_id:
login_user_id:
login_date:
login_ip:

track_e_online

Description

Table structure

CREATE TABLE `track_e_online` (
  `login_id` int(11) NOT NULL auto_increment,
  `login_user_id` int(10) unsigned NOT NULL default '0',
  `login_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `login_ip` varchar(39) NOT NULL default ,
  PRIMARY KEY  (`login_id`),
  KEY `login_user_id` (`login_user_id`)
) TYPE=MyISAM

Fields

login_id:
login_user_id:
login_date:
login_ip:

track_e_open

Description

Table structure

CREATE TABLE `track_e_open` (
  `open_id` int(11) NOT NULL auto_increment,
  `open_remote_host` tinytext NOT NULL,
  `open_agent` tinytext NOT NULL,
  `open_referer` tinytext NOT NULL,
  `open_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`open_id`)
) TYPE=MyISAM

Fields

open_id:
open_remote_host:
open_agent:
open_referer:
open_date:

track_e_uploads

Description

Table structure

CREATE TABLE `track_e_uploads` (
  `upload_id` int(11) NOT NULL auto_increment,
  `upload_user_id` int(10) unsigned default NULL,
  `upload_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `upload_cours_id` varchar(20) NOT NULL default '0',
  `upload_work_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`upload_id`)
) TYPE=MyISAM

Fields

upload_id:
upload_user_id:
upload_date:
upload_cours_id:
upload_work_id:

User Database

personal_agenda

Description

Dokeos can be configured to allow users to add personal events to their agenda. This table holds those events.

Table structure

CREATE TABLE `personal_agenda` (
  `id` int(11) NOT NULL auto_increment,
  `user` int(10) unsigned default NULL,
  `title` text,
  `text` text,
  `date` datetime default NULL,
  `enddate` datetime default NULL,
  `course` varchar(255) default NULL,
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM

Fields

id: A unique identifier
user: The owner of the event (see dokeos_main.user#user_id)
title: The title of the event
text: A description of the event
date: The date and time on which the event starts
enddate: The date and time on which the event ends
course: The event can be course related. In that case, this fields holds the course code (see dokeos_main.course#code)

user_course_category

Description

Users can define their own course categories to structure their courses on the Dokeos homepage. This table holds the information about those categories.

Table structure

CREATE TABLE `user_course_category` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL default '0',
  `title` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id: A unique identifier
user_id: The user id of the user who created the category (see dokeos_main.user#user_id)
title: A title

Course Databases

announcement

The announcements created in the announcements tool are saved in this table.

Description

Table structure

CREATE TABLE `announcement` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `title` text,
  `content` text,
  `end_date` date default NULL,
  `display_order` mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id: A unique identifier
title: A title
content: The content of the announcement
end_date:
display_order: The order in which the announcements will be displayed to the user

bb_access

Description

Table structure

CREATE TABLE `bb_access` (
  `access_id` int(10) NOT NULL auto_increment,
  `access_title` varchar(20) default NULL,
  PRIMARY KEY  (`access_id`)
) TYPE=MyISAM

Fields

access_id:
access_title:

bb_banlist

Description

Table structure

CREATE TABLE `bb_banlist` (
  `ban_id` int(10) NOT NULL auto_increment,
  `ban_userid` int(10) default NULL,
  `ban_ip` varchar(16) default NULL,
  `ban_start` int(32) default NULL,
  `ban_end` int(50) default NULL,
  `ban_time_type` int(10) default NULL,
  PRIMARY KEY  (`ban_id`),
  KEY `ban_id` (`ban_id`)
) TYPE=MyISAM

Fields

ban_id:
ban_userid:
ban_ip:
ban_start:
ban_end:
ban_time_type:

bb_categories

Description

Table structure

CREATE TABLE `bb_categories` (
  `cat_id` int(10) NOT NULL auto_increment,
  `cat_title` varchar(100) default NULL,
  `cat_order` varchar(10) default NULL,
  PRIMARY KEY  (`cat_id`)
) TYPE=MyISAM

Fields

cat_id:
cat_title:
cat_order:

bb_config

Description

Table structure

CREATE TABLE `bb_config` (
  `config_id` int(10) NOT NULL auto_increment,
  `sitename` varchar(100) default NULL,
  `allow_html` int(2) default NULL,
  `allow_bbcode` int(2) default NULL,
  `allow_sig` int(2) default NULL,
  `allow_namechange` int(2) default '0',
  `admin_passwd` varchar(32) default NULL,
  `selected` int(2) NOT NULL default '0',
  `posts_per_page` int(10) default NULL,
  `hot_threshold` int(10) default NULL,
  `topics_per_page` int(10) default NULL,
  `allow_theme_create` int(10) default NULL,
  `override_themes` int(2) default '0',
  `email_sig` varchar(255) default NULL,
  `email_from` varchar(100) default NULL,
  `default_lang` varchar(255) default NULL,
  PRIMARY KEY  (`config_id`),
  UNIQUE KEY `selected` (`selected`)
) TYPE=MyISAM

Fields

config_id:
sitename:
allow_html:
allow_bbcode:
allow_sig:
allow_namechange:
admin_passwd:
selected:
posts_per_page:
hot_threshold:
topics_per_page:
allow_theme_create:
override_themes:
email_sig:
email_from:
default_lang:

bb_disallow

Description

Table structure

CREATE TABLE `bb_disallow` (
  `disallow_id` int(10) NOT NULL auto_increment,
  `disallow_username` varchar(50) default NULL,
  PRIMARY KEY  (`disallow_id`)
) TYPE=MyISAM

Fields

disallow_id:
disallow_username:

bb_forum_access

Description

Table structure

CREATE TABLE `bb_forum_access` (
  `forum_id` int(10) NOT NULL default '0',
  `user_id` int(10) NOT NULL default '0',
  `can_post` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`forum_id`,`user_id`)
) TYPE=MyISAM

Fields

forum_id:
user_id:
can_post:

bb_forum_mods

Description

Table structure

CREATE TABLE `bb_forum_mods` (
  `forum_id` int(10) NOT NULL default '0',
  `user_id` int(10) NOT NULL default '0'
) TYPE=MyISAM

Fields

forum_id:
user_id:

bb_forums

Description

Table structure

CREATE TABLE `bb_forums` (
  `forum_id` int(10) NOT NULL auto_increment,
  `forum_name` varchar(150) default NULL,
  `forum_desc` text,
  `forum_access` int(10) default '1',
  `forum_moderator` int(10) default NULL,
  `forum_topics` int(10) NOT NULL default '0',
  `forum_posts` int(10) NOT NULL default '0',
  `forum_last_post_id` int(10) NOT NULL default '0',
  `cat_id` int(10) default NULL,
  `forum_type` int(10) default '0',
  PRIMARY KEY  (`forum_id`),
  KEY `forum_last_post_id` (`forum_last_post_id`)
) TYPE=MyISAM

Fields

forum_id:
forum_name:
forum_desc:
forum_access:
forum_moderator:
forum_topics:
forum_posts:
forum_last_post_id:
cat_id:
forum_type:

bb_headermetafooter

Description

Table structure

CREATE TABLE `bb_headermetafooter` (
  `header` text,
  `meta` text,
  `footer` text
) TYPE=MyISAM

Fields

header:
meta:
footer:

bb_posts

Description

Table structure

CREATE TABLE `bb_posts` (
  `post_id` int(10) NOT NULL auto_increment,
  `topic_id` int(10) NOT NULL default '0',
  `forum_id` int(10) NOT NULL default '0',
  `poster_id` int(10) NOT NULL default '0',
  `post_time` varchar(20) default NULL,
  `poster_ip` varchar(16) default NULL,
  `nom` varchar(30) default NULL,
  `prenom` varchar(30) default NULL,
  `topic_notify` tinyint(2) default NULL,
  `parent_id` int(10) default '0',
  PRIMARY KEY  (`post_id`),
  KEY `post_id` (`post_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_id` (`topic_id`),
  KEY `poster_id` (`poster_id`)
) TYPE=MyISAM

Fields

post_id:
topic_id:
forum_id:
poster_id:
post_time:
poster_ip:
nom:
prenom:
topic_notify:
parent_id:

bb_posts_text

Description

Table structure

CREATE TABLE `bb_posts_text` (
  `post_id` int(10) NOT NULL default '0',
  `post_text` text,
  `post_title` varchar(255) default NULL,
  PRIMARY KEY  (`post_id`)
) TYPE=MyISAM

Fields

post_id:
post_text:
post_title:

bb_priv_msgs

Description

Table structure

CREATE TABLE `bb_priv_msgs` (
  `msg_id` int(10) NOT NULL auto_increment,
  `from_userid` int(10) NOT NULL default '0',
  `to_userid` int(10) NOT NULL default '0',
  `msg_time` varchar(20) default NULL,
  `poster_ip` varchar(16) default NULL,
  `msg_status` int(10) default '0',
  `msg_text` text,
  PRIMARY KEY  (`msg_id`),
  KEY `msg_id` (`msg_id`),
  KEY `to_userid` (`to_userid`)
) TYPE=MyISAM

Fields

msg_id:
from_userid:
to_userid:
msg_time:
poster_ip:
msg_status:
msg_text:

bb_ranks

Description

Table structure

CREATE TABLE `bb_ranks` (
  `rank_id` int(10) NOT NULL auto_increment,
  `rank_title` varchar(50) NOT NULL default ,
  `rank_min` int(10) NOT NULL default '0',
  `rank_max` int(10) NOT NULL default '0',
  `rank_special` int(2) default '0',
  `rank_image` varchar(255) default NULL,
  PRIMARY KEY  (`rank_id`),
  KEY `rank_min` (`rank_min`),
  KEY `rank_max` (`rank_max`)
) TYPE=MyISAM

Fields

rank_id:
rank_title:
rank_min:
rank_max:
rank_special:
rank_image:

bb_sessions

Description

Table structure

CREATE TABLE `bb_sessions` (
  `sess_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) NOT NULL default '0',
  `start_time` int(10) unsigned NOT NULL default '0',
  `remote_ip` varchar(15) NOT NULL default ,
  PRIMARY KEY  (`sess_id`),
  KEY `sess_id` (`sess_id`),
  KEY `start_time` (`start_time`),
  KEY `remote_ip` (`remote_ip`)
) TYPE=MyISAM

Fields

sess_id:
user_id:
start_time:
remote_ip:

bb_themes

Description

Table structure

CREATE TABLE `bb_themes` (
  `theme_id` int(10) NOT NULL auto_increment,
  `theme_name` varchar(35) default NULL,
  `bgcolor` varchar(10) default NULL,
  `textcolor` varchar(10) default NULL,
  `color1` varchar(10) default NULL,
  `color2` varchar(10) default NULL,
  `table_bgcolor` varchar(10) default NULL,
  `header_image` varchar(50) default NULL,
  `newtopic_image` varchar(50) default NULL,
  `reply_image` varchar(50) default NULL,
  `linkcolor` varchar(15) default NULL,
  `vlinkcolor` varchar(15) default NULL,
  `theme_default` int(2) default '0',
  `fontface` varchar(100) default NULL,
  `fontsize1` varchar(5) default NULL,
  `fontsize2` varchar(5) default NULL,
  `fontsize3` varchar(5) default NULL,
  `fontsize4` varchar(5) default NULL,
  `tablewidth` varchar(10) default NULL,
  `replylocked_image` varchar(255) default NULL,
  PRIMARY KEY  (`theme_id`)
) TYPE=MyISAM

Fields

theme_id:
theme_name:
bgcolor:
textcolor:
color1:
color2:
table_bgcolor:
header_image:
newtopic_image:
reply_image:
linkcolor:
vlinkcolor:
theme_default:
fontface:
fontsize1:
fontsize2:
fontsize3:
fontsize4:
tablewidth:
replylocked_image:

bb_topics

Description

Table structure

CREATE TABLE `bb_topics` (
  `topic_id` int(10) NOT NULL auto_increment,
  `topic_title` varchar(100) default NULL,
  `topic_poster` int(10) default NULL,
  `topic_time` varchar(20) default NULL,
  `topic_views` int(10) NOT NULL default '0',
  `topic_replies` int(10) NOT NULL default '0',
  `topic_last_post_id` int(10) NOT NULL default '0',
  `forum_id` int(10) NOT NULL default '0',
  `topic_status` int(10) NOT NULL default '0',
  `topic_notify` int(2) default '0',
  `nom` varchar(30) default NULL,
  `prenom` varchar(30) default NULL,
  PRIMARY KEY  (`topic_id`),
  KEY `topic_id` (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_last_post_id` (`topic_last_post_id`)
) TYPE=MyISAM

Fields

topic_id:
topic_title:
topic_poster:
topic_time:
topic_views:
topic_replies:
topic_last_post_id:
forum_id:
topic_status:
topic_notify:
nom:
prenom:

bb_users

Description

Table structure

CREATE TABLE `bb_users` (
  `user_id` int(10) NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default ,
  `user_regdate` varchar(20) NOT NULL default ,
  `user_password` varchar(32) NOT NULL default ,
  `user_email` varchar(50) default NULL,
  `user_icq` varchar(15) default NULL,
  `user_website` varchar(100) default NULL,
  `user_occ` varchar(100) default NULL,
  `user_from` varchar(100) default NULL,
  `user_intrest` varchar(150) default NULL,
  `user_sig` varchar(255) default NULL,
  `user_viewemail` tinyint(2) default NULL,
  `user_theme` int(10) default NULL,
  `user_aim` varchar(18) default NULL,
  `user_yim` varchar(25) default NULL,
  `user_msnm` varchar(25) default NULL,
  `user_posts` int(10) default '0',
  `user_attachsig` int(2) default '0',
  `user_desmile` int(2) default '0',
  `user_html` int(2) default '0',
  `user_bbcode` int(2) default '0',
  `user_rank` int(10) default '0',
  `user_level` int(10) default '1',
  `user_lang` varchar(255) default NULL,
  `user_actkey` varchar(32) default NULL,
  `user_newpasswd` varchar(32) default NULL,
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM

Fields

user_id:
username:
user_regdate:
user_password:
user_email:
user_icq:
user_website:
user_occ:
user_from:
user_intrest:
user_sig:
user_viewemail:
user_theme:
user_aim:
user_yim:
user_msnm:
user_posts:
user_attachsig:
user_desmile:
user_html:
user_bbcode:
user_rank:
user_level:
user_lang:
user_actkey:
user_newpasswd:

bb_whosonline

Description

Table structure

CREATE TABLE `bb_whosonline` (
  `id` int(3) NOT NULL auto_increment,
  `ip` varchar(255) default NULL,
  `name` varchar(255) default NULL,
  `count` varchar(255) default NULL,
  `online_date` varchar(255) default NULL,
  `username` varchar(40) default NULL,
  `forum` int(10) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
ip:
name:
count:
online_date:
username:
forum:

bb_words

Description

Table structure

CREATE TABLE `bb_words` (
  `word_id` int(10) NOT NULL auto_increment,
  `word` varchar(100) default NULL,
  `replacement` varchar(100) default NULL,
  PRIMARY KEY  (`word_id`)
) TYPE=MyISAM

Fields

word_id:
word:
replacement:

calendar_event

Description

Table structure

CREATE TABLE `calendar_event` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(200) NOT NULL default ,
  `content` text,
  `start_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `end_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
title:
content:
start_date:
end_date:

chat_connected

Description

Table structure

CREATE TABLE `chat_connected` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `last_connection` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM

Fields

user_id:
last_connection:

course_description

Description

Table structure

CREATE TABLE `course_description` (
  `id` tinyint(3) unsigned NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `content` text,
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM

Fields

id:
title:
content:

document

Description

Table structure

CREATE TABLE `document` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `path` varchar(255) NOT NULL default ,
  `comment` text,
  `title` varchar(255) default NULL,
  `filetype` set('file','folder') NOT NULL default 'file',
  `size` int(16) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
path:
comment:
title:
filetype:
size:

dropbox_file

Description

One entry for each file managed by Dropbox, which can be an uploaded file or a file extracted from a mailing zip

Table structure

CREATE TABLE `dropbox_file` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `uploader_id` int(10) unsigned NOT NULL default '0',
  `filename` varchar(250) NOT NULL default ,
  `filesize` int(10) unsigned NOT NULL default '0',
  `title` varchar(250) default ,
  `description` varchar(250) default ,
  `author` varchar(250) default ,
  `upload_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_upload_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `UN_filename` (`filename`)
) TYPE=MyISAM

Fields

id:
uploader_id: user_id of uploader OR mailing_id (a big number)
filename: as stored in the course dropbox folder, e.g. renehaentjens_Wait...I_found_it!.txt_429db90d56005
filesize:
title: original filename, e.g. Wait...I_found_it!.txt
description:
author:
upload_date:
last_upload_date:

dropbox_person

Description

Cartesian product user x file, showing to whom a Dropbox file is (still) visible.

Table structure

CREATE TABLE `dropbox_person` (
  `file_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`file_id`,`user_id`)
) TYPE=MyISAM

Fields

file_id: id in dropbox_file
user_id: can also be a mailing_id (big number), meaning that the file is visible when the mailing folder is opened

dropbox_post

Description

Cartesian product file x destination, showing to whom a Dropbox file has been posted. Additional fields store feedback text and date+time: the most recent feedback given by the receiver. For a mailing zipfile, the destination is the mailing_id.

Table structure

CREATE TABLE `dropbox_post` (
  `file_id` int(10) unsigned NOT NULL default '0',
  `dest_user_id` int(10) unsigned NOT NULL default '0',
  `feedback_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `feedback` text,
  PRIMARY KEY  (`file_id`,`dest_user_id`)
) TYPE=MyISAM

Fields

file_id:
dest_user_id:
feedback_date:
feedback:

group_category

Description

Table structure

CREATE TABLE `group_category` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default ,
  `description` text NOT NULL,
  `forum_state` tinyint(3) unsigned NOT NULL default '1',
  `doc_state` tinyint(3) unsigned NOT NULL default '1',
  `max_student` smallint(5) unsigned NOT NULL default '8',
  `self_reg_allowed` enum('0','1') NOT NULL default '0',
  `self_unreg_allowed` enum('0','1') NOT NULL default '0',
  `groups_per_user` smallint(5) unsigned NOT NULL default '0',
  `display_order` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
title:
description:
forum_state:
doc_state:
max_student:
self_reg_allowed:
self_unreg_allowed:
groups_per_user:
display_order:

group_info

Description

Table structure

CREATE TABLE `group_info` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `category_id` int(10) unsigned NOT NULL default '0',
  `description` text,
  `tutor_id` mediumint(8) unsigned default NULL,
  `forum_state` enum('0','1','2') NOT NULL default '0',
  `forum_id` int(10) unsigned default NULL,
  `max_student` smallint(5) unsigned NOT NULL default '8',
  `doc_state` enum('0','1','2') NOT NULL default '0',
  `secret_directory` varchar(200) default NULL,
  `self_registration_allowed` enum('0','1') NOT NULL default '0',
  `self_unregistration_allowed` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
name:
category_id:
description:
tutor_id:
forum_state:
forum_id:
max_student:
doc_state:
secret_directory:
self_registration_allowed:
self_unregistration_allowed:

group_rel_user

Description

Table structure

CREATE TABLE `group_rel_user` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL default '0',
  `group_id` int(10) unsigned NOT NULL default '0',
  `status` int(11) NOT NULL default '0',
  `role` char(50) NOT NULL default ,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
user_id:
group_id:
status:
role:

item_property

Description

Table structure

CREATE TABLE `item_property` (
  `tool` varchar(100) NOT NULL default ,
  `insert_user_id` int(10) unsigned NOT NULL default '0',
  `insert_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `lastedit_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `ref` int(10) NOT NULL default '0',
  `lastedit_type` varchar(100) NOT NULL default ,
  `lastedit_user_id` int(10) unsigned NOT NULL default '0',
  `to_group_id` int(10) unsigned default NULL,
  `to_user_id` int(10) unsigned default NULL,
  `visibility` tinyint(1) NOT NULL default '1',
  `start_visible` datetime NOT NULL default '0000-00-00 00:00:00',
  `end_visible` datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM

Fields

tool:
insert_user_id:
insert_date:
lastedit_date:
ref:
lastedit_type:
lastedit_user_id:
to_group_id:
to_user_id:
visibility:
start_visible:
end_visible:

learnpath_chapter

Description

Table structure

CREATE TABLE `learnpath_chapter` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `learnpath_id` int(10) unsigned default NULL,
  `chapter_name` varchar(255) default NULL,
  `chapter_description` text,
  `parent_chapter_id` int(10) unsigned NOT NULL default '0',
  `display_order` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
learnpath_id:
chapter_name:
chapter_description:
parent_chapter_id:
display_order:

learnpath_item

Description

Table structure

CREATE TABLE `learnpath_item` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `chapter_id` int(10) unsigned default NULL,
  `item_type` varchar(50) default NULL,
  `item_id` int(10) unsigned default NULL,
  `display_order` smallint(6) default NULL,
  `title` varchar(255) default NULL,
  `description` text,
  `prereq_id` int(10) unsigned default NULL,
  `prereq_type` char(1) default NULL,
  `prereq_completion_limit` varchar(10) default NULL,
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM

Fields

id:
chapter_id:
item_type:
item_id:
display_order:
title:
description:
prereq_id:
prereq_type:
prereq_completion_limit:

learnpath_main

Description

Table structure

CREATE TABLE `learnpath_main` (
  `learnpath_id` int(10) unsigned NOT NULL auto_increment,
  `learnpath_name` varchar(255) default NULL,
  `learnpath_description` text,
  PRIMARY KEY  (`learnpath_id`)
) TYPE=MyISAM

Fields

learnpath_id:
learnpath_name:
learnpath_description:

learnpath_user

Description

Table structure

CREATE TABLE `learnpath_user` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `learnpath_id` int(10) unsigned NOT NULL default '0',
  `learnpath_item_id` int(10) unsigned default NULL,
  `status` varchar(15) default NULL,
  `score` smallint(6) default NULL,
  `time` varchar(20) default NULL
) TYPE=MyISAM

Fields

user_id:
learnpath_id:
learnpath_item_id:
status:
score:
time:

link

Description

Table structure

CREATE TABLE `link` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `url` text NOT NULL,
  `title` varchar(150) default NULL,
  `description` text,
  `category_id` smallint(5) unsigned default NULL,
  `display_order` smallint(5) unsigned NOT NULL default '0',
  `on_homepage` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
url:
title:
description:
category_id:
display_order:
on_homepage:

link_category

Description

Table structure

CREATE TABLE `link_category` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `category_title` varchar(255) NOT NULL default ,
  `description` text,
  `display_order` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
category_title:
description:
display_order:

metadata

Description

This table holds metadata for course objects. It is created when you save metadata for the first time, not by default when you create a new course.

Table structure

CREATE TABLE `metadata` (
 `eid` varchar(250) NOT NULL default ,
 `mdxmltext` text,
 `md5` varchar(32) default ,
 `htmlcache1` text,
 `htmlcache2` text,
 `indexabletext` text,
 PRIMARY KEY  (`eid`)
) TYPE=MyISAM;

Fields

eid: entry-id = type+dot+id, e.g. 'Document.12' for an object of type 'Document' (a document file or folder); Dokeos 1.6 scripts also work with eids such as 'Link.6', 'Scorm.25' (a complete SCORM package) and 'Scorm.25.abc' (item 'abc' in a SCORM package);
mdxmltext: the metadata, XML-formatted;
md5: HTML-cache validator;
htmlcache1: HTML-cache field 1 (see MD doc);
htmlcache2: not used in Dokeos 1.6;
indextabletext: words on which metadata can be searched, separated by spaces.

online_connected

Description

Table structure

CREATE TABLE `online_connected` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `last_connection` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM

Fields

user_id:
last_connection:

online_link

Description

Table structure

CREATE TABLE `online_link` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` char(50) NOT NULL default ,
  `url` char(100) NOT NULL default ,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
name:
url:

quiz

Description

Table structure

CREATE TABLE `quiz` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `title` varchar(200) NOT NULL default ,
  `description` text,
  `sound` varchar(50) default NULL,
  `type` tinyint(3) unsigned NOT NULL default '1',
  `random` smallint(6) NOT NULL default '0',
  `active` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
title:
description:
sound:
type:
random:
active:

quiz_answer

Description

Table structure

CREATE TABLE `quiz_answer` (
  `id` mediumint(8) unsigned NOT NULL default '0',
  `question_id` mediumint(8) unsigned NOT NULL default '0',
  `answer` text NOT NULL,
  `correct` mediumint(8) unsigned default NULL,
  `comment` text,
  `ponderation` smallint(6) default NULL,
  `position` mediumint(8) unsigned NOT NULL default '1',
  PRIMARY KEY  (`id`,`question_id`)
) TYPE=MyISAM

Fields

id:
question_id:
answer:
correct:
comment:
ponderation:
position:

quiz_question

Description

Table structure

CREATE TABLE `quiz_question` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `question` varchar(200) NOT NULL default ,
  `description` text,
  `ponderation` smallint(5) unsigned default NULL,
  `position` mediumint(8) unsigned NOT NULL default '1',
  `type` tinyint(3) unsigned NOT NULL default '2',
  `picture` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
question:
description:
ponderation:
position:
type:
picture:

quiz_rel_question

Description

Table structure

CREATE TABLE `quiz_rel_question` (
  `question_id` mediumint(8) unsigned NOT NULL default '0',
  `exercice_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`question_id`,`exercice_id`)
) TYPE=MyISAM

Fields

question_id:
exercice_id:

resource

Description

Table structure

CREATE TABLE `resource` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `source_type` varchar(50) default NULL,
  `source_id` int(10) unsigned default NULL,
  `resource_type` varchar(50) default NULL,
  `resource_id` int(10) unsigned default NULL,
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM

Fields

id:
source_type:
source_id:
resource_type:
resource_id:

scormdocument

Description

Table structure

CREATE TABLE `scormdocument` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `path` varchar(255) NOT NULL default ,
  `visibility` char(1) NOT NULL default 'v',
  `comment` varchar(255) default NULL,
  `filetype` set('file','folder') NOT NULL default 'file',
  `name` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
path:
visibility:
comment:
filetype:
name:

student_publication

Description

Table structure

CREATE TABLE `student_publication` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `url` varchar(200) default NULL,
  `title` varchar(200) default NULL,
  `description` varchar(250) default NULL,
  `author` varchar(200) default NULL,
  `active` tinyint(4) default NULL,
  `accepted` tinyint(4) default '0',
  `sent_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
url:
title:
description:
author:
active:
accepted:
sent_date:

tool

Description

Table structure

CREATE TABLE `tool` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default ,
  `link` varchar(255) NOT NULL default ,
  `image` varchar(100) default NULL,
  `visibility` tinyint(3) unsigned default '0',
  `admin` varchar(200) default NULL,
  `address` varchar(120) default NULL,
  `added_tool` enum('0','1') default '0',
  `target` enum('_self','_blank') NOT NULL default '_self',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
name:
link:
image:
visibility:
admin:
address:
added_tool:
target:

tool_intro

Description

Table structure

CREATE TABLE `tool_intro` (
  `id` varchar(50) NOT NULL default ,
  `intro_text` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
intro_text:

userinfo_content

Description

Table structure

CREATE TABLE `userinfo_content` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL default '0',
  `definition_id` int(10) unsigned NOT NULL default '0',
  `editor_ip` varchar(39) default NULL,
  `edition_time` datetime default NULL,
  `content` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`)
) TYPE=MyISAM

Fields

id:
user_id:
definition_id:
editor_ip:
edition_time:
content:

userinfo_def

Description

Table structure

CREATE TABLE `userinfo_def` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(80) NOT NULL default ,
  `comment` text,
  `line_count` tinyint(3) unsigned NOT NULL default '5',
  `rank` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

Fields

id:
title:
comment:
line_count:
rank:

Dokeos Database Structure

From Dokeos

Contents

Introduction

Main Dokeos Database

class

Description

Table structure

Fields

class_user

Description

Table structure

Fields

course

Description

Table structure

Fields

admin

Description

Table structure

Fields

course_category

Description

Table structure

Fields

course_module

Description

Table structure

Fields

course_rel_class

Description

Table structure

Fields

course_rel_user

Description

Table structure

Fields

language

Description

Table structure

Fields

session

Description

Table structure

Fields

settings_current

Description

Table structure

Fields

settings_options

Description

Table structure

Fields

sys_announcement

Description

Table structure

Fields

user

Description

Table structure

Fields

Scorm Database

scorm_main

Description

Table structure

Fields

scorm_sco_data

Description

Table structure

Fields

Tracking Database

track_c_browsers

Description

Table structure

Fields

track_c_countries

Description

Table structure

Fields

track_c_os