-- Reference init script for direct psql execution.
-- Run from the knoe-db/ directory:
--   psql -v ON_ERROR_STOP=1 -U knoe -d knoe-db -f init_prole_app.sql
--
-- CNPG path: SQL is wired via ConfigMap + postInitApplicationSQLRefs.
-- See docs/plans/junie/ekosystem-uuid-cnpg-wire.md for pending CNPG work.

-- Extensions
CREATE EXTENSION IF NOT EXISTS pgcrypto SCHEMA knoe;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA knoe TO knoe;
CREATE EXTENSION IF NOT EXISTS postgis SCHEMA knoe;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA knoe TO knoe;
CREATE EXTENSION IF NOT EXISTS postgis_topology SCHEMA knoe;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA knoe TO knoe;
CREATE EXTENSION IF NOT EXISTS vector SCHEMA knoe;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA knoe TO knoe;
CREATE EXTENSION IF NOT EXISTS tds_fdw SCHEMA knoe;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA knoe TO knoe;

-- Ekosystem UUID system (depends on extensions above)
\i schema/ekosystem.sql
\i schema/ekosystem_objects.sql

-- Seed: knoe-db is tenant 0 (inserted idempotently in ekosystem.sql)
-- Register prole as tenant 1 when deploying the prole ekosystem:
--   SELECT * FROM knoe.register_tenant('prole');