smartclass-ops / services /api /init_db.sql
balaji958685's picture
Add DB init SQL and API requirements
fffdfbc verified
-- SmartClass Database Initialization
-- This runs on first PostgreSQL container start
-- Create extensions
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
CREATE EXTENSION IF NOT EXISTS "pg_trgm";
-- Grant permissions
GRANT ALL PRIVILEGES ON DATABASE smartclass TO sc_user;