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