DDL: polnenje.sql

INSERT INTO Dorm_User (u_id, phone_number, first_name, last_name, email, pass)
VALUES 
    (1, '1234567890', 'John', 'Doe', 'john.doe@example.com', 'password123'),
    (2, '0987654321', 'Jane', 'Smith', 'jane.smith@example.com', 'password456'),
    (3, '1122334455', 'Alice', 'Johnson', 'alice.johnson@example.com', 'password789'),
    (4, '2233445566', 'Bob', 'Brown', 'bob.brown@example.com', 'password000');

INSERT INTO Block (block_id, num_available_rooms)
VALUES 
    ('A', 50),
    ('B', 40),
    ('C', 30),
    ('D', 20);

INSERT INTO Room (room_number, block_id, is_available, capacity)
VALUES 
    (101, 'A', true, 2),
    (102, 'A', true, 2),
    (103, 'B', true, 3),
    (104, 'B', false, 3),
    (201, 'C', true, 4),
    (202, 'D', true, 1);

INSERT INTO Student (u_id, faculty_name, year_of_studies, is_exempt)
VALUES 
    (1, 'Computer Science', 2, false),
    (2, 'Engineering', 3, false),
    (3, 'Mathematics', 1, false);

INSERT INTO Employee (u_id)
VALUES 
    (4);

INSERT INTO Payment (p_id, amount, payment_date, student_id, payment_month)
VALUES 
    (1, 500, '2024-01-15', 1, 'January'),
    (2, 600, '2024-02-10', 2, 'February'),
    (3, 450, '2024-03-05', 3, 'March');

INSERT INTO Dorm_Document (d_id, d_comment, d_status, upload_date, file_path, emp_id, student_id)
VALUES 
    (1, 'Room allocation document', 'Approved', '2024-01-10', '/path/to/doc1.pdf', 4, 1),
    (2, 'Payment confirmation', 'Pending', '2024-02-15', '/path/to/doc2.pdf', 4, 2);

INSERT INTO RoomRequest (status, roomate_email, room_number, block_id, employee_id, student_id)
VALUES 
    ('Pending', 'jane.smith@example.com', 101, 'A', 4, 1),
    ('Pending', 'test.test@example.com', 101, 'A', 4, 2),
    ('Approved', NULL, 103, 'B', 4, 2);

INSERT INTO StudentTookRoom (start_date, end_date, student_id, room_num, block_id)
VALUES 
    ('2024-01-01', '2024-06-01', 1, 101, 'A'),
    ('2024-01-01', NULL, 2, 101, 'A');