diff options
| author | Masaya Tojo <masaya@tojo.tokyo> | 2024-03-12 02:52:57 +0900 |
|---|---|---|
| committer | Masaya Tojo <masaya@tojo.tokyo> | 2024-03-12 02:52:57 +0900 |
| commit | 59e39e0088fc71225a0d5b4b1ca7df6ec9ec4659 (patch) | |
| tree | 900227533d65e277b408df911cc7df446edaff16 /deploy/tags.sql | |
| parent | 1fd13d3895ba1274c1754379b3003b1e4f9840ab (diff) | |
Rename article_tags to tags.
Diffstat (limited to 'deploy/tags.sql')
| -rw-r--r-- | deploy/tags.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/deploy/tags.sql b/deploy/tags.sql new file mode 100644 index 0000000..8186248 --- /dev/null +++ b/deploy/tags.sql @@ -0,0 +1,15 @@ +-- Deploy diary:tags to pg +-- requires: schema + +BEGIN; + +SET search_path to diary; + +CREATE TABLE tags( + id UUID PRIMARY KEY, + name TEXT UNIQUE NOT NULL, + created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), + updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW() +); + +COMMIT; |