src/main/java/ru.machine.service/app/Launcher.java - master - syunya/Course2026

src/main/java/ru.machine.service/app/Launcher.java

85 строк2 KB

syunya

Update: Launcher.java

23 июн 2026, 17:57

23 июн 2026, 17:57cb17fdf

DROP DATABASE IF EXISTS machine_service;

CREATE DATABASE machine_service
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci;

USE machine_service;

CREATE TABLE roles (
    id_role INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50) NOT NULL UNIQUE,
    rights VARCHAR(255)
);

CREATE TABLE users (
    id_user INT AUTO_INCREMENT PRIMARY KEY,
    login VARCHAR(50) NOT NULL UNIQUE,
    password_hash VARCHAR(255) NOT NULL,
    full_name VARCHAR(100) NOT NULL,
    role_id INT NOT NULL,

    FOREIGN KEY(role_id)
    REFERENCES roles(id_role)
);

CREATE TABLE clients (
    id_client INT AUTO_INCREMENT PRIMARY KEY,
    company_name VARCHAR(100) NOT NULL,
    address VARCHAR(200),
    phone VARCHAR(30)
);

CREATE TABLE machine_types (
    id_machine_type INT AUTO_INCREMENT PRIMARY KEY,
    brand VARCHAR(100) NOT NULL,
    production_year INT,
    manufacturer_country VARCHAR(100)
);

CREATE TABLE machines (
    id_machine INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,

    machine_type_id INT NOT NULL,

    FOREIGN KEY(machine_type_id)
    REFERENCES machine_types(id_machine_type)
);

CREATE TABLE work_types (
    id_work_type INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    duration_days INT NOT NULL,
    cost DECIMAL(10,2) NOT NULL
);

CREATE TABLE repairs (
    id_repair INT AUTO_INCREMENT PRIMARY KEY,

    client_id INT NOT NULL,
    machine_id INT NOT NULL,

    start_date DATE NOT NULL,
    end_date DATE,

    FOREIGN KEY(client_id)
    REFERENCES clients(id_client),

    FOREIGN KEY(machine_id)
    REFERENCES machines(id_machine)
);

CREATE TABLE repair_work_types (
    repair_id INT,
    work_type_id INT,

    PRIMARY KEY(repair_id, work_type_id),

    FOREIGN KEY(repair_id)
    REFERENCES repairs(id_repair)
    ON DELETE CASCADE,

    FOREIGN KEY(work_type_id)
    REFERENCES work_types(id_work_type)
);