mirror of
https://github.com/p2p-ld/linkml-activitypub.git
synced 2025-01-09 13:04:27 +00:00
1861 lines
42 KiB
MySQL
1861 lines
42 KiB
MySQL
|
|
||
|
|
||
|
CREATE TABLE "Accept" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Activity" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Add" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Announce" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Application" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Arrive" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Article" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Audio" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Block" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Collection" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
current TEXT,
|
||
|
first TEXT,
|
||
|
items TEXT,
|
||
|
last TEXT,
|
||
|
"totalItems" INTEGER,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, current, first, items, last, "totalItems")
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "CollectionPage" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
current TEXT,
|
||
|
first TEXT,
|
||
|
items TEXT,
|
||
|
last TEXT,
|
||
|
"totalItems" INTEGER,
|
||
|
next TEXT,
|
||
|
"partOf" TEXT,
|
||
|
prev TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, current, first, items, last, "totalItems", next, "partOf", prev)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Create" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Delete" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Dislike" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Document" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Event" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Flag" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Follow" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Group" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Ignore" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Image" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "IntransitiveActivity" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Invite" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Join" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Leave" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Like" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Link" (
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
height INTEGER,
|
||
|
href TEXT,
|
||
|
hreflang TEXT,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
rel TEXT,
|
||
|
width INTEGER,
|
||
|
PRIMARY KEY (name, preview, height, href, hreflang, id, "mediaType", rel, width)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Listen" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Mention" (
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
height INTEGER,
|
||
|
href TEXT,
|
||
|
hreflang TEXT,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
rel TEXT,
|
||
|
width INTEGER,
|
||
|
PRIMARY KEY (name, preview, height, href, hreflang, id, "mediaType", rel, width)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Move" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Note" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Object" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Offer" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "OrderedCollection" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
current TEXT,
|
||
|
first TEXT,
|
||
|
last TEXT,
|
||
|
"totalItems" INTEGER,
|
||
|
items TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, current, first, last, "totalItems", items)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "OrderedCollectionPage" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
current TEXT,
|
||
|
first TEXT,
|
||
|
last TEXT,
|
||
|
"totalItems" INTEGER,
|
||
|
"startIndex" INTEGER,
|
||
|
next TEXT,
|
||
|
"partOf" TEXT,
|
||
|
prev TEXT,
|
||
|
items TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, current, first, last, "totalItems", "startIndex", next, "partOf", prev, items)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Organization" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Page" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Person" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Place" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
accuracy FLOAT,
|
||
|
altitude FLOAT,
|
||
|
latitude FLOAT,
|
||
|
longitude FLOAT,
|
||
|
radius FLOAT,
|
||
|
units TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, accuracy, altitude, latitude, longitude, radius, units)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Profile" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
describes TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, describes)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Question" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
"anyOf" TEXT,
|
||
|
"oneOf" TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target, "anyOf", "oneOf")
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Read" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Reject" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Relationship" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
object TEXT,
|
||
|
relationship TEXT,
|
||
|
subject TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, object, relationship, subject)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Remove" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Service" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "TentativeAccept" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "TentativeReject" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Tombstone" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
"formerType" TEXT,
|
||
|
deleted DATETIME,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, "formerType", deleted)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Travel" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Undo" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Update" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "Video" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated)
|
||
|
);
|
||
|
|
||
|
CREATE TABLE "View" (
|
||
|
attachment TEXT,
|
||
|
"attributedTo" TEXT,
|
||
|
audience TEXT,
|
||
|
bcc TEXT,
|
||
|
bto TEXT,
|
||
|
cc TEXT,
|
||
|
content TEXT,
|
||
|
context TEXT,
|
||
|
generator TEXT,
|
||
|
icon TEXT,
|
||
|
image TEXT,
|
||
|
"inReplyTo" TEXT,
|
||
|
location TEXT,
|
||
|
name TEXT,
|
||
|
preview TEXT,
|
||
|
replies TEXT,
|
||
|
summary TEXT,
|
||
|
tag TEXT,
|
||
|
"to" TEXT,
|
||
|
url TEXT,
|
||
|
duration TEXT,
|
||
|
"endTime" DATETIME,
|
||
|
id TEXT,
|
||
|
"mediaType" TEXT,
|
||
|
published DATETIME,
|
||
|
"startTime" DATETIME,
|
||
|
updated DATETIME,
|
||
|
actor TEXT,
|
||
|
instrument TEXT,
|
||
|
object TEXT,
|
||
|
origin TEXT,
|
||
|
result TEXT,
|
||
|
target TEXT,
|
||
|
PRIMARY KEY (attachment, "attributedTo", audience, bcc, bto, cc, content, context, generator, icon, image, "inReplyTo", location, name, preview, replies, summary, tag, "to", url, duration, "endTime", id, "mediaType", published, "startTime", updated, actor, instrument, object, origin, result, target)
|
||
|
);
|