This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Seed data for HummingAgent Project Dashboard | |
| -- Insert HummingAgent organization | |
| INSERT INTO pd_organizations (id, name, slug, logo_url) VALUES | |
| ('11111111-1111-1111-1111-111111111111', 'HummingAgent', 'hummingagent', '/logo.jpg'); | |
| -- Insert client organizations | |
| INSERT INTO pd_organizations (id, name, slug) VALUES | |
| ('22222222-2222-2222-2222-222222222222', 'JVRC', 'jvrc'), | |
| ('33333333-3333-3333-3333-333333333333', 'GFM', 'gfm'), |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- HummingAgent Project Dashboard Schema | |
| -- Vercel Postgres / PostgreSQL | |
| -- Enable UUID extension | |
| CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; | |
| -- Users table (synced with auth provider) | |
| CREATE TABLE pd_users ( | |
| id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), | |
| email VARCHAR(255) UNIQUE NOT NULL, |