◆ prepare()
◆ step_1()
ilSkillDBUpdateSteps::step_1 |
( |
| ) |
|
Definition at line 30 of file class.ilSkillDBUpdateSteps.php.
30 : void
31 {
32 if ($this->db->sequenceExists('skl_self_eval')) {
33 $this->db->dropSequence('skl_self_eval');
34 }
35
36 if ($this->db->tableExists('skl_self_eval')) {
37 $this->db->dropTable('skl_self_eval');
38 }
39
40 if ($this->db->tableExists('skl_self_eval_level')) {
41 $this->db->dropTable('skl_self_eval_level');
42 }
43 }
◆ step_10()
ilSkillDBUpdateSteps::step_10 |
( |
| ) |
|
Definition at line 156 of file class.ilSkillDBUpdateSteps.php.
156 : void
157 {
158 if (!$this->db->tableColumnExists("skl_profile", "image_id")) {
159 $this->db->addTableColumn("skl_profile", "image_id", array(
160 "type" => "text",
161 "notnull" => true,
162 "length" => 4000
163 ));
164 }
165 }
◆ step_11()
ilSkillDBUpdateSteps::step_11 |
( |
| ) |
|
Definition at line 167 of file class.ilSkillDBUpdateSteps.php.
167 : void
168 {
169 if (!$this->db->tableExists("skl_profile_completion")) {
170 $fields = [
171 "profile_id" => [
172 "type" => "integer",
173 "length" => 4,
175 ],
176 "user_id" => [
177 "type" => "integer",
178 "length" => 4,
180 ],
181 "date" => [
182 "type" => "timestamp",
184 ],
185 "fulfilled" => [
186 "type" => "integer",
187 "length" => 1,
189 ]
190 ];
191 $this->db->createTable("skl_profile_completion", $fields);
192 $this->db->addPrimaryKey("skl_profile_completion", ["profile_id", "user_id", "date"]);
193 }
194 }
References true.
◆ step_2()
ilSkillDBUpdateSteps::step_2 |
( |
| ) |
|
Definition at line 45 of file class.ilSkillDBUpdateSteps.php.
45 : void
46 {
47 if (!$this->db->tableColumnExists('skl_user_skill_level', 'trigger_user_id')) {
48 $this->db->addTableColumn(
49 'skl_user_skill_level',
50 'trigger_user_id',
51 array(
52 'type' => 'text',
53 'notnull' => true,
54 'length' => 20,
55 'default' => "-"
56 )
57 );
58 }
59 }
◆ step_3()
ilSkillDBUpdateSteps::step_3 |
( |
| ) |
|
Definition at line 61 of file class.ilSkillDBUpdateSteps.php.
61 : void
62 {
63 if (!$this->db->tableColumnExists('skl_user_has_level', 'trigger_user_id')) {
64 $this->db->addTableColumn(
65 'skl_user_has_level',
66 'trigger_user_id',
67 array(
68 'type' => 'text',
69 'notnull' => true,
70 'length' => 20,
71 'default' => "-"
72 )
73 );
74 }
75 }
◆ step_4()
ilSkillDBUpdateSteps::step_4 |
( |
| ) |
|
◆ step_5()
ilSkillDBUpdateSteps::step_5 |
( |
| ) |
|
◆ step_6()
ilSkillDBUpdateSteps::step_6 |
( |
| ) |
|
Definition at line 87 of file class.ilSkillDBUpdateSteps.php.
87 : void
88 {
89 $this->db->update(
90 "object_data",
91 [
92 "title" => ["text", "Default"],
93 "description" => ["text", ""]
94 ],
95 [
96 "type" => ["text", "skee"],
97 "title" => ["text", "Skill Tree"]
98 ]
99 );
100 }
◆ step_7()
ilSkillDBUpdateSteps::step_7 |
( |
| ) |
|
Definition at line 102 of file class.ilSkillDBUpdateSteps.php.
102 : void
103 {
104 $set = $this->db->queryF(
105 "SELECT * FROM object_data " .
106 " WHERE type = %s AND title = %s",
107 ["string", "string"],
108 ["skee", "Default"]
109 );
110 $rec = $this->db->fetchAssoc($set);
111
112 $this->db->update(
113 "skl_tree",
114 [
115 "skl_tree_id" => ["integer", $rec["obj_id"]]
116 ],
117 [
118 "skl_tree_id" => ["integer", 1]
119 ]
120 );
121 }
◆ step_8()
ilSkillDBUpdateSteps::step_8 |
( |
| ) |
|
Definition at line 123 of file class.ilSkillDBUpdateSteps.php.
123 : void
124 {
125 if (!$this->db->tableColumnExists("skl_profile", "skill_tree_id")) {
126 $this->db->addTableColumn("skl_profile", "skill_tree_id", array(
127 "type" => "integer",
128 "notnull" => true,
129 "default" => 0,
130 "length" => 4
131 ));
132 }
133 }
◆ step_9()
ilSkillDBUpdateSteps::step_9 |
( |
| ) |
|
Definition at line 135 of file class.ilSkillDBUpdateSteps.php.
135 : void
136 {
137 $set = $this->db->queryF(
138 "SELECT * FROM object_data " .
139 " WHERE type = %s AND title = %s",
140 ["string", "string"],
141 ["skee", "Default"]
142 );
143 $rec = $this->db->fetchAssoc($set);
144
145 $this->db->update(
146 "skl_profile",
147 [
148 "skill_tree_id" => ["integer", $rec["obj_id"]]
149 ],
150 [
151 "skill_tree_id" => ["integer", 0]
152 ]
153 );
154 }
◆ $db
The documentation for this class was generated from the following file: