create database what_is_optimum_age;

create user 'what_is_optimum_age'@'localhost' identified by 'password';

grant select, insert on what_is_optimum_age.* to 'what_is_optimum_age'@'localhost';

create table what_is_optimum_age.images (
	id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
	age TINYINT UNSIGNED NOT NULL
);

create table what_is_optimum_age.responce (
	id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
	image_id SMALLINT UNSIGNED NOT NULL,
	score TINYINT UNSIGNED NOT NUll,
	datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

create table what_is_optimum_age.report (
	id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
	datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
	body VARCHAR(255) NOT NULL
);