---

CREATE TABLE Users (
    Id INT IDENTITY PRIMARY KEY,
    Login NVARCHAR(50) NOT NULL,
    Password NVARCHAR(50) NOT NULL,
    Role NVARCHAR(20) NOT NULL
);

CREATE TABLE Clients (
    Id INT IDENTITY PRIMARY KEY,
    FullName NVARCHAR(100),
    Phone NVARCHAR(20)
);

CREATE TABLE Rooms (
    Id INT IDENTITY PRIMARY KEY,
    RoomNumber INT,
    Type NVARCHAR(50),
    Price DECIMAL(10,2),
    IsOccupied BIT
);

CREATE TABLE Bookings (
    Id INT IDENTITY PRIMARY KEY,
    ClientId INT,
    RoomId INT,
    DateFrom DATE,
    DateTo DATE,
    FOREIGN KEY (ClientId) REFERENCES Clients(Id),
    FOREIGN KEY (RoomId) REFERENCES Rooms(Id)
);

INSERT INTO Users (Login, Password, Role)
VALUES 
('user', '1234', 'User'),
('admin', '7777', 'Admin');

INSERT INTO Rooms (RoomNumber, Type, Price, IsOccupied)
VALUES
(101, 'Стандарт', 2000, 0),
(102, 'Люкс', 5000, 0);