ILIAS  trunk Revision v11.0_alpha-3011-gc6b235a2e85
ilCourseDBUpdateSteps Class Reference
+ Inheritance diagram for ilCourseDBUpdateSteps:
+ Collaboration diagram for ilCourseDBUpdateSteps:

Public Member Functions

 prepare (ilDBInterface $db)
 
 step_1 ()
 
- Public Member Functions inherited from ilDatabaseUpdateSteps
 prepare (\ilDBInterface $db)
 Prepare the execution of the steps. More...
 

Protected Attributes

ilDBInterface $db
 

Detailed Description

Definition at line 21 of file ilCourseDBUpdateSteps.php.

Member Function Documentation

◆ prepare()

ilCourseDBUpdateSteps::prepare ( ilDBInterface  $db)

Definition at line 25 of file ilCourseDBUpdateSteps.php.

25 : void
26 {
27 $this->db = $db;
28 }

References $db.

◆ step_1()

ilCourseDBUpdateSteps::step_1 ( )

Definition at line 30 of file ilCourseDBUpdateSteps.php.

30 : void
31 {
33
34
35 if ($ilDB->tableColumnExists('crs_archives', 'archive_date')) {
36 $ilDB->modifyTableColumn('crs_archives', 'archive_date', [
37 'type' => 'integer',
38 'length' => 8,
39 'notnull' => false,
40 'default' => null
41 ]);
42 }
43 if ($ilDB->tableColumnExists('crs_items', 'timing_start')) {
44 $ilDB->modifyTableColumn('crs_items', 'timing_start', [
45 'type' => 'integer',
46 'length' => 8,
47 'notnull' => true,
48 'default' => 0
49 ]);
50 }
51 if ($ilDB->tableColumnExists('crs_items', 'timing_end')) {
52 $ilDB->modifyTableColumn('crs_items', 'timing_end', [
53 'type' => 'integer',
54 'length' => 8,
55 'notnull' => true,
56 'default' => 0
57 ]);
58 }
59 if ($ilDB->tableColumnExists('crs_items', 'suggestion_start')) {
60 $ilDB->modifyTableColumn('crs_items', 'suggestion_start', [
61 'type' => 'integer',
62 'length' => 8,
63 'notnull' => true,
64 'default' => 0
65 ]);
66 }
67 if ($ilDB->tableColumnExists('crs_items', 'suggestion_end')) {
68 $ilDB->modifyTableColumn('crs_items', 'suggestion_end', [
69 'type' => 'integer',
70 'length' => 8,
71 'notnull' => true,
72 'default' => 0
73 ]);
74 }
75 if ($ilDB->tableColumnExists('crs_items', 'suggestion_start_rel')) {
76 $ilDB->modifyTableColumn('crs_items', 'suggestion_start_rel', [
77 'type' => 'integer',
78 'length' => 8,
79 'notnull' => false,
80 'default' => 0
81 ]);
82 }
83 if ($ilDB->tableColumnExists('crs_items', 'suggestion_end_rel')) {
84 $ilDB->modifyTableColumn('crs_items', 'suggestion_end_rel', [
85 'type' => 'integer',
86 'length' => 8,
87 'notnull' => false,
88 'default' => 0
89 ]);
90 }
91 if ($ilDB->tableColumnExists('crs_lm_history', 'last_access')) {
92 $ilDB->modifyTableColumn('crs_lm_history', 'last_access', [
93 'type' => 'integer',
94 'length' => 8,
95 'notnull' => true,
96 'default' => 0
97 ]);
98 }
99 if ($ilDB->tableColumnExists('crs_settings', 'activation_start')) {
100 $ilDB->modifyTableColumn('crs_settings', 'activation_start', [
101 'type' => 'integer',
102 'length' => 8,
103 'notnull' => false,
104 'default' => null
105 ]);
106 }
107 if ($ilDB->tableColumnExists('crs_settings', 'activation_end')) {
108 $ilDB->modifyTableColumn('crs_settings', 'activation_end', [
109 'type' => 'integer',
110 'length' => 8,
111 'notnull' => false,
112 'default' => null
113 ]);
114 }
115 if ($ilDB->tableColumnExists('crs_settings', 'sub_start')) {
116 $ilDB->modifyTableColumn('crs_settings', 'sub_start', [
117 'type' => 'integer',
118 'length' => 8,
119 'notnull' => false,
120 'default' => null
121 ]);
122 }
123 if ($ilDB->tableColumnExists('crs_settings', 'sub_end')) {
124 $ilDB->modifyTableColumn('crs_settings', 'sub_end', [
125 'type' => 'integer',
126 'length' => 8,
127 'notnull' => false,
128 'default' => null
129 ]);
130 }
131 if ($ilDB->tableColumnExists('crs_settings', 'archive_start')) {
132 $ilDB->modifyTableColumn('crs_settings', 'archive_start', [
133 'type' => 'integer',
134 'length' => 8,
135 'notnull' => false,
136 'default' => null
137 ]);
138 }
139 if ($ilDB->tableColumnExists('crs_settings', 'archive_end')) {
140 $ilDB->modifyTableColumn('crs_settings', 'archive_end', [
141 'type' => 'integer',
142 'length' => 8,
143 'notnull' => false,
144 'default' => null
145 ]);
146 }
147 if ($ilDB->tableColumnExists('crs_settings', 'crs_start')) {
148 $ilDB->modifyTableColumn('crs_settings', 'crs_start', [
149 'type' => 'integer',
150 'length' => 8,
151 'notnull' => false,
152 'default' => null
153 ]);
154 }
155 if ($ilDB->tableColumnExists('crs_settings', 'crs_end')) {
156 $ilDB->modifyTableColumn('crs_settings', 'crs_end', [
157 'type' => 'integer',
158 'length' => 8,
159 'notnull' => false,
160 'default' => null
161 ]);
162 }
163 if ($ilDB->tableColumnExists('crs_settings', 'leave_end')) {
164 $ilDB->modifyTableColumn('crs_settings', 'leave_end', [
165 'type' => 'integer',
166 'length' => 8,
167 'notnull' => false,
168 'default' => null
169 ]);
170 }
171 if ($ilDB->tableColumnExists('crs_timings_planed', 'planed_start')) {
172 $ilDB->modifyTableColumn('crs_timings_planed', 'planed_start', [
173 'type' => 'integer',
174 'length' => 8,
175 'notnull' => true,
176 'default' => 0
177 ]);
178 }
179 if ($ilDB->tableColumnExists('crs_timings_planed', 'planed_end')) {
180 $ilDB->modifyTableColumn('crs_timings_planed', 'planed_end', [
181 'type' => 'integer',
182 'length' => 8,
183 'notnull' => true,
184 'default' => 0
185 ]);
186 }
187 if ($ilDB->tableColumnExists('crs_timings_user', 'sstart')) {
188 $ilDB->modifyTableColumn('crs_timings_user', 'sstart', [
189 'type' => 'integer',
190 'length' => 8,
191 'notnull' => true,
192 'default' => 0
193 ]);
194 }
195 if ($ilDB->tableColumnExists('crs_timings_user', 'ssend')) {
196 $ilDB->modifyTableColumn('crs_timings_user', 'ssend', [
197 'type' => 'integer',
198 'length' => 8,
199 'notnull' => true,
200 'default' => 0
201 ]);
202 }
203 if ($ilDB->tableColumnExists('crs_waiting_list', 'sub_time')) {
204 $ilDB->modifyTableColumn('crs_waiting_list', 'sub_time', [
205 'type' => 'integer',
206 'length' => 8,
207 'notnull' => true,
208 'default' => 0
209 ]);
210 }
211 }

References $db, and $ilDB.

Field Documentation

◆ $db

ilDBInterface ilCourseDBUpdateSteps::$db
protected

Definition at line 23 of file ilCourseDBUpdateSteps.php.

Referenced by prepare(), and step_1().


The documentation for this class was generated from the following file: