ea4f8b18a0
- Create sales schema (00-schema.sql) - Add sales enums (01-enums.sql): lead_status, lead_source, opportunity_stage, activity_type, activity_status - Add tables (02-tables.sql): pipeline_stages, leads, opportunities, activities - Add functions (03-functions.sql): convert_lead_to_opportunity, update_opportunity_stage, calculate_lead_score, get_pipeline_summary, initialize_default_stages - Add RLS policies (04-rls.sql) for tenant isolation - Add indexes (05-indexes.sql) for performance Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
20 lines
675 B
SQL
20 lines
675 B
SQL
-- ============================================
|
|
-- TEMPLATE-SAAS: Sales Schema
|
|
-- Version: 1.0.0
|
|
-- Module: SAAS-018
|
|
-- ============================================
|
|
|
|
-- Create schema
|
|
CREATE SCHEMA IF NOT EXISTS sales;
|
|
|
|
-- Grant permissions
|
|
GRANT USAGE ON SCHEMA sales TO template_saas_app;
|
|
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA sales TO template_saas_app;
|
|
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA sales TO template_saas_app;
|
|
|
|
-- Default privileges for future tables
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA sales
|
|
GRANT ALL PRIVILEGES ON TABLES TO template_saas_app;
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA sales
|
|
GRANT ALL PRIVILEGES ON SEQUENCES TO template_saas_app;
|