-- ============================================
-- SAAS-022: Goals Schema
-- Sistema de metas y objetivos
-- ============================================

-- Create schema
CREATE SCHEMA IF NOT EXISTS goals;

-- Grant permissions
GRANT USAGE ON SCHEMA goals TO template_saas_user;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA goals TO template_saas_user;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA goals TO template_saas_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA goals GRANT ALL ON TABLES TO template_saas_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA goals GRANT ALL ON SEQUENCES TO template_saas_user;