curios2-upgrade: curios3-db-structure.txt

-- phpMyAdmin SQL Dump
-- version 2.11.5.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 27, 2009 at 10:01 AM
-- Server version: 5.0.32
-- PHP Version: 5.2.0-8+etch13

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `curios`
--

-- --------------------------------------------------------

--
-- Table structure for table `authsource`
--

CREATE TABLE IF NOT EXISTS `authsource` (
  `id` int(10) unsigned NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `type` set('mysql','ldap','activ_dir') NOT NULL default 'mysql',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Possible authentication mechanisms';

-- --------------------------------------------------------

--
-- Table structure for table `authsource_param`
--

CREATE TABLE IF NOT EXISTS `authsource_param` (
  `authsource_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`authsource_id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Authsource connection parameters';

-- --------------------------------------------------------

--
-- Table structure for table `authsource_user`
--

CREATE TABLE IF NOT EXISTS `authsource_user` (
  `user_id` mediumint(8) unsigned NOT NULL default '0',
  `authsource_id` int(10) unsigned NOT NULL default '0',
  `order` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`user_id`,`authsource_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Authentication mechanism associated with user';

-- --------------------------------------------------------

--
-- Table structure for table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `uid` int(10) unsigned NOT NULL default '0',
  `position` int(10) unsigned NOT NULL default '0',
  `collapsed` tinyint(11) NOT NULL default '1' COMMENT '-1 = collapsed, 1 = not collapsed',
  PRIMARY KEY  (`id`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `custom_scores`
--

CREATE TABLE IF NOT EXISTS `custom_scores` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `task_id` int(10) unsigned NOT NULL default '0',
  `respident` varchar(255) NOT NULL default '0',
  `item_id` int(10) unsigned NOT NULL default '0',
  `response_value` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `answer_fk` int(10) unsigned NOT NULL default '0',
  `correct` set('false','true') NOT NULL default 'false',
  PRIMARY KEY  (`id`),
  KEY `answer_id` (`respident`),
  KEY `item_id` (`item_id`),
  KEY `task_id` (`task_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='validating response values not included in the item.xml';

-- --------------------------------------------------------

--
-- Table structure for table `examinee_record`
--

CREATE TABLE IF NOT EXISTS `examinee_record` (
  `task_log_id` bigint(20) NOT NULL default '0',
  `item_id` int(10) unsigned NOT NULL default '0',
  `section_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  `varname` varchar(32) NOT NULL default 'SCORE',
  `score` float default NULL,
  `max_score` float default NULL,
  `manual` varchar(10) NOT NULL default 'false',
  `comment` varchar(255) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `edit_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`task_log_id`,`item_id`,`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='item score after validation (manual=false or scorer user_id)';

-- --------------------------------------------------------

--
-- Table structure for table `examinee_total_score`
--

CREATE TABLE IF NOT EXISTS `examinee_total_score` (
  `task_log_id` bigint(20) NOT NULL default '0',
  `total_score` varchar(10) NOT NULL default '',
  `max_score` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`task_log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='total score per task after response validation';

-- --------------------------------------------------------

--
-- Table structure for table `item_category`
--

CREATE TABLE IF NOT EXISTS `item_category` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `parent_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `item_editable`
--

CREATE TABLE IF NOT EXISTS `item_editable` (
  `id` bigint(20) NOT NULL auto_increment,
  `title` varchar(200) NOT NULL,
  `xml_uri` varchar(255) NOT NULL default '',
  `secret_key` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='items that are not yet used in an official task';

-- --------------------------------------------------------

--
-- Table structure for table `item_pool`
--

CREATE TABLE IF NOT EXISTS `item_pool` (
  `id` int(10) unsigned NOT NULL default '0',
  `xml_uri` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `xml_uri` (`xml_uri`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Frozen items moved from item_editable after usage in a task';

-- --------------------------------------------------------

--
-- Table structure for table `item_properties`
--

CREATE TABLE IF NOT EXISTS `item_properties` (
  `item_id` int(10) unsigned NOT NULL default '0',
  `keywords` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Properties related to item';

-- --------------------------------------------------------

--
-- Table structure for table `item_section`
--

CREATE TABLE IF NOT EXISTS `item_section` (
  `id` bigint(20) NOT NULL auto_increment,
  `section_id` bigint(20) NOT NULL,
  `linkrefid` bigint(20) NOT NULL,
  `order` int(11) NOT NULL default '0',
  `type` set('itemref','sectionref') NOT NULL default 'itemref',
  PRIMARY KEY  (`id`),
  KEY `section_id` (`section_id`),
  KEY `linkrefid` (`linkrefid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='set of items used in the sections';

-- --------------------------------------------------------

--
-- Table structure for table `item_templates`
--

CREATE TABLE IF NOT EXISTS `item_templates` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `xml_uri` varchar(120) NOT NULL default '',
  `title` varchar(120) NOT NULL default '',
  `order` int(11) NOT NULL default '0',
  `cat_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `item_user`
--

CREATE TABLE IF NOT EXISTS `item_user` (
  `user_id` mediumint(8) unsigned NOT NULL default '0',
  `item_id` int(10) unsigned NOT NULL default '0',
  `permission` int(10) unsigned NOT NULL default '4294967295',
  PRIMARY KEY  (`user_id`,`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='User permission on item';

-- --------------------------------------------------------

--
-- Table structure for table `lang_client_servers`
--

CREATE TABLE IF NOT EXISTS `lang_client_servers` (
  `name` varchar(50) NOT NULL default '',
  `hostname` varchar(50) NOT NULL default '',
  `database` varchar(50) NOT NULL default '',
  `user` varchar(50) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Remote database for language translation';

-- --------------------------------------------------------

--
-- Table structure for table `lang_code`
--

CREATE TABLE IF NOT EXISTS `lang_code` (
  `code` varchar(4) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',
  `native_name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`code`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Language codes with full name description';

-- --------------------------------------------------------

--
-- Table structure for table `lang_location`
--

CREATE TABLE IF NOT EXISTS `lang_location` (
  `var_id` mediumint(8) unsigned NOT NULL default '0',
  `script_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`var_id`,`script_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Link between variables and scripts';

-- --------------------------------------------------------

--
-- Table structure for table `lang_scripts`
--

CREATE TABLE IF NOT EXISTS `lang_scripts` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `script` varchar(50) NOT NULL default '',
  `order` smallint(5) unsigned NOT NULL default '1',
  `version` varchar(10) NOT NULL default '',
  `include` set('false','true') NOT NULL default 'false',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `script` (`script`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Scripts with display order';

-- --------------------------------------------------------

--
-- Table structure for table `lang_translation`
--

CREATE TABLE IF NOT EXISTS `lang_translation` (
  `lang_code` varchar(4) NOT NULL default '',
  `var_id` mediumint(8) unsigned NOT NULL default '0',
  `translation` varchar(255) NOT NULL default '',
  `translation_ext_id` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`lang_code`,`var_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `lang_translation_ext`
--

CREATE TABLE IF NOT EXISTS `lang_translation_ext` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `translation` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Extended language translations';

-- --------------------------------------------------------

--
-- Table structure for table `lang_var`
--

CREATE TABLE IF NOT EXISTS `lang_var` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Language variables';

-- --------------------------------------------------------

--
-- Table structure for table `response`
--

CREATE TABLE IF NOT EXISTS `response` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `task_log_id` bigint(20) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  `respident` varchar(255) NOT NULL default '',
  `item_id` int(10) unsigned NOT NULL default '0',
  `task_id` int(10) unsigned NOT NULL default '0',
  `response_ext_id` int(10) unsigned NOT NULL default '0',
  `response_value` varchar(255) NOT NULL default '',
  `custom_score` varchar(10) default NULL,
  `status` set('correct','wrong','no_answer','empty','old','active') NOT NULL default 'active',
  `begin_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `end_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `duration` int(11) NOT NULL default '0',
  `key` varchar(32) NOT NULL default '',
  `action` set('finished','time-out') NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`,`task_id`),
  KEY `respident` (`respident`),
  KEY `task_id` (`task_id`),
  KEY `task_log_id` (`task_log_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='response input by task executions';

-- --------------------------------------------------------

--
-- Table structure for table `response_ext`
--

CREATE TABLE IF NOT EXISTS `response_ext` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `answer` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='response inputs with more than 255 chars';

-- --------------------------------------------------------

--
-- Table structure for table `scripts_log`
--

CREATE TABLE IF NOT EXISTS `scripts_log` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `script` varchar(50) NOT NULL default '',
  `execution_time` float NOT NULL default '0',
  `sql_execution_time` float NOT NULL default '0',
  `execution_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `php_version` varchar(5) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `script` (`script`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='debugging information';

-- --------------------------------------------------------

--
-- Table structure for table `section`
--

CREATE TABLE IF NOT EXISTS `section` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `author_id` int(10) unsigned NOT NULL default '0',
  `xml_uri` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `type` set('section','template') NOT NULL default 'section',
  `modified_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `metadata` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `owner` (`author_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Registered sections (=question series)';

-- --------------------------------------------------------

--
-- Table structure for table `section_category`
--

CREATE TABLE IF NOT EXISTS `section_category` (
  `section_id` int(10) unsigned NOT NULL default '0',
  `category_id` int(10) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `position` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`section_id`,`category_id`,`uid`),
  KEY `idx_category_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `section_user`
--

CREATE TABLE IF NOT EXISTS `section_user` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `section_id` int(10) unsigned NOT NULL default '0',
  `permission` int(10) unsigned NOT NULL default '4294967295',
  `order` int(10) unsigned NOT NULL default '0',
  `can_edit` set('false','true') NOT NULL default 'true',
  `can_download` set('false','true') NOT NULL default 'true',
  `can_delete` set('false','true') NOT NULL default 'true',
  `can_share` set('false','true') NOT NULL default 'true',
  PRIMARY KEY  (`user_id`,`section_id`),
  KEY `section_id` (`section_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Permission for user on section';

-- --------------------------------------------------------

--
-- Table structure for table `sql_log`
--

CREATE TABLE IF NOT EXISTS `sql_log` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `query` text NOT NULL,
  `duration` float NOT NULL default '0',
  `caller_file` varchar(255) NOT NULL default '',
  `caller_line` int(10) unsigned NOT NULL default '0',
  `error_no` int(11) NOT NULL default '0',
  `error_msg` varchar(255) NOT NULL default '',
  `num_rows` varchar(10) NOT NULL default '0',
  `insert_id` varchar(10) NOT NULL default '0',
  `affected_rows` varchar(10) NOT NULL default '0',
  `creation_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
  KEY `error_no` (`error_no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Log the sql commands';

-- --------------------------------------------------------

--
-- Table structure for table `system_blacklist`
--

CREATE TABLE IF NOT EXISTS `system_blacklist` (
  `ip` varchar(15) NOT NULL default '0.0.0.0',
  `timestmp` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Blacklisted IPs with timestamp';

-- --------------------------------------------------------

--
-- Table structure for table `system_err_reporting`
--

CREATE TABLE IF NOT EXISTS `system_err_reporting` (
  `err_level` smallint(5) unsigned NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`err_level`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Defined error levels';

-- --------------------------------------------------------

--
-- Table structure for table `system_graylist`
--

CREATE TABLE IF NOT EXISTS `system_graylist` (
  `ip` varchar(15) NOT NULL default '0.0.0.0',
  `timestmp` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ip`,`timestmp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Graylisted IPs with timestamp';

-- --------------------------------------------------------

--
-- Table structure for table `system_log`
--

CREATE TABLE IF NOT EXISTS `system_log` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `ip` varchar(15) NOT NULL default '0.0.0.0',
  `browser` varchar(255) NOT NULL default '',
  `sid` varchar(255) NOT NULL default '',
  `action` varchar(255) NOT NULL default '',
  `status` set('success','fail') NOT NULL default 'fail',
  `timestmp` datetime NOT NULL default '0000-00-00 00:00:00',
  `info` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Register system events';

-- --------------------------------------------------------

--
-- Table structure for table `system_paths`
--

CREATE TABLE IF NOT EXISTS `system_paths` (
  `name` varchar(255) NOT NULL default '',
  `path` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='paths for code locations';

-- --------------------------------------------------------

--
-- Table structure for table `system_settings`
--

CREATE TABLE IF NOT EXISTS `system_settings` (
  `id` tinyint(3) unsigned NOT NULL auto_increment,
  `status` set('online','offline') NOT NULL default 'online',
  `lang_debug` set('true','false') NOT NULL default 'true',
  `default_lang` varchar(4) NOT NULL default 'en',
  `css` varchar(30) NOT NULL default 'default.css',
  `err_level` tinyint(3) unsigned NOT NULL default '0',
  `log_script_time` set('true','false') NOT NULL default 'true',
  `default_login` varchar(15) NOT NULL default 'curios',
  `max_clipboard_items` int(10) unsigned NOT NULL default '5',
  `zip_executable` varchar(255) NOT NULL default '',
  `compression_level` tinyint(1) NOT NULL default '0',
  `menu_icons` tinyint(1) unsigned NOT NULL default '1',
  `logging` set('admins','all','off') NOT NULL default 'off',
  `log_to_database` set('false','true') NOT NULL default 'false',
  `log_to_screen` set('false','true') NOT NULL default 'false',
  `log_filename` varchar(255) NOT NULL default '',
  `log_script` set('false','true') NOT NULL default 'false',
  `encrypt_items` set('false','true') NOT NULL default 'true',
  `tex_render_url` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='System settings';

-- --------------------------------------------------------

--
-- Table structure for table `system_tables`
--

CREATE TABLE IF NOT EXISTS `system_tables` (
  `name` varchar(50) NOT NULL default '',
  `real_name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`name`),
  UNIQUE KEY `real_name` (`real_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table names';

-- --------------------------------------------------------

--
-- Table structure for table `system_user`
--

CREATE TABLE IF NOT EXISTS `system_user` (
  `user_id` mediumint(8) unsigned NOT NULL default '0',
  `permission_id` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`user_id`,`permission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='User permissions';

-- --------------------------------------------------------

--
-- Table structure for table `task`
--

CREATE TABLE IF NOT EXISTS `task` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `owner` int(10) unsigned NOT NULL default '0',
  `section_id` int(10) unsigned NOT NULL default '0',
  `start` datetime NOT NULL default '0000-00-00 00:00:00',
  `end` datetime NOT NULL default '0000-00-00 00:00:00',
  `display_feedback` set('false','true') NOT NULL default 'true',
  `go_back` set('false','true') NOT NULL default 'true',
  `question_duration` int(10) unsigned NOT NULL default '60',
  `task_duration` int(10) unsigned NOT NULL default '0',
  `description` varchar(255) NOT NULL default '',
  `display_question_duration` set('false','true') NOT NULL default 'true',
  `display_task_duration` set('false','true') NOT NULL default 'true',
  `intro_text` text NOT NULL,
  `origin_server` varchar(20) NOT NULL default '',
  `origin_course` varchar(20) NOT NULL default '',
  `origin_taskid` varchar(20) NOT NULL default '',
  `display_report` set('false','true') NOT NULL default 'false',
  `display_report_start` datetime NOT NULL default '0000-00-00 00:00:00',
  `number_of_tasklogs` int(11) NOT NULL default '1',
  `anonymous` set('false','true') NOT NULL default 'false',
  `visibility` tinyint(1) NOT NULL default '1',
  `reps` int(11) NOT NULL default '-1',
  `shuffle` set('false','true') NOT NULL default 'false',
  `branching_enabled` set('false','true') NOT NULL default 'false',
  `propagation` text,
  `metadata` text,
  `language` char(2) NOT NULL default 'nl',
  `css` varchar(50) NOT NULL default 'show.css',
  PRIMARY KEY  (`id`),
  KEY `owner` (`owner`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Execution unit for a ''''passive'''' section (question series)';

-- --------------------------------------------------------

--
-- Table structure for table `task_log`
--

CREATE TABLE IF NOT EXISTS `task_log` (
  `task_log_id` bigint(20) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL default '0',
  `task_id` int(10) unsigned NOT NULL default '0',
  `key` varchar(32) NOT NULL default '',
  `ip` varchar(16) NOT NULL default '',
  `browser` varchar(255) NOT NULL default '',
  `begin_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `end_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `action` set('start','finished','time-out','resumed','restart') NOT NULL default '',
  `metadata` text NOT NULL,
  `reps` int(11) NOT NULL default '-1',
  PRIMARY KEY  (`task_log_id`),
  KEY `user_id` (`user_id`,`task_id`),
  KEY `task_id` (`task_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Logging info for a task execution per user';

-- --------------------------------------------------------

--
-- Table structure for table `task_log_ops`
--

CREATE TABLE IF NOT EXISTS `task_log_ops` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `task_log_id` bigint(20) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  `task_id` int(10) unsigned NOT NULL default '0',
  `key` varchar(32) NOT NULL default '',
  `ip` varchar(16) NOT NULL default '',
  `browser` varchar(255) NOT NULL default '',
  `begin_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `end_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `action` set('start','finished','time-out','resumed','restart') NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`,`task_id`),
  KEY `task_id` (`task_id`),
  KEY `task_log_id` (`task_log_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Logging info for a task execution per user';

-- --------------------------------------------------------

--
-- Table structure for table `task_user`
--

CREATE TABLE IF NOT EXISTS `task_user` (
  `task_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  `can_edit` set('false','true') NOT NULL default 'true',
  `can_download` set('false','true') NOT NULL default 'true',
  `can_delete` set('false','true') NOT NULL default 'true',
  `can_share` set('false','true') NOT NULL default 'true',
  PRIMARY KEY  (`task_id`,`user_id`),
  KEY `task_id` (`task_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='user permissions for (co)authors of tasks';

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `authSource` varchar(50) NOT NULL default 'curios',
  `password` varchar(32) NOT NULL default '',
  `salt` char(3) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',
  `surname` varchar(50) NOT NULL default '',
  `email` varchar(130) NOT NULL default '',
  `reg_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `mod_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `external_id` varchar(50) default NULL,
  `status` set('docent','student','admin') NOT NULL default 'docent',
  `origin` varchar(50) NOT NULL default '',
  `origin_id` int(10) unsigned NOT NULL default '0',
  `sort_name` varchar(50) NOT NULL default '',
  `version` set('v1','v2') NOT NULL default 'v2',
  `language` char(2) NOT NULL default 'en',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `login_2` (`username`),
  KEY `name` (`name`),
  KEY `surname` (`surname`),
  KEY `idx_origin_id` (`origin_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='all registered users';

-- --------------------------------------------------------

--
-- Table structure for table `user_category`
--

CREATE TABLE IF NOT EXISTS `user_category` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `collapsed` tinyint(1) NOT NULL default '0',
  `position` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `user_data`
--

CREATE TABLE IF NOT EXISTS `user_data` (
  `id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  `parent` varchar(25) NOT NULL default '',
  `index` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  `type` set('integer','string','bool','float','parent') NOT NULL default 'string',
  `modification_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`),
  KEY `parent` (`parent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `user_id_translation`
--

CREATE TABLE IF NOT EXISTS `user_id_translation` (
  `external_user_id` int(10) unsigned NOT NULL default '0',
  `external_source` varchar(255) NOT NULL default '',
  `user_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`external_user_id`,`external_source`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='External ID to system user_id translation table';

-- --------------------------------------------------------

--
-- Table structure for table `user_ipkey`
--

CREATE TABLE IF NOT EXISTS `user_ipkey` (
  `user_id` mediumint(8) unsigned NOT NULL default '0',
  `key` char(40) NOT NULL default '',
  `extra_key` char(32) NOT NULL default '',
  `timestmp` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Requested IP key';

-- --------------------------------------------------------

--
-- Table structure for table `user_passwd`
--

CREATE TABLE IF NOT EXISTS `user_passwd` (
  `uid` int(10) unsigned NOT NULL default '0',
  `password` char(128) NOT NULL,
  `trials` tinyint(4) NOT NULL default '0',
  `timestmp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `user_profile`
--

CREATE TABLE IF NOT EXISTS `user_profile` (
  `id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  `parent` varchar(25) NOT NULL default '',
  `index` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  `type` set('integer','string','bool','float','parent') NOT NULL default 'string',
  `modification_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`),
  KEY `parent` (`parent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='collection of authoring settings';

-- --------------------------------------------------------

--
-- Table structure for table `user_restrictlist`
--

CREATE TABLE IF NOT EXISTS `user_restrictlist` (
  `user_id` mediumint(8) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '0.0.0.0',
  `restrict` set('true','false') NOT NULL default 'false',
  PRIMARY KEY  (`user_id`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='IPs per user with restricted status true/false';