dokeos_stats.sql 5.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176
  1. -- MySQL dump
  2. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  3. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  4. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  5. /*!40101 SET NAMES utf8 */;
  6. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  7. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  8. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  9. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  10. CREATE TABLE track_c_browsers (
  11. id int NOT NULL auto_increment,
  12. browser varchar(255) NOT NULL default '',
  13. counter int NOT NULL default 0,
  14. PRIMARY KEY (id)
  15. );
  16. CREATE TABLE track_c_countries (
  17. id int NOT NULL auto_increment,
  18. code varchar(40) NOT NULL default '',
  19. country varchar(50) NOT NULL default '',
  20. counter int NOT NULL default 0,
  21. PRIMARY KEY (id)
  22. );
  23. CREATE TABLE track_c_os (
  24. id int NOT NULL auto_increment,
  25. os varchar(255) NOT NULL default '',
  26. counter int NOT NULL default 0,
  27. PRIMARY KEY (id)
  28. );
  29. CREATE TABLE track_c_providers (
  30. id int NOT NULL auto_increment,
  31. provider varchar(255) NOT NULL default '',
  32. counter int NOT NULL default 0,
  33. PRIMARY KEY (id)
  34. );
  35. CREATE TABLE track_c_referers (
  36. id int NOT NULL auto_increment,
  37. referer varchar(255) NOT NULL default '',
  38. counter int NOT NULL default 0,
  39. PRIMARY KEY (id)
  40. );
  41. CREATE TABLE track_e_access (
  42. access_id int NOT NULL auto_increment,
  43. access_user_id int unsigned default NULL,
  44. access_date datetime NOT NULL default '0000-00-00 00:00:00',
  45. access_cours_code varchar(40) NOT NULL default '',
  46. access_tool varchar(30) default NULL,
  47. PRIMARY KEY (access_id),
  48. KEY access_user_id (access_user_id),
  49. KEY access_cours_code (access_cours_code)
  50. );
  51. CREATE TABLE track_e_lastaccess (
  52. access_id bigint NOT NULL auto_increment,
  53. access_user_id int unsigned default NULL,
  54. access_date datetime NOT NULL default '0000-00-00 00:00:00',
  55. access_cours_code varchar(40) NOT NULL default ,
  56. access_tool varchar(30) default NULL,
  57. access_session_id int unsigned default NULL,
  58. PRIMARY KEY (access_id),
  59. KEY access_user_id (access_user_id),
  60. KEY access_cours_code (access_cours_code)
  61. );
  62. CREATE TABLE track_e_default (
  63. default_id int NOT NULL auto_increment,
  64. default_user_id int unsigned NOT NULL default 0,
  65. default_cours_code varchar(40) NOT NULL default '',
  66. default_date datetime NOT NULL default '0000-00-00 00:00:00',
  67. default_event_type varchar(20) NOT NULL default '',
  68. default_value_type varchar(20) NOT NULL default '',
  69. default_value tinytext NOT NULL,
  70. PRIMARY KEY (default_id)
  71. );
  72. CREATE TABLE track_e_downloads (
  73. down_id int NOT NULL auto_increment,
  74. down_user_id int unsigned default NULL,
  75. down_date datetime NOT NULL default '0000-00-00 00:00:00',
  76. down_cours_id varchar(20) NOT NULL default '',
  77. down_doc_path varchar(255) NOT NULL default '',
  78. PRIMARY KEY (down_id)
  79. );
  80. CREATE TABLE track_e_exercices (
  81. exe_id int NOT NULL auto_increment,
  82. exe_user_id int unsigned default NULL,
  83. exe_date datetime NOT NULL default '0000-00-00 00:00:00',
  84. exe_cours_id varchar(40) NOT NULL default '',
  85. exe_exo_id mediumint unsigned NOT NULL default 0,
  86. exe_result smallint NOT NULL default 0,
  87. exe_weighting smallint NOT NULL default 0,
  88. PRIMARY KEY (exe_id)
  89. );
  90. CREATE TABLE track_e_attempt (
  91. exe_id int default NULL,
  92. user_id int NOT NULL default 0,
  93. question_id int NOT NULL default 0,
  94. answer text NOT NULL,
  95. teacher_comment text NOT NULL,
  96. marks int NOT NULL default 0,
  97. course_code varchar(40) NOT NULL default '',
  98. position int default 0
  99. );
  100. CREATE TABLE track_e_hotpotatoes (
  101. exe_name VARCHAR( 255 ) NOT NULL ,
  102. exe_user_id int unsigned DEFAULT NULL ,
  103. exe_date DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL ,
  104. exe_cours_id varchar(40) NOT NULL ,
  105. exe_result smallint default 0 NOT NULL ,
  106. exe_weighting smallint default 0 NOT NULL
  107. );
  108. CREATE TABLE track_e_links (
  109. links_id int NOT NULL auto_increment,
  110. links_user_id int unsigned default NULL,
  111. links_date datetime NOT NULL default '0000-00-00 00:00:00',
  112. links_cours_id varchar(40) NOT NULL default ,
  113. links_link_id int NOT NULL default 0,
  114. PRIMARY KEY (links_id)
  115. );
  116. CREATE TABLE track_e_login (
  117. login_id int NOT NULL auto_increment,
  118. login_user_id int unsigned NOT NULL default 0,
  119. login_date datetime NOT NULL default '0000-00-00 00:00:00',
  120. login_ip varchar(39) NOT NULL default '',
  121. logout_date datetime NULL default NULL,
  122. PRIMARY KEY (login_id),
  123. KEY login_user_id (login_user_id)
  124. );
  125. CREATE TABLE track_e_online (
  126. login_id int NOT NULL auto_increment,
  127. login_user_id int unsigned NOT NULL default 0,
  128. login_date datetime NOT NULL default '0000-00-00 00:00:00',
  129. login_ip varchar(39) NOT NULL default '',
  130. course varchar(40) default NULL,
  131. PRIMARY KEY (login_id),
  132. KEY login_user_id (login_user_id)
  133. );
  134. CREATE TABLE track_e_open (
  135. open_id int NOT NULL auto_increment,
  136. open_remote_host tinytext NOT NULL,
  137. open_agent tinytext NOT NULL,
  138. open_referer tinytext NOT NULL,
  139. open_date datetime NOT NULL default '0000-00-00 00:00:00',
  140. PRIMARY KEY (open_id)
  141. );
  142. CREATE TABLE track_e_uploads (
  143. upload_id int NOT NULL auto_increment,
  144. upload_user_id int unsigned default NULL,
  145. upload_date datetime NOT NULL default '0000-00-00 00:00:00',
  146. upload_cours_id varchar(20) NOT NULL default '',
  147. upload_work_id int NOT NULL default 0,
  148. PRIMARY KEY (upload_id)
  149. );
  150. CREATE TABLE track_e_course_access (
  151. course_access_id int NOT NULL auto_increment,
  152. course_code varchar(40) NOT NULL,
  153. user_id int NOT NULL,
  154. login_course_date datetime NOT NULL default '0000-00-00 00:00:00',
  155. logout_course_date datetime default NULL,
  156. counter int NOT NULL,
  157. PRIMARY KEY (course_access_id)
  158. );