CREATE TABLE pastes (
    id VARCHAR(10) PRIMARY KEY,
    title VARCHAR(255),
    content LONGTEXT NOT NULL,
    language VARCHAR(50) DEFAULT 'text',
    privacy ENUM('public', 'unlisted', 'private') DEFAULT 'public',
    expires_at DATETIME NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    ip_address VARCHAR(45),
    views INT DEFAULT 0
);

CREATE INDEX idx_created_at ON pastes(created_at);
CREATE INDEX idx_privacy_expires ON pastes(privacy, expires_at);