From f3b4768b7f79913c88689d02962c11b2da29faba Mon Sep 17 00:00:00 2001
From: Vladimir Fomichev <vladimir.fomichev@erp-flowers.ru>
Date: Mon, 8 Sep 2025 16:12:48 +0300
Subject: [PATCH] =?utf8?q?=D0=9C=D0=B8=D0=B3=D1=80=D0=B0=D1=86=D0=B8=D1=8F?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 ..._create_matrix_bouquet_actuality_table.php | 47 +++++++++++++++++++
 1 file changed, 47 insertions(+)
 create mode 100644 erp24/migrations/m250908_123600_create_matrix_bouquet_actuality_table.php

diff --git a/erp24/migrations/m250908_123600_create_matrix_bouquet_actuality_table.php b/erp24/migrations/m250908_123600_create_matrix_bouquet_actuality_table.php
new file mode 100644
index 00000000..6da8741f
--- /dev/null
+++ b/erp24/migrations/m250908_123600_create_matrix_bouquet_actuality_table.php
@@ -0,0 +1,47 @@
+<?php
+
+use yii\db\Migration;
+
+/**
+ * Handles the creation of table `{{%matrix_bouquet_actuality}}`.
+ */
+class m250908_123600_create_matrix_bouquet_actuality_table extends Migration
+{
+    /**
+     * {@inheritdoc}
+     */
+    const TABLE_NAME = 'erp24.matrix_bouquet_actuality';
+    /**
+     * {@inheritdoc}
+     */
+    public function safeUp()
+    {
+        $tableSchema = $this->db->getTableSchema(self::TABLE_NAME);
+
+        if (!isset($tableSchema)) {
+            $this->createTable(self::TABLE_NAME, [
+                'id' => $this->primaryKey(),
+                'guid' => $this->string()->notNull()->comment('GUID товара из 1С'),
+                'bouquet_id' => $this->integer()->notNull()->comment('ID букета из bouquet_composition'),
+                'date_from' => $this->dateTime()->notNull()->comment('Дата и время начала активности'),
+                'date_to' => $this->dateTime()->null()->comment('Дата и время окончания активности'),
+                'is_archive' => $this->tinyInteger()->defaultValue(0)->comment('Признак архивного товара'),
+                'created_at' => $this->dateTime()->notNull()->comment('Дата создания'),
+                'updated_at' => $this->dateTime()->null()->comment('Дата обновления'),
+                'created_by' => $this->integer()->notNull()->comment('ИД создателя'),
+                'updated_by' => $this->integer()->null()->comment('ИД редактировавшего'),
+            ]);
+        }
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function safeDown()
+    {
+        $tableSchema = $this->db->getTableSchema(self::TABLE_NAME);
+        if (isset($tableSchema)) {
+            $this->dropTable(self::TABLE_NAME);
+        }
+    }
+}
-- 
2.39.5