add repetition from monday until friday for resource bookings, re #2013

Merge request studip/studip!2539

1 files changed, 26 insertions, 0 deletions

diff --git a/db/migrations/6.0.1.1_add_weekdays_to_resource_bookings.php b/db/migrations/6.0.1.1_add_weekdays_to_resource_bookings.php
new file mode 100644
index 0000000..049f941
--- /dev/null
+++ b/db/migrations/6.0.1.1_add_weekdays_to_resource_bookings.php
@@ -0,0 +1,26 @@
+<?php
+
+
+class AddWeekdaysToResourceBookings extends Migration
+{
+    public function description()
+    {
+        return 'Adds the weekdays column to the resource_bookings table.';
+    }
+
+    protected function up()
+    {
+        DBManager::get()->exec(
+            "ALTER TABLE `resource_bookings`
+            ADD COLUMN weekdays VARCHAR(7) COLLATE `latin1_bin` NOT NULL DEFAULT ''"
+        );
+    }
+
+    protected function down()
+    {
+        DBManager::get()->exec(
+            "ALTER TABLE `resource_bookings`
+            DROP COLUMN weekdays"
+        );
+    }
+}