From 33650e273ff186c587ee09d60a6e2e8424dbd380 Mon Sep 17 00:00:00 2001 From: Teddy Wing Date: Fri, 9 Nov 2018 04:51:44 +0100 Subject: Move 'migrant' migrations to 'migrate' format Switched migration runners from https://crates.io/crates/migrant to https://github.com/golang-migrate/migrate . --- .../20181108234653_create-purchasers/down.sql | 6 ------ .../20181108234653_create-purchasers/up.sql | 21 --------------------- .../20181109031633_create_purchasers.down.sql | 6 ++++++ .../20181109031633_create_purchasers.up.sql | 21 +++++++++++++++++++++ 4 files changed, 27 insertions(+), 27 deletions(-) delete mode 100644 license-generator/migrations/20181108234653_create-purchasers/down.sql delete mode 100644 license-generator/migrations/20181108234653_create-purchasers/up.sql create mode 100644 license-generator/migrations/20181109031633_create_purchasers.down.sql create mode 100644 license-generator/migrations/20181109031633_create_purchasers.up.sql diff --git a/license-generator/migrations/20181108234653_create-purchasers/down.sql b/license-generator/migrations/20181108234653_create-purchasers/down.sql deleted file mode 100644 index d17db9c..0000000 --- a/license-generator/migrations/20181108234653_create-purchasers/down.sql +++ /dev/null @@ -1,6 +0,0 @@ -BEGIN; - -DROP TRIGGER purchasers_updated_at; -DROP TABLE purchasers; - -COMMIT; diff --git a/license-generator/migrations/20181108234653_create-purchasers/up.sql b/license-generator/migrations/20181108234653_create-purchasers/up.sql deleted file mode 100644 index 14927c2..0000000 --- a/license-generator/migrations/20181108234653_create-purchasers/up.sql +++ /dev/null @@ -1,21 +0,0 @@ -BEGIN; - -CREATE TABLE purchasers ( - id INT AUTO_INCREMENT PRIMARY KEY, - name VARCHAR(255) NOT NULL, - email VARCHAR(255) NOT NULL, - secret VARCHAR(255), - created_at DATETIME NOT NULL DEFAULT UTC_TIMESTAMP(), - updated_at DATETIME NOT NULL DEFAULT UTC_TIMESTAMP() -); - -DELIMITER $$ - CREATE TRIGGER purchasers_updated_at - BEFORE UPDATE - ON purchasers FOR EACH ROW - BEGIN - SET NEW.updated_at = UTC_TIMESTAMP(); - END$$ -DELIMITER ; - -COMMIT; diff --git a/license-generator/migrations/20181109031633_create_purchasers.down.sql b/license-generator/migrations/20181109031633_create_purchasers.down.sql new file mode 100644 index 0000000..d17db9c --- /dev/null +++ b/license-generator/migrations/20181109031633_create_purchasers.down.sql @@ -0,0 +1,6 @@ +BEGIN; + +DROP TRIGGER purchasers_updated_at; +DROP TABLE purchasers; + +COMMIT; diff --git a/license-generator/migrations/20181109031633_create_purchasers.up.sql b/license-generator/migrations/20181109031633_create_purchasers.up.sql new file mode 100644 index 0000000..14927c2 --- /dev/null +++ b/license-generator/migrations/20181109031633_create_purchasers.up.sql @@ -0,0 +1,21 @@ +BEGIN; + +CREATE TABLE purchasers ( + id INT AUTO_INCREMENT PRIMARY KEY, + name VARCHAR(255) NOT NULL, + email VARCHAR(255) NOT NULL, + secret VARCHAR(255), + created_at DATETIME NOT NULL DEFAULT UTC_TIMESTAMP(), + updated_at DATETIME NOT NULL DEFAULT UTC_TIMESTAMP() +); + +DELIMITER $$ + CREATE TRIGGER purchasers_updated_at + BEFORE UPDATE + ON purchasers FOR EACH ROW + BEGIN + SET NEW.updated_at = UTC_TIMESTAMP(); + END$$ +DELIMITER ; + +COMMIT; -- cgit v1.2.3