---

/* =========================================
   1. ИЗДАТЕЛЬСТВА
   ========================================= */

INSERT INTO Publishers (name, city)
VALUES
('Эксмо', 'Москва'),
('АСТ', 'Москва'),
('Питер', 'Санкт-Петербург');


-- Изменяем первые 2 записи
UPDATE Publishers
SET city = 'Москва, Россия'
WHERE id_publisher = 1;

UPDATE Publishers
SET name = 'Издательство АСТ'
WHERE id_publisher = 2;



/* =========================================
   2. ОБЛАСТИ ЗНАНИЙ
   ========================================= */

INSERT INTO KnowledgeAreas (unique_number, name)
VALUES
(101, 'Художественная литература'),
(102, 'Информатика'),
(103, 'История');


-- Изменяем первые 2 записи
UPDATE KnowledgeAreas
SET name = 'Русская художественная литература'
WHERE id_knowledge_area = 1;

UPDATE KnowledgeAreas
SET name = 'Информатика и программирование'
WHERE id_knowledge_area = 2;



/* =========================================
   3. ЧИТАТЕЛИ
   ========================================= */

INSERT INTO Readers
(
    last_name,
    first_name,
    middle_name,
    home_address,
    work_phone,
    home_phone,
    birth_date,
    ticket_number
)
VALUES
(
    'Иванов',
    'Иван',
    'Иванович',
    'ул. Ленина, 10',
    '89001112233',
    NULL,
    '2000-05-15',
    1001
),

(
    'Петров',
    'Петр',
    'Сергеевич',
    'ул. Советская, 15',
    NULL,
    '89002223344',
    '1998-03-20',
    1002
),

(
    'Сидорова',
    'Анна',
    'Олеговна',
    'ул. Победы, 7',
    '89003334455',
    '89004445566',
    '2002-11-10',
    1003
);


-- Изменяем первые 2 записи
UPDATE Readers
SET home_address = 'ул. Гагарина, 20'
WHERE id_reader = 1;

UPDATE Readers
SET home_phone = '89005556677'
WHERE id_reader = 2;



/* =========================================
   4. КНИГИ
   ========================================= */

INSERT INTO Books
(
    unique_code,
    title,
    author,
    coauthors,
    id_publisher,
    publication_year,
    page_count
)
VALUES
(
    'BK001',
    'Война и мир',
    'Толстой',
    NULL,
    1,
    1985,
    1200
),

(
    'BK002',
    'Преступление и наказание',
    'Достоевский',
    NULL,
    2,
    1990,
    650
),

(
    'BK003',
    'Основы программирования',
    'Иванов',
    'Петров',
    3,
    2020,
    500
);


-- Изменяем первые 2 записи
UPDATE Books
SET page_count = 1250
WHERE id_book = 1;

UPDATE Books
SET publication_year = 1995
WHERE id_book = 2;



/* =========================================
   5. ЭКЗЕМПЛЯРЫ КНИГ
   ========================================= */

INSERT INTO BookCopies
(
    inventory_number,
    id_book,
    is_available
)
VALUES
(5001, 1, 1),
(5002, 2, 1),
(5003, 3, 1);


-- Изменяем первые 2 записи
UPDATE BookCopies
SET inventory_number = 5101
WHERE id_copy = 1;

UPDATE BookCopies
SET inventory_number = 5102
WHERE id_copy = 2;



/* =========================================
   6. КНИГА - ОБЛАСТЬ ЗНАНИЙ
   ========================================= */

INSERT INTO BookKnowledgeAreas
(
    id_book,
    id_knowledge_area
)
VALUES
(1, 1),
(2, 1),
(3, 2);


-- Изменяем первые 2 записи

UPDATE BookKnowledgeAreas
SET id_knowledge_area = 3
WHERE id_book = 1
  AND id_knowledge_area = 1;

UPDATE BookKnowledgeAreas
SET id_knowledge_area = 3
WHERE id_book = 2
  AND id_knowledge_area = 1;



/* =========================================
   7. ВЫДАЧА КНИГ
   ========================================= */

INSERT INTO BookIssues
(
    id_reader,
    id_copy,
    issue_date,
    return_date
)
VALUES
(
    1,
    1,
    '2026-09-01',
    NULL
),

(
    2,
    2,
    '2026-09-02',
    NULL
),

(
    3,
    3,
    '2026-09-03',
    NULL
);


-- Изменяем первые 2 записи
UPDATE BookIssues
SET issue_date = '2026-08-30'
WHERE id_issue = 1;

UPDATE BookIssues
SET return_date = '2026-09-10'
WHERE id_issue = 2;