use Friendica\Database\DBA;
if (!defined('DB_UPDATE_VERSION')) {
- define('DB_UPDATE_VERSION', 1404);
+ define('DB_UPDATE_VERSION', 1405);
}
return [
"author-id" => ["author-id"],
"causer-id" => ["causer-id"],
"vid" => ["vid"],
- "received" => ["received"],
]
],
"post-category" => [
"network" => ["type" => "char(4)", "not null" => "1", "default" => "", "comment" => ""],
"created" => ["type" => "datetime", "not null" => "1", "default" => DBA::NULL_DATETIME, "comment" => ""],
"received" => ["type" => "datetime", "not null" => "1", "default" => DBA::NULL_DATETIME, "comment" => ""],
- "changed" => ["type" => "datetime", "not null" => "1", "default" => DBA::NULL_DATETIME, "comment" => "Date that something in the conversation changed, indicating clients should fetch the conversation again"],
+ "changed" => ["type" => "datetime", "not null" => "1", "default" => DBA::NULL_DATETIME, "comment" => "Date that something in the conversation changed, indicating clients should fetch the conversation again"],
"commented" => ["type" => "datetime", "not null" => "1", "default" => DBA::NULL_DATETIME, "comment" => ""]
],
"indexes" => [
"PRIMARY" => ["id"],
"uid_uri-id" => ["UNIQUE", "uid", "uri-id"],
"uri-id" => ["uri-id"],
- "contact-id" => ["contact-id"],
- "psid" => ["psid"],
- "uid_hidden" => ["uid", "hidden"],
- "event-id" => ["event-id"],
- "uid_wall" => ["uid", "wall"],
- "parent-uri-id_uid" => ["parent-uri-id", "uid"],
+ "parent-uri-id" => ["parent-uri-id"],
"thr-parent-id" => ["thr-parent-id"],
"external-id" => ["external-id"],
"owner-id" => ["owner-id"],
- "author-id_uid" => ["author-id", "uid"],
+ "author-id" => ["author-id"],
"causer-id" => ["causer-id"],
"vid" => ["vid"],
- "uid_received" => ["uid", "received"],
+ "contact-id" => ["contact-id"],
+ "event-id" => ["event-id"],
+ "psid" => ["psid"],
+ "author-id_uid" => ["author-id", "uid"],
+ "author-id_received" => ["author-id", "received"],
+ "parent-uri-id_uid" => ["parent-uri-id", "uid"],
+ "uid_hidden" => ["uid", "hidden"],
+ "uid_contactid" => ["uid", "contact-id"],
"uid_unseen_contactid" => ["uid", "unseen", "contact-id"],
- "uid_network_received" => ["uid", "network", "received"],
- "uid_contactid_received" => ["uid", "contact-id", "received"],
- "authorid_received" => ["author-id", "received"],
+ "uid_unseen" => ["uid", "unseen"],
"uid_unseen_wall" => ["uid", "unseen", "wall"],
- "uid_eventid" => ["uid", "event-id"],
- "psid_wall" => ["psid", "wall"],
],
],
"post-thread-user" => [
],
"indexes" => [
"PRIMARY" => ["uid", "uri-id"],
- "uid_wall" => ["uid", "wall"],
- "uid_pinned" => ["uid", "pinned"],
"uri-id" => ["uri-id"],
+ "owner-id" => ["owner-id"],
+ "author-id" => ["author-id"],
+ "causer-id" => ["causer-id"],
+ "uid" => ["uid"],
"contact-id" => ["contact-id"],
"psid" => ["psid"],
"post-user-id" => ["post-user-id"],
- "owner-id" => ["owner-id"],
- "causer-id" => ["causer-id"],
- "uid_received" => ["uid", "received"],
- "uid_commented" => ["uid", "commented"],
- "uid_changed" => ["uid", "changed"],
- "uid_contact-id" => ["uid", "contact-id", "received"],
- "uid_unseen_contactid" => ["uid", "unseen", "contact-id"],
- "uid_network_received" => ["uid", "network", "received"],
- "uid_network_commented" => ["uid", "network", "commented"],
- "uid_contact-id_received" => ["uid", "contact-id", "received"],
+ "commented" => ["commented"],
+ "received" => ["received"],
"author-id_received" => ["author-id", "received"],
- "uid_wall_changed" => ["uid", "wall", "changed"],
- "uid_unseen_wall" => ["uid", "unseen", "wall"],
+ "uid_pinned" => ["uid", "pinned"],
+ "uid_commented" => ["uid", "commented"],
"mention_uid" => ["mention", "uid"],
- "psid_wall" => ["psid", "wall"],
- "received" => ["received"],
- "commented" => ["commented"],
- "changed" => ["changed"],
+ "uid_mention" => ["uid", "mention"],
]
],
"post-user-notification" => [