15 lines
623 B
SQL
15 lines
623 B
SQL
-- topology_api/migrations/001_extensions.sql
|
|
-- Create schema and required PostgreSQL extensions
|
|
-- Extensions are installed in both public and topology schemas
|
|
-- so types like citext resolve without schema prefix
|
|
|
|
CREATE SCHEMA IF NOT EXISTS topology;
|
|
|
|
CREATE EXTENSION IF NOT EXISTS pgcrypto WITH SCHEMA public;
|
|
CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public;
|
|
CREATE EXTENSION IF NOT EXISTS btree_gist WITH SCHEMA public;
|
|
|
|
CREATE EXTENSION IF NOT EXISTS pgcrypto WITH SCHEMA topology;
|
|
CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA topology;
|
|
CREATE EXTENSION IF NOT EXISTS btree_gist WITH SCHEMA topology;
|