CREATE TABLE `users` (
	`id` int PRIMARY KEY,
	`name` varchar(255),
	`fullname` varchar(255),
	`email` varchar(255),
	`password` varchar(255),
	`is_active` bool,
	`is_block` bool,
	`age` int,
	`contry_city` varchar(255),
	`social_urls` varchar(255)
);
CREATE TABLE `articles` (
	`id` int PRIMARY KEY,
	`users_id` int,
	`categories_id` int,
	`head_image_url` varchar(255),
	`title_ge` varchar(255),
	`title_en` varchar(255),
	`title_ru` varchar(255),
	`title_desc_ge` varchar(255),
	`title_desc_ru` varchar(255),
	`title_desc_en` varchar(255),
	`text_ge` varchar(255),
	`text_en` varchar(255),
	`text_ru` varchar(255),
	`quote_ge` varchar(255),
	`quote_en` varchar(255),
	`quote_ru` varchar(255),
	`stars` int,
	`watched` int,
	`sheared_count` int,
	`is_pending` bool,
	`is_publiched` bool,
	`is_video_content` bool,
	FOREIGN KEY(`users_id`) REFERENCES `users` (`id`),
	FOREIGN KEY(`categories_id`) REFERENCES `categories` (`id`)
);
CREATE TABLE `categories` (
	`id` int PRIMARY KEY,
	`title_ge` varchar(255),
	`title_en` varchar(255),
	`title_ru` varchar(255),
	`icon` varchar(255)
);
CREATE TABLE `article_tag` (
	`id` int PRIMARY KEY,
	`articles_id` int,
	`tags_id` int,
	FOREIGN KEY(`articles_id`) REFERENCES `articles` (`id`),
	FOREIGN KEY(`tags_id`) REFERENCES `tags` (`id`)
);
CREATE TABLE `tags` (
	`id` int PRIMARY KEY,
	`name_ge` varchar(255),
	`name_en` varchar(255),
	`name_ru` varchar(255),
	FOREIGN KEY(`name_ru`) REFERENCES `name` (`ru`)
);
CREATE TABLE `videos` (
	`id` int,
	`categories_id` int,
	`url` varchar(255),
	`title_ge` varchar(255),
	`title_en` varchar(255),
	`title_ru` varchar(255),
	`text_ge` varchar(255),
	`text_en` varchar(255),
	`text_ru` varchar(255),
	`quote_ge` varchar(255),
	`quote_en` varchar(255),
	`quote_ru` varchar(255),
	`watched` varchar(255),
	`sheared_count` varchar(255),
	`is_panding` bool,
	`is_published` bool,
	FOREIGN KEY(`categories_id`) REFERENCES `categories` (`id`),
	FOREIGN KEY(`is_published`) REFERENCES `is` (`published`)
);
CREATE TABLE `author_requests` (
	`id` int,
	`users_id` int,
	`is_author` bool,
	`is_readed` bool,
	FOREIGN KEY(`users_id`) REFERENCES `users` (`id`),
	FOREIGN KEY(`is_readed`) REFERENCES `is` (`readed`)
);
CREATE TABLE `subscribers` (
	`id` int,
	`email` varchar(255)
);