---

CREATE TABLE Users (
    UserID INT IDENTITY(1,1) PRIMARY KEY,
    Login NVARCHAR(50) NOT NULL UNIQUE,
    Password NVARCHAR(50) NOT NULL,
    FullName NVARCHAR(100) NOT NULL,
    RoleID INT NOT NULL,
    CONSTRAINT FK_Users_Roles FOREIGN KEY (RoleID)
        REFERENCES Roles(RoleID)
);



INSERT INTO Users (Login, Password, FullName, RoleID)
VALUES 
('manager1', '123', 'Иванов Иван Иванович', 1),
('admin1', '123', 'Петров Петр Петрович', 2);