"indexes": {
"PRIMARY": ["url"],
"addr": ["addr(32)"],
+ "alias": ["alias(190)"],
"url": ["followers(190)"]
}
},
"hidden": {"type": "boolean", "not null": "1", "default": "0", "comment": ""},
"archive": {"type": "boolean", "not null": "1", "default": "0", "comment": ""},
"pending": {"type": "boolean", "not null": "1", "default": "1", "comment": ""},
+ "deleted": {"type": "boolean", "not null": "1", "default": "0", "comment": "Contact has been deleted"},
"rating": {"type": "tinyint", "not null": "1", "default": "0", "comment": ""},
"reason": {"type": "text", "comment": ""},
"closeness": {"type": "tinyint unsigned", "not null": "1", "default": "99", "comment": ""},
"received": ["received"]
}
},
+ "diaspora-interaction": {
+ "comment": "Signed Diaspora Interaction",
+ "fields": {
+ "uri-id": {"type": "int unsigned", "not null": "1", "primary": "1", "relation": {"item-uri": "id"}, "comment": "Id of the item-uri table entry that contains the item uri"},
+ "interaction": {"type": "mediumtext", "comment": "The Diaspora interaction"}
+ },
+ "indexes": {
+ "PRIMARY": ["uri-id"]
+ }
+ },
"event": {
"comment": "Events",
"fields": {
"indexes": {
"PRIMARY": ["id"],
"uri-hash": ["UNIQUE", "uri-hash"],
- "uri": ["uri(191)"]
+ "uri": ["uri(191)"],
+ "uri-id": ["uri-id"]
}
},
"item-content": {
"indexes": {
"PRIMARY": ["id"],
"uri-plink-hash": ["UNIQUE", "uri-plink-hash"],
- "uri": ["uri(191)"]
+ "uri": ["uri(191)"],
+ "uri-id": ["uri-id"]
}
},
"item-delivery-data": {
"created": {"type": "datetime", "not null": "1", "default": "0001-01-01 00:00:00", "comment": "Creation date"},
"pid": {"type": "int unsigned", "not null": "1", "default": "0", "comment": "Process id of the worker"},
"executed": {"type": "datetime", "not null": "1", "default": "0001-01-01 00:00:00", "comment": "Execution date"},
+ "next_try": {"type": "datetime", "not null": "1", "default": "0001-01-01 00:00:00", "comment": "Next retrial date"},
+ "retrial": {"type": "tinyint", "not null": "1", "default": "0", "comment": "Retrial counter"},
"done": {"type": "boolean", "not null": "1", "default": "0", "comment": "Marked 1 when the task was done - will be deleted later"}
},
"indexes": {
"PRIMARY": ["id"],
"pid": ["pid"],
"parameter": ["parameter(64)"],
- "priority_created": ["priority", "created"],
- "done_executed": ["done", "executed"]
+ "priority_created_next_try": ["priority", "created", "next_try"],
+ "done_executed_next_try": ["done", "executed", "next_try"]
}
}
}