Radical
4972aa37c4
this might all change completely but this is at least somewhat whats needed for federation
10 lines
293 B
SQL
10 lines
293 B
SQL
-- Your SQL goes here
|
|
CREATE TABLE instances (
|
|
instance_url VARCHAR(8000) PRIMARY KEY NOT NULL,
|
|
public_key VARCHAR(500) UNIQUE NOT NULL
|
|
);
|
|
|
|
CREATE TABLE federated_users (
|
|
uuid UUID PRIMARY KEY NOT NULL,
|
|
instance_url VARCHAR(8000) NOT NULL REFERENCES instances(instance_url)
|
|
);
|