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
);