a3f354528a
- Schema creation and grants - Enums: product_type, product_status, price_type, attribute_type - Tables: categories, products, variants, prices - RLS policies for tenant isolation - Performance indexes Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
20 lines
703 B
SQL
20 lines
703 B
SQL
-- ============================================
|
|
-- TEMPLATE-SAAS: Portfolio Schema
|
|
-- Version: 1.0.0
|
|
-- Module: SAAS-019
|
|
-- ============================================
|
|
|
|
-- Create schema
|
|
CREATE SCHEMA IF NOT EXISTS portfolio;
|
|
|
|
-- Grant permissions
|
|
GRANT USAGE ON SCHEMA portfolio TO template_saas_app;
|
|
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA portfolio TO template_saas_app;
|
|
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA portfolio TO template_saas_app;
|
|
|
|
-- Default privileges for future tables
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA portfolio
|
|
GRANT ALL PRIVILEGES ON TABLES TO template_saas_app;
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA portfolio
|
|
GRANT ALL PRIVILEGES ON SEQUENCES TO template_saas_app;
|