Skip to content

Instantly share code, notes, and snippets.

@manakuro
Last active January 17, 2020 02:07
Show Gist options
  • Save manakuro/23300e536443f9d36589389ccd26e405 to your computer and use it in GitHub Desktop.
Save manakuro/23300e536443f9d36589389ccd26e405 to your computer and use it in GitHub Desktop.
-- +goose Up
-- +goose StatementBegin
CREATE TABLE users (
id INT NOT NULL AUTO_INCREMENT,
uuid varchar(255) NOT NULL,
email varchar(255) DEFAULT NULL,
created_at datetime DEFAULT NULL,
updated_at datetime DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
INDEX user_id (id),
PRIMARY KEY(id)
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4;
-- +goose StatementEnd
-- +goose Down
-- +goose StatementBegin
DROP TABLE users;
-- +goose StatementEnd
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment