X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_item-uri.md;h=c6d1c4c3763378f5a79894f02c6faaff8ca3416c;hb=efa1344c6406d2918ca33aa8329e5286d949c7b8;hp=4b3dda5cedec747980ad362a0d94dfc874fc6952;hpb=2cd0c1d30d237806e9c3853aa0645f786e31855c;p=friendica.git diff --git a/doc/database/db_item-uri.md b/doc/database/db_item-uri.md index 4b3dda5ced..c6d1c4c376 100644 --- a/doc/database/db_item-uri.md +++ b/doc/database/db_item-uri.md @@ -3,10 +3,23 @@ Table item-uri URI and GUID for items +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)