create table cities
(
id int(11) primary key auto_increment,
name varchar(30) not null,
country_name varchar(80) not null
);

create table users
(
id int(11) primary key auto_increment,
username varchar(50) unique not null,
password varchar(255) not null,
first_name varchar(50) not null,
last_name varchar(50),
age int(11) check(age>=18) ,
money decimal(15,2) not null,
city_id int(11) not null,
register_date date not null,
constraint FK_city_user foreign key(city_id)
references cities(id)
);

create table orders
(
id int(11) primary key auto_increment,
user_id int(11) not null,
constraint FK_city_user1 foreign key (user_id)
references users(id),
order_date date not null,
is_completed bool default 0
);

create table plants
(
id int(11) primary key auto_increment,
name varchar(50) not null,
price decimal(15,2) not null,
color varchar(50),
quantity int(11) default 0
);

create table info_plants
(
id int(11) primary key auto_increment,
plant_id int(11) not null,
constraint FK_city_user3 foreign key(plant_id)
references plants(id),
family varchar(50) not null,
genus varchar(40) not null,
purpose varchar(60)
);

create table plants_orders
(
plant_id int(11) not null,
order_id int(11) not null,
constraint FK_city_user2 foreign key(order_id)
references orders(id)
);