Skip to content

Instantly share code, notes, and snippets.

@musamamasood
Forked from me-shaon/CreateTrigger.php
Created December 11, 2019 16:06
Show Gist options
  • Save musamamasood/e4dfc079f87d5e18d64ef069ad828b14 to your computer and use it in GitHub Desktop.
Save musamamasood/e4dfc079f87d5e18d64ef069ad828b14 to your computer and use it in GitHub Desktop.
Sample Laravel migration to create MySQL Trigger
<?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`');
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment