15 lines
311 B
SQL
15 lines
311 B
SQL
-- migrate:up
|
|
CREATE EXTENSION IF NOT EXISTS ltree;
|
|
|
|
CREATE TABLE categories (
|
|
id SERIAL PRIMARY KEY,
|
|
name TEXT NOT NULL,
|
|
path ltree NOT NULL
|
|
);
|
|
|
|
CREATE INDEX idx_categories_path_gist ON categories USING gist (path);
|
|
|
|
-- migrate:down
|
|
DROP TABLE IF EXISTS categories;
|
|
DROP EXTENSION IF EXISTS ltree;
|