---

CREATE TABLE Users
(
    Id INTEGER PRIMARY KEY AUTOINCREMENT,
    Login TEXT NOT NULL UNIQUE,
    Password TEXT NOT NULL,
    FullName TEXT NOT NULL,
    Role TEXT NOT NULL
);

CREATE TABLE Categories
(
    Id INTEGER PRIMARY KEY AUTOINCREMENT,
    Name TEXT NOT NULL
);

CREATE TABLE Manufacturers
(
    Id INTEGER PRIMARY KEY AUTOINCREMENT,
    Name TEXT NOT NULL
);

CREATE TABLE Products
(
    Id INTEGER PRIMARY KEY AUTOINCREMENT,
    Name TEXT NOT NULL,
    CategoryId INTEGER NOT NULL,
    Description TEXT,
    ManufacturerId INTEGER NOT NULL,
    Supplier TEXT,
    Price REAL NOT NULL,
    Unit TEXT NOT NULL,
    Quantity INTEGER NOT NULL,
    Discount REAL NOT NULL,

    FOREIGN KEY (CategoryId)
        REFERENCES Categories(Id),

    FOREIGN KEY (ManufacturerId)
        REFERENCES Manufacturers(Id)
);

CREATE TABLE Orders
(
    Id INTEGER PRIMARY KEY AUTOINCREMENT,
    Article TEXT NOT NULL,
    Status TEXT NOT NULL,
    PickupAddress TEXT,
    OrderDate TEXT,
    PickupDate TEXT
);

CREATE TABLE OrderItems
(
    Id INTEGER PRIMARY KEY AUTOINCREMENT,
    OrderId INTEGER NOT NULL,
    ProductId INTEGER NOT NULL,
    Quantity INTEGER NOT NULL,

    FOREIGN KEY (OrderId)
        REFERENCES Orders(Id),

    FOREIGN KEY (ProductId)
        REFERENCES Products(Id)
);