8 lines
491 B
SQL
8 lines
491 B
SQL
-- 000: PostgreSQL extensions required
|
|
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
|
|
CREATE EXTENSION IF NOT EXISTS "pg_trgm"; -- Trigram for fuzzy text search
|
|
CREATE EXTENSION IF NOT EXISTS "btree_gist"; -- For exclusion constraints
|
|
CREATE EXTENSION IF NOT EXISTS "citus" CASCADE; -- Distributed tables (Citus for horizontal scaling)
|
|
-- Note: Citus extension requires Citus-enabled PostgreSQL image in production
|
|
-- In dev, this CREATE EXTENSION will silently fail if not available
|