32 lines
2.0 KiB
SQL
32 lines
2.0 KiB
SQL
-- Script para expor as tabelas do schema 'gpi' no schema 'public' via views
|
|
-- Isso facilita o acesso pela API padrão do Supabase/PostgREST
|
|
|
|
-- 1. Garantir que o schema public existe
|
|
CREATE SCHEMA IF NOT EXISTS public;
|
|
|
|
-- 2. Criar views no schema public para cada tabela do gpi
|
|
CREATE OR REPLACE VIEW public.organizations AS SELECT * FROM gpi.organizations;
|
|
CREATE OR REPLACE VIEW public.users AS SELECT * FROM gpi.users;
|
|
CREATE OR REPLACE VIEW public.projects AS SELECT * FROM gpi.projects;
|
|
CREATE OR REPLACE VIEW public.parts AS SELECT * FROM gpi.parts;
|
|
CREATE OR REPLACE VIEW public.painting_schemes AS SELECT * FROM gpi.painting_schemes;
|
|
CREATE OR REPLACE VIEW public.application_records AS SELECT * FROM gpi.application_records;
|
|
CREATE OR REPLACE VIEW public.inspections AS SELECT * FROM gpi.inspections;
|
|
CREATE OR REPLACE VIEW public.technical_data_sheets AS SELECT * FROM gpi.technical_data_sheets;
|
|
CREATE OR REPLACE VIEW public.yield_studies AS SELECT * FROM gpi.yield_studies;
|
|
CREATE OR REPLACE VIEW public.instruments AS SELECT * FROM gpi.instruments;
|
|
CREATE OR REPLACE VIEW public.stock_items AS SELECT * FROM gpi.stock_items;
|
|
CREATE OR REPLACE VIEW public.stock_movements AS SELECT * FROM gpi.stock_movements;
|
|
CREATE OR REPLACE VIEW public.notifications AS SELECT * FROM gpi.notifications;
|
|
CREATE OR REPLACE VIEW public.geometry_types AS SELECT * FROM gpi.geometry_types;
|
|
CREATE OR REPLACE VIEW public.messages AS SELECT * FROM gpi.messages;
|
|
CREATE OR REPLACE VIEW public.stock_audit_logs AS SELECT * FROM gpi.stock_audit_logs;
|
|
CREATE OR REPLACE VIEW public.system_settings AS SELECT * FROM gpi.system_settings;
|
|
CREATE OR REPLACE VIEW public.stored_files AS SELECT * FROM gpi.stored_files;
|
|
|
|
-- 3. Dar permissões de acesso às views
|
|
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO postgres, anon, authenticated, service_role;
|
|
GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO postgres, anon, authenticated, service_role;
|
|
|
|
SELECT '18 views criadas no schema public com sucesso!' AS resultado;
|