---

CREATE TABLE Users (
    id INT IDENTITY(1,1) PRIMARY KEY,
    login NVARCHAR(50) NOT NULL,
    password NVARCHAR(50) NOT NULL,
    role NVARCHAR(20) NOT NULL
);

INSERT INTO Users (login, password, role)
VALUES
('admin', '1234', 'admin'),
('manager', '1111', 'manager'),
('client', '2222', 'client');