diff options
| -rw-r--r-- | license-generator/migrations/20181109031633_create_purchasers.up.sql | 6 |
1 files changed, 1 insertions, 5 deletions
diff --git a/license-generator/migrations/20181109031633_create_purchasers.up.sql b/license-generator/migrations/20181109031633_create_purchasers.up.sql index 14927c2..8bf597c 100644 --- a/license-generator/migrations/20181109031633_create_purchasers.up.sql +++ b/license-generator/migrations/20181109031633_create_purchasers.up.sql @@ -9,13 +9,9 @@ CREATE TABLE purchasers ( updated_at DATETIME NOT NULL DEFAULT UTC_TIMESTAMP() ); -DELIMITER $$ - CREATE TRIGGER purchasers_updated_at +CREATE TRIGGER purchasers_updated_at BEFORE UPDATE ON purchasers FOR EACH ROW - BEGIN SET NEW.updated_at = UTC_TIMESTAMP(); - END$$ -DELIMITER ; COMMIT; |