import flet as ft
import database_creatorplus as dc

db=dc.Database("base")
db.Table.create(db,"users",
    [
        "ID", "role","full_name", "login", "password",],
    [
        "INTEGER PRIMARY KEY AUTOINCREMENT","TEXT","TEXT","TEXT","TEXT"
    ]
)
db.Table.create(db,"products",
    [
        "ID", "article", "name", "unit", "price", "supplier", "manufacturer", "category",
        "discount", "count", "description", "image_path"
    ],
    [
        "INTEGER PRIMARY KEY AUTOINCREMENT","TEXT","TEXT","TEXT","TEXT",
        "TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT",
    ]
)
db.Table.create(db,"pick",["ID", "pick"],["INTEGER PRIMARY KEY AUTOINCREMENT","TEXT"])

db.Table.create(db,"orders",
    [
        "ID", "number_order", "article", "date_order", "date_delivery", "pick", "client", "code", "status",
    ],
    [
        "INTEGER PRIMARY KEY AUTOINCREMENT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT"
    ]
)