CREATE TABLE "Post" (
	"id" int,
	"parent_id" int CONSTRAINT Post_id REFERENCES Post(id),
	"category_id" int CONSTRAINT Category_id REFERENCES Category(id),
	"author_id" int CONSTRAINT User_id REFERENCES User(id),
	"date" datetime,
	"content" varchar(255),
	"locked" bool,
	"hit" int,
	"modified_date" datetime,
	"modified_by" varchar(255),
	"modified_reason" varchar(255)
);
CREATE TABLE "User" (
	"id" int,
	"username" varchar(255),
	"name" varchar(255),
	"email" varchar(255),
	"gender" varchar(255),
	"birthdate" datetime,
	"signature" varchar(255),
	"profile_hit" varchar(255),
	"group_id" int CONSTRAINT Group_id REFERENCES Group(id),
	"avatar" varchar(255),
	"banned" bool
);
CREATE TABLE "Category" (
	"id" int,
	"parent_id" varchar(255) CONSTRAINT Category_id REFERENCES Category(id),
	"name" varchar(255),
	"description" varchar(255),
	"locked" bool,
	"moderators" varchar(255)
);
CREATE TABLE "Group" (
	"id" int,
	"name" varchar(255)
);