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
18
19
20
21
22
23
24

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,
    updated_at DATETIME NOT NULL
);

CREATE TRIGGER purchasers_before_insert
    BEFORE INSERT
    ON purchasers FOR EACH ROW
        SET
            NEW.updated_at = UTC_TIMESTAMP(),
            NEW.created_at = UTC_TIMESTAMP();

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

COMMIT;