12 lines
356 B
SQL
12 lines
356 B
SQL
-- Initialize CloneWeb database
|
|
-- This script runs when the PostgreSQL container starts
|
|
|
|
-- Create extensions
|
|
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
|
|
CREATE EXTENSION IF NOT EXISTS "pg_trgm";
|
|
|
|
-- Create indexes for better performance
|
|
-- These will be created by Prisma migrations, but we can prepare the database
|
|
|
|
-- Set timezone
|
|
SET timezone = 'UTC'; |