X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_item-uri.md;h=c6d1c4c3763378f5a79894f02c6faaff8ca3416c;hb=a2532ad7554602d631d9caabb5c74564328d1fff;hp=1fb4f9b950e54f5d9aa8d0c54f7576ed1b18d36b;hpb=31db9dbef7f6a4f98a6c29d15493bcffb0c39929;p=friendica.git diff --git a/doc/database/db_item-uri.md b/doc/database/db_item-uri.md index 1fb4f9b950..c6d1c4c376 100644 --- a/doc/database/db_item-uri.md +++ b/doc/database/db_item-uri.md @@ -1,11 +1,25 @@ Table item-uri =========== + URI and GUID for items -| Field | Description | Type | Null | Key | Default | Extra | -| ----- | ----------- | ---- | ---- | --- | ------- | ----- | -| id | | int unsigned | YES | PRI | NULL | auto_increment | -| uri | URI of an item | varbinary(255) | YES | | NULL | | -| guid | A unique identifier for an item | varbinary(255) | NO | | NULL | | +Fields +------ + +| Field | Description | Type | Null | Key | Default | Extra | +| ----- | ------------------------------- | -------------- | ---- | --- | ------- | -------------- | +| id | | int unsigned | NO | PRI | NULL | auto_increment | +| uri | URI of an item | varbinary(255) | NO | | NULL | | +| guid | A unique identifier for an item | varbinary(255) | YES | | NULL | | + +Indexes +------------ + +| Name | Fields | +| ------- | ----------- | +| PRIMARY | id | +| uri | UNIQUE, uri | +| guid | guid | + Return to [database documentation](help/database)