
CREATE DATABASE IF NOT EXISTS support_system;
USE support_system;

CREATE TABLE tickets (
id INT AUTO_INCREMENT PRIMARY KEY,
player_id VARCHAR(50),
issue_type VARCHAR(100),
message TEXT,
ticket_number VARCHAR(50),
status VARCHAR(20) DEFAULT 'OPEN',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE messages (
id INT AUTO_INCREMENT PRIMARY KEY,
ticket_id INT,
sender VARCHAR(20),
message TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
