🚀

Restaurador Universal Supabase

Resuelve permisos y restaura la base de datos en 1 clic

PASO 2

Conexión a Supabase

URL del Proyecto (Project URL)

Clave API (anon public key)

PASO 3

Restaurar Copia JSON

Selecciona el archivo backup_100_...json

> Sistema iniciado. Listo para comenzar.

PASO 1

Código SQL Completo

Este código crea las tablas y desactiva la seguridad (RLS) automáticamente.

Ve a Supabase > SQL Editor > New Query, pega este código y haz clic en RUN. Luego continúa con el Paso 2.

-- ==========================================
-- ESTRUCTURA COMPLETA SUPABASE (V2 - ENTERPRISE)
-- ==========================================

-- 0. Limpieza: Borra intentos previos para aplicar nuevas columnas
DROP TABLE IF EXISTS users CASCADE;
DROP TABLE IF EXISTS sales CASCADE;
DROP TABLE IF EXISTS services CASCADE;
DROP TABLE IF EXISTS appointments CASCADE;
DROP TABLE IF EXISTS clients CASCADE;
DROP TABLE IF EXISTS products CASCADE;
DROP TABLE IF EXISTS expenses CASCADE;
DROP TABLE IF EXISTS config CASCADE;

-- 1. Tabla de Usuarios
CREATE TABLE users (
    id TEXT PRIMARY KEY,
    name TEXT,
    "user" TEXT,
    pass TEXT,
    role TEXT,
    status TEXT,
    photo TEXT,
    "createdAt" BIGINT
);
ALTER TABLE users DISABLE ROW LEVEL SECURITY;

-- 2. Tabla de Ventas (Sales)
CREATE TABLE sales (
    id TEXT PRIMARY KEY,
    date TEXT,
    method TEXT,
    service TEXT,
    products JSONB,
    tip NUMERIC,
    datetime TEXT,
    "barberName" TEXT,
    "clientCedula" TEXT,
    commission NUMERIC,
    price NUMERIC,
    total NUMERIC,
    "commissionRate" NUMERIC,
    client TEXT,
    "createdAt" BIGINT,
    "mixedPayments" JSONB,
    "barberId" TEXT
);
ALTER TABLE sales DISABLE ROW LEVEL SECURITY;

-- 3. Tabla de Servicios
CREATE TABLE services (
    id TEXT PRIMARY KEY,
    name TEXT,
    price NUMERIC,
    "createdAt" BIGINT
);
ALTER TABLE services DISABLE ROW LEVEL SECURITY;

-- 4. Tabla de Citas (Appointments)
CREATE TABLE appointments (
    id TEXT PRIMARY KEY,
    client TEXT,
    name TEXT,
    service TEXT,
    price NUMERIC,
    "barberId" TEXT,
    "barberName" TEXT,
    datetime TEXT,
    date TEXT,
    "startTime" TEXT,
    time TEXT,
    status TEXT,
    "createdAt" BIGINT
);
ALTER TABLE appointments DISABLE ROW LEVEL SECURITY;

-- 5. Tabla de Clientes
CREATE TABLE clients (
    id TEXT PRIMARY KEY,
    name TEXT,
    phone TEXT,
    email TEXT,
    cedula TEXT,
    "lastVisit" TEXT,
    "birthday" TEXT,
    visits INTEGER,
    "createdAt" BIGINT
);
ALTER TABLE clients DISABLE ROW LEVEL SECURITY;

-- 6. Tabla de Productos
CREATE TABLE products (
    id TEXT PRIMARY KEY,
    name TEXT,
    code TEXT,
    price NUMERIC,
    stock INTEGER,
    "createdAt" BIGINT
);
ALTER TABLE products DISABLE ROW LEVEL SECURITY;

-- 7. Tabla de Gastos (Expenses)
CREATE TABLE expenses (
    id TEXT PRIMARY KEY,
    concept TEXT,
    type TEXT,
    description TEXT,
    amount NUMERIC,
    date TEXT,
    datetime TEXT,
    "barberId" TEXT,
    "barberName" TEXT,
    "createdAt" BIGINT
);
ALTER TABLE expenses DISABLE ROW LEVEL SECURITY;

-- 8. Tabla de Configuración Global
CREATE TABLE config (
    id TEXT PRIMARY KEY DEFAULT 'main',
    "businessName" TEXT,
    "serviceDuration" INTEGER,
    "commissionRate" NUMERIC,
    "currency" TEXT,
    "ticketPrinter" TEXT
);
ALTER TABLE config DISABLE ROW LEVEL SECURITY;

-- 9. RECARGAR CACHÉ DE ESQUEMA (CRÍTICO)
-- Esto obliga a Supabase a reconocer las nuevas columnas inmediatamente sin dar error de cache.
NOTIFY pgrst, 'reload schema';