dev-template/db/migrations/20260101000000_create_items.sql
Antoine Pelletier 572489ed5c first commit
2026-07-29 16:47:05 +02:00

10 lines
252 B
SQL

-- migrate:up
-- Example table. Localized texts are stored as JSONB: {"fr": "...", "en": "..."}
CREATE TABLE items (
id SERIAL PRIMARY KEY,
"name" JSONB NOT NULL,
"description" JSONB NOT NULL
);
-- migrate:down
DROP TABLE IF EXISTS items;