Page MenuHomeMusing Studio
Files F12547263

No OneTemporary
Actions

View Options

diff --git a/postgres.sql b/postgres.sql
index 2073748..1da5c1a 100644
--- a/postgres.sql
+++ b/postgres.sql
@@ -1,148 +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,
+ "privacy" INT 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,
+ "privacy" INT 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, Nov 20, 8:29 AM (1 d, 14 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3498598

Event Timeline

musing studio · developers