Page MenuHomeMusing Studio
Files F13828704

No OneTemporary
Actions

View Options

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

File Metadata

Mime Type
text/x-diff
Expires
Thu, Feb 19, 8:35 PM (1 d, 22 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3632586

Event Timeline

musing studio · developers