CREATE TABLE `Customers` (
  `id` varchar(255) auto_increment PRIMARY KEY,
  `chat_id` varchar(255) not null,
  `username` varchar(255) not null,
  `password` varchar(255) not null,
  `fullname` varchar(255) not null,
  `phone_number` varchar(255) not null,
  `email` varchar(255) null,
  `address` varchar(255) not null,
  `payment_methods` varchar(255) not null
);

CREATE TABLE `Couriers` (
  `id` varchar(255) auto_increment PRIMARY KEY,
  `username` varchar(255) not null,
  `password` varchar(255) not null,
  `fullname` varchar(255) not null,
  `phone_number` varchar(255) not null,
  `email` varchar(255) not null
);

CREATE TABLE `Orders` (
  `id` varchar(255) auto_increment PRIMARY KEY,
  `client_id` varchar(255) not null,
  `courier_id` varchar(255) null,
  `created_at` datetime not null,
  `closed_at` datetime null,
  `supplier_id` varchar(255) not null,
  `total_price` decimal(10,2) not null
);

CREATE TABLE `Chats` (
  `id` varchar(255) auto_increment PRIMARY KEY,
  `message` varchar(255) null
);

CREATE TABLE `Suppliers` (
  `id` varchar(255) auto_increment PRIMARY KEY,
  `fullname` varchar(255) not null,
  `active` tinyint(1) default ‘1’ not null,
  `address` varchar(255) not null
);

CREATE TABLE `Food` (
  `id` varchar(255) auto_increment PRIMARY KEY,
  `name` varchar(255) not null,
  `price` decimal(10,2) default ‘1’ not null,
  `description` varchar(255) not null,
  `weight` int(10) null,
  `calories` int(10) null,
  `photo_url` varchar(255) null,
  `amount` int(10) not null
);

CREATE TABLE `Supports` (
  `id` varchar(255) auto_increment PRIMARY KEY,
  `chat_id` varchar(255) not null,
  `username` varchar(255) not null,
  `password` varchar(255) not null,
  `fullname` varchar(255) not null
);