---

CREATE TABLE Avtomobili (
    id_avto INT PRIMARY KEY AUTO_INCREMENT,
    gosnomer VARCHAR(20) NOT NULL,
    marka VARCHAR(50),
    tech_sostoyanie VARCHAR(50),
    probeg INT,
    gruzopodyomnost DECIMAL(10,2),
    rashod_topliva DECIMAL(5,2)
);

CREATE TABLE Voditeli (
    id_voditel INT PRIMARY KEY AUTO_INCREMENT,
    tabelny_nomer VARCHAR(20) NOT NULL,
    fio VARCHAR(100),
    data_rozhdeniya DATE,
    stazh INT,
    oklad DECIMAL(10,2),
    kategoriya VARCHAR(5)
);

CREATE TABLE Rejsy (
    id_rejs INT PRIMARY KEY AUTO_INCREMENT,
    id_avto INT,
    id_voditel INT,
    data_vyezda DATE,
    data_pribytiya DATE,
    mesto_naznacheniya VARCHAR(100),
    rasstoyaniye DECIMAL(10,2),
    rashod_goryuchego DECIMAL(10,2),
    massa_gruza DECIMAL(10,2),
    FOREIGN KEY (id_avto) REFERENCES Avtomobili(id_avto),
    FOREIGN KEY (id_voditel) REFERENCES Voditeli(id_voditel)
);

INSERT INTO Avtomobili VALUES 
(1, 'А123БВ61', 'КАМАЗ', 'исправен', 50000, 10.0, 25.5),
(2, 'В456ГД61', 'МАЗ', 'требует ТО', 80000, 15.0, 30.0);

INSERT INTO Voditeli VALUES 
(1, 'ТН-001', 'Иванов Иван Иванович', '1985-05-10', 10, 45000, 'C'),
(2, 'ТН-002', 'Петров Пётр Петрович', '1990-08-22', 5, 38000, 'CE');

INSERT INTO Rejsy VALUES 
(1, 1, 1, '2026-01-10', '2026-01-11', 'Москва', 1200, 300, 8.5),
(2, 2, 2, '2026-01-12', '2026-01-13', 'Краснодар', 300, 90, 12.0),
(3, 1, 2, '2026-01-15', '2026-01-16', 'Волгоград', 500, 125, 9.0);