123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232 |
- -- MySQL dump
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- /*!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' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- CREATE TABLE track_c_browsers (
- id int NOT NULL auto_increment,
- browser varchar(255) NOT NULL default '',
- counter int NOT NULL default 0,
- PRIMARY KEY (id)
- );
- CREATE TABLE track_c_countries (
- id int NOT NULL auto_increment,
- code varchar(40) NOT NULL default '',
- country varchar(50) NOT NULL default '',
- counter int NOT NULL default 0,
- PRIMARY KEY (id)
- );
- CREATE TABLE track_c_os (
- id int NOT NULL auto_increment,
- os varchar(255) NOT NULL default '',
- counter int NOT NULL default 0,
- PRIMARY KEY (id)
- );
- CREATE TABLE track_c_providers (
- id int NOT NULL auto_increment,
- provider varchar(255) NOT NULL default '',
- counter int NOT NULL default 0,
- PRIMARY KEY (id)
- );
- CREATE TABLE track_c_referers (
- id int NOT NULL auto_increment,
- referer varchar(255) NOT NULL default '',
- counter int NOT NULL default 0,
- PRIMARY KEY (id)
- );
- CREATE TABLE track_e_access (
- access_id int NOT NULL auto_increment,
- access_user_id int unsigned default NULL,
- access_date datetime NOT NULL default '0000-00-00 00:00:00',
- access_cours_code varchar(40) NOT NULL default '',
- access_tool varchar(30) default NULL,
- PRIMARY KEY (access_id),
- KEY access_user_id (access_user_id),
- KEY access_cours_code (access_cours_code)
- );
- CREATE TABLE track_e_lastaccess (
- access_id bigint NOT NULL auto_increment,
- access_user_id int unsigned default NULL,
- access_date datetime NOT NULL default '0000-00-00 00:00:00',
- access_cours_code varchar(40) NOT NULL,
- access_tool varchar(30) default NULL,
- access_session_id int unsigned default NULL,
- PRIMARY KEY (access_id),
- KEY access_user_id (access_user_id),
- KEY access_cours_code (access_cours_code),
- KEY access_session_id (access_session_id)
- );
- CREATE TABLE track_e_default (
- default_id int NOT NULL auto_increment,
- default_user_id int unsigned NOT NULL default 0,
- default_cours_code varchar(40) NOT NULL default '',
- default_date datetime NOT NULL default '0000-00-00 00:00:00',
- default_event_type varchar(20) NOT NULL default '',
- default_value_type varchar(20) NOT NULL default '',
- default_value tinytext NOT NULL,
- PRIMARY KEY (default_id)
- );
- CREATE TABLE track_e_downloads (
- down_id int NOT NULL auto_increment,
- down_user_id int unsigned default NULL,
- down_date datetime NOT NULL default '0000-00-00 00:00:00',
- down_cours_id varchar(40) NOT NULL default '',
- down_doc_path varchar(255) NOT NULL default '',
- PRIMARY KEY (down_id),
- KEY down_user_id (down_user_id),
- KEY down_cours_id (down_cours_id)
- );
- CREATE TABLE track_e_exercices (
- exe_id int NOT NULL auto_increment,
- exe_user_id int unsigned default NULL,
- exe_date datetime NOT NULL default '0000-00-00 00:00:00',
- exe_cours_id varchar(40) NOT NULL default '',
- exe_exo_id mediumint unsigned NOT NULL default 0,
- exe_result float(6,2) NOT NULL default 0,
- exe_weighting float(6,2) NOT NULL default 0,
- PRIMARY KEY (exe_id),
- KEY exe_user_id (exe_user_id),
- KEY exe_cours_id (exe_cours_id)
- );
- ALTER TABLE track_e_exercices ADD status varchar(20) NOT NULL default '';
- ALTER TABLE track_e_exercices ADD data_tracking text NOT NULL default '';
- ALTER TABLE track_e_exercices ADD start_date datetime NOT NULL default '0000-00-00 00:00:00';
- ALTER TABLE track_e_exercices ADD steps_counter SMALLINT UNSIGNED NOT NULL default 0;
- ALTER TABLE track_e_exercices ADD session_id SMALLINT UNSIGNED NOT NULL default 0;
- ALTER TABLE track_e_exercices ADD INDEX ( session_id ) ;
- ALTER TABLE track_e_exercices ADD orig_lp_id int NOT NULL default 0;
- ALTER TABLE track_e_exercices ADD orig_lp_item_id int NOT NULL default 0;
- ALTER TABLE track_e_exercices ADD exe_duration int UNSIGNED NOT NULL default 0;
-
- CREATE TABLE track_e_attempt (
- exe_id int default NULL,
- user_id int NOT NULL default 0,
- question_id int NOT NULL default 0,
- answer text NOT NULL,
- teacher_comment text NOT NULL,
- marks float(6,2) NOT NULL default 0,
- course_code varchar(40) NOT NULL default '',
- position int default 0,
- tms datetime NOT NULL default '0000-00-00 00:00:00'
- );
- ALTER TABLE track_e_attempt ADD INDEX (exe_id);
- ALTER TABLE track_e_attempt ADD INDEX (user_id);
- ALTER TABLE track_e_attempt ADD INDEX (question_id);
- CREATE TABLE track_e_attempt_recording (
- exe_id int unsigned NOT NULL,
- question_id int unsigned NOT NULL,
- marks int NOT NULL,
- insert_date datetime NOT NULL default '0000-00-00 00:00:00',
- author int unsigned NOT NULL,
- teacher_comment text NOT NULL);
- ALTER TABLE track_e_attempt_recording ADD INDEX (exe_id);
- CREATE TABLE track_e_hotpotatoes (
- exe_name VARCHAR( 255 ) NOT NULL ,
- exe_user_id int unsigned DEFAULT NULL ,
- exe_date DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL ,
- exe_cours_id varchar(40) NOT NULL ,
- exe_result smallint default 0 NOT NULL ,
- exe_weighting smallint default 0 NOT NULL,
- KEY exe_user_id (exe_user_id),
- KEY exe_cours_id (exe_cours_id)
- );
- CREATE TABLE track_e_links (
- links_id int NOT NULL auto_increment,
- links_user_id int unsigned default NULL,
- links_date datetime NOT NULL default '0000-00-00 00:00:00',
- links_cours_id varchar(40) NOT NULL default '' ,
- links_link_id int NOT NULL default 0,
- PRIMARY KEY (links_id),
- KEY links_cours_id (links_cours_id),
- KEY links_user_id (links_user_id)
- );
- CREATE TABLE track_e_login (
- login_id int NOT NULL auto_increment,
- login_user_id int unsigned NOT NULL default 0,
- login_date datetime NOT NULL default '0000-00-00 00:00:00',
- login_ip varchar(39) NOT NULL default '',
- logout_date datetime NULL default NULL,
- PRIMARY KEY (login_id),
- KEY login_user_id (login_user_id)
- );
- CREATE TABLE track_e_online (
- login_id int NOT NULL auto_increment,
- login_user_id int unsigned NOT NULL default 0,
- login_date datetime NOT NULL default '0000-00-00 00:00:00',
- login_ip varchar(39) NOT NULL default '',
- course varchar(40) default NULL,
- PRIMARY KEY (login_id),
- KEY login_user_id (login_user_id)
- );
- CREATE TABLE track_e_open (
- open_id int NOT NULL auto_increment,
- open_remote_host tinytext NOT NULL,
- open_agent tinytext NOT NULL,
- open_referer tinytext NOT NULL,
- open_date datetime NOT NULL default '0000-00-00 00:00:00',
- PRIMARY KEY (open_id)
- );
- CREATE TABLE track_e_uploads (
- upload_id int NOT NULL auto_increment,
- upload_user_id int unsigned default NULL,
- upload_date datetime NOT NULL default '0000-00-00 00:00:00',
- upload_cours_id varchar(40) NOT NULL default '',
- upload_work_id int NOT NULL default 0,
- PRIMARY KEY (upload_id),
- KEY upload_user_id (upload_user_id),
- KEY upload_cours_id (upload_cours_id)
- );
- CREATE TABLE track_e_course_access (
- course_access_id int NOT NULL auto_increment,
- course_code varchar(40) NOT NULL,
- user_id int NOT NULL,
- login_course_date datetime NOT NULL default '0000-00-00 00:00:00',
- logout_course_date datetime default NULL,
- counter int NOT NULL,
- PRIMARY KEY (course_access_id)
- );
- CREATE TABLE track_e_hotspot (
- hotspot_id int(11) NOT NULL auto_increment,
- hotspot_user_id int(11) NOT NULL,
- hotspot_course_code varchar(50) NOT NULL,
- hotspot_exe_id int(11) NOT NULL,
- hotspot_question_id int(11) NOT NULL,
- hotspot_answer_id int(11) NOT NULL,
- hotspot_correct tinyint(3) unsigned NOT NULL,
- hotspot_coordinate text NOT NULL,
- PRIMARY KEY (hotspot_id),
- KEY hotspot_course_code (hotspot_course_code),
- KEY hotspot_user_id (hotspot_user_id),
- KEY hotspot_exe_id (hotspot_exe_id),
- KEY hotspot_question_id (hotspot_question_id)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- ALTER TABLE track_e_course_access ADD INDEX (user_id);
- ALTER TABLE track_e_course_access ADD INDEX (login_course_date);
- ALTER TABLE track_e_course_access ADD INDEX (course_code);
|