CREATE TABLE `posts` (
	`id` int,
	`title` varchar(255),
	`slug` varchar(255),
	`description` varchar(255),
	`body` varchar(255),
	`date_created` datetime,
	`user_id` int,
	`is_published` bool,
	FOREIGN KEY(`user_id`) REFERENCES `users` (`id`)
);
CREATE TABLE `tag` (
	`id` int,
	`name` varchar(255)
);
CREATE TABLE `post_tags` (
	`id` int,
	`post_id` int,
	`tag_id` int,
	FOREIGN KEY(`post_id`) REFERENCES `posts` (`id`),
	FOREIGN KEY(`tag_id`) REFERENCES `tag` (`id`)
);
CREATE TABLE `users` (
	`id` varchar(255),
	`username` varchar(255),
	`password` varchar(255),
	`email` varchar(255),
	`first_name` varchar(255),
	`last_name` varchar(255),
	`display_name` varchar(255),
	`is_active` bool
);