rollpix.db — stores

CREATE TABLE stores  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  store_key TEXT UNIQUE NOT NULL,
  display_name TEXT NOT NULL,
  api_key_hash TEXT NOT NULL,
  active INTEGER NOT NULL DEFAULT 1,
  currency TEXT NOT NULL DEFAULT 'USD',
  price_per_image REAL NOT NULL,
  included_regenerations INTEGER NOT NULL DEFAULT 0,
  plan TEXT NOT NULL DEFAULT 'autogestionado',
  pricing_version INTEGER NOT NULL DEFAULT 1,
  created_at TEXT DEFAULT (datetime('now')),
  updated_at TEXT DEFAULT (datetime('now')),
  gemini_api_key TEXT,
  price_per_description REAL NOT NULL DEFAULT 0.10,
  api_key TEXT,
  google_search_api_key TEXT,
  google_search_cx TEXT,
  manufacturer_attribute TEXT DEFAULT 'manufacturer',
  billing_model TEXT DEFAULT 'session_flat',
  monthly_minimum REAL DEFAULT 0,
  price_per_search REAL DEFAULT 0,
  cost_multiplier REAL DEFAULT 2.0,
  lifestyle_app_url TEXT,
  status TEXT NOT NULL DEFAULT 'production'
)