-- MySQL dump 10.11
--
-- Host: localhost    Database: docebo35
-- ------------------------------------------------------
-- Server version	5.0.38-Ubuntu_0ubuntu1-log
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL40' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


--
-- Table structure for table `learning_advice`
--

CREATE TABLE `learning_advice` (
  `idAdvice` int(11) NOT NULL auto_increment,
  `idCourse` int(11) NOT NULL default '0',
  `posted` datetime NOT NULL default '0000-00-00 00:00:00',
  `author` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `important` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`idAdvice`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_advice`
--






--
-- Table structure for table `learning_adviceuser`
--

CREATE TABLE `learning_adviceuser` (
  `idAdvice` int(11) NOT NULL default '0',
  `idUser` int(11) NOT NULL default '0',
  `archivied` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`idAdvice`,`idUser`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_adviceuser`
--






--
-- Table structure for table `learning_assessment_rules`
--

CREATE TABLE `learning_assessment_rules` (
  `id_rule` int(11) NOT NULL auto_increment,
  `id_assessment` int(11) NOT NULL default '0',
  `rule_type` varchar(255) NOT NULL default '',
  `rule_setting` varchar(255) NOT NULL default '',
  `rule_effect` text NOT NULL,
  `rule_casualities` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_rule`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_assessment_rules`
--






--
-- Table structure for table `learning_assessment_user`
--

CREATE TABLE `learning_assessment_user` (
  `id_assessment` int(11) NOT NULL default '0',
  `id_user` int(11) NOT NULL default '0',
  `type_of` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id_assessment`,`id_user`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_assessment_user`
--






--
-- Table structure for table `learning_calendar`
--

CREATE TABLE `learning_calendar` (
  `id` bigint(20) NOT NULL default '0',
  `idCourse` int(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_calendar`
--






--
-- Table structure for table `learning_catalogue`
--

CREATE TABLE `learning_catalogue` (
  `idCatalogue` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`idCatalogue`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_catalogue`
--






--
-- Table structure for table `learning_catalogue_entry`
--

CREATE TABLE `learning_catalogue_entry` (
  `idCatalogue` int(11) NOT NULL default '0',
  `idEntry` int(11) NOT NULL default '0',
  `type_of_entry` enum('course','coursepath') NOT NULL default 'course',
  PRIMARY KEY  (`idCatalogue`,`idEntry`,`type_of_entry`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_catalogue_entry`
--






--
-- Table structure for table `learning_catalogue_member`
--

CREATE TABLE `learning_catalogue_member` (
  `idCatalogue` int(11) NOT NULL default '0',
  `idst_member` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idCatalogue`,`idst_member`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_catalogue_member`
--






--
-- Table structure for table `learning_category`
--

CREATE TABLE `learning_category` (
  `idCategory` int(11) NOT NULL auto_increment,
  `idParent` int(11) NOT NULL default '0',
  `lev` int(11) NOT NULL default '0',
  `path` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY  (`idCategory`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_category`
--






--
-- Table structure for table `learning_certificate`
--

CREATE TABLE `learning_certificate` (
  `id_certificate` int(11) NOT NULL auto_increment,
  `code` VARCHAR( 255 ) NOT NULL,
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `base_language` varchar(255) NOT NULL default '',
  `cert_structure` text NOT NULL,
  `orientation` ENUM( 'P', 'L' ) NOT NULL DEFAULT 'P',
  `bgimage` VARCHAR( 255 ) NOT NULL,
  PRIMARY KEY  (`id_certificate`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_certificate`
--






--
-- Table structure for table `learning_certificate_assign`
--

CREATE TABLE `learning_certificate_assign` (
  `id_certificate` int(11) NOT NULL default '0',
  `id_course` int(11) NOT NULL default '0',
  `id_user` int(11) NOT NULL default '0',
  `on_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `cert_file` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id_certificate`,`id_course`,`id_user`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_certificate_assign`
--






--
-- Table structure for table `learning_certificate_course`
--

CREATE TABLE `learning_certificate_course` (
  `id_certificate` int(11) NOT NULL default '0',
  `id_course` int(11) NOT NULL default '0',
  `available_for_status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id_certificate`,`id_course`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_certificate_course`
--






--
-- Table structure for table `learning_certificate_tags`
--

CREATE TABLE `learning_certificate_tags` (
  `file_name` varchar(255) NOT NULL default '',
  `class_name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`file_name`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_certificate_tags`
--



INSERT INTO `learning_certificate_tags` VALUES ('certificate.course.php','CertificateSubs_Course'),('certificate.user.php','CertificateSubs_User'),('certificate.userstat.php','CertificateSubs_UserStat'),('certificate.misc.php','CertificateSubs_Misc');



--
-- Table structure for table `learning_class_location`
--

CREATE TABLE `learning_class_location` (
  `location_id` int(11) NOT NULL auto_increment,
  `location` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`location_id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_class_location`
--






--
-- Table structure for table `learning_classroom`
--

CREATE TABLE `learning_classroom` (
  `idClassroom` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `location_id` int(11) NOT NULL default '0',
  `room` varchar(255) NOT NULL default '',
  `street` varchar(255) NOT NULL default '',
  `city` varchar(255) NOT NULL default '',
  `state` varchar(255) NOT NULL default '',
  `zip_code` varchar(255) NOT NULL default '',
  `phone` varchar(255) NOT NULL default '',
  `fax` varchar(255) NOT NULL default '',
  `capacity` varchar(255) NOT NULL default '',
  `disposition` text NOT NULL,
  `instrument` text NOT NULL,
  `available_instrument` text NOT NULL,
  `note` text NOT NULL,
  `responsable` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idClassroom`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_classroom`
--






--
-- Table structure for table `learning_classroom_calendar`
--

CREATE TABLE `learning_classroom_calendar` (
  `id` int(11) NOT NULL auto_increment,
  `classroom_id` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `owner` int(11) NOT NULL default '0',
  `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=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_classroom_calendar`
--






--
-- Table structure for table `learning_comment_ajax`
--

CREATE TABLE `learning_comment_ajax` (
  `id_comment` int(11) NOT NULL auto_increment,
  `resource_type` varchar(50) NOT NULL default '',
  `external_key` varchar(200) NOT NULL default '',
  `id_author` int(11) NOT NULL default '0',
  `posted_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `textof` text NOT NULL,
  `history_tree` varchar(255) NOT NULL default '',
  `id_parent` int(11) NOT NULL default '0',
  `moderated` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id_comment`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_comment_ajax`
--






--
-- Table structure for table `learning_commontrack`
--

CREATE TABLE `learning_commontrack` (
  `idReference` int(11) NOT NULL default '0',
  `idUser` int(11) NOT NULL default '0',
  `idTrack` int(11) NOT NULL default '0',
  `objectType` varchar(20) NOT NULL default '',
  `dateAttempt` datetime NOT NULL default '0000-00-00 00:00:00',
  `status` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`idTrack`,`objectType`),
  KEY `idReference` (`idReference`),
  KEY `idUser` (`idUser`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_commontrack`
--






--
-- Table structure for table `learning_course`
--

CREATE TABLE `learning_course` (
  `idCourse` int(11) NOT NULL auto_increment,
  `idCategory` int(11) NOT NULL default '0',
  `code` varchar(50) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `lang_code` varchar(100) NOT NULL default '',
  `status` int(1) NOT NULL default '0',
  `level_show_user` int(11) NOT NULL default '0',
  `subscribe_method` tinyint(1) NOT NULL default '0',
  `linkSponsor` varchar(255) NOT NULL default '',
  `imgSponsor` varchar(255) NOT NULL default '',
  `img_course` varchar(255) NOT NULL default '',
  `img_material` varchar(255) NOT NULL default '',
  `img_othermaterial` varchar(255) NOT NULL default '',
  `course_demo` varchar(255) NOT NULL default '',
  `mediumTime` int(10) unsigned NOT NULL default '0',
  `permCloseLO` tinyint(1) NOT NULL default '0',
  `userStatusOp` int(11) NOT NULL default '0',
  `difficult` enum('veryeasy','easy','medium','difficult','verydifficult') NOT NULL default 'medium',
  `show_progress` tinyint(1) NOT NULL default '1',
  `show_time` tinyint(1) NOT NULL default '0',
  `show_extra_info` tinyint(1) NOT NULL default '0',
  `show_rules` tinyint(1) NOT NULL default '0',
  `date_begin` date NOT NULL default '0000-00-00',
  `date_end` date NOT NULL default '0000-00-00',
  `hour_begin` varchar(5) NOT NULL default '',
  `hour_end` varchar(5) NOT NULL default '',
  `valid_time` int(10) NOT NULL default '0',
  `max_num_subscribe` int(11) NOT NULL default '0',
  `min_num_subscribe` int(11) NOT NULL default '0',
  `max_sms_budget` double NOT NULL default '0',
  `selling` tinyint(1) NOT NULL default '0',
  `prize` varchar(255) NOT NULL default '',
  `course_type` varchar(255) NOT NULL default 'elearning',
  `policy_point` varchar(255) NOT NULL default '',
  `point_to_all` int(10) NOT NULL default '0',
  `course_edition` tinyint(1) NOT NULL default '0',
  `classrooms` varchar(255) NOT NULL default '',
  `certificates` varchar(255) NOT NULL default '',
  `create_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `security_code` varchar(255) NOT NULL default '',
  `imported_from_connection` varchar(255) default NULL,
  `course_quota` varchar(255) NOT NULL default '-1',
  `used_space` varchar(255) NOT NULL default '0',
  `course_vote` double NOT NULL default '0',
  `allow_overbooking` tinyint(1) NOT NULL default '0',
  `can_subscribe` tinyint(1) NOT NULL default '0',
  `sub_start_date` datetime default NULL,
  `sub_end_date` datetime default NULL,
  `advance` varchar(255) NOT NULL default '',
  `show_who_online` TINYINT( 1 ) NOT NULL ,
  `direct_play` TINYINT( 1 ) NOT NULL ,
  `autoregistration_code` VARCHAR( 255 ) NOT NULL ,
  `use_logo_in_courselist` TINYINT(1) NOT NULL ,
  PRIMARY KEY  (`idCourse`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_course`
--






--
-- Table structure for table `learning_course_edition`
--

CREATE TABLE `learning_course_edition` (
  `idCourseEdition` int(11) NOT NULL auto_increment,
  `idCourse` int(11) NOT NULL default '0',
  `code` varchar(50) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `status` int(1) NOT NULL default '0',
  `img_material` varchar(255) NOT NULL default '',
  `img_othermaterial` varchar(255) NOT NULL default '',
  `date_begin` date NOT NULL default '0000-00-00',
  `date_end` date NOT NULL default '0000-00-00',
  `hour_begin` varchar(5) NOT NULL default '',
  `hour_end` varchar(5) NOT NULL default '',
  `classrooms` varchar(255) NOT NULL default '',
  `max_num_subscribe` int(11) NOT NULL default '0',
  `min_num_subscribe` int(11) NOT NULL default '0',
  `price` varchar(255) NOT NULL default '',
  `advance` varchar(255) NOT NULL default '',
  `edition_type` varchar(255) NOT NULL default 'elearning',
  `allow_overbooking` tinyint(1) NOT NULL default '0',
  `can_subscribe` tinyint(1) NOT NULL default '0',
  `sub_start_date` datetime default NULL,
  `sub_end_date` datetime default NULL,
  PRIMARY KEY  (`idCourseEdition`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_course_edition`
--






--
-- Table structure for table `learning_course_file`
--

CREATE TABLE `learning_course_file` (
  `id_file` int(11) NOT NULL auto_increment,
  `id_course` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `path` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id_file`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_course_file`
--






--
-- Table structure for table `learning_course_point`
--

CREATE TABLE `learning_course_point` (
  `idCourse` int(11) NOT NULL default '0',
  `idField` int(11) NOT NULL default '0',
  `point` int(11) NOT NULL default '0'
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_course_point`
--






--
-- Table structure for table `learning_coursepath`
--

CREATE TABLE `learning_coursepath` (
  `id_path` int(11) NOT NULL auto_increment,
  `path_code` varchar(255) NOT NULL default '',
  `path_name` varchar(255) NOT NULL default '',
  `path_descr` text NOT NULL,
  `subscribe_method` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id_path`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_coursepath`
--






--
-- Table structure for table `learning_coursepath_courses`
--

CREATE TABLE `learning_coursepath_courses` (
  `id_path` int(11) NOT NULL default '0',
  `id_item` int(11) NOT NULL default '0',
  `in_slot` int(11) NOT NULL default '0',
  `prerequisites` text NOT NULL,
  `sequence` int(3) NOT NULL default '0',
  PRIMARY KEY  (`id_path`,`id_item`,`in_slot`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_coursepath_courses`
--






--
-- Table structure for table `learning_coursepath_slot`
--

CREATE TABLE `learning_coursepath_slot` (
  `id_slot` int(11) NOT NULL auto_increment,
  `id_path` int(11) NOT NULL default '0',
  `min_selection` int(3) NOT NULL default '0',
  `max_selection` int(3) NOT NULL default '0',
  `sequence` int(3) NOT NULL default '0',
  PRIMARY KEY  (`id_slot`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_coursepath_slot`
--






--
-- Table structure for table `learning_coursepath_user`
--

CREATE TABLE `learning_coursepath_user` (
  `id_path` int(11) NOT NULL default '0',
  `idUser` int(11) NOT NULL default '0',
  `waiting` tinyint(1) NOT NULL default '0',
  `subscribed_by` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_path`,`idUser`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_coursepath_user`
--






--
-- Table structure for table `learning_coursereport`
--

CREATE TABLE `learning_coursereport` (
  `id_report` int(11) NOT NULL auto_increment,
  `id_course` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `max_score` float NOT NULL default '0',
  `required_score` float NOT NULL default '0',
  `weight` int(3) NOT NULL default '0',
  `show_to_user` enum('true','false') NOT NULL default 'true',
  `use_for_final` enum('true','false') NOT NULL default 'true',
  `sequence` int(3) NOT NULL default '0',
  `source_of` enum('test','activity','scorm','final_vote') NOT NULL default 'test',
  `id_source` varchar(255) NOT NULL default '0',
  PRIMARY KEY  (`id_report`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_coursereport`
--






--
-- Table structure for table `learning_coursereport_score`
--

CREATE TABLE `learning_coursereport_score` (
  `id_report` int(11) NOT NULL default '0',
  `id_user` int(11) NOT NULL default '0',
  `date_attempt` datetime NOT NULL default '0000-00-00 00:00:00',
  `score` double(5,2) NOT NULL default '0.00',
  `score_status` enum('valid','not_checked','not_passed','passed') NOT NULL default 'valid',
  `comment` text NOT NULL,
  PRIMARY KEY  (`id_report`,`id_user`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_coursereport_score`
--






--
-- Table structure for table `learning_courseuser`
--

CREATE TABLE `learning_courseuser` (
  `idUser` int(11) NOT NULL default '0',
  `idCourse` int(11) NOT NULL default '0',
  `edition_id` int(11) NOT NULL default '0',
  `level` int(11) NOT NULL default '0',
  `date_inscr` datetime default NULL,
  `date_first_access` datetime default NULL,
  `date_complete` datetime default NULL,
  `status` int(1) NOT NULL default '0',
  `waiting` tinyint(1) NOT NULL default '0',
  `subscribed_by` int(11) NOT NULL default '0',
  `score_given` int(4) default NULL,
  `imported_from_connection` varchar(255) default NULL,
  `absent` tinyint(1) NOT NULL default '0',
  `cancelled_by` int(11) NOT NULL default '0',
  `new_forum_post` int( 11 ) NOT NULL default '0',
  PRIMARY KEY  (`idUser`,`idCourse`,`edition_id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_courseuser`
--






--
-- Table structure for table `learning_eportfolio`
--

CREATE TABLE `learning_eportfolio` (
  `id_portfolio` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `custom_pdp_descr` text NOT NULL,
  `custom_competence_descr` text NOT NULL,
  PRIMARY KEY  (`id_portfolio`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_eportfolio`
--






--
-- Table structure for table `learning_eportfolio_competence`
--

CREATE TABLE `learning_eportfolio_competence` (
  `id_competence` int(11) NOT NULL auto_increment,
  `id_portfolio` int(11) NOT NULL default '0',
  `textof` text NOT NULL,
  `min_score` int(5) NOT NULL default '0',
  `max_score` int(5) NOT NULL default '0',
  `sequence` int(5) NOT NULL default '0',
  `block_competence` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id_competence`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_eportfolio_competence`
--






--
-- Table structure for table `learning_eportfolio_competence_invite`
--

CREATE TABLE `learning_eportfolio_competence_invite` (
  `invited_user` int(11) NOT NULL default '0',
  `sender` int(11) NOT NULL default '0',
  `id_portfolio` int(11) NOT NULL default '0',
  `message_text` text NOT NULL,
  `refused` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`invited_user`,`sender`,`id_portfolio`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_eportfolio_competence_invite`
--






--
-- Table structure for table `learning_eportfolio_competence_score`
--

CREATE TABLE `learning_eportfolio_competence_score` (
  `id_portfolio` int(11) NOT NULL default '0',
  `id_competence` int(11) NOT NULL default '0',
  `estimated_user` int(11) NOT NULL default '0',
  `from_user` int(11) NOT NULL default '0',
  `score` int(11) NOT NULL default '0',
  `comment` text NOT NULL,
  `status` int(3) NOT NULL default '0',
  PRIMARY KEY  (`id_portfolio`,`id_competence`,`estimated_user`,`from_user`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_eportfolio_competence_score`
--






--
-- Table structure for table `learning_eportfolio_curriculum`
--

CREATE TABLE `learning_eportfolio_curriculum` (
  `id_portfolio` int(11) NOT NULL default '0',
  `id_user` int(11) NOT NULL default '0',
  `curriculum_file` varchar(255) NOT NULL default '',
  `update_date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id_portfolio`,`id_user`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_eportfolio_curriculum`
--






--
-- Table structure for table `learning_eportfolio_member`
--

CREATE TABLE `learning_eportfolio_member` (
  `id_portfolio` int(11) NOT NULL default '0',
  `idst_member` int(11) NOT NULL default '0',
  `user_is_admin` enum('false','true') NOT NULL default 'false',
  PRIMARY KEY  (`id_portfolio`,`idst_member`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_eportfolio_member`
--






--
-- Table structure for table `learning_eportfolio_pdp`
--

CREATE TABLE `learning_eportfolio_pdp` (
  `id_pdp` int(11) NOT NULL auto_increment,
  `id_portfolio` int(11) NOT NULL default '0',
  `textof` text NOT NULL,
  `allow_answer` enum('true','false') NOT NULL default 'true',
  `max_answer` int(11) NOT NULL default '0',
  `answer_mod_for_day` int(11) NOT NULL default '0',
  `sequence` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_pdp`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_eportfolio_pdp`
--






--
-- Table structure for table `learning_eportfolio_pdp_answer`
--

CREATE TABLE `learning_eportfolio_pdp_answer` (
  `id_answer` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL default '0',
  `id_pdp` int(11) NOT NULL default '0',
  `textof` text NOT NULL,
  `post_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id_answer`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_eportfolio_pdp_answer`
--






--
-- Table structure for table `learning_eportfolio_presentation`
--

CREATE TABLE `learning_eportfolio_presentation` (
  `id_presentation` int(11) NOT NULL auto_increment,
  `id_portfolio` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `textof` text NOT NULL,
  `owner` int(11) NOT NULL default '0',
  `show_pdp` tinyint(1) NOT NULL default '0',
  `show_competence` tinyint(1) NOT NULL default '0',
  `show_curriculum` tinyint(1) NOT NULL default '0',
  `pubblication_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id_presentation`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_eportfolio_presentation`
--






--
-- Table structure for table `learning_eportfolio_presentation_attach`
--

CREATE TABLE `learning_eportfolio_presentation_attach` (
  `id_presentation` int(11) NOT NULL default '0',
  `id_user` int(11) NOT NULL default '0',
  `id_file` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_presentation`,`id_user`,`id_file`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_eportfolio_presentation_attach`
--






--
-- Table structure for table `learning_eportfolio_presentation_invite`
--

CREATE TABLE `learning_eportfolio_presentation_invite` (
  `id_presentation` int(11) NOT NULL default '0',
  `recipient_mail` varchar(255) NOT NULL default '',
  `security_code` varchar(255) NOT NULL default '',
  `send_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id_presentation`,`recipient_mail`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_eportfolio_presentation_invite`
--






--
-- Table structure for table `learning_faq`
--

CREATE TABLE `learning_faq` (
  `idFaq` int(11) NOT NULL auto_increment,
  `idCategory` int(11) NOT NULL default '0',
  `question` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `keyword` text NOT NULL,
  `answer` text NOT NULL,
  `sequence` int(5) NOT NULL default '0',
  PRIMARY KEY  (`idFaq`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_faq`
--






--
-- Table structure for table `learning_faq_cat`
--

CREATE TABLE `learning_faq_cat` (
  `idCategory` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `author` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idCategory`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_faq_cat`
--






--
-- Table structure for table `learning_forum`
--

CREATE TABLE `learning_forum` (
  `idForum` int(11) NOT NULL auto_increment,
  `idCourse` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `num_thread` int(11) NOT NULL default '0',
  `num_post` int(11) NOT NULL default '0',
  `last_post` int(11) NOT NULL default '0',
  `locked` tinyint(1) NOT NULL default '0',
  `sequence` int(5) NOT NULL default '0',
  `emoticons` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idForum`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_forum`
--






--
-- Table structure for table `learning_forum_access`
--

CREATE TABLE `learning_forum_access` (
  `idForum` int(11) NOT NULL default '0',
  `idMember` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idForum`,`idMember`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_forum_access`
--






--
-- Table structure for table `learning_forum_notifier`
--

CREATE TABLE `learning_forum_notifier` (
  `id_notify` int(11) NOT NULL default '0',
  `id_user` int(11) NOT NULL default '0',
  `notify_is_a` enum('forum','thread') NOT NULL default 'forum',
  PRIMARY KEY  (`id_notify`,`id_user`,`notify_is_a`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_forum_notifier`
--






--
-- Table structure for table `learning_forum_sema`
--

CREATE TABLE `learning_forum_sema` (
  `idc` int(11) NOT NULL default '0',
  `idprof` int(11) NOT NULL default '0',
  `iduser` int(11) NOT NULL default '0',
  `idmsg` int(11) NOT NULL default '0',
  `idsema` int(11) NOT NULL default '0',
  `idsemaitem` int(11) NOT NULL default '0',
  PRIMARY KEY  (`iduser`,`idmsg`,`idsema`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_forum_sema`
--






--
-- Table structure for table `learning_forum_timing`
--

CREATE TABLE `learning_forum_timing` (
  `idUser` int(11) NOT NULL default '0',
  `idCourse` int(11) NOT NULL default '0',
  `last_access` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`idUser`,`idCourse`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_forum_timing`
--






--
-- Table structure for table `learning_forummessage`
--

CREATE TABLE `learning_forummessage` (
  `idMessage` int(11) NOT NULL auto_increment,
  `idThread` int(11) NOT NULL default '0',
  `idCourse` int(11) NOT NULL default '0',
  `answer_tree` text NOT NULL,
  `title` varchar(255) NOT NULL default '',
  `textof` text NOT NULL,
  `posted` datetime NOT NULL default '0000-00-00 00:00:00',
  `author` int(11) NOT NULL default '0',
  `generator` tinyint(1) NOT NULL default '0',
  `attach` varchar(255) NOT NULL default '',
  `locked` tinyint(1) NOT NULL default '0',
  `modified_by` int(11) NOT NULL default '0',
  `modified_by_on` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`idMessage`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_forummessage`
--






--
-- Table structure for table `learning_forumthread`
--

CREATE TABLE `learning_forumthread` (
  `idThread` int(11) NOT NULL auto_increment,
  `id_edition` int( 11 ) NOT NULL default '0',
  `idForum` int(11) NOT NULL default '0',
  `posted` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` varchar(255) NOT NULL default '',
  `author` int(11) NOT NULL default '0',
  `num_post` int(11) NOT NULL default '0',
  `num_view` int(5) NOT NULL default '0',
  `last_post` int(11) NOT NULL default '0',
  `locked` tinyint(1) NOT NULL default '0',
  `erased` tinyint(1) NOT NULL default '0',
  `emoticons` varchar(255) NOT NULL default '',
  `rilevantForum` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`idThread`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_forumthread`
--






--
-- Table structure for table `learning_glossary`
--

CREATE TABLE `learning_glossary` (
  `idGlossary` int(11) NOT NULL auto_increment,
  `title` varchar(150) NOT NULL default '',
  `description` text NOT NULL,
  `author` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idGlossary`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_glossary`
--






--
-- Table structure for table `learning_glossaryterm`
--

CREATE TABLE `learning_glossaryterm` (
  `idTerm` int(11) NOT NULL auto_increment,
  `idGlossary` int(11) NOT NULL default '0',
  `term` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`idTerm`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_glossaryterm`
--






--
-- Table structure for table `learning_homerepo`
--

CREATE TABLE `learning_homerepo` (
  `idRepo` int(11) NOT NULL auto_increment,
  `idParent` int(11) NOT NULL default '0',
  `path` varchar(255) NOT NULL default '',
  `lev` int(10) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `objectType` varchar(20) NOT NULL default '',
  `idResource` int(11) NOT NULL default '0',
  `idCategory` int(11) NOT NULL default '0',
  `idUser` int(11) NOT NULL default '0',
  `idAuthor` int(11) NOT NULL default '0',
  `version` varchar(8) NOT NULL default '',
  `difficult` enum('_VERYEASY','_EASY','_MEDIUM','_DIFFICULT','_VERYDIFFICULT') NOT NULL default '_VERYEASY',
  `description` text NOT NULL,
  `language` varchar(50) NOT NULL default '',
  `resource` varchar(255) NOT NULL default '',
  `objective` text NOT NULL,
  `dateInsert` datetime NOT NULL default '0000-00-00 00:00:00',
  `idOwner` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idRepo`),
  KEY `idParent` (`idParent`),
  KEY `path` (`path`),
  KEY `idOwner` (`idOwner`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_homerepo`
--






--
-- Table structure for table `learning_htmlfront`
--

CREATE TABLE `learning_htmlfront` (
  `id_course` int(11) NOT NULL default '0',
  `textof` text NOT NULL,
  PRIMARY KEY  (`id_course`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_htmlfront`
--






--
-- Table structure for table `learning_htmlpage`
--

CREATE TABLE `learning_htmlpage` (
  `idPage` int(11) NOT NULL auto_increment,
  `title` varchar(150) NOT NULL default '',
  `textof` text NOT NULL,
  `author` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idPage`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_htmlpage`
--


CREATE TABLE `learning_instmsg` (
  `id_msg` bigint(20) NOT NULL auto_increment,
  `id_sender` int(11) NOT NULL default '0',
  `id_receiver` int(11) NOT NULL default '0',
  `msg` text,
  `status` smallint(2) NOT NULL default '0',
  `data` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id_msg`),
  KEY `id_sender` (`id_sender`,`id_receiver`)
) TYPE=InnoDB DEFAULT CHARSET=utf8 ;



--
-- Table structure for table `learning_light_repo`
--

CREATE TABLE `learning_light_repo` (
  `id_repository` int(11) NOT NULL auto_increment,
  `id_course` int(11) NOT NULL default '0',
  `repo_title` varchar(255) NOT NULL default '',
  `repo_descr` text NOT NULL,
  PRIMARY KEY  (`id_repository`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_light_repo`
--






--
-- Table structure for table `learning_light_repo_files`
--

CREATE TABLE `learning_light_repo_files` (
  `id_file` int(11) NOT NULL auto_increment,
  `id_repository` int(11) NOT NULL default '0',
  `file_name` varchar(255) NOT NULL default '',
  `file_descr` text NOT NULL,
  `id_author` int(11) NOT NULL default '0',
  `post_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id_file`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_light_repo_files`
--






--
-- Table structure for table `learning_light_repo_user`
--

CREATE TABLE `learning_light_repo_user` (
  `id_repo` int(11) NOT NULL default '0',
  `id_user` int(11) NOT NULL default '0',
  `last_enter` datetime NOT NULL default '0000-00-00 00:00:00',
  `repo_lock` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id_repo`,`id_user`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_light_repo_user`
--






--
-- Table structure for table `learning_link`
--

CREATE TABLE `learning_link` (
  `idLink` int(11) NOT NULL auto_increment,
  `idCategory` int(11) NOT NULL default '0',
  `title` varchar(150) NOT NULL default '',
  `link_address` varchar(255) NOT NULL default '',
  `keyword` text NOT NULL,
  `description` text NOT NULL,
  `sequence` int(5) NOT NULL default '0',
  PRIMARY KEY  (`idLink`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_link`
--






--
-- Table structure for table `learning_link_cat`
--

CREATE TABLE `learning_link_cat` (
  `idCategory` int(11) NOT NULL auto_increment,
  `title` varchar(150) NOT NULL default '',
  `description` text NOT NULL,
  `author` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idCategory`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_link_cat`
--






--
-- Table structure for table `learning_lo_param`
--

CREATE TABLE `learning_lo_param` (
  `id` int(11) NOT NULL auto_increment,
  `idParam` int(11) NOT NULL default '0',
  `param_name` varchar(20) NOT NULL default '',
  `param_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `idParam_name` (`idParam`,`param_name`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_lo_param`
--






--
-- Table structure for table `learning_lo_types`
--

CREATE TABLE `learning_lo_types` (
  `objectType` varchar(20) NOT NULL default '',
  `className` varchar(20) NOT NULL default '',
  `fileName` varchar(50) NOT NULL default '',
  `classNameTrack` varchar(255) NOT NULL default '',
  `fileNameTrack` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`objectType`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_lo_types`
--



INSERT INTO `learning_lo_types` VALUES ('faq','Learning_Faq','learning.faq.php','Track_Faq','track.faq.php'),('glossary','Learning_Glossary','learning.glossary.php','Track_Glossary','track.glossary.php'),('htmlpage','Learning_Htmlpage','learning.htmlpage.php','Track_Htmlpage','track.htmlpage.php'),('item','Learning_Item','learning.item.php','Track_Item','track.item.php'),('link','Learning_Link','learning.link.php','Track_Link','track.link.php'),('poll','Learning_Poll','learning.poll.php','Track_Poll','track.poll.php'),('scormorg','Learning_ScormOrg','learning.scorm.php','Track_Scormorg','track.scorm.php'),('test','Learning_Test','learning.test.php','Track_Test','track.test.php');



--
-- Table structure for table `learning_materials_lesson`
--

CREATE TABLE `learning_materials_lesson` (
  `idLesson` int(11) NOT NULL auto_increment,
  `author` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `path` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idLesson`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_materials_lesson`
--






--
-- Table structure for table `learning_materials_track`
--

CREATE TABLE `learning_materials_track` (
  `idTrack` int(11) NOT NULL auto_increment,
  `idResource` int(11) NOT NULL default '0',
  `idReference` int(11) NOT NULL default '0',
  `idUser` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idTrack`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_materials_track`
--






--
-- Table structure for table `learning_menu`
--

CREATE TABLE `learning_menu` (
  `idMenu` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `image` varchar(255) NOT NULL default '',
  `sequence` int(3) NOT NULL default '0',
  `collapse` enum('true','false') NOT NULL default 'false',
  PRIMARY KEY  (`idMenu`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_menu`
--



INSERT INTO `learning_menu` VALUES (1,'_MANAGEMENT_COURSE','',1,'false'),
(2,'_EXTERNAL_CONTENT','',2,'false'),
(10, '_MIDDLE_AREA','',3,'false'),
(3,'','',6,'true'),
(4,'','',7,'true'),
(5,'','',8,'true'),
(6,'_CLASSROOMS','',5,'false'),
(7,'_MAN_CERTIFICATE','',4,'false'),
(8,'_MANAGEMENT_RESERVATION','',9,'false'),
(9,'_LMS_STATS','',10,'false');



--
-- Table structure for table `learning_menu_under`
--

CREATE TABLE `learning_menu_under` (
  `idUnder` int(11) NOT NULL auto_increment,
  `idMenu` int(11) NOT NULL default '0',
  `module_name` varchar(255) NOT NULL default '',
  `default_name` varchar(255) NOT NULL default '',
  `default_op` varchar(255) NOT NULL default '',
  `associated_token` varchar(255) NOT NULL default '',
  `of_platform` varchar(255) default NULL,
  `sequence` int(3) NOT NULL default '0',
  `class_file` varchar(255) NOT NULL default '',
  `class_name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idUnder`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_menu_under`
--



INSERT INTO `learning_menu_under` VALUES 
(1,1,'course','_COURSE','course_list','view',NULL,1,'class.course.php','Module_Course'),
(2,1,'manmenu','_MAN_MENU','mancustom','view',NULL,2,'class.manmenu.php','Module_Manmenu'),
(3,1,'coursepath','_COURSEPATH','pathlist','view',NULL,3,'class.coursepath.php','Module_Coursepath'),
(4,1,'catalogue','_CATALOGUE','catlist','view',NULL,4,'class.catalogue.php','Module_Catalogue'),
(5,2,'webpages','_WEBPAGES','webpages','view',NULL,1,'class.webpages.php','Module_Webpages'),
(6,2,'news','_NEWS','news','view',NULL,2,'class.news.php','Module_News'),
(7,3,'questcategory','_QUESTCATEGORY','questcategory','view',NULL,1,'class.questcategory.php','Module_Questcategory'),
(8,4,'eportfolio','_EPORTFOLIO','eportfolio','view',NULL,1,'class.eportfolio.php','Module_Eportfolio'),
(9,5,'report','_REPORT','reportlist','view',NULL,1,'class.report.php','Module_Report'),
(10,1,'preassessment','_PREASSESSMENT','assesmentlist','view',NULL,5,'class.preassessment.php','Module_PreAssessment'),
(11,6,'classevent','_CLASSEVENT','main','view',NULL,3,'class.classevent.php','Module_Classevent'),
(12,6,'classlocation','_CLASSLOCATION','main','view',NULL,2,'class.classlocation.php','Module_Classlocation'),
(13,6,'classroom','_CLASSROOM','classroom','view',NULL,3,'class.classroom.php','Module_Classroom'),
(14,7,'certificate','_CERTIFICATE','certificate','view',NULL,1,'class.certificate.php','Module_Certificate'),
(15,7,'certificate','_REPORT_CERTIFICATE','report_certificate','view',NULL,2,'class.certificate.php','Module_Certificate'),
(16,9,'stats','_LMS_STATS','fake','view',NULL,0,'class.stats.php','Module_Stats'),
(17,8,'reservation','_EVENTS','view_event','view',NULL,1,'class.reservation.php','Module_Reservation'),
(18,8,'reservation','_CATEGORY','view_category','view',NULL,2,'class.reservation.php','Module_Reservation'),
(20,8,'reservation','_RESERVATION','view_registration','view',NULL,4,'class.reservation.php','Module_Reservation'),
(21, 10, 'middlearea', '_MIDDLE_AREA', 'view_area', 'view', NULL, 1, 'class.middlearea.php', 'Module_MiddleArea'),
(22, 10, 'internal_news', '_NEWS_INTERNAL', 'news', 'view', NULL, 2, 'class.internal_news.php', 'Module_Internal_News');


--
-- Table structure for table `learning_menucourse_main`
--

CREATE TABLE `learning_menucourse_main` (
  `idMain` int(11) NOT NULL auto_increment,
  `idCourse` int(11) NOT NULL default '0',
  `sequence` int(3) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `image` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idMain`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_menucourse_main`
--






--
-- Table structure for table `learning_menucourse_under`
--

CREATE TABLE `learning_menucourse_under` (
  `idCourse` int(11) NOT NULL default '0',
  `idModule` int(11) NOT NULL default '0',
  `idMain` int(11) NOT NULL default '0',
  `sequence` int(3) NOT NULL default '0',
  `my_name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idCourse`,`idModule`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_menucourse_under`
--



INSERT INTO `learning_menucourse_under` VALUES 
(0,1,0,1,''),
(0,2,0,2,''),
(0,3,0,3,''),
(0,4,0,4,''),
(0,5,0,5,''),
(0,6,0,6,''),
(0,7,0,7,''),
(0,8,0,8,''),
(0,9,0,9,''),
(0,32,0,10,''),
(0,33,0,11,'');



--
-- Table structure for table `learning_menucustom`
--

CREATE TABLE `learning_menucustom` (
  `idCustom` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`idCustom`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_menucustom`
--



INSERT INTO `learning_menucustom` VALUES (1,'Full menu','');



--
-- Table structure for table `learning_menucustom_main`
--

CREATE TABLE `learning_menucustom_main` (
  `idMain` int(11) NOT NULL auto_increment,
  `idCustom` int(11) NOT NULL default '0',
  `sequence` int(3) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `image` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idMain`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_menucustom_main`
--



INSERT INTO `learning_menucustom_main` VALUES 
(1,1,1,'Students area','room.gif'),
(2,1,2,'Collaboration area','community.gif'),
(3,1,3,'Teacher area','find.gif'),
(4,1,4,'Stat area','report.gif');



--
-- Table structure for table `learning_menucustom_under`
--

CREATE TABLE `learning_menucustom_under` (
  `idCustom` int(11) NOT NULL default '0',
  `idModule` int(11) NOT NULL default '0',
  `idMain` int(11) NOT NULL default '0',
  `sequence` int(3) NOT NULL default '0',
  `my_name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idCustom`,`idModule`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_menucustom_under`
--



INSERT INTO `learning_menucustom_under` VALUES 
(0,1,0,1,''),
(0,2,0,2,''),
(0,3,0,3,''),
(0,4,0,4,''),
(0,5,0,5,''),
(0,6,0,6,''),
(0,7,0,7,''),
(0,8,0,8,''),
(0,9,0,9,''),
(0,32,0,10,''),
(0,33,0,11,''),

(1,10,1,1,''),
(1,11,1,2,''),
(1,25,1,3,''),
(1,13,1,4,''),
(1,14,1,5,''),
(1,15,1,6,''),
(1,16,1,7,''),
(1,17,1,8,''),
(1,18,1,9,''),

(1,19,2,1,''),
(1,20,2,2,''),
(1,21,2,3,''),
(1,22,2,4,''),
(1,23,2,5,''),
(1,24,2,6,''),

(1,12,3,1,''),
(1,26,3,2,''),
(1,27,3,3,''),
(1,28,3,4,''),


(1,29,4,1,''),
(1,30,4,2,''),
(1,31,4,3,'');



--
-- Table structure for table `learning_module`
--

CREATE TABLE `learning_module` (
  `idModule` int(11) NOT NULL auto_increment,
  `module_name` varchar(255) NOT NULL default '',
  `default_op` varchar(255) NOT NULL default '',
  `default_name` varchar(255) NOT NULL default '',
  `token_associated` varchar(100) NOT NULL default '',
  `file_name` varchar(255) NOT NULL default '',
  `class_name` varchar(255) NOT NULL default '',
  `module_info` text NOT NULL,
  PRIMARY KEY  (`idModule`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_module`
--



INSERT INTO `learning_module` VALUES 
(1 ,'course'         ,'mycourses'    ,'_MYCOURSES'     ,'view'       ,'class.course.php'         ,'Module_Course'         ,'')         ,
(2 ,'coursecatalogue','courselist'   ,'_CATALOGUE'     ,'view'       ,'class.coursecatalogue.php','Module_Coursecatalogue','')         ,
(3 ,'profile'        ,'profile'      ,'_PROFILE'       ,'view'       ,'class.profile.php'        ,'Module_Profile'        ,'type=user'),
(4 ,'myfiles'        ,'myfiles'      ,'_MYFILES'       ,'view'       ,'class.myfiles.php'        ,'Module_MyFiles'        ,'type=user'),
(5 ,'mygroup'        ,'group'        ,'_MYGROUP'       ,'view'       ,'class.mygroup.php'        ,'Module_MyGroup'        ,'type=user'),
(6 ,'myfriends'      ,'myfriends'    ,'_MYFRIENDS'     ,'view'       ,'class.myfriends.php'      ,'Module_MyFriends'      ,'type=user'),
(7 ,'mycertificate'  ,'mycertificate','_MY_CERTIFICATE','view'       ,'class.mycertificate.php'  ,'Module_MyCertificate'  ,'type=user'),
(8 ,'eportfolio'     ,'eportfolio'   ,'_EPORTFOLIO'    ,'view'       ,'class.eportfolio.php'     ,'Module_EPortfolio'     ,'type=user'),
(9 ,'userevent'      ,'user_display' ,'_MYEVENTS'      ,'view'       ,'class.userevent.php'      ,'Module_UserEvent'      ,'type=user'),

(10,'course'         ,'infocourse'   ,'_INFCOURSE'     ,'view_info'  ,'class.course.php'         ,'Module_Course'         ,'')         ,
(11,'advice'         ,'advice'       ,'_ADVICE'        ,'view'       ,'class.advice.php'         ,'Module_Advice'         ,'')         ,
(12,'storage'        ,'display'      ,'_STORAGE'       ,'view'       ,'class.storage.php'        ,'Module_Storage'        ,'')         ,
(13,'calendar'       ,'calendar'     ,'_CALENDAR'      ,'view'       ,'class.calendar.php'       ,'Module_Calendar'       ,'')         ,
(14,'gradebook'      ,'showgrade'    ,'_GRADEBOOK'     ,'view'       ,'class.gradebook.php'      ,'Module_Gradebook'      ,'')         ,
(15,'notes'          ,'notes'        ,'_NOTES'         ,'view'       ,'class.notes.php'          ,'Module_Notes'          ,'')         ,
(16,'reservation'    ,'reservation'  ,'_RESERVATION'   ,'view'       ,'class.reservation.php'    ,'Module_Reservation'    ,'')         ,
(17,'light_repo'     ,'repolist'     ,'_LIGHT_REPO'    ,'view'       ,'class.light_repo.php'     ,'Module_LightRepo'      ,'')         ,
(18,'htmlfront'      ,'showhtml'     ,'_HTMLFRONT'     ,'view'       ,'class.htmlfront.php'      ,'Module_Htmlfront'      ,'')         ,

(19,'forum'          ,'forum'        ,'_FORUM'         ,'view'       ,'class.forum.php'          ,'Module_Forum'          ,'')         ,
(20,'wiki'           ,'main'         ,'_WIKI'          ,'view'       ,'class.wiki.php'           ,'Module_Wiki'           ,'')         ,
(21,'chat'           ,'chat'         ,'_CHAT'          ,'view'       ,'class.chat.php'           ,'Module_Chat'           ,'')         ,
(22,'conference'     ,'list'         ,'_CONFERENCE'    ,'view'       ,'class.conference.php'     ,'Module_Conference'     ,'')		   ,
(23,'project'        ,'project'      ,'_PROJECT'       ,'view'       ,'class.project.php'        ,'Module_Project'        ,'')         ,
(24,'groups'         ,'groups'       ,'_GROUPS'        ,'view'       ,'class.groups.php'         ,'Module_Groups'         ,'')         ,

(25,'organization'   ,'organization' ,'_ORGANIZATION'  ,'view'       ,'class.organization.php'   ,'Module_Organization'   ,'')         ,
(26,'coursereport'   ,'coursereport' ,'_COURSEREPORT'  ,'view'       ,'class.coursereport.php'   ,'Module_CourseReport'   ,'')         ,
(27,'newsletter'     ,'view'         ,'_NEWSLETTER'    ,'view'       ,'class.newsletter.php'     ,'Module_Newsletter'     ,'')         ,
(28,'manmenu'        ,'manmenu'      ,'_MAN_MENU'      ,'view'       ,'class.manmenu.php'        ,'Module_CourseManmenu'  ,'')         ,

(29,'statistic'      ,'statistic'    ,'_STAT'          ,'view'       ,'class.statistic.php'      ,'Module_Statistic'      ,'')         ,
(30,'stats'          ,'statuser'     ,'_STATUSER'      ,'view_user'  ,'class.stats.php'          ,'Module_Stats'          ,'')         ,
(31,'stats'          ,'statcourse'   ,'_STATCOURSE'    ,'view_course','class.stats.php'          ,'Module_Stats'          ,'') 		   ,
(32,'public_forum'   ,'public_forum' ,'_PUBLIC_FORUM'  ,'view'       ,'class.public_forum.php'   ,'Module_Public_Forum'    ,''),
(33,'course_autoregistration'   ,'course_autoregistration' ,'_COURSE_AUTOREGISTRATION'  ,'view'       ,'class.course_autoregistration.php'   ,'Module_Course_Autoregistration'    ,'');

CREATE TABLE `learning_middlearea` (
  `obj_index` varchar(255) NOT NULL default '',
  `disabled` tinyint(1) NOT NULL default '0',
  `idst_list` text NOT NULL,
  PRIMARY KEY  (`obj_index`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dump dei dati per la tabella `learning_middlearea`
-- 

INSERT INTO `learning_middlearea` VALUES ('mo_4', 1, 'a:0:{}');
INSERT INTO `learning_middlearea` VALUES ('mo_5', 1, 'a:0:{}');
INSERT INTO `learning_middlearea` VALUES ('mo_6', 1, 'a:0:{}');
INSERT INTO `learning_middlearea` VALUES ('mo_8', 1, 'a:0:{}');
INSERT INTO `learning_middlearea` VALUES ('mo_9', 1, 'a:0:{}');
INSERT INTO `learning_middlearea` VALUES ('public_forum', 1, 'a:0:{}');
INSERT INTO `learning_middlearea` VALUES ('course_autoregistration', 1, 'a:0:{}');
INSERT INTO `learning_middlearea` VALUES ('user_details_short', 1, 'a:0:{}');
INSERT INTO `learning_middlearea` VALUES ('search_form', 1, 'a:0:{}');
INSERT INTO `learning_middlearea` VALUES ('news', 1, 'a:0:{}');

--
-- Table structure for table `learning_news`
--

CREATE TABLE `learning_news` (
  `idNews` int(11) NOT NULL auto_increment,
  `publish_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` varchar(100) NOT NULL default '',
  `short_desc` text NOT NULL,
  `long_desc` text NOT NULL,
  `language` varchar(100) NOT NULL default '',
  `important` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`idNews`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_news`
--



CREATE TABLE `learning_news_internal` (
  `idNews` int(11) NOT NULL auto_increment,
  `publish_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` varchar(100) NOT NULL default '',
  `short_desc` text NOT NULL,
  `long_desc` text NOT NULL,
  `language` varchar(100) NOT NULL default '',
  `important` tinyint(1) NOT NULL default '0',
  `viewer` longtext NOT NULL,
  PRIMARY KEY  (`idNews`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;


--
-- Table structure for table `learning_notes`
--

CREATE TABLE `learning_notes` (
  `idNotes` int(11) NOT NULL auto_increment,
  `idCourse` int(11) NOT NULL default '0',
  `owner` int(11) NOT NULL default '0',
  `data` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` varchar(150) NOT NULL default '',
  `textof` text NOT NULL,
  PRIMARY KEY  (`idNotes`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_notes`
--






--
-- Table structure for table `learning_organization`
--

CREATE TABLE `learning_organization` (
  `idOrg` int(11) NOT NULL auto_increment,
  `idParent` int(11) NOT NULL default '0',
  `path` varchar(255) NOT NULL default '',
  `lev` int(10) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `objectType` varchar(20) NOT NULL default '',
  `idResource` int(11) NOT NULL default '0',
  `idCategory` int(11) NOT NULL default '0',
  `idUser` int(11) NOT NULL default '0',
  `idAuthor` int(11) NOT NULL default '0',
  `version` varchar(8) NOT NULL default '',
  `difficult` enum('_VERYEASY','_EASY','_MEDIUM','_DIFFICULT','_VERYDIFFICULT') NOT NULL default '_VERYEASY',
  `description` text NOT NULL,
  `language` varchar(50) NOT NULL default '',
  `resource` varchar(255) NOT NULL default '',
  `objective` text NOT NULL,
  `dateInsert` datetime NOT NULL default '0000-00-00 00:00:00',
  `idCourse` int(11) NOT NULL default '0',
  `prerequisites` varchar(255) NOT NULL default '',
  `isTerminator` tinyint(4) NOT NULL default '0',
  `idParam` int(11) NOT NULL default '0',
  `visible` tinyint(4) NOT NULL default '1',
  `milestone` enum('start','end','-') NOT NULL default '-',
  PRIMARY KEY  (`idOrg`),
  KEY `idParent` (`idParent`),
  KEY `path` (`path`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_organization`
--






--
-- Table structure for table `learning_organization_access`
--

CREATE TABLE `learning_organization_access` (
  `idOrgAccess` int(11) NOT NULL default '0',
  `kind` set('user','group') NOT NULL default '',
  `value` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idOrgAccess`,`kind`,`value`),
  KEY `idObject` (`idOrgAccess`),
  KEY `kind` (`kind`)
) TYPE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Access to items in area lesson (organization)';

--
-- Dumping data for table `learning_organization_access`
--






--
-- Table structure for table `learning_pagel`
--

CREATE TABLE `learning_pagel` (
  `id` int(11) NOT NULL auto_increment,
  `idc` int(11) NOT NULL default '0',
  `iduser` int(11) NOT NULL default '0',
  `idprof` int(11) NOT NULL default '0',
  `idatvt` int(11) NOT NULL default '0',
  `idcatval` int(11) NOT NULL default '0',
  `idvote` int(11) NOT NULL default '0',
  `adate` date NOT NULL default '0000-00-00',
  `title` varchar(255) NOT NULL default '',
  `comment` text NOT NULL,
  `status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_pagel`
--






--
-- Table structure for table `learning_pagel_atvt`
--

CREATE TABLE `learning_pagel_atvt` (
  `id` int(11) NOT NULL auto_increment,
  `idc` int(11) NOT NULL default '0',
  `idprof` int(11) NOT NULL default '0',
  `dsc` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_pagel_atvt`
--






--
-- Table structure for table `learning_pagel_sema`
--

CREATE TABLE `learning_pagel_sema` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_pagel_sema`
--






--
-- Table structure for table `learning_pagel_sema_items`
--

CREATE TABLE `learning_pagel_sema_items` (
  `id` int(11) NOT NULL auto_increment,
  `idref` int(11) NOT NULL default '0',
  `ord` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `val` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_pagel_sema_items`
--






--
-- Table structure for table `learning_pagel_vote`
--

CREATE TABLE `learning_pagel_vote` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_pagel_vote`
--






--
-- Table structure for table `learning_pagel_vote_items`
--

CREATE TABLE `learning_pagel_vote_items` (
  `id` int(11) NOT NULL auto_increment,
  `idref` int(11) NOT NULL default '0',
  `ord` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `val` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_pagel_vote_items`
--






--
-- Table structure for table `learning_poll`
--

CREATE TABLE `learning_poll` (
  `id_poll` int(11) NOT NULL auto_increment,
  `author` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`id_poll`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_poll`
--






--
-- Table structure for table `learning_pollquest`
--

CREATE TABLE `learning_pollquest` (
  `id_quest` int(11) NOT NULL auto_increment,
  `id_poll` int(11) NOT NULL default '0',
  `id_category` int(11) NOT NULL default '0',
  `type_quest` varchar(255) NOT NULL default '',
  `title_quest` text NOT NULL,
  `sequence` int(5) NOT NULL default '0',
  `page` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id_quest`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_pollquest`
--






--
-- Table structure for table `learning_pollquest_extra`
--

CREATE TABLE `learning_pollquest_extra` (
  `id_quest` int(11) NOT NULL default '0',
  `id_answer` int(11) NOT NULL default '0',
  `extra_info` text NOT NULL,
  PRIMARY KEY  (`id_quest`,`id_answer`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_pollquest_extra`
--






--
-- Table structure for table `learning_pollquestanswer`
--

CREATE TABLE `learning_pollquestanswer` (
  `id_answer` int(11) NOT NULL auto_increment,
  `id_quest` int(11) NOT NULL default '0',
  `sequence` int(11) NOT NULL default '0',
  `answer` text NOT NULL,
  PRIMARY KEY  (`id_answer`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_pollquestanswer`
--






--
-- Table structure for table `learning_polltrack`
--

CREATE TABLE `learning_polltrack` (
  `id_track` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL default '0',
  `id_reference` int(11) NOT NULL default '0',
  `id_poll` int(11) NOT NULL default '0',
  `date_attempt` datetime NOT NULL default '0000-00-00 00:00:00',
  `status` enum('valid','not_complete') NOT NULL default 'not_complete',
  PRIMARY KEY  (`id_track`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_polltrack`
--






--
-- Table structure for table `learning_polltrack_answer`
--

CREATE TABLE `learning_polltrack_answer` (
  `id_track` int(11) NOT NULL default '0',
  `id_quest` int(11) NOT NULL default '0',
  `id_answer` int(11) NOT NULL default '0',
  `more_info` longtext NOT NULL,
  PRIMARY KEY  (`id_track`,`id_quest`,`id_answer`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_polltrack_answer`
--






--
-- Table structure for table `learning_prj`
--

CREATE TABLE `learning_prj` (
  `id` int(11) NOT NULL auto_increment,
  `ptitle` varchar(255) NOT NULL default '',
  `pgroup` int(11) NOT NULL default '0',
  `pprog` tinyint(3) NOT NULL default '0',
  `psfiles` tinyint(1) NOT NULL default '0',
  `pstasks` tinyint(1) NOT NULL default '0',
  `psnews` tinyint(1) NOT NULL default '0',
  `pstodo` tinyint(1) NOT NULL default '0',
  `psmsg` tinyint(1) NOT NULL default '0',
  `cid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_prj`
--






--
-- Table structure for table `learning_prj_files`
--

CREATE TABLE `learning_prj_files` (
  `id` int(11) NOT NULL auto_increment,
  `pid` int(11) NOT NULL default '0',
  `fname` varchar(255) NOT NULL default '',
  `ftitle` varchar(255) NOT NULL default '',
  `fver` varchar(255) NOT NULL default '',
  `fdesc` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_prj_files`
--






--
-- Table structure for table `learning_prj_news`
--

CREATE TABLE `learning_prj_news` (
  `id` int(11) NOT NULL auto_increment,
  `pid` int(11) NOT NULL default '0',
  `ntitle` varchar(255) NOT NULL default '',
  `ndate` date NOT NULL default '0000-00-00',
  `ntxt` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_prj_news`
--






--
-- Table structure for table `learning_prj_tasks`
--

CREATE TABLE `learning_prj_tasks` (
  `id` int(11) NOT NULL auto_increment,
  `pid` int(11) NOT NULL default '0',
  `tprog` tinyint(3) NOT NULL default '0',
  `tname` varchar(255) NOT NULL default '',
  `tdesc` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_prj_tasks`
--






--
-- Table structure for table `learning_prj_todo`
--

CREATE TABLE `learning_prj_todo` (
  `id` int(11) NOT NULL auto_increment,
  `pid` int(11) NOT NULL default '0',
  `ttitle` varchar(255) NOT NULL default '',
  `ttxt` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_prj_todo`
--






--
-- Table structure for table `learning_prj_users`
--

CREATE TABLE `learning_prj_users` (
  `id` int(11) NOT NULL auto_increment,
  `pid` int(11) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `flag` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_prj_users`
--






--
-- Table structure for table `learning_quest_category`
--

CREATE TABLE `learning_quest_category` (
  `idCategory` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `textof` text NOT NULL,
  PRIMARY KEY  (`idCategory`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_quest_category`
--






--
-- Table structure for table `learning_quest_type`
--

CREATE TABLE `learning_quest_type` (
  `type_quest` varchar(255) NOT NULL default '',
  `type_file` varchar(255) NOT NULL default '',
  `type_class` varchar(255) NOT NULL default '',
  `sequence` int(3) NOT NULL default '0',
  PRIMARY KEY  (`type_quest`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_quest_type`
--



INSERT INTO `learning_quest_type` VALUES ('associate','class.associate.php','Associate_Question',8),('break_page','class.break_page.php','BreakPage_Question',10),('choice','class.choice.php','Choice_Question',1),('choice_multiple','class.choice_multiple.php','ChoiceMultiple_Question',2),('extended_text','class.extended_text.php','ExtendedText_Question',3),('hot_text','class.hot_text.php','HotText_Question',6),('inline_choice','class.inline_choice.php','InlineChoice_Question',5),('text_entry','class.text_entry.php','TextEntry_Question',4),('title','class.title.php','Title_Question',9),('upload','class.upload.php','Upload_Question',7);



--
-- Table structure for table `learning_quest_type_poll`
--

CREATE TABLE `learning_quest_type_poll` (
  `type_quest` varchar(255) NOT NULL default '',
  `type_file` varchar(255) NOT NULL default '',
  `type_class` varchar(255) NOT NULL default '',
  `sequence` int(3) NOT NULL default '0',
  PRIMARY KEY  (`type_quest`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_quest_type_poll`
--



INSERT INTO `learning_quest_type_poll` VALUES 
('break_page','class.break_page.php','BreakPage_Question',5),
('choice','class.choice.php','Choice_Question',1),
('choice_multiple','class.choice_multiple.php','ChoiceMultiple_Question',2),
('extended_text', 'class.extended_text.php', 'ExtendedText_Question', 3),
('title','class.title.php','Title_Question',4);



--
-- Table structure for table `learning_repo`
--

CREATE TABLE `learning_repo` (
  `idRepo` int(11) NOT NULL auto_increment,
  `idParent` int(11) NOT NULL default '0',
  `path` varchar(255) NOT NULL default '',
  `lev` int(10) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `objectType` varchar(20) NOT NULL default '',
  `idResource` int(11) NOT NULL default '0',
  `idCategory` int(11) NOT NULL default '0',
  `idUser` int(11) NOT NULL default '0',
  `idAuthor` varchar(11) NOT NULL default '0',
  `version` varchar(8) NOT NULL default '',
  `difficult` enum('_VERYEASY','_EASY','_MEDIUM','_DIFFICULT','_VERYDIFFICULT') NOT NULL default '_VERYEASY',
  `description` text NOT NULL,
  `language` varchar(50) NOT NULL default '',
  `resource` varchar(255) NOT NULL default '',
  `objective` text NOT NULL,
  `dateInsert` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`idRepo`),
  KEY `idParent` (`idParent`),
  KEY `path` (`path`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_repo`
--






--
-- Table structure for table `learning_report`
--

CREATE TABLE `learning_report` (
  `id_report` int(11) NOT NULL auto_increment,
  `report_name` varchar(255) NOT NULL default '',
  `class_name` varchar(255) NOT NULL default '',
  `file_name` varchar(255) NOT NULL default '',
  `use_user_selection` enum('true','false') NOT NULL default 'true',
  PRIMARY KEY  (`id_report`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_report`
--



INSERT INTO `learning_report` VALUES (1,'general_report','Report_General','class.report_general.php','true'),(2,'user_report','Report_User','class.report_user.php','true');



--
-- Table structure for table `learning_reservation_category`
--

CREATE TABLE `learning_reservation_category` (
  `idCategory` int(11) NOT NULL auto_increment,
  `idCourse` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `maxSubscription` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idCategory`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_reservation_category`
--






--
-- Table structure for table `learning_reservation_perm`
--

CREATE TABLE `learning_reservation_perm` (
	`event_id` INT NOT NULL ,
	`user_idst` INT NOT NULL ,
	`perm` VARCHAR( 255 ) NOT NULL ,
	PRIMARY KEY ( `event_id` , `user_idst` , `perm` )
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `learning_reservation_events`
--

CREATE TABLE `learning_reservation_events` (
  `idEvent` int(11) NOT NULL auto_increment,
  `idCourse` int(11) NOT NULL default '0',
  `idLaboratory` int(11) NOT NULL default '0',
  `idCategory` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` longtext,
  `date` date NOT NULL default '0000-00-00',
  `maxUser` int(11) NOT NULL default '0',
  `deadLine` date NOT NULL default '0000-00-00',
  `fromTime` time NOT NULL default '00:00:00',
  `toTime` time NOT NULL default '00:00:00',
  PRIMARY KEY  (`idEvent`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_reservation_events`
--





--
-- Dumping data for table `learning_reservation_laboratories`
--






--
-- Table structure for table `learning_reservation_subscribed`
--

CREATE TABLE `learning_reservation_subscribed` (
  `idstUser` int(11) NOT NULL default '0',
  `idEvent` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idstUser`,`idEvent`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_reservation_subscribed`
--






--
-- Table structure for table `learning_scorm_items`
--

CREATE TABLE `learning_scorm_items` (
  `idscorm_item` int(11) NOT NULL auto_increment,
  `idscorm_organization` int(11) NOT NULL default '0',
  `idscorm_parentitem` int(11) default NULL,
  `adlcp_prerequisites` varchar(200) default NULL,
  `adlcp_maxtimeallowed` varchar(24) default NULL,
  `adlcp_timelimitaction` varchar(24) default NULL,
  `adlcp_datafromlms` varchar(255) default NULL,
  `adlcp_masteryscore` varchar(200) default NULL,
  `item_identifier` varchar(255) default NULL,
  `identifierref` varchar(255) default NULL,
  `idscorm_resource` int(11) default NULL,
  `isvisible` set('true','false') default 'true',
  `parameters` varchar(100) default NULL,
  `title` varchar(100) NOT NULL default '',
  `nChild` int(11) NOT NULL default '0',
  `nDescendant` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idscorm_item`),
  UNIQUE KEY `idscorm_organization` (`idscorm_organization`,`item_identifier`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_scorm_items`
--






--
-- Table structure for table `learning_scorm_items_track`
--

CREATE TABLE `learning_scorm_items_track` (
  `idscorm_item_track` int(11) NOT NULL auto_increment,
  `idscorm_organization` int(11) NOT NULL default '0',
  `idscorm_item` int(11) default NULL,
  `idReference` int(11) NOT NULL default '0',
  `idUser` int(11) NOT NULL default '0',
  `idscorm_tracking` int(11) default NULL,
  `status` varchar(16) NOT NULL default 'not attempted',
  `nChild` int(11) NOT NULL default '0',
  `nChildCompleted` int(11) NOT NULL default '0',
  `nDescendant` int(11) NOT NULL default '0',
  `nDescendantCompleted` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idscorm_item_track`),
  KEY `idscorm_organization` (`idscorm_organization`),
  KEY `idscorm_item` (`idscorm_item`),
  KEY `idUser` (`idUser`),
  KEY `idscorm_tracking` (`idscorm_tracking`)
) TYPE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Join table 3 factor';

--
-- Dumping data for table `learning_scorm_items_track`
--






--
-- Table structure for table `learning_scorm_organizations`
--

CREATE TABLE `learning_scorm_organizations` (
  `idscorm_organization` int(11) NOT NULL auto_increment,
  `org_identifier` varchar(255) NOT NULL default '',
  `idscorm_package` int(11) NOT NULL default '0',
  `title` varchar(100) default NULL,
  `nChild` int(11) NOT NULL default '0',
  `nDescendant` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idscorm_organization`),
  UNIQUE KEY `idsco_package_unique` (`org_identifier`,`idscorm_package`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_scorm_organizations`
--






--
-- Table structure for table `learning_scorm_package`
--

CREATE TABLE `learning_scorm_package` (
  `idscorm_package` int(11) NOT NULL auto_increment,
  `idpackage` varchar(255) NOT NULL default '',
  `idProg` int(11) NOT NULL default '0',
  `path` varchar(255) NOT NULL default '',
  `defaultOrg` varchar(255) NOT NULL default '',
  `idUser` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idscorm_package`),
  KEY `idUser` (`idUser`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_scorm_package`
--






--
-- Table structure for table `learning_scorm_resources`
--

CREATE TABLE `learning_scorm_resources` (
  `idscorm_resource` int(11) NOT NULL auto_increment,
  `idsco` varchar(255) NOT NULL default '',
  `idscorm_package` int(11) NOT NULL default '0',
  `scormtype` set('sco','asset') default NULL,
  `href` varchar(255) default NULL,
  PRIMARY KEY  (`idscorm_resource`),
  UNIQUE KEY `idsco_package_unique` (`idsco`,`idscorm_package`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_scorm_resources`
--






--
-- Table structure for table `learning_scorm_tracking`
--

CREATE TABLE `learning_scorm_tracking` (
  `idscorm_tracking` int(11) NOT NULL auto_increment,
  `idUser` int(11) NOT NULL default '0',
  `idReference` int(11) NOT NULL default '0',
  `idscorm_item` int(11) NOT NULL default '0',
  `user_name` varchar(255) default NULL,
  `lesson_location` varchar(255) default NULL,
  `credit` varchar(24) default NULL,
  `lesson_status` varchar(24) default NULL,
  `entry` varchar(24) default NULL,
  `score_raw` int(10) unsigned default NULL,
  `score_max` int(10) unsigned default NULL,
  `score_min` int(10) unsigned default NULL,
  `total_time` varchar(15) default '0000:00:00.00',
  `lesson_mode` varchar(24) default NULL,
  `exit` varchar(24) default NULL,
  `session_time` varchar(15) default NULL,
  `suspend_data` blob,
  `launch_data` blob,
  `comments` blob,
  `comments_from_lms` blob,
  `xmldata` blob,
  PRIMARY KEY  (`idscorm_tracking`),
  UNIQUE KEY `Unique_tracking_usersco` (`idUser`,`idReference`,`idscorm_item`),
  KEY `idUser` (`idUser`),
  KEY `idscorm_resource` (`idReference`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_scorm_tracking`
--






--
-- Table structure for table `learning_setting`
--

CREATE TABLE `learning_setting` (
  `param_name` varchar(255) NOT NULL default '',
  `param_value` text NOT NULL,
  `value_type` varchar(255) NOT NULL default 'string',
  `max_size` int(3) NOT NULL default '255',
  `regroup` int(5) NOT NULL default '0',
  `sequence` int(5) NOT NULL default '0',
  `param_load` tinyint(1) NOT NULL default '1',
  `hide_in_modify` tinyint(1) NOT NULL default '0',
  `extra_info` text NOT NULL,
  PRIMARY KEY  (`param_name`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_setting`
--



INSERT INTO `learning_setting` VALUES 
('activeCommerce','on','enum',3,0,5,1,1,''),
('activeNews','block','sel_news',3,1,7,1,0,''),
('admin_mail','sample@localhost.com','string',255,0,2,1,0,''),
('course_block','off','enum',3,1,9,1,0,''),
('course_list_plan','on','enum',3,1,8,1,0,''),
('course_quota','50','string',255,0,5,1,0,''),
('defaultTemplate','standard','template',255,1,3,1,0,''),
('do_debug','on','enum',3,1,0,1,1,''),
('first_coursecatalogue_tab','category','first_coursecatalogue_tab',255,5,2,1,0,''),
('forum_as_table','off','enum',3,1,6,1,0,''),
('lms_version','3.0','string',255,0,0,1,1,''),
('max_pdp_answer','10','int',6,1,10,1,0,''),
('on_catalogue_empty','on','enum',3,1,10,1,0,''),
('pathchat','chat/','string',255,2,1,1,0,''),
('pathcourse','course/','string',255,2,2,1,0,''),
('pathforum','forum/','string',255,2,3,1,0,''),
('pathlesson','item/','string',255,2,4,1,0,''),
('pathmessage','message/','string',255,2,5,1,0,''),
('pathprj','project/','string',255,2,0,1,1,''),
('pathscorm','scorm/','string',255,2,7,1,0,''),
('pathsponsor','sponsor/','string',255,2,8,1,0,''),
('pathtest','test/','string',255,2,9,1,0,''),
('stop_concurrent_user','on','enum',3,3,1,1,0,''),
('tablist_coursecatalogue','a%3A6%3A%7Bs%3A4%3A%22time%22%3Bi%3A1%3Bs%3A8%3A%22category%22%3Bi%3A1%3Bs%3A3%3A%22all%22%3Bi%3A1%3Bs%3A9%3A%22mostscore%22%3Bi%3A1%3Bs%3A7%3A%22popular%22%3Bi%3A1%3Bs%3A6%3A%22recent%22%3Bi%3A1%3B%7D','tablist_coursecatalogue',255,5,1,1,0,''),
('tracking','on','enum',3,0,4,1,0,''),
('ttlSession','4000','int',5,0,3,1,0,''),
('url','http://localhost/docebo_35/doceboLms/','string',255,0,1,1,0,''),
('use_coursepath','0','menuvoice',1,7,1,1,0,'/coursepath/view'),
('use_course_catalogue','0','menuvoice',1,7,2,1,0,'/catalogue/view'),

('use_social_courselist','off','enum',3,0,0,1,0,''),

('visuItem','20','int',5,1,1,1,0,''),
('visuNewsHomePage','4','int',5,1,0,1,1,''),
('visu_course','25','int',5,1,2,1,0,''),
('no_answer_in_poll', 'off', 'enum', 3, 1, 11, 1, 0, ''),
('no_answer_in_test', 'off', 'enum', 3, 1, 12, 1, 0, ''),

('tablist_mycourses', 'status,code,name', 'tablist_mycourses', 255, 0, 6, 1, 0, '');




--
-- Table structure for table `learning_statuschangelog`
--

CREATE TABLE `learning_statuschangelog` (
  `idUser` int(11) NOT NULL default '0',
  `idCourse` int(11) NOT NULL default '0',
  `status_user` tinyint(1) NOT NULL default '0',
  `when_do` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`idUser`,`idCourse`,`status_user`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_statuschangelog`
--






--
-- Table structure for table `learning_sysforum`
--

CREATE TABLE `learning_sysforum` (
  `idMessage` int(11) NOT NULL auto_increment,
  `key1` varchar(255) NOT NULL default '',
  `key2` int(11) NOT NULL default '0',
  `key3` int(11) default NULL,
  `title` varchar(255) NOT NULL default '',
  `textof` text NOT NULL,
  `posted` datetime NOT NULL default '0000-00-00 00:00:00',
  `author` int(11) NOT NULL default '0',
  `attach` varchar(255) NOT NULL default '',
  `locked` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`idMessage`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_sysforum`
--






--
-- Table structure for table `learning_teacher_profile`
--

CREATE TABLE `learning_teacher_profile` (
  `id_user` int(11) NOT NULL default '0',
  `curriculum` text NOT NULL,
  `publications` text NOT NULL,
  PRIMARY KEY  (`id_user`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_teacher_profile`
--






--
-- Table structure for table `learning_test`
--

CREATE TABLE `learning_test` (
  `idTest` int(11) NOT NULL auto_increment,
  `author` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `point_type` tinyint(1) NOT NULL default '0',
  `point_required` double NOT NULL default '0',
  `display_type` tinyint(1) NOT NULL default '0',
  `order_type` tinyint(1) NOT NULL default '0',
  `shuffle_answer` tinyint(1) NOT NULL default '0',
  `question_random_number` int(4) NOT NULL default '0',
  `save_keep` tinyint(1) NOT NULL default '0',
  `mod_doanswer` tinyint(1) NOT NULL default '1',
  `can_travel` tinyint(1) NOT NULL default '1',
  `show_only_status` tinyint(1) NOT NULL default '0',
  `show_score` tinyint(1) NOT NULL default '1',
  `show_score_cat` tinyint(1) NOT NULL default '0',
  `show_doanswer` tinyint(1) NOT NULL default '0',
  `show_solution` tinyint(1) NOT NULL default '0',
  `time_dependent` tinyint(1) NOT NULL default '0',
  `time_assigned` int(6) NOT NULL default '0',
  `penality_test` tinyint(1) NOT NULL default '0',
  `penality_time_test` double NOT NULL default '0',
  `penality_quest` tinyint(1) NOT NULL default '0',
  `penality_time_quest` double NOT NULL default '0',
  `max_attempt` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idTest`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_test`
--






--
-- Table structure for table `learning_testquest`
--

CREATE TABLE `learning_testquest` (
  `idQuest` int(11) NOT NULL auto_increment,
  `idTest` int(11) NOT NULL default '0',
  `idCategory` int(11) NOT NULL default '0',
  `type_quest` varchar(255) NOT NULL default '',
  `title_quest` text NOT NULL,
  `difficult` int(1) NOT NULL default '3',
  `time_assigned` int(5) NOT NULL default '0',
  `sequence` int(5) NOT NULL default '0',
  `page` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idQuest`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_testquest`
--






--
-- Table structure for table `learning_testquest_extra`
--

CREATE TABLE `learning_testquest_extra` (
  `idQuest` int(11) NOT NULL default '0',
  `idAnswer` int(11) NOT NULL default '0',
  `extra_info` text NOT NULL,
  PRIMARY KEY  (`idQuest`,`idAnswer`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_testquest_extra`
--






--
-- Table structure for table `learning_testquestanswer`
--

CREATE TABLE `learning_testquestanswer` (
  `idAnswer` int(11) NOT NULL auto_increment,
  `idQuest` int(11) NOT NULL default '0',
  `sequence` int(11) NOT NULL default '0',
  `is_correct` int(11) NOT NULL default '0',
  `answer` text NOT NULL,
  `comment` text NOT NULL,
  `score_correct` double NOT NULL default '0',
  `score_incorrect` double NOT NULL default '0',
  PRIMARY KEY  (`idAnswer`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_testquestanswer`
--






--
-- Table structure for table `learning_testquestanswer_associate`
--

CREATE TABLE `learning_testquestanswer_associate` (
  `idAnswer` int(11) NOT NULL auto_increment,
  `idQuest` int(11) NOT NULL default '0',
  `answer` text NOT NULL,
  PRIMARY KEY  (`idAnswer`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_testquestanswer_associate`
--






--
-- Table structure for table `learning_testtrack`
--

CREATE TABLE `learning_testtrack` (
  `idTrack` int(11) NOT NULL auto_increment,
  `idUser` int(11) NOT NULL default '0',
  `idReference` int(11) NOT NULL default '0',
  `idTest` int(11) NOT NULL default '0',
  `date_attempt` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_attempt_mod` datetime default NULL,
  `date_end_attempt` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_page_seen` int(11) NOT NULL default '0',
  `last_page_saved` int(11) NOT NULL default '0',
  `number_of_save` int(11) NOT NULL default '0',
  `number_of_attempt` int(11) NOT NULL default '0',
  `score` double default NULL,
  `bonus_score` double NOT NULL default '0',
  `score_status` enum('valid','not_checked','not_passed','passed','not_complete','doing') NOT NULL default 'not_complete',
  `comment` text NOT NULL,
  PRIMARY KEY  (`idTrack`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_testtrack`
--


CREATE TABLE `learning_testtrack_times` (
  `idTrack` int(11) NOT NULL default '0',
  `idReference` int(11) NOT NULL default '0',
  `idTest` int(11) NOT NULL default '0',
  `date_attempt` datetime NOT NULL default '0000-00-00 00:00:00',
  `number_time` tinyint(4) NOT NULL default '0',
  `score` double NOT NULL default '0',
  `score_status` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`idTrack`,`number_time`,`idTest`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;



--
-- Table structure for table `learning_testtrack_answer`
--

CREATE TABLE `learning_testtrack_answer` (
  `idTrack` int(11) NOT NULL default '0',
  `idQuest` int(11) NOT NULL default '0',
  `idAnswer` int(11) NOT NULL default '0',
  `score_assigned` double NOT NULL default '0',
  `more_info` longtext NOT NULL,
  `manual_assigned` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`idTrack`,`idQuest`,`idAnswer`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_testtrack_answer`
--






--
-- Table structure for table `learning_testtrack_page`
--

CREATE TABLE `learning_testtrack_page` (
  `idTrack` int(11) NOT NULL default '0',
  `page` int(3) NOT NULL default '0',
  `display_from` datetime default NULL,
  `display_to` datetime default NULL,
  `accumulated` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idTrack`,`page`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_testtrack_page`
--






--
-- Table structure for table `learning_testtrack_quest`
--

CREATE TABLE `learning_testtrack_quest` (
  `idTrack` int(11) NOT NULL default '0',
  `idQuest` int(11) NOT NULL default '0',
  `page` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idTrack`,`idQuest`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_testtrack_quest`
--






--
-- Table structure for table `learning_trackingeneral`
--

CREATE TABLE `learning_trackingeneral` (
  `idTrack` int(11) NOT NULL auto_increment,
  `idEnter` int(11) NOT NULL default '0',
  `idUser` int(11) NOT NULL default '0',
  `idCourse` int(11) NOT NULL default '0',
  `session_id` varchar(255) NOT NULL default '',
  `function` varchar(250) NOT NULL default '',
  `type` varchar(255) NOT NULL default '',
  `timeof` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`idTrack`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_trackingeneral`
--






--
-- Table structure for table `learning_tracksession`
--

CREATE TABLE `learning_tracksession` (
  `idEnter` int(11) NOT NULL auto_increment,
  `idCourse` int(11) NOT NULL default '0',
  `idUser` int(11) NOT NULL default '0',
  `session_id` varchar(255) NOT NULL default '',
  `enterTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `numOp` int(5) NOT NULL default '0',
  `lastFunction` varchar(50) NOT NULL default '',
  `lastOp` varchar(5) NOT NULL default '',
  `lastTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip_address` varchar(40) NOT NULL default '',
  `active` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`idEnter`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_tracksession`
--






--
-- Table structure for table `learning_webpages`
--

CREATE TABLE `learning_webpages` (
  `idPages` int(11) NOT NULL auto_increment,
  `title` varchar(200) NOT NULL default '',
  `description` text NOT NULL,
  `language` varchar(255) NOT NULL default '',
  `sequence` int(5) NOT NULL default '0',
  `publish` tinyint(1) NOT NULL default '0',
  `in_home` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`idPages`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_webpages`
--






--
-- Table structure for table `learning_wiki_course`
--

CREATE TABLE `learning_wiki_course` (
  `course_id` int(11) NOT NULL default '0',
  `wiki_id` int(11) NOT NULL default '0',
  `is_owner` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`course_id`,`wiki_id`)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `learning_wiki_course`
--





