From aa1c06945a0a4bd103555d802277ad86d9d28eb0 Mon Sep 17 00:00:00 2001
From: Camil Staps
Date: Fri, 3 Jan 2020 20:16:07 +0100
Subject: Remove mediopassive

---
 ...2020_01_03_190703_remove_mediopassive_voice.php | 32 ++++++++++++++++++++++
 1 file changed, 32 insertions(+)
 create mode 100644 database/migrations/2020_01_03_190703_remove_mediopassive_voice.php

(limited to 'database/migrations')

diff --git a/database/migrations/2020_01_03_190703_remove_mediopassive_voice.php b/database/migrations/2020_01_03_190703_remove_mediopassive_voice.php
new file mode 100644
index 0000000..beddf3e
--- /dev/null
+++ b/database/migrations/2020_01_03_190703_remove_mediopassive_voice.php
@@ -0,0 +1,32 @@
+<?php
+
+use Illuminate\Support\Facades\Schema;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+
+use HebrewParseTrainer\Form;
+
+class RemoveMediopassiveVoice extends Migration
+{
+	/**
+	 * Run the migrations.
+	 *
+	 * @return void
+	 */
+	public function up()
+	{
+		Form::where('voice', 'MP')->update(['voice' => 'M']);
+
+		DB::statement("ALTER TABLE forms CHANGE COLUMN voice voice ENUM('A', 'M', 'P') NOT NULL");
+	}
+
+	/**
+	 * Reverse the migrations.
+	 *
+	 * @return void
+	 */
+	public function down()
+	{
+		DB::statement("ALTER TABLE forms CHANGE COLUMN voice voice ENUM('A', 'M', 'P', 'MP') NOT NULL");
+	}
+}
-- 
cgit v1.2.3