"name": ["UNIQUE", "name"]
}
},
+ "apcontact": {
+ "comment": "ActivityPub compatible contacts - used in the ActivityPub implementation",
+ "fields": {
+ "url": {"type": "varbinary(255)", "not null": "1", "primary": "1", "comment": "URL of the contact"},
+ "uuid": {"type": "varchar(255)", "comment": ""},
+ "type": {"type": "varchar(20)", "not null": "1", "comment": ""},
+ "following": {"type": "varchar(255)", "comment": ""},
+ "followers": {"type": "varchar(255)", "comment": ""},
+ "inbox": {"type": "varchar(255)", "not null": "1", "comment": ""},
+ "outbox": {"type": "varchar(255)", "comment": ""},
+ "sharedinbox": {"type": "varchar(255)", "comment": ""},
+ "nick": {"type": "varchar(255)", "not null": "1", "default": "", "comment": ""},
+ "name": {"type": "varchar(255)", "comment": ""},
+ "about": {"type": "text", "comment": ""},
+ "photo": {"type": "varchar(255)", "comment": ""},
+ "addr": {"type": "varchar(255)", "comment": ""},
+ "alias": {"type": "varchar(255)", "comment": ""},
+ "pubkey": {"type": "text", "comment": ""},
+ "baseurl": {"type": "varchar(255)", "comment": "baseurl of the ap contact"},
+ "updated": {"type": "datetime", "not null": "1", "default": "0001-01-01 00:00:00", "comment": ""}
+
+ },
+ "indexes": {
+ "PRIMARY": ["url"],
+ "addr": ["addr(32)"],
+ "url": ["followers(190)"]
+ }
+ },
"attach": {
"comment": "file attachments",
"fields": {