Additional banner for mobile view, ref #3231tic-3231

1 files changed, 32 insertions, 0 deletions

diff --git a/db/migrations/5.3.22_add_banner_mobile_path.php b/db/migrations/5.3.22_add_banner_mobile_path.php
new file mode 100644
index 0000000..8b13b5b
--- /dev/null
+++ b/db/migrations/5.3.22_add_banner_mobile_path.php
@@ -0,0 +1,32 @@
+<?php
+
+
+class AddBannerMobilePath extends Migration
+{
+    public function description()
+    {
+        return 'Add field banner_mobile_path to table banner_ads';
+    }
+
+
+    public function up()
+    {
+        $db = DBManager::get();
+
+        $db->exec(
+            "ALTER TABLE `banner_ads`
+            ADD `banner_mobile_path` varchar(255) COLLATE utf8mb4_unicode_ci NULL AFTER `banner_path`"
+        );
+    }
+
+
+    public function down()
+    {
+        $db = DBManager::get();
+
+        $db->exec(
+            "ALTER TABLE `banner_ads` DROP `banner_mobile_path`"
+        );
+
+    }
+}