CREATE TABLE "post" (
	"id" int PRIMARY KEY,
	"title" varchar(255),
	"body" varchar(255),
	"createDate" datetime,
	"editDate" datetime,
	"author" int,
	"liked" int,
	FOREIGN KEY("author") REFERENCES "user" ("id")
);
CREATE TABLE "user" (
	"id" int,
	"username" varchar(255),
	"password" varchar(255),
	"email" varchar(255),
	"name" varchar(255),
	"role" varchar(255)
);
CREATE TABLE "comment" (
	"id" int,
	"title" varchar(255),
	"body" varchar(255),
	"date" datetime,
	"author" int,
	"post" int,
	"replyTo" int,
	"liked" int,
	FOREIGN KEY("author") REFERENCES "user" ("id"),
	FOREIGN KEY("post") REFERENCES "post" ("id"),
	FOREIGN KEY("replyTo") REFERENCES "comment" ("id")
);
CREATE TABLE "tag" (
	"id" int,
	"name" varchar(255)
);
CREATE TABLE "post-tag" (
	"postId" int,
	"tagId" int,
	FOREIGN KEY("postId") REFERENCES "post" ("id"),
	FOREIGN KEY("tagId") REFERENCES "tag" ("id")
);