X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_locks.md;h=dc5371184dce15e9a9452d54bb789ffb1c6326fd;hb=9581b05603e6ee4e250738c159ed2e67b3fb2eeb;hp=0da4d8845cf96140844709fa5ca0cf9206a3af37;hpb=fd30df7300d9de5b2316b86ccc38053cec69dfe1;p=friendica.git diff --git a/doc/database/db_locks.md b/doc/database/db_locks.md index 0da4d8845c..dc5371184d 100644 --- a/doc/database/db_locks.md +++ b/doc/database/db_locks.md @@ -2,12 +2,25 @@ Table locks =========== -| Field | Description | Type | Null | Key | Default | Extra | -| ------- | ---------------------------- | ------------ | ---- | --- | ------------------- | -------------- | -| id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment | -| name | | varchar(128) | NO | | | | -| locked | | boolean | NO | | 0 | | -| pid | Process ID | int unsigned | NO | | 0 | | -| expires | datetime of cache expiration | datetime | NO | | 0001-01-01 00:00:00 | | + +Fields +------ + +| Field | Description | Type | Null | Key | Default | Extra | +| ------- | ---------------------------- | ------------ | ---- | --- | ------------------- | -------------- | +| id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment | +| name | | varchar(128) | NO | | | | +| locked | | boolean | NO | | 0 | | +| pid | Process ID | int unsigned | NO | | 0 | | +| expires | datetime of cache expiration | datetime | NO | | 0001-01-01 00:00:00 | | + +Indexes +------------ + +| Name | Fields | +| ------------ | ------------- | +| PRIMARY | id | +| name_expires | name, expires | + Return to [database documentation](help/database)