elearning/ext_tables.sql at main · AisteaTypo3/elearning · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
CREATE TABLE tx_elearning_domain_model_course (
  uid int(11) unsigned NOT NULL auto_increment,
  pid int(11) unsigned NOT NULL DEFAULT '0',
  sys_language_uid int(11) NOT NULL DEFAULT '0',
  l10n_parent int(11) unsigned NOT NULL DEFAULT '0',
  l10n_diffsource mediumblob,
  title varchar(255) NOT NULL DEFAULT '',
  slug varchar(2048) NOT NULL DEFAULT '',
  teaser text,
  description text,
  authors varchar(255) NOT NULL DEFAULT '',
  image int(11) unsigned NOT NULL DEFAULT '0',
  published tinyint(1) unsigned NOT NULL DEFAULT '0',
  sorting int(11) NOT NULL DEFAULT '0',
  tstamp int(11) unsigned NOT NULL DEFAULT '0',
  crdate int(11) unsigned NOT NULL DEFAULT '0',
  cruser_id int(11) unsigned NOT NULL DEFAULT '0',
  deleted tinyint(1) unsigned NOT NULL DEFAULT '0',
  hidden tinyint(1) unsigned NOT NULL DEFAULT '0',
  starttime int(11) unsigned NOT NULL DEFAULT '0',
  endtime int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (uid),
  KEY parent (pid)
);

CREATE TABLE tx_elearning_domain_model_lesson (
  uid int(11) unsigned NOT NULL auto_increment,
  pid int(11) unsigned NOT NULL DEFAULT '0',
  sys_language_uid int(11) NOT NULL DEFAULT '0',
  l10n_parent int(11) unsigned NOT NULL DEFAULT '0',
  l10n_diffsource mediumblob,
  course int(11) unsigned NOT NULL DEFAULT '0',
  title varchar(255) NOT NULL DEFAULT '',
  slug varchar(2048) NOT NULL DEFAULT '',
  content text,
  type varchar(20) NOT NULL DEFAULT 'content',
  video_url varchar(2048) NOT NULL DEFAULT '',
  file int(11) unsigned NOT NULL DEFAULT '0',
  link_url varchar(2048) NOT NULL DEFAULT '',
  duration_minutes int(11) NOT NULL DEFAULT '0',
  published tinyint(1) unsigned NOT NULL DEFAULT '0',
  sorting int(11) NOT NULL DEFAULT '0',
  tstamp int(11) unsigned NOT NULL DEFAULT '0',
  crdate int(11) unsigned NOT NULL DEFAULT '0',
  cruser_id int(11) unsigned NOT NULL DEFAULT '0',
  deleted tinyint(1) unsigned NOT NULL DEFAULT '0',
  hidden tinyint(1) unsigned NOT NULL DEFAULT '0',
  starttime int(11) unsigned NOT NULL DEFAULT '0',
  endtime int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (uid),
  KEY parent (pid)
);

CREATE TABLE tx_elearning_domain_model_question (
  uid int(11) unsigned NOT NULL auto_increment,
  pid int(11) unsigned NOT NULL DEFAULT '0',
  lesson int(11) unsigned NOT NULL DEFAULT '0',
  question_text text,
  sorting int(11) NOT NULL DEFAULT '0',
  tstamp int(11) unsigned NOT NULL DEFAULT '0',
  crdate int(11) unsigned NOT NULL DEFAULT '0',
  cruser_id int(11) unsigned NOT NULL DEFAULT '0',
  deleted tinyint(1) unsigned NOT NULL DEFAULT '0',
  hidden tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (uid),
  KEY parent (pid)
);

CREATE TABLE tx_elearning_domain_model_answer (
  uid int(11) unsigned NOT NULL auto_increment,
  pid int(11) unsigned NOT NULL DEFAULT '0',
  question int(11) unsigned NOT NULL DEFAULT '0',
  title varchar(255) NOT NULL DEFAULT '',
  is_correct tinyint(1) unsigned NOT NULL DEFAULT '0',
  sorting int(11) NOT NULL DEFAULT '0',
  tstamp int(11) unsigned NOT NULL DEFAULT '0',
  crdate int(11) unsigned NOT NULL DEFAULT '0',
  cruser_id int(11) unsigned NOT NULL DEFAULT '0',
  deleted tinyint(1) unsigned NOT NULL DEFAULT '0',
  hidden tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (uid),
  KEY parent (pid)
);

CREATE TABLE tx_elearning_domain_model_progress (
  uid int(11) unsigned NOT NULL auto_increment,
  pid int(11) unsigned NOT NULL DEFAULT '0',
  fe_user int(11) unsigned NOT NULL DEFAULT '0',
  lesson int(11) unsigned NOT NULL DEFAULT '0',
  completed tinyint(1) unsigned NOT NULL DEFAULT '0',
  completed_at int(11) unsigned NOT NULL DEFAULT '0',
  quiz_passed tinyint(1) unsigned NOT NULL DEFAULT '0',
  quiz_passed_at int(11) unsigned NOT NULL DEFAULT '0',
  last_quiz_failed_at int(11) unsigned NOT NULL DEFAULT '0',
  last_visited_at int(11) unsigned NOT NULL DEFAULT '0',
  tstamp int(11) unsigned NOT NULL DEFAULT '0',
  crdate int(11) unsigned NOT NULL DEFAULT '0',
  cruser_id int(11) unsigned NOT NULL DEFAULT '0',
  deleted tinyint(1) unsigned NOT NULL DEFAULT '0',
  hidden tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (uid),
  UNIQUE KEY user_lesson (fe_user, lesson),
  KEY parent (pid)
);

CREATE TABLE tx_elearning_course_favorite (
  uid int(11) unsigned NOT NULL auto_increment,
  pid int(11) unsigned NOT NULL DEFAULT '0',
  fe_user int(11) unsigned NOT NULL DEFAULT '0',
  course int(11) unsigned NOT NULL DEFAULT '0',
  tstamp int(11) unsigned NOT NULL DEFAULT '0',
  crdate int(11) unsigned NOT NULL DEFAULT '0',
  deleted tinyint(1) unsigned NOT NULL DEFAULT '0',
  hidden tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (uid),
  UNIQUE KEY user_course (fe_user, course),
  KEY parent (pid)
);

CREATE TABLE tx_elearning_domain_model_course_rating (
  uid int(11) unsigned NOT NULL auto_increment,
  pid int(11) unsigned NOT NULL DEFAULT '0',
  fe_user int(11) unsigned NOT NULL DEFAULT '0',
  course int(11) unsigned NOT NULL DEFAULT '0',
  rating tinyint(1) unsigned NOT NULL DEFAULT '0',
  tstamp int(11) unsigned NOT NULL DEFAULT '0',
  crdate int(11) unsigned NOT NULL DEFAULT '0',
  cruser_id int(11) unsigned NOT NULL DEFAULT '0',
  deleted tinyint(1) unsigned NOT NULL DEFAULT '0',
  hidden tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (uid),
  UNIQUE KEY user_course (fe_user, course),
  KEY parent (pid)
);