← back to Sdcc Awards

cypressaward/scraper/create-administrators-table.sql

24 lines

-- Create table for settlement administrators
CREATE TABLE IF NOT EXISTS scraped_administrators (
  id SERIAL PRIMARY KEY,
  name TEXT NOT NULL,
  type TEXT DEFAULT 'administrator',
  location TEXT,
  phone TEXT,
  email TEXT,
  website TEXT,
  description TEXT,
  specialties TEXT,
  cy_pres_capable BOOLEAN DEFAULT true,
  press_page TEXT,
  notes TEXT,
  source TEXT,
  hash TEXT UNIQUE,
  created_at TIMESTAMP DEFAULT NOW(),
  updated_at TIMESTAMP DEFAULT NOW()
);

-- Create index for faster queries
CREATE INDEX IF NOT EXISTS idx_administrators_name ON scraped_administrators(name);
CREATE INDEX IF NOT EXISTS idx_administrators_type ON scraped_administrators(type);
CREATE INDEX IF NOT EXISTS idx_administrators_cy_pres ON scraped_administrators(cy_pres_capable);