Lernmaterialien in Courseware sortieren

Closes #3032

Merge request studip/studip!2052

1 files changed, 27 insertions, 0 deletions

diff --git a/db/migrations/5.5.8_add_pos_to_cw_units.php b/db/migrations/5.5.8_add_pos_to_cw_units.php
new file mode 100644
index 0000000..d3e3790
--- /dev/null
+++ b/db/migrations/5.5.8_add_pos_to_cw_units.php
@@ -0,0 +1,27 @@
+<?php
+
+final class AddPosToCwUnits extends Migration
+{
+    public function description()
+    {
+        return 'Add field pos to table cw_units';
+    }
+
+    public function up()
+    {
+        $db = DBManager::get();
+        $db->exec("
+            ALTER TABLE `cw_units`
+            ADD COLUMN `position` INT(11) DEFAULT NULL AFTER `content_type`
+        ");
+    }
+
+    public function down()
+    {
+        $db = DBManager::get();
+        $db->exec("
+            ALTER TABLE `cw_units`
+            DROP COLUMN `position`
+        ");
+    }
+}