66161b1566
Sistema NEXUS v3.4 migrado con: Estructura principal: - core/orchestration: Sistema SIMCO + CAPVED (27 directivas, 28 perfiles) - core/catalog: Catalogo de funcionalidades reutilizables - shared/knowledge-base: Base de conocimiento compartida - devtools/scripts: Herramientas de desarrollo - control-plane/registries: Control de servicios y CI/CD - orchestration/: Configuracion de orquestacion de agentes Proyectos incluidos (11): - gamilit (submodule -> GitHub) - trading-platform (OrbiquanTIA) - erp-suite con 5 verticales: - erp-core, construccion, vidrio-templado - mecanicas-diesel, retail, clinicas - betting-analytics - inmobiliaria-analytics - platform_marketing_content - pos-micro, erp-basico Configuracion: - .gitignore completo para Node.js/Python/Docker - gamilit como submodule (git@github.com:rckrdmrd/gamilit-workspace.git) - Sistema de puertos estandarizado (3005-3199) Generated with NEXUS v3.4 Migration System EPIC-010: Configuracion Git y Repositorios
30 lines
1.4 KiB
SQL
30 lines
1.4 KiB
SQL
-- ===========================================
|
|
-- MECANICAS DIESEL - Creacion de Schemas
|
|
-- ===========================================
|
|
-- Ejecutar despues de extensiones
|
|
|
|
-- Schemas propios de mecanicas-diesel
|
|
|
|
CREATE SCHEMA IF NOT EXISTS service_management;
|
|
COMMENT ON SCHEMA service_management IS 'Órdenes de servicio, diagnósticos, cotizaciones';
|
|
|
|
CREATE SCHEMA IF NOT EXISTS parts_management;
|
|
COMMENT ON SCHEMA parts_management IS 'Inventario de refacciones específico del taller';
|
|
|
|
CREATE SCHEMA IF NOT EXISTS vehicle_management;
|
|
COMMENT ON SCHEMA vehicle_management IS 'Vehículos diesel, flotas, motores';
|
|
|
|
-- Grants básicos
|
|
GRANT USAGE ON SCHEMA service_management TO mecanicas_user;
|
|
GRANT USAGE ON SCHEMA parts_management TO mecanicas_user;
|
|
GRANT USAGE ON SCHEMA vehicle_management TO mecanicas_user;
|
|
|
|
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA service_management TO mecanicas_user;
|
|
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA parts_management TO mecanicas_user;
|
|
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA vehicle_management TO mecanicas_user;
|
|
|
|
-- Default privileges para tablas futuras
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA service_management GRANT ALL ON TABLES TO mecanicas_user;
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA parts_management GRANT ALL ON TABLES TO mecanicas_user;
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA vehicle_management GRANT ALL ON TABLES TO mecanicas_user;
|