create table UserProfile(
UserID INT PRIMARY KEY, 
FullName VARCHAR(100), 
Email VARCHAR(150) NOT NULL UNIQUE, 
MobileNumber VARCHAR(20) NOT NULL,
Password VARCHAR(255) NOT NULL
);

INSERT INTO UserProfile (UserID, FullName, Email, Mobilenumber, Password)
VALUES
  (101, 'John Doe', 'j.doe@company.com', '123456', 'password'),
  (102, 'Jane Smith', 'j.smith@abc.com', '234567','drowssap'),
  (206, 'Alice Johnson', 'alicejohnson@xyz.com', '345678','itIsPersonal'),
  (100, 'Bob Williams', 'williamsbob21@company.com', '347890','G45$%th4@&'),
  (310, 'Emily Brown', 'Br.emily324@abc.com','647289', 'emily345&67');

create table Reservations(
ReservationID  INT AUTO_INCREMENT PRIMARY KEY, 
UserID INT, 
CheckInDate DATE Not Null, 
CheckOutDate DATE Not Null,
RoomNumber VARCHAR(200),
Status VARCHAR(50),
FOREIGN KEY (UserID) REFERENCES UserProfile(UserID)
);

INSERT INTO Reservations (UserID, CheckInDate, CheckOutDate, RoomNumber, Status)
VALUES
  (101, '2026-04-05', '2026-04-08', 'B402', 'Approved'),
  (206, '2026-05-15', '2026-05-20', '302', 'Approved'),
  (310, '2025-09-09', '2025-09-23', '205', 'Approved'),
  (100, '2026-01-10', '2026-01-20', 'C12', 'Cancelled'),
  (101, '2026-03-05', '2026-03-08', 'A102', 'Approved');

select * from reservations;