license-generator/migrations/20181109031633_create_purchasers.up.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

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()
);

CREATE TRIGGER purchasers_updated_at
    BEFORE UPDATE
    ON purchasers FOR EACH ROW
        SET NEW.updated_at = UTC_TIMESTAMP();

COMMIT;