---

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    email VARCHAR(255) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    name VARCHAR(100) NOT NULL,
    role ENUM('musician', 'designer', 'admin') DEFAULT 'musician',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE projects (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    artist VARCHAR(255),
    genre VARCHAR(100),
    description TEXT,
    case_link VARCHAR(255),
    image_url VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE submissions_musician (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(255) NOT NULL,
    genre VARCHAR(100),
    project_description TEXT,
    status ENUM('new', 'review', 'approved', 'rejected') DEFAULT 'new',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE genres (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL UNIQUE,
    slug VARCHAR(100) NOT NULL UNIQUE
);

CREATE TABLE statistics (
    id INT AUTO_INCREMENT PRIMARY KEY,
    stat_key VARCHAR(100) NOT NULL UNIQUE,
    stat_value VARCHAR(255) NOT NULL,
    stat_label VARCHAR(255),
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

INSERT INTO statistics (stat_key, stat_value, stat_label) VALUES
('legal_protection', '5%', 'Юридическая защита'),
('designers_count', '2', 'Дизайнеров в комьюнити'),
('projects_count', '2+', 'Выполненных проектов');

INSERT INTO genres (name, slug) VALUES
('D&B', 'dnb'),
('Techno', 'techno'),
('Acid', 'acid'),
('Пост-хардкор', 'post-hardcore'),
('Экспериментальная электроника', 'experimental');