Hekkova

-- Accountscreate table accounts (  id text primary key default gen_random_uuid()::text,  display_name text not null,  light_id text,  wallet_address text,  mints_remaining integer not null default 0,  total_minted integer not null default 0,  default_phase text not null default 'new_moon',  legacy_plan boolean not null default false,  created_at timestamptz not null default now());
-- API Keyscreate table api_keys (  id text primary key default gen_random_uuid()::text,  account_id text not null references accounts(id) on delete cascade,  key_hash text not null unique,  key_prefix text not null,  environment text not null default 'live',  created_at timestamptz not null default now(),  revoked_at timestamptz);
-- Momentscreate table moments (  id text primary key default gen_random_uuid()::text,  account_id text not null references accounts(id) on delete cascade,  block_id text not null unique,  token_id integer not null,  title text not null,  description text,  phase text not null,  category text,  encrypted boolean not null default false,  media_cid text not null,  metadata_cid text not null,  media_type text not null,  polygon_tx text not null,  source_url text,  source_platform text,  eclipse_reveal_date timestamptz,  tags text[] not null default '{}',  timestamp timestamptz not null default now(),  created_at timestamptz not null default now());
-- Indexescreate index on api_keys(key_hash);create index on moments(account_id, timestamp desc);create index on moments(block_id);