001_base.sql
1-- +goose Up
2-- +goose StatementBegin
3CREATE TABLE IF NOT EXISTS users(
4 id INTEGER PRIMARY KEY,
5 email TEXT,
6 handle TEXT,
7 password_hash TEXT,
8 metadata JSON,
9 ctime DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
10 mtime DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
11);
12-- +goose StatementEnd
13
14-- +goose Down
15-- +goose StatementBegin
16DROP TABLE users;
17-- +goose StatementEnd