Installation Guide

-- Users table (extends Supabase Auth)
CREATE TABLE usuarios (
  id SERIAL PRIMARY KEY,
  auth_user_id UUID REFERENCES auth.users(id) ON DELETE CASCADE,
  nombre_usuario TEXT UNIQUE NOT NULL,
  correo TEXT UNIQUE NOT NULL,
  nombre_completo TEXT,
  puesto TEXT,
  cedula TEXT UNIQUE,
  foto_url TEXT,
  ultimo_acceso TIMESTAMPTZ,
  presence_state TEXT DEFAULT 'offline',
  fecha_registro TIMESTAMPTZ DEFAULT NOW()
);

-- Projects table
CREATE TABLE proyectos (
  id SERIAL PRIMARY KEY,
  nombre TEXT UNIQUE NOT NULL,
  descripcion TEXT,
  estado TEXT DEFAULT 'activo',
  fecha_inicio DATE NOT NULL,
  fecha_fin DATE NOT NULL,
  color TEXT DEFAULT '#ECFDF5',
  opa FLOAT DEFAULT 0.65,
  creador_id INTEGER REFERENCES usuarios(id) ON DELETE SET NULL,
  fecha_creacion TIMESTAMPTZ DEFAULT NOW()
);

-- Tasks table
CREATE TABLE tareas (
  id SERIAL PRIMARY KEY,
  titulo TEXT NOT NULL,
  descripcion TEXT,
  estado TEXT DEFAULT 'pendiente',
  prioridad TEXT DEFAULT 'media',
  fecha_vencimiento DATE,
  fecha_creacion TIMESTAMPTZ DEFAULT NOW(),
  porcentaje_completado INTEGER DEFAULT 0,
  proyecto_id INTEGER REFERENCES proyectos(id) ON DELETE CASCADE,
  CHECK (porcentaje_completado >= 0 AND porcentaje_completado <= 100)
);

-- Tags table
CREATE TABLE etiquetas (
  id SERIAL PRIMARY KEY,
  nombre TEXT UNIQUE NOT NULL,
  color TEXT DEFAULT '#3B82F6'
);

-- Task-Tag junction table
CREATE TABLE tarea_etiquetas (
  tarea_id INTEGER REFERENCES tareas(id) ON DELETE CASCADE,
  etiqueta_id INTEGER REFERENCES etiquetas(id) ON DELETE CASCADE,
  PRIMARY KEY (tarea_id, etiqueta_id)
);

-- Task-User junction table (assignments)
CREATE TABLE tarea_usuarios (
  tarea_id INTEGER REFERENCES tareas(id) ON DELETE CASCADE,
  usuario_id INTEGER REFERENCES usuarios(id) ON DELETE CASCADE,
  PRIMARY KEY (tarea_id, usuario_id)
);

-- Deleted users (ban list)
CREATE TABLE usuarios_borrados (
  id SERIAL PRIMARY KEY,
  nombre_usuario TEXT,
  correo TEXT,
  fecha_eliminacion TIMESTAMPTZ DEFAULT NOW()
);

-- Enable Row Level Security
ALTER TABLE usuarios ENABLE ROW LEVEL SECURITY;
ALTER TABLE proyectos ENABLE ROW LEVEL SECURITY;
ALTER TABLE tareas ENABLE ROW LEVEL SECURITY;
ALTER TABLE etiquetas ENABLE ROW LEVEL SECURITY;
ALTER TABLE tarea_etiquetas ENABLE ROW LEVEL SECURITY;
ALTER TABLE tarea_usuarios ENABLE ROW LEVEL SECURITY;

-- RLS Policies (allow authenticated users to read/write)
CREATE POLICY "Allow authenticated users" ON usuarios
  FOR ALL USING (auth.role() = 'authenticated');

CREATE POLICY "Allow authenticated users" ON proyectos
  FOR ALL USING (auth.role() = 'authenticated');

CREATE POLICY "Allow authenticated users" ON tareas
  FOR ALL USING (auth.role() = 'authenticated');

CREATE POLICY "Allow authenticated users" ON etiquetas
  FOR ALL USING (auth.role() = 'authenticated');

CREATE POLICY "Allow authenticated users" ON tarea_etiquetas
  FOR ALL USING (auth.role() = 'authenticated');

CREATE POLICY "Allow authenticated users" ON tarea_usuarios
  FOR ALL USING (auth.role() = 'authenticated');

// Credentials are read from multiple sources
const supabaseUrl =
  process.env?.NEXT_PUBLIC_SUPABASE_URL ||
  window.SUPABASE_URL ||
  'https://vcssfbdprqmpmuhwaapb.supabase.co'; // fallback for dev

const supabaseAnonKey =
  process.env?.NEXT_PUBLIC_SUPABASE_ANON_KEY ||
  window.SUPABASE_ANON_KEY ||
  'eyJ...'; // fallback for dev

const supabaseServiceKey =
  process.env?.SUPABASE_SERVICE_KEY ||
  window.SUPABASE_SERVICE_KEY ||
  'eyJ...'; // fallback for dev

// Initialize clients
const supabase = window.supabase.createClient(
  supabaseUrl,
  supabaseAnonKey
);

const supabaseAdmin = window.supabase.createClient(
  supabaseUrl,
  supabaseServiceKey
);

window.__supabaseClient = supabase;
window.__supabaseAdmin = supabaseAdmin;

cd frontend
vercel

vercel --prod

INSERT INTO usuarios (
  auth_user_id,
  nombre_usuario,
  correo,
  nombre_completo,
  puesto
) VALUES (
  'YOUR_AUTH_USER_ID', -- Get this from Authentication → Users
  'admin',
  'admin@yourcompany.com',
  'Admin User',
  'Administrator'
);