CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    password VARCHAR(255) NOT NULL,
    bio TEXT,
    sexuality VARCHAR(50),
    preferences TEXT,
    profile_picture VARCHAR(255) DEFAULT 'default.jpg'
);

CREATE TABLE messages (
    id INT AUTO_INCREMENT PRIMARY KEY,
    sender_id INT,
    receiver_id INT,
    message TEXT,
    sent_at DATETIME DEFAULT CURRENT_TIMESTAMP
);
