← back to Watches

database/schema-users.sql

15 lines

-- ============================================================================
-- USER AUTHENTICATION SCHEMA
-- ============================================================================
-- This file imports the user authentication migration
-- Run this to set up user tables in a fresh database
-- ============================================================================

\i migrations/001-users.sql

-- Verify tables created
SELECT 'Users schema installed successfully' AS status;
SELECT table_name FROM information_schema.tables
WHERE table_schema = 'public'
AND table_name IN ('users', 'user_sessions', 'user_preferences', 'user_watchlist', 'push_subscriptions');