From 7dff4e7d0fbfde76a391bcf7e7712c5cf4d970b5 Mon Sep 17 00:00:00 2001
From: marina <m.zozirova@gmail.com>
Date: Tue, 4 Feb 2025 15:58:45 +0300
Subject: [PATCH] =?utf8?q?ERP-302=20=D0=A0=D0=B5=D0=B4=D0=B0=D0=BA=D1=82?=
 =?utf8?q?=D0=B8=D1=80=D0=BE=D0=B2=D0=B0=D0=BD=D0=B8=D0=B5=20=D0=B1=D1=83?=
 =?utf8?q?=D0=BA=D0=B5=D1=82=D0=B0?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 .../m250203_094609_create_bouquets_tables.php | 48 +++++++++++++++++++
 1 file changed, 48 insertions(+)
 create mode 100644 erp24/migrations/m250203_094609_create_bouquets_tables.php

diff --git a/erp24/migrations/m250203_094609_create_bouquets_tables.php b/erp24/migrations/m250203_094609_create_bouquets_tables.php
new file mode 100644
index 00000000..81d5b6ca
--- /dev/null
+++ b/erp24/migrations/m250203_094609_create_bouquets_tables.php
@@ -0,0 +1,48 @@
+<?php
+
+use yii\db\Migration;
+
+/**
+ * Class m250203_094609_create_bouquets_tables
+ */
+class m250203_094609_create_bouquets_tables extends Migration
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function safeUp()
+    {
+        $this->createTable('erp24.bouquet_composition_products', [
+            'id' => $this->primaryKey(),
+            'bouquet_id' => $this->integer()->notNull()->comment('ID букета'),
+            'product_guid' => $this->string(255)->notNull()->comment('GUID продукта'),
+            'count' => $this->float()->comment('Количество продукта'),
+            'created_at' => $this->dateTime()->comment('Дата создания'),
+            'updated_at' => $this->dateTime()->comment('Дата обновления'),
+            'created_by' => $this->integer()->comment('ID создателя записи'),
+            'updated_by' => $this->integer()->comment('ID обновителя записи'),
+        ]);
+
+        $this->createTable('erp24.bouquet_composition', [
+            'id' => $this->primaryKey(),
+            'guid' => $this->string(255)->comment('GUID букета'),
+            'name' => $this->string(255)->notNull()->comment('Название букета'),
+            'matrix_type_id' => $this->integer()->comment('ИД типа матрицы'),
+            'photo_id' => $this->integer()->comment('ИД фото'),
+            'video_id' => $this->integer()->comment('ИД видео'),
+            'created_at' => $this->dateTime()->comment('Дата создания'),
+            'updated_at' => $this->dateTime()->comment('Дата обновления'),
+            'created_by' => $this->integer()->comment('ID создателя записи'),
+            'updated_by' => $this->integer()->comment('ID обновителя записи'),
+        ]);
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function safeDown()
+    {
+        $this->dropTable('erp24.bouquet_composition_products');
+        $this->dropTable('erp24.bouquet_composition');
+    }
+}
-- 
2.39.5