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);