me-shaon · December 25, 2016 05:05 · Dec 25, 2016
diff --git a/CreateTrigger.php b/CreateTrigger.php
@@ -0,0 +1,21 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+
+class CreateTrigger extends Migration
+{
+    public function up()
+    {
+        DB::unprepared('
+                CREATE TRIGGER tr_after_main_insert AFTER INSERT ON `main` FOR EACH ROW
+                    BEGIN
+                        INSERT INTO `test`(`new_id`, `type`, `value`, `created_at`) VALUES (NEW.id, NEW.type, 3, NOW());
+                    END
+                ');
+    }
+
+    public function down()
+    {
+        DB::unprepared('DROP TRIGGER `tr_after_main_insert`');
+    }
+}