Merge pull request #10403 from annando/doc-structure

[friendica.git] / doc / database / db_challenge.md

diff --git a/doc/database/db_challenge.md b/doc/database/db_challenge.md
index 5988954ab8678ca2298a76c1d0395b700accbb55..16183890943ed657a765d89541637f0e9a16ffe0 100644 (file)
--- a/doc/database/db_challenge.md
+++ b/doc/database/db_challenge.md
@@ -3,6 +3,9 @@ Table challenge
 
 
 
+Fields
+------
+
 | Field       | Description   | Type         | Null | Key | Default | Extra          |
 | ----------- | ------------- | ------------ | ---- | --- | ------- | -------------- |
 | id          | sequential ID | int unsigned | NO   | PRI | NULL    | auto_increment |
@@ -12,4 +15,13 @@ Table challenge
 | type        |               | varchar(255) | NO   |     |         |                |
 | last_update |               | varchar(255) | NO   |     |         |                |
 
+Indexes
+------------
+
+| Name    | Fields |
+| ------- | ------ |
+| PRIMARY | id     |
+| expire  | expire |
+
+
 Return to [database documentation](help/database)