diff --git a/docker-setup.sh b/docker-setup.sh
index 46f41f3..ed845d0 100755
--- a/docker-setup.sh
+++ b/docker-setup.sh
@@ -1,4 +1,4 @@
 #!/bin/bash
-docker-compose exec db sh -c 'exec mysql -u root -pchangeme writefreely < /tmp/schema.sql'
+docker-compose exec db sh -c 'exec mysql -u root -pchangeme writefreely < /tmp/mysql.sql'
 docker exec writefreely_web_1 writefreely --gen-keys
 docker exec -it writefreely_web_1 writefreely --config
\ No newline at end of file
diff --git a/schema.sql b/mysql.sql
similarity index 100%
rename from schema.sql
rename to mysql.sql
diff --git a/postgres.sql b/postgres.sql
new file mode 100644
index 0000000..2073748
--- /dev/null
+++ b/postgres.sql
@@ -0,0 +1,148 @@
+CREATE TABLE IF NOT EXISTS "accesstokens" (
+	"token" BYTEA PRIMARY KEY,
+	"user_id" INT NOT NULL,
+	"sudo" BOOLEAN NOT NULL DEFAULT FALSE,
+	"one_time" BOOLEAN NOT NULL DEFAULT FALSE,
+	"created" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+	"expires" TIMESTAMP DEFAULT NULL,
+	"user_agent" VARCHAR(255) DEFAULT NULL
+);
+
+
+CREATE TABLE IF NOT EXISTS "appcontent" (
+	"id" VARCHAR(36) PRIMARY KEY,
+	"content" TEXT NOT NULL,
+	"updated" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+);
+
+
+CREATE TABLE "appmigrations" (
+	"version" INT NOT NULL,
+	"migrated" TIMESTAMP NOT NULL,
+	"result" TEXT NOT NULL
+);
+
+
+CREATE TABLE IF NOT EXISTS "collectionattributes" (
+	"collection_id" INT NOT NULL,
+	"attribute" VARCHAR(128) NOT NULL,
+	"value" VARCHAR(255) NOT NULL,
+	PRIMARY KEY ("collection_id", "attribute")
+);
+
+
+CREATE TABLE IF NOT EXISTS "collectionkeys" (
+	"collection_id" INT PRIMARY KEY,
+	"public_key" BYTEA NOT NULL,
+	"private_key" BYTEA NOT NULL
+);
+
+
+CREATE TABLE IF NOT EXISTS "collectionpasswords" (
+    "collection_id" INT PRIMARY KEY,
+    "password" CHAR(60) NOT NULL
+);
+
+
+CREATE TABLE IF NOT EXISTS "collectionredirects" (
+    "prev_alias" VARCHAR(100) NOT NULL PRIMARY KEY,
+    "new_alias" VARCHAR(100) NOT NULL
+);
+
+
+CREATE TABLE IF NOT EXISTS "collections" (
+    "id" SERIAL PRIMARY KEY,
+    "alias" VARCHAR(100) DEFAULT NULL,
+    "title" VARCHAR(255) NOT NULL,
+    "description" VARCHAR(160) NOT NULL,
+    "style_sheet" TEXT,
+    "script" TEXT DEFAULT NULL,
+    "format" VARCHAR(8) DEFAULT NULL,
+    "privacy" BOOLEAN NOT NULL,
+    "owner_id" INT NOT NULL,
+    "view_count" INT NOT NULL
+);
+
+
+CREATE TABLE IF NOT EXISTS "posts" (
+    "id" CHAR(16) PRIMARY KEY,
+    "slug" VARCHAR(100) DEFAULT NULL,
+    "modify_token" CHAR(32) DEFAULT NULL,
+    "text_appearance" CHAR(4) NOT NULL DEFAULT 'norm',
+    "language" CHAR(2) DEFAULT NULL,
+    "rtl" BOOLEAN DEFAULT NULL,
+    "privacy" BOOLEAN NOT NULL,
+    "owner_id" INT DEFAULT NULL,
+    "collection_id" INT DEFAULT NULL,
+    "pinned_position" SMALLINT NULL,
+    "created" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updated" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "view_count" INT NOT NULL,
+    "title" VARCHAR(160) NOT NULL,
+    "content" TEXT NOT NULL
+);
+
+
+CREATE TABLE IF NOT EXISTS "remotefollows" (
+    "collection_id" INT NOT NULL,
+    "remote_user_id" INT NOT NULL,
+    "created" TIMESTAMP NOT NULL,
+    PRIMARY KEY ("collection_id", "remote_user_id")
+);
+
+
+CREATE TABLE IF NOT EXISTS "remoteuserkeys" (
+    "id" VARCHAR(255) PRIMARY KEY,
+    "remote_user_id" INT NOT NULL,
+    "public_key" BYTEA NOT NULL
+);
+
+
+CREATE TABLE IF NOT EXISTS "remoteusers" (
+    "id" SERIAL PRIMARY KEY,
+    "actor_id" VARCHAR(255) NOT NULL,
+    "inbox" VARCHAR(255) NOT NULL,
+    "shared_inbox" VARCHAR(255) NOT NULL
+);
+
+
+CREATE TABLE IF NOT EXISTS "userattributes" (
+    "user_id" INT NOT NULL,
+    "attribute" VARCHAR(64) NOT NULL,
+    "value" VARCHAR(255) NOT NULL,
+    PRIMARY KEY ("user_id", "attribute")
+);
+
+
+CREATE TABLE "userinvites" (
+    "id" CHAR(6) NOT NULL,
+    "owner_id" INT NOT NULL,
+    "max_uses" SMALLINT DEFAULT NULL,
+    "created" TIMESTAMP NOT NULL,
+    "expires" TIMESTAMP DEFAULT NULL,
+    "inactive" BOOLEAN NOT NULL
+);
+
+
+CREATE TABLE "users" (
+    "id" SERIAL PRIMARY KEY,
+    "username" VARCHAR(100) NOT NULL,
+    "password" CHAR(60) NOT NULL,
+    "email" BYTEA DEFAULT NULL,
+    "created" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+);
+
+
+CREATE TABLE "usersinvited" (
+    "invite_id" CHAR(6) NOT NULL,
+    "user_id" INT NOT NULL
+);
+
+
+CREATE INDEX IF NOT EXISTS "alias" ON "collections" ("alias");
+CREATE UNIQUE INDEX IF NOT EXISTS "id_slug" ON "posts" ("collection_id", "slug");
+CREATE UNIQUE INDEX IF NOT EXISTS "owner_id" ON "posts" ("owner_id", "id");
+CREATE INDEX IF NOT EXISTS "privacy_id" ON "posts" ("privacy", "id");
+CREATE UNIQUE INDEX IF NOT EXISTS "remote_user_id" ON "remoteuserkeys" ("remote_user_id");
+CREATE UNIQUE INDEX IF NOT EXISTS "actor_id" ON "remoteusers" ("actor_id");
+CREATE UNIQUE INDEX IF NOT EXISTS "username" ON "users" ("username");