#!/usr/bin/env python
"""Verify team_members table schema"""
import sqlite3
import os

db_path = os.path.join(os.path.dirname(__file__), 'app.db')

conn = sqlite3.connect(db_path)
cursor = conn.cursor()
cursor.execute('PRAGMA table_info(team_members)')
columns = cursor.fetchall()

print("team_members table columns:")
for col in columns:
    col_name, col_type = col[1], col[2]
    print(f"  ✓ {col_name}: {col_type}")

conn.close()
print("\n✓ Verification complete!")