PostgreSQL Starter Panel

# 1. Yöntem: Tek Connection String (Önerilen)
DATABASE_URL=postgresql://postgres:password@localhost:5432/postgres

# 2. Yöntem: Ayrı Ayrık Parametreler
# PGHOST=localhost
# PGPORT=5432
# PGUSER=postgres
# PGPASSWORD=password
# PGDATABASE=postgres

# Uygulama Portu
PORT=3000
NODE_ENV=production
AUTO_INIT_DB=true

-- 1. Ayarlar Tablosu
CREATE TABLE IF NOT EXISTS app_settings (
    key VARCHAR(100) PRIMARY KEY,
    value TEXT NOT NULL,
    description VARCHAR(255),
    updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);

-- 2. CRUD Öğe Tablosu
CREATE TABLE IF NOT EXISTS items (
    id SERIAL PRIMARY KEY,
    title VARCHAR(200) NOT NULL,
    description TEXT,
    category VARCHAR(50) DEFAULT 'Genel',
    priority VARCHAR(20) DEFAULT 'normal' CHECK (priority IN ('düşük', 'normal', 'yüksek', 'acil')),
    status VARCHAR(20) DEFAULT 'bekliyor' CHECK (status IN ('bekliyor', 'işlemde', 'tamamlandı', 'arşiv')),
    created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);

-- 3. İşlem Günlüğü
CREATE TABLE IF NOT EXISTS activity_logs (
    id SERIAL PRIMARY KEY,
    action VARCHAR(100) NOT NULL,
    details JSONB DEFAULT '{}'::jsonb,
    ip_address VARCHAR(45),
    created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX IF NOT EXISTS idx_items_status ON items(status);
CREATE INDEX IF NOT EXISTS idx_items_category ON items(category);
CREATE INDEX IF NOT EXISTS idx_items_created_at ON items(created_at DESC);