U [Mh @sdZddlmZmZddlmZddlZddlmZmZede dZ e dzee Z e hZed ZeeZd d eDZe d ed ekre dedZeeZeZe deD]6Ze deddeddeddkrdndqe dedZeeedZeeddgZeD]Zeeeq@ee de deed ZeZeD]:Ze deddeddeddkrdndqe d!W5QRXWn2ek r Zze d"eW5dZ[XYnXdS)#zH Complete Solution: Create/Update developers table and fix registration ) create_enginetext) load_dotenvN)datetimetimezonez .env.local DATABASE_URLu,🔧 Setting up developers table properly...z~ SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' cCsg|] }|dqS)r).0rowrr./setup_developers_table.py sr u📋 Existing tables: Z developersu4 🔍 Checking current developers table structure...z SELECT column_name, data_type, is_nullable, column_default FROM information_schema.columns WHERE table_name = 'developers' ORDER BY ordinal_position zCurrent columns:z - z (z) - ZYESZNULLzNOT NULLu? 🔨 Creating/updating developers table to match your model...z'DROP TABLE IF EXISTS developers CASCADEa CREATE TABLE developers ( id SERIAL PRIMARY KEY, developer_id VARCHAR UNIQUE, name VARCHAR, email VARCHAR, active BOOLEAN DEFAULT TRUE, api_token VARCHAR UNIQUE, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), last_sync TIMESTAMP WITH TIME ZONE ) zRCREATE INDEX IF NOT EXISTS ix_developers_developer_id ON developers (developer_id)zLCREATE INDEX IF NOT EXISTS ix_developers_api_token ON developers (api_token)u*✅ Developers table created successfully!u 📋 New table structure:z SELECT column_name, data_type, is_nullable, column_default FROM information_schema.columns WHERE table_name = 'developers' ORDER BY ordinal_position u 🎉 Database setup complete!u ❌ Error: )__doc__Z sqlalchemyrrZdotenvrosrrgetenvrprintZengineZconnectZconnZ tables_queryZexecuteresultZexisting_tablesZ columns_queryZfetchallcolumnscolZ drop_tableZ create_tableZindexesidxZcommit Exceptionerrrr sT      4  8