CREATE TABLE "User" (
	"id" int PRIMARY KEY,
	"password" varchar(255),
	"date_joined" datetime,
	"email" varchar(255)
);
CREATE TABLE "Document" (
	"id" int PRIMARY KEY
);
CREATE TABLE "DocumentLog" (
	"document_id" int FOREIGN KEY("document_id") REFERENCES "Document" ("id"),
	"user_id" int FOREIGN KEY("user_id") REFERENCES "User" ("id"),
	"date_edited" datetime,
	"title" varchar(255),
	"content" varchar(255)
);
CREATE TABLE "DocumentFile" (
	"document_id" int FOREIGN KEY("document_id") REFERENCES "Document" ("id"),
	"user_id" int FOREIGN KEY("user_id") REFERENCES "User" ("id"),
	"filename" varchar(255),
	"path" varchar(255)
);