From fef407970639c892fc44f122173c522f02691b0b Mon Sep 17 00:00:00 2001 From: marina Date: Tue, 27 Aug 2024 13:43:10 +0300 Subject: [PATCH] =?utf8?q?ERP-85=20=D0=A0=D0=B5=D0=B0=D0=BB=D0=B8=D0=B7?= =?utf8?q?=D0=BE=D0=B2=D0=B0=D1=82=D1=8C=20=D0=BE=D0=B1=D0=BC=D0=B5=D0=BD?= =?utf8?q?=20=D0=B4=D0=B0=D0=BD=D0=BD=D1=8B=D1=85=20=D1=81=201=D0=A1=20?= =?utf8?q?=D0=91=D1=83=D1=85=D0=B3=D0=B0=D0=BB=D1=82=D0=B5=D1=80=D0=B8?= =?utf8?q?=D1=8F?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- erp24/migrations/m240719_063451_create_table_motivation.php | 1 + .../m240722_054604_create_motivation_costs_items_table.php | 1 + erp24/migrations/m240729_081512_create_table_incoming_item.php | 1 + erp24/migrations/m240805_071431_create_api_cron_buh_table.php | 1 + ...240809_115844_insert_forecast_into_motivation_value_group.php | 1 + .../migrations/m240815_081804_add_new_column_to_api_cron_buh.php | 1 + erp24/migrations/m240820_150742_create_table_motivation_buh.php | 1 + erp24/migrations/m240821_114356_create_table_store_guid_buh.php | 1 + sql | 0 9 files changed, 8 insertions(+) create mode 100644 sql diff --git a/erp24/migrations/m240719_063451_create_table_motivation.php b/erp24/migrations/m240719_063451_create_table_motivation.php index 67e23283..fa7c467e 100755 --- a/erp24/migrations/m240719_063451_create_table_motivation.php +++ b/erp24/migrations/m240719_063451_create_table_motivation.php @@ -16,6 +16,7 @@ class m240719_063451_create_table_motivation extends Migration */ public function safeUp() { + return; $this->createTable(self::TABLE_NAME, [ 'id' => $this->primaryKey(), 'store_id' => $this->integer()->notNull()->comment('ID магазина'), diff --git a/erp24/migrations/m240722_054604_create_motivation_costs_items_table.php b/erp24/migrations/m240722_054604_create_motivation_costs_items_table.php index 9b1244bd..8ce1ff17 100644 --- a/erp24/migrations/m240722_054604_create_motivation_costs_items_table.php +++ b/erp24/migrations/m240722_054604_create_motivation_costs_items_table.php @@ -12,6 +12,7 @@ class m240722_054604_create_motivation_costs_items_table extends Migration */ public function safeUp() { + return; $this->execute('SET search_path TO erp24'); // Создаем тип ENUM diff --git a/erp24/migrations/m240729_081512_create_table_incoming_item.php b/erp24/migrations/m240729_081512_create_table_incoming_item.php index 8f18ace4..f5a097e5 100755 --- a/erp24/migrations/m240729_081512_create_table_incoming_item.php +++ b/erp24/migrations/m240729_081512_create_table_incoming_item.php @@ -14,6 +14,7 @@ class m240729_081512_create_table_incoming_item extends Migration */ public function safeUp() { + return; $this->createTable(self::TABLE_NAME, [ 'id' => $this->primaryKey(), 'incoming_id' => $this->string(36)->notNull()->comment('ID из таблицы incoming'), diff --git a/erp24/migrations/m240805_071431_create_api_cron_buh_table.php b/erp24/migrations/m240805_071431_create_api_cron_buh_table.php index 0bb353bd..551d6eac 100644 --- a/erp24/migrations/m240805_071431_create_api_cron_buh_table.php +++ b/erp24/migrations/m240805_071431_create_api_cron_buh_table.php @@ -12,6 +12,7 @@ class m240805_071431_create_api_cron_buh_table extends Migration */ public function safeUp() { + return; $this->createTable('{{%erp24.api_cron_buh}}', [ 'id' => $this->primaryKey(), 'date' => $this->dateTime()->notNull(), diff --git a/erp24/migrations/m240809_115844_insert_forecast_into_motivation_value_group.php b/erp24/migrations/m240809_115844_insert_forecast_into_motivation_value_group.php index 9498eb1b..6127410a 100755 --- a/erp24/migrations/m240809_115844_insert_forecast_into_motivation_value_group.php +++ b/erp24/migrations/m240809_115844_insert_forecast_into_motivation_value_group.php @@ -13,6 +13,7 @@ class m240809_115844_insert_forecast_into_motivation_value_group extends Migrati */ public function safeUp() { + return; $this->insert(self::TABLE_NAME, [ 'id' => 9, 'name' => 'Прогноз', diff --git a/erp24/migrations/m240815_081804_add_new_column_to_api_cron_buh.php b/erp24/migrations/m240815_081804_add_new_column_to_api_cron_buh.php index 2ab67604..c0a71635 100644 --- a/erp24/migrations/m240815_081804_add_new_column_to_api_cron_buh.php +++ b/erp24/migrations/m240815_081804_add_new_column_to_api_cron_buh.php @@ -12,6 +12,7 @@ class m240815_081804_add_new_column_to_api_cron_buh extends Migration */ public function safeUp() { + return; $this->dropColumn('api_cron_buh', 'request_id'); $this->addColumn('api_cron_buh', 'request_id', $this->string(36)->unique()->comment('ID запроса')); $this->addColumn('api_cron_buh', 'inn', $this->bigInteger()->comment('ИНН')); diff --git a/erp24/migrations/m240820_150742_create_table_motivation_buh.php b/erp24/migrations/m240820_150742_create_table_motivation_buh.php index acde2699..42436e91 100755 --- a/erp24/migrations/m240820_150742_create_table_motivation_buh.php +++ b/erp24/migrations/m240820_150742_create_table_motivation_buh.php @@ -15,6 +15,7 @@ class m240820_150742_create_table_motivation_buh extends Migration */ public function safeUp() { + return; $this->createTable(self::TABLE_NAME, [ 'id' => $this->primaryKey(), 'inn' => $this->integer()->notNull()->comment('ИНН фирмы источника данных'), diff --git a/erp24/migrations/m240821_114356_create_table_store_guid_buh.php b/erp24/migrations/m240821_114356_create_table_store_guid_buh.php index 96b06bf7..ea518842 100755 --- a/erp24/migrations/m240821_114356_create_table_store_guid_buh.php +++ b/erp24/migrations/m240821_114356_create_table_store_guid_buh.php @@ -14,6 +14,7 @@ class m240821_114356_create_table_store_guid_buh extends Migration */ public function safeUp() { + return true; $this->createTable(self::TABLE_NAME, [ 'id' => $this->primaryKey(), 'store_id' => $this->integer()->notNull()->comment('store id'), diff --git a/sql b/sql new file mode 100644 index 00000000..e69de29b -- 2.39.5